explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eK8J

Settings
# exclusive inclusive rows x rows loops node
1. 0.602 0.697 ↓ 0.0 0 1

Update on c_invoice (cost=0.08..72.12 rows=1 width=1,168) (actual time=0.697..0.697 rows=0 loops=1)

2. 0.056 0.095 ↑ 1.0 1 1

Index Scan using c_invoice_pkey on c_invoice (cost=0.08..72.12 rows=1 width=1,168) (actual time=0.093..0.095 rows=1 loops=1)

  • Index Cond: (c_invoice_id = 1503962::numeric)
3.          

SubPlan (for Index Scan)

4. 0.010 0.039 ↑ 1.0 1 1

Aggregate (cost=69.83..69.83 rows=1 width=2) (actual time=0.038..0.039 rows=1 loops=1)

5. 0.029 0.029 ↑ 453.0 1 1

Index Scan using c_invoiceline_invoice on c_invoiceline il (cost=0.09..69.60 rows=453 width=2) (actual time=0.027..0.029 rows=1 loops=1)

  • Index Cond: (c_invoice_id = c_invoice.c_invoice_id)
  • Filter: (isdescription = 'N'::bpchar)
Planning time : 0.941 ms
Execution time : 0.981 ms