PgBadger

Normalized reports are marked with a "(N)".

Generated on Tue Oct 2 14:57:57 2012
Log file: logs/postgresql-9.0-rhq.log.1
Parsed 48 065 log entries in 2,00s
Log start from 2012-09-23 06:53:10 to 2012-09-30 06:24:56

Overall statistics ^

Number of unique normalized queries: 21
Number of queries: 503
Total query duration: 36m13,85s
First query: 2012-09-24 10:23:30
Last query: 2012-09-30 06:00:18
Query peak: 2 queries/s at 2012-09-28 03:00:02
Number of errors: 4 013
Number of unique normalized errors: 20

Number temporary file: 12
Max size of temporary file: 737 042 432
Average size of temporary file: 61 420 202,67
Total number of sessions: 21890
Total duration of sessions: 83d12h54,63s
Average duration of sessions: 5m29,58s

Hourly statistics ^

Day	Time	Queries		SELECT queries		Write queries
Day	Time	Count	Av. duration (s)	Count	Av. duration (s)	INSERT	UPDATE	DELETE	Av. duration (s)
Sep 24	10	2	1,01s	2	1,01s	0	0	0	0,00s
	11	3	4,34s	0	0,00s	2	0	1	4,34s
	12	3	5,68s	0	0,00s	1	0	1	4,48s
	13	3	5,62s	0	0,00s	1	0	1	4,40s
	14	10	2,12s	6	0,74s	1	2	1	4,20s
	15	7	1,90s	2	0,60s	4	0	1	2,42s
	16	3	2,93s	0	0,00s	2	0	1	2,93s
	17	3	3,53s	0	0,00s	2	0	1	3,53s
	18	3	3,83s	0	0,00s	2	0	1	3,83s
	19	3	3,75s	0	0,00s	2	0	1	3,75s
	20	3	3,57s	0	0,00s	2	0	1	3,57s
	21	4	3,13s	0	0,00s	3	0	1	3,13s
	22	3	3,73s	0	0,00s	2	0	1	3,73s
	23	3	3,52s	0	0,00s	2	0	1	3,52s
Sep 25	00	8	18,27s	0	0,00s	2	0	1	3,82s
	01	3	3,83s	0	0,00s	2	0	1	3,83s
	02	3	3,59s	0	0,00s	2	0	1	3,59s
	03	5	2,60s	0	0,00s	4	0	1	2,60s
	04	3	3,62s	0	0,00s	2	0	1	3,62s
	05	3	3,65s	0	0,00s	2	0	1	3,65s
	06	3	3,52s	0	0,00s	2	0	1	3,52s
	07	3	3,05s	0	0,00s	2	0	1	3,05s
	08	3	3,65s	0	0,00s	2	0	1	3,65s
	09	4	3,21s	0	0,00s	3	0	1	3,21s
	10	3	3,84s	0	0,00s	2	0	1	3,84s
	11	3	2,49s	0	0,00s	2	0	1	2,49s
	12	3	2,58s	0	0,00s	2	0	1	2,58s
	13	3	2,58s	0	0,00s	2	0	1	2,58s
	14	3	2,74s	0	0,00s	2	0	1	2,74s
	15	4	2,19s	0	0,00s	3	0	1	2,19s
	16	3	2,63s	0	0,00s	2	0	1	2,63s
	17	3	2,45s	0	0,00s	2	0	1	2,45s
	18	4	4,21s	0	0,00s	2	0	1	2,70s
	19	3	2,54s	0	0,00s	2	0	1	2,54s
	20	3	2,50s	0	0,00s	2	0	1	2,50s
	21	4	2,33s	0	0,00s	3	0	1	2,33s
	22	3	2,53s	0	0,00s	2	0	1	2,53s
	23	3	2,90s	0	0,00s	2	0	1	2,90s
Sep 26	00	7	9,97s	0	0,00s	2	0	1	2,69s
	01	3	2,56s	0	0,00s	2	0	1	2,56s
	02	3	2,50s	0	0,00s	2	0	1	2,50s
	03	6	3,07s	0	0,00s	4	0	1	1,79s
	04	3	2,58s	0	0,00s	2	0	1	2,58s
	05	3	2,78s	0	0,00s	2	0	1	2,78s
	06	3	2,56s	0	0,00s	2	0	1	2,56s
	07	3	2,59s	0	0,00s	2	0	1	2,59s
	08	3	2,52s	0	0,00s	2	0	1	2,52s
	09	4	2,33s	0	0,00s	3	0	1	2,33s
	10	3	2,78s	0	0,00s	2	0	1	2,78s
	11	3	2,81s	0	0,00s	2	0	1	2,81s
	12	3	2,72s	0	0,00s	2	0	1	2,72s
	13	5	2,25s	2	1,40s	2	0	1	2,81s
	14	5	3,80s	1	0,66s	2	0	1	2,84s
	15	4	1,97s	0	0,00s	3	0	1	1,97s
	16	3	2,53s	0	0,00s	2	0	1	2,53s
	17	3	3,30s	0	0,00s	2	0	1	3,30s
	18	3	2,46s	0	0,00s	2	0	1	2,46s
	19	3	2,78s	0	0,00s	2	0	1	2,78s
	20	3	4,33s	0	0,00s	2	0	1	4,33s
	21	4	2,09s	0	0,00s	3	0	1	2,09s
	22	3	2,41s	0	0,00s	2	0	1	2,41s
	23	3	2,78s	0	0,00s	2	0	1	2,78s
Sep 27	00	8	22,51s	0	0,00s	2	0	1	2,79s
	01	3	2,51s	0	0,00s	2	0	1	2,51s
	02	3	2,53s	0	0,00s	2	0	1	2,53s
	03	5	1,79s	0	0,00s	4	0	1	1,79s
	04	3	2,65s	0	0,00s	2	0	1	2,65s
	05	3	2,62s	0	0,00s	2	0	1	2,62s
	06	3	2,55s	0	0,00s	2	0	1	2,55s
	07	3	2,46s	0	0,00s	2	0	1	2,46s
	08	3	2,70s	0	0,00s	2	0	1	2,70s
	09	4	2,17s	0	0,00s	3	0	1	2,17s
	10	3	2,63s	0	0,00s	2	0	1	2,63s
	11	3	2,49s	0	0,00s	2	0	1	2,49s
	12	3	2,77s	0	0,00s	2	0	1	2,77s
	13	5	1,97s	2	1,25s	2	0	1	2,44s
	14	3	2,52s	0	0,00s	2	0	1	2,52s
	15	4	2,06s	0	0,00s	3	0	1	2,06s
	16	3	2,49s	0	0,00s	2	0	1	2,49s
	17	3	2,52s	0	0,00s	2	0	1	2,52s
	18	3	2,50s	0	0,00s	2	0	1	2,50s
	19	3	2,53s	0	0,00s	2	0	1	2,53s
	20	3	2,66s	0	0,00s	2	0	1	2,66s
	21	4	2,10s	0	0,00s	3	0	1	2,10s
	22	3	2,57s	0	0,00s	2	0	1	2,57s
	23	3	2,57s	0	0,00s	2	0	1	2,57s
Sep 28	00	7	22,59s	0	0,00s	2	0	1	2,59s
	01	3	2,46s	0	0,00s	2	0	1	2,46s
	02	3	2,70s	0	0,00s	2	0	1	2,70s
	03	5	1,83s	0	0,00s	4	0	1	1,83s
	04	3	2,47s	0	0,00s	2	0	1	2,47s
	05	3	2,63s	0	0,00s	2	0	1	2,63s
	06	3	2,73s	0	0,00s	2	0	1	2,73s
	07	3	2,37s	0	0,00s	2	0	1	2,37s
	08	3	2,59s	0	0,00s	2	0	1	2,59s
	09	4	2,21s	0	0,00s	3	0	1	2,21s
	10	6	2,22s	3	0,69s	2	0	1	3,75s
	11	3	2,67s	0	0,00s	2	0	1	2,67s
	12	3	2,65s	0	0,00s	2	0	1	2,65s
	13	5	2,25s	2	1,30s	2	0	1	2,89s
	14	3	2,70s	0	0,00s	2	0	1	2,70s
	15	4	2,19s	0	0,00s	3	0	1	2,19s
	16	3	2,66s	0	0,00s	2	0	1	2,66s
	17	3	2,98s	0	0,00s	2	0	1	2,98s
	18	3	2,84s	0	0,00s	2	0	1	2,84s
	19	3	2,98s	0	0,00s	2	0	1	2,98s
	20	3	2,87s	0	0,00s	2	0	1	2,87s
	21	4	2,48s	0	0,00s	3	0	1	2,48s
	22	3	3,16s	0	0,00s	2	0	1	3,16s
	23	3	2,90s	0	0,00s	2	0	1	2,90s
Sep 29	00	7	23,14s	0	0,00s	2	0	1	3,24s
	01	3	3,33s	0	0,00s	2	0	1	3,33s
	02	3	2,83s	0	0,00s	2	0	1	2,83s
	03	5	2,21s	0	0,00s	4	0	1	2,21s
	04	3	2,93s	0	0,00s	2	0	1	2,93s
	05	3	2,81s	0	0,00s	2	0	1	2,81s
	06	3	3,21s	0	0,00s	2	0	1	3,21s
	07	3	3,15s	0	0,00s	2	0	1	3,15s
	08	3	2,89s	0	0,00s	2	0	1	2,89s
	09	4	2,45s	0	0,00s	3	0	1	2,45s
	10	3	2,86s	0	0,00s	2	0	1	2,86s
	11	3	3,04s	0	0,00s	2	0	1	3,04s
	12	3	2,99s	0	0,00s	2	0	1	2,99s
	13	5	2,55s	2	1,45s	2	0	1	3,29s
	14	3	3,09s	0	0,00s	2	0	1	3,09s
	15	4	2,51s	0	0,00s	3	0	1	2,51s
	16	4	2,45s	0	0,00s	2	1	1	2,45s
	17	3	4,49s	0	0,00s	2	0	1	4,49s
	18	3	3,03s	0	0,00s	2	0	1	3,03s
	19	3	2,94s	0	0,00s	2	0	1	2,94s
	20	3	5,66s	0	0,00s	2	0	1	5,66s
	21	4	2,62s	0	0,00s	3	0	1	2,62s
	22	3	3,06s	0	0,00s	2	0	1	3,06s
	23	3	3,32s	0	0,00s	2	0	1	3,32s
Sep 30	00	7	25,04s	0	0,00s	2	0	1	3,04s
	01	3	3,26s	0	0,00s	2	0	1	3,26s
	02	3	3,02s	0	0,00s	2	0	1	3,02s
	03	5	2,27s	0	0,00s	4	0	1	2,27s
	04	3	3,04s	0	0,00s	2	0	1	3,04s
	05	3	3,17s	0	0,00s	2	0	1	3,17s
	06	3	3,05s	0	0,00s	2	0	1	3,05s

Queries by type ^

Type	Count	Percentage
SELECT	22	4,37%
INSERT	307	61,03%
UPDATE	3	0,60%
DELETE	140	27,83%
OTHERS	31	6,16%

Sessions per database ^

Database	Count	Total Duration	Av. duration (s)
postgres	3 496	41,93s	0,01s
rhq	18 394	83d12h12,69s	6m32,22s

Sessions per user ^

User	Count	Total Duration	Av. duration (s)
nagios	14 392	3m14,85s	0,01s
postgres	3 359	36,52s	0,01s
rhqadmin	4 139	83d11h57m3,26s	29m2,99s

Sessions per host ^

Host	Count	Total Duration	Av. duration (s)
127.0.0.1	11 226	3m9,40s	0,02s
172.19.32.158	2 093	35d1h46m20,80s	24m7,86s
172.19.32.159	2 046	48d10h10m42,45s	34m4,89s
172.20.46.105	6 525	41,97s	0,01s

Slowest queries ^

