pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sat May 2 23:50:06 2026
Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-Wed.log
Parsed 11,603 log entries in 5s
Log start from 2026-05-01 00:00:17 to 2026-05-01 23:59:45

Global Stats

131 Number of unique normalized queries
1,057 Number of queries
4h28m32s Total query duration
2026-05-01 00:00:17 First query
2026-05-01 23:39:13 Last query
6 queries/s at 2026-05-01 23:38:56 Query peak

4h28m32s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
4h28m32s Execute total duration

1,181 Number of events
8 Number of unique normalized events
1,154 Max number of times the same event was reported
0 Number of cancellation

26 Total number of automatic vacuums
29 Total number of automatic analyzes

338 Number temporary file
483.20 MiB Max size of temporary file
16.14 MiB Average size of temporary file

389 Total number of sessions
16 sessions at 2026-05-01 06:08:13 Session peak
7d17h43m28s Total duration of sessions
28m38s Average duration of sessions
2 Average queries per session
41s419ms Average queries duration per session
27m57s Average idle time per session

390 Total number of connections
6 connections/s at 2026-05-01 03:05:17 Connection peak
3 Total number of databases

SQL Traffic

Key values

6 queries/s Query Peak
2026-05-01 23:38:56 Date

SELECT Traffic

Key values

2 queries/s Query Peak
2026-05-01 12:10:51 Date

INSERT/UPDATE/DELETE Traffic

Key values

6 queries/s Query Peak
2026-05-01 23:38:56 Date

Queries duration

Key values

4h28m32s 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)
May 01	00	323	0ms	13m41s	9s179ms	1m13s	2m15s	14m57s
	01	13	0ms	1s147ms	669ms	1s287ms	1s489ms	1s630ms
	02	8	0ms	1s153ms	936ms	1s52ms	1s153ms	1s798ms
	03	15	0ms	1s164ms	642ms	1s312ms	1s646ms	1s935ms
	04	15	0ms	1s133ms	618ms	1s95ms	1s394ms	2s113ms
	05	17	0ms	1m52s	19s69ms	2s225ms	57s485ms	1m52s
	06	14	0ms	28m44s	2m58s	1s287ms	1m11s	28m44s
	07	12	0ms	3m16s	30s320ms	1s141ms	1s236ms	3m45s
	08	17	0ms	3m12s	20s977ms	1s81ms	1s176ms	3m38s
	09	17	0ms	3m8s	20s646ms	1s69ms	1s223ms	3m33s
	10	18	0ms	3m12s	19s801ms	1s130ms	1s276ms	3m38s
	11	18	0ms	3m13s	19s881ms	1s81ms	1s252ms	3m39s
	12	17	0ms	3m10s	20s857ms	1s115ms	1s209ms	3m36s
	13	17	0ms	3m13s	21s92ms	1s91ms	1s194ms	3m39s
	14	17	0ms	3m7s	20s721ms	1s70ms	1s315ms	3m33s
	15	15	0ms	3m7s	23s358ms	1s40ms	1s168ms	3m32s
	16	15	0ms	3m8s	23s540ms	1s58ms	1s325ms	3m34s
	17	18	0ms	3m6s	19s562ms	1s45ms	1s213ms	3m32s
	18	20	0ms	28m50s	2m22s	1s399ms	3m37s	28m50s
	19	18	0ms	3m14s	19s928ms	1s91ms	1s317ms	3m40s
	20	89	0ms	3m14s	8s121ms	54s651ms	1m14s	3m51s
	21	17	0ms	3m12s	21s47ms	1s117ms	1s314ms	3m38s
	22	16	0ms	3m12s	22s383ms	1s72ms	1s225ms	3m39s
	23	311	0ms	1m3s	5s554ms	1m2s	1m5s	1m13s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
May 01	00	3	301	9s656ms	1m2s	1m13s	8m29s
	01	1	0	202ms	0ms	0ms	0ms
	02	0	0	0ms	0ms	0ms	0ms
	03	0	0	0ms	0ms	0ms	0ms
	04	3	0	217ms	0ms	0ms	216ms
	05	1	0	211ms	0ms	0ms	0ms
	06	3	0	13m48s	0ms	0ms	11m28s
	07	6	0	59s496ms	0ms	0ms	2m10s
	08	6	0	58s89ms	0ms	0ms	2m10s
	09	6	0	57s270ms	0ms	0ms	2m9s
	10	6	0	58s94ms	0ms	0ms	2m10s
	11	6	0	58s359ms	0ms	0ms	2m10s
	12	6	0	57s847ms	0ms	0ms	2m10s
	13	6	0	58s492ms	0ms	0ms	2m11s
	14	6	0	57s449ms	0ms	0ms	2m10s
	15	6	0	57s215ms	0ms	0ms	2m10s
	16	6	0	57s659ms	0ms	0ms	2m11s
	17	6	0	57s420ms	0ms	0ms	2m11s
	18	9	0	5m16s	0ms	0ms	11m34s
	19	6	0	58s466ms	0ms	0ms	2m10s
	20	6	73	9s57ms	0ms	54s651ms	2m11s
	21	6	0	58s321ms	0ms	0ms	2m11s
	22	6	0	58s464ms	0ms	0ms	2m11s
	23	0	311	5s554ms	1m1s	1m2s	1m12s

Day	Hour	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
May 01	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
May 01	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
May 01	00	23	0.01/s
	01	17	0.00/s
	02	13	0.00/s
	03	26	0.01/s
	04	17	0.00/s
	05	19	0.01/s
	06	17	0.00/s
	07	17	0.00/s
	08	8	0.00/s
	09	15	0.00/s
	10	15	0.00/s
	11	16	0.00/s
	12	16	0.00/s
	13	14	0.00/s
	14	15	0.00/s
	15	14	0.00/s
	16	16	0.00/s
	17	14	0.00/s
	18	18	0.01/s
	19	14	0.00/s
	20	20	0.01/s
	21	14	0.00/s
	22	16	0.00/s
	23	16	0.00/s

Day	Hour	Count	Average Duration	Average idle time
May 01	00	15	25m19s	22m1s
	01	24	35m48s	35m48s
	02	14	28m47s	28m46s
	03	24	13m12s	13m11s
	04	16	30m2s	30m1s
	05	18	30m16s	29m58s
	06	17	35m4s	32m37s
	07	18	30m30s	30m10s
	08	8	49m51s	49m6s
	09	15	31m27s	31m3s
	10	14	30m8s	29m43s
	11	16	30m2s	29m40s
	12	18	26m14s	25m55s
	13	13	28m3s	27m36s
	14	14	30m41s	30m15s
	15	14	29m38s	29m13s
	16	16	25m57s	25m35s
	17	14	30m33s	30m8s
	18	17	29m42s	26m54s
	19	15	32m1s	31m37s
	20	20	21m16s	20m40s
	21	14	27m23s	26m57s
	22	15	27m22s	26m59s
	23	20	25m28s	24m2s

↑ Back to the top of the General Activity table

Established Connections

Key values

6 connections Connection Peak
2026-05-01 03:05:17 Date

Connections per database

Key values

brasilia Main Database
390 connections Total

Chart
Table

Database	User	Count
brasilia		288
	etiquetas	237
	intelifix	47
	lenon	4
contagem		39
	intelifix	36
	lenon	3
jaboatao		4
	intelifix	4
rio		57
	intelifix	50
	lenon	7
testes		2
	lenon	2

Connections per user

Key values

etiquetas Main User
390 connections Total

Chart
Table

User	Count
etiquetas	237
intelifix	137
lenon	16

Connections per host

Key values

[local] Main host with 389 connections
390 Total connections

Chart
Table

Host	Count
127.0.0.1	1
[local]	389

Simultaneous sessions

Key values

16 sessions Session Peak
2026-05-01 06:08:13 Date

Histogram of session times

Key values

189 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	1	0.26%
500ms-1s	1	0.26%
1s-30s	3	0.77%
30s-1m	3	0.77%
1m-10m	189	48.59%
10m-30m	31	7.97%
30m-1h	7	1.80%
1h-8h	154	39.59%
> 8h	0	0.00%

Sessions per database

Key values

brasilia Main Database
389 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
brasilia	289	3d23h15m23s	19m46s
contagem	40	1d12h20m43s	54m31s
rio	60	2d6h7m21s	54m7s

Sessions per user

Key values

etiquetas Main User
389 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
etiquetas	237	1d23h47m49s	12m6s
intelifix	138	5d3h55m34s	53m52s
lenon	14	14h3s	1h

Sessions per host

Key values

[local] Main Host
389 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	1	45m1s	45m1s
[local]	388	7d16h58m26s	28m36s

Sessions per application

Key values

