explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YDyp

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.106 ↑ 1.0 1 1

Limit (cost=0.43..8.45 rows=1 width=28) (actual time=0.105..0.106 rows=1 loops=1)

2. 0.105 0.105 ↑ 1.0 1 1

Index Scan using pk_roadworkrequestdates on roadworkrequestdates "Extent1" (cost=0.43..8.45 rows=1 width=28) (actual time=0.105..0.105 rows=1 loops=1)

  • Index Cond: (id = 80)
Planning time : 0.125 ms