explain.depesz.com

PostgreSQL's explain analyze made readable

Result: z5DG : Optimization for: Optimization for: plan #q6NvM; plan #87Mx

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.003 0.031 ↑ 1.0 1 1

Limit (cost=0.29..2.68 rows=1 width=76) (actual time=0.031..0.031 rows=1 loops=1)

2. 0.028 0.028 ↑ 10.0 1 1

Index Scan Backward using index_reconciliations_on_order_id_and_reconcile_on on reconciliations (cost=0.29..24.21 rows=10 width=76) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: (order_id = 1,014)