explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EVgE

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 10.776 ↓ 0.0 0 1

Limit (cost=0.290..3.700 rows=1 width=99) (actual time=10.776..10.776 rows=0 loops=1)

2. 0.000 10.775 ↓ 0.0 0 1

Nested Loop (cost=0.290..5,530.920 rows=1,622 width=99) (actual time=10.775..10.775 rows=0 loops=1)

3. 10.775 10.775 ↓ 0.0 0 1

Seq Scan on zulu_victor victor_kilo (cost=0.000..2,906.940 rows=4,170 width=8) (actual time=10.774..10.775 rows=0 loops=1)

  • Filter: ((uniform = 1) AND (two_quebec = 1) AND (bravo <= zulu_golf()))
  • Rows Removed by Filter: 87009
4. 0.000 0.000 ↓ 0.0 0

Index Scan using victor_two on whiskey two_four (cost=0.290..0.630 rows=1 width=95) (never executed)

  • Index Cond: (alpha = victor_kilo.alpha)
  • Filter: ((delta five NULL) AND (golf = 1) AND (six <= zulu_golf()) AND ((papa > zulu_golf()) OR (papa five NULL)))