explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KBlr

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

Limit (cost=0.86..6.37 rows=10 width=434) (actual time=0.033..0.079 rows=10 loops=1)

2. 0.012 0.077 ↑ 536,460.1 10 1

Nested Loop (cost=0.86..2,950,776.10 rows=5,364,601 width=434) (actual time=0.032..0.077 rows=10 loops=1)

3. 0.035 0.035 ↑ 536,460.1 10 1

Index Scan Backward using bravo on alpha_mike hotel (cost=0.43..219,255.63 rows=5,364,601 width=131) (actual time=0.024..0.035 rows=10 loops=1)

4. 0.030 0.030 ↑ 1.0 1 10

Index Scan using victor on foxtrot quebec_sierra (cost=0.43..0.51 rows=1 width=295) (actual time=0.003..0.003 rows=1 loops=10)

  • Index Cond: (quebec_seven = alpha_seven1.sierra)
Planning time : 0.233 ms
Execution time : 0.110 ms