| 2903 |
10.1 s
|
idle in transaction (aborted)
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15074 |
10.1 s
|
idle in transaction (aborted)
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 17143 |
10.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2641 |
9.9 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 3006 |
9.9 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2972 |
9.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2908 |
9.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 3011 |
9.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2933 |
9.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15080 |
9.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 3028 |
9.3 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2925 |
9.2 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 3002 |
9.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26023 |
9.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2988 |
9.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26057 |
9.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2878 |
8.9 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15104 |
8.9 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2993 |
8.9 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2955 |
8.8 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2926 |
8.8 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2830 |
8.8 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2946 |
8.7 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2867 |
8.6 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2989 |
8.6 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15220 |
8.6 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26081 |
8.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15144 |
8.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2950 |
8.2 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15102 |
8.2 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26024 |
8.2 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2967 |
8.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26112 |
8.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2843 |
8.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2951 |
8.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26068 |
8.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2885 |
7.7 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 3016 |
7.6 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15079 |
7.5 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 17227 |
7.5 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2963 |
7.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2886 |
7.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2659 |
7.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2929 |
7.3 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2943 |
7.3 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26532 |
7.3 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15340 |
7.3 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2973 |
7.2 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 5294 |
7.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2938 |
7.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26070 |
7.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 3051 |
7.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15153 |
6.9 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26046 |
6.9 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2891 |
6.9 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2874 |
6.8 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2847 |
6.8 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15077 |
6.7 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2842 |
6.7 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2916 |
6.6 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26203 |
6.5 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15212 |
6.5 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26208 |
6.5 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 3005 |
6.5 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 3049 |
6.5 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26236 |
6.5 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15107 |
6.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26027 |
6.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15097 |
6.3 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 17098 |
6.3 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2918 |
6.2 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2880 |
6.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2846 |
6.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15109 |
5.9 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15223 |
5.9 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26188 |
5.8 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15115 |
5.7 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2914 |
5.6 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 20946 |
5.6 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2983 |
5.5 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26275 |
5.5 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 3012 |
5.5 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15136 |
5.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26286 |
5.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 3032 |
5.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2866 |
5.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2912 |
4.9 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26107 |
4.7 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26186 |
4.7 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2901 |
4.7 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26271 |
4.7 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2854 |
4.7 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 3050 |
4.7 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2860 |
4.6 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2953 |
4.6 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2977 |
4.6 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 3055 |
4.5 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15205 |
4.5 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2952 |
4.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15219 |
4.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 25781 |
4.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2942 |
4.3 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15204 |
4.2 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15121 |
4.2 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2877 |
4.2 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2905 |
4.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15249 |
4.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26291 |
3.9 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15261 |
3.9 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 17095 |
3.8 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2828 |
3.8 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2909 |
3.6 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15083 |
3.6 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 17135 |
3.5 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15095 |
3.5 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 25819 |
3.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 25321 |
3.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2653 |
3.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2931 |
3.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15312 |
3.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 25782 |
3.3 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15353 |
3.3 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15346 |
3.2 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 25791 |
3.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26306 |
3.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 5809 |
2.6 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 3003 |
2.6 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15247 |
2.6 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2662 |
2.5 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2935 |
2.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15176 |
2.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 25314 |
2.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 25322 |
2.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 2915 |
1.6 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 25357 |
1.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26534 |
0.7 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26566 |
0.4 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 3015 |
0.4 s
|
idle in transaction (aborted)
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
INSERT INTO "conversations" ("organization_id", "public_id", "employee_id", "client_id", "customer_account_id", "reference_id", "created_at", "updated_at", "review_completed_at", "started_at", "ended_at", "transcript", "summary", "previous_context", "previous_sentiment_score", "subject", "external_created_at", "data_source_id", "external_id", "external_url", "agent_summary", "summary_embedding", "closed_at", "handling_time", "compliance_review_id", "interaction_type", "search_vector", "sla_breach_last_checked_at", "active_evaluation_id", "organization_data_source_id", "customer_issue_id", "agent_knowledge_gap_id", "customer_sentiment_score", "customer_sentiment_score_calculated_at", "custom_attributes", "qa_score_ai", "qa_score_human", "qa_score_effective", "qa_score_updated_at", "conversation_upload_id", "follow_up_conversations_checked_at", "priority", "ticket_type", "live_summary", "resolved_at", "language", "review_status", "ticket_status", "conversation_thread_id", "transcription_state", "translation_state", "evaluation_state", "zendesk_brand_id", "group_id", "qa_auto_fail", "channel_types", "assignee_id", "resolver_id", "review_resolved_at", "review_comment", "jira_service_desk_id", "jira_request_type_id", "zendesk_channel", "ticket_tags", "churn_risk_summary", "churn_risk_level", "customer_sentiment_summary", "customer_sentiment_title", "requester_id", "company_id", "source_channel", "resolver_slack_id", "qa_risk_level", "complaint_risk_level", "dispute_risk_level", "service_issue_risk_level", "product_issue_risk_level", "compliance_risk_level", "risk_level", "risk_level_updated_at", "first_agent_response_at", "first_customer_response_at", "requester_employee_id", "sla_breaches_count", "jira_issue_key", "assignee_membership_id", "duplicate_of_id", "first_customer_message_at", "first_agent_reply_at", "first_responder_id", "time_to_first_response_seconds", "resolution_time_seconds", "first_resolved_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93) RETURNING "id"
|
| 26637 |
0.2 s
|
idle in transaction
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_job_executions"."active_job_id" FROM "good_job_executions" INNER JOIN "good_jobs" ON "good_jobs"."id" = "good_job_executions"."active_job_id" WHERE "good_jobs"."concurrency_key" = $1 AND "good_job_executions"."created_at" > $2 AND ("good_job_executions"."error" IS NULL OR "good_job_executions"."error" != $3) ORDER BY "good_job_executions"."created_at" ASC LIMIT $4
|
| 2937 |
0.2 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 15334 |
0.2 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 26486 |
0.2 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 25312 |
0.2 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 26467 |
0.2 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 3047 |
0.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 15311 |
0.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 27403 |
0.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 27405 |
0.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 26469 |
0.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 26606 |
0.1 s
|
idle in transaction
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
INSERT INTO "good_job_executions" ("created_at", "updated_at", "active_job_id", "job_class", "queue_name", "serialized_params", "scheduled_at", "finished_at", "error", "error_event", "error_backtrace", "process_id", "duration") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id"
|
| 27407 |
0.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 27406 |
0.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 15096 |
0.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 27408 |
0.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 26457 |
0.1 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 15166 |
0.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 15085 |
0.0 s
|
idle in transaction
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
UPDATE "conversation_threads" SET "public_id" = $1, "updated_at" = $2 WHERE "conversation_threads"."id" = $3
|
| 15269 |
0.0 s
|
idle in transaction
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT pg_advisory_xact_lock(('x'||substr(md5($1::text), 1, 16))::bit(64)::bigint)::text AS locked
|
| 15152 |
0.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 26521 |
0.0 s
|
idle in transaction
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT COUNT(*) FROM "good_jobs" LEFT JOIN pg_locks ON pg_locks.locktype = 'advisory' AND pg_locks.objsubid = 1 AND pg_locks.classid = ('x' || substr(md5('good_jobs' || '-' || "good_jobs"."id"::text), 1, 16))::bit(32)::int AND pg_locks.objid = (('x' || substr(md5('good_jobs' || '-' || "good_jobs"."id"::text), 1, 16))::bit(64) << 32)::bit(32)::int WHERE "good_jobs"."concurrency_key" = $1 AND "good_jobs"."finished_at" IS NULL AND "pg_locks"."locktype" IS NULL
|
| 2999 |
0.0 s
|
idle in transaction
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "pg_search_documents".* FROM "pg_search_documents" WHERE "pg_search_documents"."searchable_id" = $1 AND "pg_search_documents"."searchable_type" = $2 LIMIT $3
|
| 2640 |
0.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 15335 |
0.0 s
|
idle in transaction
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT COUNT(*) FROM "good_jobs" LEFT JOIN pg_locks ON pg_locks.locktype = 'advisory' AND pg_locks.objsubid = 1 AND pg_locks.classid = ('x' || substr(md5('good_jobs' || '-' || "good_jobs"."id"::text), 1, 16))::bit(32)::int AND pg_locks.objid = (('x' || substr(md5('good_jobs' || '-' || "good_jobs"."id"::text), 1, 16))::bit(64) << 32)::bit(32)::int WHERE "good_jobs"."concurrency_key" = $1 AND "good_jobs"."finished_at" IS NULL AND "pg_locks"."locktype" IS NULL
|
| 19216 |
0.0 s
|
idle in transaction
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "pg_search_documents".* FROM "pg_search_documents" WHERE "pg_search_documents"."searchable_id" = $1 AND "pg_search_documents"."searchable_type" = $2 LIMIT $3
|
| 3007 |
0.0 s
|
active
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
SELECT "good_jobs"."id", "good_jobs"."queue_name", "good_jobs"."priority", "good_jobs"."serialized_params", "good_jobs"."scheduled_at", "good_jobs"."performed_at", "good_jobs"."finished_at", "good_jobs"."error", "good_jobs"."created_at", "good_jobs"."updated_at", "good_jobs"."active_job_id", "good_jobs"."concurrency_key", "good_jobs"."cron_key", "good_jobs"."cron_at", "good_jobs"."batch_id", "good_jobs"."batch_callback_id", "good_jobs"."executions_count", "good_jobs"."job_class", "good_jobs"."error_event", "good_jobs"."labels", "good_jobs"."locked_by_id", "good_jobs"."locked_at" FROM "good_jobs" WHERE "good_jobs"."id" IN (WITH "rows" AS MATERIALIZED (SELECT "good_jobs"."id" FROM "good_jobs" WHERE "good_jobs"."finished_at" IS NULL AND "good_jobs"."scheduled_at" <= $1 ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC) SELECT "rows"."id" FROM "rows" WHERE pg_try_advisory_lock(('x' || substr(md5('good_jobs' || '-' || "rows"."id"::text), 1, 16))::bit(64)::bigint) LIMIT $2) ORDER BY priority ASC NULLS LAST, "good_jobs"."created_at" ASC
|
| 2859 |
-0.0 s
|
idle in transaction
|
|
/usr/local/bundle/ruby/3.3.0/bin/good_job flightcontrol
UPDATE "good_jobs" SET "performed_at" = $1, "updated_at" = $2, "executions_count" = $3, "locked_by_id" = $4, "locked_at" = $5 WHERE "good_jobs"."id" = $6
|