explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kCC6

Settings
# exclusive inclusive rows x rows loops node
1. 6.393 892.842 ↑ 10.5 4,812 1

WindowAgg (cost=488,281.42..490,945.16 rows=50,738 width=43) (actual time=881.748..892.842 rows=4,812 loops=1)

2. 4.590 886.449 ↑ 10.5 4,812 1

WindowAgg (cost=488,281.42..489,296.18 rows=50,738 width=19) (actual time=881.650..886.449 rows=4,812 loops=1)

3. 5.135 881.859 ↑ 10.5 4,812 1

Sort (cost=488,281.42..488,408.26 rows=50,738 width=11) (actual time=881.640..881.859 rows=4,812 loops=1)

  • Sort Key: re.period, re.value DESC
  • Sort Method: quicksort Memory: 418kB
4. 57.906 876.724 ↑ 10.5 4,812 1

Hash Join (cost=2,990.81..484,316.04 rows=50,738 width=11) (actual time=11.704..876.724 rows=4,812 loops=1)

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

Append (cost=0.29..478,960.25 rows=450,501 width=11) (actual time=3.504..810.888 rows=491,907 loops=1)

6. 0.018 0.018 ↓ 0.0 0 1

Index Scan using ubpr_entry_20012_metric_id_period_value_idx on ubpr_entry_20012 re (cost=0.29..2.35 rows=1 width=12) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
7. 0.008 0.008 ↓ 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.35 rows=1 width=12) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
8. 0.001 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20014 re_2 (cost=60.37..4,352.13 rows=5,322 width=10) (actual time=0.009..0.009 rows=0 loops=1)

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

Bitmap Index Scan on ubpr_entry_20014_metric_id_period_value_idx (cost=0.00..59.04 rows=5,322 width=0) (actual time=0.008..0.008 rows=0 loops=1)

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

Bitmap Heap Scan on ubpr_entry_20021 re_3 (cost=63.65..4,558.35 rows=5,461 width=11) (actual time=0.007..0.007 rows=0 loops=1)

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

