pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sun May 10 23:50:05 2026
Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-Wed.log
Parsed 10,074 log entries in 4s
Log start from 2026-05-09 00:00:57 to 2026-05-09 23:59:43

Global Stats

129 Number of unique normalized queries
732 Number of queries
2h18m37s Total query duration
2026-05-09 00:02:03 First query
2026-05-09 23:39:59 Last query
6 queries/s at 2026-05-09 23:39:39 Query peak

2h18m37s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
2h18m37s Execute total duration

1,070 Number of events
11 Number of unique normalized events
1,037 Max number of times the same event was reported
0 Number of cancellation

6 Total number of automatic vacuums
21 Total number of automatic analyzes

12 Number temporary file
222.08 MiB Max size of temporary file
95.11 MiB Average size of temporary file

515 Total number of sessions
12 sessions at 2026-05-09 18:10:16 Session peak
7d13h30m35s Total duration of sessions
21m8s Average duration of sessions
1 Average queries per session
16s149ms Average queries duration per session
20m52s Average idle time per session

529 Total number of connections
4 connections/s at 2026-05-09 00:02:03 Connection peak
3 Total number of databases

SQL Traffic

Key values

6 queries/s Query Peak
2026-05-09 23:39:39 Date

SELECT Traffic

Key values

2 queries/s Query Peak
2026-05-09 14:10:52 Date

INSERT/UPDATE/DELETE Traffic

Key values

6 queries/s Query Peak
2026-05-09 23:39:39 Date

Queries duration

Key values

2h18m37s 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 09	00	17	0ms	4s578ms	1s707ms	1s554ms	2s153ms	18s61ms
	01	13	0ms	1s601ms	879ms	1s542ms	2s79ms	2s297ms
	02	9	0ms	1s456ms	1s102ms	1s350ms	1s857ms	2s80ms
	03	11	0ms	1s421ms	986ms	1s310ms	1s759ms	2s336ms
	04	14	0ms	1s452ms	827ms	1s427ms	1s820ms	2s191ms
	05	17	0ms	1m53s	19s463ms	2s475ms	58s797ms	1m53s
	06	12	0ms	2s160ms	1s352ms	1s333ms	1s451ms	7s475ms
	07	12	0ms	3m23s	31s779ms	1s372ms	1s520ms	3m55s
	08	17	0ms	3m7s	21s43ms	1s337ms	1s536ms	3m33s
	09	15	0ms	3m5s	23s612ms	1s356ms	1s458ms	3m31s
	10	16	0ms	3m5s	22s215ms	1s329ms	1s505ms	3m31s
	11	16	0ms	3m6s	22s228ms	1s342ms	1s529ms	3m32s
	12	15	0ms	3m6s	23s752ms	1s378ms	1s517ms	3m32s
	13	15	0ms	3m9s	23s874ms	1s322ms	1s518ms	3m35s
	14	16	0ms	3m8s	22s369ms	1s366ms	1s427ms	3m34s
	15	16	0ms	3m7s	22s307ms	1s336ms	1s395ms	3m33s
	16	16	0ms	3m7s	22s365ms	1s334ms	1s434ms	3m33s
	17	16	0ms	3m7s	22s340ms	1s314ms	1s462ms	3m33s
	18	15	0ms	3m6s	23s772ms	1s325ms	1s420ms	3m32s
	19	16	0ms	3m7s	22s362ms	1s331ms	1s397ms	3m34s
	20	91	0ms	3m20s	8s192ms	54s983ms	1m13s	4m5s
	21	15	0ms	3m8s	23s857ms	1s326ms	1s494ms	3m34s
	22	16	0ms	3m7s	22s368ms	1s360ms	1s465ms	3m34s
	23	316	0ms	1m3s	5s609ms	1m4s	1m6s	1m13s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
May 09	00	2	0	785ms	0ms	0ms	0ms
	01	1	0	240ms	0ms	0ms	0ms
	02	0	0	0ms	0ms	0ms	0ms
	03	0	0	0ms	0ms	0ms	0ms
	04	3	0	230ms	0ms	0ms	259ms
	05	1	0	224ms	0ms	0ms	0ms
	06	3	0	606ms	0ms	0ms	0ms
	07	6	0	1m2s	0ms	0ms	2m17s
	08	6	0	57s965ms	0ms	0ms	2m14s
	09	6	0	57s558ms	0ms	0ms	2m14s
	10	6	0	57s729ms	0ms	0ms	2m14s
	11	6	0	57s758ms	0ms	0ms	2m14s
	12	6	0	57s872ms	0ms	0ms	2m14s
	13	6	0	58s236ms	0ms	0ms	2m14s
	14	6	0	58s113ms	0ms	0ms	2m14s
	15	6	0	57s980ms	0ms	0ms	2m14s
	16	6	0	58s147ms	0ms	0ms	2m14s
	17	6	0	58s88ms	0ms	0ms	2m15s
	18	6	0	57s986ms	0ms	0ms	2m15s
	19	6	0	58s148ms	0ms	0ms	2m14s
	20	6	73	9s299ms	0ms	54s983ms	2m16s
	21	6	0	58s185ms	0ms	0ms	2m14s
	22	6	0	58s103ms	0ms	0ms	2m14s
	23	0	316	5s609ms	1m1s	1m4s	1m7s

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

Day	Hour	Count	Average Duration	Average idle time
May 09	00	13	9m9s	9m7s
	01	30	26m23s	26m22s
	02	20	23m44s	23m44s
	03	27	13m21s	13m20s
	04	19	18m47s	18m46s
	05	22	24m29s	24m14s
	06	21	22m10s	22m9s
	07	25	29m	28m45s
	08	22	21m5s	20m48s
	09	22	19m38s	19m22s
	10	22	21m50s	21m34s
	11	22	21m48s	21m31s
	12	20	20m48s	20m30s
	13	23	21m23s	21m7s
	14	17	24m2s	23m41s
	15	21	22m39s	22m22s
	16	19	19m12s	18m53s
	17	20	23m52s	23m34s
	18	22	22m9s	21m53s
	19	23	20m48s	20m32s
	20	22	16m34s	16m
	21	20	18m26s	18m8s
	22	22	19m15s	18m59s
	23	21	21m8s	19m43s

↑ Back to the top of the General Activity table

Established Connections

Key values

4 connections Connection Peak
2026-05-09 00:02:03 Date

Connections per database

Key values

brasilia Main Database
529 connections Total

Chart
Table

Database	User	Count
brasilia		417
	etiquetas	368
	intelifix	44
	lenon	5
contagem		39
	intelifix	36
	lenon	3
jaboatao		12
	intelifix	12
rio		59
	intelifix	52
	lenon	7
testes		2
	lenon	2

Connections per user

Key values

etiquetas Main User
529 connections Total

Chart
Table

User	Count
etiquetas	368
intelifix	144
lenon	17

Connections per host

Key values

[local] Main host with 528 connections
529 Total connections

Chart
Table

Host	Count
127.0.0.1	1
[local]	528

Simultaneous sessions

Key values

12 sessions Session Peak
2026-05-09 18:10:16 Date

Histogram of session times

Key values

344 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	0	0.00%
500ms-1s	0	0.00%
1s-30s	2	0.39%
30s-1m	7	1.36%
1m-10m	344	66.80%
10m-30m	4	0.78%
30m-1h	8	1.55%
1h-8h	150	29.13%
> 8h	0	0.00%

Sessions per database

Key values

brasilia Main Database
515 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
brasilia	417	3d20h46m56s	13m20s
contagem	39	1d11h49m12s	55m6s
rio	59	2d4h54m27s	53m48s

Sessions per user

Key values

etiquetas Main User
515 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
etiquetas	368	1d23h41m	7m46s
intelifix	132	4d22h49m31s	54m
lenon	15	15h3s	1h

Sessions per host

Key values

[local] Main Host
515 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	1	45m1s	45m1s
[local]	514	7d12h45m34s	21m6s

Sessions per application

Key values

