pgBadger-
Global information
- Generated on Mon Jul 27 23:50:13 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 9,446 log entries in 12s
- Log start from 2026-07-26 00:00:32 to 2026-07-26 23:59:32
-
Overview
Global Stats
- 143 Number of unique normalized queries
- 893 Number of queries
- 4h15m53s Total query duration
- 2026-07-26 00:02:22 First query
- 2026-07-26 23:45:24 Last query
- 4 queries/s at 2026-07-26 23:45:02 Query peak
- 4h15m53s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h15m53s Execute total duration
- 1,540 Number of events
- 10 Number of unique normalized events
- 1,424 Max number of times the same event was reported
- 0 Number of cancellation
- 6 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 10 Number temporary file
- 237.16 MiB Max size of temporary file
- 110.28 MiB Average size of temporary file
- 207 Total number of sessions
- 7 sessions at 2026-07-26 06:04:34 Session peak
- 7d20h17m Total duration of sessions
- 54m34s Average duration of sessions
- 4 Average queries per session
- 1m14s Average queries duration per session
- 53m20s Average idle time per session
- 220 Total number of connections
- 5 connections/s at 2026-07-26 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-26 23:45:02 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-07-26 20:10:37 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-26 23:44:57 Date
Queries duration
Key values
- 4h15m53s 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) Jul 26 00 22 0ms 20s172ms 5s720ms 3s687ms 4s939ms 1m15s 01 12 0ms 3s819ms 1s823ms 3s273ms 3s415ms 4s418ms 02 12 0ms 4s403ms 1s914ms 3s286ms 3s433ms 4s974ms 03 14 0ms 3s922ms 1s707ms 2s933ms 4s196ms 4s717ms 04 12 0ms 3s72ms 1s604ms 2s923ms 3s271ms 3s442ms 05 17 0ms 9m45s 1m7s 7s241ms 2m36s 9m45s 06 23 0ms 19s285ms 3s331ms 2s974ms 5s162ms 30s367ms 07 21 0ms 15m57s 1m8s 3s555ms 2m50s 15m57s 08 22 0ms 5m47s 29s273ms 3s362ms 47s485ms 5m47s 09 21 0ms 5m51s 29s888ms 3s261ms 47s617ms 5m51s 10 21 0ms 5m40s 30s26ms 3s91ms 49s43ms 5m40s 11 21 0ms 5m48s 30s144ms 3s43ms 47s7ms 5m48s 12 21 0ms 5m38s 29s866ms 3s175ms 49s803ms 5m38s 13 21 0ms 5m38s 29s507ms 3s403ms 44s135ms 5m38s 14 22 0ms 5m45s 31s458ms 3s548ms 1m3s 5m45s 15 21 0ms 5m42s 29s382ms 3s108ms 45s749ms 5m42s 16 21 0ms 5m37s 29s365ms 3s32ms 46s279ms 5m37s 17 21 0ms 5m37s 29s284ms 3s166ms 45s281ms 5m37s 18 23 0ms 5m44s 26s734ms 3s342ms 43s691ms 5m44s 19 21 0ms 5m27s 28s504ms 3s494ms 14s751ms 5m58s 20 116 0ms 8m48s 12s722ms 1m14s 2m10s 8m48s 21 22 0ms 8m9s 34s340ms 3s92ms 3s564ms 8m53s 22 21 0ms 5m26s 28s295ms 3s283ms 15s237ms 5m55s 23 345 0ms 1m24s 6s131ms 1m6s 1m13s 1m51s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 26 00 4 0 7s687ms 0ms 0ms 440ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 238ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 8 0 3s748ms 0ms 0ms 1s733ms 07 9 0 2m37s 0ms 0ms 4m46s 08 7 0 1m28s 0ms 0ms 3m42s 09 6 0 1m40s 0ms 0ms 3m26s 10 6 0 1m41s 0ms 0ms 3m38s 11 6 0 1m41s 0ms 0ms 3m35s 12 6 0 1m40s 0ms 0ms 3m35s 13 6 0 1m39s 0ms 0ms 3m33s 14 6 0 1m41s 0ms 0ms 3m33s 15 6 0 1m39s 0ms 0ms 3m28s 16 6 0 1m39s 0ms 0ms 3m30s 17 6 0 1m38s 0ms 0ms 3m30s 18 8 0 1m14s 0ms 0ms 3m21s 19 6 0 1m35s 0ms 0ms 3m22s 20 15 84 14s545ms 25s788ms 1m14s 3m46s 21 6 0 2m2s 0ms 0ms 3m19s 22 6 0 1m35s 0ms 0ms 3m21s 23 22 323 6s131ms 1m1s 1m6s 1m29s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 26 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 Jul 26 00 0 1 1.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 1 1.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 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 4 4.00 0.00% Day Hour Count Average / Second Jul 26 00 14 0.00/s 01 7 0.00/s 02 6 0.00/s 03 16 0.00/s 04 7 0.00/s 05 9 0.00/s 06 14 0.00/s 07 12 0.00/s 08 9 0.00/s 09 6 0.00/s 10 9 0.00/s 11 8 0.00/s 12 7 0.00/s 13 8 0.00/s 14 9 0.00/s 15 9 0.00/s 16 8 0.00/s 17 8 0.00/s 18 7 0.00/s 19 7 0.00/s 20 11 0.00/s 21 7 0.00/s 22 8 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time Jul 26 00 7 56m8s 55m50s 01 13 1h41s 1h40s 02 6 1h 59m56s 03 14 17m14s 17m13s 04 7 1h3m 1h2m57s 05 7 1h33s 57m49s 06 9 58m22s 58m14s 07 13 1h41s 58m51s 08 10 57m36s 56m32s 09 7 1h25s 58m56s 10 7 53m17s 51m47s 11 8 57m52s 56m33s 12 8 1h42s 59m24s 13 7 1h5s 58m37s 14 7 1h1m21s 59m42s 15 8 1h27s 59m10s 16 8 1h1m7s 59m50s 17 8 1h42s 59m25s 18 7 1h1s 58m33s 19 7 1h47s 59m21s 20 10 43m47s 41m20s 21 8 1h 58m25s 22 7 1h46s 59m22s 23 14 36m48s 34m17s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-26 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 220 connections Total
Connections per user
Key values
- intelifix Main User
- 220 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-07-26 06:04:34 Date
Histogram of session times
Key values
- 179 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 207 sessions Total
Sessions per user
Key values
- intelifix Main User
- 207 sessions Total
Sessions per host
Key values
- [local] Main Host
- 207 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 9,961 buffers Checkpoint Peak
- 2026-07-26 03:05:01 Date
- 269.367 seconds Highest write time
- 0.035 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-07-26 03:05:01 Date
Checkpoints distance
Key values
- 101.49 Mo Distance Peak
- 2026-07-26 03:05:01 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 26 00 8,465 269.287s 0.008s 269.308s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 9,961 0.549s 0.006s 0.573s 04 0 0s 0s 0s 05 6,283 635.217s 0.059s 635.359s 06 4,169 387.184s 0.006s 387.206s 07 39 4.019s 0.014s 4.063s 08 22 2.231s 0.003s 2.24s 09 22 2.23s 0.004s 2.24s 10 21 2.128s 0.004s 2.137s 11 22 2.231s 0.003s 2.24s 12 22 2.23s 0.003s 2.239s 13 21 2.127s 0.003s 2.136s 14 22 2.232s 0.003s 2.24s 15 22 2.231s 0.003s 2.239s 16 21 2.134s 0.003s 2.142s 17 22 2.232s 0.004s 2.242s 18 790 79.27s 0.01s 79.305s 19 22 2.229s 0.003s 2.239s 20 73 7.405s 0.013s 7.436s 21 22 2.213s 0.003s 2.221s 22 23 2.351s 0.006s 2.368s 23 144 14.566s 0.01s 14.595s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 26 00 0 0 2 38 0.002s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 26 0.002s 0.002s 04 0 0 0 0 0s 0s 05 0 0 3 158 0.012s 0.007s 06 0 0 1 33 0.002s 0.002s 07 0 0 0 17 0.004s 0.009s 08 0 0 0 3 0.002s 0.001s 09 0 0 0 3 0.003s 0.002s 10 0 0 0 3 0.003s 0.002s 11 0 0 0 3 0.002s 0.001s 12 0 0 0 3 0.002s 0.001s 13 0 0 0 3 0.002s 0.001s 14 0 0 0 3 0.002s 0.001s 15 0 0 0 3 0.002s 0.001s 16 0 0 0 3 0.002s 0.001s 17 0 0 0 3 0.002s 0.002s 18 0 0 0 55 0.002s 0.004s 19 0 0 0 3 0.002s 0.001s 20 0 0 0 23 0.003s 0.005s 21 0 0 0 3 0.002s 0.001s 22 0 0 0 5 0.002s 0.003s 23 0 0 0 69 0.003s 0.006s Day Hour Count Avg time (sec) Jul 26 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 Jul 26 00 41,087.00 kB 41,087.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 25,982.50 kB 25,982.50 kB 04 0.00 kB 0.00 kB 05 7,686.67 kB 11,666.83 kB 06 6,046.00 kB 13,407.50 kB 07 45.20 kB 9,593.00 kB 08 171.00 kB 6,945.00 kB 09 171.00 kB 6,268.00 kB 10 171.00 kB 5,658.00 kB 11 171.00 kB 5,109.00 kB 12 171.00 kB 4,616.00 kB 13 171.00 kB 4,171.00 kB 14 171.00 kB 3,771.00 kB 15 171.00 kB 3,411.00 kB 16 171.00 kB 3,087.00 kB 17 171.00 kB 2,796.00 kB 18 675.25 kB 2,378.50 kB 19 171.00 kB 1,852.00 kB 20 196.00 kB 1,478.00 kB 21 171.00 kB 1,171.00 kB 22 85.50 kB 1,017.50 kB 23 121.75 kB 779.50 kB -
Temporary Files
Size of temporary files
Key values
- 474.31 MiB Temp Files size Peak
- 2026-07-26 05:32:08 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-26 05:30:42 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 26 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.08 GiB 110.28 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 921.50 MiB 70.74 MiB 237.16 MiB 115.19 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-26 05:32:18 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-26 05:32:08 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 181.33 MiB 90.66 MiB 90.66 MiB 90.66 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-26 05:30:45 Duration: 43s328ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-26 05:30:42 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 237.16 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-26 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 237.16 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-26 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 90.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-26 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 90.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-26 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 78.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-26 05:32:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 78.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-26 05:32:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 78.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-26 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 70.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-26 05:32:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 70.74 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-26 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 70.74 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-26 05:32:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.34 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-07-26 05:10:40 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.34 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-07-26 05:10:40 Date
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database rio
- 6 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 852 279 1,234,499 168 547 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 134 29 92,723 9 20 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 170 14 91,238 10 24 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,182 88 443,279 75 710 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,289 20 214,483 12 110 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,385 1,305 4,517,039 1,247 7,438 Total 6 6 0 0 0 0 0 9,012 1,735 6,593,261 1,521 8,849 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.34) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
Tuples removed per table
Key values
- pg_catalog.pg_statistic (4280) Main table with removed tuples on database contagem
- 13496 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain contagem.pg_catalog.pg_statistic 1 1 4,280 7,274 0 0 1,011 rio.pg_catalog.pg_statistic 1 1 4,240 7,472 0 0 1,286 brasilia.pg_catalog.pg_statistic 1 1 4,113 7,332 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 643 678 0 64 221 brasilia.pg_toast.pg_toast_2619 1 1 116 133 0 0 61 contagem.pg_toast.pg_toast_2619 1 1 104 118 0 21 35 Total 6 6 13,496 23,007 0 85 3,686 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (64) Main table with removed pages on database rio
- 85 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_toast.pg_toast_2619 1 1 643 64 contagem.pg_toast.pg_toast_2619 1 1 104 21 brasilia.pg_toast.pg_toast_2619 1 1 116 0 contagem.pg_catalog.pg_statistic 1 1 4280 0 brasilia.pg_catalog.pg_statistic 1 1 4113 0 rio.pg_catalog.pg_statistic 1 1 4240 0 Total 6 6 13,496 85 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 26 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0.34 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
- 146 Total read queries
- 407 Total write queries
Queries by database
Key values
- rio Main database
- 400 Requests
- 2h50m17s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 874 Requests
User Request type Count Duration etiquetas Total 10 5s320ms select 10 5s320ms intelifix Total 874 4h14m48s copy to 407 43m58s others 340 30m14s select 127 3h35s lenon Total 9 59s572ms select 9 59s572ms Duration by user
Key values
- 4h14m48s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 10 5s320ms select 10 5s320ms intelifix Total 874 4h14m48s copy to 407 43m58s others 340 30m14s select 127 3h35s lenon Total 9 59s572ms select 9 59s572ms Queries by host
Key values
- [local] Main host
- 893 Requests
- 4h15m53s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 447 Requests
- 3h31m40s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-26 23:10:01 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 351 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 15m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-26 07:20:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m45s analyze verbose;[ Date: 2026-07-26 05:09:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-26 20:13:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-26 21:13:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-26 09:10:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-26 11:10:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-26 08:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-26 14:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-26 18:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-26 15:10:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-26 10:10:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-26 12:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-26 13:10:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-26 17:10:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-26 16:10:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-26 19:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-26 22:10:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m36s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-07-26 07:28:26 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
19 4m7s analyze verbose;[ Date: 2026-07-26 05:13:54 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m46s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-07-26 20:19:58 - 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 1h52m 48 1s105ms 15m57s 2m20s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 26 07 3 16m44s 5m34s 08 3 6m4s 2m1s 09 3 6m8s 2m2s 10 3 5m58s 1m59s 11 3 6m5s 2m1s 12 3 5m59s 1m59s 13 3 5m55s 1m58s 14 3 6m1s 2m 15 3 5m59s 1m59s 16 3 5m53s 1m57s 17 3 5m53s 1m57s 18 3 6m2s 2m 19 3 5m43s 1m54s 20 3 9m19s 3m6s 21 3 8m25s 2m48s 22 3 5m43s 1m54s [ User: intelifix - Total duration: 1h52m - Times executed: 48 ]
[ Application: psql - Total duration: 1h52m - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-26 07:20:58 Duration: 15m57s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-26 20:13:50 Duration: 8m48s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-26 21:13:11 Duration: 8m9s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
2 1h8m23s 48 192ms 4m36s 1m25s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 26 07 3 6m50s 2m16s 08 3 4m13s 1m24s 09 3 3m56s 1m18s 10 3 4m9s 1m23s 11 3 4m6s 1m22s 12 3 4m4s 1m21s 13 3 3m59s 1m19s 14 3 4m4s 1m21s 15 3 3m56s 1m18s 16 3 4m1s 1m20s 17 3 3m59s 1m19s 18 3 3m47s 1m15s 19 3 3m51s 1m17s 20 3 5m44s 1m54s 21 3 3m47s 1m15s 22 3 3m48s 1m16s [ User: intelifix - Total duration: 1h8m23s - Times executed: 48 ]
[ Application: psql - Total duration: 1h8m23s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-26 07:28:26 Duration: 4m36s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-26 20:19:58 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-26 08:15:18 Duration: 3m41s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
3 16m28s 3 2m36s 9m45s 5m29s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 26 05 3 16m28s 5m29s [ User: intelifix - Total duration: 16m28s - Times executed: 3 ]
[ Application: psql - Total duration: 16m28s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-26 05:09:47 Duration: 9m45s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
analyze verbose;
Date: 2026-07-26 05:13:54 Duration: 4m7s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
analyze verbose;
Date: 2026-07-26 05:16:30 Duration: 2m36s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
4 8m14s 276 200ms 18s226ms 1s791ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 26 00 12 40s223ms 3s351ms 01 12 21s883ms 1s823ms 02 12 22s974ms 1s914ms 03 12 23s178ms 1s931ms 04 12 19s258ms 1s604ms 05 12 24s239ms 2s19ms 06 12 19s938ms 1s661ms 07 12 20s755ms 1s729ms 08 12 20s25ms 1s668ms 09 12 19s817ms 1s651ms 10 12 19s733ms 1s644ms 11 12 19s87ms 1s590ms 12 12 19s226ms 1s602ms 13 12 19s939ms 1s661ms 14 12 19s506ms 1s625ms 15 12 17s979ms 1s498ms 16 12 19s11ms 1s584ms 17 12 19s225ms 1s602ms 18 12 19s874ms 1s656ms 19 12 20s602ms 1s716ms 20 12 30s408ms 2s534ms 21 12 18s456ms 1s538ms 22 12 19s88ms 1s590ms [ User: intelifix - Total duration: 8m14s - Times executed: 276 ]
[ Application: psql - Total duration: 8m14s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-26 00:05:20 Duration: 18s226ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-26 20:15:15 Duration: 13s697ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-26 05:05:08 Duration: 6s913ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
5 3m3s 4 4s500ms 1m29s 45s758ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 26 20 2 1m34s 47s17ms 23 2 1m28s 44s498ms [ User: intelifix - Total duration: 3m3s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m3s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-26 20:08:37 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-26 23:16:30 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-26 23:35:10 Duration: 4s769ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
6 1m52s 4 375ms 56s505ms 28s51ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 26 20 2 57s43ms 28s521ms 23 2 55s162ms 27s581ms [ User: intelifix - Total duration: 1m52s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m52s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-26 20:05:27 Duration: 56s505ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-26 23:13:25 Duration: 54s786ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-26 20:09:55 Duration: 538ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
7 1m32s 1 1m32s 1m32s 1m32s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 26 05 1 1m32s 1m32s [ User: intelifix - Total duration: 1m32s - Times executed: 1 ]
[ Application: psql - Total duration: 1m32s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-26 05:32:18 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-26 05:32:08 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
8 1m27s 6 2s823ms 31s930ms 14s542ms 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 #8
Day Hour Count Duration Avg duration Jul 26 20 3 44s266ms 14s755ms 23 3 42s986ms 14s328ms [ User: intelifix - Total duration: 1m27s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m27s - 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-07-26 23:13:58 Duration: 31s930ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:06:00 Duration: 31s912ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:10:05 Duration: 9s335ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
9 1m20s 6 8s108ms 19s625ms 13s391ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 26 00 3 53s646ms 17s882ms 06 3 26s702ms 8s900ms [ User: intelifix - Total duration: 1m20s - Times executed: 6 ]
[ Application: psql - Total duration: 1m20s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-26 00:05:21 Duration: 19s625ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-26 00:05:55 Duration: 17s786ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-26 00:05:38 Duration: 16s234ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
10 1m12s 6 1s737ms 29s964ms 12s120ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 26 20 3 35s8ms 11s669ms 23 3 37s715ms 12s571ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m12s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-26 23:14:32 Duration: 29s964ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-26 20:06:31 Duration: 26s576ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-26 20:10:12 Duration: 6s446ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
11 1m11s 6 2s661ms 29s679ms 11s984ms 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 #11
Day Hour Count Duration Avg duration Jul 26 20 3 37s663ms 12s554ms 23 3 34s240ms 11s413ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - 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-07-26 20:09:07 Duration: 29s679ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 23:16:56 Duration: 26s151ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 23:35:15 Duration: 5s428ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
12 1m11s 9 757ms 1m3s 7s930ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 26 10 1 757ms 757ms 14 2 1m4s 32s212ms 15 1 1s97ms 1s97ms 17 1 1s45ms 1s45ms 18 1 1s82ms 1s82ms 20 1 965ms 965ms 21 1 966ms 966ms 22 1 1s29ms 1s29ms [ User: intelifix - Total duration: 1m11s - Times executed: 9 ]
[ Application: psql - Total duration: 1m11s - Times executed: 9 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-26 14:41:05 Duration: 1m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-26 15:20:02 Duration: 1s97ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-26 18:20:02 Duration: 1s82ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
13 58s382ms 6 4s148ms 20s172ms 9s730ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 26 00 3 30s309ms 10s103ms 06 3 28s73ms 9s357ms [ User: lenon - Total duration: 58s382ms - Times executed: 6 ]
[ Application: psql - Total duration: 58s382ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-26 00:02:22 Duration: 20s172ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-26 06:02:21 Duration: 19s285ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-26 00:02:32 Duration: 5s757ms Database: contagem User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
14 58s306ms 6 1s467ms 21s30ms 9s717ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 26 20 3 30s361ms 10s120ms 23 3 27s945ms 9s315ms [ User: intelifix - Total duration: 58s306ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s306ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 20:03:17 Duration: 21s30ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 23:11:17 Duration: 18s800ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 20:09:36 Duration: 7s863ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
15 57s272ms 6 1s763ms 19s391ms 9s545ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 26 20 3 28s247ms 9s415ms 23 3 29s24ms 9s674ms [ User: intelifix - Total duration: 57s272ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s272ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 23:10:45 Duration: 19s391ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 20:02:41 Duration: 18s561ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 23:34:11 Duration: 7s870ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
16 55s184ms 6 1s324ms 21s755ms 9s197ms 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 #16
Day Hour Count Duration Avg duration Jul 26 20 3 27s755ms 9s251ms 23 3 27s428ms 9s142ms [ User: intelifix - Total duration: 55s184ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 55s184ms - 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-07-26 23:12:10 Duration: 21s755ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:04:10 Duration: 20s985ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:09:51 Duration: 5s126ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
17 47s744ms 4 3s508ms 20s297ms 11s936ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 26 20 2 23s806ms 11s903ms 23 2 23s938ms 11s969ms [ User: intelifix - Total duration: 47s744ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 47s744ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-26 20:04:31 Duration: 20s297ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-26 23:12:30 Duration: 20s135ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-26 23:34:38 Duration: 3s802ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
18 45s375ms 6 1s305ms 15s242ms 7s562ms 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 #18
Day Hour Count Duration Avg duration Jul 26 20 3 23s568ms 7s856ms 23 3 21s806ms 7s268ms [ User: intelifix - Total duration: 45s375ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 45s375ms - 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-07-26 20:03:32 Duration: 15s242ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 23:11:31 Duration: 14s377ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:09:43 Duration: 7s19ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
19 43s328ms 1 43s328ms 43s328ms 43s328ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 26 05 1 43s328ms 43s328ms [ User: intelifix - Total duration: 43s328ms - Times executed: 1 ]
[ Application: psql - Total duration: 43s328ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-26 05:30:45 Duration: 43s328ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-26 05:30:42 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
20 41s313ms 37 628ms 3s509ms 1s116ms 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 #20
Day Hour Count Duration Avg duration Jul 26 08 3 5s410ms 1s803ms 09 3 2s578ms 859ms 10 2 2s108ms 1s54ms 11 3 2s469ms 823ms 12 3 3s878ms 1s292ms 13 3 4s90ms 1s363ms 14 2 1s522ms 761ms 15 2 1s397ms 698ms 16 3 2s880ms 960ms 17 2 1s638ms 819ms 18 2 1s832ms 916ms 19 3 2s858ms 952ms 20 2 3s950ms 1s975ms 21 2 2s761ms 1s380ms 22 2 1s936ms 968ms [ User: intelifix - Total duration: 41s313ms - Times executed: 37 ]
[ Application: psql - Total duration: 41s313ms - Times executed: 37 ]
-
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-07-26 08:00:04 Duration: 3s509ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:20:04 Duration: 3s193ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 13:20:04 Duration: 2s242ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 276 8m14s 200ms 18s226ms 1s791ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 26 00 12 40s223ms 3s351ms 01 12 21s883ms 1s823ms 02 12 22s974ms 1s914ms 03 12 23s178ms 1s931ms 04 12 19s258ms 1s604ms 05 12 24s239ms 2s19ms 06 12 19s938ms 1s661ms 07 12 20s755ms 1s729ms 08 12 20s25ms 1s668ms 09 12 19s817ms 1s651ms 10 12 19s733ms 1s644ms 11 12 19s87ms 1s590ms 12 12 19s226ms 1s602ms 13 12 19s939ms 1s661ms 14 12 19s506ms 1s625ms 15 12 17s979ms 1s498ms 16 12 19s11ms 1s584ms 17 12 19s225ms 1s602ms 18 12 19s874ms 1s656ms 19 12 20s602ms 1s716ms 20 12 30s408ms 2s534ms 21 12 18s456ms 1s538ms 22 12 19s88ms 1s590ms [ User: intelifix - Total duration: 8m14s - Times executed: 276 ]
[ Application: psql - Total duration: 8m14s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-26 00:05:20 Duration: 18s226ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-26 20:15:15 Duration: 13s697ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-26 05:05:08 Duration: 6s913ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
2 48 1h52m 1s105ms 15m57s 2m20s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 26 07 3 16m44s 5m34s 08 3 6m4s 2m1s 09 3 6m8s 2m2s 10 3 5m58s 1m59s 11 3 6m5s 2m1s 12 3 5m59s 1m59s 13 3 5m55s 1m58s 14 3 6m1s 2m 15 3 5m59s 1m59s 16 3 5m53s 1m57s 17 3 5m53s 1m57s 18 3 6m2s 2m 19 3 5m43s 1m54s 20 3 9m19s 3m6s 21 3 8m25s 2m48s 22 3 5m43s 1m54s [ User: intelifix - Total duration: 1h52m - Times executed: 48 ]
[ Application: psql - Total duration: 1h52m - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-26 07:20:58 Duration: 15m57s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-26 20:13:50 Duration: 8m48s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-26 21:13:11 Duration: 8m9s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
3 48 1h8m23s 192ms 4m36s 1m25s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 26 07 3 6m50s 2m16s 08 3 4m13s 1m24s 09 3 3m56s 1m18s 10 3 4m9s 1m23s 11 3 4m6s 1m22s 12 3 4m4s 1m21s 13 3 3m59s 1m19s 14 3 4m4s 1m21s 15 3 3m56s 1m18s 16 3 4m1s 1m20s 17 3 3m59s 1m19s 18 3 3m47s 1m15s 19 3 3m51s 1m17s 20 3 5m44s 1m54s 21 3 3m47s 1m15s 22 3 3m48s 1m16s [ User: intelifix - Total duration: 1h8m23s - Times executed: 48 ]
[ Application: psql - Total duration: 1h8m23s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-26 07:28:26 Duration: 4m36s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-26 20:19:58 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-26 08:15:18 Duration: 3m41s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
4 37 41s313ms 628ms 3s509ms 1s116ms 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 #4
Day Hour Count Duration Avg duration Jul 26 08 3 5s410ms 1s803ms 09 3 2s578ms 859ms 10 2 2s108ms 1s54ms 11 3 2s469ms 823ms 12 3 3s878ms 1s292ms 13 3 4s90ms 1s363ms 14 2 1s522ms 761ms 15 2 1s397ms 698ms 16 3 2s880ms 960ms 17 2 1s638ms 819ms 18 2 1s832ms 916ms 19 3 2s858ms 952ms 20 2 3s950ms 1s975ms 21 2 2s761ms 1s380ms 22 2 1s936ms 968ms [ User: intelifix - Total duration: 41s313ms - Times executed: 37 ]
[ Application: psql - Total duration: 41s313ms - Times executed: 37 ]
-
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-07-26 08:00:04 Duration: 3s509ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:20:04 Duration: 3s193ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 13:20:04 Duration: 2s242ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
5 9 1m11s 757ms 1m3s 7s930ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 26 10 1 757ms 757ms 14 2 1m4s 32s212ms 15 1 1s97ms 1s97ms 17 1 1s45ms 1s45ms 18 1 1s82ms 1s82ms 20 1 965ms 965ms 21 1 966ms 966ms 22 1 1s29ms 1s29ms [ User: intelifix - Total duration: 1m11s - Times executed: 9 ]
[ Application: psql - Total duration: 1m11s - Times executed: 9 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-26 14:41:05 Duration: 1m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-26 15:20:02 Duration: 1s97ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-26 18:20:02 Duration: 1s82ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
6 7 4s404ms 170ms 1s552ms 629ms select * from rs_etiqueta (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 26 00 1 440ms 440ms 08 1 170ms 170ms 20 1 177ms 177ms 23 4 3s615ms 903ms [ User: etiquetas - Total duration: 4s404ms - Times executed: 7 ]
[ Application: [unknown] - Total duration: 4s404ms - Times executed: 7 ]
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-07-26 23:20:09 Duration: 1s552ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-07-26 23:35:20 Duration: 1s520ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-07-26 00:26:55 Duration: 440ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-26.log
7 6 1m27s 2s823ms 31s930ms 14s542ms 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 #7
Day Hour Count Duration Avg duration Jul 26 20 3 44s266ms 14s755ms 23 3 42s986ms 14s328ms [ User: intelifix - Total duration: 1m27s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m27s - 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-07-26 23:13:58 Duration: 31s930ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:06:00 Duration: 31s912ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:10:05 Duration: 9s335ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
8 6 1m20s 8s108ms 19s625ms 13s391ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 26 00 3 53s646ms 17s882ms 06 3 26s702ms 8s900ms [ User: intelifix - Total duration: 1m20s - Times executed: 6 ]
[ Application: psql - Total duration: 1m20s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-26 00:05:21 Duration: 19s625ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-26 00:05:55 Duration: 17s786ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-26 00:05:38 Duration: 16s234ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
9 6 1m12s 1s737ms 29s964ms 12s120ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 26 20 3 35s8ms 11s669ms 23 3 37s715ms 12s571ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m12s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-26 23:14:32 Duration: 29s964ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-26 20:06:31 Duration: 26s576ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-26 20:10:12 Duration: 6s446ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
10 6 1m11s 2s661ms 29s679ms 11s984ms 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 #10
Day Hour Count Duration Avg duration Jul 26 20 3 37s663ms 12s554ms 23 3 34s240ms 11s413ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - 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-07-26 20:09:07 Duration: 29s679ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 23:16:56 Duration: 26s151ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 23:35:15 Duration: 5s428ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
11 6 58s382ms 4s148ms 20s172ms 9s730ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 26 00 3 30s309ms 10s103ms 06 3 28s73ms 9s357ms [ User: lenon - Total duration: 58s382ms - Times executed: 6 ]
[ Application: psql - Total duration: 58s382ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-26 00:02:22 Duration: 20s172ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-26 06:02:21 Duration: 19s285ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-26 00:02:32 Duration: 5s757ms Database: contagem User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
12 6 58s306ms 1s467ms 21s30ms 9s717ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 26 20 3 30s361ms 10s120ms 23 3 27s945ms 9s315ms [ User: intelifix - Total duration: 58s306ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s306ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 20:03:17 Duration: 21s30ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 23:11:17 Duration: 18s800ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 20:09:36 Duration: 7s863ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
13 6 57s272ms 1s763ms 19s391ms 9s545ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 26 20 3 28s247ms 9s415ms 23 3 29s24ms 9s674ms [ User: intelifix - Total duration: 57s272ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s272ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 23:10:45 Duration: 19s391ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 20:02:41 Duration: 18s561ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 23:34:11 Duration: 7s870ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
14 6 55s184ms 1s324ms 21s755ms 9s197ms 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 #14
Day Hour Count Duration Avg duration Jul 26 20 3 27s755ms 9s251ms 23 3 27s428ms 9s142ms [ User: intelifix - Total duration: 55s184ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 55s184ms - 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-07-26 23:12:10 Duration: 21s755ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:04:10 Duration: 20s985ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:09:51 Duration: 5s126ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
15 6 45s375ms 1s305ms 15s242ms 7s562ms 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 #15
Day Hour Count Duration Avg duration Jul 26 20 3 23s568ms 7s856ms 23 3 21s806ms 7s268ms [ User: intelifix - Total duration: 45s375ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 45s375ms - 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-07-26 20:03:32 Duration: 15s242ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 23:11:31 Duration: 14s377ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:09:43 Duration: 7s19ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
16 6 34s778ms 845ms 14s476ms 5s796ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 26 20 3 17s781ms 5s927ms 23 3 16s997ms 5s665ms [ User: intelifix - Total duration: 34s778ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 34s778ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-26 20:02:56 Duration: 14s476ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-26 23:10:58 Duration: 13s459ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-26 23:34:14 Duration: 2s668ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
17 6 31s834ms 2s754ms 8s28ms 5s305ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 26 20 3 17s647ms 5s882ms 23 3 14s187ms 4s729ms [ User: intelifix - Total duration: 31s834ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 31s834ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-26 20:06:56 Duration: 8s28ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-26 20:10:22 Duration: 6s574ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-26 23:35:04 Duration: 6s306ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
18 6 26s718ms 860ms 10s352ms 4s453ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 26 20 3 13s222ms 4s407ms 23 3 13s496ms 4s498ms [ User: intelifix - Total duration: 26s718ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 26s718ms - Times executed: 6 ]
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-07-26 23:10:22 Duration: 10s352ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-07-26 20:02:19 Duration: 9s916ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-07-26 20:09:18 Duration: 2s445ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
19 6 26s408ms 749ms 11s563ms 4s401ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 26 20 3 13s229ms 4s409ms 23 3 13s179ms 4s393ms [ User: intelifix - Total duration: 26s408ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 26s408ms - Times executed: 6 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-07-26 23:11:48 Duration: 11s563ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-07-26 20:03:49 Duration: 11s557ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-07-26 23:34:30 Duration: 867ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
20 6 15s283ms 505ms 5s169ms 2s547ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 26 20 3 7s612ms 2s537ms 23 3 7s671ms 2s557ms [ User: intelifix - Total duration: 15s283ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 15s283ms - Times executed: 6 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-07-26 20:03:38 Duration: 5s169ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-07-26 23:11:37 Duration: 5s158ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-07-26 20:09:45 Duration: 1s938ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m36s 9m45s 5m29s 3 16m28s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 26 05 3 16m28s 5m29s [ User: intelifix - Total duration: 16m28s - Times executed: 3 ]
[ Application: psql - Total duration: 16m28s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-26 05:09:47 Duration: 9m45s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
analyze verbose;
Date: 2026-07-26 05:13:54 Duration: 4m7s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
analyze verbose;
Date: 2026-07-26 05:16:30 Duration: 2m36s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
2 1s105ms 15m57s 2m20s 48 1h52m select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 26 07 3 16m44s 5m34s 08 3 6m4s 2m1s 09 3 6m8s 2m2s 10 3 5m58s 1m59s 11 3 6m5s 2m1s 12 3 5m59s 1m59s 13 3 5m55s 1m58s 14 3 6m1s 2m 15 3 5m59s 1m59s 16 3 5m53s 1m57s 17 3 5m53s 1m57s 18 3 6m2s 2m 19 3 5m43s 1m54s 20 3 9m19s 3m6s 21 3 8m25s 2m48s 22 3 5m43s 1m54s [ User: intelifix - Total duration: 1h52m - Times executed: 48 ]
[ Application: psql - Total duration: 1h52m - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-26 07:20:58 Duration: 15m57s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-26 20:13:50 Duration: 8m48s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-26 21:13:11 Duration: 8m9s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
3 1m32s 1m32s 1m32s 1 1m32s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 26 05 1 1m32s 1m32s [ User: intelifix - Total duration: 1m32s - Times executed: 1 ]
[ Application: psql - Total duration: 1m32s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-26 05:32:18 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-26 05:32:08 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 192ms 4m36s 1m25s 48 1h8m23s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 26 07 3 6m50s 2m16s 08 3 4m13s 1m24s 09 3 3m56s 1m18s 10 3 4m9s 1m23s 11 3 4m6s 1m22s 12 3 4m4s 1m21s 13 3 3m59s 1m19s 14 3 4m4s 1m21s 15 3 3m56s 1m18s 16 3 4m1s 1m20s 17 3 3m59s 1m19s 18 3 3m47s 1m15s 19 3 3m51s 1m17s 20 3 5m44s 1m54s 21 3 3m47s 1m15s 22 3 3m48s 1m16s [ User: intelifix - Total duration: 1h8m23s - Times executed: 48 ]
[ Application: psql - Total duration: 1h8m23s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-26 07:28:26 Duration: 4m36s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-26 20:19:58 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-26 08:15:18 Duration: 3m41s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
5 4s500ms 1m29s 45s758ms 4 3m3s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 26 20 2 1m34s 47s17ms 23 2 1m28s 44s498ms [ User: intelifix - Total duration: 3m3s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m3s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-26 20:08:37 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-26 23:16:30 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-26 23:35:10 Duration: 4s769ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
6 43s328ms 43s328ms 43s328ms 1 43s328ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 26 05 1 43s328ms 43s328ms [ User: intelifix - Total duration: 43s328ms - Times executed: 1 ]
[ Application: psql - Total duration: 43s328ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-26 05:30:45 Duration: 43s328ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-26 05:30:42 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
7 375ms 56s505ms 28s51ms 4 1m52s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 26 20 2 57s43ms 28s521ms 23 2 55s162ms 27s581ms [ User: intelifix - Total duration: 1m52s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m52s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-26 20:05:27 Duration: 56s505ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-26 23:13:25 Duration: 54s786ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-26 20:09:55 Duration: 538ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
8 2s823ms 31s930ms 14s542ms 6 1m27s 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 #8
Day Hour Count Duration Avg duration Jul 26 20 3 44s266ms 14s755ms 23 3 42s986ms 14s328ms [ User: intelifix - Total duration: 1m27s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m27s - 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-07-26 23:13:58 Duration: 31s930ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:06:00 Duration: 31s912ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:10:05 Duration: 9s335ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
9 8s108ms 19s625ms 13s391ms 6 1m20s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 26 00 3 53s646ms 17s882ms 06 3 26s702ms 8s900ms [ User: intelifix - Total duration: 1m20s - Times executed: 6 ]
[ Application: psql - Total duration: 1m20s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-26 00:05:21 Duration: 19s625ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-26 00:05:55 Duration: 17s786ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-26 00:05:38 Duration: 16s234ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
10 1s737ms 29s964ms 12s120ms 6 1m12s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 26 20 3 35s8ms 11s669ms 23 3 37s715ms 12s571ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m12s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-26 23:14:32 Duration: 29s964ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-26 20:06:31 Duration: 26s576ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-26 20:10:12 Duration: 6s446ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
11 2s661ms 29s679ms 11s984ms 6 1m11s 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 #11
Day Hour Count Duration Avg duration Jul 26 20 3 37s663ms 12s554ms 23 3 34s240ms 11s413ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - 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-07-26 20:09:07 Duration: 29s679ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 23:16:56 Duration: 26s151ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 23:35:15 Duration: 5s428ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
12 3s508ms 20s297ms 11s936ms 4 47s744ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 26 20 2 23s806ms 11s903ms 23 2 23s938ms 11s969ms [ User: intelifix - Total duration: 47s744ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 47s744ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-26 20:04:31 Duration: 20s297ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-26 23:12:30 Duration: 20s135ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-26 23:34:38 Duration: 3s802ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
13 4s148ms 20s172ms 9s730ms 6 58s382ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 26 00 3 30s309ms 10s103ms 06 3 28s73ms 9s357ms [ User: lenon - Total duration: 58s382ms - Times executed: 6 ]
[ Application: psql - Total duration: 58s382ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-26 00:02:22 Duration: 20s172ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-26 06:02:21 Duration: 19s285ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-26 00:02:32 Duration: 5s757ms Database: contagem User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
14 1s467ms 21s30ms 9s717ms 6 58s306ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 26 20 3 30s361ms 10s120ms 23 3 27s945ms 9s315ms [ User: intelifix - Total duration: 58s306ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s306ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 20:03:17 Duration: 21s30ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 23:11:17 Duration: 18s800ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 20:09:36 Duration: 7s863ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
15 1s763ms 19s391ms 9s545ms 6 57s272ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 26 20 3 28s247ms 9s415ms 23 3 29s24ms 9s674ms [ User: intelifix - Total duration: 57s272ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s272ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 23:10:45 Duration: 19s391ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 20:02:41 Duration: 18s561ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-26 23:34:11 Duration: 7s870ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
16 1s324ms 21s755ms 9s197ms 6 55s184ms 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 #16
Day Hour Count Duration Avg duration Jul 26 20 3 27s755ms 9s251ms 23 3 27s428ms 9s142ms [ User: intelifix - Total duration: 55s184ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 55s184ms - 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-07-26 23:12:10 Duration: 21s755ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:04:10 Duration: 20s985ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:09:51 Duration: 5s126ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
17 757ms 1m3s 7s930ms 9 1m11s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 26 10 1 757ms 757ms 14 2 1m4s 32s212ms 15 1 1s97ms 1s97ms 17 1 1s45ms 1s45ms 18 1 1s82ms 1s82ms 20 1 965ms 965ms 21 1 966ms 966ms 22 1 1s29ms 1s29ms [ User: intelifix - Total duration: 1m11s - Times executed: 9 ]
[ Application: psql - Total duration: 1m11s - Times executed: 9 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-26 14:41:05 Duration: 1m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-26 15:20:02 Duration: 1s97ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-26 18:20:02 Duration: 1s82ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
18 1s305ms 15s242ms 7s562ms 6 45s375ms 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 #18
Day Hour Count Duration Avg duration Jul 26 20 3 23s568ms 7s856ms 23 3 21s806ms 7s268ms [ User: intelifix - Total duration: 45s375ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 45s375ms - 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-07-26 20:03:32 Duration: 15s242ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 23:11:31 Duration: 14s377ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 20:09:43 Duration: 7s19ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
19 845ms 14s476ms 5s796ms 6 34s778ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 26 20 3 17s781ms 5s927ms 23 3 16s997ms 5s665ms [ User: intelifix - Total duration: 34s778ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 34s778ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-26 20:02:56 Duration: 14s476ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-26 23:10:58 Duration: 13s459ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-26 23:34:14 Duration: 2s668ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
20 2s754ms 8s28ms 5s305ms 6 31s834ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 26 20 3 17s647ms 5s882ms 23 3 14s187ms 4s729ms [ User: intelifix - Total duration: 31s834ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 31s834ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-26 20:06:56 Duration: 8s28ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-26 20:10:22 Duration: 6s574ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-26 23:35:04 Duration: 6s306ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 9 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 26 10 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 21 3 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 3m30s - Times executed: 9 ]
[ Application: psql - Total duration: 3m30s - Times executed: 9 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 5,089 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 21 FATAL entries
- 1518 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,424 Max number of times the same event was reported
- 1,540 Total events found
Rank Times reported Error 1 1,424 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 26 00 59 01 59 02 59 03 59 04 60 05 59 06 59 07 60 08 59 09 59 10 60 11 59 12 59 13 60 14 59 15 60 16 59 17 60 18 59 19 59 20 60 21 59 22 60 23 59 - ERROR: prepared statement "_PLAN000000002E955800" does not exist
- ERROR: prepared statement "_PLAN000000002E94F830" does not exist
- ERROR: prepared statement "_PLAN000000002E955370" does not exist
Statement: DEALLOCATE "_PLAN000000002E955800"
Date: 2026-07-26 00:00:32 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Statement: DEALLOCATE "_PLAN000000002E94F830"
Date: 2026-07-26 00:01:33 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Statement: DEALLOCATE "_PLAN000000002E955370"
Date: 2026-07-26 00:02:34 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
2 45 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 26 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 1 19 2 20 2 21 2 22 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'
- 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-07-26 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.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-07-26 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
3 44 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 26 08 3 09 3 10 3 11 3 12 3 13 3 14 2 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-26 08:00:06 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-26 08:20:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-26 08:40:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
4 12 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 26 00 1 01 1 03 1 06 1 07 2 08 2 13 1 15 1 17 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-26 00:02:32 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Date: 2026-07-26 01:22:51 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Date: 2026-07-26 03:34:12 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
5 6 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 26 03 6 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-26 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Date: 2026-07-26 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Date: 2026-07-26 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
6 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 26 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-07-26 05:32:18 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-26 05:32:18 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-26 05:32:18 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
7 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 26 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-26 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Date: 2026-07-26 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
8 1 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 26 18 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' 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
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-26 18:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
9 1 FATAL: database "..." does not exist /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(
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 26 14 1 - FATAL: database "jaboatao" does not exist /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-07-26 14:59:23 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
10 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 26 03 1 - LOG: database system was shut down at 2026-07-26 03:05:01 -03
Date: 2026-07-26 03:05:03 Log file: /usr/local/pgsql/data/log/serverlog-26.log