explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4eoc

Settings
# exclusive inclusive rows x rows loops node
1. 925.632 67,110.331 ↓ 29.0 1,158,531 1

Sort (cost=1,445,941.46..1,446,141.46 rows=40,000 width=28) (actual time=66,743.324..67,110.331 rows=1,158,531 loops=1)

  • Sort Key: (time_bucket_gapfill('00:05:00'::interval, "timestamp")), bucket DESC
  • Sort Method: external merge Disk: 47312kB
2. 194.357 66,184.699 ↓ 29.0 1,158,531 1

Custom Scan (GapFill) (cost=1,442,783.92..1,442,883.92 rows=40,000 width=0) (actual time=65,673.788..66,184.699 rows=1,158,531 loops=1)

3. 1,616.431 65,990.342 ↓ 28.4 1,134,897 1

Sort (cost=1,442,783.92..1,442,883.92 rows=40,000 width=0) (actual time=65,673.779..65,990.342 rows=1,134,897 loops=1)

  • Sort Key: _hyper_1_21_chunk.bucket DESC, (time_bucket_gapfill('00:05:00'::interval, _hyper_1_21_chunk."timestamp"))
  • Sort Method: external merge Disk: 46776kB
4. 1,056.922 64,373.911 ↓ 28.4 1,134,897 1

Finalize GroupAggregate (cost=1,355,405.33..1,439,726.37 rows=40,000 width=0) (actual time=51,907.086..64,373.911 rows=1,134,897 loops=1)

  • Group Key: (time_bucket_gapfill('00:05:00'::interval, _hyper_1_21_chunk."timestamp")), _hyper_1_21_chunk.bucket
5. 0.000 63,316.989 ↓ 9.1 1,448,383 1

