explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UsLK

Settings
# exclusive inclusive rows x rows loops node
1. 59.620 908.313 ↑ 7.5 31,654 1

Sort (cost=314,582.03..315,176.79 rows=237,906 width=98) (actual time=904.320..908.313 rows=31,654 loops=1)

  • Sort Key: ba.id NULLS FIRST, (COALESCE(ba.apply_date, l.created_date)), l.id
  • Sort Method: external sort Disk: 2968kB
2. 25.564 848.693 ↑ 7.5 31,654 1

GroupAggregate (cost=276,942.15..284,971.48 rows=237,906 width=98) (actual time=818.504..848.693 rows=31,654 loops=1)

  • Group Key: (date_trunc('month'::text, COALESCE(ba.apply_date, l.created_date))), l.id, ba.id, (COALESCE(ba.apply_date, l.created_date)), (COALESCE(ba.note, bo.description)), l.object_id, (abs(l.unit_count))
  • Group Key: (date_trunc('month'::text, COALESCE(ba.apply_date, l.created_date)))
3. 46.268 823.129 ↑ 3.8 31,653 1

Sort (cost=276,942.15..277,239.54 rows=118,953 width=86) (actual time=818.489..823.129 rows=31,653 loops=1)

  • Sort Key: (date_trunc('month'::text, COALESCE(ba.apply_date, l.created_date))), l.id, ba.id, (COALESCE(ba.apply_date, l.created_date)), (COALESCE(ba.note, bo.description)), l.object_id, (abs(l.unit_count))
  • Sort Method: external sort Disk: 2904kB
4. 12.972 776.861 ↑ 3.8 31,653 1

Hash Left Join (cost=271.35..263,253.65 rows=118,953 width=86) (actual time=727.514..776.861 rows=31,653 loops=1)

  • Hash Cond: (l.operation_id = bo.id)
5. 6.335 763.875 ↑ 3.8 31,653 1

Hash Left Join (cost=269.90..261,023.10 rows=118,953 width=81) (actual time=727.482..763.875 rows=31,653 loops=1)

  • Hash Cond: (ba.category_id = bac.id)
  • Filter: (((l.operation_id IS NULL) AND (l.balance_adjustment_id IS NOT NULL) AND (bac.id IS NOT NULL)) OR ((l.operation_id IS NOT NULL) AND (l.balance_adjustment_id IS NULL)))
6. 116.992 757.530 ↑ 3.8 31,653 1

