explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.002 34,568.707 ↑ 1.0 1 1

Limit (cost=11,479.84..11,479.85 rows=1 width=406) (actual time=34,568.707..34,568.707 rows=1 loops=1)

2. 0.028 34,568.705 ↑ 1.0 1 1

Sort (cost=11,479.84..11,479.85 rows=1 width=406) (actual time=34,568.705..34,568.705 rows=1 loops=1)

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

GroupAggregate (cost=11,479.81..11,479.83 rows=1 width=406) (actual time=34,568.676..34,568.677 rows=1 loops=1)

  • Group Key: social_activities.id
4. 0.046 34,568.647 ↓ 15.0 15 1

Sort (cost=11,479.81..11,479.81 rows=1 width=399) (actual time=34,568.645..34,568.647 rows=15 loops=1)

  • Sort Key: social_activities.id
  • Sort Method: quicksort Memory: 28kB
5. 3.029 34,568.601 ↓ 15.0 15 1

Nested Loop (cost=1,734.58..11,479.80 rows=1 width=399) (actual time=23,034.898..34,568.601 rows=15 loops=1)

  • Join Filter: (social_activities.id = social_interactions_201609.social_activity_id)
  • Rows Removed by Join Filter: 5,414
6. 2.258 7,955.640 ↓ 89.0 89 1

Nested Loop (cost=1,734.31..2,110.62 rows=1 width=394) (actual time=7,732.379..7,955.640 rows=89 loops=1)

  • Join Filter: ((social_activities.page_uid)::text = (social_credentials.active_page_id)::text)
  • Rows Removed by Join Filter: 15,414
7. 308.726 7,948.773 ↓ 419.0 419 1

Bitmap Heap Scan on social_activities (cost=1,734.31..2,097.92 rows=1 width=390) (actual time=7,641.036..7,948.773 rows=419 loops=1)

  • Recheck Cond: ((user_id = 4,158) AND ((processing_status)::text = 'sent'::text))
  • Rows Removed by Index Recheck: 326
  • Filter: ((social_network)::text = 'facebook'::text)
  • Rows Removed by Filter: 782
  • Heap Blocks: exact=904
8. 0.751 7,640.047 ↓ 0.0 0 1

BitmapAnd (cost=1,734.31..1,734.31 rows=92 width=0) (actual time=7,640.047..7,640.047 rows=0 loops=1)

9. 5.627 5.627 ↑ 11.8 1,565 1

Bitmap Index Scan on index_social_activities_on_user_id (cost=0.00..811.03 rows=18,480 width=0) (actual time=5.627..5.627 rows=1,565 loops=1)

  • Index Cond: (user_id = 4,158)
10. 7,633.669 7,633.669 ↓ 178.1 3,291,254 1

Bitmap Index Scan on index_social_activities_on_processing_status (cost=0.00..923.03 rows=18,480 width=0) (actual time=7,633.669..7,633.669 rows=3,291,254 loops=1)

  • Index Cond: ((processing_status)::text = 'sent'::text)
11. 4.609 4.609 ↑ 3.2 37 419

Seq Scan on social_credentials (cost=0.00..11.20 rows=120 width=36) (actual time=0.003..0.011 rows=37 loops=419)

12. 16.376 26,609.932 ↓ 1.3 61 89

Append (cost=0.27..9,368.58 rows=48 width=17) (actual time=40.960..298.988 rows=61 loops=89)

