explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vy2

Settings
# exclusive inclusive rows x rows loops node
1. 941.971 7,306.463 ↓ 3,186,049.0 3,186,049 1

Gather (cost=1,000.97..12,977.63 rows=1 width=203) (actual time=0.667..7,306.463 rows=3,186,049 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 2,067.941 6,364.492 ↓ 1,062,016.0 1,062,016 3 / 3

Nested Loop (cost=0.97..11,977.53 rows=1 width=203) (actual time=0.093..6,364.492 rows=1,062,016 loops=3)

3. 335.050 1,110.502 ↓ 1,062,016.0 1,062,016 3 / 3

Nested Loop (cost=0.56..11,977.05 rows=1 width=94) (actual time=0.074..1,110.502 rows=1,062,016 loops=3)

4. 41.950 41.950 ↓ 80.1 52,393 3 / 3

Parallel Seq Scan on dim_assessmentparticipant asmt (cost=0.00..6,412.48 rows=654 width=44) (actual time=0.052..41.950 rows=52,393 loops=3)

  • Filter: ((administrationid = 593,218) AND ((is_reportable)::text = 'YES'::text) AND ((reportphase)::text = 'IR'::text) AND (COALESCE(NULLIF((nottestedcode)::text, ''::text), '*'::text) = ANY ('{*,DN}'::text[])))
  • Rows Removed by Filter: 957
5. 733.502 733.502 ↓ 20.0 20 157,179 / 3

Index Scan using idx_fact_itemresult_1 on fact_itemresult x (cost=0.56..8.50 rows=1 width=78) (actual time=0.005..0.014 rows=20 loops=157,179)

  • Index Cond: ((administrationid = 593,218) AND (participantid = asmt.participantid) AND (assessmentparticipantid = asmt.assessmentparticipantid))
6. 3,186.049 3,186.049 ↑ 1.0 1 3,186,049 / 3

Index Scan using udx_mv_metadata_1 on mv_metadata mv (cost=0.42..0.45 rows=1 width=96) (actual time=0.003..0.003 rows=1 loops=3,186,049)

  • Index Cond: ((administrationid = 593,218) AND (subtestid = x.subtestid) AND (assessmentlevelid = x.assessmentlevelid) AND (assessmentformid = x.assessmentformid) AND (objectiveid = x.objectiveid) AND (assessmentitemid = x.assessmentitemid))
Planning time : 1.265 ms
Execution time : 7,490.512 ms