Gather Merge (cost=1,355,405.33..1,437,526.37 rows=160,000 width=52) (actual time=51,907.069..63,316.989 rows=1,448,383 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
6. 4,668.290 232,594.460 ↓ 7.2 289,677 5

Partial GroupAggregate (cost=1,354,405.27..1,417,468.77 rows=40,000 width=52) (actual time=43,886.211..46,518.892 rows=289,677 loops=5)

  • Group Key: (time_bucket_gapfill('00:05:00'::interval, _hyper_1_21_chunk."timestamp")), _hyper_1_21_chunk.bucket
7. 81,400.830 227,926.170 ↑ 1.3 4,002,980 5

Sort (cost=1,354,405.27..1,366,917.97 rows=5,005,080 width=20) (actual time=43,886.163..45,585.234 rows=4,002,980 loops=5)

  • Sort Key: (time_bucket_gapfill('00:05:00'::interval, _hyper_1_21_chunk."timestamp")), _hyper_1_21_chunk.bucket DESC
  • Sort Method: external merge Disk: 141680kB
  • Worker 0: Sort Method: external merge Disk: 113616kB
  • Worker 1: Sort Method: external merge Disk: 189480kB
  • Worker 2: Sort Method: external merge Disk: 141680kB
  • Worker 3: Sort Method: external merge Disk: 79856kB
8. 4,778.025 146,525.340 ↑ 1.3 4,002,980 5

Result (cost=0.00..677,225.25 rows=5,005,080 width=20) (actual time=213.067..29,305.068 rows=4,002,980 loops=5)

9. 2,309.359 141,747.315 ↑ 1.3 4,002,980 5

Parallel Append (cost=0.00..614,661.75 rows=5,005,080 width=20) (actual time=213.057..28,349.463 rows=4,002,980 loops=5)

10. 1,761.568 2,722.617 ↓ 2.4 68,706 1

Parallel Bitmap Heap Scan on _hyper_1_21_chunk (cost=975.98..7,064.16 rows=28,612 width=20) (actual time=1,001.087..2,722.617 rows=68,706 loops=1)

  • Recheck Cond: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
11. 961.049 961.049 ↓ 1.0 68,706 1

Bitmap Index Scan on _hyper_1_21_chunk_ueba_anomalies_timestamp_idx (cost=0.00..958.81 rows=68,669 width=0) (actual time=961.049..961.049 rows=68,706 loops=1)

  • Index Cond: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
12. 15,946.516 15,946.516 ↓ 4.0 3,474,669 1

Parallel Seq Scan on _hyper_1_25_chunk (cost=0.00..99,842.17 rows=868,878 width=20) (actual time=31.617..15,946.516 rows=3,474,669 loops=1)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
13. 36,927.395 36,927.395 ↑ 1.3 694,611 5

Parallel Seq Scan on _hyper_1_11_chunk (cost=0.00..99,800.12 rows=868,475 width=20) (actual time=8.469..7,385.479 rows=694,611 loops=5)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
14. 23,424.576 23,424.576 ↓ 4.0 3,472,032 1

Parallel Seq Scan on _hyper_1_20_chunk (cost=0.00..99,770.43 rows=868,228 width=20) (actual time=10.399..23,424.576 rows=3,472,032 loops=1)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
15. 26,147.442 26,147.442 ↓ 1.3 1,098,578 3

Parallel Seq Scan on _hyper_1_26_chunk (cost=0.00..94,705.61 rows=824,174 width=20) (actual time=68.247..8,715.814 rows=1,098,578 loops=3)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
16. 11,071.998 11,071.998 ↓ 2.0 1,593,192 2

Parallel Seq Scan on _hyper_1_29_chunk (cost=0.00..93,374.59 rows=797,067 width=20) (actual time=25.545..5,535.999 rows=1,593,192 loops=2)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
  • Rows Removed by Filter: 31532
17. 1,014.339 1,014.339 ↓ 2.4 317,228 1

Parallel Seq Scan on _hyper_1_22_chunk (cost=0.00..9,909.14 rows=132,210 width=20) (actual time=57.631..1,014.339 rows=317,228 loops=1)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
18. 563.737 563.737 ↓ 2.4 228,042 1

Parallel Seq Scan on _hyper_1_12_chunk (cost=0.00..7,122.44 rows=95,030 width=20) (actual time=5.950..563.737 rows=228,042 loops=1)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
19. 405.720 405.720 ↓ 2.4 227,725 1

Parallel Seq Scan on _hyper_1_19_chunk (cost=0.00..7,112.56 rows=94,904 width=20) (actual time=12.740..405.720 rows=227,725 loops=1)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
20. 8,640.495 8,640.495 ↓ 2.4 227,389 1

Parallel Seq Scan on _hyper_1_15_chunk (cost=0.00..7,101.18 rows=94,745 width=20) (actual time=18.937..8,640.495 rows=227,389 loops=1)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
21. 2,079.038 2,079.038 ↓ 2.4 227,361 1

Parallel Seq Scan on _hyper_1_23_chunk (cost=0.00..7,101.09 rows=94,740 width=20) (actual time=22.531..2,079.038 rows=227,361 loops=1)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
22. 1,066.461 1,066.461 ↓ 2.4 227,330 1

Parallel Seq Scan on _hyper_1_13_chunk (cost=0.00..7,099.79 rows=94,719 width=20) (actual time=9.110..1,066.461 rows=227,330 loops=1)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
23. 1,277.345 1,277.345 ↓ 2.4 227,195 1

Parallel Seq Scan on _hyper_1_9_chunk (cost=0.00..7,095.08 rows=94,672 width=20) (actual time=20.920..1,277.345 rows=227,195 loops=1)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
24. 1,357.861 1,357.861 ↓ 2.4 227,186 1

Parallel Seq Scan on _hyper_1_24_chunk (cost=0.00..7,095.01 rows=94,668 width=20) (actual time=14.114..1,357.861 rows=227,186 loops=1)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
25. 406.987 406.987 ↓ 2.4 227,161 1

Parallel Seq Scan on _hyper_1_10_chunk (cost=0.00..7,094.82 rows=94,655 width=20) (actual time=11.820..406.987 rows=227,161 loops=1)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
26. 545.552 545.552 ↓ 2.4 226,962 1

Parallel Seq Scan on _hyper_1_28_chunk (cost=0.00..7,089.19 rows=94,546 width=20) (actual time=48.882..545.552 rows=226,962 loops=1)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
27. 1,176.449 1,176.449 ↓ 2.4 226,996 1

Parallel Seq Scan on _hyper_1_17_chunk (cost=0.00..7,088.80 rows=94,587 width=20) (actual time=7.231..1,176.449 rows=226,996 loops=1)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
28. 4,343.444 4,343.444 ↓ 2.4 226,968 1

Parallel Seq Scan on _hyper_1_14_chunk (cost=0.00..7,087.80 rows=94,520 width=20) (actual time=7.527..4,343.444 rows=226,968 loops=1)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
29. 319.984 319.984 ↓ 2.4 226,775 1

Parallel Seq Scan on _hyper_1_8_chunk (cost=0.00..7,082.34 rows=94,490 width=20) (actual time=5.254..319.984 rows=226,775 loops=1)

  • Filter: (("timestamp" >= '2018-09-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2019-09-20 14:40:00'::timestamp without time zone))
Planning time : 1,254.881 ms
Execution time : 67,174.354 ms