Skip to content

Instantly share code, notes, and snippets.

@cfalzone
Created January 28, 2014 14:54
Show Gist options
  • Select an option

  • Save cfalzone/8669036 to your computer and use it in GitHub Desktop.

Select an option

Save cfalzone/8669036 to your computer and use it in GitHub Desktop.
Running queries on stag - 1/28/2014
-[ RECORD 1 ]----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 25416
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 57692
backend_start | 23-JAN-14 17:42:18.308734 -05:00
xact_start |
query_start | 23-JAN-14 22:10:02.676803 -05:00
state_change | 23-JAN-14 22:10:02.676867 -05:00
waiting | f
state | idle
query | select * from workflow_step where scheme_id = $1 order by my_order
-[ RECORD 2 ]----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 30695
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 52557
backend_start | 22-JAN-14 15:31:33.122885 -05:00
xact_start |
query_start | 23-JAN-14 17:37:02.759317 -05:00
state_change | 23-JAN-14 17:37:02.75936 -05:00
waiting | f
state | idle
query | select * from workflow_step where scheme_id = $1 order by my_order
-[ RECORD 3 ]----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 30697
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 52558
backend_start | 22-JAN-14 15:31:38.711753 -05:00
xact_start |
query_start | 22-JAN-14 15:31:56.892686 -05:00
state_change | 22-JAN-14 15:31:56.892714 -05:00
waiting | f
state | idle
query | 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 qrtz_tri
ggers.trigger_name=qrtz_cron_triggers.trigger_name and qrtz_triggers.trigger_group=qrtz_cron_triggers.trigger_group
-[ RECORD 4 ]----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 30698
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 52559
backend_start | 22-JAN-14 15:31:41.430239 -05:00
xact_start |
query_start | 22-JAN-14 15:31:43.001672 -05:00
state_change | 22-JAN-14 15:31:43.002182 -05:00
waiting | f
state | idle
query | SELECT index_name,index_type FROM indicies
-[ RECORD 5 ]----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 25844
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 57755
backend_start | 23-JAN-14 18:02:18.21924 -05:00
xact_start | 27-JAN-14 13:49:12.57404 -05:00
query_start | 27-JAN-14 13:49:12.590376 -05:00
state_change | 27-JAN-14 13:49:12.590378 -05:00
waiting | t
state | active
query | update identifier set parent_path=$1, asset_name=$2, host_inode=$3, asset_type=$4, syspublish_date=$5, sysexpire_date=$6 where id=$7
-[ RECORD 6 ]----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 30707
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 52570
backend_start | 22-JAN-14 15:31:56.691939 -05:00
xact_start | 23-JAN-14 17:36:16.286118 -05:00
query_start | 23-JAN-14 17:36:16.288 -05:00
state_change | 23-JAN-14 17:36:16.288001 -05:00
waiting | t
state | active
query | insert into permission_reference (id, asset_id, reference_id, permission_type) values (nextval('permission_reference_seq'), $1, $2, $3)
-[ RECORD 7 ]----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 30708
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 52571
backend_start | 22-JAN-14 15:31:56.699455 -05:00
xact_start |
query_start | 28-JAN-14 02:32:26.900746 -05:00
state_change | 28-JAN-14 02:32:26.902915 -05:00
waiting | f
state | idle
query | COMMIT
-[ RECORD 8 ]----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 30709
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 52574
backend_start | 22-JAN-14 15:31:57.66242 -05:00
xact_start |
query_start | 23-JAN-14 17:37:02.758704 -05:00
state_change | 23-JAN-14 17:37:02.75875 -05:00
waiting | f
state | idle
query | select * from workflow_step where scheme_id = $1 order by my_order
-[ RECORD 9 ]----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 30710
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 52577
backend_start | 22-JAN-14 15:31:57.687977 -05:00
xact_start | 23-JAN-14 17:36:14.758305 -05:00
query_start | 23-JAN-14 17:36:19.116757 -05:00
state_change | 23-JAN-14 17:36:19.116976 -05:00
waiting | f
state | idle in transaction
query | select contentlet.inode as inode0_, contentlet.show_on_menu as show_on_2_3_0_, contentlet.title as title3_0_, contentlet.mod_date as mod_date3_0_, contentlet.mod_user as mod_user3_0_, contentlet.sort_order as sort_order3_0_, contentlet.friendly_name as
friendly7_3_0_, contentlet.structure_inode as structur8_3_0_, contentlet.last_review as last_rev9_3_0_, contentlet.next_review as next_re10_3_0_, contentlet.review_interval as review_11_3_0_, contentlet.disabled_wysiwyg as disable12_3_0_, contentlet.identifier as identifi
er3_0_, contentlet.language_id as languag14_3_0_, contentlet.date1 as date13_0_, contentlet.date2 as date23_0_, contentlet.date3 as date33_0_, contentlet.date4 as date43_0_, contentlet.date5 as date53_0_, contentlet.date6 as date63_0_, contentlet.date7 as date73_0_, conte
ntlet.date8 as date83_0_, contentlet.date9 as date93_0_, contentlet.date10 as date103_0_, contentlet.date11 as date113_0_, contentlet.date12 as date123_0_, contentlet.date13 as date133_0_, contentlet.date14 as date143_0_, cont
-[ RECORD 10 ]---+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 30711
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 52578
backend_start | 22-JAN-14 15:31:57.696332 -05:00
xact_start |
query_start | 23-JAN-14 17:37:31.265491 -05:00
state_change | 23-JAN-14 17:37:31.265529 -05:00
waiting | f
state | idle
query | SELECT 1
-[ RECORD 11 ]---+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 1737
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 59248
backend_start | 24-JAN-14 02:02:18.869917 -05:00
xact_start | 27-JAN-14 14:08:01.857676 -05:00
query_start | 27-JAN-14 14:08:01.87736 -05:00
state_change | 27-JAN-14 14:08:01.877362 -05:00
waiting | t
state | active
query | update identifier set parent_path=$1, asset_name=$2, host_inode=$3, asset_type=$4, syspublish_date=$5, sysexpire_date=$6 where id=$7
-[ RECORD 12 ]---+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 1738
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 59249
backend_start | 24-JAN-14 02:02:18.893224 -05:00
xact_start | 27-JAN-14 14:06:22.642966 -05:00
query_start | 27-JAN-14 14:06:22.643146 -05:00
state_change | 27-JAN-14 14:06:22.643148 -05:00
waiting | t
state | active
query | delete from permission_reference
-[ RECORD 13 ]---+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 30714
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 52581
backend_start | 22-JAN-14 15:31:57.74186 -05:00
xact_start | 27-JAN-14 14:06:47.717746 -05:00
query_start | 27-JAN-14 14:06:47.718002 -05:00
state_change | 27-JAN-14 14:06:47.718004 -05:00
waiting | t
state | active
query | delete from permission_reference
-[ RECORD 14 ]---+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 12914
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 44866
backend_start | 27-JAN-14 03:07:25.036382 -05:00
xact_start | 27-JAN-14 13:42:12.881945 -05:00
query_start | 27-JAN-14 13:42:14.096749 -05:00
state_change | 27-JAN-14 13:42:14.096751 -05:00
waiting | t
state | active
query | update workflow_scheme set name = $1,description =$2, archived=$3,mandatory=$4,entry_action_id=$5, mod_date=$6 where id =$7
-[ RECORD 15 ]---+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 24380
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 47035
backend_start | 27-JAN-14 14:07:25.879711 -05:00
xact_start |
query_start | 28-JAN-14 09:35:35.172922 -05:00
state_change | 28-JAN-14 09:35:35.173185 -05:00
waiting | f
state | idle
query | select permission.id as id0_, permission.permission_type as permissi2_0_, permission.inode_id as inode_id0_, permission.roleid as roleid0_, permission.permission as permission0_ from permission where inode_id = $1 union all select permission.id as id
0_, permission.permission_type as permissi2_0_, permission.inode_id as inode_id0_, permission.roleid as roleid0_, permission.permission as permission0_ from permission join permission_reference on (inode_id = reference_id and permission.permission_type = permission_re
ference.permission_type) where asset_id = $2
-[ RECORD 16 ]---+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 30717
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 52584
backend_start | 22-JAN-14 15:31:57.767268 -05:00
xact_start |
query_start | 23-JAN-14 17:37:25.540399 -05:00
state_change | 23-JAN-14 17:37:25.540495 -05:00
waiting | f
state | idle
query | select contentlet0_.identifier as identifier, contentlet0_.lang as lang, contentlet0_.working_inode as working_3_, contentlet0_.live_inode as live_inode, contentlet0_.deleted as deleted, contentlet0_.locked_by as locked_by, contentlet0_.locked_on as loc
ked_on, contentlet0_.version_ts as version_ts from contentlet_version_info contentlet0_ where (identifier=$1 )and(lang=$2 )
-[ RECORD 17 ]---+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 24466
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 47053
backend_start | 27-JAN-14 14:12:25.862703 -05:00
xact_start |
query_start | 28-JAN-14 09:42:27.449593 -05:00
state_change | 28-JAN-14 09:42:27.449616 -05:00
waiting | f
state | idle
query | COMMIT
-[ RECORD 18 ]---+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 30719
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 52586
backend_start | 22-JAN-14 15:31:57.800531 -05:00
xact_start |
query_start | 23-JAN-14 17:37:02.759041 -05:00
state_change | 23-JAN-14 17:37:02.759085 -05:00
waiting | f
state | idle
query | select * from workflow_step where scheme_id = $1 order by my_order
-[ RECORD 19 ]---+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 16651
datname | dotcms
pid | 30720
usesysid | 16650
usename | dotcms
application_name |
client_addr | 10.29.185.211
client_hostname |
client_port | 52587
backend_start | 22-JAN-14 15:31:57.808791 -05:00
xact_start |
query_start | 23-JAN-14 01:02:16.871351 -05:00
state_change | 23-JAN-14 01:02:16.871514 -05:00
waiting | f
state | idle
query | select inode.inode as inode, inode.structure_inode as structur2_18_, inode.field_name as field_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 required18_
, inode.indexed as indexed18_, inode.listed as listed18_, inode.velocity_var_name as velocit10_18_, inode.sort_order as sort_order18_, inode.field_values as field_v12_18_, inode.regex_check as regex_c13_18_, inode.hint as hint18_, inode.default_value as default15_18_, ino
de.fixed as fixed18_, inode.read_only 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 type0_ from field inode inner join inode inode_1_ on inode.inode=inode_1_.inode wh
ere (inode_1_.type='field' )and(structure_inode='855a2d72-f2f3-4169-8b04-ac5157c4380c' )and(velocity_var_name='runDashboard' )
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment