explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rDFQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,878.733 ↓ 1.4 92,603 1

Finalize GroupAggregate (cost=236,755.81..245,086.10 rows=66,787 width=45) (actual time=2,677.945..2,878.733 rows=92,603 loops=1)

  • Group Key: poste.prest
2. 301.699 2,992.019 ↓ 1.9 105,123 1

Gather Merge (cost=236,755.81..243,666.88 rows=55,656 width=41) (actual time=2,677.933..2,992.019 rows=105,123 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 28.904 2,690.320 ↓ 1.3 35,041 3 / 3

Partial GroupAggregate (cost=235,755.78..236,242.77 rows=27,828 width=41) (actual time=2,656.303..2,690.320 rows=35,041 loops=3)

  • Group Key: poste.prest
4. 172.889 2,661.416 ↓ 1.4 37,852 3 / 3

Sort (cost=235,755.78..235,825.35 rows=27,828 width=19) (actual time=2,656.280..2,661.416 rows=37,852 loops=3)

  • Sort Key: poste.prest
  • Sort Method: quicksort Memory: 4,743kB
5. 62.453 2,488.527 ↓ 1.4 37,852 3 / 3

Hash Join (cost=91,236.79..233,701.48 rows=27,828 width=19) (actual time=1,551.406..2,488.527 rows=37,852 loops=3)

  • Hash Cond: ((poste.numctr)::text = (cde.numctr)::text)
  • Join Filter: ((poste.resil1 IS NULL) OR ((poste.resil1)::text <> ALL ('{ZB,ZE,ZD}'::text[])) OR ((cde.typctr)::text = ANY ('{ZC01,ZC02}'::text[])))
  • Rows Removed by Join Filter: 98
6. 912.192 912.192 ↑ 1.2 37,950 3 / 3

Parallel Seq Scan on clip_poste poste (cost=0.00..142,341.20 rows=47,046 width=22) (actual time=0.544..912.192 rows=37,950 loops=3)

  • Filter: ((prestartcod)::text = ANY ('{LETE01,LETF01,LETG01,LET10G,CEEO01,CEEO02,CEEO03,CEEO04,1ILF01}'::text[]))
  • Rows Removed by Filter: 1,472,206
7. 726.492 1,513.882 ↓ 1.0 2,343,350 3 / 3

Hash (cost=61,952.46..61,952.46 rows=2,342,746 width=16) (actual time=1,513.882..1,513.882 rows=2,343,350 loops=3)

  • Buckets: 4,194,304 Batches: 1 Memory Usage: 142,613kB
8. 787.390 787.390 ↓ 1.0 2,343,350 3 / 3

Seq Scan on clip_cde cde (cost=0.00..61,952.46 rows=2,342,746 width=16) (actual time=0.091..787.390 rows=2,343,350 loops=3)