explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3dSu

Settings
# exclusive inclusive rows x rows loops node
1. 8.027 1,612.800 ↓ 10.0 9,790 1

Sort (cost=103,832.04..103,834.49 rows=979 width=1,039) (actual time=1,611.699..1,612.800 rows=9,790 loops=1)

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

HashAggregate (cost=103,773.62..103,783.41 rows=979 width=1,039) (actual time=1,598.085..1,604.773 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.118 1,551.652 ↓ 1.7 16,912 1

Append (cost=13,914.40..103,308.73 rows=9,787 width=1,039) (actual time=74.120..1,551.652 rows=16,912 loops=1)

4. 37.846 512.096 ↓ 2.0 6,767 1

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

  • Workers Planned: 2
  • Workers Launched: 2
5. 2.629 474.250 ↓ 1.6 2,256 3 / 3

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

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

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

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

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

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

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

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

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

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

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

11. 29.213 52.863 ↓ 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=25.819..52.863 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,055
12. 0.311 23.650 ↓ 0.0 0 1 / 3

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

13. 1.352 1.352 ↑ 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=4.057..4.057 rows=16,819 loops=1)

  • Index Cond: (par_config_comb_id = 369)
14. 21.987 21.987 ↓ 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=65.961..65.961 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. 14.278 14.278 ↑ 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.010..0.011 rows=1 loops=3,894)

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

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

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

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

18. 0.094 0.273 ↓ 1.2 326 3 / 3

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

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

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

20. 391.996 391.996 ↓ 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.089..0.302 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.022 0.227 ↑ 1.0 15 3 / 3

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

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

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

23. 0.017 0.117 ↑ 1.0 10 3 / 3

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

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

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

25. 23.552 167.282 ↑ 1.7 848 1

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

  • Workers Planned: 1
  • Workers Launched: 1
26. 0.387 143.730 ↑ 2.0 424 2 / 2

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

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

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

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

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

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

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

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

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

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

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

32. 51.318 51.603 ↓ 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=11.795..51.603 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=461
33. 0.285 0.285 ↑ 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.570..0.570 rows=1,573 loops=1)

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

  • Index Cond: (dut_id = p1_1.par_dut_id)
35. 0.008 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
36. 0.018 0.018 ↑ 1.0 15 2 / 2

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

37. 0.086 0.736 ↓ 1.2 326 2 / 2

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

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

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

39. 86.688 86.688 ↑ 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.138..0.387 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.017 0.626 ↑ 1.0 15 2 / 2

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

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

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

42. 0.020 0.565 ↑ 1.0 10 2 / 2

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

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

44. 34.804 790.625 ↓ 2.1 8,897 1

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

  • Workers Planned: 2
  • Workers Launched: 2
45. 3.081 755.821 ↓ 1.7 2,966 3 / 3

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

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

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

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

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

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

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

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

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

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

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

51. 72.194 107.166 ↓ 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=61.429..107.166 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=819
52. 0.226 34.972 ↓ 0.0 0 1 / 3

BitmapAnd (cost=15,695.47..15,695.47 rows=5,611 width=0) (actual time=104.915..104.915 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.726..3.726 rows=18,541 loops=1)

  • Index Cond: (par_config_comb_id = 880)
54. 33.504 33.504 ↑ 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=100.512..100.512 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. 8.288 8.288 ↑ 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.005..0.005 rows=1 loops=4,973)

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

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

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

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

58. 0.076 0.908 ↓ 1.2 326 3 / 3

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

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

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

60. 618.310 618.310 ↓ 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.123..0.373 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.019 0.908 ↑ 1.0 15 3 / 3

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

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

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

63. 0.020 0.829 ↑ 1.0 10 3 / 3

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

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

65. 0.001 0.427 ↓ 0.0 0 1

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

66. 0.000 0.426 ↓ 0.0 0 1

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

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

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

68. 0.001 0.426 ↓ 0.0 0 1

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

69. 0.000 0.425 ↓ 0.0 0 1

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

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

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

71. 0.092 0.424 ↓ 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.424..0.424 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.068 0.332 ↓ 0.0 0 1

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

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

  • Index Cond: (par_config_comb_id = 1,620)
74. 0.129 0.129 ↓ 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.129..0.129 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.016 3.275 ↓ 6.0 6 1

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

82. 0.008 3.223 ↓ 6.0 6 1

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

83. 0.013 3.179 ↓ 6.0 6 1

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

84. 0.012 3.154 ↓ 6.0 6 1

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

85. 0.028 3.100 ↓ 6.0 6 1

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

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

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

87. 0.059 0.352 ↓ 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.313..0.352 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.015 0.293 ↓ 0.0 0 1

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

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

  • Index Cond: (par_config_comb_id = 1,723)
90. 0.170 0.170 ↑ 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.170..0.170 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.120 0.120 ↑ 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.018..0.020 rows=1 loops=6)

  • Index Cond: (dut_id = p1_4.par_dut_id)
92. 2.574 2.574 ↓ 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.060..0.429 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.036 0.036 ↑ 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.006..0.006 rows=1 loops=6)

  • Index Cond: (cna_id = p0_4.par_config_name_id)
96. 0.036 0.036 ↑ 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.006..0.006 rows=1 loops=6)

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

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

  • Workers Planned: 1
  • Workers Launched: 1
98. 0.577 41.888 ↑ 2.5 197 2 / 2

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

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

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

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

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

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

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

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

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

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

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

104. 5.868 6.080 ↑ 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.589..6.080 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=600
105. 0.212 0.212 ↓ 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.424..0.424 rows=1,463 loops=1)

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

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

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

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

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

109. 0.075 0.199 ↓ 1.2 326 2 / 2

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

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

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

111. 32.480 32.480 ↑ 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.087..0.290 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.076 ↑ 1.0 15 2 / 2

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

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

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

114. 0.013 0.105 ↑ 1.0 10 2 / 2

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

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