Hash Left Join (cost=268.79..259,780.25 rows=119,207 width=93) (actual time=727.452..757.530 rows=31,653 loops=1)

  • Hash Cond: (l.balance_adjustment_id = ba.id)
  • Filter: ((COALESCE(ba.apply_date, l.created_date) >= '2020-04-01 00:00:00'::timestamp without time zone) AND (COALESCE(ba.apply_date, l.created_date) < '2020-05-01 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1037990
7. 63.055 638.502 ↑ 1.0 1,069,643 1

Append (cost=0.00..255,471.08 rows=1,072,859 width=50) (actual time=0.039..638.502 rows=1,069,643 loops=1)

8. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on balance_log l (cost=0.00..0.00 rows=1 width=68) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
9. 0.028 0.028 ↑ 1.0 3 1

Seq Scan on balance_log_201312 l_1 (cost=0.00..2.49 rows=3 width=49) (actual time=0.024..0.028 rows=3 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 36
10. 0.008 0.008 ↓ 0.0 0 1

Index Scan using balance_log_201401_registrar_name_idx on balance_log_201401 l_2 (cost=0.14..3.16 rows=1 width=49) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
11. 0.002 0.011 ↓ 0.0 0 1

Bitmap Heap Scan on balance_log_201402 l_3 (cost=1.88..20.21 rows=13 width=49) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
12. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on balance_log_201402_registrar_name_idx (cost=0.00..1.88 rows=13 width=0) (actual time=0.008..0.009 rows=0 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
13. 0.141 0.174 ↑ 1.0 117 1

Bitmap Heap Scan on balance_log_201403 l_4 (cost=2.69..119.20 rows=117 width=50) (actual time=0.043..0.174 rows=117 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=51
14. 0.033 0.033 ↑ 1.0 117 1

Bitmap Index Scan on balance_log_201403_registrar_name_idx (cost=0.00..2.66 rows=117 width=0) (actual time=0.033..0.033 rows=117 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
15. 18.110 18.110 ↓ 1.0 39,087 1

Seq Scan on balance_log_201404 l_5 (cost=0.00..3,857.69 rows=39,068 width=49) (actual time=0.013..18.110 rows=39,087 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 11528
16. 0.398 0.507 ↑ 1.0 492 1

Bitmap Heap Scan on balance_log_201406 l_6 (cost=13.09..282.84 rows=492 width=50) (actual time=0.125..0.507 rows=492 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=98
17. 0.109 0.109 ↑ 1.0 492 1

Bitmap Index Scan on balance_log_201406_registrar_name_idx (cost=0.00..12.97 rows=492 width=0) (actual time=0.109..0.109 rows=492 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
18. 4.684 4.684 ↑ 1.0 7,035 1

Seq Scan on balance_log_201405 l_7 (cost=0.00..1,012.77 rows=7,035 width=51) (actual time=0.025..4.684 rows=7,035 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 5107
19. 0.494 0.572 ↑ 1.0 499 1

Bitmap Heap Scan on balance_log_201407 l_8 (cost=13.15..342.20 rows=499 width=51) (actual time=0.096..0.572 rows=499 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=113
20. 0.078 0.078 ↑ 1.0 499 1

Bitmap Index Scan on balance_log_201407_registrar_name_idx (cost=0.00..13.03 rows=499 width=0) (actual time=0.078..0.078 rows=499 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
21. 0.305 0.351 ↑ 1.0 314 1

Bitmap Heap Scan on balance_log_201408 l_9 (cost=8.72..237.17 rows=314 width=50) (actual time=0.056..0.351 rows=314 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=81
22. 0.046 0.046 ↑ 1.0 314 1

Bitmap Index Scan on balance_log_201408_registrar_name_idx (cost=0.00..8.64 rows=314 width=0) (actual time=0.046..0.046 rows=314 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
23. 17.029 17.029 ↑ 1.0 43,968 1

Seq Scan on balance_log_201409 l_10 (cost=0.00..2,546.65 rows=43,988 width=50) (actual time=0.019..17.029 rows=43,968 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 7524
24. 0.268 0.331 ↑ 1.0 404 1

Bitmap Heap Scan on balance_log_201410 l_11 (cost=10.92..404.82 rows=404 width=52) (actual time=0.075..0.331 rows=404 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=101
25. 0.063 0.063 ↑ 1.0 404 1

Bitmap Index Scan on balance_log_201410_registrar_name_idx (cost=0.00..10.81 rows=404 width=0) (actual time=0.063..0.063 rows=404 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
26. 1.108 1.311 ↑ 1.0 2,143 1

Bitmap Heap Scan on balance_log_201411 l_12 (cost=58.90..1,604.24 rows=2,143 width=51) (actual time=0.241..1.311 rows=2,143 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=323
27. 0.203 0.203 ↑ 1.0 2,143 1

Bitmap Index Scan on balance_log_201411_registrar_name_idx (cost=0.00..58.36 rows=2,143 width=0) (actual time=0.203..0.203 rows=2,143 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
28. 0.941 1.094 ↑ 1.0 1,325 1

Bitmap Heap Scan on balance_log_201412 l_13 (cost=30.05..961.67 rows=1,325 width=52) (actual time=0.191..1.094 rows=1,325 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=333
29. 0.153 0.153 ↑ 1.0 1,325 1

Bitmap Index Scan on balance_log_201412_registrar_name_idx (cost=0.00..29.72 rows=1,325 width=0) (actual time=0.153..0.153 rows=1,325 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
30. 28.780 28.780 ↑ 1.0 77,502 1

Seq Scan on balance_log_201501 l_14 (cost=0.00..4,646.79 rows=77,643 width=50) (actual time=0.025..28.780 rows=77,502 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 14641
31. 0.941 1.125 ↑ 1.0 1,853 1

Bitmap Heap Scan on balance_log_201502 l_15 (cost=46.15..1,228.88 rows=1,853 width=51) (actual time=0.217..1.125 rows=1,853 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=291
32. 0.184 0.184 ↑ 1.0 1,853 1

Bitmap Index Scan on balance_log_201502_registrar_name_idx (cost=0.00..45.69 rows=1,853 width=0) (actual time=0.184..0.184 rows=1,853 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
33. 9.279 9.279 ↑ 1.0 24,909 1

Index Scan using balance_log_201503_registrar_name_idx on balance_log_201503 l_16 (cost=0.41..3,966.77 rows=24,909 width=49) (actual time=0.021..9.279 rows=24,909 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
34. 21.556 26.729 ↓ 1.0 70,291 1

Bitmap Heap Scan on balance_log_201504 l_17 (cost=893.76..7,000.92 rows=70,173 width=54) (actual time=5.571..26.729 rows=70,291 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=2927
35. 5.173 5.173 ↓ 1.0 70,291 1

Bitmap Index Scan on balance_log_201504_registrar_name_idx (cost=0.00..876.22 rows=70,173 width=0) (actual time=5.173..5.173 rows=70,291 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
36. 1.062 1.235 ↓ 1.0 1,527 1

Bitmap Heap Scan on balance_log_201505 l_18 (cost=39.11..1,336.49 rows=1,525 width=52) (actual time=0.220..1.235 rows=1,527 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=408
37. 0.173 0.173 ↓ 1.0 1,527 1

Bitmap Index Scan on balance_log_201505_registrar_name_idx (cost=0.00..38.73 rows=1,525 width=0) (actual time=0.172..0.173 rows=1,527 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
38. 25.230 25.230 ↑ 1.0 46,224 1

Seq Scan on balance_log_201506 l_19 (cost=0.00..6,521.12 rows=46,439 width=50) (actual time=0.013..25.230 rows=46,224 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 34906
39. 29.186 29.186 ↓ 1.0 52,003 1

Seq Scan on balance_log_201507 l_20 (cost=0.00..7,650.32 rows=51,881 width=50) (actual time=0.008..29.186 rows=52,003 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 37303
40. 21.642 21.642 ↑ 1.0 25,388 1

Seq Scan on balance_log_201508 l_21 (cost=0.00..5,701.80 rows=25,728 width=48) (actual time=0.012..21.642 rows=25,388 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 42676
41. 5.627 6.930 ↑ 1.0 14,195 1

Bitmap Heap Scan on balance_log_201509 l_22 (cost=355.67..3,863.31 rows=14,291 width=52) (actual time=1.458..6.930 rows=14,195 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1242
42. 1.303 1.303 ↑ 1.0 14,195 1

Bitmap Index Scan on balance_log_201509_registrar_name_idx (cost=0.00..352.10 rows=14,291 width=0) (actual time=1.303..1.303 rows=14,195 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
43. 0.791 0.937 ↓ 1.0 1,186 1

Bitmap Heap Scan on balance_log_201510 l_23 (cost=28.94..1,169.76 rows=1,181 width=51) (actual time=0.182..0.937 rows=1,186 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=309
44. 0.146 0.146 ↓ 1.0 1,186 1

Bitmap Index Scan on balance_log_201510_registrar_name_idx (cost=0.00..28.65 rows=1,181 width=0) (actual time=0.146..0.146 rows=1,186 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
45. 1.883 2.238 ↑ 1.0 3,523 1

Bitmap Heap Scan on balance_log_201511 l_24 (cost=94.15..3,465.29 rows=3,578 width=51) (actual time=0.440..2.238 rows=3,523 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=714
46. 0.355 0.355 ↑ 1.0 3,523 1

Bitmap Index Scan on balance_log_201511_registrar_name_idx (cost=0.00..93.25 rows=3,578 width=0) (actual time=0.355..0.355 rows=3,523 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
47. 2.309 2.665 ↓ 1.0 3,869 1

Bitmap Heap Scan on balance_log_201512 l_25 (cost=88.55..3,924.54 rows=3,823 width=51) (actual time=0.458..2.665 rows=3,869 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=916
48. 0.356 0.356 ↓ 1.0 3,869 1

Bitmap Index Scan on balance_log_201512_registrar_name_idx (cost=0.00..87.59 rows=3,823 width=0) (actual time=0.356..0.356 rows=3,869 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
49. 58.965 58.965 ↑ 1.0 79,091 1

Seq Scan on balance_log_201601 l_26 (cost=0.00..18,424.51 rows=79,101 width=49) (actual time=0.008..58.965 rows=79,091 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 149590
50. 7.839 9.685 ↑ 1.0 25,084 1

Bitmap Heap Scan on balance_log_201602 l_27 (cost=728.82..9,956.37 rows=25,084 width=49) (actual time=2.034..9.685 rows=25,084 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1588
51. 1.846 1.846 ↑ 1.0 25,084 1

Bitmap Index Scan on balance_log_201602_registrar_name_idx (cost=0.00..722.55 rows=25,084 width=0) (actual time=1.846..1.846 rows=25,084 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
52. 18.487 23.188 ↓ 1.0 64,637 1

Bitmap Heap Scan on balance_log_201603 l_28 (cost=1,957.88..21,260.78 rows=63,672 width=49) (actual time=5.119..23.188 rows=64,637 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=3184
53. 4.701 4.701 ↓ 1.0 64,637 1

Bitmap Index Scan on balance_log_201603_registrar_name_idx (cost=0.00..1,941.96 rows=63,672 width=0) (actual time=4.700..4.701 rows=64,637 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
54. 5.182 6.004 ↓ 1.0 9,437 1

Bitmap Heap Scan on balance_log_201604 l_29 (cost=241.54..6,610.06 rows=9,242 width=57) (actual time=0.968..6.004 rows=9,437 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1247
55. 0.822 0.822 ↓ 1.0 9,437 1

Bitmap Index Scan on balance_log_201604_registrar_name_idx (cost=0.00..239.23 rows=9,242 width=0) (actual time=0.822..0.822 rows=9,437 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
56. 4.532 5.189 ↑ 1.0 7,109 1

Bitmap Heap Scan on balance_log_201605 l_30 (cost=190.99..6,555.55 rows=7,170 width=54) (actual time=0.801..5.189 rows=7,109 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1217
57. 0.657 0.657 ↑ 1.0 7,109 1

Bitmap Index Scan on balance_log_201605_registrar_name_idx (cost=0.00..189.19 rows=7,170 width=0) (actual time=0.657..0.657 rows=7,109 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
58. 9.296 10.898 ↑ 1.0 19,240 1

Bitmap Heap Scan on balance_log_201606 l_31 (cost=502.84..6,808.65 rows=19,345 width=51) (actual time=1.829..10.898 rows=19,240 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1886
59. 1.602 1.602 ↑ 1.0 19,240 1

Bitmap Index Scan on balance_log_201606_registrar_name_idx (cost=0.00..498.00 rows=19,345 width=0) (actual time=1.602..1.602 rows=19,240 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
60. 53.819 53.819 ↓ 1.0 91,048 1

Seq Scan on balance_log_201607 l_32 (cost=0.00..12,647.48 rows=90,925 width=49) (actual time=0.010..53.819 rows=91,048 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 68910
61. 28.943 28.943 ↓ 1.0 26,630 1

Seq Scan on balance_log_201608 l_33 (cost=0.00..7,186.64 rows=26,364 width=50) (actual time=0.012..28.943 rows=26,630 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 73021
62. 27.739 27.739 ↓ 1.0 40,211 1

Seq Scan on balance_log_201609 l_34 (cost=0.00..6,143.61 rows=39,648 width=49) (actual time=0.124..27.739 rows=40,211 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 77438
63. 2.141 2.591 ↑ 1.0 4,575 1

Bitmap Heap Scan on balance_log_201610 l_35 (cost=72.11..2,726.22 rows=4,622 width=51) (actual time=0.533..2.591 rows=4,575 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=651
64. 0.450 0.450 ↑ 1.0 4,575 1

Bitmap Index Scan on balance_log_201610_registrar_name_idx (cost=0.00..70.96 rows=4,622 width=0) (actual time=0.450..0.450 rows=4,575 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
65. 2.189 2.611 ↓ 1.0 4,091 1

Bitmap Heap Scan on balance_log_201611 l_36 (cost=58.36..2,572.36 rows=4,009 width=51) (actual time=0.517..2.611 rows=4,091 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=759
66. 0.422 0.422 ↓ 1.0 4,091 1

Bitmap Index Scan on balance_log_201611_registrar_name_idx (cost=0.00..57.36 rows=4,009 width=0) (actual time=0.422..0.422 rows=4,091 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
67. 2.763 3.313 ↓ 1.0 5,695 1

Bitmap Heap Scan on balance_log_201612 l_37 (cost=80.35..2,836.41 rows=5,685 width=51) (actual time=0.660..3.313 rows=5,695 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=885
68. 0.550 0.550 ↓ 1.0 5,695 1

Bitmap Index Scan on balance_log_201612_registrar_name_idx (cost=0.00..78.93 rows=5,685 width=0) (actual time=0.550..0.550 rows=5,695 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
69. 7.545 9.431 ↑ 1.0 21,312 1

Bitmap Heap Scan on balance_log_201701 l_38 (cost=306.63..9,453.95 rows=21,705 width=48) (actual time=2.130..9.431 rows=21,312 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1858
70. 1.886 1.886 ↑ 1.0 21,312 1

Bitmap Index Scan on balance_log_201701_registrar_name_idx (cost=0.00..301.21 rows=21,705 width=0) (actual time=1.886..1.886 rows=21,312 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
71. 7.393 9.110 ↑ 1.0 19,988 1

Bitmap Heap Scan on balance_log_201702 l_39 (cost=298.09..11,702.37 rows=20,602 width=49) (actual time=1.971..9.110 rows=19,988 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1955
72. 1.717 1.717 ↑ 1.0 19,988 1

Bitmap Index Scan on balance_log_201702_registrar_name_idx (cost=0.00..292.94 rows=20,602 width=0) (actual time=1.717..1.717 rows=19,988 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
73. 7.504 9.554 ↓ 1.0 23,914 1

Bitmap Heap Scan on balance_log_201703 l_40 (cost=326.53..15,318.50 rows=22,917 width=48) (actual time=2.236..9.554 rows=23,914 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1443
74. 2.050 2.050 ↓ 1.0 23,914 1

Bitmap Index Scan on balance_log_201703_registrar_name_idx (cost=0.00..320.80 rows=22,917 width=0) (actual time=2.049..2.050 rows=23,914 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
75. 3.510 3.510 ↓ 1.0 4,750 1

Index Scan using balance_log_201704_registrar_name_idx on balance_log_201704 l_41 (cost=0.42..4,362.04 rows=4,625 width=49) (actual time=0.019..3.510 rows=4,750 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
76. 7.159 8.843 ↓ 1.0 17,477 1

Bitmap Heap Scan on balance_log_201705 l_42 (cost=236.63..6,193.11 rows=17,318 width=50) (actual time=1.932..8.843 rows=17,477 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1868
77. 1.684 1.684 ↓ 1.0 17,477 1

Bitmap Index Scan on balance_log_201705_registrar_name_idx (cost=0.00..232.30 rows=17,318 width=0) (actual time=1.683..1.684 rows=17,477 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
78. 3.736 4.620 ↑ 1.0 8,589 1

Bitmap Heap Scan on balance_log_201706 l_43 (cost=119.58..4,375.31 rows=8,618 width=50) (actual time=1.021..4.620 rows=8,589 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=986
79. 0.884 0.884 ↑ 1.0 8,589 1

Bitmap Index Scan on balance_log_201706_registrar_name_idx (cost=0.00..117.43 rows=8,618 width=0) (actual time=0.884..0.884 rows=8,589 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
80. 6.275 7.897 ↓ 1.0 19,205 1

Bitmap Heap Scan on balance_log_201707 l_44 (cost=285.27..3,753.76 rows=19,159 width=51) (actual time=1.742..7.897 rows=19,205 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=972
81. 1.622 1.622 ↓ 1.0 19,205 1

Bitmap Index Scan on balance_log_201707_registrar_name_idx (cost=0.00..280.49 rows=19,159 width=0) (actual time=1.622..1.622 rows=19,205 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
82. 2.091 2.507 ↓ 1.0 3,624 1

Bitmap Heap Scan on balance_log_201708 l_45 (cost=109.39..1,435.52 rows=3,610 width=51) (actual time=0.503..2.507 rows=3,624 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=716
83. 0.416 0.416 ↓ 1.0 3,624 1

Bitmap Index Scan on balance_log_201708_registrar_name_idx (cost=0.00..108.49 rows=3,610 width=0) (actual time=0.416..0.416 rows=3,624 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
84. 8.084 8.084 ↑ 1.0 13,667 1

Seq Scan on balance_log_201709 l_46 (cost=0.00..1,723.01 rows=13,685 width=50) (actual time=0.012..8.084 rows=13,667 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 18174
85. 1.640 1.975 ↑ 1.0 3,464 1

Bitmap Heap Scan on balance_log_201710 l_47 (cost=49.63..1,366.93 rows=3,464 width=51) (actual time=0.392..1.975 rows=3,464 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=473
86. 0.335 0.335 ↑ 1.0 3,464 1

Bitmap Index Scan on balance_log_201710_registrar_name_idx (cost=0.00..48.77 rows=3,464 width=0) (actual time=0.335..0.335 rows=3,464 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
87. 2.693 3.230 ↑ 1.0 5,977 1

Bitmap Heap Scan on balance_log_201711 l_48 (cost=83.06..3,379.22 rows=6,035 width=50) (actual time=0.605..3.230 rows=5,977 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=542
88. 0.537 0.537 ↑ 1.0 5,977 1

Bitmap Index Scan on balance_log_201711_registrar_name_idx (cost=0.00..81.55 rows=6,035 width=0) (actual time=0.537..0.537 rows=5,977 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
89. 2.069 2.587 ↑ 1.0 5,931 1

Bitmap Heap Scan on balance_log_201712 l_49 (cost=85.25..1,147.39 rows=5,931 width=50) (actual time=0.569..2.587 rows=5,931 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=437
90. 0.518 0.518 ↑ 1.0 5,931 1

Bitmap Index Scan on balance_log_201712_registrar_name_idx (cost=0.00..83.77 rows=5,931 width=0) (actual time=0.518..0.518 rows=5,931 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
91. 1.407 1.628 ↑ 1.0 2,098 1

Bitmap Heap Scan on balance_log_201801 l_50 (cost=31.55..1,349.97 rows=2,098 width=51) (actual time=0.271..1.628 rows=2,098 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=416
92. 0.221 0.221 ↑ 1.0 2,098 1

Bitmap Index Scan on balance_log_201801_registrar_name_idx (cost=0.00..31.02 rows=2,098 width=0) (actual time=0.221..0.221 rows=2,098 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
93. 1.813 2.210 ↑ 1.0 4,381 1

Bitmap Heap Scan on balance_log_201802 l_51 (cost=77.74..981.50 rows=4,381 width=50) (actual time=0.446..2.210 rows=4,381 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=433
94. 0.397 0.397 ↑ 1.0 4,381 1

Bitmap Index Scan on balance_log_201802_registrar_name_idx (cost=0.00..76.64 rows=4,381 width=0) (actual time=0.397..0.397 rows=4,381 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
95. 1.160 1.331 ↑ 1.0 1,486 1

Bitmap Heap Scan on balance_log_201803 l_52 (cost=55.30..773.88 rows=1,486 width=50) (actual time=0.218..1.331 rows=1,486 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=398
96. 0.171 0.171 ↑ 1.0 1,486 1

Bitmap Index Scan on balance_log_201803_registrar_name_idx (cost=0.00..54.93 rows=1,486 width=0) (actual time=0.171..0.171 rows=1,486 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
97. 1.172 1.411 ↑ 1.0 2,345 1

Bitmap Heap Scan on balance_log_201804 l_53 (cost=102.46..678.77 rows=2,345 width=50) (actual time=0.284..1.411 rows=2,345 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=379
98. 0.239 0.239 ↑ 1.0 2,345 1

Bitmap Index Scan on balance_log_201804_registrar_name_idx (cost=0.00..101.88 rows=2,345 width=0) (actual time=0.239..0.239 rows=2,345 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
99. 1.210 1.459 ↑ 1.0 2,546 1

Bitmap Heap Scan on balance_log_201805 l_54 (cost=39.52..903.34 rows=2,546 width=50) (actual time=0.288..1.459 rows=2,546 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=328
100. 0.249 0.249 ↑ 1.0 2,546 1

Bitmap Index Scan on balance_log_201805_registrar_name_idx (cost=0.00..38.88 rows=2,546 width=0) (actual time=0.249..0.249 rows=2,546 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
101. 0.723 0.860 ↑ 1.0 1,300 1

Bitmap Heap Scan on balance_log_201806 l_55 (cost=20.86..614.11 rows=1,300 width=51) (actual time=0.167..0.860 rows=1,300 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=257
102. 0.137 0.137 ↑ 1.0 1,300 1

Bitmap Index Scan on balance_log_201806_registrar_name_idx (cost=0.00..20.54 rows=1,300 width=0) (actual time=0.137..0.137 rows=1,300 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
103. 1.355 1.668 ↑ 1.0 3,403 1

Bitmap Heap Scan on balance_log_201807 l_56 (cost=50.66..1,027.20 rows=3,403 width=52) (actual time=0.352..1.668 rows=3,403 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=331
104. 0.313 0.313 ↑ 1.0 3,403 1

Bitmap Index Scan on balance_log_201807_registrar_name_idx (cost=0.00..49.81 rows=3,403 width=0) (actual time=0.313..0.313 rows=3,403 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
105. 0.642 0.766 ↑ 1.0 1,012 1

Bitmap Heap Scan on balance_log_201808 l_57 (cost=15.63..772.42 rows=1,012 width=51) (actual time=0.154..0.766 rows=1,012 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=271
106. 0.124 0.124 ↑ 1.0 1,012 1

Bitmap Index Scan on balance_log_201808_registrar_name_idx (cost=0.00..15.38 rows=1,012 width=0) (actual time=0.124..0.124 rows=1,012 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
107. 1.347 1.686 ↑ 1.0 3,795 1

Bitmap Heap Scan on balance_log_201809 l_58 (cost=56.70..1,506.14 rows=3,795 width=50) (actual time=0.391..1.686 rows=3,795 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=308
108. 0.339 0.339 ↑ 1.0 3,795 1

Bitmap Index Scan on balance_log_201809_registrar_name_idx (cost=0.00..55.75 rows=3,795 width=0) (actual time=0.339..0.339 rows=3,795 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
109. 0.932 1.107 ↑ 1.0 1,770 1

Bitmap Heap Scan on balance_log_201810 l_59 (cost=29.00..539.13 rows=1,770 width=50) (actual time=0.206..1.107 rows=1,770 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=270
110. 0.175 0.175 ↑ 1.0 1,770 1

Bitmap Index Scan on balance_log_201810_registrar_name_idx (cost=0.00..28.56 rows=1,770 width=0) (actual time=0.175..0.175 rows=1,770 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
111. 0.763 0.872 ↑ 1.0 972 1

Bitmap Heap Scan on balance_log_201811 l_60 (cost=15.32..620.48 rows=972 width=50) (actual time=0.135..0.872 rows=972 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=239
112. 0.109 0.109 ↑ 1.0 972 1

Bitmap Index Scan on balance_log_201811_registrar_name_idx (cost=0.00..15.07 rows=972 width=0) (actual time=0.109..0.109 rows=972 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
113. 0.518 0.613 ↑ 1.0 791 1

Bitmap Heap Scan on balance_log_201812 l_61 (cost=12.42..434.48 rows=791 width=50) (actual time=0.120..0.613 rows=791 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=199
114. 0.095 0.095 ↑ 1.0 791 1

Bitmap Index Scan on balance_log_201812_registrar_name_idx (cost=0.00..12.22 rows=791 width=0) (actual time=0.095..0.095 rows=791 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
115. 0.852 0.998 ↑ 1.0 1,230 1

Bitmap Heap Scan on balance_log_201901 l_62 (cost=18.82..823.15 rows=1,230 width=51) (actual time=0.184..0.998 rows=1,230 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=336
116. 0.146 0.146 ↑ 1.0 1,230 1

Bitmap Index Scan on balance_log_201901_registrar_name_idx (cost=0.00..18.51 rows=1,230 width=0) (actual time=0.146..0.146 rows=1,230 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
117. 1.474 1.759 ↑ 1.0 3,131 1

Bitmap Heap Scan on balance_log_201902 l_63 (cost=51.55..570.69 rows=3,131 width=49) (actual time=0.322..1.759 rows=3,131 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=315
118. 0.285 0.285 ↑ 1.0 3,131 1

Bitmap Index Scan on balance_log_201902_registrar_name_idx (cost=0.00..50.77 rows=3,131 width=0) (actual time=0.285..0.285 rows=3,131 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
119. 0.757 0.865 ↑ 1.0 895 1

Bitmap Heap Scan on balance_log_201903 l_64 (cost=14.72..587.94 rows=895 width=50) (actual time=0.135..0.865 rows=895 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=249
120. 0.108 0.108 ↑ 1.0 895 1

Bitmap Index Scan on balance_log_201903_registrar_name_idx (cost=0.00..14.50 rows=895 width=0) (actual time=0.108..0.108 rows=895 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
121. 2.012 2.481 ↑ 1.0 5,262 1

Bitmap Heap Scan on balance_log_201904 l_65 (cost=84.57..1,140.34 rows=5,262 width=49) (actual time=0.516..2.481 rows=5,262 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=421
122. 0.469 0.469 ↑ 1.0 5,262 1

Bitmap Index Scan on balance_log_201904_registrar_name_idx (cost=0.00..83.25 rows=5,262 width=0) (actual time=0.469..0.469 rows=5,262 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
123. 1.229 1.435 ↑ 1.0 1,926 1

Bitmap Heap Scan on balance_log_201905 l_66 (cost=34.71..633.79 rows=1,926 width=50) (actual time=0.250..1.435 rows=1,926 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=355
124. 0.206 0.206 ↑ 1.0 1,926 1

Bitmap Index Scan on balance_log_201905_registrar_name_idx (cost=0.00..34.23 rows=1,926 width=0) (actual time=0.206..0.206 rows=1,926 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
125. 0.752 0.889 ↑ 1.0 1,302 1

Bitmap Heap Scan on balance_log_201906 l_67 (cost=25.38..505.65 rows=1,302 width=50) (actual time=0.164..0.889 rows=1,302 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=227
126. 0.137 0.137 ↑ 1.0 1,302 1

Bitmap Index Scan on balance_log_201906_registrar_name_idx (cost=0.00..25.05 rows=1,302 width=0) (actual time=0.137..0.137 rows=1,302 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
127. 1.027 1.196 ↑ 1.0 1,678 1

Bitmap Heap Scan on balance_log_201907 l_68 (cost=32.79..492.76 rows=1,678 width=50) (actual time=0.201..1.196 rows=1,678 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=271
128. 0.169 0.169 ↑ 1.0 1,678 1

Bitmap Index Scan on balance_log_201907_registrar_name_idx (cost=0.00..32.37 rows=1,678 width=0) (actual time=0.169..0.169 rows=1,678 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
129. 1.815 2.140 ↑ 1.0 3,507 1

Bitmap Heap Scan on balance_log_201908 l_69 (cost=69.46..622.30 rows=3,507 width=50) (actual time=0.367..2.140 rows=3,507 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=388
130. 0.325 0.325 ↑ 1.0 3,507 1

Bitmap Index Scan on balance_log_201908_registrar_name_idx (cost=0.00..68.59 rows=3,507 width=0) (actual time=0.325..0.325 rows=3,507 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
131. 1.980 2.393 ↑ 1.0 4,280 1

Bitmap Heap Scan on balance_log_201909 l_70 (cost=105.46..858.96 rows=4,280 width=49) (actual time=0.461..2.393 rows=4,280 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=384
132. 0.413 0.413 ↑ 1.0 4,280 1

Bitmap Index Scan on balance_log_201909_registrar_name_idx (cost=0.00..104.39 rows=4,280 width=0) (actual time=0.413..0.413 rows=4,280 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
133. 0.575 0.668 ↑ 1.0 596 1

Bitmap Heap Scan on balance_log_201910 l_71 (cost=10.90..400.96 rows=596 width=50) (actual time=0.124..0.668 rows=596 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=261
134. 0.093 0.093 ↑ 1.0 596 1

Bitmap Index Scan on balance_log_201910_registrar_name_idx (cost=0.00..10.75 rows=596 width=0) (actual time=0.093..0.093 rows=596 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
135. 1.344 1.631 ↑ 1.0 3,134 1

Bitmap Heap Scan on balance_log_201911 l_72 (cost=50.07..745.25 rows=3,134 width=50) (actual time=0.328..1.631 rows=3,134 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=353
136. 0.287 0.287 ↑ 1.0 3,134 1

Bitmap Index Scan on balance_log_201911_registrar_name_idx (cost=0.00..49.29 rows=3,134 width=0) (actual time=0.287..0.287 rows=3,134 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
137. 1.863 2.327 ↑ 1.0 5,011 1

Bitmap Heap Scan on balance_log_201912 l_73 (cost=73.62..1,058.26 rows=5,011 width=49) (actual time=0.514..2.327 rows=5,011 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=424
138. 0.464 0.464 ↑ 1.0 5,011 1

Bitmap Index Scan on balance_log_201912_registrar_name_idx (cost=0.00..72.37 rows=5,011 width=0) (actual time=0.464..0.464 rows=5,011 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
139. 3.223 4.043 ↑ 1.0 9,337 1

Bitmap Heap Scan on balance_log_202001 l_74 (cost=135.65..1,440.36 rows=9,337 width=49) (actual time=0.896..4.043 rows=9,337 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=645
140. 0.820 0.820 ↑ 1.0 9,337 1

Bitmap Index Scan on balance_log_202001_registrar_name_idx (cost=0.00..133.31 rows=9,337 width=0) (actual time=0.820..0.820 rows=9,337 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
141. 6.822 6.822 ↑ 1.1 13,462 1

Seq Scan on balance_log_202002 l_75 (cost=0.00..1,280.67 rows=14,492 width=48) (actual time=0.010..6.822 rows=13,462 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 11707
142. 7.539 7.539 ↓ 1.0 14,128 1

Seq Scan on balance_log_202003 l_76 (cost=0.00..1,315.64 rows=13,982 width=48) (actual time=0.010..7.539 rows=14,128 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 14096
143. 17.510 17.510 ↑ 1.1 31,653 1

Seq Scan on balance_log_202004 l_77 (cost=0.00..2,518.93 rows=35,555 width=48) (actual time=0.019..17.510 rows=31,653 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 15131
144. 0.568 0.639 ↑ 1.1 609 1

Bitmap Heap Scan on balance_log_202005 l_78 (cost=11.53..456.86 rows=677 width=50) (actual time=0.098..0.639 rows=609 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=204
145. 0.071 0.071 ↑ 1.1 609 1

Bitmap Index Scan on balance_log_202005_registrar_name_idx (cost=0.00..11.36 rows=677 width=0) (actual time=0.071..0.071 rows=609 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
146. 0.003 0.003 ↓ 0.0 0 1

Index Scan using balance_log_202006_registrar_name_idx on balance_log_202006 l_79 (cost=0.14..3.16 rows=1 width=68) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
147. 0.004 0.004 ↓ 0.0 0 1

Index Scan using balance_log_202007_registrar_name_idx on balance_log_202007 l_80 (cost=0.14..3.16 rows=1 width=68) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
148. 0.922 2.036 ↓ 1.0 4,848 1

Hash (cost=208.35..208.35 rows=4,835 width=43) (actual time=2.036..2.036 rows=4,848 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 408kB
149. 1.114 1.114 ↓ 1.0 4,848 1

Seq Scan on balance_adjustment ba (cost=0.00..208.35 rows=4,835 width=43) (actual time=0.005..1.114 rows=4,848 loops=1)

150. 0.005 0.010 ↑ 1.0 4 1

Hash (cost=1.06..1.06 rows=4 width=4) (actual time=0.010..0.010 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
151. 0.005 0.005 ↑ 1.0 4 1

Seq Scan on balance_adjustment_category bac (cost=0.00..1.06 rows=4 width=4) (actual time=0.004..0.005 rows=4 loops=1)

  • Filter: invoice_visible
  • Rows Removed by Filter: 2
152. 0.006 0.014 ↑ 1.0 20 1

Hash (cost=1.20..1.20 rows=20 width=35) (actual time=0.014..0.014 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
153. 0.008 0.008 ↑ 1.0 20 1

Seq Scan on balance_operation bo (cost=0.00..1.20 rows=20 width=35) (actual time=0.005..0.008 rows=20 loops=1)