explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fs4Q

Settings
# exclusive inclusive rows x rows loops node
1. 7.568 1,611.773 ↓ 10.0 9,790 1

Sort (cost=103,810.57..103,813.02 rows=979 width=1,039) (actual time=1,610.608..1,611.773 rows=9,790 loops=1)

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

HashAggregate (cost=103,752.15..103,761.94 rows=979 width=1,039) (actual time=1,598.388..1,604.205 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.231 1,551.235 ↓ 1.7 16,912 1

Append (cost=13,914.11..103,287.27 rows=9,787 width=1,039) (actual time=84.200..1,551.235 rows=16,912 loops=1)

4. 47.330 608.875 ↓ 2.0 6,767 1

Gather (cost=13,914.11..40,932.39 rows=3,303 width=1,039) (actual time=84.200..608.875 rows=6,767 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 3.048 561.545 ↓ 1.6 2,256 3 / 3

Hash Join (cost=12,914.11..39,602.09 rows=1,376 width=1,039) (actual time=29.589..561.545 rows=2,256 loops=3)

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

Hash Join (cost=12,912.88..39,584.71 rows=1,376 width=523) (actual time=28.512..557.548 rows=2,256 loops=3)

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

Nested Loop (cost=12,911.55..39,566.82 rows=1,376 width=305) (actual time=27.206..553.158 rows=2,256 loops=3)

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

Hash Join (cost=12,911.12..29,467.60 rows=668 width=268) (actual time=26.866..62.248 rows=1,298 loops=3)

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

Hash Join (cost=12,903.20..29,451.27 rows=668 width=267) (actual time=26.546..60.583 rows=1,298 loops=3)

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

Nested Loop (cost=12,901.86..29,441.90 rows=668 width=53) (actual time=26.513..59.017 rows=1,298 loops=3)

11. 23.132 49.375 ↓ 1.9 1,298 3 / 3

Parallel Bitmap Heap Scan on param_2018_8_1 p1 (cost=12,901.57..27,048.17 rows=668 width=14) (actual time=26.473..49.375 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=706
12. 0.200 26.243 ↓ 0.0 0 1 / 3

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

13. 1.162 1.162 ↑ 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,621 width=0) (actual time=3.485..3.485 rows=16,819 loops=1)

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

Bitmap Index Scan on param_2018_8_1_par_time_stamp_idx (cost=0.00..12,552.43 rows=598,400 width=0) (actual time=74.642..74.642 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. 6.490 6.490 ↑ 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.005..0.005 rows=1 loops=3,894)

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

Hash (cost=1.15..1.15 rows=15 width=222) (actual time=0.023..0.023 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.079 0.302 ↓ 1.2 326 3 / 3

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

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

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

20. 485.452 485.452 ↓ 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.09 rows=2 width=65) (actual time=0.117..0.374 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.016 1.249 ↑ 1.0 15 3 / 3

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

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

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

23. 0.019 0.949 ↑ 1.0 10 3 / 3

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

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

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

25. 32.599 125.613 ↑ 1.7 848 1

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

  • Workers Planned: 1
  • Workers Launched: 1
26. 0.853 93.014 ↑ 2.0 424 2 / 2

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

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

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

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

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

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

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

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

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

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

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

32. 6.649 6.834 ↓ 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=0.985..6.834 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=622
33. 0.184 0.184 ↑ 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.369..0.369 rows=1,573 loops=1)

  • Index Cond: (par_config_comb_id = 775)
34. 1.568 1.568 ↑ 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.007 rows=1 loops=448)

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

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

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

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

37. 0.080 0.218 ↓ 1.2 326 2 / 2

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

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

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

39. 80.416 80.416 ↑ 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.122..0.359 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.013 0.098 ↑ 1.0 15 2 / 2

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

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

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

42. 0.016 0.176 ↑ 1.0 10 2 / 2

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
43. 0.160 0.160 ↑ 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.157..0.160 rows=10 loops=2)

44. 57.965 743.471 ↓ 2.1 8,897 1

