explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X6Ij

Settings
# exclusive inclusive rows x rows loops node
1. 0.430 48.247 ↑ 1.0 301 1

Limit (cost=1.25..8,799.67 rows=301 width=227) (actual time=0.744..48.247 rows=301 loops=1)

2. 1.012 47.817 ↑ 44.9 301 1

Nested Loop (cost=1.25..395,257.97 rows=13,522 width=227) (actual time=0.743..47.817 rows=301 loops=1)

3. 0.807 45.902 ↑ 44.9 301 1

Nested Loop (cost=0.97..390,908.40 rows=13,522 width=169) (actual time=0.726..45.902 rows=301 loops=1)

4. 44.192 44.192 ↑ 44.9 301 1

Index Scan Backward using c_order_client_org_date_docno on c_order order0_ (cost=0.69..386,955.89 rows=13,522 width=142) (actual time=0.701..44.192 rows=301 loops=1)

  • Index Cond: (((ad_client_id)::text = 'E458618056C24D0088568C7F4E7AABD5'::text) AND ((ad_org_id)::text = 'F12573C4279D4225973A7EE7D5EFF60B'::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 (upper((documentno)::text) ~~ '%204%'::text) AND (((docstatus)::text <> 'CL'::text) OR (iscancelled = 'Y'::bpchar)))
  • Rows Removed by Filter: 14957
5. 0.903 0.903 ↑ 1.0 1 301

Index Scan using c_bpartner_key on c_bpartner businesspa1_ (cost=0.27..0.29 rows=1 width=60) (actual time=0.003..0.003 rows=1 loops=301)

  • Index Cond: ((c_bpartner_id)::text = (order0_.c_bpartner_id)::text)
6. 0.903 0.903 ↑ 1.0 1 301

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

  • Index Cond: ((c_doctype_id)::text = (order0_.c_doctype_id)::text)
Planning time : 0.839 ms
Execution time : 48.582 ms