PgBadger

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

Generated on Fri Jun 8 17:11:51 2012
Log file: /var/log/pglog/postgresql-2012-03-20_000000.log,/var/log/pglog/postgresql-2012-03-20_082927.log
Parsed 7,490,632 log entries in 19m34.00s
Log start from 2012-03-20 08:26:39 to 2012-03-23 17:44:05

Overall statistics ^

Number of unique normalized queries: 4,008
Number of queries: 5,459,866
Total query duration: 1d7h16m56.71s
First query: 2012-03-20 08:26:39
Last query: 2012-03-23 17:44:05
Query peak: 2,903 queries/s at 2012-03-23 06:00:04
Number of errors: 2,021
Number of unique normalized errors: 16

Number temporary file: 1215
Max size of temporary file: 52,903,936
Average size of temporary file: 43,542.33
Total number of sessions: 29346
Total duration of sessions: 10d20h23m6.20s
Average duration of sessions: 31.94s
Total number of connections: 29347

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)
Mar 20	08	302,676	0.00s	168,255	0.01s	744	115	41	0.00s
	09	641,473	0.01s	350,917	0.01s	1,124	409	127	0.00s
	10	302,172	0.02s	166,089	0.03s	2,030	70	108	0.00s
	11	419,902	0.02s	238,502	0.03s	1,305	173	128	0.00s
	12	147,899	0.01s	79,011	0.01s	3,499	34	224	0.00s
	13	96,243	0.06s	54,533	0.10s	173	401	116	0.00s
	14	84,621	0.06s	51,606	0.10s	185	175	85	0.00s
	15	127,451	0.04s	71,644	0.08s	2,956	107	21	0.00s
	16	170,417	0.02s	95,807	0.04s	1,098	120	27	0.00s
	17	133,486	0.04s	71,866	0.07s	2,420	63	25	0.00s
	18	89,618	0.05s	48,547	0.09s	70	16	0	0.00s
	19	43,210	0.09s	23,321	0.17s	57	140	33	0.00s
	20	228	16.86s	133	28.90s	0	0	0	0.00s
	21	23,881	0.08s	13,411	0.14s	4	0	0	0.00s
	22	18,120	0.10s	9,855	0.19s	4	0	0	0.00s
	23	5,105	0.71s	2,847	1.28s	0	0	0	0.00s
Mar 21	00	532	6.76s	418	8.60s	77	6	22	0.00s
	01	5,317	0.67s	2,855	1.25s	3	0	0	0.01s
	02	15,594	0.12s	14,705	0.13s	79	0	0	0.00s
	03	16,963	0.11s	10,540	0.17s	615	0	0	0.00s
	04	16	3m42.45s	8	7m24.90s	0	0	0	0.00s
	05	48	1m13.97s	22	2m41.38s	0	0	0	0.00s
	06	11,186	0.36s	8,790	0.40s	0	0	0	0.00s
	07	11,764	0.15s	6,525	0.26s	16	29	41	0.00s
	08	88,658	0.02s	48,439	0.04s	54	13	0	0.00s
	09	61,111	0.04s	36,173	0.08s	45	30	0	0.00s
	10	58,873	0.04s	33,233	0.07s	146	64	12	0.00s
	11	58,666	0.03s	34,232	0.05s	44	66	0	0.00s
	12	14,504	0.05s	8,237	0.08s	1,114	38	85	0.00s
	13	17,134	0.04s	10,502	0.07s	614	79	16	0.00s
	14	61,553	0.02s	35,338	0.03s	604	117	41	0.00s
	15	676,901	0.00s	660,539	0.00s	422	91	25	0.00s
	16	501,548	0.00s	472,292	0.00s	819	210	45	0.00s
	17	37,352	0.00s	21,587	0.00s	16	5	0	0.00s
	18	1,141	0.02s	618	0.04s	1	3	0	0.00s
	19	6,724	0.00s	3,283	0.01s	0	0	0	0.00s
	20	2,610	0.01s	1,428	0.01s	0	0	0	0.00s
	21	3,106	0.01s	1,576	0.01s	0	0	0	0.00s
	22	3	5.80s	1	17.39s	0	0	0	0.00s
	23	10,475	0.00s	5,765	0.00s	0	0	0	0.00s

Day	Time	Temporary files		Checkpoints
Day	Time	Count	Av. size	Wrote buffers	Added	Removed	Recycled	Write time (sec)	Sync time (sec)	Total time (sec)
Mar 20	00	0	0	0	0	0	0	0	0	0
	01	0	0	0	0	0	0	0	0	0
	02	0	0	0	0	0	0	0	0	0
	03	0	0	0	0	0	0	0	0	0
	04	0	0	0	0	0	0	0	0	0
	05	0	0	0	0	0	0	0	0	0
	06	0	0	0	0	0	0	0	0	0
	07	0	0	0	0	0	0	0	0	0
	08	0	0	919	0	0	0	185.327	0.172	185.561
	09	66	788,776.33	1,691	0	0	1	341.188	0.14	341.421
	10	16	4,893,537.00	1,106	0	0	1	222.94	0.169	223.141
	11	26	5,987,863.85	1,662	0	0	0	335.156	0.078	335.266
	12	10	4,710,994.20	1,781	0	0	1	360.251	0.218	360.501
	13	0	0	421	0	0	0	83.686	0.062	83.795
	14	1	9,551,872.00	473	0	0	1	93.639	0.016	93.703
	15	143	3,795,344.76	1,279	0	0	0	257.78	0.032	257.843
	16	54	4,688,218.44	1,874	0	0	2	378.924	0.203	379.19
	17	112	3,541,969.86	2,253	0	0	1	455.657	0.328	456.047
	18	0	0	121	0	0	0	23.36	0.048	23.408
	19	0	0	278	0	0	0	55.283	0.016	55.315
	20	0	0	30	0	0	0	5.28	0.094	5.374
	21	0	0	12	0	0	0	2.234	0	2.234
	22	0	0	13	0	0	0	2.438	0.015	2.453
	23	0	0	0	0	0	0	0	0	0
Mar 21	00	0	0	1,383	0	0	1	279.703	0.048	279.783
	01	0	0	2,864	0	0	2	579.312	0.016	579.36
	02	17	771,288.47	1,919	0	0	0	387.561	0.031	387.592
	03	80	762,117.30	67	0	0	1	11.782	0	11.797
	04	0	0	0	0	0	0	0	0	0
	05	0	0	0	0	0	0	0	0	0
	06	0	0	440	0	0	0	89.172	0.031	89.219
	07	0	0	48	0	0	0	9.345	0.031	9.391
	08	6	710,147.33	186	0	0	0	36.391	0.123	36.53
	09	0	0	229	0	0	0	44.482	0.111	44.639
	10	0	0	262	0	0	0	50.78	0.063	50.875
	11	0	0	414	0	0	0	81.875	0.063	81.954
	12	0	0	254	0	0	0	49.984	0.031	50.031
	13	44	4,383,019.82	844	0	0	0	169.937	0.126	170.079
	14	41	5,013,476.20	1,066	0	0	1	214.33	0.095	214.486
	15	23	6,494,911.83	411	0	0	0	81.285	0.155	81.596
	16	98	2,403,598.02	1,397	0	0	1	281.61	0.235	281.877
	17	0	0	71	0	0	0	13.406	0.187	13.593
	18	0	0	12	0	0	0	2.234	0	2.25
	19	0	0	0	0	0	0	0	0	0
	20	0	0	0	0	0	0	0	0	0
	21	0	0	0	0	0	0	0	0	0
	22	0	0	0	0	0	0	0	0	0
	23	0	0	0	0	0	0	0	0	0

Queries by type ^

Type	Count	Percentage
SELECT	3,717,439	68.09%
INSERT	34,259	0.63%
UPDATE	4,753	0.09%
DELETE	2,515	0.05%
OTHERS	1,700,900	31.15%

Sessions per database ^

Database	Count	Total Duration	Av. duration (s)
testdb	29,327	9d16h59m20.34s	28.60s
postgres	19	1d3h23m45.86s	1h26m30.83s

Sessions per user ^

User	Count	Total Duration	Av. duration (s)
postgres	14,642	9d15h23m14.97s	56.89s
brochet	14,644	1d4h58m29.12s	7.12s
vigipan	60	1m22.11s	1.37s

Sessions per host ^

Host	Count	Total Duration	Av. duration (s)
192.168.1.103	28,858	1d22h55m16.42s	5.85s
192.168.1.106	68	2m3.28s	1.81s
127.0.0.1	3	26m27.00s	8m49.00s
192.168.1.104	160	2d10h44m37.16s	22m1.73s
192.168.1.154	257	6d10h14m42.34s	36m0.63s

Connections per database ^

Database	User	Count
testdb		29,329
postgres		14,625
brochet		14,644
vigipan		60
postgres		18
postgres		18

Connections per user ^

User	Count
postgres	14,643
brochet	14,644
vigipan	60

Connections per host ^

Host	Count
192.168.1.103	28,858
192.168.1.106	68
127.0.0.1	3
192.168.1.104	160
192.168.1.154	258

Slowest queries ^

