pgBadger :: PostgreSQL Log Analyzer

Global information
- Generated on Wed Apr 22 23:50:06 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-Wed.log
- Parsed 11,043 log entries in 5s
- Log start from 2026-04-21 00:00:54 to 2026-04-21 23:59:41

Global Stats

132 Number of unique normalized queries
881 Number of queries
3h35m31s Total query duration
2026-04-21 00:02:04 First query
2026-04-21 23:39:41 Last query
6 queries/s at 2026-04-21 23:39:25 Query peak

3h35m31s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
3h35m31s Execute total duration

1,217 Number of events
6 Number of unique normalized events
1,187 Max number of times the same event was reported
0 Number of cancellation

21 Total number of automatic vacuums
26 Total number of automatic analyzes

338 Number temporary file
468.37 MiB Max size of temporary file
15.80 MiB Average size of temporary file

359 Total number of sessions
7 sessions at 2026-04-21 06:44:04 Session peak
7d18h28m33s Total duration of sessions
31m9s Average duration of sessions
2 Average queries per session
36s21ms Average queries duration per session
30m33s Average idle time per session

370 Total number of connections
4 connections/s at 2026-04-21 03:05:17 Connection peak
3 Total number of databases

SQL Traffic

Key values

6 queries/s Query Peak
2026-04-21 23:39:25 Date

SELECT Traffic

Key values

2 queries/s Query Peak
2026-04-21 10:10:43 Date

INSERT/UPDATE/DELETE Traffic

Key values

6 queries/s Query Peak
2026-04-21 23:39:25 Date

Queries duration

Key values

3h35m31s Total query duration

Prepared queries ratio

Key values

0.00 Ratio of bind vs prepare
0.00 % Ratio between prepared and "usual" statements

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Apr 21	00	24	0ms	4s640ms	1s230ms	1s641ms	1s757ms	17s829ms
	01	18	0ms	1s71ms	564ms	1s287ms	1s741ms	1s931ms
	02	18	0ms	1s127ms	546ms	1s345ms	1s604ms	1s807ms
	03	18	0ms	1s208ms	575ms	1s455ms	1s808ms	1s836ms
	04	19	0ms	1s334ms	585ms	1s384ms	1s833ms	2s260ms
	05	24	0ms	1m50s	13s416ms	2s344ms	57s140ms	1m50s
	06	21	0ms	27m16s	1m52s	2s223ms	49s775ms	27m16s
	07	18	0ms	3m12s	20s41ms	1s554ms	1s678ms	3m40s
	08	22	0ms	3m9s	16s162ms	1s540ms	1s627ms	3m34s
	09	21	0ms	3m5s	16s749ms	1s505ms	1s655ms	3m30s
	10	23	0ms	3m3s	15s190ms	1s501ms	1s704ms	3m28s
	11	22	0ms	3m5s	16s8ms	1s498ms	1s629ms	3m30s
	12	22	0ms	3m4s	15s952ms	1s509ms	1s667ms	3m29s
	13	21	0ms	3m9s	17s6ms	1s537ms	1s618ms	3m35s
	14	22	0ms	3m9s	16s193ms	1s536ms	1s604ms	3m35s
	15	23	0ms	3m6s	15s343ms	1s467ms	1s600ms	3m31s
	16	22	0ms	3m5s	16s85ms	1s520ms	1s733ms	3m30s
	17	23	0ms	3m9s	15s498ms	1s495ms	1s594ms	3m34s
	18	26	0ms	27m16s	1m44s	1s611ms	3m34s	27m16s
	19	23	0ms	3m10s	15s639ms	1s495ms	1s562ms	3m36s
	20	95	0ms	3m11s	7s568ms	53s862ms	1m13s	3m43s
	21	22	0ms	3m5s	16s135ms	1s518ms	1s578ms	3m31s
	22	23	0ms	3m7s	15s408ms	1s532ms	1s682ms	3m31s
	23	311	0ms	1m2s	5s644ms	1m2s	1m7s	1m16s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Apr 21	00	3	0	1s96ms	0ms	0ms	0ms
	01	1	0	215ms	0ms	0ms	0ms
	02	1	0	218ms	0ms	0ms	0ms
	03	0	0	0ms	0ms	0ms	0ms
	04	2	0	228ms	0ms	0ms	180ms
	05	2	0	235ms	0ms	0ms	211ms
	06	6	0	6m32s	0ms	0ms	11m5s
	07	6	0	58s553ms	0ms	0ms	2m10s
	08	6	0	57s518ms	0ms	0ms	2m10s
	09	6	0	56s964ms	0ms	0ms	2m10s
	10	6	0	56s495ms	0ms	0ms	2m10s
	11	6	0	57s24ms	0ms	0ms	2m11s
	12	6	0	56s816ms	0ms	0ms	2m11s
	13	6	0	57s870ms	0ms	0ms	2m11s
	14	6	0	57s683ms	0ms	0ms	2m10s
	15	6	0	57s125ms	0ms	0ms	2m11s
	16	6	0	57s268ms	0ms	0ms	2m12s
	17	6	0	57s733ms	0ms	0ms	2m11s
	18	10	0	4m31s	0ms	160ms	11m19s
	19	6	0	58s240ms	0ms	0ms	2m12s
	20	6	73	8s973ms	0ms	53s862ms	2m12s
	21	6	0	57s495ms	0ms	0ms	2m13s
	22	6	0	57s335ms	0ms	0ms	2m12s
	23	0	311	5s644ms	1m1s	1m2s	1m11s

Day	Hour	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Apr 21	00	0ms	0ms	0ms	0ms
	01	0ms	0ms	0ms	0ms
	02	0ms	0ms	0ms	0ms
	03	0ms	0ms	0ms	0ms
	04	0ms	0ms	0ms	0ms
	05	0ms	0ms	0ms	0ms
	06	0ms	0ms	0ms	0ms
	07	0ms	0ms	0ms	0ms
	08	0ms	0ms	0ms	0ms
	09	0ms	0ms	0ms	0ms
	10	0ms	0ms	0ms	0ms
	11	0ms	0ms	0ms	0ms
	12	0ms	0ms	0ms	0ms
	13	0ms	0ms	0ms	0ms
	14	0ms	0ms	0ms	0ms
	15	0ms	0ms	0ms	0ms
	16	0ms	0ms	0ms	0ms
	17	0ms	0ms	0ms	0ms
	18	0ms	0ms	0ms	0ms
	19	0ms	0ms	0ms	0ms
	20	0ms	0ms	0ms	0ms
	21	0ms	0ms	0ms	0ms
	22	0ms	0ms	0ms	0ms
	23	0ms	0ms	0ms	0ms

Day	Hour	Percentage of prepare
Apr 21	00	0.00%
	01	0.00%
	02	0.00%
	03	0.00%
	04	0.00%
	05	0.00%
	06	0.00%
	07	0.00%
	08	0.00%
	09	0.00%
	10	0.00%
	11	0.00%
	12	0.00%
	13	0.00%
	14	0.00%
	15	0.00%
	16	0.00%
	17	0.00%
	18	0.00%
	19	0.00%
	20	0.00%
	21	0.00%
	22	0.00%
	23	0.00%

Day	Hour	Count	Average / Second
Apr 21	00	21	0.01/s
	01	21	0.01/s
	02	14	0.00/s
	03	21	0.01/s
	04	16	0.00/s
	05	21	0.01/s
	06	19	0.01/s
	07	16	0.00/s
	08	16	0.00/s
	09	13	0.00/s
	10	10	0.00/s
	11	13	0.00/s
	12	15	0.00/s
	13	13	0.00/s
	14	16	0.00/s
	15	13	0.00/s
	16	13	0.00/s
	17	16	0.00/s
	18	17	0.00/s
	19	13	0.00/s
	20	16	0.00/s
	21	12	0.00/s
	22	13	0.00/s
	23	12	0.00/s

Day	Hour	Count	Average Duration	Average idle time
Apr 21	00	14	24m59s	24m56s
	01	23	32m8s	32m8s
	02	14	38m24s	38m24s
	03	23	15m12s	15m11s
	04	14	30m39s	30m38s
	05	15	39m1s	38m39s
	06	16	40m45s	38m17s
	07	21	34m46s	34m28s
	08	16	26m24s	26m1s
	09	14	29m49s	29m24s
	10	9	32m48s	32m10s
	11	10	34m56s	34m21s
	12	15	31m47s	31m24s
	13	13	32m37s	32m10s
	14	15	28m25s	28m1s
	15	14	34m12s	33m47s
	16	13	32m7s	31m39s
	17	14	33m44s	33m19s
	18	16	29m18s	26m28s
	19	12	38m28s	37m58s
	20	16	26m31s	25m46s
	21	13	31m36s	31m8s
	22	11	31m53s	31m21s
	23	18	28m43s	27m6s

↑ Back to the top of the General Activity table

Database	User	Count
brasilia		258
	etiquetas	206
	intelifix	47
	lenon	5
contagem		38
	intelifix	34
	lenon	4
jaboatao		13
	intelifix	13
rio		59
	intelifix	51
	lenon	8
testes		2
	lenon	2

User	Count
etiquetas	206
intelifix	145
lenon	19

Host	Count
127.0.0.1	1
[local]	369

Simultaneous sessions

Key values

7 sessions Session Peak
2026-04-21 06:44:04 Date

Histogram of session times

Key values

157 3600000-28800000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	0	0.00%
500ms-1s	0	0.00%
1s-30s	2	0.56%
30s-1m	2	0.56%
1m-10m	146	40.67%
10m-30m	46	12.81%
30m-1h	6	1.67%
1h-8h	157	43.73%
> 8h	0	0.00%

Sessions per database

Key values

brasilia Main Database
359 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
brasilia	258	4d2m39s	22m20s
contagem	38	1d11h13m17s	55m36s
rio	63	2d7h12m36s	52m34s

Sessions per user

Key values

etiquetas Main User
359 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
etiquetas	206	1d23h40m59s	13m53s
intelifix	134	5d1h29m2s	54m23s
lenon	19	17h18m31s	54m39s

Sessions per host

Key values

[local] Main Host
359 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	1	45m	45m
[local]	358	7d17h43m32s	31m7s

Sessions per application

Key values

