explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CSqx

Settings
# exclusive inclusive rows x rows loops node
1. 0.090 15.844 ↓ 2.0 47 1

Nested Loop Left Join (cost=0.97..21,246.34 rows=23 width=306) (actual time=0.766..15.844 rows=47 loops=1)

2. 0.229 3.299 ↓ 2.0 47 1

Nested Loop (cost=0.43..1,476.32 rows=23 width=298) (actual time=0.058..3.299 rows=47 loops=1)

  • Join Filter: (spl.wh_id = w.wh_id)
  • Rows Removed by Join Filter: 504
3. 0.014 0.014 ↑ 1.0 1 1

Seq Scan on warehouse w (cost=0.00..1.18 rows=1 width=278) (actual time=0.011..0.014 rows=1 loops=1)

  • Filter: (office_id = 686)
  • Rows Removed by Filter: 13
4. 0.536 3.056 ↑ 1.0 551 1

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

5. 0.316 0.316 ↑ 1.0 551 1

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

6. 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)
7. 0.141 12.455 ↓ 0.0 0 47

GroupAggregate (cost=0.54..859.55 rows=1 width=12) (actual time=0.265..0.265 rows=0 loops=47)

  • Group Key: sw.place_cod
8. 12.314 12.314 ↑ 1.0 1 47

Index Scan using ix_sortworker_ch_dt on sortworker sw (cost=0.54..859.53 rows=1 width=4) (actual time=0.240..0.262 rows=1 loops=47)

  • Index Cond: (ch_dt >= (timezone('Europe/Moscow'::text, now()) - '00:15:00'::interval))
  • Filter: (place_cod = sp.place_cod)
  • Rows Removed by Filter: 434
Planning time : 0.525 ms
Execution time : 15.947 ms