Rank	Duration (s)	Query
1	2m11,53s	REINDEX TABLE RHQ_AVAILABILITY;
2	1m56,73s	REINDEX TABLE RHQ_AVAILABILITY;
3	1m53,92s	REINDEX TABLE RHQ_AVAILABILITY;
4	1m50,35s	REINDEX TABLE RHQ_AVAILABILITY;
5	1m35,01s	REINDEX TABLE RHQ_AVAILABILITY;
6	26,61s	REINDEX TABLE RHQ_MEASUREMENT_DATA_NUM_1H;
7	26,08s	VACUUM ANALYZE;
8	24,98s	REINDEX TABLE RHQ_MEASUREMENT_DATA_NUM_1H;
9	24,80s	VACUUM ANALYZE;
10	24,26s	REINDEX TABLE RHQ_MEASUREMENT_DATA_NUM_1H;
11	23,48s	REINDEX TABLE RHQ_MEASUREMENT_DATA_NUM_1H;
12	23,03s	REINDEX TABLE RHQ_MEASUREMENT_DATA_NUM_1H;
13	22,83s	REINDEX TABLE RHQ_MEASUREMENT_DATA_NUM_1H;
14	10,79s	INSERT INTO RHQ_MEASUREMENT_BLINE ( id, BL_MIN, BL_MAX, BL_MEAN, BL_COMPUTE_TIME, SCHEDULE_ID ) SELECT NEXTVAL('RHQ_MEASUREMENT_BLINE_ID_SEQ'), MIN(data1h.minvalue) AS bline_min, MAX(data1h.maxvalue) AS bline_max, AVG(data1h.value) AS bline_mean, '1348941616301' AS bline_ts, data1h.SCHEDULE_ID AS bline_sched_id FROM RHQ_MEASUREMENT_DATA_NUM_1H data1h INNER JOIN RHQ_MEASUREMENT_SCHED sched ON data1h.SCHEDULE_ID = sched.id INNER JOIN RHQ_MEASUREMENT_DEF def ON sched.definition = def.id LEFT OUTER JOIN RHQ_MEASUREMENT_BLINE bline ON sched.id = bline.SCHEDULE_ID WHERE ( def.numeric_type = 0 ) AND ( bline.id IS NULL ) AND ( data1h.TIME_STAMP BETWEEN '1348336816301' AND '1348941616301' ) GROUP BY data1h.SCHEDULE_ID HAVING data1h.SCHEDULE_ID IN ( SELECT DISTINCT (mdata.SCHEDULE_ID) FROM RHQ_MEASUREMENT_DATA_NUM_1H mdata WHERE mdata.TIME_STAMP <= '1348336816301' ) LIMIT 100000;
15	9,83s	ANALYZE;
16	9,50s	ANALYZE;
17	9,04s	REINDEX TABLE RHQ_MEASUREMENT_DATA_NUM_6H;
18	8,73s	ANALYZE;
19	8,71s	REINDEX TABLE RHQ_MEASUREMENT_DATA_NUM_6H;
20	8,51s	REINDEX TABLE RHQ_MEASUREMENT_DATA_NUM_6H;

Queries that took up the most time (N) ^

Rank

Total duration

Times executed

Av. duration (s)

Query

9m27,54s

1m53,51s

reindex TABLE rhq_availability;

8m41,45s

140

Day	Time	Count	Duration	Av. Duration
Sep 24	11	1	3,29s	3,29s
	12	1	3,06s	3,06s
	13	1	3,09s	3,09s
	14	1	3,09s	3,09s
	15	1	3,21s	3,21s
	16	1	3,14s	3,14s
	17	1	3,22s	3,22s
	18	1	3,83s	3,83s
	19	1	3,81s	3,81s
	20	1	3,23s	3,23s
	21	1	3,79s	3,79s
	22	1	3,16s	3,16s
	23	1	2,89s	2,89s
Sep 25	00	1	3,77s	3,77s
	01	1	3,88s	3,88s
	02	1	3,24s	3,24s
	03	1	3,81s	3,81s
	04	1	3,26s	3,26s
	05	1	3,24s	3,24s
	06	1	2,92s	2,92s
	07	1	3,25s	3,25s
	08	1	3,26s	3,26s
	09	1	3,84s	3,84s
	10	1	3,22s	3,22s
	11	1	3,25s	3,25s
	12	1	3,44s	3,44s
	13	1	3,34s	3,34s
	14	1	3,91s	3,91s
	15	1	3,41s	3,41s
	16	1	3,28s	3,28s
	17	1	3,06s	3,06s
	18	1	3,97s	3,97s
	19	1	3,35s	3,35s
	20	1	3,20s	3,20s
	21	1	3,97s	3,97s
	22	1	3,39s	3,39s
	23	1	4,04s	4,04s
Sep 26	00	1	3,53s	3,53s
	01	1	3,40s	3,40s
	02	1	3,12s	3,12s
	03	1	3,48s	3,48s
	04	1	3,53s	3,53s
	05	1	3,92s	3,92s
	06	1	3,48s	3,48s
	07	1	3,48s	3,48s
	08	1	3,23s	3,23s
	09	1	4,15s	4,15s
	10	1	4,10s	4,10s
	11	1	4,16s	4,16s
	12	1	3,70s	3,70s
	13	1	3,41s	3,41s
	14	1	4,18s	4,18s
	15	1	3,27s	3,27s
	16	1	3,64s	3,64s
	17	1	3,63s	3,63s
	18	1	3,63s	3,63s
	19	1	4,28s	4,28s
	20	1	4,24s	4,24s
	21	1	3,33s	3,33s
	22	1	3,31s	3,31s
	23	1	4,25s	4,25s
Sep 27	00	1	3,68s	3,68s
	01	1	3,61s	3,61s
	02	1	3,58s	3,58s
	03	1	3,61s	3,61s
	04	1	4,11s	4,11s
	05	1	4,19s	4,19s
	06	1	3,60s	3,60s
	07	1	3,62s	3,62s
	08	1	4,21s	4,21s
	09	1	3,61s	3,61s
	10	1	3,97s	3,97s
	11	1	3,58s	3,58s
	12	1	4,30s	4,30s
	13	1	3,32s	3,32s
	14	1	3,61s	3,61s
	15	1	3,46s	3,46s
	16	1	3,54s	3,54s
	17	1	3,61s	3,61s
	18	1	3,63s	3,63s
	19	1	3,57s	3,57s
	20	1	3,57s	3,57s
	21	1	3,54s	3,54s
	22	1	3,72s	3,72s
	23	1	3,60s	3,60s
Sep 28	00	1	3,70s	3,70s
	01	1	3,54s	3,54s
	02	1	4,10s	4,10s
	03	1	4,13s	4,13s
	04	1	3,61s	3,61s
	05	1	4,24s	4,24s
	06	1	4,20s	4,20s
	07	1	3,32s	3,32s
	08	1	3,58s	3,58s
	09	1	4,24s	4,24s
	10	1	3,93s	3,93s
	11	1	4,15s	4,15s
	12	1	3,53s	3,53s
	13	1	3,64s	3,64s
	14	1	3,66s	3,66s
	15	1	3,54s	3,54s
	16	1	3,57s	3,57s
	17	1	3,59s	3,59s
	18	1	3,63s	3,63s
	19	1	4,16s	4,16s
	20	1	3,74s	3,74s
	21	1	3,69s	3,69s
	22	1	4,62s	4,62s
	23	1	3,80s	3,80s
Sep 29	00	1	3,86s	3,86s
	01	1	4,37s	4,37s
	02	1	3,62s	3,62s
	03	1	4,29s	4,29s
	04	1	3,67s	3,67s
	05	1	3,69s	3,69s
	06	1	4,36s	4,36s
	07	1	3,73s	3,73s
	08	1	3,83s	3,83s
	09	1	3,78s	3,78s
	10	1	3,70s	3,70s
	11	1	3,70s	3,70s
	12	1	3,92s	3,92s
	13	1	4,48s	4,48s
	14	1	4,52s	4,52s
	15	1	3,76s	3,76s
	16	1	3,82s	3,82s
	17	1	4,86s	4,86s
	18	1	3,97s	3,97s
	19	1	4,00s	4,00s
	20	1	3,94s	3,94s
	21	1	4,07s	4,07s
	22	1	3,99s	3,99s
	23	1	4,69s	4,69s
Sep 30	00	1	4,02s	4,02s
	01	1	4,93s	4,93s
	02	1	4,10s	4,10s
	03	1	4,05s	4,05s
	04	1	4,14s	4,14s
	05	1	4,17s	4,17s
	06	1	4,19s	4,19s

3,72s

DELETE FROM rhq_availability WHERE end_time < '';

8m7,47s

140

Day	Time	Count	Duration	Av. Duration
Sep 24	11	1	7,29s	7,29s
	12	1	5,90s	5,90s
	13	1	5,71s	5,71s
	14	1	5,75s	5,75s
	15	1	5,83s	5,83s
	16	1	4,18s	4,18s
	17	1	5,88s	5,88s
	18	1	5,93s	5,93s
	19	1	5,97s	5,97s
	20	1	5,96s	5,96s
	21	1	5,99s	5,99s
	22	1	6,21s	6,21s
	23	1	6,04s	6,04s
Sep 25	00	1	6,09s	6,09s
	01	1	6,02s	6,02s
	02	1	5,99s	5,99s
	03	1	5,99s	5,99s
	04	1	6,05s	6,05s
	05	1	6,11s	6,11s
	06	1	6,12s	6,12s
	07	1	4,33s	4,33s
	08	1	6,11s	6,11s
	09	1	6,20s	6,20s
	10	1	6,64s	6,64s
	11	1	2,62s	2,62s
	12	1	2,66s	2,66s
	13	1	2,68s	2,68s
	14	1	2,61s	2,61s
	15	1	2,61s	2,61s
	16	1	2,88s	2,88s
	17	1	2,72s	2,72s
	18	1	2,49s	2,49s
	19	1	2,66s	2,66s
	20	1	2,50s	2,50s
	21	1	2,63s	2,63s
	22	1	2,66s	2,66s
	23	1	3,01s	3,01s
Sep 26	00	1	2,93s	2,93s
	01	1	2,78s	2,78s
	02	1	2,66s	2,66s
	03	1	2,57s	2,57s
	04	1	2,63s	2,63s
	05	1	2,68s	2,68s
	06	1	2,48s	2,48s
	07	1	2,56s	2,56s
	08	1	2,60s	2,60s
	09	1	2,66s	2,66s
	10	1	2,66s	2,66s
	11	1	2,72s	2,72s
	12	1	2,78s	2,78s
	13	1	3,40s	3,40s
	14	1	2,76s	2,76s
	15	1	2,71s	2,71s
	16	1	2,66s	2,66s
	17	1	4,92s	4,92s
	18	1	2,52s	2,52s
	19	1	2,58s	2,58s
	20	1	7,44s	7,44s
	21	1	3,11s	3,11s
	22	1	2,62s	2,62s
	23	1	2,74s	2,74s
Sep 27	00	1	3,36s	3,36s
	01	1	2,57s	2,57s
	02	1	2,58s	2,58s
	03	1	2,76s	2,76s
	04	1	2,58s	2,58s
	05	1	2,50s	2,50s
	06	1	2,76s	2,76s
	07	1	2,55s	2,55s
	08	1	2,57s	2,57s
	09	1	3,26s	3,26s
	10	1	2,64s	2,64s
	11	1	2,54s	2,54s
	12	1	2,68s	2,68s
	13	1	2,60s	2,60s
	14	1	2,67s	2,67s
	15	1	2,69s	2,69s
	16	1	2,69s	2,69s
	17	1	2,57s	2,57s
	18	1	2,60s	2,60s
	19	1	2,72s	2,72s
	20	1	3,11s	3,11s
	21	1	2,66s	2,66s
	22	1	2,58s	2,58s
	23	1	2,60s	2,60s
Sep 28	00	1	2,78s	2,78s
	01	1	2,54s	2,54s
	02	1	2,57s	2,57s
	03	1	2,66s	2,66s
	04	1	2,61s	2,61s
	05	1	2,55s	2,55s
	06	1	2,54s	2,54s
	07	1	2,61s	2,61s
	08	1	2,77s	2,77s
	09	1	2,68s	2,68s
	10	1	6,11s	6,11s
	11	1	2,69s	2,69s
	12	1	2,69s	2,69s
	13	1	3,26s	3,26s
	14	1	2,70s	2,70s
	15	1	2,70s	2,70s
	16	1	2,79s	2,79s
	17	1	3,51s	3,51s
	18	1	2,82s	2,82s
	19	1	2,77s	2,77s
	20	1	2,66s	2,66s
	21	1	3,02s	3,02s
	22	1	2,65s	2,65s
	23	1	2,80s	2,80s