[unknown] Main Application
389 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
[unknown]	128	5d11m39s	56m20s
app - 177.99.204.34:49208	1	5m16s	5m16s
app - 177.99.204.34:49285	1	3m7s	3m7s
app - 177.99.204.34:49310	1	10m30s	10m30s
app - 177.99.204.34:49357	1	3m7s	3m7s
app - 177.99.204.34:49631	1	5m14s	5m14s
app - 177.99.204.34:49691	1	1h	1h
app - 177.99.204.34:49699	1	6m17s	6m17s
app - 177.99.204.34:49747	1	6m19s	6m19s
app - 177.99.204.34:49825	1	7m21s	7m21s
app - 177.99.204.34:49826	1	2m4s	2m4s
app - 177.99.204.34:49864	1	9m27s	9m27s
app - 177.99.204.34:49939	1	3m9s	3m9s
app - 177.99.204.34:49974	1	7m21s	7m21s
app - 177.99.204.34:50074	1	8m26s	8m26s
app - 177.99.204.34:50084	1	5m35s	5m35s
app - 177.99.204.34:50143	1	10m33s	10m33s
app - 177.99.204.34:50156	1	3m9s	3m9s
app - 177.99.204.34:50440	1	4m10s	4m10s
app - 177.99.204.34:50451	1	2m4s	2m4s
app - 177.99.204.34:50506	1	10m32s	10m32s
app - 177.99.204.34:50646	1	4m11s	4m11s
app - 177.99.204.34:50726	2	45m50s	22m55s
app - 177.99.204.34:50900	1	5m14s	5m14s
app - 177.99.204.34:50951	1	4m13s	4m13s
app - 177.99.204.34:50957	1	7m24s	7m24s
app - 177.99.204.34:50980	1	6m19s	6m19s
app - 177.99.204.34:51054	1	1h	1h
app - 177.99.204.34:51169	1	4m11s	4m11s
app - 177.99.204.34:51294	1	5m12s	5m12s
app - 177.99.204.34:51443	1	8m22s	8m22s
app - 177.99.204.34:51550	1	3m7s	3m7s
app - 177.99.204.34:51595	1	4m11s	4m11s
app - 177.99.204.34:51753	2	1h5m8s	32m34s
app - 177.99.204.34:51814	1	2m4s	2m4s
app - 177.99.204.34:51878	2	1h8s	30m4s
app - 177.99.204.34:51897	1	11m34s	11m34s
app - 177.99.204.34:51925	1	7m36s	7m36s
app - 177.99.204.34:51987	1	2m4s	2m4s
app - 177.99.204.34:52024	1	4m10s	4m10s
app - 177.99.204.34:52138	1	9m31s	9m31s
app - 177.99.204.34:52269	1	4m10s	4m10s
app - 177.99.204.34:52303	1	7m22s	7m22s
app - 177.99.204.34:52412	1	3m7s	3m7s
app - 177.99.204.34:52419	1	9m25s	9m25s
app - 177.99.204.34:52471	1	9m29s	9m29s
app - 177.99.204.34:52479	1	4m10s	4m10s
app - 177.99.204.34:52549	1	6m17s	6m17s
app - 177.99.204.34:53009	1	3m8s	3m8s
app - 177.99.204.34:53031	1	9m28s	9m28s
app - 177.99.204.34:53059	1	4m12s	4m12s
app - 177.99.204.34:53123	1	6m16s	6m16s
app - 177.99.204.34:53305	1	10m31s	10m31s
app - 177.99.204.34:53376	1	12m39s	12m39s
app - 177.99.204.34:53449	1	4m7s	4m7s
app - 177.99.204.34:53458	2	1h52s	30m26s
app - 177.99.204.34:53463	1	3m8s	3m8s
app - 177.99.204.34:53556	1	6m17s	6m17s
app - 177.99.204.34:53645	1	8m23s	8m23s
app - 177.99.204.34:53701	1	5m13s	5m13s
app - 177.99.204.34:53704	1	12m41s	12m41s
app - 177.99.204.34:53727	1	2m4s	2m4s
app - 177.99.204.34:53796	1	4m11s	4m11s
app - 177.99.204.34:53837	1	7m21s	7m21s
app - 177.99.204.34:53924	1	3m8s	3m8s
app - 177.99.204.34:53960	1	15m48s	15m48s
app - 177.99.204.34:54002	1	4m11s	4m11s
app - 177.99.204.34:54053	1	6m17s	6m17s
app - 177.99.204.34:54145	1	3m8s	3m8s
app - 177.99.204.34:54179	1	6m19s	6m19s
app - 177.99.204.34:54299	1	2m4s	2m4s
app - 177.99.204.34:54361	1	9m28s	9m28s
app - 177.99.204.34:54400	1	6m19s	6m19s
app - 177.99.204.34:54519	1	12m37s	12m37s
app - 177.99.204.34:54550	1	4m12s	4m12s
app - 177.99.204.34:54558	1	13m38s	13m38s
app - 177.99.204.34:54580	1	8m25s	8m25s
app - 177.99.204.34:54626	1	2m25s	2m25s
app - 177.99.204.34:54745	1	4m13s	4m13s
app - 177.99.204.34:54858	1	5m24s	5m24s
app - 177.99.204.34:54884	1	12m41s	12m41s
app - 177.99.204.34:54961	1	2m4s	2m4s
app - 177.99.204.34:55012	1	1h	1h
app - 177.99.204.34:55070	1	2m4s	2m4s
app - 177.99.204.34:55259	1	6m17s	6m17s
app - 177.99.204.34:55268	1	5m14s	5m14s
app - 177.99.204.34:55420	1	4m12s	4m12s
app - 177.99.204.34:55520	1	2m43s	2m43s
app - 177.99.204.34:55755	1	5m13s	5m13s
app - 177.99.204.34:55769	1	3m7s	3m7s
app - 177.99.204.34:56239	1	2m4s	2m4s
app - 177.99.204.34:56248	1	4m11s	4m11s
app - 177.99.204.34:56314	1	5m16s	5m16s
app - 177.99.204.34:56330	1	4m10s	4m10s
app - 177.99.204.34:56343	1	6m17s	6m17s
app - 177.99.204.34:56432	1	6m18s	6m18s
app - 177.99.204.34:56498	1	8m22s	8m22s
app - 177.99.204.34:56514	1	1h	1h
app - 177.99.204.34:56524	2	1h4m7s	32m3s
app - 177.99.204.34:56790	1	8m24s	8m24s
app - 177.99.204.34:56830	1	10m31s	10m31s
app - 177.99.204.34:56880	1	8m25s	8m25s
app - 177.99.204.34:56889	1	4m10s	4m10s
app - 177.99.204.34:56959	1	2m4s	2m4s
app - 177.99.204.34:57183	1	8m24s	8m24s
app - 177.99.204.34:57352	1	6m17s	6m17s
app - 177.99.204.34:57354	1	7m39s	7m39s
app - 177.99.204.34:57386	1	4m11s	4m11s
app - 177.99.204.34:57420	1	2m4s	2m4s
app - 177.99.204.34:57662	1	5m14s	5m14s
app - 177.99.204.34:57720	1	7m36s	7m36s
app - 177.99.204.34:57722	2	1h5m16s	32m38s
app - 177.99.204.34:57827	1	7m24s	7m24s
app - 177.99.204.34:57829	1	11m35s	11m35s
app - 177.99.204.34:57831	1	12m41s	12m41s
app - 177.99.204.34:57890	1	9m28s	9m28s
app - 177.99.204.34:57928	1	10m26s	10m26s
app - 177.99.204.34:58010	1	8m26s	8m26s
app - 177.99.204.34:58162	3	2h1s	40m
app - 177.99.204.34:58225	1	11m35s	11m35s
app - 177.99.204.34:58497	1	6m18s	6m18s
app - 177.99.204.34:58511	1	4m11s	4m11s
app - 177.99.204.34:58513	1	6m16s	6m16s
app - 177.99.204.34:58703	1	10m32s	10m32s
app - 177.99.204.34:58717	1	5m15s	5m15s
app - 177.99.204.34:58734	1	3m8s	3m8s
app - 177.99.204.34:59035	1	27m22s	27m22s
app - 177.99.204.34:59112	1	2m4s	2m4s
app - 177.99.204.34:59160	1	7m21s	7m21s
app - 177.99.204.34:59212	1	7m38s	7m38s
app - 177.99.204.34:59234	1	14m52s	14m52s
app - 177.99.204.34:59296	1	3m9s	3m9s
app - 177.99.204.34:59304	1	1h	1h
app - 177.99.204.34:59402	1	7m22s	7m22s
app - 177.99.204.34:59648	1	4m10s	4m10s
app - 177.99.204.34:59689	1	6m18s	6m18s
app - 177.99.204.34:59898	1	8m27s	8m27s
app - 177.99.204.34:59956	1	8m26s	8m26s
app - 177.99.204.34:59994	1	8m24s	8m24s
app - 177.99.204.34:60034	1	4m15s	4m15s
app - 177.99.204.34:60039	1	21m9s	21m9s
app - 177.99.204.34:60080	1	3m7s	3m7s
app - 177.99.204.34:60156	1	4m9s	4m9s
app - 177.99.204.34:60202	1	1h	1h
app - 177.99.204.34:60225	2	1h3m8s	31m34s
app - 177.99.204.34:60234	1	7m20s	7m20s
app - 177.99.204.34:60270	1	7m21s	7m21s
app - 177.99.204.34:60372	1	7m22s	7m22s
app - 177.99.204.34:60444	1	11m36s	11m36s
app - 177.99.204.34:60548	1	9m23s	9m23s
app - 177.99.204.34:60660	1	3m10s	3m10s
app - 177.99.204.34:60710	1	2m4s	2m4s
app - 177.99.204.34:60722	1	5m16s	5m16s
app - 177.99.204.34:60761	1	7m20s	7m20s
app - 177.99.204.34:60837	1	7m22s	7m22s
app - 177.99.204.34:60925	1	6m20s	6m20s
app - 177.99.204.34:60981	1	2m4s	2m4s
app - 177.99.204.34:61206	1	6m20s	6m20s
app - 177.99.204.34:61371	1	10m30s	10m30s
app - 177.99.204.34:61605	1	9m27s	9m27s
app - 177.99.204.34:61791	1	5m14s	5m14s
app - 177.99.204.34:61836	1	4m11s	4m11s
app - 177.99.204.34:61839	1	5m14s	5m14s
app - 177.99.204.34:61853	1	5m17s	5m17s
app - 177.99.204.34:62021	1	7m21s	7m21s
app - 177.99.204.34:62063	1	11m32s	11m32s
app - 177.99.204.34:62171	1	1m2s	1m2s
app - 177.99.204.34:62183	1	6m15s	6m15s
app - 177.99.204.34:62191	1	1h	1h
app - 177.99.204.34:62197	1	6m12s	6m12s
app - 177.99.204.34:62254	1	4m10s	4m10s
app - 177.99.204.34:62313	1	11m40s	11m40s
app - 177.99.204.34:62394	1	5m12s	5m12s
app - 177.99.204.34:62454	1	2m7s	2m7s
app - 177.99.204.34:62497	1	7m18s	7m18s
app - 177.99.204.34:62565	1	6m17s	6m17s
app - 177.99.204.34:62649	1	12m37s	12m37s
app - 177.99.204.34:62669	1	7m21s	7m21s
app - 177.99.204.34:62828	1	5m15s	5m15s
app - 177.99.204.34:62891	1	4m10s	4m10s
app - 177.99.204.34:62922	1	7m21s	7m21s
app - 177.99.204.34:62923	1	6m19s	6m19s
app - 177.99.204.34:62967	1	4m11s	4m11s
app - 177.99.204.34:62988	1	8m26s	8m26s
app - 177.99.204.34:63226	1	8m27s	8m27s
app - 177.99.204.34:63253	1	4m10s	4m10s
app - 177.99.204.34:63276	2	2m52s	1m26s
app - 177.99.204.34:63337	1	2m4s	2m4s
app - 177.99.204.34:63593	1	6m16s	6m16s
app - 177.99.204.34:63612	1	3m7s	3m7s
app - 177.99.204.34:63649	1	5m12s	5m12s
app - 177.99.204.34:63762	1	6m18s	6m18s
app - 177.99.204.34:63784	1	3m7s	3m7s
app - 177.99.204.34:63807	1	16m56s	16m56s
app - 177.99.204.34:63877	1	9m28s	9m28s
app - 177.99.204.34:63951	1	4m11s	4m11s
app - 177.99.204.34:63959	1	1h	1h
app - 177.99.204.34:64162	1	5m15s	5m15s
app - 177.99.204.34:64249	1	9m33s	9m33s
app - 177.99.204.34:64274	1	3m7s	3m7s
app - 177.99.204.34:64284	1	7m18s	7m18s
app - 177.99.204.34:64287	1	4m11s	4m11s
app - 177.99.204.34:64356	1	6m34s	6m34s
app - 177.99.204.34:64361	1	3m8s	3m8s
app - 177.99.204.34:64383	1	4m10s	4m10s
app - 177.99.204.34:64455	2	1h58s	30m29s
app - 177.99.204.34:64528	1	6m16s	6m16s
app - 177.99.204.34:64549	1	4m12s	4m12s
app - 177.99.204.34:64680	1	5m15s	5m15s
app - 177.99.204.34:64701	1	1h	1h
app - 177.99.204.34:64716	1	7m30s	7m30s
app - 177.99.204.34:65118	1	3m12s	3m12s
app - 177.99.204.34:65127	1	5m15s	5m15s
app - 177.99.204.34:65162	1	5m15s	5m15s
app - 177.99.204.34:65172	1	7m22s	7m22s
app - 177.99.204.34:65246	1	3m8s	3m8s
app - 177.99.204.34:65306	1	13m44s	13m44s
app - 177.99.204.34:65404	1	5m14s	5m14s
app - 177.99.204.34:65440	1	9m33s	9m33s
pg_dump	9	1h5m57s	7m19s
postgres_fdw	1	45m1s	45m1s
psql - unix(3125100@a2tech):8963	1	1h	1h
psql - unix(3125227@a2tech):8963	1	1h1s	1h1s
psql - unix(3132684@a2tech):8963	1	1h8m44s	1h8m44s
psql - unix(3133116@a2tech):8963	1	1h10m10s	1h10m10s
psql - unix(3133656@a2tech):8963	1	1h3m16s	1h3m16s
psql - unix(3134946@a2tech):8963	1	1h1s	1h1s
psql - unix(3136427@a2tech):8963	1	1h3m11s	1h3m11s
psql - unix(3139023@a2tech):8963	1	1h	1h
psql - unix(3140018@a2tech):8963	1	1h3m7s	1h3m7s
psql - unix(3140924@a2tech):8963	1	1h16s	1h16s
psql - unix(3141716@a2tech):8963	1	1h3m8s	1h3m8s
psql - unix(3142161@a2tech):8963	1	1h	1h
psql - unix(3142544@a2tech):8963	1	1h3m6s	1h3m6s
psql - unix(3142622@a2tech):8963	1	1h2m10s	1h2m10s
psql - unix(3143389@a2tech):8963	1	1h18m51s	1h18m51s
psql - unix(3143395@a2tech):8963	1	1h4s	1h4s
psql - unix(3144451@a2tech):8963	1	1h3m14s	1h3m14s
psql - unix(3145358@a2tech):8963	1	1h18s	1h18s
psql - unix(3145476@a2tech):8963	1	1h	1h
psql - unix(3145732@a2tech):8963	1	1h1s	1h1s
psql - unix(3146303@a2tech):8963	1	1h	1h
psql - unix(3147556@a2tech):8963	1	1h	1h

