explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jCxK

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 1.126 ↑ 64.5 2 1

Group (cost=1,605.90..1,618.31 rows=129 width=214) (actual time=1.120..1.126 rows=2 loops=1)

  • Group Key: (COALESCE((sar.salearticleid)::integer)), oir.amount, o.number, co.code, co.fullname, oir.storegroupid, o.isinwork, o.isinvrecieved, o.istomanager, oir.todeletedate, o.customerid, oir.prolongcount, (COALESCE((oir.orderitemreserveid)::integer)), oir.date, oir.issubrelease
2. 0.015 1.099 ↑ 64.5 2 1

Sort (cost=1,605.90..1,606.22 rows=129 width=86) (actual time=1.099..1.099 rows=2 loops=1)

  • Sort Key: (COALESCE((sar.salearticleid)::integer)), oir.amount, o.number, co.code, co.fullname, o.isinwork, o.isinvrecieved, o.istomanager, oir.todeletedate, o.customerid, oir.prolongcount, (COALESCE((oir.orderitemreserveid)::integer)), oir.date, oir.issubrelease
  • Sort Method: quicksort Memory: 25kB
3. 0.002 1.084 ↑ 64.5 2 1

Nested Loop (cost=832.61..1,601.37 rows=129 width=86) (actual time=1.065..1.084 rows=2 loops=1)

4. 0.005 1.070 ↑ 64.5 2 1

Nested Loop (cost=832.32..1,561.12 rows=129 width=51) (actual time=1.057..1.070 rows=2 loops=1)

5. 0.005 1.049 ↑ 64.5 2 1

Nested Loop (cost=831.89..1,436.82 rows=129 width=41) (actual time=1.044..1.049 rows=2 loops=1)

6. 0.001 0.046 ↑ 1.0 1 1

Unique (cost=16.90..16.91 rows=1 width=8) (actual time=0.046..0.046 rows=1 loops=1)

7. 0.005 0.045 ↑ 1.0 1 1

Sort (cost=16.90..16.90 rows=1 width=8) (actual time=0.045..0.045 rows=1 loops=1)

  • Sort Key: (COALESCE((sar.salearticleid)::integer)), sar.articleid
  • Sort Method: quicksort Memory: 25kB
8. 0.004 0.040 ↑ 1.0 1 1

Nested Loop (cost=0.84..16.89 rows=1 width=8) (actual time=0.038..0.040 rows=1 loops=1)

9. 0.025 0.025 ↑ 1.0 1 1

Index Only Scan using i_articles_level on articles a (cost=0.42..8.44 rows=1 width=4) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: (articleid = ANY ('{42907}'::integer[]))
  • Heap Fetches: 1
10. 0.011 0.011 ↑ 1.0 1 1

Index Scan using i_salearticles_article on salearticles sar (cost=0.42..8.44 rows=1 width=8) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: ((articleid)::integer = (a.articleid)::integer)
11. 0.013 0.998 ↑ 64.5 2 1

Bitmap Heap Scan on orderitemreserves oir (cost=814.99..1,418.61 rows=129 width=41) (actual time=0.995..0.998 rows=2 loops=1)

  • Recheck Cond: (((articleid)::integer = (sar.articleid)::integer) AND (amount > 0) AND (objectstatusid <= 1))
  • Filter: ((storegroupid)::integer = 5)
  • Heap Blocks: exact=2
12. 0.057 0.985 ↓ 0.0 0 1

BitmapAnd (cost=814.99..814.99 rows=154 width=0) (actual time=0.985..0.985 rows=0 loops=1)

13. 0.188 0.188 ↓ 2.1 1,303 1

Bitmap Index Scan on i_orderitemreserves_articleid (cost=0.00..13.16 rows=630 width=0) (actual time=0.188..0.188 rows=1,303 loops=1)

  • Index Cond: ((articleid)::integer = (sar.articleid)::integer)
14. 0.740 0.740 ↑ 206.4 10,289 1

Bitmap Index Scan on i_orderitemreserves_orderitemid_amountgt0_status1 (cost=0.00..356.74 rows=2,123,286 width=0) (actual time=0.740..0.740 rows=10,289 loops=1)

15. 0.016 0.016 ↑ 1.0 1 2

Index Scan using orders_pkey on orders o (cost=0.43..0.96 rows=1 width=18) (actual time=0.008..0.008 rows=1 loops=2)

  • Index Cond: ((orderid)::integer = (oir.orderid)::integer)
16. 0.012 0.012 ↑ 1.0 1 2

Index Scan using companies_pkey on companies co (cost=0.29..0.31 rows=1 width=39) (actual time=0.006..0.006 rows=1 loops=2)

  • Index Cond: ((companyid)::integer = (o.customerid)::integer)
Planning time : 1.560 ms
Execution time : 1.260 ms