[unknown] Main Application
515 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
[unknown]	127	4d20h20m17s	54m57s
app - 177.99.204.34:49159	1	4m11s	4m11s
app - 177.99.204.34:49258	1	2m4s	2m4s
app - 177.99.204.34:49276	1	4m11s	4m11s
app - 177.99.204.34:49285	1	2m4s	2m4s
app - 177.99.204.34:49330	1	3m7s	3m7s
app - 177.99.204.34:49368	1	6m17s	6m17s
app - 177.99.204.34:49396	1	6m15s	6m15s
app - 177.99.204.34:49491	1	3m7s	3m7s
app - 177.99.204.34:49536	1	3m6s	3m6s
app - 177.99.204.34:49546	1	4m10s	4m10s
app - 177.99.204.34:49564	2	1h1m48s	30m54s
app - 177.99.204.34:49567	1	4m10s	4m10s
app - 177.99.204.34:49583	1	4m10s	4m10s
app - 177.99.204.34:49610	1	3m7s	3m7s
app - 177.99.204.34:49611	1	7m18s	7m18s
app - 177.99.204.34:49615	1	5m14s	5m14s
app - 177.99.204.34:49727	1	6m15s	6m15s
app - 177.99.204.34:49729	1	6m15s	6m15s
app - 177.99.204.34:49756	1	1h	1h
app - 177.99.204.34:49900	1	4m11s	4m11s
app - 177.99.204.34:49969	2	1h34s	30m17s
app - 177.99.204.34:49974	1	4m11s	4m11s
app - 177.99.204.34:49979	1	2m4s	2m4s
app - 177.99.204.34:50034	1	4m32s	4m32s
app - 177.99.204.34:50133	1	6m16s	6m16s
app - 177.99.204.34:50245	1	4m25s	4m25s
app - 177.99.204.34:50360	1	4m10s	4m10s
app - 177.99.204.34:50413	1	8m21s	8m21s
app - 177.99.204.34:50464	1	5m13s	5m13s
app - 177.99.204.34:50496	1	5m12s	5m12s
app - 177.99.204.34:50527	1	3m7s	3m7s
app - 177.99.204.34:50577	1	5m12s	5m12s
app - 177.99.204.34:50587	1	6m16s	6m16s
app - 177.99.204.34:50654	1	7m20s	7m20s
app - 177.99.204.34:50685	1	2m4s	2m4s
app - 177.99.204.34:50721	2	1h35s	30m17s
app - 177.99.204.34:50763	1	3m6s	3m6s
app - 177.99.204.34:50935	1	7m17s	7m17s
app - 177.99.204.34:50986	1	4m25s	4m25s
app - 177.99.204.34:51001	1	3m6s	3m6s
app - 177.99.204.34:51003	1	4m11s	4m11s
app - 177.99.204.34:51013	1	4m10s	4m10s
app - 177.99.204.34:51153	1	2m4s	2m4s
app - 177.99.204.34:51329	1	7m20s	7m20s
app - 177.99.204.34:51390	1	4m9s	4m9s
app - 177.99.204.34:51404	1	5m13s	5m13s
app - 177.99.204.34:51412	1	3m7s	3m7s
app - 177.99.204.34:51501	1	4m10s	4m10s
app - 177.99.204.34:51556	1	3m7s	3m7s
app - 177.99.204.34:51559	1	3m7s	3m7s
app - 177.99.204.34:51601	1	5m13s	5m13s
app - 177.99.204.34:51617	1	3m7s	3m7s
app - 177.99.204.34:51742	2	1h4m12s	32m6s
app - 177.99.204.34:51817	1	5m12s	5m12s
app - 177.99.204.34:51853	1	4m10s	4m10s
app - 177.99.204.34:51862	1	2m4s	2m4s
app - 177.99.204.34:51866	1	3m7s	3m7s
app - 177.99.204.34:51868	1	5m14s	5m14s
app - 177.99.204.34:52042	1	3m7s	3m7s
app - 177.99.204.34:52064	1	2m4s	2m4s
app - 177.99.204.34:52069	1	2m4s	2m4s
app - 177.99.204.34:52258	1	4m11s	4m11s
app - 177.99.204.34:52290	1	3m7s	3m7s
app - 177.99.204.34:52292	1	4m11s	4m11s
app - 177.99.204.34:52356	1	4m9s	4m9s
app - 177.99.204.34:52428	1	4m10s	4m10s
app - 177.99.204.34:52436	1	5m12s	5m12s
app - 177.99.204.34:52461	1	3m8s	3m8s
app - 177.99.204.34:52510	1	6m15s	6m15s
app - 177.99.204.34:52561	1	8m19s	8m19s
app - 177.99.204.34:52635	1	3m7s	3m7s
app - 177.99.204.34:52686	1	4m20s	4m20s
app - 177.99.204.34:52701	1	3m7s	3m7s
app - 177.99.204.34:52713	1	3m9s	3m9s
app - 177.99.204.34:52734	1	6m16s	6m16s
app - 177.99.204.34:52781	1	5m13s	5m13s
app - 177.99.204.34:52814	1	3m6s	3m6s
app - 177.99.204.34:52839	1	3m8s	3m8s
app - 177.99.204.34:52910	1	6m16s	6m16s
app - 177.99.204.34:52941	1	3m6s	3m6s
app - 177.99.204.34:53113	1	7m18s	7m18s
app - 177.99.204.34:53114	1	4m11s	4m11s
app - 177.99.204.34:53153	1	5m12s	5m12s
app - 177.99.204.34:53191	2	1h2m36s	31m18s
app - 177.99.204.34:53211	1	3m7s	3m7s
app - 177.99.204.34:53319	1	2m4s	2m4s
app - 177.99.204.34:53377	1	4m11s	4m11s
app - 177.99.204.34:53385	1	3m7s	3m7s
app - 177.99.204.34:53531	1	6m1s	6m1s
app - 177.99.204.34:53564	1	5m13s	5m13s
app - 177.99.204.34:53572	1	5m12s	5m12s
app - 177.99.204.34:53628	1	2m4s	2m4s
app - 177.99.204.34:53667	1	3m7s	3m7s
app - 177.99.204.34:53692	1	2m4s	2m4s
app - 177.99.204.34:53707	1	3m8s	3m8s
app - 177.99.204.34:53746	1	5m13s	5m13s
app - 177.99.204.34:53772	1	3m7s	3m7s
app - 177.99.204.34:53795	1	3m10s	3m10s
app - 177.99.204.34:53836	1	6m15s	6m15s
app - 177.99.204.34:53889	1	2m4s	2m4s
app - 177.99.204.34:53932	1	5m13s	5m13s
app - 177.99.204.34:54008	1	6m15s	6m15s
app - 177.99.204.34:54027	1	3m7s	3m7s
app - 177.99.204.34:54121	1	2m4s	2m4s
app - 177.99.204.34:54138	1	3m7s	3m7s
app - 177.99.204.34:54177	1	5m13s	5m13s
app - 177.99.204.34:54329	1	5m13s	5m13s
app - 177.99.204.34:54332	1	2m4s	2m4s
app - 177.99.204.34:54385	2	1h3m1s	31m30s
app - 177.99.204.34:54477	1	4m10s	4m10s
app - 177.99.204.34:54554	1	4m11s	4m11s
app - 177.99.204.34:54569	1	2m4s	2m4s
app - 177.99.204.34:54595	1	5m12s	5m12s
app - 177.99.204.34:54635	1	5m12s	5m12s
app - 177.99.204.34:54645	1	4m10s	4m10s
app - 177.99.204.34:54721	1	3m7s	3m7s
app - 177.99.204.34:54772	1	2m4s	2m4s
app - 177.99.204.34:54804	1	5m14s	5m14s
app - 177.99.204.34:54829	1	4m11s	4m11s
app - 177.99.204.34:54832	1	2m4s	2m4s
app - 177.99.204.34:54908	1	4m10s	4m10s
app - 177.99.204.34:54967	1	4m9s	4m9s
app - 177.99.204.34:54988	1	6m16s	6m16s
app - 177.99.204.34:55039	1	4m10s	4m10s
app - 177.99.204.34:55061	1	3m7s	3m7s
app - 177.99.204.34:55160	1	3m7s	3m7s
app - 177.99.204.34:55164	1	3m7s	3m7s
app - 177.99.204.34:55285	1	2m4s	2m4s
app - 177.99.204.34:55314	1	5m13s	5m13s
app - 177.99.204.34:55330	1	3m7s	3m7s
app - 177.99.204.34:55396	1	4m10s	4m10s
app - 177.99.204.34:55438	1	3m7s	3m7s
app - 177.99.204.34:55504	1	2m4s	2m4s
app - 177.99.204.34:55516	1	6m15s	6m15s
app - 177.99.204.34:55599	1	7m19s	7m19s
app - 177.99.204.34:55631	1	3m7s	3m7s
app - 177.99.204.34:55678	1	5m14s	5m14s
app - 177.99.204.34:55779	1	2m4s	2m4s
app - 177.99.204.34:55831	1	2m4s	2m4s
app - 177.99.204.34:55843	1	9m25s	9m25s
app - 177.99.204.34:55983	1	6m15s	6m15s
app - 177.99.204.34:55991	2	1h32s	30m16s
app - 177.99.204.34:55998	1	3m7s	3m7s
app - 177.99.204.34:56058	1	5m39s	5m39s
app - 177.99.204.34:56062	1	3m7s	3m7s
app - 177.99.204.34:56094	1	4m11s	4m11s
app - 177.99.204.34:56138	1	2m4s	2m4s
app - 177.99.204.34:56207	1	5m13s	5m13s
app - 177.99.204.34:56209	1	7m19s	7m19s
app - 177.99.204.34:56253	1	6m15s	6m15s
app - 177.99.204.34:56259	1	6m15s	6m15s
app - 177.99.204.34:56342	1	4m10s	4m10s
app - 177.99.204.34:56374	1	5m13s	5m13s
app - 177.99.204.34:56375	1	4m9s	4m9s
app - 177.99.204.34:56403	2	1h31s	30m15s
app - 177.99.204.34:56409	1	5m14s	5m14s
app - 177.99.204.34:56459	1	5m13s	5m13s
app - 177.99.204.34:56479	1	3m9s	3m9s
app - 177.99.204.34:56531	1	3m7s	3m7s
app - 177.99.204.34:56544	1	3m7s	3m7s
app - 177.99.204.34:56614	1	4m10s	4m10s
app - 177.99.204.34:56756	1	3m7s	3m7s
app - 177.99.204.34:56832	1	5m12s	5m12s
app - 177.99.204.34:56893	1	2m4s	2m4s
app - 177.99.204.34:57054	1	7m19s	7m19s
app - 177.99.204.34:57120	1	5m12s	5m12s
app - 177.99.204.34:57129	1	4m10s	4m10s
app - 177.99.204.34:57163	1	4m10s	4m10s
app - 177.99.204.34:57425	1	3m7s	3m7s
app - 177.99.204.34:57467	1	4m10s	4m10s
app - 177.99.204.34:57532	1	4m11s	4m11s
app - 177.99.204.34:57571	1	4m9s	4m9s
app - 177.99.204.34:57611	1	3m7s	3m7s
app - 177.99.204.34:57619	1	4m10s	4m10s
app - 177.99.204.34:57648	2	1h3m9s	31m34s
app - 177.99.204.34:57770	1	4m9s	4m9s
app - 177.99.204.34:57794	1	2m4s	2m4s
app - 177.99.204.34:57806	1	2m4s	2m4s
app - 177.99.204.34:57825	1	4m9s	4m9s
app - 177.99.204.34:57895	1	3m7s	3m7s
app - 177.99.204.34:58015	1	5m12s	5m12s
app - 177.99.204.34:58020	1	4m11s	4m11s
app - 177.99.204.34:58046	1	3m6s	3m6s
app - 177.99.204.34:58128	1	5m13s	5m13s
app - 177.99.204.34:58145	1	3m7s	3m7s
app - 177.99.204.34:58197	1	3m8s	3m8s
app - 177.99.204.34:58241	2	1h2m7s	31m3s
app - 177.99.204.34:58377	2	8m21s	4m10s
app - 177.99.204.34:58463	1	3m7s	3m7s
app - 177.99.204.34:58505	1	4m10s	4m10s
app - 177.99.204.34:58510	1	5m13s	5m13s
app - 177.99.204.34:58525	1	3m7s	3m7s
app - 177.99.204.34:58554	1	2m4s	2m4s
app - 177.99.204.34:58561	2	1h1m4s	30m32s
app - 177.99.204.34:58578	1	3m7s	3m7s
app - 177.99.204.34:58599	1	6m15s	6m15s
app - 177.99.204.34:58670	1	3m8s	3m8s
app - 177.99.204.34:58704	2	43m43s	21m51s
app - 177.99.204.34:58866	1	3m7s	3m7s
app - 177.99.204.34:58888	1	4m10s	4m10s
app - 177.99.204.34:58941	1	4m9s	4m9s
app - 177.99.204.34:58943	1	2m4s	2m4s
app - 177.99.204.34:58978	1	7m18s	7m18s
app - 177.99.204.34:59018	1	4m9s	4m9s
app - 177.99.204.34:59034	1	7m20s	7m20s
app - 177.99.204.34:59046	1	5m12s	5m12s
app - 177.99.204.34:59109	1	3m7s	3m7s
app - 177.99.204.34:59199	1	3m7s	3m7s
app - 177.99.204.34:59221	1	3m7s	3m7s
app - 177.99.204.34:59239	1	3m7s	3m7s
app - 177.99.204.34:59268	1	7m17s	7m17s
app - 177.99.204.34:59290	1	5m13s	5m13s
app - 177.99.204.34:59300	1	3m7s	3m7s
app - 177.99.204.34:59315	1	5m14s	5m14s
app - 177.99.204.34:59451	1	5m12s	5m12s
app - 177.99.204.34:59484	1	2m4s	2m4s
app - 177.99.204.34:59543	1	5m13s	5m13s
app - 177.99.204.34:59547	1	3m8s	3m8s
app - 177.99.204.34:59572	1	3m7s	3m7s
app - 177.99.204.34:59667	2	1h2m34s	31m17s
app - 177.99.204.34:59683	1	5m13s	5m13s
app - 177.99.204.34:59686	1	7m18s	7m18s
app - 177.99.204.34:59832	2	1h1m32s	30m46s
app - 177.99.204.34:59848	1	4m10s	4m10s
app - 177.99.204.34:59923	1	4m11s	4m11s
app - 177.99.204.34:59965	1	3m7s	3m7s
app - 177.99.204.34:60167	1	3m8s	3m8s
app - 177.99.204.34:60172	1	3m7s	3m7s
app - 177.99.204.34:60229	1	3m7s	3m7s
app - 177.99.204.34:60252	1	4m10s	4m10s
app - 177.99.204.34:60270	1	2m4s	2m4s
app - 177.99.204.34:60303	1	6m15s	6m15s
app - 177.99.204.34:60330	1	2m4s	2m4s
app - 177.99.204.34:60335	2	10m27s	5m13s
app - 177.99.204.34:60368	1	6m15s	6m15s
app - 177.99.204.34:60412	1	3m7s	3m7s
app - 177.99.204.34:60602	1	5m13s	5m13s
app - 177.99.204.34:60629	1	36s197ms	36s197ms
app - 177.99.204.34:60808	1	3m7s	3m7s
app - 177.99.204.34:60835	1	3m6s	3m6s
app - 177.99.204.34:60871	1	5m12s	5m12s
app - 177.99.204.34:60873	1	4m9s	4m9s
app - 177.99.204.34:60970	1	5m13s	5m13s
app - 177.99.204.34:61006	1	5m12s	5m12s
app - 177.99.204.34:61041	1	7m17s	7m17s
app - 177.99.204.34:61053	1	4m10s	4m10s
app - 177.99.204.34:61072	1	4m10s	4m10s
app - 177.99.204.34:61223	1	3m7s	3m7s
app - 177.99.204.34:61225	2	1h2m51s	31m25s
app - 177.99.204.34:61231	1	4m11s	4m11s
app - 177.99.204.34:61254	1	5m13s	5m13s
app - 177.99.204.34:61272	1	4m9s	4m9s
app - 177.99.204.34:61335	1	3m6s	3m6s
app - 177.99.204.34:61349	1	4m9s	4m9s
app - 177.99.204.34:61396	1	2m4s	2m4s
app - 177.99.204.34:61432	1	2m4s	2m4s
app - 177.99.204.34:61462	1	7m18s	7m18s
app - 177.99.204.34:61469	1	3m8s	3m8s
app - 177.99.204.34:61482	1	4m10s	4m10s
app - 177.99.204.34:61525	1	6m17s	6m17s
app - 177.99.204.34:61635	1	3m8s	3m8s
app - 177.99.204.34:61752	1	4m10s	4m10s
app - 177.99.204.34:61844	1	5m14s	5m14s
app - 177.99.204.34:61905	1	3m7s	3m7s
app - 177.99.204.34:62088	1	2m4s	2m4s
app - 177.99.204.34:62130	1	6m16s	6m16s
app - 177.99.204.34:62134	1	5m12s	5m12s
app - 177.99.204.34:62282	1	3m7s	3m7s
app - 177.99.204.34:62286	1	3m7s	3m7s
app - 177.99.204.34:62359	1	5m12s	5m12s
app - 177.99.204.34:62366	1	5m13s	5m13s
app - 177.99.204.34:62388	1	4m11s	4m11s
app - 177.99.204.34:62421	1	3m7s	3m7s
app - 177.99.204.34:62455	1	3m7s	3m7s
app - 177.99.204.34:62478	1	7m18s	7m18s
app - 177.99.204.34:62550	1	3m7s	3m7s
app - 177.99.204.34:62582	2	1h2m37s	31m18s
app - 177.99.204.34:62612	1	4m10s	4m10s
app - 177.99.204.34:62656	1	4m10s	4m10s
app - 177.99.204.34:62658	1	3m7s	3m7s
app - 177.99.204.34:62705	1	3m7s	3m7s
app - 177.99.204.34:62722	1	1m35s	1m35s
app - 177.99.204.34:62730	1	7m20s	7m20s
app - 177.99.204.34:62736	2	1h3m10s	31m35s
app - 177.99.204.34:62790	1	2m4s	2m4s
app - 177.99.204.34:62815	1	2m4s	2m4s
app - 177.99.204.34:62848	1	2m4s	2m4s
app - 177.99.204.34:62926	1	4m10s	4m10s
app - 177.99.204.34:62971	1	6m15s	6m15s
app - 177.99.204.34:63030	1	3m7s	3m7s
app - 177.99.204.34:63194	1	3m7s	3m7s
app - 177.99.204.34:63319	1	6m15s	6m15s
app - 177.99.204.34:63338	1	2m4s	2m4s
app - 177.99.204.34:63468	1	3m7s	3m7s
app - 177.99.204.34:63499	1	3m6s	3m6s
app - 177.99.204.34:63503	1	4m10s	4m10s
app - 177.99.204.34:63505	1	3m7s	3m7s
app - 177.99.204.34:63524	1	4m9s	4m9s
app - 177.99.204.34:63568	1	3m7s	3m7s
app - 177.99.204.34:63621	1	4m10s	4m10s
app - 177.99.204.34:63638	1	4m9s	4m9s
app - 177.99.204.34:63683	1	6m16s	6m16s
app - 177.99.204.34:63694	1	6m14s	6m14s
app - 177.99.204.34:63765	1	5m12s	5m12s
app - 177.99.204.34:63831	1	6m16s	6m16s
app - 177.99.204.34:63937	1	4m10s	4m10s
app - 177.99.204.34:63941	1	5m14s	5m14s
app - 177.99.204.34:63990	1	2m4s	2m4s
app - 177.99.204.34:64057	1	3m7s	3m7s
app - 177.99.204.34:64060	1	3m7s	3m7s
app - 177.99.204.34:64079	1	4m10s	4m10s
app - 177.99.204.34:64121	1	5m12s	5m12s
app - 177.99.204.34:64155	1	5m13s	5m13s
app - 177.99.204.34:64158	1	3m8s	3m8s
app - 177.99.204.34:64171	1	2m4s	2m4s
app - 177.99.204.34:64226	2	1h35s	30m17s
app - 177.99.204.34:64261	1	5m14s	5m14s
app - 177.99.204.34:64381	1	5m13s	5m13s
app - 177.99.204.34:64549	1	4m10s	4m10s
app - 177.99.204.34:64553	1	4m9s	4m9s
app - 177.99.204.34:64563	1	2m4s	2m4s
app - 177.99.204.34:64607	1	3m7s	3m7s
app - 177.99.204.34:64689	1	4m10s	4m10s
app - 177.99.204.34:64706	1	3m7s	3m7s
app - 177.99.204.34:64891	1	3m7s	3m7s
app - 177.99.204.34:64899	1	4m11s	4m11s
app - 177.99.204.34:64920	1	2m4s	2m4s
app - 177.99.204.34:64943	1	2m4s	2m4s
app - 177.99.204.34:65021	1	7m20s	7m20s
app - 177.99.204.34:65041	1	5m15s	5m15s
app - 177.99.204.34:65097	1	5m13s	5m13s
app - 177.99.204.34:65103	1	5m12s	5m12s
app - 177.99.204.34:65171	2	1h1m33s	30m46s
app - 177.99.204.34:65228	1	4m10s	4m10s
app - 177.99.204.34:65240	1	3m7s	3m7s
app - 177.99.204.34:65261	1	2m4s	2m4s
app - 177.99.204.34:65374	1	3m7s	3m7s
app - 177.99.204.34:65475	1	7m20s	7m20s
app - 177.99.204.34:65477	1	3m7s	3m7s
pg_dump	6	36m9s	6m1s
postgres_fdw	1	45m1s	45m1s
psql - unix(1681103@a2tech):8963	1	1h	1h
psql - unix(1687265@a2tech):8963	1	1h	1h
psql - unix(1689764@a2tech):8963	1	1h	1h
psql - unix(1690288@a2tech):8963	1	1h3m5s	1h3m5s
psql - unix(1692001@a2tech):8963	1	1h17s	1h17s
psql - unix(1692237@a2tech):8963	1	1h	1h
psql - unix(1692352@a2tech):8963	1	1h1s	1h1s
psql - unix(1693299@a2tech):8963	1	1h	1h
psql - unix(1693633@a2tech):8963	1	1h1s	1h1s
psql - unix(1694456@a2tech):8963	1	1h1s	1h1s
psql - unix(1695178@a2tech):8963	1	1h	1h
psql - unix(1695323@a2tech):8963	1	1h3m4s	1h3m4s
psql - unix(1695474@a2tech):8963	1	1h	1h
psql - unix(1696263@a2tech):8963	1	1h5s	1h5s
psql - unix(1697028@a2tech):8963	1	1h3m5s	1h3m5s
psql - unix(1697099@a2tech):8963	1	1h6s	1h6s
psql - unix(1698038@a2tech):8963	1	1h	1h
psql - unix(1698537@a2tech):8963	1	1h	1h
psql - unix(1698709@a2tech):8963	1	1h3m20s	1h3m20s
psql - unix(1700486@a2tech):8963	1	1h3m7s	1h3m7s
psql - unix(1700701@a2tech):8963	1	1h	1h

