explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lnrT : Optimization for: plan #6lnh

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 145.959 423.632 ↓ 1.3 235,536 1

WindowAgg (cost=142,968.64..147,128.71 rows=184,892 width=30) (actual time=259.501..423.632 rows=235,536 loops=1)

  • Functions: 8
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 1.195 ms, Inlining 0.000 ms, Optimization 0.336 ms, Emission 6.536 ms, Total 8.068 ms"Execution Time: 438.498 ms
2. 135.360 277.673 ↓ 1.3 235,536 1

Sort (cost=142,968.64..143,430.87 rows=184,892 width=22) (actual time=259.476..277.673 rows=235,536 loops=1)

  • Sort Key: _hyper_1_101_chunk."timestamp", _hyper_1_101_chunk.machine_name, _hyper_1_101_chunk.segment_id
  • Sort Method: quicksort Memory: 24,546kB
3. 142.313 142.313 ↓ 1.3 235,536 1

Index Scan using _hyper_1_101_chunk_machine_telemetry_timestamp_idx on _hyper_1_101_chunk (cost=0.43..126,793.99 rows=184,892 width=22) (actual time=7.045..142.313 rows=235,536 loops=1)

  • Index Cond: (("timestamp" >= '2017-12-17 00:00:00+00'::timestamp with time zone) AND ("timestamp" <= '2017-12-18 00:00:00+00'::timestamp with time zone))