explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d1aY : Optimization for: plan #oi1K

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 374,112.709 ↑ 1.0 1 1

Limit (cost=11,817.65..11,817.66 rows=1 width=406) (actual time=374,112.708..374,112.709 rows=1 loops=1)

2. 1.210 374,112.706 ↑ 1.0 1 1

Sort (cost=11,817.65..11,817.66 rows=1 width=406) (actual time=374,112.706..374,112.706 rows=1 loops=1)

  • Sort Key: (sum(CASE WHEN social_interactions_201609.seen THEN 0 ELSE 1 END)) DESC, (max(social_interactions_201609.action_date)) DESC
  • Sort Method: quicksort Memory: 25kB
3. 1.432 374,111.496 ↑ 1.0 1 1

GroupAggregate (cost=11,817.62..11,817.64 rows=1 width=406) (actual time=374,111.495..374,111.496 rows=1 loops=1)

  • Group Key: social_activities.id
4. 0.748 374,110.064 ↓ 15.0 15 1

Sort (cost=11,817.62..11,817.62 rows=1 width=399) (actual time=374,110.062..374,110.064 rows=15 loops=1)

  • Sort Key: social_activities.id
  • Sort Method: quicksort Memory: 28kB
5. 2.304 374,109.316 ↓ 15.0 15 1

Nested Loop (cost=4.72..11,817.61 rows=1 width=399) (actual time=321,644.916..374,109.316 rows=15 loops=1)

  • Join Filter: ((social_interactions_201609.user_id = social_credentials.user_id) AND CASE WHEN ((social_activities.social_network)::text = 'google'::text) THEN ((social_activities.page_uid)::text = (social_credentials.gmb_location_id)::text) WHEN ((social_activities.social_network)::text = 'facebook'::text) THEN ((social_activities.page_uid)::text = (social_credentials.active_page_id)::text) ELSE ((social_activities.page_uid)::text = (social_credentials.uid)::text) END)
  • Rows Removed by Join Filter: 2,057
6. 108.111 374,104.996 ↓ 56.0 56 1

Nested Loop (cost=4.72..11,803.41 rows=1 width=403) (actual time=266,570.096..374,104.996 rows=56 loops=1)

7. 27.936 364,048.725 ↓ 647.7 31,088 1

Append (cost=4.29..11,389.54 rows=48 width=17) (actual time=29.880..364,048.725 rows=31,088 loops=1)

