hive sync from scratch slow at LIVE SYNC (update_hive_posts_api_helper)
After running hive sync
from scratch ( version 31a03fa6
)
[LIVE SYNC]
is slow:
INFO - hive.indexer.sync - [LIVE SYNC] =====> About to process block 48729000
INFO - hive.indexer.blocks - #############################################################################
INFO - hive.indexer.reputations - Written total reputation data records: 611683977
INFO - hive.utils.timer - update_active_starting_from_posts_on_block executed in 0.0008 s
INFO - hive.indexer.blocks - SELECT update_posts_rshares(48729000, 48729000) executed in: 0.0021 s
INFO - hive.indexer.blocks - SELECT update_hive_posts_children_count(48729000, 48729000) executed in: 0.0006 s
INFO - hive.indexer.blocks - SELECT update_hive_posts_root_id(48729000,48729000) executed in: 0.0006 s
INFO - hive.indexer.blocks - SELECT update_hive_posts_api_helper(48729000,48729000) executed in: 0.7872 s
INFO - hive.indexer.blocks - SELECT update_feed_cache(48729000, 48729000) executed in: 0.0007 s
INFO - hive.indexer.blocks - SELECT update_hive_posts_mentions(48729000, 48729000) executed in: 0.0006 s
INFO - hive.indexer.blocks - SELECT update_notification_cache(48729000, 48729000, False) executed in: 0.0134 s
INFO - hive.indexer.blocks - SELECT update_follow_count(48729000, 48729000) executed in: 0.0005 s
INFO - hive.utils.timer - on_live_blocks_processed executed in 0.8069 s
INFO - hive.indexer.blocks - [PROCESS MULTI] 1 blocks in 0.8239s
INFO - hive.utils.stats - ####################
INFO - hive.utils.stats - Operations present in the processed blocks
INFO - hive.utils.stats - `effective_comment_vote_operation`: Processed 10 times in 0.00076 seconds
INFO - hive.utils.stats - `sm_submit_team-ignored`: Processed 7 times in 0.00014 seconds
INFO - hive.utils.stats - `vote_operation`: Processed 10 times in 0.00010 seconds
INFO - hive.utils.stats - `sm_find_match-ignored`: Processed 2 times in 0.00004 seconds
INFO - hive.utils.stats - `sm_team_reveal-ignored`: Processed 2 times in 0.00003 seconds
INFO - hive.utils.stats - `comment_payout_update_operation`: Processed 1 times in 0.00001 seconds
INFO - hive.utils.stats - Current time for processing operations time: 0.0011s.
INFO - hive.utils.stats - ####################
INFO - hive.utils.stats - Flushing times
INFO - hive.utils.stats - `Posts`: Pushed 12 records in 0.0094 seconds
INFO - hive.utils.stats - `Votes`: Pushed 10 records in 0.0067 seconds
INFO - hive.utils.stats - `Reputations`: Pushed 10 records in 0.0059 seconds
INFO - hive.utils.stats - `Blocks`: Pushed 1 records in 0.0016 seconds
INFO - hive.utils.stats - `PostDataCache`: Pushed 0 records in 0.0000 seconds
INFO - hive.utils.stats - `Tags`: Pushed 0 records in 0.0000 seconds
INFO - hive.utils.stats - `Notify`: Pushed 0 records in 0.0000 seconds
INFO - hive.utils.stats - `Accounts`: Pushed 0 records in 0.0000 seconds
INFO - hive.utils.stats - `Reblog`: Pushed 0 records in 0.0000 seconds
INFO - hive.utils.stats - `Follow`: Pushed 0 records in 0.0000 seconds
INFO - hive.utils.stats - Current flushing time: 0.0237s.
INFO - hive.indexer.sync - [LIVE SYNC] <===== Processed block 48729000 at 2020-11-16T06:07:09 -- 22 txs -- 828ms
See:
SELECT update_hive_posts_api_helper(48729000,48729000) executed in: 0.7872 s