Checkpoints Buffers

Key values

134,777 buffers Checkpoint Peak
2026-05-01 06:39:34 Date
269.947 seconds Highest write time
0.009 seconds Sync time

Checkpoints Wal files

Key values

80 files Wal files usage Peak
2026-05-01 18:39:46 Date

Checkpoints distance

Key values

2,566.91 Mo Distance Peak
2026-05-01 06:39:34 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
May 01	00	6,100	430.07s	0.049s	430.163s
	01	4,354	433.225s	0.037s	433.292s
	02	454	44.622s	0.009s	44.638s
	03	1,635	161.413s	0.03s	161.467s
	04	4,049	402.298s	0.048s	402.381s
	05	7,065	488.487s	0.033s	488.544s
	06	211,077	879.885s	0.025s	879.981s
	07	40	3.918s	0.006s	3.932s
	08	21	2.008s	0.002s	2.015s
	09	20	1.907s	0.002s	1.912s
	10	20	1.909s	0.003s	1.915s
	11	21	2.008s	0.002s	2.013s
	12	21	2.008s	0.002s	2.012s
	13	21	2.008s	0.002s	2.013s
	14	20	1.908s	0.002s	1.913s
	15	21	2.008s	0.002s	2.014s
	16	21	2.007s	0.002s	2.013s
	17	21	2.007s	0.002s	2.013s
	18	208,324	586.729s	0.027s	586.834s
	19	27	2.619s	0.01s	2.649s
	20	227	22.755s	0.007s	22.772s
	21	44	4.217s	0.003s	4.225s
	22	21	2.008s	0.002s	2.014s
	23	32	3.219s	0.006s	3.237s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
May 01	00	8	0	664	0.004s	0.008s
	01	1	0	603	0.001s	0.008s
	02	0	0	130	0.001s	0.002s
	03	1	0	436	0.001s	0.006s
	04	2	0	713	0.001s	0.009s
	05	1	2	545	0.002s	0.007s
	06	0	129	366	0.001s	0.007s
	07	0	0	15	0.002s	0.003s
	08	0	0	3	0.002s	0.001s
	09	0	0	3	0.002s	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.001s	0.001s
	14	0	0	3	0.002s	0.001s
	15	0	0	3	0.002s	0.001s
	16	0	0	3	0.002s	0.001s
	17	0	0	3	0.002s	0.001s
	18	1	124	359	0.002s	0.008s
	19	0	0	10	0.003s	0.005s
	20	0	0	48	0.002s	0.004s
	21	0	0	11	0.001s	0.002s
	22	0	0	3	0.002s	0.001s
	23	0	0	13	0.001s	0.003s

Day	Hour	Avg time (sec)
May 01	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
May 01	00	17,131.88 kB	61,923.25 kB
	01	2,499.00 kB	28,150.00 kB
	02	1,670.50 kB	17,185.00 kB
	03	1,630.71 kB	4,161.86 kB
	04	2,804.67 kB	4,002.22 kB
	05	8,109.57 kB	28,453.29 kB
	06	302,357.29 kB	401,982.29 kB
	07	79.33 kB	1,020,959.33 kB
	08	158.00 kB	823,948.00 kB
	09	156.00 kB	741,569.00 kB
	10	153.00 kB	667,427.00 kB
	11	160.00 kB	600,700.00 kB
	12	158.00 kB	540,646.00 kB
	13	157.00 kB	486,597.00 kB
	14	155.00 kB	437,953.00 kB
	15	161.00 kB	394,174.00 kB
	16	159.00 kB	354,772.00 kB
	17	158.00 kB	319,311.00 kB
	18	255,749.38 kB	705,879.12 kB
	19	39.00 kB	754,510.40 kB
	20	643.67 kB	491,535.00 kB
	21	153.00 kB	376,903.50 kB
	22	157.00 kB	321,382.00 kB
	23	13.67 kB	261,286.33 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

519.46 MiB Temp Files size Peak
2026-05-01 06:33:34 Date

Number of temporary files

Key values

18 per second Temp Files Peak
2026-05-01 18:46:39 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
May 01	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	0	0	0
	04	0	0	0
	05	12	1.11 GiB	94.68 MiB
	06	163	2.11 GiB	13.25 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.11 GiB	13.24 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.22 GiB	8.00 KiB	483.20 MiB	13.24 MiB	select * from rs_posicao_oficina_estatica (?); SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); Date: 2026-05-01 18:33:53 Duration: 28m50s Database: rio User: intelifix Remote: [local] Application: psql - unix(3143389@a2tech):8963 SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); Date: 2026-05-01 06:33:46 Duration: 28m44s Database: rio User: intelifix Remote: [local] Application: psql - unix(3132684@a2tech):8963 SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); Date: 2026-05-01 18:45:28 Duration: 11m34s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3143908@a2tech):8963
2	8	858.72 MiB	65.94 MiB	221.07 MiB	107.34 MiB	refresh materialized view concurrently rs_mv_codigos_barra; REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; Date: 2026-05-01 05:31:08 Duration: 45s414ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3132034@a2tech):8963 REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; Date: 2026-05-01 05:31:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3132034@a2tech):8963
3	4	277.46 MiB	51.58 MiB	84.88 MiB	69.36 MiB	refresh materialized view concurrently rs_mv_equipamentos; REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; Date: 2026-05-01 05:30:22 Duration: 20s831ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3132027@a2tech):8963 REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; Date: 2026-05-01 05:30:20 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3132027@a2tech):8963

Rank

Count

Total size

Min size

Max size

Avg size

Query

1

326

4.22 GiB

8.00 KiB

483.20 MiB

13.24 MiB

select * from rs_posicao_oficina_estatica (?);

SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0);

Date: 2026-05-01 18:33:53 Duration: 28m50s Database: rio User: intelifix Remote: [local] Application: psql - unix(3143389@a2tech):8963
SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0);

Date: 2026-05-01 06:33:46 Duration: 28m44s Database: rio User: intelifix Remote: [local] Application: psql - unix(3132684@a2tech):8963
SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0);

Date: 2026-05-01 18:45:28 Duration: 11m34s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3143908@a2tech):8963

2

8

858.72 MiB

65.94 MiB

221.07 MiB

107.34 MiB

refresh materialized view concurrently rs_mv_codigos_barra;

REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;

Date: 2026-05-01 05:31:08 Duration: 45s414ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3132034@a2tech):8963
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;

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

3

4

277.46 MiB

51.58 MiB

84.88 MiB

69.36 MiB

refresh materialized view concurrently rs_mv_equipamentos;

REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;

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

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

Queries generating the largest temporary files


[ Date: 2026-05-01 06:33:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132684@a2tech):8963 ]
[ Date: 2026-05-01 18:33:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3143389@a2tech):8963 ]
[ Date: 2026-05-01 06:45:08 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3133116@a2tech):8963 ]
[ Date: 2026-05-01 18:45:22 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3143908@a2tech):8963 ]
[ Date: 2026-05-01 05:31:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132034@a2tech):8963 ]
[ Date: 2026-05-01 05:31:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132034@a2tech):8963 ]
[ Date: 2026-05-01 06:33:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132684@a2tech):8963 ]
[ Date: 2026-05-01 18:33:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3143389@a2tech):8963 ]
[ Date: 2026-05-01 06:45:07 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3133116@a2tech):8963 ]
[ Date: 2026-05-01 18:45:21 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3143908@a2tech):8963 ]
[ Date: 2026-05-01 05:30:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132027@a2tech):8963 ]
[ Date: 2026-05-01 05:30:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132027@a2tech):8963 ]
[ Date: 2026-05-01 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132034@a2tech):8963 ]
[ Date: 2026-05-01 05:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132034@a2tech):8963 ]
[ Date: 2026-05-01 05:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132034@a2tech):8963 ]
[ Date: 2026-05-01 05:31:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132034@a2tech):8963 ]
[ Date: 2026-05-01 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132034@a2tech):8963 ]
[ Date: 2026-05-01 05:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132034@a2tech):8963 ]
[ Date: 2026-05-01 06:05:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132684@a2tech):8963 ]
[ Date: 2026-05-01 18:05:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3143389@a2tech):8963 ]

Rank	Size	Query
1	483.20 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-05-01 06:33:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132684@a2tech):8963 ]
2	483.20 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-05-01 18:33:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3143389@a2tech):8963 ]
3	242.42 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-05-01 06:45:08 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3133116@a2tech):8963 ]
4	242.42 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-05-01 18:45:22 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3143908@a2tech):8963 ]
5	221.07 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-01 05:31:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132034@a2tech):8963 ]
6	221.07 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-01 05:31:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132034@a2tech):8963 ]
7	172.32 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-05-01 06:33:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132684@a2tech):8963 ]
8	172.32 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-05-01 18:33:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3143389@a2tech):8963 ]
9	96.05 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-05-01 06:45:07 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3133116@a2tech):8963 ]
10	96.05 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-05-01 18:45:21 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3143908@a2tech):8963 ]
11	84.88 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; [ Date: 2026-05-01 05:30:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132027@a2tech):8963 ]
12	84.88 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; [ Date: 2026-05-01 05:30:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132027@a2tech):8963 ]
13	72.93 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-01 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132034@a2tech):8963 ]
14	72.88 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-01 05:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132034@a2tech):8963 ]
15	72.87 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-01 05:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132034@a2tech):8963 ]
16	66.00 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-01 05:31:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132034@a2tech):8963 ]
17	65.95 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-01 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132034@a2tech):8963 ]
18	65.94 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-01 05:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132034@a2tech):8963 ]
19	62.20 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-05-01 06:05:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132684@a2tech):8963 ]
20	62.20 MiB	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-05-01 18:05:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3143389@a2tech):8963 ]

Vacuums / Analyzes Distribution

Key values

15.32 sec Highest CPU-cost vacuum
Table public.posicao_estoque14
Database rio
2026-05-01 18:34:29 Date
0 sec Highest CPU-cost analyze
Table
Database rio
Date

