explain.depesz.com

PostgreSQL's explain analyze made readable

Result: puYt

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.051 ↑ 1.0 10 1

Limit (cost=0.55..20.38 rows=10 width=2,146) (actual time=0.045..0.051 rows=10 loops=1)

2. 0.051 0.051 ↑ 59,511.7 10 1

Index Scan using c_invoice_client_org_date_doc on c_invoice (cost=0.55..1,180,213.70 rows=595,117 width=2,146) (actual time=0.045..0.051 rows=10 loops=1)

  • Index Cond: (((ad_client_id)::text = '23C59575B9CF467C9620760EB255B389'::text) AND ((ad_org_id)::text = 'B843C30461EA4501935CB1D125C9C25A'::text))