Skip to content
Snippets Groups Projects
New look: Off

Replace existing hive_follows table with optimized tables

    • Open Issue created by Dan Notestein @dan
    • The current hive_follows table is bigger than it should be.
    • Replace it with the tables below which are smaller and better optimized for the queries we use. In particular, this should speed up muting, since there are fewer mutes than follows.
    • This will require both the sync and API queries to be changed.
    • Functions that return created_at can look up the time using hafd.blocks.
    CREATE TABLE follows (
  follower INTEGER,
  following INTEGER,
  block_num INTEGER,
  PRIMARY KEY (follower, following)
);

CREATE INDEX follows_follower_idx ON follows(follower);
CREATE INDEX follows_following_idx ON follows(following);

CREATE TABLE muted (
  follower INTEGER,
  following INTEGER,
  block_num INTEGER,
  PRIMARY KEY (follower, following)
);

CREATE INDEX muted_follower_idx ON muted(follower);
CREATE INDEX muted_following_idx ON muted(following);

CREATE TABLE blacklisted (
  follower INTEGER,
  following INTEGER,
  block_num INTEGER,
  PRIMARY KEY (follower, following)
);

CREATE INDEX blacklisted_follower_idx ON blacklisted(follower);
CREATE INDEX blacklisted_following_idx ON blacklisted(following);

CREATE TABLE follow_muted (
  follower INTEGER,
  following INTEGER,
  block_num INTEGER,
  PRIMARY KEY (follower, following)
);

CREATE INDEX follow_muted_follower_idx ON follow_muted(follower);
CREATE INDEX follow_muted_following_idx ON follow_muted(following);

CREATE TABLE follow_blacklisted (
  follower INTEGER,
  following INTEGER,
  block_num INTEGER,
  PRIMARY KEY (follower, following)
);

CREATE INDEX follow_blacklisted_follower_idx ON follow_blacklisted(follower);
CREATE INDEX follow_blacklisted_following_idx ON follow_blacklisted(following);
    Edited

    Designs

      Child items ...

      2. Activity

      • Dan Notestein changed the description

        changed the description

      • Dan Notestein changed the description

        changed the description

      • Dan Notestein
        Dan Notestein @dan ·
        Author Owner

        The new table functions will return follows/following sorted by name, unlike the old functions that used position in the table to determine the ordering.

        Edited by Dan Notestein
      • Dan Notestein mentioned in issue #195 (closed)

        mentioned in issue #195 (closed)

      • Dan Notestein mentioned in merge request !819

        mentioned in merge request !819

      • Dan Notestein created branch 267-replace-existing-hive_follows-table-with-optimized-tables to address this issue

        created branch 267-replace-existing-hive_follows-table-with-optimized-tables to address this issue

      • Dan Notestein
        Dan Notestein @dan ·
        Author Owner

        This issue is currently being implemented in !863 which is also re-writing code for update_notification_cache to incrementally update the notification cache instead of totally re-filling the entire table each block.

      • Dan Notestein
        Dan Notestein @dan ·
        Author Owner

        The times for processing blocks with the new implementation 1e627fa0 are surprisingly varied. Some of the time, a block only takes .046s to process, which is fairly reasonable, but on other blocks it is 10x slower (e.g. 0.462s). Maybe it is just due to a lot of activity in those blocks, but it probably needs investigation just to be sure code is maximally optimized. Below is some of the log:

        INFO - hive.indexer.sync:184 - [SINGLE] *** SINGLE block processing***
