explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eVXI : Bad plan

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 35,209.503 ↑ 1.0 1 1

Limit (cost=1,243,031.110..5,617,226.930 rows=1 width=563) (actual time=35,209.502..35,209.503 rows=1 loops=1)

2. 8,573.186 35,209.500 ↑ 1.0 1 1

Hash Join (cost=1,243,031.110..5,617,226.930 rows=1 width=563) (actual time=35,209.500..35,209.500 rows=1 loops=1)

  • Hash Cond: (sierra_zulu.sierra_uniform = seven.quebec)
3. 21,785.353 21,785.353 ↑ 1.0 85,781,309 1

Seq Scan on sierra_zulu (cost=0.000..4,051,454.200 rows=86,064,428 width=563) (actual time=0.140..21,785.353 rows=85,781,309 loops=1)

  • Filter: ((juliet)::text = ANY ('lima'::text[]))
  • Rows Removed by Filter: 4562849
4. 0.008 4,850.961 ↑ 1.0 1 1

Hash (cost=1,243,031.100..1,243,031.100 rows=1 width=4) (actual time=4,850.961..4,850.961 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 4,850.953 4,850.953 ↑ 1.0 1 1

Seq Scan on seven (cost=0.000..1,243,031.100 rows=1 width=4) (actual time=4,788.784..4,850.953 rows=1 loops=1)

  • Filter: ((oscar)::text = 'xray'::text)
  • Rows Removed by Filter: 45623971
Planning time : 0.428 ms
Execution time : 35,209.600 ms