Checkpoints Buffers

Key values

15,449 buffers Checkpoint Peak
2026-05-09 00:09:44 Date
269.809 seconds Highest write time
0.011 seconds Sync time

Checkpoints Wal files

Key values

1 files Wal files usage Peak
2026-05-09 05:09:34 Date

Checkpoints distance

Key values

229.58 Mo Distance Peak
2026-05-09 00:09:44 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
May 09	00	18,336	556.988s	0.029s	557.065s
	01	3,837	382.551s	0.057s	382.647s
	02	1,498	147.985s	0.032s	148.042s
	03	2,071	205.499s	0.033s	205.556s
	04	3,475	344.866s	0.059s	344.959s
	05	7,887	589.321s	0.046s	589.403s
	06	5,151	269.766s	0.002s	269.771s
	07	1,148	114.552s	0.004s	114.565s
	08	21	2.008s	0.002s	2.014s
	09	21	2.008s	0.002s	2.013s
	10	21	2.007s	0.002s	2.012s
	11	21	2.007s	0.003s	2.013s
	12	21	2.008s	0.002s	2.014s
	13	21	2.008s	0.002s	2.013s
	14	21	2.007s	0.002s	2.013s
	15	21	2.007s	0.002s	2.012s
	16	21	2.007s	0.002s	2.014s
	17	21	2.007s	0.002s	2.013s
	18	373	37.201s	0.007s	37.219s
	19	21	2.008s	0.005s	2.02s
	20	436	68.825s	0.005s	68.836s
	21	43	4.12s	0.007s	4.138s
	22	21	2.008s	0.002s	2.013s
	23	18	1.807s	0.002s	1.812s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