Average Autovacuum Duration

Key values

15.32 sec Highest CPU-cost vacuum
Table public.posicao_estoque14
Database rio
2026-05-01 18:34:29 Date

Analyzes per table

Key values

auditor.auditor_2026_05 (7) Main table analyzed (database rio)
29 analyzes Total

Chart
Table

Table	Number of analyzes
rio.auditor.auditor_2026_05	7
rio.public.temp0000278599	4
contagem.public.posicao_oficina_01	2
brasilia.public.posicao_oficina_01	2
rio.public.posicao_oficina_01	2
rio.pg_catalog.pg_depend	1
rio.public.temp0000278601	1
rio.pg_catalog.pg_class	1
rio.pg_catalog.pg_index	1
rio.public.posicao_estoque13	1
brasilia.public.posicao_estoque37	1
rio.public.posicao_estoque14	1
brasilia.public.posicao_estoque38	1
contagem.public.posicao_estoque36	1
brasilia.auditor.auditor_2026_05	1
contagem.public.posicao_estoque35	1
contagem.auditor.auditor_2026_05	1
Total	29

Vacuums per table

Key values

auditor.auditor_2026_05 (3) Main table vacuumed on database rio
26 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
rio.auditor.auditor_2026_05	3	0	6,980	0	2,275	0	0	2,388	5	165,176
contagem.public.posicao_oficina_01	2	0	9,765	0	648	0	0	4,628	2	289,810
rio.public.posicao_oficina_01	2	0	269,393	0	130,476	0	0	134,414	6	7,979,972
brasilia.public.posicao_oficina_01	2	0	136,146	0	63,898	0	0	67,946	4	4,041,966
contagem.public.posicao_estoque35	1	0	4,919	0	324	0	0	2,316	1	145,135
contagem.pg_toast.pg_toast_2618	1	1	113	0	22	0	0	88	23	43,645
brasilia.pg_catalog.pg_statistic	1	1	2,534	0	11	0	0	2,435	10	181,438
rio.pg_catalog.pg_statistic	1	1	2,956	0	17	0	0	2,773	15	208,972
brasilia.pg_toast.pg_toast_2619	1	1	243	0	3	0	0	188	4	27,115
contagem.auditor.auditor_2026_05	1	0	1,616	0	4	0	0	760	2	59,535
contagem.pg_catalog.pg_statistic	1	1	2,566	0	6	0	0	2,479	6	187,183
rio.pg_toast.pg_toast_2619	1	1	872	0	7	0	0	684	4	60,390
brasilia.auditor.auditor_2026_05	1	0	1,396	0	4	0	0	652	2	53,879
contagem.pg_catalog.pg_depend	1	1	825	0	191	0	0	414	161	647,936
contagem.public.posicao_estoque36	1	0	4,938	0	324	0	0	2,316	1	145,119
rio.pg_toast.pg_toast_2618	1	1	110	0	26	0	0	86	24	48,463
brasilia.public.posicao_estoque38	1	0	68,130	0	31,949	0	0	33,975	2	2,021,125
rio.public.posicao_estoque14	1	0	134,747	0	65,238	0	0	67,208	3	3,990,098
brasilia.public.posicao_estoque37	1	0	68,129	0	31,949	0	0	33,975	2	2,021,201
rio.public.posicao_estoque13	1	0	134,748	0	65,238	0	0	67,209	3	3,990,130
contagem.pg_toast.pg_toast_2619	1	1	234	0	1	0	0	143	2	24,537
Total	26	9	851,360	1,875	392,611	0	0	427,077	282	26,332,825

Tuples removed per table

Key values

pg_catalog.pg_statistic (3428) Main table with removed tuples on database rio
11302 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,428	7,809	0	0	1,279
contagem.pg_catalog.pg_statistic	1	1	3,189	7,336	0	0	922
brasilia.pg_catalog.pg_statistic	1	1	3,064	7,358	0	0	951
rio.pg_toast.pg_toast_2619	1	1	597	674	0	49	234
contagem.pg_catalog.pg_depend	1	1	579	17,528	0	0	183
brasilia.pg_toast.pg_toast_2619	1	1	164	139	0	0	75
contagem.pg_toast.pg_toast_2619	1	1	106	128	0	23	42
rio.pg_toast.pg_toast_2618	1	1	88	180	0	0	102
contagem.pg_toast.pg_toast_2618	1	1	87	187	0	0	102
contagem.public.posicao_estoque35	1	0	0	40,826	0	0	2,368
rio.auditor.auditor_2026_05	3	0	0	130,203	0	0	5,319
contagem.auditor.auditor_2026_05	1	0	0	26,544	0	0	759
contagem.public.posicao_oficina_01	2	0	0	81,652	0	0	4,736
rio.public.posicao_oficina_01	2	0	0	2,709,550	0	0	134,528
brasilia.auditor.auditor_2026_05	1	0	0	22,752	0	0	651
brasilia.public.posicao_oficina_01	2	0	0	1,569,574	0	0	67,968
contagem.public.posicao_estoque36	1	0	0	40,826	0	0	2,368
brasilia.public.posicao_estoque38	1	0	0	784,787	0	0	33,984
rio.public.posicao_estoque14	1	0	0	1,354,775	0	0	67,264
brasilia.public.posicao_estoque37	1	0	0	784,787	0	0	33,984
rio.public.posicao_estoque13	1	0	0	1,354,775	0	0	67,264
Total	26	9	11,302	8,942,390	0	72	425,083

Pages removed per table

Key values

pg_toast.pg_toast_2619 (49) Main table with removed pages on database rio
72 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
rio.pg_toast.pg_toast_2619	1	1	597	49
contagem.pg_toast.pg_toast_2619	1	1	106	23
contagem.public.posicao_estoque35	1	0	0	0
contagem.pg_toast.pg_toast_2618	1	1	87	0
brasilia.pg_catalog.pg_statistic	1	1	3064	0
rio.auditor.auditor_2026_05	3	0	0	0
rio.pg_catalog.pg_statistic	1	1	3428	0
brasilia.pg_toast.pg_toast_2619	1	1	164	0
contagem.auditor.auditor_2026_05	1	0	0	0
contagem.public.posicao_oficina_01	2	0	0	0
contagem.pg_catalog.pg_statistic	1	1	3189	0
rio.public.posicao_oficina_01	2	0	0	0
brasilia.auditor.auditor_2026_05	1	0	0	0
contagem.pg_catalog.pg_depend	1	1	579	0
brasilia.public.posicao_oficina_01	2	0	0	0
contagem.public.posicao_estoque36	1	0	0	0
rio.pg_toast.pg_toast_2618	1	1	88	0
brasilia.public.posicao_estoque38	1	0	0	0
rio.public.posicao_estoque14	1	0	0	0
brasilia.public.posicao_estoque37	1	0	0	0
rio.public.posicao_estoque13	1	0	0	0
Total	26	9	11,302	72

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
May 01	00	3	4
	01	1	4
	02	0	0
	03	0	1
	04	1	6
	05	6	2
	06	8	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	7	6
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

AccessExclusiveLock Main Lock Type
3 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
AccessExclusiveLock		3	23m37s	7m52s
	relation	3	23m37s	7m52s
	Total	3	23m37s	7m52s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	3	23m37s	1m26s	13m41s	7m52s	select * from rs_auditor_novas_tabelas (); SELECT * FROM RS_AUDITOR_NOVAS_TABELAS (); Date: 2026-05-01 00:15:43 Database: rio User: lenon Remote: [local] Application: psql - unix(3120562@a2tech):8963 SELECT * FROM RS_AUDITOR_NOVAS_TABELAS (); Date: 2026-05-01 00:24:13 Database: brasilia User: lenon Remote: [local] Application: psql - unix(3121398@a2tech):8963 SELECT * FROM RS_AUDITOR_NOVAS_TABELAS (); Date: 2026-05-01 00:25:40 Database: contagem User: lenon Remote: [local] Application: psql - unix(3121735@a2tech):8963

Rank

Count

Total time

Min time

Max time

Avg duration

Query

1

3

23m37s

1m26s

13m41s

7m52s

select * from rs_auditor_novas_tabelas ();

SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();

Date: 2026-05-01 00:15:43 Database: rio User: lenon Remote: [local] Application: psql - unix(3120562@a2tech):8963
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();

Date: 2026-05-01 00:24:13 Database: brasilia User: lenon Remote: [local] Application: psql - unix(3121398@a2tech):8963
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();

Date: 2026-05-01 00:25:40 Database: contagem User: lenon Remote: [local] Application: psql - unix(3121735@a2tech):8963

Queries that waited the most

Rank	Wait time	Query
1	13m41s	SELECT * FROM RS_AUDITOR_NOVAS_TABELAS (); [ Date: 2026-05-01 00:15:43 - Database: rio - User: lenon - Remote: [local] - Application: psql - unix(3120562@a2tech):8963 ]
2	8m29s	SELECT * FROM RS_AUDITOR_NOVAS_TABELAS (); [ Date: 2026-05-01 00:24:13 - Database: brasilia - User: lenon - Remote: [local] - Application: psql - unix(3121398@a2tech):8963 ]
3	1m26s	SELECT * FROM RS_AUDITOR_NOVAS_TABELAS (); [ Date: 2026-05-01 00:25:40 - Database: contagem - User: lenon - Remote: [local] - Application: psql - unix(3121735@a2tech):8963 ]

Rank

Wait time

Query

1

13m41s

SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();

[ Date: 2026-05-01 00:15:43 - Database: rio - User: lenon - Remote: [local] - Application: psql - unix(3120562@a2tech):8963 ]

2

8m29s

SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();

[ Date: 2026-05-01 00:24:13 - Database: brasilia - User: lenon - Remote: [local] - Application: psql - unix(3121398@a2tech):8963 ]

3

1m26s

SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();

[ Date: 2026-05-01 00:25:40 - Database: contagem - User: lenon - Remote: [local] - Application: psql - unix(3121735@a2tech):8963 ]

Queries by type

Key values

110 Total read queries
685 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	110	10.41%
INSERT	0	0.00%
UPDATE	0	0.00%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	685	64.81%
CTE	0	0.00%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%
OTHERS	262	24.79%

Queries by database

Key values

rio Main database
489 Requests
2h53m15s (rio)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
brasilia	Total	339	1h27m19s
	copy to	250	17m14s
	others	54	1m33s
	select	35	1h8m31s
contagem	Total	229	7m57s
	copy to	191	2m48s
	others	3	1m3s
	select	35	4m4s
rio	Total	489	2h53m15s
	copy to	244	40m4s
	others	205	6m4s
	select	40	2h7m6s

Queries by user

Key values

intelifix Main user
1,054 Requests

Queries Chart
Table

User	Request type	Count	Duration
intelifix	Total	1,054	4h4m54s
	copy to	685	1h8s
	others	262	8m42s
	select	107	2h56m3s
lenon	Total	3	23m37s
	select	3	23m37s

Duration by user

Key values

4h4m54s (intelifix) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
intelifix	Total	1,054	4h4m54s
	copy to	685	1h8s
	others	262	8m42s
	select	107	2h56m3s
lenon	Total	3	23m37s
	select	3	23m37s

Queries by host

Key values

[local] Main host
1,057 Requests
4h28m32s ([local])
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
[local]	Total	1,057	4h28m32s
	copy to	685	1h8s
	others	262	8m42s
	select	110	3h19m41s

Queries by application

Key values