13. 1.246 1.246 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201609_user_id_idx on social_interactions_201609 (cost=0.27..8.58 rows=1 width=17) (actual time=0.014..0.014 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
14. 0.178 1.424 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201610 (cost=7.94..11.96 rows=1 width=17) (actual time=0.016..0.016 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND ((action_type)::text = 'comment'::text))
15. 0.089 1.246 ↓ 0.0 0 89

BitmapAnd (cost=7.94..7.94 rows=1 width=0) (actual time=0.014..0.014 rows=0 loops=89)

16. 1.157 1.157 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201610_user_id_idx (cost=0.00..3.31 rows=13 width=0) (actual time=0.013..0.013 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
17. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201610_interaction_type_idx (cost=0.00..4.38 rows=13 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
18. 0.089 1.513 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201611 (cost=8.30..12.32 rows=1 width=17) (actual time=0.017..0.017 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND ((action_type)::text = 'comment'::text))
19. 0.089 1.424 ↓ 0.0 0 89

BitmapAnd (cost=8.30..8.30 rows=1 width=0) (actual time=0.016..0.016 rows=0 loops=89)

20. 1.335 1.335 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201611_user_id_idx (cost=0.00..3.56 rows=28 width=0) (actual time=0.015..0.015 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
21. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201611_interaction_type_idx (cost=0.00..4.49 rows=28 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
22. 0.178 1.424 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201612 (cost=8.66..12.67 rows=1 width=17) (actual time=0.016..0.016 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text))
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND ((action_type)::text = 'comment'::text))
23. 0.089 1.246 ↓ 0.0 0 89

BitmapAnd (cost=8.66..8.66 rows=1 width=0) (actual time=0.014..0.014 rows=0 loops=89)

24. 1.157 1.157 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201612_user_id_idx (cost=0.00..3.75 rows=49 width=0) (actual time=0.013..0.013 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
25. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on social_activity_interactions_201612_interaction_type_idx (cost=0.00..4.65 rows=49 width=0) (never executed)

  • Index Cond: ((interaction_type)::text = 'SocialInteractions::Activity'::text)
26. 0.089 1.246 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201701 (cost=9.27..13.29 rows=1 width=17) (actual time=0.014..0.014 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
27. 0.089 1.157 ↓ 0.0 0 89

BitmapAnd (cost=9.27..9.27 rows=1 width=0) (actual time=0.013..0.013 rows=0 loops=89)

28. 1.068 1.068 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201701_user_id_idx (cost=0.00..4.11 rows=83 width=0) (actual time=0.012..0.012 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
29. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
30. 0.178 1.335 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201702 (cost=16.68..20.70 rows=1 width=17) (actual time=0.015..0.015 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
31. 0.089 1.157 ↓ 0.0 0 89

BitmapAnd (cost=16.68..16.68 rows=1 width=0) (actual time=0.013..0.013 rows=0 loops=89)

32. 1.068 1.068 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201702_user_id_idx (cost=0.00..7.33 rows=108 width=0) (actual time=0.012..0.012 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
33. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
34. 0.178 2.225 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201703 (cost=25.58..29.59 rows=1 width=17) (actual time=0.025..0.025 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
35. 0.089 2.047 ↓ 0.0 0 89

BitmapAnd (cost=25.58..25.58 rows=1 width=0) (actual time=0.023..0.023 rows=0 loops=89)

36. 1.958 1.958 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201703_user_id_idx (cost=0.00..11.47 rows=208 width=0) (actual time=0.022..0.022 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
37. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
38. 0.178 1.780 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201704 (cost=26.61..30.63 rows=1 width=17) (actual time=0.020..0.020 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
39. 0.089 1.602 ↓ 0.0 0 89

BitmapAnd (cost=26.61..26.61 rows=1 width=0) (actual time=0.018..0.018 rows=0 loops=89)

40. 1.513 1.513 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201704_user_id_idx (cost=0.00..12.00 rows=260 width=0) (actual time=0.017..0.017 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
41. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
42. 0.089 1.780 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201705 (cost=34.61..42.47 rows=1 width=17) (actual time=0.020..0.020 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
43. 0.089 1.691 ↓ 0.0 0 89

BitmapAnd (cost=34.61..34.61 rows=2 width=0) (actual time=0.019..0.019 rows=0 loops=89)

44. 1.602 1.602 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201705_user_id_idx (cost=0.00..15.60 rows=313 width=0) (actual time=0.018..0.018 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
45. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
46. 0.089 1.869 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201706 (cost=42.73..50.61 rows=1 width=17) (actual time=0.021..0.021 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
47. 0.089 1.780 ↓ 0.0 0 89

BitmapAnd (cost=42.73..42.73 rows=2 width=0) (actual time=0.020..0.020 rows=0 loops=89)

48. 1.691 1.691 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201706_user_id_idx (cost=0.00..19.17 rows=385 width=0) (actual time=0.019..0.019 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
49. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
50. 0.178 1.958 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201707 (cost=42.78..50.66 rows=1 width=17) (actual time=0.022..0.022 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
51. 0.089 1.780 ↓ 0.0 0 89

BitmapAnd (cost=42.78..42.78 rows=2 width=0) (actual time=0.020..0.020 rows=0 loops=89)

52. 1.691 1.691 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201707_user_id_idx (cost=0.00..19.25 rows=382 width=0) (actual time=0.019..0.019 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
53. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
54. 0.089 1.780 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201708 (cost=59.61..71.42 rows=1 width=17) (actual time=0.020..0.020 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
55. 0.089 1.691 ↓ 0.0 0 89

BitmapAnd (cost=59.61..59.61 rows=3 width=0) (actual time=0.019..0.019 rows=0 loops=89)

56. 1.602 1.602 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201708_user_id_idx (cost=0.00..26.83 rows=548 width=0) (actual time=0.018..0.018 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
57. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
58. 0.178 2.403 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201709 (cost=58.94..66.84 rows=1 width=17) (actual time=0.027..0.027 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
59. 0.000 2.225 ↓ 0.0 0 89

BitmapAnd (cost=58.94..58.94 rows=2 width=0) (actual time=0.025..0.025 rows=0 loops=89)

60. 2.225 2.225 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201709_user_id_idx (cost=0.00..26.53 rows=499 width=0) (actual time=0.025..0.025 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
61. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
62. 0.089 1.780 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201710 (cost=81.55..97.30 rows=1 width=17) (actual time=0.020..0.020 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
63. 0.089 1.691 ↓ 0.0 0 89

BitmapAnd (cost=81.55..81.55 rows=4 width=0) (actual time=0.019..0.019 rows=0 loops=89)

64. 1.602 1.602 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201710_user_id_idx (cost=0.00..35.13 rows=766 width=0) (actual time=0.018..0.018 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
65. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
66. 0.178 2.047 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201711 (cost=100.45..116.22 rows=1 width=17) (actual time=0.023..0.023 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
67. 0.089 1.869 ↓ 0.0 0 89

BitmapAnd (cost=100.45..100.45 rows=4 width=0) (actual time=0.021..0.021 rows=0 loops=89)

68. 1.780 1.780 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201711_user_id_idx (cost=0.00..45.37 rows=855 width=0) (actual time=0.020..0.020 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
69. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
70. 0.089 1.869 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201712 (cost=126.00..149.63 rows=1 width=17) (actual time=0.021..0.021 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
71. 0.089 1.780 ↓ 0.0 0 89

BitmapAnd (cost=126.00..126.00 rows=6 width=0) (actual time=0.020..0.020 rows=0 loops=89)

72. 1.691 1.691 ↓ 0.0 0 89

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

  • Index Cond: (user_id = social_credentials.user_id)
73. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
74. 0.089 2.314 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201801 (cost=143.98..171.55 rows=1 width=17) (actual time=0.026..0.026 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
75. 0.089 2.225 ↓ 0.0 0 89

BitmapAnd (cost=143.98..143.98 rows=7 width=0) (actual time=0.025..0.025 rows=0 loops=89)

76. 2.136 2.136 ↓ 0.0 0 89

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

  • Index Cond: (user_id = social_credentials.user_id)
77. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
78. 0.178 1.958 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201802 (cost=188.56..231.89 rows=1 width=17) (actual time=0.022..0.022 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
79. 0.000 1.780 ↓ 0.0 0 89

BitmapAnd (cost=188.56..188.56 rows=11 width=0) (actual time=0.020..0.020 rows=0 loops=89)

80. 1.780 1.780 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201802_user_id_idx (cost=0.00..83.97 rows=2,122 width=0) (actual time=0.020..0.020 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
81. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
82. 0.089 1.958 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201803 (cost=206.72..254.00 rows=1 width=17) (actual time=0.022..0.022 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
83. 0.089 1.869 ↓ 0.0 0 89

BitmapAnd (cost=206.72..206.72 rows=12 width=0) (actual time=0.021..0.021 rows=0 loops=89)

84. 1.780 1.780 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201803_user_id_idx (cost=0.00..92.28 rows=2,368 width=0) (actual time=0.020..0.020 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
85. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
86. 0.178 1.869 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201804 (cost=238.31..293.49 rows=1 width=17) (actual time=0.021..0.021 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
87. 0.000 1.691 ↓ 0.0 0 89

BitmapAnd (cost=238.31..238.31 rows=14 width=0) (actual time=0.019..0.019 rows=0 loops=89)

88. 1.691 1.691 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201804_user_id_idx (cost=0.00..108.46 rows=2,823 width=0) (actual time=0.019..0.019 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
89. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
90. 0.089 1.869 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201805 (cost=305.31..376.26 rows=1 width=17) (actual time=0.021..0.021 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
91. 0.089 1.780 ↓ 0.0 0 89

BitmapAnd (cost=305.31..305.31 rows=18 width=0) (actual time=0.020..0.020 rows=0 loops=89)

92. 1.691 1.691 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201805_user_id_idx (cost=0.00..140.91 rows=3,696 width=0) (actual time=0.019..0.019 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
93. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
94. 0.089 1.869 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201806 (cost=278.44..345.43 rows=1 width=17) (actual time=0.021..0.021 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
95. 0.089 1.780 ↓ 0.0 0 89

BitmapAnd (cost=278.44..278.44 rows=17 width=0) (actual time=0.020..0.020 rows=0 loops=89)

96. 1.691 1.691 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201806_user_id_idx (cost=0.00..128.61 rows=3,354 width=0) (actual time=0.019..0.019 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
97. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
98. 0.089 1.869 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201807 (cost=316.07..394.88 rows=1 width=17) (actual time=0.021..0.021 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
99. 0.089 1.780 ↓ 0.0 0 89

BitmapAnd (cost=316.07..316.07 rows=20 width=0) (actual time=0.020..0.020 rows=0 loops=89)

100. 1.691 1.691 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201807_user_id_idx (cost=0.00..145.86 rows=3,938 width=0) (actual time=0.019..0.019 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
101. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
102. 0.089 1.780 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201808 (cost=372.44..463.08 rows=1 width=17) (actual time=0.020..0.020 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
103. 0.089 1.691 ↓ 0.0 0 89

BitmapAnd (cost=372.44..372.44 rows=23 width=0) (actual time=0.019..0.019 rows=0 loops=89)

104. 1.602 1.602 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201808_user_id_idx (cost=0.00..173.30 rows=4,596 width=0) (actual time=0.018..0.018 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
105. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
106. 0.178 1.958 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201809 (cost=313.08..387.95 rows=1 width=17) (actual time=0.022..0.022 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
107. 0.000 1.780 ↓ 0.0 0 89

BitmapAnd (cost=313.08..313.08 rows=19 width=0) (actual time=0.020..0.020 rows=0 loops=89)

108. 1.780 1.780 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201809_user_id_idx (cost=0.00..144.43 rows=3,730 width=0) (actual time=0.020..0.020 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
109. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
110. 0.178 1.869 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201810 (cost=339.82..418.65 rows=1 width=17) (actual time=0.021..0.021 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
111. 0.000 1.691 ↓ 0.0 0 89

BitmapAnd (cost=339.82..339.82 rows=20 width=0) (actual time=0.019..0.019 rows=0 loops=89)

112. 1.691 1.691 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201810_user_id_idx (cost=0.00..156.62 rows=4,070 width=0) (actual time=0.019..0.019 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
113. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
114. 0.178 1.780 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201811 (cost=189.55..232.91 rows=1 width=17) (actual time=0.020..0.020 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
115. 0.089 1.602 ↓ 0.0 0 89

BitmapAnd (cost=189.55..189.55 rows=11 width=0) (actual time=0.018..0.018 rows=0 loops=89)

116. 1.513 1.513 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201811_user_id_idx (cost=0.00..88.03 rows=2,246 width=0) (actual time=0.017..0.017 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
117. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
118. 0.089 1.869 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201812 (cost=190.23..233.60 rows=1 width=17) (actual time=0.021..0.021 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
119. 0.089 1.780 ↓ 0.0 0 89

BitmapAnd (cost=190.23..190.23 rows=11 width=0) (actual time=0.020..0.020 rows=0 loops=89)

120. 1.691 1.691 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201812_user_id_idx (cost=0.00..88.41 rows=2,287 width=0) (actual time=0.019..0.019 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
121. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
122. 0.089 1.780 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201901 (cost=184.50..227.85 rows=1 width=17) (actual time=0.020..0.020 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
123. 0.089 1.691 ↓ 0.0 0 89

BitmapAnd (cost=184.50..184.50 rows=11 width=0) (actual time=0.019..0.019 rows=0 loops=89)

124. 1.602 1.602 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201901_user_id_idx (cost=0.00..87.44 rows=2,185 width=0) (actual time=0.018..0.018 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
125. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
126. 0.089 1.691 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201902 (cost=171.63..211.05 rows=1 width=17) (actual time=0.019..0.019 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
127. 0.089 1.602 ↓ 0.0 0 89

BitmapAnd (cost=171.63..171.63 rows=10 width=0) (actual time=0.018..0.018 rows=0 loops=89)

128. 1.513 1.513 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201902_user_id_idx (cost=0.00..79.82 rows=2,018 width=0) (actual time=0.017..0.017 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
129. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
130. 0.089 1.869 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201903 (cost=189.83..233.19 rows=1 width=17) (actual time=0.021..0.021 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
131. 0.089 1.780 ↓ 0.0 0 89

BitmapAnd (cost=189.83..189.83 rows=11 width=0) (actual time=0.020..0.020 rows=0 loops=89)

132. 1.691 1.691 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201903_user_id_idx (cost=0.00..88.21 rows=2,260 width=0) (actual time=0.019..0.019 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
133. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
134. 0.178 2.314 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201904 (cost=206.97..254.27 rows=1 width=17) (actual time=0.026..0.026 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
135. 0.089 2.136 ↓ 0.0 0 89

BitmapAnd (cost=206.97..206.97 rows=12 width=0) (actual time=0.024..0.024 rows=0 loops=89)

136. 2.047 2.047 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201904_user_id_idx (cost=0.00..95.98 rows=2,443 width=0) (actual time=0.023..0.023 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
137. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
138. 0.089 1.691 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201905 (cost=223.56..274.79 rows=1 width=17) (actual time=0.019..0.019 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
139. 0.089 1.602 ↓ 0.0 0 89

BitmapAnd (cost=223.56..223.56 rows=13 width=0) (actual time=0.018..0.018 rows=0 loops=89)

140. 1.513 1.513 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201905_user_id_idx (cost=0.00..103.45 rows=2,591 width=0) (actual time=0.017..0.017 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
141. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
142. 0.178 1.869 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201906 (cost=210.76..258.06 rows=1 width=17) (actual time=0.021..0.021 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
143. 0.089 1.691 ↓ 0.0 0 89

BitmapAnd (cost=210.76..210.76 rows=12 width=0) (actual time=0.019..0.019 rows=0 loops=89)

144. 1.602 1.602 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201906_user_id_idx (cost=0.00..95.92 rows=2,422 width=0) (actual time=0.018..0.018 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
145. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
146. 0.089 1.869 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201907 (cost=218.91..270.13 rows=1 width=17) (actual time=0.021..0.021 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
147. 0.089 1.780 ↓ 0.0 0 89

BitmapAnd (cost=218.91..218.91 rows=13 width=0) (actual time=0.020..0.020 rows=0 loops=89)

148. 1.691 1.691 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201907_user_id_idx (cost=0.00..103.10 rows=2,552 width=0) (actual time=0.019..0.019 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
149. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
150. 0.089 1.780 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201908 (cost=222.92..274.14 rows=1 width=17) (actual time=0.020..0.020 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
151. 0.089 1.691 ↓ 0.0 0 89

BitmapAnd (cost=222.92..222.92 rows=13 width=0) (actual time=0.019..0.019 rows=0 loops=89)

152. 1.602 1.602 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201908_user_id_idx (cost=0.00..103.13 rows=2,548 width=0) (actual time=0.018..0.018 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
153. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
154. 0.178 1.780 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201909 (cost=242.45..297.64 rows=1 width=17) (actual time=0.020..0.020 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
155. 0.089 1.602 ↓ 0.0 0 89

BitmapAnd (cost=242.45..242.45 rows=14 width=0) (actual time=0.018..0.018 rows=0 loops=89)

156. 1.513 1.513 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201909_user_id_idx (cost=0.00..112.17 rows=2,881 width=0) (actual time=0.017..0.017 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
157. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id IS NULL)
158. 76.095 3,634.582 ↓ 3.0 3 89

Bitmap Heap Scan on social_interactions_201910 (cost=241.70..296.88 rows=1 width=17) (actual time=40.113..40.838 rows=3 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 295
  • Heap Blocks: exact=11,659
159. 1.335 3,558.487 ↓ 0.0 0 89

BitmapAnd (cost=241.70..241.70 rows=14 width=0) (actual time=39.983..39.983 rows=0 loops=89)

160. 5.073 5.073 ↑ 9.5 299 89

Bitmap Index Scan on social_activity_interactions_201910_user_id_idx (cost=0.00..111.77 rows=2,833 width=0) (actual time=0.057..0.057 rows=299 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
161. 3,552.079 3,552.079 ↓ 263.8 747,333 89

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

  • Index Cond: (parent_id IS NULL)
162. 2.225 3,841.774 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201911 (cost=250.38..321.33 rows=1 width=17) (actual time=43.166..43.166 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=623
163. 0.445 3,839.549 ↓ 0.0 0 89

BitmapAnd (cost=250.38..250.38 rows=18 width=0) (actual time=43.141..43.141 rows=0 loops=89)

164. 2.314 2.314 ↑ 263.2 14 89

Bitmap Index Scan on social_activity_interactions_201911_user_id_idx (cost=0.00..118.06 rows=3,685 width=0) (actual time=0.026..0.026 rows=14 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
165. 3,836.790 3,836.790 ↓ 200.7 739,401 89

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

  • Index Cond: (parent_id IS NULL)
166. 15.486 2,823.614 ↓ 2.0 2 89

Bitmap Heap Scan on social_interactions_201912 (cost=259.55..334.43 rows=1 width=17) (actual time=31.684..31.726 rows=2 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 142
  • Heap Blocks: exact=9,968
167. 1.157 2,808.128 ↓ 0.0 0 89

BitmapAnd (cost=259.55..259.55 rows=19 width=0) (actual time=31.552..31.552 rows=0 loops=89)

168. 3.560 3.560 ↑ 26.5 144 89

Bitmap Index Scan on social_activity_interactions_201912_user_id_idx (cost=0.00..122.30 rows=3,810 width=0) (actual time=0.040..0.040 rows=144 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
169. 2,803.411 2,803.411 ↓ 203.5 775,256 89

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

  • Index Cond: (parent_id IS NULL)
170. 14.062 2,873.454 ↓ 4.0 4 89

Bitmap Heap Scan on social_interactions_202001 (cost=264.72..339.62 rows=1 width=17) (actual time=32.181..32.286 rows=4 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 134
  • Heap Blocks: exact=8,811
171. 1.068 2,859.392 ↓ 0.0 0 89

BitmapAnd (cost=264.72..264.72 rows=19 width=0) (actual time=32.128..32.128 rows=0 loops=89)

172. 3.827 3.827 ↑ 28.2 138 89

Bitmap Index Scan on social_activity_interactions_202001_user_id_idx (cost=0.00..122.90 rows=3,886 width=0) (actual time=0.043..0.043 rows=138 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
173. 2,854.497 2,854.497 ↓ 201.9 784,673 89

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

  • Index Cond: (parent_id IS NULL)
174. 22.517 2,935.665 ↓ 20.0 20 89

Bitmap Heap Scan on social_interactions_202002 (cost=273.55..352.37 rows=1 width=17) (actual time=32.758..32.985 rows=20 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 221
  • Heap Blocks: exact=13,795
175. 1.513 2,913.148 ↓ 0.0 0 89

BitmapAnd (cost=273.55..273.55 rows=20 width=0) (actual time=32.732..32.732 rows=0 loops=89)

176. 8.722 8.722 ↑ 15.0 266 89

Bitmap Index Scan on social_activity_interactions_202002_user_id_idx (cost=0.00..126.95 rows=3,990 width=0) (actual time=0.098..0.098 rows=266 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
177. 2,902.913 2,902.913 ↓ 203.5 812,088 89

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

  • Index Cond: (parent_id IS NULL)
178. 19.046 2,133.953 ↓ 5.0 5 89

Bitmap Heap Scan on social_interactions_202003 (cost=197.66..256.77 rows=1 width=17) (actual time=23.795..23.977 rows=5 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 177
  • Heap Blocks: exact=13,261
179. 1.513 2,114.907 ↓ 0.0 0 89

BitmapAnd (cost=197.66..197.66 rows=15 width=0) (actual time=23.763..23.763 rows=0 loops=89)

180. 3.738 3.738 ↑ 16.5 182 89

Bitmap Index Scan on social_activity_interactions_202003_user_id_idx (cost=0.00..90.52 rows=2,995 width=0) (actual time=0.042..0.042 rows=182 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
181. 2,109.656 2,109.656 ↓ 196.3 587,940 89

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

  • Index Cond: (parent_id IS NULL)
182. 19.224 2,709.516 ↓ 23.0 23 89

Bitmap Heap Scan on social_interactions_202004 (cost=144.19..191.47 rows=1 width=17) (actual time=30.262..30.444 rows=23 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 158
  • Heap Blocks: exact=12,905
183. 1.780 2,690.292 ↓ 0.0 0 89

BitmapAnd (cost=144.19..144.19 rows=12 width=0) (actual time=30.228..30.228 rows=0 loops=89)

184. 4.094 4.094 ↑ 7.1 327 89

Bitmap Index Scan on social_activity_interactions_202004_user_id_idx (cost=0.00..66.00 rows=2,335 width=0) (actual time=0.046..0.046 rows=327 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
185. 2,684.418 2,684.418 ↓ 314.1 733,456 89

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

  • Index Cond: (parent_id IS NULL)
186. 29.815 2,534.542 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_202005 (cost=133.58..188.76 rows=1 width=17) (actual time=28.478..28.478 rows=0 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 287
  • Heap Blocks: exact=17,978
187. 2.225 2,504.727 ↓ 0.0 0 89

BitmapAnd (cost=133.58..133.58 rows=14 width=0) (actual time=28.143..28.143 rows=0 loops=89)

188. 7.031 7.031 ↑ 4.4 656 89

Bitmap Index Scan on social_activity_interactions_202005_user_id_idx (cost=0.00..63.50 rows=2,854 width=0) (actual time=0.079..0.079 rows=656 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
189. 2,495.471 2,495.471 ↓ 235.3 671,668 89

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

  • Index Cond: (parent_id IS NULL)
190. 30.794 1,663.232 ↑ 1.0 1 89

Bitmap Heap Scan on social_interactions_202006 (cost=86.13..113.70 rows=1 width=17) (actual time=18.381..18.688 rows=1 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 304
  • Heap Blocks: exact=23,140
191. 1.780 1,632.438 ↓ 0.0 0 89

BitmapAnd (cost=86.13..86.13 rows=7 width=0) (actual time=18.342..18.342 rows=0 loops=89)

192. 6.675 6.675 ↑ 4.4 308 89

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

  • Index Cond: (user_id = social_credentials.user_id)
193. 1,623.983 1,623.983 ↓ 322.6 432,306 89

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

  • Index Cond: (parent_id IS NULL)
194. 14.952 1,375.584 ↓ 3.0 3 89

Bitmap Heap Scan on social_interactions_202007 (cost=64.48..80.25 rows=1 width=17) (actual time=15.329..15.456 rows=3 loops=89)

  • Recheck Cond: ((user_id = social_credentials.user_id) AND (parent_id IS NULL))
  • Filter: ((NOT hide) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 86
  • Heap Blocks: exact=7,209
195. 0.979 1,360.632 ↓ 0.0 0 89

BitmapAnd (cost=64.48..64.48 rows=4 width=0) (actual time=15.288..15.288 rows=0 loops=89)

196. 5.340 5.340 ↑ 1.5 579 89

Bitmap Index Scan on social_interactions_202007_user_id_idx (cost=0.00..29.38 rows=857 width=0) (actual time=0.060..0.060 rows=579 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
197. 1,354.313 1,354.313 ↓ 431.6 369,919 89

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

  • Index Cond: (parent_id IS NULL)
198. 0.356 0.356 ↓ 0.0 0 89

Index Scan using social_interactions_202008_user_id_idx on social_interactions_202008 (cost=0.15..3.04 rows=1 width=17) (actual time=0.004..0.004 rows=0 loops=89)

  • Index Cond: (user_id = social_credentials.user_id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
Planning time : 289.209 ms
Execution time : 34,570.328 ms