during init / r7079 Queries sorted by total time +--------------------------------------------------------------------------+--------+---------+------------+--------------+----------+------------+----------+ | Statement | Count | Count % | Total Time | Total Time % | Av. Time | Av. Time % | Av. rows | |--------------------------------------------------------------------------+--------+---------+------------+--------------+----------+------------+----------| | select CALENDAR_OBJECT_REVISIONS.CALENDAR_RESOURCE_ID, max(REVISION) | 32 | 0.00% | 247.174548 | 70.23% | 7.724205 | 99.97% | 65247.2 | | from CALENDAR_OBJECT_REVISIONS left join CALENDAR_BIND on | | | | | | | | | CALENDAR_OBJECT_REVISIONS.CALENDAR_RESOURCE_ID = | | | | | | | | | CALENDAR_BIND.CALENDAR_RESOURCE_ID where | | | | | | | | | CALENDAR_BIND.CALENDAR_HOME_RESOURCE_ID = ? and BIND_MODE = ? and | | | | | | | | | RESOURCE_NAME is not null or DELETED = ? group by | | | | | | | | | CALENDAR_OBJECT_REVISIONS.CALENDAR_RESOURCE_ID | | | | | | | | | select RESOURCE_NAME from CALENDAR_OBJECT where CALENDAR_RESOURCE_ID = ? | 292757 | 28.47% | 85.397458 | 24.26% | 0.000292 | 0.00% | 126.0 | | select CREATED, MODIFIED from CALENDAR where RESOURCE_ID = ? | 300697 | 29.24% | 6.931769 | 1.97% | 0.000023 | 0.00% | 1.0 | | select CALENDAR_RESOURCE_ID from CALENDAR_BIND where | 305265 | 29.68% | 6.930282 | 1.97% | 0.000023 | 0.00% | 1.0 | | CALENDAR_RESOURCE_NAME = ? and CALENDAR_HOME_RESOURCE_ID = ? and | | | | | | | | | BIND_MODE = ? | | | | | | | | | select RESOURCE_ID, RESOURCE_NAME, ICALENDAR_UID, MD5, | 57918 | 5.63% | 1.501837 | 0.43% | 0.000026 | 0.00% | 0.0 | | character_length(ICALENDAR_TEXT), ATTACHMENTS_MODE, DROPBOX_ID, | | | | | | | | | ACCESS, SCHEDULE_OBJECT, SCHEDULE_TAG, SCHEDULE_ETAGS, | | | | | | | | | PRIVATE_COMMENTS, CREATED, MODIFIED from CALENDAR_OBJECT where | | | | | | | | | RESOURCE_NAME = ? and CALENDAR_RESOURCE_ID = ? | | | | | | | | | insert into CALENDAR_OBJECT (ACCESS, ATTACHMENTS_MODE, | 7293 | 0.71% | 1.295491 | 0.37% | 0.000178 | 0.00% | 1.0 | | CALENDAR_RESOURCE_ID, DROPBOX_ID, ICALENDAR_TEXT, ICALENDAR_TYPE, | | | | | | | | | ICALENDAR_UID, MD5, ORGANIZER, PRIVATE_COMMENTS, RECURRANCE_MAX, | | | | | | | | | RESOURCE_NAME, SCHEDULE_ETAGS, SCHEDULE_OBJECT, SCHEDULE_TAG) values | | | | | | | | | (?, ?, ?, NULL, ' | | | | | | | | | insert into TIME_RANGE (CALENDAR_OBJECT_RESOURCE_ID, | 7293 | 0.71% | 0.625116 | 0.18% | 0.000086 | 0.00% | 1.0 | | CALENDAR_RESOURCE_ID, END_DATE, FBTYPE, FLOATING, START_DATE, | | | | | | | | | TRANSPARENT) values (?, ?, ?, ?, ?, ?, ?) returning INSTANCE_ID | | | | | | | | | insert into CALENDAR_OBJECT_REVISIONS (CALENDAR_HOME_RESOURCE_ID, | 7290 | 0.71% | 0.596266 | 0.17% | 0.000082 | 0.00% | 1.0 | | CALENDAR_RESOURCE_ID, DELETED, RESOURCE_NAME, REVISION) values (?, ?, | | | | | | | | | ?, ?, nextval(?)) returning REVISION | | | | | | | | | insert into TRANSPARENCY (TIME_RANGE_INSTANCE_ID, TRANSPARENT, USER_ID) | 14579 | 1.42% | 0.478947 | 0.14% | 0.000033 | 0.00% | 1.0 | | values (?, ?, ?) | | | | | | | | | select CALENDAR_OBJECT.CALENDAR_RESOURCE_ID, RESOURCE_ID from | 7292 | 0.71% | 0.364488 | 0.10% | 0.000050 | 0.00% | 0.0 | | CALENDAR_OBJECT join CALENDAR_BIND on | | | | | | | | | CALENDAR_OBJECT.CALENDAR_RESOURCE_ID = | | | | | | | | | CALENDAR_BIND.CALENDAR_RESOURCE_ID where ICALENDAR_UID = ? and | | | | | | | | | CALENDAR_HOME_RESOURCE_ID = ? | | | | | | | | | select CALENDAR_RESOURCE_ID from CALENDAR_OBJECT_REVISIONS where | 7289 | 0.71% | 0.166049 | 0.05% | 0.000023 | 0.00% | 0.0 | | CALENDAR_RESOURCE_ID = ? and RESOURCE_NAME = ? | | | | | | | | | insert into CALENDAR (RESOURCE_ID) values (default) returning | 3795 | 0.37% | 0.153168 | 0.04% | 0.000040 | 0.00% | 1.0 | | RESOURCE_ID, CREATED, MODIFIED | | | | | | | | | select RESOURCE_NAME from CALENDAR_OBJECT where ICALENDAR_UID = ? and | 7289 | 0.71% | 0.149611 | 0.04% | 0.000021 | 0.00% | 0.0 | | CALENDAR_RESOURCE_ID = ? | | | | | | | | | select NAME, VIEWER_UID, VALUE from RESOURCE_PROPERTY where RESOURCE_ID | 2517 | 0.24% | 0.067238 | 0.02% | 0.000027 | 0.00% | 1.3 | | = ? | | | | | | | | | select RESOURCE_ID from CALENDAR_HOME where OWNER_UID = ? | 876 | 0.09% | 0.022763 | 0.01% | 0.000026 | 0.00% | 0.5 | | select MEMBER from GROUPS where GROUPNAME = ? | 464 | 0.05% | 0.010852 | 0.00% | 0.000023 | 0.00% | 0.0 | | insert into CALENDAR_OBJECT_REVISIONS (CALENDAR_HOME_RESOURCE_ID, | 129 | 0.01% | 0.009606 | 0.00% | 0.000074 | 0.00% | 1.0 | | CALENDAR_NAME, CALENDAR_RESOURCE_ID, DELETED, RESOURCE_NAME) values | | | | | | | | | (?, ?, ?, ?, NULL) returning REVISION | | | | | | | | | insert into RESOURCE_PROPERTY (NAME, RESOURCE_ID, VALUE, VIEWER_UID) | 194 | 0.02% | 0.008826 | 0.00% | 0.000045 | 0.00% | 1.0 | | values (?, ?, ?????????, ?) | | | | | | | | | insert into CALENDAR_BIND (BIND_MODE, BIND_STATUS, | 129 | 0.01% | 0.008359 | 0.00% | 0.000065 | 0.00% | 1.0 | | CALENDAR_HOME_RESOURCE_ID, CALENDAR_RESOURCE_ID, | | | | | | | | | CALENDAR_RESOURCE_NAME, SEEN_BY_OWNER, SEEN_BY_SHAREE) values (?, ?, | | | | | | | | | ?, ?, ?, ?, ?) | | | | | | | | | select CALENDAR_RESOURCE_ID, CALENDAR_RESOURCE_NAME, BIND_MODE, MESSAGE | 239 | 0.02% | 0.007507 | 0.00% | 0.000031 | 0.00% | 0.0 | | from CALENDAR_BIND where CALENDAR_HOME_RESOURCE_ID = ? and BIND_MODE | | | | | | | | | != ? and CALENDAR_RESOURCE_NAME is not null | | | | | | | | | delete from CALENDAR_OBJECT_REVISIONS where CALENDAR_HOME_RESOURCE_ID = | 129 | 0.01% | 0.006889 | 0.00% | 0.000053 | 0.00% | 0.0 | | ? and CALENDAR_NAME = ? | | | | | | | | | insert into RESOURCE_PROPERTY (NAME, RESOURCE_ID, VALUE, VIEWER_UID) | 187 | 0.02% | 0.006090 | 0.00% | 0.000033 | 0.00% | 1.0 | | values (?, ?, ???????, ?) | | | | | | | | | select RESOURCE_ID, RESOURCE_NAME, ICALENDAR_UID, MD5, | 271 | 0.03% | 0.006000 | 0.00% | 0.000022 | 0.00% | 0.0 | | character_length(ICALENDAR_TEXT), ATTACHMENTS_MODE, DROPBOX_ID, | | | | | | | | | ACCESS, SCHEDULE_OBJECT, SCHEDULE_TAG, SCHEDULE_ETAGS, | | | | | | | | | PRIVATE_COMMENTS, CREATED, MODIFIED from CALENDAR_OBJECT where | | | | | | | | | CALENDAR_RESOURCE_ID = ? | | | | | | | | | select CALENDAR_RESOURCE_NAME from CALENDAR_BIND where | 239 | 0.02% | 0.005766 | 0.00% | 0.000024 | 0.00% | 2.5 | | CALENDAR_HOME_RESOURCE_ID = ? and BIND_MODE = ? | | | | | | | | | insert into CALENDAR_HOME (OWNER_UID) values (?) returning RESOURCE_ID | 34 | 0.00% | 0.005130 | 0.00% | 0.000151 | 0.00% | 1.0 | | insert into NOTIFICATION_HOME (OWNER_UID) values (?) returning | 31 | 0.00% | 0.004539 | 0.00% | 0.000146 | 0.00% | 1.0 | | RESOURCE_ID | | | | | | | | | insert into GROUPS (GROUPNAME, MEMBER) values (?, ?) | 60 | 0.01% | 0.004463 | 0.00% | 0.000074 | 0.00% | 1.0 | | select max(REVISION) from CALENDAR_OBJECT_REVISIONS where | 62 | 0.01% | 0.002070 | 0.00% | 0.000033 | 0.00% | 1.0 | | CALENDAR_RESOURCE_ID = ? | | | | | | | | | select CALENDAR_RESOURCE_ID, RESOURCE_ID, NAME, VIEWER_UID, VALUE from | 34 | 0.00% | 0.001797 | 0.00% | 0.000053 | 0.00% | 4.0 | | RESOURCE_PROPERTY right join CALENDAR_BIND on RESOURCE_ID = | | | | | | | | | CALENDAR_RESOURCE_ID where CALENDAR_HOME_RESOURCE_ID = ? | | | | | | | | | select RESOURCE_ID from NOTIFICATION_HOME where OWNER_UID = ? | 31 | 0.00% | 0.001689 | 0.00% | 0.000054 | 0.00% | 0.0 | | update RESOURCE_PROPERTY set VALUE = ????????????? where RESOURCE_ID = ? | 30 | 0.00% | 0.001673 | 0.00% | 0.000056 | 0.00% | 1.0 | | and NAME = ? and VIEWER_UID = ? | | | | | | | | | savepoint notificationsWithUID | 941 | 0.09% | 0.001613 | 0.00% | 0.000002 | 0.00% | 0.0 | | select RESOURCE_ID, CALENDAR_RESOURCE_NAME, CREATED, MODIFIED from | 34 | 0.00% | 0.001578 | 0.00% | 0.000046 | 0.00% | 2.0 | | CALENDAR left outer join CALENDAR_BIND on RESOURCE_ID = | | | | | | | | | CALENDAR_RESOURCE_ID where CALENDAR_HOME_RESOURCE_ID = ? and BIND_MODE | | | | | | | | | = ? | | | | | | | | | savepoint homeWithUID | 957 | 0.09% | 0.001491 | 0.00% | 0.000002 | 0.00% | 0.0 | | insert into NOTIFICATION_OBJECT_REVISIONS (DELETED, | 31 | 0.00% | 0.001293 | 0.00% | 0.000042 | 0.00% | 1.0 | | NOTIFICATION_HOME_RESOURCE_ID, RESOURCE_NAME, REVISION) values (?, ?, | | | | | | | | | NULL, nextval(?)) returning REVISION | | | | | | | | | release savepoint notificationsWithUID | 941 | 0.09% | 0.001269 | 0.00% | 0.000001 | 0.00% | 0.0 | | release savepoint homeWithUID | 957 | 0.09% | 0.001037 | 0.00% | 0.000001 | 0.00% | 0.0 | | insert into CALENDAR_HOME_METADATA (RESOURCE_ID) values (?) | 34 | 0.00% | 0.000976 | 0.00% | 0.000029 | 0.00% | 1.0 | | select QUOTA_USED_BYTES from CALENDAR_HOME_METADATA where RESOURCE_ID = | 31 | 0.00% | 0.000855 | 0.00% | 0.000028 | 0.00% | 1.0 | | ? | | | | | | | | | select DISTINCT CALENDAR_OBJECT.RESOURCE_NAME, | 31 | 0.00% | 0.000581 | 0.00% | 0.000019 | 0.00% | 0.0 | | CALENDAR_OBJECT.ICALENDAR_UID, CALENDAR_OBJECT.ICALENDAR_TYPE, | | | | | | | | | CALENDAR_OBJECT.ORGANIZER, TIME_RANGE.FLOATING, TIME_RANGE.START_DATE, | | | | | | | | | TIME_RANGE.END_DATE, TIME_RANGE.FBTYPE, TIME_RANGE.TRANSPARENT, | | | | | | | | | TRANSPARENCY.TRANSPARENT from CALENDAR_OBJECT, TIME_RANGE LEFT OUTER | | | | | | | | | JOIN TRANSPARENCY ON (TIME_RANGE.INSTANCE_ID = | | | | | | | | | TRANSPARENCY.TIME_RANGE_INSTANCE_ID AND TRANSPARENCY.USER_ID = ?) | | | | | | | | | where CALENDAR_OBJECT.ICALENDAR_TYPE IN (?, ?, ?) AND | | | | | | | | | ((TIME_RANGE.FLOATING = FALSE AND TIME_RANGE.START_DATE < ? AND | | | | | | | | | TIME_RANGE.END_DATE > ?) OR (TIME_RANGE.FLOATING = TRUE AND | | | | | | | | | TIME_RANGE.START_DATE < ? AND TIME_RANGE.END_DATE > '?-?-? | | | | | | | | | select RESOURCE_ID, CALENDAR_RESOURCE_NAME, CREATED, MODIFIED from | 31 | 0.00% | 0.000561 | 0.00% | 0.000018 | 0.00% | 0.0 | | CALENDAR left outer join CALENDAR_BIND on RESOURCE_ID = | | | | | | | | | CALENDAR_RESOURCE_ID where CALENDAR_HOME_RESOURCE_ID = ? and BIND_MODE | | | | | | | | | != ? and CALENDAR_RESOURCE_NAME is not null | | | | | | | | | select RESOURCE_NAME from CALENDAR_OBJECT where RECURRANCE_MAX < ? and | 31 | 0.00% | 0.000516 | 0.00% | 0.000017 | 0.00% | 0.0 | | CALENDAR_RESOURCE_ID = ? | | | | | | | | | SET standard_conforming_strings=?; | 1 | 0.00% | 0.000009 | 0.00% | 0.000009 | 0.00% | 0.0 | +--------------------------------------------------------------------------+--------+---------+------------+--------------+----------+------------+----------+ Queries sorted by count +--------------------------------------------------------------------------+--------+---------+------------+--------------+----------+------------+----------+ | Statement | Count | Count % | Total Time | Total Time % | Av. Time | Av. Time % | Av. rows | |--------------------------------------------------------------------------+--------+---------+------------+--------------+----------+------------+----------| | select CALENDAR_RESOURCE_ID from CALENDAR_BIND where | 305265 | 29.68% | 6.930282 | 1.97% | 0.000023 | 0.00% | 1.0 | | CALENDAR_RESOURCE_NAME = ? and CALENDAR_HOME_RESOURCE_ID = ? and | | | | | | | | | BIND_MODE = ? | | | | | | | | | select CREATED, MODIFIED from CALENDAR where RESOURCE_ID = ? | 300697 | 29.24% | 6.931769 | 1.97% | 0.000023 | 0.00% | 1.0 | | select RESOURCE_NAME from CALENDAR_OBJECT where CALENDAR_RESOURCE_ID = ? | 292757 | 28.47% | 85.397458 | 24.26% | 0.000292 | 0.00% | 126.0 | | select RESOURCE_ID, RESOURCE_NAME, ICALENDAR_UID, MD5, | 57918 | 5.63% | 1.501837 | 0.43% | 0.000026 | 0.00% | 0.0 | | character_length(ICALENDAR_TEXT), ATTACHMENTS_MODE, DROPBOX_ID, | | | | | | | | | ACCESS, SCHEDULE_OBJECT, SCHEDULE_TAG, SCHEDULE_ETAGS, | | | | | | | | | PRIVATE_COMMENTS, CREATED, MODIFIED from CALENDAR_OBJECT where | | | | | | | | | RESOURCE_NAME = ? and CALENDAR_RESOURCE_ID = ? | | | | | | | | | insert into TRANSPARENCY (TIME_RANGE_INSTANCE_ID, TRANSPARENT, USER_ID) | 14579 | 1.42% | 0.478947 | 0.14% | 0.000033 | 0.00% | 1.0 | | values (?, ?, ?) | | | | | | | | | insert into TIME_RANGE (CALENDAR_OBJECT_RESOURCE_ID, | 7293 | 0.71% | 0.625116 | 0.18% | 0.000086 | 0.00% | 1.0 | | CALENDAR_RESOURCE_ID, END_DATE, FBTYPE, FLOATING, START_DATE, | | | | | | | | | TRANSPARENT) values (?, ?, ?, ?, ?, ?, ?) returning INSTANCE_ID | | | | | | | | | insert into CALENDAR_OBJECT (ACCESS, ATTACHMENTS_MODE, | 7293 | 0.71% | 1.295491 | 0.37% | 0.000178 | 0.00% | 1.0 | | CALENDAR_RESOURCE_ID, DROPBOX_ID, ICALENDAR_TEXT, ICALENDAR_TYPE, | | | | | | | | | ICALENDAR_UID, MD5, ORGANIZER, PRIVATE_COMMENTS, RECURRANCE_MAX, | | | | | | | | | RESOURCE_NAME, SCHEDULE_ETAGS, SCHEDULE_OBJECT, SCHEDULE_TAG) values | | | | | | | | | (?, ?, ?, NULL, ' | | | | | | | | | select CALENDAR_OBJECT.CALENDAR_RESOURCE_ID, RESOURCE_ID from | 7292 | 0.71% | 0.364488 | 0.10% | 0.000050 | 0.00% | 0.0 | | CALENDAR_OBJECT join CALENDAR_BIND on | | | | | | | | | CALENDAR_OBJECT.CALENDAR_RESOURCE_ID = | | | | | | | | | CALENDAR_BIND.CALENDAR_RESOURCE_ID where ICALENDAR_UID = ? and | | | | | | | | | CALENDAR_HOME_RESOURCE_ID = ? | | | | | | | | | insert into CALENDAR_OBJECT_REVISIONS (CALENDAR_HOME_RESOURCE_ID, | 7290 | 0.71% | 0.596266 | 0.17% | 0.000082 | 0.00% | 1.0 | | CALENDAR_RESOURCE_ID, DELETED, RESOURCE_NAME, REVISION) values (?, ?, | | | | | | | | | ?, ?, nextval(?)) returning REVISION | | | | | | | | | select CALENDAR_RESOURCE_ID from CALENDAR_OBJECT_REVISIONS where | 7289 | 0.71% | 0.166049 | 0.05% | 0.000023 | 0.00% | 0.0 | | CALENDAR_RESOURCE_ID = ? and RESOURCE_NAME = ? | | | | | | | | | select RESOURCE_NAME from CALENDAR_OBJECT where ICALENDAR_UID = ? and | 7289 | 0.71% | 0.149611 | 0.04% | 0.000021 | 0.00% | 0.0 | | CALENDAR_RESOURCE_ID = ? | | | | | | | | | insert into CALENDAR (RESOURCE_ID) values (default) returning | 3795 | 0.37% | 0.153168 | 0.04% | 0.000040 | 0.00% | 1.0 | | RESOURCE_ID, CREATED, MODIFIED | | | | | | | | | select NAME, VIEWER_UID, VALUE from RESOURCE_PROPERTY where RESOURCE_ID | 2517 | 0.24% | 0.067238 | 0.02% | 0.000027 | 0.00% | 1.3 | | = ? | | | | | | | | | savepoint homeWithUID | 957 | 0.09% | 0.001491 | 0.00% | 0.000002 | 0.00% | 0.0 | | release savepoint homeWithUID | 957 | 0.09% | 0.001037 | 0.00% | 0.000001 | 0.00% | 0.0 | | release savepoint notificationsWithUID | 941 | 0.09% | 0.001269 | 0.00% | 0.000001 | 0.00% | 0.0 | | savepoint notificationsWithUID | 941 | 0.09% | 0.001613 | 0.00% | 0.000002 | 0.00% | 0.0 | | select RESOURCE_ID from CALENDAR_HOME where OWNER_UID = ? | 876 | 0.09% | 0.022763 | 0.01% | 0.000026 | 0.00% | 0.5 | | select MEMBER from GROUPS where GROUPNAME = ? | 464 | 0.05% | 0.010852 | 0.00% | 0.000023 | 0.00% | 0.0 | | select RESOURCE_ID, RESOURCE_NAME, ICALENDAR_UID, MD5, | 271 | 0.03% | 0.006000 | 0.00% | 0.000022 | 0.00% | 0.0 | | character_length(ICALENDAR_TEXT), ATTACHMENTS_MODE, DROPBOX_ID, | | | | | | | | | ACCESS, SCHEDULE_OBJECT, SCHEDULE_TAG, SCHEDULE_ETAGS, | | | | | | | | | PRIVATE_COMMENTS, CREATED, MODIFIED from CALENDAR_OBJECT where | | | | | | | | | CALENDAR_RESOURCE_ID = ? | | | | | | | | | select CALENDAR_RESOURCE_NAME from CALENDAR_BIND where | 239 | 0.02% | 0.005766 | 0.00% | 0.000024 | 0.00% | 2.5 | | CALENDAR_HOME_RESOURCE_ID = ? and BIND_MODE = ? | | | | | | | | | select CALENDAR_RESOURCE_ID, CALENDAR_RESOURCE_NAME, BIND_MODE, MESSAGE | 239 | 0.02% | 0.007507 | 0.00% | 0.000031 | 0.00% | 0.0 | | from CALENDAR_BIND where CALENDAR_HOME_RESOURCE_ID = ? and BIND_MODE | | | | | | | | | != ? and CALENDAR_RESOURCE_NAME is not null | | | | | | | | | insert into RESOURCE_PROPERTY (NAME, RESOURCE_ID, VALUE, VIEWER_UID) | 194 | 0.02% | 0.008826 | 0.00% | 0.000045 | 0.00% | 1.0 | | values (?, ?, ?????????, ?) | | | | | | | | | insert into RESOURCE_PROPERTY (NAME, RESOURCE_ID, VALUE, VIEWER_UID) | 187 | 0.02% | 0.006090 | 0.00% | 0.000033 | 0.00% | 1.0 | | values (?, ?, ???????, ?) | | | | | | | | | delete from CALENDAR_OBJECT_REVISIONS where CALENDAR_HOME_RESOURCE_ID = | 129 | 0.01% | 0.006889 | 0.00% | 0.000053 | 0.00% | 0.0 | | ? and CALENDAR_NAME = ? | | | | | | | | | insert into CALENDAR_BIND (BIND_MODE, BIND_STATUS, | 129 | 0.01% | 0.008359 | 0.00% | 0.000065 | 0.00% | 1.0 | | CALENDAR_HOME_RESOURCE_ID, CALENDAR_RESOURCE_ID, | | | | | | | | | CALENDAR_RESOURCE_NAME, SEEN_BY_OWNER, SEEN_BY_SHAREE) values (?, ?, | | | | | | | | | ?, ?, ?, ?, ?) | | | | | | | | | insert into CALENDAR_OBJECT_REVISIONS (CALENDAR_HOME_RESOURCE_ID, | 129 | 0.01% | 0.009606 | 0.00% | 0.000074 | 0.00% | 1.0 | | CALENDAR_NAME, CALENDAR_RESOURCE_ID, DELETED, RESOURCE_NAME) values | | | | | | | | | (?, ?, ?, ?, NULL) returning REVISION | | | | | | | | | select max(REVISION) from CALENDAR_OBJECT_REVISIONS where | 62 | 0.01% | 0.002070 | 0.00% | 0.000033 | 0.00% | 1.0 | | CALENDAR_RESOURCE_ID = ? | | | | | | | | | insert into GROUPS (GROUPNAME, MEMBER) values (?, ?) | 60 | 0.01% | 0.004463 | 0.00% | 0.000074 | 0.00% | 1.0 | | insert into CALENDAR_HOME_METADATA (RESOURCE_ID) values (?) | 34 | 0.00% | 0.000976 | 0.00% | 0.000029 | 0.00% | 1.0 | | select CALENDAR_RESOURCE_ID, RESOURCE_ID, NAME, VIEWER_UID, VALUE from | 34 | 0.00% | 0.001797 | 0.00% | 0.000053 | 0.00% | 4.0 | | RESOURCE_PROPERTY right join CALENDAR_BIND on RESOURCE_ID = | | | | | | | | | CALENDAR_RESOURCE_ID where CALENDAR_HOME_RESOURCE_ID = ? | | | | | | | | | insert into CALENDAR_HOME (OWNER_UID) values (?) returning RESOURCE_ID | 34 | 0.00% | 0.005130 | 0.00% | 0.000151 | 0.00% | 1.0 | | select RESOURCE_ID, CALENDAR_RESOURCE_NAME, CREATED, MODIFIED from | 34 | 0.00% | 0.001578 | 0.00% | 0.000046 | 0.00% | 2.0 | | CALENDAR left outer join CALENDAR_BIND on RESOURCE_ID = | | | | | | | | | CALENDAR_RESOURCE_ID where CALENDAR_HOME_RESOURCE_ID = ? and BIND_MODE | | | | | | | | | = ? | | | | | | | | | select CALENDAR_OBJECT_REVISIONS.CALENDAR_RESOURCE_ID, max(REVISION) | 32 | 0.00% | 247.174548 | 70.23% | 7.724205 | 99.97% | 65247.2 | | from CALENDAR_OBJECT_REVISIONS left join CALENDAR_BIND on | | | | | | | | | CALENDAR_OBJECT_REVISIONS.CALENDAR_RESOURCE_ID = | | | | | | | | | CALENDAR_BIND.CALENDAR_RESOURCE_ID where | | | | | | | | | CALENDAR_BIND.CALENDAR_HOME_RESOURCE_ID = ? and BIND_MODE = ? and | | | | | | | | | RESOURCE_NAME is not null or DELETED = ? group by | | | | | | | | | CALENDAR_OBJECT_REVISIONS.CALENDAR_RESOURCE_ID | | | | | | | | | select DISTINCT CALENDAR_OBJECT.RESOURCE_NAME, | 31 | 0.00% | 0.000581 | 0.00% | 0.000019 | 0.00% | 0.0 | | CALENDAR_OBJECT.ICALENDAR_UID, CALENDAR_OBJECT.ICALENDAR_TYPE, | | | | | | | | | CALENDAR_OBJECT.ORGANIZER, TIME_RANGE.FLOATING, TIME_RANGE.START_DATE, | | | | | | | | | TIME_RANGE.END_DATE, TIME_RANGE.FBTYPE, TIME_RANGE.TRANSPARENT, | | | | | | | | | TRANSPARENCY.TRANSPARENT from CALENDAR_OBJECT, TIME_RANGE LEFT OUTER | | | | | | | | | JOIN TRANSPARENCY ON (TIME_RANGE.INSTANCE_ID = | | | | | | | | | TRANSPARENCY.TIME_RANGE_INSTANCE_ID AND TRANSPARENCY.USER_ID = ?) | | | | | | | | | where CALENDAR_OBJECT.ICALENDAR_TYPE IN (?, ?, ?) AND | | | | | | | | | ((TIME_RANGE.FLOATING = FALSE AND TIME_RANGE.START_DATE < ? AND | | | | | | | | | TIME_RANGE.END_DATE > ?) OR (TIME_RANGE.FLOATING = TRUE AND | | | | | | | | | TIME_RANGE.START_DATE < ? AND TIME_RANGE.END_DATE > '?-?-? | | | | | | | | | insert into NOTIFICATION_HOME (OWNER_UID) values (?) returning | 31 | 0.00% | 0.004539 | 0.00% | 0.000146 | 0.00% | 1.0 | | RESOURCE_ID | | | | | | | | | select RESOURCE_ID, CALENDAR_RESOURCE_NAME, CREATED, MODIFIED from | 31 | 0.00% | 0.000561 | 0.00% | 0.000018 | 0.00% | 0.0 | | CALENDAR left outer join CALENDAR_BIND on RESOURCE_ID = | | | | | | | | | CALENDAR_RESOURCE_ID where CALENDAR_HOME_RESOURCE_ID = ? and BIND_MODE | | | | | | | | | != ? and CALENDAR_RESOURCE_NAME is not null | | | | | | | | | select RESOURCE_ID from NOTIFICATION_HOME where OWNER_UID = ? | 31 | 0.00% | 0.001689 | 0.00% | 0.000054 | 0.00% | 0.0 | | select RESOURCE_NAME from CALENDAR_OBJECT where RECURRANCE_MAX < ? and | 31 | 0.00% | 0.000516 | 0.00% | 0.000017 | 0.00% | 0.0 | | CALENDAR_RESOURCE_ID = ? | | | | | | | | | select QUOTA_USED_BYTES from CALENDAR_HOME_METADATA where RESOURCE_ID = | 31 | 0.00% | 0.000855 | 0.00% | 0.000028 | 0.00% | 1.0 | | ? | | | | | | | | | insert into NOTIFICATION_OBJECT_REVISIONS (DELETED, | 31 | 0.00% | 0.001293 | 0.00% | 0.000042 | 0.00% | 1.0 | | NOTIFICATION_HOME_RESOURCE_ID, RESOURCE_NAME, REVISION) values (?, ?, | | | | | | | | | NULL, nextval(?)) returning REVISION | | | | | | | | | update RESOURCE_PROPERTY set VALUE = ????????????? where RESOURCE_ID = ? | 30 | 0.00% | 0.001673 | 0.00% | 0.000056 | 0.00% | 1.0 | | and NAME = ? and VIEWER_UID = ? | | | | | | | | | SET standard_conforming_strings=?; | 1 | 0.00% | 0.000009 | 0.00% | 0.000009 | 0.00% | 0.0 | +--------------------------------------------------------------------------+--------+---------+------------+--------------+----------+------------+----------+ Queries sorted by average time +--------------------------------------------------------------------------+--------+---------+------------+--------------+----------+------------+----------+ | Statement | Count | Count % | Total Time | Total Time % | Av. Time | Av. Time % | Av. rows | |--------------------------------------------------------------------------+--------+---------+------------+--------------+----------+------------+----------| | select CALENDAR_OBJECT_REVISIONS.CALENDAR_RESOURCE_ID, max(REVISION) | 32 | 0.00% | 247.174548 | 70.23% | 7.724205 | 99.97% | 65247.2 | | from CALENDAR_OBJECT_REVISIONS left join CALENDAR_BIND on | | | | | | | | | CALENDAR_OBJECT_REVISIONS.CALENDAR_RESOURCE_ID = | | | | | | | | | CALENDAR_BIND.CALENDAR_RESOURCE_ID where | | | | | | | | | CALENDAR_BIND.CALENDAR_HOME_RESOURCE_ID = ? and BIND_MODE = ? and | | | | | | | | | RESOURCE_NAME is not null or DELETED = ? group by | | | | | | | | | CALENDAR_OBJECT_REVISIONS.CALENDAR_RESOURCE_ID | | | | | | | | | select RESOURCE_NAME from CALENDAR_OBJECT where CALENDAR_RESOURCE_ID = ? | 292757 | 28.47% | 85.397458 | 24.26% | 0.000292 | 0.00% | 126.0 | | insert into CALENDAR_OBJECT (ACCESS, ATTACHMENTS_MODE, | 7293 | 0.71% | 1.295491 | 0.37% | 0.000178 | 0.00% | 1.0 | | CALENDAR_RESOURCE_ID, DROPBOX_ID, ICALENDAR_TEXT, ICALENDAR_TYPE, | | | | | | | | | ICALENDAR_UID, MD5, ORGANIZER, PRIVATE_COMMENTS, RECURRANCE_MAX, | | | | | | | | | RESOURCE_NAME, SCHEDULE_ETAGS, SCHEDULE_OBJECT, SCHEDULE_TAG) values | | | | | | | | | (?, ?, ?, NULL, ' | | | | | | | | | insert into CALENDAR_HOME (OWNER_UID) values (?) returning RESOURCE_ID | 34 | 0.00% | 0.005130 | 0.00% | 0.000151 | 0.00% | 1.0 | | insert into NOTIFICATION_HOME (OWNER_UID) values (?) returning | 31 | 0.00% | 0.004539 | 0.00% | 0.000146 | 0.00% | 1.0 | | RESOURCE_ID | | | | | | | | | insert into TIME_RANGE (CALENDAR_OBJECT_RESOURCE_ID, | 7293 | 0.71% | 0.625116 | 0.18% | 0.000086 | 0.00% | 1.0 | | CALENDAR_RESOURCE_ID, END_DATE, FBTYPE, FLOATING, START_DATE, | | | | | | | | | TRANSPARENT) values (?, ?, ?, ?, ?, ?, ?) returning INSTANCE_ID | | | | | | | | | insert into CALENDAR_OBJECT_REVISIONS (CALENDAR_HOME_RESOURCE_ID, | 7290 | 0.71% | 0.596266 | 0.17% | 0.000082 | 0.00% | 1.0 | | CALENDAR_RESOURCE_ID, DELETED, RESOURCE_NAME, REVISION) values (?, ?, | | | | | | | | | ?, ?, nextval(?)) returning REVISION | | | | | | | | | insert into CALENDAR_OBJECT_REVISIONS (CALENDAR_HOME_RESOURCE_ID, | 129 | 0.01% | 0.009606 | 0.00% | 0.000074 | 0.00% | 1.0 | | CALENDAR_NAME, CALENDAR_RESOURCE_ID, DELETED, RESOURCE_NAME) values | | | | | | | | | (?, ?, ?, ?, NULL) returning REVISION | | | | | | | | | insert into GROUPS (GROUPNAME, MEMBER) values (?, ?) | 60 | 0.01% | 0.004463 | 0.00% | 0.000074 | 0.00% | 1.0 | | insert into CALENDAR_BIND (BIND_MODE, BIND_STATUS, | 129 | 0.01% | 0.008359 | 0.00% | 0.000065 | 0.00% | 1.0 | | CALENDAR_HOME_RESOURCE_ID, CALENDAR_RESOURCE_ID, | | | | | | | | | CALENDAR_RESOURCE_NAME, SEEN_BY_OWNER, SEEN_BY_SHAREE) values (?, ?, | | | | | | | | | ?, ?, ?, ?, ?) | | | | | | | | | update RESOURCE_PROPERTY set VALUE = ????????????? where RESOURCE_ID = ? | 30 | 0.00% | 0.001673 | 0.00% | 0.000056 | 0.00% | 1.0 | | and NAME = ? and VIEWER_UID = ? | | | | | | | | | select RESOURCE_ID from NOTIFICATION_HOME where OWNER_UID = ? | 31 | 0.00% | 0.001689 | 0.00% | 0.000054 | 0.00% | 0.0 | | delete from CALENDAR_OBJECT_REVISIONS where CALENDAR_HOME_RESOURCE_ID = | 129 | 0.01% | 0.006889 | 0.00% | 0.000053 | 0.00% | 0.0 | | ? and CALENDAR_NAME = ? | | | | | | | | | select CALENDAR_RESOURCE_ID, RESOURCE_ID, NAME, VIEWER_UID, VALUE from | 34 | 0.00% | 0.001797 | 0.00% | 0.000053 | 0.00% | 4.0 | | RESOURCE_PROPERTY right join CALENDAR_BIND on RESOURCE_ID = | | | | | | | | | CALENDAR_RESOURCE_ID where CALENDAR_HOME_RESOURCE_ID = ? | | | | | | | | | select CALENDAR_OBJECT.CALENDAR_RESOURCE_ID, RESOURCE_ID from | 7292 | 0.71% | 0.364488 | 0.10% | 0.000050 | 0.00% | 0.0 | | CALENDAR_OBJECT join CALENDAR_BIND on | | | | | | | | | CALENDAR_OBJECT.CALENDAR_RESOURCE_ID = | | | | | | | | | CALENDAR_BIND.CALENDAR_RESOURCE_ID where ICALENDAR_UID = ? and | | | | | | | | | CALENDAR_HOME_RESOURCE_ID = ? | | | | | | | | | select RESOURCE_ID, CALENDAR_RESOURCE_NAME, CREATED, MODIFIED from | 34 | 0.00% | 0.001578 | 0.00% | 0.000046 | 0.00% | 2.0 | | CALENDAR left outer join CALENDAR_BIND on RESOURCE_ID = | | | | | | | | | CALENDAR_RESOURCE_ID where CALENDAR_HOME_RESOURCE_ID = ? and BIND_MODE | | | | | | | | | = ? | | | | | | | | | insert into RESOURCE_PROPERTY (NAME, RESOURCE_ID, VALUE, VIEWER_UID) | 194 | 0.02% | 0.008826 | 0.00% | 0.000045 | 0.00% | 1.0 | | values (?, ?, ?????????, ?) | | | | | | | | | insert into NOTIFICATION_OBJECT_REVISIONS (DELETED, | 31 | 0.00% | 0.001293 | 0.00% | 0.000042 | 0.00% | 1.0 | | NOTIFICATION_HOME_RESOURCE_ID, RESOURCE_NAME, REVISION) values (?, ?, | | | | | | | | | NULL, nextval(?)) returning REVISION | | | | | | | | | insert into CALENDAR (RESOURCE_ID) values (default) returning | 3795 | 0.37% | 0.153168 | 0.04% | 0.000040 | 0.00% | 1.0 | | RESOURCE_ID, CREATED, MODIFIED | | | | | | | | | select max(REVISION) from CALENDAR_OBJECT_REVISIONS where | 62 | 0.01% | 0.002070 | 0.00% | 0.000033 | 0.00% | 1.0 | | CALENDAR_RESOURCE_ID = ? | | | | | | | | | insert into TRANSPARENCY (TIME_RANGE_INSTANCE_ID, TRANSPARENT, USER_ID) | 14579 | 1.42% | 0.478947 | 0.14% | 0.000033 | 0.00% | 1.0 | | values (?, ?, ?) | | | | | | | | | insert into RESOURCE_PROPERTY (NAME, RESOURCE_ID, VALUE, VIEWER_UID) | 187 | 0.02% | 0.006090 | 0.00% | 0.000033 | 0.00% | 1.0 | | values (?, ?, ???????, ?) | | | | | | | | | select CALENDAR_RESOURCE_ID, CALENDAR_RESOURCE_NAME, BIND_MODE, MESSAGE | 239 | 0.02% | 0.007507 | 0.00% | 0.000031 | 0.00% | 0.0 | | from CALENDAR_BIND where CALENDAR_HOME_RESOURCE_ID = ? and BIND_MODE | | | | | | | | | != ? and CALENDAR_RESOURCE_NAME is not null | | | | | | | | | insert into CALENDAR_HOME_METADATA (RESOURCE_ID) values (?) | 34 | 0.00% | 0.000976 | 0.00% | 0.000029 | 0.00% | 1.0 | | select QUOTA_USED_BYTES from CALENDAR_HOME_METADATA where RESOURCE_ID = | 31 | 0.00% | 0.000855 | 0.00% | 0.000028 | 0.00% | 1.0 | | ? | | | | | | | | | select NAME, VIEWER_UID, VALUE from RESOURCE_PROPERTY where RESOURCE_ID | 2517 | 0.24% | 0.067238 | 0.02% | 0.000027 | 0.00% | 1.3 | | = ? | | | | | | | | | select RESOURCE_ID from CALENDAR_HOME where OWNER_UID = ? | 876 | 0.09% | 0.022763 | 0.01% | 0.000026 | 0.00% | 0.5 | | select RESOURCE_ID, RESOURCE_NAME, ICALENDAR_UID, MD5, | 57918 | 5.63% | 1.501837 | 0.43% | 0.000026 | 0.00% | 0.0 | | character_length(ICALENDAR_TEXT), ATTACHMENTS_MODE, DROPBOX_ID, | | | | | | | | | ACCESS, SCHEDULE_OBJECT, SCHEDULE_TAG, SCHEDULE_ETAGS, | | | | | | | | | PRIVATE_COMMENTS, CREATED, MODIFIED from CALENDAR_OBJECT where | | | | | | | | | RESOURCE_NAME = ? and CALENDAR_RESOURCE_ID = ? | | | | | | | | | select CALENDAR_RESOURCE_NAME from CALENDAR_BIND where | 239 | 0.02% | 0.005766 | 0.00% | 0.000024 | 0.00% | 2.5 | | CALENDAR_HOME_RESOURCE_ID = ? and BIND_MODE = ? | | | | | | | | | select MEMBER from GROUPS where GROUPNAME = ? | 464 | 0.05% | 0.010852 | 0.00% | 0.000023 | 0.00% | 0.0 | | select CREATED, MODIFIED from CALENDAR where RESOURCE_ID = ? | 300697 | 29.24% | 6.931769 | 1.97% | 0.000023 | 0.00% | 1.0 | | select CALENDAR_RESOURCE_ID from CALENDAR_OBJECT_REVISIONS where | 7289 | 0.71% | 0.166049 | 0.05% | 0.000023 | 0.00% | 0.0 | | CALENDAR_RESOURCE_ID = ? and RESOURCE_NAME = ? | | | | | | | | | select CALENDAR_RESOURCE_ID from CALENDAR_BIND where | 305265 | 29.68% | 6.930282 | 1.97% | 0.000023 | 0.00% | 1.0 | | CALENDAR_RESOURCE_NAME = ? and CALENDAR_HOME_RESOURCE_ID = ? and | | | | | | | | | BIND_MODE = ? | | | | | | | | | select RESOURCE_ID, RESOURCE_NAME, ICALENDAR_UID, MD5, | 271 | 0.03% | 0.006000 | 0.00% | 0.000022 | 0.00% | 0.0 | | character_length(ICALENDAR_TEXT), ATTACHMENTS_MODE, DROPBOX_ID, | | | | | | | | | ACCESS, SCHEDULE_OBJECT, SCHEDULE_TAG, SCHEDULE_ETAGS, | | | | | | | | | PRIVATE_COMMENTS, CREATED, MODIFIED from CALENDAR_OBJECT where | | | | | | | | | CALENDAR_RESOURCE_ID = ? | | | | | | | | | select RESOURCE_NAME from CALENDAR_OBJECT where ICALENDAR_UID = ? and | 7289 | 0.71% | 0.149611 | 0.04% | 0.000021 | 0.00% | 0.0 | | CALENDAR_RESOURCE_ID = ? | | | | | | | | | select DISTINCT CALENDAR_OBJECT.RESOURCE_NAME, | 31 | 0.00% | 0.000581 | 0.00% | 0.000019 | 0.00% | 0.0 | | CALENDAR_OBJECT.ICALENDAR_UID, CALENDAR_OBJECT.ICALENDAR_TYPE, | | | | | | | | | CALENDAR_OBJECT.ORGANIZER, TIME_RANGE.FLOATING, TIME_RANGE.START_DATE, | | | | | | | | | TIME_RANGE.END_DATE, TIME_RANGE.FBTYPE, TIME_RANGE.TRANSPARENT, | | | | | | | | | TRANSPARENCY.TRANSPARENT from CALENDAR_OBJECT, TIME_RANGE LEFT OUTER | | | | | | | | | JOIN TRANSPARENCY ON (TIME_RANGE.INSTANCE_ID = | | | | | | | | | TRANSPARENCY.TIME_RANGE_INSTANCE_ID AND TRANSPARENCY.USER_ID = ?) | | | | | | | | | where CALENDAR_OBJECT.ICALENDAR_TYPE IN (?, ?, ?) AND | | | | | | | | | ((TIME_RANGE.FLOATING = FALSE AND TIME_RANGE.START_DATE < ? AND | | | | | | | | | TIME_RANGE.END_DATE > ?) OR (TIME_RANGE.FLOATING = TRUE AND | | | | | | | | | TIME_RANGE.START_DATE < ? AND TIME_RANGE.END_DATE > '?-?-? | | | | | | | | | select RESOURCE_ID, CALENDAR_RESOURCE_NAME, CREATED, MODIFIED from | 31 | 0.00% | 0.000561 | 0.00% | 0.000018 | 0.00% | 0.0 | | CALENDAR left outer join CALENDAR_BIND on RESOURCE_ID = | | | | | | | | | CALENDAR_RESOURCE_ID where CALENDAR_HOME_RESOURCE_ID = ? and BIND_MODE | | | | | | | | | != ? and CALENDAR_RESOURCE_NAME is not null | | | | | | | | | select RESOURCE_NAME from CALENDAR_OBJECT where RECURRANCE_MAX < ? and | 31 | 0.00% | 0.000516 | 0.00% | 0.000017 | 0.00% | 0.0 | | CALENDAR_RESOURCE_ID = ? | | | | | | | | | SET standard_conforming_strings=?; | 1 | 0.00% | 0.000009 | 0.00% | 0.000009 | 0.00% | 0.0 | | savepoint notificationsWithUID | 941 | 0.09% | 0.001613 | 0.00% | 0.000002 | 0.00% | 0.0 | | savepoint homeWithUID | 957 | 0.09% | 0.001491 | 0.00% | 0.000002 | 0.00% | 0.0 | | release savepoint notificationsWithUID | 941 | 0.09% | 0.001269 | 0.00% | 0.000001 | 0.00% | 0.0 | | release savepoint homeWithUID | 957 | 0.09% | 0.001037 | 0.00% | 0.000001 | 0.00% | 0.0 | +--------------------------------------------------------------------------+--------+---------+------------+--------------+----------+------------+----------+