explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r6Kd

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.097 ↑ 2.0 1 1

Unique (cost=12.46..12.46 rows=2 width=20) (actual time=0.096..0.097 rows=1 loops=1)

2. 0.012 0.096 ↑ 1.0 2 1

Sort (cost=12.46..12.46 rows=2 width=20) (actual time=0.095..0.096 rows=2 loops=1)

  • Sort Key: capacity.dump_date DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.001 0.084 ↑ 1.0 2 1

Append (cost=0.00..12.45 rows=2 width=20) (actual time=0.025..0.084 rows=2 loops=1)

4. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on capacity (cost=0.00..0.00 rows=1 width=20) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: ((start_time = '2019-03-12 00:00:00+01'::timestamp with time zone) AND (border_id = 108) AND (data_source_id = 23) AND (capacity_type_id = 1) AND (forecast_interval = '1 day'::interval))
5. 0.078 0.078 ↓ 2.0 2 1

Index Scan using _hyper_1_21_chunk_capacity_start_time_idx on _hyper_1_21_chunk (cost=0.29..12.45 rows=1 width=20) (actual time=0.019..0.078 rows=2 loops=1)

  • Index Cond: (start_time = '2019-03-12 00:00:00+01'::timestamp with time zone)
  • Filter: ((border_id = 108) AND (data_source_id = 23) AND (capacity_type_id = 1) AND (forecast_interval = '1 day'::interval))
  • Rows Removed by Filter: 39
Planning time : 1.960 ms
Execution time : 0.145 ms