8. 1.411 10.032 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201609 (cost=4.29..9.96 rows=1 width=17) (actual time=10.032..10.032 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
9. 8.621 8.621 ↓ 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=8.621..8.621 rows=627 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
10. 7.701 21.086 ↑ 1.0 1 1

Bitmap Heap Scan on social_interactions_201610 (cost=9.01..13.02 rows=1 width=17) (actual time=19.845..21.086 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
11. 0.010 13.385 ↓ 0.0 0 1

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

12. 9.149 9.149 ↓ 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=9.149..9.149 rows=4,973 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
13. 4.226 4.226 ↓ 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.226..4.226 rows=4,977 loops=1)

  • Index Cond: (parent_id IS NULL)
14. 8.037 61.585 ↑ 1.0 1 1

Bitmap Heap Scan on social_interactions_201611 (cost=9.24..13.25 rows=1 width=17) (actual time=59.651..61.585 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
15. 0.013 53.548 ↓ 0.0 0 1

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

16. 35.670 35.670 ↓ 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=35.670..35.670 rows=11,014 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
17. 17.865 17.865 ↓ 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=17.865..17.865 rows=11,016 loops=1)

  • Index Cond: (parent_id IS NULL)
18. 15.978 111.477 ↑ 1.0 1 1

Bitmap Heap Scan on social_interactions_201612 (cost=9.56..13.57 rows=1 width=17) (actual time=106.666..111.477 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
19. 0.019 95.499 ↓ 0.0 0 1

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

20. 60.158 60.158 ↓ 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=60.158..60.158 rows=19,482 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
21. 35.322 35.322 ↓ 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=35.321..35.322 rows=19,482 loops=1)

  • Index Cond: (parent_id IS NULL)
22. 110.600 263.504 ↓ 2.0 2 1

Bitmap Heap Scan on social_interactions_201701 (cost=14.20..18.21 rows=1 width=17) (actual time=166.519..263.504 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
23. 0.032 152.904 ↓ 0.0 0 1

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

24. 52.370 52.370 ↓ 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=52.370..52.370 rows=32,120 loops=1)

  • Index Cond: (parent_id IS NULL)
25. 100.502 100.502 ↓ 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=100.502..100.502 rows=32,107 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
26. 36.417 236.458 ↑ 1.0 1 1

Bitmap Heap Scan on social_interactions_201702 (cost=18.57..22.59 rows=1 width=17) (actual time=227.442..236.458 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
27. 0.050 200.041 ↓ 0.0 0 1

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

28. 67.029 67.029 ↓ 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=67.028..67.029 rows=42,119 loops=1)

  • Index Cond: (parent_id IS NULL)
29. 132.962 132.962 ↓ 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=132.962..132.962 rows=42,115 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
30. 286.114 676.663 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201703 (cost=32.08..36.09 rows=1 width=17) (actual time=676.663..676.663 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
31. 0.058 390.549 ↓ 0.0 0 1

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

32. 124.127 124.127 ↓ 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=124.127..124.127 rows=78,068 loops=1)

  • Index Cond: (parent_id IS NULL)
33. 266.364 266.364 ↓ 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=266.364..266.364 rows=78,059 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
34. 368.902 976.234 ↑ 1.0 1 1

Bitmap Heap Scan on social_interactions_201704 (cost=36.98..41.00 rows=1 width=17) (actual time=694.531..976.234 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
35. 0.073 607.332 ↓ 0.0 0 1

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

36. 289.201 289.201 ↓ 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=289.200..289.201 rows=96,859 loops=1)

  • Index Cond: (parent_id IS NULL)
37. 318.058 318.058 ↓ 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=318.058..318.058 rows=96,846 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
38. 485.801 1,125.794 ↓ 8.0 8 1

Bitmap Heap Scan on social_interactions_201705 (cost=45.78..53.63 rows=1 width=17) (actual time=696.450..1,125.794 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
39. 0.159 639.993 ↓ 0.0 0 1

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

40. 215.744 215.744 ↓ 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=215.744..215.744 rows=122,892 loops=1)

  • Index Cond: (parent_id IS NULL)
41. 424.090 424.090 ↓ 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=424.090..424.090 rows=122,859 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
42. 734.306 1,408.975 ↓ 7.0 7 1

Bitmap Heap Scan on social_interactions_201706 (cost=50.86..58.73 rows=1 width=17) (actual time=698.415..1,408.975 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
43. 0.163 674.669 ↓ 0.0 0 1

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

44. 218.321 218.321 ↓ 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=218.321..218.321 rows=136,207 loops=1)

  • Index Cond: (parent_id IS NULL)
45. 456.185 456.185 ↓ 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.185..456.185 rows=136,159 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
46. 1,002.482 1,704.690 ↓ 3.0 3 1

Bitmap Heap Scan on social_interactions_201707 (cost=50.82..58.69 rows=1 width=17) (actual time=732.357..1,704.690 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
47. 0.109 702.208 ↓ 0.0 0 1

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

48. 225.733 225.733 ↓ 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=225.733..225.733 rows=136,068 loops=1)

  • Index Cond: (parent_id IS NULL)
49. 476.366 476.366 ↓ 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=476.366..476.366 rows=136,022 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
50. 1,240.048 2,190.635 ↓ 686.0 686 1

Bitmap Heap Scan on social_interactions_201708 (cost=73.31..85.11 rows=1 width=17) (actual time=953.455..2,190.635 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
51. 0.185 950.587 ↓ 0.0 0 1

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

52. 345.512 345.512 ↓ 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=345.512..345.512 rows=192,397 loops=1)

  • Index Cond: (parent_id IS NULL)
53. 604.890 604.890 ↓ 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=604.889..604.890 rows=181,246 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
54. 883.127 1,798.889 ↓ 148.0 148 1

Bitmap Heap Scan on social_interactions_201709 (cost=76.57..84.46 rows=1 width=17) (actual time=920.117..1,798.889 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
55. 0.159 915.762 ↓ 0.0 0 1

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

56. 295.163 295.163 ↓ 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=295.163..295.163 rows=188,680 loops=1)

  • Index Cond: (parent_id IS NULL)
57. 620.440 620.440 ↓ 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=620.440..620.440 rows=188,675 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
58. 2,364.804 3,845.150 ↓ 157.0 157 1

Bitmap Heap Scan on social_interactions_201710 (cost=104.58..120.33 rows=1 width=17) (actual time=1,482.567..3,845.150 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
59. 0.216 1,480.346 ↓ 0.0 0 1

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

60. 580.319 580.319 ↓ 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=580.318..580.319 rows=258,726 loops=1)

  • Index Cond: (parent_id IS NULL)
61. 899.811 899.811 ↓ 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=899.811..899.811 rows=258,619 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
62. 2,030.213 3,816.766 ↓ 284.0 284 1

Bitmap Heap Scan on social_interactions_201711 (cost=129.92..145.68 rows=1 width=17) (actual time=1,797.056..3,816.766 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
63. 0.214 1,786.553 ↓ 0.0 0 1

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

64. 558.188 558.188 ↓ 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=558.188..558.188 rows=334,684 loops=1)

  • Index Cond: (parent_id IS NULL)
65. 1,228.151 1,228.151 ↓ 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,228.151..1,228.151 rows=334,036 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
66. 3,174.984 5,274.846 ↓ 223.0 223 1

Bitmap Heap Scan on social_interactions_201712 (cost=165.80..189.41 rows=1 width=17) (actual time=2,126.907..5,274.846 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
67. 0.398 2,099.862 ↓ 0.0 0 1

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

68. 739.401 739.401 ↓ 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=739.401..739.401 rows=429,441 loops=1)

  • Index Cond: (parent_id IS NULL)
69. 1,360.063 1,360.063 ↓ 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,360.063..1,360.063 rows=429,324 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
70. 3,958.215 6,580.919 ↓ 271.0 271 1

Bitmap Heap Scan on social_interactions_201801 (cost=181.38..208.94 rows=1 width=17) (actual time=2,655.639..6,580.919 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
71. 0.344 2,622.704 ↓ 0.0 0 1

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

72. 835.659 835.659 ↓ 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=835.659..835.659 rows=476,679 loops=1)

  • Index Cond: (parent_id IS NULL)
73. 1,786.701 1,786.701 ↓ 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,786.700..1,786.701 rows=465,292 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
74. 5,408.637 8,556.462 ↓ 279.0 279 1

Bitmap Heap Scan on social_interactions_201802 (cost=244.93..288.23 rows=1 width=17) (actual time=3,150.999..8,556.462 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
75. 0.424 3,147.825 ↓ 0.0 0 1

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

76. 1,045.836 1,045.836 ↓ 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,045.836..1,045.836 rows=615,326 loops=1)

  • Index Cond: (parent_id IS NULL)
77. 2,101.565 2,101.565 ↓ 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,101.565..2,101.565 rows=615,200 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
78. 6,039.149 9,425.495 ↓ 439.0 439 1

Bitmap Heap Scan on social_interactions_201803 (cost=264.62..311.87 rows=1 width=17) (actual time=3,389.616..9,425.495 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
79. 0.713 3,386.346 ↓ 0.0 0 1

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

80. 1,072.927 1,072.927 ↓ 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,072.927..1,072.927 rows=661,005 loops=1)

  • Index Cond: (parent_id IS NULL)
81. 2,312.706 2,312.706 ↓ 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,312.706..2,312.706 rows=660,882 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
82. 7,445.301 11,212.187 ↓ 438.0 438 1

Bitmap Heap Scan on social_interactions_201804 (cost=299.45..354.59 rows=1 width=17) (actual time=3,770.418..11,212.187 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
83. 0.683 3,766.886 ↓ 0.0 0 1

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

84. 1,195.008 1,195.008 ↓ 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,195.008..1,195.008 rows=750,355 loops=1)

  • Index Cond: (parent_id IS NULL)
85. 2,571.195 2,571.195 ↓ 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,571.195..2,571.195 rows=750,215 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
86. 9,360.897 14,229.006 ↓ 471.0 471 1

Bitmap Heap Scan on social_interactions_201805 (cost=388.54..459.45 rows=1 width=17) (actual time=4,872.281..14,229.006 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
87. 0.706 4,868.109 ↓ 0.0 0 1

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

88. 1,664.329 1,664.329 ↓ 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,664.329..1,664.329 rows=975,768 loops=1)

  • Index Cond: (parent_id IS NULL)
89. 3,203.074 3,203.074 ↓ 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,203.074..3,203.074 rows=975,606 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
90. 8,304.606 12,816.878 ↓ 551.0 551 1

Bitmap Heap Scan on social_interactions_201806 (cost=351.41..418.36 rows=1 width=17) (actual time=4,515.801..12,816.878 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
91. 0.638 4,512.272 ↓ 0.0 0 1

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

92. 1,458.925 1,458.925 ↓ 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,458.925..1,458.925 rows=879,658 loops=1)

  • Index Cond: (parent_id IS NULL)
93. 3,052.709 3,052.709 ↓ 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=3,052.709..3,052.709 rows=879,418 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
94. 7,631.821 12,597.165 ↓ 640.0 640 1

Bitmap Heap Scan on social_interactions_201807 (cost=396.17..474.93 rows=1 width=17) (actual time=4,981.824..12,597.165 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
95. 0.787 4,965.344 ↓ 0.0 0 1

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

96. 1,628.729 1,628.729 ↓ 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,628.729..1,628.729 rows=989,779 loops=1)

  • Index Cond: (parent_id IS NULL)
97. 3,335.828 3,335.828 ↓ 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,335.828..3,335.828 rows=989,421 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
98. 10,037.846 16,065.864 ↓ 374.0 374 1

Bitmap Heap Scan on social_interactions_201808 (cost=466.04..556.63 rows=1 width=17) (actual time=6,033.387..16,065.864 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
99. 0.951 6,028.018 ↓ 0.0 0 1

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

100. 2,136.971 2,136.971 ↓ 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=2,136.971..2,136.971 rows=1,171,662 loops=1)

  • Index Cond: (parent_id IS NULL)
101. 3,890.096 3,890.096 ↓ 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,890.096..3,890.096 rows=1,171,732 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
102. 10,140.376 15,325.995 ↓ 395.0 395 1

Bitmap Heap Scan on social_interactions_201809 (cost=397.05..471.87 rows=1 width=17) (actual time=5,190.302..15,325.995 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
103. 0.736 5,185.619 ↓ 0.0 0 1

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

104. 1,655.280 1,655.280 ↓ 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,655.280..1,655.280 rows=1,001,742 loops=1)

  • Index Cond: (parent_id IS NULL)
105. 3,529.603 3,529.603 ↓ 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,529.602..3,529.603 rows=1,001,814 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
106. 10,747.038 16,114.478 ↓ 710.0 710 1

Bitmap Heap Scan on social_interactions_201810 (cost=430.15..508.93 rows=1 width=17) (actual time=5,378.936..16,114.478 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
107. 0.770 5,367.440 ↓ 0.0 0 1

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

108. 1,799.078 1,799.078 ↓ 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,799.078..1,799.078 rows=1,082,175 loops=1)

  • Index Cond: (parent_id IS NULL)
109. 3,567.592 3,567.592 ↓ 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,567.592..3,567.592 rows=1,082,406 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
110. 5,467.765 8,301.675 ↓ 1,176.0 1,176 1

Bitmap Heap Scan on social_interactions_201811 (cost=238.79..282.12 rows=1 width=17) (actual time=2,847.377..8,301.675 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
111. 0.487 2,833.910 ↓ 0.0 0 1

BitmapAnd (cost=238.79..238.79 rows=11 width=0) (actual time=2,833.909..2,833.910 rows=0 loops=1)

112. 923.575 923.575 ↓ 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=923.575..923.575 rows=588,122 loops=1)

  • Index Cond: (parent_id IS NULL)
113. 1,909.848 1,909.848 ↓ 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=1,909.848..1,909.848 rows=588,392 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
114. 5,759.323 8,678.648 ↓ 1,554.0 1,554 1

Bitmap Heap Scan on social_interactions_201812 (cost=239.40..282.74 rows=1 width=17) (actual time=2,940.149..8,678.648 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
115. 0.481 2,919.325 ↓ 0.0 0 1

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

116. 951.678 951.678 ↓ 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=951.678..951.678 rows=598,748 loops=1)

  • Index Cond: (parent_id IS NULL)
117. 1,967.166 1,967.166 ↓ 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,967.166..1,967.166 rows=599,086 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
118. 5,501.229 8,427.225 ↓ 1,229.0 1,229 1

Bitmap Heap Scan on social_interactions_201901 (cost=229.87..273.19 rows=1 width=17) (actual time=3,012.952..8,427.225 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
119. 0.401 2,925.996 ↓ 0.0 0 1

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

120. 1,004.920 1,004.920 ↓ 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=1,004.920..1,004.920 rows=570,097 loops=1)

  • Index Cond: (parent_id IS NULL)
121. 1,920.675 1,920.675 ↓ 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,920.675..1,920.675 rows=570,495 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
122. 5,158.011 7,967.567 ↓ 1,025.0 1,025 1

Bitmap Heap Scan on social_interactions_201902 (cost=215.37..254.75 rows=1 width=17) (actual time=2,817.627..7,967.567 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
123. 0.431 2,809.556 ↓ 0.0 0 1

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

124. 836.540 836.540 ↓ 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=836.540..836.540 rows=532,755 loops=1)

  • Index Cond: (parent_id IS NULL)
125. 1,972.585 1,972.585 ↓ 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,972.585..1,972.585 rows=533,035 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
126. 5,940.884 8,852.967 ↓ 1,109.0 1,109 1

Bitmap Heap Scan on social_interactions_201903 (cost=239.00..282.33 rows=1 width=17) (actual time=2,936.654..8,852.967 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
127. 0.432 2,912.083 ↓ 0.0 0 1

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

128. 952.513 952.513 ↓ 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=952.513..952.513 rows=597,766 loops=1)

  • Index Cond: (parent_id IS NULL)
129. 1,959.138 1,959.138 ↓ 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=1,959.138..1,959.138 rows=598,097 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
130. 6,806.682 9,818.864 ↓ 1,162.0 1,162 1

Bitmap Heap Scan on social_interactions_201904 (cost=257.74..305.01 rows=1 width=17) (actual time=3,038.127..9,818.864 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
131. 0.621 3,012.182 ↓ 0.0 0 1

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

132. 996.032 996.032 ↓ 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=996.032..996.032 rows=644,437 loops=1)

  • Index Cond: (parent_id IS NULL)
133. 2,015.529 2,015.529 ↓ 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,015.529..2,015.529 rows=644,789 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
134. 7,327.294 10,677.003 ↓ 1,084.0 1,084 1

Bitmap Heap Scan on social_interactions_201905 (cost=275.96..327.16 rows=1 width=17) (actual time=3,392.315..10,677.003 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
135. 0.604 3,349.709 ↓ 0.0 0 1

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

136. 1,111.127 1,111.127 ↓ 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,111.127..1,111.127 rows=688,598 loops=1)

  • Index Cond: (parent_id IS NULL)
137. 2,237.978 2,237.978 ↓ 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,237.978..2,237.978 rows=688,897 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
138. 7,008.291 10,448.571 ↓ 1,045.0 1,045 1

Bitmap Heap Scan on social_interactions_201906 (cost=265.43..312.69 rows=1 width=17) (actual time=3,444.143..10,448.571 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
139. 0.601 3,440.280 ↓ 0.0 0 1

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

140. 1,068.214 1,068.214 ↓ 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,068.214..1,068.214 rows=658,289 loops=1)

  • Index Cond: (parent_id IS NULL)
141. 2,371.465 2,371.465 ↓ 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,371.465..2,371.465 rows=658,593 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
142. 7,467.255 10,868.367 ↓ 1,204.0 1,204 1

Bitmap Heap Scan on social_interactions_201907 (cost=271.38..322.57 rows=1 width=17) (actual time=3,417.728..10,868.367 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
143. 0.643 3,401.112 ↓ 0.0 0 1

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

144. 1,093.986 1,093.986 ↓ 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,093.986..1,093.986 rows=682,667 loops=1)

  • Index Cond: (parent_id IS NULL)
145. 2,306.483 2,306.483 ↓ 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,306.483..2,306.483 rows=683,026 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
146. 7,618.706 11,168.822 ↓ 903.0 903 1

Bitmap Heap Scan on social_interactions_201908 (cost=279.32..330.51 rows=1 width=17) (actual time=3,554.525..11,168.822 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
147. 0.617 3,550.116 ↓ 0.0 0 1

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

148. 1,283.988 1,283.988 ↓ 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,283.988..1,283.988 rows=688,270 loops=1)

  • Index Cond: (parent_id IS NULL)
149. 2,265.511 2,265.511 ↓ 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,265.511..2,265.511 rows=688,555 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
150. 7,734.994 11,422.592 ↓ 1,124.0 1,124 1

Bitmap Heap Scan on social_interactions_201909 (cost=304.32..359.47 rows=1 width=17) (actual time=3,691.049..11,422.592 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
151. 0.625 3,687.598 ↓ 0.0 0 1

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

152. 1,201.131 1,201.131 ↓ 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,201.131..1,201.131 rows=750,228 loops=1)

  • Index Cond: (parent_id IS NULL)
153. 2,485.842 2,485.842 ↓ 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,485.842..2,485.842 rows=750,568 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
154. 7,728.285 11,656.748 ↓ 1,055.0 1,055 1

Bitmap Heap Scan on social_interactions_201910 (cost=303.60..358.74 rows=1 width=17) (actual time=3,935.789..11,656.748 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
155. 0.678 3,928.463 ↓ 0.0 0 1

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

156. 1,197.048 1,197.048 ↓ 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,197.048..1,197.048 rows=747,333 loops=1)

  • Index Cond: (parent_id IS NULL)
157. 2,730.737 2,730.737 ↓ 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,730.737..2,730.737 rows=747,680 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
158. 11,717.847 15,400.742 ↓ 1,152.0 1,152 1

Bitmap Heap Scan on social_interactions_201911 (cost=308.38..379.28 rows=1 width=17) (actual time=3,712.854..15,400.742 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
159. 0.949 3,682.895 ↓ 0.0 0 1

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

160. 1,261.962 1,261.962 ↓ 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,261.962..1,261.962 rows=739,401 loops=1)

  • Index Cond: (parent_id IS NULL)
161. 2,419.984 2,419.984 ↓ 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,419.984..2,419.984 rows=739,811 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
162. 11,834.005 15,694.638 ↓ 1,464.0 1,464 1

Bitmap Heap Scan on social_interactions_201912 (cost=322.25..397.08 rows=1 width=17) (actual time=3,865.306..15,694.638 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
163. 0.829 3,860.633 ↓ 0.0 0 1

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

164. 1,266.311 1,266.311 ↓ 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=1,266.311..1,266.311 rows=775,256 loops=1)

  • Index Cond: (parent_id IS NULL)
165. 2,593.493 2,593.493 ↓ 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,593.493..2,593.493 rows=775,694 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
166. 11,966.460 15,887.351 ↓ 1,600.0 1,600 1

Bitmap Heap Scan on social_interactions_202001 (cost=327.39..402.24 rows=1 width=17) (actual time=3,929.907..15,887.351 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
167. 0.881 3,920.891 ↓ 0.0 0 1

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

168. 1,337.027 1,337.027 ↓ 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=1,337.026..1,337.027 rows=784,673 loops=1)

  • Index Cond: (parent_id IS NULL)
169. 2,582.983 2,582.983 ↓ 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,582.983..2,582.983 rows=785,132 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
170. 12,155.588 13,742.180 ↓ 1,706.0 1,706 1

Bitmap Heap Scan on social_interactions_202002 (cost=336.95..415.72 rows=1 width=17) (actual time=1,591.957..13,742.180 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
171. 0.939 1,586.592 ↓ 0.0 0 1

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

172. 1,368.744 1,368.744 ↓ 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=1,368.744..1,368.744 rows=812,088 loops=1)

  • Index Cond: (parent_id IS NULL)
173. 216.909 216.909 ↓ 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=216.909..216.909 rows=812,659 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
174. 9,167.462 12,127.989 ↓ 1,103.0 1,103 1

Bitmap Heap Scan on social_interactions_202003 (cost=246.03..305.10 rows=1 width=17) (actual time=2,965.082..12,127.989 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
175. 0.767 2,960.527 ↓ 0.0 0 1

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

176. 954.968 954.968 ↓ 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=954.968..954.968 rows=587,940 loops=1)

  • Index Cond: (parent_id IS NULL)
177. 2,004.792 2,004.792 ↓ 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=2,004.792..2,004.792 rows=588,281 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
178. 2,814.388 6,358.642 ↓ 1,315.0 1,315 1

Bitmap Heap Scan on social_interactions_202004 (cost=208.12..255.37 rows=1 width=17) (actual time=3,550.422..6,358.642 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
179. 0.660 3,544.254 ↓ 0.0 0 1

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

180. 1,198.798 1,198.798 ↓ 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=1,198.798..1,198.798 rows=733,456 loops=1)

  • Index Cond: (parent_id IS NULL)
181. 2,344.796 2,344.796 ↓ 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,344.796..2,344.796 rows=686,925 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
182. 9,038.459 12,271.513 ↓ 1,455.0 1,455 1

Bitmap Heap Scan on social_interactions_202005 (cost=191.91..247.06 rows=1 width=17) (actual time=3,243.493..12,271.513 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
183. 0.904 3,233.054 ↓ 0.0 0 1

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

184. 1,072.823 1,072.823 ↓ 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,072.823..1,072.823 rows=671,668 loops=1)

  • Index Cond: (parent_id IS NULL)
185. 2,159.327 2,159.327 ↓ 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,159.327..2,159.327 rows=618,963 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
186. 4,453.861 6,874.082 ↓ 935.0 935 1

Bitmap Heap Scan on social_interactions_202006 (cost=129.20..156.75 rows=1 width=17) (actual time=2,423.134..6,874.082 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
187. 0.402 2,420.221 ↓ 0.0 0 1

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

188. 996.817 996.817 ↓ 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=996.817..996.817 rows=432,306 loops=1)

  • Index Cond: (parent_id IS NULL)
189. 1,423.002 1,423.002 ↓ 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,423.002..1,423.002 rows=422,259 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
190. 223.211 923.336 ↓ 597.0 597 1

Bitmap Heap Scan on social_interactions_202007 (cost=97.95..113.71 rows=1 width=17) (actual time=708.749..923.336 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
191. 0.210 700.125 ↓ 0.0 0 1

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

192. 639.756 639.756 ↓ 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=639.756..639.756 rows=369,919 loops=1)

  • Index Cond: (parent_id IS NULL)
193. 60.159 60.159 ↓ 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=60.159..60.159 rows=330,113 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
194. 4.034 4.034 ↓ 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=17) (actual time=4.034..4.034 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))
195. 9,948.160 9,948.160 ↓ 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.320..0.320 rows=0 loops=31,088)

  • Index Cond: (id = social_interactions_201609.social_activity_id)
  • Filter: (((social_network)::text = 'facebook'::text) AND ((processing_status)::text = 'sent'::text) AND (user_id = 4,158))
  • Rows Removed by Filter: 1
196. 2.016 2.016 ↑ 3.2 37 56

Seq Scan on social_credentials (cost=0.00..11.20 rows=120 width=100) (actual time=0.025..0.036 rows=37 loops=56)

Planning time : 344.010 ms
Execution time : 374,187.632 ms