explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6VMi

Settings
# exclusive inclusive rows x rows loops node
1. 0.534 604.259 ↓ 62.7 941 1

Nested Loop (cost=180,837.13..288,522.38 rows=15 width=17) (actual time=599.527..604.259 rows=941 loops=1)

2. 0.502 600.902 ↑ 4.5 941 1

Hash Join (cost=180,836.57..257,472.60 rows=4,221 width=21) (actual time=599.494..600.902 rows=941 loops=1)

  • Hash Cond: ((oir.orderid)::integer = (o.orderid)::integer)
3. 1.118 1.118 ↑ 171.5 984 1

Index Scan using i_orderitemreserves_4_samples on orderitemreserves oir (cost=0.28..75,961.23 rows=168,762 width=12) (actual time=0.009..1.118 rows=984 loops=1)

  • Filter: ((storegroupid)::integer = 10)
  • Rows Removed by Filter: 472
4. 46.672 599.282 ↓ 2.7 192,942 1

Hash (cost=179,929.34..179,929.34 rows=72,556 width=13) (actual time=599.282..599.282 rows=192,942 loops=1)

  • Buckets: 262144 (originally 131072) Batches: 1 (originally 1) Memory Usage: 11093kB
5. 342.129 552.610 ↓ 2.7 192,942 1

Bitmap Heap Scan on orders o (cost=32,784.80..179,929.34 rows=72,556 width=13) (actual time=243.250..552.610 rows=192,942 loops=1)

  • Recheck Cond: (isinwork AND ((supplierid)::integer = 6))
  • Heap Blocks: exact=117305
6. 40.127 210.481 ↓ 0.0 0 1

BitmapAnd (cost=32,784.80..32,784.80 rows=72,556 width=0) (actual time=210.481..210.481 rows=0 loops=1)

7. 128.371 128.371 ↑ 1.0 889,277 1

Bitmap Index Scan on i_objecttasks_isinwork_firstworkdate (cost=0.00..16,145.21 rows=905,812 width=0) (actual time=128.371..128.371 rows=889,277 loops=1)

8. 41.983 41.983 ↑ 1.0 222,323 1

Bitmap Index Scan on i_orders_supplier (cost=0.00..16,603.06 rows=232,351 width=0) (actual time=41.983..41.983 rows=222,323 loops=1)

  • Index Cond: ((supplierid)::integer = 6)
9. 2.823 2.823 ↑ 1.0 1 941

Index Scan using i_orderitems_orderitemidobjectstatusid on orderitems oi (cost=0.56..7.35 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=941)

  • Index Cond: ((orderitemid)::integer = (oir.orderitemid)::integer)
  • Filter: (COALESCE(amountgiven, 0) = 0)
Planning time : 0.843 ms
Execution time : 606.081 ms