explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0Pm2

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1,497.660 ↓ 0.0 0 1

Hash Anti Join (cost=23.070..24.680 rows=1 width=178) (actual time=1,497.660..1,497.660 rows=0 loops=1)

  • Hash Cond: ((hotel.quebec)::oid = alpha_seven.sierra)
2. 1,497.657 1,497.657 ↓ 0.0 0 1

Index Scan using echo on juliet_november hotel (cost=0.570..2.170 rows=1 width=178) (actual time=1,497.656..1,497.657 rows=0 loops=1)

  • Index Cond: (juliet_charlie = 'seven'::alpha_november)
3. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.000..10.000 rows=1,000 width=4) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Function Scan on four alpha_seven (cost=0.000..10.000 rows=1,000 width=4) (never executed)

Planning time : 0.181 ms
Execution time : 1,498.046 ms