Live Queries

2 queries

Pid	Duration	State
2838668	9.4 s	active
sickadmin `SELECT To_Char(Min("DeviceDtm"), 'YYYY-MM-DD HH24:MI:SS') as "DeviceDtm" FROM "CpcbSyncTracker" WHERE "Uploaded" = 0 AND "DeviceDtm" < now()::timestamp - INTERVAL '30 min'`
2837913	-0.1 s	active
sickadmin `UPDATE "DeviceState" SET "DeviceStatus" = $1, "LastConnStatus" = $2, "ConnDesc" = $3 WHERE "DeviceId" = $4`

You may need to restart your app servers afterwards.