Rank	Duration (s)	Query
1	21m30.94s	SELECT klm_ilots.id_f, klm_users.id_user, klm_users.use_age AS nom, klm_ilots.mil_cp AS cd, klm_users.use_laws AS laws, f_vycar.pan, count(tblfinamations_ilots.idfinamation) AS observations, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS') AS date_crea, klm_users_ilots.id_oad, age1.ll_long AS reseau FROM dbfilter.klm_age JOIN (dbfilter.klm_ilots JOIN (dbfilter.klm_users_ilots JOIN dbfilter.klm_age age1 ON age1.id_cat = klm_users_ilots.id_oad) ON klm_ilots.id_f = klm_users_ilots.id_f JOIN dbfilter.klm_users ON klm_users_ilots.id_user = klm_users.id_user JOIN dbfilter.tblfinamations_ilots ON klm_users.id_user = tblfinamations_ilots.id_user AND klm_ilots.id_f = tblfinamations_ilots.id_f) ON klm_age.id_cat = tblfinamations_ilots.cat_id_eltfiname JOIN dbfilter.f_vycar ON klm_ilots.id_f = f_vycar.id_f WHERE tblfinamations_ilots.key_crea > current_timestamp - interval '1 day' GROUP BY klm_ilots.id_f, klm_users.id_user, klm_users.use_age, klm_ilots.mil_cp, klm_users.use_laws, f_vycar.pan, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), klm_users_ilots.id_oad, age1.ll_long ORDER BY to_timestamp(to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), 'DD/MM/YYYY HH24:MI:SS') DESC ;
2	21m24.45s	SELECT klm_ilots.id_f, klm_users.id_user, klm_users.use_age AS nom, klm_ilots.mil_cp AS cd, klm_users.use_laws AS laws, f_vycar.pan, count(tblfinamations_ilots.idfinamation) AS observations, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS') AS date_crea, klm_users_ilots.id_oad, age1.ll_long AS reseau FROM dbfilter.klm_age JOIN (dbfilter.klm_ilots JOIN (dbfilter.klm_users_ilots JOIN dbfilter.klm_age age1 ON age1.id_cat = klm_users_ilots.id_oad) ON klm_ilots.id_f = klm_users_ilots.id_f JOIN dbfilter.klm_users ON klm_users_ilots.id_user = klm_users.id_user JOIN dbfilter.tblfinamations_ilots ON klm_users.id_user = tblfinamations_ilots.id_user AND klm_ilots.id_f = tblfinamations_ilots.id_f) ON klm_age.id_cat = tblfinamations_ilots.cat_id_eltfiname JOIN dbfilter.f_vycar ON klm_ilots.id_f = f_vycar.id_f WHERE tblfinamations_ilots.key_crea > current_timestamp - interval '1 day' GROUP BY klm_ilots.id_f, klm_users.id_user, klm_users.use_age, klm_ilots.mil_cp, klm_users.use_laws, f_vycar.pan, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), klm_users_ilots.id_oad, age1.ll_long ORDER BY to_timestamp(to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), 'DD/MM/YYYY HH24:MI:SS') DESC ;
3	21m23.77s	SELECT klm_ilots.id_f, klm_users.id_user, klm_users.use_age AS nom, klm_ilots.mil_cp AS cd, klm_users.use_laws AS laws, f_vycar.pan, count(tblfinamations_ilots.idfinamation) AS observations, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS') AS date_crea, klm_users_ilots.id_oad, age1.ll_long AS reseau FROM dbfilter.klm_age JOIN (dbfilter.klm_ilots JOIN (dbfilter.klm_users_ilots JOIN dbfilter.klm_age age1 ON age1.id_cat = klm_users_ilots.id_oad) ON klm_ilots.id_f = klm_users_ilots.id_f JOIN dbfilter.klm_users ON klm_users_ilots.id_user = klm_users.id_user JOIN dbfilter.tblfinamations_ilots ON klm_users.id_user = tblfinamations_ilots.id_user AND klm_ilots.id_f = tblfinamations_ilots.id_f) ON klm_age.id_cat = tblfinamations_ilots.cat_id_eltfiname JOIN dbfilter.f_vycar ON klm_ilots.id_f = f_vycar.id_f WHERE tblfinamations_ilots.key_crea > current_timestamp - interval '1 day' GROUP BY klm_ilots.id_f, klm_users.id_user, klm_users.use_age, klm_ilots.mil_cp, klm_users.use_laws, f_vycar.pan, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), klm_users_ilots.id_oad, age1.ll_long ORDER BY to_timestamp(to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), 'DD/MM/YYYY HH24:MI:SS') DESC ;
4	21m19.91s	SELECT klm_ilots.id_f, klm_users.id_user, klm_users.use_age AS nom, klm_ilots.mil_cp AS cd, klm_users.use_laws AS laws, f_vycar.pan, count(tblfinamations_ilots.idfinamation) AS observations, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS') AS date_crea, klm_users_ilots.id_oad, age1.ll_long AS reseau FROM dbfilter.klm_age JOIN (dbfilter.klm_ilots JOIN (dbfilter.klm_users_ilots JOIN dbfilter.klm_age age1 ON age1.id_cat = klm_users_ilots.id_oad) ON klm_ilots.id_f = klm_users_ilots.id_f JOIN dbfilter.klm_users ON klm_users_ilots.id_user = klm_users.id_user JOIN dbfilter.tblfinamations_ilots ON klm_users.id_user = tblfinamations_ilots.id_user AND klm_ilots.id_f = tblfinamations_ilots.id_f) ON klm_age.id_cat = tblfinamations_ilots.cat_id_eltfiname JOIN dbfilter.f_vycar ON klm_ilots.id_f = f_vycar.id_f WHERE tblfinamations_ilots.key_crea > current_timestamp - interval '1 day' GROUP BY klm_ilots.id_f, klm_users.id_user, klm_users.use_age, klm_ilots.mil_cp, klm_users.use_laws, f_vycar.pan, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), klm_users_ilots.id_oad, age1.ll_long ORDER BY to_timestamp(to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), 'DD/MM/YYYY HH24:MI:SS') DESC ;
5	21m14.05s	SELECT klm_ilots.id_f, klm_users.id_user, klm_users.use_age AS nom, klm_ilots.mil_cp AS cd, klm_users.use_laws AS laws, f_vycar.pan, count(tblfinamations_ilots.idfinamation) AS observations, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS') AS date_crea, klm_users_ilots.id_oad, age1.ll_long AS reseau FROM dbfilter.klm_age JOIN (dbfilter.klm_ilots JOIN (dbfilter.klm_users_ilots JOIN dbfilter.klm_age age1 ON age1.id_cat = klm_users_ilots.id_oad) ON klm_ilots.id_f = klm_users_ilots.id_f JOIN dbfilter.klm_users ON klm_users_ilots.id_user = klm_users.id_user JOIN dbfilter.tblfinamations_ilots ON klm_users.id_user = tblfinamations_ilots.id_user AND klm_ilots.id_f = tblfinamations_ilots.id_f) ON klm_age.id_cat = tblfinamations_ilots.cat_id_eltfiname JOIN dbfilter.f_vycar ON klm_ilots.id_f = f_vycar.id_f WHERE tblfinamations_ilots.key_crea > current_timestamp - interval '1 day' GROUP BY klm_ilots.id_f, klm_users.id_user, klm_users.use_age, klm_ilots.mil_cp, klm_users.use_laws, f_vycar.pan, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), klm_users_ilots.id_oad, age1.ll_long ORDER BY to_timestamp(to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), 'DD/MM/YYYY HH24:MI:SS') DESC ;
6	21m9.88s	SELECT klm_ilots.id_f, klm_users.id_user, klm_users.use_age AS nom, klm_ilots.mil_cp AS cd, klm_users.use_laws AS laws, f_vycar.pan, count(tblfinamations_ilots.idfinamation) AS observations, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS') AS date_crea, klm_users_ilots.id_oad, age1.ll_long AS reseau FROM dbfilter.klm_age JOIN (dbfilter.klm_ilots JOIN (dbfilter.klm_users_ilots JOIN dbfilter.klm_age age1 ON age1.id_cat = klm_users_ilots.id_oad) ON klm_ilots.id_f = klm_users_ilots.id_f JOIN dbfilter.klm_users ON klm_users_ilots.id_user = klm_users.id_user JOIN dbfilter.tblfinamations_ilots ON klm_users.id_user = tblfinamations_ilots.id_user AND klm_ilots.id_f = tblfinamations_ilots.id_f) ON klm_age.id_cat = tblfinamations_ilots.cat_id_eltfiname JOIN dbfilter.f_vycar ON klm_ilots.id_f = f_vycar.id_f WHERE tblfinamations_ilots.key_crea > current_timestamp - interval '1 day' GROUP BY klm_ilots.id_f, klm_users.id_user, klm_users.use_age, klm_ilots.mil_cp, klm_users.use_laws, f_vycar.pan, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), klm_users_ilots.id_oad, age1.ll_long ORDER BY to_timestamp(to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), 'DD/MM/YYYY HH24:MI:SS') DESC ;
7	21m9.67s	SELECT klm_ilots.id_f, klm_users.id_user, klm_users.use_age AS nom, klm_ilots.mil_cp AS cd, klm_users.use_laws AS laws, f_vycar.pan, count(tblfinamations_ilots.idfinamation) AS observations, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS') AS date_crea, klm_users_ilots.id_oad, age1.ll_long AS reseau FROM dbfilter.klm_age JOIN (dbfilter.klm_ilots JOIN (dbfilter.klm_users_ilots JOIN dbfilter.klm_age age1 ON age1.id_cat = klm_users_ilots.id_oad) ON klm_ilots.id_f = klm_users_ilots.id_f JOIN dbfilter.klm_users ON klm_users_ilots.id_user = klm_users.id_user JOIN dbfilter.tblfinamations_ilots ON klm_users.id_user = tblfinamations_ilots.id_user AND klm_ilots.id_f = tblfinamations_ilots.id_f) ON klm_age.id_cat = tblfinamations_ilots.cat_id_eltfiname JOIN dbfilter.f_vycar ON klm_ilots.id_f = f_vycar.id_f WHERE tblfinamations_ilots.key_crea > current_timestamp - interval '1 day' GROUP BY klm_ilots.id_f, klm_users.id_user, klm_users.use_age, klm_ilots.mil_cp, klm_users.use_laws, f_vycar.pan, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), klm_users_ilots.id_oad, age1.ll_long ORDER BY to_timestamp(to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), 'DD/MM/YYYY HH24:MI:SS') DESC ;
8	21m4.31s	SELECT klm_ilots.id_f, klm_users.id_user, klm_users.use_age AS nom, klm_ilots.mil_cp AS cd, klm_users.use_laws AS laws, f_vycar.pan, count(tblfinamations_ilots.idfinamation) AS observations, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS') AS date_crea, klm_users_ilots.id_oad, age1.ll_long AS reseau FROM dbfilter.klm_age JOIN (dbfilter.klm_ilots JOIN (dbfilter.klm_users_ilots JOIN dbfilter.klm_age age1 ON age1.id_cat = klm_users_ilots.id_oad) ON klm_ilots.id_f = klm_users_ilots.id_f JOIN dbfilter.klm_users ON klm_users_ilots.id_user = klm_users.id_user JOIN dbfilter.tblfinamations_ilots ON klm_users.id_user = tblfinamations_ilots.id_user AND klm_ilots.id_f = tblfinamations_ilots.id_f) ON klm_age.id_cat = tblfinamations_ilots.cat_id_eltfiname JOIN dbfilter.f_vycar ON klm_ilots.id_f = f_vycar.id_f WHERE tblfinamations_ilots.key_crea > current_timestamp - interval '1 day' GROUP BY klm_ilots.id_f, klm_users.id_user, klm_users.use_age, klm_ilots.mil_cp, klm_users.use_laws, f_vycar.pan, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), klm_users_ilots.id_oad, age1.ll_long ORDER BY to_timestamp(to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), 'DD/MM/YYYY HH24:MI:SS') DESC ;
9	21m2.08s	SELECT klm_ilots.id_f, klm_users.id_user, klm_users.use_age AS nom, klm_ilots.mil_cp AS cd, klm_users.use_laws AS laws, f_vycar.pan, count(tblfinamations_ilots.idfinamation) AS observations, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS') AS date_crea, klm_users_ilots.id_oad, age1.ll_long AS reseau FROM dbfilter.klm_age JOIN (dbfilter.klm_ilots JOIN (dbfilter.klm_users_ilots JOIN dbfilter.klm_age age1 ON age1.id_cat = klm_users_ilots.id_oad) ON klm_ilots.id_f = klm_users_ilots.id_f JOIN dbfilter.klm_users ON klm_users_ilots.id_user = klm_users.id_user JOIN dbfilter.tblfinamations_ilots ON klm_users.id_user = tblfinamations_ilots.id_user AND klm_ilots.id_f = tblfinamations_ilots.id_f) ON klm_age.id_cat = tblfinamations_ilots.cat_id_eltfiname JOIN dbfilter.f_vycar ON klm_ilots.id_f = f_vycar.id_f WHERE tblfinamations_ilots.key_crea > current_timestamp - interval '1 day' GROUP BY klm_ilots.id_f, klm_users.id_user, klm_users.use_age, klm_ilots.mil_cp, klm_users.use_laws, f_vycar.pan, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), klm_users_ilots.id_oad, age1.ll_long ORDER BY to_timestamp(to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), 'DD/MM/YYYY HH24:MI:SS') DESC ;
10	21m0.44s	SELECT klm_ilots.id_f, klm_users.id_user, klm_users.use_age AS nom, klm_ilots.mil_cp AS cd, klm_users.use_laws AS laws, f_vycar.pan, count(tblfinamations_ilots.idfinamation) AS observations, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS') AS date_crea, klm_users_ilots.id_oad, age1.ll_long AS reseau FROM dbfilter.klm_age JOIN (dbfilter.klm_ilots JOIN (dbfilter.klm_users_ilots JOIN dbfilter.klm_age age1 ON age1.id_cat = klm_users_ilots.id_oad) ON klm_ilots.id_f = klm_users_ilots.id_f JOIN dbfilter.klm_users ON klm_users_ilots.id_user = klm_users.id_user JOIN dbfilter.tblfinamations_ilots ON klm_users.id_user = tblfinamations_ilots.id_user AND klm_ilots.id_f = tblfinamations_ilots.id_f) ON klm_age.id_cat = tblfinamations_ilots.cat_id_eltfiname JOIN dbfilter.f_vycar ON klm_ilots.id_f = f_vycar.id_f WHERE tblfinamations_ilots.key_crea > current_timestamp - interval '1 day' GROUP BY klm_ilots.id_f, klm_users.id_user, klm_users.use_age, klm_ilots.mil_cp, klm_users.use_laws, f_vycar.pan, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), klm_users_ilots.id_oad, age1.ll_long ORDER BY to_timestamp(to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), 'DD/MM/YYYY HH24:MI:SS') DESC ;

Queries that took up the most time (N) ^

Rank

Total duration

Times executed

Av. duration (s)

Query

23h10m4.63s

141

Day	Time	Count	Duration	Av. Duration
Mar 20	08	1	14m28.31s	14m28.31s
	09	3	44m11.73s	14m43.91s
	10	4	1h13m49.67s	18m27.42s
	11	4	1h25m39.06s	21m24.77s
	13	4	1h24m37.91s	21m9.48s
	14	4	1h23m55.97s	20m58.99s
	15	4	1h19m5.48s	19m46.37s
	16	1	19m11.86s	19m11.86s
	17	3	57m1.27s	19m0.42s
	18	4	1h9m45.00s	17m26.25s
	19	4	1h5m49.80s	16m27.45s
	20	4	1h4m2.39s	16m0.60s
	21	2	30m25.98s	15m12.99s
	22	2	30m38.72s	15m19.36s
	23	4	1h32.05s	15m8.01s
