explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IEap

Settings
# exclusive inclusive rows x rows loops node
1. 35.143 51.832 ↓ 1.0 14,935 1

Hash Left Join (cost=2,565.16..3,008.81 rows=14,347 width=212) (actual time=12.118..51.832 rows=14,935 loops=1)

  • Hash Cond: (spd_kontrahenci_hand.id_handlowca = b.kod)
2. 3.109 16.660 ↓ 1.0 14,935 1

Unique (cost=2,560.13..2,701.77 rows=14,347 width=12) (actual time=12.075..16.660 rows=14,935 loops=1)

3. 10.219 13.551 ↓ 1.0 28,386 1

Sort (cost=2,560.13..2,630.95 rows=28,328 width=12) (actual time=12.075..13.551 rows=28,386 loops=1)

  • Sort Key: spd_kontrahenci_hand.id_kontrahenta, spd_kontrahenci_hand.od_kiedy
  • Sort Method: quicksort Memory: 2099kB
4. 3.332 3.332 ↓ 1.0 28,386 1

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

5. 0.018 0.029 ↓ 1.0 48 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
6. 0.011 0.011 ↓ 1.0 48 1

Seq Scan on spd_handlowcy b (cost=0.00..4.46 rows=46 width=208) (actual time=0.004..0.011 rows=48 loops=1)

Total runtime : 52.402 ms