explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gqDQ

Settings
# exclusive inclusive rows x rows loops node
1. 20.957 1,689.697 ↓ 10.0 9,790 1

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

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

HashAggregate (cost=103,752.15..103,761.94 rows=979 width=1,039) (actual time=1,650.506..1,668.740 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.366 1,591.566 ↓ 1.7 16,912 1

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

4. 28.347 690.963 ↓ 2.0 6,767 1

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

  • Workers Planned: 2
  • Workers Launched: 2
5. 2.561 662.616 ↓ 1.6 2,256 3 / 3

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

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

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

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

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

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

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

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

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

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

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

11. 32.463 58.708 ↓ 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=37.167..58.708 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=701
12. 0.253 26.245 ↓ 0.0 0 1 / 3

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

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

  • Index Cond: (par_config_comb_id = 369)
14. 24.407 24.407 ↓ 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=73.222..73.222 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. 15.576 15.576 ↑ 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.011..0.012 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.075 0.436 ↓ 1.2 326 3 / 3

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

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

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

20. 568.524 568.524 ↓ 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.145..0.438 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.011 0.335 ↑ 1.0 15 3 / 3

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

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

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

23. 0.014 0.425 ↑ 1.0 10 3 / 3

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

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

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

25. 34.007 108.027 ↑ 1.7 848 1

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

  • Workers Planned: 1
  • Workers Launched: 1
26. 0.704 74.020 ↑ 2.0 424 2 / 2

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

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

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

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

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

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

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

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

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

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

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

32. 6.176 6.393 ↓ 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.045..6.393 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=641
33. 0.216 0.216 ↑ 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.433..0.433 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.005..0.005 rows=1 loops=448)

  • Index Cond: (dut_id = p1_1.par_dut_id)
35. 0.009 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
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.085 0.239 ↓ 1.2 326 2 / 2

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

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

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

39. 63.168 63.168 ↑ 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.086..0.282 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.078 ↑ 1.0 15 2 / 2

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

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

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

42. 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
43. 0.067 0.067 ↑ 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.065..0.067 rows=10 loops=2)

44. 27.961 676.279 ↓ 2.1 8,897 1

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

  • Workers Planned: 2
  • Workers Launched: 2
45. 2.781 648.318 ↓ 1.7 2,966 3 / 3

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

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

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

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

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

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

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

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

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

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

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

51. 39.430 68.719 ↓ 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=50.532..68.719 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=868
52. 0.229 29.289 ↓ 0.0 0 1 / 3

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

53. 1.148 1.148 ↓ 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.445..3.445 rows=18,541 loops=1)

  • Index Cond: (par_config_comb_id = 880)
54. 27.912 27.912 ↑ 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=83.737..83.737 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. 9.946 9.946 ↑ 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.006 rows=1 loops=4,973)

  • Index Cond: (dut_id = p1_2.par_dut_id)
56. 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
57. 0.014 0.014 ↑ 1.0 15 3 / 3

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

58. 0.100 1.047 ↓ 1.2 326 3 / 3

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

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

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

60. 548.688 548.688 ↓ 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.331 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.015 0.865 ↑ 1.0 15 3 / 3

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

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

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

63. 0.015 0.865 ↑ 1.0 10 3 / 3

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

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

65. 0.001 1.077 ↓ 0.0 0 1

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

66. 0.001 1.076 ↓ 0.0 0 1

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

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

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

68. 0.001 1.075 ↓ 0.0 0 1

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

69. 0.000 1.074 ↓ 0.0 0 1

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

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

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

71. 0.079 1.073 ↓ 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=1.073..1.073 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.994 ↓ 0.0 0 1

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

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

  • Index Cond: (par_config_comb_id = 1,620)
74. 0.772 0.772 ↓ 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.772..0.772 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.023 3.451 ↓ 6.0 6 1

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

82. 0.018 3.350 ↓ 6.0 6 1

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

83. 0.019 3.206 ↓ 6.0 6 1

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

84. 0.024 3.169 ↓ 6.0 6 1

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

85. 0.035 3.079 ↓ 6.0 6 1

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

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

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

87. 0.042 0.361 ↓ 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.346..0.361 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.014 0.319 ↓ 0.0 0 1

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

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

  • Index Cond: (par_config_comb_id = 1,723)
90. 0.202 0.202 ↑ 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.202..0.202 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.096 0.096 ↑ 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.015..0.016 rows=1 loops=6)

  • Index Cond: (dut_id = p1_4.par_dut_id)
92. 2.562 2.562 ↓ 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.052..0.427 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.066 0.066 ↑ 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.011..0.011 rows=1 loops=6)

  • Index Cond: (res_id = p0_4.par_result)
94. 0.018 0.018 ↑ 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.003..0.003 rows=1 loops=6)

  • Index Cond: (res_id = dut_2018_4.dut_result)
95. 0.126 0.126 ↑ 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.021..0.021 rows=1 loops=6)

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

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

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

  • Workers Planned: 1
  • Workers Launched: 1
98. 0.616 58.794 ↑ 2.5 197 2 / 2

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

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

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

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

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

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

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

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

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

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

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

104. 6.089 6.277 ↑ 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.354..6.277 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=614
105. 0.188 0.188 ↓ 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.376..0.376 rows=1,463 loops=1)

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

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

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

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

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

109. 0.083 0.239 ↓ 1.2 326 2 / 2

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

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

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

111. 48.832 48.832 ↑ 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.111..0.436 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.019 0.089 ↑ 1.0 15 2 / 2

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

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

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

114. 0.034 0.135 ↑ 1.0 10 2 / 2

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

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