explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3vSL

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.020 ↓ 0.0 0 1

Nested Loop (cost=1.00..33.11 rows=1 width=9) (actual time=0.020..0.020 rows=0 loops=1)

  • Output: dt.isreturn, o.ref_invoice_id
  • Buffers: shared hit=2
2. 0.001 0.020 ↓ 0.0 0 1

Nested Loop (cost=0.72..24.79 rows=1 width=8) (actual time=0.020..0.020 rows=0 loops=1)

  • Output: dt.isreturn, ol.c_order_id
  • Buffers: shared hit=2
3. 0.001 0.019 ↓ 0.0 0 1

Nested Loop (cost=0.43..16.48 rows=1 width=2) (actual time=0.019..0.019 rows=0 loops=1)

  • Output: dt.isreturn
  • Buffers: shared hit=2
4. 0.018 0.018 ↓ 0.0 0 1

Index Scan using m_inout_pkey on xendra.m_inout io (cost=0.29..8.30 rows=1 width=7) (actual time=0.018..0.018 rows=0 loops=1)

  • Output: io.m_inout_id, io.ad_client_id, io.ad_org_id, io.isactive, io.created, io.createdby, io.updated, io.updatedby, io.issotrx, io.documentno, io.docaction, io.docstatus, io.posted, io.processing, io.processed, io.c_doctype_id, io.de (...)
  • Index Cond: (io.m_inout_id = 1::numeric)
  • Buffers: shared hit=2
5. 0.000 0.000 ↓ 0.0 0

Index Scan using c_doctype_pkey on xendra.c_doctype dt (cost=0.14..8.17 rows=1 width=8) (never executed)

  • Output: dt.c_doctype_id, dt.ad_client_id, dt.ad_org_id, dt.isactive, dt.created, dt.createdby, dt.updated, dt.updatedby, dt.name, dt.printname, dt.description, dt.docbasetype, dt.issotrx, dt.docsubtypeso, dt.hasproforma, dt.c_doctypepro (...)
  • Index Cond: (dt.c_doctype_id = io.c_doctype_id)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using c_orderline_pkey on xendra.c_orderline ol (cost=0.29..8.30 rows=1 width=6) (never executed)

  • Output: ol.c_orderline_id, ol.ad_client_id, ol.ad_org_id, ol.isactive, ol.created, ol.createdby, ol.updated, ol.updatedby, ol.c_order_id, ol.line, ol.c_bpartner_id, ol.c_bpartner_location_id, ol.dateordered, ol.datepromised, ol.datedelivered, (...)
  • Index Cond: (ol.c_orderline_id = 1::numeric)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using c_order_pkey on xendra.c_order o (cost=0.29..8.30 rows=1 width=13) (never executed)

  • Output: o.c_order_id, o.ad_client_id, o.ad_org_id, o.isactive, o.created, o.createdby, o.updated, o.updatedby, o.issotrx, o.documentno, o.docstatus, o.docaction, o.processing, o.processed, o.c_doctype_id, o.c_doctypetarget_id, o.description, o.isap (...)
  • Index Cond: (o.c_order_id = ol.c_order_id)
Planning time : 0.669 ms
Execution time : 0.161 ms