explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j4Ze : Test

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.631 1.631 ↓ 2.0 2 1
→

CTE Scan on priceframes (cost=32.97..33.10 rows=1 width=392) (actual time=1.436..1.631 rows=2 loops=1)

  • Filter: (price_frame_rank = 1)
  • Rows Removed by Filter: 9
2.          

CTE priceframes
3. 0.191 1.575 ↓ 1.8 11 1
→

WindowAgg (cost=32.70..32.97 rows=6 width=704) (actual time=1.425..1.575 rows=11 loops=1)

4. 0.066 1.384 ↓ 1.8 11 1
→

Sort (cost=32.70..32.71 rows=6 width=514) (actual time=1.381..1.384 rows=11 loops=1)

  • Sort Key: pf.valid_from, pf.valid_until, pf.l3_code DESC, pf.l2_code
  • Sort Method: quicksort Memory: 30kB
5. 1.318 1.318 ↓ 1.8 11 1
→

Seq Scan on price_frame pf (cost=0.00..32.62 rows=6 width=514) (actual time=0.024..1.318 rows=11 loops=1)

  • Filter: (('2019-11-12 12:13:57.818+00'::timestamp with time zone >= valid_from) AND ('2019-11-12 12:13:57.818+00'::timestamp with time zone <= COALESCE(valid_until, ('infinity'::date)::timestamp with time zone)) AND (l2_code = ANY ('{ (...)
  • Rows Removed by Filter: 475
Planning time : 0.911 ms
Execution time : 1.752 ms