explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QXl5

Settings
# exclusive inclusive rows x rows loops node
1. 0.064 26,224.450 ↑ 1.0 1 1

Aggregate (cost=46,946.390..46,946.400 rows=1 width=64) (actual time=26,224.450..26,224.450 rows=1 loops=1)

2. 234.442 26,224.386 ↓ 12.0 12 1

Nested Loop (cost=0.000..46,946.370 rows=1 width=24) (actual time=1,184.744..26,224.386 rows=12 loops=1)

  • Join Filter: ((alpha_quebec.lima)::text = (victor.lima)::text)
  • Rows Removed by Join Filter: 1691964
3. 44.816 44.816 ↓ 204.0 204 1

Seq Scan on yankee victor (cost=0.000..12,297.950 rows=1 width=45) (actual time=23.704..44.816 rows=204 loops=1)

  • Filter: ((whiskey > 'alpha_kilo'::bigint) AND (whiskey < 'four'::bigint) AND (charlie < 'four'::bigint) AND (whiskey <> 0) AND (charlie <> 0))
  • Rows Removed by Filter: 210839
4. 25,945.128 25,945.128 ↓ 1.2 8,294 204

Seq Scan on quebec alpha_quebec (cost=0.000..34,564.040 rows=6,750 width=53) (actual time=0.034..127.182 rows=8,294 loops=204)

  • Filter: (((juliet)::text = 'bravo'::text) AND ((two)::text = 'uniform'::text))
  • Rows Removed by Filter: 202454
Planning time : 0.184 ms