Postgres database is getting huge

First, thank you for this app - it's really really useful and an automatic install on all my Ubuntu machines.
I am running hishtory on about 5 machines now. My server is running dockerized on my biggest machine. However after a few months of usage my postgres database is using 15GB of space which seems quite high for a storage of text. I've tried doing a VACUUM on the database but nothing seems to reduce the size. Is this just normal or is there some other maintenance I should be doing? I've tried setting the duplicate removal on but that also seems to make no difference. Any ideas?
Many thanks!

Hi @a10kiloham !
I have no idea what's happening, but I think it would be very useful if you could do the following:

Collect the logs of your hishtory container and attach them as a file (or, maybe you'll find something interesting there and share a few particular lines)
Check which tables take the most space (like this for example https://stackoverflow.com/questions/21738408/postgresql-list-and-order-tables-by-size) and also share the results.

Since the database is encrypted, it can take quite a space. My local .bash_history is only 7Mb, while table in postgres is 254mb, which is big, though not 15Gb.

Thanks ill try that this am

So for table space, the command you referenced outputs this:
     table_name      | pg_size_pretty | pg_total_relation_size
---------------------+----------------+------------------------
 enc_history_entries | 15 GB          |<PHONE_NUMBER>0
 deletion_requests   | 50 MB          |               52617216
 usage_data          | 168 kB         |                 172032
 active_user_stats   | 80 kB          |                  81920
 dump_requests       | 48 kB          |                  49152
 devices             | 48 kB          |                  49152
 feedbacks           | 8192 bytes     |                   8192

The logs don't look crazy - nothing too unusual except the very long delete
hishtory-postgres  | 2024-08-07 16:43:40.142 UTC [9066] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-07 16:50:57.502 UTC [9074] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-07 19:30:09.862 UTC [9234] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-07 22:00:58.330 UTC [9386] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-07 22:01:13.596 UTC [9387] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-07 22:01:28.796 UTC [9389] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-07 22:01:43.983 UTC [9390] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-07 22:01:44.174 UTC [9391] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-07 22:01:59.365 UTC [9392] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-07 22:02:14.554 UTC [9393] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-07 22:02:29.740 UTC [9395] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-07 22:02:44.928 UTC [9396] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-07 22:03:00.117 UTC [9397] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-07 22:03:15.305 UTC [9398] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-07 22:03:30.494 UTC [9400] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-07 22:03:45.685 UTC [9401] FATAL:  no PostgreSQL user name specified in startup packet
hishtory-postgres  | 2024-08-08 02:48:04.720 UTC [9687] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-08 03:13:16.570 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 03:13:16.782 UTC [27] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.203 s, sync=0.002 s, total=0.214 s; sync files=4, longest=0.002 s, average=0.001 s; distance=8 kB, estimate=27827 kB; lsn=59/85CB8F78, redo lsn=59/85CB8F40
hishtory-postgres  | 2024-08-08 04:33:23.427 UTC [9793] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-08 04:58:23.751 UTC [9819] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-08 05:37:44.180 UTC [9859] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-08 08:18:22.549 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 08:18:27.775 UTC [27] LOG:  checkpoint complete: wrote 53 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.217 s, sync=0.003 s, total=5.229 s; sync files=14, longest=0.001 s, average=0.001 s; distance=324 kB, estimate=25077 kB; lsn=59/85D0A1A0, redo lsn=59/85D0A168
hishtory-postgres  | 2024-08-08 08:23:22.871 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 08:23:23.780 UTC [27] LOG:  checkpoint complete: wrote 9 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.903 s, sync=0.002 s, total=0.910 s; sync files=2, longest=0.002 s, average=0.001 s; distance=9 kB, estimate=22570 kB; lsn=59/85D0C648, redo lsn=59/85D0C610
hishtory-postgres  | 2024-08-08 10:58:25.672 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 10:58:28.587 UTC [27] LOG:  checkpoint complete: wrote 30 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.908 s, sync=0.002 s, total=2.916 s; sync files=9, longest=0.001 s, average=0.001 s; distance=179 kB, estimate=20331 kB; lsn=59/85D39628, redo lsn=59/85D395F0
hishtory-postgres  | 2024-08-08 12:38:55.586 UTC [10281] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-08 15:18:30.481 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 15:18:30.692 UTC [27] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.204 s, sync=0.002 s, total=0.213 s; sync files=3, longest=0.002 s, average=0.001 s; distance=8 kB, estimate=18299 kB; lsn=59/85D3B780, redo lsn=59/85D3B748
hishtory-postgres  | 2024-08-08 15:43:31.165 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 15:43:39.186 UTC [27] LOG:  checkpoint complete: wrote 81 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=8.016 s, sync=0.002 s, total=8.021 s; sync files=12, longest=0.001 s, average=0.001 s; distance=455 kB, estimate=16514 kB; lsn=59/85DEFA48, redo lsn=59/85DAD658
hishtory-postgres  | 2024-08-08 15:48:31.283 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 15:48:41.607 UTC [27] LOG:  checkpoint complete: wrote 104 buffers (0.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=10.320 s, sync=0.002 s, total=10.325 s; sync files=11, longest=0.001 s, average=0.001 s; distance=726 kB, estimate=14935 kB; lsn=59/85E62EA8, redo lsn=59/85E62E70
hishtory-postgres  | 2024-08-08 15:53:31.633 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 15:53:40.560 UTC [27] LOG:  checkpoint complete: wrote 90 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=8.920 s, sync=0.003 s, total=8.928 s; sync files=10, longest=0.001 s, average=0.001 s; distance=411 kB, estimate=13483 kB; lsn=59/85EC9E50, redo lsn=59/85EC9E18
hishtory-postgres  | 2024-08-08 16:03:31.759 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 16:03:57.723 UTC [27] LOG:  checkpoint complete: wrote 260 buffers (1.6%); 0 WAL file(s) added, 0 removed, 1 recycled; write=25.957 s, sync=0.003 s, total=25.964 s; sync files=20, longest=0.001 s, average=0.001 s; distance=1798 kB, estimate=12314 kB; lsn=59/8779B1C8, redo lsn=59/8608B6D0
hishtory-postgres  | 2024-08-08 16:08:31.817 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 16:13:01.094 UTC [27] LOG:  checkpoint complete: wrote 3766 buffers (23.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=269.272 s, sync=0.003 s, total=269.278 s; sync files=21, longest=0.001 s, average=0.001 s; distance=23892 kB, estimate=23892 kB; lsn=59/87ABE3F0, redo lsn=59/877E07F8
hishtory-postgres  | 2024-08-08 16:13:31.108 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 16:16:11.668 UTC [27] LOG:  checkpoint complete: wrote 1603 buffers (9.8%); 0 WAL file(s) added, 0 removed, 0 recycled; write=160.556 s, sync=0.002 s, total=160.561 s; sync files=12, longest=0.001 s, average=0.001 s; distance=3102 kB, estimate=21813 kB; lsn=59/87B2FD48, redo lsn=59/87AE8230
hishtory-postgres  | 2024-08-08 16:18:31.696 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 16:18:39.319 UTC [27] LOG:  checkpoint complete: wrote 77 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=7.617 s, sync=0.003 s, total=7.623 s; sync files=10, longest=0.001 s, average=0.001 s; distance=560 kB, estimate=19688 kB; lsn=59/87B74630, redo lsn=59/87B745F8
hishtory-postgres  | 2024-08-08 16:23:31.416 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 16:28:01.044 UTC [27] LOG:  checkpoint complete: wrote 2965 buffers (18.1%); 0 WAL file(s) added, 0 removed, 2 recycled; write=269.622 s, sync=0.002 s, total=269.628 s; sync files=19, longest=0.001 s, average=0.001 s; distance=24498 kB, estimate=24498 kB; lsn=59/8AB72740, redo lsn=59/89361040
hishtory-postgres  | 2024-08-08 16:28:31.074 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 16:31:45.725 UTC [27] LOG:  checkpoint complete: wrote 1931 buffers (11.8%); 0 WAL file(s) added, 0 removed, 1 recycled; write=194.644 s, sync=0.003 s, total=194.651 s; sync files=14, longest=0.002 s, average=0.001 s; distance=24668 kB, estimate=24668 kB; lsn=59/8C2E0C38, redo lsn=59/8AB782B0
hishtory-postgres  | 2024-08-08 16:33:31.822 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 16:38:01.068 UTC [27] LOG:  checkpoint complete: wrote 3222 buffers (19.7%); 0 WAL file(s) added, 0 removed, 2 recycled; write=269.240 s, sync=0.002 s, total=269.247 s; sync files=27, longest=0.001 s, average=0.001 s; distance=25116 kB, estimate=25116 kB; lsn=59/8C446ED8, redo lsn=59/8C3FF360
hishtory-postgres  | 2024-08-08 16:43:31.189 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 16:44:29.609 UTC [27] LOG:  checkpoint complete: wrote 584 buffers (3.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=58.415 s, sync=0.002 s, total=58.420 s; sync files=6, longest=0.002 s, average=0.001 s; distance=1168 kB, estimate=22721 kB; lsn=59/8C585AB8, redo lsn=59/8C5235B0
hishtory-postgres  | 2024-08-08 16:48:31.707 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 16:52:30.864 UTC [27] LOG:  checkpoint complete: wrote 2387 buffers (14.6%); 0 WAL file(s) added, 0 removed, 1 recycled; write=239.150 s, sync=0.004 s, total=239.158 s; sync files=23, longest=0.001 s, average=0.001 s; distance=16480 kB, estimate=22097 kB; lsn=59/8D9712E8, redo lsn=59/8D53B828
hishtory-postgres  | 2024-08-08 16:53:31.922 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 16:57:12.009 UTC [27] LOG:  checkpoint complete: wrote 2068 buffers (12.6%); 0 WAL file(s) added, 0 removed, 1 recycled; write=220.080 s, sync=0.003 s, total=220.087 s; sync files=22, longest=0.001 s, average=0.001 s; distance=11374 kB, estimate=21024 kB; lsn=59/8EA30970, redo lsn=59/8E057028
hishtory-postgres  | 2024-08-08 16:58:01.483 UTC [10536] ERROR:  canceling statement due to user request
hishtory-postgres  | 2024-08-08 16:58:01.483 UTC [10536] STATEMENT:  DELETE FROM "enc_history_entries" WHERE false OR (user_id = $1 AND (encrypted_id = $2)) OR (user_id = $3 AND (encrypted_id = $4)) OR (user_id = $5 AND (encrypted_id = $6)) OR (user_id = $7 AND (encrypted_id = $8)) OR (user_id = $9 AND (encrypted_id = $10)) OR (user_id = $11 AND (encrypted_id = $12)) OR (user_id = $13 AND (encrypted_id = $14)) OR (user_id = $15 AND (encrypted_id = $16)) OR (user_id = $17 AND (encrypted_id = $18)) OR (user_id = $19 AND (encrypted_id = $20)) OR (user_id = $21 AND (encrypted_id = $22)) OR (user_id = $23 AND (encrypted_id = $24)) OR (user_id = $25 AND (encrypted_id = $26)) OR (user_id = $27 AND (encrypted_id = $28)) OR (user_id = $29 AND (encrypted_id = $30)) OR (user_id = $31 AND (encrypted_id = $32)) OR (user_id = $33 AND (encrypted_id = $34)) OR (user_id = $35 AND (encrypted_id = $36)) OR (user_id = $37 AND (encrypted_id = $38)) OR (user_id = $39 AND (encrypted_id = $40)) OR (user_id = $41 AND (encrypted_id = $42)) OR (user_id = $43 AND (encrypted_id = $44)) OR (user_id = $45 AND (encrypted_id = $46)) OR (user_id = $47 AND (encrypted_id = $48)) OR (user_id = $49 AND (encrypted_id = $50)) OR (user_id = $51 AND (encrypted_id = $52)) OR (user_id = $53 AND (encrypted_id = $54)) OR (user_id = $55 AND (encrypted_id = $56)) OR (user_id = $57 AND (encrypted_id = $58)) OR (user_id = $59 AND (encrypted_id = $60)) OR (user_id = $61 AND (encrypted_id = $62)) OR (user_id = $63 AND (encrypted_id = $64)) OR (user_id = $65 AND (encrypted_id = $66)) OR (user_id = $67 AND (encrypted_id = $68)) OR (user_id = $69 AND (encrypted_id = $70)) OR (user_id = $71 AND (encrypted_id = $72)) OR (user_id = $73 AND (encrypted_id = $74)) OR (user_id = $75 AND (encrypted_id = $76)) OR (user_id = $77 AND (encrypted_id = $78)) OR (user_id = $79 AND (encrypted_id = $80)) OR (user_id = $81 AND (encrypted_id = $82)) OR (user_id = $83 AND (encrypted_id = $84)) OR (user_id = $85 AND (encrypted_id = $86)) OR (user_id = $87 AND (encrypted_id = $88)) OR (user_id = $89 AND (encrypted_id = $90)) OR (user_id = $91 AND (encrypted_id = $92)) OR (user_id = $93 AND (encrypted_id = $94)) OR (user_id = $95 AND (encrypted_id = $96)) OR (user_id = $97 AND (encrypted_id = $98)) OR (user_id = $99 AND (encrypted_id = $100)) OR (user_id = $101 AND (encrypted_id = $102)) OR (user_id = $103 AND (encrypted_id = $104)) OR (user_id = $105 AND (encrypted_id = $106)) OR (user_id = $107 AND (encrypted_id = $108)) OR (user_id = $109 AND (encrypted_id = $110)) OR (user_id = $111 AND (encrypted_id = $112)) OR (user_id = $113 AND (encrypted_id = $114)) OR (user_id = $115 AND (encrypted_id = $116)) OR (user_id = $117 AND (encrypted_id = $118)) OR (user_id = $119 AND (encrypted_id = $120)) OR (user_id = $121 AND (encrypted_id = $122)) OR (user_id = $123 AND (encrypted_id = $124)) OR (user_id = $125 AND (encrypted_id = $126)) OR (user_id = $127 AND (encrypted_id = $128)) OR (user_id = $129 AND (encrypted_id = $130)) OR (user_id = $131 AND (encrypted_id = $132)) OR (user_id = $133 AND (encrypted_id = $134)) OR (user_id = $135 AND (encrypted_id = $136)) OR (user_id = $137 AND (encrypted_id = $138)) OR (user_id = $139 AND (encrypted_id = $140)) OR (user_id = $141 AND (encrypted_id = $142)) OR (user_id = $143 AND (encrypted_id = $144)) OR (user_id = $145 AND (encrypted_id = $146)) OR (user_id = $147 AND (encrypted_id = $148)) OR (user_id = $149 AND (encrypted_id = $150)) OR (user_id = $151 AND (encrypted_id = $152)) OR (user_id = $153 AND (encrypted_id = $154)) OR (user_id = $155 AND (encrypted_id = $156)) OR (user_id = $157 AND (encrypted_id = $158)) OR (user_id = $159 AND (encrypted_id = $160)) OR (user_id = $161 AND (encrypted_id = $162)) OR (user_id = $163 AND (encrypted_id = $164)) OR (user_id = $165 AND (encrypted_id = $166)) OR (user_id = $167 AND (encrypted_id = $168)) OR (user_id = $169 AND (encrypted_id = $170)) OR (user_id = $171 AND (encrypted_id = $172)) OR (user_id = $173 AND (encrypted_id = $174)) OR (user_id = $175 AND (encrypted_id = $176)) OR (user_id = $177 AND (encrypted_id = $178)) OR (user_id = $179 AND (encrypted_id = $180)) OR (user_id = $181 AND (encrypted_id = $182)) OR (user_id = $183 AND (encrypted_id = $184)) OR (user_id = $185 AND (encrypted_id = $186)) OR (user_id = $187 AND (encrypted_id = $188)) OR (user_id = $189 AND (encrypted_id = $190)) OR (user_id = $191 AND (encrypted_id = $192)) OR (user_id = $193 AND (encrypted_id = $194)) OR (user_id = $195 AND (encrypted_id = $196)) OR (user_id = $197 AND (encrypted_id = $198)) OR (user_id = $199 AND (encrypted_id = $200)) OR (user_id = $201 AND (encrypted_id = $202)) OR (user_id = $203 AND (encrypted_id = $204)) OR (user_id = $205 AND (encrypted_id = $206)) OR (user_id = $207 AND (encrypted_id = $208)) OR (user_id = $209 AND (encrypted_id = $210)) OR (user_id = $211 AND (encrypted_id = $212)) OR (user_id = $213 AND (encrypted_id = $214)) OR (user_id = $215 AND (encrypted_id = $216)) OR (user_id = $217 AND (encrypted_id = $218)) OR (user_id = $219 AND (encrypted_id = $220)) OR (user_id = $221 AND (encrypted_id = $222)) OR (user_id = $223 AND (encrypted_id = $224)) OR (user_id = $225 AND (encrypted_id = $226)) OR (user_id = $227 AND (encrypted_id = $228)) OR (user_id = $229 AND (encrypted_id = $230)) OR (user_id = $231 AND (encrypted_id = $232)) OR (user_id = $233 AND (encrypted_id = $234)) OR (user_id = $235 AND (encrypted_id = $236)) OR (user_id = $237 AND (encrypted_id = $238)) OR (user_id = $239 AND (encrypted_id = $240)) OR (user_id = $241 AND (encrypted_id = $242)) OR (user_id = $243 AND (encrypted_id = $244)) OR (user_id = $245 AND (encrypted_id = $246)) OR (user_id = $247 AND (encrypted_id = $248)) OR (user_id = $249 AND (encrypted_id = $250)) OR (user_id = $251 AND (encrypted_id = $252)) OR (user_id = $253 AND (encrypted_id = $254)) OR (user_id = $255 AND (encrypted_id = $256)) OR (user_id = $257 AND (encrypted_id = $258)) OR (user_id = $259 AND (encrypted_id = $260)) OR (user_id = $261 AND (encrypted_id = $262)) OR (user_id = $263 AND (encrypted_id = $264)) OR (user_id = $265 AND (encrypted_id = $266)) OR (user_id = $267 AND (encrypted_id = $268)) OR (user_id = $269 AND (encrypted_id = $270)) OR (user_id = $271 AND (encrypted_id = $272)) OR (user_id = $273 AND (encrypted_id = $274)) OR (user_id = $275 AND (encrypted_id = $276)) OR (user_id = $277 AND (encrypted_id = $278)) OR (user_id = $279 AND (encrypted_id = $280)) OR (user_id = $281 AND (encrypted_id = $282)) OR (user_id = $283 AND (encrypted_id = $284)) OR (user_id = $285 AND (encrypted_id = $286)) OR (user_id = $287 AND (encrypted_id = $288)) OR (user_id = $289 AND (encrypted_id = $290)) OR (user_id = $291 AND (encrypted_id = $292)) OR (user_id = $293 AND (encrypted_id = $294)) OR (user_id = $295 AND (encrypted_id = $296)) OR (user_id = $297 AND (encrypted_id = $298)) OR (user_id = $299 AND (encrypted_id = $300)) OR (user_id = $301 AND (encrypted_id = $302)) OR (user_id = $303 AND (encrypted_id = $304)) OR (user_id = $305 AND (encrypted_id = $306)) OR (user_id = $307 AND (encrypted_id = $308)) OR (user_id = $309 AND (encrypted_id = $310)) OR (user_id = $311 AND (encrypted_id = $312)) OR (user_id = $313 AND (encrypted_id = $314)) OR (user_id = $315 AND (encrypted_id = $316)) OR (user_id = $317 AND (encrypted_id = $318)) OR (user_id = $319 AND (encrypted_id = $320)) OR (user_id = $321 AND (encrypted_id = $322)) OR (user_id = $323 AND (encrypted_id = $324)) OR (user_id = $325 AND (encrypted_id = $326)) OR (user_id = $327 AND (encrypted_id = $328)) OR (user_id = $329 AND (encrypted_id = $330)) OR (user_id = $331 AND (encrypted_id = $332)) OR (user_id = $333 AND (encrypted_id = $334)) OR (user_id = $335 AND (encrypted_id = $336)) OR (user_id = $337 AND (encrypted_id = $338)) OR (user_id = $339 AND (encrypted_id = $340)) OR (user_id = $341 AND (encrypted_id = $342)) OR (user_id = $343 AND (encrypted_id = $344)) OR (user_id = $345 AND (encrypted_id = $346)) OR (user_id = $347 AND (encrypted_id = $348)) OR (user_id = $349 AND (encrypted_id = $350)) OR (user_id = $351 AND (encrypted_id = $352)) OR (user_id = $353 AND (encrypted_id = $354)) OR (user_id = $355 AND (encrypted_id = $356)) OR (user_id = $357 AND (encrypted_id = $358)) OR (user_id = $359 AND (encrypted_id = $360)) OR (user_id = $361 AND (encrypted_id = $362)) OR (user_id = $363 AND (encrypted_id = $364)) OR (user_id = $365 AND (encrypted_id = $366)) OR (user_id = $367 AND (encrypted_id = $368)) OR (user_id = $369 AND (encrypted_id = $370)) OR (user_id = $371 AND (encrypted_id = $372)) OR (user_id = $373 AND (encrypted_id = $374)) OR (user_id = $375 AND (encrypted_id = $376)) OR (user_id = $377 AND (encrypted_id = $378)) OR (user_id = $379 AND (encrypted_id = $380)) OR (user_id = $381 AND (encrypted_id = $382)) OR (user_id = $383 AND (encrypted_id = $384)) OR (user_id = $385 AND (encrypted_id = $386)) OR (user_id = $387 AND (encrypted_id = $388)) OR (user_id = $389 AND (encrypted_id = $390)) OR (user_id = $391 AND (encrypted_id = $392)) OR (user_id = $393 AND (encrypted_id = $394)) OR (user_id = $395 AND (encrypted_id = $396)) OR (user_id = $397 AND (encrypted_id = $398)) OR (user_id = $399 AND (encrypted_id = $400)) OR (user_id = $401 AND (encrypted_id = $402)) OR (user_id = $403 AND (encrypted_id = $404)) OR (user_id = $405 AND (encrypted_id = $406)) OR (user_id = $407 AND (encrypted_id = $408)) OR (user_id = $409 AND (encrypted_id = $410)) OR (user_id = $411 AND (encrypted_id = $412)) OR (user_id = $413 AND (encrypted_id = $414)) OR (user_id = $415 AND (encrypted_id = $416)) OR (user_id = $417 AND (encrypted_id = $418)) OR (user_id = $419 AND (encrypted_id = $420)) OR (user_id = $421 AND (encrypted_id = $422)) OR (user_id = $423 AND (encrypted_id = $424)) OR (user_id = $425 AND (encrypted_id = $426)) OR (user_id = $427 AND (encrypted_id = $428)) OR (user_id = $429 AND (encrypted_id = $430)) OR (user_id = $431 AND (encrypted_id = $432)) OR (user_id = $433 AND (encrypted_id = $434)) OR (user_id = $435 AND (encrypted_id = $436)) OR (user_id = $437 AND (encrypted_id = $438)) OR (user_id = $439 AND (encrypted_id = $440)) OR (user_id = $441 AND (encrypted_id = $442)) OR (user_id = $443 AND (encrypted_id = $444)) OR (user_id = $445 AND (encrypted_id = $446)) OR (user_id = $447 AND (encrypted_id = $448)) OR (user_id = $449 AND (encrypted_id = $450)) OR (user_id = $451 AND (encrypted_id = $452)) OR (user_id = $453 AND (encrypted_id = $454)) OR (user_id = $455 AND (encrypted_id = $456)) OR (user_id = $457 AND (encrypted_id = $458)) OR (user_id = $459 AND (encrypted_id = $460)) OR (user_id = $461 AND (encrypted_id = $462)) OR (user_id = $463 AND (encrypted_id = $464)) OR (user_id = $465 AND (encrypted_id = $466)) OR (user_id = $467 AND (encrypted_id = $468)) OR (user_id = $469 AND (encrypted_id = $470)) OR (user_id = $471 AND (encrypted_id = $472)) OR (user_id = $473 AND (encrypted_id = $474)) OR (user_id = $475 AND (encrypted_id = $476)) OR (user_id = $477 AND (encrypted_id = $478)) OR (user_id = $479 AND (encrypted_id = $480)) OR (user_id = $481 AND (encrypted_id = $482)) OR (user_id = $483 AND (encrypted_id = $484)) OR (user_id = $485 AND (encrypted_id = $486)) OR (user_id = $487 AND (encrypted_id = $488)) OR (user_id = $489 AND (encrypted_id = $490)) OR (user_id = $491 AND (encrypted_id = $492)) OR (user_id = $493 AND (encrypted_id = $494)) OR (user_id = $495 AND (encrypted_id = $496)) OR (user_id = $497 AND (encrypted_id = $498)) OR (user_id = $499 AND (encrypted_id = $500)) OR (user_id = $501 AND (encrypted_id = $502)) OR (user_id = $503 AND (encrypted_id = $504)) OR (user_id = $505 AND (encrypted_id = $506)) OR (user_id = $507 AND (encrypted_id = $508)) OR (user_id = $509 AND (encrypted_id = $510)) OR (user_id = $511 AND (encrypted_id = $512)) OR (user_id = $513 AND (encrypted_id = $514)) OR (user_id = $515 AND (encrypted_id = $516)) OR (user_id = $517 AND (encrypted_id = $518)) OR (user_id = $519 AND (encrypted_id = $520)) OR (user_id = $521 AND (encrypted_id = $522)) OR (user_id = $523 AND (encrypted_id = $524)) OR (user_id = $525 AND (encrypted_id = $526)) OR (user_id = $527 AND (encrypted_id = $528)) OR (user_id = $529 AND (encrypted_id = $530)) OR (user_id = $531 AND (encrypted_id = $532)) OR (user_id = $533 AND (encrypted_id = $534)) OR (user_id = $535 AND (encrypted_id = $536)) OR (user_id = $537 AND (encrypted_id = $538)) OR (user_id = $539 AND (encrypted_id = $540)) OR (user_id = $541 AND (encrypted_id = $542)) OR (user_id = $543 AND (encrypted_id = $544)) OR (user_id = $545 AND (encrypted_id = $546)) OR (user_id = $547 AND (encrypted_id = $548)) OR (user_id = $549 AND (encrypted_id = $550)) OR (user_id = $551 AND (encrypted_id = $552)) OR (user_id = $553 AND (encrypted_id = $554)) OR (user_id = $555 AND (encrypted_id = $556)) OR (user_id = $557 AND (encrypted_id = $558)) OR (user_id = $559 AND (encrypted_id = $560)) OR (user_id = $561 AND (encrypted_id = $562)) OR (user_id = $563 AND (encrypted_id = $564)) OR (user_id = $565 AND (encrypted_id = $566)) OR (user_id = $567 AND (encrypted_id = $568)) OR (user_id = $569 AND (encrypted_id = $570)) OR (user_id = $571 AND (encrypted_id = $572)) OR (user_id = $573 AND (encrypted_id = $574)) OR (user_id = $575 AND (encrypted_id = $576)) OR (user_id = $577 AND (encrypted_id = $578)) OR (user_id = $579 AND (encrypted_id = $580)) OR (user_id = $581 AND (encrypted_id = $582)) OR (user_id = $583 AND (encrypted_id = $584)) OR (user_id = $585 AND (encrypted_id = $586)) OR (user_id = $587 AND (encrypted_id = $588)) OR (user_id = $589 AND (encrypted_id = $590)) OR (user_id = $591 AND (encrypted_id = $592)) OR (user_id = $593 AND (encrypted_id = $594)) OR (user_id = $595 AND (encrypted_id = $596)) OR (user_id = $597 AND (encrypted_id = $598)) OR (user_id = $599 AND (encrypted_id = $600)) OR (user_id = $601 AND (encrypted_id = $602)) OR (user_id = $603 AND (encrypted_id = $604)) OR (user_id = $605 AND (encrypted_id = $606)) OR (user_id = $607 AND (encrypted_id = $608)) OR (user_id = $609 AND (encrypted_id = $610)) OR (user_id = $611 AND (encrypted_id = $612)) OR (user_id = $613 AND (encrypted_id = $614)) OR (user_id = $615 AND (encrypted_id = $616)) OR (user_id = $617 AND (encrypted_id = $618)) OR (user_id = $619 AND (encrypted_id = $620)) OR (user_id = $621 AND (encrypted_id = $622)) OR (user_id = $623 AND (encrypted_id = $624)) OR (user_id = $625 AND (encrypted_id = $626)) OR (user_id = $627 AND (encrypted_id = $628)) OR (user_id = $629 AND (encrypted_id = $630)) OR (user_id = $631 AND (encrypted_id = $632)) OR (user_id = $633 AND (encrypted_id = $634)) OR (user_id = $635 AND (encrypted_id = $636)) OR (user_id = $637 AND (encrypted_id = $638)) OR (user_id = $639 AND (encrypted_id = $640)) OR (user_id = $641 AND (encrypted_id = $642)) OR (user_id = $643 AND (encrypted_id = $644)) OR (user_id = $645 AND (encrypted_id = $646)) OR (user_id = $647 AND (encrypted_id = $648)) OR (user_id = $649 AND (encrypted_id = $650)) OR (user_id = $651 AND (encrypted_id = $652)) OR (user_id = $653 AND (encrypted_id = $654)) OR (user_id = $655 AND (encrypted_id = $656)) OR (user_id = $657 AND (encrypted_id = $658)) OR (user_id = $659 AND (encrypted_id = $660)) OR (user_id = $661 AND (encrypted_id = $662)) OR (user_id = $663 AND (encrypted_id = $664)) OR (user_id = $665 AND (encrypted_id = $666)) OR (user_id = $667 AND (encrypted_id = $668)) OR (user_id = $669 AND (encrypted_id = $670)) OR (user_id = $671 AND (encrypted_id = $672)) OR (user_id = $673 AND (encrypted_id = $674)) OR (user_id = $675 AND (encrypted_id = $676)) OR (user_id = $677 AND (encrypted_id = $678)) OR (user_id = $679 AND (encrypted_id = $680)) OR (user_id = $681 AND (encrypted_id = $682)) OR (user_id = $683 AND (encrypted_id = $684)) OR (user_id = $685 AND (encrypted_id = $686)) OR (user_id = $687 AND (encrypted_id = $688)) OR (user_id = $689 AND (encrypted_id = $690)) OR (user_id = $691 AND (encrypted_id = $692)) OR (user_id = $693 AND (encrypted_id = $694)) OR (user_id = $695 AND (encrypted_id = $696)) OR (user_id = $697 AND (encrypted_id = $698)) OR (user_id = $699 AND (encrypted_id = $700)) OR (user_id = $701 AND (encrypted_id = $702)) OR (user_id = $703 AND (encrypted_id = $704)) OR (user_id = $705 AND (encrypted_id = $706)) OR (user_id = $707 AND (date = $708 OR encrypted_id = $709)) OR (user_id = $710 AND (date = $711 OR encrypted_id = $712)) OR (user_id = $713 AND (date = $714 OR encrypted_id = $715)) OR (user_id = $716 AND (date = $717 OR encrypted_id = $718)) OR (user_id = $719 AND (date = $720 OR encrypted_id = $721)) OR (user_id = $722 AND (date = $723 OR encrypted_id = $724)) OR (user_id = $725 AND (date = $726 OR encrypted_id = $727)) OR (user_id = $728 AND (date = $729 OR encrypted_id = $730)) OR (user_id = $731 AND (date = $732 OR encrypted_id = $733)) OR (user_id = $734 AND (date = $735 OR encrypted_id = $736)) OR (user_id = $737 AND (date = $738 OR encrypted_id = $739)) OR (user_id = $740 AND (date = $741 OR encrypted_id = $742)) OR (user_id = $743 AND (date = $744 OR encrypted_id = $745)) OR (user_id = $746 AND (date = $747 OR encrypted_id = $748)) OR (user_id = $749 AND (date = $750 OR encrypted_id = $751)) OR (user_id = $752 AND (date = $753 OR encrypted_id = $754)) OR (user_id = $755 AND (date = $756 OR encrypted_id = $757)) OR (user_id = $758 AND (date = $759 OR encrypted_id = $760)) OR (user_id = $761 AND (date = $762 OR encrypted_id = $763)) OR (user_id = $764 AND (date = $765 OR encrypted_id = $766)) OR (user_id = $767 AND (date = $768 OR encrypted_id = $769)) OR (user_id = $770 AND (date = $771 OR encrypted_id = $772)) OR (user_id = $773 AND (date = $774 OR encrypted_id = $775)) OR (user_id = $776 AND (date = $777 OR encrypted_id = $778)) OR (user_id = $779 AND (date = $780 OR encrypted_id = $781)) OR (user_id = $782 AND (date = $783 OR encrypted_id = $784)) OR (user_id = $785 AND (date = $786 OR encrypted_id = $787)) OR (user_id = $788 AND (date = $789 OR encrypted_id = $790)) OR (user_id = $791 AND (date = $792 OR encrypted_id = $793)) OR (user_id = $794 AND (date = $795 OR encrypted_id = $796)) OR (user_id = $797 AND (date = $798 OR encrypted_id = $799)) OR (user_id = $800 AND (encrypted_id = $801)) OR (user_id = $802 AND (encrypted_id = $803)) OR (user_id = $804 AND (encrypted_id = $805)) OR (user_id = $806 AND (encrypted_id = $807)) OR (user_id = $808 AND (encrypted_id = $809)) OR (user_id = $810 AND (encrypted_id = $811)) OR (user_id = $812 AND (encrypted_id = $813)) OR (user_id = $814 AND (encrypted_id = $815)) OR (user_id = $816 AND (encrypted_id = $817)) OR (user_id = $818 AND (encrypted_id = $819)) OR (user_id = $820 AND (encrypted_id = $821)) OR (user_id = $822 AND (encrypted_id = $823)) OR (user_id = $824 AND (encrypted_id = $825)) OR (user_id = $826 AND (encrypted_id = $827)) OR (user_id = $828 AND (encrypted_id = $829)) OR (user_id = $830 AND (encrypted_id = $831)) OR (user_id = $832 AND (encrypted_id = $833)) OR (user_id = $834 AND (encrypted_id = $835)) OR (user_id = $836 AND (encrypted_id = $837)) OR (user_id = $838 AND (encrypted_id = $839)) OR (user_id = $840 AND (encrypted_id = $841)) OR (user_id = $842 AND (encrypted_id = $843)) OR (user_id = $844 AND (encrypted_id = $845)) OR (user_id = $846 AND (encrypted_id = $847)) OR (user_id = $848 AND (encrypted_id = $849)) OR (user_id = $850 AND (encrypted_id = $851)) OR (user_id = $852 AND (encrypted_id = $853)) OR (user_id = $854 AND (encrypted_id = $855)) OR (user_id = $856 AND (encrypted_id = $857)) OR (user_id = $858 AND (encrypted_id = $859)) OR (user_id = $860 AND (encrypted_id = $861)) OR (user_id = $862 AND (encrypted_id = $863)) OR (user_id = $864 AND (encrypted_id = $865)) OR (user_id = $866 AND (encrypted_id = $867)) OR (user_id = $868 AND (encrypted_id = $869)) OR (user_id = $870 AND (encrypted_id = $871)) OR (user_id = $872 AND (encrypted_id = $873)) OR (user_id = $874 AND (encrypted_id = $875)) OR (user_id = $876 AND (encrypted_id = $877)) OR (user_id = $878 AND (encrypted_id = $879)) OR (user_id = $880 AND (encrypted_id = $881)) OR (user_id = $882 AND (encrypted_id = $883)) OR (user_id = $884 AND (encrypted_id = $885)) OR (user_id = $886 AND (encrypted_id = $887)) OR (user_id = $888 AND (encrypted_id = $889)) OR (user_id = $890 AND (encrypted_id = $891)) OR (user_id = $892 AND (encrypted_id = $893)) OR (user_id = $894 AND (encrypted_id = $895)) OR (user_id = $896 AND (encrypted_id = $897)) OR (user_id = $898 AND (encrypted_id = $899)) OR (user_id = $900 AND (encrypted_id = $901)) OR (user_id = $902 AND (encrypted_id = $903)) OR (user_id = $904 AND (encrypted_id = $905)) OR (user_id = $906 AND (encrypted_id = $907)) OR (user_id = $908 AND (encrypted_id = $909)) OR (user_id = $910 AND (encrypted_id = $911)) OR (user_id = $912 AND (encrypted_id = $913)) OR (user_id = $914 AND (encrypted_id = $915)) OR (user_id = $916 AND (encrypted_id = $917)) OR (user_id = $918 AND (encrypted_id = $919)) OR (user_id = $920 AND (encrypted_id = $921)) OR (user_id = $922 AND (encrypted_id = $923)) OR (user_id = $924 AND (encrypted_id = $925)) OR (user_id = $926 AND (encrypted_id = $927)) OR (user_id = $928 AND (encrypted_id = $929)) OR (user_id = $930 AND (encrypted_id = $931)) OR (user_id = $932 AND (encrypted_id = $933)) OR (user_id = $934 AND (encrypted_id = $935)) OR (user_id = $936 AND (encrypted_id = $937)) OR (user_id = $938 AND (encrypted_id = $939)) OR (user_id = $940 AND (encrypted_id = $941)) OR (user_id = $942 AND (encrypted_id = $943)) OR (user_id = $944 AND (encrypted_id = $945)) OR (user_id = $946 AND (encrypted_id = $947)) OR (user_id = $948 AND (encrypted_id = $949)) OR (user_id = $950 AND (encrypted_id = $951)) OR (user_id = $952 AND (encrypted_id = $953)) OR (user_id = $954 AND (encrypted_id = $955)) OR (user_id = $956 AND (encrypted_id = $957)) OR (user_id = $958 AND (encrypted_id = $959)) OR (user_id = $960 AND (encrypted_id = $961)) OR (user_id = $962 AND (encrypted_id = $963)) OR (user_id = $964 AND (encrypted_id = $965)) OR (user_id = $966 AND (encrypted_id = $967)) OR (user_id = $968 AND (encrypted_id = $969)) OR (user_id = $970 AND (encrypted_id = $971)) OR (user_id = $972 AND (encrypted_id = $973)) OR (user_id = $974 AND (encrypted_id = $975)) OR (user_id = $976 AND (encrypted_id = $977)) OR (user_id = $978 AND (encrypted_id = $979)) OR (user_id = $980 AND (encrypted_id = $981)) OR (user_id = $982 AND (encrypted_id = $983)) OR (user_id = $984 AND (encrypted_id = $985)) OR (user_id = $986 AND (encrypted_id = $987)) OR (user_id = $988 AND (encrypted_id = $989)) OR (user_id = $990 AND (encrypted_id = $991)) OR (user_id = $992 AND (encrypted_id = $993)) OR (user_id = $994 AND (encrypted_id = $995)) OR (user_id = $996 AND (encrypted_id = $997)) OR (user_id = $998 AND (encrypted_id = $999)) OR (user_id = $1000 AND (encrypted_id = $1001)) OR (user_id = $1002 AND (encrypted_id = $1003)) OR (user_id = $1004 AND (encrypted_id = $1005)) OR (user_id = $1006 AND (encrypted_id = $1007)) OR (user_id = $1008 AND (encrypted_id = $1009)) OR (user_id = $1010 AND (encrypted_id = $1011)) OR (user_id = $1012 AND (encrypted_id = $1013)) OR (user_id = $1014 AND (encrypted_id = $1015)) OR (user_id = $1016 AND (encrypted_id = $1017)) OR (user_id = $1018 AND (encrypted_id = $1019)) OR (user_id = $1020 AND (encrypted_id = $1021)) OR (user_id = $1022 AND (encrypted_id = $1023)) OR (user_id = $1024 AND (encrypted_id = $1025)) OR (user_id = $1026 AND (encrypted_id = $1027)) OR (user_id = $1028 AND (encrypted_id = $1029)) OR (user_id = $1030 AND (encrypted_id = $1031)) OR (user_id = $1032 AND (encrypted_id = $1033)) OR (user_id = $1034 AND (encrypted_id = $1035)) OR (user_id = $1036 AND (encrypted_id = $1037)) OR (user_id = $1038 AND (encrypted_id = $1039)) OR (user_id = $1040 AND (encrypted_id = $1041)) OR (user_id = $1042 AND (encrypted_id = $1043)) OR (user_id = $1044 AND (encrypted_id = $1045)) OR (user_id = $1046 AND (encrypted_id = $1047)) OR (user_id = $1048 AND (encrypted_id = $1049)) OR (user_id = $1050 AND (encrypted_id = $1051)) OR (user_id = $1052 AND (encrypted_id = $1053)) OR (user_id = $1054 AND (encrypted_id = $1055)) OR (user_id = $1056 AND (encrypted_id = $1057)) OR (user_id = $1058 AND (encrypted_id = $1059)) OR (user_id = $1060 AND (encrypted_id = $1061)) OR (user_id = $1062 AND (encrypted_id = $1063)) OR (user_id = $1064 AND (encrypted_id = $1065)) OR (user_id = $1066 AND (encrypted_id = $1067)) OR (user_id = $1068 AND (encrypted_id = $1069)) OR (user_id = $1070 AND (encrypted_id = $1071)) OR (user_id = $1072 AND (encrypted_id = $1073)) OR (user_id = $1074 AND (encrypted_id = $1075)) OR (user_id = $1076 AND (encrypted_id = $1077)) OR (user_id = $1078 AND (encrypted_id = $1079)) OR (user_id = $1080 AND (encrypted_id = $1081)) OR (user_id = $1082 AND (encrypted_id = $1083)) OR (user_id = $1084 AND (encrypted_id = $1085)) OR (user_id = $1086 AND (encrypted_id = $1087)) OR (user_id = $1088 AND (encrypted_id = $1089)) OR (user_id = $1090 AND (encrypted_id = $1091)) OR (user_id = $1092 AND (encrypted_id = $1093)) OR (user_id = $1094 AND (encrypted_id = $1095)) OR (user_id = $1096 AND (encrypted_id = $1097)) OR (user_id = $1098 AND (encrypted_id = $1099)) OR (user_id = $1100 AND (encrypted_id = $1101)) OR (user_id = $1102 AND (encrypted_id = $1103)) OR (user_id = $1104 AND (encrypted_id = $1105)) OR (user_id = $1106 AND (encrypted_id = $1107)) OR (user_id = $1108 AND (encrypted_id = $1109)) OR (user_id = $1110 AND (encrypted_id = $1111)) OR (user_id = $1112 AND (encrypted_id = $1113)) OR (user_id = $1114 AND (encrypted_id = $1115)) OR (user_id = $1116 AND (encrypted_id = $1117)) OR (user_id = $1118 AND (encrypted_id = $1119)) OR (user_id = $1120 AND (encrypted_id = $1121)) OR (user_id = $1122 AND (encrypted_id = $1123)) OR (user_id = $1124 AND (encrypted_id = $1125)) OR (user_id = $1126 AND (encrypted_id = $1127)) OR (user_id = $1128 AND (encrypted_id = $1129)) OR (user_id = $1130 AND (encrypted_id = $1131)) OR (user_id = $1132 AND (encrypted_id = $1133)) OR (user_id = $1134 AND (encrypted_id = $1135)) OR (user_id = $1136 AND (date = $1137 OR encrypted_id = $1138)) OR (user_id = $1139 AND (encrypted_id = $1140)) OR (user_id = $1141 AND (encrypted_id = $1142)) OR (user_id = $1143 AND (encrypted_id = $1144)) OR (user_id = $1145 AND (encrypted_id = $1146)) OR (user_id = $1147 AND (encrypted_id = $1148)) OR (user_id = $1149 AND (encrypted_id = $1150)) OR (user_id = $1151 AND (encrypted_id = $1152)) OR (user_id = $1153 AND (encrypted_id = $1154)) OR (user_id = $1155 AND (encrypted_id = $1156)) OR (user_id = $1157 AND (encrypted_id = $1158)) OR (user_id = $1159 AND (encrypted_id = $1160)) OR (user_id = $1161 AND (encrypted_id = $1162)) OR (user_id = $1163 AND (encrypted_id = $1164)) OR (user_id = $1165 AND (encrypted_id = $1166)) OR (user_id = $1167 AND (encrypted_id = $1168)) OR (user_id = $1169 AND (encrypted_id = $1170)) OR (user_id = $1171 AND (encrypted_id = $1172)) OR (user_id = $1173 AND (encrypted_id = $1174)) OR (user_id = $1175 AND (encrypted_id = $1176)) OR (user_id = $1177 AND (encrypted_id = $1178)) OR (user_id = $1179 AND (encrypted_id = $1180)) OR (user_id = $1181 AND (encrypted_id = $1182)) OR (user_id = $1183 AND (encrypted_id = $1184)) OR (user_id = $1185 AND (encrypted_id = $1186)) OR (user_id = $1187 AND (encrypted_id = $1188)) OR (user_id = $1189 AND (encrypted_id = $1190)) OR (user_id = $1191 AND (encrypted_id = $1192)) OR (user_id = $1193 AND (encrypted_id = $1194)) OR (user_id = $1195 AND (encrypted_id = $1196)) OR (user_id = $1197 AND (encrypted_id = $1198)) OR (user_id = $1199 AND (encrypted_id = $1200)) OR (user_id = $1201 AND (encrypted_id = $1202)) OR (user_id = $1203 AND (encrypted_id = $1204)) OR (user_id = $1205 AND (encrypted_id = $1206)) OR (user_id = $1207 AND (encrypted_id = $1208)) OR (user_id = $1209 AND (encrypted_id = $1210)) OR (user_id = $1211 AND (encrypted_id = $1212)) OR (user_id = $1213 AND (encrypted_id = $1214)) OR (user_id = $1215 AND (encrypted_id = $1216)) OR (user_id = $1217 AND (encrypted_id = $1218)) OR (user_id = $1219 AND (encrypted_id = $1220)) OR (user_id = $1221 AND (encrypted_id = $1222)) OR (user_id = $1223 AND (encrypted_id = $1224)) OR (user_id = $1225 AND (encrypted_id = $1226)) OR (user_id = $1227 AND (encrypted_id = $1228)) OR (user_id = $1229 AND (encrypted_id = $1230)) OR (user_id = $1231 AND (encrypted_id = $1232)) OR (user_id = $1233 AND (encrypted_id = $1234)) OR (user_id = $1235 AND (encrypted_id = $1236)) OR (user_id = $1237 AND (encrypted_id = $1238)) OR (user_id = $1239 AND (encrypted_id = $1240)) OR (user_id = $1241 AND (encrypted_id = $1242)) OR (user_id = $1243 AND (encrypted_id = $1244)) OR (user_id = $1245 AND (encrypted_id = $1246)) OR (user_id = $1247 AND (encrypted_id = $1248)) OR (user_id = $1249 AND (encrypted_id = $1250)) OR (user_id = $1251 AND (encrypted_id = $1252)) OR (user_id = $1253 AND (encrypted_id = $1254)) OR (user_id = $1255 AND (encrypted_id = $1256)) OR (user_id = $1257 AND (encrypted_id = $1258)) OR (user_id = $1259 AND (encrypted_id = $1260)) OR (user_id = $1261 AND (encrypted_id = $1262)) OR (user_id = $1263 AND (encrypted_id = $1264)) OR (user_id = $1265 AND (encrypted_id = $1266)) OR (user_id = $1267 AND (encrypted_id = $1268)) OR (user_id = $1269 AND (encrypted_id = $1270)) OR (user_id = $1271 AND (encrypted_id = $1272)) OR (user_id = $1273 AND (encrypted_id = $1274)) OR (user_id = $1275 AND (encrypted_id = $1276)) OR (user_id = $1277 AND (encrypted_id = $1278)) OR (user_id = $1279 AND (encrypted_id = $1280)) OR (user_id = $1281 AND (encrypted_id = $1282)) OR (user_id = $1283 AND (encrypted_id = $1284)) OR (user_id = $1285 AND (encrypted_id = $1286)) OR (user_id = $1287 AND (encrypted_id = $1288)) OR (user_id = $1289 AND (encrypted_id = $1290)) OR (user_id = $1291 AND (encrypted_id = $1292)) OR (user_id = $1293 AND (encrypted_id = $1294)) OR (user_id = $1295 AND (encrypted_id = $1296)) OR (user_id = $1297 AND (encrypted_id = $1298)) OR (user_id = $1299 AND (encrypted_id = $1300)) OR (user_id = $1301 AND (encrypted_id = $1302)) OR (user_id = $1303 AND (encrypted_id = $1304)) OR (user_id = $1305 AND (encrypted_id = $1306)) OR (user_id = $1307 AND (encrypted_id = $1308)) OR (user_id = $1309 AND (encrypted_id = $1310)) OR (user_id = $1311 AND (encrypted_id = $1312)) OR (user_id = $1313 AND (encrypted_id = $1314)) OR (user_id = $1315 AND (encrypted_id = $1316)) OR (user_id = $1317 AND (encrypted_id = $1318)) OR (user_id = $1319 AND (encrypted_id = $1320)) OR (user_id = $1321 AND (encrypted_id = $1322)) OR (user_id = $1323 AND (encrypted_id = $1324)) OR (user_id = $1325 AND (encrypted_id = $1326)) OR (user_id = $1327 AND (encrypted_id = $1328)) OR (user_id = $1329 AND (encrypted_id = $1330)) OR (user_id = $1331 AND (encrypted_id = $1332)) OR (user_id = $1333 AND (encrypted_id = $1334)) OR (user_id = $1335 AND (encrypted_id = $1336)) OR (user_id = $1337 AND (encrypted_id = $1338)) OR (user_id = $1339 AND (encrypted_id = $1340)) OR (user_id = $1341 AND (encrypted_id = $1342)) OR (user_id = $1343 AND (encrypted_id = $1344)) OR (user_id = $1345 AND (encrypted_id = $1346)) OR (user_id = $1347 AND (encrypted_id = $1348)) OR (user_id = $1349 AND (encrypted_id = $1350)) OR (user_id = $1351 AND (encrypted_id = $1352)) OR (user_id = $1353 AND (encrypted_id = $1354)) OR (user_id = $1355 AND (encrypted_id = $1356)) OR (user_id = $1357 AND (encrypted_id = $1358)) OR (user_id = $1359 AND (encrypted_id = $1360)) OR (user_id = $1361 AND (encrypted_id = $1362)) OR (user_id = $1363 AND (encrypted_id = $1364)) OR (user_id = $1365 AND (encrypted_id = $1366)) OR (user_id = $1367 AND (encrypted_id = $1368)) OR (user_id = $1369 AND (encrypted_id = $1370)) OR (user_id = $1371 AND (encrypted_id = $1372)) OR (user_id = $1373 AND (encrypted_id = $1374)) OR (user_id = $1375 AND (encrypted_id = $1376))
hishtory-postgres  | 2024-08-08 16:58:01.484 UTC [10536] LOG:  could not send data to client: Broken pipe
hishtory-postgres  | 2024-08-08 16:58:01.484 UTC [10536] FATAL:  connection to client lost
hishtory-postgres  | 2024-08-08 16:58:31.086 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 16:59:41.912 UTC [10550] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-08 17:01:27.731 UTC [27] LOG:  checkpoint complete: wrote 1535 buffers (9.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=176.641 s, sync=0.002 s, total=176.646 s; sync files=24, longest=0.001 s, average=0.001 s; distance=14669 kB, estimate=20389 kB; lsn=59/8FD3E9C0, redo lsn=59/8EEAA688
hishtory-postgres  | 2024-08-08 17:03:31.825 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 17:05:27.754 UTC [27] LOG:  checkpoint complete: wrote 1161 buffers (7.1%); 0 WAL file(s) added, 0 removed, 1 recycled; write=115.924 s, sync=0.002 s, total=115.929 s; sync files=15, longest=0.001 s, average=0.001 s; distance=15104 kB, estimate=19861 kB; lsn=59/8FE4C548, redo lsn=59/8FD6AA58
hishtory-postgres  | 2024-08-08 17:06:15.504 UTC [10558] ERROR:  canceling statement due to user request
hishtory-postgres  | 2024-08-08 17:06:15.504 UTC [10558] STATEMENT:  DELETE FROM "enc_history_entries" WHERE false OR (user_id = $1 AND (encrypted_id = $2)) OR (user_id = $3 AND (encrypted_id = $4)) OR (user_id = $5 AND (encrypted_id = $6)) OR (user_id = $7 AND (encrypted_id = $8)) OR (user_id = $9 AND (encrypted_id = $10)) OR (user_id = $11 AND (encrypted_id = $12)) OR (user_id = $13 AND (encrypted_id = $14)) OR (user_id = $15 AND (encrypted_id = $16)) OR (user_id = $17 AND (encrypted_id = $18)) OR (user_id = $19 AND (encrypted_id = $20)) OR (user_id = $21 AND (encrypted_id = $22)) OR (user_id = $23 AND (encrypted_id = $24)) OR (user_id = $25 AND (encrypted_id = $26)) OR (user_id = $27 AND (encrypted_id = $28)) OR (user_id = $29 AND (encrypted_id = $30)) OR (user_id = $31 AND (encrypted_id = $32)) OR (user_id = $33 AND (encrypted_id = $34)) OR (user_id = $35 AND (encrypted_id = $36)) OR (user_id = $37 AND (encrypted_id = $38)) OR (user_id = $39 AND (encrypted_id = $40)) OR (user_id = $41 AND (encrypted_id = $42)) OR (user_id = $43 AND (encrypted_id = $44)) OR (user_id = $45 AND (encrypted_id = $46)) OR (user_id = $47 AND (encrypted_id = $48)) OR (user_id = $49 AND (encrypted_id = $50)) OR (user_id = $51 AND (encrypted_id = $52)) OR (user_id = $53 AND (encrypted_id = $54)) OR (user_id = $55 AND (encrypted_id = $56)) OR (user_id = $57 AND (encrypted_id = $58)) OR (user_id = $59 AND (encrypted_id = $60)) OR (user_id = $61 AND (encrypted_id = $62)) OR (user_id = $63 AND (encrypted_id = $64)) OR (user_id = $65 AND (encrypted_id = $66)) OR (user_id = $67 AND (encrypted_id = $68)) OR (user_id = $69 AND (encrypted_id = $70)) OR (user_id = $71 AND (encrypted_id = $72)) OR (user_id = $73 AND (encrypted_id = $74)) OR (user_id = $75 AND (encrypted_id = $76)) OR (user_id = $77 AND (encrypted_id = $78)) OR (user_id = $79 AND (encrypted_id = $80)) OR (user_id = $81 AND (encrypted_id = $82)) OR (user_id = $83 AND (encrypted_id = $84)) OR (user_id = $85 AND (encrypted_id = $86)) OR (user_id = $87 AND (encrypted_id = $88)) OR (user_id = $89 AND (encrypted_id = $90)) OR (user_id = $91 AND (encrypted_id = $92)) OR (user_id = $93 AND (encrypted_id = $94)) OR (user_id = $95 AND (encrypted_id = $96)) OR (user_id = $97 AND (encrypted_id = $98)) OR (user_id = $99 AND (encrypted_id = $100)) OR (user_id = $101 AND (encrypted_id = $102)) OR (user_id = $103 AND (encrypted_id = $104)) OR (user_id = $105 AND (encrypted_id = $106)) OR (user_id = $107 AND (encrypted_id = $108)) OR (user_id = $109 AND (encrypted_id = $110)) OR (user_id = $111 AND (encrypted_id = $112)) OR (user_id = $113 AND (encrypted_id = $114)) OR (user_id = $115 AND (encrypted_id = $116)) OR (user_id = $117 AND (encrypted_id = $118)) OR (user_id = $119 AND (encrypted_id = $120)) OR (user_id = $121 AND (encrypted_id = $122)) OR (user_id = $123 AND (encrypted_id = $124)) OR (user_id = $125 AND (encrypted_id = $126)) OR (user_id = $127 AND (encrypted_id = $128)) OR (user_id = $129 AND (encrypted_id = $130)) OR (user_id = $131 AND (encrypted_id = $132)) OR (user_id = $133 AND (encrypted_id = $134)) OR (user_id = $135 AND (encrypted_id = $136)) OR (user_id = $137 AND (encrypted_id = $138)) OR (user_id = $139 AND (encrypted_id = $140)) OR (user_id = $141 AND (encrypted_id = $142)) OR (user_id = $143 AND (encrypted_id = $144)) OR (user_id = $145 AND (date = $146 OR encrypted_id = $147)) OR (user_id = $148 AND (encrypted_id = $149)) OR (user_id = $150 AND (encrypted_id = $151)) OR (user_id = $152 AND (encrypted_id = $153)) OR (user_id = $154 AND (encrypted_id = $155)) OR (user_id = $156 AND (encrypted_id = $157)) OR (user_id = $158 AND (encrypted_id = $159)) OR (user_id = $160 AND (encrypted_id = $161)) OR (user_id = $162 AND (encrypted_id = $163)) OR (user_id = $164 AND (encrypted_id = $165)) OR (user_id = $166 AND (encrypted_id = $167)) OR (user_id = $168 AND (encrypted_id = $169)) OR (user_id = $170 AND (encrypted_id = $171)) OR (user_id = $172 AND (encrypted_id = $173)) OR (user_id = $174 AND (encrypted_id = $175)) OR (user_id = $176 AND (encrypted_id = $177)) OR (user_id = $178 AND (encrypted_id = $179)) OR (user_id = $180 AND (encrypted_id = $181)) OR (user_id = $182 AND (encrypted_id = $183)) OR (user_id = $184 AND (encrypted_id = $185)) OR (user_id = $186 AND (encrypted_id = $187)) OR (user_id = $188 AND (encrypted_id = $189)) OR (user_id = $190 AND (encrypted_id = $191)) OR (user_id = $192 AND (encrypted_id = $193)) OR (user_id = $194 AND (encrypted_id = $195)) OR (user_id = $196 AND (encrypted_id = $197)) OR (user_id = $198 AND (encrypted_id = $199)) OR (user_id = $200 AND (encrypted_id = $201)) OR (user_id = $202 AND (encrypted_id = $203)) OR (user_id = $204 AND (encrypted_id = $205)) OR (user_id = $206 AND (encrypted_id = $207)) OR (user_id = $208 AND (encrypted_id = $209)) OR (user_id = $210 AND (encrypted_id = $211)) OR (user_id = $212 AND (encrypted_id = $213)) OR (user_id = $214 AND (encrypted_id = $215)) OR (user_id = $216 AND (encrypted_id = $217)) OR (user_id = $218 AND (encrypted_id = $219)) OR (user_id = $220 AND (encrypted_id = $221)) OR (user_id = $222 AND (encrypted_id = $223)) OR (user_id = $224 AND (encrypted_id = $225)) OR (user_id = $226 AND (encrypted_id = $227)) OR (user_id = $228 AND (encrypted_id = $229)) OR (user_id = $230 AND (encrypted_id = $231)) OR (user_id = $232 AND (encrypted_id = $233)) OR (user_id = $234 AND (encrypted_id = $235)) OR (user_id = $236 AND (encrypted_id = $237)) OR (user_id = $238 AND (encrypted_id = $239)) OR (user_id = $240 AND (encrypted_id = $241)) OR (user_id = $242 AND (encrypted_id = $243)) OR (user_id = $244 AND (encrypted_id = $245)) OR (user_id = $246 AND (encrypted_id = $247)) OR (user_id = $248 AND (encrypted_id = $249)) OR (user_id = $250 AND (encrypted_id = $251)) OR (user_id = $252 AND (encrypted_id = $253)) OR (user_id = $254 AND (encrypted_id = $255)) OR (user_id = $256 AND (encrypted_id = $257)) OR (user_id = $258 AND (encrypted_id = $259)) OR (user_id = $260 AND (encrypted_id = $261)) OR (user_id = $262 AND (encrypted_id = $263)) OR (user_id = $264 AND (encrypted_id = $265)) OR (user_id = $266 AND (encrypted_id = $267)) OR (user_id = $268 AND (encrypted_id = $269)) OR (user_id = $270 AND (encrypted_id = $271)) OR (user_id = $272 AND (encrypted_id = $273)) OR (user_id = $274 AND (encrypted_id = $275)) OR (user_id = $276 AND (encrypted_id = $277)) OR (user_id = $278 AND (encrypted_id = $279)) OR (user_id = $280 AND (encrypted_id = $281)) OR (user_id = $282 AND (encrypted_id = $283)) OR (user_id = $284 AND (encrypted_id = $285)) OR (user_id = $286 AND (encrypted_id = $287)) OR (user_id = $288 AND (encrypted_id = $289)) OR (user_id = $290 AND (encrypted_id = $291)) OR (user_id = $292 AND (encrypted_id = $293)) OR (user_id = $294 AND (encrypted_id = $295)) OR (user_id = $296 AND (encrypted_id = $297)) OR (user_id = $298 AND (encrypted_id = $299)) OR (user_id = $300 AND (encrypted_id = $301)) OR (user_id = $302 AND (encrypted_id = $303)) OR (user_id = $304 AND (encrypted_id = $305)) OR (user_id = $306 AND (encrypted_id = $307)) OR (user_id = $308 AND (encrypted_id = $309)) OR (user_id = $310 AND (encrypted_id = $311)) OR (user_id = $312 AND (encrypted_id = $313)) OR (user_id = $314 AND (encrypted_id = $315)) OR (user_id = $316 AND (encrypted_id = $317)) OR (user_id = $318 AND (encrypted_id = $319)) OR (user_id = $320 AND (encrypted_id = $321)) OR (user_id = $322 AND (encrypted_id = $323)) OR (user_id = $324 AND (encrypted_id = $325)) OR (user_id = $326 AND (encrypted_id = $327)) OR (user_id = $328 AND (encrypted_id = $329)) OR (user_id = $330 AND (encrypted_id = $331)) OR (user_id = $332 AND (encrypted_id = $333)) OR (user_id = $334 AND (encrypted_id = $335)) OR (user_id = $336 AND (encrypted_id = $337)) OR (user_id = $338 AND (encrypted_id = $339)) OR (user_id = $340 AND (encrypted_id = $341)) OR (user_id = $342 AND (encrypted_id = $343)) OR (user_id = $344 AND (encrypted_id = $345)) OR (user_id = $346 AND (encrypted_id = $347)) OR (user_id = $348 AND (encrypted_id = $349)) OR (user_id = $350 AND (encrypted_id = $351)) OR (user_id = $352 AND (encrypted_id = $353)) OR (user_id = $354 AND (encrypted_id = $355)) OR (user_id = $356 AND (encrypted_id = $357)) OR (user_id = $358 AND (encrypted_id = $359)) OR (user_id = $360 AND (encrypted_id = $361)) OR (user_id = $362 AND (encrypted_id = $363)) OR (user_id = $364 AND (encrypted_id = $365)) OR (user_id = $366 AND (encrypted_id = $367)) OR (user_id = $368 AND (encrypted_id = $369)) OR (user_id = $370 AND (encrypted_id = $371)) OR (user_id = $372 AND (encrypted_id = $373)) OR (user_id = $374 AND (encrypted_id = $375)) OR (user_id = $376 AND (encrypted_id = $377)) OR (user_id = $378 AND (encrypted_id = $379)) OR (user_id = $380 AND (encrypted_id = $381)) OR (user_id = $382 AND (encrypted_id = $383)) OR (user_id = $384 AND (encrypted_id = $385)) OR (user_id = $386 AND (encrypted_id = $387)) OR (user_id = $388 AND (encrypted_id = $389)) OR (user_id = $390 AND (encrypted_id = $391)) OR (user_id = $392 AND (encrypted_id = $393)) OR (user_id = $394 AND (encrypted_id = $395)) OR (user_id = $396 AND (encrypted_id = $397)) OR (user_id = $398 AND (encrypted_id = $399)) OR (user_id = $400 AND (encrypted_id = $401)) OR (user_id = $402 AND (encrypted_id = $403)) OR (user_id = $404 AND (encrypted_id = $405)) OR (user_id = $406 AND (encrypted_id = $407)) OR (user_id = $408 AND (encrypted_id = $409)) OR (user_id = $410 AND (encrypted_id = $411)) OR (user_id = $412 AND (encrypted_id = $413)) OR (user_id = $414 AND (encrypted_id = $415)) OR (user_id = $416 AND (encrypted_id = $417)) OR (user_id = $418 AND (encrypted_id = $419)) OR (user_id = $420 AND (encrypted_id = $421)) OR (user_id = $422 AND (encrypted_id = $423)) OR (user_id = $424 AND (encrypted_id = $425)) OR (user_id = $426 AND (encrypted_id = $427)) OR (user_id = $428 AND (encrypted_id = $429)) OR (user_id = $430 AND (encrypted_id = $431)) OR (user_id = $432 AND (encrypted_id = $433)) OR (user_id = $434 AND (encrypted_id = $435)) OR (user_id = $436 AND (encrypted_id = $437)) OR (user_id = $438 AND (encrypted_id = $439)) OR (user_id = $440 AND (encrypted_id = $441)) OR (user_id = $442 AND (encrypted_id = $443)) OR (user_id = $444 AND (encrypted_id = $445)) OR (user_id = $446 AND (encrypted_id = $447)) OR (user_id = $448 AND (encrypted_id = $449)) OR (user_id = $450 AND (encrypted_id = $451)) OR (user_id = $452 AND (encrypted_id = $453)) OR (user_id = $454 AND (encrypted_id = $455)) OR (user_id = $456 AND (encrypted_id = $457)) OR (user_id = $458 AND (encrypted_id = $459)) OR (user_id = $460 AND (encrypted_id = $461)) OR (user_id = $462 AND (encrypted_id = $463)) OR (user_id = $464 AND (encrypted_id = $465)) OR (user_id = $466 AND (encrypted_id = $467)) OR (user_id = $468 AND (encrypted_id = $469)) OR (user_id = $470 AND (encrypted_id = $471)) OR (user_id = $472 AND (encrypted_id = $473)) OR (user_id = $474 AND (encrypted_id = $475)) OR (user_id = $476 AND (encrypted_id = $477)) OR (user_id = $478 AND (encrypted_id = $479)) OR (user_id = $480 AND (encrypted_id = $481)) OR (user_id = $482 AND (encrypted_id = $483)) OR (user_id = $484 AND (encrypted_id = $485)) OR (user_id = $486 AND (encrypted_id = $487)) OR (user_id = $488 AND (encrypted_id = $489)) OR (user_id = $490 AND (encrypted_id = $491)) OR (user_id = $492 AND (encrypted_id = $493)) OR (user_id = $494 AND (encrypted_id = $495)) OR (user_id = $496 AND (encrypted_id = $497)) OR (user_id = $498 AND (encrypted_id = $499)) OR (user_id = $500 AND (encrypted_id = $501)) OR (user_id = $502 AND (encrypted_id = $503)) OR (user_id = $504 AND (encrypted_id = $505)) OR (user_id = $506 AND (encrypted_id = $507)) OR (user_id = $508 AND (encrypted_id = $509)) OR (user_id = $510 AND (encrypted_id = $511)) OR (user_id = $512 AND (encrypted_id = $513)) OR (user_id = $514 AND (encrypted_id = $515)) OR (user_id = $516 AND (encrypted_id = $517)) OR (user_id = $518 AND (encrypted_id = $519)) OR (user_id = $520 AND (encrypted_id = $521)) OR (user_id = $522 AND (encrypted_id = $523)) OR (user_id = $524 AND (encrypted_id = $525)) OR (user_id = $526 AND (encrypted_id = $527)) OR (user_id = $528 AND (encrypted_id = $529)) OR (user_id = $530 AND (encrypted_id = $531)) OR (user_id = $532 AND (encrypted_id = $533)) OR (user_id = $534 AND (encrypted_id = $535)) OR (user_id = $536 AND (encrypted_id = $537)) OR (user_id = $538 AND (encrypted_id = $539)) OR (user_id = $540 AND (encrypted_id = $541)) OR (user_id = $542 AND (encrypted_id = $543)) OR (user_id = $544 AND (encrypted_id = $545)) OR (user_id = $546 AND (encrypted_id = $547)) OR (user_id = $548 AND (encrypted_id = $549)) OR (user_id = $550 AND (encrypted_id = $551)) OR (user_id = $552 AND (encrypted_id = $553)) OR (user_id = $554 AND (encrypted_id = $555)) OR (user_id = $556 AND (encrypted_id = $557)) OR (user_id = $558 AND (encrypted_id = $559)) OR (user_id = $560 AND (encrypted_id = $561)) OR (user_id = $562 AND (encrypted_id = $563)) OR (user_id = $564 AND (encrypted_id = $565)) OR (user_id = $566 AND (encrypted_id = $567)) OR (user_id = $568 AND (encrypted_id = $569)) OR (user_id = $570 AND (encrypted_id = $571)) OR (user_id = $572 AND (encrypted_id = $573)) OR (user_id = $574 AND (encrypted_id = $575)) OR (user_id = $576 AND (encrypted_id = $577)) OR (user_id = $578 AND (encrypted_id = $579)) OR (user_id = $580 AND (encrypted_id = $581)) OR (user_id = $582 AND (encrypted_id = $583)) OR (user_id = $584 AND (encrypted_id = $585)) OR (user_id = $586 AND (encrypted_id = $587)) OR (user_id = $588 AND (encrypted_id = $589)) OR (user_id = $590 AND (encrypted_id = $591)) OR (user_id = $592 AND (encrypted_id = $593)) OR (user_id = $594 AND (encrypted_id = $595)) OR (user_id = $596 AND (encrypted_id = $597)) OR (user_id = $598 AND (encrypted_id = $599)) OR (user_id = $600 AND (encrypted_id = $601)) OR (user_id = $602 AND (encrypted_id = $603)) OR (user_id = $604 AND (encrypted_id = $605)) OR (user_id = $606 AND (encrypted_id = $607)) OR (user_id = $608 AND (encrypted_id = $609)) OR (user_id = $610 AND (encrypted_id = $611)) OR (user_id = $612 AND (encrypted_id = $613)) OR (user_id = $614 AND (encrypted_id = $615)) OR (user_id = $616 AND (encrypted_id = $617)) OR (user_id = $618 AND (encrypted_id = $619)) OR (user_id = $620 AND (encrypted_id = $621)) OR (user_id = $622 AND (encrypted_id = $623)) OR (user_id = $624 AND (encrypted_id = $625)) OR (user_id = $626 AND (encrypted_id = $627)) OR (user_id = $628 AND (encrypted_id = $629)) OR (user_id = $630 AND (encrypted_id = $631)) OR (user_id = $632 AND (encrypted_id = $633)) OR (user_id = $634 AND (encrypted_id = $635)) OR (user_id = $636 AND (encrypted_id = $637)) OR (user_id = $638 AND (encrypted_id = $639)) OR (user_id = $640 AND (encrypted_id = $641)) OR (user_id = $642 AND (encrypted_id = $643)) OR (user_id = $644 AND (encrypted_id = $645)) OR (user_id = $646 AND (encrypted_id = $647)) OR (user_id = $648 AND (encrypted_id = $649)) OR (user_id = $650 AND (encrypted_id = $651)) OR (user_id = $652 AND (encrypted_id = $653)) OR (user_id = $654 AND (encrypted_id = $655)) OR (user_id = $656 AND (encrypted_id = $657)) OR (user_id = $658 AND (encrypted_id = $659)) OR (user_id = $660 AND (encrypted_id = $661)) OR (user_id = $662 AND (encrypted_id = $663)) OR (user_id = $664 AND (encrypted_id = $665)) OR (user_id = $666 AND (encrypted_id = $667)) OR (user_id = $668 AND (encrypted_id = $669)) OR (user_id = $670 AND (encrypted_id = $671)) OR (user_id = $672 AND (encrypted_id = $673)) OR (user_id = $674 AND (encrypted_id = $675)) OR (user_id = $676 AND (encrypted_id = $677)) OR (user_id = $678 AND (encrypted_id = $679)) OR (user_id = $680 AND (encrypted_id = $681)) OR (user_id = $682 AND (encrypted_id = $683)) OR (user_id = $684 AND (encrypted_id = $685)) OR (user_id = $686 AND (encrypted_id = $687)) OR (user_id = $688 AND (encrypted_id = $689)) OR (user_id = $690 AND (encrypted_id = $691)) OR (user_id = $692 AND (encrypted_id = $693)) OR (user_id = $694 AND (encrypted_id = $695)) OR (user_id = $696 AND (encrypted_id = $697)) OR (user_id = $698 AND (encrypted_id = $699)) OR (user_id = $700 AND (encrypted_id = $701)) OR (user_id = $702 AND (encrypted_id = $703)) OR (user_id = $704 AND (encrypted_id = $705)) OR (user_id = $706 AND (encrypted_id = $707)) OR (user_id = $708 AND (encrypted_id = $709)) OR (user_id = $710 AND (encrypted_id = $711)) OR (user_id = $712 AND (encrypted_id = $713)) OR (user_id = $714 AND (encrypted_id = $715)) OR (user_id = $716 AND (encrypted_id = $717)) OR (user_id = $718 AND (encrypted_id = $719)) OR (user_id = $720 AND (encrypted_id = $721)) OR (user_id = $722 AND (encrypted_id = $723)) OR (user_id = $724 AND (encrypted_id = $725)) OR (user_id = $726 AND (encrypted_id = $727)) OR (user_id = $728 AND (encrypted_id = $729)) OR (user_id = $730 AND (encrypted_id = $731)) OR (user_id = $732 AND (encrypted_id = $733)) OR (user_id = $734 AND (encrypted_id = $735)) OR (user_id = $736 AND (encrypted_id = $737)) OR (user_id = $738 AND (encrypted_id = $739)) OR (user_id = $740 AND (encrypted_id = $741)) OR (user_id = $742 AND (encrypted_id = $743)) OR (user_id = $744 AND (encrypted_id = $745)) OR (user_id = $746 AND (encrypted_id = $747)) OR (user_id = $748 AND (encrypted_id = $749)) OR (user_id = $750 AND (encrypted_id = $751)) OR (user_id = $752 AND (encrypted_id = $753)) OR (user_id = $754 AND (encrypted_id = $755)) OR (user_id = $756 AND (date = $757 OR encrypted_id = $758)) OR (user_id = $759 AND (date = $760 OR encrypted_id = $761)) OR (user_id = $762 AND (date = $763 OR encrypted_id = $764)) OR (user_id = $765 AND (date = $766 OR encrypted_id = $767)) OR (user_id = $768 AND (date = $769 OR encrypted_id = $770)) OR (user_id = $771 AND (date = $772 OR encrypted_id = $773)) OR (user_id = $774 AND (date = $775 OR encrypted_id = $776)) OR (user_id = $777 AND (date = $778 OR encrypted_id = $779)) OR (user_id = $780 AND (date = $781 OR encrypted_id = $782)) OR (user_id = $783 AND (date = $784 OR encrypted_id = $785)) OR (user_id = $786 AND (date = $787 OR encrypted_id = $788)) OR (user_id = $789 AND (date = $790 OR encrypted_id = $791)) OR (user_id = $792 AND (date = $793 OR encrypted_id = $794)) OR (user_id = $795 AND (date = $796 OR encrypted_id = $797)) OR (user_id = $798 AND (date = $799 OR encrypted_id = $800)) OR (user_id = $801 AND (date = $802 OR encrypted_id = $803)) OR (user_id = $804 AND (date = $805 OR encrypted_id = $806)) OR (user_id = $807 AND (date = $808 OR encrypted_id = $809)) OR (user_id = $810 AND (date = $811 OR encrypted_id = $812)) OR (user_id = $813 AND (date = $814 OR encrypted_id = $815)) OR (user_id = $816 AND (date = $817 OR encrypted_id = $818)) OR (user_id = $819 AND (date = $820 OR encrypted_id = $821)) OR (user_id = $822 AND (date = $823 OR encrypted_id = $824)) OR (user_id = $825 AND (date = $826 OR encrypted_id = $827)) OR (user_id = $828 AND (date = $829 OR encrypted_id = $830)) OR (user_id = $831 AND (date = $832 OR encrypted_id = $833)) OR (user_id = $834 AND (date = $835 OR encrypted_id = $836)) OR (user_id = $837 AND (date = $838 OR encrypted_id = $839)) OR (user_id = $840 AND (date = $841 OR encrypted_id = $842)) OR (user_id = $843 AND (date = $844 OR encrypted_id = $845)) OR (user_id = $846 AND (date = $847 OR encrypted_id = $848)) OR (user_id = $849 AND (encrypted_id = $850)) OR (user_id = $851 AND (encrypted_id = $852)) OR (user_id = $853 AND (encrypted_id = $854)) OR (user_id = $855 AND (encrypted_id = $856)) OR (user_id = $857 AND (encrypted_id = $858)) OR (user_id = $859 AND (encrypted_id = $860)) OR (user_id = $861 AND (encrypted_id = $862)) OR (user_id = $863 AND (encrypted_id = $864)) OR (user_id = $865 AND (encrypted_id = $866)) OR (user_id = $867 AND (encrypted_id = $868)) OR (user_id = $869 AND (encrypted_id = $870)) OR (user_id = $871 AND (encrypted_id = $872)) OR (user_id = $873 AND (encrypted_id = $874)) OR (user_id = $875 AND (encrypted_id = $876)) OR (user_id = $877 AND (encrypted_id = $878)) OR (user_id = $879 AND (encrypted_id = $880)) OR (user_id = $881 AND (encrypted_id = $882)) OR (user_id = $883 AND (encrypted_id = $884)) OR (user_id = $885 AND (encrypted_id = $886)) OR (user_id = $887 AND (encrypted_id = $888)) OR (user_id = $889 AND (encrypted_id = $890)) OR (user_id = $891 AND (encrypted_id = $892)) OR (user_id = $893 AND (encrypted_id = $894)) OR (user_id = $895 AND (encrypted_id = $896)) OR (user_id = $897 AND (encrypted_id = $898)) OR (user_id = $899 AND (encrypted_id = $900)) OR (user_id = $901 AND (encrypted_id = $902)) OR (user_id = $903 AND (encrypted_id = $904)) OR (user_id = $905 AND (encrypted_id = $906)) OR (user_id = $907 AND (encrypted_id = $908)) OR (user_id = $909 AND (encrypted_id = $910)) OR (user_id = $911 AND (encrypted_id = $912)) OR (user_id = $913 AND (encrypted_id = $914)) OR (user_id = $915 AND (encrypted_id = $916)) OR (user_id = $917 AND (encrypted_id = $918)) OR (user_id = $919 AND (encrypted_id = $920)) OR (user_id = $921 AND (encrypted_id = $922)) OR (user_id = $923 AND (encrypted_id = $924)) OR (user_id = $925 AND (encrypted_id = $926)) OR (user_id = $927 AND (encrypted_id = $928)) OR (user_id = $929 AND (encrypted_id = $930)) OR (user_id = $931 AND (encrypted_id = $932)) OR (user_id = $933 AND (encrypted_id = $934)) OR (user_id = $935 AND (encrypted_id = $936)) OR (user_id = $937 AND (encrypted_id = $938)) OR (user_id = $939 AND (encrypted_id = $940)) OR (user_id = $941 AND (encrypted_id = $942)) OR (user_id = $943 AND (encrypted_id = $944)) OR (user_id = $945 AND (encrypted_id = $946)) OR (user_id = $947 AND (encrypted_id = $948)) OR (user_id = $949 AND (encrypted_id = $950)) OR (user_id = $951 AND (encrypted_id = $952)) OR (user_id = $953 AND (encrypted_id = $954)) OR (user_id = $955 AND (encrypted_id = $956)) OR (user_id = $957 AND (encrypted_id = $958)) OR (user_id = $959 AND (encrypted_id = $960)) OR (user_id = $961 AND (encrypted_id = $962)) OR (user_id = $963 AND (encrypted_id = $964)) OR (user_id = $965 AND (encrypted_id = $966)) OR (user_id = $967 AND (encrypted_id = $968)) OR (user_id = $969 AND (encrypted_id = $970)) OR (user_id = $971 AND (encrypted_id = $972)) OR (user_id = $973 AND (encrypted_id = $974)) OR (user_id = $975 AND (encrypted_id = $976)) OR (user_id = $977 AND (encrypted_id = $978)) OR (user_id = $979 AND (encrypted_id = $980)) OR (user_id = $981 AND (encrypted_id = $982)) OR (user_id = $983 AND (encrypted_id = $984)) OR (user_id = $985 AND (encrypted_id = $986)) OR (user_id = $987 AND (encrypted_id = $988)) OR (user_id = $989 AND (encrypted_id = $990)) OR (user_id = $991 AND (encrypted_id = $992)) OR (user_id = $993 AND (encrypted_id = $994)) OR (user_id = $995 AND (encrypted_id = $996)) OR (user_id = $997 AND (encrypted_id = $998)) OR (user_id = $999 AND (encrypted_id = $1000)) OR (user_id = $1001 AND (encrypted_id = $1002)) OR (user_id = $1003 AND (encrypted_id = $1004)) OR (user_id = $1005 AND (encrypted_id = $1006)) OR (user_id = $1007 AND (encrypted_id = $1008)) OR (user_id = $1009 AND (encrypted_id = $1010)) OR (user_id = $1011 AND (encrypted_id = $1012)) OR (user_id = $1013 AND (encrypted_id = $1014)) OR (user_id = $1015 AND (encrypted_id = $1016)) OR (user_id = $1017 AND (encrypted_id = $1018)) OR (user_id = $1019 AND (encrypted_id = $1020)) OR (user_id = $1021 AND (encrypted_id = $1022)) OR (user_id = $1023 AND (encrypted_id = $1024)) OR (user_id = $1025 AND (encrypted_id = $1026)) OR (user_id = $1027 AND (encrypted_id = $1028)) OR (user_id = $1029 AND (encrypted_id = $1030)) OR (user_id = $1031 AND (encrypted_id = $1032)) OR (user_id = $1033 AND (encrypted_id = $1034)) OR (user_id = $1035 AND (encrypted_id = $1036)) OR (user_id = $1037 AND (encrypted_id = $1038)) OR (user_id = $1039 AND (encrypted_id = $1040)) OR (user_id = $1041 AND (encrypted_id = $1042)) OR (user_id = $1043 AND (encrypted_id = $1044)) OR (user_id = $1045 AND (encrypted_id = $1046)) OR (user_id = $1047 AND (encrypted_id = $1048)) OR (user_id = $1049 AND (encrypted_id = $1050)) OR (user_id = $1051 AND (encrypted_id = $1052)) OR (user_id = $1053 AND (encrypted_id = $1054)) OR (user_id = $1055 AND (encrypted_id = $1056)) OR (user_id = $1057 AND (encrypted_id = $1058)) OR (user_id = $1059 AND (encrypted_id = $1060)) OR (user_id = $1061 AND (encrypted_id = $1062)) OR (user_id = $1063 AND (encrypted_id = $1064)) OR (user_id = $1065 AND (encrypted_id = $1066)) OR (user_id = $1067 AND (encrypted_id = $1068)) OR (user_id = $1069 AND (encrypted_id = $1070)) OR (user_id = $1071 AND (encrypted_id = $1072)) OR (user_id = $1073 AND (encrypted_id = $1074)) OR (user_id = $1075 AND (encrypted_id = $1076)) OR (user_id = $1077 AND (encrypted_id = $1078)) OR (user_id = $1079 AND (encrypted_id = $1080)) OR (user_id = $1081 AND (encrypted_id = $1082)) OR (user_id = $1083 AND (encrypted_id = $1084)) OR (user_id = $1085 AND (encrypted_id = $1086)) OR (user_id = $1087 AND (encrypted_id = $1088)) OR (user_id = $1089 AND (encrypted_id = $1090)) OR (user_id = $1091 AND (encrypted_id = $1092)) OR (user_id = $1093 AND (encrypted_id = $1094)) OR (user_id = $1095 AND (encrypted_id = $1096)) OR (user_id = $1097 AND (encrypted_id = $1098)) OR (user_id = $1099 AND (encrypted_id = $1100)) OR (user_id = $1101 AND (encrypted_id = $1102)) OR (user_id = $1103 AND (encrypted_id = $1104)) OR (user_id = $1105 AND (encrypted_id = $1106)) OR (user_id = $1107 AND (encrypted_id = $1108)) OR (user_id = $1109 AND (encrypted_id = $1110)) OR (user_id = $1111 AND (encrypted_id = $1112)) OR (user_id = $1113 AND (encrypted_id = $1114)) OR (user_id = $1115 AND (encrypted_id = $1116)) OR (user_id = $1117 AND (encrypted_id = $1118)) OR (user_id = $1119 AND (encrypted_id = $1120)) OR (user_id = $1121 AND (encrypted_id = $1122)) OR (user_id = $1123 AND (encrypted_id = $1124)) OR (user_id = $1125 AND (encrypted_id = $1126)) OR (user_id = $1127 AND (encrypted_id = $1128)) OR (user_id = $1129 AND (encrypted_id = $1130)) OR (user_id = $1131 AND (encrypted_id = $1132)) OR (user_id = $1133 AND (encrypted_id = $1134)) OR (user_id = $1135 AND (encrypted_id = $1136)) OR (user_id = $1137 AND (encrypted_id = $1138)) OR (user_id = $1139 AND (encrypted_id = $1140)) OR (user_id = $1141 AND (encrypted_id = $1142)) OR (user_id = $1143 AND (encrypted_id = $1144)) OR (user_id = $1145 AND (encrypted_id = $1146)) OR (user_id = $1147 AND (encrypted_id = $1148)) OR (user_id = $1149 AND (encrypted_id = $1150)) OR (user_id = $1151 AND (encrypted_id = $1152)) OR (user_id = $1153 AND (encrypted_id = $1154)) OR (user_id = $1155 AND (encrypted_id = $1156)) OR (user_id = $1157 AND (encrypted_id = $1158)) OR (user_id = $1159 AND (encrypted_id = $1160)) OR (user_id = $1161 AND (encrypted_id = $1162)) OR (user_id = $1163 AND (encrypted_id = $1164)) OR (user_id = $1165 AND (encrypted_id = $1166)) OR (user_id = $1167 AND (encrypted_id = $1168)) OR (user_id = $1169 AND (encrypted_id = $1170)) OR (user_id = $1171 AND (encrypted_id = $1172)) OR (user_id = $1173 AND (encrypted_id = $1174)) OR (user_id = $1175 AND (encrypted_id = $1176)) OR (user_id = $1177 AND (encrypted_id = $1178)) OR (user_id = $1179 AND (encrypted_id = $1180)) OR (user_id = $1181 AND (encrypted_id = $1182)) OR (user_id = $1183 AND (encrypted_id = $1184)) OR (user_id = $1185 AND (encrypted_id = $1186)) OR (user_id = $1187 AND (encrypted_id = $1188)) OR (user_id = $1189 AND (encrypted_id = $1190)) OR (user_id = $1191 AND (encrypted_id = $1192)) OR (user_id = $1193 AND (encrypted_id = $1194)) OR (user_id = $1195 AND (encrypted_id = $1196)) OR (user_id = $1197 AND (encrypted_id = $1198)) OR (user_id = $1199 AND (encrypted_id = $1200)) OR (user_id = $1201 AND (encrypted_id = $1202)) OR (user_id = $1203 AND (encrypted_id = $1204)) OR (user_id = $1205 AND (encrypted_id = $1206)) OR (user_id = $1207 AND (encrypted_id = $1208)) OR (user_id = $1209 AND (encrypted_id = $1210)) OR (user_id = $1211 AND (encrypted_id = $1212)) OR (user_id = $1213 AND (encrypted_id = $1214)) OR (user_id = $1215 AND (encrypted_id = $1216)) OR (user_id = $1217 AND (encrypted_id = $1218)) OR (user_id = $1219 AND (encrypted_id = $1220)) OR (user_id = $1221 AND (encrypted_id = $1222)) OR (user_id = $1223 AND (encrypted_id = $1224)) OR (user_id = $1225 AND (encrypted_id = $1226)) OR (user_id = $1227 AND (encrypted_id = $1228)) OR (user_id = $1229 AND (encrypted_id = $1230)) OR (user_id = $1231 AND (encrypted_id = $1232)) OR (user_id = $1233 AND (encrypted_id = $1234)) OR (user_id = $1235 AND (encrypted_id = $1236)) OR (user_id = $1237 AND (encrypted_id = $1238)) OR (user_id = $1239 AND (encrypted_id = $1240)) OR (user_id = $1241 AND (encrypted_id = $1242)) OR (user_id = $1243 AND (encrypted_id = $1244)) OR (user_id = $1245 AND (encrypted_id = $1246)) OR (user_id = $1247 AND (encrypted_id = $1248)) OR (user_id = $1249 AND (encrypted_id = $1250)) OR (user_id = $1251 AND (encrypted_id = $1252)) OR (user_id = $1253 AND (encrypted_id = $1254)) OR (user_id = $1255 AND (encrypted_id = $1256)) OR (user_id = $1257 AND (encrypted_id = $1258)) OR (user_id = $1259 AND (encrypted_id = $1260)) OR (user_id = $1261 AND (encrypted_id = $1262)) OR (user_id = $1263 AND (encrypted_id = $1264)) OR (user_id = $1265 AND (encrypted_id = $1266)) OR (user_id = $1267 AND (encrypted_id = $1268)) OR (user_id = $1269 AND (encrypted_id = $1270)) OR (user_id = $1271 AND (encrypted_id = $1272)) OR (user_id = $1273 AND (encrypted_id = $1274))
hishtory-postgres  | 2024-08-08 17:08:31.854 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 17:10:25.751 UTC [27] LOG:  checkpoint complete: wrote 1091 buffers (6.7%); 0 WAL file(s) added, 0 removed, 1 recycled; write=113.892 s, sync=0.003 s, total=113.898 s; sync files=21, longest=0.001 s, average=0.001 s; distance=7138 kB, estimate=18588 kB; lsn=59/904F42E8, redo lsn=59/90463458
hishtory-postgres  | 2024-08-08 17:10:42.740 UTC [10567] ERROR:  deadlock detected
hishtory-postgres  | 2024-08-08 17:10:42.740 UTC [10567] DETAIL:  Process 10567 waits for ShareLock on transaction 349302; blocked by process 10560.
hishtory-postgres  |    Process 10560 waits for ShareLock on transaction 349301; blocked by process 10567.
hishtory-postgres  |    Process 10567: UPDATE deletion_requests SET read_count = read_count + 1 WHERE user_id = $1 AND destination_device_id = $2
hishtory-postgres  |    Process 10560: UPDATE deletion_requests SET read_count = read_count + 1 WHERE user_id = $1 AND destination_device_id = $2
hishtory-postgres  | 2024-08-08 17:10:42.740 UTC [10567] HINT:  See server log for query details.
hishtory-postgres  | 2024-08-08 17:10:42.740 UTC [10567] CONTEXT:  while updating tuple (1280,35) in relation "deletion_requests"
hishtory-postgres  | 2024-08-08 17:10:42.740 UTC [10567] STATEMENT:  UPDATE deletion_requests SET read_count = read_count + 1 WHERE user_id = $1 AND destination_device_id = $2
hishtory-postgres  | 2024-08-08 17:13:31.851 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 17:18:01.086 UTC [27] LOG:  checkpoint complete: wrote 3249 buffers (19.8%); 0 WAL file(s) added, 0 removed, 1 recycled; write=269.231 s, sync=0.002 s, total=269.236 s; sync files=26, longest=0.001 s, average=0.001 s; distance=21541 kB, estimate=21541 kB; lsn=59/9196CB28, redo lsn=59/9196CAF0
hishtory-postgres  | 2024-08-08 17:19:36.271 UTC [10578] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-08 17:23:31.214 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 17:23:38.735 UTC [27] LOG:  checkpoint complete: wrote 75 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=7.517 s, sync=0.001 s, total=7.522 s; sync files=2, longest=0.001 s, average=0.001 s; distance=167 kB, estimate=19404 kB; lsn=59/919968F0, redo lsn=59/919968B8
hishtory-postgres  | 2024-08-08 19:33:34.145 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 19:33:38.759 UTC [27] LOG:  checkpoint complete: wrote 47 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.609 s, sync=0.002 s, total=4.614 s; sync files=11, longest=0.001 s, average=0.001 s; distance=285 kB, estimate=17492 kB; lsn=59/919DDE98, redo lsn=59/919DDE60
hishtory-postgres  | 2024-08-08 21:33:18.451 UTC [10832] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-08 22:08:34.791 UTC [10868] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-08 22:39:04.309 UTC [10899] LOG:  could not receive data from client: Connection reset by peer
hishtory-postgres  | 2024-08-08 23:25:19.345 UTC [10947] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-08 23:28:39.207 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-08 23:28:44.526 UTC [27] LOG:  checkpoint complete: wrote 54 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.312 s, sync=0.002 s, total=5.320 s; sync files=13, longest=0.001 s, average=0.001 s; distance=246 kB, estimate=15767 kB; lsn=59/91A1BA08, redo lsn=59/91A1B9D0
hishtory-postgres  | 2024-08-09 00:19:48.170 UTC [11003] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-09 00:59:28.595 UTC [11043] LOG:  could not receive data from client: Connection reset by peer
hishtory-postgres  | 2024-08-09 01:39:19.391 UTC [11084] LOG:  could not receive data from client: Connection reset by peer
hishtory-postgres  | 2024-08-09 02:30:58.141 UTC [11137] LOG:  invalid length of startup packet
hishtory-postgres  | 2024-08-09 03:28:43.952 UTC [27] LOG:  checkpoint starting: time
hishtory-postgres  | 2024-08-09 03:28:44.562 UTC [27] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.602 s, sync=0.002 s, total=0.610 s; sync files=6, longest=0.002 s, average=0.001 s; distance=0 kB, estimate=14191 kB; lsn=59/91A1BBD0, redo lsn=59/91A1BB98

Any ideas?

I ran VACUUM FULL which got it down to 5GB now at least which is helpful. Still surprising it uses that much space for a casual user!

Looking at the encoded entries it does seem like there are many being hit at once in a very short time. See the timestamps below - is that usual?
f0d8-454b-9e8c-72a7b59d1fd6 | bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk= | 2024-03-12 00:25:17.922361+00 | f15de758-46d6-4847-9872-0e19cab3d7c07789 |          0 |
 \xb39b2e5d36b15b366b9e9cec41e777b0508b9735ea7712a745c5aea6bd8c7fda77fac9ea50b926914bb2f263ffb37475748fa4be2ed53a7004ec221d862ba12bbabcd566f1a33e0643b86ae3211f74da1d4a144f1fd3e631671140f552d9937df227816f235bd12c59134c5a25f3d7faa496ccdff93b955b66f466fefbc024d3893df3ae025abbd87fd59c3390b32ccdaa2685508f3ed4be7fe3646b78d93c8273e780d1d882227b2cdffc6348889de63933efd2437a9c109aea5d59149c00caa4fae11c866c8b291d61beca138c2efac37bf770e4f5340e55cff546fc6999d389ad8af7f8e085a08f9f530989785d6d087adb9f9232a045aa8d3fcbe58517f77b6cfff17f7f6e2f381090a85794d595fa9176f004e813bd4119ce35428207573806c875013b08f6092121e670fb4390b0a3f14ed4c56019b1790489627ed2cedea2b2121923ccc147bbc2d31c002d0eea107817a0e64927e46899d7ca8b50fc12f7d3e370bd1647ca64f6d1e7a32532d07482c85201b637e7937e02337ee6b9621fb1902f4da2b76d81bc91a5fbcc16c77f0f                                                               | \x69991b692b35d1896e672051 | 518019a7-f0d8-454b-9e8c-72a7b59d1fd6 | bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk= | 2024-03-12 00:25:17.920361+00 | f15de758-46d6-4847-9872-0e19cab3d7c07788 |          0 |
 \x90e4a7d8207fbfd1c61e5ff4d13e2502f64d8b3bfac612bda10d5cd2217708177f5b954f85218ae5b38ab6565e0222ecf9671dafb4590b961b8422626de7f94494f056f6de47d88af615e7a135745b415e5241a889a059995fa362a1d479bd26fb5f657ed8c18f5e526680b48b47b7ff62dbf9a04a6a051444ae83e626520f86f91406468ca7bb560c3b55605615a33146fd957871db97e5b7cc821fa2b22103306b2684a13ed645c2f530a8c0a3d43a110ff923129317fb11c5fcec3feb6ab6e62d846e331c21435017c97c46609720e193bdd800f11827d2019dd54ed7f4aa9f4aaa5d972dfe029846e0ea9042cdb92d4f7b482297a19632eeb96d361f76883254f1b0f11901351ed27cdfb57ffdf2e877c5fe78dc78b813bbaeb4e67debc62b121f5d95dfa06e540cc17c3ea975c6817f005f7e70d3ddd9329ac611555add9ebef13747738bba0e161b10bfe754a249be5ad3567d70f2ffa94a8dc9de0bbc78871d6f00b36578aaaff05d3c283c8d26cad6f75b070632cb0893c7ac3c                                                                                | \x1390dc9fcc1bcee8bdf1cc55 | 518019a7-f0d8-454b-9e8c-72a7b59d1fd6 | bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk= | 2024-03-12 00:25:17.918361+00 | f15de758-46d6-4847-9872-0e19cab3d7c07787 |          0 |
 \xbe4c0b2f75047ff361596810b9efb887fac328d23484586616f869873cd2fc2d895331201e0a4344e15ea38f6878915240a3735e359560f3b06f635b86f93cae82a8fb2306cdf93f499d915660956c9187acb97230c721337b1c544b8a04c9b8f0780e30e9e5f441cef8c26c7ec25658941991f097b32410f4865ab61c4bba8be42a66e548bfb7cd72be44d8647fcbbe271db1f153cb497c56ae728f1333c41f082475280c8e5a0461f41908f620467d209e363a7f0aca1cdc32b3ea31b2b64c11d33b85d4840d2fd933133f5822da8922840f6d2aecd086c5319fef3ab33bf49029de80a4348368516d0a4ceba2111de80fe58f4a7620290cb9b99b55cd807ecc4ef01dce981eb6de7f54411d7b8973cf131594a065747d901401a0161b972ff0050b171bcdbbfee1736475a933e22a07a33262d56e16a506a74651b3cb48ece7a110f2a6751d9505450bca0e5e4e068ceb6118362257462a4e282e4a942d7c46f52ab35708c8d60aaa9447abcfb98a32655ac62331b58b120457b380fb75e25dd502a8e241                                                                                | \x516308393b7cf62b5f9a6fd5 | 518019a7-f0d8-454b-9e8c-72a7b59d1fd6 | bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk= | 2024-03-12 00:25:17.916361+00 | f15de758-46d6-4847-9872-0e19cab3d7c07786 |          0 |
 \x0fdd17d5068e489083e61b7849e337d6b333d1673209da215524a692ac85d1a5274caa4acd3002c109a5c7de0e9dbb93dc95da265c2153f07c1bad6204bf36807f01c45f7c55c0209e8f003ff75c1d67e25ee4692975eb129a8b02dd676c2c0ce6aacd660420fdd83935c013e961a9da171289fab01aede7634463d4831198b104d258dff4e944056d017bb427f3237e6f43589819acc38e42f7a315e336567b33661d8e02440038a7d380cadcbe6673c114b2c801e751a95048d4bd595c4aa97e5de14d5c391338a274ff26b02c90d0f98809dc22d0bc848f13136f6240e41eae1b71b175dc5b799fcff44a9248e45bb247894855ff99fe09d78a7b1ccba57c47a780e6195e74185f9f54342e896546a840157f95f75d326339b5f7685dbe3c72d1113c91a41a52d7b75c1c0bd69f2b86890ace90f48e7b421ae1a8e9b46f5c919669644e186bec9975595b07b41e482897b5c1ba61fc0683bf4017d457202b1fe7443420bfd60099d21bc1740184ebc10d8310bfb521eaffadb48dcd99                                                                                | \x28e791e271adbcfc3f21744c | 518019a7-f0d8-454b-9e8c-72a7b59d1fd6 | bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk= | 2024-03-12 00:25:17.914361+00 | f15de758-46d6-4847-9872-0e19cab3d7c07785 |          0 |
 \x4bc8dd0583b356de8d8c3b1890957b092d948178f52e56f95eec2db4942e1ffc639c3b02fcbf87148d0140fd311814756afcd03c20fa8f0eeec3d6036a24392eb3ec1c72abdb6fa96b1435f8ed90964cdc4a443dd0e8190ef748663c916309652a1dd5a573026849c4aabc9b9411d59aa4e255a2fd7a5a2a15dae24f53c73add95cd0c7d7371e46df47f7eafe46ba57ab0e70e5ac70e7ffb4e4b17ba8c046b40864632006acb0c9d377126257ba3785eeeb0250d83751c8c83f77bc1655283424bbab6a3bb6cd589b2fd74bbec3e210fbf6dad27b7ba7c49028114fb6b55eec455630a76e83e52922b5a133ad742cda0ff070c3371f6adb2f539c17d3954c5a1e681a58c1d718d3622e88658791b7055b26bd59a3851437ce76a02fac4f3b09422fe13e015f7b605646a65b260ad5ba78598ebb121408553686df948504493d91ffb4cd3d28ff7acbf52ee43d9c060ce9d9f242fdbc8317a7f6a5c1251d1d4e2c5bc0905cbce49bd2a0a7f94abadcf5838d7c6f51c575f1bf1d51ba5cbd4b9d44cfae55445b8e02faafc                                                                                | \x44edc9ddd24c28de633dce1f | 518019a7-f0d8-454b-9e8c-72a7b59d1fd6 | bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk= | 2024-03-12 00:25:17.912361+00 | f15de758-46d6-4847-9872-0e19cab3d7c07784 |          0 |

My clients all seem to be getting odd locking errors after reboot however.
time="2024-08-09T10:26:50+01:00" level=info msg="github.com/ddworken/hishtory/client/hctx/hctx.go:105 database is locked (261)\n[0.032ms] [rows:0] CREATE TABLE `history_entries` (`local_username` text,`hostname` text,`command` text,`current_working_directory` text,`home_directory` text,`exit_code` integer,`start_time` datetime,`end_time` datetime,`device_id` text,`entry_id` text,`custom_columns` blob)" fromSQL=true
time="2024-08-09T10:26:50+01:00" level=info msg="failed to find presaved entry matching cmd=\"more hishtory\" even with retry, skipping delete"
time="2024-08-09T10:26:51+01:00" level=info msg="ApiPost(\"http://example.com:2274/api/v1/submit?source_device_id=07ad08f6-e8b5-429d-88c4-1747db65a8af\"): 48 bytes - 244.026647ms\n"
time="2024-08-09T10:26:53+01:00" level=info msg="github.com/ddworken/hishtory/client/hctx/hctx.go:105 database is locked (261)\n[0.049ms] [rows:0] CREATE TABLE `history_entries` (`local_username` text,`hostname` text,`command` text,`current_working_directory` text,`home_directory` text,`exit_code` integer,`start_time` datetime,`end_time` datetime,`device_id` text,`entry_id` text,`custom_columns` blob)" fromSQL=true
time="2024-08-09T10:26:53+01:00" level=info msg="github.com/ddworken/hishtory/client/hctx/hctx.go:106 database is locked (261)\n[0.049ms] [rows:0] PRAGMA journal_mode = WAL" fromSQL=true
time="2024-08-09T10:26:53+01:00" level=info msg="github.com/ddworken/hishtory/client/hctx/hctx.go:107 database is locked (261)\n[0.035ms] [rows:0] CREATE INDEX IF NOT EXISTS start_time_index ON history_entries(start_time)" fromSQL=true
time="2024-08-09T10:26:53+01:00" level=info msg="github.com/ddworken/hishtory/client/hctx/hctx.go:108 database is locked (261)\n[0.027ms] [rows:0] CREATE INDEX IF NOT EXISTS end_time_index ON history_entries(end_time)" fromSQL=true
time="2024-08-09T10:26:53+01:00" level=info msg="github.com/ddworken/hishtory/client/hctx/hctx.go:109 database is locked (261)\n[0.019ms] [rows:0] CREATE INDEX IF NOT EXISTS entry_id_index ON history_entries(entry_id)" fromSQL=true
time="2024-08-09T10:26:54+01:00" level=info msg="failed to find presaved entry matching cmd=\"ll\" even with retry, skipping delete"
time="2024-08-09T10:26:54+01:00" level=info msg="ApiPost(\"http://example.com:2274/api/v1/submit?source_device_id=07ad08f6-e8b5-429d-88c4-1747db65a8af\"): 48 bytes - 248.283507ms\n"

Looking at the server logs it seems one query hits the main server many times over...
hishtory-server    | 2024/08/09 09:39:25 /build/hishtory/backend/server/internal/database/historyentries.go:65
hishtory-server    | [0.870ms] [rows:1] INSERT INTO "enc_history_entries" ("encrypted_data","nonce","device_id","user_id","date","encrypted_id","read_count","is_from_same_device") VALUES ('<binary>','<binary>','2bd60b0a-a359-4369-8b42-ff5a26ca73ba','bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk=','2024-08-09 09:39:24.539','931a6360-ac48-44d4-a4f1-39ee6fa1d34b',0,true)
hishtory-server    |
hishtory-server    | 2024/08/09 09:39:25 /build/hishtory/backend/server/internal/database/historyentries.go:65
hishtory-server    | [0.422ms] [rows:1] INSERT INTO "enc_history_entries" ("encrypted_data","nonce","device_id","user_id","date","encrypted_id","read_count","is_from_same_device") VALUES ('<binary>','<binary>','041dc97a-ca5d-4f6f-967e-63a1ab084127','bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk=','2024-08-09 09:39:24.539','931a6360-ac48-44d4-a4f1-39ee6fa1d34b',0,false)
hishtory-server    |
hishtory-server    | 2024/08/09 09:39:25 /build/hishtory/backend/server/internal/database/historyentries.go:65
hishtory-server    | [0.324ms] [rows:1] INSERT INTO "enc_history_entries" ("encrypted_data","nonce","device_id","user_id","date","encrypted_id","read_count","is_from_same_device") VALUES ('<binary>','<binary>','ff1217c2-7a73-426f-8260-70cd5fb06c94','bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk=','2024-08-09 09:39:24.539','931a6360-ac48-44d4-a4f1-39ee6fa1d34b',0,false)
hishtory-server    |
hishtory-server    | 2024/08/09 09:39:25 /build/hishtory/backend/server/internal/database/historyentries.go:65
hishtory-server    | [0.618ms] [rows:1] INSERT INTO "enc_history_entries" ("encrypted_data","nonce","device_id","user_id","date","encrypted_id","read_count","is_from_same_device") VALUES ('<binary>','<binary>','94f25d21-f6eb-49e9-aa48-5570e23456b4','bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk=','2024-08-09 09:39:24.539','931a6360-ac48-44d4-a4f1-39ee6fa1d34b',0,false)
hishtory-server    |
hishtory-server    | 2024/08/09 09:39:25 /build/hishtory/backend/server/internal/database/historyentries.go:65
hishtory-server    | [0.224ms] [rows:1] INSERT INTO "enc_history_entries" ("encrypted_data","nonce","device_id","user_id","date","encrypted_id","read_count","is_from_same_device") VALUES ('<binary>','<binary>','4d3131db-546a-40b6-975c-8c8b7fe658c9','bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk=','2024-08-09 09:39:24.539','931a6360-ac48-44d4-a4f1-39ee6fa1d34b',0,false)
hishtory-server    |
hishtory-server    | 2024/08/09 09:39:25 /build/hishtory/backend/server/internal/database/historyentries.go:65
hishtory-server    | [0.237ms] [rows:1] INSERT INTO "enc_history_entries" ("encrypted_data","nonce","device_id","user_id","date","encrypted_id","read_count","is_from_same_device") VALUES ('<binary>','<binary>','c38bd7dd-04ed-461e-be44-e7f745b3eb97','bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk=','2024-08-09 09:39:24.539','931a6360-ac48-44d4-a4f1-39ee6fa1d34b',0,false)
hishtory-server    |
hishtory-server    | 2024/08/09 09:39:25 /build/hishtory/backend/server/internal/database/historyentries.go:65
hishtory-server    | [0.311ms] [rows:1] INSERT INTO "enc_history_entries" ("encrypted_data","nonce","device_id","user_id","date","encrypted_id","read_count","is_from_same_device") VALUES ('<binary>','<binary>','518019a7-f0d8-454b-9e8c-72a7b59d1fd6','bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk=','2024-08-09 09:39:24.539','931a6360-ac48-44d4-a4f1-39ee6fa1d34b',0,false)
hishtory-server    |
hishtory-server    | 2024/08/09 09:39:25 /build/hishtory/backend/server/internal/database/historyentries.go:65
hishtory-server    | [0.256ms] [rows:1] INSERT INTO "enc_history_entries" ("encrypted_data","nonce","device_id","user_id","date","encrypted_id","read_count","is_from_same_device") VALUES ('<binary>','<binary>','6f8e44d5-01c1-482e-bdbb-203a0ecc87cf','bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk=','2024-08-09 09:39:24.539','931a6360-ac48-44d4-a4f1-39ee6fa1d34b',0,false)
hishtory-server    |
hishtory-server    | 2024/08/09 09:39:25 /build/hishtory/backend/server/internal/database/historyentries.go:65
hishtory-server    | [0.257ms] [rows:1] INSERT INTO "enc_history_entries" ("encrypted_data","nonce","device_id","user_id","date","encrypted_id","read_count","is_from_same_device") VALUES ('<binary>','<binary>','d5c007fc-a016-4d59-a785-3d70091caea4','bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk=','2024-08-09 09:39:24.539','931a6360-ac48-44d4-a4f1-39ee6fa1d34b',0,false)
hishtory-server    |
hishtory-server    | 2024/08/09 09:39:25 /build/hishtory/backend/server/internal/database/historyentries.go:65
hishtory-server    | [0.269ms] [rows:1] INSERT INTO "enc_history_entries" ("encrypted_data","nonce","device_id","user_id","date","encrypted_id","read_count","is_from_same_device") VALUES ('<binary>','<binary>','e6df28c2-01ca-41d1-a2d9-f274b63c18e3','bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk=','2024-08-09 09:39:24.539','931a6360-ac48-44d4-a4f1-39ee6fa1d34b',0,false)
hishtory-server    |
hishtory-server    | 2024/08/09 09:39:25 /build/hishtory/backend/server/internal/database/historyentries.go:65
hishtory-server    | [0.415ms] [rows:1] INSERT INTO "enc_history_entries" ("encrypted_data","nonce","device_id","user_id","date","encrypted_id","read_count","is_from_same_device") VALUES ('<binary>','<binary>','f58cfa7d-f019-48ec-80fc-35ebc30853e4','bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk=','2024-08-09 09:39:24.539','931a6360-ac48-44d4-a4f1-39ee6fa1d34b',0,false)

Looking at the server logs it seems one query hits the main server many times over...
And it looks quite strange to me. I'm a developer of the app, yet it looks malfunctioning since device ID is different in each query.

Thanks for this. I'll have  try this weekend but I went through and tried purging one machine and restarting the init but now that fails. It says can't connect but I suspect it's a timeout b/c of the size of the data. I use it dockerized so have to figure out how to apply a hotfix to the docker image!
Just fyi the logs are -
client side:
time="2024-08-09T13:00:54-04:00" level=info msg="github.com/ddworken/hishtory/client/cmd/saveHistoryEntry.go:244 database is locked (261)\n[0.038ms] [rows:0] SELECT * FROM `history_entries` WHERE true AND ((instr(current_working_directory, \"~\") > 0 OR instr(REPLACE(current_working_directory, '~/', home_directory), \"~\") > 0)) AND (CAST(strftime(\"%s\",start_time) AS INTEGER) = \"1723222837\") AND (CAST(strftime(\"%s\",end_time) AS INTEGER) = \"0\") AND command = \"nano .bashrc\" AND device_id = \"3a3170b0-ca22-450e-a3a0-9877e086ec64\"" fromSQL=true
time="2024-08-09T13:00:55-04:00" level=info msg="failed to find presaved entry matching cmd=\"nano .bashrc\" even with retry, skipping delete"
time="2024-08-09T13:00:55-04:00" level=info msg="ApiPost(\"http://<IP_ADDRESS>:2274/api/v1/submit?source_device_id=3a3170b0-ca22-450e-a3a0-9877e086ec64\"): 48 bytes - 13.764472ms\n"
time="2024-08-09T13:01:08-04:00" level=info msg="ApiGet(\"http://<IP_ADDRESS>/api/v1/register?user_id=bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk=&device_id=5e8ec7c8-3d96-4ad3-93c1-22d31c5afd60\"): 0 bytes - 69.471309ms\n"
time="2024-08-09T13:06:55-04:00" level=info msg="ApiGet(\"http://<IP_ADDRESS>:2274/api/v1/register?user_id=bhPQNr-RyCH2YKMumqANvER6ClwCZbAErp1DsVKufOk=&device_id=f531c143-8423-4c80-908d-8fd92ede2e51\"): 0 bytes - 6.117846ms\n"

Client stdout
Setting secret hishtory key to xxxx-xxxx-xxxx-xxxx-xxxxx
2024/08/09 13:06:28 hishtory v0.302 fatal error at github.com/ddworken/hishtory/client/cmd/install.go:86: failed to register device with backend: failed to GET http://<IP_ADDRESS>:2247/api/v1/register?user_id=redacted=&device_id=redacted: Get "http://<IP_ADDRESS>:2247/api/v1/register?user_id=redacted=&device_id=redacted": dial tcp <IP_ADDRESS>:2247: connect: connection refused

Server side
hishtory-server    | 2024/08/09 17:16:28 /build/hishtory/backend/server/internal/database/historyentries.go:23 SLOW SQL >= 1s
hishtory-server    | [32482.109ms] [rows:8262533] SELECT * FROM "enc_history_entries" WHERE user_id = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx='
hishtory-server    | apiBootstrapHandler: Found 8262533 entries
hishtory-server    | Opening DB
hishtory-server    | Connecting to DB
hishtory-server    | AutoMigrating DB tables
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:145
hishtory-server    | [8.282ms] [rows:1] SELECT count(*) FROM information_schema.tables WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'enc_history_entries' AND table_type = 'BASE TABLE'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:20
hishtory-server    | [0.240ms] [rows:1] SELECT CURRENT_DATABASE()
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:330
hishtory-server    | [14.589ms] [rows:-] SELECT c.column_name, c.is_nullable = 'YES', c.udt_name, c.character_maximum_length, c.numeric_precision, c.numeric_precision_radix, c.numeric_scale, c.datetime_precision, 8 * typlen, c.column_default, pd.description FROM information_schema.columns AS c JOIN pg_type AS pgt ON c.udt_name = pgt.typname LEFT JOIN pg_catalog.pg_description as pd ON pd.objsubid = c.ordinal_position AND pd.objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = c.table_name AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = c.table_schema)) where table_catalog = 'hishtory' AND table_schema = CURRENT_SCHEMA() AND table_name = 'enc_history_entries'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:331
hishtory-server    | [10.474ms] [rows:-] SELECT * FROM "enc_history_entries" LIMIT 1
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:390
hishtory-server    | [15.212ms] [rows:-] SELECT c.column_name, constraint_type FROM information_schema.table_constraints tc JOIN information_schema.constraint_column_usage AS ccu USING (constraint_schema, constraint_name) JOIN information_schema.columns AS c ON c.table_schema = tc.constraint_schema AND tc.table_name = c.table_name AND ccu.column_name = c.column_name WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND c.table_catalog = 'hishtory' AND c.table_schema = CURRENT_SCHEMA() AND c.table_name = 'enc_history_entries'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:419
hishtory-server    | [1.962ms] [rows:-] SELECT a.attname as column_name, format_type(a.atttypid, a.atttypmod) AS data_type
hishtory-server    |            FROM pg_attribute a JOIN pg_class b ON a.attrelid = b.relfilenode AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA())
hishtory-server    |            WHERE a.attnum > 0 -- hide internal columns
hishtory-server    |            AND NOT a.attisdropped -- hide deleted columns
hishtory-server    |            AND b.relname = 'enc_history_entries'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [15.433ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'enc_history_entries' AND column_name = 'encrypted_data') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'enc_history_entries' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [5.136ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'enc_history_entries' AND column_name = 'nonce') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'enc_history_entries' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [1.918ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'enc_history_entries' AND column_name = 'device_id') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'enc_history_entries' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [3.340ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'enc_history_entries' AND column_name = 'user_id') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'enc_history_entries' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [2.836ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'enc_history_entries' AND column_name = 'date') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'enc_history_entries' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [3.794ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'enc_history_entries' AND column_name = 'encrypted_id') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'enc_history_entries' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:20
hishtory-server    | [0.637ms] [rows:1] SELECT CURRENT_DATABASE()
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:330
hishtory-server    | [6.478ms] [rows:-] SELECT c.column_name, c.is_nullable = 'YES', c.udt_name, c.character_maximum_length, c.numeric_precision, c.numeric_precision_radix, c.numeric_scale, c.datetime_precision, 8 * typlen, c.column_default, pd.description FROM information_schema.columns AS c JOIN pg_type AS pgt ON c.udt_name = pgt.typname LEFT JOIN pg_catalog.pg_description as pd ON pd.objsubid = c.ordinal_position AND pd.objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = c.table_name AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = c.table_schema)) where table_catalog = 'hishtory' AND table_schema = CURRENT_SCHEMA() AND table_name = 'enc_history_entries'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:331
hishtory-server    | [0.783ms] [rows:-] SELECT * FROM "enc_history_entries" LIMIT 1
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:390
hishtory-server    | [7.394ms] [rows:-] SELECT c.column_name, constraint_type FROM information_schema.table_constraints tc JOIN information_schema.constraint_column_usage AS ccu USING (constraint_schema, constraint_name) JOIN information_schema.columns AS c ON c.table_schema = tc.constraint_schema AND tc.table_name = c.table_name AND ccu.column_name = c.column_name WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND c.table_catalog = 'hishtory' AND c.table_schema = CURRENT_SCHEMA() AND c.table_name = 'enc_history_entries'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:419
hishtory-server    | [0.530ms] [rows:-] SELECT a.attname as column_name, format_type(a.atttypid, a.atttypmod) AS data_type
hishtory-server    |            FROM pg_attribute a JOIN pg_class b ON a.attrelid = b.relfilenode AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA())
hishtory-server    |            WHERE a.attnum > 0 -- hide internal columns
hishtory-server    |            AND NOT a.attisdropped -- hide deleted columns
hishtory-server    |            AND b.relname = 'enc_history_entries'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:252
hishtory-server    | [2.152ms] [rows:0] ALTER TABLE "enc_history_entries" ALTER COLUMN "read_count" TYPE bigint
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [4.767ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'enc_history_entries' AND column_name = 'read_count') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'enc_history_entries' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [1.499ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'enc_history_entries' AND column_name = 'is_from_same_device') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'enc_history_entries' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:145
hishtory-server    | [0.540ms] [rows:1] SELECT count(*) FROM information_schema.tables WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'devices' AND table_type = 'BASE TABLE'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:20
hishtory-server    | [0.129ms] [rows:1] SELECT CURRENT_DATABASE()
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:330
hishtory-server    | [4.213ms] [rows:-] SELECT c.column_name, c.is_nullable = 'YES', c.udt_name, c.character_maximum_length, c.numeric_precision, c.numeric_precision_radix, c.numeric_scale, c.datetime_precision, 8 * typlen, c.column_default, pd.description FROM information_schema.columns AS c JOIN pg_type AS pgt ON c.udt_name = pgt.typname LEFT JOIN pg_catalog.pg_description as pd ON pd.objsubid = c.ordinal_position AND pd.objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = c.table_name AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = c.table_schema)) where table_catalog = 'hishtory' AND table_schema = CURRENT_SCHEMA() AND table_name = 'devices'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:331
hishtory-server    | [0.368ms] [rows:-] SELECT * FROM "devices" LIMIT 1
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:390
hishtory-server    | [9.200ms] [rows:-] SELECT c.column_name, constraint_type FROM information_schema.table_constraints tc JOIN information_schema.constraint_column_usage AS ccu USING (constraint_schema, constraint_name) JOIN information_schema.columns AS c ON c.table_schema = tc.constraint_schema AND tc.table_name = c.table_name AND ccu.column_name = c.column_name WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND c.table_catalog = 'hishtory' AND c.table_schema = CURRENT_SCHEMA() AND c.table_name = 'devices'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:419
hishtory-server    | [0.608ms] [rows:-] SELECT a.attname as column_name, format_type(a.atttypid, a.atttypmod) AS data_type
hishtory-server    |            FROM pg_attribute a JOIN pg_class b ON a.attrelid = b.relfilenode AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA())
hishtory-server    |            WHERE a.attnum > 0 -- hide internal columns
hishtory-server    |            AND NOT a.attisdropped -- hide deleted columns
hishtory-server    |            AND b.relname = 'devices'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [0.276ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'devices' AND column_name = 'user_id') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'devices' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [0.217ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'devices' AND column_name = 'device_id') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'devices' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [0.397ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'devices' AND column_name = 'registration_ip') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'devices' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [0.286ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'devices' AND column_name = 'registration_date') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'devices' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [0.302ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'devices' AND column_name = 'is_integration_test_device') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'devices' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [0.315ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'devices' AND column_name = 'uninstall_date') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'devices' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:145
hishtory-server    | [3.921ms] [rows:1] SELECT count(*) FROM information_schema.tables WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'usage_data' AND table_type = 'BASE TABLE'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:20
hishtory-server    | [0.120ms] [rows:1] SELECT CURRENT_DATABASE()
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:330
hishtory-server    | [4.886ms] [rows:-] SELECT c.column_name, c.is_nullable = 'YES', c.udt_name, c.character_maximum_length, c.numeric_precision, c.numeric_precision_radix, c.numeric_scale, c.datetime_precision, 8 * typlen, c.column_default, pd.description FROM information_schema.columns AS c JOIN pg_type AS pgt ON c.udt_name = pgt.typname LEFT JOIN pg_catalog.pg_description as pd ON pd.objsubid = c.ordinal_position AND pd.objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = c.table_name AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = c.table_schema)) where table_catalog = 'hishtory' AND table_schema = CURRENT_SCHEMA() AND table_name = 'usage_data'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:331
hishtory-server    | [0.983ms] [rows:-] SELECT * FROM "usage_data" LIMIT 1
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:390
hishtory-server    | [7.219ms] [rows:-] SELECT c.column_name, constraint_type FROM information_schema.table_constraints tc JOIN information_schema.constraint_column_usage AS ccu USING (constraint_schema, constraint_name) JOIN information_schema.columns AS c ON c.table_schema = tc.constraint_schema AND tc.table_name = c.table_name AND ccu.column_name = c.column_name WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND c.table_catalog = 'hishtory' AND c.table_schema = CURRENT_SCHEMA() AND c.table_name = 'usage_data'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:419
hishtory-server    | [0.418ms] [rows:-] SELECT a.attname as column_name, format_type(a.atttypid, a.atttypmod) AS data_type
hishtory-server    |            FROM pg_attribute a JOIN pg_class b ON a.attrelid = b.relfilenode AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA())
hishtory-server    |            WHERE a.attnum > 0 -- hide internal columns
hishtory-server    |            AND NOT a.attisdropped -- hide deleted columns
hishtory-server    |            AND b.relname = 'usage_data'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [3.147ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'usage_data' AND column_name = 'user_id') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'usage_data' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [6.845ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'usage_data' AND column_name = 'device_id') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'usage_data' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [2.626ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'usage_data' AND column_name = 'last_used') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'usage_data' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [2.766ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'usage_data' AND column_name = 'last_ip') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'usage_data' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:20
hishtory-server    | [0.364ms] [rows:1] SELECT CURRENT_DATABASE()
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:330
hishtory-server    | [7.755ms] [rows:-] SELECT c.column_name, c.is_nullable = 'YES', c.udt_name, c.character_maximum_length, c.numeric_precision, c.numeric_precision_radix, c.numeric_scale, c.datetime_precision, 8 * typlen, c.column_default, pd.description FROM information_schema.columns AS c JOIN pg_type AS pgt ON c.udt_name = pgt.typname LEFT JOIN pg_catalog.pg_description as pd ON pd.objsubid = c.ordinal_position AND pd.objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = c.table_name AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = c.table_schema)) where table_catalog = 'hishtory' AND table_schema = CURRENT_SCHEMA() AND table_name = 'usage_data'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:331
hishtory-server    | [1.630ms] [rows:-] SELECT * FROM "usage_data" LIMIT 1
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:390
hishtory-server    | [8.406ms] [rows:-] SELECT c.column_name, constraint_type FROM information_schema.table_constraints tc JOIN information_schema.constraint_column_usage AS ccu USING (constraint_schema, constraint_name) JOIN information_schema.columns AS c ON c.table_schema = tc.constraint_schema AND tc.table_name = c.table_name AND ccu.column_name = c.column_name WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND c.table_catalog = 'hishtory' AND c.table_schema = CURRENT_SCHEMA() AND c.table_name = 'usage_data'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:419
hishtory-server    | [1.058ms] [rows:-] SELECT a.attname as column_name, format_type(a.atttypid, a.atttypmod) AS data_type
hishtory-server    |            FROM pg_attribute a JOIN pg_class b ON a.attrelid = b.relfilenode AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA())
hishtory-server    |            WHERE a.attnum > 0 -- hide internal columns
hishtory-server    |            AND NOT a.attisdropped -- hide deleted columns
hishtory-server    |            AND b.relname = 'usage_data'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:252
hishtory-server    | [0.746ms] [rows:0] ALTER TABLE "usage_data" ALTER COLUMN "num_entries_handled" TYPE bigint
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [0.443ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'usage_data' AND column_name = 'num_entries_handled') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'usage_data' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [0.246ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'usage_data' AND column_name = 'last_queried') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'usage_data' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:20
hishtory-server    | [0.259ms] [rows:1] SELECT CURRENT_DATABASE()
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:330
hishtory-server    | [4.216ms] [rows:-] SELECT c.column_name, c.is_nullable = 'YES', c.udt_name, c.character_maximum_length, c.numeric_precision, c.numeric_precision_radix, c.numeric_scale, c.datetime_precision, 8 * typlen, c.column_default, pd.description FROM information_schema.columns AS c JOIN pg_type AS pgt ON c.udt_name = pgt.typname LEFT JOIN pg_catalog.pg_description as pd ON pd.objsubid = c.ordinal_position AND pd.objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = c.table_name AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = c.table_schema)) where table_catalog = 'hishtory' AND table_schema = CURRENT_SCHEMA() AND table_name = 'usage_data'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:331
hishtory-server    | [1.224ms] [rows:-] SELECT * FROM "usage_data" LIMIT 1
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:390
hishtory-server    | [6.967ms] [rows:-] SELECT c.column_name, constraint_type FROM information_schema.table_constraints tc JOIN information_schema.constraint_column_usage AS ccu USING (constraint_schema, constraint_name) JOIN information_schema.columns AS c ON c.table_schema = tc.constraint_schema AND tc.table_name = c.table_name AND ccu.column_name = c.column_name WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND c.table_catalog = 'hishtory' AND c.table_schema = CURRENT_SCHEMA() AND c.table_name = 'usage_data'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:419
hishtory-server    | [1.206ms] [rows:-] SELECT a.attname as column_name, format_type(a.atttypid, a.atttypmod) AS data_type
hishtory-server    |            FROM pg_attribute a JOIN pg_class b ON a.attrelid = b.relfilenode AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA())
hishtory-server    |            WHERE a.attnum > 0 -- hide internal columns
hishtory-server    |            AND NOT a.attisdropped -- hide deleted columns
hishtory-server    |            AND b.relname = 'usage_data'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:252
hishtory-server    | [0.529ms] [rows:0] ALTER TABLE "usage_data" ALTER COLUMN "num_queries" TYPE bigint
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [0.271ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'usage_data' AND column_name = 'num_queries') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'usage_data' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [0.221ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'usage_data' AND column_name = 'version') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'usage_data' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:52
hishtory-server    | [1.713ms] [rows:1] SELECT count(*) FROM pg_indexes WHERE tablename = 'usage_data' AND indexname = 'usageDataUniqueIndex' AND schemaname = CURRENT_SCHEMA()
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:145
hishtory-server    | [1.557ms] [rows:1] SELECT count(*) FROM information_schema.tables WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'dump_requests' AND table_type = 'BASE TABLE'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:20
hishtory-server    | [0.098ms] [rows:1] SELECT CURRENT_DATABASE()
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:330
hishtory-server    | [6.586ms] [rows:-] SELECT c.column_name, c.is_nullable = 'YES', c.udt_name, c.character_maximum_length, c.numeric_precision, c.numeric_precision_radix, c.numeric_scale, c.datetime_precision, 8 * typlen, c.column_default, pd.description FROM information_schema.columns AS c JOIN pg_type AS pgt ON c.udt_name = pgt.typname LEFT JOIN pg_catalog.pg_description as pd ON pd.objsubid = c.ordinal_position AND pd.objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = c.table_name AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = c.table_schema)) where table_catalog = 'hishtory' AND table_schema = CURRENT_SCHEMA() AND table_name = 'dump_requests'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:331
hishtory-server    | [0.590ms] [rows:-] SELECT * FROM "dump_requests" LIMIT 1
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:390
hishtory-server    | [5.796ms] [rows:-] SELECT c.column_name, constraint_type FROM information_schema.table_constraints tc JOIN information_schema.constraint_column_usage AS ccu USING (constraint_schema, constraint_name) JOIN information_schema.columns AS c ON c.table_schema = tc.constraint_schema AND tc.table_name = c.table_name AND ccu.column_name = c.column_name WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND c.table_catalog = 'hishtory' AND c.table_schema = CURRENT_SCHEMA() AND c.table_name = 'dump_requests'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:419
hishtory-server    | [0.339ms] [rows:-] SELECT a.attname as column_name, format_type(a.atttypid, a.atttypmod) AS data_type
hishtory-server    |            FROM pg_attribute a JOIN pg_class b ON a.attrelid = b.relfilenode AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA())
hishtory-server    |            WHERE a.attnum > 0 -- hide internal columns
hishtory-server    |            AND NOT a.attisdropped -- hide deleted columns
hishtory-server    |            AND b.relname = 'dump_requests'
hishtory-server    |
hishtory-server    | 2024/08/09 17:18:30 /root/go/pkg/mod/gorm.io/driver/postgres@v1.3.1/migrator.go:218
hishtory-server    | [0.321ms] [rows:0] SELECT description FROM pg_catalog.pg_description WHERE objsubid = (SELECT ordinal_position FROM information_schema.columns WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'dump_requests' AND column_name = 'user_id') AND objoid = (SELECT oid FROM pg_catalog.pg_class WHERE relname = 'dump_requests' AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = CURRENT_SCHEMA()))
hishtory-server    |