explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KCaV

Settings
# exclusive inclusive rows x rows loops node
1. 11,216.710 274,090.329 ↓ 2.5 8,956,599 1

Merge Join (cost=28,087,891.52..28,752,797.01 rows=3,611,572 width=330) (actual time=257,946.175..274,090.329 rows=8,956,599 loops=1)

2.          

CTE cmfk

3. 0.000 667.504 ↑ 1.0 141,335 1

Gather (cost=1,000..136,260.2 rows=141,371 width=59) (actual time=1.184..667.504 rows=141,335 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
4. 766.126 766.126 ↑ 1.2 23,556 6 / 6

Seq Scan on cmfk cmfk (cost=0..135,260.2 rows=28,274 width=59) (actual time=1.455..766.126 rows=23,556 loops=6)

  • Filter: (((objid)::text = ANY ('{KKA2,KKA3}'::text[])) AND ((mandt)::text = '400'::text))
5. 157,302.688 260,517.988 ↑ 1.2 68,914,106 1

Sort (cost=27,936,710.23..28,137,277.88 rows=80,227,063 width=94) (actual time=201,729.86..260,517.988 rows=68,914,106 loops=1)

  • Sort Key: d.aplid, d.nr
  • Sort Method: external merge Disk: 6867728kB
6. 8,180.614 103,215.300 ↑ 1.0 78,399,815 1

Gather (cost=1,000..14,994,701.24 rows=80,227,063 width=94) (actual time=1.068..103,215.3 rows=78,399,815 loops=1)

  • Workers Planned: 9
  • Workers Launched: 9
7. 95,034.686 95,034.686 ↑ 1.1 7,839,982 10 / 10

Seq Scan on cmfp d (cost=0..14,993,701.24 rows=8,914,118 width=94) (actual time=20.063..95,034.686 rows=7,839,982 loops=10)

  • Filter: ((msgty)::text = ANY ('{E,A}'::text[]))
8. 1,582.426 2,355.631 ↓ 63.6 8,996,553 1

Sort (cost=14,921.09..15,274.52 rows=141,371 width=384) (actual time=1,959.556..2,355.631 rows=8,996,553 loops=1)

  • Sort Key: h.aplid, h.nr
  • Sort Method: quicksort Memory: 17260kB
9. 773.205 773.205 ↑ 1.0 141,335 1

CTE Scan on cmfk h (cost=0..2,827.42 rows=141,371 width=384) (actual time=1.187..773.205 rows=141,335 loops=1)

Planning time : 0.235 ms
Execution time : 275,381.575 ms