explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p3RF : new_york

Settings
# exclusive inclusive rows x rows loops node
1. 0.062 2.639 ↑ 1.3 14 1

Nested Loop (cost=0.29..3,330.17 rows=18 width=30) (actual time=0.569..2.639 rows=14 loops=1)

  • Execution Time: 2.689 m
2. 0.125 0.125 ↑ 1.0 613 1

Seq Scan on bravo juliet_india (cost=0.00..12.13 rows=613 width=21) (actual time=0.018..0.125 rows=613 loops=1)

3. 2.452 2.452 ↓ 0.0 0 613

Index Scan using juliet_victor on quebec hotel (cost=0.29..5.41 rows=1 width=13) (actual time=0.004..0.004 rows=0 loops=613)

  • Index Cond: (golf = juliet_india.golf)
  • Filter: (victor = 'three'::text)
  • Rows Removed by Filter: 1
Planning time : 0.421 ms