explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LMB5

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 2,916.989 ↑ 13,005,444.0 1 1

Subquery Scan on temptable (cost=9,419,320.93..9,841,997.86 rows=13,005,444 width=426) (actual time=2,916.984..2,916.989 rows=1 loops=1)

2. 0.016 2,916.984 ↑ 13,005,444.0 1 1

WindowAgg (cost=9,419,320.93..9,646,916.20 rows=13,005,444 width=426) (actual time=2,916.980..2,916.984 rows=1 loops=1)

3. 0.027 2,916.968 ↑ 13,005,444.0 1 1

Sort (cost=9,419,320.93..9,451,834.54 rows=13,005,444 width=410) (actual time=2,916.967..2,916.968 rows=1 loops=1)

  • Sort Key: a.rno
  • Sort Method: quicksort Memory: 25kB
4. 11.628 2,916.941 ↑ 13,005,444.0 1 1

Merge Join (cost=159,254.47..722,574.10 rows=13,005,444 width=410) (actual time=2,916.933..2,916.941 rows=1 loops=1)

  • Merge Cond: ((a.prodbeg_lower_cp)::text = b.c_pagealias_lower_cp)
5. 250.985 2,605.475 ↑ 267,519.0 1 1

Gather Merge (cost=157,133.87..524,678.86 rows=267,519 width=608) (actual time=2,605.400..2,605.475 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 151.284 2,354.490 ↓ 0.0 0 3 / 3

Merge Left Join (cost=156,133.85..492,800.51 rows=111,466 width=608) (actual time=2,354.489..2,354.490 rows=0 loops=3)

  • Merge Cond: ((a.prodbeg_lower_cp)::text = c.c_docdisplayid)
  • Filter: (c.c_documentid IS NULL)
  • Rows Removed by Filter: 17915
7. 76.233 90.265 ↓ 3.6 17,915 3 / 3

Sort (cost=7,068.89..7,081.25 rows=4,944 width=608) (actual time=82.914..90.265 rows=17,915 loops=3)

  • Sort Key: a.prodbeg_lower_cp
  • Sort Method: external merge Disk: 1216kB
  • Worker 0: Sort Method: external merge Disk: 920kB
  • Worker 1: Sort Method: external merge Disk: 880kB
8. 14.032 14.032 ↓ 3.6 17,915 3 / 3

Parallel Seq Scan on temp_dat_02112020092448_72074 a (cost=0.00..5,982.44 rows=4,944 width=608) (actual time=0.031..14.032 rows=17,915 loops=3)

9. 80.103 2,112.941 ↑ 1.2 755,338 3 / 3

Materialize (cost=149,064.96..153,573.96 rows=901,800 width=40) (actual time=1,667.550..2,112.941 rows=755,338 loops=3)

10. 1,909.981 2,032.838 ↑ 1.2 755,338 3 / 3

Sort (cost=149,064.96..151,319.46 rows=901,800 width=40) (actual time=1,667.542..2,032.838 rows=755,338 loops=3)

  • Sort Key: c.c_docdisplayid
  • Sort Method: external merge Disk: 39752kB
  • Worker 0: Sort Method: external merge Disk: 39752kB
  • Worker 1: Sort Method: external merge Disk: 39752kB
11. 122.857 122.857 ↓ 1.3 1,152,292 3 / 3

Seq Scan on temp_docinlower_02112020092448_72074 c (cost=0.00..16,533.00 rows=901,800 width=40) (actual time=0.038..122.857 rows=1,152,292 loops=3)

12. 6.724 299.838 ↓ 6.6 64,044 1

Materialize (cost=2,120.59..2,169.21 rows=9,723 width=350) (actual time=235.902..299.838 rows=64,044 loops=1)

13. 282.554 293.114 ↓ 6.6 64,044 1

Sort (cost=2,120.59..2,144.90 rows=9,723 width=350) (actual time=235.891..293.114 rows=64,044 loops=1)

  • Sort Key: b.c_pagealias_lower_cp
  • Sort Method: external merge Disk: 2248kB
14. 10.560 10.560 ↓ 6.6 64,064 1

Seq Scan on temp_pageinlower_02112020092448_72074 b (cost=0.00..560.23 rows=9,723 width=350) (actual time=1.284..10.560 rows=64,064 loops=1)

Planning time : 0.210 ms