pgBadger-
Global information
- Generated on Sun Jul 5 23:50:08 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 18,984 log entries in 6s
- Log start from 2026-07-04 00:00:08 to 2026-07-04 23:59:28
-
Overview
Global Stats
- 177 Number of unique normalized queries
- 1,396 Number of queries
- 4h22m24s Total query duration
- 2026-07-04 00:02:04 First query
- 2026-07-04 23:55:09 Last query
- 4 queries/s at 2026-07-04 23:54:31 Query peak
- 4h22m24s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h22m24s Execute total duration
- 2,903 Number of events
- 9 Number of unique normalized events
- 2,792 Max number of times the same event was reported
- 0 Number of cancellation
- 70 Total number of automatic vacuums
- 125 Total number of automatic analyzes
- 10 Number temporary file
- 233.36 MiB Max size of temporary file
- 108.51 MiB Average size of temporary file
- 274 Total number of sessions
- 7 sessions at 2026-07-04 15:05:01 Session peak
- 10d15h36m8s Total duration of sessions
- 55m58s Average duration of sessions
- 5 Average queries per session
- 57s461ms Average queries duration per session
- 55m Average idle time per session
- 276 Total number of connections
- 6 connections/s at 2026-07-04 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-04 23:54:31 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-07-04 08:16:23 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-04 23:54:31 Date
Queries duration
Key values
- 4h22m24s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 04 00 27 0ms 17s693ms 3s996ms 4s632ms 6s619ms 1m15s 01 26 0ms 4s245ms 1s334ms 5s1ms 5s365ms 5s523ms 02 17 0ms 4s864ms 1s822ms 3s169ms 5s698ms 7s142ms 03 21 0ms 3s911ms 1s541ms 4s377ms 4s707ms 6s984ms 04 36 0ms 3s927ms 1s49ms 4s220ms 6s181ms 6s750ms 05 30 0ms 8m22s 35s428ms 7s958ms 2m26s 8m22s 06 19 0ms 9s268ms 2s852ms 3s333ms 3s986ms 31s282ms 07 58 0ms 7m20s 17s526ms 19s550ms 1m28s 7m20s 08 128 0ms 5m59s 6s775ms 13s173ms 26s225ms 6m46s 09 139 0ms 6m9s 5s131ms 7s310ms 14s463ms 6m46s 10 148 0ms 6m2s 5s204ms 7s844ms 20s791ms 6m47s 11 58 0ms 6m12s 11s677ms 3s741ms 16s380ms 6m51s 12 21 0ms 6m8s 30s674ms 3s615ms 15s668ms 6m44s 13 58 0ms 6m10s 11s649ms 3s619ms 12s499ms 6m58s 14 28 0ms 6m10s 22s754ms 3s703ms 4s995ms 6m56s 15 20 0ms 5m50s 31s42ms 3s541ms 46s660ms 5m50s 16 20 0ms 5m52s 31s134ms 3s788ms 43s509ms 5m52s 17 20 0ms 5m38s 30s385ms 3s576ms 45s360ms 5m38s 18 21 0ms 6m2s 30s875ms 3s404ms 4s381ms 6m50s 19 21 0ms 5m59s 30s711ms 3s553ms 7s860ms 6m45s 20 102 0ms 7m19s 12s672ms 56s216ms 1m56s 7m19s 21 23 0ms 5m54s 26s675ms 3s371ms 42s931ms 5m54s 22 21 0ms 6m17s 34s842ms 5s113ms 16s267ms 6m49s 23 334 0ms 2m 7s783ms 1m15s 1m34s 2m19s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 04 00 4 0 731ms 0ms 0ms 193ms 01 10 0 292ms 0ms 166ms 533ms 02 0 0 0ms 0ms 0ms 0ms 03 3 0 605ms 0ms 0ms 390ms 04 18 0 260ms 0ms 247ms 1s125ms 05 10 0 305ms 0ms 167ms 950ms 06 5 0 780ms 0ms 0ms 1s27ms 07 31 0 26s221ms 1s225ms 7s64ms 3m46s 08 77 0 9s21ms 2s86ms 4s656ms 3m46s 09 79 0 8s223ms 1s592ms 2s382ms 3m6s 10 91 0 7s544ms 1s803ms 2s800ms 3m49s 11 33 0 19s711ms 965ms 1s717ms 3m27s 12 6 0 1m43s 0ms 0ms 3m19s 13 42 0 15s204ms 742ms 1s746ms 3m21s 14 13 0 46s702ms 0ms 0ms 3m7s 15 6 0 1m39s 0ms 0ms 3m20s 16 6 0 1m39s 0ms 0ms 3m21s 17 6 0 1m37s 0ms 0ms 3m19s 18 6 0 1m43s 0ms 0ms 3m33s 19 6 0 1m42s 0ms 0ms 3m28s 20 9 80 14s125ms 11s186ms 56s216ms 3m43s 21 8 0 1m13s 0ms 0ms 3m12s 22 6 0 1m54s 0ms 0ms 4m22s 23 15 319 7s783ms 1m4s 1m15s 2m Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 04 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 04 00 0 0 0.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 2 2.00 0.00% 05 0 2 2.00 0.00% 06 0 1 1.00 0.00% 07 0 2 2.00 0.00% 08 0 3 3.00 0.00% 09 0 4 4.00 0.00% 10 0 3 3.00 0.00% 11 0 2 2.00 0.00% 12 0 0 0.00 0.00% 13 0 3 3.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 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 3 3.00 0.00% Day Hour Count Average / Second Jul 04 00 16 0.00/s 01 12 0.00/s 02 9 0.00/s 03 21 0.01/s 04 13 0.00/s 05 12 0.00/s 06 16 0.00/s 07 11 0.00/s 08 12 0.00/s 09 10 0.00/s 10 12 0.00/s 11 11 0.00/s 12 9 0.00/s 13 12 0.00/s 14 14 0.00/s 15 10 0.00/s 16 9 0.00/s 17 9 0.00/s 18 10 0.00/s 19 9 0.00/s 20 13 0.00/s 21 10 0.00/s 22 9 0.00/s 23 7 0.00/s Day Hour Count Average Duration Average idle time Jul 04 00 6 1h8s 59m50s 01 15 1h1m2s 1h1m 02 12 1h30s 1h27s 03 19 23m10s 23m8s 04 12 59m4s 59m1s 05 12 1h31s 59m2s 06 12 58m5s 58m 07 15 57m44s 56m36s 08 11 1h1s 58m42s 09 12 1h15s 59m15s 10 11 58m5s 56m55s 11 11 1h56s 59m54s 12 11 1h16s 59m18s 13 10 55m 53m53s 14 11 1h50s 59m52s 15 13 56m38s 55m50s 16 9 59m32s 58m23s 17 9 1h37s 59m30s 18 9 1h40s 59m28s 19 10 1h20s 59m15s 20 12 46m20s 44m32s 21 10 1h27s 59m26s 22 10 1h38s 59m24s 23 12 48m45s 45m9s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-07-04 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 276 connections Total
Connections per user
Key values
- intelifix Main User
- 276 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-07-04 15:05:01 Date
Histogram of session times
Key values
- 240 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 274 sessions Total
Sessions per user
Key values
- intelifix Main User
- 274 sessions Total
Sessions per host
Key values
- [local] Main Host
- 274 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 16,187 buffers Checkpoint Peak
- 2026-07-04 00:19:43 Date
- 269.887 seconds Highest write time
- 0.030 seconds Sync time
Checkpoints Wal files
Key values
- 6 files Wal files usage Peak
- 2026-07-04 08:29:37 Date
Checkpoints distance
Key values
- 177.79 Mo Distance Peak
- 2026-07-04 08:29:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 04 00 22,811 686.139s 0.04s 686.249s 01 2,918 293.319s 0.051s 293.449s 02 1,432 144.067s 0.039s 144.153s 03 1,685 168.738s 0.035s 168.843s 04 3,023 304.201s 0.049s 304.308s 05 8,996 856.079s 0.084s 856.222s 06 3,838 269.709s 0.004s 269.722s 07 16,886 1,388.638s 0.065s 1,388.781s 08 19,260 1,558.164s 0.124s 1,558.399s 09 6,021 605.476s 0.142s 605.714s 10 10,166 1,174.109s 0.162s 1,174.378s 11 3,655 367.234s 0.059s 367.345s 12 380 38.073s 0.006s 38.098s 13 4,815 483.462s 0.056s 483.594s 14 352 35.402s 0.014s 35.431s 15 21 2.134s 0.004s 2.145s 16 21 2.139s 0.004s 2.149s 17 21 2.129s 0.004s 2.138s 18 25 2.544s 0.005s 2.563s 19 21 2.134s 0.004s 2.144s 20 649 65.328s 0.019s 65.365s 21 192 19.331s 0.011s 19.356s 22 23 2.36s 0.005s 2.379s 23 78 7.863s 0.008s 7.891s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 04 00 0 0 6 592 0.003s 0.008s 01 0 0 1 602 0.003s 0.012s 02 0 0 0 430 0.003s 0.008s 03 0 0 1 358 0.002s 0.008s 04 0 0 1 645 0.003s 0.008s 05 0 0 4 617 0.012s 0.007s 06 0 0 0 9 0.002s 0.001s 07 0 0 14 809 0.005s 0.007s 08 0 0 16 1,271 0.005s 0.011s 09 0 0 2 1,303 0.009s 0.012s 10 0 0 7 1,538 0.004s 0.012s 11 0 0 1 691 0.003s 0.009s 12 0 0 0 7 0.002s 0.004s 13 0 0 2 752 0.003s 0.011s 14 0 0 0 114 0.003s 0.003s 15 0 0 0 3 0.003s 0.002s 16 0 0 0 3 0.002s 0.002s 17 0 0 0 3 0.002s 0.002s 18 0 0 0 4 0.002s 0.003s 19 0 0 0 3 0.002s 0.002s 20 0 0 0 36 0.003s 0.003s 21 0 0 0 34 0.003s 0.004s 22 0 0 0 5 0.002s 0.003s 23 0 0 0 9 0.003s 0.003s Day Hour Count Avg time (sec) Jul 04 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jul 04 00 15,112.29 kB 51,765.71 kB 01 1,335.91 kB 24,493.09 kB 02 1,028.43 kB 9,904.57 kB 03 1,084.25 kB 3,012.62 kB 04 1,914.75 kB 2,572.25 kB 05 8,915.14 kB 15,782.29 kB 06 7,120.00 kB 15,364.00 kB 07 32,437.43 kB 47,630.29 kB 08 25,621.50 kB 65,664.70 kB 09 3,656.50 kB 35,896.25 kB 10 8,845.75 kB 18,535.33 kB 11 2,151.62 kB 18,034.38 kB 12 788.33 kB 10,427.67 kB 13 2,698.00 kB 9,297.00 kB 14 814.00 kB 5,109.33 kB 15 166.00 kB 4,184.00 kB 16 166.00 kB 3,782.00 kB 17 166.00 kB 3,421.00 kB 18 91.00 kB 2,934.50 kB 19 166.00 kB 2,526.00 kB 20 2,178.00 kB 5,111.00 kB 21 234.33 kB 3,804.67 kB 22 86.00 kB 2,944.50 kB 23 1,257.33 kB 3,190.00 kB -
Temporary Files
Size of temporary files
Key values
- 466.72 MiB Temp Files size Peak
- 2026-07-04 05:32:08 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-04 05:32:14 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 04 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.06 GiB 108.51 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 906.61 MiB 69.61 MiB 233.36 MiB 113.33 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-04 05:32:17 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-04 05:32:08 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 178.47 MiB 89.23 MiB 89.23 MiB 89.23 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-04 05:30:42 Duration: 40s388ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-04 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 233.36 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-04 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 233.36 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-04 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 89.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-04 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 89.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-04 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 77.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-04 05:32:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 76.98 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-04 05:32:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 76.96 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-04 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 69.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-04 05:32:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 69.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-04 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 69.61 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-04 05:32:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 1.41 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database brasilia - 2026-07-04 00:06:29 Date
- 0 sec Highest CPU-cost analyze
Table
Database brasilia - Date
Average Autovacuum Duration
Key values
- 1.41 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database brasilia - 2026-07-04 00:06:29 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (20) Main table analyzed (database rio)
- 125 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 20 rio.public.temp0000284506 19 rio.public.temp0000284516 16 rio.pg_catalog.pg_type 12 rio.pg_catalog.pg_class 12 rio.public.temp0000284502 10 rio.pg_catalog.pg_index 8 rio.pg_catalog.pg_depend 7 rio.public.temp0000284508 6 rio.public.temp0000284518 3 rio.public.temp0000284510 2 rio.public.temp0000284504 2 brasilia.pg_catalog.pg_attribute 1 brasilia.auditor.auditor_2026_07 1 rio.pg_catalog.pg_shdepend 1 brasilia.pg_catalog.pg_shdepend 1 brasilia.public.temp0000235348 1 contagem.auditor.auditor_2026_07 1 brasilia.public.temp0000235352 1 brasilia.public.temp0000235350 1 Total 125 Vacuums per table
Key values
- public.temp0000284506 (18) Main table vacuumed on database rio
- 70 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000284506 18 0 0 0 0 0 0 26,072 1,695 3,627,566 0 0 rio.pg_catalog.pg_attribute 10 9 0 0 0 0 0 4,266 738 1,514,045 19 508 rio.pg_catalog.pg_type 8 7 0 0 0 0 0 678 164 229,504 4 8 rio.pg_catalog.pg_class 8 7 0 0 0 0 0 1,219 185 376,793 0 0 rio.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,546 383 564,377 3 24 rio.pg_catalog.pg_index 4 4 0 0 0 0 0 333 93 72,870 2 3 rio.public.temp0000284518 3 0 0 0 0 0 0 4,887 12 290,142 0 0 rio.public.temp0000284510 2 0 0 0 0 0 0 3,256 8 193,310 0 0 rio.pg_catalog.pg_statistic 2 2 0 0 0 0 0 4,349 661 2,983,896 467 2,703 rio.public.logs 1 0 0 0 0 0 0 2,049 1,840 2,230,597 95 2,370 rio.public.temp0000284516 1 0 0 0 0 0 0 118 6 7,938 0 0 template1.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 226 89 117,572 3 5 rio.public.temp0000284508 1 0 0 0 0 0 0 116 6 7,820 0 0 brasilia.auditor.auditor_2026_07 1 0 0 0 0 0 0 5,677 5,027 6,202,573 0 0 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 197 30 103,133 2 7 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,359 1,046 3,214,407 1,006 7,274 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 855 114 750,616 60 296 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,645 130 611,484 105 780 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 131 55 177,595 21 49 brasilia.pg_catalog.pg_index 1 1 0 0 0 0 0 65 30 21,459 0 0 Total 70 40 0 0 0 0 0 61,044 12,312 23,297,697 1,787 14,027 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (1.41) Max CPU elapsed for vacuum on database brasilia
- unknown (0 ms) Max I/O read time for vacuum on database brasilia
- unknown (0 ms) Max I/O write time for vacuum on database brasilia
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000284506 0 0 0.92 rio.pg_catalog.pg_attribute 0 0 0.57 rio.pg_catalog.pg_type 0 0 0.1 rio.pg_catalog.pg_class 0 0 0.13 rio.pg_catalog.pg_depend 0 0 0.23 rio.pg_catalog.pg_index 0 0 0.06 rio.public.temp0000284518 0 0 0.15 rio.public.temp0000284510 0 0 0.11 rio.pg_catalog.pg_statistic 0 0 0.32 rio.public.logs 0 0 0.91 rio.public.temp0000284516 0 0 0.01 template1.pg_catalog.pg_shdepend 0 0 0.04 rio.public.temp0000284508 0 0 0.01 brasilia.auditor.auditor_2026_07 0 0 1.41 brasilia.pg_toast.pg_toast_2619 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.12 rio.pg_toast.pg_toast_2619 0 0 0.06 brasilia.pg_catalog.pg_statistic 0 0 0.15 contagem.pg_toast.pg_toast_2619 0 0 0 brasilia.pg_catalog.pg_index 0 0 0.03 Total 0 0 5.33 Tuples removed per table
Key values
- pg_catalog.pg_attribute (36072) Main table with removed tuples on database rio
- 57204 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 10 9 36,072 227,043 11,608 91 5,650 rio.pg_catalog.pg_statistic 2 2 5,761 15,418 94 0 2,572 contagem.pg_catalog.pg_statistic 1 1 4,377 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,699 7,332 0 0 1,072 rio.pg_catalog.pg_type 8 7 2,763 18,832 1,168 10 580 rio.pg_catalog.pg_depend 4 4 1,368 76,961 1,890 0 748 rio.pg_catalog.pg_index 4 4 1,042 7,820 291 0 236 rio.pg_toast.pg_toast_2619 1 1 725 675 0 0 292 template1.pg_catalog.pg_shdepend 1 1 635 13,516 2 0 115 rio.pg_catalog.pg_class 8 7 283 30,841 2,913 0 971 brasilia.pg_catalog.pg_index 1 1 190 1,857 0 10 44 brasilia.pg_toast.pg_toast_2619 1 1 187 132 0 0 75 contagem.pg_toast.pg_toast_2619 1 1 102 115 0 0 53 rio.public.logs 1 0 0 16,030,313 0 0 640,489 rio.public.temp0000284510 2 0 0 45,827 0 0 3,328 rio.public.temp0000284516 1 0 0 2,161 0 18 110 rio.public.temp0000284508 1 0 0 2,113 0 20 108 rio.public.temp0000284518 3 0 0 68,751 0 0 4,992 brasilia.auditor.auditor_2026_07 1 0 0 681,884 0 0 30,637 rio.public.temp0000284506 18 0 0 412,412 0 0 29,952 Total 70 40 57,204 17,651,277 17,966 149 723,035 Pages removed per table
Key values
- pg_catalog.pg_attribute (91) Main table with removed pages on database rio
- 149 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_catalog.pg_attribute 10 9 36072 91 rio.public.temp0000284508 1 0 0 20 rio.public.temp0000284516 1 0 0 18 rio.pg_catalog.pg_type 8 7 2763 10 brasilia.pg_catalog.pg_index 1 1 190 10 rio.public.logs 1 0 0 0 rio.pg_catalog.pg_depend 4 4 1368 0 rio.public.temp0000284510 2 0 0 0 template1.pg_catalog.pg_shdepend 1 1 635 0 rio.public.temp0000284518 3 0 0 0 rio.pg_catalog.pg_index 4 4 1042 0 brasilia.auditor.auditor_2026_07 1 0 0 0 brasilia.pg_toast.pg_toast_2619 1 1 187 0 contagem.pg_catalog.pg_statistic 1 1 4377 0 rio.pg_toast.pg_toast_2619 1 1 725 0 rio.public.temp0000284506 18 0 0 0 brasilia.pg_catalog.pg_statistic 1 1 3699 0 rio.pg_catalog.pg_class 8 7 283 0 contagem.pg_toast.pg_toast_2619 1 1 102 0 rio.pg_catalog.pg_statistic 2 2 5761 0 Total 70 40 57,204 149 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 04 00 1 2 01 1 0 02 0 0 03 0 0 04 0 7 05 7 6 06 0 0 07 33 34 08 18 29 09 1 15 10 5 20 11 1 7 12 1 0 13 2 5 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 - 1.41 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
- 490 Total read queries
- 553 Total write queries
Queries by database
Key values
- rio Main database
- 896 Requests
- 3h43s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 1,361 Requests
User Request type Count Duration etiquetas Total 4 2s445ms select 4 2s445ms intelifix Total 1,361 4h22m5s copy to 399 51m47s ddl 154 7m14s others 353 29m37s select 455 2h53m25s lenon Total 31 16s429ms select 31 16s429ms Duration by user
Key values
- 4h22m5s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 4 2s445ms select 4 2s445ms intelifix Total 1,361 4h22m5s copy to 399 51m47s ddl 154 7m14s others 353 29m37s select 455 2h53m25s lenon Total 31 16s429ms select 31 16s429ms Queries by host
Key values
- [local] Main host
- 1,396 Requests
- 4h22m24s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 511 Requests
- 3h19m13s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-04 11:45:55 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 584 100-500ms duration
Slowest individual queries
Rank Duration Query 1 8m22s analyze verbose;[ Date: 2026-07-04 05:08:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-04 07:12:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-04 20:12:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-04 22:11:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-04 11:11:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-04 14:11:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-04 13:11:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-04 09:11:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-04 12:11:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-04 10:11:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-04 18:11:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-04 08:11:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-04 19:11:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-04 21:10:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-04 16:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-04 15:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-04 17:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m20s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-07-04 22:16:27 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
19 4m3s analyze verbose;[ Date: 2026-07-04 05:12:27 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m46s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-07-04 10:15:35 - 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 1h44m10s 48 1s19ms 7m20s 2m10s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 04 07 3 7m56s 2m38s 08 3 6m17s 2m5s 09 3 6m25s 2m8s 10 3 6m20s 2m6s 11 3 6m29s 2m9s 12 3 6m25s 2m8s 13 3 6m28s 2m9s 14 3 6m26s 2m8s 15 3 6m6s 2m2s 16 3 6m7s 2m2s 17 3 5m55s 1m58s 18 3 6m21s 2m7s 19 3 6m16s 2m5s 20 3 7m47s 2m35s 21 3 6m9s 2m3s 22 3 6m35s 2m11s [ User: intelifix - Total duration: 1h44m10s - Times executed: 48 ]
[ Application: psql - Total duration: 1h44m10s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-04 07:12:21 Duration: 7m20s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-04 20:12:21 Duration: 7m19s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-04 22:11:19 Duration: 6m17s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
2 1h4m32s 48 186ms 4m20s 1m20s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 04 07 3 4m39s 1m33s 08 3 3m55s 1m18s 09 3 3m41s 1m13s 10 3 4m15s 1m25s 11 3 4m 1m20s 12 3 3m54s 1m18s 13 3 3m49s 1m16s 14 3 3m37s 1m12s 15 3 3m50s 1m16s 16 3 3m50s 1m16s 17 3 3m48s 1m16s 18 3 4m2s 1m20s 19 3 3m56s 1m18s 20 3 4m36s 1m32s 21 3 3m40s 1m13s 22 3 4m52s 1m37s [ User: intelifix - Total duration: 1h4m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h4m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-04 22:16:27 Duration: 4m20s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-04 10:15:35 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-04 07:17:31 Duration: 3m40s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
3 14m52s 3 2m26s 8m22s 4m57s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 04 05 3 14m52s 4m57s [ User: intelifix - Total duration: 14m52s - Times executed: 3 ]
[ Application: psql - Total duration: 14m52s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-04 05:08:24 Duration: 8m22s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
analyze verbose;
Date: 2026-07-04 05:12:27 Duration: 4m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
analyze verbose;
Date: 2026-07-04 05:14:54 Duration: 2m26s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
4 9m1s 261 158ms 11s522ms 2s73ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 04 00 12 31s837ms 2s653ms 01 10 22s410ms 2s241ms 02 12 24s279ms 2s23ms 03 12 22s875ms 1s906ms 04 12 23s461ms 1s955ms 05 11 24s969ms 2s269ms 06 11 23s288ms 2s117ms 07 12 22s444ms 1s870ms 08 11 26s243ms 2s385ms 09 11 23s588ms 2s144ms 10 12 23s527ms 1s960ms 11 11 21s608ms 1s964ms 12 12 21s337ms 1s778ms 13 11 22s477ms 2s43ms 14 11 21s951ms 1s995ms 15 11 20s931ms 1s902ms 16 11 21s879ms 1s989ms 17 11 21s8ms 1s909ms 18 12 21s608ms 1s800ms 19 12 21s234ms 1s769ms 20 10 30s688ms 3s68ms 21 12 19s756ms 1s646ms 22 11 27s748ms 2s522ms [ User: intelifix - Total duration: 9m1s - Times executed: 261 ]
[ Application: psql - Total duration: 9m1s - Times executed: 261 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-04 00:05:24 Duration: 11s522ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-04 20:05:10 Duration: 9s247ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-04 08:55:09 Duration: 7s841ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
5 4m44s 25 9s87ms 38s656ms 11s386ms create table temp0000284506 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 04 07 13 2m44s 12s621ms 08 10 1m41s 10s100ms 09 2 19s589ms 9s794ms [ User: intelifix - Total duration: 4m44s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 4m44s - Times executed: 25 ]
-
CREATE TABLE temp0000284506 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-04 07:00:33 Duration: 38s656ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CREATE TABLE temp0000284506 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-04 07:50:19 Duration: 11s329ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CREATE TABLE temp0000284506 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-04 07:10:39 Duration: 11s296ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
6 3m4s 4 4s757ms 1m28s 46s160ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 04 20 2 1m30s 45s239ms 23 2 1m34s 47s82ms [ User: intelifix - Total duration: 3m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m4s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-04 23:41:45 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-04 20:08:26 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-04 23:52:51 Duration: 5s203ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
7 2m27s 3 6s91ms 1m58s 49s298ms copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 04 23 3 2m27s 49s298ms [ User: intelifix - Total duration: 2m27s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m27s - Times executed: 3 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-04 23:15:31 Duration: 1m58s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-04 23:54:06 Duration: 22s889ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-04 23:42:22 Duration: 6s91ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
8 2m21s 2 20s935ms 2m 1m10s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 04 23 2 2m21s 1m10s [ User: intelifix - Total duration: 2m21s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m21s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-04 23:13:32 Duration: 2m Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-04 23:53:43 Duration: 20s935ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
9 2m15s 190 151ms 2s516ms 714ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 04 08 34 30s277ms 890ms 09 45 30s250ms 672ms 10 56 37s895ms 676ms 11 22 18s178ms 826ms 13 28 16s940ms 605ms 14 5 2s170ms 434ms [ User: intelifix - Total duration: 2m15s - Times executed: 190 ]
[ Application: [unknown] - Total duration: 2m15s - Times executed: 190 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (262254, 450, '319009345665,D4B92F2E7311,BC9B6897673F,54A65C8B3923,383FB3A75D04,B42A0E1B4229,1062D0C5B01F,70037E9C51B2,A456CCE3E643,54A65C90C9DB,946A7726AF69,1062D0133AEF,70037E9C8F00,10C25A3CF7EE,A456CCE4A477,A456CCE7664A,BC9B68972B48,80D04A8FFBC3,D4B92F281A77,905851A6E402,80D04A916340,80D04A93207D,B42A0E1A27BA,80D04A90EDF2,70037E9F8F1D,905851A99A75,5C7695952324,90585147989D', '',046,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-04 10:21:38 Duration: 2s516ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (262252, 450, '11916485850068706694,8C444F6C93E1,E820E27D559C,E820E276481A,E820E23DDECB,8C444F9C23D6,8C444F367ADF,8C444F712161,E820E24F53C0,8C444F5219B8,942CB3401143,8C444F6636FC,8C444FC3B1ED,E820E29D5BB4,942CB3C995CE,8C444FD2C555,8C444FEE637E,E820E2ED7F87,8C444F3525DE', '',039,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-04 10:49:10 Duration: 2s116ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (261654, 304, '835192928005250,241694321636,241639065872,241605033045,241649236988,241616028595,241673244247,241627941925,241691154345,241596612324,241706603945,241617416172,241682722434,241689460623,241694369697,241703746988,241693095971,241620927895,241692869406,241667021216,241617766666,241637492341,241658203251,241637494462,241690569204', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-04 09:23:19 Duration: 2s37ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
10 1m51s 4 423ms 56s15ms 27s971ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 04 20 2 56s594ms 28s297ms 23 2 55s291ms 27s645ms [ User: intelifix - Total duration: 1m51s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m51s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-04 20:05:22 Duration: 56s15ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-04 23:19:13 Duration: 54s867ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-04 20:09:37 Duration: 579ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
11 1m47s 2 20s512ms 1m27s 53s757ms copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 04 23 2 1m47s 53s757ms [ User: intelifix - Total duration: 1m47s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-04 23:11:31 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-04 23:53:22 Duration: 20s512ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
12 1m34s 1 1m34s 1m34s 1m34s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 04 05 1 1m34s 1m34s [ User: intelifix - Total duration: 1m34s - Times executed: 1 ]
[ Application: psql - Total duration: 1m34s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-04 05:32:17 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-04 05:32:08 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
13 1m26s 6 2s100ms 33s734ms 14s346ms 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 #13
Day Hour Count Duration Avg duration Jul 04 20 3 40s916ms 13s638ms 23 3 45s160ms 15s53ms [ User: intelifix - Total duration: 1m26s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m26s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-04 23:19:48 Duration: 33s734ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-04 20:05:53 Duration: 30s183ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-04 23:43:17 Duration: 9s39ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
14 1m17s 6 8s657ms 17s693ms 12s989ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 04 00 3 50s928ms 16s976ms 06 3 27s8ms 9s2ms [ User: intelifix - Total duration: 1m17s - Times executed: 6 ]
[ Application: psql - Total duration: 1m17s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-04 00:05:52 Duration: 17s693ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-04 00:05:19 Duration: 17s516ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-04 00:05:35 Duration: 15s718ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
15 1m15s 6 1s714ms 32s35ms 12s594ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 04 20 3 34s841ms 11s613ms 23 3 40s724ms 13s574ms [ User: intelifix - Total duration: 1m15s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m15s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-04 23:20:24 Duration: 32s35ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-04 20:06:24 Duration: 27s261ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-04 23:43:24 Duration: 6s893ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
16 1m10s 6 3s259ms 27s777ms 11s683ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 04 20 3 33s722ms 11s240ms 23 3 36s376ms 12s125ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-07-04 23:42:12 Duration: 27s777ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-07-04 20:08:51 Duration: 25s249ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-07-04 23:52:56 Duration: 5s339ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
17 1m2s 32 368ms 11s814ms 1s949ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 04 00 6 21s872ms 3s645ms 01 6 9s354ms 1s559ms 02 5 6s706ms 1s341ms 03 5 7s433ms 1s486ms 04 6 9s635ms 1s605ms 05 4 7s377ms 1s844ms [ User: intelifix - Total duration: 1m2s - Times executed: 32 ]
[ Application: psql - Total duration: 1m2s - Times executed: 32 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-04 00:05:13 Duration: 11s814ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-04 05:15:05 Duration: 3s962ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-04 02:05:04 Duration: 2s990ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
18 59s214ms 6 1s894ms 19s617ms 9s869ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 04 20 3 29s633ms 9s877ms 23 3 29s581ms 9s860ms [ User: intelifix - Total duration: 59s214ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s214ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-04 23:16:27 Duration: 19s617ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-04 20:02:42 Duration: 19s453ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-04 20:09:10 Duration: 8s285ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
19 58s969ms 36 172ms 8s785ms 1s638ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 04 07 7 18s197ms 2s599ms 08 13 33s690ms 2s591ms 09 8 2s859ms 357ms 10 8 4s220ms 527ms [ User: intelifix - Total duration: 58s969ms - Times executed: 36 ]
[ Application: [unknown] - Total duration: 58s969ms - Times executed: 36 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026620, 0406 )', '/var/www/html/tmp/nf_carga_lotes_0406.xlsx');
Date: 2026-07-04 08:15:29 Duration: 8s785ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,437,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');
Date: 2026-07-04 08:46:55 Duration: 7s309ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,437,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');
Date: 2026-07-04 07:20:43 Duration: 5s504ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
20 57s503ms 6 1s560ms 19s988ms 9s583ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 04 20 3 29s3ms 9s667ms 23 3 28s499ms 9s499ms [ User: intelifix - Total duration: 57s503ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s503ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-04 20:03:16 Duration: 19s988ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-04 23:17:01 Duration: 19s816ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-04 20:09:20 Duration: 7s268ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 261 9m1s 158ms 11s522ms 2s73ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 04 00 12 31s837ms 2s653ms 01 10 22s410ms 2s241ms 02 12 24s279ms 2s23ms 03 12 22s875ms 1s906ms 04 12 23s461ms 1s955ms 05 11 24s969ms 2s269ms 06 11 23s288ms 2s117ms 07 12 22s444ms 1s870ms 08 11 26s243ms 2s385ms 09 11 23s588ms 2s144ms 10 12 23s527ms 1s960ms 11 11 21s608ms 1s964ms 12 12 21s337ms 1s778ms 13 11 22s477ms 2s43ms 14 11 21s951ms 1s995ms 15 11 20s931ms 1s902ms 16 11 21s879ms 1s989ms 17 11 21s8ms 1s909ms 18 12 21s608ms 1s800ms 19 12 21s234ms 1s769ms 20 10 30s688ms 3s68ms 21 12 19s756ms 1s646ms 22 11 27s748ms 2s522ms [ User: intelifix - Total duration: 9m1s - Times executed: 261 ]
[ Application: psql - Total duration: 9m1s - Times executed: 261 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-04 00:05:24 Duration: 11s522ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-04 20:05:10 Duration: 9s247ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-04 08:55:09 Duration: 7s841ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
2 190 2m15s 151ms 2s516ms 714ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 04 08 34 30s277ms 890ms 09 45 30s250ms 672ms 10 56 37s895ms 676ms 11 22 18s178ms 826ms 13 28 16s940ms 605ms 14 5 2s170ms 434ms [ User: intelifix - Total duration: 2m15s - Times executed: 190 ]
[ Application: [unknown] - Total duration: 2m15s - Times executed: 190 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (262254, 450, '319009345665,D4B92F2E7311,BC9B6897673F,54A65C8B3923,383FB3A75D04,B42A0E1B4229,1062D0C5B01F,70037E9C51B2,A456CCE3E643,54A65C90C9DB,946A7726AF69,1062D0133AEF,70037E9C8F00,10C25A3CF7EE,A456CCE4A477,A456CCE7664A,BC9B68972B48,80D04A8FFBC3,D4B92F281A77,905851A6E402,80D04A916340,80D04A93207D,B42A0E1A27BA,80D04A90EDF2,70037E9F8F1D,905851A99A75,5C7695952324,90585147989D', '',046,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-04 10:21:38 Duration: 2s516ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (262252, 450, '11916485850068706694,8C444F6C93E1,E820E27D559C,E820E276481A,E820E23DDECB,8C444F9C23D6,8C444F367ADF,8C444F712161,E820E24F53C0,8C444F5219B8,942CB3401143,8C444F6636FC,8C444FC3B1ED,E820E29D5BB4,942CB3C995CE,8C444FD2C555,8C444FEE637E,E820E2ED7F87,8C444F3525DE', '',039,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-04 10:49:10 Duration: 2s116ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (261654, 304, '835192928005250,241694321636,241639065872,241605033045,241649236988,241616028595,241673244247,241627941925,241691154345,241596612324,241706603945,241617416172,241682722434,241689460623,241694369697,241703746988,241693095971,241620927895,241692869406,241667021216,241617766666,241637492341,241658203251,241637494462,241690569204', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-04 09:23:19 Duration: 2s37ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
3 68 18s592ms 150ms 5s136ms 273ms create table temp0000284516 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 04 08 12 7s278ms 606ms 09 19 3s718ms 195ms 10 26 5s222ms 200ms 11 11 2s373ms 215ms [ User: intelifix - Total duration: 18s592ms - Times executed: 68 ]
[ Application: [unknown] - Total duration: 18s592ms - Times executed: 68 ]
-
CREATE TABLE temp0000284516 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-06-2026", "ate" :"04-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-04 08:21:54 Duration: 5s136ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CREATE TABLE temp0000284516 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-06-2026", "ate" :"04-07-2026", "nota-fiscal":"2123", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-04 10:53:41 Duration: 277ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CREATE TABLE temp0000284516 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-06-2026", "ate" :"04-07-2026", "nota-fiscal":"2123", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-04 09:05:01 Duration: 270ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
4 48 1h44m10s 1s19ms 7m20s 2m10s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 04 07 3 7m56s 2m38s 08 3 6m17s 2m5s 09 3 6m25s 2m8s 10 3 6m20s 2m6s 11 3 6m29s 2m9s 12 3 6m25s 2m8s 13 3 6m28s 2m9s 14 3 6m26s 2m8s 15 3 6m6s 2m2s 16 3 6m7s 2m2s 17 3 5m55s 1m58s 18 3 6m21s 2m7s 19 3 6m16s 2m5s 20 3 7m47s 2m35s 21 3 6m9s 2m3s 22 3 6m35s 2m11s [ User: intelifix - Total duration: 1h44m10s - Times executed: 48 ]
[ Application: psql - Total duration: 1h44m10s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-04 07:12:21 Duration: 7m20s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-04 20:12:21 Duration: 7m19s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-04 22:11:19 Duration: 6m17s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
5 48 1h4m32s 186ms 4m20s 1m20s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 04 07 3 4m39s 1m33s 08 3 3m55s 1m18s 09 3 3m41s 1m13s 10 3 4m15s 1m25s 11 3 4m 1m20s 12 3 3m54s 1m18s 13 3 3m49s 1m16s 14 3 3m37s 1m12s 15 3 3m50s 1m16s 16 3 3m50s 1m16s 17 3 3m48s 1m16s 18 3 4m2s 1m20s 19 3 3m56s 1m18s 20 3 4m36s 1m32s 21 3 3m40s 1m13s 22 3 4m52s 1m37s [ User: intelifix - Total duration: 1h4m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h4m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-04 22:16:27 Duration: 4m20s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-04 10:15:35 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-04 07:17:31 Duration: 3m40s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
6 38 48s335ms 712ms 7s860ms 1s271ms 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 #6
Day Hour Count Duration Avg duration Jul 04 08 3 5s139ms 1s713ms 09 3 3s243ms 1s81ms 10 2 2s302ms 1s151ms 11 3 2s805ms 935ms 12 2 2s171ms 1s85ms 13 2 2s65ms 1s32ms 14 3 3s59ms 1s19ms 15 3 2s872ms 957ms 16 3 2s744ms 914ms 17 2 1s857ms 928ms 18 2 1s878ms 939ms 19 3 9s955ms 3s318ms 20 2 3s677ms 1s838ms 21 3 2s681ms 893ms 22 2 1s878ms 939ms [ User: intelifix - Total duration: 48s335ms - Times executed: 38 ]
[ Application: psql - Total duration: 48s335ms - Times executed: 38 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-04 19:00:09 Duration: 7s860ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-04 08:00:03 Duration: 2s237ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-04 20:20:04 Duration: 2s142ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
7 36 58s969ms 172ms 8s785ms 1s638ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 04 07 7 18s197ms 2s599ms 08 13 33s690ms 2s591ms 09 8 2s859ms 357ms 10 8 4s220ms 527ms [ User: intelifix - Total duration: 58s969ms - Times executed: 36 ]
[ Application: [unknown] - Total duration: 58s969ms - Times executed: 36 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026620, 0406 )', '/var/www/html/tmp/nf_carga_lotes_0406.xlsx');
Date: 2026-07-04 08:15:29 Duration: 8s785ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,437,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');
Date: 2026-07-04 08:46:55 Duration: 7s309ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,437,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');
Date: 2026-07-04 07:20:43 Duration: 5s504ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
8 32 1m2s 368ms 11s814ms 1s949ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 04 00 6 21s872ms 3s645ms 01 6 9s354ms 1s559ms 02 5 6s706ms 1s341ms 03 5 7s433ms 1s486ms 04 6 9s635ms 1s605ms 05 4 7s377ms 1s844ms [ User: intelifix - Total duration: 1m2s - Times executed: 32 ]
[ Application: psql - Total duration: 1m2s - Times executed: 32 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-04 00:05:13 Duration: 11s814ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-04 05:15:05 Duration: 3s962ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-04 02:05:04 Duration: 2s990ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
9 25 4m44s 9s87ms 38s656ms 11s386ms create table temp0000284506 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 04 07 13 2m44s 12s621ms 08 10 1m41s 10s100ms 09 2 19s589ms 9s794ms [ User: intelifix - Total duration: 4m44s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 4m44s - Times executed: 25 ]
-
CREATE TABLE temp0000284506 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-04 07:00:33 Duration: 38s656ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CREATE TABLE temp0000284506 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-04 07:50:19 Duration: 11s329ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CREATE TABLE temp0000284506 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-04 07:10:39 Duration: 11s296ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
10 25 10s820ms 271ms 643ms 432ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 04 01 1 557ms 557ms 03 1 611ms 611ms 04 2 709ms 354ms 05 2 813ms 406ms 06 1 433ms 433ms 07 2 831ms 415ms 08 3 1s117ms 372ms 09 4 2s87ms 521ms 10 3 1s301ms 433ms 11 2 708ms 354ms 13 3 1s248ms 416ms 14 1 401ms 401ms [ User: lenon - Total duration: 10s820ms - Times executed: 25 ]
[ Application: [unknown] - Total duration: 10s820ms - Times executed: 25 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-04 09:10:28 Duration: 643ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-04 09:20:58 Duration: 632ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-04 10:05:10 Duration: 614ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-04.log
11 22 21s499ms 182ms 16s634ms 977ms create table temp0000284508 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 04 07 1 16s634ms 16s634ms 08 9 2s53ms 228ms 09 11 2s620ms 238ms 13 1 191ms 191ms [ User: intelifix - Total duration: 21s499ms - Times executed: 22 ]
[ Application: [unknown] - Total duration: 21s499ms - Times executed: 22 ]
-
CREATE TABLE temp0000284508 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-06-2026", "ate" :"04-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-04 07:21:47 Duration: 16s634ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CREATE TABLE temp0000284508 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-06-2026", "ate" :"04-07-2026", "nota-fiscal":"1065334", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-04 08:57:28 Duration: 292ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CREATE TABLE temp0000284508 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-06-2026", "ate" :"04-07-2026", "nota-fiscal":"1065334", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-04 09:30:45 Duration: 289ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
12 21 11s183ms 337ms 771ms 532ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 04 01 1 758ms 758ms 04 2 1s67ms 533ms 05 2 1s15ms 507ms 07 2 987ms 493ms 08 3 1s409ms 469ms 09 3 1s708ms 569ms 10 2 1s155ms 577ms 11 2 969ms 484ms 13 3 1s557ms 519ms 14 1 554ms 554ms [ User: intelifix - Total duration: 11s183ms - Times executed: 21 ]
[ Application: [unknown] - Total duration: 11s183ms - Times executed: 21 ]
-
select * from rs_menu_grants (450, 18, 1);
Date: 2026-07-04 10:05:10 Duration: 771ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
select * from rs_menu_grants (499, 0, 1);
Date: 2026-07-04 01:16:42 Duration: 758ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
select * from rs_menu_grants (450, 18, 1);
Date: 2026-07-04 09:10:28 Duration: 723ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
13 16 3s489ms 150ms 341ms 218ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 04 01 5 903ms 180ms 04 8 1s916ms 239ms 05 3 670ms 223ms [ User: intelifix - Total duration: 3s489ms - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3s489ms - Times executed: 16 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229896150516,229910788688,229892905361,229870965476,229914653152,229892585678,229919102430,229902445271', NULL, NULL, 0263, 00);
Date: 2026-07-04 04:35:46 Duration: 341ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_TRIAGEM (428, 5, '73', 2, '229897974453,229896806067,229876585463,229902048688,229913492646,229910052344,229914430426,229919776165,229914867392,229899621831,229870935978,229871671617,229901003144,229897484854', NULL, NULL, 0263, 00);
Date: 2026-07-04 04:27:35 Duration: 281ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229847354148,229846773149,229840862527,229847607382,229840779612,229847271234', NULL, NULL, 0160, 00);
Date: 2026-07-04 05:31:29 Duration: 278ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
14 15 5s784ms 307ms 512ms 385ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 04 07 5 1s950ms 390ms 08 7 2s729ms 389ms 10 3 1s104ms 368ms [ User: intelifix - Total duration: 5s784ms - Times executed: 15 ]
[ Application: [unknown] - Total duration: 5s784ms - Times executed: 15 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-04 07:34:09 Duration: 512ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-04 08:46:35 Duration: 502ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-04 10:43:09 Duration: 464ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
15 13 6s891ms 207ms 1s82ms 530ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 04 09 8 4s520ms 565ms 10 5 2s370ms 474ms [ User: intelifix - Total duration: 6s891ms - Times executed: 13 ]
[ Application: [unknown] - Total duration: 6s891ms - Times executed: 13 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0126729) LIMIT 1;
Date: 2026-07-04 09:33:09 Duration: 1s82ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0126659) LIMIT 1;
Date: 2026-07-04 09:47:14 Duration: 896ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0126661) LIMIT 1;
Date: 2026-07-04 10:08:44 Duration: 715ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
16 10 6s930ms 166ms 4s369ms 693ms create table temp0000284518 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 04 10 10 6s930ms 693ms [ User: intelifix - Total duration: 6s930ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 6s930ms - Times executed: 10 ]
-
CREATE TABLE temp0000284518 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-06-2026", "ate" :"04-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-04 10:13:58 Duration: 4s369ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CREATE TABLE temp0000284518 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-06-2026", "ate" :"04-07-2026", "nota-fiscal":"81039", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-04 10:21:03 Duration: 623ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CREATE TABLE temp0000284518 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-06-2026", "ate" :"04-07-2026", "nota-fiscal":"81039", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-04 10:14:06 Duration: 419ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
17 9 42s252ms 986ms 14s984ms 4s694ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 04 07 5 30s883ms 6s176ms 08 3 10s382ms 3s460ms 10 1 986ms 986ms [ User: intelifix - Total duration: 42s252ms - Times executed: 9 ]
[ Application: psql - Total duration: 42s252ms - Times executed: 9 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026623);
Date: 2026-07-04 07:21:29 Duration: 14s984ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026626);
Date: 2026-07-04 07:50:15 Duration: 7s426ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026627);
Date: 2026-07-04 08:15:45 Duration: 5s62ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
18 9 1s479ms 151ms 187ms 164ms select * from rs_modelo_barra_smartcard (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 04 08 2 348ms 174ms 09 2 343ms 171ms 10 3 470ms 156ms 11 1 163ms 163ms 13 1 154ms 154ms [ User: intelifix - Total duration: 1s479ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1s479ms - Times executed: 9 ]
-
SELECT * FROM RS_MODELO_BARRA_SMARTCARD (0181);
Date: 2026-07-04 09:30:39 Duration: 187ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_MODELO_BARRA_SMARTCARD (0137);
Date: 2026-07-04 08:46:57 Duration: 182ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_MODELO_BARRA_SMARTCARD (0154);
Date: 2026-07-04 08:42:10 Duration: 165ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
19 8 19s598ms 844ms 9s106ms 2s449ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 04 10 1 966ms 966ms 12 1 844ms 844ms 13 1 1s51ms 1s51ms 17 1 903ms 903ms 18 1 1s181ms 1s181ms 20 1 1s91ms 1s91ms 22 2 13s559ms 6s779ms [ User: intelifix - Total duration: 19s598ms - Times executed: 8 ]
[ Application: psql - Total duration: 19s598ms - Times executed: 8 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-04 22:40:15 Duration: 9s106ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-04 22:40:06 Duration: 4s453ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-04 18:20:03 Duration: 1s181ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
20 7 1s146ms 150ms 176ms 163ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 04 01 1 167ms 167ms 04 5 811ms 162ms 05 1 167ms 167ms [ User: intelifix - Total duration: 1s146ms - Times executed: 7 ]
[ Application: [unknown] - Total duration: 1s146ms - Times executed: 7 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-04 04:33:50 Duration: 176ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0305;
Date: 2026-07-04 01:23:47 Duration: 167ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-04 04:25:45 Duration: 167ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m26s 8m22s 4m57s 3 14m52s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 04 05 3 14m52s 4m57s [ User: intelifix - Total duration: 14m52s - Times executed: 3 ]
[ Application: psql - Total duration: 14m52s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-04 05:08:24 Duration: 8m22s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
analyze verbose;
Date: 2026-07-04 05:12:27 Duration: 4m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
analyze verbose;
Date: 2026-07-04 05:14:54 Duration: 2m26s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
2 1s19ms 7m20s 2m10s 48 1h44m10s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 04 07 3 7m56s 2m38s 08 3 6m17s 2m5s 09 3 6m25s 2m8s 10 3 6m20s 2m6s 11 3 6m29s 2m9s 12 3 6m25s 2m8s 13 3 6m28s 2m9s 14 3 6m26s 2m8s 15 3 6m6s 2m2s 16 3 6m7s 2m2s 17 3 5m55s 1m58s 18 3 6m21s 2m7s 19 3 6m16s 2m5s 20 3 7m47s 2m35s 21 3 6m9s 2m3s 22 3 6m35s 2m11s [ User: intelifix - Total duration: 1h44m10s - Times executed: 48 ]
[ Application: psql - Total duration: 1h44m10s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-04 07:12:21 Duration: 7m20s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-04 20:12:21 Duration: 7m19s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-04 22:11:19 Duration: 6m17s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
3 1m34s 1m34s 1m34s 1 1m34s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 04 05 1 1m34s 1m34s [ User: intelifix - Total duration: 1m34s - Times executed: 1 ]
[ Application: psql - Total duration: 1m34s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-04 05:32:17 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-04 05:32:08 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 186ms 4m20s 1m20s 48 1h4m32s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 04 07 3 4m39s 1m33s 08 3 3m55s 1m18s 09 3 3m41s 1m13s 10 3 4m15s 1m25s 11 3 4m 1m20s 12 3 3m54s 1m18s 13 3 3m49s 1m16s 14 3 3m37s 1m12s 15 3 3m50s 1m16s 16 3 3m50s 1m16s 17 3 3m48s 1m16s 18 3 4m2s 1m20s 19 3 3m56s 1m18s 20 3 4m36s 1m32s 21 3 3m40s 1m13s 22 3 4m52s 1m37s [ User: intelifix - Total duration: 1h4m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h4m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-04 22:16:27 Duration: 4m20s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-04 10:15:35 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-04 07:17:31 Duration: 3m40s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
5 20s935ms 2m 1m10s 2 2m21s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 04 23 2 2m21s 1m10s [ User: intelifix - Total duration: 2m21s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m21s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-04 23:13:32 Duration: 2m Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-04 23:53:43 Duration: 20s935ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
6 20s512ms 1m27s 53s757ms 2 1m47s copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 04 23 2 1m47s 53s757ms [ User: intelifix - Total duration: 1m47s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-04 23:11:31 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-04 23:53:22 Duration: 20s512ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
7 6s91ms 1m58s 49s298ms 3 2m27s copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 04 23 3 2m27s 49s298ms [ User: intelifix - Total duration: 2m27s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m27s - Times executed: 3 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-04 23:15:31 Duration: 1m58s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-04 23:54:06 Duration: 22s889ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-04 23:42:22 Duration: 6s91ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
8 4s757ms 1m28s 46s160ms 4 3m4s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 04 20 2 1m30s 45s239ms 23 2 1m34s 47s82ms [ User: intelifix - Total duration: 3m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m4s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-04 23:41:45 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-04 20:08:26 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-04 23:52:51 Duration: 5s203ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
9 423ms 56s15ms 27s971ms 4 1m51s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 04 20 2 56s594ms 28s297ms 23 2 55s291ms 27s645ms [ User: intelifix - Total duration: 1m51s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m51s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-04 20:05:22 Duration: 56s15ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-04 23:19:13 Duration: 54s867ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-04 20:09:37 Duration: 579ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
10 2s100ms 33s734ms 14s346ms 6 1m26s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 04 20 3 40s916ms 13s638ms 23 3 45s160ms 15s53ms [ User: intelifix - Total duration: 1m26s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m26s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-04 23:19:48 Duration: 33s734ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-04 20:05:53 Duration: 30s183ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-04 23:43:17 Duration: 9s39ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
11 8s657ms 17s693ms 12s989ms 6 1m17s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 04 00 3 50s928ms 16s976ms 06 3 27s8ms 9s2ms [ User: intelifix - Total duration: 1m17s - Times executed: 6 ]
[ Application: psql - Total duration: 1m17s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-04 00:05:52 Duration: 17s693ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-04 00:05:19 Duration: 17s516ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-04 00:05:35 Duration: 15s718ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
12 1s714ms 32s35ms 12s594ms 6 1m15s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 04 20 3 34s841ms 11s613ms 23 3 40s724ms 13s574ms [ User: intelifix - Total duration: 1m15s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m15s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-04 23:20:24 Duration: 32s35ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-04 20:06:24 Duration: 27s261ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-04 23:43:24 Duration: 6s893ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
13 3s259ms 27s777ms 11s683ms 6 1m10s 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 Jul 04 20 3 33s722ms 11s240ms 23 3 36s376ms 12s125ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-07-04 23:42:12 Duration: 27s777ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-07-04 20:08:51 Duration: 25s249ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-07-04 23:52:56 Duration: 5s339ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
14 9s87ms 38s656ms 11s386ms 25 4m44s create table temp0000284506 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 04 07 13 2m44s 12s621ms 08 10 1m41s 10s100ms 09 2 19s589ms 9s794ms [ User: intelifix - Total duration: 4m44s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 4m44s - Times executed: 25 ]
-
CREATE TABLE temp0000284506 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-04 07:00:33 Duration: 38s656ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CREATE TABLE temp0000284506 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-04 07:50:19 Duration: 11s329ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CREATE TABLE temp0000284506 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-04 07:10:39 Duration: 11s296ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-04.log
15 1s894ms 19s617ms 9s869ms 6 59s214ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 04 20 3 29s633ms 9s877ms 23 3 29s581ms 9s860ms [ User: intelifix - Total duration: 59s214ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s214ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-04 23:16:27 Duration: 19s617ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-04 20:02:42 Duration: 19s453ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-04 20:09:10 Duration: 8s285ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
16 1s560ms 19s988ms 9s583ms 6 57s503ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 04 20 3 29s3ms 9s667ms 23 3 28s499ms 9s499ms [ User: intelifix - Total duration: 57s503ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s503ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-04 20:03:16 Duration: 19s988ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-04 23:17:01 Duration: 19s816ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-04 20:09:20 Duration: 7s268ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-04.log
17 986ms 14s984ms 4s694ms 9 42s252ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 04 07 5 30s883ms 6s176ms 08 3 10s382ms 3s460ms 10 1 986ms 986ms [ User: intelifix - Total duration: 42s252ms - Times executed: 9 ]
[ Application: psql - Total duration: 42s252ms - Times executed: 9 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026623);
Date: 2026-07-04 07:21:29 Duration: 14s984ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026626);
Date: 2026-07-04 07:50:15 Duration: 7s426ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026627);
Date: 2026-07-04 08:15:45 Duration: 5s62ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
18 844ms 9s106ms 2s449ms 8 19s598ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 04 10 1 966ms 966ms 12 1 844ms 844ms 13 1 1s51ms 1s51ms 17 1 903ms 903ms 18 1 1s181ms 1s181ms 20 1 1s91ms 1s91ms 22 2 13s559ms 6s779ms [ User: intelifix - Total duration: 19s598ms - Times executed: 8 ]
[ Application: psql - Total duration: 19s598ms - Times executed: 8 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-04 22:40:15 Duration: 9s106ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-04 22:40:06 Duration: 4s453ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-04 18:20:03 Duration: 1s181ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
19 158ms 11s522ms 2s73ms 261 9m1s call rs_giga_triagem (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 04 00 12 31s837ms 2s653ms 01 10 22s410ms 2s241ms 02 12 24s279ms 2s23ms 03 12 22s875ms 1s906ms 04 12 23s461ms 1s955ms 05 11 24s969ms 2s269ms 06 11 23s288ms 2s117ms 07 12 22s444ms 1s870ms 08 11 26s243ms 2s385ms 09 11 23s588ms 2s144ms 10 12 23s527ms 1s960ms 11 11 21s608ms 1s964ms 12 12 21s337ms 1s778ms 13 11 22s477ms 2s43ms 14 11 21s951ms 1s995ms 15 11 20s931ms 1s902ms 16 11 21s879ms 1s989ms 17 11 21s8ms 1s909ms 18 12 21s608ms 1s800ms 19 12 21s234ms 1s769ms 20 10 30s688ms 3s68ms 21 12 19s756ms 1s646ms 22 11 27s748ms 2s522ms [ User: intelifix - Total duration: 9m1s - Times executed: 261 ]
[ Application: psql - Total duration: 9m1s - Times executed: 261 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-04 00:05:24 Duration: 11s522ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-04 20:05:10 Duration: 9s247ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-04 08:55:09 Duration: 7s841ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
20 368ms 11s814ms 1s949ms 32 1m2s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 04 00 6 21s872ms 3s645ms 01 6 9s354ms 1s559ms 02 5 6s706ms 1s341ms 03 5 7s433ms 1s486ms 04 6 9s635ms 1s605ms 05 4 7s377ms 1s844ms [ User: intelifix - Total duration: 1m2s - Times executed: 32 ]
[ Application: psql - Total duration: 1m2s - Times executed: 32 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-04 00:05:13 Duration: 11s814ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-04 05:15:05 Duration: 3s962ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-04 02:05:04 Duration: 2s990ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-04.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 7 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 04 10 1 0ms 0ms 12 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 3m51s - Times executed: 7 ]
[ Application: psql - Total duration: 3m51s - Times executed: 7 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 8,948 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
- 2886 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,792 Max number of times the same event was reported
- 2,903 Total events found
Rank Times reported Error 1 2,792 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 04 00 117 01 117 02 117 03 107 04 116 05 116 06 117 07 116 08 117 09 117 10 117 11 116 12 117 13 117 14 118 15 117 16 117 17 117 18 118 19 117 20 118 21 118 22 116 23 112 - ERROR: prepared statement "_PLAN0000000029F48A90" does not exist
- ERROR: prepared statement "_PLAN000000003D329070" does not exist
- ERROR: prepared statement "_PLAN000000002992AD30" does not exist
Statement: DEALLOCATE "_PLAN0000000029F48A90"
Date: 2026-07-04 00:00:08 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
Statement: DEALLOCATE "_PLAN000000003D329070"
Date: 2026-07-04 00:00:59 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
Statement: DEALLOCATE "_PLAN000000002992AD30"
Date: 2026-07-04 00:01:08 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
2 45 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 04 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 1 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-04 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-04 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-04 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
3 44 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 04 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 2 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-04 08:00:05 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-04 08:20:04 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-04 08:40:04 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
4 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 04 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-04 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
Date: 2026-07-04 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
Date: 2026-07-04 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
5 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 04 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-04 05:32:17 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-04 05:32:17 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-04 05:32:17 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
6 4 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 04 00 1 06 1 14 2 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-04 00:02:05 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
Date: 2026-07-04 06:02:05 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
Date: 2026-07-04 14:04:35 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
7 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 04 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-04 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
Date: 2026-07-04 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
Date: 2026-07-04 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log
8 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 04 03 1 - LOG: database system was shut down at 2026-07-04 03:05:01 -03
Date: 2026-07-04 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-04.log
9 1 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 04 12 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-04 12:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-04.log