explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VMKg : Optimization for: Optimization for: Optimization for: Optimization for: plan #oi1K; plan #d1aY; plan #KjB; plan #RbuR

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.002 372,034.738 ↑ 1.0 1 1

Limit (cost=11,815.27..11,815.27 rows=1 width=406) (actual time=372,034.737..372,034.738 rows=1 loops=1)

2. 4.326 372,034.736 ↑ 1.0 1 1

Sort (cost=11,815.27..11,815.27 rows=1 width=406) (actual time=372,034.735..372,034.736 rows=1 loops=1)

  • Sort Key: (sum((social_interactions_201609.seen)::integer)) DESC, (max(social_interactions_201609.action_date)) DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.446 372,030.410 ↑ 1.0 1 1

GroupAggregate (cost=11,815.23..11,815.26 rows=1 width=406) (actual time=372,030.377..372,030.410 rows=1 loops=1)

  • Group Key: social_activities.id
4. 1.462 372,029.964 ↓ 15.0 15 1

Sort (cost=11,815.23..11,815.24 rows=1 width=399) (actual time=372,029.962..372,029.964 rows=15 loops=1)

  • Sort Key: social_activities.id
  • Sort Method: quicksort Memory: 28kB
5. 0.583 372,028.502 ↓ 15.0 15 1

Nested Loop (cost=4.72..11,815.22 rows=1 width=399) (actual time=320,855.692..372,028.502 rows=15 loops=1)

  • Join Filter: ((social_activities.page_uid)::text = (social_credentials.active_page_id)::text)
  • Rows Removed by Join Filter: 41
6. 2.242 2.242 ↑ 1.0 1 1

Seq Scan on social_credentials (cost=0.00..11.80 rows=1 width=32) (actual time=0.455..2.242 rows=1 loops=1)

  • Filter: ((user_id = 4,158) AND ((social_network)::text = 'facebook'::text))
  • Rows Removed by Filter: 36
7. 115.770 372,025.677 ↓ 56.0 56 1

Nested Loop (cost=4.72..11,803.41 rows=1 width=399) (actual time=265,696.623..372,025.677 rows=56 loops=1)

8. 27.407 361,588.691 ↓ 647.7 31,088 1

Append (cost=4.29..11,389.54 rows=48 width=13) (actual time=38.220..361,588.691 rows=31,088 loops=1)

9. 1.206 6.053 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201609 (cost=4.29..9.96 rows=1 width=13) (actual time=6.053..6.053 rows=0 loops=1)

  • Recheck Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 627
  • Heap Blocks: exact=12
10. 4.847 4.847 ↓ 313.5 627 1

