explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RahM

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.136 ↑ 1.2 237 1

Custom Scan (ChunkAppend) on candlestick (cost=0.42..296.74 rows=280 width=5) (actual time=0.066..0.136 rows=237 loops=1)

  • Chunks excluded during startup: 22
2. 0.068 0.126 ↑ 1.1 237 1

Bitmap Heap Scan on _hyper_1_25_chunk (cost=5.27..261.49 rows=258 width=5) (actual time=0.066..0.126 rows=237 loops=1)

  • Recheck Cond: ((symbol = 'GVTBTC'::text) AND ("time" > (now() - '04:00:00'::interval)))
  • Heap Blocks: exact=23
3. 0.058 0.058 ↑ 1.1 237 1

Bitmap Index Scan on _hyper_1_25_chunk_candlestick_symbol_time_idx (cost=0.00..5.21 rows=258 width=0) (actual time=0.058..0.058 rows=237 loops=1)

  • Index Cond: ((symbol = 'GVTBTC'::text) AND ("time" > (now() - '04:00:00'::interval)))