Sep 29	00	1	3,84s	3,84s
	01	1	3,41s	3,41s
	02	1	2,72s	2,72s
	03	1	2,65s	2,65s
	04	1	2,77s	2,77s
	05	1	2,76s	2,76s
	06	1	3,35s	3,35s
	07	1	3,40s	3,40s
	08	1	2,73s	2,73s
	09	1	2,86s	2,86s
	10	1	2,89s	2,89s
	11	1	3,38s	3,38s
	12	1	2,95s	2,95s
	13	1	3,35s	3,35s
	14	1	2,78s	2,78s
	15	1	2,79s	2,79s
	16	1	2,76s	2,76s
	17	1	6,51s	6,51s
	18	1	2,91s	2,91s
	19	1	2,76s	2,76s
	20	1	10,79s	10,79s
	21	1	3,27s	3,27s
	22	1	2,93s	2,93s
	23	1	3,13s	3,13s
Sep 30	00	1	3,04s	3,04s
	01	1	2,79s	2,79s
	02	1	2,70s	2,70s
	03	1	2,76s	2,76s
	04	1	2,75s	2,75s
	05	1	3,37s	3,37s
	06	1	2,84s	2,84s

3,48s

INSERT INTO rhq_measurement_bline ( id, bl_min, bl_max, bl_mean, bl_compute_time, schedule_id ) SELECT NEXTVAL(''), min(data1h.minvalue) AS bline_min, max(data1h.maxvalue) AS bline_max, avg(data1h.value) AS bline_mean, '' AS bline_ts, data1h.schedule_id AS bline_sched_id FROM rhq_measurement_data_num_1h data1h INNER JOIN rhq_measurement_sched sched ON data1h.schedule_id = sched.id INNER JOIN rhq_measurement_def def ON sched.definition = def.id LEFT OUTER JOIN rhq_measurement_bline bline ON sched.id = bline.schedule_id WHERE ( def.numeric_type = 0 ) AND ( bline.id IS NULL ) AND ( data1h.time_stamp BETWEEN '' AND '' ) GROUP BY data1h.schedule_id HAVING data1h.schedule_id IN ( SELECT DISTINCT (mdata.schedule_id) FROM rhq_measurement_data_num_1h mdata WHERE mdata.time_stamp <= '' ) LIMIT 0;

10,79s | INSERT INTO RHQ_MEASUREMENT_BLINE ( id, BL_MIN, BL_MAX, BL_MEAN, BL_COMPUTE_TIME, SCHEDULE_ID ) SELECT NEXTVAL('RHQ_MEASUREMENT_BLINE_ID_SEQ'), MIN(data1h.minvalue) AS bline_min, MAX(data1h.maxvalue) AS bline_max, AVG(data1h.value) AS bline_mean, '1348941616301' AS bline_ts, data1h.SCHEDULE_ID AS bline_sched_id FROM RHQ_MEASUREMENT_DATA_NUM_1H data1h INNER JOIN RHQ_MEASUREMENT_SCHED sched ON data1h.SCHEDULE_ID = sched.id INNER JOIN RHQ_MEASUREMENT_DEF def ON sched.definition = def.id LEFT OUTER JOIN RHQ_MEASUREMENT_BLINE bline ON sched.id = bline.SCHEDULE_ID WHERE ( def.numeric_type = 0 ) AND ( bline.id IS NULL ) AND ( data1h.TIME_STAMP BETWEEN '1348336816301' AND '1348941616301' ) GROUP BY data1h.SCHEDULE_ID HAVING data1h.SCHEDULE_ID IN ( SELECT DISTINCT (mdata.SCHEDULE_ID) FROM RHQ_MEASUREMENT_DATA_NUM_1H mdata WHERE mdata.TIME_STAMP <= '1348336816301' ) LIMIT 100000;

7,44s | INSERT INTO RHQ_MEASUREMENT_BLINE ( id, BL_MIN, BL_MAX, BL_MEAN, BL_COMPUTE_TIME, SCHEDULE_ID ) SELECT NEXTVAL('RHQ_MEASUREMENT_BLINE_ID_SEQ'), MIN(data1h.minvalue) AS bline_min, MAX(data1h.maxvalue) AS bline_max, AVG(data1h.value) AS bline_mean, '1348682414354' AS bline_ts, data1h.SCHEDULE_ID AS bline_sched_id FROM RHQ_MEASUREMENT_DATA_NUM_1H data1h INNER JOIN RHQ_MEASUREMENT_SCHED sched ON data1h.SCHEDULE_ID = sched.id INNER JOIN RHQ_MEASUREMENT_DEF def ON sched.definition = def.id LEFT OUTER JOIN RHQ_MEASUREMENT_BLINE bline ON sched.id = bline.SCHEDULE_ID WHERE ( def.numeric_type = 0 ) AND ( bline.id IS NULL ) AND ( data1h.TIME_STAMP BETWEEN '1348077614354' AND '1348682414354' ) GROUP BY data1h.SCHEDULE_ID HAVING data1h.SCHEDULE_ID IN ( SELECT DISTINCT (mdata.SCHEDULE_ID) FROM RHQ_MEASUREMENT_DATA_NUM_1H mdata WHERE mdata.TIME_STAMP <= '1348077614354' ) LIMIT 100000;

7,29s | INSERT INTO RHQ_MEASUREMENT_BLINE ( id, BL_MIN, BL_MAX, BL_MEAN, BL_COMPUTE_TIME, SCHEDULE_ID ) SELECT NEXTVAL('RHQ_MEASUREMENT_BLINE_ID_SEQ'), MIN(data1h.minvalue) AS bline_min, MAX(data1h.maxvalue) AS bline_max, AVG(data1h.value) AS bline_mean, '1348477215421' AS bline_ts, data1h.SCHEDULE_ID AS bline_sched_id FROM RHQ_MEASUREMENT_DATA_NUM_1H data1h INNER JOIN RHQ_MEASUREMENT_SCHED sched ON data1h.SCHEDULE_ID = sched.id INNER JOIN RHQ_MEASUREMENT_DEF def ON sched.definition = def.id LEFT OUTER JOIN RHQ_MEASUREMENT_BLINE bline ON sched.id = bline.SCHEDULE_ID WHERE ( def.numeric_type = 0 ) AND ( bline.id IS NULL ) AND ( data1h.TIME_STAMP BETWEEN '1347872415421' AND '1348477215421' ) GROUP BY data1h.SCHEDULE_ID HAVING data1h.SCHEDULE_ID IN ( SELECT DISTINCT (mdata.SCHEDULE_ID) FROM RHQ_MEASUREMENT_DATA_NUM_1H mdata WHERE mdata.TIME_STAMP <= '1347872415421' ) LIMIT 100000;

3m11,21s

120

Day	Time	Count	Duration	Av. Duration
Sep 24	15	1	0,64s	0,64s
	16	1	1,48s	1,48s
	17	1	1,51s	1,51s
	18	1	1,71s	1,71s
	19	1	1,47s	1,47s
	20	1	1,52s	1,52s
	21	1	1,87s	1,87s
	22	1	1,83s	1,83s
	23	1	1,62s	1,62s
Sep 25	00	1	1,60s	1,60s
	01	1	1,60s	1,60s
	02	1	1,54s	1,54s
	03	1	1,76s	1,76s
	04	1	1,53s	1,53s
	05	1	1,59s	1,59s
	06	1	1,51s	1,51s
	07	1	1,58s	1,58s
	08	1	1,57s	1,57s
	09	1	1,67s	1,67s
	10	1	1,65s	1,65s
	11	1	1,60s	1,60s
	12	1	1,63s	1,63s
	13	1	1,72s	1,72s
	14	1	1,69s	1,69s
	15	1	1,86s	1,86s
	16	1	1,72s	1,72s
	17	1	1,57s	1,57s
	18	1	1,65s	1,65s
	19	1	1,62s	1,62s
	20	1	1,82s	1,82s
	21	1	1,85s	1,85s
	22	1	1,53s	1,53s
	23	1	1,65s	1,65s
Sep 26	00	1	1,61s	1,61s
	01	1	1,49s	1,49s
	02	1	1,71s	1,71s
	03	1	1,53s	1,53s
	04	1	1,58s	1,58s
	05	1	1,72s	1,72s
	06	1	1,72s	1,72s
	07	1	1,75s	1,75s
	08	1	1,73s	1,73s
	09	1	1,75s	1,75s
	10	1	1,58s	1,58s
	11	1	1,55s	1,55s
	12	1	1,69s	1,69s
	13	1	1,61s	1,61s
	14	1	1,59s	1,59s
	15	1	1,35s	1,35s
	16	1	1,29s	1,29s
	17	1	1,36s	1,36s
	18	1	1,22s	1,22s
	19	1	1,49s	1,49s
	20	1	1,30s	1,30s
	21	1	1,25s	1,25s
	22	1	1,30s	1,30s
	23	1	1,35s	1,35s
Sep 27	00	1	1,34s	1,34s
	01	1	1,34s	1,34s
	02	1	1,44s	1,44s
	03	1	1,34s	1,34s
	04	1	1,25s	1,25s
	05	1	1,18s	1,18s
	06	1	1,28s	1,28s
	07	1	1,21s	1,21s
	08	1	1,32s	1,32s
	09	1	1,23s	1,23s
	10	1	1,28s	1,28s
	11	1	1,34s	1,34s
	12	1	1,33s	1,33s
	13	1	1,41s	1,41s
	14	1	1,28s	1,28s
	15	1	1,46s	1,46s
	16	1	1,25s	1,25s
	17	1	1,37s	1,37s
	18	1	1,26s	1,26s
	19	1	1,31s	1,31s
	20	1	1,30s	1,30s
	21	1	1,40s	1,40s
	22	1	1,40s	1,40s
	23	1	1,51s	1,51s
Sep 28	00	1	1,28s	1,28s
	01	1	1,30s	1,30s
	02	1	1,44s	1,44s
	03	1	1,20s	1,20s
	04	1	1,20s	1,20s
	05	1	1,11s	1,11s
	06	1	1,45s	1,45s
	07	1	1,19s	1,19s
	08	1	1,42s	1,42s
	09	1	1,32s	1,32s
	10	1	1,19s	1,19s
	11	1	1,16s	1,16s
	12	1	1,72s	1,72s
	13	1	1,76s	1,76s
	14	1	1,74s	1,74s
	15	1	1,64s	1,64s
	16	1	1,61s	1,61s
	17	1	1,84s	1,84s
	18	1	2,05s	2,05s
	19	1	1,99s	1,99s
	20	1	2,22s	2,22s
	21	1	2,08s	2,08s
	22	1	2,21s	2,21s
	23	1	2,10s	2,10s
Sep 29	00	1	2,03s	2,03s
	01	1	2,21s	2,21s
	02	1	2,14s	2,14s
	03	1	2,24s	2,24s
	04	1	2,36s	2,36s
	05	1	1,97s	1,97s
	06	1	1,93s	1,93s
	07	1	2,31s	2,31s
	08	1	2,13s	2,13s
	09	1	2,08s	2,08s
	10	1	1,98s	1,98s
	11	1	2,03s	2,03s
	12	1	2,10s	2,10s
	13	1	2,03s	2,03s
	14	1	1,97s	1,97s

1,59s

INSERT INTO rhq_measurement_data_num_1h (SELECT '', ft.schedule_id, avg(value), min(value), max(value) FROM rhq_meas_data_num_r00 ft WHERE ft.time_stamp >= '' AND ft.time_stamp < '' GROUP BY ft.schedule_id);

2m25,21s

24,20s

reindex TABLE rhq_measurement_data_num_1h;

51,25s

8,54s

reindex TABLE rhq_measurement_data_num_6h;

50,88s

25,44s

VACUUM ANALYZE;

44,20s

8,84s

ANALYZE;

38,47s

Day	Time	Count	Duration	Av. Duration
Sep 24	11	1	2,45s	2,45s
	15	1	1,56s	1,56s
Sep 29	15	1	2,31s	2,31s
	16	1	2,05s	2,05s
	17	1	2,11s	2,11s
	18	1	2,20s	2,20s
	19	1	2,05s	2,05s
	20	1	2,25s	2,25s
	21	1	2,07s	2,07s
	22	1	2,28s	2,28s
	23	1	2,13s	2,13s