Bitmap Index Scan on social_activity_interactions_201609_interaction_type_idx (cost=0.00..4.29 rows=2 width=0) (actual time=4.847..4.847 rows=627 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
11. 3.881 32.961 ↑ 1.0 1 1

Bitmap Heap Scan on social_interactions_201610 (cost=9.01..13.02 rows=1 width=13) (actual time=32.164..32.961 rows=1 loops=1)

  • Recheck Cond: (((interaction_type)::text = 'SocialInteractions::Activity'::text) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 4,972
  • Heap Blocks: exact=97
12. 0.008 29.080 ↓ 0.0 0 1

BitmapAnd (cost=9.01..9.01 rows=1 width=0) (actual time=29.080..29.080 rows=0 loops=1)

13. 24.143 24.143 ↓ 382.5 4,973 1

Bitmap Index Scan on social_activity_interactions_201610_interaction_type_idx (cost=0.00..4.38 rows=13 width=0) (actual time=24.143..24.143 rows=4,973 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
14. 4.929 4.929 ↓ 382.8 4,977 1

Bitmap Index Scan on social_activity_interactions_201610_parent_id_idx (cost=0.00..4.38 rows=13 width=0) (actual time=4.929..4.929 rows=4,977 loops=1)

  • Index Cond: (parent_id IS NULL)
15. 9.090 64.729 ↑ 1.0 1 1

Bitmap Heap Scan on social_interactions_201611 (cost=9.24..13.25 rows=1 width=13) (actual time=62.595..64.729 rows=1 loops=1)

  • Recheck Cond: (((interaction_type)::text = 'SocialInteractions::Activity'::text) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 11,010
  • Heap Blocks: exact=212
16. 0.013 55.639 ↓ 0.0 0 1

BitmapAnd (cost=9.24..9.24 rows=1 width=0) (actual time=55.639..55.639 rows=0 loops=1)

17. 37.551 37.551 ↓ 393.4 11,014 1

Bitmap Index Scan on social_activity_interactions_201611_interaction_type_idx (cost=0.00..4.49 rows=28 width=0) (actual time=37.551..37.551 rows=11,014 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
18. 18.075 18.075 ↓ 393.4 11,016 1

Bitmap Index Scan on social_activity_interactions_201611_parent_id_idx (cost=0.00..4.49 rows=28 width=0) (actual time=18.075..18.075 rows=11,016 loops=1)

  • Index Cond: (parent_id IS NULL)
19. 15.828 115.159 ↑ 1.0 1 1

Bitmap Heap Scan on social_interactions_201612 (cost=9.56..13.57 rows=1 width=13) (actual time=109.319..115.159 rows=1 loops=1)

  • Recheck Cond: (((interaction_type)::text = 'SocialInteractions::Activity'::text) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 19,479
  • Heap Blocks: exact=373
20. 0.018 99.331 ↓ 0.0 0 1

BitmapAnd (cost=9.56..9.56 rows=1 width=0) (actual time=99.330..99.331 rows=0 loops=1)

21. 67.070 67.070 ↓ 397.6 19,482 1

Bitmap Index Scan on social_activity_interactions_201612_interaction_type_idx (cost=0.00..4.65 rows=49 width=0) (actual time=67.070..67.070 rows=19,482 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
22. 32.243 32.243 ↓ 397.6 19,482 1

Bitmap Index Scan on social_activity_interactions_201612_parent_id_idx (cost=0.00..4.65 rows=49 width=0) (actual time=32.243..32.243 rows=19,482 loops=1)

  • Index Cond: (parent_id IS NULL)
23. 104.280 266.689 ↓ 2.0 2 1

Bitmap Heap Scan on social_interactions_201701 (cost=14.20..18.21 rows=1 width=13) (actual time=180.155..266.689 rows=2 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 32,103
  • Heap Blocks: exact=604
24. 0.031 162.409 ↓ 0.0 0 1

BitmapAnd (cost=14.20..14.20 rows=1 width=0) (actual time=162.409..162.409 rows=0 loops=1)

25. 56.288 56.288 ↓ 387.0 32,120 1

Bitmap Index Scan on social_activity_interactions_201701_parent_id_idx (cost=0.00..4.91 rows=83 width=0) (actual time=56.288..56.288 rows=32,120 loops=1)

  • Index Cond: (parent_id IS NULL)
26. 106.090 106.090 ↓ 386.8 32,107 1

Bitmap Index Scan on social_activity_interactions_201701_interaction_type_idx (cost=0.00..9.04 rows=83 width=0) (actual time=106.090..106.090 rows=32,107 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
27. 38.552 248.320 ↑ 1.0 1 1

Bitmap Heap Scan on social_interactions_201702 (cost=18.57..22.59 rows=1 width=13) (actual time=239.114..248.320 rows=1 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 42,113
  • Heap Blocks: exact=824
28. 0.040 209.768 ↓ 0.0 0 1

BitmapAnd (cost=18.57..18.57 rows=1 width=0) (actual time=209.768..209.768 rows=0 loops=1)

29. 71.227 71.227 ↓ 390.0 42,119 1

Bitmap Index Scan on social_activity_interactions_201702_parent_id_idx (cost=0.00..9.10 rows=108 width=0) (actual time=71.227..71.227 rows=42,119 loops=1)

  • Index Cond: (parent_id IS NULL)
30. 138.501 138.501 ↓ 390.0 42,115 1

Bitmap Index Scan on social_activity_interactions_201702_interaction_type_idx (cost=0.00..9.22 rows=108 width=0) (actual time=138.501..138.501 rows=42,115 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
31. 248.937 802.225 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201703 (cost=32.08..36.09 rows=1 width=13) (actual time=802.225..802.225 rows=0 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 78,059
  • Heap Blocks: exact=1,434
32. 0.062 553.288 ↓ 0.0 0 1

BitmapAnd (cost=32.08..32.08 rows=1 width=0) (actual time=553.288..553.288 rows=0 loops=1)

33. 134.836 134.836 ↓ 375.3 78,068 1

Bitmap Index Scan on social_activity_interactions_201703_parent_id_idx (cost=0.00..13.85 rows=208 width=0) (actual time=134.836..134.836 rows=78,068 loops=1)

  • Index Cond: (parent_id IS NULL)
34. 418.390 418.390 ↓ 375.3 78,059 1

Bitmap Index Scan on social_activity_interactions_201703_interaction_type_idx (cost=0.00..17.97 rows=208 width=0) (actual time=418.390..418.390 rows=78,059 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
35. 359.252 814.005 ↑ 1.0 1 1

Bitmap Heap Scan on social_interactions_201704 (cost=36.98..41.00 rows=1 width=13) (actual time=537.788..814.005 rows=1 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 96,838
  • Heap Blocks: exact=1,814
36. 0.073 454.753 ↓ 0.0 0 1

BitmapAnd (cost=36.98..36.98 rows=1 width=0) (actual time=454.753..454.753 rows=0 loops=1)

37. 153.312 153.312 ↓ 372.5 96,859 1

Bitmap Index Scan on social_activity_interactions_201704_parent_id_idx (cost=0.00..14.36 rows=260 width=0) (actual time=153.312..153.312 rows=96,859 loops=1)

  • Index Cond: (parent_id IS NULL)
38. 301.368 301.368 ↓ 372.5 96,846 1

Bitmap Index Scan on social_activity_interactions_201704_interaction_type_idx (cost=0.00..22.36 rows=260 width=0) (actual time=301.368..301.368 rows=96,846 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
39. 500.897 1,153.542 ↓ 8.0 8 1

Bitmap Heap Scan on social_interactions_201705 (cost=45.78..53.63 rows=1 width=13) (actual time=714.263..1,153.542 rows=8 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 122,846
  • Heap Blocks: exact=2,295
40. 1.620 652.645 ↓ 0.0 0 1

BitmapAnd (cost=45.78..45.78 rows=2 width=0) (actual time=652.645..652.645 rows=0 loops=1)

41. 219.212 219.212 ↓ 392.6 122,892 1

Bitmap Index Scan on social_activity_interactions_201705_parent_id_idx (cost=0.00..18.76 rows=313 width=0) (actual time=219.212..219.212 rows=122,892 loops=1)

  • Index Cond: (parent_id IS NULL)
42. 431.813 431.813 ↓ 392.5 122,859 1

Bitmap Index Scan on social_activity_interactions_201705_interaction_type_idx (cost=0.00..26.76 rows=313 width=0) (actual time=431.813..431.813 rows=122,859 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
43. 713.357 1,402.119 ↓ 7.0 7 1

Bitmap Heap Scan on social_interactions_201706 (cost=50.86..58.73 rows=1 width=13) (actual time=712.313..1,402.119 rows=7 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 136,143
  • Heap Blocks: exact=2,918
44. 0.109 688.762 ↓ 0.0 0 1

BitmapAnd (cost=50.86..50.86 rows=2 width=0) (actual time=688.762..688.762 rows=0 loops=1)

45. 232.349 232.349 ↓ 353.8 136,207 1

Bitmap Index Scan on social_activity_interactions_201706_parent_id_idx (cost=0.00..23.30 rows=385 width=0) (actual time=232.349..232.349 rows=136,207 loops=1)

  • Index Cond: (parent_id IS NULL)
46. 456.304 456.304 ↓ 353.7 136,159 1

Bitmap Index Scan on social_activity_interactions_201706_interaction_type_idx (cost=0.00..27.30 rows=385 width=0) (actual time=456.304..456.304 rows=136,159 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
47. 1,177.854 1,879.909 ↓ 3.0 3 1

Bitmap Heap Scan on social_interactions_201707 (cost=50.82..58.69 rows=1 width=13) (actual time=759.748..1,879.909 rows=3 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 136,014
  • Heap Blocks: exact=2,869
48. 0.109 702.055 ↓ 0.0 0 1

BitmapAnd (cost=50.82..50.82 rows=2 width=0) (actual time=702.055..702.055 rows=0 loops=1)

49. 233.837 233.837 ↓ 356.2 136,068 1

Bitmap Index Scan on social_activity_interactions_201707_parent_id_idx (cost=0.00..23.28 rows=382 width=0) (actual time=233.837..233.837 rows=136,068 loops=1)

  • Index Cond: (parent_id IS NULL)
50. 468.109 468.109 ↓ 356.1 136,022 1

Bitmap Index Scan on social_activity_interactions_201707_interaction_type_idx (cost=0.00..27.28 rows=382 width=0) (actual time=468.109..468.109 rows=136,022 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
51. 1,237.106 2,159.438 ↓ 686.0 686 1

Bitmap Heap Scan on social_interactions_201708 (cost=73.31..85.11 rows=1 width=13) (actual time=930.962..2,159.438 rows=686 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 180,552
  • Heap Blocks: exact=3,834
52. 0.156 922.332 ↓ 0.0 0 1

BitmapAnd (cost=73.31..73.31 rows=3 width=0) (actual time=922.332..922.332 rows=0 loops=1)

53. 336.579 336.579 ↓ 351.1 192,397 1

Bitmap Index Scan on social_activity_interactions_201708_parent_id_idx (cost=0.00..32.53 rows=548 width=0) (actual time=336.579..336.579 rows=192,397 loops=1)

  • Index Cond: (parent_id IS NULL)
54. 585.597 585.597 ↓ 330.7 181,246 1

Bitmap Index Scan on social_activity_interactions_201708_interaction_type_idx (cost=0.00..40.53 rows=548 width=0) (actual time=585.597..585.597 rows=181,246 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
55. 1,011.619 1,946.778 ↓ 148.0 148 1

Bitmap Heap Scan on social_interactions_201709 (cost=76.57..84.46 rows=1 width=13) (actual time=939.118..1,946.778 rows=148 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 188,497
  • Heap Blocks: exact=3,784
56. 0.149 935.159 ↓ 0.0 0 1

BitmapAnd (cost=76.57..76.57 rows=2 width=0) (actual time=935.158..935.159 rows=0 loops=1)

57. 307.472 307.472 ↓ 378.1 188,680 1

Bitmap Index Scan on social_activity_interactions_201709_parent_id_idx (cost=0.00..32.16 rows=499 width=0) (actual time=307.472..307.472 rows=188,680 loops=1)

  • Index Cond: (parent_id IS NULL)
58. 627.538 627.538 ↓ 378.1 188,675 1

Bitmap Index Scan on social_activity_interactions_201709_interaction_type_idx (cost=0.00..44.16 rows=499 width=0) (actual time=627.538..627.538 rows=188,675 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
59. 2,403.135 3,689.053 ↓ 157.0 157 1

Bitmap Heap Scan on social_interactions_201710 (cost=104.58..120.33 rows=1 width=13) (actual time=1,287.726..3,689.053 rows=157 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 258,441
  • Heap Blocks: exact=5,390
60. 0.299 1,285.918 ↓ 0.0 0 1

BitmapAnd (cost=104.58..104.58 rows=4 width=0) (actual time=1,285.918..1,285.918 rows=0 loops=1)

61. 428.589 428.589 ↓ 337.8 258,726 1

Bitmap Index Scan on social_activity_interactions_201710_parent_id_idx (cost=0.00..46.16 rows=766 width=0) (actual time=428.589..428.589 rows=258,726 loops=1)

  • Index Cond: (parent_id IS NULL)
62. 857.030 857.030 ↓ 337.6 258,619 1

Bitmap Index Scan on social_activity_interactions_201710_interaction_type_idx (cost=0.00..58.16 rows=766 width=0) (actual time=857.030..857.030 rows=258,619 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
63. 1,877.850 3,618.088 ↓ 284.0 284 1

Bitmap Heap Scan on social_interactions_201711 (cost=129.92..145.68 rows=1 width=13) (actual time=1,747.945..3,618.088 rows=284 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 333,723
  • Heap Blocks: exact=6,553
64. 0.211 1,740.238 ↓ 0.0 0 1

BitmapAnd (cost=129.92..129.92 rows=4 width=0) (actual time=1,740.238..1,740.238 rows=0 loops=1)

65. 581.252 581.252 ↓ 391.4 334,684 1

Bitmap Index Scan on social_activity_interactions_201711_parent_id_idx (cost=0.00..54.83 rows=855 width=0) (actual time=581.252..581.252 rows=334,684 loops=1)

  • Index Cond: (parent_id IS NULL)
66. 1,158.775 1,158.775 ↓ 390.7 334,036 1

Bitmap Index Scan on social_activity_interactions_201711_interaction_type_idx (cost=0.00..74.83 rows=855 width=0) (actual time=1,158.775..1,158.775 rows=334,036 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
67. 3,122.286 5,265.612 ↓ 223.0 223 1

Bitmap Heap Scan on social_interactions_201712 (cost=165.80..189.41 rows=1 width=13) (actual time=2,158.165..5,265.612 rows=223 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 429,062
  • Heap Blocks: exact=8,392
68. 0.312 2,143.326 ↓ 0.0 0 1

BitmapAnd (cost=165.80..165.80 rows=6 width=0) (actual time=2,143.326..2,143.326 rows=0 loops=1)

69. 720.933 720.933 ↓ 385.5 429,441 1

Bitmap Index Scan on social_activity_interactions_201712_parent_id_idx (cost=0.00..68.78 rows=1,114 width=0) (actual time=720.933..720.933 rows=429,441 loops=1)

  • Index Cond: (parent_id IS NULL)
70. 1,422.081 1,422.081 ↓ 385.4 429,324 1

Bitmap Index Scan on social_activity_interactions_201712_interaction_type_idx (cost=0.00..96.78 rows=1,114 width=0) (actual time=1,422.081..1,422.081 rows=429,324 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
71. 3,969.976 6,421.295 ↓ 271.0 271 1

Bitmap Heap Scan on social_interactions_201801 (cost=181.38..208.94 rows=1 width=13) (actual time=2,483.787..6,421.295 rows=271 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 464,974
  • Heap Blocks: exact=9,541
72. 0.348 2,451.319 ↓ 0.0 0 1

BitmapAnd (cost=181.38..181.38 rows=7 width=0) (actual time=2,451.319..2,451.319 rows=0 loops=1)

73. 786.405 786.405 ↓ 352.6 476,679 1

Bitmap Index Scan on social_activity_interactions_201801_parent_id_idx (cost=0.00..78.56 rows=1,352 width=0) (actual time=786.405..786.405 rows=476,679 loops=1)

  • Index Cond: (parent_id IS NULL)
74. 1,664.566 1,664.566 ↓ 344.2 465,292 1

Bitmap Index Scan on social_activity_interactions_201801_interaction_type_idx (cost=0.00..102.56 rows=1,352 width=0) (actual time=1,664.566..1,664.566 rows=465,292 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
75. 5,530.993 8,893.285 ↓ 279.0 279 1

Bitmap Heap Scan on social_interactions_201802 (cost=244.93..288.23 rows=1 width=13) (actual time=3,365.066..8,893.285 rows=279 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 614,868
  • Heap Blocks: exact=13,238
76. 0.448 3,362.292 ↓ 0.0 0 1

BitmapAnd (cost=244.93..244.93 rows=11 width=0) (actual time=3,362.291..3,362.292 rows=0 loops=1)

77. 1,263.861 1,263.861 ↓ 290.0 615,326 1

Bitmap Index Scan on social_activity_interactions_201802_parent_id_idx (cost=0.00..104.34 rows=2,122 width=0) (actual time=1,263.860..1,263.861 rows=615,326 loops=1)

  • Index Cond: (parent_id IS NULL)
78. 2,097.983 2,097.983 ↓ 289.9 615,200 1

Bitmap Index Scan on social_activity_interactions_201802_interaction_type_idx (cost=0.00..140.34 rows=2,122 width=0) (actual time=2,097.983..2,097.983 rows=615,200 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
79. 5,735.061 9,249.801 ↓ 439.0 439 1

Bitmap Heap Scan on social_interactions_201803 (cost=264.62..311.87 rows=1 width=13) (actual time=3,517.440..9,249.801 rows=439 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 660,387
  • Heap Blocks: exact=14,095
80. 0.550 3,514.740 ↓ 0.0 0 1

BitmapAnd (cost=264.62..264.62 rows=12 width=0) (actual time=3,514.740..3,514.740 rows=0 loops=1)

81. 1,142.583 1,142.583 ↓ 279.1 661,005 1

Bitmap Index Scan on social_activity_interactions_201803_parent_id_idx (cost=0.00..114.18 rows=2,368 width=0) (actual time=1,142.583..1,142.583 rows=661,005 loops=1)

  • Index Cond: (parent_id IS NULL)
82. 2,371.607 2,371.607 ↓ 279.1 660,882 1

Bitmap Index Scan on social_activity_interactions_201803_interaction_type_idx (cost=0.00..150.18 rows=2,368 width=0) (actual time=2,371.607..2,371.607 rows=660,882 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
83. 7,568.618 11,278.034 ↓ 438.0 438 1

Bitmap Heap Scan on social_interactions_201804 (cost=299.45..354.59 rows=1 width=13) (actual time=3,713.143..11,278.034 rows=438 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 749,720
  • Heap Blocks: exact=16,428
84. 0.602 3,709.416 ↓ 0.0 0 1

BitmapAnd (cost=299.45..299.45 rows=14 width=0) (actual time=3,709.416..3,709.416 rows=0 loops=1)

85. 1,185.094 1,185.094 ↓ 265.8 750,355 1

Bitmap Index Scan on social_activity_interactions_201804_parent_id_idx (cost=0.00..129.60 rows=2,823 width=0) (actual time=1,185.094..1,185.094 rows=750,355 loops=1)

  • Index Cond: (parent_id IS NULL)
86. 2,523.720 2,523.720 ↓ 265.8 750,215 1

Bitmap Index Scan on social_activity_interactions_201804_interaction_type_idx (cost=0.00..169.60 rows=2,823 width=0) (actual time=2,523.720..2,523.720 rows=750,215 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
87. 9,145.960 14,055.343 ↓ 471.0 471 1

Bitmap Heap Scan on social_interactions_201805 (cost=388.54..459.45 rows=1 width=13) (actual time=4,914.306..14,055.343 rows=471 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 975,053
  • Heap Blocks: exact=20,782
88. 0.724 4,909.383 ↓ 0.0 0 1

BitmapAnd (cost=388.54..388.54 rows=18 width=0) (actual time=4,909.382..4,909.383 rows=0 loops=1)

89. 1,703.409 1,703.409 ↓ 264.0 975,768 1

Bitmap Index Scan on social_activity_interactions_201805_parent_id_idx (cost=0.00..164.15 rows=3,696 width=0) (actual time=1,703.409..1,703.409 rows=975,768 loops=1)

  • Index Cond: (parent_id IS NULL)
90. 3,205.250 3,205.250 ↓ 264.0 975,606 1

Bitmap Index Scan on social_activity_interactions_201805_interaction_type_idx (cost=0.00..224.15 rows=3,696 width=0) (actual time=3,205.250..3,205.250 rows=975,606 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
91. 8,643.383 13,105.159 ↓ 551.0 551 1

Bitmap Heap Scan on social_interactions_201806 (cost=351.41..418.36 rows=1 width=13) (actual time=4,467.005..13,105.159 rows=551 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 878,770
  • Heap Blocks: exact=18,339
92. 1.643 4,461.776 ↓ 0.0 0 1

BitmapAnd (cost=351.41..351.41 rows=17 width=0) (actual time=4,461.776..4,461.776 rows=0 loops=1)

93. 1,504.073 1,504.073 ↓ 262.3 879,658 1

Bitmap Index Scan on social_activity_interactions_201806_parent_id_idx (cost=0.00..149.58 rows=3,354 width=0) (actual time=1,504.073..1,504.073 rows=879,658 loops=1)

  • Index Cond: (parent_id IS NULL)
94. 2,956.060 2,956.060 ↓ 262.2 879,418 1

Bitmap Index Scan on social_activity_interactions_201806_interaction_type_idx (cost=0.00..201.58 rows=3,354 width=0) (actual time=2,956.060..2,956.060 rows=879,418 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
95. 7,634.459 12,574.967 ↓ 640.0 640 1

Bitmap Heap Scan on social_interactions_201807 (cost=396.17..474.93 rows=1 width=13) (actual time=4,956.430..12,574.967 rows=640 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 988,673
  • Heap Blocks: exact=17,254
96. 0.621 4,940.508 ↓ 0.0 0 1

BitmapAnd (cost=396.17..396.17 rows=20 width=0) (actual time=4,940.508..4,940.508 rows=0 loops=1)

97. 1,613.109 1,613.109 ↓ 251.3 989,779 1

Bitmap Index Scan on social_activity_interactions_201807_parent_id_idx (cost=0.00..169.96 rows=3,938 width=0) (actual time=1,613.109..1,613.109 rows=989,779 loops=1)

  • Index Cond: (parent_id IS NULL)
98. 3,326.778 3,326.778 ↓ 251.2 989,421 1

Bitmap Index Scan on social_activity_interactions_201807_interaction_type_idx (cost=0.00..225.96 rows=3,938 width=0) (actual time=3,326.778..3,326.778 rows=989,421 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
99. 9,715.828 15,705.214 ↓ 374.0 374 1

Bitmap Heap Scan on social_interactions_201808 (cost=466.04..556.63 rows=1 width=13) (actual time=5,993.861..15,705.214 rows=374 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 1,171,288
  • Heap Blocks: exact=21,784
100. 0.799 5,989.386 ↓ 0.0 0 1

BitmapAnd (cost=466.04..466.04 rows=23 width=0) (actual time=5,989.386..5,989.386 rows=0 loops=1)

101. 1,989.012 1,989.012 ↓ 254.9 1,171,662 1

Bitmap Index Scan on social_activity_interactions_201808_parent_id_idx (cost=0.00..198.90 rows=4,596 width=0) (actual time=1,989.012..1,989.012 rows=1,171,662 loops=1)

  • Index Cond: (parent_id IS NULL)
102. 3,999.575 3,999.575 ↓ 254.9 1,171,732 1

Bitmap Index Scan on social_activity_interactions_201808_interaction_type_idx (cost=0.00..266.90 rows=4,596 width=0) (actual time=3,999.575..3,999.575 rows=1,171,732 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
103. 10,161.419 15,336.145 ↓ 395.0 395 1

Bitmap Heap Scan on social_interactions_201809 (cost=397.05..471.87 rows=1 width=13) (actual time=5,178.631..15,336.145 rows=395 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 1,001,347
  • Heap Blocks: exact=22,439
104. 0.739 5,174.726 ↓ 0.0 0 1

BitmapAnd (cost=397.05..397.05 rows=19 width=0) (actual time=5,174.726..5,174.726 rows=0 loops=1)

105. 1,614.507 1,614.507 ↓ 268.6 1,001,742 1

Bitmap Index Scan on social_activity_interactions_201809_parent_id_idx (cost=0.00..168.40 rows=3,730 width=0) (actual time=1,614.507..1,614.507 rows=1,001,742 loops=1)

  • Index Cond: (parent_id IS NULL)
106. 3,559.480 3,559.480 ↓ 268.6 1,001,814 1

Bitmap Index Scan on social_activity_interactions_201809_interaction_type_idx (cost=0.00..228.40 rows=3,730 width=0) (actual time=3,559.480..3,559.480 rows=1,001,814 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
107. 10,587.188 16,155.177 ↓ 710.0 710 1

Bitmap Heap Scan on social_interactions_201810 (cost=430.15..508.93 rows=1 width=13) (actual time=5,572.986..16,155.177 rows=710 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 1,081,465
  • Heap Blocks: exact=23,826
108. 0.836 5,567.989 ↓ 0.0 0 1

BitmapAnd (cost=430.15..430.15 rows=20 width=0) (actual time=5,567.989..5,567.989 rows=0 loops=1)

109. 1,798.440 1,798.440 ↓ 265.9 1,082,175 1

Bitmap Index Scan on social_activity_interactions_201810_parent_id_idx (cost=0.00..182.95 rows=4,070 width=0) (actual time=1,798.440..1,798.440 rows=1,082,175 loops=1)

  • Index Cond: (parent_id IS NULL)
110. 3,768.713 3,768.713 ↓ 265.9 1,082,406 1

Bitmap Index Scan on social_activity_interactions_201810_interaction_type_idx (cost=0.00..246.95 rows=4,070 width=0) (actual time=3,768.713..3,768.713 rows=1,082,406 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
111. 5,536.358 8,814.109 ↓ 1,176.0 1,176 1

Bitmap Heap Scan on social_interactions_201811 (cost=238.79..282.12 rows=1 width=13) (actual time=3,292.509..8,814.109 rows=1,176 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 586,946
  • Heap Blocks: exact=12,526
112. 0.408 3,277.751 ↓ 0.0 0 1

BitmapAnd (cost=238.79..238.79 rows=11 width=0) (actual time=3,277.751..3,277.751 rows=0 loops=1)

113. 1,024.776 1,024.776 ↓ 261.9 588,122 1

Bitmap Index Scan on social_activity_interactions_201811_parent_id_idx (cost=0.00..101.27 rows=2,246 width=0) (actual time=1,024.776..1,024.776 rows=588,122 loops=1)

  • Index Cond: (parent_id IS NULL)
114. 2,252.567 2,252.567 ↓ 262.0 588,392 1

Bitmap Index Scan on social_activity_interactions_201811_interaction_type_idx (cost=0.00..137.27 rows=2,246 width=0) (actual time=2,252.567..2,252.567 rows=588,392 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
115. 5,827.595 8,799.328 ↓ 1,554.0 1,554 1

Bitmap Heap Scan on social_interactions_201812 (cost=239.40..282.74 rows=1 width=13) (actual time=2,994.711..8,799.328 rows=1,554 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 597,194
  • Heap Blocks: exact=12,951
116. 0.655 2,971.733 ↓ 0.0 0 1

BitmapAnd (cost=239.40..239.40 rows=11 width=0) (actual time=2,971.733..2,971.733 rows=0 loops=1)

117. 976.558 976.558 ↓ 261.8 598,748 1

Bitmap Index Scan on social_activity_interactions_201812_parent_id_idx (cost=0.00..101.58 rows=2,287 width=0) (actual time=976.558..976.558 rows=598,748 loops=1)

  • Index Cond: (parent_id IS NULL)
118. 1,994.520 1,994.520 ↓ 262.0 599,086 1

Bitmap Index Scan on social_activity_interactions_201812_interaction_type_idx (cost=0.00..137.58 rows=2,287 width=0) (actual time=1,994.520..1,994.520 rows=599,086 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
119. 5,410.998 8,211.249 ↓ 1,229.0 1,229 1

Bitmap Heap Scan on social_interactions_201901 (cost=229.87..273.19 rows=1 width=13) (actual time=2,886.914..8,211.249 rows=1,229 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 568,868
  • Heap Blocks: exact=12,359
120. 0.392 2,800.251 ↓ 0.0 0 1

BitmapAnd (cost=229.87..229.87 rows=11 width=0) (actual time=2,800.251..2,800.251 rows=0 loops=1)

121. 940.901 940.901 ↓ 260.9 570,097 1

Bitmap Index Scan on social_activity_interactions_201901_parent_id_idx (cost=0.00..96.81 rows=2,185 width=0) (actual time=940.901..940.901 rows=570,097 loops=1)

  • Index Cond: (parent_id IS NULL)
122. 1,858.958 1,858.958 ↓ 261.1 570,495 1

Bitmap Index Scan on social_activity_interactions_201901_interaction_type_idx (cost=0.00..132.81 rows=2,185 width=0) (actual time=1,858.958..1,858.958 rows=570,495 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
123. 5,274.019 7,993.765 ↓ 1,025.0 1,025 1

Bitmap Heap Scan on social_interactions_201902 (cost=215.37..254.75 rows=1 width=13) (actual time=2,727.809..7,993.765 rows=1,025 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 531,729
  • Heap Blocks: exact=11,905
124. 0.409 2,719.746 ↓ 0.0 0 1

BitmapAnd (cost=215.37..215.37 rows=10 width=0) (actual time=2,719.746..2,719.746 rows=0 loops=1)

125. 879.756 879.756 ↓ 264.0 532,755 1

Bitmap Index Scan on social_activity_interactions_201902_parent_id_idx (cost=0.00..91.56 rows=2,018 width=0) (actual time=879.756..879.756 rows=532,755 loops=1)

  • Index Cond: (parent_id IS NULL)
126. 1,839.581 1,839.581 ↓ 264.1 533,035 1

Bitmap Index Scan on social_activity_interactions_201902_interaction_type_idx (cost=0.00..123.56 rows=2,018 width=0) (actual time=1,839.581..1,839.581 rows=533,035 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
127. 5,810.014 9,073.891 ↓ 1,109.0 1,109 1

Bitmap Heap Scan on social_interactions_201903 (cost=239.00..282.33 rows=1 width=13) (actual time=3,287.090..9,073.891 rows=1,109 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 596,654
  • Heap Blocks: exact=13,519
128. 0.479 3,263.877 ↓ 0.0 0 1

BitmapAnd (cost=239.00..239.00 rows=11 width=0) (actual time=3,263.877..3,263.877 rows=0 loops=1)

129. 990.524 990.524 ↓ 264.5 597,766 1

Bitmap Index Scan on social_activity_interactions_201903_parent_id_idx (cost=0.00..101.37 rows=2,260 width=0) (actual time=990.524..990.524 rows=597,766 loops=1)

  • Index Cond: (parent_id IS NULL)
130. 2,272.874 2,272.874 ↓ 264.6 598,097 1

Bitmap Index Scan on social_activity_interactions_201903_interaction_type_idx (cost=0.00..137.37 rows=2,260 width=0) (actual time=2,272.874..2,272.874 rows=598,097 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
131. 6,480.994 9,599.468 ↓ 1,162.0 1,162 1

Bitmap Heap Scan on social_interactions_201904 (cost=257.74..305.01 rows=1 width=13) (actual time=3,159.480..9,599.468 rows=1,162 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 643,273
  • Heap Blocks: exact=14,488
132. 0.651 3,118.474 ↓ 0.0 0 1

BitmapAnd (cost=257.74..257.74 rows=12 width=0) (actual time=3,118.474..3,118.474 rows=0 loops=1)

133. 1,024.093 1,024.093 ↓ 263.8 644,437 1

Bitmap Index Scan on social_activity_interactions_201904_parent_id_idx (cost=0.00..110.74 rows=2,443 width=0) (actual time=1,024.093..1,024.093 rows=644,437 loops=1)

  • Index Cond: (parent_id IS NULL)
134. 2,093.730 2,093.730 ↓ 263.9 644,789 1

Bitmap Index Scan on social_activity_interactions_201904_interaction_type_idx (cost=0.00..146.75 rows=2,443 width=0) (actual time=2,093.730..2,093.730 rows=644,789 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
135. 6,954.590 10,458.116 ↓ 1,084.0 1,084 1

Bitmap Heap Scan on social_interactions_201905 (cost=275.96..327.16 rows=1 width=13) (actual time=3,543.926..10,458.116 rows=1,084 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 687,514
  • Heap Blocks: exact=15,756
136. 0.596 3,503.526 ↓ 0.0 0 1

BitmapAnd (cost=275.96..275.96 rows=13 width=0) (actual time=3,503.526..3,503.526 rows=0 loops=1)

137. 1,152.119 1,152.119 ↓ 265.8 688,598 1

Bitmap Index Scan on social_activity_interactions_201905_parent_id_idx (cost=0.00..119.86 rows=2,591 width=0) (actual time=1,152.119..1,152.119 rows=688,598 loops=1)

  • Index Cond: (parent_id IS NULL)
138. 2,350.811 2,350.811 ↓ 265.9 688,897 1

Bitmap Index Scan on social_activity_interactions_201905_interaction_type_idx (cost=0.00..155.86 rows=2,591 width=0) (actual time=2,350.811..2,350.811 rows=688,897 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
139. 7,128.562 10,471.078 ↓ 1,045.0 1,045 1

Bitmap Heap Scan on social_interactions_201906 (cost=265.43..312.69 rows=1 width=13) (actual time=3,347.109..10,471.078 rows=1,045 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 657,243
  • Heap Blocks: exact=15,783
140. 0.593 3,342.516 ↓ 0.0 0 1

BitmapAnd (cost=265.43..265.43 rows=12 width=0) (actual time=3,342.516..3,342.516 rows=0 loops=1)

141. 1,069.254 1,069.254 ↓ 271.8 658,289 1

Bitmap Index Scan on social_activity_interactions_201906_parent_id_idx (cost=0.00..114.59 rows=2,422 width=0) (actual time=1,069.254..1,069.254 rows=658,289 loops=1)

  • Index Cond: (parent_id IS NULL)
142. 2,272.669 2,272.669 ↓ 271.9 658,593 1

Bitmap Index Scan on social_activity_interactions_201906_interaction_type_idx (cost=0.00..150.59 rows=2,422 width=0) (actual time=2,272.669..2,272.669 rows=658,593 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
143. 7,277.066 10,706.550 ↓ 1,204.0 1,204 1

Bitmap Heap Scan on social_interactions_201907 (cost=271.38..322.57 rows=1 width=13) (actual time=3,448.841..10,706.550 rows=1,204 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 681,463
  • Heap Blocks: exact=16,861
144. 0.613 3,429.484 ↓ 0.0 0 1

BitmapAnd (cost=271.38..271.38 rows=13 width=0) (actual time=3,429.484..3,429.484 rows=0 loops=1)

145. 1,086.675 1,086.675 ↓ 267.5 682,667 1

Bitmap Index Scan on social_activity_interactions_201907_parent_id_idx (cost=0.00..115.56 rows=2,552 width=0) (actual time=1,086.675..1,086.675 rows=682,667 loops=1)

  • Index Cond: (parent_id IS NULL)
146. 2,342.196 2,342.196 ↓ 267.6 683,026 1

Bitmap Index Scan on social_activity_interactions_201907_interaction_type_idx (cost=0.00..155.56 rows=2,552 width=0) (actual time=2,342.196..2,342.196 rows=683,026 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
147. 7,442.149 10,824.804 ↓ 903.0 903 1

Bitmap Heap Scan on social_interactions_201908 (cost=279.32..330.51 rows=1 width=13) (actual time=3,387.249..10,824.804 rows=903 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 687,367
  • Heap Blocks: exact=17,275
148. 0.622 3,382.655 ↓ 0.0 0 1

BitmapAnd (cost=279.32..279.32 rows=13 width=0) (actual time=3,382.655..3,382.655 rows=0 loops=1)

149. 1,177.229 1,177.229 ↓ 270.1 688,270 1

Bitmap Index Scan on social_activity_interactions_201908_parent_id_idx (cost=0.00..119.53 rows=2,548 width=0) (actual time=1,177.229..1,177.229 rows=688,270 loops=1)

  • Index Cond: (parent_id IS NULL)
150. 2,204.804 2,204.804 ↓ 270.2 688,555 1

Bitmap Index Scan on social_activity_interactions_201908_interaction_type_idx (cost=0.00..159.53 rows=2,548 width=0) (actual time=2,204.804..2,204.804 rows=688,555 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
151. 7,519.673 11,187.198 ↓ 1,124.0 1,124 1

Bitmap Heap Scan on social_interactions_201909 (cost=304.32..359.47 rows=1 width=13) (actual time=3,671.493..11,187.198 rows=1,124 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 749,082
  • Heap Blocks: exact=17,238
152. 0.851 3,667.525 ↓ 0.0 0 1

BitmapAnd (cost=304.32..304.32 rows=14 width=0) (actual time=3,667.525..3,667.525 rows=0 loops=1)

153. 1,224.517 1,224.517 ↓ 260.4 750,228 1

Bitmap Index Scan on social_activity_interactions_201909_parent_id_idx (cost=0.00..130.03 rows=2,881 width=0) (actual time=1,224.517..1,224.517 rows=750,228 loops=1)

  • Index Cond: (parent_id IS NULL)
154. 2,442.157 2,442.157 ↓ 260.5 750,568 1

Bitmap Index Scan on social_activity_interactions_201909_interaction_type_idx (cost=0.00..174.03 rows=2,881 width=0) (actual time=2,442.157..2,442.157 rows=750,568 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
155. 7,863.060 11,706.465 ↓ 1,055.0 1,055 1

Bitmap Heap Scan on social_interactions_201910 (cost=303.60..358.74 rows=1 width=13) (actual time=3,851.457..11,706.465 rows=1,055 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 746,237
  • Heap Blocks: exact=18,060
156. 0.648 3,843.405 ↓ 0.0 0 1

BitmapAnd (cost=303.60..303.60 rows=14 width=0) (actual time=3,843.405..3,843.405 rows=0 loops=1)

157. 1,230.417 1,230.417 ↓ 263.8 747,333 1

Bitmap Index Scan on social_activity_interactions_201910_parent_id_idx (cost=0.00..129.67 rows=2,833 width=0) (actual time=1,230.417..1,230.417 rows=747,333 loops=1)

  • Index Cond: (parent_id IS NULL)
158. 2,612.340 2,612.340 ↓ 263.9 747,680 1

Bitmap Index Scan on social_activity_interactions_201910_interaction_type_idx (cost=0.00..173.67 rows=2,833 width=0) (actual time=2,612.340..2,612.340 rows=747,680 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
159. 12,390.434 16,372.364 ↓ 1,152.0 1,152 1

Bitmap Heap Scan on social_interactions_201911 (cost=308.38..379.28 rows=1 width=13) (actual time=4,011.721..16,372.364 rows=1,152 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 738,228
  • Heap Blocks: exact=26,202
160. 1.309 3,981.930 ↓ 0.0 0 1

BitmapAnd (cost=308.38..308.38 rows=18 width=0) (actual time=3,981.930..3,981.930 rows=0 loops=1)

161. 1,362.694 1,362.694 ↓ 200.7 739,401 1

Bitmap Index Scan on social_activity_interactions_201911_parent_id_idx (cost=0.00..132.06 rows=3,685 width=0) (actual time=1,362.694..1,362.694 rows=739,401 loops=1)

  • Index Cond: (parent_id IS NULL)
162. 2,617.927 2,617.927 ↓ 200.8 739,811 1

Bitmap Index Scan on social_activity_interactions_201911_interaction_type_idx (cost=0.00..176.06 rows=3,685 width=0) (actual time=2,617.927..2,617.927 rows=739,811 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
163. 11,800.493 14,380.692 ↓ 1,464.0 1,464 1

Bitmap Heap Scan on social_interactions_201912 (cost=322.25..397.08 rows=1 width=13) (actual time=2,585.333..14,380.692 rows=1,464 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 773,747
  • Heap Blocks: exact=26,043
164. 0.991 2,580.199 ↓ 0.0 0 1

BitmapAnd (cost=322.25..322.25 rows=19 width=0) (actual time=2,580.199..2,580.199 rows=0 loops=1)

165. 51.159 51.159 ↓ 203.5 775,256 1

Bitmap Index Scan on social_activity_interactions_201912_parent_id_idx (cost=0.00..137.00 rows=3,810 width=0) (actual time=51.159..51.159 rows=775,256 loops=1)

  • Index Cond: (parent_id IS NULL)
166. 2,528.049 2,528.049 ↓ 203.6 775,694 1

Bitmap Index Scan on social_activity_interactions_201912_interaction_type_idx (cost=0.00..185.00 rows=3,810 width=0) (actual time=2,528.049..2,528.049 rows=775,694 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
167. 12,225.101 15,009.474 ↓ 1,600.0 1,600 1

Bitmap Heap Scan on social_interactions_202001 (cost=327.39..402.24 rows=1 width=13) (actual time=2,788.995..15,009.474 rows=1,600 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 782,912
  • Heap Blocks: exact=27,037
168. 0.947 2,784.373 ↓ 0.0 0 1

BitmapAnd (cost=327.39..327.39 rows=19 width=0) (actual time=2,784.373..2,784.373 rows=0 loops=1)

169. 88.466 88.466 ↓ 201.9 784,673 1

Bitmap Index Scan on social_activity_interactions_202001_parent_id_idx (cost=0.00..141.57 rows=3,886 width=0) (actual time=88.466..88.466 rows=784,673 loops=1)

  • Index Cond: (parent_id IS NULL)
170. 2,694.960 2,694.960 ↓ 202.0 785,132 1

Bitmap Index Scan on social_activity_interactions_202001_interaction_type_idx (cost=0.00..185.57 rows=3,886 width=0) (actual time=2,694.960..2,694.960 rows=785,132 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
171. 12,519.105 15,077.756 ↓ 1,706.0 1,706 1

Bitmap Heap Scan on social_interactions_202002 (cost=336.95..415.72 rows=1 width=13) (actual time=2,562.936..15,077.756 rows=1,706 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 810,164
  • Heap Blocks: exact=27,037
172. 0.962 2,558.651 ↓ 0.0 0 1

BitmapAnd (cost=336.95..336.95 rows=20 width=0) (actual time=2,558.651..2,558.651 rows=0 loops=1)

173. 47.775 47.775 ↓ 203.5 812,088 1

Bitmap Index Scan on social_activity_interactions_202002_parent_id_idx (cost=0.00..146.35 rows=3,990 width=0) (actual time=47.775..47.775 rows=812,088 loops=1)

  • Index Cond: (parent_id IS NULL)
174. 2,509.914 2,509.914 ↓ 203.7 812,659 1

Bitmap Index Scan on social_activity_interactions_202002_interaction_type_idx (cost=0.00..190.35 rows=3,990 width=0) (actual time=2,509.914..2,509.914 rows=812,659 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
175. 9,179.488 11,153.001 ↓ 1,103.0 1,103 1

Bitmap Heap Scan on social_interactions_202003 (cost=246.03..305.10 rows=1 width=13) (actual time=1,977.619..11,153.001 rows=1,103 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 586,594
  • Heap Blocks: exact=20,793
176. 0.802 1,973.513 ↓ 0.0 0 1

BitmapAnd (cost=246.03..246.03 rows=15 width=0) (actual time=1,973.513..1,973.513 rows=0 loops=1)

177. 44.807 44.807 ↓ 196.3 587,940 1

Bitmap Index Scan on social_activity_interactions_202003_parent_id_idx (cost=0.00..106.89 rows=2,995 width=0) (actual time=44.807..44.807 rows=587,940 loops=1)

  • Index Cond: (parent_id IS NULL)
178. 1,927.904 1,927.904 ↓ 196.4 588,281 1

Bitmap Index Scan on social_activity_interactions_202003_interaction_type_idx (cost=0.00..138.89 rows=2,995 width=0) (actual time=1,927.904..1,927.904 rows=588,281 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
179. 2,844.263 5,454.918 ↓ 1,315.0 1,315 1

Bitmap Heap Scan on social_interactions_202004 (cost=208.12..255.37 rows=1 width=13) (actual time=2,615.729..5,454.918 rows=1,315 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 683,962
  • Heap Blocks: exact=17,482
180. 0.700 2,610.655 ↓ 0.0 0 1

BitmapAnd (cost=208.12..208.12 rows=12 width=0) (actual time=2,610.655..2,610.655 rows=0 loops=1)

181. 102.133 102.133 ↓ 314.1 733,456 1

Bitmap Index Scan on social_activity_interactions_202004_parent_id_idx (cost=0.00..77.94 rows=2,335 width=0) (actual time=102.133..102.133 rows=733,456 loops=1)

  • Index Cond: (parent_id IS NULL)
182. 2,507.822 2,507.822 ↓ 294.2 686,925 1

Bitmap Index Scan on social_activity_interactions_202004_interaction_type_idx (cost=0.00..129.94 rows=2,335 width=0) (actual time=2,507.822..2,507.822 rows=686,925 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
183. 9,235.546 12,466.982 ↓ 1,455.0 1,455 1

Bitmap Heap Scan on social_interactions_202005 (cost=191.91..247.06 rows=1 width=13) (actual time=3,255.381..12,466.982 rows=1,455 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 616,030
  • Heap Blocks: exact=21,764
184. 0.740 3,231.436 ↓ 0.0 0 1

BitmapAnd (cost=191.91..191.91 rows=14 width=0) (actual time=3,231.436..3,231.436 rows=0 loops=1)

185. 1,099.804 1,099.804 ↓ 235.3 671,668 1

Bitmap Index Scan on social_activity_interactions_202005_parent_id_idx (cost=0.00..69.83 rows=2,854 width=0) (actual time=1,099.804..1,099.804 rows=671,668 loops=1)

  • Index Cond: (parent_id IS NULL)
186. 2,130.892 2,130.892 ↓ 216.9 618,963 1

Bitmap Index Scan on social_activity_interactions_202005_interaction_type_idx (cost=0.00..121.83 rows=2,854 width=0) (actual time=2,130.892..2,130.892 rows=618,963 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
187. 4,286.606 6,613.696 ↓ 935.0 935 1

Bitmap Heap Scan on social_interactions_202006 (cost=129.20..156.75 rows=1 width=13) (actual time=2,329.858..6,613.696 rows=935 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 420,908
  • Heap Blocks: exact=10,232
188. 0.487 2,327.090 ↓ 0.0 0 1

BitmapAnd (cost=129.20..129.20 rows=7 width=0) (actual time=2,327.090..2,327.090 rows=0 loops=1)

189. 798.497 798.497 ↓ 322.6 432,306 1

Bitmap Index Scan on social_interactions_202006_parent_id_idx (cost=0.00..46.47 rows=1,340 width=0) (actual time=798.497..798.497 rows=432,306 loops=1)

  • Index Cond: (parent_id IS NULL)
190. 1,528.106 1,528.106 ↓ 315.1 422,259 1

Bitmap Index Scan on social_interactions_202006_interaction_type_idx (cost=0.00..82.47 rows=1,340 width=0) (actual time=1,528.106..1,528.106 rows=422,259 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
191. 219.551 945.193 ↓ 597.0 597 1

Bitmap Heap Scan on social_interactions_202007 (cost=97.95..113.71 rows=1 width=13) (actual time=732.403..945.193 rows=597 loops=1)

  • Recheck Cond: ((parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 329,099
  • Heap Blocks: exact=6,574
192. 1.518 725.642 ↓ 0.0 0 1

BitmapAnd (cost=97.95..97.95 rows=4 width=0) (actual time=725.642..725.642 rows=0 loops=1)

193. 650.870 650.870 ↓ 431.6 369,919 1

Bitmap Index Scan on social_interactions_202007_parent_id_idx (cost=0.00..34.85 rows=857 width=0) (actual time=650.870..650.870 rows=369,919 loops=1)

  • Index Cond: (parent_id IS NULL)
194. 73.254 73.254 ↓ 385.2 330,113 1

Bitmap Index Scan on social_interactions_202007_interaction_type_idx (cost=0.00..62.85 rows=857 width=0) (actual time=73.254..73.254 rows=330,113 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
195. 2.087 2.087 ↓ 0.0 0 1

Index Scan using social_interactions_202008_interaction_type_idx on social_interactions_202008 (cost=0.15..8.17 rows=1 width=13) (actual time=2.087..2.087 rows=0 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND ((action_type)::text = 'comment'::text))
196. 10,321.216 10,321.216 ↓ 0.0 0 31,088

Index Scan using social_activities_pkey on social_activities (cost=0.43..8.46 rows=1 width=390) (actual time=0.332..0.332 rows=0 loops=31,088)

  • Index Cond: (id = social_interactions_201609.social_activity_id)
  • Filter: ((user_id = 4,158) AND ((social_network)::text = 'facebook'::text) AND ((processing_status)::text = 'sent'::text))
  • Rows Removed by Filter: 1
Planning time : 112.463 ms
Execution time : 372,144.951 ms