May 09	00	8	0	455	0.002s	0.007s
	01	2	0	839	0.002s	0.009s
	02	1	0	402	0.002s	0.008s
	03	0	0	354	0.002s	0.007s
	04	2	0	693	0.004s	0.008s
	05	2	2	634	0.003s	0.01s
	06	0	1	8	0.001s	0.001s
	07	0	0	22	0.001s	0.002s
	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.002s	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.001s	0.001s
	18	0	0	47	0.002s	0.003s
	19	0	0	3	0.004s	0.002s
	20	0	1	25	0.002s	0.002s
	21	0	0	14	0.003s	0.003s
	22	0	0	3	0.002s	0.001s
	23	0	0	9	0.001s	0.001s

Day	Hour	Avg time (sec)
May 09	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 09	00	20,345.29 kB	88,988.43 kB
	01	3,135.22 kB	40,449.00 kB
	02	1,503.29 kB	18,338.71 kB
	03	1,836.50 kB	4,691.25 kB
	04	3,264.38 kB	5,738.38 kB
	05	6,723.00 kB	25,113.00 kB
	06	13,202.00 kB	18,815.00 kB
	07	4,248.50 kB	16,844.50 kB
	08	157.00 kB	14,430.00 kB
	09	158.00 kB	13,003.00 kB
	10	158.00 kB	11,718.00 kB
	11	159.00 kB	10,562.00 kB
	12	160.00 kB	9,522.00 kB
	13	160.00 kB	8,586.00 kB
	14	161.00 kB	7,743.00 kB
	15	162.00 kB	6,985.00 kB
	16	162.00 kB	6,303.00 kB
	17	163.00 kB	5,689.00 kB
	18	783.00 kB	4,832.00 kB
	19	157.00 kB	3,921.00 kB
	20	2,315.00 kB	3,748.50 kB
	21	93.00 kB	2,950.67 kB
	22	159.00 kB	2,401.00 kB
	23	29.00 kB	2,164.00 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (71) Main checkpoint cause
72 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	71
shutdown immediate	1
Total	72

Size of temporary files

Key values

444.16 MiB Temp Files size Peak
2026-05-09 05:31:03 Date

Number of temporary files

Key values

3 per second Temp Files Peak
2026-05-09 05:31:07 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
May 09	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	95.11 MiB
	06	0	0	0
	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	0	0	0
	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	8	862.77 MiB	66.24 MiB	222.08 MiB	107.85 MiB	refresh materialized view concurrently rs_mv_codigos_barra; REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; Date: 2026-05-09 05:31:09 Duration: 45s947ms Database: rio User: intelifix Remote: [local] Application: psql - unix(1686332@a2tech):8963 REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; Date: 2026-05-09 05:31:03 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(1686332@a2tech):8963
2	4	278.60 MiB	51.78 MiB	85.22 MiB	69.65 MiB	refresh materialized view concurrently rs_mv_equipamentos; REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; Date: 2026-05-09 05:30:23 Duration: 20s765ms Database: rio User: intelifix Remote: [local] Application: psql - unix(1686326@a2tech):8963 REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; Date: 2026-05-09 05:30:20 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(1686326@a2tech):8963

Rank

Count

Total size

Min size

Max size

Avg size

Query

1

8

862.77 MiB

66.24 MiB

222.08 MiB

107.85 MiB

refresh materialized view concurrently rs_mv_codigos_barra;

REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;

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

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

2

4

278.60 MiB

51.78 MiB

85.22 MiB

69.65 MiB

refresh materialized view concurrently rs_mv_equipamentos;

REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;

Date: 2026-05-09 05:30:23 Duration: 20s765ms Database: rio User: intelifix Remote: [local] Application: psql - unix(1686326@a2tech):8963
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;

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

Queries generating the largest temporary files


[ Date: 2026-05-09 05:31:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686332@a2tech):8963 ]
[ Date: 2026-05-09 05:31:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686332@a2tech):8963 ]
[ Date: 2026-05-09 05:30:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686326@a2tech):8963 ]
[ Date: 2026-05-09 05:30:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686326@a2tech):8963 ]
[ Date: 2026-05-09 05:31:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686332@a2tech):8963 ]
[ Date: 2026-05-09 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686332@a2tech):8963 ]
[ Date: 2026-05-09 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686332@a2tech):8963 ]
[ Date: 2026-05-09 05:31:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686332@a2tech):8963 ]
[ Date: 2026-05-09 05:31:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686332@a2tech):8963 ]
[ Date: 2026-05-09 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686332@a2tech):8963 ]
[ Date: 2026-05-09 05:30:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686326@a2tech):8963 ]
[ Date: 2026-05-09 05:30:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686326@a2tech):8963 ]

Rank	Size	Query
1	222.08 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-09 05:31:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686332@a2tech):8963 ]
2	222.08 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-09 05:31:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686332@a2tech):8963 ]
3	85.22 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; [ Date: 2026-05-09 05:30:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686326@a2tech):8963 ]
4	85.22 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; [ Date: 2026-05-09 05:30:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686326@a2tech):8963 ]
5	73.31 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-09 05:31:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686332@a2tech):8963 ]
6	73.26 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-09 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686332@a2tech):8963 ]
7	73.25 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-09 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686332@a2tech):8963 ]
8	66.30 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-09 05:31:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686332@a2tech):8963 ]
9	66.25 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-09 05:31:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686332@a2tech):8963 ]
10	66.24 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-09 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686332@a2tech):8963 ]
11	56.38 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; [ Date: 2026-05-09 05:30:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686326@a2tech):8963 ]
12	51.78 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; [ Date: 2026-05-09 05:30:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1686326@a2tech):8963 ]

Vacuums / Analyzes Distribution

Key values

0.05 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio
2026-05-09 05:02:04 Date
0 sec Highest CPU-cost analyze
Table
Database rio
Date

Average Autovacuum Duration

Key values

0.05 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio
2026-05-09 05:02:04 Date

Analyzes per table

Key values

public.temp0000279267 (17) Main table analyzed (database rio)
21 analyzes Total

Chart
Table

Table	Number of analyzes
rio.public.temp0000279267	17
rio.pg_catalog.pg_attribute	1
rio.pg_catalog.pg_class	1
rio.pg_catalog.pg_index	1
rio.pg_catalog.pg_type	1
Total	21

Vacuums per table

Key values

pg_toast.pg_toast_2619 (1) Main table vacuumed on database rio
6 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
rio.pg_toast.pg_toast_2619	1	1	872	0	28	0	0	738	22	63,586
brasilia.pg_catalog.pg_statistic	1	1	2,354	0	2	0	0	2,280	1	155,238
contagem.pg_toast.pg_toast_2619	1	1	185	0	1	0	0	127	2	23,478
contagem.pg_catalog.pg_statistic	1	1	2,346	0	2	0	0	2,271	1	156,019
rio.pg_catalog.pg_statistic	1	1	3,324	0	32	0	0	3,111	29	242,170
brasilia.pg_toast.pg_toast_2619	1	1	242	0	1	0	0	186	2	27,282
Total	6	6	9,323	249	66	0	0	8,713	57	667,773

Tuples removed per table

Key values

pg_catalog.pg_statistic (3612) Main table with removed tuples on database rio
10379 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,612	7,822	0	0	1,279
brasilia.pg_catalog.pg_statistic	1	1	2,933	7,358	0	0	951
contagem.pg_catalog.pg_statistic	1	1	2,886	7,336	0	0	922
rio.pg_toast.pg_toast_2619	1	1	677	671	0	19	273
brasilia.pg_toast.pg_toast_2619	1	1	163	138	0	0	74
contagem.pg_toast.pg_toast_2619	1	1	108	117	0	0	54
Total	6	6	10,379	23,442	0	19	3,553

Pages removed per table

Key values

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

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
rio.pg_toast.pg_toast_2619	1	1	677	19
brasilia.pg_catalog.pg_statistic	1	1	2933	0
contagem.pg_toast.pg_toast_2619	1	1	108	0
contagem.pg_catalog.pg_statistic	1	1	2886	0
rio.pg_catalog.pg_statistic	1	1	3612	0
brasilia.pg_toast.pg_toast_2619	1	1	163	0
Total	6	6	10,379	19

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
May 09	00	0	0
	01	0	11
	02	0	0
	03	0	0
	04	0	10
	05	6	0
	06	0	0
	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	0	0
	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

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

NO DATASET

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

106 Total read queries
389 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	106	14.48%
INSERT	0	0.00%
UPDATE	0	0.00%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	389	53.14%
CTE	0	0.00%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%
OTHERS	237	32.38%

Queries by database

Key values

rio Main database
391 Requests
1h27m6s (rio)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
brasilia	Total	200	48m35s
	copy to	139	9m5s
	others	27	1m31s
	select	34	37m58s
contagem	Total	141	2m54s
	copy to	105	1m34s
	others	3	1m5s
	select	33	15s323ms
rio	Total	391	1h27m6s
	copy to	145	24m59s
	others	207	6m44s
	select	39	55m23s

Queries by user

Key values

intelifix Main user
727 Requests

Queries Chart
Table

