explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mcTl

Settings
# exclusive inclusive rows x rows loops node
1. 35.244 64.215 ↓ 1.0 14,935 1

Hash Left Join (cost=1,502.15..3,241.76 rows=14,347 width=212) (actual time=19.698..64.215 rows=14,935 loops=1)

  • Hash Cond: (bb.id_handlowca = cc.kod)
2. 7.098 28.924 ↓ 1.0 14,935 1

Hash Left Join (cost=1,497.12..2,967.83 rows=14,347 width=8) (actual time=19.627..28.924 rows=14,935 loops=1)

  • Hash Cond: ((spd_kontrahenci_hand.id_kontrahenta = bb.id_kontrahenta) AND ((max(spd_kontrahenci_hand.od_kiedy)) = bb.od_kiedy))
3. 10.131 12.899 ↓ 1.0 14,935 1

HashAggregate (cost=606.92..750.39 rows=14,347 width=8) (actual time=10.677..12.899 rows=14,935 loops=1)

4. 2.768 2.768 ↓ 1.0 28,386 1

Seq Scan on spd_kontrahenci_hand (cost=0.00..465.28 rows=28,328 width=8) (actual time=0.016..2.768 rows=28,386 loops=1)

5. 5.508 8.927 ↓ 1.0 28,386 1

Hash (cost=465.28..465.28 rows=28,328 width=12) (actual time=8.927..8.927 rows=28,386 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 1220kB
6. 3.419 3.419 ↓ 1.0 28,386 1

Seq Scan on spd_kontrahenci_hand bb (cost=0.00..465.28 rows=28,328 width=12) (actual time=0.003..3.419 rows=28,386 loops=1)

7. 0.021 0.047 ↓ 1.0 48 1

Hash (cost=4.46..4.46 rows=46 width=208) (actual time=0.047..0.047 rows=48 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
8. 0.026 0.026 ↓ 1.0 48 1

Seq Scan on spd_handlowcy cc (cost=0.00..4.46 rows=46 width=208) (actual time=0.007..0.026 rows=48 loops=1)

Total runtime : 65.038 ms