pgBadger-
Global information
- Generated on Sun Aug 9 23:50:08 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 9,153 log entries in 6s
- Log start from 2026-08-09 00:00:29 to 2026-08-09 23:49:32
-
Overview
Global Stats
- 141 Number of unique normalized queries
- 922 Number of queries
- 4h18m13s Total query duration
- 2026-08-09 00:02:05 First query
- 2026-08-09 23:44:03 Last query
- 4 queries/s at 2026-08-09 23:43:53 Query peak
- 4h18m13s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h18m13s Execute total duration
- 1,483 Number of events
- 7 Number of unique normalized events
- 1,417 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
- 239.57 MiB Max size of temporary file
- 111.38 MiB Average size of temporary file
- 206 Total number of sessions
- 7 sessions at 2026-08-09 15:05:01 Session peak
- 7d18h10m27s Total duration of sessions
- 54m13s Average duration of sessions
- 4 Average queries per session
- 1m15s Average queries duration per session
- 52m58s Average idle time per session
- 213 Total number of connections
- 4 connections/s at 2026-08-09 00:05:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-09 23:43:53 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-08-09 20:09:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-09 23:43:53 Date
Queries duration
Key values
- 4h18m13s 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) Aug 09 00 20 0ms 18s625ms 4s918ms 3s975ms 4s250ms 1m11s 01 12 0ms 4s365ms 2s93ms 3s772ms 4s154ms 4s885ms 02 12 0ms 3s787ms 2s10ms 3s706ms 4s71ms 4s371ms 03 13 0ms 4s284ms 1s804ms 1s417ms 4s427ms 4s693ms 04 12 0ms 4s799ms 2s235ms 3s895ms 4s362ms 5s53ms 05 17 0ms 9m40s 1m8s 9s250ms 2m38s 9m40s 06 18 0ms 8s607ms 3s131ms 4s258ms 4s875ms 28s587ms 07 18 0ms 14m45s 1m12s 4s568ms 2m8s 14m45s 08 24 0ms 5m57s 26s924ms 6s387ms 48s956ms 5m57s 09 24 0ms 5m48s 26s437ms 6s214ms 48s388ms 5m48s 10 24 0ms 6m2s 27s216ms 4s857ms 8s224ms 6m50s 11 24 0ms 5m48s 26s659ms 6s946ms 50s542ms 5m48s 12 24 0ms 5m42s 26s395ms 7s481ms 47s519ms 5m42s 13 24 0ms 5m39s 26s298ms 7s306ms 46s987ms 5m39s 14 29 0ms 5m48s 22s236ms 6s909ms 47s987ms 5m48s 15 24 0ms 5m46s 26s327ms 6s141ms 47s546ms 5m46s 16 24 0ms 5m54s 27s271ms 6s65ms 50s329ms 5m54s 17 24 0ms 5m50s 26s550ms 6s126ms 47s524ms 5m50s 18 27 0ms 5m46s 23s829ms 6s148ms 49s95ms 5m46s 19 24 0ms 5m49s 26s703ms 6s415ms 48s481ms 5m49s 20 116 0ms 10m18s 14s53ms 57s431ms 2m18s 10m32s 21 25 0ms 8m1s 30s645ms 5s843ms 7s289ms 8m47s 22 24 0ms 5m46s 26s646ms 6s27ms 49s370ms 5m46s 23 339 0ms 1m24s 5s989ms 1m9s 1m10s 2m Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 09 00 3 0 2s174ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 199ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 1s838ms 0ms 0ms 0ms 07 6 0 3m34s 0ms 0ms 3m52s 08 6 0 1m39s 0ms 0ms 3m11s 09 6 0 1m37s 0ms 0ms 3m11s 10 6 0 1m40s 0ms 0ms 3m12s 11 6 0 1m38s 0ms 0ms 3m11s 12 6 0 1m37s 0ms 0ms 3m13s 13 6 0 1m36s 0ms 0ms 3m14s 14 11 0 54s194ms 0ms 386ms 3m16s 15 6 0 1m37s 0ms 0ms 3m11s 16 6 0 1m41s 0ms 0ms 3m24s 17 6 0 1m38s 0ms 0ms 3m12s 18 9 0 1m6s 0ms 0ms 3m20s 19 6 0 1m39s 0ms 0ms 3m15s 20 16 81 16s216ms 33s888ms 57s431ms 4m18s 21 7 0 1m42s 0ms 0ms 3m10s 22 6 0 1m38s 0ms 0ms 3m17s 23 16 323 5s989ms 1m2s 1m9s 2m Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 09 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 Aug 09 00 0 0 0.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 1 1.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 4 4.00 0.00% Day Hour Count Average / Second Aug 09 00 16 0.00/s 01 8 0.00/s 02 7 0.00/s 03 14 0.00/s 04 8 0.00/s 05 10 0.00/s 06 14 0.00/s 07 8 0.00/s 08 8 0.00/s 09 7 0.00/s 10 8 0.00/s 11 7 0.00/s 12 7 0.00/s 13 8 0.00/s 14 9 0.00/s 15 8 0.00/s 16 8 0.00/s 17 8 0.00/s 18 7 0.00/s 19 8 0.00/s 20 12 0.00/s 21 7 0.00/s 22 8 0.00/s 23 8 0.00/s Day Hour Count Average Duration Average idle time Aug 09 00 3 43m20s 42m47s 01 14 1h1m15s 1h1m13s 02 7 1h1s 59m57s 03 13 23m49s 23m47s 04 8 1h3m 1h2m56s 05 8 54m8s 51m42s 06 8 59m23s 59m16s 07 13 59m9s 57m28s 08 8 57m30s 56m9s 09 7 1h50s 59m20s 10 7 1h 58m27s 11 8 1h22s 59m2s 12 6 1h1m2s 59m16s 13 7 1h2s 58m31s 14 8 1h2s 58m41s 15 10 55m18s 54m15s 16 7 1h2s 58m28s 17 9 55m8s 53m57s 18 7 1h1m42s 1h10s 19 7 1h1s 58m29s 20 12 41m34s 39m18s 21 8 1h23s 58m47s 22 7 56m26s 54m55s 23 14 36m56s 34m31s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-08-09 00:05:01 Date
Connections per database
Key values
- rio Main Database
- 213 connections Total
Connections per user
Key values
- intelifix Main User
- 213 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-08-09 15:05:01 Date
Histogram of session times
Key values
- 175 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 206 sessions Total
Sessions per user
Key values
- intelifix Main User
- 206 sessions Total
Sessions per host
Key values
- [local] Main Host
- 206 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 8,606 buffers Checkpoint Peak
- 2026-08-09 00:09:54 Date
- 270.033 seconds Highest write time
- 0.066 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-08-09 03:05:02 Date
Checkpoints distance
Key values
- 92.08 Mo Distance Peak
- 2026-08-09 03:05:02 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 09 00 8,606 270.033s 0.066s 270.112s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 8,371 0.393s 0.014s 0.425s 04 0 0s 0s 0s 05 6,155 616.773s 0.088s 616.903s 06 3,100 269.152s 0.027s 269.188s 07 1,099 110.304s 0.014s 110.348s 08 23 2.329s 0.005s 2.34s 09 22 2.228s 0.014s 2.249s 10 23 2.33s 0.004s 2.341s 11 23 2.328s 0.006s 2.34s 12 23 2.329s 0.064s 2.399s 13 22 2.228s 0.004s 2.239s 14 34 3.459s 0.009s 3.48s 15 23 2.329s 0.004s 2.341s 16 23 2.328s 0.005s 2.339s 17 22 2.224s 0.004s 2.235s 18 1,159 116.065s 0.071s 116.172s 19 23 2.328s 0.005s 2.339s 20 84 8.526s 0.016s 8.577s 21 22 2.228s 0.007s 2.244s 22 23 2.328s 0.005s 2.339s 23 22 2.225s 0.003s 2.234s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 09 00 0 0 3 32 0.046s 0.003s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 25 0.007s 0.002s 04 0 0 0 0 0s 0s 05 0 0 2 134 0.012s 0.007s 06 0 0 1 32 0.025s 0.001s 07 0 0 0 18 0.004s 0.006s 08 0 0 0 3 0.003s 0.002s 09 0 0 0 3 0.012s 0.005s 10 0 0 0 3 0.002s 0.002s 11 0 0 0 3 0.004s 0.002s 12 0 0 0 3 0.062s 0.022s 13 0 0 0 3 0.002s 0.002s 14 0 0 0 15 0.003s 0.003s 15 0 0 0 3 0.002s 0.002s 16 0 0 0 3 0.003s 0.002s 17 0 0 0 3 0.003s 0.002s 18 0 0 1 73 0.063s 0.035s 19 0 0 0 3 0.003s 0.002s 20 0 0 0 12 0.004s 0.008s 21 0 0 0 3 0.004s 0.003s 22 0 0 0 3 0.003s 0.002s 23 0 0 0 1 0.003s 0.003s Day Hour Count Avg time (sec) Aug 09 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 Aug 09 00 38,060.00 kB 38,060.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 23,572.50 kB 23,572.50 kB 04 0.00 kB 0.00 kB 05 9,266.00 kB 10,757.00 kB 06 8,668.00 kB 14,063.00 kB 07 1,362.00 kB 11,338.50 kB 08 181.00 kB 8,684.00 kB 09 180.00 kB 7,834.00 kB 10 181.00 kB 7,068.00 kB 11 181.00 kB 6,380.00 kB 12 180.00 kB 5,760.00 kB 13 180.00 kB 5,202.00 kB 14 108.50 kB 4,466.50 kB 15 181.00 kB 3,828.00 kB 16 181.00 kB 3,463.00 kB 17 180.00 kB 3,135.00 kB 18 937.50 kB 2,927.50 kB 19 181.00 kB 2,275.00 kB 20 199.75 kB 1,805.00 kB 21 180.00 kB 1,423.00 kB 22 181.00 kB 1,299.00 kB 23 74.00 kB 1,177.00 kB -
Temporary Files
Size of temporary files
Key values
- 479.14 MiB Temp Files size Peak
- 2026-08-09 05:31:55 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-09 05:30:38 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 09 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.09 GiB 111.38 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 930.87 MiB 71.46 MiB 239.57 MiB 116.36 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-09 05:32:03 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-09 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 182.94 MiB 91.47 MiB 91.47 MiB 91.47 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-09 05:30:41 Duration: 39s144ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-09 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 239.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-09 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 239.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-09 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 91.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-09 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 91.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-09 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 79.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-09 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 79.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-09 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 79.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-09 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 71.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-09 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 71.46 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-09 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.46 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-09 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.19 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-08-09 05:09:52 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.19 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-08-09 05:09:52 Date
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_statistic (1) Main table vacuumed on database 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_catalog.pg_statistic 1 1 0 0 0 0 0 2,474 1,065 3,336,795 1,021 7,115 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 158 64 283,153 19 45 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,181 12 173,274 5 44 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 813 101 671,445 72 283 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 160 7 23,761 2 7 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,991 273 1,400,720 250 1,569 Total 6 6 0 0 0 0 0 8,777 1,522 5,889,148 1,369 9,063 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.19) 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 (4600) Main table with removed tuples on database rio
- 13864 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,600 7,472 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,481 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,922 7,346 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 634 676 0 20 259 brasilia.pg_toast.pg_toast_2619 1 1 115 135 0 0 61 contagem.pg_toast.pg_toast_2619 1 1 112 115 0 17 48 Total 6 6 13,864 23,018 0 37 3,737 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (20) Main table with removed pages on database rio
- 37 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_toast.pg_toast_2619 1 1 634 20 contagem.pg_toast.pg_toast_2619 1 1 112 17 brasilia.pg_catalog.pg_statistic 1 1 3922 0 brasilia.pg_toast.pg_toast_2619 1 1 115 0 contagem.pg_catalog.pg_statistic 1 1 4481 0 rio.pg_catalog.pg_statistic 1 1 4600 0 Total 6 6 13,864 37 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 09 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.19 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
- 404 Total write queries
Queries by database
Key values
- rio Main database
- 389 Requests
- 2h54m56s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 909 Requests
User Request type Count Duration etiquetas Total 6 2s555ms select 6 2s555ms intelifix Total 909 4h17m58s copy to 404 42m26s others 380 35m58s select 125 2h59m33s lenon Total 7 12s584ms select 7 12s584ms Duration by user
Key values
- 4h17m58s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 6 2s555ms select 6 2s555ms intelifix Total 909 4h17m58s copy to 404 42m26s others 380 35m58s select 125 2h59m33s lenon Total 7 12s584ms select 7 12s584ms Queries by host
Key values
- [local] Main host
- 922 Requests
- 4h18m13s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 486 Requests
- 3h35m36s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-09 09:27:03 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 418 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 14m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-09 07:19:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 10m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-09 20:15:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m40s analyze verbose;[ Date: 2026-08-09 05:09:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-09 21:13:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-09 10:11:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-09 08:10:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-09 16:10:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-09 17:10:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-09 19:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-09 11:10:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-09 09:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-09 14:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-09 15:10:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-09 22:10:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-09 18:10:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-09 12:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-09 13:10:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m40s analyze verbose;[ Date: 2026-08-09 05:14:23 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
19 4m11s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-09 20:22:24 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m45s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-09 07:26:19 - 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 1h54m19s 48 1s295ms 14m45s 2m22s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 09 07 3 15m29s 5m9s 08 3 6m14s 2m4s 09 3 6m5s 2m1s 10 3 6m21s 2m7s 11 3 6m7s 2m2s 12 3 6m 2m 13 3 5m57s 1m59s 14 3 6m5s 2m1s 15 3 6m4s 2m1s 16 3 6m13s 2m4s 17 3 6m7s 2m2s 18 3 6m3s 2m1s 19 3 6m8s 2m2s 20 3 10m57s 3m39s 21 3 8m18s 2m46s 22 3 6m3s 2m1s [ User: intelifix - Total duration: 1h54m19s - Times executed: 48 ]
[ Application: psql - Total duration: 1h54m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-09 07:19:46 Duration: 14m45s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-09 20:15:20 Duration: 10m18s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-09 21:13:03 Duration: 8m1s Database: rio User: intelifix Remote: [local] Application: psql
2 1h5m4s 48 187ms 4m11s 1m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 09 07 3 5m55s 1m58s 08 3 3m44s 1m14s 09 3 3m42s 1m14s 10 3 3m41s 1m13s 11 3 3m43s 1m14s 12 3 3m43s 1m14s 13 3 3m44s 1m14s 14 3 3m46s 1m15s 15 3 3m42s 1m14s 16 3 3m56s 1m18s 17 3 3m42s 1m14s 18 3 3m52s 1m17s 19 3 3m45s 1m15s 20 3 6m32s 2m10s 21 3 3m40s 1m13s 22 3 3m49s 1m16s [ User: intelifix - Total duration: 1h5m4s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m4s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-09 20:22:24 Duration: 4m11s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-09 07:26:19 Duration: 3m45s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-09 16:15:09 Duration: 3m22s Database: brasilia User: intelifix Remote: [local] Application: psql
3 16m59s 3 2m38s 9m40s 5m39s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 09 05 3 16m59s 5m39s [ User: intelifix - Total duration: 16m59s - Times executed: 3 ]
[ Application: psql - Total duration: 16m59s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-09 05:09:42 Duration: 9m40s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-09 05:14:23 Duration: 4m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-09 05:17:01 Duration: 2m38s Database: contagem User: intelifix Remote: [local] Application: psql
4 10m23s 275 241ms 18s577ms 2s267ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 09 00 12 41s463ms 3s455ms 01 12 25s126ms 2s93ms 02 12 24s124ms 2s10ms 03 11 22s762ms 2s69ms 04 12 26s830ms 2s235ms 05 12 29s698ms 2s474ms 06 12 27s76ms 2s256ms 07 12 25s901ms 2s158ms 08 12 25s720ms 2s143ms 09 12 25s649ms 2s137ms 10 12 27s964ms 2s330ms 11 12 25s940ms 2s161ms 12 12 25s808ms 2s150ms 13 12 25s771ms 2s147ms 14 12 26s1ms 2s166ms 15 12 26s245ms 2s187ms 16 12 25s692ms 2s141ms 17 12 25s764ms 2s147ms 18 12 26s384ms 2s198ms 19 12 26s403ms 2s200ms 20 12 33s893ms 2s824ms 21 12 26s763ms 2s230ms 22 12 26s658ms 2s221ms [ User: intelifix - Total duration: 10m23s - Times executed: 275 ]
[ Application: psql - Total duration: 10m23s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-09 00:05:20 Duration: 18s577ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-09 20:15:13 Duration: 11s749ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-09 05:05:10 Duration: 8s877ms Database: rio User: intelifix Remote: [local] Application: psql
5 3m9s 54 2s801ms 5s6ms 3s509ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 09 08 4 12s614ms 3s153ms 09 4 14s 3s500ms 10 3 11s703ms 3s901ms 11 3 11s630ms 3s876ms 12 4 16s671ms 4s167ms 13 4 16s316ms 4s79ms 14 3 11s574ms 3s858ms 15 3 9s338ms 3s112ms 16 4 12s812ms 3s203ms 17 3 9s25ms 3s8ms 18 4 12s723ms 3s180ms 19 4 13s572ms 3s393ms 20 3 11s272ms 3s757ms 21 4 13s473ms 3s368ms 22 4 12s758ms 3s189ms [ User: intelifix - Total duration: 3m9s - Times executed: 54 ]
[ Application: psql - Total duration: 3m9s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-09 12:00:10 Duration: 5s6ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-09 20:20:11 Duration: 4s623ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-09 11:00:09 Duration: 4s622ms Database: brasilia User: intelifix Remote: [local] Application: psql
6 2m57s 4 4s544ms 1m24s 44s386ms 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 Aug 09 20 2 1m28s 44s34ms 23 2 1m29s 44s739ms [ User: intelifix - Total duration: 2m57s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m57s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-09 23:16:22 Duration: 1m24s 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-08-09 20:08:32 Duration: 1m23s 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-08-09 23:34:18 Duration: 4s788ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 2m9s 36 2s957ms 4s929ms 3s594ms 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 #7
Day Hour Count Duration Avg duration Aug 09 08 2 8s812ms 4s406ms 09 2 6s944ms 3s472ms 10 3 10s523ms 3s507ms 11 3 11s454ms 3s818ms 12 2 7s460ms 3s730ms 13 2 7s376ms 3s688ms 14 3 11s133ms 3s711ms 15 3 9s772ms 3s257ms 16 2 6s385ms 3s192ms 17 3 11s611ms 3s870ms 18 2 6s444ms 3s222ms 19 2 6s806ms 3s403ms 20 3 11s831ms 3s943ms 21 2 6s429ms 3s214ms 22 2 6s414ms 3s207ms [ User: intelifix - Total duration: 2m9s - Times executed: 36 ]
[ Application: psql - Total duration: 2m9s - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-08-09 20:20:06 Duration: 4s929ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-08-09 14:20:06 Duration: 4s681ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-08-09 17:20:06 Duration: 4s665ms Database: rio User: intelifix Remote: [local] Application: psql
8 1m49s 4 422ms 55s798ms 27s339ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 09 20 2 56s221ms 28s110ms 23 2 53s136ms 26s568ms [ User: intelifix - Total duration: 1m49s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m49s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-09 20:05:24 Duration: 55s798ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-09 23:13:18 Duration: 52s542ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-09 23:33:44 Duration: 593ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1m29s 6 2s723ms 33s763ms 14s919ms 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 #9
Day Hour Count Duration Avg duration Aug 09 20 3 45s237ms 15s79ms 23 3 44s281ms 14s760ms [ User: intelifix - Total duration: 1m29s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m29s - 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-08-09 20:05:59 Duration: 33s763ms 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-08-09 23:13:52 Duration: 32s688ms 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-08-09 20:09:54 Duration: 8s750ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 1m21s 1 1m21s 1m21s 1m21s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 09 05 1 1m21s 1m21s [ User: intelifix - Total duration: 1m21s - Times executed: 1 ]
[ Application: psql - Total duration: 1m21s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-09 05:32:03 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-09 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
11 1m13s 6 1s860ms 28s63ms 12s245ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 09 20 3 36s90ms 12s30ms 23 3 37s380ms 12s460ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-09 23:14:23 Duration: 28s63ms 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-08-09 20:06:31 Duration: 27s649ms 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-08-09 23:34:01 Duration: 7s133ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1m12s 6 7s36ms 18s625ms 12s111ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 09 00 3 48s892ms 16s297ms 06 3 23s773ms 7s924ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: psql - Total duration: 1m12s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-09 00:05:20 Duration: 18s625ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-09 00:05:50 Duration: 16s515ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-09 00:05:34 Duration: 13s752ms Database: brasilia User: intelifix Remote: [local] Application: psql
13 1m8s 6 2s938ms 26s922ms 11s393ms 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 #13
Day Hour Count Duration Avg duration Aug 09 20 3 35s173ms 11s724ms 23 3 33s186ms 11s62ms [ User: intelifix - Total duration: 1m8s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m8s - 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-08-09 20:08:58 Duration: 26s922ms 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-08-09 23:16:46 Duration: 24s113ms 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-08-09 23:34:24 Duration: 6s135ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 59s320ms 6 1s595ms 20s891ms 9s886ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 09 20 3 30s432ms 10s144ms 23 3 28s888ms 9s629ms [ User: intelifix - Total duration: 59s320ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s320ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-09 20:03:19 Duration: 20s891ms 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-08-09 23:11:16 Duration: 19s748ms 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-08-09 23:33:25 Duration: 7s543ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 57s788ms 6 1s821ms 19s89ms 9s631ms 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 Aug 09 20 3 29s425ms 9s808ms 23 3 28s363ms 9s454ms [ User: intelifix - Total duration: 57s788ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s788ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-09 20:02:43 Duration: 19s89ms 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-08-09 23:10:42 Duration: 18s756ms 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-08-09 20:09:17 Duration: 8s41ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 54s771ms 6 1s335ms 21s929ms 9s128ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 09 20 3 26s902ms 8s967ms 23 3 27s869ms 9s289ms [ User: intelifix - Total duration: 54s771ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 54s771ms - 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-08-09 23:12:07 Duration: 21s929ms 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-08-09 20:04:08 Duration: 21s347ms 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-08-09 23:33:39 Duration: 4s472ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 46s25ms 4 3s796ms 19s326ms 11s506ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 09 20 2 23s123ms 11s561ms 23 2 22s901ms 11s450ms [ User: intelifix - Total duration: 46s25ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 46s25ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-09 20:04:28 Duration: 19s326ms 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-08-09 23:12:25 Duration: 18s766ms 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-08-09 23:33:44 Duration: 4s135ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 43s44ms 6 1s378ms 14s6ms 7s174ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 09 20 3 20s471ms 6s823ms 23 3 22s572ms 7s524ms [ User: intelifix - Total duration: 43s44ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 43s44ms - 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-08-09 23:11:30 Duration: 14s6ms 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-08-09 20:03:32 Duration: 12s868ms 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-08-09 23:33:32 Duration: 6s772ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 39s144ms 1 39s144ms 39s144ms 39s144ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 09 05 1 39s144ms 39s144ms [ User: intelifix - Total duration: 39s144ms - Times executed: 1 ]
[ Application: psql - Total duration: 39s144ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-09 05:30:41 Duration: 39s144ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-09 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
20 34s784ms 6 905ms 14s726ms 5s797ms 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 #20
Day Hour Count Duration Avg duration Aug 09 20 3 18s62ms 6s20ms 23 3 16s721ms 5s573ms [ User: intelifix - Total duration: 34s784ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 34s784ms - 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-08-09 20:02:58 Duration: 14s726ms 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-08-09 23:10:56 Duration: 13s345ms 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-08-09 20:09:20 Duration: 2s430ms 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 275 10m23s 241ms 18s577ms 2s267ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 09 00 12 41s463ms 3s455ms 01 12 25s126ms 2s93ms 02 12 24s124ms 2s10ms 03 11 22s762ms 2s69ms 04 12 26s830ms 2s235ms 05 12 29s698ms 2s474ms 06 12 27s76ms 2s256ms 07 12 25s901ms 2s158ms 08 12 25s720ms 2s143ms 09 12 25s649ms 2s137ms 10 12 27s964ms 2s330ms 11 12 25s940ms 2s161ms 12 12 25s808ms 2s150ms 13 12 25s771ms 2s147ms 14 12 26s1ms 2s166ms 15 12 26s245ms 2s187ms 16 12 25s692ms 2s141ms 17 12 25s764ms 2s147ms 18 12 26s384ms 2s198ms 19 12 26s403ms 2s200ms 20 12 33s893ms 2s824ms 21 12 26s763ms 2s230ms 22 12 26s658ms 2s221ms [ User: intelifix - Total duration: 10m23s - Times executed: 275 ]
[ Application: psql - Total duration: 10m23s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-09 00:05:20 Duration: 18s577ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-09 20:15:13 Duration: 11s749ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-09 05:05:10 Duration: 8s877ms Database: rio User: intelifix Remote: [local] Application: psql
2 54 3m9s 2s801ms 5s6ms 3s509ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 09 08 4 12s614ms 3s153ms 09 4 14s 3s500ms 10 3 11s703ms 3s901ms 11 3 11s630ms 3s876ms 12 4 16s671ms 4s167ms 13 4 16s316ms 4s79ms 14 3 11s574ms 3s858ms 15 3 9s338ms 3s112ms 16 4 12s812ms 3s203ms 17 3 9s25ms 3s8ms 18 4 12s723ms 3s180ms 19 4 13s572ms 3s393ms 20 3 11s272ms 3s757ms 21 4 13s473ms 3s368ms 22 4 12s758ms 3s189ms [ User: intelifix - Total duration: 3m9s - Times executed: 54 ]
[ Application: psql - Total duration: 3m9s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-09 12:00:10 Duration: 5s6ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-09 20:20:11 Duration: 4s623ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-09 11:00:09 Duration: 4s622ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 48 1h54m19s 1s295ms 14m45s 2m22s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 09 07 3 15m29s 5m9s 08 3 6m14s 2m4s 09 3 6m5s 2m1s 10 3 6m21s 2m7s 11 3 6m7s 2m2s 12 3 6m 2m 13 3 5m57s 1m59s 14 3 6m5s 2m1s 15 3 6m4s 2m1s 16 3 6m13s 2m4s 17 3 6m7s 2m2s 18 3 6m3s 2m1s 19 3 6m8s 2m2s 20 3 10m57s 3m39s 21 3 8m18s 2m46s 22 3 6m3s 2m1s [ User: intelifix - Total duration: 1h54m19s - Times executed: 48 ]
[ Application: psql - Total duration: 1h54m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-09 07:19:46 Duration: 14m45s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-09 20:15:20 Duration: 10m18s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-09 21:13:03 Duration: 8m1s Database: rio User: intelifix Remote: [local] Application: psql
4 48 1h5m4s 187ms 4m11s 1m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 09 07 3 5m55s 1m58s 08 3 3m44s 1m14s 09 3 3m42s 1m14s 10 3 3m41s 1m13s 11 3 3m43s 1m14s 12 3 3m43s 1m14s 13 3 3m44s 1m14s 14 3 3m46s 1m15s 15 3 3m42s 1m14s 16 3 3m56s 1m18s 17 3 3m42s 1m14s 18 3 3m52s 1m17s 19 3 3m45s 1m15s 20 3 6m32s 2m10s 21 3 3m40s 1m13s 22 3 3m49s 1m16s [ User: intelifix - Total duration: 1h5m4s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m4s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-09 20:22:24 Duration: 4m11s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-09 07:26:19 Duration: 3m45s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-09 16:15:09 Duration: 3m22s Database: brasilia User: intelifix Remote: [local] Application: psql
5 36 2m9s 2s957ms 4s929ms 3s594ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 09 08 2 8s812ms 4s406ms 09 2 6s944ms 3s472ms 10 3 10s523ms 3s507ms 11 3 11s454ms 3s818ms 12 2 7s460ms 3s730ms 13 2 7s376ms 3s688ms 14 3 11s133ms 3s711ms 15 3 9s772ms 3s257ms 16 2 6s385ms 3s192ms 17 3 11s611ms 3s870ms 18 2 6s444ms 3s222ms 19 2 6s806ms 3s403ms 20 3 11s831ms 3s943ms 21 2 6s429ms 3s214ms 22 2 6s414ms 3s207ms [ User: intelifix - Total duration: 2m9s - Times executed: 36 ]
[ Application: psql - Total duration: 2m9s - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-08-09 20:20:06 Duration: 4s929ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-08-09 14:20:06 Duration: 4s681ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-08-09 17:20:06 Duration: 4s665ms Database: rio User: intelifix Remote: [local] Application: psql
6 7 1s911ms 153ms 513ms 273ms select p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault(?, p.proowner) as acldefault, p.pronamespace, p.proowner from pg_proc p left join pg_init_privs pip on (p.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?) where p.prokind <> ? and not exists ( select ? from pg_depend where classid = ?::regclass and objid = p.oid and deptype = ?) and (pronamespace != ( select oid from pg_namespace where nspname = ?) or exists ( select ? from pg_cast where pg_cast.oid > ? and p.oid = pg_cast.castfunc) or exists ( select ? from pg_transform where pg_transform.oid > ? and (p.oid = pg_transform.trffromsql or p.oid = pg_transform.trftosql)) or p.proacl is distinct from pip.initprivs);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 09 20 3 774ms 258ms 23 4 1s137ms 284ms [ User: intelifix - Total duration: 1s911ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 1s911ms - Times executed: 7 ]
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-09 23:10:02 Duration: 513ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-09 20:02:03 Duration: 356ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-09 20:10:25 Duration: 264ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 6 1m29s 2s723ms 33s763ms 14s919ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 09 20 3 45s237ms 15s79ms 23 3 44s281ms 14s760ms [ User: intelifix - Total duration: 1m29s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m29s - 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-08-09 20:05:59 Duration: 33s763ms 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-08-09 23:13:52 Duration: 32s688ms 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-08-09 20:09:54 Duration: 8s750ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 6 1m13s 1s860ms 28s63ms 12s245ms 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 Aug 09 20 3 36s90ms 12s30ms 23 3 37s380ms 12s460ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-09 23:14:23 Duration: 28s63ms 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-08-09 20:06:31 Duration: 27s649ms 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-08-09 23:34:01 Duration: 7s133ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 6 1m12s 7s36ms 18s625ms 12s111ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 09 00 3 48s892ms 16s297ms 06 3 23s773ms 7s924ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: psql - Total duration: 1m12s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-09 00:05:20 Duration: 18s625ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-09 00:05:50 Duration: 16s515ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-09 00:05:34 Duration: 13s752ms Database: brasilia User: intelifix Remote: [local] Application: psql
10 6 1m8s 2s938ms 26s922ms 11s393ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 09 20 3 35s173ms 11s724ms 23 3 33s186ms 11s62ms [ User: intelifix - Total duration: 1m8s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m8s - 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-08-09 20:08:58 Duration: 26s922ms 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-08-09 23:16:46 Duration: 24s113ms 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-08-09 23:34:24 Duration: 6s135ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 59s320ms 1s595ms 20s891ms 9s886ms 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 Aug 09 20 3 30s432ms 10s144ms 23 3 28s888ms 9s629ms [ User: intelifix - Total duration: 59s320ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s320ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-09 20:03:19 Duration: 20s891ms 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-08-09 23:11:16 Duration: 19s748ms 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-08-09 23:33:25 Duration: 7s543ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 6 57s788ms 1s821ms 19s89ms 9s631ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 09 20 3 29s425ms 9s808ms 23 3 28s363ms 9s454ms [ User: intelifix - Total duration: 57s788ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s788ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-09 20:02:43 Duration: 19s89ms 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-08-09 23:10:42 Duration: 18s756ms 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-08-09 20:09:17 Duration: 8s41ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 54s771ms 1s335ms 21s929ms 9s128ms 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 #13
Day Hour Count Duration Avg duration Aug 09 20 3 26s902ms 8s967ms 23 3 27s869ms 9s289ms [ User: intelifix - Total duration: 54s771ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 54s771ms - 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-08-09 23:12:07 Duration: 21s929ms 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-08-09 20:04:08 Duration: 21s347ms 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-08-09 23:33:39 Duration: 4s472ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 43s44ms 1s378ms 14s6ms 7s174ms 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 #14
Day Hour Count Duration Avg duration Aug 09 20 3 20s471ms 6s823ms 23 3 22s572ms 7s524ms [ User: intelifix - Total duration: 43s44ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 43s44ms - 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-08-09 23:11:30 Duration: 14s6ms 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-08-09 20:03:32 Duration: 12s868ms 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-08-09 23:33:32 Duration: 6s772ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 34s784ms 905ms 14s726ms 5s797ms 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 Aug 09 20 3 18s62ms 6s20ms 23 3 16s721ms 5s573ms [ User: intelifix - Total duration: 34s784ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 34s784ms - 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-08-09 20:02:58 Duration: 14s726ms 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-08-09 23:10:56 Duration: 13s345ms 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-08-09 20:09:20 Duration: 2s430ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 33s591ms 3s38ms 8s620ms 5s598ms 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 #16
Day Hour Count Duration Avg duration Aug 09 20 3 17s768ms 5s922ms 23 3 15s822ms 5s274ms [ User: intelifix - Total duration: 33s591ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 33s591ms - 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-08-09 20:06:55 Duration: 8s620ms 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-08-09 23:34:12 Duration: 6s854ms 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-08-09 20:10:11 Duration: 6s109ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 6 27s55ms 874ms 10s692ms 4s509ms 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 #17
Day Hour Count Duration Avg duration Aug 09 20 3 13s869ms 4s623ms 23 3 13s186ms 4s395ms [ User: intelifix - Total duration: 27s55ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s55ms - 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-08-09 20:02:21 Duration: 10s692ms 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-08-09 23:10:20 Duration: 10s27ms 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-08-09 23:33:07 Duration: 2s283ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 25s110ms 827ms 10s917ms 4s185ms 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 Aug 09 20 3 12s528ms 4s176ms 23 3 12s581ms 4s193ms [ User: intelifix - Total duration: 25s110ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 25s110ms - 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-08-09 23:11:45 Duration: 10s917ms 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-08-09 20:03:47 Duration: 10s676ms 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-08-09 20:10:40 Duration: 990ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 6 14s935ms 2s275ms 2s777ms 2s489ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 09 20 3 7s238ms 2s412ms 23 3 7s697ms 2s565ms [ User: intelifix - Total duration: 14s935ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 14s935ms - Times executed: 6 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-08-09 23:33:04 Duration: 2s777ms 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-08-09 20:02:09 Duration: 2s572ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-08-09 23:10:08 Duration: 2s498ms Database: rio User: intelifix Remote: [local] Application: pg_dump
20 6 13s491ms 486ms 4s284ms 2s248ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 09 20 3 6s782ms 2s260ms 23 3 6s709ms 2s236ms [ User: intelifix - Total duration: 13s491ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 13s491ms - Times executed: 6 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-08-09 20:03:36 Duration: 4s284ms 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-08-09 23:11:34 Duration: 4s86ms 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-08-09 23:33:34 Duration: 2s136ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m38s 9m40s 5m39s 3 16m59s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 09 05 3 16m59s 5m39s [ User: intelifix - Total duration: 16m59s - Times executed: 3 ]
[ Application: psql - Total duration: 16m59s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-09 05:09:42 Duration: 9m40s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-09 05:14:23 Duration: 4m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-09 05:17:01 Duration: 2m38s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s295ms 14m45s 2m22s 48 1h54m19s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 09 07 3 15m29s 5m9s 08 3 6m14s 2m4s 09 3 6m5s 2m1s 10 3 6m21s 2m7s 11 3 6m7s 2m2s 12 3 6m 2m 13 3 5m57s 1m59s 14 3 6m5s 2m1s 15 3 6m4s 2m1s 16 3 6m13s 2m4s 17 3 6m7s 2m2s 18 3 6m3s 2m1s 19 3 6m8s 2m2s 20 3 10m57s 3m39s 21 3 8m18s 2m46s 22 3 6m3s 2m1s [ User: intelifix - Total duration: 1h54m19s - Times executed: 48 ]
[ Application: psql - Total duration: 1h54m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-09 07:19:46 Duration: 14m45s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-09 20:15:20 Duration: 10m18s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-09 21:13:03 Duration: 8m1s Database: rio User: intelifix Remote: [local] Application: psql
3 1m21s 1m21s 1m21s 1 1m21s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 09 05 1 1m21s 1m21s [ User: intelifix - Total duration: 1m21s - Times executed: 1 ]
[ Application: psql - Total duration: 1m21s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-09 05:32:03 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-09 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 187ms 4m11s 1m21s 48 1h5m4s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 09 07 3 5m55s 1m58s 08 3 3m44s 1m14s 09 3 3m42s 1m14s 10 3 3m41s 1m13s 11 3 3m43s 1m14s 12 3 3m43s 1m14s 13 3 3m44s 1m14s 14 3 3m46s 1m15s 15 3 3m42s 1m14s 16 3 3m56s 1m18s 17 3 3m42s 1m14s 18 3 3m52s 1m17s 19 3 3m45s 1m15s 20 3 6m32s 2m10s 21 3 3m40s 1m13s 22 3 3m49s 1m16s [ User: intelifix - Total duration: 1h5m4s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m4s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-09 20:22:24 Duration: 4m11s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-09 07:26:19 Duration: 3m45s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-09 16:15:09 Duration: 3m22s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s544ms 1m24s 44s386ms 4 2m57s 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 Aug 09 20 2 1m28s 44s34ms 23 2 1m29s 44s739ms [ User: intelifix - Total duration: 2m57s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m57s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-09 23:16:22 Duration: 1m24s 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-08-09 20:08:32 Duration: 1m23s 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-08-09 23:34:18 Duration: 4s788ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 39s144ms 39s144ms 39s144ms 1 39s144ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 09 05 1 39s144ms 39s144ms [ User: intelifix - Total duration: 39s144ms - Times executed: 1 ]
[ Application: psql - Total duration: 39s144ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-09 05:30:41 Duration: 39s144ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-09 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
7 422ms 55s798ms 27s339ms 4 1m49s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 09 20 2 56s221ms 28s110ms 23 2 53s136ms 26s568ms [ User: intelifix - Total duration: 1m49s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m49s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-09 20:05:24 Duration: 55s798ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-09 23:13:18 Duration: 52s542ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-09 23:33:44 Duration: 593ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 2s723ms 33s763ms 14s919ms 6 1m29s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 09 20 3 45s237ms 15s79ms 23 3 44s281ms 14s760ms [ User: intelifix - Total duration: 1m29s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m29s - 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-08-09 20:05:59 Duration: 33s763ms 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-08-09 23:13:52 Duration: 32s688ms 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-08-09 20:09:54 Duration: 8s750ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1s860ms 28s63ms 12s245ms 6 1m13s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 09 20 3 36s90ms 12s30ms 23 3 37s380ms 12s460ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-09 23:14:23 Duration: 28s63ms 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-08-09 20:06:31 Duration: 27s649ms 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-08-09 23:34:01 Duration: 7s133ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 7s36ms 18s625ms 12s111ms 6 1m12s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 09 00 3 48s892ms 16s297ms 06 3 23s773ms 7s924ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: psql - Total duration: 1m12s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-09 00:05:20 Duration: 18s625ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-09 00:05:50 Duration: 16s515ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-09 00:05:34 Duration: 13s752ms Database: brasilia User: intelifix Remote: [local] Application: psql
11 3s796ms 19s326ms 11s506ms 4 46s25ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 09 20 2 23s123ms 11s561ms 23 2 22s901ms 11s450ms [ User: intelifix - Total duration: 46s25ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 46s25ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-09 20:04:28 Duration: 19s326ms 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-08-09 23:12:25 Duration: 18s766ms 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-08-09 23:33:44 Duration: 4s135ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s938ms 26s922ms 11s393ms 6 1m8s 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 #12
Day Hour Count Duration Avg duration Aug 09 20 3 35s173ms 11s724ms 23 3 33s186ms 11s62ms [ User: intelifix - Total duration: 1m8s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m8s - 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-08-09 20:08:58 Duration: 26s922ms 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-08-09 23:16:46 Duration: 24s113ms 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-08-09 23:34:24 Duration: 6s135ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1s595ms 20s891ms 9s886ms 6 59s320ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 09 20 3 30s432ms 10s144ms 23 3 28s888ms 9s629ms [ User: intelifix - Total duration: 59s320ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s320ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-09 20:03:19 Duration: 20s891ms 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-08-09 23:11:16 Duration: 19s748ms 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-08-09 23:33:25 Duration: 7s543ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1s821ms 19s89ms 9s631ms 6 57s788ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 09 20 3 29s425ms 9s808ms 23 3 28s363ms 9s454ms [ User: intelifix - Total duration: 57s788ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s788ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-09 20:02:43 Duration: 19s89ms 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-08-09 23:10:42 Duration: 18s756ms 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-08-09 20:09:17 Duration: 8s41ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1s335ms 21s929ms 9s128ms 6 54s771ms 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 #15
Day Hour Count Duration Avg duration Aug 09 20 3 26s902ms 8s967ms 23 3 27s869ms 9s289ms [ User: intelifix - Total duration: 54s771ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 54s771ms - 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-08-09 23:12:07 Duration: 21s929ms 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-08-09 20:04:08 Duration: 21s347ms 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-08-09 23:33:39 Duration: 4s472ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1s378ms 14s6ms 7s174ms 6 43s44ms 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 #16
Day Hour Count Duration Avg duration Aug 09 20 3 20s471ms 6s823ms 23 3 22s572ms 7s524ms [ User: intelifix - Total duration: 43s44ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 43s44ms - 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-08-09 23:11:30 Duration: 14s6ms 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-08-09 20:03:32 Duration: 12s868ms 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-08-09 23:33:32 Duration: 6s772ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 905ms 14s726ms 5s797ms 6 34s784ms 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 #17
Day Hour Count Duration Avg duration Aug 09 20 3 18s62ms 6s20ms 23 3 16s721ms 5s573ms [ User: intelifix - Total duration: 34s784ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 34s784ms - 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-08-09 20:02:58 Duration: 14s726ms 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-08-09 23:10:56 Duration: 13s345ms 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-08-09 20:09:20 Duration: 2s430ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 3s38ms 8s620ms 5s598ms 6 33s591ms 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 #18
Day Hour Count Duration Avg duration Aug 09 20 3 17s768ms 5s922ms 23 3 15s822ms 5s274ms [ User: intelifix - Total duration: 33s591ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 33s591ms - 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-08-09 20:06:55 Duration: 8s620ms 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-08-09 23:34:12 Duration: 6s854ms 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-08-09 20:10:11 Duration: 6s109ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 874ms 10s692ms 4s509ms 6 27s55ms 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 #19
Day Hour Count Duration Avg duration Aug 09 20 3 13s869ms 4s623ms 23 3 13s186ms 4s395ms [ User: intelifix - Total duration: 27s55ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s55ms - 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-08-09 20:02:21 Duration: 10s692ms 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-08-09 23:10:20 Duration: 10s27ms 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-08-09 23:33:07 Duration: 2s283ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 827ms 10s917ms 4s185ms 6 25s110ms 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 #20
Day Hour Count Duration Avg duration Aug 09 20 3 12s528ms 4s176ms 23 3 12s581ms 4s193ms [ User: intelifix - Total duration: 25s110ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 25s110ms - 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-08-09 23:11:45 Duration: 10s917ms 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-08-09 20:03:47 Duration: 10s676ms 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-08-09 20:10:40 Duration: 990ms Database: contagem 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 9 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 09 09 2 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 15 2 0ms 0ms 19 2 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 9m30s - Times executed: 9 ]
[ Application: psql - Total duration: 9m30s - Times executed: 9 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 4,884 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 16 FATAL entries
- 1466 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,417 Max number of times the same event was reported
- 1,483 Total events found
Rank Times reported Error 1 1,417 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 09 00 59 01 59 02 60 03 59 04 60 05 59 06 60 07 58 08 59 09 60 10 59 11 60 12 60 13 59 14 60 15 59 16 60 17 60 18 59 19 60 20 59 21 60 22 59 23 50 - ERROR: prepared statement "_PLAN0000000029B157C0" does not exist
- ERROR: prepared statement "_PLAN00000000297512A0" does not exist
- ERROR: prepared statement "_PLAN0000000029750060" does not exist
Statement: DEALLOCATE "_PLAN0000000029B157C0"
Date: 2026-08-09 00:00:29 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000297512A0"
Date: 2026-08-09 00:01:30 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029750060"
Date: 2026-08-09 00:02:30 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 Aug 09 00 2 01 2 02 2 03 1 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 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-08-09 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-08-09 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-08-09 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 09 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-08-09 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-09 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-09 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
4 7 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 09 00 1 01 1 04 1 05 1 06 1 08 1 11 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-09 00:02:09 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-09 01:33:14 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-09 04:23:44 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
5 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 09 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-08-09 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-09 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-09 05:32:03 Database: contagem Application: psql User: intelifix Remote: [local]
6 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 09 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-09 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-09 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
7 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 09 03 1 - LOG: database system was shut down at 2026-08-09 03:05:02 -03
Date: 2026-08-09 03:05:03