pgBadger-
Global information
- Generated on Mon Jul 6 23:50:13 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 16,090 log entries in 11s
- Log start from 2026-07-05 00:00:23 to 2026-07-05 23:59:32
-
Overview
Global Stats
- 140 Number of unique normalized queries
- 852 Number of queries
- 4h5m1s Total query duration
- 2026-07-05 00:02:05 First query
- 2026-07-05 23:47:06 Last query
- 5 queries/s at 2026-07-05 23:46:33 Query peak
- 4h5m1s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h5m1s Execute total duration
- 2,908 Number of events
- 10 Number of unique normalized events
- 2,799 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
- 233.36 MiB Max size of temporary file
- 108.52 MiB Average size of temporary file
- 247 Total number of sessions
- 7 sessions at 2026-07-05 01:05:02 Session peak
- 9d14h57m22s Total duration of sessions
- 56m6s Average duration of sessions
- 3 Average queries per session
- 59s521ms Average queries duration per session
- 55m6s Average idle time per session
- 249 Total number of connections
- 5 connections/s at 2026-07-05 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-05 23:46:33 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-07-05 06:02:05 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-05 23:46:33 Date
Queries duration
Key values
- 4h5m1s 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 05 00 21 0ms 21s467ms 4s822ms 3s549ms 4s494ms 1m16s 01 10 0ms 4s915ms 2s527ms 3s491ms 4s293ms 4s915ms 02 11 0ms 3s928ms 2s64ms 3s428ms 3s784ms 4s346ms 03 14 0ms 4s24ms 1s635ms 3s99ms 4s52ms 4s898ms 04 11 0ms 4s249ms 2s23ms 2s839ms 4s235ms 4s600ms 05 16 0ms 8m52s 1m6s 3s430ms 2m25s 8m52s 06 18 0ms 10s99ms 2s857ms 3s505ms 3s711ms 29s826ms 07 17 0ms 13m56s 1m11s 3s859ms 1m46s 13m56s 08 20 0ms 5m36s 30s406ms 3s831ms 45s714ms 5m36s 09 20 0ms 5m36s 30s436ms 3s596ms 47s784ms 5m36s 10 20 0ms 5m35s 30s249ms 3s522ms 44s521ms 5m35s 11 20 0ms 5m43s 31s211ms 3s985ms 45s416ms 5m43s 12 20 0ms 5m41s 30s405ms 3s614ms 45s245ms 5m41s 13 20 0ms 5m37s 30s556ms 4s378ms 45s529ms 5m37s 14 19 0ms 5m49s 32s814ms 3s845ms 48s103ms 5m49s 15 21 0ms 5m42s 29s245ms 3s884ms 45s72ms 5m42s 16 19 0ms 5m27s 30s955ms 3s691ms 16s807ms 5m57s 17 19 0ms 5m49s 32s730ms 3s279ms 44s826ms 5m49s 18 23 0ms 5m48s 26s647ms 3s505ms 42s640ms 5m48s 19 20 0ms 5m37s 30s474ms 3s924ms 49s964ms 5m37s 20 110 0ms 7m8s 12s134ms 1m3s 1m50s 7m8s 21 20 0ms 7m30s 35s606ms 3s766ms 43s386ms 7m30s 22 19 0ms 5m20s 30s393ms 3s556ms 14s2ms 5m47s 23 344 0ms 1m27s 6s438ms 1m7s 1m27s 2m12s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 05 00 4 0 1s195ms 0ms 0ms 287ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 166ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 1s180ms 0ms 0ms 0ms 07 6 0 3m20s 0ms 0ms 3m36s 08 6 0 1m36s 0ms 0ms 3m17s 09 6 0 1m37s 0ms 0ms 3m20s 10 6 0 1m36s 0ms 0ms 3m20s 11 6 0 1m39s 0ms 0ms 3m27s 12 6 0 1m37s 0ms 0ms 3m17s 13 6 0 1m36s 0ms 0ms 3m19s 14 6 0 1m39s 0ms 0ms 3m20s 15 6 0 1m38s 0ms 0ms 3m20s 16 6 0 1m33s 0ms 0ms 3m8s 17 6 0 1m39s 0ms 0ms 3m22s 18 9 0 1m5s 0ms 0ms 3m15s 19 6 0 1m37s 0ms 0ms 3m16s 20 13 83 13s559ms 24s690ms 59s510ms 3m45s 21 6 0 1m54s 0ms 0ms 3m13s 22 6 0 1m32s 0ms 0ms 3m13s 23 17 327 6s438ms 1m2s 1m7s 2m2s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 05 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 05 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.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 2 2.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 05 00 17 0.00/s 01 10 0.00/s 02 9 0.00/s 03 19 0.01/s 04 9 0.00/s 05 10 0.00/s 06 15 0.00/s 07 10 0.00/s 08 7 0.00/s 09 10 0.00/s 10 10 0.00/s 11 10 0.00/s 12 9 0.00/s 13 9 0.00/s 14 10 0.00/s 15 10 0.00/s 16 9 0.00/s 17 10 0.00/s 18 9 0.00/s 19 9 0.00/s 20 13 0.00/s 21 9 0.00/s 22 9 0.00/s 23 7 0.00/s Day Hour Count Average Duration Average idle time Jul 05 00 4 1h 59m35s 01 16 1h1m5s 1h1m3s 02 10 1h 59m58s 03 18 21m3s 21m2s 04 10 1h3m54s 1h3m51s 05 9 1h20s 58m22s 06 10 58m30s 58m25s 07 14 1h38s 59m11s 08 10 57m 55m59s 09 7 1h55s 59m28s 10 10 1h1m27s 1h27s 11 10 1h 58m57s 12 10 1h57s 59m57s 13 9 1h57s 59m49s 14 9 1h39s 59m29s 15 11 55m44s 54m48s 16 9 1h56s 59m50s 17 9 59m26s 58m17s 18 10 1h36s 59m35s 19 9 1h37s 59m29s 20 12 45m51s 44m 21 10 1h1m18s 1h7s 22 9 1h1s 58m57s 23 12 48m5s 45m1s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-05 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 249 connections Total
Connections per user
Key values
- intelifix Main User
- 249 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-07-05 01:05:02 Date
Histogram of session times
Key values
- 219 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 247 sessions Total
Sessions per user
Key values
- intelifix Main User
- 247 sessions Total
Sessions per host
Key values
- [local] Main Host
- 247 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 10,061 buffers Checkpoint Peak
- 2026-07-05 03:05:02 Date
- 269.120 seconds Highest write time
- 0.011 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-07-05 03:05:02 Date
Checkpoints distance
Key values
- 113.93 Mo Distance Peak
- 2026-07-05 03:05:02 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 05 00 4,845 269.12s 0.011s 269.143s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 10,061 0.652s 0.009s 0.681s 04 1 0.123s 0.001s 0.134s 05 6,312 635.315s 0.027s 635.383s 06 2,306 231.07s 0.003s 231.09s 07 1,122 112.382s 0.006s 112.4s 08 21 2.131s 0.004s 2.14s 09 22 2.253s 0.006s 2.27s 10 21 2.131s 0.004s 2.14s 11 21 2.131s 0.003s 2.141s 12 21 2.131s 0.003s 2.142s 13 21 2.125s 0.003s 2.134s 14 21 2.13s 0.003s 2.139s 15 21 2.133s 0.004s 2.142s 16 21 2.132s 0.004s 2.142s 17 21 2.131s 0.004s 2.141s 18 851 85.399s 0.009s 85.432s 19 27 2.734s 0.003s 2.742s 20 85 8.578s 0.008s 8.602s 21 21 2.127s 0.004s 2.137s 22 21 2.131s 0.003s 2.14s 23 0 0.08s 0.005s 0.108s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 05 00 0 0 2 28 0.002s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 36 0.003s 0.003s 04 0 0 0 1 0.001s 0.001s 05 0 0 3 140 0.002s 0.006s 06 0 0 0 9 0.001s 0.001s 07 0 0 1 18 0.002s 0.002s 08 0 0 0 3 0.002s 0.002s 09 0 0 0 5 0.002s 0.003s 10 0 0 0 3 0.002s 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.003s 0.002s 16 0 0 0 3 0.002s 0.002s 17 0 0 0 3 0.002s 0.002s 18 0 0 0 75 0.002s 0.004s 19 0 0 0 4 0.002s 0.001s 20 0 0 0 11 0.002s 0.003s 21 0 0 0 3 0.002s 0.002s 22 0 0 0 3 0.002s 0.001s 23 0 0 0 4 0.002s 0.005s Day Hour Count Avg time (sec) Jul 05 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 05 00 22,764.00 kB 22,764.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 29,165.00 kB 29,165.00 kB 04 1.00 kB 1.00 kB 05 7,643.50 kB 11,944.33 kB 06 4,966.00 kB 13,003.00 kB 07 2,932.50 kB 11,669.00 kB 08 166.00 kB 9,972.00 kB 09 83.00 kB 8,541.50 kB 10 166.00 kB 7,299.00 kB 11 166.00 kB 6,586.00 kB 12 166.00 kB 5,944.00 kB 13 166.00 kB 5,366.00 kB 14 166.00 kB 4,846.00 kB 15 166.00 kB 4,378.00 kB 16 166.00 kB 3,957.00 kB 17 166.00 kB 3,578.00 kB 18 1,132.00 kB 3,545.25 kB 19 179.00 kB 2,751.00 kB 20 250.00 kB 2,276.00 kB 21 166.00 kB 1,884.00 kB 22 166.00 kB 1,712.00 kB 23 40.25 kB 1,333.75 kB -
Temporary Files
Size of temporary files
Key values
- 466.72 MiB Temp Files size Peak
- 2026-07-05 05:31:58 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-05 05:32:04 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 05 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.06 GiB 108.52 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 906.76 MiB 69.61 MiB 233.36 MiB 113.35 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-05 05:32:06 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-05 05:31:58 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 178.47 MiB 89.23 MiB 89.23 MiB 89.23 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-05 05:30:43 Duration: 40s709ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-05 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 233.36 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-05 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 233.36 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-05 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 89.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-05 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 89.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-05 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 77.10 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-05 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 77.03 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-05 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 77.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-05 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 69.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-05 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 69.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-05 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 69.61 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-05 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.23 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-07-05 05:09:41 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.23 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-07-05 05:09:41 Date
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_statistic (1) Main table vacuumed on database contagem
- 6 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,319 846 2,679,271 811 5,763 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,184 337 1,620,411 313 1,967 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,439 71 410,984 61 518 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 160 26 71,736 1 3 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 134 34 112,610 9 24 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 882 119 726,294 48 245 Total 6 6 0 0 0 0 0 9,118 1,433 5,621,306 1,243 8,520 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.23) 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 (4508) Main table with removed tuples on database rio
- 13558 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,508 7,458 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,344 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,824 7,332 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 677 673 0 22 270 brasilia.pg_toast.pg_toast_2619 1 1 106 136 0 36 39 contagem.pg_toast.pg_toast_2619 1 1 99 114 0 14 39 Total 6 6 13,558 22,987 0 72 3,717 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (36) Main table with removed pages on database brasilia
- 72 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed brasilia.pg_toast.pg_toast_2619 1 1 106 36 rio.pg_toast.pg_toast_2619 1 1 677 22 contagem.pg_toast.pg_toast_2619 1 1 99 14 contagem.pg_catalog.pg_statistic 1 1 4344 0 rio.pg_catalog.pg_statistic 1 1 4508 0 brasilia.pg_catalog.pg_statistic 1 1 3824 0 Total 6 6 13,558 72 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 05 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.23 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
- 131 Total read queries
- 410 Total write queries
Queries by database
Key values
- rio Main database
- 384 Requests
- 2h45m48s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 837 Requests
User Request type Count Duration etiquetas Total 9 3s383ms select 9 3s383ms intelifix Total 837 4h4m50s copy to 410 45m23s others 311 28m25s select 116 2h51m lenon Total 6 8s36ms select 6 8s36ms Duration by user
Key values
- 4h4m50s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 9 3s383ms select 9 3s383ms intelifix Total 837 4h4m50s copy to 410 45m23s others 311 28m25s select 116 2h51m lenon Total 6 8s36ms select 6 8s36ms Queries by host
Key values
- [local] Main host
- 852 Requests
- 4h5m1s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 427 Requests
- 3h19m30s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-05 02:40:46 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 365 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 13m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-05 07:18:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m52s analyze verbose;[ Date: 2026-07-05 05:08:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-05 21:12:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-05 20:12:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-05 17:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-05 14:10:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-05 18:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-05 11:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-05 15:10:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-05 12:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-05 19:10:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-05 13:10:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-05 08:10:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-05 09:10:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-05 10:10:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-05 16:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-05 22:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m analyze verbose;[ Date: 2026-07-05 05:12:54 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
19 3m39s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-07-05 20:18:01 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m36s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-07-05 07:24:56 - 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 1h47m10s 48 1s115ms 13m56s 2m13s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 05 07 3 14m37s 4m52s 08 3 5m53s 1m57s 09 3 5m55s 1m58s 10 3 5m51s 1m57s 11 3 6m 2m 12 3 5m58s 1m59s 13 3 5m54s 1m58s 14 3 6m6s 2m2s 15 3 6m 2m 16 3 5m46s 1m55s 17 3 6m5s 2m1s 18 3 6m3s 2m1s 19 3 5m55s 1m58s 20 3 7m38s 2m32s 21 3 7m45s 2m35s 22 3 5m36s 1m52s [ User: intelifix - Total duration: 1h47m10s - Times executed: 48 ]
[ Application: psql - Total duration: 1h47m10s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-05 07:18:58 Duration: 13m56s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-05 21:12:32 Duration: 7m30s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-05 20:12:10 Duration: 7m8s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
2 1h3m43s 48 183ms 3m39s 1m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 05 07 3 5m24s 1m48s 08 3 3m46s 1m15s 09 3 3m48s 1m16s 10 3 3m48s 1m16s 11 3 3m55s 1m18s 12 3 3m45s 1m15s 13 3 3m47s 1m15s 14 3 3m51s 1m17s 15 3 3m47s 1m15s 16 3 3m37s 1m12s 17 3 3m51s 1m17s 18 3 3m43s 1m14s 19 3 3m48s 1m16s 20 3 5m27s 1m49s 21 3 3m41s 1m13s 22 3 3m37s 1m12s [ User: intelifix - Total duration: 1h3m43s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m43s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-05 20:18:01 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-05 07:24:56 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-05 11:14:56 Duration: 3m25s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
3 15m14s 3 2m20s 8m52s 5m4s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 05 05 3 15m14s 5m4s [ User: intelifix - Total duration: 15m14s - Times executed: 3 ]
[ Application: psql - Total duration: 15m14s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-05 05:08:54 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
analyze verbose;
Date: 2026-07-05 05:12:54 Duration: 4m Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
analyze verbose;
Date: 2026-07-05 05:15:15 Duration: 2m20s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
4 8m52s 251 150ms 17s700ms 2s120ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 05 00 11 39s350ms 3s577ms 01 10 25s276ms 2s527ms 02 11 22s712ms 2s64ms 03 12 22s388ms 1s865ms 04 11 22s260ms 2s23ms 05 11 20s737ms 1s885ms 06 12 21s554ms 1s796ms 07 11 21s2ms 1s909ms 08 11 21s954ms 1s995ms 09 11 21s45ms 1s913ms 10 11 21s256ms 1s932ms 11 11 24s766ms 2s251ms 12 11 21s224ms 1s929ms 13 11 25s94ms 2s281ms 14 10 22s315ms 2s231ms 15 12 22s974ms 1s914ms 16 10 21s323ms 2s132ms 17 10 20s539ms 2s53ms 18 11 21s489ms 1s953ms 19 11 22s763ms 2s69ms 20 11 27s709ms 2s519ms 21 11 22s168ms 2s15ms 22 10 20s214ms 2s21ms [ User: intelifix - Total duration: 8m52s - Times executed: 251 ]
[ Application: psql - Total duration: 8m52s - Times executed: 251 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-05 00:05:19 Duration: 17s700ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-05 20:15:10 Duration: 8s642ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-05 11:25:06 Duration: 4s937ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
5 2m56s 4 4s737ms 1m24s 44s12ms 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 05 20 2 1m29s 44s884ms 23 2 1m26s 43s139ms [ User: intelifix - Total duration: 2m56s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m56s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-05 20:08:30 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-05 23:35:13 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-05 20:10:10 Duration: 4s978ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
6 1m48s 3 5s440ms 1m23s 36s213ms copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 05 23 3 1m48s 36s213ms [ User: intelifix - Total duration: 1m48s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 3 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-05 23:14:03 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-05 23:46:09 Duration: 19s295ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-05 23:35:47 Duration: 5s440ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
7 1m46s 2 19s480ms 1m27s 53s340ms copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 05 23 2 1m46s 53s340ms [ User: intelifix - Total duration: 1m46s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-05 23:12:40 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-05 23:45:49 Duration: 19s480ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
8 1m44s 4 330ms 58s175ms 26s89ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 05 20 2 58s600ms 29s300ms 23 2 45s758ms 22s879ms [ User: intelifix - Total duration: 1m44s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m44s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-05 20:05:27 Duration: 58s175ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-05 23:17:15 Duration: 45s427ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-05 20:09:38 Duration: 425ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
9 1m24s 2 16s496ms 1m7s 42s45ms copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 05 23 2 1m24s 42s45ms [ User: intelifix - Total duration: 1m24s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-05 23:11:12 Duration: 1m7s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-05 23:45:30 Duration: 16s496ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
10 1m23s 1 1m23s 1m23s 1m23s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 05 05 1 1m23s 1m23s [ User: intelifix - Total duration: 1m23s - Times executed: 1 ]
[ Application: psql - Total duration: 1m23s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-05 05:32:06 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-05 05:31:58 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
11 1m22s 6 2s254ms 31s396ms 13s786ms 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 #11
Day Hour Count Duration Avg duration Jul 05 20 3 41s660ms 13s886ms 23 3 41s57ms 13s685ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - 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-05 20:06:00 Duration: 31s396ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:17:46 Duration: 30s242ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:36:39 Duration: 8s99ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
12 1m22s 6 7s931ms 21s467ms 13s708ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 05 00 3 55s919ms 18s639ms 06 3 26s329ms 8s776ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: psql - Total duration: 1m22s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-05 00:05:23 Duration: 21s467ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-05 00:05:57 Duration: 18s158ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-05 00:05:39 Duration: 16s292ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
13 1m11s 6 1s620ms 27s928ms 11s834ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 05 20 3 35s777ms 11s925ms 23 3 35s231ms 11s743ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-05 20:06:31 Duration: 27s928ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-05 23:18:16 Duration: 26s656ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-05 23:36:45 Duration: 6s349ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
14 1m5s 6 2s910ms 24s663ms 10s910ms 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 #14
Day Hour Count Duration Avg duration Jul 05 20 3 33s233ms 11s77ms 23 3 32s231ms 10s743ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m5s - 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-05 23:35:38 Duration: 24s663ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:08:55 Duration: 24s150ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:10:15 Duration: 5s911ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
15 56s170ms 6 1s690ms 19s218ms 9s361ms 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 05 20 3 27s686ms 9s228ms 23 3 28s483ms 9s494ms [ User: intelifix - Total duration: 56s170ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 56s170ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 23:14:53 Duration: 19s218ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 20:02:43 Duration: 18s692ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 20:09:12 Duration: 7s304ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
16 55s435ms 6 1s608ms 19s255ms 9s239ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 05 20 3 28s154ms 9s384ms 23 3 27s280ms 9s93ms [ User: intelifix - Total duration: 55s435ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 55s435ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 20:03:17 Duration: 19s255ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 23:15:24 Duration: 17s870ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 23:36:15 Duration: 7s801ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
17 51s86ms 6 1s553ms 20s461ms 8s514ms 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 #17
Day Hour Count Duration Avg duration Jul 05 20 3 25s845ms 8s615ms 23 3 25s240ms 8s413ms [ User: intelifix - Total duration: 51s86ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s86ms - 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-05 20:04:08 Duration: 20s461ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:16:11 Duration: 19s594ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:36:27 Duration: 4s92ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
18 44s757ms 4 2s971ms 20s436ms 11s189ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 05 20 2 23s408ms 11s704ms 23 2 21s349ms 10s674ms [ User: intelifix - Total duration: 44s757ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 44s757ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-05 20:04:29 Duration: 20s436ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-05 23:16:29 Duration: 18s143ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-05 23:36:30 Duration: 3s205ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
19 43s289ms 37 660ms 4s487ms 1s169ms 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 #19
Day Hour Count Duration Avg duration Jul 05 08 3 6s407ms 2s135ms 09 2 2s27ms 1s13ms 10 2 2s285ms 1s142ms 11 2 2s228ms 1s114ms 12 2 1s870ms 935ms 13 3 4s40ms 1s346ms 14 3 2s639ms 879ms 15 3 3s22ms 1s7ms 16 3 3s215ms 1s71ms 17 2 2s131ms 1s65ms 18 3 2s945ms 981ms 19 3 2s852ms 950ms 20 2 4s300ms 2s150ms 21 2 1s701ms 850ms 22 2 1s622ms 811ms [ User: intelifix - Total duration: 43s289ms - Times executed: 37 ]
[ Application: psql - Total duration: 43s289ms - 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-05 08:00:05 Duration: 4s487ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:20:05 Duration: 3s539ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 13:20:03 Duration: 2s77ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
20 40s856ms 6 1s193ms 14s461ms 6s809ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 05 20 3 21s917ms 7s305ms 23 3 18s939ms 6s313ms [ User: intelifix - Total duration: 40s856ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s856ms - 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-05 20:03:32 Duration: 14s461ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:15:37 Duration: 12s582ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:09:28 Duration: 5s926ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 251 8m52s 150ms 17s700ms 2s120ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 05 00 11 39s350ms 3s577ms 01 10 25s276ms 2s527ms 02 11 22s712ms 2s64ms 03 12 22s388ms 1s865ms 04 11 22s260ms 2s23ms 05 11 20s737ms 1s885ms 06 12 21s554ms 1s796ms 07 11 21s2ms 1s909ms 08 11 21s954ms 1s995ms 09 11 21s45ms 1s913ms 10 11 21s256ms 1s932ms 11 11 24s766ms 2s251ms 12 11 21s224ms 1s929ms 13 11 25s94ms 2s281ms 14 10 22s315ms 2s231ms 15 12 22s974ms 1s914ms 16 10 21s323ms 2s132ms 17 10 20s539ms 2s53ms 18 11 21s489ms 1s953ms 19 11 22s763ms 2s69ms 20 11 27s709ms 2s519ms 21 11 22s168ms 2s15ms 22 10 20s214ms 2s21ms [ User: intelifix - Total duration: 8m52s - Times executed: 251 ]
[ Application: psql - Total duration: 8m52s - Times executed: 251 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-05 00:05:19 Duration: 17s700ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-05 20:15:10 Duration: 8s642ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-05 11:25:06 Duration: 4s937ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
2 48 1h47m10s 1s115ms 13m56s 2m13s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 05 07 3 14m37s 4m52s 08 3 5m53s 1m57s 09 3 5m55s 1m58s 10 3 5m51s 1m57s 11 3 6m 2m 12 3 5m58s 1m59s 13 3 5m54s 1m58s 14 3 6m6s 2m2s 15 3 6m 2m 16 3 5m46s 1m55s 17 3 6m5s 2m1s 18 3 6m3s 2m1s 19 3 5m55s 1m58s 20 3 7m38s 2m32s 21 3 7m45s 2m35s 22 3 5m36s 1m52s [ User: intelifix - Total duration: 1h47m10s - Times executed: 48 ]
[ Application: psql - Total duration: 1h47m10s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-05 07:18:58 Duration: 13m56s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-05 21:12:32 Duration: 7m30s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-05 20:12:10 Duration: 7m8s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
3 48 1h3m43s 183ms 3m39s 1m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 05 07 3 5m24s 1m48s 08 3 3m46s 1m15s 09 3 3m48s 1m16s 10 3 3m48s 1m16s 11 3 3m55s 1m18s 12 3 3m45s 1m15s 13 3 3m47s 1m15s 14 3 3m51s 1m17s 15 3 3m47s 1m15s 16 3 3m37s 1m12s 17 3 3m51s 1m17s 18 3 3m43s 1m14s 19 3 3m48s 1m16s 20 3 5m27s 1m49s 21 3 3m41s 1m13s 22 3 3m37s 1m12s [ User: intelifix - Total duration: 1h3m43s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m43s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-05 20:18:01 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-05 07:24:56 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-05 11:14:56 Duration: 3m25s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
4 37 43s289ms 660ms 4s487ms 1s169ms 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 05 08 3 6s407ms 2s135ms 09 2 2s27ms 1s13ms 10 2 2s285ms 1s142ms 11 2 2s228ms 1s114ms 12 2 1s870ms 935ms 13 3 4s40ms 1s346ms 14 3 2s639ms 879ms 15 3 3s22ms 1s7ms 16 3 3s215ms 1s71ms 17 2 2s131ms 1s65ms 18 3 2s945ms 981ms 19 3 2s852ms 950ms 20 2 4s300ms 2s150ms 21 2 1s701ms 850ms 22 2 1s622ms 811ms [ User: intelifix - Total duration: 43s289ms - Times executed: 37 ]
[ Application: psql - Total duration: 43s289ms - 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-05 08:00:05 Duration: 4s487ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:20:05 Duration: 3s539ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 13:20:03 Duration: 2s77ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
5 8 8s779ms 784ms 2s188ms 1s97ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 05 09 1 784ms 784ms 10 1 920ms 920ms 11 1 792ms 792ms 12 1 818ms 818ms 17 1 2s188ms 2s188ms 20 1 1s52ms 1s52ms 21 1 1s46ms 1s46ms 22 1 1s176ms 1s176ms [ User: intelifix - Total duration: 8s779ms - Times executed: 8 ]
[ Application: psql - Total duration: 8s779ms - Times executed: 8 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-05 17:20:04 Duration: 2s188ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-05 22:20:02 Duration: 1s176ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-05 20:40:02 Duration: 1s52ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
6 6 1m22s 2s254ms 31s396ms 13s786ms 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 #6
Day Hour Count Duration Avg duration Jul 05 20 3 41s660ms 13s886ms 23 3 41s57ms 13s685ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - 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-05 20:06:00 Duration: 31s396ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:17:46 Duration: 30s242ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:36:39 Duration: 8s99ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
7 6 1m22s 7s931ms 21s467ms 13s708ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 05 00 3 55s919ms 18s639ms 06 3 26s329ms 8s776ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: psql - Total duration: 1m22s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-05 00:05:23 Duration: 21s467ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-05 00:05:57 Duration: 18s158ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-05 00:05:39 Duration: 16s292ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
8 6 1m11s 1s620ms 27s928ms 11s834ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 05 20 3 35s777ms 11s925ms 23 3 35s231ms 11s743ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-05 20:06:31 Duration: 27s928ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-05 23:18:16 Duration: 26s656ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-05 23:36:45 Duration: 6s349ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
9 6 1m5s 2s910ms 24s663ms 10s910ms 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 #9
Day Hour Count Duration Avg duration Jul 05 20 3 33s233ms 11s77ms 23 3 32s231ms 10s743ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m5s - 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-05 23:35:38 Duration: 24s663ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:08:55 Duration: 24s150ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:10:15 Duration: 5s911ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
10 6 56s170ms 1s690ms 19s218ms 9s361ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 05 20 3 27s686ms 9s228ms 23 3 28s483ms 9s494ms [ User: intelifix - Total duration: 56s170ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 56s170ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 23:14:53 Duration: 19s218ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 20:02:43 Duration: 18s692ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 20:09:12 Duration: 7s304ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
11 6 55s435ms 1s608ms 19s255ms 9s239ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 05 20 3 28s154ms 9s384ms 23 3 27s280ms 9s93ms [ User: intelifix - Total duration: 55s435ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 55s435ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 20:03:17 Duration: 19s255ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 23:15:24 Duration: 17s870ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 23:36:15 Duration: 7s801ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
12 6 51s86ms 1s553ms 20s461ms 8s514ms 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 #12
Day Hour Count Duration Avg duration Jul 05 20 3 25s845ms 8s615ms 23 3 25s240ms 8s413ms [ User: intelifix - Total duration: 51s86ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s86ms - 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-05 20:04:08 Duration: 20s461ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:16:11 Duration: 19s594ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:36:27 Duration: 4s92ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
13 6 40s856ms 1s193ms 14s461ms 6s809ms 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 #13
Day Hour Count Duration Avg duration Jul 05 20 3 21s917ms 7s305ms 23 3 18s939ms 6s313ms [ User: intelifix - Total duration: 40s856ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s856ms - 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-05 20:03:32 Duration: 14s461ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:15:37 Duration: 12s582ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:09:28 Duration: 5s926ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
14 6 35s264ms 1s 14s499ms 5s877ms 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 #14
Day Hour Count Duration Avg duration Jul 05 20 3 18s641ms 6s213ms 23 3 16s623ms 5s541ms [ User: intelifix - Total duration: 35s264ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s264ms - 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-05 20:02:58 Duration: 14s499ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:15:06 Duration: 13s420ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:09:15 Duration: 3s141ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
15 6 30s65ms 2s888ms 7s65ms 5s10ms 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 #15
Day Hour Count Duration Avg duration Jul 05 20 3 14s700ms 4s900ms 23 3 15s364ms 5s121ms [ User: intelifix - Total duration: 30s65ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 30s65ms - 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-05 23:33:39 Duration: 7s65ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:10:03 Duration: 6s436ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:06:52 Duration: 5s375ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
16 6 26s316ms 791ms 10s931ms 4s386ms 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 #16
Day Hour Count Duration Avg duration Jul 05 20 3 14s290ms 4s763ms 23 3 12s25ms 4s8ms [ User: intelifix - Total duration: 26s316ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 26s316ms - 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-05 20:02:21 Duration: 10s931ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:14:30 Duration: 8s678ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:35:57 Duration: 2s554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
17 6 25s374ms 733ms 11s311ms 4s229ms 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 #17
Day Hour Count Duration Avg duration Jul 05 20 3 12s872ms 4s290ms 23 3 12s501ms 4s167ms [ User: intelifix - Total duration: 25s374ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 25s374ms - 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-05 20:03:48 Duration: 11s311ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:15:51 Duration: 10s803ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:36:23 Duration: 964ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
18 6 14s778ms 2s166ms 2s794ms 2s463ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 05 20 3 7s41ms 2s347ms 23 3 7s737ms 2s579ms [ User: intelifix - Total duration: 14s778ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 14s778ms - Times executed: 6 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-07-05 23:35:54 Duration: 2s794ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-07-05 23:14:20 Duration: 2s776ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-07-05 20:02:08 Duration: 2s387ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
19 6 12s829ms 429ms 4s465ms 2s138ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 05 20 3 6s841ms 2s280ms 23 3 5s988ms 1s996ms [ User: intelifix - Total duration: 12s829ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 12s829ms - 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-05 20:03:36 Duration: 4s465ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-07-05 23:15:41 Duration: 3s879ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-07-05 20:09:30 Duration: 1s831ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
20 6 8s36ms 231ms 3s72ms 1s339ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 05 00 3 4s494ms 1s498ms 06 3 3s542ms 1s180ms [ User: lenon - Total duration: 8s36ms - Times executed: 6 ]
[ Application: psql - Total duration: 8s36ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-05 00:02:05 Duration: 3s72ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-05 06:02:05 Duration: 2s898ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-05 00:02:06 Duration: 1s70ms Database: brasilia User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m20s 8m52s 5m4s 3 15m14s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 05 05 3 15m14s 5m4s [ User: intelifix - Total duration: 15m14s - Times executed: 3 ]
[ Application: psql - Total duration: 15m14s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-05 05:08:54 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
analyze verbose;
Date: 2026-07-05 05:12:54 Duration: 4m Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
analyze verbose;
Date: 2026-07-05 05:15:15 Duration: 2m20s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
2 1s115ms 13m56s 2m13s 48 1h47m10s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 05 07 3 14m37s 4m52s 08 3 5m53s 1m57s 09 3 5m55s 1m58s 10 3 5m51s 1m57s 11 3 6m 2m 12 3 5m58s 1m59s 13 3 5m54s 1m58s 14 3 6m6s 2m2s 15 3 6m 2m 16 3 5m46s 1m55s 17 3 6m5s 2m1s 18 3 6m3s 2m1s 19 3 5m55s 1m58s 20 3 7m38s 2m32s 21 3 7m45s 2m35s 22 3 5m36s 1m52s [ User: intelifix - Total duration: 1h47m10s - Times executed: 48 ]
[ Application: psql - Total duration: 1h47m10s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-05 07:18:58 Duration: 13m56s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-05 21:12:32 Duration: 7m30s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-05 20:12:10 Duration: 7m8s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
3 1m23s 1m23s 1m23s 1 1m23s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 05 05 1 1m23s 1m23s [ User: intelifix - Total duration: 1m23s - Times executed: 1 ]
[ Application: psql - Total duration: 1m23s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-05 05:32:06 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-05 05:31:58 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 183ms 3m39s 1m19s 48 1h3m43s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 05 07 3 5m24s 1m48s 08 3 3m46s 1m15s 09 3 3m48s 1m16s 10 3 3m48s 1m16s 11 3 3m55s 1m18s 12 3 3m45s 1m15s 13 3 3m47s 1m15s 14 3 3m51s 1m17s 15 3 3m47s 1m15s 16 3 3m37s 1m12s 17 3 3m51s 1m17s 18 3 3m43s 1m14s 19 3 3m48s 1m16s 20 3 5m27s 1m49s 21 3 3m41s 1m13s 22 3 3m37s 1m12s [ User: intelifix - Total duration: 1h3m43s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m43s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-05 20:18:01 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-05 07:24:56 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-05 11:14:56 Duration: 3m25s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
5 19s480ms 1m27s 53s340ms 2 1m46s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 05 23 2 1m46s 53s340ms [ User: intelifix - Total duration: 1m46s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-05 23:12:40 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-05 23:45:49 Duration: 19s480ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
6 4s737ms 1m24s 44s12ms 4 2m56s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 05 20 2 1m29s 44s884ms 23 2 1m26s 43s139ms [ User: intelifix - Total duration: 2m56s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m56s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-05 20:08:30 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-05 23:35:13 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-05 20:10:10 Duration: 4s978ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
7 16s496ms 1m7s 42s45ms 2 1m24s copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 05 23 2 1m24s 42s45ms [ User: intelifix - Total duration: 1m24s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-05 23:11:12 Duration: 1m7s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-05 23:45:30 Duration: 16s496ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
8 5s440ms 1m23s 36s213ms 3 1m48s copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 05 23 3 1m48s 36s213ms [ User: intelifix - Total duration: 1m48s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 3 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-05 23:14:03 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-05 23:46:09 Duration: 19s295ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-05 23:35:47 Duration: 5s440ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
9 330ms 58s175ms 26s89ms 4 1m44s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 05 20 2 58s600ms 29s300ms 23 2 45s758ms 22s879ms [ User: intelifix - Total duration: 1m44s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m44s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-05 20:05:27 Duration: 58s175ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-05 23:17:15 Duration: 45s427ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-05 20:09:38 Duration: 425ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
10 2s254ms 31s396ms 13s786ms 6 1m22s 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 #10
Day Hour Count Duration Avg duration Jul 05 20 3 41s660ms 13s886ms 23 3 41s57ms 13s685ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - 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-05 20:06:00 Duration: 31s396ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:17:46 Duration: 30s242ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:36:39 Duration: 8s99ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
11 7s931ms 21s467ms 13s708ms 6 1m22s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 05 00 3 55s919ms 18s639ms 06 3 26s329ms 8s776ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: psql - Total duration: 1m22s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-05 00:05:23 Duration: 21s467ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-05 00:05:57 Duration: 18s158ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-05 00:05:39 Duration: 16s292ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-05.log
12 1s620ms 27s928ms 11s834ms 6 1m11s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 05 20 3 35s777ms 11s925ms 23 3 35s231ms 11s743ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-05 20:06:31 Duration: 27s928ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-05 23:18:16 Duration: 26s656ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-05 23:36:45 Duration: 6s349ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
13 2s971ms 20s436ms 11s189ms 4 44s757ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 05 20 2 23s408ms 11s704ms 23 2 21s349ms 10s674ms [ User: intelifix - Total duration: 44s757ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 44s757ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-05 20:04:29 Duration: 20s436ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-05 23:16:29 Duration: 18s143ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-05 23:36:30 Duration: 3s205ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
14 2s910ms 24s663ms 10s910ms 6 1m5s 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 #14
Day Hour Count Duration Avg duration Jul 05 20 3 33s233ms 11s77ms 23 3 32s231ms 10s743ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m5s - 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-05 23:35:38 Duration: 24s663ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:08:55 Duration: 24s150ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:10:15 Duration: 5s911ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
15 1s690ms 19s218ms 9s361ms 6 56s170ms 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 05 20 3 27s686ms 9s228ms 23 3 28s483ms 9s494ms [ User: intelifix - Total duration: 56s170ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 56s170ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 23:14:53 Duration: 19s218ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 20:02:43 Duration: 18s692ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 20:09:12 Duration: 7s304ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
16 1s608ms 19s255ms 9s239ms 6 55s435ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 05 20 3 28s154ms 9s384ms 23 3 27s280ms 9s93ms [ User: intelifix - Total duration: 55s435ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 55s435ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 20:03:17 Duration: 19s255ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 23:15:24 Duration: 17s870ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-05 23:36:15 Duration: 7s801ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
17 1s553ms 20s461ms 8s514ms 6 51s86ms 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 #17
Day Hour Count Duration Avg duration Jul 05 20 3 25s845ms 8s615ms 23 3 25s240ms 8s413ms [ User: intelifix - Total duration: 51s86ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s86ms - 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-05 20:04:08 Duration: 20s461ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:16:11 Duration: 19s594ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:36:27 Duration: 4s92ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
18 1s193ms 14s461ms 6s809ms 6 40s856ms 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 05 20 3 21s917ms 7s305ms 23 3 18s939ms 6s313ms [ User: intelifix - Total duration: 40s856ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s856ms - 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-05 20:03:32 Duration: 14s461ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:15:37 Duration: 12s582ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:09:28 Duration: 5s926ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
19 1s 14s499ms 5s877ms 6 35s264ms 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 05 20 3 18s641ms 6s213ms 23 3 16s623ms 5s541ms [ User: intelifix - Total duration: 35s264ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s264ms - 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-05 20:02:58 Duration: 14s499ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 23:15:06 Duration: 13s420ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:09:15 Duration: 3s141ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.log
20 2s888ms 7s65ms 5s10ms 6 30s65ms 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 05 20 3 14s700ms 4s900ms 23 3 15s364ms 5s121ms [ User: intelifix - Total duration: 30s65ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 30s65ms - 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-05 23:33:39 Duration: 7s65ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:10:03 Duration: 6s436ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 20:06:52 Duration: 5s375ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-05.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 8 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 05 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 15 1 0ms 0ms 18 1 0ms 0ms 21 2 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 20s656ms - Times executed: 8 ]
[ Application: psql - Total duration: 20s656ms - Times executed: 8 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 7,911 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 13 FATAL entries
- 2894 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,799 Max number of times the same event was reported
- 2,908 Total events found
Rank Times reported Error 1 2,799 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 05 00 116 01 116 02 116 03 114 04 116 05 117 06 115 07 118 08 115 09 118 10 116 11 117 12 118 13 118 14 116 15 118 16 117 17 118 18 118 19 116 20 118 21 116 22 116 23 116 - ERROR: prepared statement "_PLAN000000003F2B2270" does not exist
- ERROR: prepared statement "_PLAN0000000029D2DEF0" does not exist
- ERROR: prepared statement "_PLAN000000003F2AB980" does not exist
Statement: DEALLOCATE "_PLAN000000003F2B2270"
Date: 2026-07-05 00:00:23 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
Statement: DEALLOCATE "_PLAN0000000029D2DEF0"
Date: 2026-07-05 00:00:28 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
Statement: DEALLOCATE "_PLAN000000003F2AB980"
Date: 2026-07-05 00:01:25 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
2 44 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 05 08 3 09 3 10 2 11 3 12 3 13 3 14 3 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-05 08:00:07 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 08:20:09 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 08:40:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
3 44 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 05 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 1 11 1 12 2 13 2 14 2 15 2 16 2 17 2 18 2 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-05 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.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-05 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
4 8 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 05 03 8 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-05 03:05:02 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
Date: 2026-07-05 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
Date: 2026-07-05 03:05:02 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
5 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 05 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-05 05:32:06 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-05 05:32:06 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-05 05:32:06 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
6 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 05 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-05 03:05:02 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
Date: 2026-07-05 03:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
Date: 2026-07-05 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
7 2 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 05 00 1 06 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
Date: 2026-07-05 00:02:07 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
Date: 2026-07-05 06:02:05 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
8 2 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 05 10 1 11 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
- 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-05 10:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-05 11:05:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log
9 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 05 03 1 - LOG: database system was shut down at 2026-07-05 03:05:02 -03
Date: 2026-07-05 03:05:04 Log file: /usr/local/pgsql/data/log/serverlog-05.log
10 1 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 05 10 1 - ERROR: invalid input syntax for type json 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
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-05 10:00:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-05.log