explain.depesz.com

PostgreSQL's explain analyze made readable

Result: woLd

Settings
# exclusive inclusive rows x rows loops node
1. 15.679 64,194.545 ↑ 11.9 8,150 1

WindowAgg (cost=497,418.08..502,507.54 rows=96,942 width=43) (actual time=64,165.698..64,194.545 rows=8,150 loops=1)

2. 12.868 64,178.866 ↑ 11.9 8,150 1

WindowAgg (cost=497,418.08..499,356.92 rows=96,942 width=19) (actual time=64,165.439..64,178.866 rows=8,150 loops=1)

3. 20.589 64,165.998 ↑ 11.9 8,150 1

Sort (cost=497,418.08..497,660.44 rows=96,942 width=11) (actual time=64,165.422..64,165.998 rows=8,150 loops=1)

  • Sort Key: re.period, re.value DESC
  • Sort Method: quicksort Memory: 575kB
4. 121.238 64,145.409 ↑ 11.9 8,150 1

Hash Join (cost=9,461.71..489,388.94 rows=96,942 width=11) (actual time=185.978..64,145.409 rows=8,150 loops=1)

  • Hash Cond: ((re.bank_id = bpg.bank_id) AND (re.period = bpg.period))
5. 38.026 63,843.295 ↓ 1.1 491,907 1

Append (cost=0.29..477,570.34 rows=448,961 width=11) (actual time=3.051..63,843.295 rows=491,907 loops=1)

6. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ubpr_entry_20012_metric_id_period_value_idx on ubpr_entry_20012 re (cost=0.29..1.90 rows=1 width=9) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
7. 0.005 0.005 ↓ 0.0 0 1

