explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4bMS

Settings
# exclusive inclusive rows x rows loops node
1. 58.141 953.565 ↓ 1.5 31,654 1

Sort (cost=263,139.58..263,194.01 rows=21,772 width=98) (actual time=949.717..953.565 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. 24.123 895.424 ↓ 1.5 31,654 1

GroupAggregate (cost=260,836.08..261,570.88 rows=21,772 width=98) (actual time=866.690..895.424 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. 40.926 871.301 ↓ 2.9 31,653 1

Sort (cost=260,836.08..260,863.29 rows=10,886 width=86) (actual time=866.680..871.301 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.460 830.375 ↓ 2.9 31,653 1

Hash Left Join (cost=271.35..260,106.16 rows=10,886 width=86) (actual time=784.593..830.375 rows=31,653 loops=1)

  • Hash Cond: (l.operation_id = bo.id)
5. 5.894 817.902 ↓ 2.9 31,653 1

Hash Left Join (cost=269.90..259,900.72 rows=10,886 width=81) (actual time=784.557..817.902 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. 171.268 811.998 ↓ 2.9 31,653 1

Hash Left Join (cost=268.79..259,785.97 rows=10,909 width=93) (actual time=784.528..811.998 rows=31,653 loops=1)

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

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

8. 0.005 0.005 ↓ 0.0 0 1

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

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

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

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 36
10. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
11. 0.002 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
12. 0.008 0.008 ↓ 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.008 rows=0 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
13. 0.138 0.170 ↑ 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.040..0.170 rows=117 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=51
14. 0.032 0.032 ↑ 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.031..0.032 rows=117 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
15. 17.283 17.283 ↓ 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.007..17.283 rows=39,087 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 11528
16. 0.319 0.387 ↑ 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.079..0.387 rows=492 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=98
17. 0.068 0.068 ↑ 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.067..0.068 rows=492 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
18. 4.882 4.882 ↑ 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.014..4.882 rows=7,035 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 5107
19. 0.461 0.534 ↑ 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.091..0.534 rows=499 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=113
20. 0.073 0.073 ↑ 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.073..0.073 rows=499 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
21. 0.317 0.364 ↑ 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.060..0.364 rows=314 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=81
22. 0.047 0.047 ↑ 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.047..0.047 rows=314 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
23. 17.830 17.830 ↑ 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.010..17.830 rows=43,968 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 7524
24. 0.269 0.328 ↑ 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.071..0.328 rows=404 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=101
25. 0.059 0.059 ↑ 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.059..0.059 rows=404 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
26. 1.101 1.298 ↑ 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.232..1.298 rows=2,143 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=323
27. 0.197 0.197 ↑ 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.196..0.197 rows=2,143 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
28. 0.917 1.074 ↑ 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.196..1.074 rows=1,325 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=333
29. 0.157 0.157 ↑ 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.157..0.157 rows=1,325 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
30. 29.292 29.292 ↑ 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.016..29.292 rows=77,502 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 14641
31. 0.944 1.135 ↑ 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.227..1.135 rows=1,853 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=291
32. 0.191 0.191 ↑ 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.191..0.191 rows=1,853 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
33. 9.050 9.050 ↑ 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.023..9.050 rows=24,909 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
34. 21.604 26.472 ↓ 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.288..26.472 rows=70,291 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=2927
35. 4.868 4.868 ↓ 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=4.868..4.868 rows=70,291 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
36. 1.073 1.249 ↓ 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.226..1.249 rows=1,527 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=408
37. 0.176 0.176 ↓ 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.176..0.176 rows=1,527 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
38. 25.421 25.421 ↑ 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.022..25.421 rows=46,224 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 34906
39. 29.026 29.026 ↓ 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.014..29.026 rows=52,003 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 37303
40. 21.102 21.102 ↑ 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.021..21.102 rows=25,388 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 42676
41. 5.573 6.754 ↑ 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.328..6.754 rows=14,195 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1242
42. 1.181 1.181 ↑ 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.181..1.181 rows=14,195 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
43. 0.790 0.923 ↓ 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.188..0.923 rows=1,186 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=309
44. 0.133 0.133 ↓ 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.133..0.133 rows=1,186 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
45. 1.796 2.144 ↑ 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.427..2.144 rows=3,523 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=714
46. 0.348 0.348 ↑ 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.348..0.348 rows=3,523 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
47. 2.319 2.707 ↓ 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.502..2.707 rows=3,869 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=916
48. 0.388 0.388 ↓ 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.388..0.388 rows=3,869 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
49. 60.808 60.808 ↑ 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.016..60.808 rows=79,091 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 149590
50. 8.298 10.277 ↑ 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.189..10.277 rows=25,084 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1588
51. 1.979 1.979 ↑ 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.979..1.979 rows=25,084 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
52. 19.357 24.426 ↓ 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.511..24.426 rows=64,637 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=3184
53. 5.069 5.069 ↓ 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=5.069..5.069 rows=64,637 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
54. 5.181 6.056 ↓ 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=1.051..6.056 rows=9,437 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1247
55. 0.875 0.875 ↓ 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.875..0.875 rows=9,437 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
56. 4.691 5.387 ↑ 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.849..5.387 rows=7,109 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1217
57. 0.696 0.696 ↑ 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.696..0.696 rows=7,109 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
58. 9.516 11.175 ↑ 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.904..11.175 rows=19,240 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1886
59. 1.659 1.659 ↑ 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.659..1.659 rows=19,240 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
60. 56.415 56.415 ↓ 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.018..56.415 rows=91,048 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 68910
61. 28.114 28.114 ↓ 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.018..28.114 rows=26,630 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 73021
62. 28.648 28.648 ↓ 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.115..28.648 rows=40,211 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 77438
63. 2.114 2.553 ↑ 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.520..2.553 rows=4,575 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=651
64. 0.439 0.439 ↑ 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.439..0.439 rows=4,575 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
65. 2.189 2.602 ↓ 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.516..2.602 rows=4,091 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=759
66. 0.413 0.413 ↓ 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.413..0.413 rows=4,091 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
67. 2.761 3.317 ↓ 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.665..3.317 rows=5,695 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=885
68. 0.556 0.556 ↓ 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.556..0.556 rows=5,695 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
69. 7.323 9.171 ↑ 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.086..9.171 rows=21,312 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1858
70. 1.848 1.848 ↑ 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.848..1.848 rows=21,312 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
71. 6.988 8.628 ↑ 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.911..8.628 rows=19,988 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1955
72. 1.640 1.640 ↑ 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.640..1.640 rows=19,988 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
73. 7.269 9.240 ↓ 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.162..9.240 rows=23,914 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1443
74. 1.971 1.971 ↓ 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=1.971..1.971 rows=23,914 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
75. 3.421 3.421 ↓ 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.017..3.421 rows=4,750 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
76. 6.909 8.459 ↓ 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.786..8.459 rows=17,477 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=1868
77. 1.550 1.550 ↓ 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.550..1.550 rows=17,477 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
78. 3.599 4.367 ↑ 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=0.887..4.367 rows=8,589 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=986
79. 0.768 0.768 ↑ 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.768..0.768 rows=8,589 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
80. 5.899 7.463 ↓ 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.680..7.463 rows=19,205 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=972
81. 1.564 1.564 ↓ 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.564..1.564 rows=19,205 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
82. 2.038 2.444 ↓ 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.489..2.444 rows=3,624 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=716
83. 0.406 0.406 ↓ 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.406..0.406 rows=3,624 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
84. 8.050 8.050 ↑ 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.019..8.050 rows=13,667 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 18174
85. 1.600 1.924 ↑ 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.378..1.924 rows=3,464 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=473
86. 0.324 0.324 ↑ 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.324..0.324 rows=3,464 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
87. 2.616 3.145 ↑ 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.594..3.145 rows=5,977 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=542
88. 0.529 0.529 ↑ 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.529..0.529 rows=5,977 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
89. 2.047 2.523 ↑ 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.526..2.523 rows=5,931 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=437
90. 0.476 0.476 ↑ 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.476..0.476 rows=5,931 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
91. 1.302 1.503 ↑ 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.249..1.503 rows=2,098 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=416
92. 0.201 0.201 ↑ 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.201..0.201 rows=2,098 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
93. 1.708 2.060 ↑ 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.397..2.060 rows=4,381 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=433
94. 0.352 0.352 ↑ 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.352..0.352 rows=4,381 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
95. 1.073 1.229 ↑ 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.197..1.229 rows=1,486 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=398
96. 0.156 0.156 ↑ 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.156..0.156 rows=1,486 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
97. 1.117 1.339 ↑ 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.261..1.339 rows=2,345 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=379
98. 0.222 0.222 ↑ 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.222..0.222 rows=2,345 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
99. 1.177 1.403 ↑ 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.262..1.403 rows=2,546 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=328
100. 0.226 0.226 ↑ 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.226..0.226 rows=2,546 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
101. 0.691 0.823 ↑ 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.161..0.823 rows=1,300 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=257
102. 0.132 0.132 ↑ 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.132..0.132 rows=1,300 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
103. 1.232 1.519 ↑ 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.323..1.519 rows=3,403 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=331
104. 0.287 0.287 ↑ 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.287..0.287 rows=3,403 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
105. 0.584 0.694 ↑ 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.139..0.694 rows=1,012 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=271
106. 0.110 0.110 ↑ 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.110..0.110 rows=1,012 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
107. 1.223 1.536 ↑ 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.345..1.536 rows=3,795 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=308
108. 0.313 0.313 ↑ 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.313..0.313 rows=3,795 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
109. 0.919 1.085 ↑ 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.194..1.085 rows=1,770 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=270
110. 0.166 0.166 ↑ 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.166..0.166 rows=1,770 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
111. 0.698 0.803 ↑ 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.130..0.803 rows=972 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=239
112. 0.105 0.105 ↑ 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.105..0.105 rows=972 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
113. 0.497 0.578 ↑ 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.104..0.578 rows=791 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=199
114. 0.081 0.081 ↑ 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.081..0.081 rows=791 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
115. 0.807 0.935 ↑ 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.163..0.935 rows=1,230 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=336
116. 0.128 0.128 ↑ 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.128..0.128 rows=1,230 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
117. 1.372 1.644 ↑ 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.310..1.644 rows=3,131 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=315
118. 0.272 0.272 ↑ 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.272..0.272 rows=3,131 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
119. 0.721 0.818 ↑ 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.121..0.818 rows=895 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=249
120. 0.097 0.097 ↑ 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.097..0.097 rows=895 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
121. 1.944 2.374 ↑ 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.475..2.374 rows=5,262 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=421
122. 0.430 0.430 ↑ 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.430..0.430 rows=5,262 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
123. 1.190 1.398 ↑ 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.247..1.398 rows=1,926 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=355
124. 0.208 0.208 ↑ 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.208..0.208 rows=1,926 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
125. 0.734 0.864 ↑ 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.155..0.864 rows=1,302 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=227
126. 0.130 0.130 ↑ 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.130..0.130 rows=1,302 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
127. 1.046 1.226 ↑ 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.212..1.226 rows=1,678 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=271
128. 0.180 0.180 ↑ 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.180..0.180 rows=1,678 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
129. 1.752 2.059 ↑ 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.348..2.059 rows=3,507 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=388
130. 0.307 0.307 ↑ 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.307..0.307 rows=3,507 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
131. 1.859 2.246 ↑ 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.431..2.246 rows=4,280 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=384
132. 0.387 0.387 ↑ 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.387..0.387 rows=4,280 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
133. 0.567 0.646 ↑ 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.108..0.646 rows=596 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=261
134. 0.079 0.079 ↑ 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.079..0.079 rows=596 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
135. 1.288 1.577 ↑ 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.577 rows=3,134 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=353
136. 0.289 0.289 ↑ 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.289..0.289 rows=3,134 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
137. 1.853 2.267 ↑ 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.459..2.267 rows=5,011 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=424
138. 0.414 0.414 ↑ 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.413..0.414 rows=5,011 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
139. 2.999 3.743 ↑ 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.816..3.743 rows=9,337 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=645
140. 0.744 0.744 ↑ 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.744..0.744 rows=9,337 loops=1)

  • Index Cond: (registrar_name = 'uniregistrar'::text)
141. 6.747 6.747 ↑ 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.015..6.747 rows=13,462 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 11707
142. 7.358 7.358 ↓ 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.017..7.358 rows=14,128 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 14096
143. 16.800 16.800 ↑ 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.018..16.800 rows=31,653 loops=1)

  • Filter: (registrar_name = 'uniregistrar'::text)
  • Rows Removed by Filter: 15131
144. 0.523 0.586 ↑ 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.086..0.586 rows=609 loops=1)

  • Recheck Cond: (registrar_name = 'uniregistrar'::text)
  • Heap Blocks: exact=204
145. 0.063 0.063 ↑ 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.063..0.063 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.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

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

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

  • Buckets: 8192 Batches: 1 Memory Usage: 408kB
149. 1.144 1.144 ↓ 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.144 rows=4,848 loops=1)

150. 0.004 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.006 0.006 ↑ 1.0 4 1

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

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

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

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

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