[unknown] Main Application
359 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
[unknown]	120	4d13h16m21s	54m38s
app - 177.99.204.34:49173	1	8m26s	8m26s
app - 177.99.204.34:49176	1	1m59s	1m59s
app - 177.99.204.34:49371	1	5m14s	5m14s
app - 177.99.204.34:49431	1	5m12s	5m12s
app - 177.99.204.34:49440	1	14m50s	14m50s
app - 177.99.204.34:49450	1	4m10s	4m10s
app - 177.99.204.34:49523	1	11m35s	11m35s
app - 177.99.204.34:49785	1	8m23s	8m23s
app - 177.99.204.34:49821	1	3m1s	3m1s
app - 177.99.204.34:49893	1	4m10s	4m10s
app - 177.99.204.34:49941	1	2m56s	2m56s
app - 177.99.204.34:50221	1	5m16s	5m16s
app - 177.99.204.34:50239	1	9m26s	9m26s
app - 177.99.204.34:50381	1	6m19s	6m19s
app - 177.99.204.34:50447	1	9m27s	9m27s
app - 177.99.204.34:50496	1	8m23s	8m23s
app - 177.99.204.34:50600	2	1h1m58s	30m59s
app - 177.99.204.34:50688	1	8m25s	8m25s
app - 177.99.204.34:50733	1	14m45s	14m45s
app - 177.99.204.34:50811	1	11m31s	11m31s
app - 177.99.204.34:50837	1	11m33s	11m33s
app - 177.99.204.34:50850	1	12m41s	12m41s
app - 177.99.204.34:50892	1	5m14s	5m14s
app - 177.99.204.34:50904	1	8m24s	8m24s
app - 177.99.204.34:51169	1	9m28s	9m28s
app - 177.99.204.34:51257	1	17m58s	17m58s
app - 177.99.204.34:51653	1	3m8s	3m8s
app - 177.99.204.34:51655	1	5m17s	5m17s
app - 177.99.204.34:51759	1	12m36s	12m36s
app - 177.99.204.34:51842	1	4m9s	4m9s
app - 177.99.204.34:51937	1	4m11s	4m11s
app - 177.99.204.34:52039	1	4m15s	4m15s
app - 177.99.204.34:52153	1	10m32s	10m32s
app - 177.99.204.34:52160	1	4m12s	4m12s
app - 177.99.204.34:52340	1	3m7s	3m7s
app - 177.99.204.34:52465	1	14m41s	14m41s
app - 177.99.204.34:52561	1	3m8s	3m8s
app - 177.99.204.34:52663	2	1h1m58s	30m59s
app - 177.99.204.34:52791	1	15m45s	15m45s
app - 177.99.204.34:53023	1	6m16s	6m16s
app - 177.99.204.34:53258	1	14m48s	14m48s
app - 177.99.204.34:53262	2	1h5m3s	32m31s
app - 177.99.204.34:53278	1	6m18s	6m18s
app - 177.99.204.34:53313	1	9m28s	9m28s
app - 177.99.204.34:53402	1	4m11s	4m11s
app - 177.99.204.34:53406	1	8m25s	8m25s
app - 177.99.204.34:53445	1	30m39s	30m39s
app - 177.99.204.34:53513	1	2m4s	2m4s
app - 177.99.204.34:53566	1	3m7s	3m7s
app - 177.99.204.34:53607	1	7m20s	7m20s
app - 177.99.204.34:53811	1	10m33s	10m33s
app - 177.99.204.34:53854	1	12m38s	12m38s
app - 177.99.204.34:54012	1	10m31s	10m31s
app - 177.99.204.34:54035	1	12m36s	12m36s
app - 177.99.204.34:54281	1	3m8s	3m8s
app - 177.99.204.34:54358	1	6m20s	6m20s
app - 177.99.204.34:54401	1	5m13s	5m13s
app - 177.99.204.34:54443	1	3m6s	3m6s
app - 177.99.204.34:54456	1	13m42s	13m42s
app - 177.99.204.34:54461	1	3m8s	3m8s
app - 177.99.204.34:54488	1	14m45s	14m45s
app - 177.99.204.34:54511	1	8m25s	8m25s
app - 177.99.204.34:54704	1	3m8s	3m8s
app - 177.99.204.34:54742	1	6m18s	6m18s
app - 177.99.204.34:54765	1	1h	1h
app - 177.99.204.34:54839	1	11m36s	11m36s
app - 177.99.204.34:54897	1	9m29s	9m29s
app - 177.99.204.34:55034	1	8m23s	8m23s
app - 177.99.204.34:55201	1	2m4s	2m4s
app - 177.99.204.34:55293	1	14m44s	14m44s
app - 177.99.204.34:55411	1	13m44s	13m44s
app - 177.99.204.34:55494	1	3m7s	3m7s
app - 177.99.204.34:55521	2	1h2m12s	31m6s
app - 177.99.204.34:55530	1	5m13s	5m13s
app - 177.99.204.34:55615	1	6m18s	6m18s
app - 177.99.204.34:55752	1	7m25s	7m25s
app - 177.99.204.34:55805	1	10m37s	10m37s
app - 177.99.204.34:55900	1	1h	1h
app - 177.99.204.34:55901	2	1h44s	30m22s
app - 177.99.204.34:55936	1	7m21s	7m21s
app - 177.99.204.34:55961	1	11m35s	11m35s
app - 177.99.204.34:55991	1	3m8s	3m8s
app - 177.99.204.34:56132	2	1h1m55s	30m57s
app - 177.99.204.34:56190	1	4m10s	4m10s
app - 177.99.204.34:56206	1	6m17s	6m17s
app - 177.99.204.34:56307	1	11m39s	11m39s
app - 177.99.204.34:56312	1	4m11s	4m11s
app - 177.99.204.34:56435	1	10m32s	10m32s
app - 177.99.204.34:56545	1	4m11s	4m11s
app - 177.99.204.34:56557	1	1h	1h
app - 177.99.204.34:56575	1	8m23s	8m23s
app - 177.99.204.34:56851	1	6m17s	6m17s
app - 177.99.204.34:56997	1	6m16s	6m16s
app - 177.99.204.34:57154	1	1h	1h
app - 177.99.204.34:57314	1	1h	1h
app - 177.99.204.34:57372	1	7m20s	7m20s
app - 177.99.204.34:57478	1	18m56s	18m56s
app - 177.99.204.34:57489	1	8s968ms	8s968ms
app - 177.99.204.34:57490	1	4m10s	4m10s
app - 177.99.204.34:57548	1	5m13s	5m13s
app - 177.99.204.34:57585	1	7m19s	7m19s
app - 177.99.204.34:57713	1	2m4s	2m4s
app - 177.99.204.34:57740	1	4m13s	4m13s
app - 177.99.204.34:57886	2	1h1m59s	30m59s
app - 177.99.204.34:57899	1	1h	1h
app - 177.99.204.34:57914	1	9m29s	9m29s
app - 177.99.204.34:58074	1	5m16s	5m16s
app - 177.99.204.34:58427	1	2m4s	2m4s
app - 177.99.204.34:58774	1	7m20s	7m20s
app - 177.99.204.34:58870	1	8m25s	8m25s
app - 177.99.204.34:58877	1	6m16s	6m16s
app - 177.99.204.34:58889	1	5m13s	5m13s
app - 177.99.204.34:58913	1	1h	1h
app - 177.99.204.34:58920	1	1h	1h
app - 177.99.204.34:59010	1	6m18s	6m18s
app - 177.99.204.34:59057	1	6m19s	6m19s
app - 177.99.204.34:59138	1	11m32s	11m32s
app - 177.99.204.34:59144	1	5m13s	5m13s
app - 177.99.204.34:59451	1	2m4s	2m4s
app - 177.99.204.34:59483	1	1h	1h
app - 177.99.204.34:59596	1	1m9s	1m9s
app - 177.99.204.34:59662	1	17m55s	17m55s
app - 177.99.204.34:59703	1	4m12s	4m12s
app - 177.99.204.34:59757	1	20m1s	20m1s
app - 177.99.204.34:59763	1	8m26s	8m26s
app - 177.99.204.34:59781	1	7m21s	7m21s
app - 177.99.204.34:59893	1	2m4s	2m4s
app - 177.99.204.34:60072	1	11m37s	11m37s
app - 177.99.204.34:60090	1	3m7s	3m7s
app - 177.99.204.34:60102	1	7m22s	7m22s
app - 177.99.204.34:60145	2	1h2m16s	31m8s
app - 177.99.204.34:60156	1	6m17s	6m17s
app - 177.99.204.34:60216	1	7m24s	7m24s
app - 177.99.204.34:60230	1	1h	1h
app - 177.99.204.34:60394	1	8m23s	8m23s
app - 177.99.204.34:60418	1	6m39s	6m39s
app - 177.99.204.34:60481	1	10m37s	10m37s
app - 177.99.204.34:60601	1	6m17s	6m17s
app - 177.99.204.34:60666	1	10m26s	10m26s
app - 177.99.204.34:60800	1	6m20s	6m20s
app - 177.99.204.34:60902	1	7m22s	7m22s
app - 177.99.204.34:60908	1	11m34s	11m34s
app - 177.99.204.34:61134	1	5m14s	5m14s
app - 177.99.204.34:61189	1	7m22s	7m22s
app - 177.99.204.34:61201	1	2m4s	2m4s
app - 177.99.204.34:61245	1	1h	1h
app - 177.99.204.34:61270	1	4m19s	4m19s
app - 177.99.204.34:61314	1	4m16s	4m16s
app - 177.99.204.34:61360	1	5m15s	5m15s
app - 177.99.204.34:61375	1	1h	1h
app - 177.99.204.34:61528	1	10m36s	10m36s
app - 177.99.204.34:61543	1	13m42s	13m42s
app - 177.99.204.34:61668	1	12m44s	12m44s
app - 177.99.204.34:61716	1	13m41s	13m41s
app - 177.99.204.34:61748	1	2m	2m
app - 177.99.204.34:61867	1	3m7s	3m7s
app - 177.99.204.34:61921	1	4m19s	4m19s
app - 177.99.204.34:62120	1	4m9s	4m9s
app - 177.99.204.34:62211	1	8m22s	8m22s
app - 177.99.204.34:62219	1	8m26s	8m26s
app - 177.99.204.34:62237	1	1h	1h
app - 177.99.204.34:62318	1	6m19s	6m19s
app - 177.99.204.34:62348	1	2m4s	2m4s
app - 177.99.204.34:62378	1	5m14s	5m14s
app - 177.99.204.34:62462	1	6m17s	6m17s
app - 177.99.204.34:62928	1	3m8s	3m8s
app - 177.99.204.34:62952	1	8m25s	8m25s
app - 177.99.204.34:63036	1	3m8s	3m8s
app - 177.99.204.34:63202	1	18m57s	18m57s
app - 177.99.204.34:63302	1	4m11s	4m11s
app - 177.99.204.34:63309	1	6m24s	6m24s
app - 177.99.204.34:63327	1	6m16s	6m16s
app - 177.99.204.34:63339	1	6m19s	6m19s
app - 177.99.204.34:63407	1	8m22s	8m22s
app - 177.99.204.34:63718	1	7m20s	7m20s
app - 177.99.204.34:64056	1	6m16s	6m16s
app - 177.99.204.34:64059	1	5m13s	5m13s
app - 177.99.204.34:64145	1	7m21s	7m21s
app - 177.99.204.34:64146	1	4m10s	4m10s
app - 177.99.204.34:64197	1	8m22s	8m22s
app - 177.99.204.34:64350	1	2m4s	2m4s
app - 177.99.204.34:64359	1	1h	1h
app - 177.99.204.34:64372	1	2m4s	2m4s
app - 177.99.204.34:64480	1	53m39s	53m39s
app - 177.99.204.34:64577	1	4m11s	4m11s
app - 177.99.204.34:64625	1	10m29s	10m29s
app - 177.99.204.34:64648	1	8m24s	8m24s
app - 177.99.204.34:64772	1	12m38s	12m38s
app - 177.99.204.34:65082	1	2m1s	2m1s
app - 177.99.204.34:65107	1	2m4s	2m4s
app - 177.99.204.34:65340	1	1h	1h
app - 177.99.204.34:65349	1	12m41s	12m41s
app - 177.99.204.34:65396	1	16m58s	16m58s
app - 177.99.204.34:65532	1	4m9s	4m9s
pg_dump	6	35m45s	5m57s
postgres_fdw	1	45m	45m
psql - unix(3837937@a2tech):8963	1	1h1s	1h1s
psql - unix(3839538@a2tech):8963	1	1h	1h
psql - unix(3845569@a2tech):8963	1	1h7m16s	1h7m16s
psql - unix(3846588@a2tech):8963	1	1h3m12s	1h3m12s
psql - unix(3847001@a2tech):8963	1	1h1s	1h1s
psql - unix(3847994@a2tech):8963	1	1h	1h
psql - unix(3848272@a2tech):8963	1	1h3m5s	1h3m5s
psql - unix(3849199@a2tech):8963	1	1h15s	1h15s
psql - unix(3849818@a2tech):8963	1	1h1s	1h1s
psql - unix(3850144@a2tech):8963	1	1h	1h
psql - unix(3850880@a2tech):8963	1	1h6s	1h6s
psql - unix(3851690@a2tech):8963	1	1h	1h
psql - unix(3851763@a2tech):8963	1	1h5s	1h5s
psql - unix(3852628@a2tech):8963	1	1h	1h
psql - unix(3853523@a2tech):8963	1	1h	1h
psql - unix(3853633@a2tech):8963	1	1h	1h
psql - unix(3854214@a2tech):8963	1	1h3m4s	1h3m4s
psql - unix(3855041@a2tech):8963	1	1h2s	1h2s
psql - unix(3855798@a2tech):8963	1	1h	1h
psql - unix(3855965@a2tech):8963	1	1h16s	1h16s
psql - unix(3856154@a2tech):8963	1	1h	1h
psql - unix(3856415@a2tech):8963	1	1h	1h
psql - unix(3856945@a2tech):8963	1	1h3m9s	1h3m9s
psql - unix(3857051@a2tech):8963	1	1h	1h
psql - unix(3857283@a2tech):8963	1	1h	1h
psql - unix(3857960@a2tech):8963	1	1h	1h
psql - unix(3859781@a2tech):8963	1	1h13s	1h13s
psql - unix(3859788@a2tech):8963	1	1h2s	1h2s
psql - unix(3859825@a2tech):8963	1	1h	1h
psql - unix(3860275@a2tech):8963	1	1h	1h

Checkpoints Buffers

Key values

130,774 buffers Checkpoint Peak
2026-04-21 18:39:43 Date
269.982 seconds Highest write time
0.011 seconds Sync time

Checkpoints Wal files

Key values

78 files Wal files usage Peak
2026-04-21 18:39:43 Date

Checkpoints distance

