pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Mon May 11 23:50:07 2026
Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-Wed.log
Parsed 9,515 log entries in 5s
Log start from 2026-05-10 00:00:46 to 2026-05-10 23:59:18

Global Stats

129 Number of unique normalized queries
692 Number of queries
2h19m5s Total query duration
2026-05-10 00:02:03 First query
2026-05-10 23:39:44 Last query
6 queries/s at 2026-05-10 23:39:24 Query peak

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

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

6 Total number of automatic vacuums
0 Total number of automatic analyzes

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

517 Total number of sessions
9 sessions at 2026-05-10 07:02:04 Session peak
7d12h48m4s Total duration of sessions
20m58s Average duration of sessions
1 Average queries per session
16s142ms Average queries duration per session
20m42s Average idle time per session

522 Total number of connections
4 connections/s at 2026-05-10 06:02:04 Connection peak
3 Total number of databases

SQL Traffic

Key values

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

SELECT Traffic

Key values

2 queries/s Query Peak
2026-05-10 13:10:53 Date

INSERT/UPDATE/DELETE Traffic

Key values

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

Queries duration

Key values

2h19m5s 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 10	00	12	0ms	4s549ms	1s985ms	1s373ms	1s409ms	15s290ms
	01	6	0ms	1s508ms	1s399ms	1s313ms	1s366ms	1s508ms
	02	6	0ms	1s500ms	1s389ms	1s324ms	1s396ms	1s500ms
	03	6	0ms	1s441ms	1s167ms	156ms	1s370ms	1s441ms
	04	6	0ms	1s387ms	1s346ms	1s298ms	1s372ms	1s387ms
	05	11	0ms	1m55s	30s111ms	1s810ms	59s125ms	1m55s
	06	12	0ms	2s150ms	1s333ms	1s336ms	1s404ms	7s330ms
	07	12	0ms	3m25s	31s913ms	1s399ms	10s17ms	3m48s
	08	17	0ms	3m14s	21s436ms	1s353ms	1s483ms	3m40s
	09	15	0ms	3m9s	23s871ms	1s380ms	1s493ms	3m35s
	10	14	0ms	3m8s	25s605ms	1s392ms	1s498ms	3m34s
	11	17	0ms	3m10s	21s249ms	1s371ms	1s480ms	3m37s
	12	16	0ms	3m8s	22s386ms	1s353ms	1s418ms	3m34s
	13	15	0ms	3m9s	23s894ms	1s337ms	1s513ms	3m35s
	14	15	0ms	3m13s	24s203ms	1s378ms	1s466ms	3m39s
	15	16	0ms	3m13s	22s705ms	1s373ms	1s491ms	3m39s
	16	16	0ms	3m11s	22s626ms	1s405ms	1s479ms	3m38s
	17	16	0ms	3m13s	22s695ms	1s364ms	1s509ms	3m40s
	18	16	0ms	3m8s	22s390ms	1s358ms	1s439ms	3m34s
	19	16	0ms	3m15s	22s814ms	1s389ms	1s445ms	3m41s
	20	90	0ms	3m20s	8s265ms	54s904ms	1m13s	4m4s
	21	14	0ms	3m11s	25s862ms	1s409ms	1s513ms	3m38s
	22	15	0ms	3m13s	24s223ms	1s348ms	1s472ms	3m39s
	23	313	0ms	1m2s	5s613ms	1m3s	1m7s	1m21s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
May 10	00	2	0	812ms	0ms	0ms	0ms
	01	0	0	0ms	0ms	0ms	0ms
	02	0	0	0ms	0ms	0ms	0ms
	03	0	0	0ms	0ms	0ms	0ms
	04	0	0	0ms	0ms	0ms	0ms
	05	0	0	0ms	0ms	0ms	0ms
	06	3	0	615ms	0ms	0ms	0ms
	07	6	0	1m2s	0ms	0ms	2m16s
	08	6	0	59s111ms	0ms	0ms	2m14s
	09	6	0	58s181ms	0ms	0ms	2m14s
	10	6	0	58s263ms	0ms	0ms	2m14s
	11	6	0	58s626ms	0ms	0ms	2m14s
	12	6	0	58s186ms	0ms	0ms	2m14s
	13	6	0	58s257ms	0ms	0ms	2m14s
	14	6	0	58s999ms	0ms	0ms	2m14s
	15	6	0	59s4ms	0ms	0ms	2m14s
	16	6	0	58s781ms	0ms	0ms	2m14s
	17	6	0	58s974ms	0ms	0ms	2m13s
	18	7	0	49s906ms	0ms	0ms	2m14s
	19	6	0	59s284ms	0ms	0ms	2m13s
	20	6	73	9s281ms	0ms	54s904ms	2m16s
	21	6	0	58s849ms	0ms	0ms	2m14s
	22	6	0	59s68ms	0ms	0ms	2m14s
	23	0	313	5s613ms	1m	1m3s	1m8s

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

Day	Hour	Count	Average Duration	Average idle time
May 10	00	12	9m45s	9m43s
	01	27	27m5s	27m5s
	02	23	18m4s	18m4s
	03	27	12m24s	12m23s
	04	23	18m23s	18m23s
	05	21	19m36s	19m20s
	06	22	20m56s	20m56s
	07	30	28m24s	28m11s
	08	21	20m28s	20m11s
	09	21	18m54s	18m37s
	10	22	21m46s	21m29s
	11	18	23m9s	22m49s
	12	22	22m7s	21m51s
	13	21	22m47s	22m30s
	14	21	22m48s	22m31s
	15	19	18m55s	18m36s
	16	18	23m8s	22m48s
	17	20	20m52s	20m34s
	18	20	21m9s	20m51s
	19	20	20m41s	20m23s
	20	23	21m11s	20m39s
	21	20	24m12s	23m54s
	22	23	21m3s	20m47s
	23	23	19m27s	18m11s

↑ Back to the top of the General Activity table

Established Connections

Key values

4 connections Connection Peak
2026-05-10 06:02:04 Date

Connections per database

Key values

brasilia Main Database
522 connections Total

Chart
Table

Database	User	Count
brasilia		423
	etiquetas	373
	intelifix	46
	lenon	4
contagem		41
	intelifix	38
	lenon	3
jaboatao		3
	intelifix	3
rio		53
	intelifix	49
	lenon	4
testes		2
	lenon	2

Connections per user

Key values

etiquetas Main User
522 connections Total

Chart
Table

User	Count
etiquetas	373
intelifix	136
lenon	13

Connections per host

Key values

[local] Main host with 521 connections
522 Total connections

Chart
Table

Host	Count
127.0.0.1	1
[local]	521

Simultaneous sessions

Key values

9 sessions Session Peak
2026-05-10 07:02:04 Date

Histogram of session times

Key values

348 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	0	0.00%
500ms-1s	0	0.00%
1s-30s	1	0.19%
30s-1m	8	1.55%
1m-10m	348	67.31%
10m-30m	2	0.39%
30m-1h	8	1.55%
1h-8h	150	29.01%
> 8h	0	0.00%

Sessions per database

Key values

brasilia Main Database
517 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
brasilia	423	3d21h18m37s	13m14s
contagem	41	1d14h1m30s	55m38s
rio	53	2d1h27m56s	55m59s

Sessions per user

Key values

etiquetas Main User
517 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
etiquetas	373	1d23h49m17s	7m41s
intelifix	133	5d2h1m43s	55m3s
lenon	11	10h57m3s	59m43s

Sessions per host

Key values

[local] Main Host
517 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	1	45m1s	45m1s
[local]	516	7d12h3m2s	20m56s

Sessions per application

Key values

