explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4SUt

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 8.242 ↓ 0.0 0 1

Limit (cost=6,004.70..6,004.70 rows=1 width=298) (actual time=8.242..8.242 rows=0 loops=1)

2. 0.011 8.241 ↓ 0.0 0 1

Sort (cost=6,004.70..6,004.70 rows=1 width=298) (actual time=8.241..8.241 rows=0 loops=1)

  • Sort Key: (CASE WHEN (sum(CASE WHEN social_interactions_201609.seen THEN 0 ELSE 1 END) > 0) THEN 1 ELSE 0 END) DESC, (max(social_interactions_201609.action_date)) DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.001 8.230 ↓ 0.0 0 1

GroupAggregate (cost=6,004.66..6,004.69 rows=1 width=298) (actual time=8.230..8.230 rows=0 loops=1)

  • Group Key: social_activities.id
4. 0.007 8.229 ↓ 0.0 0 1

Sort (cost=6,004.66..6,004.67 rows=1 width=287) (actual time=8.229..8.229 rows=0 loops=1)

  • Sort Key: social_activities.id
  • Sort Method: quicksort Memory: 25kB
5. 0.001 8.222 ↓ 0.0 0 1

Nested Loop (cost=38.58..6,004.65 rows=1 width=287) (actual time=8.222..8.222 rows=0 loops=1)

6. 0.176 8.221 ↓ 0.0 0 1

Nested Loop (cost=38.30..5,996.34 rows=1 width=291) (actual time=8.221..8.221 rows=0 loops=1)

7. 0.132 1.993 ↓ 89.0 89 1

Nested Loop (cost=35.52..3,626.42 rows=1 width=282) (actual time=0.829..1.993 rows=89 loops=1)

  • Join Filter: ((social_activities.page_uid)::text = (social_credentials.active_page_id)::text)
  • Rows Removed by Join Filter: 330
8. 0.019 0.019 ↑ 1.0 1 1

Seq Scan on social_credentials (cost=0.00..3.46 rows=1 width=20) (actual time=0.014..0.019 rows=1 loops=1)

  • Filter: (user_id = 4,158)
  • Rows Removed by Filter: 36
9. 1.552 1.842 ↓ 5.7 419 1

Bitmap Heap Scan on social_activities (cost=35.52..3,622.04 rows=73 width=278) (actual time=0.396..1.842 rows=419 loops=1)

  • Recheck Cond: (user_id = 4,158)
  • Filter: ((created_at >= '2019-10-02 08:00:56.320847'::timestamp without time zone) AND ((social_network)::text = 'facebook'::text) AND ((processing_status)::text = 'sent'::text))
  • Rows Removed by Filter: 1,146
  • Heap Blocks: exact=934
10. 0.290 0.290 ↓ 1.7 1,565 1

Bitmap Index Scan on index_social_activities_on_user_id (cost=0.00..35.50 rows=943 width=0) (actual time=0.290..0.290 rows=1,565 loops=1)

  • Index Cond: (user_id = 4,158)
11. 0.979 6.052 ↓ 0.0 0 89

Append (cost=2.78..2,369.45 rows=48 width=13) (actual time=0.068..0.068 rows=0 loops=89)

12. 0.089 0.267 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201609 (cost=2.78..12.21 rows=1 width=13) (actual time=0.003..0.003 rows=0 loops=89)

  • Recheck Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