Key values

2,491.27 Mo Distance Peak
2026-04-21 18:39:43 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Apr 21	00	21,268	697.643s	0.029s	697.72s
	01	3,182	316.397s	0.052s	316.475s
	02	1,747	172.641s	0.03s	172.691s
	03	1,669	164.338s	0.035s	164.402s
	04	2,506	249.392s	0.039s	249.458s
	05	8,246	583.129s	0.06s	583.219s
	06	205,643	884.292s	0.025s	884.387s
	07	53	5.219s	0.006s	5.234s
	08	21	2.009s	0.001s	2.013s
	09	20	1.907s	0.002s	1.911s
	10	21	2.007s	0.002s	2.013s
	11	20	1.907s	0.002s	1.914s
	12	20	1.907s	0.002s	1.913s
	13	20	1.907s	0.002s	1.911s
	14	20	1.907s	0.002s	1.912s
	15	21	2.007s	0.002s	2.012s
	16	20	1.907s	0.002s	1.912s
	17	21	2.009s	0.002s	2.015s
	18	201,836	599.412s	0.023s	599.501s
	19	31	3.017s	0.007s	3.04s
	20	239	24.159s	0.006s	24.176s
	21	42	4.016s	0.005s	4.027s
	22	22	2.11s	0.002s	2.117s
	23	21	2.112s	0.004s	2.125s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Apr 21	00	10	0	468	0.001s	0.007s
	01	1	0	754	0.002s	0.009s
	02	1	0	425	0.001s	0.006s
	03	0	1	419	0.002s	0.008s
	04	0	1	580	0.002s	0.008s
	05	0	4	850	0.004s	0.009s
	06	0	125	359	0.001s	0.006s
	07	0	0	11	0.002s	0.003s
	08	0	0	3	0.001s	0.001s
	09	0	0	3	0.001s	0.001s
	10	0	0	3	0.002s	0.001s
	11	0	0	3	0.002s	0.001s
	12	0	0	3	0.002s	0.001s
	13	0	0	3	0.002s	0.001s
	14	0	0	3	0.002s	0.001s
	15	0	0	3	0.002s	0.001s
	16	0	0	3	0.001s	0.001s
	17	0	0	3	0.002s	0.001s
	18	0	121	328	0.001s	0.005s
	19	0	0	10	0.003s	0.003s
	20	0	0	44	0.001s	0.003s
	21	0	0	12	0.002s	0.002s
	22	0	0	4	0.001s	0.001s
	23	0	0	12	0.002s	0.002s

Day	Hour	Avg time (sec)
Apr 21	00	0s
	01	0s
	02	0s
	03	0s
	04	0s
	05	0s
	06	0s
	07	0s
	08	0s
	09	0s
	10	0s
	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s
	22	0s
	23	0s

Day	Hour	Mean distance	Mean estimate
Apr 21	00	22,622.29 kB	79,046.86 kB
	01	2,624.78 kB	36,207.11 kB
	02	2,016.67 kB	17,391.17 kB
	03	1,346.11 kB	4,403.44 kB
	04	2,243.38 kB	4,588.75 kB
	05	7,303.00 kB	28,238.56 kB
	06	340,966.33 kB	441,240.17 kB
	07	76.00 kB	989,915.67 kB
	08	156.00 kB	798,895.00 kB
	09	152.00 kB	719,021.00 kB
	10	156.00 kB	647,134.00 kB
	11	152.00 kB	582,436.00 kB
	12	155.00 kB	524,208.00 kB
	13	151.00 kB	471,802.00 kB
	14	155.00 kB	424,638.00 kB
	15	159.00 kB	382,190.00 kB
	16	155.00 kB	343,986.00 kB
	17	159.00 kB	309,603.00 kB
	18	396,721.40 kB	650,016.80 kB
	19	74.67 kB	990,535.33 kB
	20	516.00 kB	722,207.33 kB
	21	150.50 kB	553,746.00 kB
	22	154.00 kB	472,163.00 kB
	23	10.00 kB	403,701.00 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (82) Main checkpoint cause
83 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	82
shutdown immediate	1
Total	83

Size of temporary files

Key values

503.58 MiB Temp Files size Peak
2026-04-21 18:32:08 Date

Number of temporary files

Key values

28 per second Temp Files Peak
2026-04-21 18:44:27 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Apr 21	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	0	0	0
	04	0	0	0
	05	12	1.10 GiB	94.05 MiB
	06	163	2.06 GiB	12.92 MiB
	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	163	2.06 GiB	12.92 MiB
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0
	23	0	0	0

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	326	4.11 GiB	8.00 KiB	468.37 MiB	12.92 MiB	select * from rs_posicao_oficina_estatica (?); SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); Date: 2026-04-21 06:32:18 Duration: 27m16s Database: rio User: intelifix Remote: [local] Application: psql - unix(3845569@a2tech):8963 SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); Date: 2026-04-21 18:32:19 Duration: 27m16s Database: rio User: intelifix Remote: [local] Application: psql - unix(3855876@a2tech):8963 SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); Date: 2026-04-21 18:43:39 Duration: 11m19s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3856352@a2tech):8963
2	8	852.86 MiB	65.48 MiB	219.52 MiB	106.61 MiB	refresh materialized view concurrently rs_mv_codigos_barra; REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; Date: 2026-04-21 05:31:06 Duration: 44s37ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3844647@a2tech):8963 REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; Date: 2026-04-21 05:31:01 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3844647@a2tech):8963
3	4	275.77 MiB	51.25 MiB	84.35 MiB	68.94 MiB	refresh materialized view concurrently rs_mv_equipamentos; REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; Date: 2026-04-21 05:30:22 Duration: 20s475ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3844641@a2tech):8963 REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; Date: 2026-04-21 05:30:20 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3844641@a2tech):8963

Rank

Count

Total size

Min size

Max size

Avg size

Query

326

4.11 GiB

8.00 KiB

468.37 MiB

12.92 MiB

select * from rs_posicao_oficina_estatica (?);

SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0);

Date: 2026-04-21 06:32:18 Duration: 27m16s Database: rio User: intelifix Remote: [local] Application: psql - unix(3845569@a2tech):8963
SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0);

Date: 2026-04-21 18:32:19 Duration: 27m16s Database: rio User: intelifix Remote: [local] Application: psql - unix(3855876@a2tech):8963
SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0);

Date: 2026-04-21 18:43:39 Duration: 11m19s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3856352@a2tech):8963

852.86 MiB

65.48 MiB

219.52 MiB

106.61 MiB

refresh materialized view concurrently rs_mv_codigos_barra;

REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;

Date: 2026-04-21 05:31:06 Duration: 44s37ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3844647@a2tech):8963
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;

Date: 2026-04-21 05:31:01 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3844647@a2tech):8963

275.77 MiB

51.25 MiB

84.35 MiB

68.94 MiB

refresh materialized view concurrently rs_mv_equipamentos;

REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;

Date: 2026-04-21 05:30:22 Duration: 20s475ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3844641@a2tech):8963
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;

Date: 2026-04-21 05:30:20 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3844641@a2tech):8963

Queries generating the largest temporary files


[ Date: 2026-04-21 06:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3845569@a2tech):8963 ]
[ Date: 2026-04-21 18:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3855876@a2tech):8963 ]
[ Date: 2026-04-21 06:43:18 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3846024@a2tech):8963 ]
[ Date: 2026-04-21 18:43:32 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3856352@a2tech):8963 ]
[ Date: 2026-04-21 05:31:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844647@a2tech):8963 ]
[ Date: 2026-04-21 05:31:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844647@a2tech):8963 ]
[ Date: 2026-04-21 06:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3845569@a2tech):8963 ]
[ Date: 2026-04-21 18:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3855876@a2tech):8963 ]
[ Date: 2026-04-21 06:43:17 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3846024@a2tech):8963 ]
[ Date: 2026-04-21 18:43:31 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3856352@a2tech):8963 ]
[ Date: 2026-04-21 05:30:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844641@a2tech):8963 ]
[ Date: 2026-04-21 05:30:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844641@a2tech):8963 ]
[ Date: 2026-04-21 05:31:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844647@a2tech):8963 ]
[ Date: 2026-04-21 05:31:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844647@a2tech):8963 ]
[ Date: 2026-04-21 05:31:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844647@a2tech):8963 ]
[ Date: 2026-04-21 05:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844647@a2tech):8963 ]
[ Date: 2026-04-21 05:31:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844647@a2tech):8963 ]
[ Date: 2026-04-21 05:31:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844647@a2tech):8963 ]
[ Date: 2026-04-21 06:05:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3845569@a2tech):8963 ]
[ Date: 2026-04-21 18:05:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3855876@a2tech):8963 ]

Rank	Size	Query
1	468.37 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-04-21 06:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3845569@a2tech):8963 ]
2	468.37 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-04-21 18:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3855876@a2tech):8963 ]
3	238.16 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-04-21 06:43:18 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3846024@a2tech):8963 ]
4	238.16 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-04-21 18:43:32 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3856352@a2tech):8963 ]
5	219.52 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-04-21 05:31:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844647@a2tech):8963 ]
6	219.52 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-04-21 05:31:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844647@a2tech):8963 ]
7	167.05 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-04-21 06:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3845569@a2tech):8963 ]
8	167.05 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-04-21 18:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3855876@a2tech):8963 ]
9	94.49 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-04-21 06:43:17 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3846024@a2tech):8963 ]
10	94.49 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-04-21 18:43:31 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3856352@a2tech):8963 ]
11	84.35 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; [ Date: 2026-04-21 05:30:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844641@a2tech):8963 ]
12	84.35 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; [ Date: 2026-04-21 05:30:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844641@a2tech):8963 ]
13	72.48 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-04-21 05:31:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844647@a2tech):8963 ]
14	72.43 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-04-21 05:31:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844647@a2tech):8963 ]
15	72.42 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-04-21 05:31:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844647@a2tech):8963 ]
16	65.53 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-04-21 05:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844647@a2tech):8963 ]
17	65.48 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-04-21 05:31:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844647@a2tech):8963 ]
18	65.48 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-04-21 05:31:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3844647@a2tech):8963 ]
19	60.34 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-04-21 06:05:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3845569@a2tech):8963 ]
20	60.34 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-04-21 18:05:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3855876@a2tech):8963 ]

Vacuums / Analyzes Distribution

Key values

14.79 sec Highest CPU-cost vacuum
Table public.posicao_oficina_21
Database rio
2026-04-21 06:33:19 Date
0 sec Highest CPU-cost analyze
Table
Database rio
Date

Average Autovacuum Duration

Key values

14.79 sec Highest CPU-cost vacuum
Table public.posicao_oficina_21
Database rio
2026-04-21 06:33:19 Date

Analyzes per table

Key values

public.temp0000277806 (9) Main table analyzed (database rio)
26 analyzes Total

Chart
Table

Table	Number of analyzes
rio.public.temp0000277806	9
rio.public.temp0000277812	3
brasilia.public.posicao_oficina_21	2
rio.public.posicao_oficina_21	2
contagem.public.posicao_oficina_21	2
rio.pg_catalog.pg_attribute	1
brasilia.public.posicao_estoque22	1
contagem.public.posicao_estoque20	1
brasilia.public.posicao_estoque21	1
contagem.public.posicao_estoque19	1
rio.pg_catalog.pg_class	1
rio.public.posicao_estoque48	1
rio.public.posicao_estoque47	1
Total	26

Vacuums per table

Key values

public.posicao_oficina_21 (2) Main table vacuumed on database rio
21 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
rio.public.posicao_oficina_21	2	0	260,834	0	126,250	0	0	130,306	4	7,721,206
brasilia.public.posicao_oficina_21	2	0	133,866	0	62,746	0	0	66,770	4	3,972,582
contagem.public.posicao_oficina_21	2	0	6,603	0	8	0	0	3,182	2	204,496
contagem.public.posicao_estoque20	1	0	3,357	0	4	0	0	1,593	1	102,468
brasilia.public.posicao_estoque22	1	0	66,976	0	31,373	0	0	33,386	2	1,986,413
brasilia.pg_toast.pg_toast_2619	1	1	218	0	1	0	0	162	2	25,404
contagem.public.posicao_estoque19	1	0	3,355	0	4	0	0	1,593	1	102,388
brasilia.public.posicao_estoque21	1	0	66,988	0	31,373	0	0	33,386	2	1,986,371
brasilia.pg_catalog.pg_statistic	1	1	2,305	0	2	0	0	2,228	1	153,952
contagem.pg_toast.pg_toast_2619	1	1	202	0	2	0	0	148	3	24,872
brasilia.pg_catalog.pg_rewrite	1	1	72	0	11	0	0	23	10	78,273
rio.pg_catalog.pg_attribute	1	1	2,416	0	425	0	0	869	315	960,116
contagem.pg_catalog.pg_statistic	1	1	2,289	0	3	0	0	2,209	3	153,694
rio.pg_catalog.pg_rewrite	1	1	72	0	12	0	0	25	11	86,555
rio.pg_toast.pg_toast_2619	1	1	834	0	20	0	0	716	13	67,457
rio.pg_catalog.pg_statistic	1	1	2,973	0	21	0	0	2,787	14	209,423
rio.public.posicao_estoque48	1	0	130,446	0	63,125	0	0	65,154	2	3,860,679
rio.public.posicao_estoque47	1	0	130,440	0	63,125	0	0	65,154	2	3,860,677
Total	21	9	814,246	2,415	378,505	0	0	409,691	392	25,557,026