[unknown] Main Application
517 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
[unknown]	123	4d20h23m54s	56m46s
app - 177.99.204.34:49256	1	4m9s	4m9s
app - 177.99.204.34:49263	1	4m10s	4m10s
app - 177.99.204.34:49369	1	6m17s	6m17s
app - 177.99.204.34:49400	1	4m10s	4m10s
app - 177.99.204.34:49513	2	1h1m34s	30m47s
app - 177.99.204.34:49531	1	3m7s	3m7s
app - 177.99.204.34:49564	1	2m4s	2m4s
app - 177.99.204.34:49607	1	4m11s	4m11s
app - 177.99.204.34:49628	1	4m11s	4m11s
app - 177.99.204.34:49637	1	7m19s	7m19s
app - 177.99.204.34:49700	1	3m7s	3m7s
app - 177.99.204.34:49780	1	5m12s	5m12s
app - 177.99.204.34:49787	1	2m4s	2m4s
app - 177.99.204.34:49794	1	3m7s	3m7s
app - 177.99.204.34:49831	2	1h5m16s	32m38s
app - 177.99.204.34:49864	1	3m7s	3m7s
app - 177.99.204.34:49994	1	5m13s	5m13s
app - 177.99.204.34:50196	1	2m4s	2m4s
app - 177.99.204.34:50197	1	4m11s	4m11s
app - 177.99.204.34:50304	1	3m7s	3m7s
app - 177.99.204.34:50428	1	5m13s	5m13s
app - 177.99.204.34:50438	1	4m9s	4m9s
app - 177.99.204.34:50460	1	4m10s	4m10s
app - 177.99.204.34:50486	1	4m11s	4m11s
app - 177.99.204.34:50506	1	2m4s	2m4s
app - 177.99.204.34:50531	1	5m13s	5m13s
app - 177.99.204.34:50579	1	5m12s	5m12s
app - 177.99.204.34:50607	2	1h5m17s	32m38s
app - 177.99.204.34:50630	1	4m10s	4m10s
app - 177.99.204.34:50649	1	5m12s	5m12s
app - 177.99.204.34:50650	1	3m7s	3m7s
app - 177.99.204.34:50686	1	4m10s	4m10s
app - 177.99.204.34:50756	1	3m7s	3m7s
app - 177.99.204.34:50775	1	2m4s	2m4s
app - 177.99.204.34:50822	1	4m9s	4m9s
app - 177.99.204.34:50857	1	3m7s	3m7s
app - 177.99.204.34:50869	1	4m9s	4m9s
app - 177.99.204.34:50890	1	5m13s	5m13s
app - 177.99.204.34:50911	1	3m7s	3m7s
app - 177.99.204.34:51045	1	5m12s	5m12s
app - 177.99.204.34:51061	1	4m11s	4m11s
app - 177.99.204.34:51099	1	3m8s	3m8s
app - 177.99.204.34:51200	1	4m38s	4m38s
app - 177.99.204.34:51410	1	3m7s	3m7s
app - 177.99.204.34:51515	1	4m10s	4m10s
app - 177.99.204.34:51534	1	4m10s	4m10s
app - 177.99.204.34:51540	1	5m13s	5m13s
app - 177.99.204.34:51592	2	1h1m4s	30m32s
app - 177.99.204.34:51687	1	4m9s	4m9s
app - 177.99.204.34:51745	1	4m10s	4m10s
app - 177.99.204.34:51764	1	3m7s	3m7s
app - 177.99.204.34:51794	1	4m11s	4m11s
app - 177.99.204.34:51808	1	4m10s	4m10s
app - 177.99.204.34:51898	1	2m4s	2m4s
app - 177.99.204.34:51920	1	4m11s	4m11s
app - 177.99.204.34:51928	1	6m15s	6m15s
app - 177.99.204.34:51960	1	5m13s	5m13s
app - 177.99.204.34:51972	1	5m13s	5m13s
app - 177.99.204.34:52001	1	2m4s	2m4s
app - 177.99.204.34:52134	1	5m13s	5m13s
app - 177.99.204.34:52145	1	3m10s	3m10s
app - 177.99.204.34:52175	2	1h5m16s	32m38s
app - 177.99.204.34:52199	1	3m7s	3m7s
app - 177.99.204.34:52215	1	5m12s	5m12s
app - 177.99.204.34:52302	1	6m16s	6m16s
app - 177.99.204.34:52340	3	1h5m49s	21m56s
app - 177.99.204.34:52360	1	6m14s	6m14s
app - 177.99.204.34:52468	1	2m4s	2m4s
app - 177.99.204.34:52484	1	2m4s	2m4s
app - 177.99.204.34:52504	1	4m10s	4m10s
app - 177.99.204.34:52628	1	2m4s	2m4s
app - 177.99.204.34:52660	1	4m10s	4m10s
app - 177.99.204.34:52716	1	5m14s	5m14s
app - 177.99.204.34:52755	1	2m4s	2m4s
app - 177.99.204.34:52787	1	5m12s	5m12s
app - 177.99.204.34:52814	1	4m10s	4m10s
app - 177.99.204.34:52820	1	4m10s	4m10s
app - 177.99.204.34:52963	1	3m7s	3m7s
app - 177.99.204.34:52982	1	2m4s	2m4s
app - 177.99.204.34:53116	1	3m7s	3m7s
app - 177.99.204.34:53150	1	5m12s	5m12s
app - 177.99.204.34:53174	1	4m11s	4m11s
app - 177.99.204.34:53179	1	3m7s	3m7s
app - 177.99.204.34:53248	2	6m14s	3m7s
app - 177.99.204.34:53261	1	7m19s	7m19s
app - 177.99.204.34:53283	1	4m10s	4m10s
app - 177.99.204.34:53310	1	3m8s	3m8s
app - 177.99.204.34:53325	1	3m7s	3m7s
app - 177.99.204.34:53427	2	1h4m12s	32m6s
app - 177.99.204.34:53475	1	2m3s	2m3s
app - 177.99.204.34:53570	1	3m7s	3m7s
app - 177.99.204.34:53687	1	7m17s	7m17s
app - 177.99.204.34:53768	1	7m17s	7m17s
app - 177.99.204.34:53789	1	2m4s	2m4s
app - 177.99.204.34:53896	1	3m7s	3m7s
app - 177.99.204.34:53915	1	3m7s	3m7s
app - 177.99.204.34:53979	1	8m21s	8m21s
app - 177.99.204.34:53995	1	3m7s	3m7s
app - 177.99.204.34:54015	1	4m10s	4m10s
app - 177.99.204.34:54037	1	4m11s	4m11s
app - 177.99.204.34:54055	1	6m16s	6m16s
app - 177.99.204.34:54089	1	5m12s	5m12s
app - 177.99.204.34:54163	1	3m7s	3m7s
app - 177.99.204.34:54192	1	3m7s	3m7s
app - 177.99.204.34:54232	1	6m14s	6m14s
app - 177.99.204.34:54247	2	1h33s	30m16s
app - 177.99.204.34:54350	1	3m7s	3m7s
app - 177.99.204.34:54414	2	49m2s	24m31s
app - 177.99.204.34:54420	1	2m4s	2m4s
app - 177.99.204.34:54436	1	4m10s	4m10s
app - 177.99.204.34:54438	1	4m13s	4m13s
app - 177.99.204.34:54444	1	2m4s	2m4s
app - 177.99.204.34:54487	1	3m7s	3m7s
app - 177.99.204.34:54505	1	3m7s	3m7s
app - 177.99.204.34:54551	1	5m14s	5m14s
app - 177.99.204.34:54596	1	4m11s	4m11s
app - 177.99.204.34:54632	1	4m10s	4m10s
app - 177.99.204.34:54688	1	3m7s	3m7s
app - 177.99.204.34:54703	1	3m7s	3m7s
app - 177.99.204.34:54937	1	2m4s	2m4s
app - 177.99.204.34:54948	1	5m13s	5m13s
app - 177.99.204.34:54962	1	5m12s	5m12s
app - 177.99.204.34:55091	1	6m15s	6m15s
app - 177.99.204.34:55124	2	10m27s	5m13s
app - 177.99.204.34:55161	1	6m16s	6m16s
app - 177.99.204.34:55226	1	4m10s	4m10s
app - 177.99.204.34:55261	1	6m16s	6m16s
app - 177.99.204.34:55388	1	6m15s	6m15s
app - 177.99.204.34:55446	1	5m13s	5m13s
app - 177.99.204.34:55496	2	1h36s	30m18s
app - 177.99.204.34:55535	1	3m7s	3m7s
app - 177.99.204.34:55566	1	9m23s	9m23s
app - 177.99.204.34:55617	1	4m10s	4m10s
app - 177.99.204.34:55708	1	8m20s	8m20s
app - 177.99.204.34:55762	1	4m10s	4m10s
app - 177.99.204.34:55795	1	2m4s	2m4s
app - 177.99.204.34:55858	1	4m10s	4m10s
app - 177.99.204.34:55895	1	3m7s	3m7s
app - 177.99.204.34:55983	1	6m15s	6m15s
app - 177.99.204.34:55997	1	2m4s	2m4s
app - 177.99.204.34:56062	1	2m7s	2m7s
app - 177.99.204.34:56115	1	3m7s	3m7s
app - 177.99.204.34:56163	1	4m10s	4m10s
app - 177.99.204.34:56178	1	5m14s	5m14s
app - 177.99.204.34:56228	1	4m11s	4m11s
app - 177.99.204.34:56246	1	3m7s	3m7s
app - 177.99.204.34:56341	1	4m10s	4m10s
app - 177.99.204.34:56347	1	4m10s	4m10s
app - 177.99.204.34:56481	1	6m15s	6m15s
app - 177.99.204.34:56574	1	3m7s	3m7s
app - 177.99.204.34:56605	1	4m10s	4m10s
app - 177.99.204.34:56635	1	3m7s	3m7s
app - 177.99.204.34:56727	1	2m4s	2m4s
app - 177.99.204.34:56737	1	33s604ms	33s604ms
app - 177.99.204.34:56775	1	5m13s	5m13s
app - 177.99.204.34:56803	1	3m7s	3m7s
app - 177.99.204.34:56883	1	4m9s	4m9s
app - 177.99.204.34:56909	1	7m18s	7m18s
app - 177.99.204.34:56959	1	3m7s	3m7s
app - 177.99.204.34:57072	1	4m10s	4m10s
app - 177.99.204.34:57147	1	5m13s	5m13s
app - 177.99.204.34:57199	1	3m7s	3m7s
app - 177.99.204.34:57237	1	2m4s	2m4s
app - 177.99.204.34:57245	1	3m7s	3m7s
app - 177.99.204.34:57259	2	1h3m10s	31m35s
app - 177.99.204.34:57287	1	2m4s	2m4s
app - 177.99.204.34:57318	1	6m16s	6m16s
app - 177.99.204.34:57322	1	4m10s	4m10s
app - 177.99.204.34:57410	1	2m4s	2m4s
app - 177.99.204.34:57464	1	4m10s	4m10s
app - 177.99.204.34:57542	1	4m10s	4m10s
app - 177.99.204.34:57579	1	3m7s	3m7s
app - 177.99.204.34:57591	1	3m7s	3m7s
app - 177.99.204.34:57687	1	5m14s	5m14s
app - 177.99.204.34:57699	1	5m13s	5m13s
app - 177.99.204.34:57770	1	6m15s	6m15s
app - 177.99.204.34:57818	1	4m10s	4m10s
app - 177.99.204.34:57825	1	5m12s	5m12s
app - 177.99.204.34:57943	1	2m4s	2m4s
app - 177.99.204.34:58004	2	6m15s	3m7s
app - 177.99.204.34:58020	2	1h38s	30m19s
app - 177.99.204.34:58034	1	3m7s	3m7s
app - 177.99.204.34:58117	1	2m4s	2m4s
app - 177.99.204.34:58119	1	6m15s	6m15s
app - 177.99.204.34:58249	1	4m9s	4m9s
app - 177.99.204.34:58273	1	2m4s	2m4s
app - 177.99.204.34:58365	1	4m10s	4m10s
app - 177.99.204.34:58474	1	2m4s	2m4s
app - 177.99.204.34:58511	1	2m4s	2m4s
app - 177.99.204.34:58516	1	5m13s	5m13s
app - 177.99.204.34:58577	1	4m43s	4m43s
app - 177.99.204.34:58626	1	5m14s	5m14s
app - 177.99.204.34:58655	1	3m7s	3m7s
app - 177.99.204.34:58670	1	2m4s	2m4s
app - 177.99.204.34:58672	1	4m10s	4m10s
app - 177.99.204.34:58674	1	3m7s	3m7s
app - 177.99.204.34:58728	1	3m7s	3m7s
app - 177.99.204.34:58736	1	4m9s	4m9s
app - 177.99.204.34:58815	2	1h2m40s	31m20s
app - 177.99.204.34:58838	1	4m10s	4m10s
app - 177.99.204.34:58903	1	4m11s	4m11s
app - 177.99.204.34:58977	1	3m7s	3m7s
app - 177.99.204.34:58978	1	4m11s	4m11s
app - 177.99.204.34:59024	1	4m10s	4m10s
app - 177.99.204.34:59062	1	6m17s	6m17s
app - 177.99.204.34:59078	1	4m10s	4m10s
app - 177.99.204.34:59108	1	4m11s	4m11s
app - 177.99.204.34:59192	1	3m8s	3m8s
app - 177.99.204.34:59244	1	3m7s	3m7s
app - 177.99.204.34:59247	1	3m7s	3m7s
app - 177.99.204.34:59363	1	3m8s	3m8s
app - 177.99.204.34:59366	1	4m11s	4m11s
app - 177.99.204.34:59455	1	5m12s	5m12s
app - 177.99.204.34:59458	1	4m11s	4m11s
app - 177.99.204.34:59465	1	5m13s	5m13s
app - 177.99.204.34:59602	1	4m10s	4m10s
app - 177.99.204.34:59664	1	3m7s	3m7s
app - 177.99.204.34:59697	1	4m11s	4m11s
app - 177.99.204.34:59730	1	3m7s	3m7s
app - 177.99.204.34:59792	1	6m17s	6m17s
app - 177.99.204.34:59813	1	3m7s	3m7s
app - 177.99.204.34:59855	1	7m19s	7m19s
app - 177.99.204.34:60012	1	7m19s	7m19s
app - 177.99.204.34:60118	1	5m12s	5m12s
app - 177.99.204.34:60209	1	6m16s	6m16s
app - 177.99.204.34:60213	1	4m9s	4m9s
app - 177.99.204.34:60258	1	5m12s	5m12s
app - 177.99.204.34:60273	3	2h4m45s	41m35s
app - 177.99.204.34:60310	1	3m7s	3m7s
app - 177.99.204.34:60312	1	3m7s	3m7s
app - 177.99.204.34:60322	1	2m4s	2m4s
app - 177.99.204.34:60344	1	5m13s	5m13s
app - 177.99.204.34:60403	2	1h1m32s	30m46s
app - 177.99.204.34:60412	1	3m7s	3m7s
app - 177.99.204.34:60435	1	4m10s	4m10s
app - 177.99.204.34:60491	1	2m4s	2m4s
app - 177.99.204.34:60508	1	3m7s	3m7s
app - 177.99.204.34:60520	1	7m19s	7m19s
app - 177.99.204.34:60629	1	1h	1h
app - 177.99.204.34:60714	1	3m7s	3m7s
app - 177.99.204.34:60756	2	1h4m43s	32m21s
app - 177.99.204.34:60778	1	6m16s	6m16s
app - 177.99.204.34:60864	1	3m8s	3m8s
app - 177.99.204.34:60894	1	2m4s	2m4s
app - 177.99.204.34:60971	1	3m7s	3m7s
app - 177.99.204.34:60996	1	4m10s	4m10s
app - 177.99.204.34:61027	1	3m7s	3m7s
app - 177.99.204.34:61054	1	3m8s	3m8s
app - 177.99.204.34:61099	1	4m11s	4m11s
app - 177.99.204.34:61210	1	7m20s	7m20s
app - 177.99.204.34:61214	1	3m7s	3m7s
app - 177.99.204.34:61229	1	3m7s	3m7s
app - 177.99.204.34:61251	1	5m13s	5m13s
app - 177.99.204.34:61337	1	2m4s	2m4s
app - 177.99.204.34:61396	1	2m4s	2m4s
app - 177.99.204.34:61498	1	3m6s	3m6s
app - 177.99.204.34:61584	1	5m13s	5m13s
app - 177.99.204.34:61606	1	6m17s	6m17s
app - 177.99.204.34:61615	1	4m10s	4m10s
app - 177.99.204.34:61782	1	4m10s	4m10s
app - 177.99.204.34:61791	1	4m10s	4m10s
app - 177.99.204.34:61866	1	3m7s	3m7s
app - 177.99.204.34:61923	1	32s363ms	32s363ms
app - 177.99.204.34:61926	1	4m10s	4m10s
app - 177.99.204.34:61993	1	6m15s	6m15s
app - 177.99.204.34:62042	1	5m12s	5m12s
app - 177.99.204.34:62093	1	3m7s	3m7s
app - 177.99.204.34:62105	1	4m10s	4m10s
app - 177.99.204.34:62107	1	2m4s	2m4s
app - 177.99.204.34:62119	1	4m10s	4m10s
app - 177.99.204.34:62146	1	3m7s	3m7s
app - 177.99.204.34:62260	1	2m4s	2m4s
app - 177.99.204.34:62300	1	5m14s	5m14s
app - 177.99.204.34:62377	1	4m9s	4m9s
app - 177.99.204.34:62382	1	5m13s	5m13s
app - 177.99.204.34:62425	1	3m7s	3m7s
app - 177.99.204.34:62460	1	4m11s	4m11s
app - 177.99.204.34:62504	1	6m16s	6m16s
app - 177.99.204.34:62529	1	2m4s	2m4s
app - 177.99.204.34:62543	1	3m7s	3m7s
app - 177.99.204.34:62572	1	5m12s	5m12s
app - 177.99.204.34:62808	1	5m12s	5m12s
app - 177.99.204.34:62924	1	2m4s	2m4s
app - 177.99.204.34:62927	1	4m10s	4m10s
app - 177.99.204.34:62948	1	4m11s	4m11s
app - 177.99.204.34:62970	1	7m18s	7m18s
app - 177.99.204.34:62979	1	3m7s	3m7s
app - 177.99.204.34:63009	1	2m4s	2m4s
app - 177.99.204.34:63020	1	3m7s	3m7s
app - 177.99.204.34:63045	1	4m10s	4m10s
app - 177.99.204.34:63146	1	3m7s	3m7s
app - 177.99.204.34:63172	1	6m15s	6m15s
app - 177.99.204.34:63205	1	4m9s	4m9s
app - 177.99.204.34:63206	1	4m10s	4m10s
app - 177.99.204.34:63232	2	1h1m33s	30m46s
app - 177.99.204.34:63319	1	2m4s	2m4s
app - 177.99.204.34:63373	1	4m10s	4m10s
app - 177.99.204.34:63460	1	2m4s	2m4s
app - 177.99.204.34:63546	2	1h36s	30m18s
app - 177.99.204.34:63558	1	2m4s	2m4s
app - 177.99.204.34:63571	1	7m18s	7m18s
app - 177.99.204.34:63632	1	2m4s	2m4s
app - 177.99.204.34:63675	1	4m11s	4m11s
app - 177.99.204.34:63727	1	2m4s	2m4s
app - 177.99.204.34:63745	2	9m23s	4m41s
app - 177.99.204.34:63816	1	3m8s	3m8s
app - 177.99.204.34:63872	1	5m13s	5m13s
app - 177.99.204.34:64032	1	3m7s	3m7s
app - 177.99.204.34:64041	1	3m7s	3m7s
app - 177.99.204.34:64046	1	3m8s	3m8s
app - 177.99.204.34:64115	1	4m10s	4m10s
app - 177.99.204.34:64137	2	1h4m50s	32m25s
app - 177.99.204.34:64142	1	5m12s	5m12s
app - 177.99.204.34:64186	1	5m13s	5m13s
app - 177.99.204.34:64205	1	2m4s	2m4s
app - 177.99.204.34:64257	1	5m13s	5m13s
app - 177.99.204.34:64333	1	2m4s	2m4s
app - 177.99.204.34:64349	1	4m10s	4m10s
app - 177.99.204.34:64352	1	4m10s	4m10s
app - 177.99.204.34:64381	1	3m8s	3m8s
app - 177.99.204.34:64453	1	3m7s	3m7s
app - 177.99.204.34:64454	1	3m7s	3m7s
app - 177.99.204.34:64587	1	4m11s	4m11s
app - 177.99.204.34:64606	1	6m16s	6m16s
app - 177.99.204.34:64627	2	1h7m23s	33m41s
app - 177.99.204.34:64640	1	4m9s	4m9s
app - 177.99.204.34:64790	1	6m16s	6m16s
app - 177.99.204.34:64793	1	7m19s	7m19s
app - 177.99.204.34:64909	1	6m16s	6m16s
app - 177.99.204.34:64924	1	2m4s	2m4s
app - 177.99.204.34:64937	1	6m15s	6m15s
app - 177.99.204.34:65007	1	5m13s	5m13s
app - 177.99.204.34:65012	1	6m16s	6m16s
app - 177.99.204.34:65099	1	3m7s	3m7s
app - 177.99.204.34:65108	1	3m7s	3m7s
app - 177.99.204.34:65123	1	3m8s	3m8s
app - 177.99.204.34:65143	1	3m7s	3m7s
app - 177.99.204.34:65276	1	3m7s	3m7s
app - 177.99.204.34:65462	1	4m10s	4m10s
app - 177.99.204.34:65483	2	1h2m44s	31m22s
app - 177.99.204.34:65488	1	4m10s	4m10s
app - 177.99.204.34:65505	1	3m8s	3m8s
app - 177.99.204.34:65522	1	3m8s	3m8s
pg_dump	6	35m54s	5m59s
postgres_fdw	1	45m1s	45m1s
psql - unix(1704846@a2tech):8963	1	1h1s	1h1s
psql - unix(1707681@a2tech):8963	1	1h1s	1h1s
psql - unix(1709177@a2tech):8963	1	1h	1h
psql - unix(1709435@a2tech):8963	1	1h	1h
psql - unix(1711505@a2tech):8963	1	1h1s	1h1s
psql - unix(1711576@a2tech):8963	1	1h1m59s	1h1m59s
psql - unix(1712325@a2tech):8963	1	1h3m9s	1h3m9s
psql - unix(1713141@a2tech):8963	1	1h3m7s	1h3m7s
psql - unix(1713587@a2tech):8963	1	1h	1h
psql - unix(1714282@a2tech):8963	1	1h	1h
psql - unix(1715371@a2tech):8963	1	1h	1h
psql - unix(1717170@a2tech):8963	1	1h	1h
psql - unix(1718162@a2tech):8963	1	1h3m7s	1h3m7s
psql - unix(1719841@a2tech):8963	1	1h11s	1h11s
psql - unix(1720690@a2tech):8963	1	1h3m10s	1h3m10s
psql - unix(1720701@a2tech):8963	1	1h1s	1h1s
psql - unix(1720928@a2tech):8963	1	1h	1h

