explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E7fG

Settings
# exclusive inclusive rows x rows loops node
1. 0.617 8.345 ↓ 31.5 63 1

Sort (cost=29.45..29.46 rows=2 width=575) (actual time=8.342..8.345 rows=63 loops=1)

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

Index Scan using cars_make_model_variant on cars (cost=0.42..29.44 rows=2 width=575) (actual time=1.427..7.728 rows=63 loops=1)

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

SubPlan (for Index Scan)

4. 0.063 7.056 ↑ 1.0 1 63

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

5. 6.993 6.993 ↑ 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.111..0.111 rows=1 loops=63)

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