Sep 30	00	1	2,07s	2,07s
	01	1	2,05s	2,05s
	02	1	2,26s	2,26s
	03	1	2,33s	2,33s
	04	1	2,22s	2,22s
	05	1	1,97s	1,97s
	06	1	2,12s	2,12s

2,14s

INSERT INTO rhq_measurement_data_num_1h (SELECT '', ft.schedule_id, avg(value), min(value), max(value) FROM rhq_meas_data_num_r10 ft WHERE ft.time_stamp >= '' AND ft.time_stamp < '' GROUP BY ft.schedule_id);

21,44s

3,57s

reindex TABLE rhq_measurement_data_num_1d;

20,00s

Day	Time	Count	Duration	Av. Duration
Sep 24	15	1	0,86s	0,86s
	21	1	0,85s	0,85s
Sep 25	03	1	0,87s	0,87s
	09	1	1,13s	1,13s
	15	1	0,90s	0,90s
	21	1	0,87s	0,87s
Sep 26	03	1	0,80s	0,80s
	09	1	0,77s	0,77s
	15	1	0,54s	0,54s
	21	1	0,68s	0,68s
Sep 27	03	1	0,65s	0,65s
	09	1	0,59s	0,59s
	15	1	0,64s	0,64s
	21	1	0,79s	0,79s
Sep 28	03	1	0,66s	0,66s
	09	1	0,61s	0,61s
	15	1	0,86s	0,86s
	21	1	1,14s	1,14s
Sep 29	03	1	1,16s	1,16s
	09	1	1,08s	1,08s
	15	1	1,17s	1,17s
	21	1	1,06s	1,06s
Sep 30	03	1	1,32s	1,32s

0,87s

INSERT INTO rhq_measurement_data_num_6h (SELECT '', ft.schedule_id, avg(value), min(minvalue), max(maxvalue) FROM rhq_measurement_data_num_1h ft WHERE ft.time_stamp >= '' AND ft.time_stamp < '' GROUP BY ft.schedule_id);

10,03s

1,67s

SELECT pg_stop_backup();

7,18s

UPDATE RHQ_AGENT SET STATUS=0 WHERE ID IN ('10161');

5,78s

0,64s

SELECT (SELECT count(resourceav3_.id) FROM rhq_resource_group_res_exp_map explicitre1_, rhq_resource resource2_ INNER JOIN rhq_resource_avail resourceav3_ ON resource2_.id=resourceav3_.resource_id WHERE resourcegr0_.id=explicitre1_.resource_group_id AND explicitre1_.resource_id=resource2_.id) AS col_0_0_, (SELECT count(resourceav6_.id) FROM rhq_resource_group_res_exp_map explicitre4_, rhq_resource resource5_ INNER JOIN rhq_resource_avail resourceav6_ ON resource5_.id=resourceav6_.resource_id WHERE resourcegr0_.id=explicitre4_.resource_group_id AND explicitre4_.resource_id=resource5_.id AND resourceav6_.availability_type=0) AS col_1_0_, (SELECT count(resourceav9_.id) FROM rhq_resource_group_res_exp_map explicitre7_, rhq_resource resource8_ INNER JOIN rhq_resource_avail resourceav9_ ON resource8_.id=resourceav9_.resource_id WHERE resourcegr0_.id=explicitre7_.resource_group_id AND explicitre7_.resource_id=resource8_.id AND resourceav9_.availability_type=0) AS col_2_0_, (SELECT count(resourceav10_.id) FROM rhq_resource_group_res_exp_map explicitre10_, rhq_resource resource10_ INNER JOIN rhq_resource_avail resourceav10_ ON resource10_.id=resourceav10_.resource_id WHERE resourcegr0_.id=explicitre10_.resource_group_id AND explicitre10_.resource_id=resource10_.id AND resourceav10_.availability_type=0) AS col_3_0_, (SELECT count(resourceav10_.id) FROM rhq_resource_group_res_imp_map implicitre10_, rhq_resource resource10_ INNER JOIN rhq_resource_avail resourceav10_ ON resource10_.id=resourceav10_.resource_id WHERE resourcegr0_.id=implicitre10_.resource_group_id AND implicitre10_.resource_id=resource10_.id) AS col_4_0_, (SELECT count(resourceav10_.id) FROM rhq_resource_group_res_imp_map implicitre10_, rhq_resource resource10_ INNER JOIN rhq_resource_avail resourceav10_ ON resource10_.id=resourceav10_.resource_id WHERE resourcegr0_.id=implicitre10_.resource_group_id AND implicitre10_.resource_id=resource10_.id AND resourceav10_.availability_type=0) AS col_5_0_, (SELECT count(resourceav20_.id) FROM rhq_resource_group_res_imp_map implicitre10_, rhq_resource resource20_ INNER JOIN rhq_resource_avail resourceav20_ ON resource20_.id=resourceav20_.resource_id WHERE resourcegr0_.id=implicitre10_.resource_group_id AND implicitre10_.resource_id=resource20_.id AND resourceav20_.availability_type=0) AS col_6_0_, (SELECT count(resourceav20_.id) FROM rhq_resource_group_res_imp_map implicitre20_, rhq_resource resource20_ INNER JOIN rhq_resource_avail resourceav20_ ON resource20_.id=resourceav20_.resource_id WHERE resourcegr0_.id=implicitre20_.resource_group_id AND implicitre20_.resource_id=resource20_.id AND resourceav20_.availability_type=0) AS col_7_0_, resourcegr0_.id AS col_8_0_ FROM rhq_resource_group resourcegr0_ WHERE resourcegr0_.visible='' LIMIT '';

0,71s | SELECT (SELECT count(resourceav3_.ID) FROM RHQ_RESOURCE_GROUP_RES_EXP_MAP explicitre1_, RHQ_RESOURCE resource2_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav3_ ON resource2_.ID=resourceav3_.RESOURCE_ID WHERE resourcegr0_.ID=explicitre1_.RESOURCE_GROUP_ID AND explicitre1_.RESOURCE_ID=resource2_.ID) AS col_0_0_, (SELECT count(resourceav6_.ID) FROM RHQ_RESOURCE_GROUP_RES_EXP_MAP explicitre4_, RHQ_RESOURCE resource5_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav6_ ON resource5_.ID=resourceav6_.RESOURCE_ID WHERE resourcegr0_.ID=explicitre4_.RESOURCE_GROUP_ID AND explicitre4_.RESOURCE_ID=resource5_.ID AND resourceav6_.AVAILABILITY_TYPE=0) AS col_1_0_, (SELECT count(resourceav9_.ID) FROM RHQ_RESOURCE_GROUP_RES_EXP_MAP explicitre7_, RHQ_RESOURCE resource8_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav9_ ON resource8_.ID=resourceav9_.RESOURCE_ID WHERE resourcegr0_.ID=explicitre7_.RESOURCE_GROUP_ID AND explicitre7_.RESOURCE_ID=resource8_.ID AND resourceav9_.AVAILABILITY_TYPE=2) AS col_2_0_, (SELECT count(resourceav12_.ID) FROM RHQ_RESOURCE_GROUP_RES_EXP_MAP explicitre10_, RHQ_RESOURCE resource11_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav12_ ON resource11_.ID=resourceav12_.RESOURCE_ID WHERE resourcegr0_.ID=explicitre10_.RESOURCE_GROUP_ID AND explicitre10_.RESOURCE_ID=resource11_.ID AND resourceav12_.AVAILABILITY_TYPE=3) AS col_3_0_, (SELECT count(resourceav15_.ID) FROM RHQ_RESOURCE_GROUP_RES_IMP_MAP implicitre13_, RHQ_RESOURCE resource14_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav15_ ON resource14_.ID=resourceav15_.RESOURCE_ID WHERE resourcegr0_.ID=implicitre13_.RESOURCE_GROUP_ID AND implicitre13_.RESOURCE_ID=resource14_.ID) AS col_4_0_, (SELECT count(resourceav18_.ID) FROM RHQ_RESOURCE_GROUP_RES_IMP_MAP implicitre16_, RHQ_RESOURCE resource17_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav18_ ON resource17_.ID=resourceav18_.RESOURCE_ID WHERE resourcegr0_.ID=implicitre16_.RESOURCE_GROUP_ID AND implicitre16_.RESOURCE_ID=resource17_.ID AND resourceav18_.AVAILABILITY_TYPE=0) AS col_5_0_, (SELECT count(resourceav21_.ID) FROM RHQ_RESOURCE_GROUP_RES_IMP_MAP implicitre19_, RHQ_RESOURCE resource20_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav21_ ON resource20_.ID=resourceav21_.RESOURCE_ID WHERE resourcegr0_.ID=implicitre19_.RESOURCE_GROUP_ID AND implicitre19_.RESOURCE_ID=resource20_.ID AND resourceav21_.AVAILABILITY_TYPE=2) AS col_6_0_, (SELECT count(resourceav24_.ID) FROM RHQ_RESOURCE_GROUP_RES_IMP_MAP implicitre22_, RHQ_RESOURCE resource23_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav24_ ON resource23_.ID=resourceav24_.RESOURCE_ID WHERE resourcegr0_.ID=implicitre22_.RESOURCE_GROUP_ID AND implicitre22_.RESOURCE_ID=resource23_.ID AND resourceav24_.AVAILABILITY_TYPE=3) AS col_7_0_, resourcegr0_.ID AS col_8_0_ FROM RHQ_RESOURCE_GROUP resourcegr0_ WHERE resourcegr0_.visible='t' LIMIT '50';

0,70s | SELECT (SELECT count(resourceav3_.ID) FROM RHQ_RESOURCE_GROUP_RES_EXP_MAP explicitre1_, RHQ_RESOURCE resource2_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav3_ ON resource2_.ID=resourceav3_.RESOURCE_ID WHERE resourcegr0_.ID=explicitre1_.RESOURCE_GROUP_ID AND explicitre1_.RESOURCE_ID=resource2_.ID) AS col_0_0_, (SELECT count(resourceav6_.ID) FROM RHQ_RESOURCE_GROUP_RES_EXP_MAP explicitre4_, RHQ_RESOURCE resource5_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav6_ ON resource5_.ID=resourceav6_.RESOURCE_ID WHERE resourcegr0_.ID=explicitre4_.RESOURCE_GROUP_ID AND explicitre4_.RESOURCE_ID=resource5_.ID AND resourceav6_.AVAILABILITY_TYPE=0) AS col_1_0_, (SELECT count(resourceav9_.ID) FROM RHQ_RESOURCE_GROUP_RES_EXP_MAP explicitre7_, RHQ_RESOURCE resource8_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav9_ ON resource8_.ID=resourceav9_.RESOURCE_ID WHERE resourcegr0_.ID=explicitre7_.RESOURCE_GROUP_ID AND explicitre7_.RESOURCE_ID=resource8_.ID AND resourceav9_.AVAILABILITY_TYPE=2) AS col_2_0_, (SELECT count(resourceav12_.ID) FROM RHQ_RESOURCE_GROUP_RES_EXP_MAP explicitre10_, RHQ_RESOURCE resource11_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav12_ ON resource11_.ID=resourceav12_.RESOURCE_ID WHERE resourcegr0_.ID=explicitre10_.RESOURCE_GROUP_ID AND explicitre10_.RESOURCE_ID=resource11_.ID AND resourceav12_.AVAILABILITY_TYPE=3) AS col_3_0_, (SELECT count(resourceav15_.ID) FROM RHQ_RESOURCE_GROUP_RES_IMP_MAP implicitre13_, RHQ_RESOURCE resource14_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav15_ ON resource14_.ID=resourceav15_.RESOURCE_ID WHERE resourcegr0_.ID=implicitre13_.RESOURCE_GROUP_ID AND implicitre13_.RESOURCE_ID=resource14_.ID) AS col_4_0_, (SELECT count(resourceav18_.ID) FROM RHQ_RESOURCE_GROUP_RES_IMP_MAP implicitre16_, RHQ_RESOURCE resource17_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav18_ ON resource17_.ID=resourceav18_.RESOURCE_ID WHERE resourcegr0_.ID=implicitre16_.RESOURCE_GROUP_ID AND implicitre16_.RESOURCE_ID=resource17_.ID AND resourceav18_.AVAILABILITY_TYPE=0) AS col_5_0_, (SELECT count(resourceav21_.ID) FROM RHQ_RESOURCE_GROUP_RES_IMP_MAP implicitre19_, RHQ_RESOURCE resource20_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav21_ ON resource20_.ID=resourceav21_.RESOURCE_ID WHERE resourcegr0_.ID=implicitre19_.RESOURCE_GROUP_ID AND implicitre19_.RESOURCE_ID=resource20_.ID AND resourceav21_.AVAILABILITY_TYPE=2) AS col_6_0_, (SELECT count(resourceav24_.ID) FROM RHQ_RESOURCE_GROUP_RES_IMP_MAP implicitre22_, RHQ_RESOURCE resource23_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav24_ ON resource23_.ID=resourceav24_.RESOURCE_ID WHERE resourcegr0_.ID=implicitre22_.RESOURCE_GROUP_ID AND implicitre22_.RESOURCE_ID=resource23_.ID AND resourceav24_.AVAILABILITY_TYPE=3) AS col_7_0_, resourcegr0_.ID AS col_8_0_ FROM RHQ_RESOURCE_GROUP resourcegr0_ WHERE resourcegr0_.visible='t' LIMIT '54';