13. 0.178 0.178 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201609_social_activity_id_idx (cost=0.00..2.78 rows=5 width=0) (actual time=0.002..0.002 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
14. 0.000 0.089 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201610 (cost=3.31..25.83 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

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

Bitmap Index Scan on social_activity_interactions_201610_social_activity_id_idx (cost=0.00..3.31 rows=9 width=0) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
16. 0.000 0.089 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201611 (cost=3.48..27.84 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Recheck Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
17. 0.089 0.089 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201611_social_activity_id_idx (cost=0.00..3.48 rows=9 width=0) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
18. 0.000 0.089 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201612 (cost=3.59..28.88 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

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

Bitmap Index Scan on social_activity_interactions_201612_social_activity_id_idx (cost=0.00..3.59 rows=9 width=0) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
20. 0.000 0.089 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201701 (cost=3.71..33.19 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Recheck Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
21. 0.089 0.089 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201701_social_activity_id_idx (cost=0.00..3.70 rows=10 width=0) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
22. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201702_social_activity_id_idx on social_interactions_201702 (cost=0.29..36.70 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
23. 0.000 0.089 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201703 (cost=4.26..53.03 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Recheck Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
24. 0.089 0.089 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201703_social_activity_id_idx (cost=0.00..4.26 rows=16 width=0) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
25. 0.000 0.089 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201704 (cost=4.32..53.46 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Recheck Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
26. 0.089 0.089 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201704_social_activity_id_idx (cost=0.00..4.32 rows=16 width=0) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
27. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201705_social_activity_id_idx on social_interactions_201705 (cost=0.42..55.85 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
28. 0.000 0.089 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201706 (cost=4.36..50.31 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Recheck Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
29. 0.089 0.089 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201706_social_activity_id_idx (cost=0.00..4.36 rows=14 width=0) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
30. 0.089 0.178 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201707 (cost=4.42..50.36 rows=1 width=13) (actual time=0.002..0.002 rows=0 loops=89)

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

Bitmap Index Scan on social_activity_interactions_201707_social_activity_id_idx (cost=0.00..4.42 rows=14 width=0) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
32. 0.000 0.089 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201708 (cost=4.40..46.92 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Recheck Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
33. 0.089 0.089 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201708_social_activity_id_idx (cost=0.00..4.40 rows=12 width=0) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
34. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201709_social_activity_id_idx on social_interactions_201709 (cost=0.42..55.33 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
35. 0.178 0.178 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201710_social_activity_id_idx on social_interactions_201710 (cost=0.42..89.72 rows=1 width=13) (actual time=0.002..0.002 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
36. 0.000 0.089 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201711 (cost=4.56..89.18 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Recheck Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
37. 0.089 0.089 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201711_social_activity_id_idx (cost=0.00..4.56 rows=25 width=0) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
38. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201712_social_activity_id_idx on social_interactions_201712 (cost=0.42..101.11 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
39. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201801_social_activity_id_idx on social_interactions_201801 (cost=0.42..81.89 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
40. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201802_social_activity_id_idx on social_interactions_201802 (cost=0.42..104.49 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
41. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201803_social_activity_id_idx on social_interactions_201803 (cost=0.42..106.64 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
42. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201804_social_activity_id_idx on social_interactions_201804 (cost=0.42..77.51 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
43. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201805_social_activity_id_idx on social_interactions_201805 (cost=0.42..89.07 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
44. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201806_social_activity_id_idx on social_interactions_201806 (cost=0.42..71.91 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
45. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201807_social_activity_id_idx on social_interactions_201807 (cost=0.42..55.26 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
46. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201808_social_activity_id_idx on social_interactions_201808 (cost=0.43..67.55 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
47. 0.178 0.178 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201809_social_activity_id_idx on social_interactions_201809 (cost=0.42..79.95 rows=1 width=13) (actual time=0.002..0.002 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
48. 0.178 0.178 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201810_social_activity_id_idx on social_interactions_201810 (cost=0.43..85.91 rows=1 width=13) (actual time=0.002..0.002 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
49. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201811_social_activity_id_idx on social_interactions_201811 (cost=0.42..40.82 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
50. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201812_social_activity_id_idx on social_interactions_201812 (cost=0.42..37.76 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
51. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201901_social_activity_id_idx on social_interactions_201901 (cost=0.42..33.41 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
52. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201902_social_activity_id_idx on social_interactions_201902 (cost=0.42..35.75 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
53. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201903_social_activity_id_idx on social_interactions_201903 (cost=0.42..31.66 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
54. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201904_social_activity_id_idx on social_interactions_201904 (cost=0.42..36.37 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
55. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201905_social_activity_id_idx on social_interactions_201905 (cost=0.42..33.60 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
56. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201906_social_activity_id_idx on social_interactions_201906 (cost=0.42..34.30 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
57. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201907_social_activity_id_idx on social_interactions_201907 (cost=0.42..35.17 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
58. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201908_social_activity_id_idx on social_interactions_201908 (cost=0.42..34.58 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
59. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201909_social_activity_id_idx on social_interactions_201909 (cost=0.42..37.10 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
60. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201910_social_activity_id_idx on social_interactions_201910 (cost=0.42..26.78 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
61. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201911_social_activity_id_idx on social_interactions_201911 (cost=0.42..42.59 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
62. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201912_social_activity_id_idx on social_interactions_201912 (cost=0.42..38.40 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
63. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_202001_social_activity_id_idx on social_interactions_202001 (cost=0.42..39.22 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
64. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_202002_social_activity_id_idx on social_interactions_202002 (cost=0.42..42.79 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 0
65. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_202003_social_activity_id_idx on social_interactions_202003 (cost=0.42..34.43 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
66. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_202004_social_activity_id_idx on social_interactions_202004 (cost=0.42..29.90 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
67. 0.178 0.178 ↓ 0.0 0 89

Index Scan using social_activity_interactions_202005_social_activity_id_idx on social_interactions_202005 (cost=0.42..26.62 rows=1 width=13) (actual time=0.002..0.002 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
68. 0.178 0.178 ↓ 0.0 0 89

Index Scan using social_interactions_202006_social_activity_id_idx on social_interactions_202006 (cost=0.42..35.17 rows=1 width=13) (actual time=0.002..0.002 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 0
69. 0.178 0.178 ↓ 0.0 0 89

Index Scan using social_interactions_202007_social_activity_id_idx on social_interactions_202007 (cost=0.42..29.57 rows=1 width=13) (actual time=0.002..0.002 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
  • Rows Removed by Filter: 0
70. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_interactions_202008_social_activity_id_idx on social_interactions_202008 (cost=0.15..3.07 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=89)

  • Index Cond: (social_activity_id = social_activities.id)
  • Filter: ((NOT hide) AND (parent_id IS NULL) AND (NOT seen) AND ((interaction_type)::text = 'SocialInteractions::Activity'::text) AND ((action_type)::text = 'comment'::text))
71. 0.000 0.000 ↓ 0.0 0

Index Only Scan using users_pkey on users (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: (id = 4,158)
  • Heap Fetches: 0
Planning time : 6.282 ms
Execution time : 9.212 ms