pg_dump Main application
685 Requests
1h8s (pg_dump)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
app - 127.0.0.1:36912	Total	1	202ms
	select	1	202ms
app - 127.0.0.1:37402	Total	1	179ms
	select	1	179ms
app - 127.0.0.1:40798	Total	1	211ms
	select	1	211ms
app - 127.0.0.1:46760	Total	1	256ms
	select	1	256ms
app - 127.0.0.1:58122	Total	1	216ms
	select	1	216ms
pg_dump	Total	685	1h8s
	copy to	685	1h8s
psql - unix(3120562@a2tech):8963	Total	1	13m41s
	select	1	13m41s
psql - unix(3120610@a2tech):8963	Total	1	6s214ms
	others	1	6s214ms
psql - unix(3120611@a2tech):8963	Total	1	4s423ms
	others	1	4s423ms
psql - unix(3120616@a2tech):8963	Total	1	3s772ms
	others	1	3s772ms
psql - unix(3120620@a2tech):8963	Total	1	1s253ms
	others	1	1s253ms
psql - unix(3120628@a2tech):8963	Total	1	207ms
	others	1	207ms
psql - unix(3120629@a2tech):8963	Total	1	4s274ms
	others	1	4s274ms
psql - unix(3121269@a2tech):8963	Total	1	281ms
	others	1	281ms
psql - unix(3121272@a2tech):8963	Total	1	1s339ms
	others	1	1s339ms
psql - unix(3121281@a2tech):8963	Total	1	253ms
	others	1	253ms
psql - unix(3121398@a2tech):8963	Total	1	8m29s
	select	1	8m29s
psql - unix(3121735@a2tech):8963	Total	1	1m26s
	select	1	1m26s
psql - unix(3121754@a2tech):8963	Total	1	597ms
	others	1	597ms
psql - unix(3121757@a2tech):8963	Total	1	1s547ms
	others	1	1s547ms
psql - unix(3121765@a2tech):8963	Total	1	197ms
	others	1	197ms
psql - unix(3121945@a2tech):8963	Total	1	384ms
	others	1	384ms
psql - unix(3121951@a2tech):8963	Total	1	1s135ms
	others	1	1s135ms
psql - unix(3122092@a2tech):8963	Total	1	618ms
	others	1	618ms
psql - unix(3122097@a2tech):8963	Total	1	1s118ms
	others	1	1s118ms
psql - unix(3122258@a2tech):8963	Total	1	570ms
	others	1	570ms
psql - unix(3122262@a2tech):8963	Total	1	1s97ms
	others	1	1s97ms
psql - unix(3122271@a2tech):8963	Total	1	197ms
	others	1	197ms
psql - unix(3122422@a2tech):8963	Total	1	286ms
	others	1	286ms
psql - unix(3122427@a2tech):8963	Total	1	1s103ms
	others	1	1s103ms
psql - unix(3122558@a2tech):8963	Total	1	226ms
	others	1	226ms
psql - unix(3122561@a2tech):8963	Total	1	1s147ms
	others	1	1s147ms
psql - unix(3123649@a2tech):8963	Total	1	417ms
	others	1	417ms
psql - unix(3123652@a2tech):8963	Total	1	1s71ms
	others	1	1s71ms
psql - unix(3124926@a2tech):8963	Total	1	201ms
	others	1	201ms
psql - unix(3124930@a2tech):8963	Total	1	1s85ms
	others	1	1s85ms
psql - unix(3125097@a2tech):8963	Total	1	531ms
	others	1	531ms
psql - unix(3125100@a2tech):8963	Total	1	1s99ms
	others	1	1s99ms
psql - unix(3125224@a2tech):8963	Total	1	194ms
	others	1	194ms
psql - unix(3125227@a2tech):8963	Total	1	1s135ms
	others	1	1s135ms
psql - unix(3125398@a2tech):8963	Total	1	683ms
	others	1	683ms
psql - unix(3125407@a2tech):8963	Total	1	1s114ms
	others	1	1s114ms
psql - unix(3125527@a2tech):8963	Total	1	1s108ms
	others	1	1s108ms
psql - unix(3125536@a2tech):8963	Total	1	153ms
	others	1	153ms
psql - unix(3125658@a2tech):8963	Total	1	1s52ms
	others	1	1s52ms
psql - unix(3125785@a2tech):8963	Total	1	1s151ms
	others	1	1s151ms
psql - unix(3125920@a2tech):8963	Total	1	1s153ms
	others	1	1s153ms
psql - unix(3126041@a2tech):8963	Total	1	1s75ms
	others	1	1s75ms
psql - unix(3126530@a2tech):8963	Total	1	602ms
	others	1	602ms
psql - unix(3126582@a2tech):8963	Total	1	1s164ms
	others	1	1s164ms
psql - unix(3126590@a2tech):8963	Total	1	168ms
	others	1	168ms
psql - unix(3126715@a2tech):8963	Total	1	399ms
	others	1	399ms
psql - unix(3126720@a2tech):8963	Total	1	1s90ms
	others	1	1s90ms
psql - unix(3126730@a2tech):8963	Total	1	156ms
	others	1	156ms
psql - unix(3126856@a2tech):8963	Total	1	254ms
	others	1	254ms
psql - unix(3126860@a2tech):8963	Total	1	1s57ms
	others	1	1s57ms
psql - unix(3127042@a2tech):8963	Total	1	548ms
	others	1	548ms
psql - unix(3127048@a2tech):8963	Total	1	1s143ms
	others	1	1s143ms
psql - unix(3127057@a2tech):8963	Total	1	161ms
	others	1	161ms
psql - unix(3127178@a2tech):8963	Total	1	219ms
	others	1	219ms
psql - unix(3127181@a2tech):8963	Total	1	1s109ms
	others	1	1s109ms
psql - unix(3127321@a2tech):8963	Total	1	423ms
	others	1	423ms
psql - unix(3127324@a2tech):8963	Total	1	1s144ms
	others	1	1s144ms
psql - unix(3127462@a2tech):8963	Total	1	1s95ms
	others	1	1s95ms
psql - unix(3127665@a2tech):8963	Total	1	488ms
	others	1	488ms
psql - unix(3127669@a2tech):8963	Total	1	1s133ms
	others	1	1s133ms
psql - unix(3127874@a2tech):8963	Total	1	1s89ms
	others	1	1s89ms
psql - unix(3127884@a2tech):8963	Total	1	157ms
	others	1	157ms
psql - unix(3128551@a2tech):8963	Total	1	648ms
	others	1	648ms
psql - unix(3128557@a2tech):8963	Total	1	1s124ms
	others	1	1s124ms
psql - unix(3128566@a2tech):8963	Total	1	160ms
	others	1	160ms
psql - unix(3130472@a2tech):8963	Total	1	220ms
	others	1	220ms
psql - unix(3130475@a2tech):8963	Total	1	1s112ms
	others	1	1s112ms
psql - unix(3131414@a2tech):8963	Total	1	339ms
	others	1	339ms
psql - unix(3131417@a2tech):8963	Total	1	1s55ms
	others	1	1s55ms
psql - unix(3131512@a2tech):8963	Total	1	1m52s
	others	1	1m52s
psql - unix(3131551@a2tech):8963	Total	1	1m18s
	others	1	1m18s
psql - unix(3131573@a2tech):8963	Total	1	57s485ms
	others	1	57s485ms
psql - unix(3131616@a2tech):8963	Total	1	940ms
	others	1	940ms
psql - unix(3131621@a2tech):8963	Total	1	1s89ms
	others	1	1s89ms
psql - unix(3131784@a2tech):8963	Total	1	1s8ms
	others	1	1s8ms
psql - unix(3131787@a2tech):8963	Total	1	1s217ms
	others	1	1s217ms
psql - unix(3131936@a2tech):8963	Total	1	615ms
	others	1	615ms
psql - unix(3131940@a2tech):8963	Total	1	1s142ms
	others	1	1s142ms
psql - unix(3132027@a2tech):8963	Total	1	20s831ms
	others	1	20s831ms
psql - unix(3132034@a2tech):8963	Total	1	45s414ms
	others	1	45s414ms
psql - unix(3132250@a2tech):8963	Total	1	195ms
	others	1	195ms
psql - unix(3132254@a2tech):8963	Total	1	1s74ms
	others	1	1s74ms
psql - unix(3132384@a2tech):8963	Total	1	1s41ms
	others	1	1s41ms
psql - unix(3132392@a2tech):8963	Total	1	183ms
	others	1	183ms
psql - unix(3132503@a2tech):8963	Total	1	1s70ms
	others	1	1s70ms
psql - unix(3132684@a2tech):8963	Total	1	28m44s
	select	1	28m44s
psql - unix(3132707@a2tech):8963	Total	1	1s212ms
	others	1	1s212ms
psql - unix(3132708@a2tech):8963	Total	1	2s325ms
	others	1	2s325ms
psql - unix(3132737@a2tech):8963	Total	1	2s62ms
	others	1	2s62ms
psql - unix(3132739@a2tech):8963	Total	1	2s137ms
	others	1	2s137ms
psql - unix(3132838@a2tech):8963	Total	1	1s655ms
	others	1	1s655ms
psql - unix(3132847@a2tech):8963	Total	1	192ms
	others	1	192ms
psql - unix(3132967@a2tech):8963	Total	1	1s97ms
	others	1	1s97ms
psql - unix(3133116@a2tech):8963	Total	1	11m28s
	select	1	11m28s
psql - unix(3133162@a2tech):8963	Total	1	1s103ms
	others	1	1s103ms
psql - unix(3133173@a2tech):8963	Total	1	184ms
	others	1	184ms
psql - unix(3133288@a2tech):8963	Total	1	1s187ms
	others	1	1s187ms
psql - unix(3133364@a2tech):8963	Total	1	1m11s
	select	1	1m11s
psql - unix(3133515@a2tech):8963	Total	1	1s28ms
	others	1	1s28ms
psql - unix(3133656@a2tech):8963	Total	1	3m16s
	select	1	3m16s
psql - unix(3133663@a2tech):8963	Total	1	1s158ms
	others	1	1s158ms
psql - unix(3133720@a2tech):8963	Total	1	20s351ms
	select	1	20s351ms
psql - unix(3133729@a2tech):8963	Total	1	8s759ms
	select	1	8s759ms
psql - unix(3133733@a2tech):8963	Total	1	2m10s
	select	1	2m10s
psql - unix(3133760@a2tech):8963	Total	1	667ms
	select	1	667ms
psql - unix(3133765@a2tech):8963	Total	1	420ms
	select	1	420ms
psql - unix(3133817@a2tech):8963	Total	1	1s112ms
	others	1	1s112ms
psql - unix(3133945@a2tech):8963	Total	1	1s155ms
	others	1	1s155ms
psql - unix(3134069@a2tech):8963	Total	1	1s236ms
	others	1	1s236ms
psql - unix(3134192@a2tech):8963	Total	1	1s55ms
	others	1	1s55ms
psql - unix(3134307@a2tech):8963	Total	1	1s141ms
	others	1	1s141ms
psql - unix(3134426@a2tech):8963	Total	1	559ms
	others	1	559ms
psql - unix(3134428@a2tech):8963	Total	1	224ms
	others	1	224ms
psql - unix(3134509@a2tech):8963	Total	1	3m12s
	select	1	3m12s
psql - unix(3134513@a2tech):8963	Total	1	1s176ms
	others	1	1s176ms
psql - unix(3134568@a2tech):8963	Total	1	17s742ms
	select	1	17s742ms