0,68s | SELECT (SELECT count(resourceav3_.ID) FROM RHQ_RESOURCE_GROUP_RES_EXP_MAP explicitre1_, RHQ_RESOURCE resource2_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav3_ ON resource2_.ID=resourceav3_.RESOURCE_ID WHERE resourcegr0_.ID=explicitre1_.RESOURCE_GROUP_ID AND explicitre1_.RESOURCE_ID=resource2_.ID) AS col_0_0_, (SELECT count(resourceav6_.ID) FROM RHQ_RESOURCE_GROUP_RES_EXP_MAP explicitre4_, RHQ_RESOURCE resource5_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav6_ ON resource5_.ID=resourceav6_.RESOURCE_ID WHERE resourcegr0_.ID=explicitre4_.RESOURCE_GROUP_ID AND explicitre4_.RESOURCE_ID=resource5_.ID AND resourceav6_.AVAILABILITY_TYPE=0) AS col_1_0_, (SELECT count(resourceav9_.ID) FROM RHQ_RESOURCE_GROUP_RES_EXP_MAP explicitre7_, RHQ_RESOURCE resource8_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav9_ ON resource8_.ID=resourceav9_.RESOURCE_ID WHERE resourcegr0_.ID=explicitre7_.RESOURCE_GROUP_ID AND explicitre7_.RESOURCE_ID=resource8_.ID AND resourceav9_.AVAILABILITY_TYPE=2) AS col_2_0_, (SELECT count(resourceav12_.ID) FROM RHQ_RESOURCE_GROUP_RES_EXP_MAP explicitre10_, RHQ_RESOURCE resource11_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav12_ ON resource11_.ID=resourceav12_.RESOURCE_ID WHERE resourcegr0_.ID=explicitre10_.RESOURCE_GROUP_ID AND explicitre10_.RESOURCE_ID=resource11_.ID AND resourceav12_.AVAILABILITY_TYPE=3) AS col_3_0_, (SELECT count(resourceav15_.ID) FROM RHQ_RESOURCE_GROUP_RES_IMP_MAP implicitre13_, RHQ_RESOURCE resource14_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav15_ ON resource14_.ID=resourceav15_.RESOURCE_ID WHERE resourcegr0_.ID=implicitre13_.RESOURCE_GROUP_ID AND implicitre13_.RESOURCE_ID=resource14_.ID) AS col_4_0_, (SELECT count(resourceav18_.ID) FROM RHQ_RESOURCE_GROUP_RES_IMP_MAP implicitre16_, RHQ_RESOURCE resource17_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav18_ ON resource17_.ID=resourceav18_.RESOURCE_ID WHERE resourcegr0_.ID=implicitre16_.RESOURCE_GROUP_ID AND implicitre16_.RESOURCE_ID=resource17_.ID AND resourceav18_.AVAILABILITY_TYPE=0) AS col_5_0_, (SELECT count(resourceav21_.ID) FROM RHQ_RESOURCE_GROUP_RES_IMP_MAP implicitre19_, RHQ_RESOURCE resource20_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav21_ ON resource20_.ID=resourceav21_.RESOURCE_ID WHERE resourcegr0_.ID=implicitre19_.RESOURCE_GROUP_ID AND implicitre19_.RESOURCE_ID=resource20_.ID AND resourceav21_.AVAILABILITY_TYPE=2) AS col_6_0_, (SELECT count(resourceav24_.ID) FROM RHQ_RESOURCE_GROUP_RES_IMP_MAP implicitre22_, RHQ_RESOURCE resource23_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav24_ ON resource23_.ID=resourceav24_.RESOURCE_ID WHERE resourcegr0_.ID=implicitre22_.RESOURCE_GROUP_ID AND implicitre22_.RESOURCE_ID=resource23_.ID AND resourceav24_.AVAILABILITY_TYPE=3) AS col_7_0_, resourcegr0_.ID AS col_8_0_ FROM RHQ_RESOURCE_GROUP resourcegr0_ WHERE resourcegr0_.visible='t' LIMIT '54';

3,85s

0,64s

INSERT INTO rhq_measurement_data_num_1d (SELECT '', ft.schedule_id, avg(value), min(minvalue), max(maxvalue) FROM rhq_measurement_data_num_6h ft WHERE ft.time_stamp >= '' AND ft.time_stamp < '' GROUP BY ft.schedule_id);

2,81s

0,70s

SELECT pg_start_backup('', true);

2,03s

1,02s

SELECT count(alertcondi0_.id) AS col_0_0_ FROM rhq_alert_condition alertcondi0_ INNER JOIN rhq_alert_definition alertdefin1_ ON alertcondi0_.alert_definition_id=alertdefin1_.id INNER JOIN rhq_resource resource2_ ON alertdefin1_.resource_id=resource2_.id WHERE (alertdefin1_.recovery_id=0 OR alertdefin1_.recovery_id<>0 AND (EXISTS (SELECT alertdefin3_.id FROM rhq_alert_definition alertdefin3_ WHERE alertdefin3_.id=alertdefin1_.recovery_id AND alertdefin3_.deleted=false AND alertdefin3_.enabled=false))) AND (resource2_.agent_id='' OR '' IS NULL) AND alertdefin1_.enabled=true AND alertdefin1_.deleted=false AND alertcondi0_.type='';

1,15s

UPDATE RHQ_AGENT SET LAST_AVAILABILITY_PING='1348928946344', BACKFILLED=false WHERE NAME='swishostbossa02';

0,77s

UPDATE RHQ_RESOURCE SET UUID='097ed54d-bd35-4e96-bb33-16fc594df0e1', RESOURCE_KEY='infroerrorboss02.schlund.de RHQ Agent', NAME='RHQ Agent', ANCESTRY='10008_:_10581_:_infroerrorboss02.schlund.de', INVENTORY_STATUS='COMMITTED', CONNECTED='f', VERSION='4.4.0', DESCRIPTION='RHQ Management Agent', CTIME='1340794523724', MTIME='1340794530641', ITIME='1340794530641', MODIFIED_BY='admin', LOCATION=NULL, RESOURCE_TYPE_ID='10147', PARENT_RESOURCE_ID='10581', RES_CONFIGURATION_ID='82952', PLUGIN_CONFIGURATION_ID='12774', AGENT_ID='10061', PRODUCT_VERSION_ID='10002' WHERE ID='10582';

0,57s

COMMIT;

Most frequent queries (N) ^

Rank

Times executed

Total duration

Av. duration (s)

Query

140

Day	Time	Count	Duration	Av. Duration
Sep 24	11	1	3,29s	3,29s
	12	1	3,06s	3,06s
	13	1	3,09s	3,09s
	14	1	3,09s	3,09s
	15	1	3,21s	3,21s
	16	1	3,14s	3,14s
	17	1	3,22s	3,22s
	18	1	3,83s	3,83s
	19	1	3,81s	3,81s
	20	1	3,23s	3,23s
	21	1	3,79s	3,79s
	22	1	3,16s	3,16s
	23	1	2,89s	2,89s
Sep 25	00	1	3,77s	3,77s
	01	1	3,88s	3,88s
	02	1	3,24s	3,24s
	03	1	3,81s	3,81s
	04	1	3,26s	3,26s
	05	1	3,24s	3,24s
	06	1	2,92s	2,92s
	07	1	3,25s	3,25s
	08	1	3,26s	3,26s
	09	1	3,84s	3,84s
	10	1	3,22s	3,22s
	11	1	3,25s	3,25s
	12	1	3,44s	3,44s
	13	1	3,34s	3,34s
	14	1	3,91s	3,91s
	15	1	3,41s	3,41s
	16	1	3,28s	3,28s
	17	1	3,06s	3,06s
	18	1	3,97s	3,97s
	19	1	3,35s	3,35s
	20	1	3,20s	3,20s
	21	1	3,97s	3,97s
	22	1	3,39s	3,39s
	23	1	4,04s	4,04s
Sep 26	00	1	3,53s	3,53s
	01	1	3,40s	3,40s
	02	1	3,12s	3,12s
	03	1	3,48s	3,48s
	04	1	3,53s	3,53s
	05	1	3,92s	3,92s
	06	1	3,48s	3,48s
	07	1	3,48s	3,48s
	08	1	3,23s	3,23s
	09	1	4,15s	4,15s
	10	1	4,10s	4,10s
	11	1	4,16s	4,16s
	12	1	3,70s	3,70s
	13	1	3,41s	3,41s
	14	1	4,18s	4,18s
	15	1	3,27s	3,27s
	16	1	3,64s	3,64s
	17	1	3,63s	3,63s
	18	1	3,63s	3,63s
	19	1	4,28s	4,28s
	20	1	4,24s	4,24s
	21	1	3,33s	3,33s
	22	1	3,31s	3,31s
	23	1	4,25s	4,25s
Sep 27	00	1	3,68s	3,68s
	01	1	3,61s	3,61s
	02	1	3,58s	3,58s
	03	1	3,61s	3,61s
	04	1	4,11s	4,11s
	05	1	4,19s	4,19s
	06	1	3,60s	3,60s
	07	1	3,62s	3,62s
	08	1	4,21s	4,21s
	09	1	3,61s	3,61s
	10	1	3,97s	3,97s
	11	1	3,58s	3,58s
	12	1	4,30s	4,30s
	13	1	3,32s	3,32s
	14	1	3,61s	3,61s
	15	1	3,46s	3,46s
	16	1	3,54s	3,54s
	17	1	3,61s	3,61s
	18	1	3,63s	3,63s
	19	1	3,57s	3,57s
	20	1	3,57s	3,57s
	21	1	3,54s	3,54s
	22	1	3,72s	3,72s
	23	1	3,60s	3,60s
Sep 28	00	1	3,70s	3,70s
	01	1	3,54s	3,54s
	02	1	4,10s	4,10s
	03	1	4,13s	4,13s
	04	1	3,61s	3,61s
	05	1	4,24s	4,24s
	06	1	4,20s	4,20s
	07	1	3,32s	3,32s
	08	1	3,58s	3,58s
	09	1	4,24s	4,24s
	10	1	3,93s	3,93s
	11	1	4,15s	4,15s
	12	1	3,53s	3,53s
	13	1	3,64s	3,64s
	14	1	3,66s	3,66s
	15	1	3,54s	3,54s
	16	1	3,57s	3,57s
	17	1	3,59s	3,59s
	18	1	3,63s	3,63s
	19	1	4,16s	4,16s
	20	1	3,74s	3,74s
	21	1	3,69s	3,69s
	22	1	4,62s	4,62s
	23	1	3,80s	3,80s
Sep 29	00	1	3,86s	3,86s
	01	1	4,37s	4,37s
	02	1	3,62s	3,62s
	03	1	4,29s	4,29s
	04	1	3,67s	3,67s
	05	1	3,69s	3,69s
	06	1	4,36s	4,36s
	07	1	3,73s	3,73s
	08	1	3,83s	3,83s
	09	1	3,78s	3,78s
	10	1	3,70s	3,70s
	11	1	3,70s	3,70s
	12	1	3,92s	3,92s
	13	1	4,48s	4,48s
	14	1	4,52s	4,52s
	15	1	3,76s	3,76s
	16	1	3,82s	3,82s
	17	1	4,86s	4,86s
	18	1	3,97s	3,97s
	19	1	4,00s	4,00s
	20	1	3,94s	3,94s
	21	1	4,07s	4,07s
	22	1	3,99s	3,99s
	23	1	4,69s	4,69s
