explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6lnh

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 139.526 115,417.145 ↓ 1.3 235,536 1

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

  • Functions: 8
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 1.162 ms, Inlining 0.000 ms, Optimization 0.312 ms, Emission 5.647 ms, Total 7.122 ms"Execution Time: 115,431.297 ms
2. 179.770 115,277.619 ↓ 1.3 235,536 1

Sort (cost=142,968.64..143,430.87 rows=184,892 width=22) (actual time=115,259.757..115,277.619 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. 115,097.849 115,097.849 ↓ 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=6.291..115,097.849 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))