Gather (cost=16,708.01..47,607.95 rows=4,224 width=1,039) (actual time=132.255..743.471 rows=8,897 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
45. 2.741 685.506 ↓ 1.7 2,966 3 / 3

Hash Join (cost=15,708.01..46,185.55 rows=1,760 width=1,039) (actual time=65.266..685.506 rows=2,966 loops=3)

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

Hash Join (cost=15,706.79..46,163.67 rows=1,760 width=523) (actual time=64.212..681.867 rows=2,966 loops=3)

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

Nested Loop (cost=15,705.45..46,141.15 rows=1,760 width=305) (actual time=63.317..678.180 rows=2,966 loops=3)

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

Hash Join (cost=15,705.02..34,476.15 rows=779 width=268) (actual time=62.328..103.019 rows=1,658 loops=3)

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

Hash Join (cost=15,697.10..34,458.42 rows=779 width=267) (actual time=61.355..100.573 rows=1,658 loops=3)

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

Nested Loop (cost=15,695.77..34,447.71 rows=779 width=53) (actual time=61.299..98.766 rows=1,658 loops=3)

51. 40.470 82.625 ↓ 2.1 1,658 3 / 3

Parallel Bitmap Heap Scan on param_2018_8_3 p1_2 (cost=15,695.47..31,843.93 rows=779 width=14) (actual time=60.421..82.625 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=923
52. 0.241 42.155 ↓ 0.0 0 1 / 3

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

53. 1.242 1.242 ↓ 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=3.727..3.727 rows=18,541 loops=1)

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

Bitmap Index Scan on param_2018_8_3_par_time_stamp_idx (cost=0.00..15,350.95 rows=731,852 width=0) (actual time=122.016..122.016 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. 13.261 13.261 ↑ 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.008 rows=1 loops=4,973)

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

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

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

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

58. 0.087 0.955 ↓ 1.2 326 3 / 3

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

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

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

60. 570.237 570.237 ↓ 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.113..0.344 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.016 0.839 ↑ 1.0 15 3 / 3

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

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

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

63. 0.020 0.898 ↑ 1.0 10 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
64. 0.878 0.878 ↑ 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.875..0.878 rows=10 loops=3)

65. 0.001 0.380 ↓ 0.0 0 1

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

66. 0.000 0.379 ↓ 0.0 0 1

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

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

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

68. 0.000 0.378 ↓ 0.0 0 1

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

69. 0.001 0.378 ↓ 0.0 0 1

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

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

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

71. 0.079 0.376 ↓ 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.376..0.376 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.023 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.130 0.130 ↓ 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.130..0.130 rows=428 loops=1)

  • Index Cond: (par_config_comb_id = 1,620)
74. 0.144 0.144 ↓ 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.144..0.144 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.007 2.752 ↓ 6.0 6 1

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

82. 0.005 2.685 ↓ 6.0 6 1

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

83. 0.006 2.638 ↓ 6.0 6 1

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

84. 0.008 2.620 ↓ 6.0 6 1

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

85. 0.029 2.570 ↓ 6.0 6 1

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

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

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

87. 0.037 0.426 ↓ 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.417..0.426 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.016 0.389 ↓ 0.0 0 1

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

89. 0.135 0.135 ↓ 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.135..0.135 rows=512 loops=1)

  • Index Cond: (par_config_comb_id = 1,723)
90. 0.238 0.238 ↑ 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.238..0.238 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.084 0.084 ↑ 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.013..0.014 rows=1 loops=6)

  • Index Cond: (dut_id = p1_4.par_dut_id)
92. 2.010 2.010 ↓ 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.049..0.335 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.042 0.042 ↑ 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.007..0.007 rows=1 loops=6)

  • Index Cond: (res_id = p0_4.par_result)
94. 0.012 0.012 ↑ 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.002..0.002 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.060 0.060 ↑ 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.010..0.010 rows=1 loops=6)

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

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

  • Workers Planned: 1
  • Workers Launched: 1
98. 0.433 34.294 ↑ 2.5 197 2 / 2

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

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

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

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

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

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

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

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

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

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

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

104. 4.442 4.577 ↑ 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.247..4.577 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=638
105. 0.135 0.135 ↓ 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.270..0.270 rows=1,463 loops=1)

  • Index Cond: (par_config_comb_id = 2,415)
106. 0.672 0.672 ↑ 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.006 rows=1 loops=224)

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

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

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

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

109. 0.049 0.139 ↓ 1.2 326 2 / 2

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

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

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

111. 27.216 27.216 ↑ 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.074..0.243 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.011 0.054 ↑ 1.0 15 2 / 2

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

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

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

114. 0.016 0.077 ↑ 1.0 10 2 / 2

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
115. 0.061 0.061 ↑ 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.060..0.061 rows=10 loops=2)