Sep 30	00	1	4,02s	4,02s
	01	1	4,93s	4,93s
	02	1	4,10s	4,10s
	03	1	4,05s	4,05s
	04	1	4,14s	4,14s
	05	1	4,17s	4,17s
	06	1	4,19s	4,19s

8m41,45s

3,72s

DELETE FROM rhq_availability WHERE end_time < '';

140

Day	Time	Count	Duration	Av. Duration
Sep 24	11	1	7,29s	7,29s
	12	1	5,90s	5,90s
	13	1	5,71s	5,71s
	14	1	5,75s	5,75s
	15	1	5,83s	5,83s
	16	1	4,18s	4,18s
	17	1	5,88s	5,88s
	18	1	5,93s	5,93s
	19	1	5,97s	5,97s
	20	1	5,96s	5,96s
	21	1	5,99s	5,99s
	22	1	6,21s	6,21s
	23	1	6,04s	6,04s
Sep 25	00	1	6,09s	6,09s
	01	1	6,02s	6,02s
	02	1	5,99s	5,99s
	03	1	5,99s	5,99s
	04	1	6,05s	6,05s
	05	1	6,11s	6,11s
	06	1	6,12s	6,12s
	07	1	4,33s	4,33s
	08	1	6,11s	6,11s
	09	1	6,20s	6,20s
	10	1	6,64s	6,64s
	11	1	2,62s	2,62s
	12	1	2,66s	2,66s
	13	1	2,68s	2,68s
	14	1	2,61s	2,61s
	15	1	2,61s	2,61s
	16	1	2,88s	2,88s
	17	1	2,72s	2,72s
	18	1	2,49s	2,49s
	19	1	2,66s	2,66s
	20	1	2,50s	2,50s
	21	1	2,63s	2,63s
	22	1	2,66s	2,66s
	23	1	3,01s	3,01s
Sep 26	00	1	2,93s	2,93s
	01	1	2,78s	2,78s
	02	1	2,66s	2,66s
	03	1	2,57s	2,57s
	04	1	2,63s	2,63s
	05	1	2,68s	2,68s
	06	1	2,48s	2,48s
	07	1	2,56s	2,56s
	08	1	2,60s	2,60s
	09	1	2,66s	2,66s
	10	1	2,66s	2,66s
	11	1	2,72s	2,72s
	12	1	2,78s	2,78s
	13	1	3,40s	3,40s
	14	1	2,76s	2,76s
	15	1	2,71s	2,71s
	16	1	2,66s	2,66s
	17	1	4,92s	4,92s
	18	1	2,52s	2,52s
	19	1	2,58s	2,58s
	20	1	7,44s	7,44s
	21	1	3,11s	3,11s
	22	1	2,62s	2,62s
	23	1	2,74s	2,74s
Sep 27	00	1	3,36s	3,36s
	01	1	2,57s	2,57s
	02	1	2,58s	2,58s
	03	1	2,76s	2,76s
	04	1	2,58s	2,58s
	05	1	2,50s	2,50s
	06	1	2,76s	2,76s
	07	1	2,55s	2,55s
	08	1	2,57s	2,57s
	09	1	3,26s	3,26s
	10	1	2,64s	2,64s
	11	1	2,54s	2,54s
	12	1	2,68s	2,68s
	13	1	2,60s	2,60s
	14	1	2,67s	2,67s
	15	1	2,69s	2,69s
	16	1	2,69s	2,69s
	17	1	2,57s	2,57s
	18	1	2,60s	2,60s
	19	1	2,72s	2,72s
	20	1	3,11s	3,11s
	21	1	2,66s	2,66s
	22	1	2,58s	2,58s
	23	1	2,60s	2,60s
Sep 28	00	1	2,78s	2,78s
	01	1	2,54s	2,54s
	02	1	2,57s	2,57s
	03	1	2,66s	2,66s
	04	1	2,61s	2,61s
	05	1	2,55s	2,55s
	06	1	2,54s	2,54s
	07	1	2,61s	2,61s
	08	1	2,77s	2,77s
	09	1	2,68s	2,68s
	10	1	6,11s	6,11s
	11	1	2,69s	2,69s
	12	1	2,69s	2,69s
	13	1	3,26s	3,26s
	14	1	2,70s	2,70s
	15	1	2,70s	2,70s
	16	1	2,79s	2,79s
	17	1	3,51s	3,51s
	18	1	2,82s	2,82s
	19	1	2,77s	2,77s
	20	1	2,66s	2,66s
	21	1	3,02s	3,02s
	22	1	2,65s	2,65s
	23	1	2,80s	2,80s
Sep 29	00	1	3,84s	3,84s
	01	1	3,41s	3,41s
	02	1	2,72s	2,72s
	03	1	2,65s	2,65s
	04	1	2,77s	2,77s
	05	1	2,76s	2,76s
	06	1	3,35s	3,35s
	07	1	3,40s	3,40s
	08	1	2,73s	2,73s
	09	1	2,86s	2,86s
	10	1	2,89s	2,89s
	11	1	3,38s	3,38s
	12	1	2,95s	2,95s
	13	1	3,35s	3,35s
	14	1	2,78s	2,78s
	15	1	2,79s	2,79s
	16	1	2,76s	2,76s
	17	1	6,51s	6,51s
	18	1	2,91s	2,91s
	19	1	2,76s	2,76s
	20	1	10,79s	10,79s
	21	1	3,27s	3,27s
	22	1	2,93s	2,93s
	23	1	3,13s	3,13s
Sep 30	00	1	3,04s	3,04s
	01	1	2,79s	2,79s
	02	1	2,70s	2,70s
	03	1	2,76s	2,76s
	04	1	2,75s	2,75s
	05	1	3,37s	3,37s
	06	1	2,84s	2,84s

8m7,47s

3,48s

120

Day	Time	Count	Duration	Av. Duration
Sep 24	15	1	0,64s	0,64s
	16	1	1,48s	1,48s
	17	1	1,51s	1,51s
	18	1	1,71s	1,71s
	19	1	1,47s	1,47s
	20	1	1,52s	1,52s
	21	1	1,87s	1,87s
	22	1	1,83s	1,83s
	23	1	1,62s	1,62s
Sep 25	00	1	1,60s	1,60s
	01	1	1,60s	1,60s
	02	1	1,54s	1,54s
	03	1	1,76s	1,76s
	04	1	1,53s	1,53s
	05	1	1,59s	1,59s
	06	1	1,51s	1,51s
	07	1	1,58s	1,58s
	08	1	1,57s	1,57s
	09	1	1,67s	1,67s
	10	1	1,65s	1,65s
	11	1	1,60s	1,60s
	12	1	1,63s	1,63s
	13	1	1,72s	1,72s
	14	1	1,69s	1,69s
	15	1	1,86s	1,86s
	16	1	1,72s	1,72s
	17	1	1,57s	1,57s
	18	1	1,65s	1,65s
	19	1	1,62s	1,62s
	20	1	1,82s	1,82s
	21	1	1,85s	1,85s
	22	1	1,53s	1,53s
	23	1	1,65s	1,65s
Sep 26	00	1	1,61s	1,61s
	01	1	1,49s	1,49s
	02	1	1,71s	1,71s
	03	1	1,53s	1,53s
	04	1	1,58s	1,58s
	05	1	1,72s	1,72s
	06	1	1,72s	1,72s
	07	1	1,75s	1,75s
	08	1	1,73s	1,73s
	09	1	1,75s	1,75s
	10	1	1,58s	1,58s
	11	1	1,55s	1,55s
	12	1	1,69s	1,69s
	13	1	1,61s	1,61s
	14	1	1,59s	1,59s
	15	1	1,35s	1,35s
	16	1	1,29s	1,29s
	17	1	1,36s	1,36s
	18	1	1,22s	1,22s
	19	1	1,49s	1,49s
	20	1	1,30s	1,30s
	21	1	1,25s	1,25s
	22	1	1,30s	1,30s
	23	1	1,35s	1,35s
Sep 27	00	1	1,34s	1,34s
	01	1	1,34s	1,34s
	02	1	1,44s	1,44s
	03	1	1,34s	1,34s
	04	1	1,25s	1,25s
	05	1	1,18s	1,18s
	06	1	1,28s	1,28s
	07	1	1,21s	1,21s
	08	1	1,32s	1,32s
	09	1	1,23s	1,23s
	10	1	1,28s	1,28s
	11	1	1,34s	1,34s
	12	1	1,33s	1,33s
	13	1	1,41s	1,41s
	14	1	1,28s	1,28s
	15	1	1,46s	1,46s
	16	1	1,25s	1,25s
	17	1	1,37s	1,37s
	18	1	1,26s	1,26s
	19	1	1,31s	1,31s
	20	1	1,30s	1,30s
	21	1	1,40s	1,40s
	22	1	1,40s	1,40s
	23	1	1,51s	1,51s
Sep 28	00	1	1,28s	1,28s
	01	1	1,30s	1,30s
	02	1	1,44s	1,44s
	03	1	1,20s	1,20s
	04	1	1,20s	1,20s
	05	1	1,11s	1,11s
	06	1	1,45s	1,45s
	07	1	1,19s	1,19s
	08	1	1,42s	1,42s
	09	1	1,32s	1,32s
	10	1	1,19s	1,19s
	11	1	1,16s	1,16s
	12	1	1,72s	1,72s
	13	1	1,76s	1,76s
	14	1	1,74s	1,74s
	15	1	1,64s	1,64s
	16	1	1,61s	1,61s
	17	1	1,84s	1,84s
	18	1	2,05s	2,05s
	19	1	1,99s	1,99s
	20	1	2,22s	2,22s
	21	1	2,08s	2,08s
	22	1	2,21s	2,21s
	23	1	2,10s	2,10s
Sep 29	00	1	2,03s	2,03s
	01	1	2,21s	2,21s
	02	1	2,14s	2,14s
	03	1	2,24s	2,24s
	04	1	2,36s	2,36s
	05	1	1,97s	1,97s
	06	1	1,93s	1,93s
	07	1	2,31s	2,31s
	08	1	2,13s	2,13s
	09	1	2,08s	2,08s
	10	1	1,98s	1,98s
	11	1	2,03s	2,03s
	12	1	2,10s	2,10s
	13	1	2,03s	2,03s
	14	1	1,97s	1,97s

3m11,21s

1,59s

Day	Time	Count	Duration	Av. Duration
Sep 24	15	1	0,86s	0,86s
	21	1	0,85s	0,85s
Sep 25	03	1	0,87s	0,87s
	09	1	1,13s	1,13s
	15	1	0,90s	0,90s
	21	1	0,87s	0,87s
Sep 26	03	1	0,80s	0,80s
	09	1	0,77s	0,77s
	15	1	0,54s	0,54s
	21	1	0,68s	0,68s
Sep 27	03	1	0,65s	0,65s
	09	1	0,59s	0,59s
	15	1	0,64s	0,64s
	21	1	0,79s	0,79s
Sep 28	03	1	0,66s	0,66s
	09	1	0,61s	0,61s
	15	1	0,86s	0,86s
	21	1	1,14s	1,14s
Sep 29	03	1	1,16s	1,16s
	09	1	1,08s	1,08s
	15	1	1,17s	1,17s
	21	1	1,06s	1,06s
Sep 30	03	1	1,32s	1,32s

20,00s

0,87s

Day	Time	Count	Duration	Av. Duration
Sep 24	11	1	2,45s	2,45s
	15	1	1,56s	1,56s
Sep 29	15	1	2,31s	2,31s
	16	1	2,05s	2,05s
	17	1	2,11s	2,11s
	18	1	2,20s	2,20s
	19	1	2,05s	2,05s
	20	1	2,25s	2,25s
	21	1	2,07s	2,07s
	22	1	2,28s	2,28s
	23	1	2,13s	2,13s
Sep 30	00	1	2,07s	2,07s
	01	1	2,05s	2,05s
	02	1	2,26s	2,26s
	03	1	2,33s	2,33s
	04	1	2,22s	2,22s
	05	1	1,97s	1,97s
	06	1	2,12s	2,12s