User	Request type	Count	Duration
intelifix	Total	727	2h18m33s
	copy to	389	35m39s
	others	237	9m21s
	select	101	1h33m33s
lenon	Total	5	3s388ms
	select	5	3s388ms

Duration by user

Key values

2h18m33s (intelifix) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
intelifix	Total	727	2h18m33s
	copy to	389	35m39s
	others	237	9m21s
	select	101	1h33m33s
lenon	Total	5	3s388ms
	select	5	3s388ms

Queries by host

Key values

[local] Main host
732 Requests
2h18m37s ([local])
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
[local]	Total	732	2h18m37s
	copy to	389	35m39s
	others	237	9m21s
	select	106	1h33m36s

Queries by application

Key values

pg_dump Main application
389 Requests
35m39s (pg_dump)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
app - 127.0.0.1:39314	Total	1	240ms
	select	1	240ms
app - 127.0.0.1:41400	Total	1	171ms
	select	1	171ms
app - 127.0.0.1:46950	Total	1	259ms
	select	1	259ms
app - 127.0.0.1:54800	Total	1	259ms
	select	1	259ms
app - 127.0.0.1:56110	Total	1	224ms
	select	1	224ms
pg_dump	Total	389	35m39s
	copy to	389	35m39s
psql - unix(1675790@a2tech):8963	Total	1	1s284ms
	select	1	1s284ms
psql - unix(1675794@a2tech):8963	Total	1	286ms
	select	1	286ms
psql - unix(1675857@a2tech):8963	Total	1	2s889ms
	others	1	2s889ms
psql - unix(1675863@a2tech):8963	Total	1	4s578ms
	others	1	4s578ms
psql - unix(1675871@a2tech):8963	Total	1	2s51ms
	others	1	2s51ms
psql - unix(1675872@a2tech):8963	Total	1	3s873ms
	others	1	3s873ms
psql - unix(1675881@a2tech):8963	Total	1	226ms
	others	1	226ms
psql - unix(1675897@a2tech):8963	Total	1	4s441ms
	others	1	4s441ms
psql - unix(1676038@a2tech):8963	Total	1	931ms
	others	1	931ms
psql - unix(1676042@a2tech):8963	Total	1	1s407ms
	others	1	1s407ms
psql - unix(1676161@a2tech):8963	Total	1	150ms
	others	1	150ms
psql - unix(1676164@a2tech):8963	Total	1	1s403ms
	others	1	1s403ms
psql - unix(1676325@a2tech):8963	Total	1	771ms
	others	1	771ms
psql - unix(1676331@a2tech):8963	Total	1	1s382ms
	others	1	1s382ms
psql - unix(1676461@a2tech):8963	Total	1	1s383ms
	others	1	1s383ms
psql - unix(1676612@a2tech):8963	Total	1	646ms
	others	1	646ms
psql - unix(1676615@a2tech):8963	Total	1	1s320ms
	others	1	1s320ms
psql - unix(1676777@a2tech):8963	Total	1	195ms
	others	1	195ms
psql - unix(1676782@a2tech):8963	Total	1	1s362ms
	others	1	1s362ms
psql - unix(1677057@a2tech):8963	Total	1	695ms
	others	1	695ms
psql - unix(1677060@a2tech):8963	Total	1	1s601ms
	others	1	1s601ms
psql - unix(1678257@a2tech):8963	Total	1	203ms
	others	1	203ms
psql - unix(1678260@a2tech):8963	Total	1	1s338ms
	others	1	1s338ms
psql - unix(1679482@a2tech):8963	Total	1	686ms
	others	1	686ms
psql - unix(1679489@a2tech):8963	Total	1	1s392ms
	others	1	1s392ms
psql - unix(1680333@a2tech):8963	Total	1	155ms
	others	1	155ms
psql - unix(1680336@a2tech):8963	Total	1	1s445ms
	others	1	1s445ms
psql - unix(1680774@a2tech):8963	Total	1	777ms
	others	1	777ms
psql - unix(1680777@a2tech):8963	Total	1	1s335ms
	others	1	1s335ms
psql - unix(1681103@a2tech):8963	Total	1	1s388ms
	others	1	1s388ms
psql - unix(1681223@a2tech):8963	Total	1	1s376ms
	others	1	1s376ms
psql - unix(1681349@a2tech):8963	Total	1	1s350ms
	others	1	1s350ms
psql - unix(1681495@a2tech):8963	Total	1	497ms
	others	1	497ms
psql - unix(1681501@a2tech):8963	Total	1	1s372ms
	others	1	1s372ms
psql - unix(1681650@a2tech):8963	Total	1	489ms
	others	1	489ms
psql - unix(1681653@a2tech):8963	Total	1	1s367ms
	others	1	1s367ms
psql - unix(1681795@a2tech):8963	Total	1	624ms
	others	1	624ms
psql - unix(1681798@a2tech):8963	Total	1	1s456ms
	others	1	1s456ms
psql - unix(1682240@a2tech):8963	Total	1	374ms
	others	1	374ms
psql - unix(1682290@a2tech):8963	Total	1	1s384ms
	others	1	1s384ms
psql - unix(1682489@a2tech):8963	Total	1	915ms
	others	1	915ms
psql - unix(1682494@a2tech):8963	Total	1	1s421ms
	others	1	1s421ms
psql - unix(1682651@a2tech):8963	Total	1	1s310ms
	others	1	1s310ms
psql - unix(1682817@a2tech):8963	Total	1	775ms
	others	1	775ms
psql - unix(1682825@a2tech):8963	Total	1	1s366ms
	others	1	1s366ms
psql - unix(1682960@a2tech):8963	Total	1	243ms
	others	1	243ms
psql - unix(1682963@a2tech):8963	Total	1	1s311ms
	others	1	1s311ms
psql - unix(1683104@a2tech):8963	Total	1	405ms
	others	1	405ms
psql - unix(1683107@a2tech):8963	Total	1	1s337ms
	others	1	1s337ms
psql - unix(1683320@a2tech):8963	Total	1	481ms
	others	1	481ms
psql - unix(1683325@a2tech):8963	Total	1	1s338ms
	others	1	1s338ms
psql - unix(1683469@a2tech):8963	Total	1	472ms
	others	1	472ms
psql - unix(1683474@a2tech):8963	Total	1	1s347ms
	others	1	1s347ms
psql - unix(1683854@a2tech):8963	Total	1	371ms
	others	1	371ms
psql - unix(1683857@a2tech):8963	Total	1	1s395ms
	others	1	1s395ms
psql - unix(1684894@a2tech):8963	Total	1	635ms
	others	1	635ms
psql - unix(1684900@a2tech):8963	Total	1	1s384ms
	others	1	1s384ms
psql - unix(1685258@a2tech):8963	Total	1	1s427ms
	others	1	1s427ms
psql - unix(1685437@a2tech):8963	Total	1	591ms
	others	1	591ms
psql - unix(1685440@a2tech):8963	Total	1	1s452ms
	others	1	1s452ms
psql - unix(1685689@a2tech):8963	Total	1	1m53s
	others	1	1m53s
psql - unix(1685724@a2tech):8963	Total	1	1m20s
	others	1	1m20s
psql - unix(1685740@a2tech):8963	Total	1	58s797ms
	others	1	58s797ms
psql - unix(1685776@a2tech):8963	Total	1	390ms
	others	1	390ms
psql - unix(1685781@a2tech):8963	Total	1	1s328ms
	others	1	1s328ms
psql - unix(1686045@a2tech):8963	Total	1	552ms
	others	1	552ms
psql - unix(1686049@a2tech):8963	Total	1	1s322ms
	others	1	1s322ms
psql - unix(1686204@a2tech):8963	Total	1	999ms
	others	1	999ms
psql - unix(1686208@a2tech):8963	Total	1	1s418ms
	others	1	1s418ms
psql - unix(1686326@a2tech):8963	Total	1	20s765ms
	others	1	20s765ms
psql - unix(1686332@a2tech):8963	Total	1	45s947ms
	others	1	45s947ms
psql - unix(1686498@a2tech):8963	Total	1	1s141ms
	others	1	1s141ms
psql - unix(1686505@a2tech):8963	Total	1	1s333ms
	others	1	1s333ms
psql - unix(1686631@a2tech):8963	Total	1	248ms
	others	1	248ms
psql - unix(1686634@a2tech):8963	Total	1	1s308ms
	others	1	1s308ms
psql - unix(1686829@a2tech):8963	Total	1	1s297ms
	others	1	1s297ms
psql - unix(1686942@a2tech):8963	Total	1	1s364ms
	select	1	1s364ms
psql - unix(1686944@a2tech):8963	Total	1	283ms
	select	1	283ms
psql - unix(1686947@a2tech):8963	Total	1	170ms
	select	1	170ms
psql - unix(1687013@a2tech):8963	Total	1	1s348ms
	others	1	1s348ms
psql - unix(1687014@a2tech):8963	Total	1	2s160ms
	others	1	2s160ms
psql - unix(1687037@a2tech):8963	Total	1	1s938ms
	others	1	1s938ms
psql - unix(1687045@a2tech):8963	Total	1	2s28ms
	others	1	2s28ms
psql - unix(1687148@a2tech):8963	Total	1	1s377ms
	others	1	1s377ms
psql - unix(1687265@a2tech):8963	Total	1	1s328ms
	others	1	1s328ms
psql - unix(1687403@a2tech):8963	Total	1	1s447ms
	others	1	1s447ms
psql - unix(1687523@a2tech):8963	Total	1	1s451ms
	others	1	1s451ms
psql - unix(1687641@a2tech):8963	Total	1	1s333ms
	others	1	1s333ms
psql - unix(1687809@a2tech):8963	Total	1	3m23s
	select	1	3m23s
psql - unix(1687812@a2tech):8963	Total	1	1s520ms
	others	1	1s520ms
psql - unix(1687872@a2tech):8963	Total	1	21s849ms
	select	1	21s849ms
psql - unix(1687879@a2tech):8963	Total	1	10s23ms
	select	1	10s23ms
psql - unix(1687883@a2tech):8963	Total	1	2m16s
	select	1	2m16s
psql - unix(1687911@a2tech):8963	Total	1	777ms
	select	1	777ms
psql - unix(1687917@a2tech):8963	Total	1	456ms
	select	1	456ms
psql - unix(1687969@a2tech):8963	Total	1	1s307ms
	others	1	1s307ms
psql - unix(1688095@a2tech):8963	Total	1	1s326ms
	others	1	1s326ms
psql - unix(1688223@a2tech):8963	Total	1	1s412ms
	others	1	1s412ms
