explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xdlV : Get order id

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.013 ↑ 1.0 1 1

Limit (cost=0.570..0.740 rows=1 width=926) (actual time=0.012..0.013 rows=1 loops=1)

2. 0.011 0.011 ↑ 44,618.0 1 1

Index Scan Backward using romeo_zulu on romeo_bravo papa_kilo (cost=0.570..7,508.670 rows=44,618 width=926) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: ((yankee >= 'oscar'::timestamp without time zone) AND (yankee <= 'kilo'::timestamp without time zone))
  • Filter: ((papa_xray >= 120000000) AND (papa_xray <= 840000000))
Planning time : 0.236 ms
Execution time : 0.041 ms