INFO - hive.indexer.sync:185 - [SINGLE] Current system time: 2025-03-23 16:11:10.096
INFO - hive.indexer.sync:246 - [SINGLE] Attempting to process first block in range: <94391500:94391500>
INFO - hive.indexer.blocks:207 - #############################################################################
INFO - hive.indexer.blocks:224 - [PROCESS MULTI] Flushing data in 1 thread
INFO - hive.indexer.blocks:227 - [PROCESS MULTI] Tables updating in live synchronization
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_posts_rshares(94391500, 94391500) executed in: 0.0055 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_children_count(94391500, 94391500) executed in: 0.0025 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_root_id(94391500,94391500) executed in: 0.0006 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_feed_cache(94391500, 94391500) executed in: 0.0004 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_mentions(94391500, 94391500) executed in: 0.0004 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391500, 94391500, False) executed in: 0.0484 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_follow_count(94391500, 94391500) executed in: 0.0006 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_last_completed_block(94391500) executed in: 0.0021 s
INFO - hive.utils.timer:18 - on_live_blocks_processed executed in 0.0611 s
INFO - hive.indexer.blocks:235 - [PROCESS MULTI] 1 blocks in 0.1065s
INFO - hive.indexer.sync:123 - Last imported block is: 94391500
INFO - hive.indexer.sync:123 - Last imported block is: 94391500
INFO - hive.indexer.sync:123 - Last imported block is: 94391500
INFO - hive.indexer.sync:241 - Next block range from hive.app_next_iteration is: <94391501:94391501>
INFO - hive.indexer.sync:143 - target_head_block: 94391501
INFO - hive.indexer.sync:144 - test_max_block: None
INFO - hive.indexer.sync:184 - [SINGLE] *** SINGLE block processing***
INFO - hive.indexer.sync:185 - [SINGLE] Current system time: 2025-03-23 16:11:13.220
INFO - hive.indexer.sync:246 - [SINGLE] Attempting to process first block in range: <94391501:94391501>
INFO - hive.indexer.blocks:207 - #############################################################################
INFO - hive.indexer.blocks:224 - [PROCESS MULTI] Flushing data in 1 thread
INFO - hive.indexer.blocks:227 - [PROCESS MULTI] Tables updating in live synchronization
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_posts_rshares(94391501, 94391501) executed in: 0.0051 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_children_count(94391501, 94391501) executed in: 0.0024 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_root_id(94391501,94391501) executed in: 0.0003 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_feed_cache(94391501, 94391501) executed in: 0.0002 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_mentions(94391501, 94391501) executed in: 0.0003 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391501, 94391501, False) executed in: 0.0447 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_follow_count(94391501, 94391501) executed in: 0.0005 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_last_completed_block(94391501) executed in: 0.0021 s
INFO - hive.utils.timer:18 - on_live_blocks_processed executed in 0.0559 s
INFO - hive.indexer.blocks:235 - [PROCESS MULTI] 1 blocks in 0.0817s
INFO - hive.indexer.sync:123 - Last imported block is: 94391501
INFO - hive.indexer.sync:123 - Last imported block is: 94391501
INFO - hive.indexer.sync:123 - Last imported block is: 94391501
INFO - hive.indexer.sync:241 - Next block range from hive.app_next_iteration is: <94391502:94391502>
INFO - hive.indexer.sync:143 - target_head_block: 94391502
INFO - hive.indexer.sync:144 - test_max_block: None
INFO - hive.indexer.sync:184 - [SINGLE] *** SINGLE block processing***
INFO - hive.indexer.sync:185 - [SINGLE] Current system time: 2025-03-23 16:11:16.318
INFO - hive.indexer.sync:246 - [SINGLE] Attempting to process first block in range: <94391502:94391502>
INFO - hive.indexer.blocks:207 - #############################################################################
INFO - hive.indexer.blocks:224 - [PROCESS MULTI] Flushing data in 1 thread
INFO - hive.indexer.blocks:227 - [PROCESS MULTI] Tables updating in live synchronization
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_posts_rshares(94391502, 94391502) executed in: 0.0034 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_children_count(94391502, 94391502) executed in: 0.0024 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_root_id(94391502,94391502) executed in: 0.0003 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_feed_cache(94391502, 94391502) executed in: 0.0003 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_mentions(94391502, 94391502) executed in: 0.0017 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391502, 94391502, False) executed in: 0.4623 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_follow_count(94391502, 94391502) executed in: 0.0006 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_last_completed_block(94391502) executed in: 0.0014 s
INFO - hive.utils.timer:18 - on_live_blocks_processed executed in 0.4728 s
INFO - hive.indexer.blocks:235 - [PROCESS MULTI] 1 blocks in 0.4977s
INFO - hive.indexer.sync:123 - Last imported block is: 94391502
INFO - hive.indexer.sync:123 - Last imported block is: 94391502
INFO - hive.indexer.sync:241 - Next block range from hive.app_next_iteration is: <94391503:94391503>
INFO - hive.indexer.sync:143 - target_head_block: 94391503
INFO - hive.indexer.sync:144 - test_max_block: None
INFO - hive.indexer.sync:184 - [SINGLE] *** SINGLE block processing***
INFO - hive.indexer.sync:185 - [SINGLE] Current system time: 2025-03-23 16:11:18.326
INFO - hive.indexer.sync:246 - [SINGLE] Attempting to process first block in range: <94391503:94391503>
INFO - hive.indexer.blocks:207 - #############################################################################
INFO - hive.indexer.blocks:224 - [PROCESS MULTI] Flushing data in 1 thread
INFO - hive.indexer.blocks:227 - [PROCESS MULTI] Tables updating in live synchronization
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_posts_rshares(94391503, 94391503) executed in: 0.0034 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_children_count(94391503, 94391503) executed in: 0.0024 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_root_id(94391503,94391503) executed in: 0.0003 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_feed_cache(94391503, 94391503) executed in: 0.0022 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_mentions(94391503, 94391503) executed in: 0.0004 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391503, 94391503, False) executed in: 0.0453 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_follow_count(94391503, 94391503) executed in: 0.0005 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_last_completed_block(94391503) executed in: 0.0015 s
INFO - hive.utils.timer:18 - on_live_blocks_processed executed in 0.0563 s
INFO - hive.indexer.blocks:235 - [PROCESS MULTI] 1 blocks in 0.0869s
INFO - hive.indexer.sync:123 - Last imported block is: 94391503
INFO - hive.indexer.sync:123 - Last imported block is: 94391503
INFO - hive.indexer.sync:123 - Last imported block is: 94391503
INFO - hive.indexer.sync:241 - Next block range from hive.app_next_iteration is: <94391504:94391504>
INFO - hive.indexer.sync:143 - target_head_block: 94391504
INFO - hive.indexer.sync:144 - test_max_block: None
INFO - hive.indexer.sync:184 - [SINGLE] *** SINGLE block processing***
INFO - hive.indexer.sync:185 - [SINGLE] Current system time: 2025-03-23 16:11:21.432
INFO - hive.indexer.sync:246 - [SINGLE] Attempting to process first block in range: <94391504:94391504>
INFO - hive.indexer.blocks:207 - #############################################################################
INFO - hive.indexer.blocks:224 - [PROCESS MULTI] Flushing data in 1 thread
INFO - hive.indexer.blocks:227 - [PROCESS MULTI] Tables updating in live synchronization
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_posts_rshares(94391504, 94391504) executed in: 0.0054 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_children_count(94391504, 94391504) executed in: 0.0018 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_root_id(94391504,94391504) executed in: 0.0003 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_feed_cache(94391504, 94391504) executed in: 0.0002 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_mentions(94391504, 94391504) executed in: 0.0024 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391504, 94391504, False) executed in: 0.4632 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_follow_count(94391504, 94391504) executed in: 0.0005 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_last_completed_block(94391504) executed in: 0.0038 s
INFO - hive.utils.timer:18 - on_live_blocks_processed executed in 0.4778 s
INFO - hive.indexer.blocks:235 - [PROCESS MULTI] 1 blocks in 0.5069s
INFO - hive.indexer.sync:123 - Last imported block is: 94391504
INFO - hive.indexer.sync:123 - Last imported block is: 94391504
INFO - hive.indexer.sync:123 - Last imported block is: 94391504
INFO - hive.indexer.sync:241 - Next block range from hive.app_next_iteration is: <94391505:94391505>
INFO - hive.indexer.sync:143 - target_head_block: 94391505
INFO - hive.indexer.sync:144 - test_max_block: None
INFO - hive.indexer.sync:184 - [SINGLE] *** SINGLE block processing***
INFO - hive.indexer.sync:185 - [SINGLE] Current system time: 2025-03-23 16:11:24.959
INFO - hive.indexer.sync:246 - [SINGLE] Attempting to process first block in range: <94391505:94391505>
WARNING - hive.indexer.custom_op:80 - setLastRead::date: `2025-03-23T16:13:21' exceeds head block time. Correcting to head block time: `2025-03-23T16:11:21'
INFO - hive.indexer.blocks:207 - #############################################################################
INFO - hive.indexer.blocks:224 - [PROCESS MULTI] Flushing data in 1 thread
INFO - hive.indexer.blocks:227 - [PROCESS MULTI] Tables updating in live synchronization
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_posts_rshares(94391505, 94391505) executed in: 0.0037 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_children_count(94391505, 94391505) executed in: 0.0025 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_root_id(94391505,94391505) executed in: 0.0003 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_feed_cache(94391505, 94391505) executed in: 0.0004 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_mentions(94391505, 94391505) executed in: 0.0019 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391505, 94391505, False) executed in: 0.4699 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_follow_count(94391505, 94391505) executed in: 0.0006 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_last_completed_block(94391505) executed in: 0.0031 s
INFO - hive.utils.timer:18 - on_live_blocks_processed executed in 0.4827 s
INFO - hive.indexer.blocks:235 - [PROCESS MULTI] 1 blocks in 0.5112s
INFO - hive.indexer.sync:123 - Last imported block is: 94391505
INFO - hive.indexer.sync:123 - Last imported block is: 94391505
INFO - hive.indexer.sync:123 - Last imported block is: 94391505
INFO - hive.indexer.sync:241 - Next block range from hive.app_next_iteration is: <94391506:94391506>
INFO - hive.indexer.sync:143 - target_head_block: 94391506
INFO - hive.indexer.sync:144 - test_max_block: None
INFO - hive.indexer.sync:184 - [SINGLE] *** SINGLE block processing***
INFO - hive.indexer.sync:185 - [SINGLE] Current system time: 2025-03-23 16:11:28.486
INFO - hive.indexer.sync:246 - [SINGLE] Attempting to process first block in range: <94391506:94391506>
INFO - hive.indexer.blocks:207 - #############################################################################
INFO - hive.indexer.blocks:224 - [PROCESS MULTI] Flushing data in 1 thread
INFO - hive.indexer.blocks:227 - [PROCESS MULTI] Tables updating in live synchronization
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_posts_rshares(94391506, 94391506) executed in: 0.0041 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_children_count(94391506, 94391506) executed in: 0.0017 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_root_id(94391506,94391506) executed in: 0.0003 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_feed_cache(94391506, 94391506) executed in: 0.0002 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_hive_posts_mentions(94391506, 94391506) executed in: 0.0003 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391506, 94391506, False) executed in: 0.0456 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_follow_count(94391506, 94391506) executed in: 0.0005 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_last_completed_block(94391506) executed in: 0.0015 s
INFO - hive.utils.timer:18 - on_live_blocks_processed executed in 0.0545 s
INFO - hive.indexer.blocks:235 - [PROCESS MULTI] 1 blocks in 0.0740s
INFO - hive.indexer.sync:123 - Last imported block is: 94391506
INFO - hive.indexer.sync:123 - Last imported block is: 94391506
INFO - hive.indexer.sync:241 - Next block range from hive.app_next_iteration is: <94391507:94391507>
INFO - hive.indexer.sync:143 - target_head_block: 94391507
INFO - hive.indexer.sync:144 - test_max_block: None
        Edited by Dan Notestein
        • Dan Notestein
          Dan Notestein @dan ·
          Author Owner

          Fortunately, log above probably wasn't the most representative example, and in most cases, it seems like only 1 in 8 takes a long time. Overall, we are definitely seeing much less load on the node during live sync with this change of update_notification_cache to an incremental implementation, as expected. Still probably worth determining why some blocks are taking longer just in case it can be improved.

          Here are some block times:

          NFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391906, 94391906, False) executed in: 0.0437 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391907, 94391907, False) executed in: 0.0419 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391908, 94391908, False) executed in: 0.0409 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391909, 94391909, False) executed in: 0.0444 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391910, 94391910, False) executed in: 0.0443 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391911, 94391911, False) executed in: 0.0440 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391912, 94391912, False) executed in: 0.0435 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391913, 94391913, False) executed in: 0.0442 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391914, 94391914, False) executed in: 0.0446 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391915, 94391915, False) executed in: 0.0442 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391916, 94391916, False) executed in: 0.0435 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391917, 94391917, False) executed in: 0.0446 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391918, 94391918, False) executed in: 0.4456 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391919, 94391919, False) executed in: 0.0430 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391920, 94391920, False) executed in: 0.0442 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391921, 94391921, False) executed in: 0.0436 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391922, 94391922, False) executed in: 0.0413 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391923, 94391923, False) executed in: 0.0427 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391924, 94391924, False) executed in: 0.0441 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391925, 94391925, False) executed in: 0.0430 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391926, 94391926, False) executed in: 0.0418 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391927, 94391927, False) executed in: 0.0433 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391928, 94391928, False) executed in: 0.0450 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391929, 94391929, False) executed in: 0.0419 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391930, 94391930, False) executed in: 0.0414 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391931, 94391931, False) executed in: 0.0432 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391932, 94391932, False) executed in: 0.4731 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391933, 94391933, False) executed in: 0.0446 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391934, 94391934, False) executed in: 0.0453 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391935, 94391935, False) executed in: 0.0465 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391936, 94391936, False) executed in: 0.0449 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391937, 94391937, False) executed in: 0.0450 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391938, 94391938, False) executed in: 0.0431 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391939, 94391939, False) executed in: 0.0443 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391940, 94391940, False) executed in: 0.0417 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391941, 94391941, False) executed in: 0.4691 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391942, 94391942, False) executed in: 0.0439 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391943, 94391943, False) executed in: 0.0415 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391944, 94391944, False) executed in: 0.0440 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391945, 94391945, False) executed in: 0.0438 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391946, 94391946, False) executed in: 0.0434 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391947, 94391947, False) executed in: 0.0434 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391948, 94391948, False) executed in: 0.0424 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391949, 94391949, False) executed in: 0.0436 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391950, 94391950, False) executed in: 0.0442 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391951, 94391951, False) executed in: 0.0425 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391952, 94391952, False) executed in: 0.0446 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391953, 94391953, False) executed in: 0.4564 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391954, 94391954, False) executed in: 0.0429 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391955, 94391955, False) executed in: 0.0422 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391956, 94391956, False) executed in: 0.0407 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391957, 94391957, False) executed in: 0.0440 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391958, 94391958, False) executed in: 0.0435 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391959, 94391959, False) executed in: 0.4809 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391960, 94391960, False) executed in: 0.0441 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391961, 94391961, False) executed in: 0.0438 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391962, 94391962, False) executed in: 0.0439 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391963, 94391963, False) executed in: 0.0452 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391964, 94391964, False) executed in: 0.4680 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391965, 94391965, False) executed in: 0.0452 s
INFO - hive.indexer.blocks:435 - SELECT hivemind_app.update_notification_cache(94391966, 94391966, False) executed in: 0.0431 s
          Edited by Dan Notestein
        • Krzysztof Leśniak
          Krzysztof Leśniak @klesniak ·
          Developer

          Note that hivemind_app.update_notification_cache function is scheduled for deletion in this MR. The new code is in the indexer, which flush times are apparently not logged in live sync.

        • Please register or sign in to reply
      • Dan Notestein mentioned in issue #283

        mentioned in issue #283

      • Howo mentioned in issue #284

        mentioned in issue #284

      Please register or sign in to reply