explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tF4G

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.533 0.663 ↓ 0.0 0 1

Update on c_invoice (cost=0.42..154.37 rows=1 width=1,188) (actual time=0.663..0.663 rows=0 loops=1)

2. 0.051 0.130 ↑ 1.0 1 1

Index Scan using c_invoice_pkey on c_invoice (cost=0.42..154.37 rows=1 width=1,188) (actual time=0.128..0.130 rows=1 loops=1)

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

SubPlan (for Index Scan)

4. 0.012 0.079 ↑ 1.0 1 1

Aggregate (cost=145.92..145.93 rows=1 width=2) (actual time=0.078..0.079 rows=1 loops=1)

5. 0.067 0.067 ↑ 313.0 1 1

Index Scan using c_invoiceline_invoice on c_invoiceline il (cost=0.43..145.13 rows=313 width=2) (actual time=0.065..0.067 rows=1 loops=1)

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