explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wlUd

Settings
# exclusive inclusive rows x rows loops node
1. 0.066 15.997 ↑ 1.0 1 1

Aggregate (cost=126.21..126.22 rows=1 width=8) (actual time=15.997..15.997 rows=1 loops=1)

2. 0.013 15.931 ↓ 8.0 8 1

Nested Loop (cost=78.14..126.20 rows=1 width=8) (actual time=15.684..15.931 rows=8 loops=1)

3. 0.026 15.886 ↓ 8.0 8 1

Nested Loop (cost=77.86..125.87 rows=1 width=24) (actual time=15.667..15.886 rows=8 loops=1)

4. 0.461 11.628 ↓ 23.0 23 1

Hash Join (cost=77.58..125.33 rows=1 width=8) (actual time=10.796..11.628 rows=23 loops=1)

  • Hash Cond: (alignments.outcome_id = outcomes.id)
5. 2.458 2.458 ↑ 1.0 1,879 1

Seq Scan on alignments (cost=0.00..42.81 rows=1,879 width=16) (actual time=0.500..2.458 rows=1,879 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 202
6. 0.016 8.709 ↓ 1.4 10 1

Hash (cost=77.50..77.50 rows=7 width=8) (actual time=8.709..8.709 rows=10 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 8.693 8.693 ↓ 1.4 10 1

Index Scan using outcomes_pkey on outcomes (cost=0.42..77.50 rows=7 width=8) (actual time=3.286..8.693 rows=10 loops=1)

  • Index Cond: (id = ANY ('{69392,84521,84603,41614,83419,27138,41936,89414,90197,90198}'::bigint[]))
  • Filter: (deleted_at IS NULL)
8. 4.232 4.232 ↓ 0.0 0 23

Index Scan using index_artifacts_on_alignment_set_id on artifacts (cost=0.28..0.54 rows=1 width=16) (actual time=0.184..0.184 rows=0 loops=23)

  • Index Cond: (alignment_set_id = alignments.alignment_set_id)
  • Filter: (((artifact_type)::text = 'quizzes.item'::text) AND (artifact_id = ANY ('{15186,15187,15188,15189,15190,15191,15192,15193,15194,15195,15196,15197,15198,15199,15200,15201,15202,15203,15204,15205,15211,15212,15206,15207,15209,15208,15210}'::bigint[])))
  • Rows Removed by Filter: 3
9. 0.032 0.032 ↑ 1.0 1 8

Index Scan using alignment_sets_pkey on alignment_sets (cost=0.28..0.33 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=8)

  • Index Cond: (id = alignments.alignment_set_id)
  • Filter: (deleted_at IS NULL)