explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LST6

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 0.090 ↓ 2.8 11 1

Seq Scan on mike_four (cost=17.970..19.090 rows=4 width=334) (actual time=0.085..0.090 rows=11 loops=1)

  • Filter: (NOT (mike_mike delta 1))
2.          

SubPlan (for Seq Scan)

3. 0.002 0.063 ↓ 0.0 0 1

Nested Loop Semi Join (cost=0.710..17.970 rows=1 width=4) (actual time=0.063..0.063 rows=0 loops=1)

  • Join Filter: (golf1.quebec = hotel_quebec.echo_alpha)
4. 0.006 0.006 ↓ 1.2 11 1

Seq Scan on mike_four tango (cost=0.000..1.090 rows=9 width=4) (actual time=0.003..0.006 rows=11 loops=1)

5. 0.007 0.055 ↓ 0.0 0 11

Materialize (cost=0.710..16.750 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=11)

6. 0.000 0.048 ↓ 0.0 0 1

Nested Loop (cost=0.710..16.740 rows=1 width=4) (actual time=0.048..0.048 rows=0 loops=1)

7. 0.048 0.048 ↓ 0.0 0 1

Index Scan using oscar on hotel_quebec (cost=0.290..8.300 rows=1 width=8) (actual time=0.048..0.048 rows=0 loops=1)

  • Index Cond: ((hotel_golf)::text = 'echo_tango'::text)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using juliet on victor (cost=0.420..8.440 rows=1 width=4) (never executed)

  • Index Cond: (quebec = hotel_quebec.lima)
  • Filter: (foxtrot AND (NOT seven))
Planning time : 1.156 ms
Execution time : 0.173 ms