explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hMsA

Settings
# exclusive inclusive rows x rows loops node
1. 8.074 1,601.936 ↓ 10.0 9,790 1

Sort (cost=103,831.95..103,834.40 rows=979 width=1,039) (actual time=1,600.526..1,601.936 rows=9,790 loops=1)

  • Sort Key: p0.par_time_stamp
  • Sort Method: quicksort Memory: 2,933kB
2. 56.411 1,593.862 ↓ 10.0 9,790 1

HashAggregate (cost=103,773.53..103,783.32 rows=979 width=1,039) (actual time=1,587.647..1,593.862 rows=9,790 loops=1)

  • Group Key: p0.par_time_stamp, p0.par_meas_num, p0.par_min_val_num, p0.par_max_val_num, res_param.res_descr, res_dut.res_descr, p0.par_result, dut_2018.dut_identification, dut_2018.dut_id, dut_2018.dut_duration, "user".use_login, p0.par_config_comb_id, p0.par_config_name_id, config_name.cna_name, p0.par_type, p0.par_prod_info, p0.par_meas_text, p0.par_min_val_txt, p0.par_max_val_txt
3. 2.000 1,537.451 ↓ 1.7 16,912 1

Append (cost=13,914.40..103,308.64 rows=9,787 width=1,039) (actual time=88.325..1,537.451 rows=16,912 loops=1)

4. 38.396 644.461 ↓ 2.0 6,767 1

