index state management about hivemind HOT 6 CLOSED

               edit   vote  reply  new
post_id                             x
author                              x
permlink                            x
category                            x
depth                               x
children                       x    x
title           x                   x
preview         x                   x
body            x                   x
img_url         x                   x
payout                  x           x
promoted                x           x
payout_at               x           x
updated_at      x                   x
created_at                          x
rshares                 x           x
votes                   x           x
json            x                   x
is_nsfw         x                   x
is_paidout              x           x
sc_trend                x           x
sc_hot                  x           x
flag_weight             x           x
total_votes             x           x
up_votes                x           x
is_hidden               x           x
is_grayed               x           x
author_rep              x           x
raw_json        x       x           x
is_declined     x                   x
is_full_power   x                   x

{
  "id": 20164398,
  "root_comment": 20096395,
  "curator_payout_value": "0.000 SBD",
  "net_votes": 0,

  "parent_author": "sergioss",
  "parent_permlink": "re-anacristinasilva-pedras-no-caminho-20171211t145336052z",
  "max_accepted_payout": "1000000.000 SBD",
  "allow_replies": true,
  "allow_votes": true,
  "allow_curation_rewards": true,
  "beneficiaries": [],
  "url": "/writing/@anacristinasilva/pedras-no-caminho#@anacristinasilva/re-sergioss-re-anacristinasilva-pedras-no-caminho-20171212t011639135z",
  "root_title": "Pedras no caminho...",
}

             update    post    vote   sweep
name            x                        
proxy           x                       x
post_count              x
reputation                      x
proxy_weight                            x
vote_weight                             x
kb_used         -       -       -       x
active_at               x       x
cached_at       x       ?       ?       x
display_name    x               
about           x
location        x
website         x
profile_image   x
cover_image     x
raw_json        x                       x

 12.6%  208367ms      0.80avg   262055x -- UPDATE hive_posts_cache SET payout = :payout, promoted = :promoted, rshares = :rshares, votes = :votes, sc_trend = :sc_trend, sc_hot = :sc_hot, flag_weight = :flag_weight, total_vo
 11.7%  192930ms      1.00avg   192297x -- UPDATE hive_posts_cache SET created_at = :created_at, payout_at = :payout_at, updated_at = :updated_at, title = :title, preview = :preview, body = :body, img_url = :img_url, is_nsf
  6.1%  100382ms      0.67avg   149649x -- INSERT INTO hive_posts_cache (post_id, author, permlink, category, depth, created_at, payout_at, updated_at, title, preview, body, img_url, is_nsfw, is_declined, is_full_power, is_