psql - unix(1688348@a2tech):8963	Total	1	1s386ms
	others	1	1s386ms
psql - unix(1688464@a2tech):8963	Total	1	1s372ms
	others	1	1s372ms
psql - unix(1688532@a2tech):8963	Total	1	761ms
	others	1	761ms
psql - unix(1688536@a2tech):8963	Total	1	227ms
	others	1	227ms
psql - unix(1688620@a2tech):8963	Total	1	3m7s
	select	1	3m7s
psql - unix(1688624@a2tech):8963	Total	1	1s536ms
	others	1	1s536ms
psql - unix(1688679@a2tech):8963	Total	1	17s720ms
	select	1	17s720ms
psql - unix(1688686@a2tech):8963	Total	1	8s283ms
	select	1	8s283ms
psql - unix(1688692@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1688718@a2tech):8963	Total	1	524ms
	select	1	524ms
psql - unix(1688721@a2tech):8963	Total	1	323ms
	select	1	323ms
psql - unix(1688774@a2tech):8963	Total	1	1s329ms
	others	1	1s329ms
psql - unix(1688848@a2tech):8963	Total	1	217ms
	others	1	217ms
psql - unix(1688850@a2tech):8963	Total	1	226ms
	others	1	226ms
psql - unix(1688905@a2tech):8963	Total	1	1s343ms
	others	1	1s343ms
psql - unix(1689031@a2tech):8963	Total	1	1s397ms
	others	1	1s397ms
psql - unix(1689101@a2tech):8963	Total	1	245ms
	others	1	245ms
psql - unix(1689161@a2tech):8963	Total	1	1s337ms
	others	1	1s337ms
psql - unix(1689286@a2tech):8963	Total	1	1s322ms
	others	1	1s322ms
psql - unix(1689355@a2tech):8963	Total	1	160ms
	others	1	160ms
psql - unix(1689439@a2tech):8963	Total	1	3m5s
	select	1	3m5s
psql - unix(1689444@a2tech):8963	Total	1	1s458ms
	others	1	1s458ms
psql - unix(1689506@a2tech):8963	Total	1	17s548ms
	select	1	17s548ms
psql - unix(1689512@a2tech):8963	Total	1	8s152ms
	select	1	8s152ms
psql - unix(1689518@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1689578@a2tech):8963	Total	1	565ms
	select	1	565ms
psql - unix(1689582@a2tech):8963	Total	1	358ms
	select	1	358ms
psql - unix(1689635@a2tech):8963	Total	1	1s378ms
	others	1	1s378ms
psql - unix(1689710@a2tech):8963	Total	1	278ms
	others	1	278ms
psql - unix(1689764@a2tech):8963	Total	1	1s300ms
	others	1	1s300ms
psql - unix(1689889@a2tech):8963	Total	1	1s356ms
	others	1	1s356ms
psql - unix(1689959@a2tech):8963	Total	1	233ms
	others	1	233ms
psql - unix(1690020@a2tech):8963	Total	1	1s357ms
	others	1	1s357ms
psql - unix(1690137@a2tech):8963	Total	1	1s309ms
	others	1	1s309ms
psql - unix(1690207@a2tech):8963	Total	1	150ms
	others	1	150ms
psql - unix(1690288@a2tech):8963	Total	1	3m5s
	select	1	3m5s
psql - unix(1690295@a2tech):8963	Total	1	1s431ms
	others	1	1s431ms
psql - unix(1690350@a2tech):8963	Total	1	17s833ms
	select	1	17s833ms
psql - unix(1690357@a2tech):8963	Total	1	8s210ms
	select	1	8s210ms
psql - unix(1690362@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1690391@a2tech):8963	Total	1	603ms
	select	1	603ms
psql - unix(1690396@a2tech):8963	Total	1	380ms
	select	1	380ms
psql - unix(1690449@a2tech):8963	Total	1	1s350ms
	others	1	1s350ms
psql - unix(1690521@a2tech):8963	Total	1	226ms
	others	1	226ms
psql - unix(1690523@a2tech):8963	Total	1	229ms
	others	1	229ms
psql - unix(1690578@a2tech):8963	Total	1	1s301ms
	others	1	1s301ms
psql - unix(1690701@a2tech):8963	Total	1	1s505ms
	others	1	1s505ms
psql - unix(1690778@a2tech):8963	Total	1	239ms
	others	1	239ms
psql - unix(1690838@a2tech):8963	Total	1	1s298ms
	others	1	1s298ms
psql - unix(1690961@a2tech):8963	Total	1	1s329ms
	others	1	1s329ms
psql - unix(1691113@a2tech):8963	Total	1	3m6s
	select	1	3m6s
psql - unix(1691121@a2tech):8963	Total	1	1s481ms
	others	1	1s481ms
psql - unix(1691175@a2tech):8963	Total	1	17s438ms
	select	1	17s438ms
psql - unix(1691183@a2tech):8963	Total	1	8s257ms
	select	1	8s257ms
psql - unix(1691188@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1691215@a2tech):8963	Total	1	560ms
	select	1	560ms
psql - unix(1691219@a2tech):8963	Total	1	357ms
	select	1	357ms
psql - unix(1691272@a2tech):8963	Total	1	1s308ms
	others	1	1s308ms
psql - unix(1691343@a2tech):8963	Total	1	250ms
	others	1	250ms
psql - unix(1691401@a2tech):8963	Total	1	1s378ms
	others	1	1s378ms
psql - unix(1691409@a2tech):8963	Total	1	151ms
	others	1	151ms
psql - unix(1691527@a2tech):8963	Total	1	1s364ms
	others	1	1s364ms
psql - unix(1691606@a2tech):8963	Total	1	261ms
	others	1	261ms
psql - unix(1691608@a2tech):8963	Total	1	245ms
	others	1	245ms
psql - unix(1691669@a2tech):8963	Total	1	1s323ms
	others	1	1s323ms
psql - unix(1691787@a2tech):8963	Total	1	1s342ms
	others	1	1s342ms
psql - unix(1691942@a2tech):8963	Total	1	3m6s
	select	1	3m6s
psql - unix(1691946@a2tech):8963	Total	1	1s517ms
	others	1	1s517ms
psql - unix(1692001@a2tech):8963	Total	1	17s655ms
	select	1	17s655ms
psql - unix(1692007@a2tech):8963	Total	1	8s353ms
	select	1	8s353ms
psql - unix(1692012@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1692040@a2tech):8963	Total	1	545ms
	select	1	545ms
psql - unix(1692045@a2tech):8963	Total	1	360ms
	select	1	360ms
psql - unix(1692098@a2tech):8963	Total	1	1s301ms
	others	1	1s301ms
psql - unix(1692167@a2tech):8963	Total	1	236ms
	others	1	236ms
psql - unix(1692228@a2tech):8963	Total	1	1s337ms
	others	1	1s337ms
psql - unix(1692352@a2tech):8963	Total	1	1s378ms
	others	1	1s378ms
psql - unix(1692430@a2tech):8963	Total	1	262ms
	others	1	262ms
psql - unix(1692435@a2tech):8963	Total	1	226ms
	others	1	226ms
psql - unix(1692497@a2tech):8963	Total	1	1s406ms
	others	1	1s406ms
psql - unix(1692647@a2tech):8963	Total	1	1s390ms
	others	1	1s390ms
psql - unix(1692719@a2tech):8963	Total	1	237ms
	others	1	237ms
psql - unix(1692721@a2tech):8963	Total	1	213ms
	others	1	213ms
psql - unix(1692799@a2tech):8963	Total	1	3m9s
	select	1	3m9s
psql - unix(1692805@a2tech):8963	Total	1	1s461ms
	others	1	1s461ms
psql - unix(1692860@a2tech):8963	Total	1	17s831ms
	select	1	17s831ms
psql - unix(1692867@a2tech):8963	Total	1	8s372ms
	select	1	8s372ms
psql - unix(1692873@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1692899@a2tech):8963	Total	1	562ms
	select	1	562ms
psql - unix(1692904@a2tech):8963	Total	1	346ms
	select	1	346ms
psql - unix(1692957@a2tech):8963	Total	1	1s316ms
	others	1	1s316ms
psql - unix(1693088@a2tech):8963	Total	1	1s303ms
	others	1	1s303ms
psql - unix(1693219@a2tech):8963	Total	1	1s322ms
	others	1	1s322ms
psql - unix(1693356@a2tech):8963	Total	1	1s365ms
	others	1	1s365ms
psql - unix(1693365@a2tech):8963	Total	1	153ms
	others	1	153ms
psql - unix(1693478@a2tech):8963	Total	1	1s324ms
	others	1	1s324ms
psql - unix(1693549@a2tech):8963	Total	1	246ms
	others	1	246ms
psql - unix(1693553@a2tech):8963	Total	1	222ms
	others	1	222ms
psql - unix(1693630@a2tech):8963	Total	1	3m8s
	select	1	3m8s
psql - unix(1693633@a2tech):8963	Total	1	1s341ms
	others	1	1s341ms
psql - unix(1693688@a2tech):8963	Total	1	17s787ms
	select	1	17s787ms
psql - unix(1693697@a2tech):8963	Total	1	8s385ms
	select	1	8s385ms
psql - unix(1693702@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1693728@a2tech):8963	Total	1	564ms
	select	1	564ms
psql - unix(1693732@a2tech):8963	Total	1	353ms
	select	1	353ms
psql - unix(1693791@a2tech):8963	Total	1	1s377ms
	others	1	1s377ms
psql - unix(1693861@a2tech):8963	Total	1	258ms
	others	1	258ms
psql - unix(1693920@a2tech):8963	Total	1	1s341ms
	others	1	1s341ms
psql - unix(1694045@a2tech):8963	Total	1	1s427ms
	others	1	1s427ms
psql - unix(1694118@a2tech):8963	Total	1	275ms
	others	1	275ms
psql - unix(1694178@a2tech):8963	Total	1	1s366ms
	others	1	1s366ms
psql - unix(1694299@a2tech):8963	Total	1	1s382ms
	others	1	1s382ms
psql - unix(1694371@a2tech):8963	Total	1	234ms
	others	1	234ms
psql - unix(1694373@a2tech):8963	Total	1	236ms
	others	1	236ms
psql - unix(1694453@a2tech):8963	Total	1	3m7s
	select	1	3m7s
psql - unix(1694456@a2tech):8963	Total	1	1s317ms
	others	1	1s317ms
psql - unix(1694513@a2tech):8963	Total	1	17s786ms
	select	1	17s786ms