Tuples removed per table

Key values

pg_catalog.pg_statistic (3558) Main table with removed tuples on database rio
12595 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
rio.pg_catalog.pg_statistic	1	1	3,558	7,788	0	0	1,279
brasilia.pg_catalog.pg_statistic	1	1	3,145	7,358	0	0	951
contagem.pg_catalog.pg_statistic	1	1	3,036	7,336	0	0	922
rio.pg_catalog.pg_attribute	1	1	1,907	28,147	0	0	916
rio.pg_toast.pg_toast_2619	1	1	680	675	0	0	282
brasilia.pg_toast.pg_toast_2619	1	1	138	135	0	0	66
contagem.pg_toast.pg_toast_2619	1	1	123	124	0	0	59
brasilia.pg_catalog.pg_rewrite	1	1	4	169	0	0	16
rio.pg_catalog.pg_rewrite	1	1	4	171	0	0	17
contagem.public.posicao_estoque20	1	0	0	28,398	0	0	1,600
brasilia.public.posicao_estoque22	1	0	0	773,115	0	0	33,408
contagem.public.posicao_estoque19	1	0	0	28,398	0	0	1,600
rio.public.posicao_oficina_21	2	0	0	2,631,136	0	0	130,304
brasilia.public.posicao_estoque21	1	0	0	773,115	0	0	33,408
brasilia.public.posicao_oficina_21	2	0	0	1,546,230	0	0	66,816
rio.public.posicao_estoque48	1	0	0	1,315,568	0	0	65,152
rio.public.posicao_estoque47	1	0	0	1,315,568	0	0	65,152
contagem.public.posicao_oficina_21	2	0	0	56,796	0	0	3,200
Total	21	9	12,595	8,520,227	0	0	405,148

Pages removed per table

Key values

unknown (0) Main table with removed pages on database unknown
0 pages Total removed

Chart
Table

Pages removed per tables

NO DATASET

Table	Number of vacuums	Index scans	Tuples removed
contagem.public.posicao_estoque20	1	0	0
brasilia.public.posicao_estoque22	1	0	0
brasilia.pg_toast.pg_toast_2619	1	1	138
contagem.public.posicao_estoque19	1	0	0
rio.public.posicao_oficina_21	2	0	0
brasilia.public.posicao_estoque21	1	0	0
brasilia.pg_catalog.pg_statistic	1	1	3145
contagem.pg_toast.pg_toast_2619	1	1	123
brasilia.public.posicao_oficina_21	2	0	0
brasilia.pg_catalog.pg_rewrite	1	1	4
rio.pg_catalog.pg_attribute	1	1	1907
contagem.pg_catalog.pg_statistic	1	1	3036
rio.pg_catalog.pg_rewrite	1	1	4
rio.pg_toast.pg_toast_2619	1	1	680
rio.pg_catalog.pg_statistic	1	1	3558
rio.public.posicao_estoque48	1	0	0
rio.public.posicao_estoque47	1	0	0
contagem.public.posicao_oficina_21	2	0	0
Total	21	9	12,595

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Apr 21	00	0	0
	01	0	3
	02	0	0
	03	0	0
	04	0	6
	05	6	4
	06	7	6
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	8	7
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0

↑ Back to the top of the Autovacuum Activity table

Type	Object	Count	Total Duration	Average Duration (s)
NO DATASET

Rank	Count	Total time	Min time	Max time	Avg duration	Query
NO DATASET

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

115 Total read queries
384 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	115	13.05%
INSERT	0	0.00%
UPDATE	0	0.00%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	384	43.59%
CTE	0	0.00%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%
OTHERS	382	43.36%

Queries by database

Key values

rio Main database
405 Requests
2h20m29s (rio)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
brasilia	Total	337	1h10m35s
	copy to	139	9m2s
	others	162	1m58s
	select	36	59m34s
contagem	Total	139	4m26s
	copy to	100	1m28s
	others	3	1m3s
	select	36	1m53s
rio	Total	405	2h20m29s
	copy to	145	24m43s
	others	217	6m24s
	select	43	1h49m21s

Queries by user

Key values

intelifix Main user
875 Requests

Queries Chart
Table

User	Request type	Count	Duration
intelifix	Total	875	3h35m24s
	copy to	384	35m14s
	others	382	9m26s
	select	109	2h50m43s
lenon	Total	6	6s886ms
	select	6	6s886ms

Duration by user

Key values

3h35m24s (intelifix) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
intelifix	Total	875	3h35m24s
	copy to	384	35m14s
	others	382	9m26s
	select	109	2h50m43s
lenon	Total	6	6s886ms
	select	6	6s886ms

Queries by host

Key values

[local] Main host
881 Requests
3h35m31s ([local])
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
[local]	Total	881	3h35m31s
	copy to	384	35m14s
	others	382	9m26s
	select	115	2h50m50s

Queries by application

Key values

pg_dump Main application
384 Requests
35m14s (pg_dump)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
app - 127.0.0.1:33856	Total	1	180ms
	select	1	180ms
app - 127.0.0.1:39288	Total	1	215ms
	select	1	215ms
app - 127.0.0.1:51180	Total	1	259ms
	select	1	259ms
app - 127.0.0.1:54406	Total	1	218ms
	select	1	218ms
app - 127.0.0.1:55644	Total	1	211ms
	select	1	211ms
app - 127.0.0.1:55882	Total	1	277ms
	select	1	277ms
pg_dump	Total	384	35m14s
	copy to	384	35m14s
psql - unix(3832110@a2tech):8963	Total	1	2s179ms
	select	1	2s179ms
psql - unix(3832112@a2tech):8963	Total	1	813ms
	select	1	813ms
psql - unix(3832115@a2tech):8963	Total	1	297ms
	select	1	297ms
psql - unix(3832217@a2tech):8963	Total	1	3s275ms
	others	1	3s275ms
psql - unix(3832221@a2tech):8963	Total	1	4s640ms
	others	1	4s640ms
psql - unix(3832227@a2tech):8963	Total	1	1s386ms
	others	1	1s386ms
psql - unix(3832232@a2tech):8963	Total	1	3s703ms
	others	1	3s703ms
psql - unix(3832238@a2tech):8963	Total	1	357ms
	others	1	357ms
psql - unix(3832254@a2tech):8963	Total	1	4s464ms
	others	1	4s464ms
psql - unix(3832404@a2tech):8963	Total	1	454ms
	others	1	454ms
psql - unix(3832408@a2tech):8963	Total	1	1s5ms
	others	1	1s5ms
psql - unix(3832416@a2tech):8963	Total	1	243ms
	others	1	243ms
psql - unix(3832543@a2tech):8963	Total	1	314ms
	others	1	314ms
psql - unix(3832546@a2tech):8963	Total	1	1s38ms
	others	1	1s38ms
psql - unix(3832555@a2tech):8963	Total	1	207ms
	others	1	207ms
psql - unix(3832719@a2tech):8963	Total	1	506ms
	others	1	506ms
psql - unix(3832725@a2tech):8963	Total	1	1s53ms
	others	1	1s53ms
psql - unix(3832735@a2tech):8963	Total	1	196ms
	others	1	196ms
psql - unix(3832870@a2tech):8963	Total	1	394ms
	others	1	394ms
psql - unix(3832874@a2tech):8963	Total	1	1s39ms
	others	1	1s39ms
psql - unix(3832883@a2tech):8963	Total	1	206ms
	others	1	206ms
psql - unix(3833023@a2tech):8963	Total	1	501ms
	others	1	501ms
psql - unix(3833027@a2tech):8963	Total	1	1s60ms
	others	1	1s60ms
psql - unix(3833036@a2tech):8963	Total	1	194ms
	others	1	194ms
psql - unix(3833231@a2tech):8963	Total	1	670ms
	others	1	670ms
psql - unix(3833237@a2tech):8963	Total	1	1s57ms
	others	1	1s57ms
psql - unix(3833246@a2tech):8963	Total	1	202ms
	others	1	202ms
psql - unix(3833471@a2tech):8963	Total	1	1s36ms
	others	1	1s36ms
psql - unix(3833480@a2tech):8963	Total	1	251ms
	others	1	251ms
psql - unix(3834597@a2tech):8963	Total	1	484ms
	others	1	484ms
psql - unix(3834600@a2tech):8963	Total	1	1s10ms
	others	1	1s10ms
psql - unix(3834611@a2tech):8963	Total	1	246ms
	others	1	246ms
psql - unix(3836054@a2tech):8963	Total	1	228ms
	others	1	228ms
psql - unix(3836060@a2tech):8963	Total	1	1s34ms
	others	1	1s34ms
psql - unix(3836078@a2tech):8963	Total	1	201ms
	others	1	201ms
psql - unix(3836909@a2tech):8963	Total	1	317ms
	others	1	317ms
psql - unix(3836913@a2tech):8963	Total	1	1s71ms
	others	1	1s71ms
psql - unix(3836922@a2tech):8963	Total	1	211ms
	others	1	211ms
psql - unix(3837075@a2tech):8963	Total	1	657ms
	others	1	657ms
psql - unix(3837079@a2tech):8963	Total	1	1s58ms
	others	1	1s58ms
psql - unix(3837088@a2tech):8963	Total	1	201ms
	others	1	201ms
psql - unix(3837232@a2tech):8963	Total	1	271ms
	others	1	271ms
psql - unix(3837237@a2tech):8963	Total	1	1s51ms
	others	1	1s51ms
psql - unix(3837248@a2tech):8963	Total	1	199ms
	others	1	199ms
psql - unix(3837376@a2tech):8963	Total	1	426ms
	others	1	426ms
psql - unix(3837379@a2tech):8963	Total	1	1s125ms
	others	1	1s125ms
psql - unix(3837388@a2tech):8963	Total	1	256ms
	others	1	256ms
psql - unix(3837508@a2tech):8963	Total	1	260ms
	others	1	260ms
psql - unix(3837511@a2tech):8963	Total	1	1s26ms
	others	1	1s26ms
psql - unix(3837519@a2tech):8963	Total	1	249ms
	others	1	249ms
psql - unix(3837642@a2tech):8963	Total	1	1s127ms
	others	1	1s127ms
psql - unix(3837652@a2tech):8963	Total	1	217ms
	others	1	217ms
psql - unix(3837800@a2tech):8963	Total	1	563ms
	others	1	563ms
psql - unix(3837804@a2tech):8963	Total	1	1s26ms
	others	1	1s26ms
psql - unix(3837813@a2tech):8963	Total	1	210ms
	others	1	210ms
psql - unix(3837934@a2tech):8963	Total	1	282ms
	others	1	282ms
psql - unix(3837937@a2tech):8963	Total	1	1s93ms
	others	1	1s93ms
psql - unix(3837945@a2tech):8963	Total	1	228ms
	others	1	228ms
psql - unix(3838422@a2tech):8963	Total	1	503ms
	others	1	503ms
psql - unix(3838470@a2tech):8963	Total	1	1s75ms
	others	1	1s75ms
psql - unix(3838481@a2tech):8963	Total	1	257ms
	others	1	257ms
psql - unix(3838607@a2tech):8963	Total	1	332ms
	others	1	332ms
psql - unix(3838612@a2tech):8963	Total	1	1s197ms
	others	1	1s197ms
psql - unix(3838622@a2tech):8963	Total	1	282ms
	others	1	282ms
psql - unix(3838740@a2tech):8963	Total	1	178ms
	others	1	178ms
psql - unix(3838743@a2tech):8963	Total	1	1s19ms
	others	1	1s19ms
psql - unix(3838752@a2tech):8963	Total	1	257ms
	others	1	257ms
psql - unix(3838904@a2tech):8963	Total	1	473ms
	others	1	473ms
psql - unix(3838911@a2tech):8963	Total	1	1s83ms
	others	1	1s83ms
psql - unix(3838919@a2tech):8963	Total	1	250ms
	others	1	250ms
psql - unix(3839057@a2tech):8963	Total	1	336ms
	others	1	336ms
psql - unix(3839060@a2tech):8963	Total	1	1s208ms
	others	1	1s208ms
psql - unix(3839069@a2tech):8963	Total	1	228ms
	others	1	228ms
psql - unix(3839202@a2tech):8963	Total	1	323ms
	others	1	323ms
psql - unix(3839205@a2tech):8963	Total	1	1s138ms
	others	1	1s138ms
psql - unix(3839214@a2tech):8963	Total	1	202ms
	others	1	202ms
psql - unix(3839375@a2tech):8963	Total	1	563ms
	others	1	563ms
psql - unix(3839381@a2tech):8963	Total	1	1s334ms
	others	1	1s334ms
psql - unix(3839390@a2tech):8963	Total	1	217ms
	others	1	217ms
psql - unix(3839518@a2tech):8963	Total	1	246ms
	others	1	246ms
psql - unix(3839522@a2tech):8963	Total	1	1s209ms
	others	1	1s209ms
psql - unix(3839532@a2tech):8963	Total	1	196ms
	others	1	196ms
psql - unix(3840279@a2tech):8963	Total	1	646ms
	others	1	646ms
psql - unix(3840286@a2tech):8963	Total	1	1s179ms
	others	1	1s179ms
psql - unix(3840321@a2tech):8963	Total	1	253ms
	others	1	253ms
psql - unix(3841468@a2tech):8963	Total	1	154ms
	others	1	154ms
psql - unix(3841472@a2tech):8963	Total	1	1s213ms
	others	1	1s213ms
psql - unix(3841484@a2tech):8963	Total	1	243ms
	others	1	243ms
psql - unix(3841619@a2tech):8963	Total	1	438ms
	others	1	438ms
psql - unix(3841622@a2tech):8963	Total	1	1s177ms
	others	1	1s177ms
psql - unix(3841631@a2tech):8963	Total	1	216ms
	others	1	216ms
psql - unix(3841756@a2tech):8963	Total	1	1s169ms
	others	1	1s169ms
psql - unix(3841765@a2tech):8963	Total	1	215ms
	others	1	215ms
psql - unix(3842114@a2tech):8963	Total	1	1m50s
	others	1	1m50s
psql - unix(3842225@a2tech):8963	Total	1	1m17s
	others	1	1m17s
psql - unix(3842464@a2tech):8963	Total	1	57s140ms
	others	1	57s140ms
psql - unix(3842699@a2tech):8963	Total	1	885ms
	others	1	885ms
psql - unix(3842706@a2tech):8963	Total	1	1s249ms
	others	1	1s249ms
psql - unix(3842716@a2tech):8963	Total	1	209ms
	others	1	209ms
psql - unix(3844013@a2tech):8963	Total	1	892ms
	others	1	892ms
psql - unix(3844039@a2tech):8963	Total	1	1s201ms
	others	1	1s201ms
psql - unix(3844048@a2tech):8963	Total	1	199ms
	others	1	199ms
psql - unix(3844536@a2tech):8963	Total	1	251ms
	others	1	251ms
psql - unix(3844540@a2tech):8963	Total	1	1s202ms
	others	1	1s202ms
psql - unix(3844549@a2tech):8963	Total	1	250ms
	others	1	250ms
psql - unix(3844641@a2tech):8963	Total	1	20s475ms
	others	1	20s475ms
psql - unix(3844647@a2tech):8963	Total	1	44s37ms
	others	1	44s37ms
psql - unix(3844887@a2tech):8963	Total	1	433ms
	others	1	433ms
psql - unix(3844893@a2tech):8963	Total	1	1s243ms
	others	1	1s243ms
psql - unix(3844903@a2tech):8963	Total	1	205ms
	others	1	205ms
psql - unix(3845154@a2tech):8963	Total	1	316ms
	others	1	316ms
psql - unix(3845157@a2tech):8963	Total	1	1s261ms
	others	1	1s261ms
psql - unix(3845165@a2tech):8963	Total	1	248ms
	others	1	248ms
psql - unix(3845374@a2tech):8963	Total	1	1s298ms
	others	1	1s298ms
psql - unix(3845382@a2tech):8963	Total	1	206ms
	others	1	206ms
psql - unix(3845498@a2tech):8963	Total	1	2s285ms
	select	1	2s285ms
psql - unix(3845499@a2tech):8963	Total	1	908ms
	select	1	908ms
psql - unix(3845503@a2tech):8963	Total	1	402ms
	select	1	402ms
psql - unix(3845569@a2tech):8963	Total	1	27m16s
	select	1	27m16s
psql - unix(3845599@a2tech):8963	Total	1	1s420ms
	others	1	1s420ms
psql - unix(3845600@a2tech):8963	Total	1	2s452ms
	others	1	2s452ms
psql - unix(3845611@a2tech):8963	Total	1	201ms
	others	1	201ms
psql - unix(3845624@a2tech):8963	Total	1	1s952ms
	others	1	1s952ms
psql - unix(3845629@a2tech):8963	Total	1	2s99ms
	others	1	2s99ms
psql - unix(3845744@a2tech):8963	Total	1	1s910ms
	others	1	1s910ms
psql - unix(3845752@a2tech):8963	Total	1	313ms
	others	1	313ms
psql - unix(3845877@a2tech):8963	Total	1	1s313ms
	others	1	1s313ms
psql - unix(3845885@a2tech):8963	Total	1	212ms
	others	1	212ms
psql - unix(3846024@a2tech):8963	Total	1	11m5s
	select	1	11m5s
psql - unix(3846082@a2tech):8963	Total	1	1s325ms
	others	1	1s325ms
psql - unix(3846094@a2tech):8963	Total	1	206ms
	others	1	206ms
psql - unix(3846236@a2tech):8963	Total	1	49s775ms
	select	1	49s775ms
psql - unix(3846315@a2tech):8963	Total	1	1s321ms
	others	1	1s321ms
psql - unix(3846323@a2tech):8963	Total	1	247ms
	others	1	247ms
psql - unix(3846433@a2tech):8963	Total	1	1s261ms
	others	1	1s261ms
psql - unix(3846441@a2tech):8963	Total	1	199ms
	others	1	199ms
psql - unix(3846588@a2tech):8963	Total	1	3m12s
	select	1	3m12s
psql - unix(3846596@a2tech):8963	Total	1	1s462ms
	others	1	1s462ms
psql - unix(3846607@a2tech):8963	Total	1	215ms
	others	1	215ms
psql - unix(3846650@a2tech):8963	Total	1	19s584ms
	select	1	19s584ms
psql - unix(3846659@a2tech):8963	Total	1	8s498ms
	select	1	8s498ms
psql - unix(3846663@a2tech):8963	Total	1	2m9s
	select	1	2m9s
psql - unix(3846688@a2tech):8963	Total	1	670ms
	select	1	670ms
psql - unix(3846692@a2tech):8963	Total	1	376ms
	select	1	376ms
psql - unix(3846746@a2tech):8963	Total	1	1s297ms
	others	1	1s297ms
psql - unix(3846754@a2tech):8963	Total	1	196ms
	others	1	196ms
psql - unix(3846868@a2tech):8963	Total	1	1s278ms
	others	1	1s278ms
psql - unix(3846876@a2tech):8963	Total	1	199ms
	others	1	199ms
psql - unix(3847001@a2tech):8963	Total	1	1s373ms
	others	1	1s373ms
psql - unix(3847012@a2tech):8963	Total	1	248ms
	others	1	248ms
psql - unix(3847128@a2tech):8963	Total	1	1s266ms
	others	1	1s266ms
psql - unix(3847137@a2tech):8963	Total	1	287ms
	others	1	287ms
psql - unix(3847257@a2tech):8963	Total	1	1s360ms
	others	1	1s360ms
psql - unix(3847265@a2tech):8963	Total	1	248ms
	others	1	248ms
psql - unix(3847329@a2tech):8963	Total	1	504ms
	others	1	504ms
psql - unix(3847331@a2tech):8963	Total	1	231ms
	others	1	231ms
psql - unix(3847405@a2tech):8963	Total	1	3m9s
	select	1	3m9s
psql - unix(3847416@a2tech):8963	Total	1	1s394ms
	others	1	1s394ms
psql - unix(3847427@a2tech):8963	Total	1	207ms
	others	1	207ms
psql - unix(3847473@a2tech):8963	Total	1	17s577ms
	select	1	17s577ms
psql - unix(3847481@a2tech):8963	Total	1	8s157ms
	select	1	8s157ms
psql - unix(3847484@a2tech):8963	Total	1	2m9s
	select	1	2m9s
psql - unix(3847510@a2tech):8963	Total	1	526ms
	select	1	526ms
psql - unix(3847514@a2tech):8963	Total	1	335ms
	select	1	335ms
psql - unix(3847604@a2tech):8963	Total	1	1s344ms
	others	1	1s344ms
psql - unix(3847612@a2tech):8963	Total	1	196ms
	others	1	196ms
psql - unix(3847675@a2tech):8963	Total	1	245ms
	others	1	245ms
psql - unix(3847732@a2tech):8963	Total	1	1s299ms
	others	1	1s299ms
psql - unix(3847740@a2tech):8963	Total	1	190ms
	others	1	190ms
psql - unix(3847857@a2tech):8963	Total	1	1s347ms
	others	1	1s347ms
psql - unix(3847867@a2tech):8963	Total	1	199ms
	others	1	199ms
psql - unix(3847933@a2tech):8963	Total	1	152ms
	others	1	152ms
psql - unix(3847994@a2tech):8963	Total	1	1s316ms
	others	1	1s316ms
psql - unix(3848002@a2tech):8963	Total	1	196ms
	others	1	196ms
psql - unix(3848112@a2tech):8963	Total	1	1s370ms
	others	1	1s370ms
psql - unix(3848122@a2tech):8963	Total	1	256ms
	others	1	256ms
psql - unix(3848185@a2tech):8963	Total	1	274ms
	others	1	274ms
psql - unix(3848190@a2tech):8963	Total	1	243ms
	others	1	243ms
psql - unix(3848272@a2tech):8963	Total	1	3m5s
	select	1	3m5s
psql - unix(3848275@a2tech):8963	Total	1	1s408ms
	others	1	1s408ms
psql - unix(3848286@a2tech):8963	Total	1	247ms
	others	1	247ms
psql - unix(3848335@a2tech):8963	Total	1	17s294ms
	select	1	17s294ms
psql - unix(3848342@a2tech):8963	Total	1	8s209ms
	select	1	8s209ms
psql - unix(3848347@a2tech):8963	Total	1	2m9s
	select	1	2m9s
psql - unix(3848370@a2tech):8963	Total	1	519ms
	select	1	519ms
psql - unix(3848374@a2tech):8963	Total	1	328ms
	select	1	328ms
psql - unix(3848430@a2tech):8963	Total	1	1s362ms
	others	1	1s362ms
psql - unix(3848438@a2tech):8963	Total	1	201ms
	others	1	201ms
psql - unix(3848507@a2tech):8963	Total	1	244ms
	others	1	244ms
psql - unix(3848578@a2tech):8963	Total	1	1s275ms
	others	1	1s275ms
psql - unix(3848586@a2tech):8963	Total	1	195ms
	others	1	195ms
psql - unix(3848719@a2tech):8963	Total	1	1s313ms
	others	1	1s313ms
psql - unix(3848730@a2tech):8963	Total	1	212ms
	others	1	212ms
psql - unix(3848856@a2tech):8963	Total	1	1s271ms
	others	1	1s271ms
psql - unix(3848864@a2tech):8963	Total	1	193ms
	others	1	193ms
psql - unix(3848980@a2tech):8963	Total	1	1s309ms
	others	1	1s309ms
psql - unix(3848989@a2tech):8963	Total	1	196ms
	others	1	196ms
psql - unix(3849050@a2tech):8963	Total	1	251ms
	others	1	251ms
psql - unix(3849054@a2tech):8963	Total	1	251ms
	others	1	251ms
psql - unix(3849141@a2tech):8963	Total	1	3m3s
	select	1	3m3s
psql - unix(3849145@a2tech):8963	Total	1	1s420ms
	others	1	1s420ms
psql - unix(3849156@a2tech):8963	Total	1	283ms
	others	1	283ms