psql - unix(3134578@a2tech):8963	Total	1	8s377ms
	select	1	8s377ms
psql - unix(3134583@a2tech):8963	Total	1	2m9s
	select	1	2m9s
psql - unix(3134611@a2tech):8963	Total	1	493ms
	select	1	493ms
psql - unix(3134614@a2tech):8963	Total	1	309ms
	select	1	309ms
psql - unix(3134666@a2tech):8963	Total	1	1s84ms
	others	1	1s84ms
psql - unix(3134744@a2tech):8963	Total	1	222ms
	others	1	222ms
psql - unix(3134748@a2tech):8963	Total	1	227ms
	others	1	227ms
psql - unix(3134806@a2tech):8963	Total	1	1s81ms
	others	1	1s81ms
psql - unix(3134946@a2tech):8963	Total	1	1s65ms
	others	1	1s65ms
psql - unix(3135024@a2tech):8963	Total	1	272ms
	others	1	272ms
psql - unix(3135080@a2tech):8963	Total	1	1s102ms
	others	1	1s102ms
psql - unix(3135199@a2tech):8963	Total	1	1s60ms
	others	1	1s60ms
psql - unix(3135274@a2tech):8963	Total	1	234ms
	others	1	234ms
psql - unix(3135348@a2tech):8963	Total	1	3m8s
	select	1	3m8s
psql - unix(3135356@a2tech):8963	Total	1	1s166ms
	others	1	1s166ms
psql - unix(3135414@a2tech):8963	Total	1	17s413ms
	select	1	17s413ms
psql - unix(3135421@a2tech):8963	Total	1	8s216ms
	select	1	8s216ms
psql - unix(3135427@a2tech):8963	Total	1	2m9s
	select	1	2m9s
psql - unix(3135454@a2tech):8963	Total	1	530ms
	select	1	530ms
psql - unix(3135458@a2tech):8963	Total	1	335ms
	select	1	335ms
psql - unix(3135514@a2tech):8963	Total	1	1s45ms
	others	1	1s45ms
psql - unix(3135522@a2tech):8963	Total	1	177ms
	others	1	177ms
psql - unix(3135590@a2tech):8963	Total	1	245ms
	others	1	245ms
psql - unix(3135651@a2tech):8963	Total	1	1s31ms
	others	1	1s31ms
psql - unix(3135659@a2tech):8963	Total	1	158ms
	others	1	158ms
psql - unix(3135781@a2tech):8963	Total	1	1s69ms
	others	1	1s69ms
psql - unix(3135853@a2tech):8963	Total	1	150ms
	others	1	150ms
psql - unix(3135914@a2tech):8963	Total	1	1s37ms
	others	1	1s37ms
psql - unix(3136038@a2tech):8963	Total	1	1s53ms
	others	1	1s53ms
psql - unix(3136154@a2tech):8963	Total	1	243ms
	others	1	243ms
psql - unix(3136427@a2tech):8963	Total	1	3m12s
	select	1	3m12s
psql - unix(3136435@a2tech):8963	Total	1	1s197ms
	others	1	1s197ms
psql - unix(3136599@a2tech):8963	Total	1	17s943ms
	select	1	17s943ms
psql - unix(3136619@a2tech):8963	Total	1	8s384ms
	select	1	8s384ms
psql - unix(3136626@a2tech):8963	Total	1	2m9s
	select	1	2m9s
psql - unix(3136725@a2tech):8963	Total	1	548ms
	select	1	548ms
psql - unix(3136732@a2tech):8963	Total	1	357ms
	select	1	357ms
psql - unix(3136790@a2tech):8963	Total	1	1s18ms
	others	1	1s18ms
psql - unix(3136798@a2tech):8963	Total	1	150ms
	others	1	150ms
psql - unix(3136863@a2tech):8963	Total	1	247ms
	others	1	247ms
psql - unix(3136868@a2tech):8963	Total	1	267ms
	others	1	267ms
psql - unix(3136928@a2tech):8963	Total	1	1s95ms
	others	1	1s95ms
psql - unix(3136936@a2tech):8963	Total	1	181ms
	others	1	181ms
psql - unix(3137058@a2tech):8963	Total	1	1s73ms
	others	1	1s73ms
psql - unix(3137132@a2tech):8963	Total	1	230ms
	others	1	230ms
psql - unix(3137192@a2tech):8963	Total	1	1s17ms
	others	1	1s17ms
psql - unix(3137310@a2tech):8963	Total	1	1s130ms
	others	1	1s130ms
psql - unix(3137385@a2tech):8963	Total	1	248ms
	others	1	248ms
psql - unix(3137471@a2tech):8963	Total	1	3m13s
	select	1	3m13s
psql - unix(3137475@a2tech):8963	Total	1	1s81ms
	others	1	1s81ms
psql - unix(3137532@a2tech):8963	Total	1	17s930ms
	select	1	17s930ms
psql - unix(3137539@a2tech):8963	Total	1	8s314ms
	select	1	8s314ms
psql - unix(3137543@a2tech):8963	Total	1	2m9s
	select	1	2m9s
psql - unix(3137573@a2tech):8963	Total	1	544ms
	select	1	544ms
psql - unix(3137577@a2tech):8963	Total	1	340ms
	select	1	340ms
psql - unix(3137632@a2tech):8963	Total	1	1s62ms
	others	1	1s62ms
psql - unix(3137730@a2tech):8963	Total	1	243ms
	others	1	243ms
psql - unix(3137811@a2tech):8963	Total	1	1s99ms
	others	1	1s99ms
psql - unix(3137819@a2tech):8963	Total	1	153ms
	others	1	153ms
psql - unix(3137938@a2tech):8963	Total	1	1s81ms
	others	1	1s81ms
psql - unix(3137949@a2tech):8963	Total	1	153ms
	others	1	153ms
psql - unix(3138014@a2tech):8963	Total	1	166ms
	others	1	166ms
psql - unix(3138016@a2tech):8963	Total	1	207ms
	others	1	207ms
psql - unix(3138070@a2tech):8963	Total	1	1s62ms
	others	1	1s62ms
psql - unix(3138190@a2tech):8963	Total	1	1s148ms
	others	1	1s148ms
psql - unix(3138263@a2tech):8963	Total	1	154ms
	others	1	154ms
psql - unix(3138338@a2tech):8963	Total	1	3m10s
	select	1	3m10s
psql - unix(3138345@a2tech):8963	Total	1	1s118ms
	others	1	1s118ms
psql - unix(3138404@a2tech):8963	Total	1	17s808ms
	select	1	17s808ms
psql - unix(3138410@a2tech):8963	Total	1	8s200ms
	select	1	8s200ms
psql - unix(3138415@a2tech):8963	Total	1	2m9s
	select	1	2m9s
psql - unix(3138450@a2tech):8963	Total	1	542ms
	select	1	542ms
psql - unix(3138453@a2tech):8963	Total	1	331ms
	select	1	331ms
psql - unix(3138507@a2tech):8963	Total	1	1s159ms
	others	1	1s159ms
psql - unix(3138582@a2tech):8963	Total	1	216ms
	others	1	216ms
psql - unix(3138639@a2tech):8963	Total	1	1s56ms
	others	1	1s56ms
psql - unix(3138763@a2tech):8963	Total	1	1s115ms
	others	1	1s115ms
psql - unix(3138840@a2tech):8963	Total	1	156ms
	others	1	156ms
psql - unix(3138842@a2tech):8963	Total	1	229ms
	others	1	229ms
psql - unix(3138902@a2tech):8963	Total	1	1s53ms
	others	1	1s53ms
psql - unix(3138910@a2tech):8963	Total	1	155ms
	others	1	155ms
psql - unix(3139023@a2tech):8963	Total	1	1s74ms
	others	1	1s74ms
psql - unix(3139096@a2tech):8963	Total	1	239ms
	others	1	239ms
psql - unix(3139099@a2tech):8963	Total	1	206ms
	others	1	206ms
psql - unix(3139178@a2tech):8963	Total	1	3m13s
	select	1	3m13s
psql - unix(3139187@a2tech):8963	Total	1	1s152ms
	others	1	1s152ms
psql - unix(3139243@a2tech):8963	Total	1	17s854ms
	select	1	17s854ms
psql - unix(3139251@a2tech):8963	Total	1	8s326ms
	select	1	8s326ms
psql - unix(3139255@a2tech):8963	Total	1	2m10s
	select	1	2m10s
psql - unix(3139280@a2tech):8963	Total	1	536ms
	select	1	536ms
psql - unix(3139284@a2tech):8963	Total	1	351ms
	select	1	351ms
psql - unix(3139338@a2tech):8963	Total	1	1s91ms
	others	1	1s91ms
psql - unix(3139412@a2tech):8963	Total	1	222ms
	others	1	222ms
psql - unix(3139468@a2tech):8963	Total	1	1s67ms
	others	1	1s67ms
psql - unix(3139592@a2tech):8963	Total	1	1s180ms
	others	1	1s180ms
psql - unix(3139672@a2tech):8963	Total	1	251ms
	others	1	251ms
psql - unix(3139739@a2tech):8963	Total	1	1s18ms
	others	1	1s18ms
psql - unix(3139862@a2tech):8963	Total	1	1s39ms
	others	1	1s39ms
psql - unix(3139871@a2tech):8963	Total	1	155ms
	others	1	155ms
psql - unix(3139937@a2tech):8963	Total	1	172ms
	others	1	172ms
psql - unix(3139942@a2tech):8963	Total	1	219ms
	others	1	219ms
psql - unix(3140018@a2tech):8963	Total	1	3m7s
	select	1	3m7s
psql - unix(3140021@a2tech):8963	Total	1	1s149ms
	others	1	1s149ms
psql - unix(3140076@a2tech):8963	Total	1	17s760ms
	select	1	17s760ms
psql - unix(3140084@a2tech):8963	Total	1	8s418ms
	select	1	8s418ms
psql - unix(3140089@a2tech):8963	Total	1	2m9s
	select	1	2m9s
psql - unix(3140115@a2tech):8963	Total	1	532ms
	select	1	532ms
psql - unix(3140119@a2tech):8963	Total	1	335ms
	select	1	335ms
psql - unix(3140172@a2tech):8963	Total	1	1s28ms
	others	1	1s28ms
psql - unix(3140249@a2tech):8963	Total	1	226ms
	others	1	226ms
psql - unix(3140307@a2tech):8963	Total	1	1s44ms
	others	1	1s44ms
psql - unix(3140433@a2tech):8963	Total	1	1s106ms
	others	1	1s106ms
psql - unix(3140527@a2tech):8963	Total	1	237ms
	others	1	237ms
psql - unix(3140591@a2tech):8963	Total	1	1s165ms
	others	1	1s165ms
psql - unix(3140599@a2tech):8963	Total	1	150ms
	others	1	150ms
psql - unix(3140710@a2tech):8963	Total	1	1s70ms
	others	1	1s70ms
psql - unix(3140784@a2tech):8963	Total	1	235ms
	others	1	235ms
psql - unix(3140862@a2tech):8963	Total	1	3m7s
	select	1	3m7s
psql - unix(3140871@a2tech):8963	Total	1	1s168ms
	others	1	1s168ms
psql - unix(3140924@a2tech):8963	Total	1	17s263ms
	select	1	17s263ms
psql - unix(3140931@a2tech):8963	Total	1	8s317ms
	select	1	8s317ms