Checkpoints Buffers

Key values

15,286 buffers Checkpoint Peak
2026-05-10 00:09:48 Date
269.560 seconds Highest write time
0.004 seconds Sync time

Checkpoints Wal files

Key values

7 files Wal files usage Peak
2026-05-10 00:09:48 Date

Checkpoints distance

Key values

227.41 Mo Distance Peak
2026-05-10 00:09:48 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
May 10	00	15,286	269.524s	0.003s	269.536s
	01	0	0s	0s	0s
	02	0	0s	0s	0s
	03	2	0.009s	0.002s	0.017s
	04	0	0s	0s	0s
	05	4,295	326.89s	0.013s	326.919s
	06	3,358	269.474s	0.002s	269.48s
	07	932	92.783s	0.005s	92.793s
	08	21	2.008s	0.003s	2.013s
	09	21	2.008s	0.002s	2.013s
	10	21	2.008s	0.002s	2.013s
	11	21	2.008s	0.002s	2.014s
	12	22	2.107s	0.002s	2.112s
	13	21	2.007s	0.003s	2.015s
	14	21	2.008s	0.002s	2.014s
	15	21	2.008s	0.002s	2.012s
	16	21	2.009s	0.002s	2.013s
	17	21	2.008s	0.002s	2.014s
	18	1,409	140.634s	0.009s	140.659s
	19	21	2.009s	0.003s	2.018s
	20	291	29.055s	0.004s	29.064s
	21	21	2.007s	0.003s	2.014s
	22	21	2.008s	0.002s	2.013s
	23	0	0s	0s	0s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
