explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R1mp

Settings
# exclusive inclusive rows x rows loops node
1. 42.912 406.722 ↑ 1.0 1 1

Aggregate (cost=8,597.07..8,597.08 rows=1 width=8) (actual time=406.721..406.722 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=1,140
2. 119.757 363.810 ↑ 1.0 318,656 1

Custom Scan (ChunkAppend) on dbn0_hua_m2000.t1275071429 a (cost=0.43..7,800.31 rows=318,704 width=0) (actual time=0.028..363.810 rows=318,656 loops=1)

  • Startup Exclusion: true
  • Runtime Exclusion: false
  • Chunks excluded during startup: 48
  • Buffers: shared hit=1,140
3. 4.033 4.033 ↑ 1.0 14,065 1

Index Only Scan using _hyper_777_51964_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_51964_chunk a_1 (cost=0.29..340.99 rows=14,065 width=0) (actual time=0.026..4.033 rows=14,065 loops=1)

  • Index Cond: ((a_1.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_1.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=51
4. 4.155 4.155 ↑ 1.0 14,744 1

Index Only Scan using _hyper_777_52137_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_52137_chunk a_2 (cost=0.29..365.57 rows=14,744 width=0) (actual time=0.104..4.155 rows=14,744 loops=1)

  • Index Cond: ((a_2.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_2.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=55
5. 4.482 4.482 ↑ 1.0 15,973 1

Index Only Scan using _hyper_777_52386_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_52386_chunk a_3 (cost=0.29..404.65 rows=15,973 width=0) (actual time=0.035..4.482 rows=15,973 loops=1)

  • Index Cond: ((a_3.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_3.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=55
6. 4.343 4.343 ↑ 1.0 15,384 1

Index Only Scan using _hyper_777_52619_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_52619_chunk a_4 (cost=0.29..391.57 rows=15,384 width=0) (actual time=0.086..4.343 rows=15,384 loops=1)

  • Index Cond: ((a_4.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_4.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=70
7. 4.503 4.503 ↑ 1.0 15,953 1

Index Only Scan using _hyper_777_54072_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_54072_chunk a_5 (cost=0.29..396.35 rows=15,953 width=0) (actual time=0.099..4.503 rows=15,953 loops=1)

  • Index Cond: ((a_5.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_5.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=60
8. 3.881 3.881 ↑ 1.0 13,709 1

Index Only Scan using _hyper_777_56284_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_56284_chunk a_6 (cost=0.29..339.37 rows=13,709 width=0) (actual time=0.038..3.881 rows=13,709 loops=1)

  • Index Cond: ((a_6.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_6.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=53
9. 4.498 4.498 ↑ 1.0 15,881 1

Index Only Scan using _hyper_777_57789_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_57789_chunk a_7 (cost=0.29..390.51 rows=15,881 width=0) (actual time=0.034..4.498 rows=15,881 loops=1)

  • Index Cond: ((a_7.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_7.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=60
10. 3.253 3.253 ↑ 1.0 11,527 1

Index Only Scan using _hyper_777_58417_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_58417_chunk a_8 (cost=0.29..266.03 rows=11,527 width=0) (actual time=0.112..3.253 rows=11,527 loops=1)

  • Index Cond: ((a_8.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_8.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=32
11. 15.924 15.924 ↑ 1.0 10,058 1

Index Only Scan using _hyper_777_60698_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_60698_chunk a_9 (cost=0.29..232.25 rows=10,058 width=0) (actual time=0.109..15.924 rows=10,058 loops=1)

  • Index Cond: ((a_9.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_9.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=28
12. 3.050 3.050 ↑ 1.0 10,717 1

Index Only Scan using _hyper_777_62553_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_62553_chunk a_10 (cost=0.29..248.73 rows=10,717 width=0) (actual time=0.133..3.050 rows=10,717 loops=1)

  • Index Cond: ((a_10.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_10.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=31
13. 17.531 17.531 ↑ 1.0 15,752 1

Index Only Scan using _hyper_777_62908_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_62908_chunk a_11 (cost=0.29..383.53 rows=15,752 width=0) (actual time=0.066..17.531 rows=15,752 loops=1)

  • Index Cond: ((a_11.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_11.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=57
14. 3.235 3.235 ↑ 1.0 11,095 1

Index Only Scan using _hyper_777_64780_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_64780_chunk a_12 (cost=0.29..256.29 rows=11,095 width=0) (actual time=0.144..3.235 rows=11,095 loops=1)

  • Index Cond: ((a_12.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_12.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=31
15. 4.933 4.933 ↑ 1.0 15,558 1

Index Only Scan using _hyper_777_65984_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_65984_chunk a_13 (cost=0.29..375.25 rows=15,558 width=0) (actual time=0.072..4.933 rows=15,558 loops=1)

  • Index Cond: ((a_13.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_13.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=55
16. 3.870 3.870 ↑ 1.0 10,669 1

Index Only Scan using _hyper_777_66825_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_66825_chunk a_14 (cost=0.29..246.67 rows=10,669 width=0) (actual time=0.187..3.870 rows=10,669 loops=1)

  • Index Cond: ((a_14.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_14.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=30
17. 17.991 17.991 ↑ 1.0 16,125 1

Index Only Scan using _hyper_777_68010_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_68010_chunk a_15 (cost=0.29..401.99 rows=16,125 width=0) (actual time=0.061..17.991 rows=16,125 loops=1)

  • Index Cond: ((a_15.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_15.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=68
18. 2.963 2.963 ↑ 1.0 10,258 1

Index Only Scan using _hyper_777_68832_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_68832_chunk a_16 (cost=0.29..239.55 rows=10,258 width=0) (actual time=0.164..2.963 rows=10,258 loops=1)

  • Index Cond: ((a_16.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_16.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=31
19. 16.206 16.206 ↑ 1.0 10,836 1

Index Only Scan using _hyper_777_71044_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_71044_chunk a_17 (cost=0.29..252.21 rows=10,836 width=0) (actual time=0.163..16.206 rows=10,836 loops=1)

  • Index Cond: ((a_17.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_17.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=32
20. 3.837 3.837 ↑ 1.0 12,894 1

Index Only Scan using _hyper_777_75655_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_75655_chunk a_18 (cost=0.29..315.37 rows=12,894 width=0) (actual time=0.144..3.837 rows=12,894 loops=1)

  • Index Cond: ((a_18.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_18.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=49
21. 18.048 18.048 ↑ 1.0 16,808 1

Index Only Scan using _hyper_777_77319_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_77319_chunk a_19 (cost=0.29..434.35 rows=16,808 width=0) (actual time=0.107..18.048 rows=16,808 loops=1)

  • Index Cond: ((a_19.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_19.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=83
22. 3.644 3.644 ↑ 1.0 12,230 1

Index Only Scan using _hyper_777_77582_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_77582_chunk a_20 (cost=0.29..297.69 rows=12,230 width=0) (actual time=0.101..3.644 rows=12,230 loops=1)

  • Index Cond: ((a_20.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_20.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=47
23. 10.466 10.466 ↑ 1.0 10,914 1

Index Only Scan using _hyper_777_79643_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_79643_chunk a_21 (cost=0.29..253.77 rows=10,914 width=0) (actual time=0.113..10.466 rows=10,914 loops=1)

  • Index Cond: ((a_21.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_21.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=32
24. 4.755 4.755 ↑ 1.0 9,929 1

Index Only Scan using _hyper_777_81610_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_81610_chunk a_22 (cost=0.29..229.67 rows=9,929 width=0) (actual time=0.185..4.755 rows=9,929 loops=1)

  • Index Cond: ((a_22.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_22.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=28
25. 78.957 78.957 ↑ 1.0 16,979 1

Index Only Scan using _hyper_777_82953_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_82953_chunk a_23 (cost=0.29..417.97 rows=16,979 width=0) (actual time=0.134..78.957 rows=16,979 loops=1)

  • Index Cond: ((a_23.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_23.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=70
26. 5.495 5.495 ↑ 1.0 10,598 1

Index Only Scan using _hyper_777_83744_chunk_t1275071429_resulttime_idx on _timescaledb_internal._hyper_777_83744_chunk a_24 (cost=0.29..247.45 rows=10,598 width=0) (actual time=0.300..5.495 rows=10,598 loops=1)

  • Index Cond: ((a_24.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_24.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Heap Fetches: 0
  • Buffers: shared hit=32
Planning time : 9.896 ms
Execution time : 409.059 ms