Mar 21	00	4	59m39.64s	14m54.91s
	01	4	59m15.06s	14m48.77s
	02	2	29m10.44s	14m35.22s
	03	2	29m8.34s	14m34.17s
	04	4	59m19.20s	14m49.80s
	05	4	59m10.45s	14m47.61s
	06	4	58m14.56s	14m33.64s
	07	2	28m29.23s	14m14.62s
	08	2	28m28.47s	14m14.23s
	09	4	42m46.38s	10m41.59s
	10	4	24m43.00s	6m10.75s
	11	4	16m46.08s	4m11.52s
	12	1	2m32.28s	2m32.28s
	13	1	2m35.28s	2m35.28s
	14	1	2m12.66s	2m12.66s
	15	1	1m43.91s	1m43.91s
	16	1	1m22.73s	1m22.73s
	17	1	35.97s	35.97s
	18	1	25.66s	25.66s
	19	1	21.14s	21.14s
	20	1	18.33s	18.33s
	21	1	17.47s	17.47s
	22	1	17.39s	17.39s
	23	1	16.80s	16.80s
Mar 22	00	1	16.80s	16.80s
	01	1	22.06s	22.06s
	02	1	16.77s	16.77s
	03	1	16.81s	16.81s
	04	1	16.73s	16.73s
	05	1	16.86s	16.86s
	06	1	16.59s	16.59s
	07	1	16.08s	16.08s
	08	1	13.16s	13.16s
	10	2	27.08s	13.54s
	12	1	18.92s	18.92s
	13	1	18.94s	18.94s
	14	2	43.50s	21.75s
	15	1	30.20s	30.20s
	16	1	29.94s	29.94s
	17	1	28.77s	28.77s
	19	2	57.92s	28.96s
	20	1	28.98s	28.98s
	21	1	29.34s	29.34s
	22	1	29.27s	29.27s
Mar 23	00	1	29.66s	29.66s
	01	1	29.44s	29.44s
	02	1	29.27s	29.27s
	03	1	29.20s	29.20s
	04	1	29.08s	29.08s
	05	1	29.48s	29.48s
	06	1	29.30s	29.30s
	07	1	28.92s	28.92s
	08	1	29.08s	29.08s
	09	1	29.41s	29.41s
	10	1	15.47s	15.47s
	11	1	19.39s	19.39s
	12	1	20.95s	20.95s
	13	1	45.44s	45.44s
	14	1	51.30s	51.30s
	15	1	51.59s	51.59s
	16	1	48.67s	48.67s
	17	1	1m18.59s	1m18.59s

9m51.52s

SELECT klm_ilots.id_f, klm_users.id_user, klm_users.use_age AS nom, klm_ilots.mil_cp AS cd, klm_users.use_laws AS laws, f_vycar.pan, count(tblfinamations_ilots.idfinamation) AS observations, to_char(tblfinamations_ilots.key_crea, '') AS date_crea, klm_users_ilots.id_oad, age1.ll_long AS reseau FROM dbfilter.klm_age JOIN (dbfilter.klm_ilots JOIN (dbfilter.klm_users_ilots JOIN dbfilter.klm_age age1 ON age1.id_cat = klm_users_ilots.id_oad) ON klm_ilots.id_f = klm_users_ilots.id_f JOIN dbfilter.klm_users ON klm_users_ilots.id_user = klm_users.id_user JOIN dbfilter.tblfinamations_ilots ON klm_users.id_user = tblfinamations_ilots.id_user AND klm_ilots.id_f = tblfinamations_ilots.id_f) ON klm_age.id_cat = tblfinamations_ilots.cat_id_eltfiname JOIN dbfilter.f_vycar ON klm_ilots.id_f = f_vycar.id_f WHERE tblfinamations_ilots.key_crea > current_timestamp - interval '' GROUP BY klm_ilots.id_f, klm_users.id_user, klm_users.use_age, klm_ilots.mil_cp, klm_users.use_laws, f_vycar.pan, to_char(tblfinamations_ilots.key_crea, ''), klm_users_ilots.id_oad, age1.ll_long ORDER BY to_timestamp(to_char(tblfinamations_ilots.key_crea, ''), '') DESC ;

21m30.94s | SELECT klm_ilots.id_f, klm_users.id_user, klm_users.use_age AS nom, klm_ilots.mil_cp AS cd, klm_users.use_laws AS laws, f_vycar.pan, count(tblfinamations_ilots.idfinamation) AS observations, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS') AS date_crea, klm_users_ilots.id_oad, age1.ll_long AS reseau FROM dbfilter.klm_age JOIN (dbfilter.klm_ilots JOIN (dbfilter.klm_users_ilots JOIN dbfilter.klm_age age1 ON age1.id_cat = klm_users_ilots.id_oad) ON klm_ilots.id_f = klm_users_ilots.id_f JOIN dbfilter.klm_users ON klm_users_ilots.id_user = klm_users.id_user JOIN dbfilter.tblfinamations_ilots ON klm_users.id_user = tblfinamations_ilots.id_user AND klm_ilots.id_f = tblfinamations_ilots.id_f) ON klm_age.id_cat = tblfinamations_ilots.cat_id_eltfiname JOIN dbfilter.f_vycar ON klm_ilots.id_f = f_vycar.id_f WHERE tblfinamations_ilots.key_crea > current_timestamp - interval '1 day' GROUP BY klm_ilots.id_f, klm_users.id_user, klm_users.use_age, klm_ilots.mil_cp, klm_users.use_laws, f_vycar.pan, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), klm_users_ilots.id_oad, age1.ll_long ORDER BY to_timestamp(to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), 'DD/MM/YYYY HH24:MI:SS') DESC ;

21m24.45s | SELECT klm_ilots.id_f, klm_users.id_user, klm_users.use_age AS nom, klm_ilots.mil_cp AS cd, klm_users.use_laws AS laws, f_vycar.pan, count(tblfinamations_ilots.idfinamation) AS observations, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS') AS date_crea, klm_users_ilots.id_oad, age1.ll_long AS reseau FROM dbfilter.klm_age JOIN (dbfilter.klm_ilots JOIN (dbfilter.klm_users_ilots JOIN dbfilter.klm_age age1 ON age1.id_cat = klm_users_ilots.id_oad) ON klm_ilots.id_f = klm_users_ilots.id_f JOIN dbfilter.klm_users ON klm_users_ilots.id_user = klm_users.id_user JOIN dbfilter.tblfinamations_ilots ON klm_users.id_user = tblfinamations_ilots.id_user AND klm_ilots.id_f = tblfinamations_ilots.id_f) ON klm_age.id_cat = tblfinamations_ilots.cat_id_eltfiname JOIN dbfilter.f_vycar ON klm_ilots.id_f = f_vycar.id_f WHERE tblfinamations_ilots.key_crea > current_timestamp - interval '1 day' GROUP BY klm_ilots.id_f, klm_users.id_user, klm_users.use_age, klm_ilots.mil_cp, klm_users.use_laws, f_vycar.pan, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), klm_users_ilots.id_oad, age1.ll_long ORDER BY to_timestamp(to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), 'DD/MM/YYYY HH24:MI:SS') DESC ;

21m23.77s | SELECT klm_ilots.id_f, klm_users.id_user, klm_users.use_age AS nom, klm_ilots.mil_cp AS cd, klm_users.use_laws AS laws, f_vycar.pan, count(tblfinamations_ilots.idfinamation) AS observations, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS') AS date_crea, klm_users_ilots.id_oad, age1.ll_long AS reseau FROM dbfilter.klm_age JOIN (dbfilter.klm_ilots JOIN (dbfilter.klm_users_ilots JOIN dbfilter.klm_age age1 ON age1.id_cat = klm_users_ilots.id_oad) ON klm_ilots.id_f = klm_users_ilots.id_f JOIN dbfilter.klm_users ON klm_users_ilots.id_user = klm_users.id_user JOIN dbfilter.tblfinamations_ilots ON klm_users.id_user = tblfinamations_ilots.id_user AND klm_ilots.id_f = tblfinamations_ilots.id_f) ON klm_age.id_cat = tblfinamations_ilots.cat_id_eltfiname JOIN dbfilter.f_vycar ON klm_ilots.id_f = f_vycar.id_f WHERE tblfinamations_ilots.key_crea > current_timestamp - interval '1 day' GROUP BY klm_ilots.id_f, klm_users.id_user, klm_users.use_age, klm_ilots.mil_cp, klm_users.use_laws, f_vycar.pan, to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), klm_users_ilots.id_oad, age1.ll_long ORDER BY to_timestamp(to_char(tblfinamations_ilots.key_crea, 'DD/MM/YYYY HH24:MI:SS'), 'DD/MM/YYYY HH24:MI:SS') DESC ;

2h43m15.90s

Day	Time	Count	Duration	Av. Duration
Mar 20	10	1	5m24.44s	5m24.44s
	11	2	11m26.64s	5m43.32s
	12	2	11m25.62s	5m42.81s
	15	1	7m4.42s	7m4.42s
	16	4	39m25.61s	9m51.40s
	17	1	20m0.30s	20m0.30s
Mar 21	13	2	7m53.06s	3m56.53s
	14	2	4m52.27s	2m26.13s
	16	3	11m59.64s	3m59.88s
Mar 22	09	2	7m55.97s	3m57.98s
	10	1	3m57.48s	3m57.48s
	15	4	18m52.34s	4m43.09s
Mar 23	09	1	8m58.97s	8m58.97s
	10	1	3m59.14s	3m59.14s

6m2.81s

SELECT "id_slam" ,"getit" ,"id_libel32_serie" ,"?COLUMN?" FROM "watfall"."plilibel32" WHERE (("id_slam" IN (...) ) AND ("getit" IN (...) ) );

50m5.92s

375

Day	Time	Count	Duration	Av. Duration
Mar 20	09	23	3m15.12s	8.48s
	10	31	3m57.44s	7.66s
	11	7	1m42.16s	14.59s
	12	2	15.27s	7.63s
	13	2	16.31s	8.16s
	15	7	1m0.05s	8.58s
	16	2	15.81s	7.91s
Mar 21	09	2	15.17s	7.59s
	10	69	9m9.29s	7.96s
	11	60	7m53.45s	7.89s
	12	70	8m42.01s	7.46s
	13	1	7.56s	7.56s
	14	11	1m27.24s	7.93s
	16	4	32.48s	8.12s
Mar 22	10	2	15.27s	7.63s
	11	2	16.30s	8.15s
	15	2	15.81s	7.91s
Mar 23	09	3	26.67s	8.89s
	10	7	52.70s	7.53s
	15	12	1m31.92s	7.66s
	16	55	7m30.33s	8.19s
	17	1	7.56s	7.56s

8.02s

SELECT "id_air" ,"pets_h" ,"pets_ha" FROM "watfall"."plilibel32" ORDER BY "watfall"."plilibel32"."id_air";

30m31.30s

837,734

0.00s

SELECT to_char(charge, '') AS charge FROM (SELECT max(dbfilter.klm_ilots_gstadi_carto_20.id_libel32) AS libel32 FROM dbfilter.klm_ilots_libel32s_stadi_carto_20 WHERE id_f = 0 AND id_cat = 0 AND idplace_o = 0 AND id_cat_operation = 0 AND dbfilter.klm_ilots_libel32s_stadi_carto_20.date_libel32 > '' GROUP BY id_f, id_cat, idplace_o, id_cat_operation) req JOIN dbfilter.klm_ilots_libel32s_stadi_carto_20 ON dbfilter.klm_ilots_libel32s_stadi_carto_20.id_libel32 = req.libel32;

18m55.11s

25,304

0.04s

