Last active
July 26, 2023 09:37
-
-
Save Nutomic/1e030437e81db4f6e9e2dda25854d62c to your computer and use it in GitHub Desktop.
lemmy.ml slow queries 3
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -[ RECORD 1 ]----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | 3697935042131327076 | |
| query | COPY public.activity (id, data, local, published, updated, ap_id, sensitive) TO stdout | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 1 | |
| total_exec_time | 1008311.987323 | |
| min_exec_time | 1008311.987323 | |
| max_exec_time | 1008311.987323 | |
| mean_exec_time | 1008311.987323 | |
| stddev_exec_time | 0 | |
| rows | 43648855 | |
| shared_blks_hit | 1603403 | |
| shared_blks_read | 4957784 | |
| shared_blks_dirtied | 27807 | |
| shared_blks_written | 28020 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 0 | |
| temp_blks_written | 0 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 2729 | |
| wal_fpi | 2729 | |
| wal_bytes | 15986087 | |
| jit_functions | 0 | |
| jit_generation_time | 0 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 0 | |
| jit_optimization_time | 0 | |
| jit_emission_count | 0 | |
| jit_emission_time | 0 | |
| -[ RECORD 2 ]----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | 3929319056763082342 | |
| query | UPDATE "post" SET "removed" = $1, "updated" = $2 WHERE ("post"."creator_id" = $3) RETURNING "post"."id", "post"."name", "post"."url", "post"."body", "post"."creator_id", "post"."community_id", "post"."removed", "post"."locked", "post"."published", "post"."updated", "post"."deleted", "post"."nsfw", "post"."embed_title", "post"."embed_description", "post"."thumbnail_url", "post"."ap_id", "post"."local", "post"."embed_video_url", "post"."language_id", "post"."featured_community", "post"."featured_local" | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 6 | |
| total_exec_time | 691424.3024519999 | |
| min_exec_time | 0.019272 | |
| max_exec_time | 624648.4238199999 | |
| mean_exec_time | 115237.38374200002 | |
| stddev_exec_time | 228315.69268431005 | |
| rows | 87 | |
| shared_blks_hit | 66609550 | |
| shared_blks_read | 10024807 | |
| shared_blks_dirtied | 49490 | |
| shared_blks_written | 2859 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 4039010 | |
| temp_blks_written | 4902542 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 424214 | |
| wal_fpi | 4097 | |
| wal_bytes | 56541850 | |
| jit_functions | 0 | |
| jit_generation_time | 0 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 0 | |
| jit_optimization_time | 0 | |
| jit_emission_count | 0 | |
| jit_emission_time | 0 | |
| -[ RECORD 3 ]----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | 3714628757163292883 | |
| query | DELETE FROM "activity" WHERE ("activity"."published" < (CURRENT_TIMESTAMP - $1)) | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 6 | |
| total_exec_time | 349640.724329 | |
| min_exec_time | 55152.995296999994 | |
| max_exec_time | 61310.663059 | |
| mean_exec_time | 58273.45405483333 | |
| stddev_exec_time | 1885.1482738624238 | |
| rows | 27135 | |
| shared_blks_hit | 40319 | |
| shared_blks_read | 27269627 | |
| shared_blks_dirtied | 216748 | |
| shared_blks_written | 197796 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 0 | |
| temp_blks_written | 0 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 35068 | |
| wal_fpi | 18852 | |
| wal_bytes | 140686740 | |
| jit_functions | 18 | |
| jit_generation_time | 1.7257860000000003 | |
| jit_inlining_count | 6 | |
| jit_inlining_time | 168.64013799999998 | |
| jit_optimization_count | 6 | |
| jit_optimization_time | 162.057995 | |
| jit_emission_count | 6 | |
| jit_emission_time | 67.77102599999999 | |
| -[ RECORD 4 ]----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | -8338133826951894097 | |
| query | UPDATE "comment" SET "content" = $1, "deleted" = $2, "updated" = $3 WHERE ("comment"."creator_id" = $4) RETURNING "comment"."id", "comment"."creator_id", "comment"."post_id", "comment"."content", "comment"."removed", "comment"."published", "comment"."updated", "comment"."deleted", "comment"."ap_id", "comment"."local", "comment"."path", "comment"."distinguished", "comment"."language_id" | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 21 | |
| total_exec_time | 1103933.599304 | |
| min_exec_time | 0.013975 | |
| max_exec_time | 342177.997022 | |
| mean_exec_time | 52568.26663352381 | |
| stddev_exec_time | 98236.9587530844 | |
| rows | 92 | |
| shared_blks_hit | 68310948 | |
| shared_blks_read | 17309279 | |
| shared_blks_dirtied | 5355 | |
| shared_blks_written | 2467 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 6500989 | |
| temp_blks_written | 7714815 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 12960 | |
| wal_fpi | 787 | |
| wal_bytes | 5571262 | |
| jit_functions | 0 | |
| jit_generation_time | 0 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 0 | |
| jit_optimization_time | 0 | |
| jit_emission_count | 0 | |
| jit_emission_time | 0 | |
| -[ RECORD 5 ]----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | 7456096206148916267 | |
| query | COPY public.comment_like (id, person_id, comment_id, post_id, score, published) TO stdout | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 1 | |
| total_exec_time | 46919.581093 | |
| min_exec_time | 46919.581093 | |
| max_exec_time | 46919.581093 | |
| mean_exec_time | 46919.581093 | |
| stddev_exec_time | 0 | |
| rows | 11086702 | |
| shared_blks_hit | 2 | |
| shared_blks_read | 82631 | |
| shared_blks_dirtied | 0 | |
| shared_blks_written | 0 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 0 | |
| temp_blks_written | 0 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 0 | |
| wal_fpi | 0 | |
| wal_bytes | 0 | |
| jit_functions | 0 | |
| jit_generation_time | 0 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 0 | |
| jit_optimization_time | 0 | |
| jit_emission_count | 0 | |
| jit_emission_time | 0 | |
| -[ RECORD 6 ]----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | 1271248864239285823 | |
| query | COPY public.post_like (id, post_id, person_id, score, published) TO stdout | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 1 | |
| total_exec_time | 42815.690482 | |
| min_exec_time | 42815.690482 | |
| max_exec_time | 42815.690482 | |
| mean_exec_time | 42815.690482 | |
| stddev_exec_time | 0 | |
| rows | 9463977 | |
| shared_blks_hit | 11 | |
| shared_blks_read | 61171 | |
| shared_blks_dirtied | 133 | |
| shared_blks_written | 53 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 0 | |
| temp_blks_written | 0 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 80 | |
| wal_fpi | 80 | |
| wal_bytes | 652992 | |
| jit_functions | 0 | |
| jit_generation_time | 0 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 0 | |
| jit_optimization_time | 0 | |
| jit_emission_count | 0 | |
| jit_emission_time | 0 | |
| -[ RECORD 7 ]----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | 8472469506640218479 | |
| query | SELECT "comment"."id", "comment"."creator_id", "comment"."post_id", "comment"."content", "comment"."removed", "comment"."published", "comment"."updated", "comment"."deleted", "comment"."ap_id", "comment"."local", "comment"."path", "comment"."distinguished", "comment"."language_id", "person"."id", "person"."name", "person"."display_name", "person"."avatar", "person"."banned", "person"."published", "person"."updated", "person"."actor_id", "person"."bio", "person"."local", "person"."private_key", "person"."public_key", "person"."last_refreshed_at", "person"."banner", "person"."deleted", "person"."inbox_url", "person"."shared_inbox_url", "person"."matrix_user_id", "person"."admin", "person"."bot_account", "person"."ban_expires", "person"."instance_id", "post"."id", "post"."name", "post"."url", "post"."body", "post"."creator_id", "post"."community_id", "post"."removed", "post"."locked", "post"."published", "post"."updated", "post"."deleted", "post"."nsfw", "post"."embed_title", "post"."embed_description", "post"."thumbnail_url", "post"."ap_id", "post"."local", "post"."embed_video_url", "post"."language_id", "post"."featured_community", "post"."featured_local", "community"."id", "community"."name", "community"."title", "community"."description", "community"."removed", "community"."published", "community"."updated", "community"."deleted", "community"."nsfw", "community"."actor_id", "community"."local", "community"."private_key", "community"."public_key", "community"."last_refreshed_at", "community"."icon", "community"."banner", "community"."followers_url", "community"."inbox_url", "community"."shared_inbox_url", "community"."hidden", "community"."posting_restricted_to_mods", "community"."instance_id", "community"."moderators_url", "community"."featured_url", "comment_aggregates"."id", "comment_aggregates"."comment_id", "comment_aggregates"."score", "comment_aggregates"."upvotes", "comment_aggregates"."downvotes", "comment_aggregates"."published", "comment_aggregates"."child_count", "comment_aggregates"."hot_rank", "community_person_ban"."id", "community_person_ban"."community_id", "community_person_ban"."person_id", "community_person_ban"."published", "community_person_ban"."expires", "community_follower"."id", "community_follower"."community_id", "community_follower"."person_id", "community_follower"."published", "community_follower"."pending", "comment_saved"."id", "comment_saved"."comment_id", "comment_saved"."person_id", "comment_saved"."published", "person_block"."id", "person_block"."person_id", "person_block"."target_id", "person_block"."published", "comment_like"."score" FROM ((((((((((("comment" INNER JOIN "person" ON ("comment"."creator_id" = "person"."id")) INNER JOIN "post" ON ("comment"."post_id" = "post"."id")) INNER JOIN "community" ON ("post"."community_id" = "community"."id")) INNER JOIN "comment_aggregates" ON ("comment_aggregates"."comment_id" = "comment"."id")) LEFT OUTER JOIN "community_person_ban" ON (("community"."id" = "community_person_ban"."community_id") AND ("community_person_ban"."person_id" = "comment"."creator_id"))) LEFT OUTER JOIN "community_follower" ON (("post"."community_id" = "community_follower"."community_id") AND ("community_follower"."person_id" = $1))) LEFT OUTER JOIN "comment_saved" ON (("comment"."id" = "comment_saved"."comment_id") AND ("comment_saved"."person_id" = $2))) LEFT OUTER JOIN "person_block" ON (("comment"."creator_id" = "person_block"."target_id") AND ("person_block"."person_id" = $3))) LEFT OUTER JOIN "community_block" ON (("community"."id" = "community_block"."community_id") AND ("community_block"."person_id" = $4))) LEFT OUTER JOIN "comment_like" ON (("comment"."id" = "comment_like"."comment_id") AND ("comment_like"."person_id" = $5))) LEFT OUTER JOIN "local_user_language" ON (("comment"."language_id" = "local_user_language"."language_id") AND ("local_user_language"."local_user_id" = $6))) WHERE ((("community"."hidden" = $7) OR ("community_follower"."person_id" = $8)) AND (nlevel("comment"."path") <= $9)) ORDER BY subpath("comment"."path", $10, $11), "comment_aggregates"."hot_rank" DESC LIMIT $12 OFFSET $13 | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 74 | |
| total_exec_time | 2636017.1266630013 | |
| min_exec_time | 17729.189581 | |
| max_exec_time | 606188.7788620001 | |
| mean_exec_time | 35621.853063013514 | |
| stddev_exec_time | 68058.38339970597 | |
| rows | 22200 | |
| shared_blks_hit | 755258950 | |
| shared_blks_read | 85784671 | |
| shared_blks_dirtied | 112639 | |
| shared_blks_written | 227001 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 7695772 | |
| temp_blks_written | 10971105 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 40491 | |
| wal_fpi | 17943 | |
| wal_bytes | 130974001 | |
| jit_functions | 5106 | |
| jit_generation_time | 796.6317109999997 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 74 | |
| jit_optimization_time | 256.542632 | |
| jit_emission_count | 74 | |
| jit_emission_time | 4868.177588999999 | |
| -[ RECORD 8 ]----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | 2982909720204203398 | |
| query | UPDATE "comment" SET "removed" = $1 WHERE ("comment"."id" = $2) RETURNING "comment"."id", "comment"."creator_id", "comment"."post_id", "comment"."content", "comment"."removed", "comment"."published", "comment"."updated", "comment"."deleted", "comment"."ap_id", "comment"."local", "comment"."path", "comment"."distinguished", "comment"."language_id" | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 227 | |
| total_exec_time | 6506184.188338001 | |
| min_exec_time | 0.091666 | |
| max_exec_time | 187688.633397 | |
| mean_exec_time | 28661.604353911895 | |
| stddev_exec_time | 42072.57101332027 | |
| rows | 227 | |
| shared_blks_hit | 109102998 | |
| shared_blks_read | 27545991 | |
| shared_blks_dirtied | 12881 | |
| shared_blks_written | 7419 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 10245094 | |
| temp_blks_written | 12145227 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 23070 | |
| wal_fpi | 1236 | |
| wal_bytes | 8396675 | |
| jit_functions | 0 | |
| jit_generation_time | 0 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 0 | |
| jit_optimization_time | 0 | |
| jit_emission_count | 0 | |
| jit_emission_time | 0 | |
| -[ RECORD 9 ]----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | -2913403126206048752 | |
| query | SELECT "comment"."id", "comment"."creator_id", "comment"."post_id", "comment"."content", "comment"."removed", "comment"."published", "comment"."updated", "comment"."deleted", "comment"."ap_id", "comment"."local", "comment"."path", "comment"."distinguished", "comment"."language_id", "person"."id", "person"."name", "person"."display_name", "person"."avatar", "person"."banned", "person"."published", "person"."updated", "person"."actor_id", "person"."bio", "person"."local", "person"."private_key", "person"."public_key", "person"."last_refreshed_at", "person"."banner", "person"."deleted", "person"."inbox_url", "person"."shared_inbox_url", "person"."matrix_user_id", "person"."admin", "person"."bot_account", "person"."ban_expires", "person"."instance_id", "post"."id", "post"."name", "post"."url", "post"."body", "post"."creator_id", "post"."community_id", "post"."removed", "post"."locked", "post"."published", "post"."updated", "post"."deleted", "post"."nsfw", "post"."embed_title", "post"."embed_description", "post"."thumbnail_url", "post"."ap_id", "post"."local", "post"."embed_video_url", "post"."language_id", "post"."featured_community", "post"."featured_local", "community"."id", "community"."name", "community"."title", "community"."description", "community"."removed", "community"."published", "community"."updated", "community"."deleted", "community"."nsfw", "community"."actor_id", "community"."local", "community"."private_key", "community"."public_key", "community"."last_refreshed_at", "community"."icon", "community"."banner", "community"."followers_url", "community"."inbox_url", "community"."shared_inbox_url", "community"."hidden", "community"."posting_restricted_to_mods", "community"."instance_id", "community"."moderators_url", "community"."featured_url", "comment_aggregates"."id", "comment_aggregates"."comment_id", "comment_aggregates"."score", "comment_aggregates"."upvotes", "comment_aggregates"."downvotes", "comment_aggregates"."published", "comment_aggregates"."child_count", "comment_aggregates"."hot_rank", "community_person_ban"."id", "community_person_ban"."community_id", "community_person_ban"."person_id", "community_person_ban"."published", "community_person_ban"."expires", "community_follower"."id", "community_follower"."community_id", "community_follower"."person_id", "community_follower"."published", "community_follower"."pending", "comment_saved"."id", "comment_saved"."comment_id", "comment_saved"."person_id", "comment_saved"."published", "person_block"."id", "person_block"."person_id", "person_block"."target_id", "person_block"."published", "comment_like"."score" FROM ((((((((((("comment" INNER JOIN "person" ON ("comment"."creator_id" = "person"."id")) INNER JOIN "post" ON ("comment"."post_id" = "post"."id")) INNER JOIN "community" ON ("post"."community_id" = "community"."id")) INNER JOIN "comment_aggregates" ON ("comment_aggregates"."comment_id" = "comment"."id")) LEFT OUTER JOIN "community_person_ban" ON (("community"."id" = "community_person_ban"."community_id") AND ("community_person_ban"."person_id" = "comment"."creator_id"))) LEFT OUTER JOIN "community_follower" ON (("post"."community_id" = "community_follower"."community_id") AND ("community_follower"."person_id" = $1))) LEFT OUTER JOIN "comment_saved" ON (("comment"."id" = "comment_saved"."comment_id") AND ("comment_saved"."person_id" = $2))) LEFT OUTER JOIN "person_block" ON (("comment"."creator_id" = "person_block"."target_id") AND ("person_block"."person_id" = $3))) LEFT OUTER JOIN "community_block" ON (("community"."id" = "community_block"."community_id") AND ("community_block"."person_id" = $4))) LEFT OUTER JOIN "comment_like" ON (("comment"."id" = "comment_like"."comment_id") AND ("comment_like"."person_id" = $5))) LEFT OUTER JOIN "local_user_language" ON (("comment"."language_id" = "local_user_language"."language_id") AND ("local_user_language"."local_user_id" = $6))) WHERE (((((("community"."hidden" = $7) OR ("community_follower"."person_id" = $8)) AND ("local_user_language"."language_id" IS NOT NULL)) AND ("community_block"."person_id" IS NULL)) AND ("person_block"."person_id" IS NULL)) AND (nlevel("comment"."path") <= $9)) ORDER BY subpath("comment"."path", $10, $11), "comment_aggregates"."hot_rank" DESC LIMIT $12 OFFSET $13 | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 10 | |
| total_exec_time | 269281.936247 | |
| min_exec_time | 17827.93038 | |
| max_exec_time | 33421.584912 | |
| mean_exec_time | 26928.193624699998 | |
| stddev_exec_time | 4260.060038903517 | |
| rows | 3000 | |
| shared_blks_hit | 101011311 | |
| shared_blks_read | 11312089 | |
| shared_blks_dirtied | 14435 | |
| shared_blks_written | 19449 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 1032971 | |
| temp_blks_written | 1471858 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 628 | |
| wal_fpi | 45 | |
| wal_bytes | 377541 | |
| jit_functions | 810 | |
| jit_generation_time | 109.14659600000002 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 10 | |
| jit_optimization_time | 39.67996900000001 | |
| jit_emission_count | 10 | |
| jit_emission_time | 770.0043519999999 | |
| -[ RECORD 10 ]---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | 2537746929555263403 | |
| query | INSERT INTO "site" ("name", "sidebar", "updated", "icon", "banner", "description", "actor_id", "last_refreshed_at", "inbox_url", "private_key", "public_key", "instance_id") VALUES ($1, $2, $3, DEFAULT, DEFAULT, $4, $5, $6, $7, DEFAULT, $8, $9) ON CONFLICT ("actor_id") DO UPDATE SET "name" = $10, "sidebar" = $11, "updated" = $12, "description" = $13, "actor_id" = $14, "last_refreshed_at" = $15, "inbox_url" = $16, "public_key" = $17, "instance_id" = $18 RETURNING "site"."id", "site"."name", "site"."sidebar", "site"."published", "site"."updated", "site"."icon", "site"."banner", "site"."description", "site"."actor_id", "site"."last_refreshed_at", "site"."inbox_url", "site"."private_key", "site"."public_key", "site"."instance_id" | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 105 | |
| total_exec_time | 2656117.6975919977 | |
| min_exec_time | 0.07122300000000001 | |
| max_exec_time | 505790.077856 | |
| mean_exec_time | 25296.35902468571 | |
| stddev_exec_time | 90808.33417853942 | |
| rows | 105 | |
| shared_blks_hit | 1214 | |
| shared_blks_read | 470 | |
| shared_blks_dirtied | 352 | |
| shared_blks_written | 5 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 0 | |
| temp_blks_written | 0 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 366 | |
| wal_fpi | 184 | |
| wal_bytes | 1166797 | |
| jit_functions | 0 | |
| jit_generation_time | 0 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 0 | |
| jit_optimization_time | 0 | |
| jit_emission_count | 0 | |
| jit_emission_time | 0 | |
| -[ RECORD 11 ]---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | -4354683800972425971 | |
| query | COPY public.comment (id, creator_id, post_id, content, removed, published, updated, deleted, ap_id, local, path, distinguished, language_id) TO stdout | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 1 | |
| total_exec_time | 24627.385752 | |
| min_exec_time | 24627.385752 | |
| max_exec_time | 24627.385752 | |
| mean_exec_time | 24627.385752 | |
| stddev_exec_time | 0 | |
| rows | 1706216 | |
| shared_blks_hit | 14627 | |
| shared_blks_read | 82437 | |
| shared_blks_dirtied | 0 | |
| shared_blks_written | 13 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 0 | |
| temp_blks_written | 0 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 0 | |
| wal_fpi | 0 | |
| wal_bytes | 0 | |
| jit_functions | 0 | |
| jit_generation_time | 0 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 0 | |
| jit_optimization_time | 0 | |
| jit_emission_count | 0 | |
| jit_emission_time | 0 | |
| -[ RECORD 12 ]---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | 228737954722553604 | |
| query | COPY public.local_user_language (id, local_user_id, language_id) TO stdout | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 1 | |
| total_exec_time | 23351.915323 | |
| min_exec_time | 23351.915323 | |
| max_exec_time | 23351.915323 | |
| mean_exec_time | 23351.915323 | |
| stddev_exec_time | 0 | |
| rows | 7722383 | |
| shared_blks_hit | 0 | |
| shared_blks_read | 48675 | |
| shared_blks_dirtied | 166 | |
| shared_blks_written | 156 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 0 | |
| temp_blks_written | 0 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 12 | |
| wal_fpi | 12 | |
| wal_bytes | 28860 | |
| jit_functions | 0 | |
| jit_generation_time | 0 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 0 | |
| jit_optimization_time | 0 | |
| jit_emission_count | 0 | |
| jit_emission_time | 0 | |
| -[ RECORD 13 ]---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | 4512440373956898667 | |
| query | INSERT INTO "post" ("name", "creator_id", "community_id", "nsfw", "url", "body", "removed", "locked", "updated", "published", "deleted", "embed_title", "embed_description", "embed_video_url", "thumbnail_url", "ap_id", "local", "language_id", "featured_community", "featured_local") VALUES ($1, $2, $3, DEFAULT, DEFAULT, $4, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT) ON CONFLICT ("ap_id") DO UPDATE SET "name" = $5, "creator_id" = $6, "community_id" = $7, "body" = $8 RETURNING "post"."id", "post"."name", "post"."url", "post"."body", "post"."creator_id", "post"."community_id", "post"."removed", "post"."locked", "post"."published", "post"."updated", "post"."deleted", "post"."nsfw", "post"."embed_title", "post"."embed_description", "post"."thumbnail_url", "post"."ap_id", "post"."local", "post"."embed_video_url", "post"."language_id", "post"."featured_community", "post"."featured_local" | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 24 | |
| total_exec_time | 550538.3284580002 | |
| min_exec_time | 14.487521999999998 | |
| max_exec_time | 548729.0123640001 | |
| mean_exec_time | 22939.09701908334 | |
| stddev_exec_time | 109634.89095803122 | |
| rows | 24 | |
| shared_blks_hit | 1816286 | |
| shared_blks_read | 130789 | |
| shared_blks_dirtied | 15775 | |
| shared_blks_written | 373 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 0 | |
| temp_blks_written | 0 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 96538 | |
| wal_fpi | 3434 | |
| wal_bytes | 11114228 | |
| jit_functions | 0 | |
| jit_generation_time | 0 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 0 | |
| jit_optimization_time | 0 | |
| jit_emission_count | 0 | |
| jit_emission_time | 0 | |
| -[ RECORD 14 ]---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | -3840816129504233702 | |
| query | UPDATE "comment" SET "deleted" = $1 WHERE ("comment"."id" = $2) RETURNING "comment"."id", "comment"."creator_id", "comment"."post_id", "comment"."content", "comment"."removed", "comment"."published", "comment"."updated", "comment"."deleted", "comment"."ap_id", "comment"."local", "comment"."path", "comment"."distinguished", "comment"."language_id" | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 694 | |
| total_exec_time | 15190032.874581985 | |
| min_exec_time | 0.34546499999999997 | |
| max_exec_time | 693781.656437 | |
| mean_exec_time | 21887.655438878963 | |
| stddev_exec_time | 51199.393658835485 | |
| rows | 694 | |
| shared_blks_hit | 432641831 | |
| shared_blks_read | 109164025 | |
| shared_blks_dirtied | 113520 | |
| shared_blks_written | 35531 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 40353124 | |
| temp_blks_written | 47832992 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 454536 | |
| wal_fpi | 14362 | |
| wal_bytes | 79730027 | |
| jit_functions | 0 | |
| jit_generation_time | 0 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 0 | |
| jit_optimization_time | 0 | |
| jit_emission_count | 0 | |
| jit_emission_time | 0 | |
| -[ RECORD 15 ]---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | -1113434605057531957 | |
| query | COPY public.person (id, name, display_name, avatar, banned, published, updated, actor_id, bio, local, private_key, public_key, last_refreshed_at, banner, deleted, inbox_url, shared_inbox_url, matrix_user_id, admin, bot_account, ban_expires, instance_id) TO stdout | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 1 | |
| total_exec_time | 20162.233371 | |
| min_exec_time | 20162.233371 | |
| max_exec_time | 20162.233371 | |
| mean_exec_time | 20162.233371 | |
| stddev_exec_time | 0 | |
| rows | 378584 | |
| shared_blks_hit | 116419 | |
| shared_blks_read | 55229 | |
| shared_blks_dirtied | 0 | |
| shared_blks_written | 22 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 0 | |
| temp_blks_written | 0 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 0 | |
| wal_fpi | 0 | |
| wal_bytes | 0 | |
| jit_functions | 0 | |
| jit_generation_time | 0 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 0 | |
| jit_optimization_time | 0 | |
| jit_emission_count | 0 | |
| jit_emission_time | 0 | |
| -[ RECORD 16 ]---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | 1715845457586678341 | |
| query | COPY public.post_read (id, post_id, person_id, published) TO stdout | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 1 | |
| total_exec_time | 15528.840463 | |
| min_exec_time | 15528.840463 | |
| max_exec_time | 15528.840463 | |
| mean_exec_time | 15528.840463 | |
| stddev_exec_time | 0 | |
| rows | 3456292 | |
| shared_blks_hit | 3 | |
| shared_blks_read | 22718 | |
| shared_blks_dirtied | 188 | |
| shared_blks_written | 162 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 0 | |
| temp_blks_written | 0 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 0 | |
| wal_fpi | 0 | |
| wal_bytes | 0 | |
| jit_functions | 0 | |
| jit_generation_time | 0 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 0 | |
| jit_optimization_time | 0 | |
| jit_emission_count | 0 | |
| jit_emission_time | 0 | |
| -[ RECORD 17 ]---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | -3574213176294878610 | |
| query | INSERT INTO "post" ("name", "creator_id", "community_id", "nsfw", "url", "body", "removed", "locked", "updated", "published", "deleted", "embed_title", "embed_description", "embed_video_url", "thumbnail_url", "ap_id", "local", "language_id", "featured_community", "featured_local") VALUES ($1, $2, $3, $4, DEFAULT, $5, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $6, DEFAULT, DEFAULT) ON CONFLICT ("ap_id") DO UPDATE SET "name" = $7, "creator_id" = $8, "community_id" = $9, "nsfw" = $10, "body" = $11, "language_id" = $12 RETURNING "post"."id", "post"."name", "post"."url", "post"."body", "post"."creator_id", "post"."community_id", "post"."removed", "post"."locked", "post"."published", "post"."updated", "post"."deleted", "post"."nsfw", "post"."embed_title", "post"."embed_description", "post"."thumbnail_url", "post"."ap_id", "post"."local", "post"."embed_video_url", "post"."language_id", "post"."featured_community", "post"."featured_local" | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 12 | |
| total_exec_time | 174290.382993 | |
| min_exec_time | 18.272061 | |
| max_exec_time | 173664.105775 | |
| mean_exec_time | 14524.198582750001 | |
| stddev_exec_time | 47982.50254732366 | |
| rows | 12 | |
| shared_blks_hit | 696015 | |
| shared_blks_read | 67304 | |
| shared_blks_dirtied | 8347 | |
| shared_blks_written | 320 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 0 | |
| temp_blks_written | 0 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 50319 | |
| wal_fpi | 1362 | |
| wal_bytes | 5612029 | |
| jit_functions | 0 | |
| jit_generation_time | 0 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 0 | |
| jit_optimization_time | 0 | |
| jit_emission_count | 0 | |
| jit_emission_time | 0 | |
| -[ RECORD 18 ]---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | f | |
| queryid | 7973792853866111528 | |
| query | update person_aggregates ua + | |
| | set comment_score = cd.score + | |
| | from ( + | |
| | select u.id, + | |
| | coalesce($16, sum(cl.score)) as score + | |
| | -- User join because comments could be empty + | |
| | from person u + | |
| | left join comment c on u.id = c.creator_id and c.deleted = $17 and c.removed = $18 + | |
| | left join comment_like cl on c.id = cl.comment_id + | |
| | group by u.id + | |
| | ) cd + | |
| | where ua.person_id = OLD.creator_id | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 290 | |
| total_exec_time | 3833937.0515600005 | |
| min_exec_time | 10683.262124 | |
| max_exec_time | 20182.23339 | |
| mean_exec_time | 13220.472591586196 | |
| stddev_exec_time | 1636.0003131853134 | |
| rows | 290 | |
| shared_blks_hit | 222114176 | |
| shared_blks_read | 56627345 | |
| shared_blks_dirtied | 16524 | |
| shared_blks_written | 13419 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 21229748 | |
| temp_blks_written | 25196519 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 2648 | |
| wal_fpi | 1071 | |
| wal_bytes | 7498833 | |
| jit_functions | 9574 | |
| jit_generation_time | 468.6088259999998 | |
| jit_inlining_count | 290 | |
| jit_inlining_time | 4469.232477 | |
| jit_optimization_count | 290 | |
| jit_optimization_time | 23687.300923000006 | |
| jit_emission_count | 290 | |
| jit_emission_time | 16410.494537000002 | |
| -[ RECORD 19 ]---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | -1893767274481675806 | |
| query | UPDATE "post" SET "deleted" = $1 WHERE ("post"."id" = $2) RETURNING "post"."id", "post"."name", "post"."url", "post"."body", "post"."creator_id", "post"."community_id", "post"."removed", "post"."locked", "post"."published", "post"."updated", "post"."deleted", "post"."nsfw", "post"."embed_title", "post"."embed_description", "post"."thumbnail_url", "post"."ap_id", "post"."local", "post"."embed_video_url", "post"."language_id", "post"."featured_community", "post"."featured_local" | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 55 | |
| total_exec_time | 722150.0240490001 | |
| min_exec_time | 1172.4511579999999 | |
| max_exec_time | 64754.986013999995 | |
| mean_exec_time | 13130.000437254545 | |
| stddev_exec_time | 8152.604376019955 | |
| rows | 55 | |
| shared_blks_hit | 39166799 | |
| shared_blks_read | 6559799 | |
| shared_blks_dirtied | 14871 | |
| shared_blks_written | 3136 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 2643989 | |
| temp_blks_written | 3208178 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 36542 | |
| wal_fpi | 5245 | |
| wal_bytes | 44331443 | |
| jit_functions | 0 | |
| jit_generation_time | 0 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 0 | |
| jit_optimization_time | 0 | |
| jit_emission_count | 0 | |
| jit_emission_time | 0 | |
| -[ RECORD 20 ]---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| userid | 10 | |
| dbid | 16384 | |
| toplevel | t | |
| queryid | 9083833851709914137 | |
| query | UPDATE "post" SET "removed" = $1 WHERE ("post"."id" = $2) RETURNING "post"."id", "post"."name", "post"."url", "post"."body", "post"."creator_id", "post"."community_id", "post"."removed", "post"."locked", "post"."published", "post"."updated", "post"."deleted", "post"."nsfw", "post"."embed_title", "post"."embed_description", "post"."thumbnail_url", "post"."ap_id", "post"."local", "post"."embed_video_url", "post"."language_id", "post"."featured_community", "post"."featured_local" | |
| plans | 0 | |
| total_plan_time | 0 | |
| min_plan_time | 0 | |
| max_plan_time | 0 | |
| mean_plan_time | 0 | |
| stddev_plan_time | 0 | |
| calls | 154 | |
| total_exec_time | 1811094.9741549992 | |
| min_exec_time | 0.12352 | |
| max_exec_time | 57900.004068 | |
| mean_exec_time | 11760.356975032466 | |
| stddev_exec_time | 5609.761817521606 | |
| rows | 154 | |
| shared_blks_hit | 109428898 | |
| shared_blks_read | 19765615 | |
| shared_blks_dirtied | 35001 | |
| shared_blks_written | 17222 | |
| local_blks_hit | 0 | |
| local_blks_read | 0 | |
| local_blks_dirtied | 0 | |
| local_blks_written | 0 | |
| temp_blks_read | 7316185 | |
| temp_blks_written | 8876097 | |
| blk_read_time | 0 | |
| blk_write_time | 0 | |
| temp_blk_read_time | 0 | |
| temp_blk_write_time | 0 | |
| wal_records | 43769 | |
| wal_fpi | 17693 | |
| wal_bytes | 144484969 | |
| jit_functions | 0 | |
| jit_generation_time | 0 | |
| jit_inlining_count | 0 | |
| jit_inlining_time | 0 | |
| jit_optimization_count | 0 | |
| jit_optimization_time | 0 | |
| jit_emission_count | 0 | |
| jit_emission_time | 0 | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment