explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oi1K

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 367,573.621 ↑ 1.0 1 1

Limit (cost=11,823.29..11,823.30 rows=1 width=410) (actual time=367,573.619..367,573.621 rows=1 loops=1)

2. 0.822 367,573.618 ↑ 1.0 1 1

Sort (cost=11,823.29..11,823.30 rows=1 width=410) (actual time=367,573.617..367,573.618 rows=1 loops=1)

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

GroupAggregate (cost=11,823.25..11,823.28 rows=1 width=410) (actual time=367,572.796..367,572.796 rows=1 loops=1)

  • Group Key: social_activities.id
4. 3.440 367,572.769 ↓ 15.0 15 1

Sort (cost=11,823.25..11,823.26 rows=1 width=399) (actual time=367,572.768..367,572.769 rows=15 loops=1)

  • Sort Key: social_activities.id
  • Sort Method: quicksort Memory: 28kB
5. 0.125 367,569.329 ↓ 15.0 15 1

Nested Loop (cost=5.00..11,823.24 rows=1 width=399) (actual time=314,771.227..367,569.329 rows=15 loops=1)

  • Join Filter: 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: 41
6. 0.050 0.050 ↑ 1.0 1 1

Seq Scan on social_credentials (cost=0.00..11.50 rows=1 width=100) (actual time=0.037..0.050 rows=1 loops=1)

  • Filter: (user_id = 4,158)
  • Rows Removed by Filter: 36
7. 0.544 367,569.154 ↓ 56.0 56 1

Nested Loop (cost=5.00..11,811.72 rows=1 width=403) (actual time=260,371.556..367,569.154 rows=56 loops=1)

8. 121.266 367,565.250 ↓ 56.0 56 1

Nested Loop (cost=4.72..11,803.41 rows=1 width=399) (actual time=260,368.072..367,565.250 rows=56 loops=1)

9. 19.519 358,366.288 ↓ 647.7 31,088 1

Append (cost=4.29..11,389.54 rows=48 width=13) (actual time=23.907..358,366.288 rows=31,088 loops=1)

