pgBadger-
Global information
- Generated on Mon Jul 13 23:50:11 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 9,390 log entries in 10s
- Log start from 2026-07-12 00:00:06 to 2026-07-12 23:59:10
-
Overview
Global Stats
- 145 Number of unique normalized queries
- 883 Number of queries
- 4h25m39s Total query duration
- 2026-07-12 00:02:13 First query
- 2026-07-12 23:54:05 Last query
- 5 queries/s at 2026-07-12 23:53:26 Query peak
- 4h25m39s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h25m39s Execute total duration
- 1,527 Number of events
- 9 Number of unique normalized events
- 1,396 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
- 234.55 MiB Max size of temporary file
- 109.07 MiB Average size of temporary file
- 202 Total number of sessions
- 7 sessions at 2026-07-12 07:05:01 Session peak
- 7d18h24m15s Total duration of sessions
- 55m22s Average duration of sessions
- 4 Average queries per session
- 1m18s Average queries duration per session
- 54m3s Average idle time per session
- 228 Total number of connections
- 5 connections/s at 2026-07-12 00:05:02 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-12 23:53:26 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-07-12 20:11:25 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-12 23:53:26 Date
Queries duration
Key values
- 4h25m39s 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 12 00 22 0ms 20s166ms 5s294ms 4s159ms 5s42ms 1m18s 01 12 0ms 4s977ms 2s169ms 3s973ms 4s208ms 5s270ms 02 12 0ms 4s988ms 2s256ms 3s723ms 4s600ms 5s198ms 03 14 0ms 4s484ms 1s916ms 4s51ms 4s298ms 5s661ms 04 12 0ms 4s248ms 2s135ms 3s851ms 4s441ms 4s661ms 05 16 0ms 9m36s 1m11s 4s548ms 2m26s 9m36s 06 18 0ms 11s110ms 4s11ms 4s432ms 5s350ms 32s968ms 07 18 0ms 13m55s 1m10s 3s982ms 2m1s 13m55s 08 21 0ms 5m47s 30s893ms 4s498ms 46s469ms 5m47s 09 20 0ms 5m47s 31s292ms 4s2ms 45s892ms 5m47s 10 21 0ms 5m53s 30s605ms 4s332ms 45s823ms 5m53s 11 21 0ms 5m57s 30s483ms 4s206ms 44s826ms 5m57s 12 21 0ms 5m37s 29s748ms 4s461ms 44s601ms 5m37s 13 21 0ms 5m52s 30s857ms 4s652ms 46s354ms 5m52s 14 20 0ms 5m48s 31s538ms 3s804ms 44s410ms 5m48s 15 20 0ms 5m56s 32s303ms 3s988ms 44s295ms 5m56s 16 21 0ms 5m46s 30s553ms 4s592ms 49s742ms 5m46s 17 21 0ms 5m43s 29s760ms 4s239ms 48s995ms 5m43s 18 24 0ms 5m46s 26s682ms 4s483ms 46s537ms 5m46s 19 21 0ms 5m46s 30s668ms 4s444ms 49s157ms 5m46s 20 116 0ms 7m51s 13s374ms 1m8s 3m4s 7m51s 21 21 0ms 8m4s 36s528ms 3s980ms 5s78ms 8m50s 22 21 0ms 5m43s 29s808ms 4s368ms 46s252ms 5m43s 23 349 0ms 1m45s 7s543ms 1m8s 1m44s 2m22s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 12 00 4 0 3s937ms 0ms 0ms 519ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 280ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 5s75ms 0ms 0ms 0ms 07 6 0 3m27s 0ms 0ms 4m9s 08 6 0 1m41s 0ms 0ms 3m37s 09 6 0 1m40s 0ms 0ms 3m24s 10 6 0 1m42s 0ms 0ms 3m34s 11 6 0 1m42s 0ms 0ms 3m30s 12 6 0 1m39s 0ms 0ms 3m34s 13 6 0 1m43s 0ms 0ms 3m40s 14 6 0 1m40s 0ms 0ms 3m31s 15 6 0 1m42s 0ms 0ms 3m37s 16 6 0 1m42s 0ms 0ms 3m36s 17 6 0 1m39s 0ms 0ms 3m23s 18 9 0 1m7s 0ms 0ms 3m34s 19 6 0 1m42s 0ms 0ms 3m40s 20 19 80 15s223ms 40s523ms 1m8s 4m42s 21 7 0 1m45s 0ms 0ms 3m28s 22 6 0 1m39s 0ms 0ms 3m27s 23 17 332 7s543ms 1m4s 1m8s 1m45s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 12 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 12 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 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Jul 12 00 16 0.00/s 01 7 0.00/s 02 7 0.00/s 03 17 0.00/s 04 8 0.00/s 05 10 0.00/s 06 14 0.00/s 07 8 0.00/s 08 7 0.00/s 09 7 0.00/s 10 8 0.00/s 11 6 0.00/s 12 7 0.00/s 13 8 0.00/s 14 8 0.00/s 15 8 0.00/s 16 7 0.00/s 17 8 0.00/s 18 8 0.00/s 19 7 0.00/s 20 12 0.00/s 21 25 0.01/s 22 10 0.00/s 23 5 0.00/s Day Hour Count Average Duration Average idle time Jul 12 00 3 43m20s 42m41s 01 14 1h1m17s 1h1m15s 02 7 1h 59m56s 03 15 19m19s 19m17s 04 8 1h3m 1h2m57s 05 8 1h29s 58m6s 06 9 57m14s 57m6s 07 13 1h27s 58m49s 08 7 59m52s 58m19s 09 7 1h49s 59m20s 10 7 1h1s 58m29s 11 8 1h 58m40s 12 6 1h56s 59m12s 13 7 1h2s 58m29s 14 8 1h1m6s 59m47s 15 7 1h51s 59m19s 16 8 1h50s 59m30s 17 7 1h50s 59m21s 18 8 1h1m5s 59m45s 19 8 1h 58m40s 20 11 39m59s 37m38s 21 8 1h 58m24s 22 7 1h49s 59m19s 23 11 47m38s 43m39s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-12 00:05:02 Date
Connections per database
Key values
- rio Main Database
- 228 connections Total
Connections per user
Key values
- intelifix Main User
- 228 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-07-12 07:05:01 Date
Histogram of session times
Key values
- 175 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 202 sessions Total
Sessions per user
Key values
- intelifix Main User
- 202 sessions Total
Sessions per host
Key values
- [local] Main Host
- 202 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 10,210 buffers Checkpoint Peak
- 2026-07-12 03:05:02 Date
- 269.861 seconds Highest write time
- 0.047 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-07-12 03:05:02 Date
Checkpoints distance
Key values
- 112.38 Mo Distance Peak
- 2026-07-12 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 12 00 5,269 269.468s 0.009s 269.487s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 10,210 0.543s 0.009s 0.57s 04 0 0s 0s 0s 05 6,204 621.457s 0.068s 621.577s 06 2,747 269.861s 0.004s 269.872s 07 1,152 115.499s 0.006s 115.549s 08 21 2.132s 0.003s 2.141s 09 21 2.131s 0.003s 2.143s 10 22 2.231s 0.003s 2.24s 11 21 2.129s 0.003s 2.137s 12 21 2.127s 0.004s 2.136s 13 21 2.128s 0.004s 2.139s 14 22 2.255s 0.007s 2.272s 15 21 2.13s 0.003s 2.141s 16 21 2.135s 0.005s 2.146s 17 21 2.131s 0.005s 2.141s 18 834 83.866s 0.007s 83.9s 19 21 2.134s 0.004s 2.146s 20 109 11.006s 0.008s 11.037s 21 21 2.126s 0.004s 2.134s 22 21 2.133s 0.004s 2.142s 23 58 5.864s 0.005s 5.887s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 12 00 0 0 2 30 0.002s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 33 0.002s 0.003s 04 0 0 0 0 0s 0s 05 0 0 3 152 0.029s 0.007s 06 0 0 0 10 0.002s 0.001s 07 0 0 0 19 0.002s 0.002s 08 0 0 0 3 0.002s 0.001s 09 0 0 1 3 0.002s 0.001s 10 0 0 0 3 0.002s 0.001s 11 0 0 0 3 0.002s 0.001s 12 0 0 0 3 0.002s 0.002s 13 0 0 0 3 0.003s 0.002s 14 0 0 0 5 0.002s 0.004s 15 0 0 0 3 0.002s 0.001s 16 0 0 0 3 0.003s 0.002s 17 0 0 0 3 0.003s 0.002s 18 0 0 0 79 0.003s 0.004s 19 0 0 0 3 0.002s 0.002s 20 0 0 0 12 0.003s 0.003s 21 0 0 0 3 0.002s 0.002s 22 0 0 0 3 0.002s 0.002s 23 0 0 0 4 0.002s 0.004s Day Hour Count Avg time (sec) Jul 12 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 12 00 26,757.00 kB 26,757.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 28,768.00 kB 28,768.00 kB 04 0.00 kB 0.00 kB 05 6,804.17 kB 10,332.17 kB 06 6,121.00 kB 11,458.00 kB 07 3,086.00 kB 10,378.50 kB 08 169.00 kB 8,871.00 kB 09 170.00 kB 8,001.00 kB 10 170.00 kB 7,218.00 kB 11 167.00 kB 6,513.00 kB 12 167.00 kB 5,878.00 kB 13 168.00 kB 5,307.00 kB 14 83.50 kB 4,545.50 kB 15 168.00 kB 3,901.00 kB 16 168.00 kB 3,527.00 kB 17 167.00 kB 3,191.00 kB 18 1,045.25 kB 3,295.75 kB 19 168.00 kB 2,555.00 kB 20 256.67 kB 2,115.33 kB 21 168.00 kB 1,758.00 kB 22 168.00 kB 1,599.00 kB 23 63.33 kB 1,316.33 kB -
Temporary Files
Size of temporary files
Key values
- 469.11 MiB Temp Files size Peak
- 2026-07-12 05:31:57 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-12 05:31:57 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 12 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.07 GiB 109.07 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 911.39 MiB 69.96 MiB 234.55 MiB 113.92 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-12 05:32:05 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-12 05:31:57 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 179.33 MiB 89.66 MiB 89.66 MiB 89.66 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-12 05:30:41 Duration: 39s468ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-12 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 234.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-12 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 234.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-12 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 89.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-12 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 89.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-12 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 77.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-12 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 77.42 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-12 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 77.41 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-12 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 70.03 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-12 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 69.97 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-12 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 69.96 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-12 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.27 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-07-12 05:09:41 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.27 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-07-12 05:09:41 Date
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database brasilia
- 6 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 168 18 119,256 15 40 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,151 59 338,293 49 486 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 116 21 67,446 6 11 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,339 27 236,977 21 209 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,081 293 1,458,414 270 1,714 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 824 89 539,272 42 213 Total 6 6 0 0 0 0 0 8,679 507 2,759,658 403 2,673 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.27) 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 (4355) Main table with removed tuples on database rio
- 13319 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,355 7,460 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,257 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,877 7,332 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 614 678 0 70 224 brasilia.pg_toast.pg_toast_2619 1 1 121 129 0 0 61 contagem.pg_toast.pg_toast_2619 1 1 95 116 0 0 52 Total 6 6 13,319 22,989 0 70 3,706 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (70) Main table with removed pages on database rio
- 70 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_toast.pg_toast_2619 1 1 614 70 brasilia.pg_toast.pg_toast_2619 1 1 121 0 contagem.pg_catalog.pg_statistic 1 1 4257 0 contagem.pg_toast.pg_toast_2619 1 1 95 0 brasilia.pg_catalog.pg_statistic 1 1 3877 0 rio.pg_catalog.pg_statistic 1 1 4355 0 Total 6 6 13,319 70 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 12 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.27 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
- 138 Total read queries
- 412 Total write queries
Queries by database
Key values
- rio Main database
- 390 Requests
- 2h58m3s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 870 Requests
User Request type Count Duration etiquetas Total 7 3s21ms select 7 3s21ms intelifix Total 870 4h25m6s copy to 412 53m29s others 333 31m19s select 125 3h17s lenon Total 6 30s456ms select 6 30s456ms Duration by user
Key values
- 4h25m6s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 7 3s21ms select 7 3s21ms intelifix Total 870 4h25m6s copy to 412 53m29s others 333 31m19s select 125 3h17s lenon Total 6 30s456ms select 6 30s456ms Queries by host
Key values
- [local] Main host
- 883 Requests
- 4h25m39s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 439 Requests
- 3h32m (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-12 19:28:46 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 352 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 13m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-12 07:18:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m36s analyze verbose;[ Date: 2026-07-12 05:09:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-12 21:13:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-12 20:12:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-12 11:10:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-12 15:10:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-12 10:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-12 13:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-12 14:10:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-12 09:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-12 08:10:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-12 16:10:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-12 18:10:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-12 19:10:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-12 17:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-12 22:10:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-12 12:10:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m35s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-07-12 20:20:16 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
19 4m32s analyze verbose;[ Date: 2026-07-12 05:14:09 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 4m2s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-07-12 07:25:37 - 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 1h50m38s 48 1s376ms 13m55s 2m18s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 12 07 3 14m36s 4m52s 08 3 6m5s 2m1s 09 3 6m5s 2m1s 10 3 6m10s 2m3s 11 3 6m14s 2m4s 12 3 5m54s 1m58s 13 3 6m8s 2m2s 14 3 6m4s 2m1s 15 3 6m12s 2m4s 16 3 6m6s 2m2s 17 3 6m1s 2m 18 3 6m4s 2m1s 19 3 6m5s 2m1s 20 3 8m28s 2m49s 21 3 8m21s 2m47s 22 3 5m59s 1m59s [ User: intelifix - Total duration: 1h50m38s - Times executed: 48 ]
[ Application: psql - Total duration: 1h50m38s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-12 07:18:57 Duration: 13m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-12 21:13:06 Duration: 8m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-12 20:12:53 Duration: 7m51s Database: rio User: intelifix Remote: [local] Application: psql
2 1h9m28s 48 199ms 4m35s 1m26s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 12 07 3 6m5s 2m1s 08 3 4m6s 1m22s 09 3 3m54s 1m18s 10 3 4m3s 1m21s 11 3 3m57s 1m19s 12 3 4m2s 1m20s 13 3 4m10s 1m23s 14 3 4m 1m20s 15 3 4m5s 1m21s 16 3 4m6s 1m22s 17 3 3m55s 1m18s 18 3 4m3s 1m21s 19 3 4m10s 1m23s 20 3 6m52s 2m17s 21 3 3m57s 1m19s 22 3 3m56s 1m18s [ User: intelifix - Total duration: 1h9m28s - Times executed: 48 ]
[ Application: psql - Total duration: 1h9m28s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-12 20:20:16 Duration: 4m35s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-12 07:25:37 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-12 19:15:15 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql
3 16m34s 3 2m26s 9m36s 5m31s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 12 05 3 16m34s 5m31s [ User: intelifix - Total duration: 16m34s - Times executed: 3 ]
[ Application: psql - Total duration: 16m34s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-12 05:09:37 Duration: 9m36s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-12 05:14:09 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-12 05:16:36 Duration: 2m26s Database: contagem User: intelifix Remote: [local] Application: psql
4 10m17s 270 152ms 20s166ms 2s285ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 12 00 12 44s991ms 3s749ms 01 12 26s30ms 2s169ms 02 12 27s77ms 2s256ms 03 12 26s112ms 2s176ms 04 12 25s626ms 2s135ms 05 11 25s167ms 2s287ms 06 12 27s995ms 2s332ms 07 12 24s950ms 2s79ms 08 12 24s772ms 2s64ms 09 11 22s502ms 2s45ms 10 12 25s865ms 2s155ms 11 12 24s702ms 2s58ms 12 12 25s265ms 2s105ms 13 11 26s154ms 2s377ms 14 11 23s65ms 2s96ms 15 11 24s434ms 2s221ms 16 12 25s933ms 2s161ms 17 12 25s382ms 2s115ms 18 12 26s489ms 2s207ms 19 12 24s886ms 2s73ms 20 12 37s953ms 3s162ms 21 11 25s41ms 2s276ms 22 12 26s673ms 2s222ms [ User: intelifix - Total duration: 10m17s - Times executed: 270 ]
[ Application: psql - Total duration: 10m17s - Times executed: 270 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-12 00:05:22 Duration: 20s166ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-12 20:15:16 Duration: 14s665ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-12 22:35:07 Duration: 5s275ms Database: rio User: intelifix Remote: [local] Application: psql
5 3m17s 4 4s721ms 1m36s 49s445ms 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 12 20 2 1m42s 51s268ms 23 2 1m35s 47s622ms [ User: intelifix - Total duration: 3m17s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m17s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-12 20:09:15 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-12 23:40:04 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-12 20:11:15 Duration: 5s627ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 2m14s 3 6s726ms 1m44s 44s965ms 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 12 23 3 2m14s 44s965ms [ User: intelifix - Total duration: 2m14s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m14s - 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-12 23:14:53 Duration: 1m44s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:52:59 Duration: 23s202ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-12.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-12 23:40:43 Duration: 6s726ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 2m8s 2 22s543ms 1m45s 1m4s 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 12 23 2 2m8s 1m4s [ User: intelifix - Total duration: 2m8s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m8s - 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-12 23:13:09 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:52:35 Duration: 22s543ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-12.log
8 1m59s 4 441ms 1m7s 29s936ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 12 20 2 1m8s 34s61ms 23 2 51s621ms 25s810ms [ User: intelifix - Total duration: 1m59s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m59s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-12 20:05:46 Duration: 1m7s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-12 23:18:46 Duration: 51s180ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-12 20:10:35 Duration: 479ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1m38s 2 20s338ms 1m18s 49s307ms 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 12 23 2 1m38s 49s307ms [ User: intelifix - Total duration: 1m38s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m38s - 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-12 23:11:23 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:52:13 Duration: 20s338ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-12.log
10 1m28s 6 2s246ms 33s424ms 14s805ms 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 12 20 3 46s416ms 15s472ms 23 3 42s416ms 14s138ms [ User: intelifix - Total duration: 1m28s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m28s - 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-12 20:06:21 Duration: 33s424ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:19:19 Duration: 31s396ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 20:10:46 Duration: 9s812ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 1m23s 1 1m23s 1m23s 1m23s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 12 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-12 05:32:05 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-12 05:31:57 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
12 1m23s 6 8s624ms 20s54ms 13s838ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 12 00 3 54s41ms 18s13ms 06 3 28s987ms 9s662ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: psql - Total duration: 1m23s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-12 00:05:22 Duration: 20s54ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-12 00:05:56 Duration: 17s570ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-12 00:05:38 Duration: 16s416ms Database: brasilia User: intelifix Remote: [local] Application: psql
13 1m18s 6 1s868ms 30s350ms 13s54ms 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 12 20 3 40s297ms 13s432ms 23 3 38s29ms 12s676ms [ User: intelifix - Total duration: 1m18s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m18s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-12 20:06:56 Duration: 30s350ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-12 23:19:52 Duration: 29s442ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-12 20:10:54 Duration: 8s78ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1m16s 6 2s680ms 28s697ms 12s668ms 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 12 20 3 38s542ms 12s847ms 23 3 37s469ms 12s489ms [ User: intelifix - Total duration: 1m16s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m16s - 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-12 20:09:44 Duration: 28s697ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:40:32 Duration: 28s326ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 20:11:22 Duration: 6s536ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1m 6 1s688ms 19s443ms 10s117ms 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 12 20 3 30s882ms 10s294ms 23 3 29s825ms 9s941ms [ User: intelifix - Total duration: 1m - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 23:16:09 Duration: 19s443ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 20:02:46 Duration: 19s380ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 20:10:07 Duration: 9s513ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 58s754ms 6 1s683ms 20s120ms 9s792ms 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 12 20 3 29s459ms 9s819ms 23 3 29s294ms 9s764ms [ User: intelifix - Total duration: 58s754ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s754ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 20:03:22 Duration: 20s120ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 23:16:43 Duration: 19s819ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 23:41:18 Duration: 7s791ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 55s987ms 6 1s297ms 24s6ms 9s331ms 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 12 20 3 30s421ms 10s140ms 23 3 25s565ms 8s521ms [ User: intelifix - Total duration: 55s987ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 55s987ms - 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-12 20:04:18 Duration: 24s6ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:17:35 Duration: 20s449ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 20:10:31 Duration: 4s793ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 51s238ms 3 6s767ms 35s61ms 17s79ms copy auditor.auditor_2026_07 (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 #18
Day Hour Count Duration Avg duration Jul 12 23 3 51s238ms 17s79ms [ User: intelifix - Total duration: 51s238ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 51s238ms - Times executed: 3 ]
-
COPY auditor.auditor_2026_07 (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-12 23:15:29 Duration: 35s61ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_07 (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-12 23:40:52 Duration: 9s409ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_07 (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-12 23:53:05 Duration: 6s767ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-12.log
19 49s782ms 36 760ms 7s570ms 1s382ms 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 12 08 2 11s773ms 5s886ms 09 3 2s906ms 968ms 10 2 2s91ms 1s45ms 11 2 2s14ms 1s7ms 12 2 2s607ms 1s303ms 13 3 2s994ms 998ms 14 3 3s67ms 1s22ms 15 3 3s740ms 1s246ms 16 2 2s86ms 1s43ms 17 3 2s924ms 974ms 18 1 1s136ms 1s136ms 19 3 2s950ms 983ms 20 3 5s943ms 1s981ms 21 2 1s688ms 844ms 22 2 1s856ms 928ms [ User: intelifix - Total duration: 49s782ms - Times executed: 36 ]
[ Application: psql - Total duration: 49s782ms - Times executed: 36 ]
-
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-12 08:20:09 Duration: 7s570ms Database: rio User: intelifix Remote: [local] Application: psql
-
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-12 20:20:06 Duration: 4s327ms Database: rio User: intelifix Remote: [local] Application: psql
-
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-12 08:00:05 Duration: 4s202ms Database: rio User: intelifix Remote: [local] Application: psql
20 47s140ms 4 3s532ms 20s314ms 11s785ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 12 20 2 23s846ms 11s923ms 23 2 23s293ms 11s646ms [ User: intelifix - Total duration: 47s140ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 47s140ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-12 20:04:38 Duration: 20s314ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-12 23:17:55 Duration: 19s695ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-12 23:41:35 Duration: 3s597ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 270 10m17s 152ms 20s166ms 2s285ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 12 00 12 44s991ms 3s749ms 01 12 26s30ms 2s169ms 02 12 27s77ms 2s256ms 03 12 26s112ms 2s176ms 04 12 25s626ms 2s135ms 05 11 25s167ms 2s287ms 06 12 27s995ms 2s332ms 07 12 24s950ms 2s79ms 08 12 24s772ms 2s64ms 09 11 22s502ms 2s45ms 10 12 25s865ms 2s155ms 11 12 24s702ms 2s58ms 12 12 25s265ms 2s105ms 13 11 26s154ms 2s377ms 14 11 23s65ms 2s96ms 15 11 24s434ms 2s221ms 16 12 25s933ms 2s161ms 17 12 25s382ms 2s115ms 18 12 26s489ms 2s207ms 19 12 24s886ms 2s73ms 20 12 37s953ms 3s162ms 21 11 25s41ms 2s276ms 22 12 26s673ms 2s222ms [ User: intelifix - Total duration: 10m17s - Times executed: 270 ]
[ Application: psql - Total duration: 10m17s - Times executed: 270 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-12 00:05:22 Duration: 20s166ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-12 20:15:16 Duration: 14s665ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-12 22:35:07 Duration: 5s275ms Database: rio User: intelifix Remote: [local] Application: psql
2 48 1h50m38s 1s376ms 13m55s 2m18s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 12 07 3 14m36s 4m52s 08 3 6m5s 2m1s 09 3 6m5s 2m1s 10 3 6m10s 2m3s 11 3 6m14s 2m4s 12 3 5m54s 1m58s 13 3 6m8s 2m2s 14 3 6m4s 2m1s 15 3 6m12s 2m4s 16 3 6m6s 2m2s 17 3 6m1s 2m 18 3 6m4s 2m1s 19 3 6m5s 2m1s 20 3 8m28s 2m49s 21 3 8m21s 2m47s 22 3 5m59s 1m59s [ User: intelifix - Total duration: 1h50m38s - Times executed: 48 ]
[ Application: psql - Total duration: 1h50m38s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-12 07:18:57 Duration: 13m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-12 21:13:06 Duration: 8m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-12 20:12:53 Duration: 7m51s Database: rio User: intelifix Remote: [local] Application: psql
3 48 1h9m28s 199ms 4m35s 1m26s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 12 07 3 6m5s 2m1s 08 3 4m6s 1m22s 09 3 3m54s 1m18s 10 3 4m3s 1m21s 11 3 3m57s 1m19s 12 3 4m2s 1m20s 13 3 4m10s 1m23s 14 3 4m 1m20s 15 3 4m5s 1m21s 16 3 4m6s 1m22s 17 3 3m55s 1m18s 18 3 4m3s 1m21s 19 3 4m10s 1m23s 20 3 6m52s 2m17s 21 3 3m57s 1m19s 22 3 3m56s 1m18s [ User: intelifix - Total duration: 1h9m28s - Times executed: 48 ]
[ Application: psql - Total duration: 1h9m28s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-12 20:20:16 Duration: 4m35s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-12 07:25:37 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-12 19:15:15 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql
4 36 49s782ms 760ms 7s570ms 1s382ms 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 12 08 2 11s773ms 5s886ms 09 3 2s906ms 968ms 10 2 2s91ms 1s45ms 11 2 2s14ms 1s7ms 12 2 2s607ms 1s303ms 13 3 2s994ms 998ms 14 3 3s67ms 1s22ms 15 3 3s740ms 1s246ms 16 2 2s86ms 1s43ms 17 3 2s924ms 974ms 18 1 1s136ms 1s136ms 19 3 2s950ms 983ms 20 3 5s943ms 1s981ms 21 2 1s688ms 844ms 22 2 1s856ms 928ms [ User: intelifix - Total duration: 49s782ms - Times executed: 36 ]
[ Application: psql - Total duration: 49s782ms - Times executed: 36 ]
-
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-12 08:20:09 Duration: 7s570ms Database: rio User: intelifix Remote: [local] Application: psql
-
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-12 20:20:06 Duration: 4s327ms Database: rio User: intelifix Remote: [local] Application: psql
-
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-12 08:00:05 Duration: 4s202ms Database: rio User: intelifix Remote: [local] Application: psql
5 9 9s722ms 749ms 1s787ms 1s80ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 12 08 1 1s55ms 1s55ms 10 1 820ms 820ms 11 1 749ms 749ms 12 1 778ms 778ms 16 1 1s210ms 1s210ms 18 2 2s883ms 1s441ms 21 1 1s192ms 1s192ms 22 1 1s32ms 1s32ms [ User: intelifix - Total duration: 9s722ms - Times executed: 9 ]
[ Application: psql - Total duration: 9s722ms - Times executed: 9 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-12 18:00:03 Duration: 1s787ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-12 16:20:02 Duration: 1s210ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-12 21:20:02 Duration: 1s192ms Database: rio User: intelifix Remote: [local] Application: psql
6 6 1m28s 2s246ms 33s424ms 14s805ms 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 12 20 3 46s416ms 15s472ms 23 3 42s416ms 14s138ms [ User: intelifix - Total duration: 1m28s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m28s - 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-12 20:06:21 Duration: 33s424ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:19:19 Duration: 31s396ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 20:10:46 Duration: 9s812ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 6 1m23s 8s624ms 20s54ms 13s838ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 12 00 3 54s41ms 18s13ms 06 3 28s987ms 9s662ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: psql - Total duration: 1m23s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-12 00:05:22 Duration: 20s54ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-12 00:05:56 Duration: 17s570ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-12 00:05:38 Duration: 16s416ms Database: brasilia User: intelifix Remote: [local] Application: psql
8 6 1m18s 1s868ms 30s350ms 13s54ms 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 12 20 3 40s297ms 13s432ms 23 3 38s29ms 12s676ms [ User: intelifix - Total duration: 1m18s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m18s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-12 20:06:56 Duration: 30s350ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-12 23:19:52 Duration: 29s442ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-12 20:10:54 Duration: 8s78ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 6 1m16s 2s680ms 28s697ms 12s668ms 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 12 20 3 38s542ms 12s847ms 23 3 37s469ms 12s489ms [ User: intelifix - Total duration: 1m16s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m16s - 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-12 20:09:44 Duration: 28s697ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:40:32 Duration: 28s326ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 20:11:22 Duration: 6s536ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 6 1m 1s688ms 19s443ms 10s117ms 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 12 20 3 30s882ms 10s294ms 23 3 29s825ms 9s941ms [ User: intelifix - Total duration: 1m - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 23:16:09 Duration: 19s443ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 20:02:46 Duration: 19s380ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 20:10:07 Duration: 9s513ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 58s754ms 1s683ms 20s120ms 9s792ms 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 12 20 3 29s459ms 9s819ms 23 3 29s294ms 9s764ms [ User: intelifix - Total duration: 58s754ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s754ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 20:03:22 Duration: 20s120ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 23:16:43 Duration: 19s819ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 23:41:18 Duration: 7s791ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 6 55s987ms 1s297ms 24s6ms 9s331ms 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 12 20 3 30s421ms 10s140ms 23 3 25s565ms 8s521ms [ User: intelifix - Total duration: 55s987ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 55s987ms - 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-12 20:04:18 Duration: 24s6ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:17:35 Duration: 20s449ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 20:10:31 Duration: 4s793ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 45s404ms 1s530ms 15s166ms 7s567ms 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 12 20 3 22s351ms 7s450ms 23 3 23s53ms 7s684ms [ User: intelifix - Total duration: 45s404ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 45s404ms - 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-12 23:16:58 Duration: 15s166ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 20:03:37 Duration: 14s598ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 20:10:23 Duration: 6s222ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 39s809ms 3s568ms 9s300ms 6s634ms 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 #14
Day Hour Count Duration Avg duration Jul 12 20 3 21s528ms 7s176ms 23 3 18s281ms 6s93ms [ User: intelifix - Total duration: 39s809ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 39s809ms - 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-12 20:07:25 Duration: 9s300ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-12 20:11:08 Duration: 8s629ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-12 23:38:20 Duration: 7s526ms Database: rio User: intelifix Remote: [local] Application: pg_dump
15 6 35s291ms 829ms 15s195ms 5s881ms 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 #15
Day Hour Count Duration Avg duration Jul 12 20 3 18s473ms 6s157ms 23 3 16s817ms 5s605ms [ User: intelifix - Total duration: 35s291ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s291ms - 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-12 20:03:02 Duration: 15s195ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:16:23 Duration: 13s650ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:41:11 Duration: 2s337ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 30s906ms 829ms 11s653ms 5s151ms 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 12 20 3 16s405ms 5s468ms 23 3 14s501ms 4s833ms [ User: intelifix - Total duration: 30s906ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 30s906ms - 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-12 20:02:23 Duration: 11s653ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:15:45 Duration: 11s311ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 20:09:56 Duration: 3s864ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 6 30s456ms 891ms 11s493ms 5s76ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 12 00 3 15s231ms 5s77ms 06 3 15s225ms 5s75ms [ User: lenon - Total duration: 30s456ms - Times executed: 6 ]
[ Application: psql - Total duration: 30s456ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-12 00:02:13 Duration: 11s493ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-12 06:02:12 Duration: 10s934ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-12 00:02:16 Duration: 2s845ms Database: brasilia User: lenon Remote: [local] Application: psql
18 6 27s791ms 921ms 12s434ms 4s631ms 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 #18
Day Hour Count Duration Avg duration Jul 12 20 3 13s286ms 4s428ms 23 3 14s504ms 4s834ms [ User: intelifix - Total duration: 27s791ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s791ms - 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-12 23:17:15 Duration: 12s434ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 20:03:54 Duration: 11s302ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:41:28 Duration: 1s148ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 16s96ms 518ms 6s190ms 2s682ms 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 12 20 3 9s548ms 3s182ms 23 3 6s548ms 2s182ms [ User: intelifix - Total duration: 16s96ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 16s96ms - 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-12 20:03:43 Duration: 6s190ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-07-12 23:17:02 Duration: 4s88ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-07-12 20:10:25 Duration: 2s741ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 15s71ms 2s386ms 2s684ms 2s511ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 12 20 3 7s590ms 2s530ms 23 3 7s480ms 2s493ms [ User: intelifix - Total duration: 15s71ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 15s71ms - Times executed: 6 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-07-12 23:53:09 Duration: 2s684ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-12.log
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-07-12 20:09:52 Duration: 2s605ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-07-12 20:02:10 Duration: 2s581ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m26s 9m36s 5m31s 3 16m34s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 12 05 3 16m34s 5m31s [ User: intelifix - Total duration: 16m34s - Times executed: 3 ]
[ Application: psql - Total duration: 16m34s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-12 05:09:37 Duration: 9m36s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-12 05:14:09 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-12 05:16:36 Duration: 2m26s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s376ms 13m55s 2m18s 48 1h50m38s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 12 07 3 14m36s 4m52s 08 3 6m5s 2m1s 09 3 6m5s 2m1s 10 3 6m10s 2m3s 11 3 6m14s 2m4s 12 3 5m54s 1m58s 13 3 6m8s 2m2s 14 3 6m4s 2m1s 15 3 6m12s 2m4s 16 3 6m6s 2m2s 17 3 6m1s 2m 18 3 6m4s 2m1s 19 3 6m5s 2m1s 20 3 8m28s 2m49s 21 3 8m21s 2m47s 22 3 5m59s 1m59s [ User: intelifix - Total duration: 1h50m38s - Times executed: 48 ]
[ Application: psql - Total duration: 1h50m38s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-12 07:18:57 Duration: 13m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-12 21:13:06 Duration: 8m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-12 20:12:53 Duration: 7m51s Database: rio User: intelifix Remote: [local] Application: psql
3 199ms 4m35s 1m26s 48 1h9m28s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 12 07 3 6m5s 2m1s 08 3 4m6s 1m22s 09 3 3m54s 1m18s 10 3 4m3s 1m21s 11 3 3m57s 1m19s 12 3 4m2s 1m20s 13 3 4m10s 1m23s 14 3 4m 1m20s 15 3 4m5s 1m21s 16 3 4m6s 1m22s 17 3 3m55s 1m18s 18 3 4m3s 1m21s 19 3 4m10s 1m23s 20 3 6m52s 2m17s 21 3 3m57s 1m19s 22 3 3m56s 1m18s [ User: intelifix - Total duration: 1h9m28s - Times executed: 48 ]
[ Application: psql - Total duration: 1h9m28s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-12 20:20:16 Duration: 4m35s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-12 07:25:37 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-12 19:15:15 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql
4 1m23s 1m23s 1m23s 1 1m23s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 12 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-12 05:32:05 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-12 05:31:57 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
5 22s543ms 1m45s 1m4s 2 2m8s 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 12 23 2 2m8s 1m4s [ User: intelifix - Total duration: 2m8s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m8s - 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-12 23:13:09 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:52:35 Duration: 22s543ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-12.log
6 4s721ms 1m36s 49s445ms 4 3m17s 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 12 20 2 1m42s 51s268ms 23 2 1m35s 47s622ms [ User: intelifix - Total duration: 3m17s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m17s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-12 20:09:15 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-12 23:40:04 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-12 20:11:15 Duration: 5s627ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 20s338ms 1m18s 49s307ms 2 1m38s 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 12 23 2 1m38s 49s307ms [ User: intelifix - Total duration: 1m38s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m38s - 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-12 23:11:23 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:52:13 Duration: 20s338ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-12.log
8 6s726ms 1m44s 44s965ms 3 2m14s 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 12 23 3 2m14s 44s965ms [ User: intelifix - Total duration: 2m14s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m14s - 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-12 23:14:53 Duration: 1m44s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:52:59 Duration: 23s202ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-12.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-12 23:40:43 Duration: 6s726ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 441ms 1m7s 29s936ms 4 1m59s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 12 20 2 1m8s 34s61ms 23 2 51s621ms 25s810ms [ User: intelifix - Total duration: 1m59s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m59s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-12 20:05:46 Duration: 1m7s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-12 23:18:46 Duration: 51s180ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-12 20:10:35 Duration: 479ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 6s767ms 35s61ms 17s79ms 3 51s238ms copy auditor.auditor_2026_07 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 12 23 3 51s238ms 17s79ms [ User: intelifix - Total duration: 51s238ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 51s238ms - Times executed: 3 ]
-
COPY auditor.auditor_2026_07 (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-12 23:15:29 Duration: 35s61ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_07 (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-12 23:40:52 Duration: 9s409ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_07 (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-12 23:53:05 Duration: 6s767ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-12.log
11 2s246ms 33s424ms 14s805ms 6 1m28s 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 12 20 3 46s416ms 15s472ms 23 3 42s416ms 14s138ms [ User: intelifix - Total duration: 1m28s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m28s - 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-12 20:06:21 Duration: 33s424ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:19:19 Duration: 31s396ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 20:10:46 Duration: 9s812ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 8s624ms 20s54ms 13s838ms 6 1m23s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 12 00 3 54s41ms 18s13ms 06 3 28s987ms 9s662ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: psql - Total duration: 1m23s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-12 00:05:22 Duration: 20s54ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-12 00:05:56 Duration: 17s570ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-12 00:05:38 Duration: 16s416ms Database: brasilia User: intelifix Remote: [local] Application: psql
13 1s868ms 30s350ms 13s54ms 6 1m18s 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 12 20 3 40s297ms 13s432ms 23 3 38s29ms 12s676ms [ User: intelifix - Total duration: 1m18s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m18s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-12 20:06:56 Duration: 30s350ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-12 23:19:52 Duration: 29s442ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-12 20:10:54 Duration: 8s78ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 2s680ms 28s697ms 12s668ms 6 1m16s 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 12 20 3 38s542ms 12s847ms 23 3 37s469ms 12s489ms [ User: intelifix - Total duration: 1m16s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m16s - 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-12 20:09:44 Duration: 28s697ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:40:32 Duration: 28s326ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 20:11:22 Duration: 6s536ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 3s532ms 20s314ms 11s785ms 4 47s140ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 12 20 2 23s846ms 11s923ms 23 2 23s293ms 11s646ms [ User: intelifix - Total duration: 47s140ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 47s140ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-12 20:04:38 Duration: 20s314ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-12 23:17:55 Duration: 19s695ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-12 23:41:35 Duration: 3s597ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1s688ms 19s443ms 10s117ms 6 1m copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 12 20 3 30s882ms 10s294ms 23 3 29s825ms 9s941ms [ User: intelifix - Total duration: 1m - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 23:16:09 Duration: 19s443ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 20:02:46 Duration: 19s380ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 20:10:07 Duration: 9s513ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1s683ms 20s120ms 9s792ms 6 58s754ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 12 20 3 29s459ms 9s819ms 23 3 29s294ms 9s764ms [ User: intelifix - Total duration: 58s754ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s754ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 20:03:22 Duration: 20s120ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 23:16:43 Duration: 19s819ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-12 23:41:18 Duration: 7s791ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 1s297ms 24s6ms 9s331ms 6 55s987ms 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 #18
Day Hour Count Duration Avg duration Jul 12 20 3 30s421ms 10s140ms 23 3 25s565ms 8s521ms [ User: intelifix - Total duration: 55s987ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 55s987ms - 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-12 20:04:18 Duration: 24s6ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 23:17:35 Duration: 20s449ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 20:10:31 Duration: 4s793ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 1s530ms 15s166ms 7s567ms 6 45s404ms 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 #19
Day Hour Count Duration Avg duration Jul 12 20 3 22s351ms 7s450ms 23 3 23s53ms 7s684ms [ User: intelifix - Total duration: 45s404ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 45s404ms - 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-12 23:16:58 Duration: 15s166ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 20:03:37 Duration: 14s598ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-12 20:10:23 Duration: 6s222ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 3s568ms 9s300ms 6s634ms 6 39s809ms 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 12 20 3 21s528ms 7s176ms 23 3 18s281ms 6s93ms [ User: intelifix - Total duration: 39s809ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 39s809ms - 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-12 20:07:25 Duration: 9s300ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-12 20:11:08 Duration: 8s629ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-12 23:38:20 Duration: 7s526ms Database: rio User: intelifix Remote: [local] Application: pg_dump
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 12 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 17 1 0ms 0ms 19 1 0ms 0ms 20 2 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 14m54s - Times executed: 8 ]
[ Application: psql - Total duration: 14m54s - Times executed: 8 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 5,045 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 35 FATAL entries
- 1491 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,396 Max number of times the same event was reported
- 1,527 Total events found
Rank Times reported Error 1 1,396 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 12 00 60 01 59 02 59 03 59 04 59 05 59 06 59 07 58 08 59 09 59 10 60 11 57 12 58 13 53 14 59 15 56 16 60 17 53 18 53 19 59 20 60 21 59 22 60 23 59 - ERROR: prepared statement "_PLAN0000000029EC09A0" does not exist
- ERROR: prepared statement "_PLAN0000000029F312A0" does not exist
- ERROR: prepared statement "_PLAN0000000029F304F0" does not exist
Statement: DEALLOCATE "_PLAN0000000029EC09A0"
Date: 2026-07-12 00:00:06 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029F312A0"
Date: 2026-07-12 00:01:07 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029F304F0"
Date: 2026-07-12 00:02:07 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 45 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 12 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 1 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-12 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
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-12 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
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-12 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 12 08 3 09 3 10 3 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-12 08:00:07 Database: brasilia Application: psql User: intelifix Remote: [local]
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-12 08:20:10 Database: brasilia Application: psql User: intelifix Remote: [local]
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-12 08:40:08 Database: brasilia Application: psql User: intelifix Remote: [local]
4 26 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 12 00 1 03 1 05 1 06 1 07 1 14 1 21 18 22 2 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-12 00:02:17 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-12 03:37:47 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-12 05:40:25 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
5 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 12 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-12 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-12 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-12 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
6 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 12 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-12 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-12 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-12 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
7 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 12 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-12 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-12 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
8 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 12 03 1 - LOG: database system was shut down at 2026-07-12 03:05:02 -03
Date: 2026-07-12 03:05:03
9 1 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 12 12 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-12 12:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]