explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vjqa : Optimization for: plan #5TXX

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 7.722 7.722 ↓ 2,144.0 2,144 1

CTE Scan on yankee (cost=510.890..514.420 rows=1 width=6) (actual time=5.434..7.722 rows=2,144 loops=1)

  • Filter: (five_zulu = 1)
2.          

CTE yankee

3. 1.377 6.964 ↓ 13.9 2,188 1

WindowAgg (cost=507.750..510.890 rows=157 width=11) (actual time=5.430..6.964 rows=2,188 loops=1)

4. 1.076 5.587 ↓ 13.9 2,188 1

Sort (cost=507.750..508.140 rows=157 width=11) (actual time=5.427..5.587 rows=2,188 loops=1)

  • Sort Key: sierra.foxtrot, (five_hotel(CASE WHEN ((sierra.xray)::smallint = 2) THEN ((sierra.papa)::numeric * 1.5) ELSE (sierra.papa)::numeric END))
  • Sort Method: quicksort Memory: 199kB
5. 3.093 4.511 ↓ 13.9 2,188 1

HashAggregate (cost=500.060..502.020 rows=157 width=11) (actual time=3.896..4.511 rows=2,188 loops=1)

  • Filter: (five_hotel(CASE WHEN ((sierra.xray)::smallint = 2) THEN ((sierra.papa)::numeric * 1.5) ELSE (sierra.papa)::numeric END) > 0::numeric)
6. 1.018 1.418 ↓ 2.3 3,613 1

Bitmap Heap Scan on sierra (cost=75.580..468.800 rows=1,563 width=11) (actual time=0.448..1.418 rows=3,613 loops=1)

  • Recheck Cond: (((six)::smallint = ANY ('seven'::integer[])) AND ((xray)::smallint = ANY ('kilo'::integer[])))
7. 0.400 0.400 ↓ 2.5 3,832 1

Bitmap Index Scan on lima (cost=0.000..75.190 rows=1,563 width=0) (actual time=0.400..0.400 rows=3,832 loops=1)

  • Index Cond: (((six)::smallint = ANY ('seven'::integer[])) AND ((xray)::smallint = ANY ('kilo'::integer[])))