explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o7nl

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.041 ↑ 4.0 1 1

Append (cost=0.56..17.64 rows=4 width=1,488) (actual time=0.039..0.041 rows=1 loops=1)

2. 0.000 0.011 ↓ 0.0 0 1

Nested Loop (cost=0.56..6.56 rows=1 width=541) (actual time=0.011..0.011 rows=0 loops=1)

3. 0.011 0.011 ↓ 0.0 0 1

Index Scan using c_invoice_pkey on c_invoice i (cost=0.42..2.64 rows=1 width=352) (actual time=0.010..0.011 rows=0 loops=1)

  • Index Cond: (c_invoice_id = '5150196'::numeric)
  • Filter: (ispayschedulevalid <> 'Y'::bpchar)
  • Rows Removed by Filter: 1
4. 0.000 0.000 ↓ 0.0 0

Index Scan using c_doctype_pkey on c_doctype d (cost=0.14..2.36 rows=1 width=10) (never executed)

  • Index Cond: (c_doctype_id = i.c_doctype_id)
5. 0.002 0.030 ↑ 3.0 1 1

Subquery Scan on *SELECT* 2 (cost=0.98..11.08 rows=3 width=516) (actual time=0.028..0.030 rows=1 loops=1)

6. 0.015 0.028 ↑ 3.0 1 1

Nested Loop (cost=0.98..11.02 rows=3 width=460) (actual time=0.026..0.028 rows=1 loops=1)

7. 0.001 0.007 ↑ 1.0 1 1

Nested Loop (cost=0.56..5.02 rows=1 width=333) (actual time=0.006..0.007 rows=1 loops=1)

8. 0.004 0.004 ↑ 1.0 1 1

Index Scan using c_invoice_pkey on c_invoice i_1 (cost=0.42..2.64 rows=1 width=329) (actual time=0.003..0.004 rows=1 loops=1)

  • Index Cond: (c_invoice_id = '5150196'::numeric)
  • Filter: (ispayschedulevalid = 'Y'::bpchar)
9. 0.002 0.002 ↑ 1.0 1 1

Index Scan using c_doctype_pkey on c_doctype d_1 (cost=0.14..2.36 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=1)

  • Index Cond: (c_doctype_id = i_1.c_doctype_id)
10. 0.006 0.006 ↑ 3.0 1 1

Index Scan using idx_c_invoicepayschedule_c_invoice_id_c_invoicepayschedule_id on c_invoicepayschedule ips (cost=0.42..3.67 rows=3 width=35) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (c_invoice_id = '5150196'::numeric)
  • Filter: (isvalid = 'Y'::bpchar)
Planning time : 0.666 ms
Execution time : 0.142 ms