explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RhOZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.455 7.766 ↓ 10.4 239 1

Hash Join (cost=790.91..2,261.90 rows=23 width=306) (actual time=2.504..7.766 rows=239 loops=1)

  • Hash Cond: (spl.wh_id = w.wh_id)
2. 0.585 7.287 ↑ 1.0 551 1

Hash Left Join (cost=789.73..2,259.01 rows=551 width=32) (actual time=2.470..7.287 rows=551 loops=1)

  • Hash Cond: (sp.place_cod = eq.place_cod)
3. 1.098 4.272 ↑ 1.0 551 1

Nested Loop (cost=0.43..1,468.26 rows=551 width=24) (actual time=0.032..4.272 rows=551 loops=1)

4. 0.419 0.419 ↑ 1.0 551 1

Seq Scan on sortplace sp (cost=0.00..12.51 rows=551 width=20) (actual time=0.012..0.419 rows=551 loops=1)

5. 2.755 2.755 ↑ 1.0 1 551

Index Scan using pk_storageplace on storageplace spl (cost=0.43..2.64 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=551)

  • Index Cond: (place_cod = sp.place_cod)
6. 0.080 2.430 ↑ 2.0 118 1

Hash (cost=786.38..786.38 rows=233 width=12) (actual time=2.429..2.430 rows=118 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
7. 0.169 2.350 ↑ 2.0 118 1

Subquery Scan on eq (cost=781.72..786.38 rows=233 width=12) (actual time=2.098..2.350 rows=118 loops=1)

8. 0.409 2.181 ↑ 2.0 118 1

HashAggregate (cost=781.72..784.05 rows=233 width=12) (actual time=2.096..2.181 rows=118 loops=1)

  • Group Key: sw.place_cod
9. 1.772 1.772 ↓ 1.0 392 1

Index Scan using ix_sortworker_ch_dt on sortworker sw (cost=0.54..779.81 rows=382 width=4) (actual time=0.029..1.772 rows=392 loops=1)

  • Index Cond: (ch_dt >= (timezone('Europe/Moscow'::text, now()) - '00:15:00'::interval))
10. 0.008 0.024 ↓ 7.0 7 1

Hash (cost=1.18..1.18 rows=1 width=278) (actual time=0.024..0.024 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.016 0.016 ↓ 7.0 7 1

Seq Scan on warehouse w (cost=0.00..1.18 rows=1 width=278) (actual time=0.009..0.016 rows=7 loops=1)

  • Filter: (office_id = 507)
  • Rows Removed by Filter: 7
Planning time : 0.803 ms
Execution time : 7.993 ms