38,47s

2,14s

5,78s

0,64s

2m25,21s

24,20s

reindex TABLE rhq_measurement_data_num_1h;

51,25s

8,54s

reindex TABLE rhq_measurement_data_num_6h;

3,85s

0,64s

21,44s

3,57s

reindex TABLE rhq_measurement_data_num_1d;

10,03s

1,67s

SELECT pg_stop_backup();

44,20s

8,84s

ANALYZE;

9m27,54s

1m53,51s

reindex TABLE rhq_availability;

2,81s

0,70s

SELECT pg_start_backup('', true);

2,03s

1,02s

50,88s

25,44s

VACUUM ANALYZE;

7,18s

UPDATE RHQ_AGENT SET STATUS=0 WHERE ID IN ('10161');

0,57s

COMMIT;

0,56s

0,00s

SELECT (SELECT count(resourceav3_.ID) FROM RHQ_RESOURCE_GROUP_RES_EXP_MAP explicitre1_, RHQ_RESOURCE resource2_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav3_ ON resource2_.ID=resourceav3_.RESOURCE_ID WHERE resourcegr0_.ID=explicitre1_.RESOURCE_GROUP_ID AND explicitre1_.RESOURCE_ID=resource2_.ID) AS col_0_0_, (SELECT count(resourceav6_.ID) FROM RHQ_RESOURCE_GROUP_RES_EXP_MAP explicitre4_, RHQ_RESOURCE resource5_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav6_ ON resource5_.ID=resourceav6_.RESOURCE_ID WHERE resourcegr0_.ID=explicitre4_.RESOURCE_GROUP_ID AND explicitre4_.RESOURCE_ID=resource5_.ID AND resourceav6_.AVAILABILITY_TYPE=0) AS col_1_0_, (SELECT count(resourceav9_.ID) FROM RHQ_RESOURCE_GROUP_RES_EXP_MAP explicitre7_, RHQ_RESOURCE resource8_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav9_ ON resource8_.ID=resourceav9_.RESOURCE_ID WHERE resourcegr0_.ID=explicitre7_.RESOURCE_GROUP_ID AND explicitre7_.RESOURCE_ID=resource8_.ID AND resourceav9_.AVAILABILITY_TYPE=2) AS col_2_0_, (SELECT count(resourceav12_.ID) FROM RHQ_RESOURCE_GROUP_RES_EXP_MAP explicitre10_, RHQ_RESOURCE resource11_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav12_ ON resource11_.ID=resourceav12_.RESOURCE_ID WHERE resourcegr0_.ID=explicitre10_.RESOURCE_GROUP_ID AND explicitre10_.RESOURCE_ID=resource11_.ID AND resourceav12_.AVAILABILITY_TYPE=3) AS col_3_0_, (SELECT count(resourceav15_.ID) FROM RHQ_RESOURCE_GROUP_RES_IMP_MAP implicitre13_, RHQ_RESOURCE resource14_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav15_ ON resource14_.ID=resourceav15_.RESOURCE_ID WHERE resourcegr0_.ID=implicitre13_.RESOURCE_GROUP_ID AND implicitre13_.RESOURCE_ID=resource14_.ID) AS col_4_0_, (SELECT count(resourceav18_.ID) FROM RHQ_RESOURCE_GROUP_RES_IMP_MAP implicitre16_, RHQ_RESOURCE resource17_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav18_ ON resource17_.ID=resourceav18_.RESOURCE_ID WHERE resourcegr0_.ID=implicitre16_.RESOURCE_GROUP_ID AND implicitre16_.RESOURCE_ID=resource17_.ID AND resourceav18_.AVAILABILITY_TYPE=0) AS col_5_0_, (SELECT count(resourceav21_.ID) FROM RHQ_RESOURCE_GROUP_RES_IMP_MAP implicitre19_, RHQ_RESOURCE resource20_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav21_ ON resource20_.ID=resourceav21_.RESOURCE_ID WHERE resourcegr0_.ID=implicitre19_.RESOURCE_GROUP_ID AND implicitre19_.RESOURCE_ID=resource20_.ID AND resourceav21_.AVAILABILITY_TYPE=2) AS col_6_0_, (SELECT count(resourceav24_.ID) FROM RHQ_RESOURCE_GROUP_RES_IMP_MAP implicitre22_, RHQ_RESOURCE resource23_ INNER JOIN RHQ_RESOURCE_AVAIL resourceav24_ ON resource23_.ID=resourceav24_.RESOURCE_ID WHERE resourcegr0_.ID=implicitre22_.RESOURCE_GROUP_ID AND implicitre22_.RESOURCE_ID=resource23_.ID AND resourceav24_.AVAILABILITY_TYPE=3) AS col_7_0_, resourcegr0_.ID AS col_8_0_ FROM RHQ_RESOURCE_GROUP resourcegr0_ WHERE resourcegr0_.CATEGORY='COMPATIBLE' AND resourcegr0_.visible='t' LIMIT '50';

0,77s

Slowest queries (N) ^

Rank

Av. duration (s)

Times executed

Total duration

Query

1m53,51s

9m27,54s

reindex TABLE rhq_availability;

25,44s

50,88s

VACUUM ANALYZE;

24,20s

2m25,21s

reindex TABLE rhq_measurement_data_num_1h;

8,84s

44,20s

ANALYZE;

8,54s

51,25s

reindex TABLE rhq_measurement_data_num_6h;

7,18s

UPDATE RHQ_AGENT SET STATUS=0 WHERE ID IN ('10161');

3,72s

140

Day	Time	Count	Duration	Av. Duration
Sep 24	11	1	3,29s	3,29s
	12	1	3,06s	3,06s
	13	1	3,09s	3,09s
	14	1	3,09s	3,09s
	15	1	3,21s	3,21s
	16	1	3,14s	3,14s
	17	1	3,22s	3,22s
	18	1	3,83s	3,83s
	19	1	3,81s	3,81s
	20	1	3,23s	3,23s
	21	1	3,79s	3,79s
	22	1	3,16s	3,16s
	23	1	2,89s	2,89s
Sep 25	00	1	3,77s	3,77s
	01	1	3,88s	3,88s
	02	1	3,24s	3,24s
	03	1	3,81s	3,81s
	04	1	3,26s	3,26s
	05	1	3,24s	3,24s
	06	1	2,92s	2,92s
	07	1	3,25s	3,25s
	08	1	3,26s	3,26s
	09	1	3,84s	3,84s
	10	1	3,22s	3,22s
	11	1	3,25s	3,25s
	12	1	3,44s	3,44s
	13	1	3,34s	3,34s
	14	1	3,91s	3,91s
	15	1	3,41s	3,41s
	16	1	3,28s	3,28s
	17	1	3,06s	3,06s
	18	1	3,97s	3,97s
	19	1	3,35s	3,35s
	20	1	3,20s	3,20s
	21	1	3,97s	3,97s
	22	1	3,39s	3,39s
	23	1	4,04s	4,04s
Sep 26	00	1	3,53s	3,53s
	01	1	3,40s	3,40s
	02	1	3,12s	3,12s
	03	1	3,48s	3,48s
	04	1	3,53s	3,53s
	05	1	3,92s	3,92s
	06	1	3,48s	3,48s
	07	1	3,48s	3,48s
	08	1	3,23s	3,23s
	09	1	4,15s	4,15s
	10	1	4,10s	4,10s
	11	1	4,16s	4,16s
	12	1	3,70s	3,70s
	13	1	3,41s	3,41s
	14	1	4,18s	4,18s
	15	1	3,27s	3,27s
	16	1	3,64s	3,64s
	17	1	3,63s	3,63s
	18	1	3,63s	3,63s
	19	1	4,28s	4,28s
	20	1	4,24s	4,24s
	21	1	3,33s	3,33s
	22	1	3,31s	3,31s
	23	1	4,25s	4,25s
Sep 27	00	1	3,68s	3,68s
	01	1	3,61s	3,61s
	02	1	3,58s	3,58s
	03	1	3,61s	3,61s
	04	1	4,11s	4,11s
	05	1	4,19s	4,19s
	06	1	3,60s	3,60s
	07	1	3,62s	3,62s
	08	1	4,21s	4,21s
	09	1	3,61s	3,61s
	10	1	3,97s	3,97s
	11	1	3,58s	3,58s
	12	1	4,30s	4,30s
	13	1	3,32s	3,32s
	14	1	3,61s	3,61s
	15	1	3,46s	3,46s
	16	1	3,54s	3,54s
	17	1	3,61s	3,61s
	18	1	3,63s	3,63s
	19	1	3,57s	3,57s
	20	1	3,57s	3,57s
	21	1	3,54s	3,54s
	22	1	3,72s	3,72s
	23	1	3,60s	3,60s
Sep 28	00	1	3,70s	3,70s
	01	1	3,54s	3,54s
	02	1	4,10s	4,10s
	03	1	4,13s	4,13s
	04	1	3,61s	3,61s
	05	1	4,24s	4,24s
	06	1	4,20s	4,20s
	07	1	3,32s	3,32s
	08	1	3,58s	3,58s
	09	1	4,24s	4,24s
	10	1	3,93s	3,93s
	11	1	4,15s	4,15s
	12	1	3,53s	3,53s
	13	1	3,64s	3,64s
	14	1	3,66s	3,66s
	15	1	3,54s	3,54s
	16	1	3,57s	3,57s
	17	1	3,59s	3,59s
	18	1	3,63s	3,63s
	19	1	4,16s	4,16s
	20	1	3,74s	3,74s
	21	1	3,69s	3,69s
	22	1	4,62s	4,62s
	23	1	3,80s	3,80s
Sep 29	00	1	3,86s	3,86s
	01	1	4,37s	4,37s
	02	1	3,62s	3,62s
	03	1	4,29s	4,29s
	04	1	3,67s	3,67s
	05	1	3,69s	3,69s
	06	1	4,36s	4,36s
	07	1	3,73s	3,73s
	08	1	3,83s	3,83s
	09	1	3,78s	3,78s
	10	1	3,70s	3,70s
	11	1	3,70s	3,70s
	12	1	3,92s	3,92s
	13	1	4,48s	4,48s
	14	1	4,52s	4,52s
	15	1	3,76s	3,76s
	16	1	3,82s	3,82s
	17	1	4,86s	4,86s
	18	1	3,97s	3,97s
	19	1	4,00s	4,00s
	20	1	3,94s	3,94s
	21	1	4,07s	4,07s
	22	1	3,99s	3,99s
	23	1	4,69s	4,69s
Sep 30	00	1	4,02s	4,02s
	01	1	4,93s	4,93s
	02	1	4,10s	4,10s
	03	1	4,05s	4,05s
	04	1	4,14s	4,14s
	05	1	4,17s	4,17s
	06	1	4,19s	4,19s

8m41,45s

DELETE FROM rhq_availability WHERE end_time < '';

3,57s

21,44s

reindex TABLE rhq_measurement_data_num_1d;

3,48s

140

Day	Time	Count	Duration	Av. Duration
Sep 24	11	1	7,29s	7,29s
	12	1	5,90s	5,90s
	13	1	5,71s	5,71s
	14	1	5,75s	5,75s
	15	1	5,83s	5,83s
	16	1	4,18s	4,18s
	17	1	5,88s	5,88s
	18	1	5,93s	5,93s
	19	1	5,97s	5,97s
	20	1	5,96s	5,96s
	21	1	5,99s	5,99s
	22	1	6,21s	6,21s
	23	1	6,04s	6,04s
Sep 25	00	1	6,09s	6,09s
	01	1	6,02s	6,02s
	02	1	5,99s	5,99s
	03	1	5,99s	5,99s
	04	1	6,05s	6,05s
	05	1	6,11s	6,11s
	06	1	6,12s	6,12s
	07	1	4,33s	4,33s
	08	1	6,11s	6,11s
	09	1	6,20s	6,20s
	10	1	6,64s	6,64s
	11	1	2,62s	2,62s
	12	1	2,66s	2,66s
	13	1	2,68s	2,68s
	14	1	2,61s	2,61s
	15	1	2,61s	2,61s
	16	1	2,88s	2,88s
	17	1	2,72s	2,72s
	18	1	2,49s	2,49s
	19	1	2,66s	2,66s
	20	1	2,50s	2,50s
	21	1	2,63s	2,63s
	22	1	2,66s	2,66s
	23	1	3,01s	3,01s