May 10	00	7	44	0.001s	0.001s
	01	0	0	0s	0s
	02	0	0	0s	0s
	03	0	3	0.001s	0.001s
	04	0	0	0s	0s
	05	2	117	0.002s	0.004s
	06	1	13	0.001s	0.001s
	07	0	16	0.002s	0.002s
	08	0	3	0.002s	0.001s
	09	0	3	0.002s	0.001s
	10	0	3	0.002s	0.001s
	11	0	3	0.002s	0.001s
	12	0	3	0.002s	0.001s
	13	0	3	0.002s	0.001s
	14	0	3	0.002s	0.001s
	15	0	3	0.002s	0.001s
	16	0	3	0.001s	0.001s
	17	0	3	0.002s	0.001s
	18	1	73	0.002s	0.005s
	19	0	3	0.003s	0.001s
	20	0	17	0.001s	0.002s
	21	0	3	0.002s	0.001s
	22	0	3	0.001s	0.001s
	23	0	0	0s	0s

Day	Hour	Avg time (sec)
May 10	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 10	00	116,435.00 kB	116,435.00 kB
	01	0.00 kB	0.00 kB
	02	0.00 kB	0.00 kB
	03	0.00 kB	52,396.00 kB
	04	0.00 kB	0.00 kB
	05	9,396.00 kB	23,580.25 kB
	06	13,310.00 kB	26,327.00 kB
	07	3,395.50 kB	23,147.50 kB
	08	161.00 kB	19,760.00 kB
	09	161.00 kB	17,800.00 kB
	10	162.00 kB	16,036.00 kB
	11	163.00 kB	14,449.00 kB
	12	164.00 kB	13,020.00 kB
	13	157.00 kB	11,734.00 kB
	14	158.00 kB	10,576.00 kB
	15	158.00 kB	9,535.00 kB
	16	159.00 kB	8,597.00 kB
	17	160.00 kB	7,753.00 kB
	18	2,666.25 kB	8,973.50 kB
	19	161.00 kB	6,876.00 kB
	20	327.50 kB	5,912.00 kB
	21	162.00 kB	5,088.00 kB
	22	163.00 kB	4,595.00 kB
	23	0.00 kB	0.00 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (28) Main checkpoint cause
29 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	28
shutdown immediate	1
Total	29

Size of temporary files

Key values

444.16 MiB Temp Files size Peak
2026-05-10 05:31:02 Date

Number of temporary files

Key values

3 per second Temp Files Peak
2026-05-10 05:31:06 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
May 10	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.13 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.90 MiB	66.24 MiB	222.08 MiB	107.86 MiB	refresh materialized view concurrently rs_mv_codigos_barra; REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; Date: 2026-05-10 05:31:08 Duration: 45s921ms Database: rio User: intelifix Remote: [local] Application: psql - unix(1707776@a2tech):8963 REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; Date: 2026-05-10 05:31:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(1707776@a2tech):8963
2	4	278.62 MiB	51.78 MiB	85.22 MiB	69.66 MiB	refresh materialized view concurrently rs_mv_equipamentos; REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; Date: 2026-05-10 05:30:22 Duration: 20s829ms Database: rio User: intelifix Remote: [local] Application: psql - unix(1707766@a2tech):8963 REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; Date: 2026-05-10 05:30:19 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(1707766@a2tech):8963

Rank

Count

Total size

Min size

Max size

Avg size

Query

1

8

862.90 MiB

66.24 MiB

222.08 MiB

107.86 MiB

refresh materialized view concurrently rs_mv_codigos_barra;

REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;

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

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

2

4

278.62 MiB

51.78 MiB

85.22 MiB

69.66 MiB

refresh materialized view concurrently rs_mv_equipamentos;

REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;

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

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

Queries generating the largest temporary files


[ Date: 2026-05-10 05:31:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707776@a2tech):8963 ]
[ Date: 2026-05-10 05:31:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707776@a2tech):8963 ]
[ Date: 2026-05-10 05:30:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707766@a2tech):8963 ]
[ Date: 2026-05-10 05:30:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707766@a2tech):8963 ]
[ Date: 2026-05-10 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707776@a2tech):8963 ]
[ Date: 2026-05-10 05:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707776@a2tech):8963 ]
[ Date: 2026-05-10 05:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707776@a2tech):8963 ]
[ Date: 2026-05-10 05:31:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707776@a2tech):8963 ]
[ Date: 2026-05-10 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707776@a2tech):8963 ]
[ Date: 2026-05-10 05:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707776@a2tech):8963 ]
[ Date: 2026-05-10 05:30:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707766@a2tech):8963 ]
[ Date: 2026-05-10 05:30:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707766@a2tech):8963 ]

Rank	Size	Query
1	222.08 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-10 05:31:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707776@a2tech):8963 ]
2	222.08 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-10 05:31:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707776@a2tech):8963 ]
3	85.22 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; [ Date: 2026-05-10 05:30:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707766@a2tech):8963 ]
4	85.22 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; [ Date: 2026-05-10 05:30:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707766@a2tech):8963 ]
5	73.36 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-10 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707776@a2tech):8963 ]
6	73.30 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-10 05:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707776@a2tech):8963 ]
7	73.29 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-10 05:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707776@a2tech):8963 ]
8	66.30 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-10 05:31:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707776@a2tech):8963 ]
9	66.25 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-10 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707776@a2tech):8963 ]
10	66.24 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA; [ Date: 2026-05-10 05:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707776@a2tech):8963 ]
11	56.40 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; [ Date: 2026-05-10 05:30:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707766@a2tech):8963 ]
12	51.78 MiB	REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS; [ Date: 2026-05-10 05:30:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1707766@a2tech):8963 ]

Vacuums / Analyzes Distribution

Key values

0.05 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio
2026-05-10 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-10 05:02:04 Date

Analyzes per table

Key values

unknown (0) Main table analyzed (database )
0 analyzes Total

Chart
Table

Analyzes per tables

NO DATASET

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

pg_catalog.pg_statistic (1) Main table vacuumed on database contagem
6 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
contagem.pg_catalog.pg_statistic	1	1	2,156	0	1	0	0	2,084	2	151,609
brasilia.pg_toast.pg_toast_2619	1	1	271	0	3	0	0	168	2	26,007
rio.pg_toast.pg_toast_2619	1	1	767	0	17	0	0	607	8	59,832
brasilia.pg_catalog.pg_statistic	1	1	2,419	0	1	0	0	2,349	2	166,422
contagem.pg_toast.pg_toast_2619	1	1	199	0	1	0	0	135	2	23,806
rio.pg_catalog.pg_statistic	1	1	2,902	0	22	0	0	2,727	17	213,662
Total	6	6	8,714	247	45	0	0	8,070	33	641,338

Tuples removed per table

Key values

pg_catalog.pg_statistic (3549) Main table with removed tuples on database rio
10286 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,549	7,688	0	0	1,279
contagem.pg_catalog.pg_statistic	1	1	3,031	7,336	0	0	922
brasilia.pg_catalog.pg_statistic	1	1	2,864	7,358	0	0	951
rio.pg_toast.pg_toast_2619	1	1	621	673	0	0	273
brasilia.pg_toast.pg_toast_2619	1	1	125	141	0	36	38
contagem.pg_toast.pg_toast_2619	1	1	96	122	0	6	48
Total	6	6	10,286	23,318	0	42	3,511

Pages removed per table

Key values

