explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hy4P : Optimization for: plan #kJok

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.269 66,347.198 ↓ 1.4 288 1

GroupAggregate (cost=405,377.20..405,388.40 rows=200 width=72) (actual time=66,346.928..66,347.198 rows=288 loops=1)

  • Group Key: arqlmed_1019.data_
2. 1.359 66,346.929 ↓ 1.1 576 1

Sort (cost=405,377.20..405,378.57 rows=547 width=19) (actual time=66,346.884..66,346.929 rows=576 loops=1)

  • Sort Key: arqlmed_1019.data_
  • Sort Method: quicksort Memory: 70kB
3. 0.281 66,345.570 ↓ 1.1 576 1

Append (cost=0.00..405,352.32 rows=547 width=19) (actual time=291.758..66,345.570 rows=576 loops=1)

  • Subplans Removed: 28
4. 66,345.289 66,345.289 ↓ 1.1 576 1

Index Scan using arqlmed1019_idx_data_id_tag on arqlmed_1019 (cost=0.57..405,115.71 rows=519 width=19) (actual time=291.757..66,345.289 rows=576 loops=1)

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