explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cwUQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.169 ↑ 1.0 1 1

Limit (cost=36.32..36.32 rows=1 width=216) (actual time=0.169..0.169 rows=1 loops=1)

2. 0.024 0.169 ↑ 1.0 1 1

Sort (cost=36.32..36.32 rows=1 width=216) (actual time=0.168..0.169 rows=1 loops=1)

  • Sort Key: order0_.dateordered DESC, order0_.documentno DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.004 0.145 ↑ 1.0 1 1

Nested Loop (cost=23.40..36.31 rows=1 width=216) (actual time=0.131..0.145 rows=1 loops=1)

4. 0.015 0.125 ↑ 1.0 1 1

Hash Join (cost=23.13..27.99 rows=1 width=160) (actual time=0.111..0.125 rows=1 loops=1)

  • Hash Cond: ((businesspa1_.c_bpartner_id)::text = (order0_.c_bpartner_id)::text)
5. 0.010 0.010 ↑ 1.0 62 1

Seq Scan on c_bpartner businesspa1_ (cost=0.00..4.62 rows=62 width=53) (actual time=0.003..0.010 rows=62 loops=1)

6. 0.003 0.100 ↑ 1.0 1 1

Hash (cost=23.12..23.12 rows=1 width=140) (actual time=0.100..0.100 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.008 0.097 ↑ 1.0 1 1

Bitmap Heap Scan on c_order order0_ (cost=19.08..23.12 rows=1 width=140) (actual time=0.096..0.097 rows=1 loops=1)

  • Recheck Cond: (((ad_client_id)::text = '118A93FC5CF04FF18E047B80341C5394'::text) AND ((ad_org_id)::text = '7BA68293CD4A480EB71A0FF2BC10FC75'::text) AND (upper((documentno)::text) ~~ '%205%'::text))
  • Filter: ((em_obpos_applications_id IS NOT NULL) AND ((docstatus)::text <> 'CJ'::text) AND ((docstatus)::text <> 'CA'::text) AND (em_obpos_islayaway <> 'Y'::bpchar) AND (em_obpos_isdeleted = 'N'::bpchar) AND (((docstatus)::te (...)
  • Heap Blocks: exact=1
8. 0.005 0.089 ↓ 0.0 0 1

BitmapAnd (cost=19.08..19.08 rows=1 width=0) (actual time=0.089..0.089 rows=0 loops=1)

9. 0.067 0.067 ↓ 63.0 441 1

Bitmap Index Scan on c_order_client_org_date_docno (cost=0.00..4.48 rows=7 width=0) (actual time=0.067..0.067 rows=441 loops=1)

  • Index Cond: (((ad_client_id)::text = '118A93FC5CF04FF18E047B80341C5394'::text) AND ((ad_org_id)::text = '7BA68293CD4A480EB71A0FF2BC10FC75'::text))
10. 0.017 0.017 ↑ 39.2 8 1

Bitmap Index Scan on c_order_documentno_upper (cost=0.00..14.35 rows=314 width=0) (actual time=0.017..0.017 rows=8 loops=1)

  • Index Cond: (upper((documentno)::text) ~~ '%205%'::text)
11. 0.016 0.016 ↑ 1.0 1 1

Index Scan using c_doctype_key on c_doctype documentty2_ (cost=0.28..8.29 rows=1 width=37) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: ((c_doctype_id)::text = (order0_.c_doctype_id)::text)
Planning time : 1.552 ms
Execution time : 0.263 ms