pg_toast.pg_toast_2619 (36) Main table with removed pages on database brasilia
42 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
brasilia.pg_toast.pg_toast_2619	1	1	125	36
contagem.pg_toast.pg_toast_2619	1	1	96	6
contagem.pg_catalog.pg_statistic	1	1	3031	0
rio.pg_toast.pg_toast_2619	1	1	621	0
brasilia.pg_catalog.pg_statistic	1	1	2864	0
rio.pg_catalog.pg_statistic	1	1	3549	0
Total	6	6	10,286	42

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs
May 10	00	0
	01	0
	02	0
	03	0
	04	0
	05	6
	06	0
	07	0
	08	0
	09	0
	10	0
	11	0
	12	0
	13	0
	14	0
	15	0
	16	0
	17	0
	18	0
	19	0
	20	0
	21	0
	22	0
	23	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

102 Total read queries
386 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	102	14.74%
INSERT	0	0.00%
UPDATE	0	0.00%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	386	55.78%
CTE	0	0.00%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%
OTHERS	204	29.48%

Queries by database

Key values

rio Main database
356 Requests
1h27m45s (rio)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
brasilia	Total	198	48m28s
	copy to	139	9m3s
	others	25	1m30s
	select	34	37m54s
contagem	Total	138	2m52s
	copy to	102	1m31s
	others	3	1m5s
	select	33	15s201ms
rio	Total	356	1h27m45s
	copy to	145	24m48s
	others	176	6m30s
	select	35	56m26s

Queries by user

Key values

intelifix Main user
687 Requests

Queries Chart
Table

User	Request type	Count	Duration
intelifix	Total	687	2h19m2s
	copy to	386	35m22s
	others	204	9m6s
	select	97	1h34m32s
lenon	Total	5	3s471ms
	select	5	3s471ms

Duration by user

Key values

2h19m2s (intelifix) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
intelifix	Total	687	2h19m2s
	copy to	386	35m22s
	others	204	9m6s
	select	97	1h34m32s
lenon	Total	5	3s471ms
	select	5	3s471ms

Queries by host

Key values

[local] Main host
692 Requests
2h19m5s ([local])
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
[local]	Total	692	2h19m5s
	copy to	386	35m22s
	others	204	9m6s
	select	102	1h34m36s

Queries by application

Key values

pg_dump Main application
386 Requests
35m22s (pg_dump)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
pg_dump	Total	386	35m22s
	copy to	386	35m22s
psql - unix(1703069@a2tech):8963	Total	1	1s325ms
	select	1	1s325ms
psql - unix(1703072@a2tech):8963	Total	1	299ms
	select	1	299ms
psql - unix(1703141@a2tech):8963	Total	1	2s319ms
	others	1	2s319ms
psql - unix(1703143@a2tech):8963	Total	1	4s549ms
	others	1	4s549ms
psql - unix(1703154@a2tech):8963	Total	1	243ms
	others	1	243ms
psql - unix(1703172@a2tech):8963	Total	1	3s753ms
	others	1	3s753ms
psql - unix(1703173@a2tech):8963	Total	1	4s423ms
	others	1	4s423ms
psql - unix(1703327@a2tech):8963	Total	1	1s373ms
	others	1	1s373ms
psql - unix(1703450@a2tech):8963	Total	1	1s379ms
	others	1	1s379ms
psql - unix(1703585@a2tech):8963	Total	1	1s409ms
	others	1	1s409ms
psql - unix(1703706@a2tech):8963	Total	1	1s406ms
	others	1	1s406ms
psql - unix(1703825@a2tech):8963	Total	1	1s344ms
	others	1	1s344ms
psql - unix(1703965@a2tech):8963	Total	1	1s508ms
	others	1	1s508ms
psql - unix(1704090@a2tech):8963	Total	1	1s506ms
	others	1	1s506ms
psql - unix(1704210@a2tech):8963	Total	1	1s338ms
	others	1	1s338ms
psql - unix(1704337@a2tech):8963	Total	1	1s364ms
	others	1	1s364ms
psql - unix(1704460@a2tech):8963	Total	1	1s366ms
	others	1	1s366ms
psql - unix(1704578@a2tech):8963	Total	1	1s313ms
	others	1	1s313ms
psql - unix(1704722@a2tech):8963	Total	1	1s330ms
	others	1	1s330ms
psql - unix(1704846@a2tech):8963	Total	1	1s352ms
	others	1	1s352ms
psql - unix(1704964@a2tech):8963	Total	1	1s431ms
	others	1	1s431ms
psql - unix(1705095@a2tech):8963	Total	1	1s396ms
	others	1	1s396ms
psql - unix(1705215@a2tech):8963	Total	1	1s324ms
	others	1	1s324ms
psql - unix(1705337@a2tech):8963	Total	1	1s500ms
	others	1	1s500ms
psql - unix(1705806@a2tech):8963	Total	1	156ms
	others	1	156ms
psql - unix(1705928@a2tech):8963	Total	1	1s441ms
	others	1	1s441ms
psql - unix(1706115@a2tech):8963	Total	1	1s329ms
	others	1	1s329ms
psql - unix(1706241@a2tech):8963	Total	1	1s397ms
	others	1	1s397ms
psql - unix(1706365@a2tech):8963	Total	1	1s308ms
	others	1	1s308ms
psql - unix(1706496@a2tech):8963	Total	1	1s370ms
	others	1	1s370ms
psql - unix(1706640@a2tech):8963	Total	1	1s372ms
	others	1	1s372ms
psql - unix(1706760@a2tech):8963	Total	1	1s298ms
	others	1	1s298ms
psql - unix(1706923@a2tech):8963	Total	1	1s378ms
	others	1	1s378ms
psql - unix(1707047@a2tech):8963	Total	1	1s387ms
	others	1	1s387ms
psql - unix(1707174@a2tech):8963	Total	1	1s298ms
	others	1	1s298ms
psql - unix(1707294@a2tech):8963	Total	1	1s343ms
	others	1	1s343ms
psql - unix(1707366@a2tech):8963	Total	1	1m55s
	others	1	1m55s
psql - unix(1707395@a2tech):8963	Total	1	1m20s
	others	1	1m20s
psql - unix(1707409@a2tech):8963	Total	1	59s125ms
	others	1	59s125ms
psql - unix(1707440@a2tech):8963	Total	1	1s370ms
	others	1	1s370ms
psql - unix(1707559@a2tech):8963	Total	1	1s546ms
	others	1	1s546ms
psql - unix(1707681@a2tech):8963	Total	1	1s430ms
	others	1	1s430ms
psql - unix(1707766@a2tech):8963	Total	1	20s829ms
	others	1	20s829ms
psql - unix(1707776@a2tech):8963	Total	1	45s921ms
	others	1	45s921ms
psql - unix(1707836@a2tech):8963	Total	1	1s444ms
	others	1	1s444ms
psql - unix(1707960@a2tech):8963	Total	1	1s329ms
	others	1	1s329ms
psql - unix(1708081@a2tech):8963	Total	1	1s810ms
	others	1	1s810ms
psql - unix(1708193@a2tech):8963	Total	1	1s360ms
	select	1	1s360ms
psql - unix(1708196@a2tech):8963	Total	1	288ms
	select	1	288ms
psql - unix(1708199@a2tech):8963	Total	1	197ms
	select	1	197ms
psql - unix(1708261@a2tech):8963	Total	1	1s374ms
	others	1	1s374ms
psql - unix(1708263@a2tech):8963	Total	1	2s150ms
	others	1	2s150ms
psql - unix(1708284@a2tech):8963	Total	1	1s791ms
	others	1	1s791ms
psql - unix(1708295@a2tech):8963	Total	1	2s14ms
	others	1	2s14ms
psql - unix(1708393@a2tech):8963	Total	1	1s398ms
	others	1	1s398ms
psql - unix(1708513@a2tech):8963	Total	1	1s323ms
	others	1	1s323ms
psql - unix(1708641@a2tech):8963	Total	1	1s404ms
	others	1	1s404ms
psql - unix(1708767@a2tech):8963	Total	1	1s367ms
	others	1	1s367ms
psql - unix(1708884@a2tech):8963	Total	1	1s336ms
	others	1	1s336ms
psql - unix(1709019@a2tech):8963	Total	1	3m25s
	select	1	3m25s
psql - unix(1709027@a2tech):8963	Total	1	1s526ms
	others	1	1s526ms
psql - unix(1709084@a2tech):8963	Total	1	22s252ms
	select	1	22s252ms
psql - unix(1709092@a2tech):8963	Total	1	10s17ms
	select	1	10s17ms
psql - unix(1709097@a2tech):8963	Total	1	2m15s
	select	1	2m15s
psql - unix(1709123@a2tech):8963	Total	1	819ms
	select	1	819ms
psql - unix(1709129@a2tech):8963	Total	1	453ms
	select	1	453ms
psql - unix(1709177@a2tech):8963	Total	1	1s401ms
	others	1	1s401ms
psql - unix(1709297@a2tech):8963	Total	1	1s322ms
	others	1	1s322ms
psql - unix(1709423@a2tech):8963	Total	1	1s392ms
	others	1	1s392ms
psql - unix(1709543@a2tech):8963	Total	1	1s399ms
	others	1	1s399ms
psql - unix(1709694@a2tech):8963	Total	1	1s312ms
	others	1	1s312ms
psql - unix(1709772@a2tech):8963	Total	1	585ms
	others	1	585ms
psql - unix(1709775@a2tech):8963	Total	1	231ms
	others	1	231ms
psql - unix(1709847@a2tech):8963	Total	1	3m14s
	select	1	3m14s
psql - unix(1709855@a2tech):8963	Total	1	1s353ms
	others	1	1s353ms
psql - unix(1709912@a2tech):8963	Total	1	18s137ms
	select	1	18s137ms
psql - unix(1709920@a2tech):8963	Total	1	8s226ms
	select	1	8s226ms
psql - unix(1709924@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1709951@a2tech):8963	Total	1	516ms
	select	1	516ms
psql - unix(1709954@a2tech):8963	Total	1	320ms
	select	1	320ms
psql - unix(1710005@a2tech):8963	Total	1	1s360ms
	others	1	1s360ms