psql - unix(3849199@a2tech):8963	Total	1	17s85ms
	select	1	17s85ms
psql - unix(3849206@a2tech):8963	Total	1	8s221ms
	select	1	8s221ms
psql - unix(3849211@a2tech):8963	Total	1	2m9s
	select	1	2m9s
psql - unix(3849235@a2tech):8963	Total	1	523ms
	select	1	523ms
psql - unix(3849239@a2tech):8963	Total	1	350ms
	select	1	350ms
psql - unix(3849303@a2tech):8963	Total	1	1s260ms
	others	1	1s260ms
psql - unix(3849312@a2tech):8963	Total	1	206ms
	others	1	206ms
psql - unix(3849370@a2tech):8963	Total	1	234ms
	others	1	234ms
psql - unix(3849374@a2tech):8963	Total	1	209ms
	others	1	209ms
psql - unix(3849428@a2tech):8963	Total	1	1s275ms
	others	1	1s275ms
psql - unix(3849436@a2tech):8963	Total	1	201ms
	others	1	201ms
psql - unix(3849559@a2tech):8963	Total	1	1s418ms
	others	1	1s418ms
psql - unix(3849570@a2tech):8963	Total	1	198ms
	others	1	198ms
psql - unix(3849629@a2tech):8963	Total	1	157ms
	others	1	157ms
psql - unix(3849696@a2tech):8963	Total	1	1s343ms
	others	1	1s343ms
psql - unix(3849704@a2tech):8963	Total	1	198ms
	others	1	198ms
psql - unix(3849818@a2tech):8963	Total	1	1s307ms
	others	1	1s307ms
psql - unix(3849826@a2tech):8963	Total	1	194ms
	others	1	194ms
psql - unix(3849890@a2tech):8963	Total	1	255ms
	others	1	255ms
psql - unix(3849979@a2tech):8963	Total	1	1s387ms
	others	1	1s387ms
psql - unix(3849980@a2tech):8963	Total	1	3m5s
	select	1	3m5s
psql - unix(3849992@a2tech):8963	Total	1	241ms
	others	1	241ms
psql - unix(3850042@a2tech):8963	Total	1	17s419ms
	select	1	17s419ms
psql - unix(3850050@a2tech):8963	Total	1	8s76ms
	select	1	8s76ms
psql - unix(3850055@a2tech):8963	Total	1	2m10s
	select	1	2m10s
psql - unix(3850083@a2tech):8963	Total	1	531ms
	select	1	531ms
psql - unix(3850088@a2tech):8963	Total	1	360ms
	select	1	360ms
psql - unix(3850144@a2tech):8963	Total	1	1s302ms
	others	1	1s302ms
psql - unix(3850152@a2tech):8963	Total	1	195ms
	others	1	195ms
psql - unix(3850213@a2tech):8963	Total	1	239ms
	others	1	239ms
psql - unix(3850216@a2tech):8963	Total	1	199ms
	others	1	199ms
psql - unix(3850277@a2tech):8963	Total	1	1s265ms
	others	1	1s265ms
psql - unix(3850285@a2tech):8963	Total	1	196ms
	others	1	196ms
psql - unix(3850399@a2tech):8963	Total	1	1s307ms
	others	1	1s307ms
psql - unix(3850410@a2tech):8963	Total	1	193ms
	others	1	193ms
psql - unix(3850472@a2tech):8963	Total	1	261ms
	others	1	261ms
psql - unix(3850541@a2tech):8963	Total	1	1s269ms
	others	1	1s269ms
psql - unix(3850549@a2tech):8963	Total	1	203ms
	others	1	203ms
psql - unix(3850660@a2tech):8963	Total	1	1s310ms
	others	1	1s310ms
psql - unix(3850668@a2tech):8963	Total	1	206ms
	others	1	206ms
psql - unix(3850729@a2tech):8963	Total	1	156ms
	others	1	156ms
psql - unix(3850812@a2tech):8963	Total	1	3m4s
	select	1	3m4s
psql - unix(3850816@a2tech):8963	Total	1	1s408ms
	others	1	1s408ms
psql - unix(3850828@a2tech):8963	Total	1	259ms
	others	1	259ms
psql - unix(3850872@a2tech):8963	Total	1	17s361ms
	select	1	17s361ms
psql - unix(3850880@a2tech):8963	Total	1	8s224ms
	select	1	8s224ms
psql - unix(3850884@a2tech):8963	Total	1	2m10s
	select	1	2m10s
psql - unix(3850910@a2tech):8963	Total	1	473ms
	select	1	473ms
psql - unix(3850913@a2tech):8963	Total	1	306ms
	select	1	306ms
psql - unix(3850971@a2tech):8963	Total	1	1s260ms
	others	1	1s260ms
psql - unix(3850979@a2tech):8963	Total	1	223ms
	others	1	223ms
psql - unix(3851091@a2tech):8963	Total	1	265ms
	others	1	265ms
psql - unix(3851094@a2tech):8963	Total	1	216ms
	others	1	216ms
psql - unix(3851149@a2tech):8963	Total	1	1s322ms
	others	1	1s322ms
psql - unix(3851157@a2tech):8963	Total	1	204ms
	others	1	204ms
psql - unix(3851278@a2tech):8963	Total	1	1s301ms
	others	1	1s301ms
psql - unix(3851289@a2tech):8963	Total	1	207ms
	others	1	207ms
psql - unix(3851357@a2tech):8963	Total	1	254ms
	others	1	254ms
psql - unix(3851422@a2tech):8963	Total	1	1s335ms
	others	1	1s335ms
psql - unix(3851430@a2tech):8963	Total	1	195ms
	others	1	195ms
psql - unix(3851544@a2tech):8963	Total	1	1s257ms
	others	1	1s257ms
psql - unix(3851552@a2tech):8963	Total	1	193ms
	others	1	193ms
psql - unix(3851696@a2tech):8963	Total	1	3m9s
	select	1	3m9s
psql - unix(3851700@a2tech):8963	Total	1	1s371ms
	others	1	1s371ms
psql - unix(3851711@a2tech):8963	Total	1	247ms
	others	1	247ms
psql - unix(3851754@a2tech):8963	Total	1	17s423ms
	select	1	17s423ms
psql - unix(3851763@a2tech):8963	Total	1	8s287ms
	select	1	8s287ms
psql - unix(3851768@a2tech):8963	Total	1	2m11s
	select	1	2m11s
psql - unix(3851793@a2tech):8963	Total	1	537ms
	select	1	537ms
psql - unix(3851797@a2tech):8963	Total	1	338ms
	select	1	338ms
psql - unix(3851853@a2tech):8963	Total	1	1s320ms
	others	1	1s320ms
psql - unix(3851861@a2tech):8963	Total	1	227ms
	others	1	227ms
psql - unix(3851924@a2tech):8963	Total	1	225ms
	others	1	225ms
psql - unix(3851928@a2tech):8963	Total	1	214ms
	others	1	214ms
psql - unix(3851985@a2tech):8963	Total	1	1s337ms
	others	1	1s337ms
psql - unix(3851994@a2tech):8963	Total	1	199ms
	others	1	199ms
psql - unix(3852115@a2tech):8963	Total	1	1s358ms
	others	1	1s358ms
psql - unix(3852126@a2tech):8963	Total	1	200ms
	others	1	200ms
psql - unix(3852188@a2tech):8963	Total	1	254ms
	others	1	254ms
psql - unix(3852250@a2tech):8963	Total	1	1s293ms
	others	1	1s293ms
psql - unix(3852258@a2tech):8963	Total	1	196ms
	others	1	196ms
psql - unix(3852373@a2tech):8963	Total	1	1s272ms
	others	1	1s272ms
psql - unix(3852381@a2tech):8963	Total	1	195ms
	others	1	195ms
psql - unix(3852446@a2tech):8963	Total	1	152ms
	others	1	152ms
psql - unix(3852525@a2tech):8963	Total	1	3m9s
	select	1	3m9s
psql - unix(3852531@a2tech):8963	Total	1	1s340ms
	others	1	1s340ms
psql - unix(3852542@a2tech):8963	Total	1	195ms
	others	1	195ms
psql - unix(3852586@a2tech):8963	Total	1	17s488ms
	select	1	17s488ms
psql - unix(3852594@a2tech):8963	Total	1	8s213ms
	select	1	8s213ms
psql - unix(3852599@a2tech):8963	Total	1	2m9s
	select	1	2m9s
psql - unix(3852624@a2tech):8963	Total	1	534ms
	select	1	534ms
psql - unix(3852628@a2tech):8963	Total	1	336ms
	select	1	336ms
psql - unix(3852684@a2tech):8963	Total	1	1s351ms
	others	1	1s351ms
psql - unix(3852692@a2tech):8963	Total	1	252ms
	others	1	252ms
psql - unix(3852752@a2tech):8963	Total	1	237ms
	others	1	237ms
psql - unix(3852756@a2tech):8963	Total	1	238ms
	others	1	238ms
psql - unix(3852814@a2tech):8963	Total	1	1s286ms
	others	1	1s286ms
psql - unix(3852823@a2tech):8963	Total	1	245ms
	others	1	245ms
psql - unix(3852939@a2tech):8963	Total	1	1s348ms
	others	1	1s348ms
psql - unix(3852950@a2tech):8963	Total	1	203ms
	others	1	203ms
psql - unix(3853012@a2tech):8963	Total	1	252ms
	others	1	252ms
psql - unix(3853079@a2tech):8963	Total	1	1s357ms
	others	1	1s357ms
psql - unix(3853087@a2tech):8963	Total	1	224ms
	others	1	224ms
psql - unix(3853200@a2tech):8963	Total	1	1s254ms
	others	1	1s254ms
psql - unix(3853208@a2tech):8963	Total	1	206ms
	others	1	206ms
psql - unix(3853272@a2tech):8963	Total	1	155ms
	others	1	155ms
psql - unix(3853349@a2tech):8963	Total	1	3m6s
	select	1	3m6s
psql - unix(3853357@a2tech):8963	Total	1	1s397ms
	others	1	1s397ms
psql - unix(3853369@a2tech):8963	Total	1	203ms
	others	1	203ms
psql - unix(3853409@a2tech):8963	Total	1	17s133ms
	select	1	17s133ms
psql - unix(3853418@a2tech):8963	Total	1	8s325ms
	select	1	8s325ms
psql - unix(3853423@a2tech):8963	Total	1	2m10s
	select	1	2m10s
psql - unix(3853450@a2tech):8963	Total	1	524ms
	select	1	524ms
psql - unix(3853453@a2tech):8963	Total	1	345ms
	select	1	345ms
psql - unix(3853507@a2tech):8963	Total	1	1s273ms
	others	1	1s273ms
psql - unix(3853515@a2tech):8963	Total	1	194ms
	others	1	194ms
psql - unix(3853573@a2tech):8963	Total	1	170ms
	others	1	170ms
psql - unix(3853575@a2tech):8963	Total	1	245ms
	others	1	245ms
psql - unix(3853633@a2tech):8963	Total	1	1s319ms
	others	1	1s319ms
psql - unix(3853644@a2tech):8963	Total	1	274ms
	others	1	274ms
psql - unix(3853762@a2tech):8963	Total	1	1s331ms
	others	1	1s331ms
psql - unix(3853773@a2tech):8963	Total	1	199ms
	others	1	199ms
psql - unix(3853833@a2tech):8963	Total	1	233ms
	others	1	233ms
psql - unix(3853835@a2tech):8963	Total	1	219ms
	others	1	219ms
psql - unix(3853892@a2tech):8963	Total	1	1s268ms
	others	1	1s268ms
psql - unix(3853900@a2tech):8963	Total	1	198ms
	others	1	198ms
psql - unix(3854013@a2tech):8963	Total	1	1s269ms
	others	1	1s269ms
psql - unix(3854021@a2tech):8963	Total	1	193ms
	others	1	193ms
psql - unix(3854129@a2tech):8963	Total	1	158ms
	others	1	158ms
psql - unix(3854211@a2tech):8963	Total	1	1s528ms
	others	1	1s528ms
psql - unix(3854214@a2tech):8963	Total	1	3m5s
	select	1	3m5s
psql - unix(3854225@a2tech):8963	Total	1	204ms
	others	1	204ms
psql - unix(3854269@a2tech):8963	Total	1	17s183ms
	select	1	17s183ms
psql - unix(3854278@a2tech):8963	Total	1	8s213ms
	select	1	8s213ms
psql - unix(3854285@a2tech):8963	Total	1	2m11s
	select	1	2m11s
psql - unix(3854310@a2tech):8963	Total	1	521ms
	select	1	521ms
psql - unix(3854315@a2tech):8963	Total	1	326ms
	select	1	326ms
psql - unix(3854371@a2tech):8963	Total	1	1s289ms
	others	1	1s289ms
psql - unix(3854379@a2tech):8963	Total	1	220ms
	others	1	220ms
psql - unix(3854447@a2tech):8963	Total	1	230ms
	others	1	230ms
psql - unix(3854504@a2tech):8963	Total	1	1s324ms
	others	1	1s324ms
psql - unix(3854512@a2tech):8963	Total	1	244ms
	others	1	244ms
psql - unix(3854630@a2tech):8963	Total	1	1s389ms
	others	1	1s389ms
psql - unix(3854641@a2tech):8963	Total	1	222ms
	others	1	222ms
psql - unix(3854704@a2tech):8963	Total	1	251ms
	others	1	251ms
psql - unix(3854706@a2tech):8963	Total	1	220ms
	others	1	220ms
psql - unix(3854771@a2tech):8963	Total	1	1s322ms
	others	1	1s322ms
psql - unix(3854779@a2tech):8963	Total	1	198ms
	others	1	198ms
psql - unix(3854890@a2tech):8963	Total	1	1s263ms
	others	1	1s263ms
psql - unix(3854898@a2tech):8963	Total	1	195ms
	others	1	195ms
psql - unix(3854964@a2tech):8963	Total	1	156ms
	others	1	156ms
psql - unix(3855041@a2tech):8963	Total	1	3m9s
	select	1	3m9s
psql - unix(3855048@a2tech):8963	Total	1	1s266ms
	others	1	1s266ms
psql - unix(3855059@a2tech):8963	Total	1	203ms
	others	1	203ms
psql - unix(3855104@a2tech):8963	Total	1	17s107ms
	select	1	17s107ms
psql - unix(3855113@a2tech):8963	Total	1	8s203ms
	select	1	8s203ms
psql - unix(3855120@a2tech):8963	Total	1	2m10s
	select	1	2m10s
psql - unix(3855143@a2tech):8963	Total	1	534ms
	select	1	534ms
psql - unix(3855147@a2tech):8963	Total	1	337ms
	select	1	337ms
psql - unix(3855199@a2tech):8963	Total	1	1s268ms
	others	1	1s268ms
psql - unix(3855207@a2tech):8963	Total	1	246ms
	others	1	246ms
psql - unix(3855270@a2tech):8963	Total	1	161ms
	others	1	161ms
psql - unix(3855274@a2tech):8963	Total	1	248ms
	others	1	248ms
psql - unix(3855327@a2tech):8963	Total	1	1s274ms
	others	1	1s274ms
psql - unix(3855335@a2tech):8963	Total	1	245ms
	others	1	245ms
psql - unix(3855454@a2tech):8963	Total	1	1s384ms
	others	1	1s384ms
psql - unix(3855465@a2tech):8963	Total	1	210ms
	others	1	210ms
psql - unix(3855529@a2tech):8963	Total	1	242ms
	others	1	242ms
psql - unix(3855531@a2tech):8963	Total	1	217ms
	others	1	217ms
psql - unix(3855592@a2tech):8963	Total	1	1s275ms
	others	1	1s275ms
psql - unix(3855600@a2tech):8963	Total	1	220ms
	others	1	220ms
psql - unix(3855710@a2tech):8963	Total	1	1s249ms
	others	1	1s249ms
psql - unix(3855719@a2tech):8963	Total	1	194ms
	others	1	194ms
psql - unix(3855788@a2tech):8963	Total	1	160ms
	select	1	160ms
psql - unix(3855791@a2tech):8963	Total	1	276ms
	others	1	276ms
psql - unix(3855875@a2tech):8963	Total	1	3m8s
	select	1	3m8s
psql - unix(3855876@a2tech):8963	Total	1	27m16s
	select	1	27m16s
psql - unix(3855879@a2tech):8963	Total	1	1s408ms
	others	1	1s408ms
psql - unix(3855918@a2tech):8963	Total	1	197ms
	others	1	197ms
psql - unix(3855965@a2tech):8963	Total	1	17s142ms
	select	1	17s142ms
psql - unix(3855973@a2tech):8963	Total	1	8s810ms
	select	1	8s810ms
psql - unix(3855986@a2tech):8963	Total	1	2m14s
	select	1	2m14s
psql - unix(3856017@a2tech):8963	Total	1	583ms
	select	1	583ms
psql - unix(3856022@a2tech):8963	Total	1	352ms
	select	1	352ms
psql - unix(3856077@a2tech):8963	Total	1	1s292ms
	others	1	1s292ms
psql - unix(3856085@a2tech):8963	Total	1	210ms
	others	1	210ms
psql - unix(3856152@a2tech):8963	Total	1	266ms
	others	1	266ms
psql - unix(3856209@a2tech):8963	Total	1	1s348ms
	others	1	1s348ms
psql - unix(3856217@a2tech):8963	Total	1	262ms
	others	1	262ms
psql - unix(3856352@a2tech):8963	Total	1	11m19s
	select	1	11m19s
psql - unix(3856415@a2tech):8963	Total	1	1s299ms
	others	1	1s299ms
psql - unix(3856425@a2tech):8963	Total	1	212ms
	others	1	212ms
psql - unix(3856487@a2tech):8963	Total	1	170ms
	others	1	170ms
psql - unix(3856492@a2tech):8963	Total	1	218ms
	others	1	218ms
psql - unix(3856586@a2tech):8963	Total	1	49s389ms
	select	1	49s389ms
psql - unix(3856659@a2tech):8963	Total	1	1s372ms
	others	1	1s372ms
psql - unix(3856667@a2tech):8963	Total	1	233ms
	others	1	233ms
psql - unix(3856789@a2tech):8963	Total	1	1s268ms
	others	1	1s268ms
psql - unix(3856797@a2tech):8963	Total	1	199ms
	others	1	199ms
psql - unix(3856868@a2tech):8963	Total	1	252ms
	others	1	252ms
psql - unix(3856870@a2tech):8963	Total	1	205ms
	others	1	205ms
psql - unix(3856945@a2tech):8963	Total	1	3m10s
	select	1	3m10s
psql - unix(3856948@a2tech):8963	Total	1	1s309ms
	others	1	1s309ms
psql - unix(3856959@a2tech):8963	Total	1	198ms
	others	1	198ms
psql - unix(3857004@a2tech):8963	Total	1	17s929ms
	select	1	17s929ms
psql - unix(3857013@a2tech):8963	Total	1	8s539ms
	select	1	8s539ms
psql - unix(3857018@a2tech):8963	Total	1	2m11s
	select	1	2m11s
psql - unix(3857051@a2tech):8963	Total	1	512ms
	select	1	512ms
psql - unix(3857054@a2tech):8963	Total	1	369ms
	select	1	369ms
psql - unix(3857116@a2tech):8963	Total	1	1s284ms
	others	1	1s284ms
psql - unix(3857125@a2tech):8963	Total	1	198ms
	others	1	198ms
psql - unix(3857186@a2tech):8963	Total	1	159ms
	others	1	159ms
psql - unix(3857274@a2tech):8963	Total	1	1s296ms
	others	1	1s296ms
psql - unix(3857283@a2tech):8963	Total	1	199ms
	others	1	199ms
psql - unix(3857421@a2tech):8963	Total	1	1s292ms
	others	1	1s292ms
psql - unix(3857432@a2tech):8963	Total	1	259ms
	others	1	259ms
psql - unix(3857494@a2tech):8963	Total	1	303ms
	others	1	303ms
psql - unix(3857499@a2tech):8963	Total	1	261ms
	others	1	261ms
psql - unix(3857553@a2tech):8963	Total	1	1s319ms
	others	1	1s319ms
psql - unix(3857563@a2tech):8963	Total	1	243ms
	others	1	243ms
psql - unix(3857676@a2tech):8963	Total	1	1s275ms
	others	1	1s275ms
psql - unix(3857685@a2tech):8963	Total	1	198ms
	others	1	198ms
psql - unix(3857750@a2tech):8963	Total	1	243ms
	others	1	243ms
psql - unix(3857845@a2tech):8963	Total	1	3m11s
	select	1	3m11s
psql - unix(3857852@a2tech):8963	Total	1	1s403ms
	others	1	1s403ms
psql - unix(3857863@a2tech):8963	Total	1	198ms
	others	1	198ms
psql - unix(3857912@a2tech):8963	Total	1	17s441ms
	select	1	17s441ms
psql - unix(3857924@a2tech):8963	Total	1	8s511ms
	select	1	8s511ms
psql - unix(3857930@a2tech):8963	Total	1	2m11s
	select	1	2m11s
psql - unix(3857956@a2tech):8963	Total	1	518ms
	select	1	518ms
psql - unix(3857960@a2tech):8963	Total	1	352ms
	select	1	352ms
psql - unix(3858019@a2tech):8963	Total	1	1s310ms
	others	1	1s310ms
psql - unix(3858028@a2tech):8963	Total	1	214ms
	others	1	214ms
psql - unix(3858087@a2tech):8963	Total	1	158ms
	others	1	158ms
psql - unix(3858148@a2tech):8963	Total	1	1s266ms
	others	1	1s266ms
psql - unix(3858157@a2tech):8963	Total	1	205ms
	others	1	205ms
psql - unix(3858270@a2tech):8963	Total	1	1s323ms
	others	1	1s323ms
psql - unix(3858283@a2tech):8963	Total	1	198ms
	others	1	198ms
psql - unix(3858347@a2tech):8963	Total	1	277ms
	others	1	277ms
psql - unix(3858351@a2tech):8963	Total	1	257ms
	others	1	257ms
psql - unix(3858410@a2tech):8963	Total	1	1s324ms
	others	1	1s324ms
psql - unix(3858419@a2tech):8963	Total	1	262ms
	others	1	262ms
psql - unix(3858532@a2tech):8963	Total	1	1s265ms
	others	1	1s265ms
psql - unix(3858541@a2tech):8963	Total	1	200ms
	others	1	200ms
psql - unix(3858610@a2tech):8963	Total	1	256ms
	others	1	256ms
psql - unix(3858612@a2tech):8963	Total	1	229ms
	others	1	229ms
psql - unix(3858682@a2tech):8963	Total	1	3m5s
	select	1	3m5s
psql - unix(3858689@a2tech):8963	Total	1	1s378ms
	others	1	1s378ms
psql - unix(3858701@a2tech):8963	Total	1	199ms
	others	1	199ms
psql - unix(3858753@a2tech):8963	Total	1	17s73ms
	select	1	17s73ms
psql - unix(3858760@a2tech):8963	Total	1	8s803ms
	select	1	8s803ms
psql - unix(3858766@a2tech):8963	Total	1	2m12s
	select	1	2m12s
psql - unix(3858793@a2tech):8963	Total	1	555ms
	select	1	555ms
psql - unix(3858797@a2tech):8963	Total	1	343ms
	select	1	343ms
psql - unix(3858849@a2tech):8963	Total	1	1s263ms
	others	1	1s263ms
psql - unix(3858858@a2tech):8963	Total	1	211ms
	others	1	211ms
psql - unix(3858921@a2tech):8963	Total	1	159ms
	others	1	159ms
psql - unix(3858989@a2tech):8963	Total	1	1s331ms
	others	1	1s331ms
psql - unix(3859001@a2tech):8963	Total	1	200ms
	others	1	200ms
psql - unix(3859117@a2tech):8963	Total	1	1s314ms
	others	1	1s314ms
psql - unix(3859129@a2tech):8963	Total	1	203ms
	others	1	203ms
psql - unix(3859198@a2tech):8963	Total	1	235ms
	others	1	235ms
psql - unix(3859255@a2tech):8963	Total	1	1s294ms
	others	1	1s294ms
psql - unix(3859264@a2tech):8963	Total	1	250ms
	others	1	250ms
psql - unix(3859372@a2tech):8963	Total	1	1s269ms
	others	1	1s269ms
psql - unix(3859380@a2tech):8963	Total	1	199ms
	others	1	199ms
psql - unix(3859534@a2tech):8963	Total	1	161ms
	others	1	161ms
psql - unix(3859537@a2tech):8963	Total	1	220ms
	others	1	220ms
psql - unix(3859631@a2tech):8963	Total	1	3m7s
	select	1	3m7s
psql - unix(3859657@a2tech):8963	Total	1	1s460ms
	others	1	1s460ms
psql - unix(3859669@a2tech):8963	Total	1	222ms
	others	1	222ms
psql - unix(3859781@a2tech):8963	Total	1	16s867ms
	select	1	16s867ms
psql - unix(3859788@a2tech):8963	Total	1	7s821ms
	select	1	7s821ms
psql - unix(3859793@a2tech):8963	Total	1	2m11s
	select	1	2m11s
psql - unix(3859821@a2tech):8963	Total	1	500ms
	select	1	500ms
psql - unix(3859825@a2tech):8963	Total	1	333ms
	select	1	333ms
psql - unix(3859880@a2tech):8963	Total	1	1s278ms
	others	1	1s278ms
psql - unix(3859890@a2tech):8963	Total	1	254ms
	others	1	254ms
psql - unix(3859963@a2tech):8963	Total	1	238ms
	others	1	238ms
psql - unix(3859965@a2tech):8963	Total	1	216ms
	others	1	216ms
psql - unix(3860019@a2tech):8963	Total	1	1s266ms
	others	1	1s266ms
psql - unix(3860027@a2tech):8963	Total	1	199ms
	others	1	199ms
psql - unix(3860144@a2tech):8963	Total	1	1s404ms
	others	1	1s404ms
psql - unix(3860155@a2tech):8963	Total	1	197ms
	others	1	197ms
psql - unix(3860215@a2tech):8963	Total	1	159ms
	others	1	159ms
psql - unix(3860275@a2tech):8963	Total	1	1s271ms
	others	1	1s271ms
psql - unix(3860283@a2tech):8963	Total	1	200ms
	others	1	200ms
psql - unix(3860395@a2tech):8963	Total	1	1s429ms
	others	1	1s429ms
psql - unix(3860404@a2tech):8963	Total	1	197ms
	others	1	197ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-04-21 06:25:03 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

389 1000-10000ms duration

Chart
Table

Range	Count	Percentage
0-1ms	0	0.00%
1-5ms	0	0.00%
5-10ms	0	0.00%
10-25ms	0	0.00%
25-50ms	0	0.00%
50-100ms	0	0.00%
100-500ms	346	39.27%
500-1000ms	52	5.90%
1000-10000ms	389	44.15%
> 10000ms	94	10.67%

Slowest individual queries


[ Date: 2026-04-21 06:32:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3845569@a2tech):8963 ]
[ Date: 2026-04-21 18:32:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3855876@a2tech):8963 ]
[ Date: 2026-04-21 18:43:39 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3856352@a2tech):8963 ]
[ Date: 2026-04-21 06:43:25 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3846024@a2tech):8963 ]
[ Date: 2026-04-21 07:08:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3846588@a2tech):8963 ]
[ Date: 2026-04-21 20:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3857845@a2tech):8963 ]
[ Date: 2026-04-21 19:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3856945@a2tech):8963 ]
[ Date: 2026-04-21 14:08:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3852525@a2tech):8963 ]
[ Date: 2026-04-21 13:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3851696@a2tech):8963 ]
[ Date: 2026-04-21 17:08:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3855041@a2tech):8963 ]
[ Date: 2026-04-21 08:08:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3847405@a2tech):8963 ]
[ Date: 2026-04-21 18:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3855875@a2tech):8963 ]
[ Date: 2026-04-21 22:08:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3859631@a2tech):8963 ]
[ Date: 2026-04-21 15:08:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3853349@a2tech):8963 ]
[ Date: 2026-04-21 21:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3858682@a2tech):8963 ]
[ Date: 2026-04-21 11:08:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3849980@a2tech):8963 ]
[ Date: 2026-04-21 09:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3848272@a2tech):8963 ]
[ Date: 2026-04-21 16:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3854214@a2tech):8963 ]
[ Date: 2026-04-21 12:08:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3850812@a2tech):8963 ]
[ Date: 2026-04-21 10:08:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3849141@a2tech):8963 ]

Rank	Duration	Query
1	27m16s	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-04-21 06:32:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3845569@a2tech):8963 ]
2	27m16s	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-04-21 18:32:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3855876@a2tech):8963 ]
3	11m19s	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-04-21 18:43:39 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3856352@a2tech):8963 ]
4	11m5s	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-04-21 06:43:25 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3846024@a2tech):8963 ]
5	3m12s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-04-21 07:08:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3846588@a2tech):8963 ]
6	3m11s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-04-21 20:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3857845@a2tech):8963 ]
7	3m10s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-04-21 19:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3856945@a2tech):8963 ]
8	3m9s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-04-21 14:08:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3852525@a2tech):8963 ]
9	3m9s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-04-21 13:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3851696@a2tech):8963 ]
10	3m9s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-04-21 17:08:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3855041@a2tech):8963 ]
11	3m9s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-04-21 08:08:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3847405@a2tech):8963 ]
12	3m8s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-04-21 18:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3855875@a2tech):8963 ]
13	3m7s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-04-21 22:08:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3859631@a2tech):8963 ]
14	3m6s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-04-21 15:08:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3853349@a2tech):8963 ]
15	3m5s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-04-21 21:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3858682@a2tech):8963 ]
16	3m5s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-04-21 11:08:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3849980@a2tech):8963 ]
17	3m5s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-04-21 09:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3848272@a2tech):8963 ]
18	3m5s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-04-21 16:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3854214@a2tech):8963 ]
19	3m4s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-04-21 12:08:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3850812@a2tech):8963 ]
20	3m3s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-04-21 10:08:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3849141@a2tech):8963 ]

Time consuming queries (N)


[ User: intelifix - Total duration: 1h18m37s - Times executed: 6 ]
[ User: intelifix - Total duration: 52m25s - Times executed: 48 ]
[ User: intelifix - Total duration: 39m39s - Times executed: 48 ]
[ User: intelifix - Total duration: 4m5s - Times executed: 3 ]
[ User: intelifix - Total duration: 3m26s - Times executed: 276 ]
[ User: intelifix - Total duration: 1m42s - Times executed: 4 ]
[ User: intelifix - Total duration: 1m36s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m25s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m24s - Times executed: 4 ]
[ User: intelifix - Total duration: 1m13s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m7s - Times executed: 6 ]
[ User: intelifix - Total duration: 56s563ms - Times executed: 6 ]
[ User: intelifix - Total duration: 55s777ms - Times executed: 6 ]
[ User: intelifix - Total duration: 53s72ms - Times executed: 3 ]
[ User: intelifix - Total duration: 46s683ms - Times executed: 6 ]
[ User: intelifix - Total duration: 46s424ms - Times executed: 6 ]
[ User: intelifix - Total duration: 44s37ms - Times executed: 1 ]
[ User: intelifix - Total duration: 41s162ms - Times executed: 6 ]
[ User: intelifix - Total duration: 36s508ms - Times executed: 4 ]
[ User: intelifix - Total duration: 34s909ms - Times executed: 6 ]

Most frequent queries (N)


[ User: intelifix - Total duration: 3m26s - Times executed: 276 ]
[ User: intelifix - Total duration: 52m25s - Times executed: 48 ]
[ User: intelifix - Total duration: 39m39s - Times executed: 48 ]
[ User: intelifix - Total duration: 8s491ms - Times executed: 37 ]
[ User: intelifix - Total duration: 16s585ms - Times executed: 32 ]
[ User: intelifix - Total duration: 5s774ms - Times executed: 26 ]
[ User: intelifix - Total duration: 1h18m37s - Times executed: 6 ]
[ User: intelifix - Total duration: 1m7s - Times executed: 6 ]
[ User: intelifix - Total duration: 56s563ms - Times executed: 6 ]
[ User: intelifix - Total duration: 55s777ms - Times executed: 6 ]
[ User: intelifix - Total duration: 46s683ms - Times executed: 6 ]
[ User: intelifix - Total duration: 46s424ms - Times executed: 6 ]
[ User: intelifix - Total duration: 41s162ms - Times executed: 6 ]
[ User: intelifix - Total duration: 34s909ms - Times executed: 6 ]
[ User: intelifix - Total duration: 26s340ms - Times executed: 6 ]
[ User: intelifix - Total duration: 19s312ms - Times executed: 6 ]
[ User: intelifix - Total duration: 19s252ms - Times executed: 6 ]
[ User: intelifix - Total duration: 18s457ms - Times executed: 6 ]
[ User: intelifix - Total duration: 17s81ms - Times executed: 6 ]
[ User: intelifix - Total duration: 12s118ms - Times executed: 6 ]

Normalized slowest queries (N)


[ User: intelifix - Total duration: 1h18m37s - Times executed: 6 ]
[ User: intelifix - Total duration: 4m5s - Times executed: 3 ]
[ User: intelifix - Total duration: 52m25s - Times executed: 48 ]
[ User: intelifix - Total duration: 39m39s - Times executed: 48 ]
[ User: intelifix - Total duration: 44s37ms - Times executed: 1 ]
[ User: intelifix - Total duration: 1m36s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m25s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m42s - Times executed: 4 ]
[ User: intelifix - Total duration: 1m13s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m24s - Times executed: 4 ]
[ User: intelifix - Total duration: 53s72ms - Times executed: 3 ]
[ User: intelifix - Total duration: 1m7s - Times executed: 6 ]
[ User: intelifix - Total duration: 56s563ms - Times executed: 6 ]
[ User: intelifix - Total duration: 55s777ms - Times executed: 6 ]
[ User: intelifix - Total duration: 36s508ms - Times executed: 4 ]
[ User: intelifix - Total duration: 46s683ms - Times executed: 6 ]
[ User: intelifix - Total duration: 46s424ms - Times executed: 6 ]
[ User: intelifix - Total duration: 41s162ms - Times executed: 6 ]
[ User: intelifix - Total duration: 34s909ms - Times executed: 6 ]
[ User: intelifix - Total duration: 26s340ms - Times executed: 6 ]

Time consuming prepare

Rank	Total duration	Times executed	Min duration	Max duration	Avg duration	Query
NO DATASET

Time consuming bind

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

0ms

Details

0ms

;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
Apr 21	10	1	0ms	0ms
	11	1	0ms	0ms
	15	1	0ms	0ms
	16	1	0ms	0ms
	17	1	0ms	0ms
	20	1	0ms	0ms

[ User: intelifix - Total duration: 3s680ms - Times executed: 6 ]

[ Application: psql - unix(3858410@a2tech):8963 - Total duration: 1s324ms - Times executed: 1 ]

[ Application: psql - unix(3850399@a2tech):8963 - Total duration: 1s307ms - Times executed: 1 ]

[ Application: psql - unix(3849156@a2tech):8963 - Total duration: 283ms - Times executed: 1 ]

[ Application: psql - unix(3853644@a2tech):8963 - Total duration: 274ms - Times executed: 1 ]

[ Application: psql - unix(3855335@a2tech):8963 - Total duration: 245ms - Times executed: 1 ]

[ Application: psql - unix(3854512@a2tech):8963 - Total duration: 244ms - Times executed: 1 ]

;

Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql - unix(3858410@a2tech):8963

Log levels

Key values

5,998 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	338	5.64%
ERROR	1,191	19.86%
EVENTLOG	1	0.02%
FATAL	25	0.42%
LOG	2,914	48.58%
STATEMENT	1,529	25.49%

Events distribution (except queries)

Key values

0 PANIC entries
25 FATAL entries
1191 ERROR entries
0 WARNING entries
1 EVENTLOG entries

Most Frequent Errors/Events

Key values

1,187 Max number of times the same event was reported
1,217 Total events found

Rank

Times reported

Error

1,187

Details

ERROR: prepared statement "..." does not exist

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Apr 21	00	48
	01	45
	02	51
	03	46
	04	49
	05	51
	06	51
	07	47
	08	48
	09	49
	10	52
	11	52
	12	49
	13	50
	14	49
	15	50
	16	50
	17	50
	18	48
	19	52
	20	50
	21	50
	22	51
	23	49

ERROR: prepared statement "_PLAN00000000446DAEF0" does not exist
ERROR: prepared statement "_PLAN00000000446E2100" does not exist
ERROR: prepared statement "_PLAN00000000446DBCA0" does not exist

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Apr 21	00	1
	01	1
	05	4
	06	2
	09	1
	11	1
	12	1
	17	1
	18	1
	19	2

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Apr 21	03	9

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Apr 21	05	4

ERROR: relation "rs_mv_equipamentos" does not exist
ERROR: relation "rs_mv_codigos_barra" does not exist

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Apr 21	03	1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Apr 21	03	1

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Average Autovacuum Duration

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Pages removed per tables

Autovacuum Activity

Locks

Locks by types

Key values

Type of locks

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values