explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8YLV

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 714.137 ↓ 0.0 0 1

Nested Loop (cost=4.72..11,892.44 rows=1 width=282) (actual time=714.137..714.137 rows=0 loops=1)

2. 0.028 714.114 ↑ 48.0 1 1

Append (cost=4.29..11,486.84 rows=48 width=282) (actual time=610.063..714.114 rows=1 loops=1)

3. 0.817 0.875 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201609 (cost=4.29..9.97 rows=1 width=282) (actual time=0.875..0.875 rows=0 loops=1)

  • Recheck Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text) AND (user_id = 4,158))
  • Rows Removed by Filter: 627
  • Heap Blocks: exact=12
4. 0.058 0.058 ↓ 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=0.058..0.058 rows=627 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
5. 0.001 0.325 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201610 (cost=9.01..13.02 rows=1 width=282) (actual time=0.325..0.325 rows=0 loops=1)

  • Recheck Cond: (((interaction_type)::text = 'SocialInteractions::Activity'::text) AND (user_id = 4,158))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
6. 0.005 0.324 ↓ 0.0 0 1

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

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

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

Bitmap Index Scan on social_activity_interactions_201610_user_id_idx (cost=0.00..4.38 rows=13 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
9. 0.001 1.333 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201611 (cost=9.24..13.25 rows=1 width=282) (actual time=1.333..1.333 rows=0 loops=1)

  • Recheck Cond: (((interaction_type)::text = 'SocialInteractions::Activity'::text) AND (user_id = 4,158))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
10. 0.007 1.332 ↓ 0.0 0 1

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

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

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

Bitmap Index Scan on social_activity_interactions_201611_user_id_idx (cost=0.00..4.49 rows=28 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
13. 0.002 4.166 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201612 (cost=9.56..13.57 rows=1 width=282) (actual time=4.166..4.166 rows=0 loops=1)

  • Recheck Cond: (((interaction_type)::text = 'SocialInteractions::Activity'::text) AND (user_id = 4,158))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
14. 0.011 4.164 ↓ 0.0 0 1

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

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

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

Bitmap Index Scan on social_activity_interactions_201612_user_id_idx (cost=0.00..4.65 rows=49 width=0) (actual time=0.005..0.006 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
17. 0.019 0.022 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201701 (cost=14.20..18.21 rows=1 width=282) (actual time=0.022..0.022 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
18. 0.000 0.003 ↓ 0.0 0 1

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

19. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201701_user_id_idx (cost=0.00..4.91 rows=83 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
20. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201701_interaction_type_idx (cost=0.00..9.04 rows=83 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
21. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201702 (cost=18.57..22.59 rows=1 width=282) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
22. 0.000 0.004 ↓ 0.0 0 1

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

23. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201702_user_id_idx (cost=0.00..9.10 rows=108 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
24. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201702_interaction_type_idx (cost=0.00..9.22 rows=108 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
25. 0.003 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201703 (cost=32.20..36.22 rows=1 width=282) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
26. 0.000 0.004 ↓ 0.0 0 1

BitmapAnd (cost=32.20..32.20 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

27. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201703_user_id_idx (cost=0.00..13.97 rows=208 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
28. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201703_interaction_type_idx (cost=0.00..17.97 rows=208 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
29. 0.001 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201704 (cost=36.98..41.00 rows=1 width=282) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
30. 0.000 0.003 ↓ 0.0 0 1

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

31. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201704_user_id_idx (cost=0.00..14.36 rows=260 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
32. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201704_interaction_type_idx (cost=0.00..22.36 rows=260 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
33. 0.001 0.068 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201705 (cost=45.78..53.64 rows=1 width=282) (actual time=0.068..0.068 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
34. 0.000 0.067 ↓ 0.0 0 1

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

35. 0.067 0.067 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201705_user_id_idx (cost=0.00..18.76 rows=313 width=0) (actual time=0.067..0.067 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
36. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201705_interaction_type_idx (cost=0.00..26.76 rows=313 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
37. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201706 (cost=50.86..58.74 rows=1 width=282) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
38. 0.001 0.006 ↓ 0.0 0 1

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

39. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201706_user_id_idx (cost=0.00..23.30 rows=385 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
40. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201706_interaction_type_idx (cost=0.00..27.30 rows=385 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
41. 0.001 0.010 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201707 (cost=50.82..58.69 rows=1 width=282) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
42. 0.000 0.009 ↓ 0.0 0 1

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

43. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201707_user_id_idx (cost=0.00..23.28 rows=382 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
44. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201707_interaction_type_idx (cost=0.00..27.28 rows=382 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
45. 0.002 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201708 (cost=73.31..85.12 rows=1 width=282) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
46. 0.001 0.004 ↓ 0.0 0 1

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

47. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201708_user_id_idx (cost=0.00..32.53 rows=548 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
48. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201708_interaction_type_idx (cost=0.00..40.53 rows=548 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
49. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201709 (cost=76.57..84.47 rows=1 width=282) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
50. 0.001 0.004 ↓ 0.0 0 1

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

51. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201709_user_id_idx (cost=0.00..32.16 rows=499 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
52. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201709_interaction_type_idx (cost=0.00..44.16 rows=499 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
53. 0.002 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201710 (cost=100.58..116.34 rows=1 width=282) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
54. 0.000 0.004 ↓ 0.0 0 1

BitmapAnd (cost=100.58..100.58 rows=4 width=0) (actual time=0.004..0.004 rows=0 loops=1)

55. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201710_user_id_idx (cost=0.00..42.16 rows=766 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
56. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201710_interaction_type_idx (cost=0.00..58.16 rows=766 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
57. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201711 (cost=129.92..145.69 rows=1 width=282) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
58. 0.000 0.005 ↓ 0.0 0 1

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

59. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201711_user_id_idx (cost=0.00..54.83 rows=855 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
60. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201711_interaction_type_idx (cost=0.00..74.83 rows=855 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
61. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201712 (cost=165.80..189.43 rows=1 width=282) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
62. 0.000 0.006 ↓ 0.0 0 1

BitmapAnd (cost=165.80..165.80 rows=6 width=0) (actual time=0.006..0.006 rows=0 loops=1)

63. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201712_user_id_idx (cost=0.00..68.78 rows=1,114 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
64. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201712_interaction_type_idx (cost=0.00..96.78 rows=1,114 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
65. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201801 (cost=181.38..208.95 rows=1 width=282) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
66. 0.001 0.006 ↓ 0.0 0 1

BitmapAnd (cost=181.38..181.38 rows=7 width=0) (actual time=0.005..0.006 rows=0 loops=1)

67. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201801_user_id_idx (cost=0.00..78.56 rows=1,352 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
68. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201801_interaction_type_idx (cost=0.00..102.56 rows=1,352 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
69. 0.000 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201802 (cost=240.93..284.26 rows=1 width=282) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
70. 0.001 0.007 ↓ 0.0 0 1

BitmapAnd (cost=240.93..240.93 rows=11 width=0) (actual time=0.007..0.007 rows=0 loops=1)

71. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201802_user_id_idx (cost=0.00..100.34 rows=2,122 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
72. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201802_interaction_type_idx (cost=0.00..140.34 rows=2,122 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
73. 0.002 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201803 (cost=260.62..307.90 rows=1 width=282) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
74. 0.000 0.004 ↓ 0.0 0 1

BitmapAnd (cost=260.62..260.62 rows=12 width=0) (actual time=0.004..0.004 rows=0 loops=1)

75. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201803_user_id_idx (cost=0.00..110.18 rows=2,368 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
76. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201803_interaction_type_idx (cost=0.00..150.18 rows=2,368 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
77. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201804 (cost=299.45..354.62 rows=1 width=282) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
78. 0.001 0.005 ↓ 0.0 0 1

BitmapAnd (cost=299.45..299.45 rows=14 width=0) (actual time=0.005..0.005 rows=0 loops=1)

79. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201804_user_id_idx (cost=0.00..129.60 rows=2,823 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
80. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201804_interaction_type_idx (cost=0.00..169.60 rows=2,823 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
81. 0.002 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201805 (cost=392.54..463.50 rows=1 width=282) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
82. 0.000 0.004 ↓ 0.0 0 1

BitmapAnd (cost=392.54..392.54 rows=18 width=0) (actual time=0.004..0.004 rows=0 loops=1)

83. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201805_user_id_idx (cost=0.00..168.15 rows=3,696 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
84. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201805_interaction_type_idx (cost=0.00..224.15 rows=3,696 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
85. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201806 (cost=355.41..422.40 rows=1 width=282) (actual time=0.004..0.005 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
86. 0.000 0.004 ↓ 0.0 0 1

BitmapAnd (cost=355.41..355.41 rows=17 width=0) (actual time=0.004..0.004 rows=0 loops=1)

87. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201806_user_id_idx (cost=0.00..153.58 rows=3,354 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
88. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201806_interaction_type_idx (cost=0.00..201.58 rows=3,354 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
89. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201807 (cost=400.17..478.98 rows=1 width=282) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
90. 0.000 0.006 ↓ 0.0 0 1

BitmapAnd (cost=400.17..400.17 rows=20 width=0) (actual time=0.006..0.006 rows=0 loops=1)

91. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201807_user_id_idx (cost=0.00..173.96 rows=3,938 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
92. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201807_interaction_type_idx (cost=0.00..225.96 rows=3,938 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
93. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201808 (cost=474.04..564.68 rows=1 width=282) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
94. 0.000 0.004 ↓ 0.0 0 1

BitmapAnd (cost=474.04..474.04 rows=23 width=0) (actual time=0.004..0.004 rows=0 loops=1)

95. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201808_user_id_idx (cost=0.00..206.90 rows=4,596 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
96. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201808_interaction_type_idx (cost=0.00..266.90 rows=4,596 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
97. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201809 (cost=401.05..475.92 rows=1 width=282) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
98. 0.001 0.006 ↓ 0.0 0 1

BitmapAnd (cost=401.05..401.05 rows=19 width=0) (actual time=0.006..0.006 rows=0 loops=1)

99. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201809_user_id_idx (cost=0.00..172.40 rows=3,730 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
100. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201809_interaction_type_idx (cost=0.00..228.40 rows=3,730 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
101. 0.002 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201810 (cost=434.15..512.98 rows=1 width=282) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
102. 0.000 0.004 ↓ 0.0 0 1

BitmapAnd (cost=434.15..434.15 rows=20 width=0) (actual time=0.004..0.004 rows=0 loops=1)

103. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201810_user_id_idx (cost=0.00..186.95 rows=4,070 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
104. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201810_interaction_type_idx (cost=0.00..246.95 rows=4,070 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
105. 0.000 0.010 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201811 (cost=242.79..286.15 rows=1 width=282) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
106. 0.000 0.010 ↓ 0.0 0 1

BitmapAnd (cost=242.79..242.79 rows=11 width=0) (actual time=0.010..0.010 rows=0 loops=1)

107. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201811_user_id_idx (cost=0.00..105.27 rows=2,246 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
108. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201811_interaction_type_idx (cost=0.00..137.27 rows=2,246 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
109. 0.002 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201812 (cost=243.40..286.77 rows=1 width=282) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
110. 0.001 0.005 ↓ 0.0 0 1

BitmapAnd (cost=243.40..243.40 rows=11 width=0) (actual time=0.005..0.005 rows=0 loops=1)

111. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201812_user_id_idx (cost=0.00..105.58 rows=2,287 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
112. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201812_interaction_type_idx (cost=0.00..137.58 rows=2,287 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
113. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201901 (cost=237.87..281.22 rows=1 width=282) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
114. 0.000 0.004 ↓ 0.0 0 1

BitmapAnd (cost=237.87..237.87 rows=11 width=0) (actual time=0.004..0.004 rows=0 loops=1)

115. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201901_user_id_idx (cost=0.00..104.81 rows=2,185 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
116. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201901_interaction_type_idx (cost=0.00..132.81 rows=2,185 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
117. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201902 (cost=219.37..258.78 rows=1 width=282) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
118. 0.000 0.006 ↓ 0.0 0 1

BitmapAnd (cost=219.37..219.37 rows=10 width=0) (actual time=0.006..0.006 rows=0 loops=1)

119. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201902_user_id_idx (cost=0.00..95.56 rows=2,018 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
120. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201902_interaction_type_idx (cost=0.00..123.56 rows=2,018 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
121. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201903 (cost=243.00..286.36 rows=1 width=282) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
122. 0.001 0.004 ↓ 0.0 0 1

BitmapAnd (cost=243.00..243.00 rows=11 width=0) (actual time=0.004..0.004 rows=0 loops=1)

123. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201903_user_id_idx (cost=0.00..105.37 rows=2,260 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
124. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201903_interaction_type_idx (cost=0.00..137.37 rows=2,260 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
125. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201904 (cost=261.74..309.04 rows=1 width=282) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
126. 0.000 0.006 ↓ 0.0 0 1

BitmapAnd (cost=261.74..261.74 rows=12 width=0) (actual time=0.006..0.006 rows=0 loops=1)

127. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201904_user_id_idx (cost=0.00..114.74 rows=2,443 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
128. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201904_interaction_type_idx (cost=0.00..146.75 rows=2,443 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
129. 0.003 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201905 (cost=279.96..331.19 rows=1 width=282) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
130. 0.000 0.004 ↓ 0.0 0 1

BitmapAnd (cost=279.96..279.96 rows=13 width=0) (actual time=0.004..0.004 rows=0 loops=1)

131. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201905_user_id_idx (cost=0.00..123.86 rows=2,591 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
132. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201905_interaction_type_idx (cost=0.00..155.86 rows=2,591 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
133. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201906 (cost=265.43..312.72 rows=1 width=282) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
134. 0.000 0.004 ↓ 0.0 0 1

BitmapAnd (cost=265.43..265.43 rows=12 width=0) (actual time=0.004..0.004 rows=0 loops=1)

135. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201906_user_id_idx (cost=0.00..114.59 rows=2,422 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
136. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201906_interaction_type_idx (cost=0.00..150.59 rows=2,422 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
137. 0.002 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201907 (cost=279.38..330.60 rows=1 width=282) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
138. 0.000 0.004 ↓ 0.0 0 1

BitmapAnd (cost=279.38..279.38 rows=13 width=0) (actual time=0.004..0.004 rows=0 loops=1)

139. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201907_user_id_idx (cost=0.00..123.56 rows=2,552 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
140. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201907_interaction_type_idx (cost=0.00..155.56 rows=2,552 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
141. 0.001 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201908 (cost=283.32..334.54 rows=1 width=282) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
142. 0.000 0.003 ↓ 0.0 0 1

BitmapAnd (cost=283.32..283.32 rows=13 width=0) (actual time=0.003..0.003 rows=0 loops=1)

143. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201908_user_id_idx (cost=0.00..123.53 rows=2,548 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
144. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201908_interaction_type_idx (cost=0.00..159.53 rows=2,548 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
145. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201909 (cost=308.32..363.50 rows=1 width=282) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
146. 0.000 0.006 ↓ 0.0 0 1

BitmapAnd (cost=308.32..308.32 rows=14 width=0) (actual time=0.006..0.006 rows=0 loops=1)

147. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on social_activity_interactions_201909_user_id_idx (cost=0.00..134.03 rows=2,881 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (user_id = 4,158)
148. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201909_interaction_type_idx (cost=0.00..174.03 rows=2,881 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
149. 0.214 123.687 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201910 (cost=307.60..362.78 rows=1 width=282) (actual time=123.687..123.687 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 299
  • Heap Blocks: exact=131
150. 0.132 123.473 ↓ 0.0 0 1

BitmapAnd (cost=307.60..307.60 rows=14 width=0) (actual time=123.473..123.473 rows=0 loops=1)

151. 0.022 0.022 ↑ 9.5 299 1

Bitmap Index Scan on social_activity_interactions_201910_user_id_idx (cost=0.00..133.67 rows=2,833 width=0) (actual time=0.021..0.022 rows=299 loops=1)

  • Index Cond: (user_id = 4,158)
152. 123.319 123.319 ↓ 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=123.319..123.319 rows=747,680 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
153. 0.029 132.400 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201911 (cost=316.38..387.33 rows=1 width=282) (actual time=132.400..132.400 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=7
154. 0.184 132.371 ↓ 0.0 0 1

BitmapAnd (cost=316.38..316.38 rows=18 width=0) (actual time=132.371..132.371 rows=0 loops=1)

155. 0.015 0.015 ↑ 263.2 14 1

Bitmap Index Scan on social_activity_interactions_201911_user_id_idx (cost=0.00..140.06 rows=3,685 width=0) (actual time=0.015..0.015 rows=14 loops=1)

  • Index Cond: (user_id = 4,158)
156. 132.172 132.172 ↓ 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=132.172..132.172 rows=739,811 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
157. 0.150 134.806 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_201912 (cost=330.25..405.13 rows=1 width=282) (actual time=134.806..134.806 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 144
  • Heap Blocks: exact=112
158. 0.199 134.656 ↓ 0.0 0 1

BitmapAnd (cost=330.25..330.25 rows=19 width=0) (actual time=134.656..134.656 rows=0 loops=1)

159. 0.024 0.024 ↑ 26.5 144 1

Bitmap Index Scan on social_activity_interactions_201912_user_id_idx (cost=0.00..145.00 rows=3,810 width=0) (actual time=0.024..0.024 rows=144 loops=1)

  • Index Cond: (user_id = 4,158)
160. 134.433 134.433 ↓ 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=134.432..134.433 rows=775,694 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
161. 0.142 58.174 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_202001 (cost=331.39..406.29 rows=1 width=282) (actual time=58.174..58.174 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 138
  • Heap Blocks: exact=99
162. 0.192 58.032 ↓ 0.0 0 1

BitmapAnd (cost=331.39..331.39 rows=19 width=0) (actual time=58.032..58.032 rows=0 loops=1)

163. 0.020 0.020 ↑ 28.2 138 1

Bitmap Index Scan on social_activity_interactions_202001_user_id_idx (cost=0.00..145.57 rows=3,886 width=0) (actual time=0.020..0.020 rows=138 loops=1)

  • Index Cond: (user_id = 4,158)
164. 57.820 57.820 ↓ 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=57.820..57.820 rows=785,132 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
165. 0.270 58.747 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_202002 (cost=340.95..419.77 rows=1 width=282) (actual time=58.747..58.747 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 251
  • Heap Blocks: exact=155
166. 0.201 58.477 ↓ 0.0 0 1

BitmapAnd (cost=340.95..340.95 rows=20 width=0) (actual time=58.477..58.477 rows=0 loops=1)

167. 0.025 0.025 ↑ 15.0 266 1

Bitmap Index Scan on social_activity_interactions_202002_user_id_idx (cost=0.00..150.35 rows=3,990 width=0) (actual time=0.025..0.025 rows=266 loops=1)

  • Index Cond: (user_id = 4,158)
168. 58.251 58.251 ↓ 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=58.250..58.251 rows=812,659 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
169. 0.184 42.988 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_202003 (cost=246.03..305.14 rows=1 width=282) (actual time=42.988..42.988 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 182
  • Heap Blocks: exact=149
170. 0.195 42.804 ↓ 0.0 0 1

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

171. 0.024 0.024 ↑ 16.5 182 1

Bitmap Index Scan on social_activity_interactions_202003_user_id_idx (cost=0.00..106.89 rows=2,995 width=0) (actual time=0.024..0.024 rows=182 loops=1)

  • Index Cond: (user_id = 4,158)
172. 42.585 42.585 ↓ 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=42.585..42.585 rows=588,281 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
173. 0.241 52.277 ↑ 1.0 1 1

Bitmap Heap Scan on social_interactions_202004 (cost=208.12..255.40 rows=1 width=282) (actual time=52.263..52.277 rows=1 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 191
  • Heap Blocks: exact=148
174. 0.200 52.036 ↓ 0.0 0 1

BitmapAnd (cost=208.12..208.12 rows=12 width=0) (actual time=52.036..52.036 rows=0 loops=1)

175. 0.027 0.027 ↑ 7.1 327 1

Bitmap Index Scan on social_activity_interactions_202004_user_id_idx (cost=0.00..77.94 rows=2,335 width=0) (actual time=0.027..0.027 rows=327 loops=1)

  • Index Cond: (user_id = 4,158)
176. 51.809 51.809 ↓ 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=51.809..51.809 rows=686,925 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
177. 0.273 47.980 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_202005 (cost=195.91..251.09 rows=1 width=282) (actual time=47.980..47.980 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 287
  • Heap Blocks: exact=202
178. 0.208 47.707 ↓ 0.0 0 1

BitmapAnd (cost=195.91..195.91 rows=14 width=0) (actual time=47.707..47.707 rows=0 loops=1)

179. 0.070 0.070 ↑ 4.4 656 1

Bitmap Index Scan on social_activity_interactions_202005_user_id_idx (cost=0.00..73.83 rows=2,854 width=0) (actual time=0.070..0.070 rows=656 loops=1)

  • Index Cond: (user_id = 4,158)
180. 47.429 47.429 ↓ 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=47.429..47.429 rows=618,963 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
181. 0.353 31.690 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_202006 (cost=129.20..156.77 rows=1 width=282) (actual time=31.690..31.690 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 305
  • Heap Blocks: exact=260
182. 0.022 31.337 ↓ 0.0 0 1

BitmapAnd (cost=129.20..129.20 rows=7 width=0) (actual time=31.336..31.337 rows=0 loops=1)

183. 0.041 0.041 ↑ 4.4 308 1

Bitmap Index Scan on social_interactions_202006_user_id_idx (cost=0.00..46.47 rows=1,340 width=0) (actual time=0.041..0.041 rows=308 loops=1)

  • Index Cond: (user_id = 4,158)
184. 31.274 31.274 ↓ 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=31.274..31.274 rows=422,259 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
185. 0.132 24.353 ↓ 0.0 0 1

Bitmap Heap Scan on social_interactions_202007 (cost=97.95..113.72 rows=1 width=282) (actual time=24.353..24.353 rows=0 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 89
  • Heap Blocks: exact=81
186. 0.012 24.221 ↓ 0.0 0 1

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

187. 0.033 0.033 ↑ 1.5 579 1

Bitmap Index Scan on social_interactions_202007_user_id_idx (cost=0.00..34.85 rows=857 width=0) (actual time=0.033..0.033 rows=579 loops=1)

  • Index Cond: (user_id = 4,158)
188. 24.176 24.176 ↓ 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=24.176..24.176 rows=330,113 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
189. 0.008 0.008 ↓ 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=282) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
  • Filter: ((NOT hide) AND (NOT seen) AND ((action_type)::text = 'comment'::text) AND (user_id = 4,158))
190. 0.019 0.019 ↓ 0.0 0 1

Index Scan using social_activities_pkey on social_activities (cost=0.43..8.45 rows=1 width=4) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (id = social_interactions_201609.social_activity_id)
  • Filter: ((page_uid)::text = '355871241641842'::text)
  • Rows Removed by Filter: 1
Planning time : 34.869 ms
Execution time : 717.877 ms