psql - unix(1710079@a2tech):8963	Total	1	235ms
	others	1	235ms
psql - unix(1710083@a2tech):8963	Total	1	217ms
	others	1	217ms
psql - unix(1710138@a2tech):8963	Total	1	1s483ms
	others	1	1s483ms
psql - unix(1710262@a2tech):8963	Total	1	1s393ms
	others	1	1s393ms
psql - unix(1710342@a2tech):8963	Total	1	235ms
	others	1	235ms
psql - unix(1710400@a2tech):8963	Total	1	1s332ms
	others	1	1s332ms
psql - unix(1710516@a2tech):8963	Total	1	1s325ms
	others	1	1s325ms
psql - unix(1710588@a2tech):8963	Total	1	156ms
	others	1	156ms
psql - unix(1710664@a2tech):8963	Total	1	3m9s
	select	1	3m9s
psql - unix(1710672@a2tech):8963	Total	1	1s493ms
	others	1	1s493ms
psql - unix(1710728@a2tech):8963	Total	1	17s654ms
	select	1	17s654ms
psql - unix(1710738@a2tech):8963	Total	1	8s310ms
	select	1	8s310ms
psql - unix(1710742@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1710771@a2tech):8963	Total	1	563ms
	select	1	563ms
psql - unix(1710775@a2tech):8963	Total	1	465ms
	select	1	465ms
psql - unix(1710831@a2tech):8963	Total	1	1s345ms
	others	1	1s345ms
psql - unix(1710906@a2tech):8963	Total	1	209ms
	others	1	209ms
psql - unix(1710958@a2tech):8963	Total	1	1s343ms
	others	1	1s343ms
psql - unix(1711090@a2tech):8963	Total	1	1s412ms
	others	1	1s412ms
psql - unix(1711166@a2tech):8963	Total	1	263ms
	others	1	263ms
psql - unix(1711225@a2tech):8963	Total	1	1s380ms
	others	1	1s380ms
psql - unix(1711346@a2tech):8963	Total	1	1s380ms
	others	1	1s380ms
psql - unix(1711502@a2tech):8963	Total	1	3m8s
	select	1	3m8s
psql - unix(1711505@a2tech):8963	Total	1	1s420ms
	others	1	1s420ms
psql - unix(1711563@a2tech):8963	Total	1	17s676ms
	select	1	17s676ms
psql - unix(1711571@a2tech):8963	Total	1	8s301ms
	select	1	8s301ms
psql - unix(1711576@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1711602@a2tech):8963	Total	1	548ms
	select	1	548ms
psql - unix(1711606@a2tech):8963	Total	1	350ms
	select	1	350ms
psql - unix(1711659@a2tech):8963	Total	1	1s348ms
	others	1	1s348ms
psql - unix(1711734@a2tech):8963	Total	1	245ms
	others	1	245ms
psql - unix(1711791@a2tech):8963	Total	1	1s317ms
	others	1	1s317ms
psql - unix(1711916@a2tech):8963	Total	1	1s433ms
	others	1	1s433ms
psql - unix(1711991@a2tech):8963	Total	1	244ms
	others	1	244ms
psql - unix(1712049@a2tech):8963	Total	1	1s498ms
	others	1	1s498ms
psql - unix(1712169@a2tech):8963	Total	1	1s392ms
	others	1	1s392ms
psql - unix(1712241@a2tech):8963	Total	1	153ms
	others	1	153ms
psql - unix(1712325@a2tech):8963	Total	1	3m10s
	select	1	3m10s
psql - unix(1712328@a2tech):8963	Total	1	1s461ms
	others	1	1s461ms
psql - unix(1712385@a2tech):8963	Total	1	18s116ms
	select	1	18s116ms
psql - unix(1712393@a2tech):8963	Total	1	8s414ms
	select	1	8s414ms
psql - unix(1712397@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1712422@a2tech):8963	Total	1	567ms
	select	1	567ms
psql - unix(1712428@a2tech):8963	Total	1	349ms
	select	1	349ms
psql - unix(1712480@a2tech):8963	Total	1	1s323ms
	others	1	1s323ms
psql - unix(1712551@a2tech):8963	Total	1	247ms
	others	1	247ms
psql - unix(1712554@a2tech):8963	Total	1	234ms
	others	1	234ms
psql - unix(1712608@a2tech):8963	Total	1	1s362ms
	others	1	1s362ms
psql - unix(1712735@a2tech):8963	Total	1	1s393ms
	others	1	1s393ms
psql - unix(1712808@a2tech):8963	Total	1	237ms
	others	1	237ms
psql - unix(1712810@a2tech):8963	Total	1	207ms
	others	1	207ms
psql - unix(1712864@a2tech):8963	Total	1	1s371ms
	others	1	1s371ms
psql - unix(1712988@a2tech):8963	Total	1	1s480ms
	others	1	1s480ms
psql - unix(1713058@a2tech):8963	Total	1	153ms
	others	1	153ms
psql - unix(1713141@a2tech):8963	Total	1	3m8s
	select	1	3m8s
psql - unix(1713144@a2tech):8963	Total	1	1s418ms
	others	1	1s418ms
psql - unix(1713199@a2tech):8963	Total	1	17s840ms
	select	1	17s840ms
psql - unix(1713206@a2tech):8963	Total	1	8s205ms
	select	1	8s205ms
psql - unix(1713212@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1713238@a2tech):8963	Total	1	513ms
	select	1	513ms
psql - unix(1713241@a2tech):8963	Total	1	320ms
	select	1	320ms
psql - unix(1713328@a2tech):8963	Total	1	1s353ms
	others	1	1s353ms
psql - unix(1713401@a2tech):8963	Total	1	214ms
	others	1	214ms
psql - unix(1713460@a2tech):8963	Total	1	1s304ms
	others	1	1s304ms
psql - unix(1713587@a2tech):8963	Total	1	1s333ms
	others	1	1s333ms
psql - unix(1713662@a2tech):8963	Total	1	251ms
	others	1	251ms
psql - unix(1713665@a2tech):8963	Total	1	220ms
	others	1	220ms
psql - unix(1713720@a2tech):8963	Total	1	1s412ms
	others	1	1s412ms
psql - unix(1713839@a2tech):8963	Total	1	1s399ms
	others	1	1s399ms
psql - unix(1713909@a2tech):8963	Total	1	232ms
	others	1	232ms
psql - unix(1713984@a2tech):8963	Total	1	3m9s
	select	1	3m9s
psql - unix(1713991@a2tech):8963	Total	1	1s513ms
	others	1	1s513ms
psql - unix(1714048@a2tech):8963	Total	1	17s686ms
	select	1	17s686ms
psql - unix(1714054@a2tech):8963	Total	1	8s212ms
	select	1	8s212ms
psql - unix(1714059@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1714087@a2tech):8963	Total	1	529ms
	select	1	529ms
psql - unix(1714090@a2tech):8963	Total	1	357ms
	select	1	357ms
psql - unix(1714145@a2tech):8963	Total	1	1s343ms
	others	1	1s343ms
psql - unix(1714274@a2tech):8963	Total	1	1s335ms
	others	1	1s335ms
psql - unix(1714398@a2tech):8963	Total	1	1s337ms
	others	1	1s337ms
psql - unix(1714470@a2tech):8963	Total	1	235ms
	others	1	235ms
psql - unix(1714472@a2tech):8963	Total	1	207ms
	others	1	207ms
psql - unix(1714532@a2tech):8963	Total	1	1s340ms
	others	1	1s340ms
psql - unix(1714659@a2tech):8963	Total	1	1s324ms
	others	1	1s324ms
psql - unix(1714735@a2tech):8963	Total	1	218ms
	others	1	218ms
psql - unix(1714820@a2tech):8963	Total	1	3m13s
	select	1	3m13s
psql - unix(1714823@a2tech):8963	Total	1	1s431ms
	others	1	1s431ms
psql - unix(1714878@a2tech):8963	Total	1	18s195ms
	select	1	18s195ms
psql - unix(1714885@a2tech):8963	Total	1	8s276ms
	select	1	8s276ms
psql - unix(1714890@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1714917@a2tech):8963	Total	1	548ms
	select	1	548ms
psql - unix(1714921@a2tech):8963	Total	1	343ms
	select	1	343ms
psql - unix(1714972@a2tech):8963	Total	1	1s466ms
	others	1	1s466ms
psql - unix(1715042@a2tech):8963	Total	1	247ms
	others	1	247ms
psql - unix(1715115@a2tech):8963	Total	1	1s378ms
	others	1	1s378ms
psql - unix(1715238@a2tech):8963	Total	1	1s380ms
	others	1	1s380ms
psql - unix(1715313@a2tech):8963	Total	1	244ms
	others	1	244ms
psql - unix(1715371@a2tech):8963	Total	1	1s362ms
	others	1	1s362ms
psql - unix(1715491@a2tech):8963	Total	1	1s327ms
	others	1	1s327ms
psql - unix(1715562@a2tech):8963	Total	1	249ms
	others	1	249ms
psql - unix(1715646@a2tech):8963	Total	1	3m13s
	select	1	3m13s
psql - unix(1715654@a2tech):8963	Total	1	1s491ms
	others	1	1s491ms
psql - unix(1715707@a2tech):8963	Total	1	18s52ms
	select	1	18s52ms
psql - unix(1715713@a2tech):8963	Total	1	8s656ms
	select	1	8s656ms
psql - unix(1715720@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1715746@a2tech):8963	Total	1	559ms
	select	1	559ms
psql - unix(1715750@a2tech):8963	Total	1	357ms
	select	1	357ms
psql - unix(1715802@a2tech):8963	Total	1	1s381ms
	others	1	1s381ms
psql - unix(1715907@a2tech):8963	Total	1	231ms
	others	1	231ms
psql - unix(1715909@a2tech):8963	Total	1	201ms
	others	1	201ms
psql - unix(1715963@a2tech):8963	Total	1	1s387ms
	others	1	1s387ms
psql - unix(1716088@a2tech):8963	Total	1	1s346ms
	others	1	1s346ms