Gather (cost=13,914.40..40,953.85 rows=3,303 width=1,039) (actual time=88.325..644.461 rows=6,767 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 2.692 606.065 ↓ 1.6 2,256 3 / 3

Hash Join (cost=12,914.40..39,623.55 rows=1,376 width=1,039) (actual time=41.362..606.065 rows=2,256 loops=3)

  • Hash Cond: (p0.par_config_name_id = config_name.cna_id)
6. 2.635 602.897 ↓ 1.6 2,256 3 / 3

Hash Join (cost=12,913.17..39,606.18 rows=1,376 width=523) (actual time=40.590..602.897 rows=2,256 loops=3)

  • Hash Cond: (p0.par_result = res_param.res_id)
7. 5.920 599.773 ↓ 1.6 2,256 3 / 3

Nested Loop (cost=12,911.83..39,588.29 rows=1,376 width=305) (actual time=40.042..599.773 rows=2,256 loops=3)

  • Join Filter: (p1.par_last = p0.par_last)
  • Rows Removed by Join Filter: 1,670
8. 1.284 85.037 ↓ 1.9 1,298 3 / 3

Hash Join (cost=12,911.40..29,468.58 rows=668 width=268) (actual time=39.580..85.037 rows=1,298 loops=3)

  • Hash Cond: (dut_2018.dut_user_id = "user".use_id)
9. 1.527 83.028 ↓ 1.9 1,298 3 / 3

Hash Join (cost=12,903.49..29,452.25 rows=668 width=267) (actual time=38.834..83.028 rows=1,298 loops=3)

  • Hash Cond: (dut_2018.dut_result = res_dut.res_id)
10. 2.968 81.477 ↓ 1.9 1,298 3 / 3

Nested Loop (cost=12,902.15..29,442.88 rows=668 width=53) (actual time=38.798..81.477 rows=1,298 loops=3)

11. 42.034 69.423 ↓ 1.9 1,298 3 / 3

Parallel Bitmap Heap Scan on param_2018_8_1 p1 (cost=12,901.86..27,049.16 rows=668 width=14) (actual time=38.614..69.423 rows=1,298 loops=3)

  • Recheck Cond: ((par_config_comb_id = 369) AND (par_time_stamp > '2018-08-23 00:00:00'::timestamp without time zone) AND (par_time_stamp < '2018-08-30 00:00:00'::timestamp without time zone))
  • Filter: ((par_meas_num)::double precision > '0'::double precision)
  • Rows Removed by Filter: 153
  • Heap Blocks: exact=1,030
12. 0.289 27.389 ↓ 0.0 0 1 / 3

BitmapAnd (cost=12,901.86..12,901.86 rows=4,807 width=0) (actual time=82.166..82.166 rows=0 loops=1)

13. 1.991 1.991 ↑ 1.1 16,819 1 / 3

Bitmap Index Scan on param_2018_8_1_par_config_comb_id_idx (cost=0.00..348.09 rows=18,622 width=0) (actual time=5.974..5.974 rows=16,819 loops=1)

  • Index Cond: (par_config_comb_id = 369)
14. 25.109 25.109 ↓ 1.0 600,136 1 / 3

Bitmap Index Scan on param_2018_8_1_par_time_stamp_idx (cost=0.00..12,552.71 rows=598,428 width=0) (actual time=75.326..75.326 rows=600,136 loops=1)

  • Index Cond: ((par_time_stamp > '2018-08-23 00:00:00'::timestamp without time zone) AND (par_time_stamp < '2018-08-30 00:00:00'::timestamp without time zone))
15. 9.086 9.086 ↑ 1.0 1 3,894 / 3

Index Scan using dut_2018_dut_id_idx on dut_2018 (cost=0.29..3.57 rows=1 width=39) (actual time=0.006..0.007 rows=1 loops=3,894)

  • Index Cond: (dut_id = p1.par_dut_id)
16. 0.010 0.024 ↑ 1.0 15 3 / 3

Hash (cost=1.15..1.15 rows=15 width=222) (actual time=0.024..0.024 rows=15 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
17. 0.014 0.014 ↑ 1.0 15 3 / 3

Seq Scan on result res_dut (cost=0.00..1.15 rows=15 width=222) (actual time=0.011..0.014 rows=15 loops=3)

18. 0.088 0.725 ↓ 1.2 326 3 / 3

Hash (cost=4.63..4.63 rows=263 width=17) (actual time=0.725..0.725 rows=326 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 25kB
19. 0.637 0.637 ↓ 1.2 326 3 / 3

Seq Scan on "user" (cost=0.00..4.63 rows=263 width=17) (actual time=0.560..0.637 rows=326 loops=3)

20. 508.816 508.816 ↓ 1.5 3 3,894 / 3

Index Scan using param_2018_8_1_par_dut_id_idx on param_2018_8_1 p0 (cost=0.43..15.12 rows=2 width=65) (actual time=0.113..0.392 rows=3 loops=3,894)

  • Index Cond: (par_dut_id = dut_2018.dut_id)
  • Filter: ((par_time_stamp > '2018-08-23 00:00:00'::timestamp without time zone) AND (par_time_stamp < '2018-08-30 00:00:00'::timestamp without time zone) AND (par_config_comb_id = ANY ('{369,775,880,1620,1723,2415}'::bigint[])))
  • Rows Removed by Filter: 411
21. 0.018 0.489 ↑ 1.0 15 3 / 3

Hash (cost=1.15..1.15 rows=15 width=222) (actual time=0.489..0.489 rows=15 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
22. 0.471 0.471 ↑ 1.0 15 3 / 3

Seq Scan on result res_param (cost=0.00..1.15 rows=15 width=222) (actual time=0.462..0.471 rows=15 loops=3)

23. 0.024 0.476 ↑ 1.0 10 3 / 3

Hash (cost=1.10..1.10 rows=10 width=524) (actual time=0.476..0.476 rows=10 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
24. 0.452 0.452 ↑ 1.0 10 3 / 3

Seq Scan on config_name (cost=0.00..1.10 rows=10 width=524) (actual time=0.450..0.452 rows=10 loops=3)

25. 29.982 109.101 ↑ 1.7 848 1

Gather (cost=1,044.97..8,016.96 rows=1,435 width=1,039) (actual time=11.810..109.101 rows=848 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
26. 0.522 79.119 ↑ 2.0 424 2 / 2

Hash Join (cost=44.97..6,873.46 rows=844 width=1,039) (actual time=4.715..79.119 rows=424 loops=2)

  • Hash Cond: (p0_1.par_config_name_id = config_name_1.cna_id)
27. 0.462 77.934 ↑ 2.0 424 2 / 2

Hash Join (cost=43.75..6,862.32 rows=844 width=523) (actual time=3.962..77.934 rows=424 loops=2)

  • Hash Cond: (p0_1.par_result = res_param_1.res_id)
28. 0.833 76.813 ↑ 2.0 424 2 / 2

Nested Loop (cost=42.41..6,850.83 rows=844 width=305) (actual time=3.261..76.813 rows=424 loops=2)

  • Join Filter: (p1_1.par_last = p0_1.par_last)
  • Rows Removed by Join Filter: 261
29. 0.251 9.228 ↓ 1.1 224 2 / 2

Hash Join (cost=41.99..4,458.73 rows=195 width=268) (actual time=2.331..9.228 rows=224 loops=2)

  • Hash Cond: (dut_2018_1.dut_user_id = user_1.use_id)
30. 0.267 8.069 ↓ 1.1 224 2 / 2

Hash Join (cost=34.07..4,448.36 rows=195 width=267) (actual time=1.408..8.069 rows=224 loops=2)

  • Hash Cond: (dut_2018_1.dut_result = res_dut_1.res_id)
31. 0.670 7.752 ↓ 1.1 224 2 / 2

Nested Loop (cost=32.74..4,444.67 rows=195 width=53) (actual time=1.343..7.752 rows=224 loops=2)

32. 5.464 5.738 ↓ 1.1 224 2 / 2

Parallel Bitmap Heap Scan on param_2018_8_2 p1_1 (cost=32.44..3,196.96 rows=195 width=14) (actual time=1.293..5.738 rows=224 loops=2)

  • Recheck Cond: (par_config_comb_id = 775)
  • Filter: ((par_time_stamp > '2018-08-23 00:00:00'::timestamp without time zone) AND (par_time_stamp < '2018-08-30 00:00:00'::timestamp without time zone) AND ((par_meas_num)::double precision > '0'::double precision))
  • Rows Removed by Filter: 563
  • Heap Blocks: exact=649
33. 0.274 0.274 ↑ 1.0 1,573 1 / 2

Bitmap Index Scan on param_2018_8_2_par_config_comb_id_idx (cost=0.00..32.36 rows=1,592 width=0) (actual time=0.548..0.548 rows=1,573 loops=1)

  • Index Cond: (par_config_comb_id = 775)
34. 1.344 1.344 ↑ 1.0 1 448 / 2

Index Scan using dut_2018_dut_id_idx on dut_2018 dut_2018_1 (cost=0.29..6.39 rows=1 width=39) (actual time=0.006..0.006 rows=1 loops=448)

  • Index Cond: (dut_id = p1_1.par_dut_id)
35. 0.010 0.050 ↑ 1.0 15 2 / 2

Hash (cost=1.15..1.15 rows=15 width=222) (actual time=0.050..0.050 rows=15 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
36. 0.040 0.040 ↑ 1.0 15 2 / 2

Seq Scan on result res_dut_1 (cost=0.00..1.15 rows=15 width=222) (actual time=0.037..0.040 rows=15 loops=2)

37. 0.082 0.908 ↓ 1.2 326 2 / 2

Hash (cost=4.63..4.63 rows=263 width=17) (actual time=0.908..0.908 rows=326 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 25kB
38. 0.826 0.826 ↓ 1.2 326 2 / 2

Seq Scan on "user" user_1 (cost=0.00..4.63 rows=263 width=17) (actual time=0.714..0.826 rows=326 loops=2)

39. 66.752 66.752 ↑ 1.7 3 448 / 2

Index Scan using param_2018_8_2_par_dut_id_idx on param_2018_8_2 p0_1 (cost=0.42..12.20 rows=5 width=65) (actual time=0.095..0.298 rows=3 loops=448)

  • Index Cond: (par_dut_id = dut_2018_1.dut_id)
  • Filter: ((par_time_stamp > '2018-08-23 00:00:00'::timestamp without time zone) AND (par_time_stamp < '2018-08-30 00:00:00'::timestamp without time zone) AND (par_config_comb_id = ANY ('{369,775,880,1620,1723,2415}'::bigint[])))
  • Rows Removed by Filter: 384
40. 0.018 0.659 ↑ 1.0 15 2 / 2

Hash (cost=1.15..1.15 rows=15 width=222) (actual time=0.659..0.659 rows=15 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
41. 0.641 0.641 ↑ 1.0 15 2 / 2

Seq Scan on result res_param_1 (cost=0.00..1.15 rows=15 width=222) (actual time=0.638..0.641 rows=15 loops=2)

42. 0.018 0.663 ↑ 1.0 10 2 / 2

Hash (cost=1.10..1.10 rows=10 width=524) (actual time=0.663..0.663 rows=10 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
43. 0.645 0.645 ↑ 1.0 10 2 / 2

Seq Scan on config_name config_name_1 (cost=0.00..1.10 rows=10 width=524) (actual time=0.643..0.645 rows=10 loops=2)

44. 20.398 714.726 ↓ 2.1 8,897 1

Gather (cost=16,707.92..47,607.86 rows=4,224 width=1,039) (actual time=83.643..714.726 rows=8,897 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
45. 3.031 694.328 ↓ 1.7 2,966 3 / 3

Hash Join (cost=15,707.92..46,185.46 rows=1,760 width=1,039) (actual time=51.161..694.328 rows=2,966 loops=3)

  • Hash Cond: (p0_2.par_config_name_id = config_name_2.cna_id)
46. 3.003 690.602 ↓ 1.7 2,966 3 / 3

Hash Join (cost=15,706.70..46,163.58 rows=1,760 width=523) (actual time=50.343..690.602 rows=2,966 loops=3)

  • Hash Cond: (p0_2.par_result = res_param_2.res_id)
47. 5.267 686.915 ↓ 1.7 2,966 3 / 3

Nested Loop (cost=15,705.36..46,141.06 rows=1,760 width=305) (actual time=49.619..686.915 rows=2,966 loops=3)

  • Join Filter: (p1_2.par_last = p0_2.par_last)
  • Rows Removed by Join Filter: 2,211
48. 1.693 104.780 ↓ 2.1 1,658 3 / 3

Hash Join (cost=15,704.93..34,476.06 rows=779 width=268) (actual time=48.822..104.780 rows=1,658 loops=3)

  • Hash Cond: (dut_2018_2.dut_user_id = user_2.use_id)
49. 1.945 101.906 ↓ 2.1 1,658 3 / 3

Hash Join (cost=15,697.01..34,458.33 rows=779 width=267) (actual time=47.626..101.906 rows=1,658 loops=3)

  • Hash Cond: (dut_2018_2.dut_result = res_dut_2.res_id)
50. 4.682 99.936 ↓ 2.1 1,658 3 / 3

Nested Loop (cost=15,695.68..34,447.62 rows=779 width=53) (actual time=47.574..99.936 rows=1,658 loops=3)

51. 56.828 83.650 ↓ 2.1 1,658 3 / 3

Parallel Bitmap Heap Scan on param_2018_8_3 p1_2 (cost=15,695.38..31,843.84 rows=779 width=14) (actual time=47.507..83.650 rows=1,658 loops=3)

  • Recheck Cond: ((par_config_comb_id = 880) AND (par_time_stamp > '2018-08-23 00:00:00'::timestamp without time zone) AND (par_time_stamp < '2018-08-30 00:00:00'::timestamp without time zone))
  • Filter: ((par_meas_num)::double precision > '0'::double precision)
  • Rows Removed by Filter: 191
  • Heap Blocks: exact=1,299
52. 0.409 26.822 ↓ 0.0 0 1 / 3

BitmapAnd (cost=15,695.38..15,695.38 rows=5,611 width=0) (actual time=80.466..80.466 rows=0 loops=1)

53. 1.474 1.474 ↓ 1.0 18,541 1 / 3

Bitmap Index Scan on param_2018_8_3_par_config_comb_id_idx (cost=0.00..343.34 rows=18,521 width=0) (actual time=4.422..4.422 rows=18,541 loops=1)

  • Index Cond: (par_config_comb_id = 880)
54. 24.939 24.939 ↑ 1.0 731,260 1 / 3

Bitmap Index Scan on param_2018_8_3_par_time_stamp_idx (cost=0.00..15,350.86 rows=731,843 width=0) (actual time=74.818..74.818 rows=731,260 loops=1)

  • Index Cond: ((par_time_stamp > '2018-08-23 00:00:00'::timestamp without time zone) AND (par_time_stamp < '2018-08-30 00:00:00'::timestamp without time zone))
55. 11.604 11.604 ↑ 1.0 1 4,973 / 3

Index Scan using dut_2018_dut_id_idx on dut_2018 dut_2018_2 (cost=0.29..3.33 rows=1 width=39) (actual time=0.007..0.007 rows=1 loops=4,973)

  • Index Cond: (dut_id = p1_2.par_dut_id)
56. 0.012 0.025 ↑ 1.0 15 3 / 3

Hash (cost=1.15..1.15 rows=15 width=222) (actual time=0.025..0.025 rows=15 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
57. 0.013 0.013 ↑ 1.0 15 3 / 3

Seq Scan on result res_dut_2 (cost=0.00..1.15 rows=15 width=222) (actual time=0.010..0.013 rows=15 loops=3)

58. 0.084 1.181 ↓ 1.2 326 3 / 3

Hash (cost=4.63..4.63 rows=263 width=17) (actual time=1.181..1.181 rows=326 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 25kB
59. 1.097 1.097 ↓ 1.2 326 3 / 3

Seq Scan on "user" user_2 (cost=0.00..4.63 rows=263 width=17) (actual time=1.027..1.097 rows=326 loops=3)

60. 576.868 576.868 ↓ 1.5 3 4,973 / 3

Index Scan using param_2018_8_3_par_dut_id_idx on param_2018_8_3 p0_2 (cost=0.43..14.95 rows=2 width=65) (actual time=0.105..0.348 rows=3 loops=4,973)

  • Index Cond: (par_dut_id = dut_2018_2.dut_id)
  • Filter: ((par_time_stamp > '2018-08-23 00:00:00'::timestamp without time zone) AND (par_time_stamp < '2018-08-30 00:00:00'::timestamp without time zone) AND (par_config_comb_id = ANY ('{369,775,880,1620,1723,2415}'::bigint[])))
  • Rows Removed by Filter: 400
61. 0.013 0.684 ↑ 1.0 15 3 / 3

Hash (cost=1.15..1.15 rows=15 width=222) (actual time=0.684..0.684 rows=15 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
62. 0.671 0.671 ↑ 1.0 15 3 / 3

Seq Scan on result res_param_2 (cost=0.00..1.15 rows=15 width=222) (actual time=0.669..0.671 rows=15 loops=3)

63. 0.011 0.695 ↑ 1.0 10 3 / 3

Hash (cost=1.10..1.10 rows=10 width=524) (actual time=0.695..0.695 rows=10 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
64. 0.684 0.684 ↑ 1.0 10 3 / 3

Seq Scan on config_name config_name_2 (cost=0.00..1.10 rows=10 width=524) (actual time=0.681..0.684 rows=10 loops=3)

65. 0.001 0.363 ↓ 0.0 0 1

Nested Loop (cost=27.13..64.30 rows=1 width=1,039) (actual time=0.363..0.363 rows=0 loops=1)

66. 0.000 0.362 ↓ 0.0 0 1

Nested Loop (cost=26.98..64.14 rows=1 width=1,038) (actual time=0.362..0.362 rows=0 loops=1)

  • Join Filter: (p0_3.par_config_name_id = config_name_3.cna_id)
67. 0.001 0.362 ↓ 0.0 0 1

Nested Loop (cost=26.98..62.91 rows=1 width=522) (actual time=0.362..0.362 rows=0 loops=1)

68. 0.001 0.361 ↓ 0.0 0 1

Nested Loop (cost=26.85..62.76 rows=1 width=308) (actual time=0.361..0.361 rows=0 loops=1)

69. 0.000 0.360 ↓ 0.0 0 1

Nested Loop (cost=26.71..61.48 rows=1 width=90) (actual time=0.360..0.360 rows=0 loops=1)

  • Join Filter: (p1_3.par_last = p0_3.par_last)
70. 0.001 0.360 ↓ 0.0 0 1

Nested Loop (cost=26.42..49.87 rows=1 width=53) (actual time=0.360..0.360 rows=0 loops=1)

71. 0.062 0.359 ↓ 0.0 0 1

Bitmap Heap Scan on param_2018_8_4 p1_3 (cost=26.13..41.55 rows=1 width=14) (actual time=0.359..0.359 rows=0 loops=1)

  • Recheck Cond: ((par_config_comb_id = 1,620) AND (par_time_stamp > '2018-08-23 00:00:00'::timestamp without time zone) AND (par_time_stamp < '2018-08-30 00:00:00'::timestamp without time zone))
  • Filter: ((par_meas_num)::double precision > '0'::double precision)
  • Rows Removed by Filter: 5
  • Heap Blocks: exact=4
72. 0.014 0.297 ↓ 0.0 0 1

BitmapAnd (cost=26.13..26.13 rows=4 width=0) (actual time=0.297..0.297 rows=0 loops=1)

73. 0.098 0.098 ↓ 1.1 428 1

Bitmap Index Scan on param_2018_8_4_par_config_comb_id_idx (cost=0.00..11.24 rows=393 width=0) (actual time=0.098..0.098 rows=428 loops=1)

  • Index Cond: (par_config_comb_id = 1,620)
74. 0.185 0.185 ↓ 1.3 826 1

Bitmap Index Scan on param_2018_8_4_par_time_stamp_idx (cost=0.00..14.64 rows=635 width=0) (actual time=0.185..0.185 rows=826 loops=1)

  • Index Cond: ((par_time_stamp > '2018-08-23 00:00:00'::timestamp without time zone) AND (par_time_stamp < '2018-08-30 00:00:00'::timestamp without time zone))
75. 0.000 0.000 ↓ 0.0 0

Index Scan using dut_2018_dut_id_idx on dut_2018 dut_2018_3 (cost=0.29..8.31 rows=1 width=39) (never executed)

  • Index Cond: (dut_id = p1_3.par_dut_id)
76. 0.000 0.000 ↓ 0.0 0

Index Scan using param_2018_8_4_par_dut_id_idx on param_2018_8_4 p0_3 (cost=0.29..11.60 rows=1 width=65) (never executed)

  • Index Cond: (par_dut_id = dut_2018_3.dut_id)
  • Filter: ((par_time_stamp > '2018-08-23 00:00:00'::timestamp without time zone) AND (par_time_stamp < '2018-08-30 00:00:00'::timestamp without time zone) AND (par_config_comb_id = ANY ('{369,775,880,1620,1723,2415}'::bigint[])))
77. 0.000 0.000 ↓ 0.0 0

Index Scan using result_pkey on result res_param_3 (cost=0.14..1.15 rows=1 width=222) (never executed)

  • Index Cond: (res_id = p0_3.par_result)
78. 0.000 0.000 ↓ 0.0 0

Index Scan using result_pkey on result res_dut_3 (cost=0.14..0.15 rows=1 width=222) (never executed)

  • Index Cond: (res_id = dut_2018_3.dut_result)
79. 0.000 0.000 ↓ 0.0 0

Seq Scan on config_name config_name_3 (cost=0.00..1.10 rows=10 width=524) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Index Scan using user_pkey on "user" user_3 (cost=0.15..0.17 rows=1 width=17) (never executed)

  • Index Cond: (use_id = dut_2018_3.dut_user_id)
81. 0.006 2.333 ↓ 6.0 6 1

Nested Loop (cost=48.91..142.89 rows=1 width=1,039) (actual time=0.711..2.333 rows=6 loops=1)

82. 0.010 2.297 ↓ 6.0 6 1

Nested Loop (cost=48.77..142.72 rows=1 width=1,038) (actual time=0.687..2.297 rows=6 loops=1)

83. 0.007 2.245 ↓ 6.0 6 1

Nested Loop (cost=48.63..142.06 rows=1 width=522) (actual time=0.646..2.245 rows=6 loops=1)

84. 0.011 2.232 ↓ 6.0 6 1

Nested Loop (cost=48.50..141.91 rows=1 width=308) (actual time=0.642..2.232 rows=6 loops=1)

85. 0.013 2.185 ↓ 6.0 6 1

Nested Loop (cost=48.36..141.27 rows=1 width=90) (actual time=0.607..2.185 rows=6 loops=1)

  • Join Filter: (p1_4.par_last = p0_4.par_last)
  • Rows Removed by Join Filter: 6
86. 0.008 0.570 ↓ 2.0 6 1

Nested Loop (cost=48.07..110.53 rows=3 width=53) (actual time=0.529..0.570 rows=6 loops=1)

87. 0.028 0.412 ↓ 2.0 6 1

Bitmap Heap Scan on param_2018_8_5 p1_4 (cost=47.78..85.57 rows=3 width=14) (actual time=0.405..0.412 rows=6 loops=1)

  • Recheck Cond: ((par_config_comb_id = 1,723) AND (par_time_stamp > '2018-08-23 00:00:00'::timestamp without time zone) AND (par_time_stamp < '2018-08-30 00:00:00'::timestamp without time zone))
  • Filter: ((par_meas_num)::double precision > '0'::double precision)
  • Heap Blocks: exact=6
88. 0.020 0.384 ↓ 0.0 0 1

BitmapAnd (cost=47.78..47.78 rows=10 width=0) (actual time=0.384..0.384 rows=0 loops=1)

89. 0.110 0.110 ↓ 1.1 512 1

Bitmap Index Scan on param_2018_8_5_par_config_comb_id_idx (cost=0.00..11.92 rows=484 width=0) (actual time=0.110..0.110 rows=512 loops=1)

  • Index Cond: (par_config_comb_id = 1,723)
90. 0.254 0.254 ↑ 1.2 1,260 1

Bitmap Index Scan on param_2018_8_5_par_time_stamp_idx (cost=0.00..35.60 rows=1,531 width=0) (actual time=0.254..0.254 rows=1,260 loops=1)

  • Index Cond: ((par_time_stamp > '2018-08-23 00:00:00'::timestamp without time zone) AND (par_time_stamp < '2018-08-30 00:00:00'::timestamp without time zone))
91. 0.150 0.150 ↑ 1.0 1 6

Index Scan using dut_2018_dut_id_idx on dut_2018 dut_2018_4 (cost=0.29..8.31 rows=1 width=39) (actual time=0.024..0.025 rows=1 loops=6)

  • Index Cond: (dut_id = p1_4.par_dut_id)
92. 1.602 1.602 ↓ 2.0 2 6

Index Scan using param_2018_8_5_par_dut_id_idx on param_2018_8_5 p0_4 (cost=0.29..10.23 rows=1 width=65) (actual time=0.038..0.267 rows=2 loops=6)

  • Index Cond: (par_dut_id = dut_2018_4.dut_id)
  • Filter: ((par_time_stamp > '2018-08-23 00:00:00'::timestamp without time zone) AND (par_time_stamp < '2018-08-30 00:00:00'::timestamp without time zone) AND (par_config_comb_id = ANY ('{369,775,880,1620,1723,2415}'::bigint[])))
  • Rows Removed by Filter: 375
93. 0.036 0.036 ↑ 1.0 1 6

Index Scan using result_pkey on result res_param_4 (cost=0.14..0.58 rows=1 width=222) (actual time=0.006..0.006 rows=1 loops=6)

  • Index Cond: (res_id = p0_4.par_result)
94. 0.006 0.006 ↑ 1.0 1 6

Index Scan using result_pkey on result res_dut_4 (cost=0.14..0.15 rows=1 width=222) (actual time=0.001..0.001 rows=1 loops=6)

  • Index Cond: (res_id = dut_2018_4.dut_result)
95. 0.042 0.042 ↑ 1.0 1 6

Index Scan using config_name_pkey on config_name config_name_4 (cost=0.14..0.58 rows=1 width=524) (actual time=0.007..0.007 rows=1 loops=6)

  • Index Cond: (cna_id = p0_4.par_config_name_id)
96. 0.030 0.030 ↑ 1.0 1 6

Index Scan using user_pkey on "user" user_4 (cost=0.15..0.17 rows=1 width=17) (actual time=0.005..0.005 rows=1 loops=6)

  • Index Cond: (use_id = dut_2018_4.dut_user_id)
97. 28.978 64.467 ↑ 2.1 394 1

Gather (cost=1,038.44..6,424.91 rows=823 width=1,039) (actual time=2.868..64.467 rows=394 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
98. 0.415 35.489 ↑ 2.5 197 2 / 2

Hash Join (cost=38.44..5,342.61 rows=484 width=1,039) (actual time=1.503..35.489 rows=197 loops=2)

  • Hash Cond: (p0_5.par_config_name_id = config_name_5.cna_id)
99. 0.215 34.994 ↑ 2.5 197 2 / 2

Hash Join (cost=37.22..5,335.70 rows=484 width=523) (actual time=1.173..34.994 rows=197 loops=2)

  • Hash Cond: (p0_5.par_result = res_param_5.res_id)
100. 0.383 34.712 ↑ 2.5 197 2 / 2

Nested Loop (cost=35.88..5,328.54 rows=484 width=305) (actual time=1.066..34.712 rows=197 loops=2)

  • Join Filter: (p1_5.par_last = p0_5.par_last)
  • Rows Removed by Join Filter: 148
101. 0.113 6.889 ↑ 1.2 112 2 / 2

Hash Join (cost=35.46..3,636.13 rows=134 width=268) (actual time=0.738..6.889 rows=112 loops=2)

  • Hash Cond: (dut_2018_5.dut_user_id = user_5.use_id)
102. 0.115 6.548 ↑ 1.2 112 2 / 2

Hash Join (cost=27.54..3,626.53 rows=134 width=267) (actual time=0.497..6.548 rows=112 loops=2)

  • Hash Cond: (dut_2018_5.dut_result = res_dut_5.res_id)
103. 0.206 6.407 ↑ 1.2 112 2 / 2

Nested Loop (cost=26.20..3,623.58 rows=134 width=53) (actual time=0.458..6.407 rows=112 loops=2)

104. 5.202 5.417 ↑ 1.2 112 2 / 2

Parallel Bitmap Heap Scan on param_2018_8_6 p1_5 (cost=25.91..2,704.68 rows=134 width=14) (actual time=0.370..5.417 rows=112 loops=2)

  • Recheck Cond: (par_config_comb_id = 2,415)
  • Filter: ((par_time_stamp > '2018-08-23 00:00:00'::timestamp without time zone) AND (par_time_stamp < '2018-08-30 00:00:00'::timestamp without time zone) AND ((par_meas_num)::double precision > '0'::double precision))
  • Rows Removed by Filter: 620
  • Heap Blocks: exact=611
105. 0.215 0.215 ↓ 1.2 1,463 1 / 2

Bitmap Index Scan on param_2018_8_6_par_config_comb_id_idx (cost=0.00..25.86 rows=1,258 width=0) (actual time=0.430..0.430 rows=1,463 loops=1)

  • Index Cond: (par_config_comb_id = 2,415)
106. 0.784 0.784 ↑ 1.0 1 224 / 2

Index Scan using dut_2018_dut_id_idx on dut_2018 dut_2018_5 (cost=0.29..6.85 rows=1 width=39) (actual time=0.006..0.007 rows=1 loops=224)

  • Index Cond: (dut_id = p1_5.par_dut_id)
107. 0.013 0.026 ↑ 1.0 15 2 / 2

Hash (cost=1.15..1.15 rows=15 width=222) (actual time=0.026..0.026 rows=15 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
108. 0.013 0.013 ↑ 1.0 15 2 / 2

Seq Scan on result res_dut_5 (cost=0.00..1.15 rows=15 width=222) (actual time=0.010..0.013 rows=15 loops=2)

109. 0.089 0.228 ↓ 1.2 326 2 / 2

Hash (cost=4.63..4.63 rows=263 width=17) (actual time=0.228..0.228 rows=326 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 25kB
110. 0.139 0.139 ↓ 1.2 326 2 / 2

Seq Scan on "user" user_5 (cost=0.00..4.63 rows=263 width=17) (actual time=0.056..0.139 rows=326 loops=2)

111. 27.440 27.440 ↑ 1.3 3 224 / 2

Index Scan using param_2018_8_6_par_dut_id_idx on param_2018_8_6 p0_5 (cost=0.42..12.58 rows=4 width=65) (actual time=0.075..0.245 rows=3 loops=224)

  • Index Cond: (par_dut_id = dut_2018_5.dut_id)
  • Filter: ((par_time_stamp > '2018-08-23 00:00:00'::timestamp without time zone) AND (par_time_stamp < '2018-08-30 00:00:00'::timestamp without time zone) AND (par_config_comb_id = ANY ('{369,775,880,1620,1723,2415}'::bigint[])))
  • Rows Removed by Filter: 404
112. 0.010 0.067 ↑ 1.0 15 2 / 2

Hash (cost=1.15..1.15 rows=15 width=222) (actual time=0.067..0.067 rows=15 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
113. 0.057 0.057 ↑ 1.0 15 2 / 2

Seq Scan on result res_param_5 (cost=0.00..1.15 rows=15 width=222) (actual time=0.054..0.057 rows=15 loops=2)

114. 0.013 0.080 ↑ 1.0 10 2 / 2

Hash (cost=1.10..1.10 rows=10 width=524) (actual time=0.080..0.080 rows=10 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
115. 0.067 0.067 ↑ 1.0 10 2 / 2

Seq Scan on config_name config_name_5 (cost=0.00..1.10 rows=10 width=524) (actual time=0.065..0.067 rows=10 loops=2)