explain.depesz.com

PostgreSQL's explain analyze made readable

Result: voMx

Settings
# exclusive inclusive rows x rows loops node
1. 0.375 5.922 ↓ 10.4 239 1

Hash Join (cost=818.93..2,289.91 rows=23 width=306) (actual time=1.541..5.922 rows=239 loops=1)

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

Hash Left Join (cost=817.74..2,287.02 rows=551 width=32) (actual time=1.515..5.528 rows=551 loops=1)

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

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

4. 0.342 0.342 ↑ 1.0 551 1

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

5. 2.204 2.204 ↑ 1.0 1 551

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

  • Index Cond: (place_cod = sp.place_cod)
6. 0.054 1.478 ↑ 2.0 117 1

Hash (cost=814.33..814.33 rows=238 width=12) (actual time=1.478..1.478 rows=117 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
7. 0.081 1.424 ↑ 2.0 117 1

Subquery Scan on eq (cost=809.57..814.33 rows=238 width=12) (actual time=1.293..1.424 rows=117 loops=1)

8. 0.273 1.343 ↑ 2.0 117 1

HashAggregate (cost=809.57..811.95 rows=238 width=12) (actual time=1.291..1.343 rows=117 loops=1)

  • Group Key: sw.place_cod
9. 1.070 1.070 ↑ 1.0 382 1

Index Scan using ix_sortworker_ch_dt on sortworker sw (cost=0.54..807.59 rows=396 width=4) (actual time=0.020..1.070 rows=382 loops=1)

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

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

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

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

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