psql - unix(3140936@a2tech):8963	Total	1	2m9s
	select	1	2m9s
psql - unix(3140962@a2tech):8963	Total	1	530ms
	select	1	530ms
psql - unix(3140966@a2tech):8963	Total	1	367ms
	select	1	367ms
psql - unix(3141018@a2tech):8963	Total	1	1s31ms
	others	1	1s31ms
psql - unix(3141130@a2tech):8963	Total	1	232ms
	others	1	232ms
psql - unix(3141132@a2tech):8963	Total	1	216ms
	others	1	216ms
psql - unix(3141185@a2tech):8963	Total	1	1s56ms
	others	1	1s56ms
psql - unix(3141311@a2tech):8963	Total	1	1s30ms
	others	1	1s30ms
psql - unix(3141448@a2tech):8963	Total	1	1s70ms
	others	1	1s70ms
psql - unix(3141565@a2tech):8963	Total	1	1s40ms
	others	1	1s40ms
psql - unix(3141716@a2tech):8963	Total	1	3m8s
	select	1	3m8s
psql - unix(3141724@a2tech):8963	Total	1	1s172ms
	others	1	1s172ms
psql - unix(3141735@a2tech):8963	Total	1	153ms
	others	1	153ms
psql - unix(3141782@a2tech):8963	Total	1	17s877ms
	select	1	17s877ms
psql - unix(3141790@a2tech):8963	Total	1	8s335ms
	select	1	8s335ms
psql - unix(3141795@a2tech):8963	Total	1	2m10s
	select	1	2m10s
psql - unix(3141822@a2tech):8963	Total	1	548ms
	select	1	548ms
psql - unix(3141826@a2tech):8963	Total	1	327ms
	select	1	327ms
psql - unix(3141887@a2tech):8963	Total	1	1s36ms
	others	1	1s36ms
psql - unix(3141961@a2tech):8963	Total	1	222ms
	others	1	222ms
psql - unix(3141963@a2tech):8963	Total	1	233ms
	others	1	233ms
psql - unix(3142020@a2tech):8963	Total	1	1s72ms
	others	1	1s72ms
psql - unix(3142142@a2tech):8963	Total	1	1s58ms
	others	1	1s58ms
psql - unix(3142278@a2tech):8963	Total	1	1s154ms
	others	1	1s154ms
psql - unix(3142393@a2tech):8963	Total	1	1s53ms
	others	1	1s53ms
psql - unix(3142466@a2tech):8963	Total	1	172ms
	others	1	172ms
psql - unix(3142544@a2tech):8963	Total	1	3m6s
	select	1	3m6s
psql - unix(3142551@a2tech):8963	Total	1	1s142ms
	others	1	1s142ms
psql - unix(3142609@a2tech):8963	Total	1	17s599ms
	select	1	17s599ms
psql - unix(3142618@a2tech):8963	Total	1	8s437ms
	select	1	8s437ms
psql - unix(3142622@a2tech):8963	Total	1	2m10s
	select	1	2m10s
psql - unix(3142648@a2tech):8963	Total	1	538ms
	select	1	538ms
psql - unix(3142652@a2tech):8963	Total	1	332ms
	select	1	332ms
psql - unix(3142710@a2tech):8963	Total	1	1s106ms
	others	1	1s106ms
psql - unix(3142785@a2tech):8963	Total	1	231ms
	others	1	231ms
psql - unix(3142787@a2tech):8963	Total	1	229ms
	others	1	229ms
psql - unix(3142845@a2tech):8963	Total	1	1s56ms
	others	1	1s56ms
psql - unix(3142853@a2tech):8963	Total	1	157ms
	others	1	157ms
psql - unix(3142969@a2tech):8963	Total	1	1s45ms
	others	1	1s45ms
psql - unix(3143043@a2tech):8963	Total	1	160ms
	others	1	160ms
psql - unix(3143047@a2tech):8963	Total	1	230ms
	others	1	230ms
psql - unix(3143101@a2tech):8963	Total	1	1s36ms
	others	1	1s36ms
psql - unix(3143226@a2tech):8963	Total	1	1s32ms
	others	1	1s32ms
psql - unix(3143310@a2tech):8963	Total	1	161ms
	others	1	161ms
psql - unix(3143389@a2tech):8963	Total	1	28m50s
	select	1	28m50s
psql - unix(3143395@a2tech):8963	Total	1	3m10s
	select	1	3m10s
psql - unix(3143424@a2tech):8963	Total	1	1s239ms
	others	1	1s239ms
psql - unix(3143437@a2tech):8963	Total	1	159ms
	others	1	159ms
psql - unix(3143485@a2tech):8963	Total	1	18s188ms
	select	1	18s188ms
psql - unix(3143493@a2tech):8963	Total	1	9s32ms
	select	1	9s32ms
psql - unix(3143498@a2tech):8963	Total	1	2m14s
	select	1	2m14s
psql - unix(3143528@a2tech):8963	Total	1	634ms
	select	1	634ms
psql - unix(3143533@a2tech):8963	Total	1	361ms
	select	1	361ms
psql - unix(3143590@a2tech):8963	Total	1	1s46ms
	others	1	1s46ms
psql - unix(3143658@a2tech):8963	Total	1	228ms
	others	1	228ms
psql - unix(3143716@a2tech):8963	Total	1	1s51ms
	others	1	1s51ms
psql - unix(3143724@a2tech):8963	Total	1	156ms
	others	1	156ms
psql - unix(3143908@a2tech):8963	Total	1	11m34s
	select	1	11m34s
psql - unix(3143951@a2tech):8963	Total	1	1s135ms
	others	1	1s135ms
psql - unix(3144026@a2tech):8963	Total	1	211ms
	others	1	211ms
psql - unix(3144084@a2tech):8963	Total	1	1s44ms
	others	1	1s44ms
psql - unix(3144161@a2tech):8963	Total	1	1m11s
	select	1	1m11s
psql - unix(3144297@a2tech):8963	Total	1	1s51ms
	others	1	1s51ms
psql - unix(3144370@a2tech):8963	Total	1	205ms
	others	1	205ms
psql - unix(3144451@a2tech):8963	Total	1	3m14s
	select	1	3m14s
psql - unix(3144458@a2tech):8963	Total	1	1s178ms
	others	1	1s178ms
psql - unix(3144514@a2tech):8963	Total	1	18s160ms
	select	1	18s160ms
psql - unix(3144523@a2tech):8963	Total	1	8s197ms
	select	1	8s197ms
psql - unix(3144528@a2tech):8963	Total	1	2m9s
	select	1	2m9s
psql - unix(3144553@a2tech):8963	Total	1	516ms
	select	1	516ms
psql - unix(3144556@a2tech):8963	Total	1	306ms
	select	1	306ms
psql - unix(3144609@a2tech):8963	Total	1	1s51ms
	others	1	1s51ms
psql - unix(3144679@a2tech):8963	Total	1	235ms
	others	1	235ms
psql - unix(3144738@a2tech):8963	Total	1	1s159ms
	others	1	1s159ms
psql - unix(3144746@a2tech):8963	Total	1	157ms
	others	1	157ms
psql - unix(3144863@a2tech):8963	Total	1	1s103ms
	others	1	1s103ms
psql - unix(3144875@a2tech):8963	Total	1	153ms
	others	1	153ms
psql - unix(3144936@a2tech):8963	Total	1	276ms
	others	1	276ms
psql - unix(3144938@a2tech):8963	Total	1	222ms
	others	1	222ms
psql - unix(3145002@a2tech):8963	Total	1	1s91ms
	others	1	1s91ms
psql - unix(3145118@a2tech):8963	Total	1	1s78ms
	others	1	1s78ms
psql - unix(3145295@a2tech):8963	Total	1	3m14s
	select	1	3m14s
psql - unix(3145298@a2tech):8963	Total	1	1s105ms
	others	1	1s105ms
psql - unix(3145358@a2tech):8963	Total	1	18s181ms
	select	1	18s181ms
psql - unix(3145369@a2tech):8963	Total	1	8s660ms
	select	1	8s660ms
psql - unix(3145374@a2tech):8963	Total	1	2m10s
	select	1	2m10s
psql - unix(3145399@a2tech):8963	Total	1	572ms
	select	1	572ms
psql - unix(3145403@a2tech):8963	Total	1	355ms
	select	1	355ms
psql - unix(3145459@a2tech):8963	Total	1	1s72ms
	others	1	1s72ms
psql - unix(3145533@a2tech):8963	Total	1	266ms
	others	1	266ms
psql - unix(3145590@a2tech):8963	Total	1	1s37ms
	others	1	1s37ms
psql - unix(3145732@a2tech):8963	Total	1	1s47ms
	others	1	1s47ms
psql - unix(3145742@a2tech):8963	Total	1	169ms
	others	1	169ms
psql - unix(3145802@a2tech):8963	Total	1	255ms
	others	1	255ms
psql - unix(3145807@a2tech):8963	Total	1	206ms
	others	1	206ms
psql - unix(3145866@a2tech):8963	Total	1	1s114ms
	others	1	1s114ms
psql - unix(3145984@a2tech):8963	Total	1	1s34ms
	others	1	1s34ms
psql - unix(3146057@a2tech):8963	Total	1	247ms
	others	1	247ms
psql - unix(3146144@a2tech):8963	Total	1	3m12s
	select	1	3m12s
psql - unix(3146151@a2tech):8963	Total	1	1s189ms
	others	1	1s189ms
psql - unix(3146205@a2tech):8963	Total	1	17s683ms
	select	1	17s683ms
psql - unix(3146213@a2tech):8963	Total	1	8s283ms
	select	1	8s283ms
psql - unix(3146219@a2tech):8963	Total	1	2m10s
	select	1	2m10s
psql - unix(3146248@a2tech):8963	Total	1	545ms
	select	1	545ms
psql - unix(3146252@a2tech):8963	Total	1	337ms
	select	1	337ms
psql - unix(3146303@a2tech):8963	Total	1	1s71ms
	others	1	1s71ms
psql - unix(3146369@a2tech):8963	Total	1	253ms
	others	1	253ms
psql - unix(3146434@a2tech):8963	Total	1	1s169ms
	others	1	1s169ms
psql - unix(3146567@a2tech):8963	Total	1	1s117ms
	others	1	1s117ms
psql - unix(3146638@a2tech):8963	Total	1	228ms
	others	1	228ms
psql - unix(3146640@a2tech):8963	Total	1	248ms
	others	1	248ms
psql - unix(3146699@a2tech):8963	Total	1	1s151ms
	others	1	1s151ms
psql - unix(3146708@a2tech):8963	Total	1	163ms
	others	1	163ms
psql - unix(3146824@a2tech):8963	Total	1	1s39ms
	others	1	1s39ms
psql - unix(3146932@a2tech):8963	Total	1	154ms
	others	1	154ms
psql - unix(3147018@a2tech):8963	Total	1	3m12s
	select	1	3m12s
psql - unix(3147060@a2tech):8963	Total	1	1s188ms
	others	1	1s188ms
psql - unix(3147184@a2tech):8963	Total	1	17s878ms
	select	1	17s878ms
psql - unix(3147192@a2tech):8963	Total	1	8s358ms
	select	1	8s358ms
psql - unix(3147198@a2tech):8963	Total	1	2m10s
	select	1	2m10s
psql - unix(3147225@a2tech):8963	Total	1	543ms
	select	1	543ms
psql - unix(3147230@a2tech):8963	Total	1	348ms
	select	1	348ms