psql - unix(1694523@a2tech):8963	Total	1	8s318ms
	select	1	8s318ms
psql - unix(1694528@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1694566@a2tech):8963	Total	1	553ms
	select	1	553ms
psql - unix(1694570@a2tech):8963	Total	1	355ms
	select	1	355ms
psql - unix(1694653@a2tech):8963	Total	1	1s392ms
	others	1	1s392ms
psql - unix(1694724@a2tech):8963	Total	1	171ms
	others	1	171ms
psql - unix(1694781@a2tech):8963	Total	1	1s324ms
	others	1	1s324ms
psql - unix(1694905@a2tech):8963	Total	1	1s395ms
	others	1	1s395ms
psql - unix(1694982@a2tech):8963	Total	1	232ms
	others	1	232ms
psql - unix(1695042@a2tech):8963	Total	1	1s390ms
	others	1	1s390ms
psql - unix(1695169@a2tech):8963	Total	1	1s336ms
	others	1	1s336ms
psql - unix(1695243@a2tech):8963	Total	1	152ms
	others	1	152ms
psql - unix(1695245@a2tech):8963	Total	1	233ms
	others	1	233ms
psql - unix(1695323@a2tech):8963	Total	1	3m7s
	select	1	3m7s
psql - unix(1695330@a2tech):8963	Total	1	1s434ms
	others	1	1s434ms
psql - unix(1695437@a2tech):8963	Total	1	18s86ms
	select	1	18s86ms
psql - unix(1695445@a2tech):8963	Total	1	8s289ms
	select	1	8s289ms
psql - unix(1695450@a2tech):8963	Total	1	2m14s
	select	1	2m14s
psql - unix(1695474@a2tech):8963	Total	1	551ms
	select	1	551ms
psql - unix(1695478@a2tech):8963	Total	1	375ms
	select	1	375ms
psql - unix(1695538@a2tech):8963	Total	1	1s357ms
	others	1	1s357ms
psql - unix(1695606@a2tech):8963	Total	1	215ms
	others	1	215ms
psql - unix(1695611@a2tech):8963	Total	1	216ms
	others	1	216ms
psql - unix(1695667@a2tech):8963	Total	1	1s418ms
	others	1	1s418ms
psql - unix(1695794@a2tech):8963	Total	1	1s292ms
	others	1	1s292ms
psql - unix(1695928@a2tech):8963	Total	1	1s334ms
	others	1	1s334ms
psql - unix(1696044@a2tech):8963	Total	1	1s308ms
	others	1	1s308ms
psql - unix(1696115@a2tech):8963	Total	1	152ms
	others	1	152ms
psql - unix(1696193@a2tech):8963	Total	1	3m7s
	select	1	3m7s
psql - unix(1696201@a2tech):8963	Total	1	1s462ms
	others	1	1s462ms
psql - unix(1696256@a2tech):8963	Total	1	17s723ms
	select	1	17s723ms
psql - unix(1696263@a2tech):8963	Total	1	8s557ms
	select	1	8s557ms
psql - unix(1696268@a2tech):8963	Total	1	2m14s
	select	1	2m14s
psql - unix(1696293@a2tech):8963	Total	1	536ms
	select	1	536ms
psql - unix(1696299@a2tech):8963	Total	1	349ms
	select	1	349ms
psql - unix(1696358@a2tech):8963	Total	1	1s287ms
	others	1	1s287ms
psql - unix(1696433@a2tech):8963	Total	1	240ms
	others	1	240ms
psql - unix(1696435@a2tech):8963	Total	1	230ms
	others	1	230ms
psql - unix(1696491@a2tech):8963	Total	1	1s321ms
	others	1	1s321ms
psql - unix(1696618@a2tech):8963	Total	1	1s362ms
	others	1	1s362ms
psql - unix(1696695@a2tech):8963	Total	1	244ms
	others	1	244ms
psql - unix(1696753@a2tech):8963	Total	1	1s297ms
	others	1	1s297ms
psql - unix(1696870@a2tech):8963	Total	1	1s314ms
	others	1	1s314ms
psql - unix(1697028@a2tech):8963	Total	1	3m6s
	select	1	3m6s
psql - unix(1697036@a2tech):8963	Total	1	1s420ms
	others	1	1s420ms
psql - unix(1697091@a2tech):8963	Total	1	17s934ms
	select	1	17s934ms
psql - unix(1697099@a2tech):8963	Total	1	8s475ms
	select	1	8s475ms
psql - unix(1697102@a2tech):8963	Total	1	2m14s
	select	1	2m14s
psql - unix(1697128@a2tech):8963	Total	1	540ms
	select	1	540ms
psql - unix(1697131@a2tech):8963	Total	1	345ms
	select	1	345ms
psql - unix(1697185@a2tech):8963	Total	1	1s357ms
	others	1	1s357ms
psql - unix(1697261@a2tech):8963	Total	1	232ms
	others	1	232ms
psql - unix(1697263@a2tech):8963	Total	1	238ms
	others	1	238ms
psql - unix(1697318@a2tech):8963	Total	1	1s306ms
	others	1	1s306ms
psql - unix(1697442@a2tech):8963	Total	1	1s335ms
	others	1	1s335ms
psql - unix(1697530@a2tech):8963	Total	1	157ms
	others	1	157ms
psql - unix(1697590@a2tech):8963	Total	1	1s294ms
	others	1	1s294ms
psql - unix(1697716@a2tech):8963	Total	1	1s325ms
	others	1	1s325ms
psql - unix(1697788@a2tech):8963	Total	1	158ms
	others	1	158ms
psql - unix(1697869@a2tech):8963	Total	1	3m7s
	select	1	3m7s
psql - unix(1697877@a2tech):8963	Total	1	1s397ms
	others	1	1s397ms
psql - unix(1697931@a2tech):8963	Total	1	18s156ms
	select	1	18s156ms
psql - unix(1697939@a2tech):8963	Total	1	8s327ms
	select	1	8s327ms
psql - unix(1697944@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1697972@a2tech):8963	Total	1	554ms
	select	1	554ms
psql - unix(1697975@a2tech):8963	Total	1	361ms
	select	1	361ms
psql - unix(1698030@a2tech):8963	Total	1	1s332ms
	others	1	1s332ms
psql - unix(1698101@a2tech):8963	Total	1	240ms
	others	1	240ms
psql - unix(1698104@a2tech):8963	Total	1	249ms
	others	1	249ms
psql - unix(1698157@a2tech):8963	Total	1	1s327ms
	others	1	1s327ms
psql - unix(1698286@a2tech):8963	Total	1	1s389ms
	others	1	1s389ms
psql - unix(1698359@a2tech):8963	Total	1	158ms
	others	1	158ms
psql - unix(1698420@a2tech):8963	Total	1	1s331ms
	others	1	1s331ms
psql - unix(1698537@a2tech):8963	Total	1	1s325ms
	others	1	1s325ms
psql - unix(1698608@a2tech):8963	Total	1	237ms
	others	1	237ms
psql - unix(1698612@a2tech):8963	Total	1	221ms
	others	1	221ms
psql - unix(1698709@a2tech):8963	Total	1	3m20s
	select	1	3m20s
psql - unix(1698714@a2tech):8963	Total	1	2s296ms
	others	1	2s296ms
psql - unix(1698725@a2tech):8963	Total	1	173ms
	others	1	173ms
psql - unix(1698783@a2tech):8963	Total	1	22s121ms
	select	1	22s121ms
psql - unix(1698792@a2tech):8963	Total	1	9s54ms
	select	1	9s54ms
psql - unix(1698797@a2tech):8963	Total	1	2m14s
	select	1	2m14s
psql - unix(1698821@a2tech):8963	Total	1	746ms
	select	1	746ms
psql - unix(1698825@a2tech):8963	Total	1	479ms
	select	1	479ms
psql - unix(1698877@a2tech):8963	Total	1	1s652ms
	others	1	1s652ms
psql - unix(1698987@a2tech):8963	Total	1	261ms
	others	1	261ms
psql - unix(1699045@a2tech):8963	Total	1	1s334ms
	others	1	1s334ms
psql - unix(1699169@a2tech):8963	Total	1	1s516ms
	others	1	1s516ms
psql - unix(1699242@a2tech):8963	Total	1	252ms
	others	1	252ms
psql - unix(1699244@a2tech):8963	Total	1	243ms
	others	1	243ms
psql - unix(1699300@a2tech):8963	Total	1	1s315ms
	others	1	1s315ms
psql - unix(1699422@a2tech):8963	Total	1	1s333ms
	others	1	1s333ms
psql - unix(1699568@a2tech):8963	Total	1	159ms
	others	1	159ms
psql - unix(1699656@a2tech):8963	Total	1	3m8s
	select	1	3m8s
psql - unix(1699666@a2tech):8963	Total	1	1s494ms
	others	1	1s494ms
psql - unix(1699720@a2tech):8963	Total	1	17s848ms
	select	1	17s848ms
psql - unix(1699730@a2tech):8963	Total	1	8s263ms
	select	1	8s263ms
psql - unix(1699734@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1699760@a2tech):8963	Total	1	535ms
	select	1	535ms
psql - unix(1699764@a2tech):8963	Total	1	347ms
	select	1	347ms
psql - unix(1699817@a2tech):8963	Total	1	1s326ms
	others	1	1s326ms
psql - unix(1699894@a2tech):8963	Total	1	251ms
	others	1	251ms
psql - unix(1699896@a2tech):8963	Total	1	204ms
	others	1	204ms
psql - unix(1699957@a2tech):8963	Total	1	1s341ms
	others	1	1s341ms
psql - unix(1700085@a2tech):8963	Total	1	1s341ms
	others	1	1s341ms
psql - unix(1700215@a2tech):8963	Total	1	1s323ms
	others	1	1s323ms
psql - unix(1700333@a2tech):8963	Total	1	1s313ms
	others	1	1s313ms
psql - unix(1700408@a2tech):8963	Total	1	251ms
	others	1	251ms
psql - unix(1700486@a2tech):8963	Total	1	3m7s
	select	1	3m7s
psql - unix(1700494@a2tech):8963	Total	1	1s465ms
	others	1	1s465ms
psql - unix(1700656@a2tech):8963	Total	1	18s11ms
	select	1	18s11ms
psql - unix(1700666@a2tech):8963	Total	1	8s266ms
	select	1	8s266ms
psql - unix(1700670@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1700697@a2tech):8963	Total	1	529ms
	select	1	529ms
psql - unix(1700701@a2tech):8963	Total	1	348ms
	select	1	348ms
psql - unix(1700755@a2tech):8963	Total	1	1s360ms
	others	1	1s360ms
psql - unix(1700827@a2tech):8963	Total	1	235ms
	others	1	235ms
psql - unix(1700829@a2tech):8963	Total	1	218ms
	others	1	218ms
psql - unix(1700883@a2tech):8963	Total	1	1s356ms
	others	1	1s356ms
psql - unix(1701005@a2tech):8963	Total	1	1s411ms
	others	1	1s411ms
psql - unix(1701081@a2tech):8963	Total	1	247ms
	others	1	247ms
psql - unix(1701137@a2tech):8963	Total	1	1s383ms
	others	1	1s383ms
psql - unix(1701257@a2tech):8963	Total	1	1s343ms
	others	1	1s343ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-05-09 23:10:32 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

390 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	199	27.19%
500-1000ms	55	7.51%
1000-10000ms	390	53.28%
> 10000ms	88	12.02%

Slowest individual queries


[ Date: 2026-05-09 07:08:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1687809@a2tech):8963 ]
[ Date: 2026-05-09 20:08:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1698709@a2tech):8963 ]
[ Date: 2026-05-09 13:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1692799@a2tech):8963 ]
[ Date: 2026-05-09 21:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1699656@a2tech):8963 ]
[ Date: 2026-05-09 14:08:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1693630@a2tech):8963 ]
[ Date: 2026-05-09 22:08:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1700486@a2tech):8963 ]
[ Date: 2026-05-09 15:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1694453@a2tech):8963 ]
[ Date: 2026-05-09 19:08:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1697869@a2tech):8963 ]
[ Date: 2026-05-09 16:08:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1695323@a2tech):8963 ]
[ Date: 2026-05-09 17:08:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1696193@a2tech):8963 ]
[ Date: 2026-05-09 08:08:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1688620@a2tech):8963 ]
[ Date: 2026-05-09 12:08:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1691942@a2tech):8963 ]
[ Date: 2026-05-09 11:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1691113@a2tech):8963 ]
[ Date: 2026-05-09 18:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1697028@a2tech):8963 ]
[ Date: 2026-05-09 10:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1690288@a2tech):8963 ]
[ Date: 2026-05-09 09:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1689439@a2tech):8963 ]
[ Date: 2026-05-09 07:11:16 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(1687883@a2tech):8963 ]
[ Date: 2026-05-09 20:11:10 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(1698797@a2tech):8963 ]
[ Date: 2026-05-09 18:10:50 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(1697102@a2tech):8963 ]
[ Date: 2026-05-09 17:10:51 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(1696268@a2tech):8963 ]

Rank	Duration	Query
1	3m23s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-09 07:08:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1687809@a2tech):8963 ]
2	3m20s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-09 20:08:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1698709@a2tech):8963 ]
3	3m9s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-09 13:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1692799@a2tech):8963 ]
4	3m8s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-09 21:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1699656@a2tech):8963 ]
5	3m8s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-09 14:08:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1693630@a2tech):8963 ]
6	3m7s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-09 22:08:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1700486@a2tech):8963 ]
7	3m7s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-09 15:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1694453@a2tech):8963 ]
8	3m7s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-09 19:08:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1697869@a2tech):8963 ]
9	3m7s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-09 16:08:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1695323@a2tech):8963 ]
10	3m7s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-09 17:08:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1696193@a2tech):8963 ]
11	3m7s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-09 08:08:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1688620@a2tech):8963 ]
12	3m6s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-09 12:08:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1691942@a2tech):8963 ]
13	3m6s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-09 11:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1691113@a2tech):8963 ]
14	3m6s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-09 18:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1697028@a2tech):8963 ]
15	3m5s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-09 10:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1690288@a2tech):8963 ]
16	3m5s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-09 09:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1689439@a2tech):8963 ]
17	2m16s	SELECT * FROM RS_SMART_FISCAL_SAIDA (); [ Date: 2026-05-09 07:11:16 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(1687883@a2tech):8963 ]
18	2m14s	SELECT * FROM RS_SMART_FISCAL_SAIDA (); [ Date: 2026-05-09 20:11:10 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(1698797@a2tech):8963 ]
19	2m14s	SELECT * FROM RS_SMART_FISCAL_SAIDA (); [ Date: 2026-05-09 18:10:50 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(1697102@a2tech):8963 ]
20	2m14s	SELECT * FROM RS_SMART_FISCAL_SAIDA (); [ Date: 2026-05-09 17:10:51 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(1696268@a2tech):8963 ]

Time consuming queries (N)


[ User: intelifix - Total duration: 52m50s - Times executed: 48 ]
[ User: intelifix - Total duration: 40m41s - Times executed: 48 ]
[ User: intelifix - Total duration: 4m12s - Times executed: 3 ]
[ User: intelifix - Total duration: 3m11s - Times executed: 142 ]
[ User: intelifix - Total duration: 1m44s - Times executed: 4 ]
[ User: intelifix - Total duration: 1m37s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m25s - Times executed: 4 ]
[ User: intelifix - Total duration: 1m22s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m14s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ User: intelifix - Total duration: 57s696ms - Times executed: 6 ]
[ User: intelifix - Total duration: 57s207ms - Times executed: 6 ]
[ User: intelifix - Total duration: 47s538ms - Times executed: 6 ]
[ User: intelifix - Total duration: 47s134ms - Times executed: 6 ]
[ User: intelifix - Total duration: 45s947ms - Times executed: 1 ]
[ User: intelifix - Total duration: 41s958ms - Times executed: 6 ]
[ User: intelifix - Total duration: 37s332ms - Times executed: 4 ]
[ User: intelifix - Total duration: 35s423ms - Times executed: 6 ]
[ User: intelifix - Total duration: 28s7ms - Times executed: 3 ]
[ User: intelifix - Total duration: 27s88ms - Times executed: 6 ]

Most frequent queries (N)


[ User: intelifix - Total duration: 3m11s - Times executed: 142 ]
[ User: intelifix - Total duration: 52m50s - Times executed: 48 ]
[ User: intelifix - Total duration: 40m41s - Times executed: 48 ]
[ User: intelifix - Total duration: 7s424ms - Times executed: 31 ]
[ User: intelifix - Total duration: 18s313ms - Times executed: 29 ]
[ User: intelifix - Total duration: 5s489ms - Times executed: 24 ]
[ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ User: intelifix - Total duration: 57s696ms - Times executed: 6 ]
[ User: intelifix - Total duration: 57s207ms - Times executed: 6 ]
[ User: intelifix - Total duration: 47s538ms - Times executed: 6 ]
[ User: intelifix - Total duration: 47s134ms - Times executed: 6 ]
[ User: intelifix - Total duration: 41s958ms - Times executed: 6 ]
[ User: intelifix - Total duration: 35s423ms - Times executed: 6 ]
[ User: intelifix - Total duration: 27s88ms - Times executed: 6 ]
[ User: intelifix - Total duration: 19s629ms - Times executed: 6 ]
[ User: intelifix - Total duration: 19s20ms - Times executed: 6 ]
[ User: intelifix - Total duration: 18s986ms - Times executed: 6 ]
[ User: intelifix - Total duration: 17s457ms - Times executed: 6 ]
[ User: intelifix - Total duration: 12s175ms - Times executed: 6 ]
[ User: intelifix - Total duration: 8s890ms - Times executed: 6 ]

Normalized slowest queries (N)


[ User: intelifix - Total duration: 4m12s - Times executed: 3 ]
[ User: intelifix - Total duration: 52m50s - Times executed: 48 ]
[ User: intelifix - Total duration: 40m41s - Times executed: 48 ]
[ User: intelifix - Total duration: 45s947ms - Times executed: 1 ]
[ User: intelifix - Total duration: 1m37s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m22s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m44s - Times executed: 4 ]
[ User: intelifix - Total duration: 1m14s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m25s - Times executed: 4 ]
[ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ User: intelifix - Total duration: 57s696ms - Times executed: 6 ]
[ User: intelifix - Total duration: 57s207ms - Times executed: 6 ]
[ User: intelifix - Total duration: 28s7ms - Times executed: 3 ]
[ User: intelifix - Total duration: 37s332ms - Times executed: 4 ]
[ User: intelifix - Total duration: 47s538ms - Times executed: 6 ]
[ User: intelifix - Total duration: 47s134ms - Times executed: 6 ]
[ User: intelifix - Total duration: 41s958ms - Times executed: 6 ]
[ User: intelifix - Total duration: 35s423ms - Times executed: 6 ]
[ User: intelifix - Total duration: 27s88ms - Times executed: 6 ]
[ User: intelifix - Total duration: 19s629ms - 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

1

0ms

5

Details

0ms

;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
May 09	12	1	0ms	0ms
	13	1	0ms	0ms
	16	1	0ms	0ms
	20	1	0ms	0ms
	22	1	0ms	0ms

[ User: intelifix - Total duration: 18s396ms - Times executed: 5 ]

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

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

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

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

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

;

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

Log levels

Key values

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

Chart
Table

Type	Count	Percentage
CONTEXT	12	0.23%
ERROR	1,041	19.99%
EVENTLOG	4	0.08%
FATAL	25	0.48%
LOG	3,073	59.01%
STATEMENT	1,053	20.22%

Events distribution (except queries)

Key values

0 PANIC entries
25 FATAL entries
1041 ERROR entries
0 WARNING entries
4 EVENTLOG entries

Most Frequent Errors/Events

Key values

1,037 Max number of times the same event was reported
1,070 Total events found

Rank

Times reported

Error

1

1,037

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
May 09	00	45
	01	40
	02	44
	03	43
	04	44
	05	43
	06	44
	07	44
	08	42
	09	42
	10	42
	11	43
	12	44
	13	42
	14	46
	15	44
	16	43
	17	45
	18	42
	19	41
	20	44
	21	43
	22	41
	23	46

ERROR: prepared statement "_PLAN000000004FAB9F20" does not exist
ERROR: prepared statement "_PLAN000000004FABA3B0" does not exist
ERROR: prepared statement "_PLAN000000004FAAED30" does not exist

2

13

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
May 09	00	1
	06	1
	13	1
	20	6
	21	4

3

7

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
May 09	03	7

4

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
May 09	05	4

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

5

3

Details

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

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
May 09	07	2
	14	1

6

1

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
May 09	07	1

7

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
May 09	03	1

8

1

Details

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

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
May 09	14	1

9

1

Details

FATAL: database "..." does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'cq.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
May 09	20	1

10

1

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
May 09	03	1

11

1

Details

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

Times Reported Most Frequent Error / Event #11

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

Type of locks

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user