Index Scan using ubpr_entry_20013_metric_id_period_value_idx on ubpr_entry_20013 re_1 (cost=0.29..2.51 rows=1 width=9) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
8. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20014 re_2 (cost=68.05..4,837.68 rows=5,887 width=10) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
9. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20014_metric_id_period_value_idx (cost=0.00..66.58 rows=5,887 width=0) (actual time=0.005..0.006 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
10. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20021 re_3 (cost=69.28..4,965.39 rows=5,904 width=11) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
11. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20021_metric_id_period_value_idx (cost=0.00..67.81 rows=5,904 width=0) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
12. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20022 re_4 (cost=75.50..5,312.57 rows=6,280 width=11) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
13. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20022_metric_id_period_value_idx (cost=0.00..73.93 rows=6,280 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
14. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20023 re_5 (cost=78.02..5,497.80 rows=6,463 width=11) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
15. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20023_metric_id_period_value_idx (cost=0.00..76.40 rows=6,463 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
16. 77.367 79.177 ↓ 1.2 8,468 1

Bitmap Heap Scan on ubpr_entry_20024 re_6 (cost=84.66..7,680.59 rows=7,178 width=11) (actual time=3.011..79.177 rows=8,468 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=8,468
17. 1.810 1.810 ↓ 1.2 8,468 1

Bitmap Index Scan on ubpr_entry_20024_metric_id_period_value_idx (cost=0.00..82.87 rows=7,178 width=0) (actual time=1.810..1.810 rows=8,468 loops=1)

  • Index Cond: (metric_id = 682)
18. 67.233 69.372 ↓ 1.1 8,444 1

Bitmap Heap Scan on ubpr_entry_20031 re_7 (cost=87.48..7,898.53 rows=7,399 width=11) (actual time=3.210..69.372 rows=8,444 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=8,444
19. 2.139 2.139 ↓ 1.1 8,444 1

Bitmap Index Scan on ubpr_entry_20031_metric_id_period_value_idx (cost=0.00..85.63 rows=7,399 width=0) (actual time=2.139..2.139 rows=8,444 loops=1)

  • Index Cond: (metric_id = 682)
20. 73.678 75.804 ↓ 1.1 8,410 1

Bitmap Heap Scan on ubpr_entry_20032 re_8 (cost=86.95..7,830.67 rows=7,331 width=11) (actual time=3.813..75.804 rows=8,410 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=8,409
21. 2.126 2.126 ↓ 1.1 8,410 1

Bitmap Index Scan on ubpr_entry_20032_metric_id_period_value_idx (cost=0.00..85.12 rows=7,331 width=0) (actual time=2.126..2.126 rows=8,410 loops=1)

  • Index Cond: (metric_id = 682)
22. 69.216 70.794 ↓ 1.1 8,391 1

Bitmap Heap Scan on ubpr_entry_20033 re_9 (cost=87.05..7,842.16 rows=7,344 width=11) (actual time=3.097..70.794 rows=8,391 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=8,391
23. 1.578 1.578 ↓ 1.1 8,391 1

Bitmap Index Scan on ubpr_entry_20033_metric_id_period_value_idx (cost=0.00..85.22 rows=7,344 width=0) (actual time=1.578..1.578 rows=8,391 loops=1)

  • Index Cond: (metric_id = 682)
24. 59.527 60.735 ↓ 1.2 8,348 1

Bitmap Heap Scan on ubpr_entry_20034 re_10 (cost=84.53..7,654.94 rows=7,160 width=11) (actual time=2.293..60.735 rows=8,348 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=8,348
25. 1.208 1.208 ↓ 1.2 8,348 1

Bitmap Index Scan on ubpr_entry_20034_metric_id_period_value_idx (cost=0.00..82.73 rows=7,160 width=0) (actual time=1.208..1.208 rows=8,348 loops=1)

  • Index Cond: (metric_id = 682)
26. 62.374 64.877 ↓ 1.2 8,286 1

Bitmap Heap Scan on ubpr_entry_20041 re_11 (cost=84.81..7,685.46 rows=7,197 width=11) (actual time=4.139..64.877 rows=8,286 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=8,286
27. 2.503 2.503 ↓ 1.2 8,286 1

Bitmap Index Scan on ubpr_entry_20041_metric_id_period_value_idx (cost=0.00..83.01 rows=7,197 width=0) (actual time=2.503..2.503 rows=8,286 loops=1)

  • Index Cond: (metric_id = 682)
28. 69.049 70.693 ↓ 1.1 8,261 1

Bitmap Heap Scan on ubpr_entry_20042 re_12 (cost=85.10..7,724.97 rows=7,234 width=11) (actual time=2.868..70.693 rows=8,261 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=8,261
29. 1.644 1.644 ↓ 1.1 8,261 1

Bitmap Index Scan on ubpr_entry_20042_metric_id_period_value_idx (cost=0.00..83.29 rows=7,234 width=0) (actual time=1.644..1.644 rows=8,261 loops=1)

  • Index Cond: (metric_id = 682)
30. 59.429 60.826 ↓ 1.1 8,219 1

Bitmap Heap Scan on ubpr_entry_20043 re_13 (cost=85.21..7,753.48 rows=7,249 width=11) (actual time=2.664..60.826 rows=8,219 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=8,219
31. 1.397 1.397 ↓ 1.1 8,219 1

Bitmap Index Scan on ubpr_entry_20043_metric_id_period_value_idx (cost=0.00..83.40 rows=7,249 width=0) (actual time=1.397..1.397 rows=8,219 loops=1)

  • Index Cond: (metric_id = 682)
32. 52.961 54.437 ↓ 1.2 8,179 1

Bitmap Heap Scan on ubpr_entry_20044 re_14 (cost=82.42..7,514.39 rows=7,030 width=11) (actual time=2.812..54.437 rows=8,179 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=8,179
33. 1.476 1.476 ↓ 1.2 8,179 1

Bitmap Index Scan on ubpr_entry_20044_metric_id_period_value_idx (cost=0.00..80.66 rows=7,030 width=0) (actual time=1.476..1.476 rows=8,179 loops=1)

  • Index Cond: (metric_id = 682)
34. 45.928 47.178 ↓ 1.1 8,141 1

Bitmap Heap Scan on ubpr_entry_20051 re_15 (cost=83.99..7,571.31 rows=7,091 width=11) (actual time=2.315..47.178 rows=8,141 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=8,141
35. 1.250 1.250 ↓ 1.1 8,141 1

Bitmap Index Scan on ubpr_entry_20051_metric_id_period_value_idx (cost=0.00..82.22 rows=7,091 width=0) (actual time=1.250..1.250 rows=8,141 loops=1)

  • Index Cond: (metric_id = 682)
36. 47.228 48.466 ↓ 1.1 8,083 1

Bitmap Heap Scan on ubpr_entry_20052 re_16 (cost=84.17..7,610.00 rows=7,114 width=11) (actual time=2.269..48.466 rows=8,083 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=8,083
37. 1.238 1.238 ↓ 1.1 8,083 1

Bitmap Index Scan on ubpr_entry_20052_metric_id_period_value_idx (cost=0.00..82.39 rows=7,114 width=0) (actual time=1.238..1.238 rows=8,083 loops=1)

  • Index Cond: (metric_id = 682)
38. 48.985 50.251 ↓ 1.1 8,079 1

Bitmap Heap Scan on ubpr_entry_20053 re_17 (cost=82.50..7,516.50 rows=7,040 width=11) (actual time=2.366..50.251 rows=8,079 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=8,079
39. 1.266 1.266 ↓ 1.1 8,079 1

Bitmap Index Scan on ubpr_entry_20053_metric_id_period_value_idx (cost=0.00..80.73 rows=7,040 width=0) (actual time=1.266..1.266 rows=8,079 loops=1)

  • Index Cond: (metric_id = 682)
40. 44.210 46.004 ↓ 1.2 8,056 1

Bitmap Heap Scan on ubpr_entry_20054 re_18 (cost=81.22..7,352.43 rows=6,876 width=11) (actual time=3.114..46.004 rows=8,056 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=8,056
41. 1.794 1.794 ↓ 1.2 8,056 1

Bitmap Index Scan on ubpr_entry_20054_metric_id_period_value_idx (cost=0.00..79.51 rows=6,876 width=0) (actual time=1.794..1.794 rows=8,056 loops=1)

  • Index Cond: (metric_id = 682)
42. 38.137 40.062 ↓ 1.1 8,020 1

Bitmap Heap Scan on ubpr_entry_20061 re_19 (cost=84.63..7,651.11 rows=7,174 width=11) (actual time=3.232..40.062 rows=8,020 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=8,020
43. 1.925 1.925 ↓ 1.1 8,020 1

Bitmap Index Scan on ubpr_entry_20061_metric_id_period_value_idx (cost=0.00..82.84 rows=7,174 width=0) (actual time=1.925..1.925 rows=8,020 loops=1)

  • Index Cond: (metric_id = 682)
44. 33.360 35.075 ↓ 1.1 8,010 1

Bitmap Heap Scan on ubpr_entry_20062 re_20 (cost=82.28..7,485.64 rows=7,012 width=11) (actual time=3.096..35.075 rows=8,010 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=8,010
45. 1.715 1.715 ↓ 1.1 8,010 1

Bitmap Index Scan on ubpr_entry_20062_metric_id_period_value_idx (cost=0.00..80.53 rows=7,012 width=0) (actual time=1.715..1.715 rows=8,010 loops=1)

  • Index Cond: (metric_id = 682)
46. 30.859 32.258 ↓ 1.1 7,978 1

Bitmap Heap Scan on ubpr_entry_20063 re_21 (cost=83.94..7,561.72 rows=7,085 width=11) (actual time=2.348..32.258 rows=7,978 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,978
47. 1.399 1.399 ↓ 1.1 7,978 1

Bitmap Index Scan on ubpr_entry_20063_metric_id_period_value_idx (cost=0.00..82.17 rows=7,085 width=0) (actual time=1.399..1.399 rows=7,978 loops=1)

  • Index Cond: (metric_id = 682)
48. 29.591 30.907 ↓ 1.2 7,922 1

Bitmap Heap Scan on ubpr_entry_20064 re_22 (cost=80.17..7,209.17 rows=6,740 width=11) (actual time=2.544..30.907 rows=7,922 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,922
49. 1.316 1.316 ↓ 1.2 7,922 1

Bitmap Index Scan on ubpr_entry_20064_metric_id_period_value_idx (cost=0.00..78.48 rows=6,740 width=0) (actual time=1.316..1.316 rows=7,922 loops=1)

  • Index Cond: (metric_id = 682)
50. 36.567 38.252 ↓ 1.2 7,896 1

Bitmap Heap Scan on ubpr_entry_20071 re_23 (cost=77.86..7,051.80 rows=6,584 width=11) (actual time=2.899..38.252 rows=7,896 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,896
51. 1.685 1.685 ↓ 1.2 7,896 1

Bitmap Index Scan on ubpr_entry_20071_metric_id_period_value_idx (cost=0.00..76.22 rows=6,584 width=0) (actual time=1.685..1.685 rows=7,896 loops=1)

  • Index Cond: (metric_id = 682)
52. 16.287 18.331 ↓ 1.2 7,862 1

Bitmap Heap Scan on ubpr_entry_20072 re_24 (cost=77.90..7,058.63 rows=6,589 width=11) (actual time=3.591..18.331 rows=7,862 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,862
53. 2.044 2.044 ↓ 1.2 7,862 1

Bitmap Index Scan on ubpr_entry_20072_metric_id_period_value_idx (cost=0.00..76.25 rows=6,589 width=0) (actual time=2.044..2.044 rows=7,862 loops=1)

  • Index Cond: (metric_id = 682)
54. 10.600 12.053 ↓ 1.2 7,811 1

Bitmap Heap Scan on ubpr_entry_20073 re_25 (cost=77.89..7,054.75 rows=6,588 width=11) (actual time=2.597..12.053 rows=7,811 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,810
55. 1.453 1.453 ↓ 1.2 7,811 1

Bitmap Index Scan on ubpr_entry_20073_metric_id_period_value_idx (cost=0.00..76.25 rows=6,588 width=0) (actual time=1.453..1.453 rows=7,811 loops=1)

  • Index Cond: (metric_id = 682)
56. 9.393 10.671 ↓ 1.2 7,788 1

Bitmap Heap Scan on ubpr_entry_20074 re_26 (cost=76.79..6,912.03 rows=6,446 width=11) (actual time=2.251..10.671 rows=7,788 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,788
57. 1.278 1.278 ↓ 1.2 7,788 1

Bitmap Index Scan on ubpr_entry_20074_metric_id_period_value_idx (cost=0.00..75.18 rows=6,446 width=0) (actual time=1.278..1.278 rows=7,788 loops=1)

  • Index Cond: (metric_id = 682)
58. 8.823 10.640 ↓ 1.1 7,740 1

Bitmap Heap Scan on ubpr_entry_20081 re_27 (cost=80.49..7,259.16 rows=6,781 width=11) (actual time=3.094..10.640 rows=7,740 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,740
59. 1.817 1.817 ↓ 1.1 7,740 1

Bitmap Index Scan on ubpr_entry_20081_metric_id_period_value_idx (cost=0.00..78.79 rows=6,781 width=0) (actual time=1.817..1.817 rows=7,740 loops=1)

  • Index Cond: (metric_id = 682)
60. 9.841 11.435 ↓ 1.1 7,698 1

Bitmap Heap Scan on ubpr_entry_20082 re_28 (cost=79.00..7,220.64 rows=6,731 width=11) (actual time=3.039..11.435 rows=7,698 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,698
61. 1.594 1.594 ↓ 1.1 7,698 1

Bitmap Index Scan on ubpr_entry_20082_metric_id_period_value_idx (cost=0.00..77.32 rows=6,731 width=0) (actual time=1.594..1.594 rows=7,698 loops=1)

  • Index Cond: (metric_id = 682)
62. 10.111 11.488 ↓ 1.2 7,640 1

Bitmap Heap Scan on ubpr_entry_20083 re_29 (cost=78.28..7,123.46 rows=6,638 width=11) (actual time=2.527..11.488 rows=7,640 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,640
63. 1.377 1.377 ↓ 1.2 7,640 1

Bitmap Index Scan on ubpr_entry_20083_metric_id_period_value_idx (cost=0.00..76.62 rows=6,638 width=0) (actual time=1.377..1.377 rows=7,640 loops=1)

  • Index Cond: (metric_id = 682)
64. 10.411 12.125 ↓ 1.2 7,568 1

Bitmap Heap Scan on ubpr_entry_20084 re_30 (cost=77.57..7,016.84 rows=6,546 width=11) (actual time=2.753..12.125 rows=7,568 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,568
65. 1.714 1.714 ↓ 1.2 7,568 1

Bitmap Index Scan on ubpr_entry_20084_metric_id_period_value_idx (cost=0.00..75.93 rows=6,546 width=0) (actual time=1.714..1.714 rows=7,568 loops=1)

  • Index Cond: (metric_id = 682)
66. 9.078 10.348 ↓ 1.2 7,520 1

Bitmap Heap Scan on ubpr_entry_20091 re_31 (cost=77.21..6,964.41 rows=6,500 width=11) (actual time=2.306..10.348 rows=7,520 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,520
67. 1.270 1.270 ↓ 1.2 7,520 1

Bitmap Index Scan on ubpr_entry_20091_metric_id_period_value_idx (cost=0.00..75.59 rows=6,500 width=0) (actual time=1.270..1.270 rows=7,520 loops=1)

  • Index Cond: (metric_id = 682)
68. 7.833 9.431 ↓ 1.2 7,476 1

Bitmap Heap Scan on ubpr_entry_20092 re_32 (cost=74.91..6,805.16 rows=6,345 width=11) (actual time=2.520..9.431 rows=7,476 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,476
69. 1.598 1.598 ↓ 1.2 7,476 1

Bitmap Index Scan on ubpr_entry_20092_metric_id_period_value_idx (cost=0.00..73.32 rows=6,345 width=0) (actual time=1.598..1.598 rows=7,476 loops=1)

  • Index Cond: (metric_id = 682)
70. 8.252 9.547 ↓ 1.2 7,393 1

Bitmap Heap Scan on ubpr_entry_20093 re_33 (cost=74.31..6,722.91 rows=6,268 width=11) (actual time=2.217..9.547 rows=7,393 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,393
71. 1.295 1.295 ↓ 1.2 7,393 1

Bitmap Index Scan on ubpr_entry_20093_metric_id_period_value_idx (cost=0.00..72.75 rows=6,268 width=0) (actual time=1.295..1.295 rows=7,393 loops=1)

  • Index Cond: (metric_id = 682)
72. 7.983 9.190 ↓ 1.3 7,321 1

Bitmap Heap Scan on ubpr_entry_20094 re_34 (cost=68.57..6,262.11 rows=5,811 width=11) (actual time=2.082..9.190 rows=7,321 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,321
73. 1.207 1.207 ↓ 1.3 7,321 1

Bitmap Index Scan on ubpr_entry_20094_metric_id_period_value_idx (cost=0.00..67.12 rows=5,811 width=0) (actual time=1.207..1.207 rows=7,321 loops=1)

  • Index Cond: (metric_id = 682)
74. 9.024 10.214 ↓ 1.2 7,250 1

Bitmap Heap Scan on ubpr_entry_20101 re_35 (cost=72.10..6,569.06 rows=6,125 width=11) (actual time=2.429..10.214 rows=7,250 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,250
75. 1.190 1.190 ↓ 1.2 7,250 1

Bitmap Index Scan on ubpr_entry_20101_metric_id_period_value_idx (cost=0.00..70.57 rows=6,125 width=0) (actual time=1.190..1.190 rows=7,250 loops=1)

  • Index Cond: (metric_id = 682)
76. 8.508 9.600 ↓ 1.2 7,152 1

Bitmap Heap Scan on ubpr_entry_20102 re_36 (cost=71.86..6,545.85 rows=6,093 width=11) (actual time=2.208..9.600 rows=7,152 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,152
77. 1.092 1.092 ↓ 1.2 7,152 1

Bitmap Index Scan on ubpr_entry_20102_metric_id_period_value_idx (cost=0.00..70.33 rows=6,093 width=0) (actual time=1.092..1.092 rows=7,152 loops=1)

  • Index Cond: (metric_id = 682)
78. 7.727 8.574 ↓ 1.2 7,094 1

Bitmap Heap Scan on ubpr_entry_20103 re_37 (cost=71.14..6,436.64 rows=6,000 width=11) (actual time=1.677..8.574 rows=7,094 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,094
79. 0.847 0.847 ↓ 1.2 7,094 1

Bitmap Index Scan on ubpr_entry_20103_metric_id_period_value_idx (cost=0.00..69.64 rows=6,000 width=0) (actual time=0.847..0.847 rows=7,094 loops=1)

  • Index Cond: (metric_id = 682)
80. 7.688 9.180 ↓ 1.3 6,999 1

Bitmap Heap Scan on ubpr_entry_20104 re_38 (cost=65.28..5,949.94 rows=5,529 width=11) (actual time=2.404..9.180 rows=6,999 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,999
81. 1.492 1.492 ↓ 1.3 6,999 1

Bitmap Index Scan on ubpr_entry_20104_metric_id_period_value_idx (cost=0.00..63.90 rows=5,529 width=0) (actual time=1.492..1.492 rows=6,999 loops=1)

  • Index Cond: (metric_id = 682)
82. 7.985 9.030 ↑ 1.3 6,923 1

Bitmap Heap Scan on ubpr_entry_20111 re_39 (cost=108.35..9,719.69 rows=9,240 width=11) (actual time=1.948..9.030 rows=6,923 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,923
83. 1.045 1.045 ↑ 1.3 6,923 1

Bitmap Index Scan on ubpr_entry_20111_metric_id_period_value_idx (cost=0.00..106.04 rows=9,240 width=0) (actual time=1.045..1.045 rows=6,923 loops=1)

  • Index Cond: (metric_id = 682)
84. 7.405 8.559 ↓ 1.2 6,876 1

Bitmap Heap Scan on ubpr_entry_20112 re_40 (cost=67.74..6,129.67 rows=5,704 width=11) (actual time=1.950..8.559 rows=6,876 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,876
85. 1.154 1.154 ↓ 1.2 6,876 1

Bitmap Index Scan on ubpr_entry_20112_metric_id_period_value_idx (cost=0.00..66.31 rows=5,704 width=0) (actual time=1.154..1.154 rows=6,876 loops=1)

  • Index Cond: (metric_id = 682)
86. 8.506 9.112 ↓ 1.2 6,820 1

Bitmap Heap Scan on ubpr_entry_20113 re_41 (cost=67.78..6,132.23 rows=5,709 width=11) (actual time=1.320..9.112 rows=6,820 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,820
87. 0.606 0.606 ↓ 1.2 6,820 1

Bitmap Index Scan on ubpr_entry_20113_metric_id_period_value_idx (cost=0.00..66.35 rows=5,709 width=0) (actual time=0.606..0.606 rows=6,820 loops=1)

  • Index Cond: (metric_id = 682)
88. 7.988 9.230 ↓ 1.2 6,789 1

Bitmap Heap Scan on ubpr_entry_20114 re_42 (cost=64.57..5,861.62 rows=5,437 width=11) (actual time=2.403..9.230 rows=6,789 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,789
89. 1.242 1.242 ↓ 1.2 6,789 1

Bitmap Index Scan on ubpr_entry_20114_metric_id_period_value_idx (cost=0.00..63.21 rows=5,437 width=0) (actual time=1.242..1.242 rows=6,789 loops=1)

  • Index Cond: (metric_id = 682)
90. 7.969 9.683 ↓ 1.2 7,377 1

Bitmap Heap Scan on ubpr_entry_20121 re_43 (cost=72.13..6,581.19 rows=6,129 width=11) (actual time=2.603..9.683 rows=7,377 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,377
91. 1.714 1.714 ↓ 1.2 7,377 1

Bitmap Index Scan on ubpr_entry_20121_metric_id_period_value_idx (cost=0.00..70.60 rows=6,129 width=0) (actual time=1.714..1.714 rows=7,377 loops=1)

  • Index Cond: (metric_id = 682)
92. 8.790 10.052 ↓ 1.2 7,314 1

Bitmap Heap Scan on ubpr_entry_20122 re_44 (cost=72.10..6,588.81 rows=6,125 width=11) (actual time=2.179..10.052 rows=7,314 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,314
93. 1.262 1.262 ↓ 1.2 7,314 1

Bitmap Index Scan on ubpr_entry_20122_metric_id_period_value_idx (cost=0.00..70.57 rows=6,125 width=0) (actual time=1.262..1.262 rows=7,314 loops=1)

  • Index Cond: (metric_id = 682)
94. 8.897 10.260 ↓ 1.2 7,249 1

Bitmap Heap Scan on ubpr_entry_20123 re_45 (cost=72.38..6,623.10 rows=6,160 width=11) (actual time=2.326..10.260 rows=7,249 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,249
95. 1.363 1.363 ↓ 1.2 7,249 1

Bitmap Index Scan on ubpr_entry_20123_metric_id_period_value_idx (cost=0.00..70.84 rows=6,160 width=0) (actual time=1.363..1.363 rows=7,249 loops=1)

  • Index Cond: (metric_id = 682)
96. 8.590 10.099 ↓ 1.2 7,150 1

Bitmap Heap Scan on ubpr_entry_20124 re_46 (cost=67.90..6,171.50 rows=5,725 width=11) (actual time=2.475..10.099 rows=7,150 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,150
97. 1.509 1.509 ↓ 1.2 7,150 1

Bitmap Index Scan on ubpr_entry_20124_metric_id_period_value_idx (cost=0.00..66.47 rows=5,725 width=0) (actual time=1.509..1.509 rows=7,150 loops=1)

  • Index Cond: (metric_id = 682)
98. 7.876 9.938 ↓ 1.2 7,085 1

Bitmap Heap Scan on ubpr_entry_20131 re_47 (cost=70.61..6,370.01 rows=5,932 width=11) (actual time=3.075..9.938 rows=7,085 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,085
99. 2.062 2.062 ↓ 1.2 7,085 1

Bitmap Index Scan on ubpr_entry_20131_metric_id_period_value_idx (cost=0.00..69.13 rows=5,932 width=0) (actual time=2.062..2.062 rows=7,085 loops=1)

  • Index Cond: (metric_id = 682)
100. 7.703 8.403 ↓ 1.2 7,005 1

Bitmap Heap Scan on ubpr_entry_20132 re_48 (cost=70.66..6,376.50 rows=5,939 width=11) (actual time=1.719..8.403 rows=7,005 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,005
101. 0.700 0.700 ↓ 1.2 7,005 1

Bitmap Index Scan on ubpr_entry_20132_metric_id_period_value_idx (cost=0.00..69.18 rows=5,939 width=0) (actual time=0.700..0.700 rows=7,005 loops=1)

  • Index Cond: (metric_id = 682)
102. 7.565 8.610 ↓ 1.2 6,955 1

Bitmap Heap Scan on ubpr_entry_20133 re_49 (cost=68.48..6,230.13 rows=5,800 width=11) (actual time=1.784..8.610 rows=6,955 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,955
103. 1.045 1.045 ↓ 1.2 6,955 1

Bitmap Index Scan on ubpr_entry_20133_metric_id_period_value_idx (cost=0.00..67.03 rows=5,800 width=0) (actual time=1.045..1.045 rows=6,955 loops=1)

  • Index Cond: (metric_id = 682)
104. 7.261 8.148 ↑ 1.3 6,877 1

Bitmap Heap Scan on ubpr_entry_20134 re_50 (cost=107.11..9,573.57 rows=9,081 width=11) (actual time=1.918..8.148 rows=6,877 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,877
105. 0.887 0.887 ↑ 1.3 6,877 1

Bitmap Index Scan on ubpr_entry_20134_metric_id_period_value_idx (cost=0.00..104.84 rows=9,081 width=0) (actual time=0.887..0.887 rows=6,877 loops=1)

  • Index Cond: (metric_id = 682)
106. 9.788 10.863 ↓ 1.2 6,794 1

Bitmap Heap Scan on ubpr_entry_20141 re_51 (cost=68.20..6,184.79 rows=5,763 width=11) (actual time=1.889..10.863 rows=6,794 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,794
107. 1.075 1.075 ↓ 1.2 6,794 1

Bitmap Index Scan on ubpr_entry_20141_metric_id_period_value_idx (cost=0.00..66.76 rows=5,763 width=0) (actual time=1.075..1.075 rows=6,794 loops=1)

  • Index Cond: (metric_id = 682)
108. 7.200 8.165 ↓ 1.2 6,722 1

Bitmap Heap Scan on ubpr_entry_20142 re_52 (cost=65.64..5,999.49 rows=5,575 width=11) (actual time=1.705..8.165 rows=6,722 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,722
109. 0.965 0.965 ↓ 1.2 6,722 1

Bitmap Index Scan on ubpr_entry_20142_metric_id_period_value_idx (cost=0.00..64.25 rows=5,575 width=0) (actual time=0.965..0.965 rows=6,722 loops=1)

  • Index Cond: (metric_id = 682)
110. 7.223 8.240 ↓ 1.2 6,651 1

Bitmap Heap Scan on ubpr_entry_20143 re_53 (cost=65.63..5,995.65 rows=5,573 width=11) (actual time=1.912..8.240 rows=6,651 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,651
111. 1.017 1.017 ↓ 1.2 6,651 1

Bitmap Index Scan on ubpr_entry_20143_metric_id_period_value_idx (cost=0.00..64.23 rows=5,573 width=0) (actual time=1.017..1.017 rows=6,651 loops=1)

  • Index Cond: (metric_id = 682)
112. 7.779 8.667 ↓ 1.3 6,570 1

Bitmap Heap Scan on ubpr_entry_20144 re_54 (cost=61.91..5,644.23 rows=5,235 width=11) (actual time=1.581..8.667 rows=6,570 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,570
113. 0.888 0.888 ↓ 1.3 6,570 1

Bitmap Index Scan on ubpr_entry_20144_metric_id_period_value_idx (cost=0.00..60.60 rows=5,235 width=0) (actual time=0.888..0.888 rows=6,570 loops=1)

  • Index Cond: (metric_id = 682)
114. 7.813 8.692 ↓ 1.2 6,480 1

Bitmap Heap Scan on ubpr_entry_20151 re_55 (cost=65.40..5,955.97 rows=5,544 width=11) (actual time=1.768..8.692 rows=6,480 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,480
115. 0.879 0.879 ↓ 1.2 6,480 1

Bitmap Index Scan on ubpr_entry_20151_metric_id_period_value_idx (cost=0.00..64.02 rows=5,544 width=0) (actual time=0.878..0.879 rows=6,480 loops=1)

  • Index Cond: (metric_id = 682)
116. 7.674 9.119 ↓ 1.2 6,408 1

Bitmap Heap Scan on ubpr_entry_20152 re_56 (cost=64.70..5,872.63 rows=5,454 width=11) (actual time=2.586..9.119 rows=6,408 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,408
117. 1.445 1.445 ↓ 1.2 6,408 1

Bitmap Index Scan on ubpr_entry_20152_metric_id_period_value_idx (cost=0.00..63.34 rows=5,454 width=0) (actual time=1.445..1.445 rows=6,408 loops=1)

  • Index Cond: (metric_id = 682)
118. 9.380 10.214 ↓ 1.2 6,328 1

Bitmap Heap Scan on ubpr_entry_20153 re_57 (cost=63.00..5,777.77 rows=5,376 width=11) (actual time=1.887..10.214 rows=6,328 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,328
119. 0.834 0.834 ↓ 1.2 6,328 1

Bitmap Index Scan on ubpr_entry_20153_metric_id_period_value_idx (cost=0.00..61.66 rows=5,376 width=0) (actual time=0.834..0.834 rows=6,328 loops=1)

  • Index Cond: (metric_id = 682)
120. 9.640 10.795 ↓ 1.2 6,238 1

Bitmap Heap Scan on ubpr_entry_20154 re_58 (cost=59.26..5,424.35 rows=5,035 width=11) (actual time=2.227..10.795 rows=6,238 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,238
121. 1.155 1.155 ↓ 1.2 6,238 1

Bitmap Index Scan on ubpr_entry_20154_metric_id_period_value_idx (cost=0.00..58.00 rows=5,035 width=0) (actual time=1.155..1.155 rows=6,238 loops=1)

  • Index Cond: (metric_id = 682)
122. 10.741 11.910 ↓ 1.2 6,176 1

Bitmap Heap Scan on ubpr_entry_20161 re_59 (cost=62.34..5,684.70 rows=5,291 width=11) (actual time=2.582..11.910 rows=6,176 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,176
123. 1.169 1.169 ↓ 1.2 6,176 1

Bitmap Index Scan on ubpr_entry_20161_metric_id_period_value_idx (cost=0.00..61.01 rows=5,291 width=0) (actual time=1.169..1.169 rows=6,176 loops=1)

  • Index Cond: (metric_id = 682)
124. 8.744 10.141 ↓ 1.2 6,112 1

Bitmap Heap Scan on ubpr_entry_20162 re_60 (cost=60.93..5,496.55 rows=5,109 width=11) (actual time=2.319..10.141 rows=6,112 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,112
125. 1.397 1.397 ↓ 1.2 6,112 1

Bitmap Index Scan on ubpr_entry_20162_metric_id_period_value_idx (cost=0.00..59.65 rows=5,109 width=0) (actual time=1.397..1.397 rows=6,112 loops=1)

  • Index Cond: (metric_id = 682)
126. 8.405 9.266 ↓ 1.2 6,034 1

Bitmap Heap Scan on ubpr_entry_20163 re_61 (cost=61.38..5,552.02 rows=5,167 width=11) (actual time=1.745..9.266 rows=6,034 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,034
127. 0.861 0.861 ↓ 1.2 6,034 1

Bitmap Index Scan on ubpr_entry_20163_metric_id_period_value_idx (cost=0.00..60.09 rows=5,167 width=0) (actual time=0.861..0.861 rows=6,034 loops=1)

  • Index Cond: (metric_id = 682)
128. 1,212.604 1,213.465 ↓ 1.2 5,966 1

Bitmap Heap Scan on ubpr_entry_20164 re_62 (cost=56.31..5,168.33 rows=4,797 width=11) (actual time=1.779..1,213.465 rows=5,966 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,966
129. 0.861 0.861 ↓ 1.2 5,966 1

Bitmap Index Scan on ubpr_entry_20164_metric_id_period_value_idx (cost=0.00..55.11 rows=4,797 width=0) (actual time=0.860..0.861 rows=5,966 loops=1)

  • Index Cond: (metric_id = 682)
130. 8,474.472 8,475.938 ↓ 1.3 5,908 1

Bitmap Heap Scan on ubpr_entry_20171 re_63 (cost=54.53..4,911.58 rows=4,567 width=11) (actual time=2.416..8,475.938 rows=5,908 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,908
131. 1.466 1.466 ↓ 1.3 5,908 1

Bitmap Index Scan on ubpr_entry_20171_metric_id_period_value_idx (cost=0.00..53.38 rows=4,567 width=0) (actual time=1.466..1.466 rows=5,908 loops=1)

  • Index Cond: (metric_id = 682)
132. 6,764.531 6,766.630 ↓ 1.3 5,839 1

Bitmap Heap Scan on ubpr_entry_20172 re_64 (cost=54.21..4,875.55 rows=4,526 width=11) (actual time=5.075..6,766.630 rows=5,839 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,839
133. 2.099 2.099 ↓ 1.3 5,839 1

Bitmap Index Scan on ubpr_entry_20172_metric_id_period_value_idx (cost=0.00..53.08 rows=4,526 width=0) (actual time=2.099..2.099 rows=5,839 loops=1)

  • Index Cond: (metric_id = 682)
134. 4,567.783 4,569.996 ↓ 1.3 5,789 1

Bitmap Heap Scan on ubpr_entry_20173 re_65 (cost=54.08..4,856.60 rows=4,509 width=11) (actual time=3.157..4,569.996 rows=5,789 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,789
135. 2.213 2.213 ↓ 1.3 5,789 1

Bitmap Index Scan on ubpr_entry_20173_metric_id_period_value_idx (cost=0.00..52.95 rows=4,509 width=0) (actual time=2.213..2.213 rows=5,789 loops=1)

  • Index Cond: (metric_id = 682)
136. 7,634.440 7,635.705 ↓ 1.3 5,721 1

Bitmap Heap Scan on ubpr_entry_20174 re_66 (cost=50.99..4,582.57 rows=4,252 width=11) (actual time=2.182..7,635.705 rows=5,721 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,721
137. 1.265 1.265 ↓ 1.3 5,721 1

Bitmap Index Scan on ubpr_entry_20174_metric_id_period_value_idx (cost=0.00..49.92 rows=4,252 width=0) (actual time=1.265..1.265 rows=5,721 loops=1)

  • Index Cond: (metric_id = 682)
138. 114.721 118.427 ↓ 1.3 5,657 1

Bitmap Heap Scan on ubpr_entry_20181 re_67 (cost=51.33..4,621.83 rows=4,297 width=11) (actual time=4.642..118.427 rows=5,657 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,657
139. 3.706 3.706 ↓ 1.3 5,657 1

Bitmap Index Scan on ubpr_entry_20181_metric_id_period_value_idx (cost=0.00..50.26 rows=4,297 width=0) (actual time=3.706..3.706 rows=5,657 loops=1)

  • Index Cond: (metric_id = 682)
140. 12,635.334 12,638.629 ↓ 1.3 5,593 1

Bitmap Heap Scan on ubpr_entry_20182 re_68 (cost=51.71..4,668.43 rows=4,346 width=11) (actual time=9.204..12,638.629 rows=5,593 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,591
141. 3.295 3.295 ↓ 1.3 5,593 1

Bitmap Index Scan on ubpr_entry_20182_metric_id_period_value_idx (cost=0.00..50.63 rows=4,346 width=0) (actual time=3.295..3.295 rows=5,593 loops=1)

  • Index Cond: (metric_id = 682)
142. 12,997.044 13,000.057 ↓ 1.3 5,527 1

Bitmap Heap Scan on ubpr_entry_20183 re_69 (cost=51.50..4,638.56 rows=4,319 width=11) (actual time=8.295..13,000.057 rows=5,527 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,527
143. 3.013 3.013 ↓ 1.3 5,527 1

Bitmap Index Scan on ubpr_entry_20183_metric_id_period_value_idx (cost=0.00..50.42 rows=4,319 width=0) (actual time=3.013..3.013 rows=5,527 loops=1)

  • Index Cond: (metric_id = 682)
144. 5,887.855 5,887.855 ↓ 1.3 5,456 1

Index Scan using ubpr_entry_20184_metric_id_period_value_idx on ubpr_entry_20184 re_70 (cost=0.43..4,464.83 rows=4,111 width=11) (actual time=9.987..5,887.855 rows=5,456 loops=1)

  • Index Cond: (metric_id = 682)
145. 48.506 53.193 ↓ 1.3 5,411 1

Bitmap Heap Scan on ubpr_entry_20191 re_71 (cost=50.86..4,546.86 rows=4,236 width=11) (actual time=5.590..53.193 rows=5,411 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,411
146. 4.687 4.687 ↓ 1.3 5,411 1

Bitmap Index Scan on ubpr_entry_20191_metric_id_period_value_idx (cost=0.00..49.80 rows=4,236 width=0) (actual time=4.687..4.687 rows=5,411 loops=1)

  • Index Cond: (metric_id = 682)
147. 1,727.253 1,732.064 ↓ 1.3 5,352 1

Bitmap Heap Scan on ubpr_entry_20192 re_72 (cost=50.44..4,491.33 rows=4,182 width=11) (actual time=6.566..1,732.064 rows=5,352 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,352
148. 4.811 4.811 ↓ 1.3 5,352 1

Bitmap Index Scan on ubpr_entry_20192_metric_id_period_value_idx (cost=0.00..49.40 rows=4,182 width=0) (actual time=4.811..4.811 rows=5,352 loops=1)

  • Index Cond: (metric_id = 682)
149. 119.368 123.195 ↓ 1.3 5,308 1

Bitmap Heap Scan on ubpr_entry_20193 re_73 (cost=47.86..4,287.35 rows=3,991 width=11) (actual time=5.042..123.195 rows=5,308 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,308
150. 3.827 3.827 ↓ 1.3 5,308 1

Bitmap Index Scan on ubpr_entry_20193_metric_id_period_value_idx (cost=0.00..46.86 rows=3,991 width=0) (actual time=3.827..3.827 rows=5,308 loops=1)

  • Index Cond: (metric_id = 682)
151. 178.445 178.445 ↑ 1.3 5,227 1

Index Scan using ubpr_entry_20194_metric_id_period_value_idx on ubpr_entry_20194 re_74 (cost=0.43..7,237.09 rows=6,767 width=11) (actual time=0.174..178.445 rows=5,227 loops=1)

  • Index Cond: (metric_id = 682)
152. 52.279 56.351 ↑ 1.4 4,717 1

Bitmap Heap Scan on ubpr_entry_20201 re_75 (cost=77.22..6,788.13 rows=6,502 width=11) (actual time=5.073..56.351 rows=4,717 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=4,717
153. 4.072 4.072 ↑ 1.4 4,717 1

Bitmap Index Scan on ubpr_entry_20201_metric_id_period_value_idx (cost=0.00..75.60 rows=6,502 width=0) (actual time=4.072..4.072 rows=4,717 loops=1)

  • Index Cond: (metric_id = 682)
154. 0.001 0.012 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20202 re_76 (cost=1.28..5.48 rows=4 width=38) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
155. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20202_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.010..0.011 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
156. 0.001 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20203 re_77 (cost=1.28..5.48 rows=4 width=38) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
157. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20203_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
158. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20204 re_78 (cost=1.28..5.48 rows=4 width=38) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
159. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20204_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
160. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20211 re_79 (cost=1.28..5.48 rows=4 width=38) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
161. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20211_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
162. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20212 re_80 (cost=1.28..5.48 rows=4 width=38) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
163. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20212_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
164. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20213 re_81 (cost=1.28..5.48 rows=4 width=38) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
165. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20213_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
166. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20214 re_82 (cost=1.28..5.48 rows=4 width=38) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
167. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20214_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
168. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20221 re_83 (cost=1.28..5.48 rows=4 width=38) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
169. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20221_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
170. 0.000 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20222 re_84 (cost=1.28..5.48 rows=4 width=38) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
171. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20222_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
172. 0.001 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20223 re_85 (cost=1.28..5.48 rows=4 width=38) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
173. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20223_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
174. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20224 re_86 (cost=1.28..5.48 rows=4 width=38) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
175. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20224_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
176. 0.000 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20231 re_87 (cost=1.28..5.48 rows=4 width=38) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
177. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20231_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
178. 0.001 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20232 re_88 (cost=1.28..5.48 rows=4 width=38) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
179. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20232_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
180. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20233 re_89 (cost=1.28..5.48 rows=4 width=38) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
181. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20233_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
182. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20234 re_90 (cost=1.28..5.48 rows=4 width=38) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
183. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20234_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
184. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20241 re_91 (cost=1.28..5.48 rows=4 width=38) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
185. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20241_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
186. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20242 re_92 (cost=1.28..5.48 rows=4 width=38) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
187. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20242_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
188. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20243 re_93 (cost=1.28..5.48 rows=4 width=38) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
189. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20243_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
190. 0.001 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20244 re_94 (cost=1.28..5.48 rows=4 width=38) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
191. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20244_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
192. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20251 re_95 (cost=1.28..5.48 rows=4 width=38) (actual time=0.003..0.004 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
193. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20251_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
194. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20252 re_96 (cost=1.28..5.48 rows=4 width=38) (actual time=0.003..0.004 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
195. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20252_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
196. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20253 re_97 (cost=1.28..5.48 rows=4 width=38) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
197. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20253_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
198. 0.000 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20254 re_98 (cost=1.28..5.48 rows=4 width=38) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
199. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on ubpr_entry_20254_metric_id_period_value_idx (cost=0.00..1.28 rows=4 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
200. 2.220 180.876 ↑ 1.1 8,150 1

Hash (cost=9,331.87..9,331.87 rows=8,637 width=6) (actual time=180.876..180.876 rows=8,150 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 431kB
201. 7.455 178.656 ↑ 1.1 8,150 1

HashAggregate (cost=9,159.13..9,245.50 rows=8,637 width=6) (actual time=176.210..178.656 rows=8,150 loops=1)

  • Group Key: bpg.bank_id, bpg.period
202. 0.266 171.201 ↑ 1.0 8,277 1

Append (cost=1,000.00..9,115.94 rows=8,637 width=6) (actual time=3.883..171.201 rows=8,277 loops=1)

203. 127.166 170.343 ↑ 1.1 8,150 1

Gather (cost=1,000.00..8,918.94 rows=8,578 width=6) (actual time=3.882..170.343 rows=8,150 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
204. 43.177 43.177 ↑ 1.2 4,075 2 / 2

Parallel Seq Scan on bank_in_peer_group bpg (cost=0.00..7,061.14 rows=5,046 width=6) (actual time=0.014..43.177 rows=4,075 loops=2)

  • Filter: (peer_group_id = 3)
  • Rows Removed by Filter: 272,627
205. 0.592 0.592 ↓ 2.2 127 1

Index Only Scan using bank_in_peer_group_pkey on bank_in_peer_group bpg_1 (cost=0.42..67.45 rows=59 width=6) (actual time=0.476..0.592 rows=127 loops=1)

  • Index Cond: (bank_id = 42,420)
  • Heap Fetches: 127
Planning time : 77.680 ms
Execution time : 64,223.352 ms