-
-
Save wezell/ac22bcb1903abb2a9a321c6005ef3461 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
template1=# \c dotcms | |
You are now connected to database "dotcms" as user "postgres". | |
dotcms=# SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, | |
dotcms-# pg_stat_get_backend_activity(S.backendid) AS current_query | |
dotcms-# FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
procpid | current_query | |
---------+----------------------------------------------------------------------------------------------------------------------------------------------------------- | |
6900 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6902 | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
6903 | select count(*) as count from dist_reindex_journal | |
6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6905 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6906 | select * from workflow_step where scheme_id = $1 order by my_order | |
6907 | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
6908 | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
6909 | lock table dist_reindex_journal | |
11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12131 | select * from workflow_action_class_pars where workflow_action_class_id = $1 | |
12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12187 | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12393 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12445 | SELECT * FROM cluster_server_action | |
12981 | SELECT 1 | |
12982 | SELECT 1 | |
13130 | COMMIT | |
13704 | SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, + | |
| pg_stat_get_backend_activity(S.backendid) AS current_query + | |
| FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
(26 rows) | |
dotcms=# SELECT pg_cancel_backend(6909); | |
pg_cancel_backend | |
------------------- | |
t | |
(1 row) | |
dotcms=# SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, | |
pg_stat_get_backend_activity(S.backendid) AS current_query | |
FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
procpid | cur | |
rent_query | |
---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
6900 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6902 | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
6903 | select count(*) as count from dist_reindex_journal | |
6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6905 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6906 | SELECT * FROM load_records_to_index($1, $2, $3) | |
6907 | select layoutsrol0_.id as id, layoutsrol0_.layout_id as layout_id, layoutsrol0_.role_id as role_id from layouts_cms_roles layoutsrol0_ where (role_id=$1 ) | |
6908 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
6909 | select inode.inode as inode, owner, idate as idate, name, description, default_structure, page_detail, structuretype, system, fixed, velocity_var_name , url_map_pattern , host, folder, expire_date_var , publish_date_var , mod_d | |
ate from inode, structure where inode.type='structure' and inode.inode = structure.inode and (inode.inode like $1 or name like $2 or velocity_var_name like $3) and 1=1 and structuretype>=$4 and structuretype<= $5 order by name desc | |
11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12131 | select * from workflow_action_class_pars where workflow_action_class_id = $1 | |
12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12187 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12393 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12445 | SELECT 1 | |
12981 | SELECT 1 | |
12982 | lock table dist_reindex_journal | |
13130 | SELECT 1 | |
13704 | SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, | |
+ | |
| pg_stat_get_backend_activity(S.backendid) AS current_query | |
+ | |
| FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
(26 rows) | |
dotcms=# SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, | |
pg_stat_get_backend_activity(S.backendid) AS current_query | |
FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
procpid | current_query | |
---------+------------------------------------------------------------------------------------------------------------------------------------------------------------ | |
6900 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6902 | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
6903 | select count(*) as count from dist_reindex_journal | |
6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6905 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6906 | SELECT * FROM load_records_to_index($1, $2, $3) | |
6907 | select layoutsrol0_.id as id, layoutsrol0_.layout_id as layout_id, layoutsrol0_.role_id as role_id from layouts_cms_roles layoutsrol0_ where (role_id=$1 ) | |
6908 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
6909 | SELECT * FROM cluster_server_action | |
11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12131 | select * from workflow_action_class_pars where workflow_action_class_id = $1 | |
12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12187 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12393 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12445 | SELECT 1 | |
12981 | SELECT 1 | |
12982 | lock table dist_reindex_journal | |
13130 | SELECT 1 | |
13704 | SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, + | |
| pg_stat_get_backend_activity(S.backendid) AS current_query + | |
| FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
(26 rows) | |
dotcms=# SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, | |
pg_stat_get_backend_activity(S.backendid) AS current_query | |
FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
procpid | current_query | |
---------+----------------------------------------------------------------------------------------------------------------------------------------------------------- | |
6900 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6902 | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
6903 | select count(*) as count from dist_reindex_journal | |
6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6905 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6906 | SELECT * FROM load_records_to_index($1, $2, $3) | |
6907 | COMMIT | |
6908 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
6909 | COMMIT | |
11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12131 | select * from workflow_action_class_pars where workflow_action_class_id = $1 | |
12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12187 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12393 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12445 | SELECT 1 | |
12981 | SELECT 1 | |
12982 | lock table dist_reindex_journal | |
13130 | SELECT 1 | |
13704 | SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, + | |
| pg_stat_get_backend_activity(S.backendid) AS current_query + | |
| FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
(26 rows) | |
dotcms=# SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, | |
pg_stat_get_backend_activity(S.backendid) AS current_query | |
FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
procpid | current_query | |
---------+----------------------------------------------------------------------------------------------------------------------------------------------------------- | |
6900 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6902 | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
6903 | select count(*) as count from dist_reindex_journal | |
6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6905 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6906 | SELECT * FROM load_records_to_index($1, $2, $3) | |
6907 | select * from workflow_scheme where (archived = $1 or archived = $2) order by name | |
6908 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
6909 | COMMIT | |
11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12131 | select * from workflow_action_class_pars where workflow_action_class_id = $1 | |
12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12187 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12393 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12445 | SELECT 1 | |
12981 | SELECT 1 | |
12982 | lock table dist_reindex_journal | |
13130 | SELECT 1 | |
13704 | SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, + | |
| pg_stat_get_backend_activity(S.backendid) AS current_query + | |
| FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
(26 rows) | |
dotcms=# SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, | |
pg_stat_get_backend_activity(S.backendid) AS current_query | |
FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
procpid | current_query | |
---------+----------------------------------------------------------------------------------------------------------------------------------------------------------- | |
6900 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6902 | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
6903 | select count(*) as count from dist_reindex_journal | |
6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6905 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6906 | SELECT * FROM load_records_to_index($1, $2, $3) | |
6907 | SELECT * FROM cluster_server_action | |
6908 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
6909 | COMMIT | |
11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12131 | select * from workflow_action_class_pars where workflow_action_class_id = $1 | |
12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12187 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12393 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12445 | SELECT 1 | |
12981 | SELECT 1 | |
12982 | lock table dist_reindex_journal | |
13130 | SELECT 1 | |
13704 | SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, + | |
| pg_stat_get_backend_activity(S.backendid) AS current_query + | |
| FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
(26 rows) | |
dotcms=# SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, | |
pg_stat_get_backend_activity(S.backendid) AS current_query | |
FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
procpid | current_query | |
---------+----------------------------------------------------------------------------------------------------------------------------------------------------------- | |
6900 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6902 | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
6903 | select count(*) as count from dist_reindex_journal | |
6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6905 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6906 | SELECT * FROM load_records_to_index($1, $2, $3) | |
6907 | SELECT * FROM cluster_server_action | |
6908 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
6909 | COMMIT | |
11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12131 | select * from workflow_action_class_pars where workflow_action_class_id = $1 | |
12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12187 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12393 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12445 | SELECT 1 | |
12981 | SELECT 1 | |
12982 | lock table dist_reindex_journal | |
13130 | SELECT 1 | |
13704 | SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, + | |
| pg_stat_get_backend_activity(S.backendid) AS current_query + | |
| FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
(26 rows) | |
dotcms=# SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, | |
pg_stat_get_backend_activity(S.backendid) AS current_query | |
FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
procpid | current_query | |
---------+----------------------------------------------------------------------------------------------------------------------------------------------------------- | |
6900 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6902 | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
6903 | select count(*) as count from dist_reindex_journal | |
6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6905 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6906 | SELECT * FROM load_records_to_index($1, $2, $3) | |
6907 | COMMIT | |
6908 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
6909 | COMMIT | |
11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12131 | select * from workflow_action_class_pars where workflow_action_class_id = $1 | |
12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12187 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12393 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12445 | SELECT 1 | |
12981 | SELECT 1 | |
12982 | lock table dist_reindex_journal | |
13130 | SELECT 1 | |
13704 | SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, + | |
| pg_stat_get_backend_activity(S.backendid) AS current_query + | |
| FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
(26 rows) | |
dotcms=# SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, | |
pg_stat_get_backend_activity(S.backendid) AS current_query | |
FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
procpid | current_query | |
---------+----------------------------------------------------------------------------------------------------------------------------------------------------------- | |
6900 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6902 | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
6903 | select count(*) as count from dist_reindex_journal | |
6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6905 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6906 | SELECT * FROM load_records_to_index($1, $2, $3) | |
6907 | SELECT * FROM cluster_server_action | |
6908 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
6909 | COMMIT | |
11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12131 | select * from workflow_action_class_pars where workflow_action_class_id = $1 | |
12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12187 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12393 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12445 | SELECT 1 | |
12981 | SELECT 1 | |
12982 | lock table dist_reindex_journal | |
13130 | SELECT 1 | |
13704 | SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, + | |
| pg_stat_get_backend_activity(S.backendid) AS current_query + | |
| FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
(26 rows) | |
dotcms=# SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, | |
pg_stat_get_backend_activity(S.backendid) AS current_query | |
FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
procpid | current_query | |
---------+----------------------------------------------------------------------------------------------------------------------------------------------------------- | |
6900 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6902 | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
6903 | COMMIT | |
6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
6905 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
6906 | SELECT * FROM load_records_to_index($1, $2, $3) | |
6907 | SELECT * FROM cluster_server_action | |
6908 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
6909 | SELECT 1 | |
11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12131 | select * from workflow_action_class_pars where workflow_action_class_id = $1 | |
12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12187 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12393 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
12445 | SELECT 1 | |
12981 | SELECT 1 | |
12982 | lock table dist_reindex_journal | |
13130 | SELECT 1 | |
13704 | SELECT pg_stat_get_backend_pid(S.backendid) AS procpid, + | |
| pg_stat_get_backend_activity(S.backendid) AS current_query + | |
| FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S; | |
(26 rows) | |
dotcms=# SELECT * from pg_stat_activity ; | |
datid | datname | pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_chang | |
e | waiting | state | query | |
-------+---------+-------+----------+--------------+------------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------- | |
-----------+---------+---------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------- | |
31933 | dotcms | 6900 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57388 | 2018-09-14 17:31:57.271675-04 | 2018-10-12 14:45:39.556345-04 | 2018-10-12 14:45:39.561937-04 | 2018-10-12 14:45:39 | |
.561938-04 | t | active | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
31933 | dotcms | 6901 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57390 | 2018-09-14 17:31:57.308403-04 | 2018-10-12 14:54:18.996372-04 | 2018-10-12 14:54:18.99678-04 | 2018-10-12 14:54:18 | |
.99678-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 6902 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57392 | 2018-09-14 17:31:57.312366-04 | 2018-10-12 14:41:47.486862-04 | 2018-10-12 15:20:19.584792-04 | 2018-10-12 15:20:19 | |
.584966-04 | f | idle in transaction | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
31933 | dotcms | 6903 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57394 | 2018-09-14 17:31:57.316155-04 | | 2018-10-12 15:20:40.253233-04 | 2018-10-12 15:20:40 | |
.253278-04 | f | idle | COMMIT | |
31933 | dotcms | 6904 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57396 | 2018-09-14 17:31:57.32024-04 | 2018-10-12 14:54:02.870285-04 | 2018-10-12 14:54:02.870757-04 | 2018-10-12 14:54:02 | |
.870758-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 6905 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57398 | 2018-09-14 17:31:57.323685-04 | 2018-10-12 14:41:58.697576-04 | 2018-10-12 14:41:58.698472-04 | 2018-10-12 14:41:58 | |
.698473-04 | t | active | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
31933 | dotcms | 6906 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57400 | 2018-09-14 17:31:57.326938-04 | 2018-10-12 15:20:20.093687-04 | 2018-10-12 15:20:20.093737-04 | 2018-10-12 15:20:20 | |
.093737-04 | t | active | SELECT * FROM load_records_to_index($1, $2, $3) | |
31933 | dotcms | 6907 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57404 | 2018-09-14 17:31:57.330384-04 | | 2018-10-12 15:20:57.530946-04 | 2018-10-12 15:20:57 | |
.530958-04 | f | idle | COMMIT | |
31933 | dotcms | 6908 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57406 | 2018-09-14 17:31:57.33425-04 | 2018-10-12 14:44:19.383455-04 | 2018-10-12 15:20:19.586526-04 | 2018-10-12 15:20:19 | |
.586539-04 | f | idle in transaction | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
31933 | dotcms | 6909 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57408 | 2018-09-14 17:31:57.337471-04 | | 2018-10-12 15:20:40.252812-04 | 2018-10-12 15:20:40 | |
.252868-04 | f | idle | SELECT 1 | |
31933 | dotcms | 11729 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 36180 | 2018-10-12 14:45:00.011317-04 | 2018-10-12 14:48:28.911133-04 | 2018-10-12 14:48:28.92136-04 | 2018-10-12 14:48:28 | |
.921361-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12131 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 36612 | 2018-10-12 14:46:00.012114-04 | 2018-10-12 14:46:29.083696-04 | 2018-10-12 14:46:29.131659-04 | 2018-10-12 14:46:29 | |
.131672-04 | f | idle in transaction | select * from workflow_action_class_pars where workflow_action_class_id = $1 | |
31933 | dotcms | 12150 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 37106 | 2018-10-12 14:47:00.010792-04 | 2018-10-12 14:47:40.987136-04 | 2018-10-12 14:47:40.995006-04 | 2018-10-12 14:47:40 | |
.995007-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12171 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 37838 | 2018-10-12 14:48:00.007895-04 | 2018-10-12 14:57:07.963777-04 | 2018-10-12 14:57:07.964811-04 | 2018-10-12 14:57:07 | |
.964812-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12187 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 38762 | 2018-10-12 14:49:00.009974-04 | 2018-10-12 14:56:56.008607-04 | 2018-10-12 15:20:19.587714-04 | 2018-10-12 15:20:19 | |
.587729-04 | f | idle in transaction | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
31933 | dotcms | 12293 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 40588 | 2018-10-12 14:55:00.002217-04 | 2018-10-12 15:06:44.953186-04 | 2018-10-12 15:06:44.953799-04 | 2018-10-12 15:06:44 | |
.9538-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12294 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 40590 | 2018-10-12 14:55:00.006296-04 | 2018-10-12 14:59:28.653484-04 | 2018-10-12 14:59:28.666821-04 | 2018-10-12 14:59:28 | |
.666822-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12296 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 40626 | 2018-10-12 14:55:00.575901-04 | 2018-10-12 15:06:51.955316-04 | 2018-10-12 15:06:51.955938-04 | 2018-10-12 15:06:51 | |
.955939-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12393 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 41876 | 2018-10-12 14:57:45.74153-04 | 2018-10-12 15:13:43.495481-04 | 2018-10-12 15:13:43.495996-04 | 2018-10-12 15:13:43 | |
.495996-04 | t | active | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
31933 | dotcms | 12394 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 41878 | 2018-10-12 14:57:45.741921-04 | 2018-10-12 14:59:24.238894-04 | 2018-10-12 14:59:24.23934-04 | 2018-10-12 14:59:24 | |
.239341-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12403 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 42104 | 2018-10-12 14:57:56.392607-04 | 2018-10-12 14:59:19.043299-04 | 2018-10-12 14:59:19.043875-04 | 2018-10-12 14:59:19 | |
.043876-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12445 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 43416 | 2018-10-12 15:00:00.0115-04 | | 2018-10-12 15:20:40.253969-04 | 2018-10-12 15:20:40 | |
.253983-04 | f | idle | SELECT 1 | |
31933 | dotcms | 12981 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 45488 | 2018-10-12 15:07:00.002392-04 | | 2018-10-12 15:20:40.253505-04 | 2018-10-12 15:20:40 | |
.253519-04 | f | idle | SELECT 1 | |
31933 | dotcms | 12982 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 45490 | 2018-10-12 15:07:00.013841-04 | 2018-10-12 15:20:18.144027-04 | 2018-10-12 15:20:18.144059-04 | 2018-10-12 15:20:18 | |
.144059-04 | t | active | lock table dist_reindex_journal | |
31933 | dotcms | 13130 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 47532 | 2018-10-12 15:14:00.010613-04 | | 2018-10-12 15:20:40.253728-04 | 2018-10-12 15:20:40 | |
.253741-04 | f | idle | SELECT 1 | |
31933 | dotcms | 13704 | 10 | postgres | psql | | | -1 | 2018-10-12 15:18:47.424136-04 | 2018-10-12 15:20:57.549668-04 | 2018-10-12 15:20:57.549668-04 | 2018-10-12 15:20:57 | |
.54967-04 | f | active | SELECT * from pg_stat_activity ; | |
(26 rows) | |
dotcms=# SELECT * from pg_stat_activity ; | |
datid | datname | pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | waiting | state | | |
query | |
-------+---------+-------+----------+--------------+------------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+---------+---------------------+--------------------------------------------------------------- | |
-------------------------------------------------------------------------------------------- | |
31933 | dotcms | 6900 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57388 | 2018-09-14 17:31:57.271675-04 | 2018-10-12 14:45:39.556345-04 | 2018-10-12 14:45:39.561937-04 | 2018-10-12 14:45:39.561938-04 | t | active | INSERT INTO permission_reference (id,asset_id,reference_id,per | |
mission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
31933 | dotcms | 6901 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57390 | 2018-09-14 17:31:57.308403-04 | 2018-10-12 14:54:18.996372-04 | 2018-10-12 14:54:18.99678-04 | 2018-10-12 14:54:18.99678-04 | t | active | update contentlet_version_info set working_inode=$1, live_inod | |
e=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 6902 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57392 | 2018-09-14 17:31:57.312366-04 | 2018-10-12 14:41:47.486862-04 | 2018-10-12 15:20:19.584792-04 | 2018-10-12 15:20:19.584966-04 | f | idle in transaction | insert into dist_reindex_journal(inode_to_index,ident_to_index | |
,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
31933 | dotcms | 6903 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57394 | 2018-09-14 17:31:57.316155-04 | | 2018-10-12 15:21:05.961958-04 | 2018-10-12 15:21:05.962057-04 | f | idle | SELECT * FROM cluster_server_action | |
31933 | dotcms | 6904 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57396 | 2018-09-14 17:31:57.32024-04 | 2018-10-12 14:54:02.870285-04 | 2018-10-12 14:54:02.870757-04 | 2018-10-12 14:54:02.870758-04 | t | active | update contentlet_version_info set working_inode=$1, live_inod | |
e=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 6905 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57398 | 2018-09-14 17:31:57.323685-04 | 2018-10-12 14:41:58.697576-04 | 2018-10-12 14:41:58.698472-04 | 2018-10-12 14:41:58.698473-04 | t | active | INSERT INTO permission_reference (id,asset_id,reference_id,per | |
mission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
31933 | dotcms | 6906 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57400 | 2018-09-14 17:31:57.326938-04 | 2018-10-12 15:20:20.093687-04 | 2018-10-12 15:20:20.093737-04 | 2018-10-12 15:20:20.093737-04 | t | active | SELECT * FROM load_records_to_index($1, $2, $3) | |
31933 | dotcms | 6907 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57404 | 2018-09-14 17:31:57.330384-04 | | 2018-10-12 15:21:00.015809-04 | 2018-10-12 15:21:00.015834-04 | f | idle | COMMIT | |
31933 | dotcms | 6908 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57406 | 2018-09-14 17:31:57.33425-04 | 2018-10-12 14:44:19.383455-04 | 2018-10-12 15:20:19.586526-04 | 2018-10-12 15:20:19.586539-04 | f | idle in transaction | select id, field_id, variable_name, variable_key, variable_val | |
ue, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
31933 | dotcms | 6909 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57408 | 2018-09-14 17:31:57.337471-04 | | 2018-10-12 15:21:00.009639-04 | 2018-10-12 15:21:00.009648-04 | f | idle | COMMIT | |
31933 | dotcms | 11729 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 36180 | 2018-10-12 14:45:00.011317-04 | 2018-10-12 14:48:28.911133-04 | 2018-10-12 14:48:28.92136-04 | 2018-10-12 14:48:28.921361-04 | t | active | update contentlet_version_info set working_inode=$1, live_inod | |
e=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12131 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 36612 | 2018-10-12 14:46:00.012114-04 | 2018-10-12 14:46:29.083696-04 | 2018-10-12 14:46:29.131659-04 | 2018-10-12 14:46:29.131672-04 | f | idle in transaction | select * from workflow_action_class_pars where workflow_action | |
_class_id = $1 | |
31933 | dotcms | 12150 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 37106 | 2018-10-12 14:47:00.010792-04 | 2018-10-12 14:47:40.987136-04 | 2018-10-12 14:47:40.995006-04 | 2018-10-12 14:47:40.995007-04 | t | active | update contentlet_version_info set working_inode=$1, live_inod | |
e=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12171 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 37838 | 2018-10-12 14:48:00.007895-04 | 2018-10-12 14:57:07.963777-04 | 2018-10-12 14:57:07.964811-04 | 2018-10-12 14:57:07.964812-04 | t | active | update contentlet_version_info set working_inode=$1, live_inod | |
e=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12187 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 38762 | 2018-10-12 14:49:00.009974-04 | 2018-10-12 14:56:56.008607-04 | 2018-10-12 15:20:19.587714-04 | 2018-10-12 15:20:19.587729-04 | f | idle in transaction | select id, field_id, variable_name, variable_key, variable_val | |
ue, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
31933 | dotcms | 12293 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 40588 | 2018-10-12 14:55:00.002217-04 | 2018-10-12 15:06:44.953186-04 | 2018-10-12 15:06:44.953799-04 | 2018-10-12 15:06:44.9538-04 | t | active | update contentlet_version_info set working_inode=$1, live_inod | |
e=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12294 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 40590 | 2018-10-12 14:55:00.006296-04 | 2018-10-12 14:59:28.653484-04 | 2018-10-12 14:59:28.666821-04 | 2018-10-12 14:59:28.666822-04 | t | active | update contentlet_version_info set working_inode=$1, live_inod | |
e=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12296 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 40626 | 2018-10-12 14:55:00.575901-04 | 2018-10-12 15:06:51.955316-04 | 2018-10-12 15:06:51.955938-04 | 2018-10-12 15:06:51.955939-04 | t | active | update contentlet_version_info set working_inode=$1, live_inod | |
e=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12393 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 41876 | 2018-10-12 14:57:45.74153-04 | 2018-10-12 15:13:43.495481-04 | 2018-10-12 15:13:43.495996-04 | 2018-10-12 15:13:43.495996-04 | t | active | INSERT INTO permission_reference (id,asset_id,reference_id,per | |
mission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
31933 | dotcms | 12394 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 41878 | 2018-10-12 14:57:45.741921-04 | 2018-10-12 14:59:24.238894-04 | 2018-10-12 14:59:24.23934-04 | 2018-10-12 14:59:24.239341-04 | t | active | update contentlet_version_info set working_inode=$1, live_inod | |
e=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12403 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 42104 | 2018-10-12 14:57:56.392607-04 | 2018-10-12 14:59:19.043299-04 | 2018-10-12 14:59:19.043875-04 | 2018-10-12 14:59:19.043876-04 | t | active | update contentlet_version_info set working_inode=$1, live_inod | |
e=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12445 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 43416 | 2018-10-12 15:00:00.0115-04 | | 2018-10-12 15:20:40.253969-04 | 2018-10-12 15:20:40.253983-04 | f | idle | SELECT 1 | |
31933 | dotcms | 12981 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 45488 | 2018-10-12 15:07:00.002392-04 | | 2018-10-12 15:21:00.016605-04 | 2018-10-12 15:21:00.016617-04 | f | idle | COMMIT | |
31933 | dotcms | 12982 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 45490 | 2018-10-12 15:07:00.013841-04 | 2018-10-12 15:20:18.144027-04 | 2018-10-12 15:20:18.144059-04 | 2018-10-12 15:20:18.144059-04 | t | active | lock table dist_reindex_journal | |
31933 | dotcms | 13130 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 47532 | 2018-10-12 15:14:00.010613-04 | | 2018-10-12 15:20:40.253728-04 | 2018-10-12 15:20:40.253741-04 | f | idle | SELECT 1 | |
31933 | dotcms | 13704 | 10 | postgres | psql | | | -1 | 2018-10-12 15:18:47.424136-04 | 2018-10-12 15:21:06.27135-04 | 2018-10-12 15:21:06.27135-04 | 2018-10-12 15:21:06.271353-04 | f | active | SELECT * from pg_stat_activity ; | |
(26 rows) | |
dotcms=# SELECT * from pg_stat_activity ; | |
datid | datname | pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | waiting | state | | |
query | |
-------+---------+-------+----------+--------------+------------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+---------+---------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
31933 | dotcms | 6900 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57388 | 2018-09-14 17:31:57.271675-04 | 2018-10-12 14:45:39.556345-04 | 2018-10-12 14:45:39.561937-04 | 2018-10-12 14:45:39.561938-04 | t | active | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
31933 | dotcms | 6901 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57390 | 2018-09-14 17:31:57.308403-04 | 2018-10-12 14:54:18.996372-04 | 2018-10-12 14:54:18.99678-04 | 2018-10-12 14:54:18.99678-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 6902 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57392 | 2018-09-14 17:31:57.312366-04 | 2018-10-12 14:41:47.486862-04 | 2018-10-12 15:20:19.584792-04 | 2018-10-12 15:20:19.584966-04 | f | idle in transaction | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
31933 | dotcms | 6903 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57394 | 2018-09-14 17:31:57.316155-04 | | 2018-10-12 15:21:11.296372-04 | 2018-10-12 15:21:11.296656-04 | f | idle | select inode.inode as inode, owner, idate as idate, name, description, default_structure, page_detail, structuretype, system, fixed, velocity_var_name , url_map_pattern , hos | |
t, folder, expire_date_var , publish_date_var , mod_date from inode, structure where inode.type='structure' and inode.inode = structure.inode order by structuretype,upper(name) | |
31933 | dotcms | 6904 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57396 | 2018-09-14 17:31:57.32024-04 | 2018-10-12 14:54:02.870285-04 | 2018-10-12 14:54:02.870757-04 | 2018-10-12 14:54:02.870758-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 6905 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57398 | 2018-09-14 17:31:57.323685-04 | 2018-10-12 14:41:58.697576-04 | 2018-10-12 14:41:58.698472-04 | 2018-10-12 14:41:58.698473-04 | t | active | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
31933 | dotcms | 6906 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57400 | 2018-09-14 17:31:57.326938-04 | 2018-10-12 15:20:20.093687-04 | 2018-10-12 15:20:20.093737-04 | 2018-10-12 15:20:20.093737-04 | t | active | SELECT * FROM load_records_to_index($1, $2, $3) | |
31933 | dotcms | 6907 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57404 | 2018-09-14 17:31:57.330384-04 | | 2018-10-12 15:21:10.252712-04 | 2018-10-12 15:21:10.252766-04 | f | idle | SELECT 1 | |
31933 | dotcms | 6908 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57406 | 2018-09-14 17:31:57.33425-04 | 2018-10-12 14:44:19.383455-04 | 2018-10-12 15:20:19.586526-04 | 2018-10-12 15:20:19.586539-04 | f | idle in transaction | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
31933 | dotcms | 6909 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57408 | 2018-09-14 17:31:57.337471-04 | | 2018-10-12 15:21:10.252936-04 | 2018-10-12 15:21:10.252981-04 | f | idle | SELECT 1 | |
31933 | dotcms | 11729 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 36180 | 2018-10-12 14:45:00.011317-04 | 2018-10-12 14:48:28.911133-04 | 2018-10-12 14:48:28.92136-04 | 2018-10-12 14:48:28.921361-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12131 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 36612 | 2018-10-12 14:46:00.012114-04 | 2018-10-12 14:46:29.083696-04 | 2018-10-12 14:46:29.131659-04 | 2018-10-12 14:46:29.131672-04 | f | idle in transaction | select * from workflow_action_class_pars where workflow_action_class_id = $1 | |
31933 | dotcms | 12150 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 37106 | 2018-10-12 14:47:00.010792-04 | 2018-10-12 14:47:40.987136-04 | 2018-10-12 14:47:40.995006-04 | 2018-10-12 14:47:40.995007-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12171 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 37838 | 2018-10-12 14:48:00.007895-04 | 2018-10-12 14:57:07.963777-04 | 2018-10-12 14:57:07.964811-04 | 2018-10-12 14:57:07.964812-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12187 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 38762 | 2018-10-12 14:49:00.009974-04 | 2018-10-12 14:56:56.008607-04 | 2018-10-12 15:20:19.587714-04 | 2018-10-12 15:20:19.587729-04 | f | idle in transaction | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
31933 | dotcms | 12293 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 40588 | 2018-10-12 14:55:00.002217-04 | 2018-10-12 15:06:44.953186-04 | 2018-10-12 15:06:44.953799-04 | 2018-10-12 15:06:44.9538-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12294 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 40590 | 2018-10-12 14:55:00.006296-04 | 2018-10-12 14:59:28.653484-04 | 2018-10-12 14:59:28.666821-04 | 2018-10-12 14:59:28.666822-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12296 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 40626 | 2018-10-12 14:55:00.575901-04 | 2018-10-12 15:06:51.955316-04 | 2018-10-12 15:06:51.955938-04 | 2018-10-12 15:06:51.955939-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12393 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 41876 | 2018-10-12 14:57:45.74153-04 | 2018-10-12 15:13:43.495481-04 | 2018-10-12 15:13:43.495996-04 | 2018-10-12 15:13:43.495996-04 | t | active | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
31933 | dotcms | 12394 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 41878 | 2018-10-12 14:57:45.741921-04 | 2018-10-12 14:59:24.238894-04 | 2018-10-12 14:59:24.23934-04 | 2018-10-12 14:59:24.239341-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12403 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 42104 | 2018-10-12 14:57:56.392607-04 | 2018-10-12 14:59:19.043299-04 | 2018-10-12 14:59:19.043875-04 | 2018-10-12 14:59:19.043876-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12445 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 43416 | 2018-10-12 15:00:00.0115-04 | | 2018-10-12 15:21:10.253342-04 | 2018-10-12 15:21:10.253359-04 | f | idle | SELECT 1 | |
31933 | dotcms | 12981 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 45488 | 2018-10-12 15:07:00.002392-04 | | 2018-10-12 15:21:10.252436-04 | 2018-10-12 15:21:10.252518-04 | f | idle | SELECT 1 | |
31933 | dotcms | 12982 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 45490 | 2018-10-12 15:07:00.013841-04 | 2018-10-12 15:20:18.144027-04 | 2018-10-12 15:20:18.144059-04 | 2018-10-12 15:20:18.144059-04 | t | active | lock table dist_reindex_journal | |
31933 | dotcms | 13130 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 47532 | 2018-10-12 15:14:00.010613-04 | | 2018-10-12 15:21:10.253152-04 | 2018-10-12 15:21:10.253167-04 | f | idle | SELECT 1 | |
31933 | dotcms | 13704 | 10 | postgres | psql | | | -1 | 2018-10-12 15:18:47.424136-04 | 2018-10-12 15:21:11.558597-04 | 2018-10-12 15:21:11.558597-04 | 2018-10-12 15:21:11.558602-04 | f | active | SELECT * from pg_stat_activity ; | |
(26 rows) | |
dotcms=# SELECT * from pg_stat_activity ; | |
datid | datname | pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | waiting | state | query | |
-------+---------+-------+----------+--------------+------------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+---------+---------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------- | |
31933 | dotcms | 6900 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57388 | 2018-09-14 17:31:57.271675-04 | 2018-10-12 14:45:39.556345-04 | 2018-10-12 14:45:39.561937-04 | 2018-10-12 14:45:39.561938-04 | t | active | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
31933 | dotcms | 6901 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57390 | 2018-09-14 17:31:57.308403-04 | 2018-10-12 14:54:18.996372-04 | 2018-10-12 14:54:18.99678-04 | 2018-10-12 14:54:18.99678-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 6902 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57392 | 2018-09-14 17:31:57.312366-04 | 2018-10-12 14:41:47.486862-04 | 2018-10-12 15:20:19.584792-04 | 2018-10-12 15:20:19.584966-04 | f | idle in transaction | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
31933 | dotcms | 6903 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57394 | 2018-09-14 17:31:57.316155-04 | | 2018-10-12 15:21:17.968431-04 | 2018-10-12 15:21:17.968468-04 | f | idle | SELECT * FROM cluster_server_action | |
31933 | dotcms | 6904 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57396 | 2018-09-14 17:31:57.32024-04 | 2018-10-12 14:54:02.870285-04 | 2018-10-12 14:54:02.870757-04 | 2018-10-12 14:54:02.870758-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 6905 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57398 | 2018-09-14 17:31:57.323685-04 | 2018-10-12 14:41:58.697576-04 | 2018-10-12 14:41:58.698472-04 | 2018-10-12 14:41:58.698473-04 | t | active | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
31933 | dotcms | 6906 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57400 | 2018-09-14 17:31:57.326938-04 | 2018-10-12 15:20:20.093687-04 | 2018-10-12 15:20:20.093737-04 | 2018-10-12 15:20:20.093737-04 | t | active | SELECT * FROM load_records_to_index($1, $2, $3) | |
31933 | dotcms | 6907 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57404 | 2018-09-14 17:31:57.330384-04 | | 2018-10-12 15:21:10.252712-04 | 2018-10-12 15:21:10.252766-04 | f | idle | SELECT 1 | |
31933 | dotcms | 6908 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57406 | 2018-09-14 17:31:57.33425-04 | 2018-10-12 14:44:19.383455-04 | 2018-10-12 15:20:19.586526-04 | 2018-10-12 15:20:19.586539-04 | f | idle in transaction | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
31933 | dotcms | 6909 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57408 | 2018-09-14 17:31:57.337471-04 | | 2018-10-12 15:21:10.252936-04 | 2018-10-12 15:21:10.252981-04 | f | idle | SELECT 1 | |
31933 | dotcms | 11729 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 36180 | 2018-10-12 14:45:00.011317-04 | 2018-10-12 14:48:28.911133-04 | 2018-10-12 14:48:28.92136-04 | 2018-10-12 14:48:28.921361-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12131 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 36612 | 2018-10-12 14:46:00.012114-04 | 2018-10-12 14:46:29.083696-04 | 2018-10-12 14:46:29.131659-04 | 2018-10-12 14:46:29.131672-04 | f | idle in transaction | select * from workflow_action_class_pars where workflow_action_class_id = $1 | |
31933 | dotcms | 12150 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 37106 | 2018-10-12 14:47:00.010792-04 | 2018-10-12 14:47:40.987136-04 | 2018-10-12 14:47:40.995006-04 | 2018-10-12 14:47:40.995007-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12171 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 37838 | 2018-10-12 14:48:00.007895-04 | 2018-10-12 14:57:07.963777-04 | 2018-10-12 14:57:07.964811-04 | 2018-10-12 14:57:07.964812-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12187 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 38762 | 2018-10-12 14:49:00.009974-04 | 2018-10-12 14:56:56.008607-04 | 2018-10-12 15:20:19.587714-04 | 2018-10-12 15:20:19.587729-04 | f | idle in transaction | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
31933 | dotcms | 12293 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 40588 | 2018-10-12 14:55:00.002217-04 | 2018-10-12 15:06:44.953186-04 | 2018-10-12 15:06:44.953799-04 | 2018-10-12 15:06:44.9538-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12294 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 40590 | 2018-10-12 14:55:00.006296-04 | 2018-10-12 14:59:28.653484-04 | 2018-10-12 14:59:28.666821-04 | 2018-10-12 14:59:28.666822-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12296 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 40626 | 2018-10-12 14:55:00.575901-04 | 2018-10-12 15:06:51.955316-04 | 2018-10-12 15:06:51.955938-04 | 2018-10-12 15:06:51.955939-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12393 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 41876 | 2018-10-12 14:57:45.74153-04 | 2018-10-12 15:13:43.495481-04 | 2018-10-12 15:13:43.495996-04 | 2018-10-12 15:13:43.495996-04 | t | active | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
31933 | dotcms | 12394 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 41878 | 2018-10-12 14:57:45.741921-04 | 2018-10-12 14:59:24.238894-04 | 2018-10-12 14:59:24.23934-04 | 2018-10-12 14:59:24.239341-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12403 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 42104 | 2018-10-12 14:57:56.392607-04 | 2018-10-12 14:59:19.043299-04 | 2018-10-12 14:59:19.043875-04 | 2018-10-12 14:59:19.043876-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12445 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 43416 | 2018-10-12 15:00:00.0115-04 | | 2018-10-12 15:21:10.253342-04 | 2018-10-12 15:21:10.253359-04 | f | idle | SELECT 1 | |
31933 | dotcms | 12981 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 45488 | 2018-10-12 15:07:00.002392-04 | | 2018-10-12 15:21:10.252436-04 | 2018-10-12 15:21:10.252518-04 | f | idle | SELECT 1 | |
31933 | dotcms | 12982 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 45490 | 2018-10-12 15:07:00.013841-04 | 2018-10-12 15:20:18.144027-04 | 2018-10-12 15:20:18.144059-04 | 2018-10-12 15:20:18.144059-04 | t | active | lock table dist_reindex_journal | |
31933 | dotcms | 13130 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 47532 | 2018-10-12 15:14:00.010613-04 | | 2018-10-12 15:21:10.253152-04 | 2018-10-12 15:21:10.253167-04 | f | idle | SELECT 1 | |
31933 | dotcms | 13704 | 10 | postgres | psql | | | -1 | 2018-10-12 15:18:47.424136-04 | 2018-10-12 15:21:18.366862-04 | 2018-10-12 15:21:18.366862-04 | 2018-10-12 15:21:18.366867-04 | f | active | SELECT * from pg_stat_activity ; | |
(26 rows) | |
dotcms=# SELECT * from pg_stat_activity ; | |
datid | datname | pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | waiting | state | query | |
-------+---------+-------+----------+--------------+------------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+---------+---------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------- | |
31933 | dotcms | 6900 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57388 | 2018-09-14 17:31:57.271675-04 | 2018-10-12 14:45:39.556345-04 | 2018-10-12 14:45:39.561937-04 | 2018-10-12 14:45:39.561938-04 | t | active | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
31933 | dotcms | 6901 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57390 | 2018-09-14 17:31:57.308403-04 | 2018-10-12 14:54:18.996372-04 | 2018-10-12 14:54:18.99678-04 | 2018-10-12 14:54:18.99678-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 6902 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57392 | 2018-09-14 17:31:57.312366-04 | 2018-10-12 14:41:47.486862-04 | 2018-10-12 15:20:19.584792-04 | 2018-10-12 15:20:19.584966-04 | f | idle in transaction | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) values ($1, $2, $3, $4, $5) | |
31933 | dotcms | 6903 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57394 | 2018-09-14 17:31:57.316155-04 | | 2018-10-12 15:21:19.969354-04 | 2018-10-12 15:21:19.969424-04 | f | idle | SELECT * FROM cluster_server_action | |
31933 | dotcms | 6904 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57396 | 2018-09-14 17:31:57.32024-04 | 2018-10-12 14:54:02.870285-04 | 2018-10-12 14:54:02.870757-04 | 2018-10-12 14:54:02.870758-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 6905 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57398 | 2018-09-14 17:31:57.323685-04 | 2018-10-12 14:41:58.697576-04 | 2018-10-12 14:41:58.698472-04 | 2018-10-12 14:41:58.698473-04 | t | active | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
31933 | dotcms | 6906 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57400 | 2018-09-14 17:31:57.326938-04 | 2018-10-12 15:20:20.093687-04 | 2018-10-12 15:20:20.093737-04 | 2018-10-12 15:20:20.093737-04 | t | active | SELECT * FROM load_records_to_index($1, $2, $3) | |
31933 | dotcms | 6907 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57404 | 2018-09-14 17:31:57.330384-04 | | 2018-10-12 15:21:10.252712-04 | 2018-10-12 15:21:10.252766-04 | f | idle | SELECT 1 | |
31933 | dotcms | 6908 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57406 | 2018-09-14 17:31:57.33425-04 | 2018-10-12 14:44:19.383455-04 | 2018-10-12 15:20:19.586526-04 | 2018-10-12 15:20:19.586539-04 | f | idle in transaction | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
31933 | dotcms | 6909 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 57408 | 2018-09-14 17:31:57.337471-04 | | 2018-10-12 15:21:10.252936-04 | 2018-10-12 15:21:10.252981-04 | f | idle | SELECT 1 | |
31933 | dotcms | 11729 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 36180 | 2018-10-12 14:45:00.011317-04 | 2018-10-12 14:48:28.911133-04 | 2018-10-12 14:48:28.92136-04 | 2018-10-12 14:48:28.921361-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12131 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 36612 | 2018-10-12 14:46:00.012114-04 | 2018-10-12 14:46:29.083696-04 | 2018-10-12 14:46:29.131659-04 | 2018-10-12 14:46:29.131672-04 | f | idle in transaction | select * from workflow_action_class_pars where workflow_action_class_id = $1 | |
31933 | dotcms | 12150 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 37106 | 2018-10-12 14:47:00.010792-04 | 2018-10-12 14:47:40.987136-04 | 2018-10-12 14:47:40.995006-04 | 2018-10-12 14:47:40.995007-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12171 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 37838 | 2018-10-12 14:48:00.007895-04 | 2018-10-12 14:57:07.963777-04 | 2018-10-12 14:57:07.964811-04 | 2018-10-12 14:57:07.964812-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12187 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 38762 | 2018-10-12 14:49:00.009974-04 | 2018-10-12 14:56:56.008607-04 | 2018-10-12 15:20:19.587714-04 | 2018-10-12 15:20:19.587729-04 | f | idle in transaction | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_variable where field_id = $1 order by variable_key | |
31933 | dotcms | 12293 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 40588 | 2018-10-12 14:55:00.002217-04 | 2018-10-12 15:06:44.953186-04 | 2018-10-12 15:06:44.953799-04 | 2018-10-12 15:06:44.9538-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12294 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 40590 | 2018-10-12 14:55:00.006296-04 | 2018-10-12 14:59:28.653484-04 | 2018-10-12 14:59:28.666821-04 | 2018-10-12 14:59:28.666822-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12296 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 40626 | 2018-10-12 14:55:00.575901-04 | 2018-10-12 15:06:51.955316-04 | 2018-10-12 15:06:51.955938-04 | 2018-10-12 15:06:51.955939-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12393 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 41876 | 2018-10-12 14:57:45.74153-04 | 2018-10-12 15:13:43.495481-04 | 2018-10-12 15:13:43.495996-04 | 2018-10-12 15:13:43.495996-04 | t | active | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
31933 | dotcms | 12394 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 41878 | 2018-10-12 14:57:45.741921-04 | 2018-10-12 14:59:24.238894-04 | 2018-10-12 14:59:24.23934-04 | 2018-10-12 14:59:24.239341-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12403 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 42104 | 2018-10-12 14:57:56.392607-04 | 2018-10-12 14:59:19.043299-04 | 2018-10-12 14:59:19.043875-04 | 2018-10-12 14:59:19.043876-04 | t | active | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
31933 | dotcms | 12445 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 43416 | 2018-10-12 15:00:00.0115-04 | | 2018-10-12 15:21:10.253342-04 | 2018-10-12 15:21:10.253359-04 | f | idle | SELECT 1 | |
31933 | dotcms | 12981 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 45488 | 2018-10-12 15:07:00.002392-04 | | 2018-10-12 15:21:10.252436-04 | 2018-10-12 15:21:10.252518-04 | f | idle | SELECT 1 | |
31933 | dotcms | 12982 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 45490 | 2018-10-12 15:07:00.013841-04 | 2018-10-12 15:20:18.144027-04 | 2018-10-12 15:20:18.144059-04 | 2018-10-12 15:20:18.144059-04 | t | active | lock table dist_reindex_journal | |
31933 | dotcms | 13130 | 16385 | dotcmsdbuser | PostgreSQL JDBC Driver | 127.0.0.1 | | 47532 | 2018-10-12 15:14:00.010613-04 | | 2018-10-12 15:21:10.253152-04 | 2018-10-12 15:21:10.253167-04 | f | idle | SELECT 1 | |
31933 | dotcms | 13704 | 10 | postgres | psql | | | -1 | 2018-10-12 15:18:47.424136-04 | 2018-10-12 15:21:20.597926-04 | 2018-10-12 15:21:20.597926-04 | 2018-10-12 15:21:20.597928-04 | f | active | SELECT * from pg_stat_activity ; | |
(26 rows) | |
dotcms=# select pid, | |
dotcms-# usename, | |
dotcms-# pg_blocking_pids(pid) as blocked_by, | |
dotcms-# query as blocked_query | |
dotcms-# from pg_stat_activity | |
dotcms-# where cardinality(pg_blocking_pids(pid)) > 0; | |
ERROR: function pg_blocking_pids(integer) does not exist | |
LINE 3: pg_blocking_pids(pid) as blocked_by, | |
^ | |
HINT: No function matches the given name and argument types. You might need to add explicit type casts. | |
dotcms=# CREATE VIEW lock_monitor AS( | |
dotcms(# SELECT | |
dotcms(# COALESCE(blockingl.relation::regclass::text,blockingl.locktype) as locked_item, | |
dotcms(# now() - blockeda.query_start AS waiting_duration, blockeda.pid AS blocked_pid, | |
dotcms(# blockeda.query as blocked_query, blockedl.mode as blocked_mode, | |
dotcms(# blockinga.pid AS blocking_pid, blockinga.query as blocking_query, | |
dotcms(# blockingl.mode as blocking_mode | |
dotcms(# FROM pg_catalog.pg_locks blockedl | |
dotcms(# JOIN pg_stat_activity blockeda ON blockedl.pid = blockeda.pid | |
dotcms(# JOIN pg_catalog.pg_locks blockingl ON( | |
dotcms(# ( (blockingl.transactionid=blockedl.transactionid) OR | |
dotcms(# (blockingl.relation=blockedl.relation AND blockingl.locktype=blockedl.locktype) | |
dotcms(# ) AND blockedl.pid != blockingl.pid) | |
dotcms(# JOIN pg_stat_activity blockinga ON blockingl.pid = blockinga.pid | |
dotcms(# AND blockinga.datid = blockeda.datid | |
dotcms(# WHERE NOT blockedl.granted | |
dotcms(# AND blockinga.datname = current_database() | |
dotcms(# ); | |
CREATE VIEW | |
dotcms=# | |
dotcms=# SELECT * from lock_monitor; | |
locked_item | waiting_duration | blocked_pid | blocked_query | |
| blocked_mode | blocking_pid | | |
blocking_query | |
| blocking_mode | |
-------------------------+------------------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+--------------+------------------------------------------------------------------------------------------------------ | |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
--------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------- | |
dist_reindex_journal | 00:01:48.534682 | 12982 | lock table dist_reindex_journal | |
| AccessExclusiveLock | 6908 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_v | |
ariable where field_id = $1 order by variable_key | |
| RowExclusiveLock | |
dist_reindex_journal | 00:01:46.585004 | 6906 | SELECT * FROM load_records_to_index($1, $2, $3) | |
| RowShareLock | 6908 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_v | |
ariable where field_id = $1 order by variable_key | |
| RowExclusiveLock | |
transactionid | 00:36:27.116804 | 6900 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
| ShareLock | 6908 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_v | |
ariable where field_id = $1 order by variable_key | |
| ExclusiveLock | |
contentlet_version_info | 00:24:58.71393 | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:42.439401 | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:27:47.681961 | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:38.01192 | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:47.634866 | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:33:37.757381 | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:28:03.807984 | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:21.724942 | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:24:58.71393 | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:42.439401 | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:27:47.681961 | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:38.01192 | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:47.634866 | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:33:37.757381 | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:28:03.807984 | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:14.722803 | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
user_ | 00:00:30.931186 | 6903 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwordReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, sk | |
inId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$35, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | 12981 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwor | |
dReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, skinId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$3 | |
5, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | |
user_ | 00:00:23.461006 | 6907 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwordReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, sk | |
inId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$35, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | 12981 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwor | |
dReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, skinId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$3 | |
5, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | |
user_ | 00:00:09.771434 | 6909 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwordReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, sk | |
inId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$35, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | 12981 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwor | |
dReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, skinId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$3 | |
5, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | |
dist_reindex_journal | 00:01:48.534682 | 12982 | lock table dist_reindex_journal | |
| AccessExclusiveLock | 6906 | SELECT * FROM load_records_to_index($1, $2, $3) | |
| RowShareLock | |
contentlet_version_info | 00:24:58.71393 | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:42.439401 | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:27:47.681961 | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:38.01192 | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:47.634866 | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:33:37.757381 | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:21.724942 | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:14.722803 | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:24:58.71393 | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:42.439401 | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:27:47.681961 | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:38.01192 | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:47.634866 | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:33:37.757381 | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:28:03.807984 | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:21.724942 | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:14.722803 | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
user_ | 00:00:30.931186 | 6903 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwordReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, sk | |
inId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$35, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | 6909 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwor | |
dReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, skinId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$3 | |
5, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | |
user_ | 00:00:23.461006 | 6907 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwordReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, sk | |
inId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$35, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | 6909 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwor | |
dReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, skinId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$3 | |
5, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | |
transactionid | 00:34:25.683735 | 12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ShareLock | 12981 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwor | |
dReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, skinId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$3 | |
5, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ShareLock | |
dist_reindex_journal | 00:01:48.534682 | 12982 | lock table dist_reindex_journal | |
| AccessExclusiveLock | 12187 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_v | |
ariable where field_id = $1 order by variable_key | |
| RowExclusiveLock | |
dist_reindex_journal | 00:01:46.585004 | 6906 | SELECT * FROM load_records_to_index($1, $2, $3) | |
| RowShareLock | 12187 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_v | |
ariable where field_id = $1 order by variable_key | |
| RowExclusiveLock | |
contentlet_version_info | 00:24:58.71393 | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:42.439401 | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:27:47.681961 | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:38.01192 | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:47.634866 | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:28:03.807984 | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:21.724942 | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:14.722803 | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
transactionid | 00:34:25.683735 | 12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ShareLock | 12131 | select * from workflow_action_class_pars where workflow_action_class_id = $1 | |
| ExclusiveLock | |
transactionid | 00:00:30.988374 | 12981 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwordReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, sk | |
inId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$35, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ShareLock | 12131 | select * from workflow_action_class_pars where workflow_action_class_id = $1 | |
| ExclusiveLock | |
transactionid | 00:08:23.182745 | 12393 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
| ShareLock | 12187 | select id, field_id, variable_name, variable_key, variable_value, user_id, last_mod_date from field_v | |
ariable where field_id = $1 order by variable_key | |
| ExclusiveLock | |
user_ | 00:00:30.931186 | 6903 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwordReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, sk | |
inId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$35, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | 6907 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwor | |
dReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, skinId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$3 | |
5, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | |
user_ | 00:00:09.771434 | 6909 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwordReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, sk | |
inId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$35, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | 6907 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwor | |
dReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, skinId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$3 | |
5, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | |
dist_reindex_journal | 00:01:48.534682 | 12982 | lock table dist_reindex_journal | |
| AccessExclusiveLock | 6902 | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) va | |
lues ($1, $2, $3, $4, $5) | |
| RowExclusiveLock | |
dist_reindex_journal | 00:01:46.585004 | 6906 | SELECT * FROM load_records_to_index($1, $2, $3) | |
| RowShareLock | 6902 | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) va | |
lues ($1, $2, $3, $4, $5) | |
| RowExclusiveLock | |
contentlet_version_info | 00:24:58.71393 | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:42.439401 | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:27:47.681961 | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:38.01192 | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:33:37.757381 | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:28:03.807984 | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:21.724942 | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:14.722803 | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
dist_reindex_journal | 00:01:46.585004 | 6906 | SELECT * FROM load_records_to_index($1, $2, $3) | |
| RowShareLock | 12982 | lock table dist_reindex_journal | |
| AccessExclusiveLock | |
contentlet_version_info | 00:24:58.71393 | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:42.439401 | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:27:47.681961 | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:47.634866 | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:33:37.757381 | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:28:03.807984 | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:21.724942 | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:14.722803 | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:24:58.71393 | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:42.439401 | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:38.01192 | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:47.634866 | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:33:37.757381 | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:28:03.807984 | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:21.724942 | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:14.722803 | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:24:58.71393 | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:27:47.681961 | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:38.01192 | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:47.634866 | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:33:37.757381 | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:28:03.807984 | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:21.724942 | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:14.722803 | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
transactionid | 00:40:07.980269 | 6905 | INSERT INTO permission_reference (id,asset_id,reference_id,permission_type) VALUES (nextval('permission_reference_seq'),$1,$2,$3) | |
| ShareLock | 6902 | insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) va | |
lues ($1, $2, $3, $4, $5) | |
| ExclusiveLock | |
contentlet_version_info | 00:22:42.439401 | 12394 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:27:47.681961 | 6901 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:38.01192 | 12294 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:22:47.634866 | 12403 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:33:37.757381 | 11729 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:28:03.807984 | 6904 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:21.724942 | 12293 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
contentlet_version_info | 00:15:14.722803 | 12296 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | 12171 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ExclusiveLock | |
user_ | 00:00:23.461006 | 6907 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwordReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, sk | |
inId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$35, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | 6903 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwor | |
dReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, skinId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$3 | |
5, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | |
user_ | 00:00:09.771434 | 6909 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwordReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, sk | |
inId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$35, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | 6903 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwor | |
dReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, skinId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$3 | |
5, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ExclusiveLock | |
transactionid | 00:00:30.988374 | 12981 | update User_ set companyId=$1, password_=$2, passwordEncrypted=$3, passwordExpirationDate=$4, passwordReset=$5, firstName=$6, middleName=$7, lastName=$8, nickName=$9, male=$10, birthday=$11, emailAddress=$12, smsId=$13, aimId=$14, icqId=$15, msnId=$16, ymId=$17, favoriteActivity=$18, favoriteBibleVerse=$19, favoriteFood=$20, favoriteMovie=$21, favoriteMusic=$22, languageId=$23, timeZoneId=$24, sk | |
inId=$25, dottedSkins=$26, roundedSkins=$27, greeting=$28, resolution=$29, refreshRate=$30, comments=$31, createDate=$32, mod_date=$33, loginDate=$34, loginIP=$35, lastLoginDate=$36, lastLoginIP=$37, failedLoginAttempts=$38, agreedToTermsOfUse=$39, active_=$40, delete_in_progress=$41, delete_date=$42 where userId=$43 | ShareLock | 12150 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by=$4, locked_ | |
on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| ShareLock | |
(105 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment