explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jlmb : plan

Settings
# exclusive inclusive rows x rows loops node
1. 59.539 578.798 ↑ 1.0 440,840 1

Merge Left Join (cost=70,862.71..74,263.51 rows=440,840 width=40) (actual time=428.036..578.798 rows=440,840 loops=1)

  • Merge Cond: ((a.id_portfel = b.id_portfel) AND (a.id_bank = b.id_bank))
2. 383.665 517.887 ↑ 1.0 440,840 1

Sort (cost=70,825.92..71,928.02 rows=440,840 width=24) (actual time=428.012..517.887 rows=440,840 loops=1)

  • Sort Key: a.id_portfel, a.id_bank
  • Sort Method: external merge Disk: 14616kB
3. 134.222 134.222 ↑ 1.0 440,840 1

Seq Scan on bp_produkt a (cost=0.00..20,453.40 rows=440,840 width=24) (actual time=0.005..134.222 rows=440,840 loops=1)

4. 1.365 1.372 ↓ 56.6 27,723 1

Sort (cost=36.79..38.02 rows=490 width=48) (actual time=0.020..1.372 rows=27,723 loops=1)

  • Sort Key: b.id_portfel, b.id_bank
  • Sort Method: quicksort Memory: 25kB
5. 0.007 0.007 ↑ 49.0 10 1

Seq Scan on _temp b (cost=0.00..14.90 rows=490 width=48) (actual time=0.004..0.007 rows=10 loops=1)

Planning time : 0.324 ms
Execution time : 597.282 ms