explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wvyb

Settings
# exclusive inclusive rows x rows loops node
1. 0.326 4.603 ↓ 10.4 239 1

Hash Join (cost=807.15..2,278.13 rows=23 width=306) (actual time=1.144..4.603 rows=239 loops=1)

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

Hash Left Join (cost=805.96..2,275.24 rows=551 width=32) (actual time=1.118..4.258 rows=551 loops=1)

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

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

4. 0.286 0.286 ↑ 1.0 551 1

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

5. 1.653 1.653 ↑ 1.0 1 551

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

  • Index Cond: (place_cod = sp.place_cod)
6. 0.053 1.091 ↑ 2.0 119 1

Hash (cost=802.58..802.58 rows=236 width=12) (actual time=1.090..1.091 rows=119 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
7. 0.082 1.038 ↑ 2.0 119 1

Subquery Scan on eq (cost=797.86..802.58 rows=236 width=12) (actual time=0.904..1.038 rows=119 loops=1)

8. 0.263 0.956 ↑ 2.0 119 1

HashAggregate (cost=797.86..800.22 rows=236 width=12) (actual time=0.903..0.956 rows=119 loops=1)

  • Group Key: sw.place_cod
9. 0.693 0.693 ↓ 1.0 396 1

Index Scan using ix_sortworker_ch_dt on sortworker sw (cost=0.54..795.91 rows=390 width=4) (actual time=0.015..0.693 rows=396 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.018..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.535 ms
Execution time : 4.764 ms