Sep 26	00	1	2,93s	2,93s
	01	1	2,78s	2,78s
	02	1	2,66s	2,66s
	03	1	2,57s	2,57s
	04	1	2,63s	2,63s
	05	1	2,68s	2,68s
	06	1	2,48s	2,48s
	07	1	2,56s	2,56s
	08	1	2,60s	2,60s
	09	1	2,66s	2,66s
	10	1	2,66s	2,66s
	11	1	2,72s	2,72s
	12	1	2,78s	2,78s
	13	1	3,40s	3,40s
	14	1	2,76s	2,76s
	15	1	2,71s	2,71s
	16	1	2,66s	2,66s
	17	1	4,92s	4,92s
	18	1	2,52s	2,52s
	19	1	2,58s	2,58s
	20	1	7,44s	7,44s
	21	1	3,11s	3,11s
	22	1	2,62s	2,62s
	23	1	2,74s	2,74s
Sep 27	00	1	3,36s	3,36s
	01	1	2,57s	2,57s
	02	1	2,58s	2,58s
	03	1	2,76s	2,76s
	04	1	2,58s	2,58s
	05	1	2,50s	2,50s
	06	1	2,76s	2,76s
	07	1	2,55s	2,55s
	08	1	2,57s	2,57s
	09	1	3,26s	3,26s
	10	1	2,64s	2,64s
	11	1	2,54s	2,54s
	12	1	2,68s	2,68s
	13	1	2,60s	2,60s
	14	1	2,67s	2,67s
	15	1	2,69s	2,69s
	16	1	2,69s	2,69s
	17	1	2,57s	2,57s
	18	1	2,60s	2,60s
	19	1	2,72s	2,72s
	20	1	3,11s	3,11s
	21	1	2,66s	2,66s
	22	1	2,58s	2,58s
	23	1	2,60s	2,60s
Sep 28	00	1	2,78s	2,78s
	01	1	2,54s	2,54s
	02	1	2,57s	2,57s
	03	1	2,66s	2,66s
	04	1	2,61s	2,61s
	05	1	2,55s	2,55s
	06	1	2,54s	2,54s
	07	1	2,61s	2,61s
	08	1	2,77s	2,77s
	09	1	2,68s	2,68s
	10	1	6,11s	6,11s
	11	1	2,69s	2,69s
	12	1	2,69s	2,69s
	13	1	3,26s	3,26s
	14	1	2,70s	2,70s
	15	1	2,70s	2,70s
	16	1	2,79s	2,79s
	17	1	3,51s	3,51s
	18	1	2,82s	2,82s
	19	1	2,77s	2,77s
	20	1	2,66s	2,66s
	21	1	3,02s	3,02s
	22	1	2,65s	2,65s
	23	1	2,80s	2,80s
Sep 29	00	1	3,84s	3,84s
	01	1	3,41s	3,41s
	02	1	2,72s	2,72s
	03	1	2,65s	2,65s
	04	1	2,77s	2,77s
	05	1	2,76s	2,76s
	06	1	3,35s	3,35s
	07	1	3,40s	3,40s
	08	1	2,73s	2,73s
	09	1	2,86s	2,86s
	10	1	2,89s	2,89s
	11	1	3,38s	3,38s
	12	1	2,95s	2,95s
	13	1	3,35s	3,35s
	14	1	2,78s	2,78s
	15	1	2,79s	2,79s
	16	1	2,76s	2,76s
	17	1	6,51s	6,51s
	18	1	2,91s	2,91s
	19	1	2,76s	2,76s
	20	1	10,79s	10,79s
	21	1	3,27s	3,27s
	22	1	2,93s	2,93s
	23	1	3,13s	3,13s
Sep 30	00	1	3,04s	3,04s
	01	1	2,79s	2,79s
	02	1	2,70s	2,70s
	03	1	2,76s	2,76s
	04	1	2,75s	2,75s
	05	1	3,37s	3,37s
	06	1	2,84s	2,84s

8m7,47s

2,14s

Day	Time	Count	Duration	Av. Duration
Sep 24	11	1	2,45s	2,45s
	15	1	1,56s	1,56s
Sep 29	15	1	2,31s	2,31s
	16	1	2,05s	2,05s
	17	1	2,11s	2,11s
	18	1	2,20s	2,20s
	19	1	2,05s	2,05s
	20	1	2,25s	2,25s
	21	1	2,07s	2,07s
	22	1	2,28s	2,28s
	23	1	2,13s	2,13s
Sep 30	00	1	2,07s	2,07s
	01	1	2,05s	2,05s
	02	1	2,26s	2,26s
	03	1	2,33s	2,33s
	04	1	2,22s	2,22s
	05	1	1,97s	1,97s
	06	1	2,12s	2,12s

38,47s

1,67s

10,03s

SELECT pg_stop_backup();

1,59s

120

Day	Time	Count	Duration	Av. Duration
Sep 24	15	1	0,64s	0,64s
	16	1	1,48s	1,48s
	17	1	1,51s	1,51s
	18	1	1,71s	1,71s
	19	1	1,47s	1,47s
	20	1	1,52s	1,52s
	21	1	1,87s	1,87s
	22	1	1,83s	1,83s
	23	1	1,62s	1,62s
Sep 25	00	1	1,60s	1,60s
	01	1	1,60s	1,60s
	02	1	1,54s	1,54s
	03	1	1,76s	1,76s
	04	1	1,53s	1,53s
	05	1	1,59s	1,59s
	06	1	1,51s	1,51s
	07	1	1,58s	1,58s
	08	1	1,57s	1,57s
	09	1	1,67s	1,67s
	10	1	1,65s	1,65s
	11	1	1,60s	1,60s
	12	1	1,63s	1,63s
	13	1	1,72s	1,72s
	14	1	1,69s	1,69s
	15	1	1,86s	1,86s
	16	1	1,72s	1,72s
	17	1	1,57s	1,57s
	18	1	1,65s	1,65s
	19	1	1,62s	1,62s
	20	1	1,82s	1,82s
	21	1	1,85s	1,85s
	22	1	1,53s	1,53s
	23	1	1,65s	1,65s
Sep 26	00	1	1,61s	1,61s
	01	1	1,49s	1,49s
	02	1	1,71s	1,71s
	03	1	1,53s	1,53s
	04	1	1,58s	1,58s
	05	1	1,72s	1,72s
	06	1	1,72s	1,72s
	07	1	1,75s	1,75s
	08	1	1,73s	1,73s
	09	1	1,75s	1,75s
	10	1	1,58s	1,58s
	11	1	1,55s	1,55s
	12	1	1,69s	1,69s
	13	1	1,61s	1,61s
	14	1	1,59s	1,59s
	15	1	1,35s	1,35s
	16	1	1,29s	1,29s
	17	1	1,36s	1,36s
	18	1	1,22s	1,22s
	19	1	1,49s	1,49s
	20	1	1,30s	1,30s
	21	1	1,25s	1,25s
	22	1	1,30s	1,30s
	23	1	1,35s	1,35s
Sep 27	00	1	1,34s	1,34s
	01	1	1,34s	1,34s
	02	1	1,44s	1,44s
	03	1	1,34s	1,34s
	04	1	1,25s	1,25s
	05	1	1,18s	1,18s
	06	1	1,28s	1,28s
	07	1	1,21s	1,21s
	08	1	1,32s	1,32s
	09	1	1,23s	1,23s
	10	1	1,28s	1,28s
	11	1	1,34s	1,34s
	12	1	1,33s	1,33s
	13	1	1,41s	1,41s
	14	1	1,28s	1,28s
	15	1	1,46s	1,46s
	16	1	1,25s	1,25s
	17	1	1,37s	1,37s
	18	1	1,26s	1,26s
	19	1	1,31s	1,31s
	20	1	1,30s	1,30s
	21	1	1,40s	1,40s
	22	1	1,40s	1,40s
	23	1	1,51s	1,51s
Sep 28	00	1	1,28s	1,28s
	01	1	1,30s	1,30s
	02	1	1,44s	1,44s
	03	1	1,20s	1,20s
	04	1	1,20s	1,20s
	05	1	1,11s	1,11s
	06	1	1,45s	1,45s
	07	1	1,19s	1,19s
	08	1	1,42s	1,42s
	09	1	1,32s	1,32s
	10	1	1,19s	1,19s
	11	1	1,16s	1,16s
	12	1	1,72s	1,72s
	13	1	1,76s	1,76s
	14	1	1,74s	1,74s
	15	1	1,64s	1,64s
	16	1	1,61s	1,61s
	17	1	1,84s	1,84s
	18	1	2,05s	2,05s
	19	1	1,99s	1,99s
	20	1	2,22s	2,22s
	21	1	2,08s	2,08s
	22	1	2,21s	2,21s
	23	1	2,10s	2,10s
Sep 29	00	1	2,03s	2,03s
	01	1	2,21s	2,21s
	02	1	2,14s	2,14s
	03	1	2,24s	2,24s
	04	1	2,36s	2,36s
	05	1	1,97s	1,97s
	06	1	1,93s	1,93s
	07	1	2,31s	2,31s
	08	1	2,13s	2,13s
	09	1	2,08s	2,08s
	10	1	1,98s	1,98s
	11	1	2,03s	2,03s
	12	1	2,10s	2,10s
	13	1	2,03s	2,03s
	14	1	1,97s	1,97s

3m11,21s

1,15s

UPDATE RHQ_AGENT SET LAST_AVAILABILITY_PING='1348928946344', BACKFILLED=false WHERE NAME='swishostbossa02';

1,02s

2,03s

0,87s

Day	Time	Count	Duration	Av. Duration
Sep 24	15	1	0,86s	0,86s
	21	1	0,85s	0,85s
Sep 25	03	1	0,87s	0,87s
	09	1	1,13s	1,13s
	15	1	0,90s	0,90s
	21	1	0,87s	0,87s
Sep 26	03	1	0,80s	0,80s
	09	1	0,77s	0,77s
	15	1	0,54s	0,54s
	21	1	0,68s	0,68s
Sep 27	03	1	0,65s	0,65s
	09	1	0,59s	0,59s
	15	1	0,64s	0,64s
	21	1	0,79s	0,79s
Sep 28	03	1	0,66s	0,66s
	09	1	0,61s	0,61s
	15	1	0,86s	0,86s
	21	1	1,14s	1,14s
Sep 29	03	1	1,16s	1,16s
	09	1	1,08s	1,08s
	15	1	1,17s	1,17s
	21	1	1,06s	1,06s
Sep 30	03	1	1,32s	1,32s

20,00s

0,77s

0,70s

2,81s

SELECT pg_start_backup('', true);

0,64s

5,78s

0,64s

3,85s

0,57s

COMMIT;

Most frequent errors (N) ^

Rank

Times reported

Error

2 546

WARNING: skipping "..." --- only superuser or database owner can analyze it

536

WARNING: skipping "..." --- only table or database owner can analyze it

402

WARNING: skipping "..." --- only superuser can analyze it

243

WARNING: nonstandard use of \\ in a string literal

114

WARNING: skipping "..." --- only superuser or database owner can vacuum it

FATAL: archive command failed with exit code 255

ERROR: update or delete on table "..." violates foreign key constraint "..." on table "..."

FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL off

WARNING: skipping "..." --- only table or database owner can vacuum it

WARNING: skipping "..." --- only superuser can vacuum it

FATAL: terminating connection due to administrator command

ERROR: a backup is not in progress

ERROR: syntax error at or near "..."

FATAL: the database system is starting up

ERROR: relation "..." does not exist

ERROR: column "..." does not exist

HINT: See server log for query details.

Detail: REINDEX TABLE RHQ_AVAILABILITY

ERROR: deadlock detected

Detail: Process 5959 waits for AccessExclusiveLock on relation 17662 of database 16385; blocked by process 3236.

HINT: Consider increasing the configuration parameter "...".

FATAL: terminating walreceiver process due to administrator command

^ Back to top
Overall statistics
Hourly statistics
Queries by type
Sessions per database
Sessions per user
Sessions per host
Slowest queries
Queries that took up the most time (N)
Most frequent queries (N)
Slowest queries (N)
Most frequent errors (N)

Table of contents