SELECT dbfilter.pli_klm_ilots_g(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_deb(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_deb(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_deb(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_deb(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_deb(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_deb(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_deb(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_deb(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_deb(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_deb(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_deb(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, ''); SELECT dbfilter.pli_klm_ilots_libel32s_date(0, 0, 0, 0, '');

0.59s | SELECT dbfilter.pli_klm_ilots_deb(103126, 314, 402, -1, '2011-11-06'); SELECT dbfilter.pli_klm_ilots_deb(103126, 315, 402, -1, '2011-12-03'); SELECT dbfilter.pli_klm_ilots_deb(103126, 316, 402, -1, '2012-03-08'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 317, 402, -1, '2012-03-22'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 318, 402, -1, '2012-03-31'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 319, 402, -1, '2012-04-19'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 320, 402, -1, '2012-04-29'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 321, 402, -1, '2012-05-08'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 322, 402, -1, '2012-05-15'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 323, 402, -1, '2012-06-25'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 324, 402, -1, '2012-07-15'); SELECT dbfilter.pli_klm_ilots_deb(103126, 314, 405, -1, '2011-11-06'); SELECT dbfilter.pli_klm_ilots_deb(103126, 314, 404, -1, '2011-11-06'); SELECT dbfilter.pli_klm_ilots_deb(103126, 314, 403, -1, '2011-11-06'); SELECT dbfilter.pli_klm_ilots_deb(103126, 315, 405, -1, '2011-12-03'); SELECT dbfilter.pli_klm_ilots_deb(103126, 315, 403, -1, '2011-12-03'); SELECT dbfilter.pli_klm_ilots_deb(103126, 315, 404, -1, '2011-12-03'); SELECT dbfilter.pli_klm_ilots_deb(103126, 316, 405, -1, '2012-03-08'); SELECT dbfilter.pli_klm_ilots_deb(103126, 316, 403, -1, '2012-03-08'); SELECT dbfilter.pli_klm_ilots_deb(103126, 316, 404, -1, '2012-03-08'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 317, 403, -1, '2012-03-22'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 317, 405, -1, '2012-03-22'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 317, 404, -1, '2012-03-22'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 318, 403, -1, '2012-03-30'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 318, 404, -1, '2012-03-30'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 318, 405, -1, '2012-03-31'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 319, 405, -1, '2012-04-22'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 319, 404, -1, '2012-04-16'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 319, 403, -1, '2012-04-20'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 320, 403, -1, '2012-04-29'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 320, 404, -1, '2012-04-27'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 320, 405, -1, '2012-05-03'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 321, 403, -1, '2012-05-09'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 321, 405, -1, '2012-05-12'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 321, 404, -1, '2012-05-05'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 322, 405, -1, '2012-05-19'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 322, 404, -1, '2012-05-13'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 322, 403, -1, '2012-05-17'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 323, 405, -1, '2012-06-27'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 323, 403, -1, '2012-06-26'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 323, 404, -1, '2012-06-24'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 324, 404, -1, '2012-07-11'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 324, 405, -1, '2012-07-18'); SELECT dbfilter.pli_klm_ilots_libel32s_date(103126, 324, 403, -1, '2012-07-15');

0.55s | SELECT dbfilter.pli_klm_ilots_deb(93734, 314, 402, 4467, '2011-10-28'); SELECT dbfilter.pli_klm_ilots_deb(93734, 315, 402, 4467, '2011-11-23'); SELECT dbfilter.pli_klm_ilots_deb(93734, 316, 402, 4467, '2012-03-06'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 317, 402, 4467, '2012-03-21'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 318, 402, 4467, '2012-03-29'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 319, 402, 4467, '2012-04-16'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 320, 402, 4467, '2012-04-27'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 321, 402, 4467, '2012-05-06'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 322, 402, 4467, '2012-05-14'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 323, 402, 4467, '2012-06-24'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 324, 402, 4467, '2012-07-13'); SELECT dbfilter.pli_klm_ilots_deb(93734, 314, 405, 4467, '2011-10-28'); SELECT dbfilter.pli_klm_ilots_deb(93734, 314, 404, 4467, '2011-10-28'); SELECT dbfilter.pli_klm_ilots_deb(93734, 314, 403, 4467, '2011-10-28'); SELECT dbfilter.pli_klm_ilots_deb(93734, 315, 405, 4467, '2011-11-23'); SELECT dbfilter.pli_klm_ilots_deb(93734, 315, 403, 4467, '2011-11-23'); SELECT dbfilter.pli_klm_ilots_deb(93734, 315, 404, 4467, '2011-11-23'); SELECT dbfilter.pli_klm_ilots_deb(93734, 316, 405, 4467, '2012-03-06'); SELECT dbfilter.pli_klm_ilots_deb(93734, 316, 403, 4467, '2012-03-06'); SELECT dbfilter.pli_klm_ilots_deb(93734, 316, 404, 4467, '2012-03-06'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 317, 403, 4467, '2012-03-21'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 317, 405, 4467, '2012-03-21'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 317, 404, 4467, '2012-03-21'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 318, 403, 4467, '2012-03-29'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 318, 404, 4467, '2012-03-29'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 318, 405, 4467, '2012-03-30'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 319, 405, 4467, '2012-04-20'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 319, 404, 4467, '2012-04-13'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 319, 403, 4467, '2012-04-16'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 320, 403, 4467, '2012-04-28'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 320, 404, 4467, '2012-04-24'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 320, 405, 4467, '2012-04-30'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 321, 403, 4467, '2012-05-07'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 321, 405, 4467, '2012-05-10'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 321, 404, 4467, '2012-05-04'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 322, 405, 4467, '2012-05-17'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 322, 404, 4467, '2012-05-11'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 322, 403, 4467, '2012-05-15'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 323, 405, 4467, '2012-06-26'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 323, 403, 4467, '2012-06-24'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 323, 404, 4467, '2012-06-21'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 324, 404, 4467, '2012-07-09'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 324, 405, 4467, '2012-07-17'); SELECT dbfilter.pli_klm_ilots_libel32s_date(93734, 324, 403, 4467, '2012-07-14');

0.47s | SELECT dbfilter.pli_klm_ilots_deb(102966, 314, 402, -1, '2011-11-05'); SELECT dbfilter.pli_klm_ilots_deb(102966, 315, 402, -1, '2011-12-04'); SELECT dbfilter.pli_klm_ilots_deb(102966, 316, 402, -1, '2012-03-07'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 317, 402, -1, '2012-03-21'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 318, 402, -1, '2012-03-30'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 319, 402, -1, '2012-04-24'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 320, 402, -1, '2012-05-04'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 321, 402, -1, '2012-05-13'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 322, 402, -1, '2012-05-21'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 323, 402, -1, '2012-06-30'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 324, 402, -1, '2012-07-20'); SELECT dbfilter.pli_klm_ilots_deb(102966, 314, 405, -1, '2011-11-05'); SELECT dbfilter.pli_klm_ilots_deb(102966, 314, 404, -1, '2011-11-05'); SELECT dbfilter.pli_klm_ilots_deb(102966, 314, 403, -1, '2011-11-05'); SELECT dbfilter.pli_klm_ilots_deb(102966, 315, 405, -1, '2011-12-04'); SELECT dbfilter.pli_klm_ilots_deb(102966, 315, 403, -1, '2011-12-04'); SELECT dbfilter.pli_klm_ilots_deb(102966, 315, 404, -1, '2011-12-04'); SELECT dbfilter.pli_klm_ilots_deb(102966, 316, 405, -1, '2012-03-07'); SELECT dbfilter.pli_klm_ilots_deb(102966, 316, 403, -1, '2012-03-07'); SELECT dbfilter.pli_klm_ilots_deb(102966, 316, 404, -1, '2012-03-07'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 317, 403, -1, '2012-03-21'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 317, 405, -1, '2012-03-21'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 317, 404, -1, '2012-03-21'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 318, 403, -1, '2012-03-30'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 318, 404, -1, '2012-03-29'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 318, 405, -1, '2012-03-31'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 319, 405, -1, '2012-04-27'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 319, 404, -1, '2012-04-22'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 319, 403, -1, '2012-04-25'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 320, 403, -1, '2012-05-04'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 320, 404, -1, '2012-05-01'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 320, 405, -1, '2012-05-07'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 321, 403, -1, '2012-05-14'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 321, 405, -1, '2012-05-16'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 321, 404, -1, '2012-05-11'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 322, 405, -1, '2012-05-24'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 322, 404, -1, '2012-05-19'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 322, 403, -1, '2012-05-21'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 323, 405, -1, '2012-07-03'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 323, 403, -1, '2012-07-01'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 323, 404, -1, '2012-06-28'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 324, 404, -1, '2012-07-16'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 324, 405, -1, '2012-07-23'); SELECT dbfilter.pli_klm_ilots_libel32s_date(102966, 324, 403, -1, '2012-07-21');

14m16.51s

Day	Time	Count	Duration	Av. Duration
Mar 20	10	1	20.27s	20.27s
	11	2	40.28s	20.14s
	12	2	35.19s	17.59s
	15	1	20.14s	20.14s
	16	3	2m47.95s	55.98s
	17	2	2m22.73s	1m11.37s
Mar 21	14	6	1m24.00s	14.00s
	15	1	21.14s	21.14s
	16	3	1m4.09s	21.36s
Mar 22	09	1	21.17s	21.17s
	10	1	21.23s	21.23s
	11	1	56.03s	56.03s
	14	1	1.91s	1.91s
	15	5	1m34.45s	18.89s
Mar 23	09	2	44.78s	22.39s
	10	1	21.14s	21.14s

25.95s

SELECT "watfall"."plilibel32sitk"."mlgt" ,"watfall"."plilibel32sitk"."idjetflag" ,"watfall"."plilibel32sitk"."gin_age" ,"watfall"."plilibel32sitk"."id_categoriejetflag" ,"watfall"."plilibel32sitk"."gin_ordre" ,"watfall"."plilibel32sitk"."ind_ordre" ,"watfall"."plilibel32sitk"."ll_unite" ,"watfall"."plilibel32sitk"."ind_age" ,"watfall"."plilibel32sitk"."id_slam" ,"watfall"."plilibel32sitk"."y_getit" ,"watfall"."plilibel32sitk"."exp_age" ,"watfall"."plilibel32sitk"."charge" ,"watfall"."plilibel32sitk"."sum_t" ,"watfall"."plilibel32sitk"."id_itk" ,"watfall"."plilibel32sitk"."itk_age" ,"watfall"."plilibel32sitk"."pan" ,"dbfilter"."klm_age"."ll_long" FROM "watfall"."plilibel32sitk","dbfilter"."klm_age" WHERE (((("watfall"."plilibel32sitk"."id_libel32_serie" IN (...) ) AND ("watfall"."plilibel32sitk"."id_groupejetflag" IN (...) ) ) AND ("watfall"."plilibel32sitk"."ind_echelle" IN (...) ) ) AND ("watfall"."plilibel32sitk"."id_categoriejetflag" = "dbfilter"."klm_age"."id_cat" ) );

2m7.91s | SELECT "watfall"."plilibel32sitk"."mlgt" ,"watfall"."plilibel32sitk"."idjetflag" ,"watfall"."plilibel32sitk"."gin_age" ,"watfall"."plilibel32sitk"."id_categoriejetflag" ,"watfall"."plilibel32sitk"."gin_ordre" ,"watfall"."plilibel32sitk"."ind_ordre" ,"watfall"."plilibel32sitk"."ll_unite" ,"watfall"."plilibel32sitk"."ind_age" ,"watfall"."plilibel32sitk"."id_slam" ,"watfall"."plilibel32sitk"."y_getit" ,"watfall"."plilibel32sitk"."exp_age" ,"watfall"."plilibel32sitk"."charge" ,"watfall"."plilibel32sitk"."sum_t" ,"watfall"."plilibel32sitk"."id_itk" ,"watfall"."plilibel32sitk"."itk_age" ,"watfall"."plilibel32sitk"."pan" ,"dbfilter"."klm_age"."ll_long" FROM "watfall"."plilibel32sitk","dbfilter"."klm_age" WHERE (((("watfall"."plilibel32sitk"."id_libel32_serie" IN (5572 ,5573 ) ) AND ("watfall"."plilibel32sitk"."id_groupejetflag" IN (12 ,4 ,14 ,13 ,7 ,3 ,8 ,17 ,18 ,19 ,6 ,1 ,2 ,15 ,11 ,16 ) ) ) AND ("watfall"."plilibel32sitk"."ind_echelle" IN (1 ,3 ) ) ) AND ("watfall"."plilibel32sitk"."id_categoriejetflag" = "dbfilter"."klm_age"."id_cat" ) );

2m2.75s | SELECT "watfall"."plilibel32sitk"."mlgt" ,"watfall"."plilibel32sitk"."idjetflag" ,"watfall"."plilibel32sitk"."gin_age" ,"watfall"."plilibel32sitk"."id_categoriejetflag" ,"watfall"."plilibel32sitk"."gin_ordre" ,"watfall"."plilibel32sitk"."ind_ordre" ,"watfall"."plilibel32sitk"."ll_unite" ,"watfall"."plilibel32sitk"."ind_age" ,"watfall"."plilibel32sitk"."id_slam" ,"watfall"."plilibel32sitk"."y_getit" ,"watfall"."plilibel32sitk"."exp_age" ,"watfall"."plilibel32sitk"."charge" ,"watfall"."plilibel32sitk"."sum_t" ,"watfall"."plilibel32sitk"."id_itk" ,"watfall"."plilibel32sitk"."itk_age" ,"watfall"."plilibel32sitk"."pan" ,"dbfilter"."klm_age"."ll_long" FROM "watfall"."plilibel32sitk","dbfilter"."klm_age" WHERE (((("watfall"."plilibel32sitk"."id_libel32_serie" IN (5577 ,5578 ) ) AND ("watfall"."plilibel32sitk"."id_groupejetflag" IN (12 ,4 ,14 ,13 ,7 ,3 ,8 ,17 ,18 ,19 ,6 ,1 ,2 ,15 ,11 ,16 ) ) ) AND ("watfall"."plilibel32sitk"."ind_echelle" IN (1 ,3 ) ) ) AND ("watfall"."plilibel32sitk"."id_categoriejetflag" = "dbfilter"."klm_age"."id_cat" ) );

56.03s | SELECT "watfall"."plilibel32sitk"."mlgt" ,"watfall"."plilibel32sitk"."idjetflag" ,"watfall"."plilibel32sitk"."gin_age" ,"watfall"."plilibel32sitk"."id_categoriejetflag" ,"watfall"."plilibel32sitk"."gin_ordre" ,"watfall"."plilibel32sitk"."ind_ordre" ,"watfall"."plilibel32sitk"."ll_unite" ,"watfall"."plilibel32sitk"."ind_age" ,"watfall"."plilibel32sitk"."id_slam" ,"watfall"."plilibel32sitk"."y_getit" ,"watfall"."plilibel32sitk"."exp_age" ,"watfall"."plilibel32sitk"."charge" ,"watfall"."plilibel32sitk"."sum_t" ,"watfall"."plilibel32sitk"."id_itk" ,"watfall"."plilibel32sitk"."itk_age" ,"watfall"."plilibel32sitk"."pan" ,"dbfilter"."klm_age"."ll_long" FROM "watfall"."plilibel32sitk","dbfilter"."klm_age" WHERE (((("watfall"."plilibel32sitk"."id_libel32_serie" IN (2519 ) ) AND ("watfall"."plilibel32sitk"."id_groupejetflag" IN (12 ,4 ,14 ,13 ,7 ,3 ,8 ,17 ,18 ,19 ,6 ,1 ,2 ,15 ,11 ,16 ) ) ) AND ("watfall"."plilibel32sitk"."ind_echelle" IN (1 ,3 ) ) ) AND ("watfall"."plilibel32sitk"."id_categoriejetflag" = "dbfilter"."klm_age"."id_cat" ) );

13m44.55s

Day	Time	Count	Duration	Av. Duration
Mar 20	10	1	14.45s	14.45s
	11	2	28.59s	14.30s
	12	2	28.58s	14.29s
	15	1	23.44s	23.44s
	16	3	2m35.94s	51.98s
	17	2	2m13.30s	1m6.65s
Mar 21	14	6	1m25.97s	14.33s
	15	1	17.41s	17.41s
	16	3	52.09s	17.36s
Mar 22	09	1	25.31s	25.31s
	10	1	25.45s	25.45s
	11	1	52.61s	52.61s
	14	1	1.92s	1.92s
	15	5	1m49.31s	21.86s
Mar 23	09	2	52.78s	26.39s
	10	1	17.39s	17.39s

24.99s

SELECT "watfall"."plilibel32splot"."cre_charge" ,"watfall"."plilibel32splot"."mlgt" ,"watfall"."plilibel32splot"."idjetflag" ,"watfall"."plilibel32splot"."gin_age" ,"watfall"."plilibel32splot"."id_categoriejetflag" ,"watfall"."plilibel32splot"."gin_ordre" ,"watfall"."plilibel32splot"."ind_ordre" ,"watfall"."plilibel32splot"."ll_unite" ,"watfall"."plilibel32splot"."ind_age" ,"watfall"."plilibel32splot"."id_f" ,"watfall"."plilibel32splot"."mil_hhigt" ,"watfall"."plilibel32splot"."exp_age" ,"watfall"."plilibel32splot"."mil_age" ,"watfall"."plilibel32splot"."itk_age" ,"watfall"."plilibel32splot"."pan" ,"watfall"."plilibel32splot"."precedent" ,"watfall"."plilibel32splot"."lot_age" ,"watfall"."plilibel32splot"."y_getit" ,"watfall"."plilibel32splot"."id_slam" ,"dbfilter"."klm_age"."ll_long" FROM "watfall"."plilibel32splot","dbfilter"."klm_age" WHERE (((("watfall"."plilibel32splot"."id_libel32_serie" IN (...) ) AND ("watfall"."plilibel32splot"."id_groupejetflag" IN (...) ) ) AND ("watfall"."plilibel32splot"."ind_echelle" IN (...) ) ) AND ("watfall"."plilibel32splot"."id_categoriejetflag" = "dbfilter"."klm_age"."id_cat" ) );

1m49.95s | SELECT "watfall"."plilibel32splot"."cre_charge" ,"watfall"."plilibel32splot"."mlgt" ,"watfall"."plilibel32splot"."idjetflag" ,"watfall"."plilibel32splot"."gin_age" ,"watfall"."plilibel32splot"."id_categoriejetflag" ,"watfall"."plilibel32splot"."gin_ordre" ,"watfall"."plilibel32splot"."ind_ordre" ,"watfall"."plilibel32splot"."ll_unite" ,"watfall"."plilibel32splot"."ind_age" ,"watfall"."plilibel32splot"."id_f" ,"watfall"."plilibel32splot"."mil_hhigt" ,"watfall"."plilibel32splot"."exp_age" ,"watfall"."plilibel32splot"."mil_age" ,"watfall"."plilibel32splot"."itk_age" ,"watfall"."plilibel32splot"."pan" ,"watfall"."plilibel32splot"."precedent" ,"watfall"."plilibel32splot"."lot_age" ,"watfall"."plilibel32splot"."y_getit" ,"watfall"."plilibel32splot"."id_slam" ,"dbfilter"."klm_age"."ll_long" FROM "watfall"."plilibel32splot","dbfilter"."klm_age" WHERE (((("watfall"."plilibel32splot"."id_libel32_serie" IN (5577 ,5578 ) ) AND ("watfall"."plilibel32splot"."id_groupejetflag" IN (12 ,4 ,14 ,13 ,7 ,3 ,8 ,17 ,18 ,19 ,6 ,1 ,2 ,15 ,11 ,16 ) ) ) AND ("watfall"."plilibel32splot"."ind_echelle" IN (1 ,3 ) ) ) AND ("watfall"."plilibel32splot"."id_categoriejetflag" = "dbfilter"."klm_age"."id_cat" ) );

1m49.27s | SELECT "watfall"."plilibel32splot"."cre_charge" ,"watfall"."plilibel32splot"."mlgt" ,"watfall"."plilibel32splot"."idjetflag" ,"watfall"."plilibel32splot"."gin_age" ,"watfall"."plilibel32splot"."id_categoriejetflag" ,"watfall"."plilibel32splot"."gin_ordre" ,"watfall"."plilibel32splot"."ind_ordre" ,"watfall"."plilibel32splot"."ll_unite" ,"watfall"."plilibel32splot"."ind_age" ,"watfall"."plilibel32splot"."id_f" ,"watfall"."plilibel32splot"."mil_hhigt" ,"watfall"."plilibel32splot"."exp_age" ,"watfall"."plilibel32splot"."mil_age" ,"watfall"."plilibel32splot"."itk_age" ,"watfall"."plilibel32splot"."pan" ,"watfall"."plilibel32splot"."precedent" ,"watfall"."plilibel32splot"."lot_age" ,"watfall"."plilibel32splot"."y_getit" ,"watfall"."plilibel32splot"."id_slam" ,"dbfilter"."klm_age"."ll_long" FROM "watfall"."plilibel32splot","dbfilter"."klm_age" WHERE (((("watfall"."plilibel32splot"."id_libel32_serie" IN (5572 ,5573 ) ) AND ("watfall"."plilibel32splot"."id_groupejetflag" IN (12 ,4 ,14 ,13 ,7 ,3 ,8 ,17 ,18 ,19 ,6 ,1 ,2 ,15 ,11 ,16 ) ) ) AND ("watfall"."plilibel32splot"."ind_echelle" IN (1 ,3 ) ) ) AND ("watfall"."plilibel32splot"."id_categoriejetflag" = "dbfilter"."klm_age"."id_cat" ) );

1m0.69s | SELECT "watfall"."plilibel32splot"."cre_charge" ,"watfall"."plilibel32splot"."mlgt" ,"watfall"."plilibel32splot"."idjetflag" ,"watfall"."plilibel32splot"."gin_age" ,"watfall"."plilibel32splot"."id_categoriejetflag" ,"watfall"."plilibel32splot"."gin_ordre" ,"watfall"."plilibel32splot"."ind_ordre" ,"watfall"."plilibel32splot"."ll_unite" ,"watfall"."plilibel32splot"."ind_age" ,"watfall"."plilibel32splot"."id_f" ,"watfall"."plilibel32splot"."mil_hhigt" ,"watfall"."plilibel32splot"."exp_age" ,"watfall"."plilibel32splot"."mil_age" ,"watfall"."plilibel32splot"."itk_age" ,"watfall"."plilibel32splot"."pan" ,"watfall"."plilibel32splot"."precedent" ,"watfall"."plilibel32splot"."lot_age" ,"watfall"."plilibel32splot"."y_getit" ,"watfall"."plilibel32splot"."id_slam" ,"dbfilter"."klm_age"."ll_long" FROM "watfall"."plilibel32splot","dbfilter"."klm_age" WHERE (((("watfall"."plilibel32splot"."id_libel32_serie" IN (5380 ,5381 ) ) AND ("watfall"."plilibel32splot"."id_groupejetflag" IN (12 ,4 ,14 ,13 ,7 ,3 ,8 ,17 ,18 ,19 ,6 ,1 ,2 ,15 ,11 ,16 ) ) ) AND ("watfall"."plilibel32splot"."ind_echelle" IN (1 ,3 ) ) ) AND ("watfall"."plilibel32splot"."id_categoriejetflag" = "dbfilter"."klm_age"."id_cat" ) );

13m34.17s

Day	Time	Count	Duration	Av. Duration
Mar 20	10	1	17.58s	17.58s
	11	2	38.55s	19.27s
	12	2	34.36s	17.18s
	15	1	19.34s	19.34s
	16	3	2m39.58s	53.19s
	17	2	2m17.58s	1m8.79s
Mar 21	14	6	1m22.22s	13.70s
	15	1	19.83s	19.83s
	16	3	59.52s	19.84s
Mar 22	09	1	19.81s	19.81s
	10	1	19.88s	19.88s
	11	1	55.80s	55.80s
	14	1	1.92s	1.92s
	15	5	1m26.81s	17.36s
Mar 23	09	2	41.58s	20.79s
	10	1	19.83s	19.83s

24.67s

SELECT "watfall"."plilibel32span"."mlgt" ,"watfall"."plilibel32span"."idjetflag" ,"watfall"."plilibel32span"."gin_age" ,"watfall"."plilibel32span"."id_categoriejetflag" ,"watfall"."plilibel32span"."gin_ordre" ,"watfall"."plilibel32span"."ind_ordre" ,"watfall"."plilibel32span"."ll_unite" ,"watfall"."plilibel32span"."ind_age" ,"watfall"."plilibel32span"."id_slam" ,"watfall"."plilibel32span"."y_getit" ,"watfall"."plilibel32span"."exp_age" ,"watfall"."plilibel32span"."charge" ,"watfall"."plilibel32span"."sum_t" ,"watfall"."plilibel32span"."pan" ,"dbfilter"."klm_age"."ll_long" FROM "watfall"."plilibel32span","dbfilter"."klm_age" WHERE (((("watfall"."plilibel32span"."id_libel32_serie" IN (...) ) AND ("watfall"."plilibel32span"."id_groupejetflag" IN (...) ) ) AND ("watfall"."plilibel32span"."ind_echelle" IN (...) ) ) AND ("watfall"."plilibel32span"."id_categoriejetflag" = "dbfilter"."klm_age"."id_cat" ) );

2m1.27s | SELECT "watfall"."plilibel32span"."mlgt" ,"watfall"."plilibel32span"."idjetflag" ,"watfall"."plilibel32span"."gin_age" ,"watfall"."plilibel32span"."id_categoriejetflag" ,"watfall"."plilibel32span"."gin_ordre" ,"watfall"."plilibel32span"."ind_ordre" ,"watfall"."plilibel32span"."ll_unite" ,"watfall"."plilibel32span"."ind_age" ,"watfall"."plilibel32span"."id_slam" ,"watfall"."plilibel32span"."y_getit" ,"watfall"."plilibel32span"."exp_age" ,"watfall"."plilibel32span"."charge" ,"watfall"."plilibel32span"."sum_t" ,"watfall"."plilibel32span"."pan" ,"dbfilter"."klm_age"."ll_long" FROM "watfall"."plilibel32span","dbfilter"."klm_age" WHERE (((("watfall"."plilibel32span"."id_libel32_serie" IN (5572 ,5573 ) ) AND ("watfall"."plilibel32span"."id_groupejetflag" IN (12 ,4 ,14 ,13 ,7 ,3 ,8 ,17 ,18 ,19 ,6 ,1 ,2 ,15 ,11 ,16 ) ) ) AND ("watfall"."plilibel32span"."ind_echelle" IN (1 ,3 ) ) ) AND ("watfall"."plilibel32span"."id_categoriejetflag" = "dbfilter"."klm_age"."id_cat" ) );

1m58.31s | SELECT "watfall"."plilibel32span"."mlgt" ,"watfall"."plilibel32span"."idjetflag" ,"watfall"."plilibel32span"."gin_age" ,"watfall"."plilibel32span"."id_categoriejetflag" ,"watfall"."plilibel32span"."gin_ordre" ,"watfall"."plilibel32span"."ind_ordre" ,"watfall"."plilibel32span"."ll_unite" ,"watfall"."plilibel32span"."ind_age" ,"watfall"."plilibel32span"."id_slam" ,"watfall"."plilibel32span"."y_getit" ,"watfall"."plilibel32span"."exp_age" ,"watfall"."plilibel32span"."charge" ,"watfall"."plilibel32span"."sum_t" ,"watfall"."plilibel32span"."pan" ,"dbfilter"."klm_age"."ll_long" FROM "watfall"."plilibel32span","dbfilter"."klm_age" WHERE (((("watfall"."plilibel32span"."id_libel32_serie" IN (5577 ,5578 ) ) AND ("watfall"."plilibel32span"."id_groupejetflag" IN (12 ,4 ,14 ,13 ,7 ,3 ,8 ,17 ,18 ,19 ,6 ,1 ,2 ,15 ,11 ,16 ) ) ) AND ("watfall"."plilibel32span"."ind_echelle" IN (1 ,3 ) ) ) AND ("watfall"."plilibel32span"."id_categoriejetflag" = "dbfilter"."klm_age"."id_cat" ) );

55.80s | SELECT "watfall"."plilibel32span"."mlgt" ,"watfall"."plilibel32span"."idjetflag" ,"watfall"."plilibel32span"."gin_age" ,"watfall"."plilibel32span"."id_categoriejetflag" ,"watfall"."plilibel32span"."gin_ordre" ,"watfall"."plilibel32span"."ind_ordre" ,"watfall"."plilibel32span"."ll_unite" ,"watfall"."plilibel32span"."ind_age" ,"watfall"."plilibel32span"."id_slam" ,"watfall"."plilibel32span"."y_getit" ,"watfall"."plilibel32span"."exp_age" ,"watfall"."plilibel32span"."charge" ,"watfall"."plilibel32span"."sum_t" ,"watfall"."plilibel32span"."pan" ,"dbfilter"."klm_age"."ll_long" FROM "watfall"."plilibel32span","dbfilter"."klm_age" WHERE (((("watfall"."plilibel32span"."id_libel32_serie" IN (2519 ) ) AND ("watfall"."plilibel32span"."id_groupejetflag" IN (12 ,4 ,14 ,13 ,7 ,3 ,8 ,17 ,18 ,19 ,6 ,1 ,2 ,15 ,11 ,16 ) ) ) AND ("watfall"."plilibel32span"."ind_echelle" IN (1 ,3 ) ) ) AND ("watfall"."plilibel32span"."id_categoriejetflag" = "dbfilter"."klm_age"."id_cat" ) );

11m26.89s

19.08s

COPY dbfilter.klm_ilots_gstadi_carto_20 (id_libel32, id_f, id_cat, idplace_o, charge, date_libel32, id_cat_operation) TO STDOUT;

9m26.19s

15.73s

COPY dbfilter.klm_ilots_gstadi_parcelle_20 (id_libel32, id_f, id_cat, idplace_o, charge, date_libel32, id_cat_operation) TO STDOUT;

Most frequent queries (N) ^

Rank

Times executed

Total duration

Av. duration (s)

Query

1,600,267

Day	Time	Count	Duration	Av. Duration
Mar 20	08	131,079	6.58s	0.00s
	09	285,217	16.10s	0.00s
	10	131,312	5.96s	0.00s
	11	175,625	9.49s	0.00s
	12	63,665	3.76s	0.00s
	13	37,797	2.17s	0.00s
	14	30,370	1.37s	0.00s
	15	46,850	2.23s	0.00s
	16	70,616	3.78s	0.00s
	17	53,906	2.87s	0.00s
	18	40,476	2.03s	0.00s
	19	19,241	0.83s	0.00s
	20	85	0.01s	0.00s
	21	10,238	0.66s	0.00s
	22	8,045	0.52s	0.00s
	23	2,220	0.14s	0.00s
Mar 21	01	2,315	0.10s	0.00s
	06	987	0.14s	0.00s
	07	5,001	0.40s	0.00s
	08	39,202	2.22s	0.00s
	09	24,184	1.34s	0.00s
	10	21,883	1.17s	0.00s
	11	23,829	1.57s	0.00s
	12	4,891	0.24s	0.00s
	13	4,338	0.08s	0.00s
	14	23,795	1.52s	0.00s
	15	14,281	0.85s	0.00s
	16	24,819	1.65s	0.00s
	17	14,875	0.73s	0.00s
	18	483	0.03s	0.00s
	19	3,227	0.12s	0.00s
	20	1,154	0.01s	0.00s
	21	1,410	0.06s	0.00s
	23	4,658	0.22s	0.00s
Mar 22	01	1,208	0.11s	0.00s
	02	6	0.00s	0.00s
	07	166	0.00s	0.00s
	08	4,095	0.33s	0.00s
	09	34,074	2.00s	0.00s
	10	9,280	0.55s	0.00s
	11	1,728	0.06s	0.00s
	13	11,699	0.69s	0.00s
	14	9,607	0.39s	0.00s
	15	36,701	1.44s	0.00s
	16	1,098	0.09s	0.00s
	17	17,749	1.14s	0.00s
	18	4,215	0.20s	0.00s
	19	858	0.08s	0.00s
	20	3,310	0.16s	0.00s
	21	125	0.02s	0.00s
	22	584	0.03s	0.00s
	23	130	0.00s	0.00s
Mar 23	00	361	0.05s	0.00s
	08	4,511	0.19s	0.00s
	09	10,753	0.57s	0.00s
	10	11,932	0.53s	0.00s
	11	6,424	0.42s	0.00s
	12	7,801	0.56s	0.00s
	13	14,797	0.91s	0.00s
	14	9,843	0.50s	0.00s
	15	13,137	0.91s	0.00s
	16	48,441	3.15s	0.00s
	17	13,560	0.91s	0.00s

1m26.98s

0.00s

reset ALL;

837,734

30m31.30s

0.00s

409,985

3m24.85s

0.00s

SELECT to_char(charge, '') AS charge FROM (SELECT max(dbfilter.klm_ilots_gstadi_carto_final.id_libel32) AS libel32 FROM dbfilter.klm_ilots_libel32s_stadi_carto_final WHERE id_f = 0 AND id_cat = 0 AND idplace_o = 0 AND id_cat_operation = 0 AND dbfilter.klm_ilots_libel32s_stadi_carto_final.date_libel32 > '' GROUP BY id_f, id_cat, idplace_o, id_cat_operation) req JOIN dbfilter.klm_ilots_libel32s_stadi_carto_final ON dbfilter.klm_ilots_libel32s_stadi_carto_final.id_libel32 = req.libel32;

366,927

Day	Time	Count	Duration	Av. Duration
Mar 20	08	40,421	15.45s	0.00s
	09	55,843	19.97s	0.00s
	10	26,880	8.45s	0.00s
	11	42,657	14.76s	0.00s
	12	14,818	5.06s	0.00s
	13	5,151	1.77s	0.00s
	14	6,826	2.65s	0.00s
	15	11,867	4.11s	0.00s
	16	10,251	3.44s	0.00s
	17	15,507	5.06s	0.00s
	18	7,619	2.61s	0.00s
	19	3,760	1.37s	0.00s
	20	36	0.03s	0.00s
	21	1,732	0.48s	0.00s
	22	1,129	0.47s	0.00s
	23	409	0.17s	0.00s
Mar 21	01	942	0.50s	0.00s
	06	453	0.16s	0.00s
	07	2,082	0.80s	0.00s
	08	8,337	3.00s	0.00s
	09	5,492	1.96s	0.00s
	10	3,811	1.48s	0.00s
	11	6,216	2.07s	0.00s
	12	959	0.55s	0.00s
	13	345	0.23s	0.00s
	14	2,007	0.75s	0.00s
	15	2,974	1.19s	0.00s
	16	3,842	1.24s	0.00s
	17	4,197	1.57s	0.00s
	18	76	0.03s	0.00s
	19	271	0.13s	0.00s
	20	250	0.11s	0.00s
	21	124	0.02s	0.00s
	23	1,042	0.33s	0.00s
Mar 22	01	212	0.03s	0.00s
	07	72	0.05s	0.00s
	08	804	0.27s	0.00s
	09	4,078	1.50s	0.00s
	10	2,236	0.97s	0.00s
	11	193	0.05s	0.00s
	13	2,580	0.92s	0.00s
	14	2,623	0.84s	0.00s
	15	6,290	2.44s	0.00s
	16	363	0.19s	0.00s
	17	6,301	2.11s	0.00s
	18	1,003	0.37s	0.00s
	19	117	0.05s	0.00s
	20	744	0.31s	0.00s
	21	45	0.01s	0.00s
	22	256	0.12s	0.00s
	23	52	0.03s	0.00s
Mar 23	00	106	0.03s	0.00s
	08	1,726	0.69s	0.00s
	09	4,947	1.49s	0.00s
	10	4,908	1.97s	0.00s
	11	2,339	0.80s	0.00s
	12	3,445	1.10s	0.00s
	13	5,296	1.97s	0.00s
	14	2,215	0.80s	0.00s
	15	2,995	1.03s	0.00s
	16	19,664	7.56s	0.00s
	17	2,991	1.09s	0.00s

2m10.75s

0.00s

SELECT dbfilter.klmintrants.id_type_intrant FROM dbfilter.klmilots LEFT JOIN dbfilter.klmintrants ON dbfilter.klmilots.id_action = dbfilter.klmintrants.id_action WHERE (((dbfilter.klmilots.id_f)=0) AND ((dbfilter.klmilots.id_type_action)=0));

358,047

Day	Time	Count	Duration	Av. Duration
Mar 20	08	20,633	3.05s	0.00s
	09	89,111	12.80s	0.00s
	10	42,284	5.60s	0.00s
	11	47,658	6.46s	0.00s
	12	15,683	2.37s	0.00s
	13	12,010	1.43s	0.00s
	14	7,230	1.24s	0.00s
	15	9,961	1.24s	0.00s
	16	20,449	2.63s	0.00s
	17	10,562	1.73s	0.00s
	18	7,790	1.17s	0.00s
	19	4,421	0.52s	0.00s
	21	1,941	0.36s	0.00s
	22	1,991	0.20s	0.00s
Mar 21	08	10,317	1.40s	0.00s
	09	1,085	0.14s	0.00s
	10	1,612	0.20s	0.00s
	11	1,668	0.14s	0.00s
	13	1,949	0.34s	0.00s
	14	11,436	1.84s	0.00s
	15	604	0.09s	0.00s
	16	5,508	0.81s	0.00s
	17	597	0.22s	0.00s
	18	156	0.00s	0.00s
Mar 22	08	312	0.03s	0.00s
	09	9,233	1.27s	0.00s
	10	982	0.31s	0.00s
	11	312	0.00s	0.00s
	13	128	0.02s	0.00s
	14	74	0.00s	0.00s
	15	3,894	0.50s	0.00s
	17	144	0.01s	0.00s
	18	801	0.25s	0.00s
Mar 23	08	60	0.00s	0.00s
	09	181	0.03s	0.00s
	10	70	0.02s	0.00s
	11	88	0.14s	0.00s
	12	335	0.13s	0.00s
	13	363	0.03s	0.00s
	14	2,882	0.45s	0.00s
	15	3,656	0.78s	0.00s
	16	2,849	0.48s	0.00s
	17	5,027	0.64s	0.00s

51.10s

0.00s

SELECT description FROM dbfilter.klm_age WHERE id_cat=0;

152,953

Day	Time	Count	Duration	Av. Duration
Mar 20	08	17,692	6.99s	0.00s
	09	24,030	10.11s	0.00s
	10	13,768	5.41s	0.00s
	11	23,958	9.48s	0.00s
	12	5,778	2.23s	0.00s
	13	1,818	0.80s	0.00s
	14	3,140	1.30s	0.00s
	15	5,476	2.08s	0.00s
	16	3,688	1.42s	0.00s
	17	7,081	2.64s	0.00s
	18	2,300	1.16s	0.00s
	19	584	0.27s	0.00s
	21	666	0.30s	0.00s
	22	364	0.16s	0.00s
Mar 21	07	548	0.22s	0.00s
	08	4,052	1.92s	0.00s
	09	1,270	0.38s	0.00s
	10	1,096	0.43s	0.00s
	11	256	0.08s	0.00s
	14	1,024	0.38s	0.00s
	15	588	0.31s	0.00s
	17	878	0.42s	0.00s
Mar 22	09	256	0.08s	0.00s
	10	598	0.12s	0.00s
	13	292	0.09s	0.00s
	14	620	0.25s	0.00s
	15	256	0.09s	0.00s
	17	3,824	1.67s	0.00s
	20	344	0.11s	0.00s
Mar 23	08	688	0.35s	0.00s
	09	4,128	1.86s	0.00s
	10	1,734	0.53s	0.00s
	11	548	0.30s	0.00s
	12	2,596	1.24s	0.00s
	13	1,980	0.68s	0.00s
	14	1,032	0.45s	0.00s
	15	1,236	0.61s	0.00s
	16	10,154	4.29s	0.00s
	17	2,612	1.11s	0.00s

1m2.31s

0.00s

SELECT id_peer, cat_id_eltfiname, startan, mois_h_an, lem_ofinam, lem_hfinam FROM caves.klm_peerfinamation WHERE cat_id_eltfiname=0 AND pvic=false AND 0 = ANY (list_id_cul);

152,948

Day	Time	Count	Duration	Av. Duration
Mar 20	08	17,692	4.81s	0.00s
	09	24,030	6.61s	0.00s
	10	13,768	3.77s	0.00s
	11	23,958	6.33s	0.00s
	12	5,778	1.46s	0.00s
	13	1,818	0.39s	0.00s
	14	3,140	0.88s	0.00s
	15	5,474	1.43s	0.00s
	16	3,688	0.95s	0.00s
	17	7,078	1.83s	0.00s
	18	2,300	0.70s	0.00s
	19	584	0.18s	0.00s
	21	666	0.28s	0.00s
	22	364	0.06s	0.00s
Mar 21	07	548	0.20s	0.00s
	08	4,052	1.19s	0.00s
	09	1,270	0.27s	0.00s
	10	1,096	0.28s	0.00s
	11	256	0.06s	0.00s
	14	1,024	0.33s	0.00s
	15	588	0.20s	0.00s
	17	878	0.24s	0.00s
Mar 22	09	256	0.03s	0.00s
	10	598	0.14s	0.00s
	13	292	0.08s	0.00s
	14	620	0.19s	0.00s
	15	256	0.08s	0.00s
	17	3,824	1.23s	0.00s
	20	344	0.14s	0.00s
Mar 23	08	688	0.22s	0.00s
	09	4,128	1.35s	0.00s
	10	1,734	0.73s	0.00s
	11	548	0.17s	0.00s
	12	2,596	0.51s	0.00s
	13	1,980	0.60s	0.00s
	14	1,032	0.16s	0.00s
	15	1,236	0.37s	0.00s
	16	10,154	2.73s	0.00s
	17	2,612	0.80s	0.00s

41.99s

0.00s

SELECT valide, idfinamation, cat_id_eltfiname, lip_val_num, lip_val_texte FROM dbfilter.tblfinamations_ilots WHERE lip_date='' AND id_f=0 AND cat_id_eltfiname=0;

140,953

Day	Time	Count	Duration	Av. Duration
Mar 20	08	18,933	3.26s	0.00s
	09	22,449	4.20s	0.00s
	10	9,547	1.77s	0.00s
	11	15,030	2.60s	0.00s
	12	5,917	0.99s	0.00s
	13	1,794	0.23s	0.00s
	14	2,723	0.50s	0.00s
	15	4,329	0.79s	0.00s
	16	1,851	0.39s	0.00s
	17	6,575	1.05s	0.00s
	18	1,755	0.36s	0.00s
	19	1,578	0.31s	0.00s
	20	33	0.00s	0.00s
	21	420	0.08s	0.00s
	22	384	0.09s	0.00s
	23	41	0.00s	0.00s
Mar 21	01	848	0.17s	0.00s
	06	398	0.09s	0.00s
	07	1,332	0.19s	0.00s
	08	2,982	0.68s	0.00s
	09	1,608	0.53s	0.00s
	10	1,326	0.22s	0.00s
	11	3,268	0.62s	0.00s
	12	96	0.00s	0.00s
	13	249	0.11s	0.00s
	14	509	0.08s	0.00s
	15	612	0.14s	0.00s
	16	1,585	0.27s	0.00s
	17	2,583	0.48s	0.00s
	18	70	0.01s	0.00s
	19	226	0.03s	0.00s
	20	139	0.05s	0.00s
	21	20	0.00s	0.00s
	23	397	0.10s	0.00s
Mar 22	01	12	0.00s	0.00s
	07	66	0.00s	0.00s
	08	381	0.10s	0.00s
	09	1,374	0.31s	0.00s
	10	1,368	0.26s	0.00s
	11	24	0.02s	0.00s
	13	1,061	0.11s	0.00s
	14	816	0.17s	0.00s
	15	884	0.17s	0.00s
	16	291	0.01s	0.00s
	17	1,253	0.23s	0.00s
	18	721	0.16s	0.00s
	19	12	0.00s	0.00s
	20	160	0.01s	0.00s
	21	36	0.00s	0.00s
	22	223	0.03s	0.00s
	23	40	0.00s	0.00s
Mar 23	00	75	0.00s	0.00s
	08	908	0.15s	0.00s
	09	787	0.22s	0.00s
	10	2,728	0.59s	0.00s
	11	1,572	0.44s	0.00s
	12	794	0.13s	0.00s
	13	2,610	0.48s	0.00s
	14	877	0.20s	0.00s
	15	1,455	0.28s	0.00s
	16	8,592	1.52s	0.00s
	17	226	0.05s	0.00s

26.06s

0.00s

SELECT DISTINCT dbfilter.klm_age.ro_dic FROM dbfilter.klm_age WHERE (dbfilter.klm_age.id_cat IN (...));

110,753

Day	Time	Count	Duration	Av. Duration
Mar 20	08	5,945	4.51s	0.00s
	09	28,117	21.62s	0.00s
	10	13,218	9.70s	0.00s
	11	13,892	10.69s	0.00s
	12	4,863	3.98s	0.00s
	13	3,962	3.35s	0.00s
	14	2,313	1.74s	0.00s
	15	3,038	2.29s	0.00s
	16	6,308	4.47s	0.00s
	17	3,259	2.50s	0.00s
	18	2,407	1.74s	0.00s
	19	1,441	1.05s	0.00s
	21	723	0.78s	0.00s
	22	724	0.53s	0.00s
Mar 21	08	3,127	2.99s	0.00s
	09	355	0.27s	0.00s
	10	527	0.41s	0.00s
	11	562	0.33s	0.00s
	13	648	0.47s	0.00s
	14	3,911	2.96s	0.00s
	15	200	0.23s	0.00s
	16	1,832	1.90s	0.00s
	17	226	0.08s	0.00s
	18	52	0.03s	0.00s
Mar 22	08	104	0.10s	0.00s
	09	3,029	2.15s	0.00s
	10	414	0.38s	0.00s
	11	104	0.06s	0.00s
	13	42	0.03s	0.00s
	14	12	0.00s	0.00s
	15	1,269	1.04s	0.00s
	17	47	0.02s	0.00s
	18	267	0.22s	0.00s
Mar 23	08	30	0.03s	0.00s
	09	90	0.06s	0.00s
	10	16	0.01s	0.00s
	11	109	0.05s	0.00s
	12	6	0.00s	0.00s
	13	3	0.00s	0.00s
	14	958	0.84s	0.00s
	15	1,174	1.00s	0.00s
	16	266	0.28s	0.00s
	17	1,163	1.38s	0.00s

1m26.26s

0.00s

SELECT t_font FROM caves.klm_cata_stop WHERE id_cat = 0 AND t_val_min <= 0 AND t_val_max > 0;

76,156

1m47.54s

0.00s

SELECT to_char(charge, '') AS charge FROM (SELECT max(dbfilter.klm_ilots_glift32.id_libel32) AS libel32 FROM dbfilter.klm_ilots_libel32s_lift32 WHERE id_f = 0 AND id_cat = 0 AND NOT idplace_o = - 0 AND idplace_o = 0 AND id_cat_operation = 0 AND dbfilter.klm_ilots_libel32s_lift32.date_libel32 > '' GROUP BY id_f, id_cat, idplace_o, id_cat_operation) req JOIN dbfilter.klm_ilots_libel32s_lift32 ON dbfilter.klm_ilots_libel32s_lift32.id_libel32 = req.libel32;

Slowest queries (N) ^

Rank

Av. duration (s)

Times executed

Total duration

Query

9m51.52s

141

Day	Time	Count	Duration	Av. Duration
Mar 20	08	1	14m28.31s	14m28.31s
	09	3	44m11.73s	14m43.91s
	10	4	1h13m49.67s	18m27.42s
	11	4	1h25m39.06s	21m24.77s
	13	4	1h24m37.91s	21m9.48s
	14	4	1h23m55.97s	20m58.99s
	15	4	1h19m5.48s	19m46.37s
	16	1	19m11.86s	19m11.86s
	17	3	57m1.27s	19m0.42s
	18	4	1h9m45.00s	17m26.25s
	19	4	1h5m49.80s	16m27.45s
	20	4	1h4m2.39s	16m0.60s
	21	2	30m25.98s	15m12.99s
	22	2	30m38.72s	15m19.36s
	23	4	1h32.05s	15m8.01s
Mar 21	00	4	59m39.64s	14m54.91s
	01	4	59m15.06s	14m48.77s
	02	2	29m10.44s	14m35.22s
	03	2	29m8.34s	14m34.17s
	04	4	59m19.20s	14m49.80s
	05	4	59m10.45s	14m47.61s
	06	4	58m14.56s	14m33.64s
	07	2	28m29.23s	14m14.62s
	08	2	28m28.47s	14m14.23s
	09	4	42m46.38s	10m41.59s
	10	4	24m43.00s	6m10.75s
	11	4	16m46.08s	4m11.52s
	12	1	2m32.28s	2m32.28s
	13	1	2m35.28s	2m35.28s
	14	1	2m12.66s	2m12.66s
	15	1	1m43.91s	1m43.91s
	16	1	1m22.73s	1m22.73s
	17	1	35.97s	35.97s
	18	1	25.66s	25.66s
	19	1	21.14s	21.14s
	20	1	18.33s	18.33s
	21	1	17.47s	17.47s
	22	1	17.39s	17.39s
	23	1	16.80s	16.80s
Mar 22	00	1	16.80s	16.80s
	01	1	22.06s	22.06s
	02	1	16.77s	16.77s
	03	1	16.81s	16.81s
	04	1	16.73s	16.73s
	05	1	16.86s	16.86s
	06	1	16.59s	16.59s
	07	1	16.08s	16.08s
	08	1	13.16s	13.16s
	10	2	27.08s	13.54s
	12	1	18.92s	18.92s
	13	1	18.94s	18.94s
	14	2	43.50s	21.75s
	15	1	30.20s	30.20s
	16	1	29.94s	29.94s
	17	1	28.77s	28.77s
	19	2	57.92s	28.96s
	20	1	28.98s	28.98s
	21	1	29.34s	29.34s
	22	1	29.27s	29.27s
Mar 23	00	1	29.66s	29.66s
	01	1	29.44s	29.44s
	02	1	29.27s	29.27s
	03	1	29.20s	29.20s
	04	1	29.08s	29.08s
	05	1	29.48s	29.48s
	06	1	29.30s	29.30s
	07	1	28.92s	28.92s
	08	1	29.08s	29.08s
	09	1	29.41s	29.41s
	10	1	15.47s	15.47s
	11	1	19.39s	19.39s
	12	1	20.95s	20.95s
	13	1	45.44s	45.44s
	14	1	51.30s	51.30s
	15	1	51.59s	51.59s
	16	1	48.67s	48.67s
	17	1	1m18.59s	1m18.59s

23h10m4.63s

6m2.81s

Day	Time	Count	Duration	Av. Duration
Mar 20	10	1	5m24.44s	5m24.44s
	11	2	11m26.64s	5m43.32s
	12	2	11m25.62s	5m42.81s
	15	1	7m4.42s	7m4.42s
	16	4	39m25.61s	9m51.40s
	17	1	20m0.30s	20m0.30s
Mar 21	13	2	7m53.06s	3m56.53s
	14	2	4m52.27s	2m26.13s
	16	3	11m59.64s	3m59.88s
Mar 22	09	2	7m55.97s	3m57.98s
	10	1	3m57.48s	3m57.48s
	15	4	18m52.34s	4m43.09s
Mar 23	09	1	8m58.97s	8m58.97s
	10	1	3m59.14s	3m59.14s

2h43m15.90s

SELECT "id_slam" ,"getit" ,"id_libel32_serie" ,"?COLUMN?" FROM "watfall"."plilibel32" WHERE (("id_slam" IN (...) ) AND ("getit" IN (...) ) );

25.95s

Day	Time	Count	Duration	Av. Duration
Mar 20	10	1	20.27s	20.27s
	11	2	40.28s	20.14s
	12	2	35.19s	17.59s
	15	1	20.14s	20.14s
	16	3	2m47.95s	55.98s
	17	2	2m22.73s	1m11.37s
Mar 21	14	6	1m24.00s	14.00s
	15	1	21.14s	21.14s
	16	3	1m4.09s	21.36s
Mar 22	09	1	21.17s	21.17s
	10	1	21.23s	21.23s
	11	1	56.03s	56.03s
	14	1	1.91s	1.91s
	15	5	1m34.45s	18.89s
Mar 23	09	2	44.78s	22.39s
	10	1	21.14s	21.14s

14m16.51s

24.99s

Day	Time	Count	Duration	Av. Duration
Mar 20	10	1	14.45s	14.45s
	11	2	28.59s	14.30s
	12	2	28.58s	14.29s
	15	1	23.44s	23.44s
	16	3	2m35.94s	51.98s
	17	2	2m13.30s	1m6.65s
Mar 21	14	6	1m25.97s	14.33s
	15	1	17.41s	17.41s
	16	3	52.09s	17.36s
Mar 22	09	1	25.31s	25.31s
	10	1	25.45s	25.45s
	11	1	52.61s	52.61s
	14	1	1.92s	1.92s
	15	5	1m49.31s	21.86s
Mar 23	09	2	52.78s	26.39s
	10	1	17.39s	17.39s

13m44.55s

24.67s

Day	Time	Count	Duration	Av. Duration
Mar 20	10	1	17.58s	17.58s
	11	2	38.55s	19.27s
	12	2	34.36s	17.18s
	15	1	19.34s	19.34s
	16	3	2m39.58s	53.19s
	17	2	2m17.58s	1m8.79s
Mar 21	14	6	1m22.22s	13.70s
	15	1	19.83s	19.83s
	16	3	59.52s	19.84s
Mar 22	09	1	19.81s	19.81s
	10	1	19.88s	19.88s
	11	1	55.80s	55.80s
	14	1	1.92s	1.92s
	15	5	1m26.81s	17.36s
Mar 23	09	2	41.58s	20.79s
	10	1	19.83s	19.83s

13m34.17s

19.08s

11m26.89s

COPY dbfilter.klm_ilots_gstadi_carto_20 (id_libel32, id_f, id_cat, idplace_o, charge, date_libel32, id_cat_operation) TO STDOUT;

15.73s

9m26.19s

COPY dbfilter.klm_ilots_gstadi_parcelle_20 (id_libel32, id_f, id_cat, idplace_o, charge, date_libel32, id_cat_operation) TO STDOUT;

13.14s

3m56.45s

SELECT "watfall"."pligeno_gpe_publi"."gin_age" ,"watfall"."pligeno_gpe_publi"."id_groupejetflag" ,"watfall"."pligeno_gpe_publi"."gin_echelle" ,"watfall"."pligeno_gpe_publi"."y_visa" ,"watfall"."pligeno_gpe_publi"."id_categoriejetflag" ,"watfall"."pligeno_gpe_publi"."gin_ordre" ,"watfall"."pligeno_gpe_publi"."y_publication" FROM "watfall"."pligeno_f","watfall"."pligeno_gpe_publi" WHERE ((("watfall"."pligeno_f"."port" = '' ) AND (("watfall"."pligeno_gpe_publi"."id_slam" = "watfall"."pligeno_f"."id_slam" ) AND ("watfall"."pligeno_gpe_publi"."getit" = "watfall"."pligeno_f"."getit" ) ) ) AND ("watfall"."pligeno_gpe_publi"."id_libel32_serie" IN (...) ) ) GROUP BY "watfall"."pligeno_gpe_publi"."gin_age" ,"watfall"."pligeno_gpe_publi"."id_groupejetflag" ,"watfall"."pligeno_gpe_publi"."gin_echelle" ,"watfall"."pligeno_gpe_publi"."y_visa" ,"watfall"."pligeno_gpe_publi"."id_categoriejetflag" ,"watfall"."pligeno_gpe_publi"."gin_ordre" ,"watfall"."pligeno_gpe_publi"."y_publication" ORDER BY "watfall"."pligeno_gpe_publi"."id_categoriejetflag" ,"watfall"."pligeno_gpe_publi"."gin_ordre";

8.02s

375

Day	Time	Count	Duration	Av. Duration
Mar 20	09	23	3m15.12s	8.48s
	10	31	3m57.44s	7.66s
	11	7	1m42.16s	14.59s
	12	2	15.27s	7.63s
	13	2	16.31s	8.16s
	15	7	1m0.05s	8.58s
	16	2	15.81s	7.91s
Mar 21	09	2	15.17s	7.59s
	10	69	9m9.29s	7.96s
	11	60	7m53.45s	7.89s
	12	70	8m42.01s	7.46s
	13	1	7.56s	7.56s
	14	11	1m27.24s	7.93s
	16	4	32.48s	8.12s
Mar 22	10	2	15.27s	7.63s
	11	2	16.30s	8.15s
	15	2	15.81s	7.91s
Mar 23	09	3	26.67s	8.89s
	10	7	52.70s	7.53s
	15	12	1m31.92s	7.66s
	16	55	7m30.33s	8.19s
	17	1	7.56s	7.56s

50m5.92s

SELECT "id_air" ,"pets_h" ,"pets_ha" FROM "watfall"."plilibel32" ORDER BY "watfall"."plilibel32"."id_air";

4.95s

Day	Time	Count	Duration	Av. Duration
Mar 20	10	1	5.11s	5.11s
	11	5	23.92s	4.78s
	12	1	4.78s	4.78s
	13	1	4.78s	4.78s
	14	2	9.62s	4.81s
	15	6	29.08s	4.85s
	16	6	28.91s	4.82s
Mar 21	09	6	30.97s	5.16s
	10	3	17.69s	5.90s
	11	2	9.59s	4.80s
	13	1	4.78s	4.78s
	14	4	19.41s	4.85s
	15	3	14.44s	4.81s
	16	15	1m16.59s	5.11s
Mar 22	09	6	28.67s	4.78s
	11	1	4.80s	4.80s
	13	1	4.78s	4.78s
	14	7	35.67s	5.10s
	15	3	14.36s	4.79s
	16	1	4.78s	4.78s
Mar 23	09	3	14.36s	4.79s
	10	2	9.56s	4.78s
	13	3	14.36s	4.79s
	15	1	4.78s	4.78s

6m55.80s

SELECT "dbfilter"."final_ilots"."id_final_ilots" FROM "dbfilter"."final_ilots";

Most frequent errors (N) ^

Rank

Times reported

Error

1,095

WARNING: nonstandard use of \\ in a string literal

309

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

ERROR: syntax error at or near "," at character 147

Detail: INSERT INTO dbfilter.tblfinamations_ilots (id_f, id_user, cat_id_eltfiname, lip_val_num, lip_date, key_crea) VALUES (82947, 1954, 2634, 8 %, '19-03-2012', CURRENT_TIMESTAMP)

ERROR: syntax error at or near "GROUP" at character 321

Detail: SELECT dbfilter.klm_genres_slams.lvval_num FROM dbfilter.klm_genres_slams WHERE dbfilter_klm_genres_slams.id_slam = 891 And dbfilter.klm_genres_slams.id_type_genre = 1605 And dbfilter.klm_genres_slams.lvval_num = GROUP BY dbfilter.klm_genres_slams.lvval_num;

ERROR: syntax error at or near "GROUP" at character 319

Detail: SELECT dbfilter.klm_genres_slams.lvval_num FROM dbfilter.klm_genres_slams WHERE dbfilter_klm_genres_slams.id_slam = 5 And dbfilter.klm_genres_slams.id_type_genre = 1605 And dbfilter.klm_genres_slams.lvval_num = GROUP BY dbfilter.klm_genres_slams.lvval_num;

ERROR: syntax error at or near ")" at character 2272

Detail: SELECT dbfilter.klm_slams.exp_age, (klm_gseries.y_getit - 1 || '-' || klm_libel32s_series.y_getit) AS camp, to_char(klm_libel32s_sessions.key_crea, 'IYYY-MM-DD HH24:SS') AS date, CASE WHEN klm_libel32s_series.y_publication = TRUE THEN 'x' ELSE NULL END AS publi, CASE WHEN klm_libel32s_series.y_visa = TRUE THEN 'x' ELSE NULL END AS visa, klm_libel32s_series.id_libel32_serie FROM SYSTERRE.klm_libel32s_series JOIN watfall.klm_libel32s_sessions ON watfall.klm_libel32s_sessions.id_libel32_session = watfall.klm_libel32s_series.id_libel32_session JOIN watfall.klm_zygs_slams ON watfall.klm_zygs_slams.id_slam = watfall.klm_libel32s_series.id_slam JOIN dbfilter.klm_slams ON dbfilter.klm_slams.id_slam = watfall.klm_libel32s_series.id_slam JOIN watfall.klm_users_zygs ON watfall.klm_users_zygs.id_zyg = watfall.klm_zygs_slams.id_zyg JOIN watfall.klm_users_droits ON watfall.klm_users_droits.id_user = watfall.klm_users_zygs.id_user JOIN watfall.klm_zygs ON watfall.klm_zygs.id_zyg = watfall.klm_zygs_slams.id_zyg AND watfall.klm_zygs.id_oad = watfall.klm_users_droits.id_oad JOIN dbfilter.klm_ilots ON dbfilter.klm_ilots.id_slam = watfall.klm_libel32s_series.id_slam JOIN dbfilter.klm_genres_ilots ON dbfilter.klm_genres_ilots.id_f = dbfilter.klm_ilots.id_f AND dbfilter.klm_genres_ilots.fafa_num = watfall.klm_libel32s_series.y_getit JOIN dbfilter.klm_genres_ilots AS klm_genres_ilots_1 ON klm_genres_ilots_1.id_f = dbfilter.klm_ilots.id_f JOIN watfall.klm_itk ON watfall.klm_itk.id_itk::double precision = klm_genres_ilots_1.fafa_num WHERE watfall.klm_libel32s_series.pvic = FALSE AND dbfilter.klm_ilots.pvic = FALSE AND dbfilter.klm_ilots.id_type_f = 770 AND dbfilter.klm_slams.pvic = FALSE AND dbfilter.klm_genres_ilots.id_type_genre = 1605 AND klm_genres_ilots_1.id_type_genre = 1609 AND watfall.klm_users_droits.udr_calci = TRUE AND watfall.klm_libel32s_series.y_getit IN() AND watfall.klm_libel32s_series.id_slam IN(891) GROUP BY dbfilter.klm_slams.exp_age, watfall.klm_libel32s_series.id_libel32_serie, watfall.klm_libel32s_series.id_slam, watfall.klm_libel32s_series.y_getit, watfall.klm_libel32s_series.y_publication, watfall.klm_libel32s_series.y_visa, watfall.klm_libel32s_sessions.key_crea ORDER BY dbfilter.klm_slams.exp_age, watfall.klm_libel32s_series.y_getit DESC, watfall.klm_libel32s_series.y_publication, watfall.klm_libel32s_series.y_visa;

207

ERROR: missing FROM-clause entry for table "..."

183

ERROR: relation "..." does not exist

114

ERROR: invalid input syntax for integer: "..."

ERROR: syntax error at end of input

WARNING: nonstandard use of escape in a string literal

ERROR: duplicate key value violates unique constraint "..."

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

ERROR: invalid input syntax for type date: "..."

^ Back to top
Overall statistics
Hourly statistics
Queries by type
Sessions per database
Sessions per user
Sessions per host
Connections per database
Connections per user
Connections 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