explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b4kU : Optimization for: Bad plan; plan #eVXI

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 749.597 ↑ 1.0 1 1

Limit (cost=9.200..3,524,192.800 rows=1 width=563) (actual time=749.597..749.597 rows=1 loops=1)

2. 36.156 749.596 ↑ 1.0 1 1

Hash Join (cost=9.200..3,524,192.800 rows=1 width=563) (actual time=749.596..749.596 rows=1 loops=1)

  • Hash Cond: (sierra_zulu.sierra_uniform = seven.quebec_seven)
3. 361.677 713.420 ↑ 15.9 543,589 1

Nested Loop (cost=0.600..3,491,743.160 rows=8,650,944 width=563) (actual time=0.045..713.420 rows=543,589 loops=1)

4. 0.003 0.017 ↑ 1.0 2 1

Unique (cost=0.040..0.040 rows=2 width=32) (actual time=0.016..0.017 rows=2 loops=1)

5. 0.010 0.014 ↑ 1.0 2 1

Sort (cost=0.040..0.040 rows=2 width=32) (actual time=0.014..0.014 rows=2 loops=1)

  • Sort Key: "quebec_kilo".victor_juliet1
  • Sort Method: quicksort Memory: 25kB
6. 0.004 0.004 ↑ 1.0 2 1

Values Scan on "*VALUES*" (cost=0.000..0.030 rows=2 width=32) (actual time=0.004..0.004 rows=2 loops=1)

7. 351.726 351.726 ↑ 15.9 271,794 2

Index Scan using kilo on sierra_zulu (cost=0.570..1,702,616.840 rows=4,325,472 width=563) (actual time=0.031..175.863 rows=271,794 loops=2)

  • Index Cond: ((juliet)::text = "quebec_kilo".victor_juliet1)
8. 0.003 0.020 ↑ 1.0 1 1

Hash (cost=8.580..8.580 rows=1 width=4) (actual time=0.020..0.020 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.017 0.017 ↑ 1.0 1 1

Index Scan using victor_three on seven (cost=0.560..8.580 rows=1 width=4) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: ((oscar)::text = 'xray'::text)
Planning time : 0.617 ms
Execution time : 749.759 ms