psql - unix(1716163@a2tech):8963	Total	1	242ms
	others	1	242ms
psql - unix(1716222@a2tech):8963	Total	1	1s366ms
	others	1	1s366ms
psql - unix(1716350@a2tech):8963	Total	1	1s373ms
	others	1	1s373ms
psql - unix(1716424@a2tech):8963	Total	1	251ms
	others	1	251ms
psql - unix(1716502@a2tech):8963	Total	1	3m11s
	select	1	3m11s
psql - unix(1716507@a2tech):8963	Total	1	1s438ms
	others	1	1s438ms
psql - unix(1716564@a2tech):8963	Total	1	18s17ms
	select	1	18s17ms
psql - unix(1716571@a2tech):8963	Total	1	8s304ms
	select	1	8s304ms
psql - unix(1716577@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1716603@a2tech):8963	Total	1	544ms
	select	1	544ms
psql - unix(1716607@a2tech):8963	Total	1	349ms
	select	1	349ms
psql - unix(1716659@a2tech):8963	Total	1	1s405ms
	others	1	1s405ms
psql - unix(1716729@a2tech):8963	Total	1	218ms
	others	1	218ms
psql - unix(1716731@a2tech):8963	Total	1	201ms
	others	1	201ms
psql - unix(1716787@a2tech):8963	Total	1	1s479ms
	others	1	1s479ms
psql - unix(1716916@a2tech):8963	Total	1	1s461ms
	others	1	1s461ms
psql - unix(1716992@a2tech):8963	Total	1	153ms
	others	1	153ms
psql - unix(1717051@a2tech):8963	Total	1	1s363ms
	others	1	1s363ms
psql - unix(1717170@a2tech):8963	Total	1	1s370ms
	others	1	1s370ms
psql - unix(1717243@a2tech):8963	Total	1	252ms
	others	1	252ms
psql - unix(1717326@a2tech):8963	Total	1	3m13s
	select	1	3m13s
psql - unix(1717329@a2tech):8963	Total	1	1s509ms
	others	1	1s509ms
psql - unix(1717388@a2tech):8963	Total	1	18s253ms
	select	1	18s253ms
psql - unix(1717395@a2tech):8963	Total	1	8s413ms
	select	1	8s413ms
psql - unix(1717401@a2tech):8963	Total	1	2m12s
	select	1	2m12s
psql - unix(1717426@a2tech):8963	Total	1	533ms
	select	1	533ms
psql - unix(1717430@a2tech):8963	Total	1	346ms
	select	1	346ms
psql - unix(1717483@a2tech):8963	Total	1	1s353ms
	others	1	1s353ms
psql - unix(1717553@a2tech):8963	Total	1	225ms
	others	1	225ms
psql - unix(1717555@a2tech):8963	Total	1	218ms
	others	1	218ms
psql - unix(1717621@a2tech):8963	Total	1	1s364ms
	others	1	1s364ms
psql - unix(1717749@a2tech):8963	Total	1	1s395ms
	others	1	1s395ms
psql - unix(1717825@a2tech):8963	Total	1	239ms
	others	1	239ms
psql - unix(1717883@a2tech):8963	Total	1	1s335ms
	others	1	1s335ms
psql - unix(1718004@a2tech):8963	Total	1	1s382ms
	others	1	1s382ms
psql - unix(1718078@a2tech):8963	Total	1	227ms
	select	1	227ms
psql - unix(1718079@a2tech):8963	Total	1	252ms
	others	1	252ms
psql - unix(1718162@a2tech):8963	Total	1	3m8s
	select	1	3m8s
psql - unix(1718169@a2tech):8963	Total	1	1s410ms
	others	1	1s410ms
psql - unix(1718223@a2tech):8963	Total	1	17s858ms
	select	1	17s858ms
psql - unix(1718232@a2tech):8963	Total	1	8s198ms
	select	1	8s198ms
psql - unix(1718237@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1718264@a2tech):8963	Total	1	552ms
	select	1	552ms
psql - unix(1718267@a2tech):8963	Total	1	356ms
	select	1	356ms
psql - unix(1718320@a2tech):8963	Total	1	1s364ms
	others	1	1s364ms
psql - unix(1718393@a2tech):8963	Total	1	246ms
	others	1	246ms
psql - unix(1718451@a2tech):8963	Total	1	1s343ms
	others	1	1s343ms
psql - unix(1718579@a2tech):8963	Total	1	1s358ms
	others	1	1s358ms
psql - unix(1718651@a2tech):8963	Total	1	152ms
	others	1	152ms
psql - unix(1718714@a2tech):8963	Total	1	1s439ms
	others	1	1s439ms
psql - unix(1718830@a2tech):8963	Total	1	1s329ms
	others	1	1s329ms
psql - unix(1718905@a2tech):8963	Total	1	249ms
	others	1	249ms
psql - unix(1718992@a2tech):8963	Total	1	3m15s
	select	1	3m15s
psql - unix(1718995@a2tech):8963	Total	1	1s445ms
	others	1	1s445ms
psql - unix(1719055@a2tech):8963	Total	1	18s52ms
	select	1	18s52ms
psql - unix(1719062@a2tech):8963	Total	1	8s285ms
	select	1	8s285ms
psql - unix(1719067@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1719099@a2tech):8963	Total	1	547ms
	select	1	547ms
psql - unix(1719103@a2tech):8963	Total	1	345ms
	select	1	345ms
psql - unix(1719155@a2tech):8963	Total	1	1s389ms
	others	1	1s389ms
psql - unix(1719224@a2tech):8963	Total	1	232ms
	others	1	232ms
psql - unix(1719229@a2tech):8963	Total	1	241ms
	others	1	241ms
psql - unix(1719286@a2tech):8963	Total	1	1s416ms
	others	1	1s416ms
psql - unix(1719410@a2tech):8963	Total	1	1s428ms
	others	1	1s428ms
psql - unix(1719489@a2tech):8963	Total	1	248ms
	others	1	248ms
psql - unix(1719551@a2tech):8963	Total	1	1s333ms
	others	1	1s333ms
psql - unix(1719672@a2tech):8963	Total	1	1s340ms
	others	1	1s340ms
psql - unix(1719737@a2tech):8963	Total	1	165ms
	others	1	165ms
psql - unix(1719841@a2tech):8963	Total	1	3m20s
	select	1	3m20s
psql - unix(1719846@a2tech):8963	Total	1	2s294ms
	others	1	2s294ms
psql - unix(1719944@a2tech):8963	Total	1	21s745ms
	select	1	21s745ms
psql - unix(1719951@a2tech):8963	Total	1	8s999ms
	select	1	8s999ms
psql - unix(1719956@a2tech):8963	Total	1	2m14s
	select	1	2m14s
psql - unix(1719982@a2tech):8963	Total	1	725ms
	select	1	725ms
psql - unix(1719987@a2tech):8963	Total	1	454ms
	select	1	454ms
psql - unix(1720037@a2tech):8963	Total	1	1s814ms
	others	1	1s814ms
psql - unix(1720110@a2tech):8963	Total	1	245ms
	others	1	245ms
psql - unix(1720112@a2tech):8963	Total	1	239ms
	others	1	239ms
psql - unix(1720168@a2tech):8963	Total	1	1s339ms
	others	1	1s339ms
psql - unix(1720293@a2tech):8963	Total	1	1s437ms
	others	1	1s437ms
psql - unix(1720366@a2tech):8963	Total	1	246ms
	others	1	246ms
psql - unix(1720368@a2tech):8963	Total	1	222ms
	others	1	222ms
psql - unix(1720428@a2tech):8963	Total	1	1s329ms
	others	1	1s329ms
psql - unix(1720546@a2tech):8963	Total	1	1s332ms
	others	1	1s332ms
psql - unix(1720690@a2tech):8963	Total	1	3m11s
	select	1	3m11s
psql - unix(1720701@a2tech):8963	Total	1	1s409ms
	others	1	1s409ms
psql - unix(1720757@a2tech):8963	Total	1	18s667ms
	select	1	18s667ms
psql - unix(1720766@a2tech):8963	Total	1	8s250ms
	select	1	8s250ms
psql - unix(1720770@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1720796@a2tech):8963	Total	1	521ms
	select	1	521ms
psql - unix(1720799@a2tech):8963	Total	1	325ms
	select	1	325ms
psql - unix(1720850@a2tech):8963	Total	1	1s422ms
	others	1	1s422ms
psql - unix(1720924@a2tech):8963	Total	1	241ms
	others	1	241ms
psql - unix(1720989@a2tech):8963	Total	1	1s513ms
	others	1	1s513ms
psql - unix(1721119@a2tech):8963	Total	1	1s361ms
	others	1	1s361ms
psql - unix(1721204@a2tech):8963	Total	1	214ms
	others	1	214ms
psql - unix(1721261@a2tech):8963	Total	1	1s397ms
	others	1	1s397ms
psql - unix(1721378@a2tech):8963	Total	1	1s409ms
	others	1	1s409ms
psql - unix(1721546@a2tech):8963	Total	1	3m13s
	select	1	3m13s
psql - unix(1721556@a2tech):8963	Total	1	1s405ms
	others	1	1s405ms
psql - unix(1721708@a2tech):8963	Total	1	18s98ms
	select	1	18s98ms
psql - unix(1721715@a2tech):8963	Total	1	8s299ms
	select	1	8s299ms
psql - unix(1721719@a2tech):8963	Total	1	2m13s
	select	1	2m13s
psql - unix(1721748@a2tech):8963	Total	1	545ms
	select	1	545ms
psql - unix(1721751@a2tech):8963	Total	1	371ms
	select	1	371ms
psql - unix(1721802@a2tech):8963	Total	1	1s389ms
	others	1	1s389ms
psql - unix(1721870@a2tech):8963	Total	1	250ms
	others	1	250ms
psql - unix(1721931@a2tech):8963	Total	1	1s472ms
	others	1	1s472ms
psql - unix(1722058@a2tech):8963	Total	1	1s348ms
	others	1	1s348ms
psql - unix(1722135@a2tech):8963	Total	1	156ms
	others	1	156ms
