pgBadger-
Global information
- Generated on Mon May 25 23:50:14 2026
- Log file: /usr/local/pgsql/data/log/serverlog-04.log, ..., /usr/local/pgsql/data/log/serverlog-26.log
- Parsed 4,498 log entries in 13s
- Log start from 2026-05-25 00:02:02 to 2026-05-25 23:46:24
-
Overview
Global Stats
- 173 Number of unique normalized queries
- 881 Number of queries
- 4h50m41s Total query duration
- 2026-05-25 00:02:12 First query
- 2026-05-25 23:46:24 Last query
- 5 queries/s at 2026-05-25 23:46:14 Query peak
- 4h50m41s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h50m41s Execute total duration
- 116 Number of events
- 10 Number of unique normalized events
- 41 Max number of times the same event was reported
- 0 Number of cancellation
- 27 Total number of automatic vacuums
- 21 Total number of automatic analyzes
- 10 Number temporary file
- 224.91 MiB Max size of temporary file
- 104.63 MiB Average size of temporary file
- 165 Total number of sessions
- 9 sessions at 2026-05-25 09:00:29 Session peak
- 6d7h2m45s Total duration of sessions
- 54m55s Average duration of sessions
- 5 Average queries per session
- 1m45s Average queries duration per session
- 53m9s Average idle time per session
- 180 Total number of connections
- 3 connections/s at 2026-05-25 07:05:43 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-05-25 23:46:14 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-05-25 06:43:14 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-05-25 23:46:14 Date
Queries duration
Key values
- 4h50m41s 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 25 00 14 0ms 21s881ms 8s44ms 19s176ms 1m1s 1m1s 01 6 0ms 4s78ms 3s519ms 4s78ms 4s78ms 4s78ms 02 6 2s366ms 3s338ms 2s829ms 3s338ms 3s338ms 3s338ms 03 5 0ms 3s121ms 2s654ms 2s727ms 3s121ms 3s121ms 04 6 0ms 2s892ms 2s629ms 2s892ms 2s892ms 2s892ms 05 11 0ms 8m36s 1m41s 5m10s 8m36s 8m36s 06 25 0ms 11s554ms 2s624ms 8s989ms 33s787ms 33s787ms 07 103 0ms 12m53s 23s434ms 3m49s 4m37s 12m53s 08 30 0ms 12m39s 44s820ms 46s998ms 4m29s 12m39s 09 27 0ms 6m38s 27s752ms 53s771ms 3m50s 6m38s 10 18 0ms 6m46s 39s257ms 3m43s 6m46s 6m46s 11 19 0ms 6m36s 37s331ms 3m58s 6m36s 6m36s 12 18 0ms 6m36s 38s302ms 3m38s 6m36s 6m36s 13 18 553ms 6m38s 40s446ms 4m15s 6m38s 6m38s 14 18 0ms 6m47s 38s399ms 3m33s 6m47s 6m47s 15 18 513ms 6m10s 36s306ms 3m35s 6m44s 6m44s 16 18 0ms 6m15s 36s846ms 3m41s 6m48s 6m48s 17 18 0ms 6m38s 37s911ms 3m33s 6m38s 6m38s 18 19 0ms 6m28s 35s606ms 3m37s 6m28s 6m28s 19 18 499ms 6m18s 36s97ms 3m25s 6m51s 6m51s 20 98 0ms 7m25s 12s542ms 1m27s 3m31s 7m25s 21 20 0ms 6m16s 32s810ms 3m32s 6m49s 6m49s 22 18 511ms 6m14s 36s991ms 3m44s 6m47s 6m47s 23 330 0ms 1m11s 6s580ms 1m11s 1m25s 1m42s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 25 00 3 0 4s304ms 0ms 0ms 12s912ms 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 14 0 1s49ms 1s419ms 1s545ms 8s989ms 07 75 0 28s833ms 13s618ms 3m39s 12m53s 08 12 0 1m44s 1s178ms 33s96ms 12m39s 09 8 0 1m28s 0ms 53s771ms 6m38s 10 6 0 1m53s 50s589ms 3m43s 6m46s 11 6 0 1m54s 50s935ms 3m58s 6m36s 12 6 0 1m51s 50s632ms 3m38s 6m36s 13 6 0 1m57s 51s938ms 4m15s 6m38s 14 6 0 1m51s 49s385ms 3m33s 6m47s 15 6 0 1m45s 16s360ms 3m33s 6m44s 16 6 0 1m47s 16s580ms 3m38s 6m48s 17 6 0 1m50s 50s779ms 3m33s 6m38s 18 7 0 1m34s 52s669ms 3m35s 6m28s 19 6 0 1m45s 15s971ms 3m23s 6m51s 20 8 76 14s282ms 1m7s 1m25s 7m25s 21 8 0 1m19s 16s516ms 3m30s 6m49s 22 6 0 1m47s 16s595ms 3m41s 6m47s 23 4 326 6s580ms 1m4s 1m11s 1m42s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 25 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 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 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 25 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 2 2.00 0.00% 07 0 7 7.00 0.00% 08 0 1 1.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second May 25 00 17 0.00/s 01 6 0.00/s 02 4 0.00/s 03 10 0.00/s 04 5 0.00/s 05 7 0.00/s 06 13 0.00/s 07 13 0.00/s 08 13 0.00/s 09 11 0.00/s 10 4 0.00/s 11 6 0.00/s 12 5 0.00/s 13 6 0.00/s 14 4 0.00/s 15 5 0.00/s 16 6 0.00/s 17 5 0.00/s 18 6 0.00/s 19 6 0.00/s 20 9 0.00/s 21 5 0.00/s 22 5 0.00/s 23 9 0.00/s Day Hour Count Average Duration Average idle time May 25 00 4 49m44s 49m16s 01 10 1h57s 1h55s 02 5 1h 59m56s 03 7 29m18s 29m16s 04 5 1h36s 1h33s 05 5 1h12s 56m29s 06 6 55m53s 55m42s 07 12 56m57s 53m36s 08 13 55m14s 53m31s 09 13 38m3s 37m5s 10 9 1h26m36s 1h25m18s 11 6 1h4m3s 1h2m5s 12 5 54m 51m42s 13 5 1h1m20s 58m54s 14 6 1h31s 58m36s 15 4 1h2m21s 59m37s 16 5 1h1m49s 59m37s 17 7 53m17s 51m40s 18 5 50m 47m44s 19 6 51m40s 49m52s 20 8 39m7s 36m34s 21 6 1h51s 59m2s 22 5 1h 57m47s 23 8 42m25s 37m54s -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2026-05-25 07:05:43 Date
Connections per database
Key values
- rio Main Database
- 180 connections Total
Connections per user
Key values
- intelifix Main User
- 180 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-05-25 09:00:29 Date
Histogram of session times
Key values
- 136 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 165 sessions Total
Sessions per user
Key values
- intelifix Main User
- 165 sessions Total
Sessions per host
Key values
- [local] Main Host
- 165 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 165 sessions Total
Application Count Total Duration Average Duration [unknown] 121 4d16h50m27s 55m57s pgAdmin 4 - CONN:289225 1 2h22m40s 2h22m40s pgAdmin 4 - CONN:3297970 2 3m40s 1m50s pgAdmin 4 - CONN:7825798 1 163ms 163ms pgAdmin 4 - DB:brasilia 1 2h21m36s 2h21m36s pgAdmin 4 - DB:postgres 3 4h33m23s 1h31m7s pgAdmin 4 - DB:rio 2 3m47s 1m53s pg_dump 6 44m18s 7m23s postgres_fdw 1 35m9s 35m9s psql 27 1d3h27m40s 1h1m1s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 16,757 buffers Checkpoint Peak
- 2026-05-25 00:11:40 Date
- 269.996 seconds Highest write time
- 0.008 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-05-25 08:55:19 Date
Checkpoints distance
Key values
- 193.62 Mo Distance Peak
- 2026-05-25 00:11:40 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 25 00 16,757 269.235s 0.003s 269.262s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0.053s 0.003s 0.066s 04 0 0s 0s 0s 05 5,918 594.108s 0.017s 594.155s 06 2,475 248.069s 0.007s 248.09s 07 15,238 1,354.686s 0.052s 1,354.843s 08 852 85.684s 0.03s 85.769s 09 900 172.223s 0.011s 172.249s 10 20 2.028s 0.002s 2.035s 11 20 2.029s 0.003s 2.036s 12 79 7.95s 0.002s 7.957s 13 23 2.326s 0.003s 2.333s 14 20 2.016s 0.004s 2.03s 15 20 2.017s 0.002s 2.021s 16 76 7.63s 0.002s 7.635s 17 20 2.017s 0.002s 2.021s 18 768 76.867s 0.007s 76.892s 19 20 2.017s 0.002s 2.022s 20 221 22.178s 0.005s 22.193s 21 144 14.506s 0.007s 14.528s 22 25 2.529s 0.003s 2.537s 23 141 14.191s 0.008s 14.216s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 25 00 0 6 0 49 0.002s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 3 0.002s 0.001s 04 0 0 0 0 0s 0s 05 0 3 0 120 0.004s 0.006s 06 0 0 0 80 0.002s 0.003s 07 0 13 0 1,337 0.004s 0.012s 08 0 1 0 228 0.003s 0.012s 09 0 1 0 81 0.002s 0.003s 10 0 0 0 3 0.002s 0.001s 11 0 0 0 3 0.002s 0.001s 12 0 0 0 5 0.002s 0.001s 13 0 0 0 4 0.003s 0.001s 14 0 0 0 3 0.003s 0.002s 15 0 0 0 3 0.001s 0.001s 16 0 0 0 5 0.001s 0.001s 17 0 0 0 3 0.002s 0.001s 18 0 1 0 34 0.002s 0.004s 19 0 0 0 3 0.001s 0.001s 20 0 0 0 36 0.003s 0.003s 21 0 0 0 28 0.002s 0.005s 22 0 0 0 5 0.001s 0.002s 23 0 0 0 87 0.002s 0.006s Day Hour Count Avg time (sec) May 25 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate May 25 00 99,131.00 kB 99,131.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 44,609.00 kB 04 0.00 kB 0.00 kB 05 6,576.33 kB 9,644.67 kB 06 3,914.67 kB 10,329.33 kB 07 17,506.08 kB 43,196.50 kB 08 861.78 kB 45,639.67 kB 09 8,828.33 kB 25,660.33 kB 10 158.00 kB 21,147.00 kB 11 159.00 kB 19,048.00 kB 12 237.00 kB 17,167.00 kB 13 159.00 kB 15,466.00 kB 14 159.00 kB 13,935.00 kB 15 159.00 kB 12,558.00 kB 16 236.00 kB 11,325.00 kB 17 158.00 kB 10,209.00 kB 18 638.75 kB 8,104.75 kB 19 159.00 kB 6,217.00 kB 20 272.67 kB 5,107.00 kB 21 146.00 kB 3,446.60 kB 22 93.00 kB 2,380.50 kB 23 193.67 kB 1,647.67 kB -
Temporary Files
Size of temporary files
Key values
- 449.83 MiB Temp Files size Peak
- 2026-05-25 05:32:12 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-05-25 05:32:19 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 25 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.02 GiB 104.63 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 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 873.95 MiB 67.09 MiB 224.91 MiB 109.24 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-25 05:32:21 Duration: 1m35s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-25 05:32:12 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 172.39 MiB 86.20 MiB 86.20 MiB 86.20 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-05-25 05:30:46 Duration: 44s2ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-05-25 05:30:42 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 224.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-25 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 224.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-25 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 86.20 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-05-25 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 86.20 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-05-25 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 74.30 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-25 05:32:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 74.25 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-25 05:32:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 74.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-25 05:32:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 67.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-25 05:32:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 67.10 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-25 05:32:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 67.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-25 05:32:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.47 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_05
Database rio - 2026-05-25 07:31:06 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.47 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_05
Database rio - 2026-05-25 07:31:06 Date
Analyzes per table
Key values
- public.temp0000280657 (9) Main table analyzed (database rio)
- 21 analyzes Total
Vacuums per table
Key values
- public.temp0000280657 (5) Main table vacuumed on database rio
- 27 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000280657 5 0 0 0 0 0 0 3,297 24 198,188 0 0 rio.public.logs 4 0 0 0 0 0 0 557 231 297,480 127 3,173 rio.public.temp0000280645 4 0 0 0 0 0 0 6,080 16 361,132 0 0 rio.auditor.auditor_2026_05 3 0 0 0 0 0 0 4,172 1,172 1,493,253 808 10,321 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,863 174 756,918 140 920 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 118 33 95,674 0 0 rio.pg_catalog.pg_attribute 1 1 0 0 0 0 0 307 181 278,574 10 233 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 189 30 155,286 12 57 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,723 369 1,107,509 300 2,224 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,339 428 1,828,588 311 2,019 brasilia.auditor.auditor_2026_05 1 0 0 0 0 0 0 835 187 302,322 0 0 rio.public.temp0000280661 1 0 0 0 0 0 0 65 4 4,438 0 0 rio.public.temp0000280659 1 0 0 0 0 0 0 65 4 4,438 0 0 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 753 146 902,406 70 352 rio.pg_catalog.pg_class 1 1 0 0 0 0 0 132 96 216,000 1 29 Total 27 8 0 0 0 0 0 25,495 3,095 8,002,206 1,779 19,328 Vacuum throughput per table
Key values
- auditor.auditor_2026_05 (0.68) 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
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000280657 0 0 0.14 rio.public.logs 0 0 0.23 rio.public.temp0000280645 0 0 0.16 rio.auditor.auditor_2026_05 0 0 0.68 brasilia.pg_catalog.pg_statistic 0 0 0.1 contagem.pg_toast.pg_toast_2619 0 0 0.01 rio.pg_catalog.pg_attribute 0 0 0.13 brasilia.pg_toast.pg_toast_2619 0 0 0.01 contagem.pg_catalog.pg_statistic 0 0 0.14 rio.pg_catalog.pg_statistic 0 0 0.18 brasilia.auditor.auditor_2026_05 0 0 0.2 rio.public.temp0000280661 0 0 0 rio.public.temp0000280659 0 0 0 rio.pg_toast.pg_toast_2619 0 0 0.05 rio.pg_catalog.pg_class 0 0 0.05 Total 0 0 2.08 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4354) Main table with removed tuples on database rio
- 14317 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,354 7,458 0 0 1,162 brasilia.pg_catalog.pg_statistic 1 1 4,019 7,360 0 0 1,077 contagem.pg_catalog.pg_statistic 1 1 3,944 7,274 0 0 989 rio.pg_catalog.pg_attribute 1 1 1,223 24,515 0 0 481 rio.pg_toast.pg_toast_2619 1 1 544 671 0 0 258 brasilia.pg_toast.pg_toast_2619 1 1 137 134 0 0 67 contagem.pg_toast.pg_toast_2619 1 1 94 122 0 30 28 rio.pg_catalog.pg_class 1 1 2 3,382 16 0 84 rio.auditor.auditor_2026_05 3 0 0 55,640,792 0 0 2,440,627 rio.public.logs 4 0 0 62,932,278 0 0 2,514,204 brasilia.auditor.auditor_2026_05 1 0 0 3,755,577 0 0 160,913 rio.public.temp0000280657 5 0 0 46,350 0 80 3,312 rio.public.temp0000280661 1 0 0 1,212 0 0 64 rio.public.temp0000280659 1 0 0 1,212 0 0 64 rio.public.temp0000280645 4 0 0 85,622 0 0 6,144 Total 27 8 14,317 122,513,959 16 110 5,129,474 Pages removed per table
Key values
- public.temp0000280657 (80) Main table with removed pages on database rio
- 110 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000280657 5 0 0 80 contagem.pg_toast.pg_toast_2619 1 1 94 30 brasilia.pg_catalog.pg_statistic 1 1 4019 0 rio.pg_catalog.pg_attribute 1 1 1223 0 brasilia.pg_toast.pg_toast_2619 1 1 137 0 rio.auditor.auditor_2026_05 3 0 0 0 contagem.pg_catalog.pg_statistic 1 1 3944 0 rio.pg_catalog.pg_statistic 1 1 4354 0 rio.public.logs 4 0 0 0 brasilia.auditor.auditor_2026_05 1 0 0 0 rio.public.temp0000280661 1 0 0 0 rio.public.temp0000280659 1 0 0 0 rio.pg_toast.pg_toast_2619 1 1 544 0 rio.public.temp0000280645 4 0 0 0 rio.pg_catalog.pg_class 1 1 2 0 Total 27 8 14,317 110 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 25 00 2 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 1 07 10 10 08 5 5 09 1 4 10 0 0 11 0 0 12 1 0 13 0 0 14 0 0 15 0 0 16 1 0 17 0 0 18 0 0 19 0 0 20 1 0 21 0 1 22 0 0 23 0 0 - 0.47 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
- 199 Total read queries
- 437 Total write queries
Queries by database
Key values
- rio Main database
- 486 Requests
- 3h22m8s (rio)
- Main time consuming database
Queries by user
Key values
- lenon Main user
- 2,206 Requests
User Request type Count Duration etiquetas Total 1 277ms select 1 277ms intelifix Total 1,439 7h55m41s copy to 740 1h36m16s ddl 43 6m3s others 394 41m5s select 262 5h32m16s lenon Total 2,206 3h10m53s copy from 446 1h26m48s cursor 1 266ms ddl 1,726 1h25m9s others 6 18m13s select 27 41s11ms Duration by user
Key values
- 7h55m41s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 1 277ms select 1 277ms intelifix Total 1,439 7h55m41s copy to 740 1h36m16s ddl 43 6m3s others 394 41m5s select 262 5h32m16s lenon Total 2,206 3h10m53s copy from 446 1h26m48s cursor 1 266ms ddl 1,726 1h25m9s others 6 18m13s select 27 41s11ms Queries by host
Key values
- [local] Main host
- 3,638 Requests
- 11h6m28s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 406 Requests
- 3h43m14s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-25 23:17:22 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 366 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 12m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-25 07:17:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 12m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-25 08:17:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m36s analyze verbose;[ Date: 2026-05-25 05:08:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-25 20:12:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-25 14:11:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-25 10:11:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-25 17:11:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-25 13:11:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-25 09:11:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-25 12:11:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-25 11:11:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-25 18:11:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-25 19:11:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-25 21:11:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-25 16:11:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 6m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-25 22:11:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 6m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-25 15:11:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 6m7s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024594, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-05-25 07:30:10 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m10s analyze verbose;[ Date: 2026-05-25 05:13:49 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 4m26s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-05-25 08:24:26 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h2m25s 47 818ms 12m53s 2m36s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 25 07 3 13m39s 4m33s 08 2 12m40s 6m20s 09 3 6m57s 2m19s 10 3 7m4s 2m21s 11 3 6m55s 2m18s 12 3 6m54s 2m18s 13 3 6m56s 2m18s 14 3 7m5s 2m21s 15 3 6m27s 2m9s 16 3 6m32s 2m10s 17 3 6m56s 2m18s 18 3 6m47s 2m15s 19 3 6m35s 2m11s 20 3 7m44s 2m34s 21 3 6m34s 2m11s 22 3 6m31s 2m10s [ User: intelifix - Total duration: 2h2m25s - Times executed: 47 ]
[ Application: psql - Total duration: 2h2m25s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-25 07:17:55 Duration: 12m53s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-25 08:17:41 Duration: 12m39s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-25 20:12:27 Duration: 7m25s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
2 1h11m11s 41 478ms 4m26s 1m44s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 25 07 3 5m48s 1m56s 08 3 5m54s 1m58s 09 3 4m25s 1m28s 10 2 4m14s 2m7s 11 2 4m30s 2m15s 12 3 4m11s 1m23s 13 2 4m48s 2m24s 14 3 4m5s 1m21s 15 2 4m5s 2m2s 16 2 4m10s 2m5s 17 3 4m6s 1m22s 18 3 4m9s 1m23s 19 3 3m55s 1m18s 20 2 4m28s 2m14s 21 3 4m2s 1m20s 22 2 4m14s 2m7s [ User: intelifix - Total duration: 1h11m11s - Times executed: 41 ]
[ Application: psql - Total duration: 1h11m11s - Times executed: 41 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-25 08:24:26 Duration: 4m26s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-25 13:16:45 Duration: 4m13s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-25 07:24:25 Duration: 4m12s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
3 16m1s 3 2m14s 8m36s 5m20s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 25 05 3 16m1s 5m20s [ User: intelifix - Total duration: 16m1s - Times executed: 3 ]
[ Application: psql - Total duration: 16m1s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-05-25 05:08:38 Duration: 8m36s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
analyze verbose;
Date: 2026-05-25 05:13:49 Duration: 5m10s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
analyze verbose;
Date: 2026-05-25 05:16:03 Duration: 2m14s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
4 10m57s 5 329ms 6m7s 2m11s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 25 07 5 10m57s 2m11s [ User: intelifix - Total duration: 10m57s - Times executed: 5 ]
[ Application: [unknown] - Total duration: 10m57s - Times executed: 5 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024594, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-25 07:30:10 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024596, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-25 07:53:43 Duration: 3m49s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-05-22''),DATE(''2026-05-22'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-05-25 07:22:17 Duration: 56s393ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
5 5m36s 118 161ms 18s268ms 2s854ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 25 00 7 38s56ms 5s436ms 01 6 21s118ms 3s519ms 02 6 16s976ms 2s829ms 03 5 13s272ms 2s654ms 04 6 15s776ms 2s629ms 05 6 15s21ms 2s503ms 06 6 16s549ms 2s758ms 07 6 16s172ms 2s695ms 08 6 16s578ms 2s763ms 09 6 15s910ms 2s651ms 10 5 16s438ms 3s287ms 11 5 11s350ms 2s270ms 12 4 12s567ms 3s141ms 13 4 11s13ms 2s753ms 14 4 9s422ms 2s355ms 15 4 9s266ms 2s316ms 16 4 9s935ms 2s483ms 17 4 9s989ms 2s497ms 18 4 9s215ms 2s303ms 19 4 9s191ms 2s297ms 20 5 17s687ms 3s537ms 21 5 11s409ms 2s281ms 22 6 13s911ms 2s318ms [ User: intelifix - Total duration: 5m36s - Times executed: 118 ]
[ Application: psql - Total duration: 5m36s - Times executed: 118 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-25 00:05:20 Duration: 18s268ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-25 20:15:11 Duration: 9s966ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-25 10:25:06 Duration: 4s360ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
6 4m4s 9 3s22ms 1m24s 27s179ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 25 07 5 2m7s 25s456ms 08 3 1m30s 30s126ms 09 1 26s954ms 26s954ms [ User: intelifix - Total duration: 4m4s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 4m4s - Times executed: 9 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-25', 080, '', '', 0, 6, '2026-05-01');
Date: 2026-05-25 07:59:09 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-25', 080, '', '', 0, 6, '2026-05-01');
Date: 2026-05-25 08:03:17 Duration: 33s96ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-25', 080, '', '', 0, 6, '2026-05-01');
Date: 2026-05-25 08:06:01 Duration: 29s920ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
7 2m42s 1 2m42s 2m42s 2m42s select * from rs_fast_excel (?, ?) notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 25 07 1 2m42s 2m42s [ User: intelifix - Total duration: 2m42s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 2m42s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-05-22''),DATE(''2026-05-22'')) ;', '/var/www/html/tmp/temp_54.xlsx') NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-05-25 07:22:18 Duration: 2m42s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
8 2m30s 12 9s316ms 39s116ms 12s544ms create table temp0000280645 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 25 07 12 2m30s 12s544ms [ User: intelifix - Total duration: 2m30s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m30s - Times executed: 12 ]
-
CREATE TABLE temp0000280645 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-25 07:22:18 Duration: 39s116ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CREATE TABLE temp0000280645 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-25 07:49:49 Duration: 11s344ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CREATE TABLE temp0000280645 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-25 07:48:15 Duration: 10s797ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
9 2m 4 2s609ms 57s608ms 30s23ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 25 20 2 59s791ms 29s895ms 23 2 1m 30s150ms [ User: intelifix - Total duration: 2m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-25 23:34:16 Duration: 57s608ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-25 20:07:47 Duration: 57s181ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-25 23:44:32 Duration: 2s693ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
10 1m50s 3 16s501ms 1m11s 36s884ms copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 25 23 3 1m50s 36s884ms [ User: intelifix - Total duration: 1m50s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m50s - Times executed: 3 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:12:05 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:35:30 Duration: 23s60ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:45:10 Duration: 16s501ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
11 1m40s 4 362ms 50s83ms 25s121ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 25 20 2 50s446ms 25s223ms 23 2 50s40ms 25s20ms [ User: intelifix - Total duration: 1m40s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m40s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-25 20:05:16 Duration: 50s83ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-25 23:17:21 Duration: 49s672ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-25 23:36:46 Duration: 367ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
12 1m35s 1 1m35s 1m35s 1m35s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 25 05 1 1m35s 1m35s [ User: intelifix - Total duration: 1m35s - Times executed: 1 ]
[ Application: psql - Total duration: 1m35s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-25 05:32:21 Duration: 1m35s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-25 05:32:12 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
13 1m33s 3 13s40ms 1m5s 31s156ms copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 25 23 3 1m33s 31s156ms [ User: intelifix - Total duration: 1m33s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m33s - Times executed: 3 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:14:09 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:36:04 Duration: 15s183ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:45:38 Duration: 13s40ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
14 1m32s 6 8s909ms 21s881ms 15s356ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 25 00 3 1m1s 20s409ms 06 3 30s909ms 10s303ms [ User: intelifix - Total duration: 1m32s - Times executed: 6 ]
[ Application: psql - Total duration: 1m32s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-25 00:05:24 Duration: 21s881ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-25 00:05:44 Duration: 20s170ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-25 00:06:03 Duration: 19s176ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
15 1m32s 3 14s826ms 58s525ms 30s699ms copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 25 23 3 1m32s 30s699ms [ User: intelifix - Total duration: 1m32s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m32s - Times executed: 3 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:13:03 Duration: 58s525ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:35:49 Duration: 18s747ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:45:25 Duration: 14s826ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
16 1m26s 6 2s166ms 32s35ms 14s340ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 25 20 3 42s959ms 14s319ms 23 3 43s84ms 14s361ms [ User: intelifix - Total duration: 1m26s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m26s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-25 23:17:54 Duration: 32s35ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-25 20:05:49 Duration: 32s17ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-25 23:36:55 Duration: 8s878ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
17 1m24s 3 13s303ms 50s735ms 28s296ms copy auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 25 23 3 1m24s 28s296ms [ User: intelifix - Total duration: 1m24s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 3 ]
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:10:54 Duration: 50s735ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:35:07 Duration: 20s849ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:44:54 Duration: 13s303ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
18 1m10s 6 1s642ms 26s842ms 11s707ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 25 20 3 35s45ms 11s681ms 23 3 35s200ms 11s733ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-25 20:06:19 Duration: 26s842ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-25 23:18:23 Duration: 26s790ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-25 23:37:02 Duration: 6s648ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
19 1m9s 6 2s868ms 26s931ms 11s530ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 25 20 3 34s112ms 11s370ms 23 3 35s70ms 11s690ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-25 23:34:43 Duration: 26s931ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-25 20:08:14 Duration: 26s119ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-25 23:44:37 Duration: 5s244ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
20 59s827ms 6 1s669ms 19s823ms 9s971ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 25 20 3 29s813ms 9s937ms 23 3 30s13ms 10s4ms [ User: intelifix - Total duration: 59s827ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s827ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-25 20:02:42 Duration: 19s823ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-25 23:14:47 Duration: 19s746ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-25 23:36:20 Duration: 8s554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 118 5m36s 161ms 18s268ms 2s854ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 25 00 7 38s56ms 5s436ms 01 6 21s118ms 3s519ms 02 6 16s976ms 2s829ms 03 5 13s272ms 2s654ms 04 6 15s776ms 2s629ms 05 6 15s21ms 2s503ms 06 6 16s549ms 2s758ms 07 6 16s172ms 2s695ms 08 6 16s578ms 2s763ms 09 6 15s910ms 2s651ms 10 5 16s438ms 3s287ms 11 5 11s350ms 2s270ms 12 4 12s567ms 3s141ms 13 4 11s13ms 2s753ms 14 4 9s422ms 2s355ms 15 4 9s266ms 2s316ms 16 4 9s935ms 2s483ms 17 4 9s989ms 2s497ms 18 4 9s215ms 2s303ms 19 4 9s191ms 2s297ms 20 5 17s687ms 3s537ms 21 5 11s409ms 2s281ms 22 6 13s911ms 2s318ms [ User: intelifix - Total duration: 5m36s - Times executed: 118 ]
[ Application: psql - Total duration: 5m36s - Times executed: 118 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-25 00:05:20 Duration: 18s268ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-25 20:15:11 Duration: 9s966ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-25 10:25:06 Duration: 4s360ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
2 59 55s337ms 572ms 2s189ms 937ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 25 08 3 3s209ms 1s69ms 09 5 4s338ms 867ms 10 4 4s550ms 1s137ms 11 5 5s860ms 1s172ms 12 4 3s281ms 820ms 13 3 2s705ms 901ms 14 3 3s730ms 1s243ms 15 5 4s362ms 872ms 16 5 4s37ms 807ms 17 3 2s205ms 735ms 18 4 3s183ms 795ms 19 4 3s192ms 798ms 20 4 4s33ms 1s8ms 21 4 3s393ms 848ms 22 3 3s252ms 1s84ms [ User: intelifix - Total duration: 55s337ms - Times executed: 59 ]
[ Application: psql - Total duration: 55s337ms - Times executed: 59 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-25 11:20:03 Duration: 2s189ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-25 20:20:02 Duration: 1s792ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-25 14:20:03 Duration: 1s779ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
3 47 2h2m25s 818ms 12m53s 2m36s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 25 07 3 13m39s 4m33s 08 2 12m40s 6m20s 09 3 6m57s 2m19s 10 3 7m4s 2m21s 11 3 6m55s 2m18s 12 3 6m54s 2m18s 13 3 6m56s 2m18s 14 3 7m5s 2m21s 15 3 6m27s 2m9s 16 3 6m32s 2m10s 17 3 6m56s 2m18s 18 3 6m47s 2m15s 19 3 6m35s 2m11s 20 3 7m44s 2m34s 21 3 6m34s 2m11s 22 3 6m31s 2m10s [ User: intelifix - Total duration: 2h2m25s - Times executed: 47 ]
[ Application: psql - Total duration: 2h2m25s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-25 07:17:55 Duration: 12m53s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-25 08:17:41 Duration: 12m39s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-25 20:12:27 Duration: 7m25s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
4 41 1h11m11s 478ms 4m26s 1m44s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 25 07 3 5m48s 1m56s 08 3 5m54s 1m58s 09 3 4m25s 1m28s 10 2 4m14s 2m7s 11 2 4m30s 2m15s 12 3 4m11s 1m23s 13 2 4m48s 2m24s 14 3 4m5s 1m21s 15 2 4m5s 2m2s 16 2 4m10s 2m5s 17 3 4m6s 1m22s 18 3 4m9s 1m23s 19 3 3m55s 1m18s 20 2 4m28s 2m14s 21 3 4m2s 1m20s 22 2 4m14s 2m7s [ User: intelifix - Total duration: 1h11m11s - Times executed: 41 ]
[ Application: psql - Total duration: 1h11m11s - Times executed: 41 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-25 08:24:26 Duration: 4m26s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-25 13:16:45 Duration: 4m13s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-25 07:24:25 Duration: 4m12s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
5 31 30s678ms 736ms 2s686ms 989ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 25 08 3 4s797ms 1s599ms 09 1 888ms 888ms 10 2 2s638ms 1s319ms 11 1 1s22ms 1s22ms 12 2 1s970ms 985ms 13 3 2s876ms 958ms 14 3 2s766ms 922ms 15 1 889ms 889ms 16 1 859ms 859ms 17 3 2s703ms 901ms 18 2 1s610ms 805ms 19 2 1s582ms 791ms 20 2 1s646ms 823ms 21 2 1s916ms 958ms 22 3 2s507ms 835ms [ User: intelifix - Total duration: 30s678ms - Times executed: 31 ]
[ Application: psql - Total duration: 30s678ms - Times executed: 31 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-05-25 08:00:03 Duration: 2s686ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-05-25 10:00:02 Duration: 1s331ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-05-25 08:40:03 Duration: 1s329ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
6 24 9s713ms 166ms 1s196ms 404ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 25 06 2 1s545ms 772ms 07 22 8s167ms 371ms [ User: intelifix - Total duration: 9s713ms - Times executed: 24 ]
[ Application: [unknown] - Total duration: 9s713ms - Times executed: 24 ]
-
SELECT * FROM RS_TRIAGEM (403, 5, '113', 3, '229728619596,229812646069,229670652021,229726243451,229814567895,229660309697,229859347484,229813804656,229860552844,229727069805', NULL, NULL, 0141, 00);
Date: 2026-05-25 06:56:38 Duration: 1s196ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '216822347998,216793307487,216843277190,216564947288,216321448080,216825998703,216913585769,216536557278,216890297682,216826139299,216880819293,216415943959,216450616074', NULL, NULL, 064, 00);
Date: 2026-05-25 07:09:00 Duration: 764ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_TRIAGEM (403, 5, '113', 3, '216937994762,229747002525,229879661937,229782326780,229737920113,216936813749,229667800520,229785950311,229809265167,229816805061', NULL, NULL, 0141, 00);
Date: 2026-05-25 07:04:49 Duration: 703ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
7 22 54s704ms 2s179ms 3s425ms 2s486ms call rs_giga_triagem (?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 25 09 1 2s655ms 2s655ms 10 1 3s54ms 3s54ms 11 2 5s61ms 2s530ms 12 2 5s626ms 2s813ms 13 2 5s488ms 2s744ms 14 2 4s606ms 2s303ms 15 2 4s534ms 2s267ms 16 2 4s626ms 2s313ms 17 1 2s179ms 2s179ms 18 2 4s411ms 2s205ms 19 2 4s493ms 2s246ms 20 2 5s729ms 2s864ms 21 1 2s238ms 2s238ms [ User: intelifix - Total duration: 54s704ms - Times executed: 22 ]
[ Application: psql - Total duration: 54s704ms - Times executed: 22 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-05-25 20:35:04 Duration: 3s425ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-05-25 10:35:04 Duration: 3s54ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-05-25 13:35:04 Duration: 2s988ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
8 12 2m30s 9s316ms 39s116ms 12s544ms create table temp0000280645 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 25 07 12 2m30s 12s544ms [ User: intelifix - Total duration: 2m30s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m30s - Times executed: 12 ]
-
CREATE TABLE temp0000280645 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-25 07:22:18 Duration: 39s116ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CREATE TABLE temp0000280645 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-25 07:49:49 Duration: 11s344ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CREATE TABLE temp0000280645 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-25 07:48:15 Duration: 10s797ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
9 9 4m4s 3s22ms 1m24s 27s179ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 25 07 5 2m7s 25s456ms 08 3 1m30s 30s126ms 09 1 26s954ms 26s954ms [ User: intelifix - Total duration: 4m4s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 4m4s - Times executed: 9 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-25', 080, '', '', 0, 6, '2026-05-01');
Date: 2026-05-25 07:59:09 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-25', 080, '', '', 0, 6, '2026-05-01');
Date: 2026-05-25 08:03:17 Duration: 33s96ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-25', 080, '', '', 0, 6, '2026-05-01');
Date: 2026-05-25 08:06:01 Duration: 29s920ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
10 9 4s920ms 431ms 705ms 546ms 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 #10
Day Hour Count Duration Avg duration May 25 06 2 995ms 497ms 07 6 3s458ms 576ms 08 1 466ms 466ms [ User: lenon - Total duration: 4s920ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 4s920ms - Times executed: 9 ]
-
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-25 07:47:14 Duration: 705ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
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-25 07:19:22 Duration: 678ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
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-25 07:59:03 Duration: 672ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-25.log
11 7 15s310ms 951ms 3s270ms 2s187ms create table temp0000280657 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 25 08 3 9s308ms 3s102ms 09 4 6s1ms 1s500ms [ User: intelifix - Total duration: 15s310ms - Times executed: 7 ]
[ Application: [unknown] - Total duration: 15s310ms - Times executed: 7 ]
-
CREATE TABLE temp0000280657 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-05-2026", "ate" :"25-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-25 08:52:31 Duration: 3s270ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CREATE TABLE temp0000280657 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-05-2026", "ate" :"25-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-25 08:51:45 Duration: 3s95ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CREATE TABLE temp0000280657 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-05-2026", "ate" :"25-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-25 09:02:48 Duration: 3s55ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
12 7 4s170ms 511ms 727ms 595ms select * from rs_smart_fiscal_saida () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 25 10 1 650ms 650ms 11 1 695ms 695ms 13 1 553ms 553ms 15 1 513ms 513ms 16 1 518ms 518ms 20 1 727ms 727ms 22 1 511ms 511ms [ User: intelifix - Total duration: 4s170ms - Times executed: 7 ]
[ Application: psql - Total duration: 4s170ms - Times executed: 7 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-05-25 20:17:15 Duration: 727ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-05-25 11:16:27 Duration: 695ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-05-25 10:16:21 Duration: 650ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
13 6 1m32s 8s909ms 21s881ms 15s356ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 25 00 3 1m1s 20s409ms 06 3 30s909ms 10s303ms [ User: intelifix - Total duration: 1m32s - Times executed: 6 ]
[ Application: psql - Total duration: 1m32s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-25 00:05:24 Duration: 21s881ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-25 00:05:44 Duration: 20s170ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-25 00:06:03 Duration: 19s176ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
14 6 1m26s 2s166ms 32s35ms 14s340ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 25 20 3 42s959ms 14s319ms 23 3 43s84ms 14s361ms [ User: intelifix - Total duration: 1m26s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m26s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-25 23:17:54 Duration: 32s35ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-25 20:05:49 Duration: 32s17ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-25 23:36:55 Duration: 8s878ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
15 6 1m10s 1s642ms 26s842ms 11s707ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 25 20 3 35s45ms 11s681ms 23 3 35s200ms 11s733ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-25 20:06:19 Duration: 26s842ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-25 23:18:23 Duration: 26s790ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-25 23:37:02 Duration: 6s648ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
16 6 1m9s 2s868ms 26s931ms 11s530ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 25 20 3 34s112ms 11s370ms 23 3 35s70ms 11s690ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-25 23:34:43 Duration: 26s931ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-25 20:08:14 Duration: 26s119ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-25 23:44:37 Duration: 5s244ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
17 6 59s827ms 1s669ms 19s823ms 9s971ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 25 20 3 29s813ms 9s937ms 23 3 30s13ms 10s4ms [ User: intelifix - Total duration: 59s827ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s827ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-25 20:02:42 Duration: 19s823ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-25 23:14:47 Duration: 19s746ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-25 23:36:20 Duration: 8s554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
18 6 59s811ms 1s510ms 20s467ms 9s968ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 25 20 3 30s31ms 10s10ms 23 3 29s780ms 9s926ms [ User: intelifix - Total duration: 59s811ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s811ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-25 20:03:17 Duration: 20s467ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-25 23:15:22 Duration: 20s334ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-25 20:08:41 Duration: 8s35ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
19 6 52s292ms 1s216ms 21s2ms 8s715ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 25 20 3 26s91ms 8s697ms 23 3 26s200ms 8s733ms [ User: intelifix - Total duration: 52s292ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 52s292ms - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-25 23:16:11 Duration: 21s2ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-25 20:04:06 Duration: 20s855ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-25 20:08:53 Duration: 4s19ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
20 6 42s286ms 1s210ms 13s826ms 7s47ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 25 20 3 21s118ms 7s39ms 23 3 21s167ms 7s55ms [ User: intelifix - Total duration: 42s286ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 42s286ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-25 23:15:35 Duration: 13s826ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-25 20:03:31 Duration: 13s821ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-25 23:36:36 Duration: 6s130ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m14s 8m36s 5m20s 3 16m1s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 25 05 3 16m1s 5m20s [ User: intelifix - Total duration: 16m1s - Times executed: 3 ]
[ Application: psql - Total duration: 16m1s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-05-25 05:08:38 Duration: 8m36s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
analyze verbose;
Date: 2026-05-25 05:13:49 Duration: 5m10s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
analyze verbose;
Date: 2026-05-25 05:16:03 Duration: 2m14s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
2 2m42s 2m42s 2m42s 1 2m42s select * from rs_fast_excel (?, ?) notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 25 07 1 2m42s 2m42s [ User: intelifix - Total duration: 2m42s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 2m42s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-05-22''),DATE(''2026-05-22'')) ;', '/var/www/html/tmp/temp_54.xlsx') NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-05-25 07:22:18 Duration: 2m42s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
3 818ms 12m53s 2m36s 47 2h2m25s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 25 07 3 13m39s 4m33s 08 2 12m40s 6m20s 09 3 6m57s 2m19s 10 3 7m4s 2m21s 11 3 6m55s 2m18s 12 3 6m54s 2m18s 13 3 6m56s 2m18s 14 3 7m5s 2m21s 15 3 6m27s 2m9s 16 3 6m32s 2m10s 17 3 6m56s 2m18s 18 3 6m47s 2m15s 19 3 6m35s 2m11s 20 3 7m44s 2m34s 21 3 6m34s 2m11s 22 3 6m31s 2m10s [ User: intelifix - Total duration: 2h2m25s - Times executed: 47 ]
[ Application: psql - Total duration: 2h2m25s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-25 07:17:55 Duration: 12m53s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-25 08:17:41 Duration: 12m39s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-25 20:12:27 Duration: 7m25s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
4 329ms 6m7s 2m11s 5 10m57s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 25 07 5 10m57s 2m11s [ User: intelifix - Total duration: 10m57s - Times executed: 5 ]
[ Application: [unknown] - Total duration: 10m57s - Times executed: 5 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024594, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-25 07:30:10 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024596, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-25 07:53:43 Duration: 3m49s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-05-22''),DATE(''2026-05-22'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-05-25 07:22:17 Duration: 56s393ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
5 478ms 4m26s 1m44s 41 1h11m11s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 25 07 3 5m48s 1m56s 08 3 5m54s 1m58s 09 3 4m25s 1m28s 10 2 4m14s 2m7s 11 2 4m30s 2m15s 12 3 4m11s 1m23s 13 2 4m48s 2m24s 14 3 4m5s 1m21s 15 2 4m5s 2m2s 16 2 4m10s 2m5s 17 3 4m6s 1m22s 18 3 4m9s 1m23s 19 3 3m55s 1m18s 20 2 4m28s 2m14s 21 3 4m2s 1m20s 22 2 4m14s 2m7s [ User: intelifix - Total duration: 1h11m11s - Times executed: 41 ]
[ Application: psql - Total duration: 1h11m11s - Times executed: 41 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-25 08:24:26 Duration: 4m26s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-25 13:16:45 Duration: 4m13s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-25 07:24:25 Duration: 4m12s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
6 1m35s 1m35s 1m35s 1 1m35s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 25 05 1 1m35s 1m35s [ User: intelifix - Total duration: 1m35s - Times executed: 1 ]
[ Application: psql - Total duration: 1m35s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-25 05:32:21 Duration: 1m35s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-25 05:32:12 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
7 16s501ms 1m11s 36s884ms 3 1m50s copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 25 23 3 1m50s 36s884ms [ User: intelifix - Total duration: 1m50s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m50s - Times executed: 3 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:12:05 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:35:30 Duration: 23s60ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:45:10 Duration: 16s501ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
8 13s40ms 1m5s 31s156ms 3 1m33s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 25 23 3 1m33s 31s156ms [ User: intelifix - Total duration: 1m33s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m33s - Times executed: 3 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:14:09 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:36:04 Duration: 15s183ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:45:38 Duration: 13s40ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
9 14s826ms 58s525ms 30s699ms 3 1m32s copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 25 23 3 1m32s 30s699ms [ User: intelifix - Total duration: 1m32s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m32s - Times executed: 3 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:13:03 Duration: 58s525ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:35:49 Duration: 18s747ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:45:25 Duration: 14s826ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
10 2s609ms 57s608ms 30s23ms 4 2m copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 25 20 2 59s791ms 29s895ms 23 2 1m 30s150ms [ User: intelifix - Total duration: 2m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-25 23:34:16 Duration: 57s608ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-25 20:07:47 Duration: 57s181ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-25 23:44:32 Duration: 2s693ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
11 13s303ms 50s735ms 28s296ms 3 1m24s copy auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 25 23 3 1m24s 28s296ms [ User: intelifix - Total duration: 1m24s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 3 ]
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:10:54 Duration: 50s735ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:35:07 Duration: 20s849ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-25 23:44:54 Duration: 13s303ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
12 3s22ms 1m24s 27s179ms 9 4m4s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 25 07 5 2m7s 25s456ms 08 3 1m30s 30s126ms 09 1 26s954ms 26s954ms [ User: intelifix - Total duration: 4m4s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 4m4s - Times executed: 9 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-25', 080, '', '', 0, 6, '2026-05-01');
Date: 2026-05-25 07:59:09 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-25', 080, '', '', 0, 6, '2026-05-01');
Date: 2026-05-25 08:03:17 Duration: 33s96ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-25', 080, '', '', 0, 6, '2026-05-01');
Date: 2026-05-25 08:06:01 Duration: 29s920ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
13 362ms 50s83ms 25s121ms 4 1m40s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 25 20 2 50s446ms 25s223ms 23 2 50s40ms 25s20ms [ User: intelifix - Total duration: 1m40s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m40s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-25 20:05:16 Duration: 50s83ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-25 23:17:21 Duration: 49s672ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-25 23:36:46 Duration: 367ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
14 8s909ms 21s881ms 15s356ms 6 1m32s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 25 00 3 1m1s 20s409ms 06 3 30s909ms 10s303ms [ User: intelifix - Total duration: 1m32s - Times executed: 6 ]
[ Application: psql - Total duration: 1m32s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-25 00:05:24 Duration: 21s881ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-25 00:05:44 Duration: 20s170ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-25 00:06:03 Duration: 19s176ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-25.log
15 2s166ms 32s35ms 14s340ms 6 1m26s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 25 20 3 42s959ms 14s319ms 23 3 43s84ms 14s361ms [ User: intelifix - Total duration: 1m26s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m26s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-25 23:17:54 Duration: 32s35ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-25 20:05:49 Duration: 32s17ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-25 23:36:55 Duration: 8s878ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
16 9s316ms 39s116ms 12s544ms 12 2m30s create table temp0000280645 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 25 07 12 2m30s 12s544ms [ User: intelifix - Total duration: 2m30s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m30s - Times executed: 12 ]
-
CREATE TABLE temp0000280645 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-25 07:22:18 Duration: 39s116ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CREATE TABLE temp0000280645 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-25 07:49:49 Duration: 11s344ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
CREATE TABLE temp0000280645 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-25 07:48:15 Duration: 10s797ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-25.log
17 1s642ms 26s842ms 11s707ms 6 1m10s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 25 20 3 35s45ms 11s681ms 23 3 35s200ms 11s733ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-25 20:06:19 Duration: 26s842ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-25 23:18:23 Duration: 26s790ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-25 23:37:02 Duration: 6s648ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
18 2s868ms 26s931ms 11s530ms 6 1m9s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 25 20 3 34s112ms 11s370ms 23 3 35s70ms 11s690ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-25 23:34:43 Duration: 26s931ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-25 20:08:14 Duration: 26s119ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-25 23:44:37 Duration: 5s244ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
19 1s669ms 19s823ms 9s971ms 6 59s827ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 25 20 3 29s813ms 9s937ms 23 3 30s13ms 10s4ms [ User: intelifix - Total duration: 59s827ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s827ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-25 20:02:42 Duration: 19s823ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-25 23:14:47 Duration: 19s746ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-25 23:36:20 Duration: 8s554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
20 1s510ms 20s467ms 9s968ms 6 59s811ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 25 20 3 30s31ms 10s10ms 23 3 29s780ms 9s926ms [ User: intelifix - Total duration: 59s811ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s811ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-25 20:03:17 Duration: 20s467ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-25 23:15:22 Duration: 20s334ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-25 20:08:41 Duration: 8s35ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-25.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 181ms 1 181ms 181ms 181ms SELECT pro_id, pgp_sym_decrypt(nome, $1)::varchar, pgp_sym_decrypt(descricao, $1)::varchar, pgp_sym_decrypt(classe, $1)::varchar, pgp_sym_decrypt(php, $1)::varchar, pgp_sym_decrypt(extras, $1)::varchar from progs ORDER BY PRO_ID;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration May 25 12 1 181ms 181ms [ User: lenon - Total duration: 682ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 682ms - Times executed: 1 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, $1)::varchar, pgp_sym_decrypt(descricao, $1)::varchar, pgp_sym_decrypt(classe, $1)::varchar, pgp_sym_decrypt(php, $1)::varchar, pgp_sym_decrypt(extras, $1)::varchar from progs ORDER BY PRO_ID;
Date: 2026-05-24 12:20:20 Duration: 181ms Database: postgres User: contagem Remote: lenon Application: [local] Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 21 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration May 24 12 1 0ms 0ms 13 2 0ms 0ms 17 2 0ms 0ms 18 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms May 25 09 2 0ms 0ms 11 2 0ms 0ms 13 1 0ms 0ms 15 1 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 19 1 0ms 0ms 21 2 0ms 0ms [ User: intelifix - Total duration: 8m13s - Times executed: 20 ]
[ User: lenon - Total duration: 682ms - Times executed: 1 ]
[ Application: psql - Total duration: 8m13s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 682ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 2,070 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 20 FATAL entries
- 91 ERROR entries
- 0 WARNING entries
- 5 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 41 Max number of times the same event was reported
- 116 Total events found
Rank Times reported Error 1 41 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count May 25 07 41 - ERROR: prepared statement "_PLAN00000000279A7590" does not exist
- ERROR: prepared statement "_PLAN000000002EAC5740" does not exist
- ERROR: prepared statement "_PLAN00000000272E2580" does not exist
Statement: DEALLOCATE "_PLAN00000000279A7590"
Date: 2026-05-25 07:20:59 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
Statement: DEALLOCATE "_PLAN000000002EAC5740"
Date: 2026-05-25 07:22:39 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
Statement: DEALLOCATE "_PLAN00000000272E2580"
Date: 2026-05-25 07:23:36 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
2 26 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb//upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count May 25 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 10 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb//upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb//upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb//upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-05-25 00:05:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-05-25 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-05-25 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
3 18 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/rio//upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #3
Day Hour Count May 25 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/rio//upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/rio//upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/rio//upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-05-25 00:05:02 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-05-25 00:35:01 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-05-25 01:05:01 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
4 14 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count May 25 00 7 01 1 03 2 05 1 06 2 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-05-25 00:02:15 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
Date: 2026-05-25 00:03:23 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
Date: 2026-05-25 00:03:39 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
5 4 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count May 25 03 4 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-05-25 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
Date: 2026-05-25 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
Date: 2026-05-25 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
6 4 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #6
Day Hour Count May 25 10 3 11 1 - LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
Date: 2026-05-25 10:40:19 Database: postgres Application: pgAdmin 4 - DB:postgres User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-25.log
Date: 2026-05-25 10:46:52 Database: brasilia Application: pgAdmin 4 - DB:brasilia User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-25.log
Date: 2026-05-25 10:47:58 Database: brasilia Application: pgAdmin 4 - CONN:289225 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-25.log
7 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count May 25 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-05-25 05:32:21 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-25 05:32:21 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-05-25 05:32:21 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
8 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count May 25 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-05-25 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
Date: 2026-05-25 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
9 2 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #9
Day Hour Count May 25 08 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: call rs_giga_tecnicos()Date: 2026-05-25 08:33:17 Database: brasilia Application: pgAdmin 4 - CONN:289225 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-25.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-05-25 08:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-25.log
10 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #10
Day Hour Count May 25 03 1 - LOG: database system was shut down at 2026-05-25 03:05:01 -03
Date: 2026-05-25 03:05:03 Log file: /usr/local/pgsql/data/log/serverlog-25.log