explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oDV1 : Optimization for: plan #iLY

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.338 7,047.914 ↑ 1.1 576 1

Append (cost=0.00..411,335.39 rows=650 width=31) (actual time=233.791..7,047.914 rows=576 loops=1)

  • Subplans Removed: 28
2. 7,047.576 7,047.576 ↑ 1.1 576 1

Index Scan using arqlmed0118_idx_data_id_tag on arqlmed_0118 (cost=0.57..411,098.27 rows=622 width=31) (actual time=233.790..7,047.576 rows=576 loops=1)

  • Index Cond: ((data_ >= to_timestamp('01/01/2018 00:00:00'::text, 'dd/mm/yyyy hh24:mi:ss'::text)) AND (data_ <= to_timestamp('02/01/2018 00:00:00'::text, 'dd/mm/yyyy hh24:mi:ss'::text)) AND (id_tag = ANY ('{85564,264089}'::integer[])))