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. 16,798.097 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. 933.658 46,518.892 ↓ 7.2 289,677 5 / 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. 16,280.166 45,585.234 ↑ 1.3 4,002,980 5 / 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. 955.605 29,305.068 ↑ 1.3 4,002,980 5 / 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. 461.872 28,349.463 ↑ 1.3 4,002,980 5 / 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. 352.314 544.523 ↓ 2.4 68,706 1 / 5

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. 192.210 192.210 ↓ 1.0 68,706 1 / 5

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. 3,189.303 3,189.303 ↓ 4.0 3,474,669 1 / 5

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. 7,385.479 7,385.479 ↑ 1.3 694,611 5 / 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. 4,684.915 4,684.915 ↓ 4.0 3,472,032 1 / 5

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. 5,229.488 5,229.488 ↓ 1.3 1,098,578 3 / 5

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. 2,214.400 2,214.400 ↓ 2.0 1,593,192 2 / 5

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. 202.868 202.868 ↓ 2.4 317,228 1 / 5

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. 112.747 112.747 ↓ 2.4 228,042 1 / 5

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. 81.144 81.144 ↓ 2.4 227,725 1 / 5

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. 1,728.099 1,728.099 ↓ 2.4 227,389 1 / 5

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. 415.808 415.808 ↓ 2.4 227,361 1 / 5

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. 213.292 213.292 ↓ 2.4 227,330 1 / 5

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. 255.469 255.469 ↓ 2.4 227,195 1 / 5

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. 271.572 271.572 ↓ 2.4 227,186 1 / 5

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. 81.397 81.397 ↓ 2.4 227,161 1 / 5

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. 109.110 109.110 ↓ 2.4 226,962 1 / 5

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. 235.290 235.290 ↓ 2.4 226,996 1 / 5

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. 868.689 868.689 ↓ 2.4 226,968 1 / 5

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. 63.997 63.997 ↓ 2.4 226,775 1 / 5

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