explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i6tA

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1,660.016 ↑ 1.0 1 1

Limit (cost=0.430..36.160 rows=1 width=4) (actual time=1,660.015..1,660.016 rows=1 loops=1)

2. 1,660.013 1,660.013 ↑ 6,286.0 1 1

Index Scan using six on oscar kilo (cost=0.430..224,558.280 rows=6,286 width=4) (actual time=1,660.013..1,660.013 rows=1 loops=1)

  • Filter: ((romeo five NULL) AND (hotel = 31))
  • Rows Removed by Filter: 6626607
Planning time : 0.138 ms
Execution time : 1,660.036 ms