explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SFow

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 12.616 ↓ 0.0 0 1

Limit (cost=191,021.60..191,021.60 rows=1 width=298) (actual time=12.616..12.616 rows=0 loops=1)

2. 0.010 12.614 ↓ 0.0 0 1

Sort (cost=191,021.60..191,021.60 rows=1 width=298) (actual time=12.614..12.614 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.002 12.604 ↓ 0.0 0 1

GroupAggregate (cost=191,021.56..191,021.59 rows=1 width=298) (actual time=12.604..12.604 rows=0 loops=1)

  • Group Key: social_activities.id
4. 0.028 12.602 ↓ 0.0 0 1

Sort (cost=191,021.56..191,021.57 rows=1 width=287) (actual time=12.602..12.602 rows=0 loops=1)

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

Nested Loop (cost=3.17..191,021.55 rows=1 width=287) (actual time=12.574..12.574 rows=0 loops=1)

6. 1.969 1.969 ↑ 1.0 1 1

Seq Scan on users (cost=0.00..1,341.01 rows=1 width=4) (actual time=1.170..1.969 rows=1 loops=1)

  • Filter: (id = 4,158)
  • Rows Removed by Filter: 6,000
7. 0.199 10.602 ↓ 0.0 0 1

Nested Loop (cost=3.17..189,680.53 rows=1 width=291) (actual time=10.602..10.602 rows=0 loops=1)

8. 0.285 1.859 ↓ 1.1 89 1

Nested Loop (cost=0.43..3,782.30 rows=82 width=282) (actual time=0.059..1.859 rows=89 loops=1)

  • Join Filter: CASE WHEN ((social_activities.social_network)::text = 'google'::text) THEN ((social_activities.page_uid)::text = (social_credentials.gmb_location_id)::text) WHEN ((social_activities.social_network)::text = 'facebook'::text) THEN ((social_activities.page_uid)::text = (social_credentials.active_page_id)::text) ELSE ((social_activities.page_uid)::text = (social_credentials.uid)::text) END
  • Rows Removed by Join Filter: 330
9. 1.574 1.574 ↓ 2.5 419 1

Index Scan using index_social_activities_on_user_id on social_activities (cost=0.43..3,774.71 rows=165 width=278) (actual time=0.030..1.574 rows=419 loops=1)

  • Index Cond: (user_id = 4,158)
  • Filter: (((social_network)::text = 'facebook'::text) AND ((processing_status)::text = 'sent'::text))
  • Rows Removed by Filter: 1,146
10. 0.000 0.000 ↑ 1.0 1 419

Materialize (cost=0.00..3.47 rows=1 width=68) (actual time=0.000..0.000 rows=1 loops=419)

11. 0.015 0.015 ↑ 1.0 1 1

Seq Scan on social_credentials (cost=0.00..3.46 rows=1 width=68) (actual time=0.012..0.015 rows=1 loops=1)

  • Filter: (user_id = 4,158)
  • Rows Removed by Filter: 36
12. 1.513 8.544 ↓ 0.0 0 89

Append (cost=2.74..2,266.57 rows=48 width=13) (actual time=0.096..0.096 rows=0 loops=89)

13. 0.000 0.089 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201609 (cost=2.74..12.17 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))
14. 0.089 0.089 ↓ 0.0 0 89

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

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

Bitmap Heap Scan on social_interactions_201610 (cost=3.26..25.78 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))
16. 0.089 0.089 ↓ 0.0 0 89

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

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

Bitmap Heap Scan on social_interactions_201611 (cost=3.38..27.74 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))
18. 0.089 0.089 ↓ 0.0 0 89

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

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

Bitmap Heap Scan on social_interactions_201612 (cost=3.41..28.70 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))
20. 0.089 0.089 ↓ 0.0 0 89

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

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

Bitmap Heap Scan on social_interactions_201701 (cost=3.49..32.98 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))
22. 0.178 0.178 ↓ 0.0 0 89

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

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

Index Scan using social_activity_interactions_201702_social_activity_id_idx on social_interactions_201702 (cost=0.29..35.45 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))
24. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201703_social_activity_id_idx on social_interactions_201703 (cost=0.42..53.00 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))
25. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201704_social_activity_id_idx on social_interactions_201704 (cost=0.42..53.35 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))
26. 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..52.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))
27. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201706_social_activity_id_idx on social_interactions_201706 (cost=0.42..48.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))
28. 0.089 0.089 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201707_social_activity_id_idx on social_interactions_201707 (cost=0.42..48.50 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))
29. 0.000 0.089 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201708 (cost=4.27..43.02 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))
30. 0.089 0.089 ↓ 0.0 0 89

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

  • Index Cond: (social_activity_id = social_activities.id)
31. 0.356 0.356 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201709_social_activity_id_idx on social_interactions_201709 (cost=0.42..50.84 rows=1 width=13) (actual time=0.004..0.004 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))
32. 0.089 0.534 ↓ 0.0 0 89

Bitmap Heap Scan on social_interactions_201710 (cost=4.44..81.38 rows=1 width=13) (actual time=0.006..0.006 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.445 0.445 ↓ 0.0 0 89

Bitmap Index Scan on social_activity_interactions_201710_social_activity_id_idx (cost=0.00..4.44 rows=25 width=0) (actual time=0.005..0.005 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_201711_social_activity_id_idx on social_interactions_201711 (cost=0.42..83.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))
35. 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..92.29 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))
36. 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..74.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))
37. 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..97.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))
38. 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..99.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))
39. 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..73.31 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.178 0.178 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201805_social_activity_id_idx on social_interactions_201805 (cost=0.42..84.98 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))
41. 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..68.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))
42. 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..52.99 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_201808_social_activity_id_idx on social_interactions_201808 (cost=0.43..64.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))
44. 0.267 0.267 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201809_social_activity_id_idx on social_interactions_201809 (cost=0.42..76.29 rows=1 width=13) (actual time=0.003..0.003 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_201810_social_activity_id_idx on social_interactions_201810 (cost=0.43..82.24 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_201811_social_activity_id_idx on social_interactions_201811 (cost=0.42..39.39 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.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..36.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))
48. 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..32.45 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))
49. 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..34.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))
50. 1.157 1.157 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201903_social_activity_id_idx on social_interactions_201903 (cost=0.42..30.89 rows=1 width=13) (actual time=0.013..0.013 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_201904_social_activity_id_idx on social_interactions_201904 (cost=0.42..35.52 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_201905_social_activity_id_idx on social_interactions_201905 (cost=0.42..32.86 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.267 0.267 ↓ 0.0 0 89

Index Scan using social_activity_interactions_201906_social_activity_id_idx on social_interactions_201906 (cost=0.42..33.59 rows=1 width=13) (actual time=0.003..0.003 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_201907_social_activity_id_idx on social_interactions_201907 (cost=0.42..34.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))
55. 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..33.83 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_201909_social_activity_id_idx on social_interactions_201909 (cost=0.42..36.36 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_201910_social_activity_id_idx on social_interactions_201910 (cost=0.42..26.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))
58. 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..41.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))
59. 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..37.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))
60. 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..38.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))
61. 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.13 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
62. 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..33.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))
63. 0.178 0.178 ↓ 0.0 0 89

Index Scan using social_activity_interactions_202004_social_activity_id_idx on social_interactions_202004 (cost=0.42..29.16 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))
64. 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.13 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))
65. 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..33.93 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
66. 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..28.32 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
67. 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.03 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))
Planning time : 5.846 ms
Execution time : 13.505 ms