psql - unix(3147283@a2tech):8963	Total	1	1s68ms
	others	1	1s68ms
psql - unix(3147357@a2tech):8963	Total	1	237ms
	others	1	237ms
psql - unix(3147417@a2tech):8963	Total	1	1s72ms
	others	1	1s72ms
psql - unix(3147544@a2tech):8963	Total	1	1s42ms
	others	1	1s42ms
psql - unix(3147634@a2tech):8963	Total	1	235ms
	others	1	235ms
psql - unix(3147694@a2tech):8963	Total	1	1s70ms
	others	1	1s70ms
psql - unix(3147703@a2tech):8963	Total	1	155ms
	others	1	155ms
psql - unix(3147825@a2tech):8963	Total	1	1s118ms
	others	1	1s118ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-05-01 08:16:32 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

576 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	309	29.23%
500-1000ms	60	5.68%
1000-10000ms	576	54.49%
> 10000ms	112	10.60%

Slowest individual queries


[ Date: 2026-05-01 18:33:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3143389@a2tech):8963 ]
[ Date: 2026-05-01 06:33:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132684@a2tech):8963 ]
[ Date: 2026-05-01 00:15:43 - Database: rio - User: lenon - Remote: [local] - Application: psql - unix(3120562@a2tech):8963 ]
[ Date: 2026-05-01 18:45:28 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3143908@a2tech):8963 ]
[ Date: 2026-05-01 06:45:14 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3133116@a2tech):8963 ]
[ Date: 2026-05-01 00:24:13 - Database: brasilia - User: lenon - Remote: [local] - Application: psql - unix(3121398@a2tech):8963 ]
[ Date: 2026-05-01 07:08:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3133656@a2tech):8963 ]
[ Date: 2026-05-01 19:08:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3144451@a2tech):8963 ]
[ Date: 2026-05-01 20:08:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3145295@a2tech):8963 ]
[ Date: 2026-05-01 11:08:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3137471@a2tech):8963 ]
[ Date: 2026-05-01 13:08:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3139178@a2tech):8963 ]
[ Date: 2026-05-01 22:08:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3147018@a2tech):8963 ]
[ Date: 2026-05-01 21:08:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3146144@a2tech):8963 ]
[ Date: 2026-05-01 10:08:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3136427@a2tech):8963 ]
[ Date: 2026-05-01 08:08:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3134509@a2tech):8963 ]
[ Date: 2026-05-01 12:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3138338@a2tech):8963 ]
[ Date: 2026-05-01 18:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3143395@a2tech):8963 ]
[ Date: 2026-05-01 16:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3141716@a2tech):8963 ]
[ Date: 2026-05-01 09:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3135348@a2tech):8963 ]
[ Date: 2026-05-01 14:08:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3140018@a2tech):8963 ]

Rank	Duration	Query
1	28m50s	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-05-01 18:33:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3143389@a2tech):8963 ]
2	28m44s	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-05-01 06:33:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3132684@a2tech):8963 ]
3	13m41s	SELECT * FROM RS_AUDITOR_NOVAS_TABELAS (); [ Date: 2026-05-01 00:15:43 - Database: rio - User: lenon - Remote: [local] - Application: psql - unix(3120562@a2tech):8963 ]
4	11m34s	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-05-01 18:45:28 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3143908@a2tech):8963 ]
5	11m28s	SELECT * FROM RS_POSICAO_OFICINA_ESTATICA (0); [ Date: 2026-05-01 06:45:14 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3133116@a2tech):8963 ]
6	8m29s	SELECT * FROM RS_AUDITOR_NOVAS_TABELAS (); [ Date: 2026-05-01 00:24:13 - Database: brasilia - User: lenon - Remote: [local] - Application: psql - unix(3121398@a2tech):8963 ]
7	3m16s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-01 07:08:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3133656@a2tech):8963 ]
8	3m14s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-01 19:08:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3144451@a2tech):8963 ]
9	3m14s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-01 20:08:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3145295@a2tech):8963 ]
10	3m13s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-01 11:08:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3137471@a2tech):8963 ]
11	3m13s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-01 13:08:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3139178@a2tech):8963 ]
12	3m12s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-01 22:08:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3147018@a2tech):8963 ]
13	3m12s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-01 21:08:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3146144@a2tech):8963 ]
14	3m12s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-01 10:08:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3136427@a2tech):8963 ]
15	3m12s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-01 08:08:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3134509@a2tech):8963 ]
16	3m10s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-01 12:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3138338@a2tech):8963 ]
17	3m10s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-01 18:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3143395@a2tech):8963 ]
18	3m8s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-01 16:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3141716@a2tech):8963 ]
19	3m8s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-01 09:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3135348@a2tech):8963 ]
20	3m7s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-01 14:08:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3140018@a2tech):8963 ]

Time consuming queries (N)


[ User: intelifix - Total duration: 1h23m1s - Times executed: 6 ]
[ User: intelifix - Total duration: 53m24s - Times executed: 48 ]
[ User: intelifix - Total duration: 39m36s - Times executed: 48 ]
[ User: lenon - Total duration: 23m37s - Times executed: 3 ]
[ User: intelifix - Total duration: 4m8s - Times executed: 3 ]
[ User: intelifix - Total duration: 2m38s - Times executed: 169 ]
[ User: intelifix - Total duration: 2m37s - Times executed: 6 ]
[ User: intelifix - Total duration: 2m11s - Times executed: 5 ]
[ User: intelifix - Total duration: 2m8s - Times executed: 6 ]
[ User: intelifix - Total duration: 1m49s - Times executed: 5 ]
[ User: intelifix - Total duration: 1m44s - Times executed: 5 ]
[ User: intelifix - Total duration: 1m44s - Times executed: 9 ]
[ User: intelifix - Total duration: 1m27s - Times executed: 9 ]
[ User: intelifix - Total duration: 1m26s - Times executed: 9 ]
[ User: intelifix - Total duration: 1m2s - Times executed: 9 ]
[ User: intelifix - Total duration: 56s699ms - Times executed: 6 ]
[ User: intelifix - Total duration: 55s260ms - Times executed: 8 ]
[ User: intelifix - Total duration: 54s900ms - Times executed: 8 ]
[ User: intelifix - Total duration: 45s414ms - Times executed: 1 ]
[ User: intelifix - Total duration: 42s572ms - Times executed: 6 ]

Most frequent queries (N)


[ User: intelifix - Total duration: 2m38s - Times executed: 169 ]
[ User: intelifix - Total duration: 53m24s - Times executed: 48 ]
[ User: intelifix - Total duration: 39m36s - Times executed: 48 ]
[ User: intelifix - Total duration: 7s298ms - Times executed: 32 ]
[ User: intelifix - Total duration: 18s114ms - Times executed: 27 ]
[ User: intelifix - Total duration: 5s264ms - Times executed: 23 ]
[ User: intelifix - Total duration: 1m44s - Times executed: 9 ]
[ User: intelifix - Total duration: 1m27s - Times executed: 9 ]
[ User: intelifix - Total duration: 1m26s - Times executed: 9 ]
[ User: intelifix - Total duration: 1m2s - Times executed: 9 ]
[ User: intelifix - Total duration: 26s333ms - Times executed: 9 ]
[ User: intelifix - Total duration: 55s260ms - Times executed: 8 ]
[ User: intelifix - Total duration: 54s900ms - Times executed: 8 ]
[ User: intelifix - Total duration: 41s721ms - Times executed: 8 ]
[ User: intelifix - Total duration: 29s32ms - Times executed: 8 ]
[ User: intelifix - Total duration: 20s548ms - Times executed: 8 ]
[ User: intelifix - Total duration: 20s520ms - Times executed: 8 ]
[ User: intelifix - Total duration: 16s796ms - Times executed: 8 ]
[ User: intelifix - Total duration: 10s450ms - Times executed: 8 ]
[ User: intelifix - Total duration: 7s847ms - Times executed: 8 ]

Normalized slowest queries (N)


[ User: intelifix - Total duration: 1h23m1s - Times executed: 6 ]
[ User: lenon - Total duration: 23m37s - Times executed: 3 ]
[ User: intelifix - Total duration: 4m8s - Times executed: 3 ]
[ User: intelifix - Total duration: 53m24s - Times executed: 48 ]
[ User: intelifix - Total duration: 39m36s - Times executed: 48 ]
[ User: intelifix - Total duration: 45s414ms - Times executed: 1 ]
[ User: intelifix - Total duration: 2m11s - Times executed: 5 ]
[ User: intelifix - Total duration: 2m37s - Times executed: 6 ]
[ User: intelifix - Total duration: 1m49s - Times executed: 5 ]
[ User: intelifix - Total duration: 2m8s - Times executed: 6 ]
[ User: intelifix - Total duration: 1m44s - Times executed: 5 ]
[ User: intelifix - Total duration: 1m44s - Times executed: 9 ]
[ User: intelifix - Total duration: 1m27s - Times executed: 9 ]
[ User: intelifix - Total duration: 1m26s - Times executed: 9 ]
[ User: intelifix - Total duration: 56s699ms - Times executed: 6 ]
[ User: intelifix - Total duration: 42s572ms - Times executed: 6 ]
[ User: intelifix - Total duration: 1m2s - Times executed: 9 ]
[ User: intelifix - Total duration: 55s260ms - Times executed: 8 ]
[ User: intelifix - Total duration: 54s900ms - Times executed: 8 ]
[ User: intelifix - Total duration: 41s721ms - Times executed: 8 ]

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

1

0ms

6

Details

0ms

;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
May 01	08	1	0ms	0ms
	10	1	0ms	0ms
	15	1	0ms	0ms
	17	1	0ms	0ms
	21	1	0ms	0ms
	22	1	0ms	0ms

[ User: intelifix - Total duration: 11s31ms - Times executed: 6 ]

[ Application: psql - unix(3140931@a2tech):8963 - Total duration: 8s317ms - Times executed: 1 ]

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

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

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

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

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

;

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

Log levels

Key values

6,295 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	344	5.46%
DETAIL	3	0.05%
ERROR	1,158	18.40%
EVENTLOG	9	0.14%
FATAL	14	0.22%
LOG	3,265	51.87%
STATEMENT	1,502	23.86%

Events distribution (except queries)

Key values

0 PANIC entries
14 FATAL entries
1158 ERROR entries
0 WARNING entries
9 EVENTLOG entries

Most Frequent Errors/Events

Key values

1,154 Max number of times the same event was reported
1,181 Total events found

Rank

Times reported

Error

1

1,154

Details

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

Times Reported Most Frequent Error / Event #1

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

ERROR: prepared statement "_PLAN000000004CA77BE0" does not exist
ERROR: prepared statement "_PLAN000000004CA7FBA0" does not exist
ERROR: prepared statement "_PLAN000000004CA81270" does not exist

2

6

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
May 01	03	6

3

6

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
May 01	00	1
	06	1
	07	1
	14	1
	23	2

4

5

Details

LOG: could not receive data from client: Connection reset by peer

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
May 01	02	4
	17	1

5

4

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
May 01	05	4

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

6

3

Details

LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
May 01	00	3

LOG: process 3120563 still waiting for AccessExclusiveLock on relation 2085839 of database 323676 after 1000.112 ms

7

2

Details

FATAL: unsupported frontend protocol 27265.28208: server supports 3.0 to 3.0

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
May 01	02	2

8

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
May 01	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

Autovacuum Activity

Locks

Locks by types

Key values

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values