10. 1.301 4.844 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201609 (cost=4.29..9.96 rows=1 width=13) (actual time=4.844..4.844 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
11. 3.543 3.543 ↓ 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=3.543..3.543 rows=627 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
12. 4.923 19.797 ↑ 1.0 1 1

Bitmap Heap Scan on social_interactions_201610 (cost=9.01..13.02 rows=1 width=13) (actual time=19.061..19.797 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
13. 0.009 14.874 ↓ 0.0 0 1

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

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

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

  • Index Cond: (parent_id IS NULL)
16. 8.015 64.732 ↑ 1.0 1 1

Bitmap Heap Scan on social_interactions_201611 (cost=9.24..13.25 rows=1 width=13) (actual time=62.832..64.732 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
17. 0.014 56.717 ↓ 0.0 0 1

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

18. 37.149 37.149 ↓ 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.149..37.149 rows=11,014 loops=1)

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

  • Index Cond: (parent_id IS NULL)
20. 17.535 115.096 ↑ 1.0 1 1

Bitmap Heap Scan on social_interactions_201612 (cost=9.56..13.57 rows=1 width=13) (actual time=111.907..115.096 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
21. 0.019 97.561 ↓ 0.0 0 1

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

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

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

  • Index Cond: (parent_id IS NULL)
24. 97.521 251.842 ↓ 2.0 2 1

Bitmap Heap Scan on social_interactions_201701 (cost=14.20..18.21 rows=1 width=13) (actual time=167.430..251.842 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
25. 0.033 154.321 ↓ 0.0 0 1

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

26. 50.678 50.678 ↓ 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=50.677..50.678 rows=32,120 loops=1)

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
28. 32.993 223.810 ↑ 1.0 1 1

Bitmap Heap Scan on social_interactions_201702 (cost=18.57..22.59 rows=1 width=13) (actual time=215.606..223.810 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
29. 0.034 190.817 ↓ 0.0 0 1

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

30. 63.793 63.793 ↓ 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=63.793..63.793 rows=42,119 loops=1)

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
32. 240.981 685.205 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201703 (cost=32.08..36.09 rows=1 width=13) (actual time=685.205..685.205 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
33. 0.060 444.224 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
36. 399.377 880.133 ↑ 1.0 1 1

Bitmap Heap Scan on social_interactions_201704 (cost=36.98..41.00 rows=1 width=13) (actual time=579.896..880.133 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
37. 0.000 480.756 ↓ 0.0 0 1

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

38. 158.371 158.371 ↓ 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=158.371..158.371 rows=96,859 loops=1)

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
40. 448.120 1,037.550 ↓ 8.0 8 1

Bitmap Heap Scan on social_interactions_201705 (cost=45.78..53.63 rows=1 width=13) (actual time=636.841..1,037.550 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
41. 0.141 589.430 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
44. 679.366 1,316.868 ↓ 7.0 7 1

Bitmap Heap Scan on social_interactions_201706 (cost=50.86..58.73 rows=1 width=13) (actual time=659.005..1,316.868 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
45. 0.136 637.502 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
48. 910.502 1,592.141 ↓ 3.0 3 1

Bitmap Heap Scan on social_interactions_201707 (cost=50.82..58.69 rows=1 width=13) (actual time=710.462..1,592.141 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
49. 0.109 681.639 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
52. 1,299.891 2,265.508 ↓ 686.0 686 1

Bitmap Heap Scan on social_interactions_201708 (cost=73.31..85.11 rows=1 width=13) (actual time=968.323..2,265.508 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
53. 0.156 965.617 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
56. 890.873 1,815.011 ↓ 148.0 148 1

Bitmap Heap Scan on social_interactions_201709 (cost=76.57..84.46 rows=1 width=13) (actual time=928.014..1,815.011 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
57. 0.149 924.138 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
60. 2,229.725 3,548.679 ↓ 157.0 157 1

Bitmap Heap Scan on social_interactions_201710 (cost=104.58..120.33 rows=1 width=13) (actual time=1,320.586..3,548.679 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
61. 0.191 1,318.954 ↓ 0.0 0 1

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

62. 425.482 425.482 ↓ 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=425.481..425.482 rows=258,726 loops=1)

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
64. 2,008.968 3,670.459 ↓ 284.0 284 1

Bitmap Heap Scan on social_interactions_201711 (cost=129.92..145.68 rows=1 width=13) (actual time=1,668.729..3,670.459 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
65. 0.217 1,661.491 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
68. 3,113.327 5,181.443 ↓ 223.0 223 1

Bitmap Heap Scan on social_interactions_201712 (cost=165.80..189.41 rows=1 width=13) (actual time=2,083.820..5,181.443 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
69. 0.306 2,068.116 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
72. 3,771.266 6,002.299 ↓ 271.0 271 1

Bitmap Heap Scan on social_interactions_201801 (cost=181.38..208.94 rows=1 width=13) (actual time=2,271.221..6,002.299 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
73. 0.347 2,231.033 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
76. 5,293.210 8,393.046 ↓ 279.0 279 1

Bitmap Heap Scan on social_interactions_201802 (cost=244.93..288.23 rows=1 width=13) (actual time=3,102.812..8,393.046 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
77. 0.411 3,099.836 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
80. 6,093.779 9,579.387 ↓ 439.0 439 1

Bitmap Heap Scan on social_interactions_201803 (cost=264.62..311.87 rows=1 width=13) (actual time=3,492.648..9,579.387 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
81. 1.488 3,485.608 ↓ 0.0 0 1

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

82. 1,145.294 1,145.294 ↓ 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,145.293..1,145.294 rows=661,005 loops=1)

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
84. 7,392.627 11,073.974 ↓ 438.0 438 1

Bitmap Heap Scan on social_interactions_201804 (cost=299.45..354.59 rows=1 width=13) (actual time=3,684.154..11,073.974 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
85. 0.625 3,681.347 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
88. 9,676.995 14,463.075 ↓ 471.0 471 1

Bitmap Heap Scan on social_interactions_201805 (cost=388.54..459.45 rows=1 width=13) (actual time=4,789.613..14,463.075 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
89. 0.812 4,786.080 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
92. 7,933.938 12,157.250 ↓ 551.0 551 1

Bitmap Heap Scan on social_interactions_201806 (cost=351.41..418.36 rows=1 width=13) (actual time=4,226.180..12,157.250 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
93. 0.619 4,223.312 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
96. 7,724.872 12,477.841 ↓ 640.0 640 1

Bitmap Heap Scan on social_interactions_201807 (cost=396.17..474.93 rows=1 width=13) (actual time=4,769.857..12,477.841 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
97. 0.617 4,752.969 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
100. 9,641.149 15,761.159 ↓ 374.0 374 1

Bitmap Heap Scan on social_interactions_201808 (cost=466.04..556.63 rows=1 width=13) (actual time=6,125.050..15,761.159 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
101. 0.717 6,120.010 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
104. 10,144.473 15,135.004 ↓ 395.0 395 1

Bitmap Heap Scan on social_interactions_201809 (cost=397.05..471.87 rows=1 width=13) (actual time=4,994.172..15,135.004 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
105. 0.838 4,990.531 ↓ 0.0 0 1

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

106. 1,568.876 1,568.876 ↓ 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,568.875..1,568.876 rows=1,001,742 loops=1)

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
108. 10,525.461 16,080.424 ↓ 710.0 710 1

Bitmap Heap Scan on social_interactions_201810 (cost=430.15..508.93 rows=1 width=13) (actual time=5,558.955..16,080.424 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
109. 0.767 5,554.963 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
112. 5,212.631 7,982.189 ↓ 1,176.0 1,176 1

Bitmap Heap Scan on social_interactions_201811 (cost=238.79..282.12 rows=1 width=13) (actual time=2,781.449..7,982.189 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
113. 0.403 2,769.558 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
116. 5,933.310 8,922.589 ↓ 1,554.0 1,554 1

Bitmap Heap Scan on social_interactions_201812 (cost=239.40..282.74 rows=1 width=13) (actual time=3,013.253..8,922.589 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
117. 0.402 2,989.279 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
120. 5,412.887 8,289.319 ↓ 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,966.468..8,289.319 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
121. 0.541 2,876.432 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
124. 5,062.337 7,643.015 ↓ 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,589.728..7,643.015 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
125. 0.378 2,580.678 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
128. 5,893.107 8,745.346 ↓ 1,109.0 1,109 1

Bitmap Heap Scan on social_interactions_201903 (cost=239.00..282.33 rows=1 width=13) (actual time=2,875.992..8,745.346 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
129. 0.430 2,852.239 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
132. 6,230.542 9,541.765 ↓ 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,332.122..9,541.765 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
133. 0.585 3,311.223 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
136. 6,621.866 9,884.204 ↓ 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,300.383..9,884.204 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
137. 1.203 3,262.338 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
140. 6,842.252 10,091.165 ↓ 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,253.410..10,091.165 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
141. 0.725 3,248.913 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
144. 7,238.933 10,705.700 ↓ 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,484.622..10,705.700 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
145. 0.615 3,466.767 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
148. 7,567.947 10,911.952 ↓ 903.0 903 1

Bitmap Heap Scan on social_interactions_201908 (cost=279.32..330.51 rows=1 width=13) (actual time=3,349.262..10,911.952 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
149. 0.711 3,344.005 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
152. 7,741.018 11,318.960 ↓ 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,581.408..11,318.960 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
153. 1.014 3,577.942 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
156. 7,722.336 11,470.034 ↓ 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,750.933..11,470.034 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
157. 0.744 3,747.698 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
160. 11,670.718 15,302.213 ↓ 1,152.0 1,152 1

Bitmap Heap Scan on social_interactions_201911 (cost=308.38..379.28 rows=1 width=13) (actual time=3,659.766..15,302.213 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
161. 1.006 3,631.495 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
164. 11,521.130 15,424.186 ↓ 1,464.0 1,464 1

Bitmap Heap Scan on social_interactions_201912 (cost=322.25..397.08 rows=1 width=13) (actual time=3,909.400..15,424.186 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
165. 1.059 3,903.056 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
168. 12,003.525 15,852.830 ↓ 1,600.0 1,600 1

Bitmap Heap Scan on social_interactions_202001 (cost=327.39..402.24 rows=1 width=13) (actual time=3,854.200..15,852.830 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
169. 0.935 3,849.305 ↓ 0.0 0 1

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

170. 1,248.816 1,248.816 ↓ 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,248.816..1,248.816 rows=784,673 loops=1)

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
172. 11,979.733 13,435.829 ↓ 1,706.0 1,706 1

Bitmap Heap Scan on social_interactions_202002 (cost=336.95..415.72 rows=1 width=13) (actual time=1,460.787..13,435.829 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
173. 0.997 1,456.096 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
176. 9,496.305 12,320.059 ↓ 1,103.0 1,103 1

Bitmap Heap Scan on social_interactions_202003 (cost=246.03..305.10 rows=1 width=13) (actual time=2,827.679..12,320.059 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
177. 0.676 2,823.754 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
180. 3,020.899 6,705.541 ↓ 1,315.0 1,315 1

Bitmap Heap Scan on social_interactions_202004 (cost=208.12..255.37 rows=1 width=13) (actual time=3,689.128..6,705.541 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
181. 0.650 3,684.642 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
184. 9,120.442 12,393.678 ↓ 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,287.839..12,393.678 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
185. 0.710 3,273.236 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
188. 4,364.047 6,655.558 ↓ 935.0 935 1

Bitmap Heap Scan on social_interactions_202006 (cost=129.20..156.75 rows=1 width=13) (actual time=2,298.019..6,655.558 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
189. 0.352 2,291.511 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
192. 248.537 953.624 ↓ 597.0 597 1

Bitmap Heap Scan on social_interactions_202007 (cost=97.95..113.71 rows=1 width=13) (actual time=707.823..953.624 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
193. 0.209 705.087 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
196. 0.436 0.436 ↓ 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=0.436..0.436 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))
197. 9,077.696 9,077.696 ↓ 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.292..0.292 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
198. 3.360 3.360 ↑ 1.0 1 56

Index Only Scan using users_pkey on users (cost=0.29..8.30 rows=1 width=4) (actual time=0.059..0.060 rows=1 loops=56)

  • Index Cond: (id = 4,158)
  • Heap Fetches: 56
Planning time : 6.229 ms
Execution time : 367,603.225 ms