explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EHdJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 942.735 ↓ 0.0 0 1

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

2. 0.005 942.733 ↓ 0.0 0 1

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

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

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

4. 942.727 942.727 ↓ 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=942.727..942.727 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 = 16921.33))
  • 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 = 1001371::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 = 1001371::numeric)
Planning time : 1.152 ms
Execution time : 942.822 ms