explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qd92

Settings
# exclusive inclusive rows x rows loops node
1. 0.059 0.671 ↓ 13.0 13 1

Sort (cost=133.51..133.52 rows=1 width=5,085) (actual time=0.664..0.671 rows=13 loops=1)

  • Sort Key: activities.""sortOrder"", activities.id
  • Sort Method: quicksort Memory: 33kB
2. 0.019 0.612 ↓ 13.0 13 1

Nested Loop Left Join (cost=42.58..133.50 rows=1 width=5,085) (actual time=0.320..0.612 rows=13 loops=1)

3. 0.029 0.580 ↓ 13.0 13 1

Nested Loop Left Join (cost=42.44..132.88 rows=1 width=4,929) (actual time=0.316..0.580 rows=13 loops=1)

4. 0.030 0.551 ↓ 13.0 13 1

Nested Loop Left Join (cost=42.30..132.52 rows=1 width=3,381) (actual time=0.313..0.551 rows=13 loops=1)

5. 0.022 0.521 ↓ 13.0 13 1

Nested Loop Left Join (cost=42.02..131.03 rows=1 width=3,046) (actual time=0.310..0.521 rows=13 loops=1)

6. 0.066 0.369 ↓ 13.0 13 1

Hash Join (cost=41.59..130.00 rows=1 width=3,030) (actual time=0.293..0.369 rows=13 loops=1)

  • Hash Cond: (activity_participants.""activityId"" = activities.id)
  • Join Filter: (((activities.""deletedAt"" IS NULL) AND (activity_participants.""deletedAt"" IS NULL)) OR (hashed SubPlan 1))
7. 0.208 0.208 ↑ 1.1 64 1

Index Scan using activity_participants_userid_index on activity_participants (cost=0.56..88.60 rows=72 width=78) (actual time=0.033..0.208 rows=64 loops=1)

  • Index Cond: (""userId"" = '24a8398514996d6da25375deccf74170f8770f52'::text)
8. 0.032 0.095 ↑ 1.9 13 1

Hash (cost=36.85..36.85 rows=25 width=2,960) (actual time=0.095..0.095 rows=13 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
9. 0.063 0.063 ↑ 1.9 13 1

Index Scan using activity_rootid on activities (cost=0.42..36.85 rows=25 width=2,960) (actual time=0.013..0.063 rows=13 loops=1)

  • Index Cond: (""rootId"" = ANY ('{54318,54324,54304,54310,54312}'::integer[]))
10.          

SubPlan (for Hash Join)

11. 0.000 0.000 ↓ 0.0 0

Seq Scan on deleted_reasons (cost=0.00..1.61 rows=2 width=4) (never executed)

  • Filter: ((value)::text = ANY ('{EXPIRED,LOST_ELIGIBILITY}'::text[]))
12. 0.013 0.130 ↓ 0.0 0 13

Subquery Scan on activity_participants_metrics (cost=0.43..0.92 rows=1 width=32) (actual time=0.010..0.010 rows=0 loops=13)

  • Filter: (activity_participants_metrics.""activityParticipantsUuid"" = activity_participants.uuid)
13. 0.013 0.117 ↓ 0.0 0 13

Limit (cost=0.43..0.82 rows=1 width=32) (actual time=0.009..0.009 rows=0 loops=13)

14. 0.104 0.104 ↓ 0.0 0 13

Index Only Scan Backward using activity_participants_metrics_3columns on activity_participants_metrics activity_participants_metrics_1 (cost=0.43..9.50 rows=23 width=32) (actual time=0.008..0.008 rows=0 loops=13)

  • Index Cond: (""activityParticipantsUuid"" = activity_participants.uuid)
  • Heap Fetches: 0
15. 0.000 0.000 ↓ 0.0 0 13

Index Scan using activity_health_measures_pkey on activity_health_measures ahm (cost=0.28..1.40 rows=1 width=335) (actual time=0.000..0.000 rows=0 loops=13)

  • Index Cond: (activities.""activityHealthMeasureId"" = id)
16. 0.000 0.000 ↓ 0.0 0 13

Index Scan using activity_health_measure_types_pkey on activity_health_measure_types ahmt (cost=0.14..0.26 rows=1 width=1,552) (actual time=0.000..0.000 rows=0 loops=13)

  • Index Cond: (ahm.""healthMeasureTypeId"" = id)
17. 0.013 0.013 ↓ 0.0 0 13

Index Scan using wellsource_hra_settings_pkey on wellsource_hra_settings hra (cost=0.14..0.52 rows=1 width=156) (actual time=0.001..0.001 rows=0 loops=13)

  • Index Cond: (activities.""wellsourceHraSettingsId"" = id)