explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HgOu

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

Limit (cost=10,232.44..10,232.45 rows=1 width=14) (actual time=30.680..30.680 rows=0 loops=1)

2. 0.004 30.679 ↓ 0.0 0 1

Sort (cost=10,232.44..10,232.45 rows=1 width=14) (actual time=30.679..30.679 rows=0 loops=1)

  • Sort Key: inl.created
  • Sort Method: quicksort Memory: 25kB
3. 0.001 30.675 ↓ 0.0 0 1

Nested Loop (cost=34.19..10,232.43 rows=1 width=14) (actual time=30.675..30.675 rows=0 loops=1)

4. 30.674 30.674 ↓ 0.0 0 1

Index Scan using c_doctypetarget_id_c_invoice_idx on c_invoice (cost=0.42..10,194.64 rows=1 width=6) (actual time=30.674..30.674 rows=0 loops=1)

  • Index Cond: (c_doctypetarget_id = ANY ('{1000143,1000204,1000327,1000342}'::numeric[]))
  • Filter: ((docstatus = ANY ('{CO,CL}'::bpchar[])) AND (ad_org_id = 34800::numeric))
  • Rows Removed by Filter: 33285
5. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on c_invoiceline inl (cost=33.77..37.78 rows=1 width=20) (never executed)

  • Recheck Cond: ((c_invoice_id = c_invoice.c_invoice_id) AND (m_product_id = 1001646::numeric))
6. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=33.77..33.77 rows=1 width=0) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on c_invoiceline_invoice (cost=0.00..6.57 rows=285 width=0) (never executed)

  • Index Cond: (c_invoice_id = c_invoice.c_invoice_id)
8. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on c_invoiceline_product (cost=0.00..26.61 rows=1,356 width=0) (never executed)

  • Index Cond: (m_product_id = 1001646::numeric)
Planning time : 1.190 ms
Execution time : 30.754 ms