Bitmap Index Scan on ubpr_entry_20021_metric_id_period_value_idx (cost=0.00..62.29 rows=5,461 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
12. 0.000 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on ubpr_entry_20022 re_4 (cost=78.25..5,371.82 rows=6,209 width=11) (actual time=0.007..0.007 rows=0 loops=1)

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

Bitmap Index Scan on ubpr_entry_20022_metric_id_period_value_idx (cost=0.00..76.69 rows=6,209 width=0) (actual time=0.007..0.007 rows=0 loops=1)

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

Bitmap Heap Scan on ubpr_entry_20023 re_5 (cost=77.93..5,410.55 rows=6,168 width=11) (actual time=0.009..0.009 rows=0 loops=1)

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

Bitmap Index Scan on ubpr_entry_20023_metric_id_period_value_idx (cost=0.00..76.39 rows=6,168 width=0) (actual time=0.008..0.009 rows=0 loops=1)

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

Bitmap Heap Scan on ubpr_entry_20024 re_6 (cost=115.01..7,661.08 rows=7,119 width=11) (actual time=3.445..13.478 rows=8,468 loops=1)

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

Bitmap Index Scan on ubpr_entry_20024_metric_id_period_value_idx (cost=0.00..113.23 rows=7,119 width=0) (actual time=2.030..2.030 rows=8,468 loops=1)

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

Bitmap Heap Scan on ubpr_entry_20031 re_7 (cost=116.96..7,909.21 rows=7,371 width=11) (actual time=3.437..13.921 rows=8,444 loops=1)

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

Bitmap Index Scan on ubpr_entry_20031_metric_id_period_value_idx (cost=0.00..115.12 rows=7,371 width=0) (actual time=2.041..2.041 rows=8,444 loops=1)

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

Bitmap Heap Scan on ubpr_entry_20032 re_8 (cost=122.04..8,019.75 rows=7,459 width=11) (actual time=2.985..13.215 rows=8,410 loops=1)

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

Bitmap Index Scan on ubpr_entry_20032_metric_id_period_value_idx (cost=0.00..120.18 rows=7,459 width=0) (actual time=1.620..1.621 rows=8,410 loops=1)

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

Bitmap Heap Scan on ubpr_entry_20033 re_9 (cost=121.76..7,981.62 rows=7,423 width=11) (actual time=3.037..12.817 rows=8,391 loops=1)

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

Bitmap Index Scan on ubpr_entry_20033_metric_id_period_value_idx (cost=0.00..119.91 rows=7,423 width=0) (actual time=1.660..1.660 rows=8,391 loops=1)

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

Bitmap Heap Scan on ubpr_entry_20034 re_10 (cost=119.15..7,780.81 rows=7,228 width=11) (actual time=2.962..13.714 rows=8,348 loops=1)

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

Bitmap Index Scan on ubpr_entry_20034_metric_id_period_value_idx (cost=0.00..117.35 rows=7,228 width=0) (actual time=1.603..1.603 rows=8,348 loops=1)

  • Index Cond: (metric_id = 682)
26. 11.174 12.872 ↓ 1.1 8,286 1

Bitmap Heap Scan on ubpr_entry_20041 re_11 (cost=116.55..7,849.10 rows=7,318 width=11) (actual time=3.069..12.872 rows=8,286 loops=1)

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

Bitmap Index Scan on ubpr_entry_20041_metric_id_period_value_idx (cost=0.00..114.72 rows=7,318 width=0) (actual time=1.698..1.698 rows=8,286 loops=1)

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

Bitmap Heap Scan on ubpr_entry_20042 re_12 (cost=121.04..7,881.53 rows=7,330 width=11) (actual time=3.001..12.816 rows=8,261 loops=1)

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

Bitmap Index Scan on ubpr_entry_20042_metric_id_period_value_idx (cost=0.00..119.21 rows=7,330 width=0) (actual time=1.645..1.645 rows=8,261 loops=1)

  • Index Cond: (metric_id = 682)
30. 12.027 13.696 ↓ 1.2 8,219 1

Bitmap Heap Scan on ubpr_entry_20043 re_13 (cost=117.36..7,682.37 rows=7,139 width=11) (actual time=3.003..13.696 rows=8,219 loops=1)

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

Bitmap Index Scan on ubpr_entry_20043_metric_id_period_value_idx (cost=0.00..115.58 rows=7,139 width=0) (actual time=1.669..1.669 rows=8,219 loops=1)

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

Bitmap Heap Scan on ubpr_entry_20044 re_14 (cost=114.87..7,498.45 rows=6,959 width=11) (actual time=3.212..13.645 rows=8,179 loops=1)

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

Bitmap Index Scan on ubpr_entry_20044_metric_id_period_value_idx (cost=0.00..113.13 rows=6,959 width=0) (actual time=1.854..1.854 rows=8,179 loops=1)

  • Index Cond: (metric_id = 682)
34. 11.570 13.244 ↓ 1.2 8,141 1

Bitmap Heap Scan on ubpr_entry_20051 re_15 (cost=113.41..7,574.22 rows=7,055 width=11) (actual time=3.001..13.244 rows=8,141 loops=1)

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

Bitmap Index Scan on ubpr_entry_20051_metric_id_period_value_idx (cost=0.00..111.65 rows=7,055 width=0) (actual time=1.674..1.674 rows=8,141 loops=1)

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

Bitmap Heap Scan on ubpr_entry_20052 re_16 (cost=116.76..7,597.46 rows=7,061 width=11) (actual time=3.109..13.536 rows=8,083 loops=1)

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

Bitmap Index Scan on ubpr_entry_20052_metric_id_period_value_idx (cost=0.00..114.99 rows=7,061 width=0) (actual time=1.775..1.775 rows=8,083 loops=1)

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

Bitmap Heap Scan on ubpr_entry_20053 re_17 (cost=115.43..7,563.25 rows=7,031 width=11) (actual time=2.963..12.978 rows=8,079 loops=1)

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

Bitmap Index Scan on ubpr_entry_20053_metric_id_period_value_idx (cost=0.00..113.67 rows=7,031 width=0) (actual time=1.636..1.636 rows=8,079 loops=1)

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

Bitmap Heap Scan on ubpr_entry_20054 re_18 (cost=114.70..7,468.11 rows=6,937 width=11) (actual time=2.914..12.578 rows=8,056 loops=1)

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

Bitmap Index Scan on ubpr_entry_20054_metric_id_period_value_idx (cost=0.00..112.96 rows=6,937 width=0) (actual time=1.598..1.598 rows=8,056 loops=1)

  • Index Cond: (metric_id = 682)
42. 3.195 3.195 ↓ 1.2 8,020 1

Index Scan using ubpr_entry_20061_metric_id_period_value_idx on ubpr_entry_20061 re_19 (cost=0.56..3,418.27 rows=6,831 width=11) (actual time=0.024..3.195 rows=8,020 loops=1)

  • Index Cond: (metric_id = 682)
43. 10.855 12.561 ↓ 1.1 8,010 1

Bitmap Heap Scan on ubpr_entry_20062 re_20 (cost=116.18..7,660.09 rows=7,128 width=11) (actual time=3.006..12.561 rows=8,010 loops=1)

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

Bitmap Index Scan on ubpr_entry_20062_metric_id_period_value_idx (cost=0.00..114.40 rows=7,128 width=0) (actual time=1.705..1.706 rows=8,010 loops=1)

  • Index Cond: (metric_id = 682)
45. 11.372 12.969 ↓ 1.1 7,978 1

Bitmap Heap Scan on ubpr_entry_20063 re_21 (cost=116.06..7,645.02 rows=7,113 width=11) (actual time=2.900..12.969 rows=7,978 loops=1)

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

Bitmap Index Scan on ubpr_entry_20063_metric_id_period_value_idx (cost=0.00..114.28 rows=7,113 width=0) (actual time=1.597..1.597 rows=7,978 loops=1)

  • Index Cond: (metric_id = 682)
47. 11.515 13.151 ↓ 1.1 7,922 1

Bitmap Heap Scan on ubpr_entry_20064 re_22 (cost=113.33..7,428.03 rows=6,902 width=11) (actual time=2.955..13.151 rows=7,922 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,922
48. 1.636 1.636 ↓ 1.1 7,922 1

Bitmap Index Scan on ubpr_entry_20064_metric_id_period_value_idx (cost=0.00..111.60 rows=6,902 width=0) (actual time=1.636..1.636 rows=7,922 loops=1)

  • Index Cond: (metric_id = 682)
49. 11.062 12.753 ↓ 1.2 7,896 1

Bitmap Heap Scan on ubpr_entry_20071 re_23 (cost=105.88..7,157.64 rows=6,651 width=11) (actual time=3.065..12.753 rows=7,896 loops=1)

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

Bitmap Index Scan on ubpr_entry_20071_metric_id_period_value_idx (cost=0.00..104.22 rows=6,651 width=0) (actual time=1.690..1.691 rows=7,896 loops=1)

  • Index Cond: (metric_id = 682)
51. 10.962 12.578 ↓ 1.2 7,862 1

Bitmap Heap Scan on ubpr_entry_20072 re_24 (cost=109.30..7,188.38 rows=6,666 width=11) (actual time=2.904..12.578 rows=7,862 loops=1)

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

Bitmap Index Scan on ubpr_entry_20072_metric_id_period_value_idx (cost=0.00..107.63 rows=6,666 width=0) (actual time=1.616..1.616 rows=7,862 loops=1)

  • Index Cond: (metric_id = 682)
53. 10.988 12.563 ↓ 1.2 7,811 1

Bitmap Heap Scan on ubpr_entry_20073 re_25 (cost=109.54..7,219.47 rows=6,697 width=11) (actual time=2.924..12.563 rows=7,811 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,811
54. 1.575 1.575 ↓ 1.2 7,811 1

Bitmap Index Scan on ubpr_entry_20073_metric_id_period_value_idx (cost=0.00..107.86 rows=6,697 width=0) (actual time=1.575..1.575 rows=7,811 loops=1)

  • Index Cond: (metric_id = 682)
55. 10.931 12.529 ↓ 1.2 7,788 1

Bitmap Heap Scan on ubpr_entry_20074 re_26 (cost=105.48..6,971.90 rows=6,458 width=11) (actual time=2.871..12.529 rows=7,788 loops=1)

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

Bitmap Index Scan on ubpr_entry_20074_metric_id_period_value_idx (cost=0.00..103.87 rows=6,458 width=0) (actual time=1.598..1.598 rows=7,788 loops=1)

  • Index Cond: (metric_id = 682)
57. 10.872 12.632 ↓ 1.1 7,740 1

Bitmap Heap Scan on ubpr_entry_20081 re_27 (cost=109.08..7,295.56 rows=6,780 width=11) (actual time=3.024..12.632 rows=7,740 loops=1)

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

Bitmap Index Scan on ubpr_entry_20081_metric_id_period_value_idx (cost=0.00..107.39 rows=6,780 width=0) (actual time=1.760..1.760 rows=7,740 loops=1)

  • Index Cond: (metric_id = 682)
59. 10.800 12.374 ↓ 1.2 7,698 1

Bitmap Heap Scan on ubpr_entry_20082 re_28 (cost=109.30..7,193.72 rows=6,667 width=11) (actual time=2.837..12.374 rows=7,698 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,698
60. 1.574 1.574 ↓ 1.2 7,698 1

Bitmap Index Scan on ubpr_entry_20082_metric_id_period_value_idx (cost=0.00..107.64 rows=6,667 width=0) (actual time=1.574..1.574 rows=7,698 loops=1)

  • Index Cond: (metric_id = 682)
61. 10.907 12.512 ↓ 1.1 7,640 1

Bitmap Heap Scan on ubpr_entry_20083 re_29 (cost=111.20..7,298.77 rows=6,770 width=11) (actual time=2.859..12.512 rows=7,640 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,640
62. 1.605 1.605 ↓ 1.1 7,640 1

Bitmap Index Scan on ubpr_entry_20083_metric_id_period_value_idx (cost=0.00..109.51 rows=6,770 width=0) (actual time=1.604..1.605 rows=7,640 loops=1)

  • Index Cond: (metric_id = 682)
63. 10.748 12.347 ↓ 1.2 7,568 1

Bitmap Heap Scan on ubpr_entry_20084 re_30 (cost=108.54..7,089.97 rows=6,569 width=11) (actual time=2.839..12.347 rows=7,568 loops=1)

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

Bitmap Index Scan on ubpr_entry_20084_metric_id_period_value_idx (cost=0.00..106.90 rows=6,569 width=0) (actual time=1.599..1.599 rows=7,568 loops=1)

  • Index Cond: (metric_id = 682)
65. 10.698 12.317 ↓ 1.2 7,520 1

Bitmap Heap Scan on ubpr_entry_20091 re_31 (cost=103.39..6,969.14 rows=6,471 width=11) (actual time=2.853..12.317 rows=7,520 loops=1)

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

Bitmap Index Scan on ubpr_entry_20091_metric_id_period_value_idx (cost=0.00..101.77 rows=6,471 width=0) (actual time=1.618..1.619 rows=7,520 loops=1)

  • Index Cond: (metric_id = 682)
67. 11.184 12.868 ↓ 1.2 7,476 1

Bitmap Heap Scan on ubpr_entry_20092 re_32 (cost=106.69..6,984.64 rows=6,471 width=11) (actual time=2.951..12.868 rows=7,476 loops=1)

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

Bitmap Index Scan on ubpr_entry_20092_metric_id_period_value_idx (cost=0.00..105.07 rows=6,471 width=0) (actual time=1.684..1.684 rows=7,476 loops=1)

  • Index Cond: (metric_id = 682)
69. 10.706 12.619 ↓ 1.2 7,393 1

Bitmap Heap Scan on ubpr_entry_20093 re_33 (cost=104.54..6,842.94 rows=6,336 width=11) (actual time=3.190..12.619 rows=7,393 loops=1)

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

Bitmap Index Scan on ubpr_entry_20093_metric_id_period_value_idx (cost=0.00..102.96 rows=6,336 width=0) (actual time=1.913..1.913 rows=7,393 loops=1)

  • Index Cond: (metric_id = 682)
71. 10.797 12.333 ↓ 1.2 7,321 1

Bitmap Heap Scan on ubpr_entry_20094 re_34 (cost=98.02..6,410.01 rows=5,921 width=11) (actual time=2.728..12.333 rows=7,321 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,321
72. 1.536 1.536 ↓ 1.2 7,321 1

Bitmap Index Scan on ubpr_entry_20094_metric_id_period_value_idx (cost=0.00..96.54 rows=5,921 width=0) (actual time=1.536..1.536 rows=7,321 loops=1)

  • Index Cond: (metric_id = 682)
73. 10.347 11.830 ↑ 1.7 7,250 1

Bitmap Heap Scan on ubpr_entry_20101 re_35 (cost=191.28..12,522.57 rows=11,993 width=11) (actual time=2.678..11.830 rows=7,250 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=7,250
74. 1.483 1.483 ↑ 1.7 7,250 1

Bitmap Index Scan on ubpr_entry_20101_metric_id_period_value_idx (cost=0.00..188.28 rows=11,993 width=0) (actual time=1.483..1.483 rows=7,250 loops=1)

  • Index Cond: (metric_id = 682)
75. 10.024 11.596 ↓ 1.2 7,152 1

Bitmap Heap Scan on ubpr_entry_20102 re_36 (cost=98.98..6,529.49 rows=6,044 width=11) (actual time=2.741..11.596 rows=7,152 loops=1)

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

Bitmap Index Scan on ubpr_entry_20102_metric_id_period_value_idx (cost=0.00..97.47 rows=6,044 width=0) (actual time=1.571..1.572 rows=7,152 loops=1)

  • Index Cond: (metric_id = 682)
77. 10.108 11.046 ↓ 1.2 7,094 1

Bitmap Heap Scan on ubpr_entry_20103 re_37 (cost=100.46..6,581.25 rows=6,094 width=11) (actual time=2.012..11.046 rows=7,094 loops=1)

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

Bitmap Index Scan on ubpr_entry_20103_metric_id_period_value_idx (cost=0.00..98.94 rows=6,094 width=0) (actual time=0.937..0.938 rows=7,094 loops=1)

  • Index Cond: (metric_id = 682)
79. 9.896 11.066 ↓ 1.2 6,999 1

Bitmap Heap Scan on ubpr_entry_20104 re_38 (cost=92.45..6,093.80 rows=5,628 width=11) (actual time=2.231..11.066 rows=6,999 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,999
80. 1.170 1.170 ↓ 1.2 6,999 1

Bitmap Index Scan on ubpr_entry_20104_metric_id_period_value_idx (cost=0.00..91.05 rows=5,628 width=0) (actual time=1.170..1.170 rows=6,999 loops=1)

  • Index Cond: (metric_id = 682)
81. 9.644 10.983 ↓ 1.2 6,923 1

Bitmap Heap Scan on ubpr_entry_20111 re_39 (cost=92.91..6,286.82 rows=5,829 width=11) (actual time=2.400..10.983 rows=6,923 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,923
82. 1.339 1.339 ↓ 1.2 6,923 1

Bitmap Index Scan on ubpr_entry_20111_metric_id_period_value_idx (cost=0.00..91.45 rows=5,829 width=0) (actual time=1.339..1.339 rows=6,923 loops=1)

  • Index Cond: (metric_id = 682)
83. 9.518 10.710 ↓ 1.2 6,876 1

Bitmap Heap Scan on ubpr_entry_20112 re_40 (cost=96.79..6,379.33 rows=5,904 width=11) (actual time=2.215..10.710 rows=6,876 loops=1)

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

Bitmap Index Scan on ubpr_entry_20112_metric_id_period_value_idx (cost=0.00..95.31 rows=5,904 width=0) (actual time=1.191..1.192 rows=6,876 loops=1)

  • Index Cond: (metric_id = 682)
85. 9.509 10.732 ↓ 1.2 6,820 1

Bitmap Heap Scan on ubpr_entry_20113 re_41 (cost=93.96..6,144.86 rows=5,680 width=11) (actual time=2.237..10.732 rows=6,820 loops=1)

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

Bitmap Index Scan on ubpr_entry_20113_metric_id_period_value_idx (cost=0.00..92.54 rows=5,680 width=0) (actual time=1.223..1.223 rows=6,820 loops=1)

  • Index Cond: (metric_id = 682)
87. 9.652 11.008 ↓ 1.2 6,789 1

Bitmap Heap Scan on ubpr_entry_20114 re_42 (cost=89.86..5,890.61 rows=5,435 width=11) (actual time=2.373..11.008 rows=6,789 loops=1)

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

Bitmap Index Scan on ubpr_entry_20114_metric_id_period_value_idx (cost=0.00..88.50 rows=5,435 width=0) (actual time=1.355..1.356 rows=6,789 loops=1)

  • Index Cond: (metric_id = 682)
89. 10.773 12.671 ↓ 1.2 7,377 1

Bitmap Heap Scan on ubpr_entry_20121 re_43 (cost=99.08..6,688.97 rows=6,200 width=11) (actual time=3.124..12.671 rows=7,377 loops=1)

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

Bitmap Index Scan on ubpr_entry_20121_metric_id_period_value_idx (cost=0.00..97.53 rows=6,200 width=0) (actual time=1.897..1.898 rows=7,377 loops=1)

  • Index Cond: (metric_id = 682)
91. 10.550 12.089 ↓ 1.2 7,314 1

Bitmap Heap Scan on ubpr_entry_20122 re_44 (cost=101.80..6,623.56 rows=6,124 width=11) (actual time=2.766..12.089 rows=7,314 loops=1)

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

Bitmap Index Scan on ubpr_entry_20122_metric_id_period_value_idx (cost=0.00..100.27 rows=6,124 width=0) (actual time=1.538..1.539 rows=7,314 loops=1)

  • Index Cond: (metric_id = 682)
93. 10.167 11.712 ↓ 1.2 7,249 1

Bitmap Heap Scan on ubpr_entry_20123 re_45 (cost=101.87..6,631.74 rows=6,133 width=11) (actual time=2.731..11.712 rows=7,249 loops=1)

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

Bitmap Index Scan on ubpr_entry_20123_metric_id_period_value_idx (cost=0.00..100.33 rows=6,133 width=0) (actual time=1.545..1.545 rows=7,249 loops=1)

  • Index Cond: (metric_id = 682)
95. 10.078 11.860 ↓ 1.2 7,150 1

Bitmap Heap Scan on ubpr_entry_20124 re_46 (cost=94.66..6,251.78 rows=5,771 width=11) (actual time=2.983..11.860 rows=7,150 loops=1)

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

Bitmap Index Scan on ubpr_entry_20124_metric_id_period_value_idx (cost=0.00..93.22 rows=5,771 width=0) (actual time=1.781..1.782 rows=7,150 loops=1)

  • Index Cond: (metric_id = 682)
97. 9.921 10.851 ↓ 1.2 7,085 1

Bitmap Heap Scan on ubpr_entry_20131 re_47 (cost=97.02..6,549.50 rows=6,075 width=11) (actual time=1.985..10.851 rows=7,085 loops=1)

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

Bitmap Index Scan on ubpr_entry_20131_metric_id_period_value_idx (cost=0.00..95.50 rows=6,075 width=0) (actual time=0.930..0.930 rows=7,085 loops=1)

  • Index Cond: (metric_id = 682)
99. 9.797 11.523 ↓ 1.2 7,005 1

Bitmap Heap Scan on ubpr_entry_20132 re_48 (cost=97.90..6,385.85 rows=5,905 width=11) (actual time=2.878..11.523 rows=7,005 loops=1)

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

Bitmap Index Scan on ubpr_entry_20132_metric_id_period_value_idx (cost=0.00..96.42 rows=5,905 width=0) (actual time=1.726..1.726 rows=7,005 loops=1)

  • Index Cond: (metric_id = 682)
101. 9.725 11.262 ↓ 1.2 6,955 1

Bitmap Heap Scan on ubpr_entry_20133 re_49 (cost=98.04..6,402.86 rows=5,923 width=11) (actual time=2.667..11.262 rows=6,955 loops=1)

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

Bitmap Index Scan on ubpr_entry_20133_metric_id_period_value_idx (cost=0.00..96.56 rows=5,923 width=0) (actual time=1.536..1.537 rows=6,955 loops=1)

  • Index Cond: (metric_id = 682)
103. 9.561 10.428 ↓ 1.2 6,877 1

Bitmap Heap Scan on ubpr_entry_20134 re_50 (cost=91.51..5,968.60 rows=5,507 width=11) (actual time=1.889..10.428 rows=6,877 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,877
104. 0.867 0.867 ↓ 1.2 6,877 1

Bitmap Index Scan on ubpr_entry_20134_metric_id_period_value_idx (cost=0.00..90.14 rows=5,507 width=0) (actual time=0.866..0.867 rows=6,877 loops=1)

  • Index Cond: (metric_id = 682)
105. 9.522 11.237 ↑ 1.4 6,794 1

Bitmap Heap Scan on ubpr_entry_20141 re_51 (cost=154.86..10,232.80 rows=9,706 width=11) (actual time=2.818..11.237 rows=6,794 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=6,794
106. 1.715 1.715 ↑ 1.4 6,794 1

Bitmap Index Scan on ubpr_entry_20141_metric_id_period_value_idx (cost=0.00..152.43 rows=9,706 width=0) (actual time=1.715..1.715 rows=6,794 loops=1)

  • Index Cond: (metric_id = 682)
107. 9.482 10.554 ↓ 1.2 6,722 1

Bitmap Heap Scan on ubpr_entry_20142 re_52 (cost=94.29..6,186.43 rows=5,723 width=11) (actual time=2.072..10.554 rows=6,722 loops=1)

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

Bitmap Index Scan on ubpr_entry_20142_metric_id_period_value_idx (cost=0.00..92.86 rows=5,723 width=0) (actual time=1.072..1.072 rows=6,722 loops=1)

  • Index Cond: (metric_id = 682)
109. 9.366 10.439 ↓ 1.2 6,651 1

Bitmap Heap Scan on ubpr_entry_20143 re_53 (cost=93.58..6,088.99 rows=5,631 width=11) (actual time=2.065..10.439 rows=6,651 loops=1)

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

Bitmap Index Scan on ubpr_entry_20143_metric_id_period_value_idx (cost=0.00..92.17 rows=5,631 width=0) (actual time=1.072..1.073 rows=6,651 loops=1)

  • Index Cond: (metric_id = 682)
111. 9.141 10.220 ↓ 1.2 6,570 1

Bitmap Heap Scan on ubpr_entry_20144 re_54 (cost=87.48..5,711.29 rows=5,270 width=11) (actual time=2.059..10.220 rows=6,570 loops=1)

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

Bitmap Index Scan on ubpr_entry_20144_metric_id_period_value_idx (cost=0.00..86.16 rows=5,270 width=0) (actual time=1.079..1.079 rows=6,570 loops=1)

  • Index Cond: (metric_id = 682)
113. 9.059 10.112 ↓ 1.2 6,480 1

Bitmap Heap Scan on ubpr_entry_20151 re_55 (cost=89.00..6,052.59 rows=5,609 width=11) (actual time=2.016..10.112 rows=6,480 loops=1)

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

Bitmap Index Scan on ubpr_entry_20151_metric_id_period_value_idx (cost=0.00..87.60 rows=5,609 width=0) (actual time=1.052..1.053 rows=6,480 loops=1)

  • Index Cond: (metric_id = 682)
115. 8.958 10.015 ↓ 1.2 6,408 1

Bitmap Heap Scan on ubpr_entry_20152 re_56 (cost=90.57..5,978.92 rows=5,527 width=11) (actual time=2.018..10.015 rows=6,408 loops=1)

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

Bitmap Index Scan on ubpr_entry_20152_metric_id_period_value_idx (cost=0.00..89.19 rows=5,527 width=0) (actual time=1.057..1.057 rows=6,408 loops=1)

  • Index Cond: (metric_id = 682)
117. 8.971 10.050 ↓ 1.2 6,328 1

Bitmap Heap Scan on ubpr_entry_20153 re_57 (cost=89.97..5,898.09 rows=5,450 width=11) (actual time=2.090..10.050 rows=6,328 loops=1)

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

Bitmap Index Scan on ubpr_entry_20153_metric_id_period_value_idx (cost=0.00..88.61 rows=5,450 width=0) (actual time=1.079..1.079 rows=6,328 loops=1)

  • Index Cond: (metric_id = 682)
119. 9.049 10.111 ↓ 1.2 6,238 1

Bitmap Heap Scan on ubpr_entry_20154 re_58 (cost=83.43..5,459.22 rows=5,031 width=11) (actual time=1.994..10.111 rows=6,238 loops=1)

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

Bitmap Index Scan on ubpr_entry_20154_metric_id_period_value_idx (cost=0.00..82.17 rows=5,031 width=0) (actual time=1.062..1.062 rows=6,238 loops=1)

  • Index Cond: (metric_id = 682)
121. 8.827 9.992 ↓ 1.2 6,176 1

Bitmap Heap Scan on ubpr_entry_20161 re_59 (cost=85.39..5,708.79 rows=5,285 width=11) (actual time=2.091..9.992 rows=6,176 loops=1)

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

Bitmap Index Scan on ubpr_entry_20161_metric_id_period_value_idx (cost=0.00..84.07 rows=5,285 width=0) (actual time=1.165..1.165 rows=6,176 loops=1)

  • Index Cond: (metric_id = 682)
123. 8.868 9.925 ↓ 1.2 6,112 1

Bitmap Heap Scan on ubpr_entry_20162 re_60 (cost=87.23..5,671.00 rows=5,238 width=11) (actual time=2.033..9.925 rows=6,112 loops=1)

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

Bitmap Index Scan on ubpr_entry_20162_metric_id_period_value_idx (cost=0.00..85.92 rows=5,238 width=0) (actual time=1.056..1.057 rows=6,112 loops=1)

  • Index Cond: (metric_id = 682)
125. 8.674 9.695 ↓ 1.2 6,034 1

Bitmap Heap Scan on ubpr_entry_20163 re_61 (cost=85.36..5,563.43 rows=5,139 width=11) (actual time=1.950..9.695 rows=6,034 loops=1)

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

Bitmap Index Scan on ubpr_entry_20163_metric_id_period_value_idx (cost=0.00..84.08 rows=5,139 width=0) (actual time=1.021..1.021 rows=6,034 loops=1)

  • Index Cond: (metric_id = 682)
127. 8.464 9.506 ↑ 1.4 5,966 1

Bitmap Heap Scan on ubpr_entry_20164 re_62 (cost=135.44..8,710.47 rows=8,194 width=11) (actual time=1.941..9.506 rows=5,966 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,966
128. 1.042 1.042 ↑ 1.4 5,966 1

Bitmap Index Scan on ubpr_entry_20164_metric_id_period_value_idx (cost=0.00..133.39 rows=8,194 width=0) (actual time=1.042..1.042 rows=5,966 loops=1)

  • Index Cond: (metric_id = 682)
129. 8.397 9.465 ↓ 1.3 5,908 1

Bitmap Heap Scan on ubpr_entry_20171 re_63 (cost=74.45..4,953.98 rows=4,583 width=11) (actual time=1.959..9.465 rows=5,908 loops=1)

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

Bitmap Index Scan on ubpr_entry_20171_metric_id_period_value_idx (cost=0.00..73.31 rows=4,583 width=0) (actual time=1.068..1.068 rows=5,908 loops=1)

  • Index Cond: (metric_id = 682)
131. 8.503 9.514 ↓ 1.3 5,839 1

Bitmap Heap Scan on ubpr_entry_20172 re_64 (cost=76.57..4,952.74 rows=4,573 width=11) (actual time=1.891..9.514 rows=5,839 loops=1)

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

Bitmap Index Scan on ubpr_entry_20172_metric_id_period_value_idx (cost=0.00..75.43 rows=4,573 width=0) (actual time=1.011..1.011 rows=5,839 loops=1)

  • Index Cond: (metric_id = 682)
133. 8.493 9.544 ↓ 1.3 5,789 1

Bitmap Heap Scan on ubpr_entry_20173 re_65 (cost=76.26..4,912.65 rows=4,533 width=11) (actual time=1.944..9.544 rows=5,789 loops=1)

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

Bitmap Index Scan on ubpr_entry_20173_metric_id_period_value_idx (cost=0.00..75.13 rows=4,533 width=0) (actual time=1.051..1.051 rows=5,789 loops=1)

  • Index Cond: (metric_id = 682)
135. 8.644 9.665 ↓ 1.3 5,721 1

Bitmap Heap Scan on ubpr_entry_20174 re_66 (cost=73.52..4,693.51 rows=4,321 width=11) (actual time=1.873..9.665 rows=5,721 loops=1)

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

Bitmap Index Scan on ubpr_entry_20174_metric_id_period_value_idx (cost=0.00..72.44 rows=4,321 width=0) (actual time=1.021..1.021 rows=5,721 loops=1)

  • Index Cond: (metric_id = 682)
137. 8.337 9.550 ↓ 1.3 5,657 1

Bitmap Heap Scan on ubpr_entry_20181 re_67 (cost=94.89..4,792.73 rows=4,366 width=11) (actual time=2.068..9.550 rows=5,657 loops=1)

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

Bitmap Index Scan on ubpr_entry_20181_metric_id_period_value_idx (cost=0.00..93.80 rows=4,366 width=0) (actual time=1.212..1.213 rows=5,657 loops=1)

  • Index Cond: (metric_id = 682)
139. 7.893 8.903 ↓ 1.3 5,593 1

Bitmap Heap Scan on ubpr_entry_20182 re_68 (cost=88.25..4,762.07 rows=4,360 width=11) (actual time=1.838..8.903 rows=5,593 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,593
140. 1.010 1.010 ↓ 1.3 5,593 1

Bitmap Index Scan on ubpr_entry_20182_metric_id_period_value_idx (cost=0.00..87.16 rows=4,360 width=0) (actual time=1.010..1.010 rows=5,593 loops=1)

  • Index Cond: (metric_id = 682)
141. 7.061 7.061 ↓ 1.3 5,527 1

Index Scan using ubpr_entry_20183_metric_id_period_value_idx on ubpr_entry_20183 re_69 (cost=0.56..4,880.17 rows=4,409 width=11) (actual time=0.030..7.061 rows=5,527 loops=1)

  • Index Cond: (metric_id = 682)
142. 7.920 9.059 ↓ 1.3 5,456 1

Bitmap Heap Scan on ubpr_entry_20184 re_70 (cost=86.59..4,538.88 rows=4,146 width=11) (actual time=1.955..9.059 rows=5,456 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,454
143. 1.139 1.139 ↓ 1.3 5,456 1

Bitmap Index Scan on ubpr_entry_20184_metric_id_period_value_idx (cost=0.00..85.55 rows=4,146 width=0) (actual time=1.139..1.139 rows=5,456 loops=1)

  • Index Cond: (metric_id = 682)
144. 8.216 9.293 ↓ 1.3 5,411 1

Bitmap Heap Scan on ubpr_entry_20191 re_71 (cost=95.13..4,674.29 rows=4,254 width=11) (actual time=1.910..9.293 rows=5,411 loops=1)

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

Bitmap Index Scan on ubpr_entry_20191_metric_id_period_value_idx (cost=0.00..94.06 rows=4,254 width=0) (actual time=1.077..1.077 rows=5,411 loops=1)

  • Index Cond: (metric_id = 682)
146. 8.040 9.094 ↓ 1.3 5,352 1

Bitmap Heap Scan on ubpr_entry_20192 re_72 (cost=77.25..4,619.60 rows=4,235 width=11) (actual time=1.875..9.094 rows=5,352 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,349
147. 1.054 1.054 ↓ 1.3 5,352 1

Bitmap Index Scan on ubpr_entry_20192_metric_id_period_value_idx (cost=0.00..76.20 rows=4,235 width=0) (actual time=1.053..1.054 rows=5,352 loops=1)

  • Index Cond: (metric_id = 682)
148. 8.028 8.987 ↓ 1.3 5,308 1

Bitmap Heap Scan on ubpr_entry_20193 re_73 (cost=85.18..4,479.28 rows=4,106 width=11) (actual time=1.738..8.987 rows=5,308 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,250
149. 0.959 0.959 ↓ 1.3 5,308 1

Bitmap Index Scan on ubpr_entry_20193_metric_id_period_value_idx (cost=0.00..84.15 rows=4,106 width=0) (actual time=0.958..0.959 rows=5,308 loops=1)

  • Index Cond: (metric_id = 682)
150. 7.897 8.884 ↓ 1.3 5,227 1

Bitmap Heap Scan on ubpr_entry_20194 re_74 (cost=89.51..4,344.13 rows=3,955 width=11) (actual time=1.772..8.884 rows=5,227 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=5,225
151. 0.987 0.987 ↓ 1.3 5,227 1

Bitmap Index Scan on ubpr_entry_20194_metric_id_period_value_idx (cost=0.00..88.52 rows=3,955 width=0) (actual time=0.987..0.987 rows=5,227 loops=1)

  • Index Cond: (metric_id = 682)
152. 7.549 8.589 ↓ 1.3 4,717 1

Bitmap Heap Scan on ubpr_entry_20201 re_75 (cost=80.46..3,846.05 rows=3,497 width=11) (actual time=1.746..8.589 rows=4,717 loops=1)

  • Recheck Cond: (metric_id = 682)
  • Heap Blocks: exact=4,717
153. 1.040 1.040 ↓ 1.3 4,717 1

Bitmap Index Scan on ubpr_entry_20201_metric_id_period_value_idx (cost=0.00..79.59 rows=3,497 width=0) (actual time=1.040..1.040 rows=4,717 loops=1)

  • Index Cond: (metric_id = 682)
154. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
155. 0.006 0.006 ↓ 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.005..0.006 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
156. 0.000 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
157. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
158. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
159. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
160. 0.001 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
161. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
162. 0.000 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.003 0.003 ↓ 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.003 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
164. 0.001 0.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
165. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
166. 0.001 0.003 ↓ 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.002..0.003 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
167. 0.002 0.002 ↓ 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.002..0.002 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.002..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.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
171. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
172. 0.000 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
173. 0.002 0.002 ↓ 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.002..0.002 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.002 0.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
177. 0.002 0.002 ↓ 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.002 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
178. 0.000 0.003 ↓ 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.003..0.003 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.002..0.003 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
180. 0.000 0.002 ↓ 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.002..0.002 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.000 0.002 ↓ 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.002..0.002 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.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
185. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
186. 0.000 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
187. 0.003 0.003 ↓ 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.003 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
188. 0.000 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Recheck Cond: (metric_id = 682)
189. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
190. 0.000 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.005 0.005 ↓ 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.004..0.005 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
192. 0.001 0.003 ↓ 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.003 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.001 0.003 ↓ 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.002..0.003 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.000 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.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
198. 0.000 0.002 ↓ 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.002..0.002 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.002..0.003 rows=0 loops=1)

  • Index Cond: (metric_id = 682)
200. 0.775 7.930 ↓ 1.1 4,812 1

Hash (cost=2,922.95..2,922.95 rows=4,505 width=6) (actual time=7.930..7.930 rows=4,812 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 243kB
201. 1.975 7.155 ↓ 1.1 4,812 1

HashAggregate (cost=2,832.85..2,877.90 rows=4,505 width=6) (actual time=6.347..7.155 rows=4,812 loops=1)

  • Group Key: bpg.bank_id, bpg.period
202. 0.219 5.180 ↓ 1.1 4,869 1

Append (cost=49.18..2,810.32 rows=4,505 width=6) (actual time=0.799..5.180 rows=4,869 loops=1)

203. 4.341 4.809 ↓ 1.1 4,742 1

Bitmap Heap Scan on bank_in_peer_group bpg (cost=49.18..2,675.31 rows=4,446 width=6) (actual time=0.799..4.809 rows=4,742 loops=1)

  • Recheck Cond: (peer_group_id = 2)
  • Heap Blocks: exact=2,322
204. 0.468 0.468 ↓ 1.1 4,742 1

Bitmap Index Scan on bank_in_peer_group_pgid_period_ix (cost=0.00..48.07 rows=4,446 width=0) (actual time=0.468..0.468 rows=4,742 loops=1)

  • Index Cond: (peer_group_id = 2)
205. 0.152 0.152 ↓ 2.2 127 1

Index Only Scan using bank_in_peer_group_pkey on bank_in_peer_group bpg_1 (cost=0.42..67.44 rows=59 width=6) (actual time=0.025..0.152 rows=127 loops=1)

  • Index Cond: (bank_id = 42,420)
  • Heap Fetches: 127
Planning time : 24.757 ms
Execution time : 904.093 ms