explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oRJl

Settings
# exclusive inclusive rows x rows loops node
1. 0.530 53.668 ↓ 31.5 63 1

Sort (cost=11,086.72..11,086.72 rows=2 width=574) (actual time=53.664..53.668 rows=63 loops=1)

  • Sort Key: (((cars.current_price)::numeric / (cars.starting_price)::numeric))
  • Sort Method: quicksort Memory: 88kB
2. 52.067 53.138 ↓ 31.5 63 1

Seq Scan on cars (cost=0.00..11,086.70 rows=2 width=574) (actual time=0.700..53.138 rows=63 loops=1)

  • Filter: ((NOT sold) AND (lower((make)::text) = 'porsche'::text) AND (lower((model)::text) = 'panamera'::text))
  • Rows Removed by Filter: 80573
3.          

SubPlan (for Seq Scan)

4. 0.063 1.071 ↑ 1.0 1 63

Aggregate (cost=8.44..8.45 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=63)

5. 1.008 1.008 ↑ 1.0 1 63

Index Only Scan using prices_advert_id_created on prices (cost=0.42..8.44 rows=1 width=0) (actual time=0.015..0.016 rows=1 loops=63)

  • Index Cond: (advert_id = (cars.advert_id)::text)
  • Heap Fetches: 92
Planning time : 0.129 ms
Execution time : 54.337 ms