psql - unix(1722137@a2tech):8963	Total	1	245ms
	others	1	245ms
psql - unix(1722201@a2tech):8963	Total	1	1s347ms
	others	1	1s347ms
psql - unix(1722321@a2tech):8963	Total	1	1s319ms
	others	1	1s319ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-05-10 23:16:27 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

388 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	175	25.29%
500-1000ms	41	5.92%
1000-10000ms	388	56.07%
> 10000ms	88	12.72%

Slowest individual queries


[ Date: 2026-05-10 07:08:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1709019@a2tech):8963 ]
[ Date: 2026-05-10 20:08:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1719841@a2tech):8963 ]
[ Date: 2026-05-10 19:08:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1718992@a2tech):8963 ]
[ Date: 2026-05-10 08:08:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1709847@a2tech):8963 ]
[ Date: 2026-05-10 17:08:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1717326@a2tech):8963 ]
[ Date: 2026-05-10 22:08:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1721546@a2tech):8963 ]
[ Date: 2026-05-10 15:08:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1715646@a2tech):8963 ]
[ Date: 2026-05-10 14:08:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1714820@a2tech):8963 ]
[ Date: 2026-05-10 16:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1716502@a2tech):8963 ]
[ Date: 2026-05-10 21:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1720690@a2tech):8963 ]
[ Date: 2026-05-10 11:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1712325@a2tech):8963 ]
[ Date: 2026-05-10 13:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1713984@a2tech):8963 ]
[ Date: 2026-05-10 09:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1710664@a2tech):8963 ]
[ Date: 2026-05-10 10:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1711502@a2tech):8963 ]
[ Date: 2026-05-10 12:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1713141@a2tech):8963 ]
[ Date: 2026-05-10 18:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1718162@a2tech):8963 ]
[ Date: 2026-05-10 07:11:17 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(1709097@a2tech):8963 ]
[ Date: 2026-05-10 20:11:10 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(1719956@a2tech):8963 ]
[ Date: 2026-05-10 10:10:52 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(1711576@a2tech):8963 ]
[ Date: 2026-05-10 16:10:55 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(1716577@a2tech):8963 ]

Rank	Duration	Query
1	3m25s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-10 07:08:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1709019@a2tech):8963 ]
2	3m20s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-10 20:08:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1719841@a2tech):8963 ]
3	3m15s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-10 19:08:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1718992@a2tech):8963 ]
4	3m14s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-10 08:08:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1709847@a2tech):8963 ]
5	3m13s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-10 17:08:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1717326@a2tech):8963 ]
6	3m13s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-10 22:08:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1721546@a2tech):8963 ]
7	3m13s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-10 15:08:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1715646@a2tech):8963 ]
8	3m13s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-10 14:08:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1714820@a2tech):8963 ]
9	3m11s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-10 16:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1716502@a2tech):8963 ]
10	3m11s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-10 21:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1720690@a2tech):8963 ]
11	3m10s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-10 11:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1712325@a2tech):8963 ]
12	3m9s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-10 13:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1713984@a2tech):8963 ]
13	3m9s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-10 09:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1710664@a2tech):8963 ]
14	3m8s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-10 10:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1711502@a2tech):8963 ]
15	3m8s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-10 12:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1713141@a2tech):8963 ]
16	3m8s	SELECT * FROM RS_SMART_FISCAL_ENTRADA (); [ Date: 2026-05-10 18:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(1718162@a2tech):8963 ]
17	2m15s	SELECT * FROM RS_SMART_FISCAL_SAIDA (); [ Date: 2026-05-10 07:11:17 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(1709097@a2tech):8963 ]
18	2m14s	SELECT * FROM RS_SMART_FISCAL_SAIDA (); [ Date: 2026-05-10 20:11:10 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(1719956@a2tech):8963 ]
19	2m13s	SELECT * FROM RS_SMART_FISCAL_SAIDA (); [ Date: 2026-05-10 10:10:52 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(1711576@a2tech):8963 ]
20	2m13s	SELECT * FROM RS_SMART_FISCAL_SAIDA (); [ Date: 2026-05-10 16:10:55 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(1716577@a2tech):8963 ]

Time consuming queries (N)


[ User: intelifix - Total duration: 53m52s - Times executed: 48 ]
[ User: intelifix - Total duration: 40m40s - Times executed: 48 ]
[ User: intelifix - Total duration: 4m15s - Times executed: 3 ]
[ User: intelifix - Total duration: 3m13s - Times executed: 139 ]
[ User: intelifix - Total duration: 1m43s - Times executed: 4 ]
[ User: intelifix - Total duration: 1m36s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m24s - Times executed: 4 ]
[ User: intelifix - Total duration: 1m19s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m14s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ User: intelifix - Total duration: 57s552ms - Times executed: 6 ]
[ User: intelifix - Total duration: 57s138ms - Times executed: 6 ]
[ User: intelifix - Total duration: 47s298ms - Times executed: 6 ]
[ User: intelifix - Total duration: 47s47ms - Times executed: 6 ]
[ User: intelifix - Total duration: 45s921ms - Times executed: 1 ]
[ User: intelifix - Total duration: 41s512ms - Times executed: 6 ]
[ User: intelifix - Total duration: 36s905ms - Times executed: 4 ]
[ User: intelifix - Total duration: 35s295ms - Times executed: 6 ]
[ User: intelifix - Total duration: 31s354ms - Times executed: 3 ]
[ User: intelifix - Total duration: 27s68ms - Times executed: 6 ]

Most frequent queries (N)


[ User: intelifix - Total duration: 3m13s - Times executed: 139 ]
[ User: intelifix - Total duration: 53m52s - Times executed: 48 ]
[ User: intelifix - Total duration: 40m40s - Times executed: 48 ]
[ User: intelifix - Total duration: 6s375ms - Times executed: 29 ]
[ User: intelifix - Total duration: 5s837ms - Times executed: 24 ]
[ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ User: intelifix - Total duration: 57s552ms - Times executed: 6 ]
[ User: intelifix - Total duration: 57s138ms - Times executed: 6 ]
[ User: intelifix - Total duration: 47s298ms - Times executed: 6 ]
[ User: intelifix - Total duration: 47s47ms - Times executed: 6 ]
[ User: intelifix - Total duration: 41s512ms - Times executed: 6 ]
[ User: intelifix - Total duration: 35s295ms - Times executed: 6 ]
[ User: intelifix - Total duration: 27s68ms - Times executed: 6 ]
[ User: intelifix - Total duration: 19s496ms - Times executed: 6 ]
[ User: intelifix - Total duration: 18s701ms - Times executed: 6 ]
[ User: intelifix - Total duration: 18s682ms - Times executed: 6 ]
[ User: intelifix - Total duration: 17s489ms - Times executed: 6 ]
[ User: intelifix - Total duration: 12s234ms - Times executed: 6 ]
[ User: intelifix - Total duration: 8s883ms - Times executed: 6 ]
[ User: intelifix - Total duration: 5s361ms - Times executed: 6 ]

Normalized slowest queries (N)


[ User: intelifix - Total duration: 4m15s - Times executed: 3 ]
[ User: intelifix - Total duration: 53m52s - Times executed: 48 ]
[ User: intelifix - Total duration: 40m40s - Times executed: 48 ]
[ User: intelifix - Total duration: 45s921ms - Times executed: 1 ]
[ User: intelifix - Total duration: 1m36s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m19s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m43s - Times executed: 4 ]
[ User: intelifix - Total duration: 1m14s - Times executed: 3 ]
[ User: intelifix - Total duration: 1m24s - Times executed: 4 ]
[ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ User: intelifix - Total duration: 31s354ms - Times executed: 3 ]
[ User: intelifix - Total duration: 57s552ms - Times executed: 6 ]
[ User: intelifix - Total duration: 57s138ms - Times executed: 6 ]
[ User: intelifix - Total duration: 36s905ms - Times executed: 4 ]
[ User: intelifix - Total duration: 47s298ms - Times executed: 6 ]
[ User: intelifix - Total duration: 47s47ms - Times executed: 6 ]
[ User: intelifix - Total duration: 41s512ms - Times executed: 6 ]
[ User: intelifix - Total duration: 35s295ms - Times executed: 6 ]
[ User: intelifix - Total duration: 27s68ms - Times executed: 6 ]
[ User: intelifix - Total duration: 19s496ms - 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

8

Details

0ms

;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
May 10	08	1	0ms	0ms
	11	1	0ms	0ms
	12	1	0ms	0ms
	14	1	0ms	0ms
	15	1	0ms	0ms
	16	1	0ms	0ms
	17	1	0ms	0ms
	18	1	0ms	0ms

[ User: intelifix - Total duration: 3m40s - Times executed: 8 ]

[ Application: psql - unix(1717326@a2tech):8963 - Total duration: 3m13s - Times executed: 1 ]

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

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

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

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

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

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

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

;

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

Log levels

Key values

4,981 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	12	0.24%
ERROR	1,034	20.76%
EVENTLOG	2	0.04%
FATAL	14	0.28%
LOG	2,873	57.68%
STATEMENT	1,046	21.00%

Events distribution (except queries)

Key values

0 PANIC entries
14 FATAL entries
1034 ERROR entries
0 WARNING entries
2 EVENTLOG entries

Most Frequent Errors/Events

Key values

1,030 Max number of times the same event was reported
1,050 Total events found

Rank

Times reported

Error

1

1,030

Details

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

Times Reported Most Frequent Error / Event #1

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

ERROR: prepared statement "_PLAN000000004FAB23F0" does not exist
ERROR: prepared statement "_PLAN000000004FAB4870" does not exist
ERROR: prepared statement "_PLAN000000004FAAED30" does not exist

2

7

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
May 10	03	7

3

5

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
May 10	00	1
	03	1
	06	1
	15	1
	17	1

4

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
May 10	05	4

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

5

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
May 10	03	1

6

1

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
May 10	14	1

7

1

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
May 10	14	1

8

1

Details

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

Times Reported Most Frequent Error / Event #8

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

Analyzes per tables

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