pgBadger-
Global information
- Generated on Fri May 15 23:50:23 2026
- Log file: /usr/local/pgsql/data/log/serverlog-04.log, ..., /usr/local/pgsql/data/log/serverlog-26.log
- Parsed 233 log entries in 22s
- Log start from 2026-05-13 10:48:01 to 2026-05-13 18:51:14
-
Overview
Global Stats
- 4 Number of unique normalized queries
- 10 Number of queries
- 1m39s Total query duration
- 2026-05-13 10:48:12 First query
- 2026-05-13 11:04:32 Last query
- 2 queries/s at 2026-05-13 10:48:12 Query peak
- 1m39s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1m39s Execute total duration
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 6 Total number of automatic vacuums
- 6 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 16 Total number of sessions
- 10 sessions at 2026-05-13 17:50:22 Session peak
- 6h11m18s Total duration of sessions
- 23m12s Average duration of sessions
- 0 Average queries per session
- 6s238ms Average queries duration per session
- 23m6s Average idle time per session
- 16 Total number of connections
- 2 connections/s at 2026-05-13 10:48:11 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2026-05-13 10:48:12 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-05-13 10:48:12 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-05-13 11:03:53 Date
Queries duration
Key values
- 1m39s 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
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 13 10 4 0ms 40s989ms 12s849ms 42s424ms 42s424ms 42s424ms 11 6 0ms 10s275ms 8s69ms 19s746ms 19s746ms 19s746ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 13 10 2 0 717ms 0ms 1s435ms 1s435ms 11 1 0 1s781ms 0ms 1s781ms 1s781ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 13 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 13 10 0 1 1.00 0.00% 11 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% Day Hour Count Average / Second May 13 10 4 0.00/s 11 0 0.00/s 17 12 0.00/s 18 0 0.00/s Day Hour Count Average Duration Average idle time May 13 10 0 0ms 0ms 11 4 1h1m27s 1h1m15s 17 10 15s292ms 15s292ms 18 2 1h1m27s 1h1m27s -
Connections
Established Connections
Key values
- 2 connections Connection Peak
- 2026-05-13 10:48:11 Date
Connections per database
Key values
- rio Main Database
- 16 connections Total
Connections per user
Key values
- lenon Main User
- 16 connections Total
-
Sessions
Simultaneous sessions
Key values
- 10 sessions Session Peak
- 2026-05-13 17:50:22 Date
Histogram of session times
Key values
- 6 1000-30000ms duration
Sessions per database
Key values
- rio Main Database
- 16 sessions Total
Sessions per user
Key values
- lenon Main User
- 16 sessions Total
Sessions per host
Key values
- 172.20.0.3 Main Host
- 16 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 16 sessions Total
Application Count Total Duration Average Duration [unknown] 6 6h8m45s 1h1m27s pgAdmin 4 - CONN:4698698 1 22s84ms 22s84ms pgAdmin 4 - CONN:5792648 4 5s60ms 1s265ms pgAdmin 4 - CONN:7113132 1 12s314ms 12s314ms pgAdmin 4 - DB:brasilia 1 26s303ms 26s303ms pgAdmin 4 - DB:contagem 1 17s276ms 17s276ms pgAdmin 4 - DB:postgres 1 41s368ms 41s368ms pgAdmin 4 - DB:rio 1 28s517ms 28s517ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 1,499 buffers Checkpoint Peak
- 2026-05-13 10:51:52 Date
- 150.480 seconds Highest write time
- 0.005 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-05-13 17:54:37 Date
Checkpoints distance
Key values
- 92.48 Mo Distance Peak
- 2026-05-13 11:04:30 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 13 10 2,995 300.329s 0.006s 300.348s 11 1,548 154.884s 0.006s 154.917s 17 94 9.473s 0.007s 9.488s 18 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 13 10 0 1 0 75 0.002s 0.002s 11 0 4 0 70 0.002s 0.002s 17 0 0 0 37 0.002s 0.003s 18 0 0 0 0 0s 0s Day Hour Count Avg time (sec) May 13 10 0 0s 11 0 0s 17 0 0s 18 0 0s Day Hour Mean distance Mean estimate May 13 10 11,908.50 kB 11,908.50 kB 11 29,576.00 kB 45,572.50 kB 17 155.00 kB 37,460.50 kB 18 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 13 10 0 0 0 11 0 0 0 17 0 0 0 18 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.04 sec Highest CPU-cost vacuum
Table public.temp0000277702
Database rio - 2026-05-13 10:49:04 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.04 sec Highest CPU-cost vacuum
Table public.temp0000277702
Database rio - 2026-05-13 10:49:04 Date
Analyzes per table
Key values
- public.temp0000277702 (6) Main table analyzed (database rio)
- 6 analyzes Total
Vacuums per table
Key values
- public.temp0000277702 (6) Main table vacuumed on database rio
- 6 vacuums Total
Vacuum throughput per table
Key values
- public.temp0000277702 (0.24) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 13 10 2 2 11 4 4 17 0 0 18 0 0 - 0.04 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
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
Queries by type
Key values
- 3 Total read queries
- 7 Total write queries
Queries by database
Key values
- rio Main database
- 10 Requests
- 1m39s (rio)
- Main time consuming database
Queries by user
Key values
- lenon Main user
- 838 Requests
User Request type Count Duration intelifix Total 25 2m16s ddl 13 2m8s select 12 8s115ms lenon Total 838 36m50s copy from 139 12m59s ddl 680 22m39s others 7 1m4s select 12 5s709ms Duration by user
Key values
- 36m50s (lenon) Main time consuming user
User Request type Count Duration intelifix Total 25 2m16s ddl 13 2m8s select 12 8s115ms lenon Total 838 36m50s copy from 139 12m59s ddl 680 22m39s others 7 1m4s select 12 5s709ms Queries by host
Key values
- [local] Main host
- 854 Requests
- 38m48s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 10 Requests
- 1m39s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-13 17:48:13 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 6 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 40s989ms CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);[ Date: 2026-05-13 10:48:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 10s275ms CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);[ Date: 2026-05-13 11:01:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 9s806ms CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);[ Date: 2026-05-13 11:04:32 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 9s470ms CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);[ Date: 2026-05-13 11:01:00 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 8s973ms CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);[ Date: 2026-05-13 10:52:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 8s693ms CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);[ Date: 2026-05-13 11:03:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 8s390ms CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);[ Date: 2026-05-13 11:00:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 1s781ms SELECT * FROM RS_NF_ENTRADA_REGISTRO ('/var/www/html/uploads/TESTE1305.xlsx', 080, 02, 06); / pg_procs / temp / tmp_0000025816.run : line 3: psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : No such file or directory / pg_procs / temp / tmp_0000025816.run : line 8: psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : No such file or directory / pg_procs / temp / tmp_0000025816.run : line 13: psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : No such file or directory;[ Date: 2026-05-13 11:00:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 811ms SELECT * FROM RS_MENU (80, 1);[ Date: 2026-05-13 10:48:12 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 624ms SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;[ Date: 2026-05-13 10:48:12 - Database: rio - User: lenon - Remote: [local] - Application: [unknown] - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1m36s 7 8s390ms 40s989ms 13s800ms create table temp0000277702 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 13 10 2 49s963ms 24s981ms 11 5 46s636ms 9s327ms [ User: intelifix - Total duration: 1m36s - Times executed: 7 ]
[ Application: [unknown] - Total duration: 1m36s - Times executed: 7 ]
-
CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-13 10:48:58 Duration: 40s989ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-13 11:01:41 Duration: 10s275ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-13 11:04:32 Duration: 9s806ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
2 1s781ms 1 1s781ms 1s781ms 1s781ms select * from rs_nf_entrada_registro (?, ?, ?, ?); / pg_procs / temp / tmp_0000025816.run : line ? : psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : no such file or directory / pg_procs / temp / tmp_0000025816.run : line ? : psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : no such file or directory / pg_procs / temp / tmp_0000025816.run : line ? : psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : no such file or directory;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 13 11 1 1s781ms 1s781ms [ User: intelifix - Total duration: 1s781ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 1s781ms - Times executed: 1 ]
-
SELECT * FROM RS_NF_ENTRADA_REGISTRO ('/var/www/html/uploads/TESTE1305.xlsx', 080, 02, 06); / pg_procs / temp / tmp_0000025816.run : line 3: psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : No such file or directory / pg_procs / temp / tmp_0000025816.run : line 8: psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : No such file or directory / pg_procs / temp / tmp_0000025816.run : line 13: psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : No such file or directory;
Date: 2026-05-13 11:00:51 Duration: 1s781ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
3 811ms 1 811ms 811ms 811ms select * from rs_menu (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 13 10 1 811ms 811ms [ User: intelifix - Total duration: 811ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 811ms - Times executed: 1 ]
-
SELECT * FROM RS_MENU (80, 1);
Date: 2026-05-13 10:48:12 Duration: 811ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
4 624ms 1 624ms 624ms 624ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 13 10 1 624ms 624ms [ User: lenon - Total duration: 624ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 624ms - Times executed: 1 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-05-13 10:48:12 Duration: 624ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-13.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 7 1m36s 8s390ms 40s989ms 13s800ms create table temp0000277702 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 13 10 2 49s963ms 24s981ms 11 5 46s636ms 9s327ms [ User: intelifix - Total duration: 1m36s - Times executed: 7 ]
[ Application: [unknown] - Total duration: 1m36s - Times executed: 7 ]
-
CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-13 10:48:58 Duration: 40s989ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-13 11:01:41 Duration: 10s275ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-13 11:04:32 Duration: 9s806ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
2 1 1s781ms 1s781ms 1s781ms 1s781ms select * from rs_nf_entrada_registro (?, ?, ?, ?); / pg_procs / temp / tmp_0000025816.run : line ? : psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : no such file or directory / pg_procs / temp / tmp_0000025816.run : line ? : psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : no such file or directory / pg_procs / temp / tmp_0000025816.run : line ? : psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : no such file or directory;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 13 11 1 1s781ms 1s781ms [ User: intelifix - Total duration: 1s781ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 1s781ms - Times executed: 1 ]
-
SELECT * FROM RS_NF_ENTRADA_REGISTRO ('/var/www/html/uploads/TESTE1305.xlsx', 080, 02, 06); / pg_procs / temp / tmp_0000025816.run : line 3: psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : No such file or directory / pg_procs / temp / tmp_0000025816.run : line 8: psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : No such file or directory / pg_procs / temp / tmp_0000025816.run : line 13: psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : No such file or directory;
Date: 2026-05-13 11:00:51 Duration: 1s781ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
3 1 811ms 811ms 811ms 811ms select * from rs_menu (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 13 10 1 811ms 811ms [ User: intelifix - Total duration: 811ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 811ms - Times executed: 1 ]
-
SELECT * FROM RS_MENU (80, 1);
Date: 2026-05-13 10:48:12 Duration: 811ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
4 1 624ms 624ms 624ms 624ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 13 10 1 624ms 624ms [ User: lenon - Total duration: 624ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 624ms - Times executed: 1 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-05-13 10:48:12 Duration: 624ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-13.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 8s390ms 40s989ms 13s800ms 7 1m36s create table temp0000277702 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 13 10 2 49s963ms 24s981ms 11 5 46s636ms 9s327ms [ User: intelifix - Total duration: 1m36s - Times executed: 7 ]
[ Application: [unknown] - Total duration: 1m36s - Times executed: 7 ]
-
CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-13 10:48:58 Duration: 40s989ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-13 11:01:41 Duration: 10s275ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-13 11:04:32 Duration: 9s806ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
2 1s781ms 1s781ms 1s781ms 1 1s781ms select * from rs_nf_entrada_registro (?, ?, ?, ?); / pg_procs / temp / tmp_0000025816.run : line ? : psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : no such file or directory / pg_procs / temp / tmp_0000025816.run : line ? : psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : no such file or directory / pg_procs / temp / tmp_0000025816.run : line ? : psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : no such file or directory;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 13 11 1 1s781ms 1s781ms [ User: intelifix - Total duration: 1s781ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 1s781ms - Times executed: 1 ]
-
SELECT * FROM RS_NF_ENTRADA_REGISTRO ('/var/www/html/uploads/TESTE1305.xlsx', 080, 02, 06); / pg_procs / temp / tmp_0000025816.run : line 3: psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : No such file or directory / pg_procs / temp / tmp_0000025816.run : line 8: psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : No such file or directory / pg_procs / temp / tmp_0000025816.run : line 13: psql: command not found cat: / pg_procs / temp / tmp_0000025816.out : No such file or directory;
Date: 2026-05-13 11:00:51 Duration: 1s781ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
3 811ms 811ms 811ms 1 811ms select * from rs_menu (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 13 10 1 811ms 811ms [ User: intelifix - Total duration: 811ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 811ms - Times executed: 1 ]
-
SELECT * FROM RS_MENU (80, 1);
Date: 2026-05-13 10:48:12 Duration: 811ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
4 624ms 624ms 624ms 1 624ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 13 10 1 624ms 624ms [ User: lenon - Total duration: 624ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 624ms - Times executed: 1 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-05-13 10:48:12 Duration: 624ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-13.log
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 NO DATASET
-
Events
Log levels
Key values
- 99 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Events per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET