explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zmL

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.097 ↓ 0.0 0 1

Limit (cost=34.25..34.26 rows=1 width=282) (actual time=0.097..0.097 rows=0 loops=1)

2. 0.008 0.096 ↓ 0.0 0 1

Sort (cost=34.25..34.26 rows=1 width=282) (actual time=0.096..0.096 rows=0 loops=1)

  • Sort Key: order0_.dateordered DESC, order0_.documentno DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.001 0.088 ↓ 0.0 0 1

Nested Loop (cost=8.87..34.24 rows=1 width=282) (actual time=0.088..0.088 rows=0 loops=1)

4. 0.000 0.087 ↓ 0.0 0 1

Nested Loop (cost=8.60..25.91 rows=1 width=222) (actual time=0.087..0.087 rows=0 loops=1)

5. 0.000 0.087 ↓ 0.0 0 1

Nested Loop (cost=8.33..17.55 rows=1 width=222) (actual time=0.087..0.087 rows=0 loops=1)

6. 0.010 0.087 ↓ 0.0 0 1

Hash Join (cost=8.33..15.52 rows=1 width=220) (actual time=0.087..0.087 rows=0 loops=1)

  • Hash Cond: ((businesspa1_.c_bpartner_id)::text = (order0_.c_bpartner_id)::text)
7. 0.006 0.006 ↑ 86.0 1 1

Seq Scan on c_bpartner businesspa1_ (cost=0.00..6.86 rows=86 width=51) (actual time=0.005..0.006 rows=1 loops=1)

8. 0.000 0.071 ↓ 0.0 0 1

Hash (cost=8.31..8.31 rows=1 width=202) (actual time=0.071..0.071 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
9. 0.071 0.071 ↓ 0.0 0 1

Index Scan Backward using c_order_client_org_date_docno on c_order order0_ (cost=0.28..8.31 rows=1 width=202) (actual time=0.071..0.071 rows=0 loops=1)

  • Index Cond: (((ad_client_id)::text = '39363B0921BB4293B48383844325E84C'::text) AND ((ad_org_id)::text = 'D270A5AC50874F8BA67A88EE977F8E3B'::text))
  • Filter: ((em_obpos_applications_id IS NOT NULL) AND ((docstatus)::text <> 'CJ'::text) AND ((docstatus)::text <> 'CA'::text) AND (em_obpos_isdeleted = 'N'::bpchar) AND (upper((documentno)::text) ~~ '$205%'::text) (...)
  • Rows Removed by Filter: 29
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on ad_org organizati2_ (cost=0.00..2.02 rows=1 width=4) (never executed)

  • Filter: ((ad_org_id)::text = 'D270A5AC50874F8BA67A88EE977F8E3B'::text)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using obpos_app_pk on obpos_applications obpos_appl3_ (cost=0.27..8.29 rows=1 width=66) (never executed)

  • Index Cond: ((obpos_applications_id)::text = (order0_.em_obpos_applications_id)::text)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using c_doctype_key on c_doctype documentty4_ (cost=0.27..8.29 rows=1 width=37) (never executed)

  • Index Cond: ((c_doctype_id)::text = (order0_.c_doctype_id)::text)
Planning time : 1.550 ms
Execution time : 0.293 ms