explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U7HW : Optimization for: mv_reservations; uses denormalized reservations

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.021 15.604 ↑ 1.0 100 1

Limit (cost=3,438.35..3,438.60 rows=100 width=987) (actual time=15.561..15.604 rows=100 loops=1)

2. 0.530 15.583 ↑ 9.7 100 1

Sort (cost=3,438.35..3,440.79 rows=973 width=987) (actual time=15.558..15.583 rows=100 loops=1)

  • Sort Key: md_reservation_denormalized.id
  • Sort Method: top-N heapsort Memory: 126kB
3. 15.053 15.053 ↓ 1.1 1,050 1

Index Scan using idx_denormalize_order_status on md_reservation_denormalized (cost=0.42..3,401.17 rows=973 width=987) (actual time=0.062..15.053 rows=1,050 loops=1)

  • Index Cond: ((orderstatus)::text = 'ACCEPTED'::text)
  • Filter: ((selectedstartdate >= '2018-04-11 10:00:00+00'::timestamp with time zone) AND (selectedstartdate <= '2020-05-11 18:45:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 61