explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yJCTT

Settings
# exclusive inclusive rows x rows loops node
1. 273.381 6,589.896 ↓ 2.8 744,351 1

Unique (cost=527,257.77..554,128.89 rows=268,711 width=56) (actual time=5,364.406..6,589.896 rows=744,351 loops=1)

  • JIT:
  • Functions: 1
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 0.313 ms, Inlining 2.981 ms, Optimization 7.901 ms, Emission 7.181 ms, Total 18.376 ms
2. 6,153.408 6,316.515 ↑ 1.0 2,687,112 1

Sort (cost=527,257.77..533,975.55 rows=2,687,112 width=56) (actual time=5,364.405..6,316.515 rows=2,687,112 loops=1)

  • Sort Key: whse_code, npc, last_upd DESC
  • Sort Method: external merge Disk: 185,784kB
3. 163.107 163.107 ↑ 1.0 2,687,112 1

Seq Scan on cts_binloc (cost=0.00..56,612.12 rows=2,687,112 width=56) (actual time=0.036..163.107 rows=2,687,112 loops=1)

Planning time : 0.092 ms
Execution time : 6,623.271 ms