[2024-12-25 12:18:54] Connected
openchs.public> set role jscs
[2024-12-25 12:18:55] completed in 30 ms
[2024-12-25 12:19:03] transaction rolled back: @console_19 [openchs@prod]
openchs: jscs, public> set role jscs
[2024-12-25 12:19:12] completed in 32 ms
openchs: jscs, public> begin transaction
[2024-12-25 12:19:14] [25001] there is already a transaction in progress
[2024-12-25 12:19:14] completed in 64 ms
openchs: jscs, public> SELECT id FROM users where username = 'himeshR'
[2024-12-25 12:19:18] 1 row retrieved starting from 1 in 131 ms (execution: 53 ms, fetching: 78 ms)
openchs: jscs, public> select count(*) from location_location_mapping
                       where last_modified_date_time < now()::date
[2024-12-25 12:19:21] 1 row retrieved starting from 1 in 839 ms (execution: 815 ms, fetching: 24 ms)
openchs: jscs, public> UPDATE location_location_mapping llm
                       SET
                           last_modified_date_time = current_timestamp + random() * 5000 * (interval '1 millisecond'),
                           last_modified_by_id     = 5516
[2024-12-25 12:19:39] 8,770 rows affected in 11 s 906 ms
openchs: jscs, public> select count(*) from location_location_mapping
                       where last_modified_date_time > now() - interval '2 min'
[2024-12-25 12:19:45] 1 row retrieved starting from 1 in 65 ms (execution: 47 ms, fetching: 18 ms)
openchs: jscs, public> select current_timestamp, min(last_modified_date_time), max(last_modified_date_time) from location_location_mapping
[2024-12-25 12:19:55] 1 row retrieved starting from 1 in 1 s 464 ms (execution: 1 s 427 ms, fetching: 37 ms)
openchs: jscs, public> commit
[2024-12-25 12:20:33] completed in 36 ms
[2024-12-25 12:20:35] transaction committed: @console_19 [openchs@prod]