explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C9TG

Settings
# exclusive inclusive rows x rows loops node
1. 40.514 17,680.481 ↑ 1.0 1 1

Aggregate (cost=4,016.36..4,016.37 rows=1 width=8) (actual time=17,680.480..17,680.481 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=19,215 read=26,028
2. 68.250 17,639.967 ↓ 3.1 318,656 1

Custom Scan (ChunkAppend) on dbn0_hua_m2000.t1275071429 a (cost=0.43..3,763.35 rows=101,205 width=0) (actual time=29.959..17,639.967 rows=318,656 loops=1)

  • Startup Exclusion: true
  • Runtime Exclusion: false
  • Chunks excluded during startup: 47
  • Buffers: shared hit=19,215 read=26,028
3. 81.676 81.676 ↑ 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=29.955..81.676 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=3 read=51
4. 47.343 47.343 ↑ 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=15.739..47.343 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 read=55
5. 56.674 56.674 ↓ 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..401.81 rows=15,831 width=0) (actual time=33.664..56.674 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 read=55
6. 61.602 61.602 ↑ 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=14.486..61.602 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 read=70
7. 1,934.888 1,934.888 ↓ 15,953.0 15,953 1

Index Only Scan using _hyper_777_54072_chunk_t12750714291 on _timescaledb_internal._hyper_777_54072_chunk a_5 (cost=0.26..2.47 rows=1 width=0) (actual time=33.269..1,934.888 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: 15,953
  • Buffers: shared hit=2,301 read=1,851
8. 44.093 44.093 ↑ 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=15.429..44.093 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 read=53
9. 61.948 61.948 ↑ 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=11.702..61.948 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 read=60
10. 231.500 231.500 ↑ 1.0 11,527 1

Seq Scan on _timescaledb_internal._hyper_777_58417_chunk a_8 (cost=0.00..1,390.54 rows=11,527 width=0) (actual time=17.473..231.500 rows=11,527 loops=1)

  • Filter: ((a_8.resulttime >= to_timestamp('202006240000'::text, 'YYYYMMDDHH24MI'::text)) AND (a_8.resulttime < to_timestamp('202006250000'::text, 'YYYYMMDDHH24MI'::text)))
  • Buffers: shared read=1,160
11. 182.050 182.050 ↓ 10,058.0 10,058 1

Index Only Scan using _hyper_777_60698_chunk_t12750714291 on _timescaledb_internal._hyper_777_60698_chunk a_9 (cost=0.26..2.47 rows=1 width=0) (actual time=51.282..182.050 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: 10,058
  • Buffers: shared hit=27 read=1,093
12. 840.301 840.301 ↓ 10,717.0 10,717 1

Index Only Scan using _hyper_777_62553_chunk_t12750714291 on _timescaledb_internal._hyper_777_62553_chunk a_10 (cost=0.26..2.47 rows=1 width=0) (actual time=23.942..840.301 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: 10,717
  • Buffers: shared hit=19 read=1,160
13. 1,258.686 1,258.686 ↓ 15,752.0 15,752 1

Index Only Scan using _hyper_777_62908_chunk_t12750714291 on _timescaledb_internal._hyper_777_62908_chunk a_11 (cost=0.26..2.47 rows=1 width=0) (actual time=29.487..1,258.686 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: 15,752
  • Buffers: shared hit=3,593 read=1,821
14. 1,063.050 1,063.050 ↓ 11,095.0 11,095 1

Index Only Scan using _hyper_777_64780_chunk_t12750714291 on _timescaledb_internal._hyper_777_64780_chunk a_12 (cost=0.26..2.47 rows=1 width=0) (actual time=23.690..1,063.050 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: 11,095
  • Buffers: shared hit=25 read=1,204
15. 936.574 936.574 ↓ 15,558.0 15,558 1

Index Only Scan using _hyper_777_65984_chunk_t12750714291 on _timescaledb_internal._hyper_777_65984_chunk a_13 (cost=0.26..2.47 rows=1 width=0) (actual time=27.154..936.574 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: 15,558
  • Buffers: shared hit=2,042 read=1,789
16. 754.323 754.323 ↓ 10,669.0 10,669 1

Index Only Scan using _hyper_777_66825_chunk_t12750714291 on _timescaledb_internal._hyper_777_66825_chunk a_14 (cost=0.26..2.47 rows=1 width=0) (actual time=31.996..754.323 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: 10,669
  • Buffers: shared hit=20 read=1,155
17. 1,082.562 1,082.562 ↓ 16,125.0 16,125 1

Index Only Scan using _hyper_777_68010_chunk_t12750714291 on _timescaledb_internal._hyper_777_68010_chunk a_15 (cost=0.26..2.47 rows=1 width=0) (actual time=23.278..1,082.562 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: 16,125
  • Buffers: shared hit=3,610 read=1,917
18. 200.953 200.953 ↓ 10,258.0 10,258 1

Index Only Scan using _hyper_777_68832_chunk_t12750714291 on _timescaledb_internal._hyper_777_68832_chunk a_16 (cost=0.26..2.47 rows=1 width=0) (actual time=35.908..200.953 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: 10,258
  • Buffers: shared hit=22 read=1,120
19. 423.584 423.584 ↓ 10,836.0 10,836 1

Index Only Scan using _hyper_777_71044_chunk_t12750714291 on _timescaledb_internal._hyper_777_71044_chunk a_17 (cost=0.26..2.47 rows=1 width=0) (actual time=113.486..423.584 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: 10,836
  • Buffers: shared hit=33 read=1,180
20. 2,568.370 2,568.370 ↓ 12,894.0 12,894 1

Index Only Scan using _hyper_777_75655_chunk_t12750714291 on _timescaledb_internal._hyper_777_75655_chunk a_18 (cost=0.26..2.47 rows=1 width=0) (actual time=104.526..2,568.370 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: 12,894
  • Buffers: shared hit=1,734 read=1,488
21. 1,345.317 1,345.317 ↓ 16,808.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.26..2.47 rows=1 width=0) (actual time=249.773..1,345.317 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: 16,808
  • Buffers: shared read=1,928
22. 1,619.917 1,619.917 ↓ 12,230.0 12,230 1

Index Only Scan using _hyper_777_77582_chunk_t12750714291 on _timescaledb_internal._hyper_777_77582_chunk a_20 (cost=0.26..2.47 rows=1 width=0) (actual time=36.021..1,619.917 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: 12,230
  • Buffers: shared hit=2,398 read=1,412
23. 1,001.852 1,001.852 ↓ 10,914.0 10,914 1

Index Only Scan using _hyper_777_79643_chunk_t12750714291 on _timescaledb_internal._hyper_777_79643_chunk a_21 (cost=0.26..2.47 rows=1 width=0) (actual time=27.002..1,001.852 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: 10,914
  • Buffers: shared hit=36 read=1,189
24. 242.878 242.878 ↓ 9,929.0 9,929 1

Index Only Scan using _hyper_777_81610_chunk_t12750714291 on _timescaledb_internal._hyper_777_81610_chunk a_22 (cost=0.26..2.47 rows=1 width=0) (actual time=34.488..242.878 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: 9,929
  • Buffers: shared hit=31 read=1,087
25. 1,301.504 1,301.504 ↓ 16,979.0 16,979 1

Index Only Scan using _hyper_777_82953_chunk_t12750714291 on _timescaledb_internal._hyper_777_82953_chunk a_23 (cost=0.26..2.47 rows=1 width=0) (actual time=32.658..1,301.504 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: 16,979
  • Buffers: shared hit=3,288 read=1,979
26. 230.072 230.072 ↓ 10,598.0 10,598 1

Index Only Scan using _hyper_777_83744_chunk_t12750714291 on _timescaledb_internal._hyper_777_83744_chunk a_24 (cost=0.26..2.47 rows=1 width=0) (actual time=32.958..230.072 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: 10,598
  • Buffers: shared hit=33 read=1,151