Created
July 14, 2014 20:52
-
-
Save cfalzone/284bf3518cc0432eab9b to your computer and use it in GitHub Desktop.
This file contains hidden or 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
| dotcms=# select pid,waiting,state,now() - query_start, query from pg_stat_activity; | |
| pid | waiting | state | ?column? | | |
| query | |
| -------+---------+---------------------+-------------------------+------------------------------------------------------------------------------------------- | |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| ------------------------------------------------- | |
| 23421 | f | idle | 7 days 04:27:31.864018 | UPDATE import_audit SET status=$1 where id=$2 | |
| 23429 | f | idle | 18 days 09:37:01.641285 | select working_inode from contentlet_version_info join contentlet on (contentlet.inode = c | |
| ontentlet_version_info.working_inode) where bool1 = $1 and structure_inode =$2 | |
| 23436 | f | idle | 18 days 09:36:59.433349 | select * from qrtz_triggers, qrtz_cron_triggers where (qrtz_triggers.job_group='User | |
| Job' or qrtz_triggers.job_group='Recurrent Campaign') and qrtz_triggers.job_group<>'PAUSED' and qrtz_triggers.start_time < $1 and qr | |
| tz_triggers.trigger_name=qrtz_cron_triggers.trigger_name and qrtz_triggers.trigger_group=qrtz_cron_triggers.trigger_group | |
| 23442 | f | idle | 17 days 16:00:19.846472 | select inode.inode as inode, inode.structure_inode as structur2_18_, inode.field_name as f | |
| ield_name18_, inode.field_type as field_type18_, inode.field_relation_type as field_re5_18_, inode.field_contentlet as field_co6_18_, inode.required as requi | |
| red18_, inode.indexed as indexed18_, inode.listed as listed18_, inode.velocity_var_name as velocit10_18_, inode.sort_order as sort_order18_, inode.field_valu | |
| es as field_v12_18_, inode.regex_check as regex_c13_18_, inode.hint as hint18_, inode.default_value as default15_18_, inode.fixed as fixed18_, inode.read_onl | |
| y as read_only18_, inode.searchable as searchable18_, inode.unique_ as unique_18_, inode_1_.owner as owner0_, inode_1_.iDate as iDate0_, inode_1_.type as typ | |
| e0_ from field inode inner join inode inode_1_ on inode.inode=inode_1_.inode where (inode_1_.type='field' )and(structure_inode='855a2d72-f2f3-4169-8b04-ac515 | |
| 7c4380c' )and(velocity_var_name='runDashboard' ) | |
| 23443 | t | active | 00:30:36.011715 | update identifier set parent_path=$1, asset_name=$2, host_inode=$3, asset_type=$4, syspubl | |
| ish_date=$5, sysexpire_date=$6 where id=$7 | |
| 24118 | f | idle | 11 days 01:32:11.042128 | UPDATE import_audit SET status=$1 where id=$2 | |
| 27994 | f | idle | 7 days 04:39:07.099179 | UPDATE import_audit SET status=$1 where id=$2 | |
| 25673 | f | idle | 11 days 01:29:49.369531 | UPDATE import_audit SET status=$1 where id=$2 | |
| 25674 | f | idle | 11 days 01:25:51.284914 | UPDATE import_audit SET status=$1 where id=$2 | |
| 27995 | f | idle in transaction | 00:31:31.440702 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by= | |
| $4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| 24490 | f | idle | 00:00:01.2305 | SELECT 1 | |
| 3917 | t | active | 00:26:33.509836 | update identifier set parent_path=$1, asset_name=$2, host_inode=$3, asset_type=$4, syspubl | |
| ish_date=$5, sysexpire_date=$6 where id=$7 | |
| 27827 | t | active | 00:30:35.319538 | update identifier set parent_path=$1, asset_name=$2, host_inode=$3, asset_type=$4, syspubl | |
| ish_date=$5, sysexpire_date=$6 where id=$7 | |
| 25703 | f | active | 00:00:00 | select pid,waiting,state,now() - query_start, query from pg_stat_activity; | |
| 31757 | f | idle | 6 days 03:29:49.699903 | UPDATE import_audit SET status=$1 where id=$2 | |
| 27946 | f | idle | 00:00:03.051138 | COMMIT | |
| 27947 | t | active | 00:31:31.815078 | update identifier set parent_path=$1, asset_name=$2, host_inode=$3, asset_type=$4, syspubl | |
| ish_date=$5, sysexpire_date=$6 where id=$7 | |
| 25196 | t | active | 00:07:35.726413 | update identifier set parent_path=$1, asset_name=$2, host_inode=$3, asset_type=$4, syspubl | |
| ish_date=$5, sysexpire_date=$6 where id=$7 | |
| 28009 | f | idle | 00:01:17.419627 | COMMIT | |
| 17825 | t | active | 00:31:30.753983 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by= | |
| $4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| 17824 | t | active | 00:06:35.876719 | update contentlet_version_info set working_inode=$1, live_inode=$2, deleted=$3, locked_by= | |
| $4, locked_on=$5, version_ts=$6 where identifier=$7 and lang=$8 | |
| (21 rows) | |
| dotcms=# |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment