explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KaIp

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 52.697 ↑ 16.7 36 1

Finalize GroupAggregate (cost=28,359.62..28,673.99 rows=600 width=72) (actual time=52.644..52.697 rows=36 loops=1)

  • Group Key: (time_bucket('7 days'::interval, _hyper_44_666_chunk.occurrence_time)), pr.key
2. 0.000 56.281 ↑ 25.8 93 1

Gather Merge (cost=28,359.62..28,646.99 rows=2,400 width=72) (actual time=52.638..56.281 rows=93 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 0.215 229.610 ↑ 31.6 19 5

Sort (cost=27,359.56..27,361.06 rows=600 width=72) (actual time=45.920..45.922 rows=19 loops=5)

  • Sort Key: (time_bucket('7 days'::interval, _hyper_44_666_chunk.occurrence_time)), pr.key
  • Sort Method: quicksort Memory: 28kB
  • Worker 0: Sort Method: quicksort Memory: 27kB
  • Worker 1: Sort Method: quicksort Memory: 26kB
  • Worker 2: Sort Method: quicksort Memory: 27kB
  • Worker 3: Sort Method: quicksort Memory: 27kB
4. 23.455 229.395 ↑ 31.6 19 5

Partial HashAggregate (cost=27,324.38..27,331.88 rows=600 width=72) (actual time=45.870..45.879 rows=19 loops=5)

  • Group Key: time_bucket('7 days'::interval, _hyper_44_666_chunk.occurrence_time), pr.key
5. 9.751 205.940 ↑ 1.3 11,030 5

Nested Loop (cost=28.43..27,185.35 rows=13,903 width=72) (actual time=0.714..41.188 rows=11,030 loops=5)

6. 1.777 48.605 ↑ 1.3 3,690 5

Parallel Append (cost=28.43..20,638.41 rows=4,635 width=592) (actual time=0.688..9.721 rows=3,690 loops=5)

7. 4.084 4.549 ↓ 1.5 1,875 1

Parallel Bitmap Heap Scan on _hyper_44_666_chunk (cost=30.45..2,296.49 rows=1,218 width=589) (actual time=0.726..4.549 rows=1,875 loops=1)

  • Recheck Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
8. 0.465 0.465 ↑ 1.1 1,875 1

Bitmap Index Scan on _hyper_44_666_chunk_well_map_id_occurrence_time_idx (cost=0.00..29.93 rows=2,070 width=0) (actual time=0.465..0.465 rows=1,875 loops=1)

  • Index Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
9. 3.504 3.989 ↓ 1.5 1,839 1

Parallel Bitmap Heap Scan on _hyper_44_673_chunk (cost=30.37..2,289.49 rows=1,213 width=599) (actual time=0.743..3.989 rows=1,839 loops=1)

  • Recheck Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
10. 0.485 0.485 ↑ 1.1 1,839 1

Bitmap Index Scan on _hyper_44_673_chunk_well_map_id_occurrence_time_idx (cost=0.00..29.85 rows=2,062 width=0) (actual time=0.485..0.485 rows=1,839 loops=1)

  • Index Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
11. 5.309 5.741 ↓ 1.6 1,809 1

Parallel Bitmap Heap Scan on _hyper_44_667_chunk (cost=29.00..2,142.88 rows=1,135 width=589) (actual time=0.925..5.741 rows=1,809 loops=1)

  • Recheck Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
12. 0.432 0.432 ↑ 1.1 1,809 1

Bitmap Index Scan on _hyper_44_667_chunk_well_map_id_occurrence_time_idx (cost=0.00..28.52 rows=1,929 width=0) (actual time=0.432..0.432 rows=1,809 loops=1)

  • Index Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
13. 4.617 5.152 ↓ 1.6 1,709 1

Parallel Bitmap Heap Scan on _hyper_44_670_chunk (cost=28.43..2,081.36 rows=1,102 width=598) (actual time=0.849..5.152 rows=1,709 loops=1)

  • Recheck Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
14. 0.535 0.535 ↑ 1.1 1,709 1

Bitmap Index Scan on _hyper_44_670_chunk_well_map_id_occurrence_time_idx (cost=0.00..27.96 rows=1,873 width=0) (actual time=0.535..0.535 rows=1,709 loops=1)

  • Index Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
15. 3.286 3.806 ↑ 1.1 920 2

Parallel Bitmap Heap Scan on _hyper_44_671_chunk (cost=26.00..1,938.94 rows=1,025 width=599) (actual time=0.398..1.903 rows=920 loops=2)

  • Recheck Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
16. 0.520 0.520 ↓ 1.1 1,839 1

Bitmap Index Scan on _hyper_44_671_chunk_well_map_id_occurrence_time_idx (cost=0.00..25.56 rows=1,743 width=0) (actual time=0.520..0.520 rows=1,839 loops=1)

  • Index Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
17. 3.013 3.362 ↓ 1.8 1,721 1

Parallel Bitmap Heap Scan on _hyper_44_669_chunk (cost=24.70..1,799.11 rows=951 width=598) (actual time=0.567..3.362 rows=1,721 loops=1)

  • Recheck Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
18. 0.349 0.349 ↓ 1.1 1,721 1

Bitmap Index Scan on _hyper_44_669_chunk_well_map_id_occurrence_time_idx (cost=0.00..24.30 rows=1,617 width=0) (actual time=0.349..0.349 rows=1,721 loops=1)

  • Index Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
19. 6.214 6.855 ↑ 2.5 377 5

Parallel Bitmap Heap Scan on _hyper_44_665_chunk (cost=24.68..1,796.50 rows=950 width=582) (actual time=0.223..1.371 rows=377 loops=5)

  • Recheck Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
  • Heap Blocks: exact=208
20. 0.641 0.641 ↓ 1.2 1,884 1

Bitmap Index Scan on _hyper_44_665_chunk_well_map_id_occurrence_time_idx (cost=0.00..24.28 rows=1,615 width=0) (actual time=0.641..0.641 rows=1,884 loops=1)

  • Index Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
21. 5.600 6.171 ↑ 1.5 627 3

Parallel Bitmap Heap Scan on _hyper_44_664_chunk (cost=24.63..1,791.07 rows=947 width=581) (actual time=0.306..2.057 rows=627 loops=3)

  • Recheck Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
  • Heap Blocks: exact=887
22. 0.571 0.571 ↓ 1.2 1,882 1

Bitmap Index Scan on _hyper_44_664_chunk_well_map_id_occurrence_time_idx (cost=0.00..24.23 rows=1,610 width=0) (actual time=0.571..0.571 rows=1,882 loops=1)

  • Index Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
23. 1.928 2.112 ↓ 1.5 1,224 1

Parallel Bitmap Heap Scan on _hyper_44_668_chunk (cost=21.66..1,588.66 rows=839 width=594) (actual time=0.342..2.112 rows=1,224 loops=1)

  • Recheck Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
  • Heap Blocks: exact=1224
24. 0.184 0.184 ↑ 1.2 1,224 1

Bitmap Index Scan on _hyper_44_668_chunk_well_map_id_occurrence_time_idx (cost=0.00..21.30 rows=1,427 width=0) (actual time=0.184..0.184 rows=1,224 loops=1)

  • Index Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
25. 2.283 2.570 ↓ 1.8 1,418 1

Parallel Bitmap Heap Scan on _hyper_44_672_chunk (cost=20.72..1,489.05 rows=786 width=593) (actual time=0.470..2.570 rows=1,418 loops=1)

  • Recheck Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
  • Heap Blocks: exact=1418
26. 0.287 0.287 ↓ 1.1 1,418 1

Bitmap Index Scan on _hyper_44_672_chunk_well_map_id_occurrence_time_idx (cost=0.00..20.39 rows=1,336 width=0) (actual time=0.287..0.287 rows=1,418 loops=1)

  • Index Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
27. 1.832 2.065 ↓ 1.7 1,105 1

Parallel Bitmap Heap Scan on _hyper_44_663_chunk (cost=17.28..1,235.67 rows=651 width=587) (actual time=0.380..2.065 rows=1,105 loops=1)

  • Recheck Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
  • Heap Blocks: exact=1105
28. 0.233 0.233 ↑ 1.0 1,105 1

Bitmap Index Scan on _hyper_44_663_chunk_well_map_id_occurrence_time_idx (cost=0.00..17.00 rows=1,107 width=0) (actual time=0.233..0.233 rows=1,105 loops=1)

  • Index Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
29. 0.292 0.456 ↓ 1.6 143 1

Parallel Bitmap Heap Scan on _hyper_44_674_chunk (cost=3.04..166.01 rows=87 width=599) (actual time=0.191..0.456 rows=143 loops=1)

  • Recheck Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
  • Heap Blocks: exact=143
30. 0.164 0.164 ↑ 1.0 143 1

Bitmap Index Scan on _hyper_44_674_chunk_well_map_id_occurrence_time_idx (cost=0.00..3.00 rows=148 width=0) (actual time=0.164..0.164 rows=143 loops=1)

  • Index Cond: ((well_map_id = 16204) AND (occurrence_time >= '2019-05-04 17:28:09.886+00'::timestamp with time zone))
31. 147.584 147.584 ↑ 1.0 3 18,448

Function Scan on jsonb_each pr (cost=0.00..1.38 rows=3 width=64) (actual time=0.006..0.008 rows=3 loops=18,448)

  • Filter: (key = ANY ('{bus_voltage,vibration_x,auto_speed_source}'::text[]))
  • Rows Removed by Filter: 12
Planning time : 5.114 ms
Execution time : 56.743 ms