pgBadger-
Global information
- Generated on Sat Jul 11 23:50:11 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 9,945 log entries in 9s
- Log start from 2026-07-11 00:00:51 to 2026-07-11 23:50:06
-
Overview
Global Stats
- 162 Number of unique normalized queries
- 954 Number of queries
- 4h18m14s Total query duration
- 2026-07-11 00:02:10 First query
- 2026-07-11 23:50:05 Last query
- 5 queries/s at 2026-07-11 23:49:53 Query peak
- 4h18m14s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h18m14s Execute total duration
- 1,523 Number of events
- 9 Number of unique normalized events
- 1,412 Max number of times the same event was reported
- 0 Number of cancellation
- 13 Total number of automatic vacuums
- 18 Total number of automatic analyzes
- 10 Number temporary file
- 234.55 MiB Max size of temporary file
- 109.04 MiB Average size of temporary file
- 223 Total number of sessions
- 8 sessions at 2026-07-11 00:35:07 Session peak
- 8d6h50m42s Total duration of sessions
- 53m30s Average duration of sessions
- 4 Average queries per session
- 1m9s Average queries duration per session
- 52m20s Average idle time per session
- 222 Total number of connections
- 7 connections/s at 2026-07-11 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-11 23:49:53 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-07-11 03:06:13 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-11 23:49:53 Date
Queries duration
Key values
- 4h18m14s 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 11 00 28 0ms 18s3ms 4s301ms 5s401ms 6s58ms 1m20s 01 33 0ms 4s702ms 1s188ms 4s127ms 5s539ms 9s927ms 02 17 0ms 4s254ms 2s58ms 4s748ms 6s320ms 6s445ms 03 22 0ms 4s858ms 1s655ms 4s864ms 5s502ms 8s581ms 04 24 0ms 4s698ms 1s578ms 4s204ms 6s801ms 7s27ms 05 28 0ms 10m7s 44s712ms 8s420ms 2m45s 10m8s 06 18 0ms 9s818ms 3s671ms 4s412ms 5s110ms 30s875ms 07 32 0ms 8m43s 31s942ms 37s534ms 1m7s 8m43s 08 21 0ms 6m3s 31s214ms 4s294ms 6s33ms 6m48s 09 20 0ms 5m50s 32s13ms 4s287ms 46s814ms 5m50s 10 20 0ms 5m44s 31s168ms 4s168ms 44s933ms 5m44s 11 21 0ms 6m14s 31s698ms 5s474ms 15s654ms 6m43s 12 21 0ms 5m52s 30s782ms 5s73ms 47s262ms 5m52s 13 21 0ms 6m13s 32s814ms 4s851ms 16s482ms 6m48s 14 21 0ms 6m11s 31s793ms 4s541ms 15s484ms 6m43s 15 21 0ms 5m50s 31s303ms 4s228ms 51s12ms 5m50s 16 21 0ms 5m49s 30s788ms 4s38ms 48s266ms 5m49s 17 21 0ms 6m8s 31s543ms 4s349ms 5s537ms 6m55s 18 23 0ms 6m11s 29s281ms 4s794ms 15s357ms 6m47s 19 21 0ms 5m55s 30s309ms 4s445ms 49s559ms 5m55s 20 109 0ms 7m28s 12s116ms 59s500ms 1m54s 7m28s 21 22 0ms 6m50s 31s12ms 4s57ms 47s690ms 6m50s 22 20 0ms 5m32s 31s202ms 3s947ms 42s394ms 5m32s 23 349 0ms 1m53s 6s859ms 1m8s 1m36s 1m53s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 11 00 5 0 2s524ms 0ms 0ms 1s343ms 01 16 0 248ms 0ms 345ms 451ms 02 0 0 0ms 0ms 0ms 0ms 03 4 0 319ms 0ms 0ms 214ms 04 6 0 497ms 0ms 0ms 884ms 05 6 0 379ms 0ms 0ms 758ms 06 3 0 4s58ms 0ms 0ms 0ms 07 17 0 55s625ms 0ms 12s582ms 4m2s 08 6 0 1m43s 0ms 0ms 3m33s 09 6 0 1m41s 0ms 0ms 3m33s 10 6 0 1m39s 0ms 0ms 3m26s 11 6 0 1m44s 0ms 0ms 3m29s 12 6 0 1m42s 0ms 0ms 3m34s 13 6 0 1m49s 0ms 0ms 3m50s 14 6 0 1m46s 0ms 0ms 3m38s 15 6 0 1m44s 0ms 0ms 3m46s 16 6 0 1m42s 0ms 0ms 3m40s 17 6 0 1m45s 0ms 0ms 3m35s 18 8 0 1m20s 0ms 0ms 3m37s 19 6 0 1m41s 0ms 0ms 3m22s 20 9 84 13s719ms 9s637ms 59s500ms 3m41s 21 7 0 1m33s 0ms 0ms 3m14s 22 6 0 1m39s 0ms 0ms 3m43s 23 23 326 6s859ms 1m4s 1m8s 1m47s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 11 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 11 00 0 1 1.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 1 1.00 0.00% 06 0 0 0.00 0.00% 07 0 2 2.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 6 6.00 0.00% Day Hour Count Average / Second Jul 11 00 17 0.00/s 01 11 0.00/s 02 9 0.00/s 03 19 0.01/s 04 9 0.00/s 05 9 0.00/s 06 14 0.00/s 07 10 0.00/s 08 8 0.00/s 09 6 0.00/s 10 8 0.00/s 11 9 0.00/s 12 8 0.00/s 13 10 0.00/s 14 7 0.00/s 15 7 0.00/s 16 7 0.00/s 17 9 0.00/s 18 8 0.00/s 19 7 0.00/s 20 11 0.00/s 21 7 0.00/s 22 7 0.00/s 23 5 0.00/s Day Hour Count Average Duration Average idle time Jul 11 00 6 1h 59m40s 01 16 1h55s 1h52s 02 11 1h33s 1h29s 03 21 20m36s 20m34s 04 7 1h3m 1h2m54s 05 10 55m36s 53m31s 06 8 58m8s 58m 07 13 59m55s 58m37s 08 10 1h36s 59m30s 09 9 54m46s 53m35s 10 5 1h 57m56s 11 9 54m47s 53m33s 12 9 54m46s 53m34s 13 8 54m18s 52m52s 14 8 1h2s 58m38s 15 8 53m45s 52m23s 16 6 1h58s 59m10s 17 8 54m11s 52m48s 18 9 55m26s 54m11s 19 7 1h50s 59m20s 20 10 43m4s 40m52s 21 8 1h56s 59m30s 22 7 1h 58m31s 23 10 46m18s 42m19s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-07-11 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 222 connections Total
Connections per user
Key values
- intelifix Main User
- 222 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-07-11 00:35:07 Date
Histogram of session times
Key values
- 186 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 223 sessions Total
Sessions per user
Key values
- intelifix Main User
- 223 sessions Total
Sessions per host
Key values
- [local] Main Host
- 223 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 11,431 buffers Checkpoint Peak
- 2026-07-11 00:19:46 Date
- 269.912 seconds Highest write time
- 0.042 seconds Sync time
Checkpoints Wal files
Key values
- 4 files Wal files usage Peak
- 2026-07-11 00:19:46 Date
Checkpoints distance
Key values
- 126.70 Mo Distance Peak
- 2026-07-11 00:19:46 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 11 00 18,554 653.412s 0.043s 653.52s 01 3,122 313.815s 0.048s 313.929s 02 1,761 177.051s 0.029s 177.12s 03 1,652 166.271s 0.03s 166.369s 04 2,569 258.393s 0.033s 258.478s 05 8,654 870.616s 0.095s 870.764s 06 4,316 269.125s 0.004s 269.14s 07 8,282 672.595s 0.032s 672.667s 08 2,740 274.669s 0.012s 274.707s 09 21 2.135s 0.003s 2.146s 10 21 2.132s 0.003s 2.141s 11 21 2.118s 0.004s 2.127s 12 21 2.136s 0.006s 2.15s 13 21 2.133s 0.003s 2.143s 14 21 2.132s 0.003s 2.141s 15 21 2.135s 0.004s 2.144s 16 455 45.575s 0.003s 45.586s 17 24 2.428s 0.004s 2.437s 18 806 80.875s 0.008s 80.901s 19 22 2.233s 0.004s 2.243s 20 546 54.703s 0.014s 54.737s 21 68 6.873s 0.014s 6.897s 22 21 2.131s 0.004s 2.141s 23 70 7.08s 0.013s 7.113s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 11 00 0 0 7 481 0.004s 0.008s 01 0 0 1 632 0.003s 0.009s 02 0 0 0 389 0.004s 0.006s 03 0 0 1 375 0.003s 0.009s 04 0 0 0 572 0.002s 0.008s 05 0 0 4 607 0.014s 0.007s 06 0 0 1 10 0.001s 0.001s 07 0 0 4 261 0.009s 0.005s 08 0 0 0 92 0.003s 0.004s 09 0 0 0 3 0.002s 0.001s 10 0 0 0 3 0.002s 0.001s 11 0 0 0 3 0.003s 0.002s 12 0 0 0 3 0.005s 0.002s 13 0 0 0 3 0.002s 0.001s 14 0 0 0 3 0.002s 0.001s 15 0 0 0 3 0.002s 0.002s 16 0 0 1 5 0.002s 0.001s 17 0 0 0 4 0.002s 0.001s 18 0 0 0 51 0.002s 0.003s 19 0 0 0 4 0.003s 0.001s 20 0 0 0 29 0.002s 0.003s 21 0 0 0 21 0.008s 0.002s 22 0 0 0 3 0.002s 0.002s 23 0 0 0 7 0.009s 0.012s Day Hour Count Avg time (sec) Jul 11 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 11 00 14,603.57 kB 48,162.00 kB 01 1,751.11 kB 24,534.11 kB 02 1,524.33 kB 11,627.33 kB 03 966.78 kB 2,912.33 kB 04 1,469.00 kB 2,165.88 kB 05 9,137.86 kB 13,727.14 kB 06 7,747.00 kB 13,900.00 kB 07 12,432.40 kB 18,198.60 kB 08 3,187.75 kB 27,797.50 kB 09 169.00 kB 21,272.00 kB 10 169.00 kB 19,162.00 kB 11 170.00 kB 17,262.00 kB 12 169.00 kB 15,553.00 kB 13 170.00 kB 14,015.00 kB 14 170.00 kB 12,630.00 kB 15 169.00 kB 11,384.00 kB 16 2,812.00 kB 10,527.00 kB 17 170.00 kB 9,491.00 kB 18 1,009.67 kB 7,980.67 kB 19 173.00 kB 6,468.00 kB 20 877.33 kB 5,467.00 kB 21 140.00 kB 4,243.50 kB 22 169.00 kB 3,641.00 kB 23 390.67 kB 3,034.00 kB -
Temporary Files
Size of temporary files
Key values
- 469.11 MiB Temp Files size Peak
- 2026-07-11 05:32:07 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-11 05:32:14 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 11 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 109.04 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 911.11 MiB 69.96 MiB 234.55 MiB 113.89 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-11 05:32:16 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-11 05:32:07 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 179.33 MiB 89.66 MiB 89.66 MiB 89.66 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-11 05:30:44 Duration: 41s575ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-11 05:30:40 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 234.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-11 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 234.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-11 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 89.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-11 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 89.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-11 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 77.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-11 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 77.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-11 05:32:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 77.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-11 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 70.03 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-11 05:32:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 69.97 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-11 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 69.96 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-11 05:32:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.80 sec Highest CPU-cost vacuum
Table public.logs
Database rio - 2026-07-11 16:11:47 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.80 sec Highest CPU-cost vacuum
Table public.logs
Database rio - 2026-07-11 16:11:47 Date
Analyzes per table
Key values
- public.temp0000285098 (8) Main table analyzed (database rio)
- 18 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_class (1) Main table vacuumed on database rio
- 13 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_class 1 1 0 0 0 0 0 449 134 128,815 3 8 rio.public.temp0000285094 1 0 0 0 0 0 0 1,646 4 97,717 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,694 1,046 3,360,839 997 6,991 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 145 4 11,402 0 0 rio.pg_catalog.pg_type 1 1 0 0 0 0 0 179 63 82,674 2 4 rio.public.logs 1 0 0 0 0 0 0 2,583 2,216 2,688,342 174 4,338 rio.pg_catalog.pg_depend 1 1 0 0 0 0 0 631 218 257,370 2 12 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 190 70 223,247 23 68 rio.pg_catalog.pg_attribute 1 1 0 0 0 0 0 985 298 438,760 2 68 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 910 280 1,297,792 156 463 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,295 1,228 4,379,810 1,155 6,860 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,187 6 154,225 0 0 rio.pg_catalog.pg_index 1 1 0 0 0 0 0 115 39 27,595 2 2 Total 13 11 0 0 0 0 0 16,009 5,606 13,148,588 2,516 18,814 Vacuum throughput per table
Key values
- public.logs (0.8) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_class 0 0 0.07 rio.public.temp0000285094 0 0 0.05 brasilia.pg_catalog.pg_statistic 0 0 0.14 contagem.pg_toast.pg_toast_2619 0 0 0.02 rio.pg_catalog.pg_type 0 0 0.05 rio.public.logs 0 0 0.8 rio.pg_catalog.pg_depend 0 0 0.13 brasilia.pg_toast.pg_toast_2619 0 0 0.02 rio.pg_catalog.pg_attribute 0 0 0.24 rio.pg_toast.pg_toast_2619 0 0 0.07 rio.pg_catalog.pg_statistic 0 0 0.44 contagem.pg_catalog.pg_statistic 0 0 0.05 rio.pg_catalog.pg_index 0 0 0.07 Total 0 0 2.15 Tuples removed per table
Key values
- pg_catalog.pg_attribute (5629) Main table with removed tuples on database rio
- 23180 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 1 1 5,629 20,148 0 154 559 rio.pg_catalog.pg_statistic 1 1 4,420 7,477 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,346 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,853 7,332 0 0 1,072 rio.pg_catalog.pg_depend 1 1 2,893 18,692 0 0 187 rio.pg_toast.pg_toast_2619 1 1 740 679 0 0 294 rio.pg_catalog.pg_type 1 1 539 2,205 0 9 70 rio.pg_catalog.pg_index 1 1 350 1,879 0 0 57 rio.pg_catalog.pg_class 1 1 163 3,364 0 0 145 brasilia.pg_toast.pg_toast_2619 1 1 140 141 0 24 46 contagem.pg_toast.pg_toast_2619 1 1 107 116 0 32 32 rio.public.temp0000285094 1 0 0 23,151 0 0 1,664 rio.public.logs 1 0 0 16,086,290 0 0 642,713 Total 13 11 23,180 16,178,748 0 219 649,136 Pages removed per table
Key values
- pg_catalog.pg_attribute (154) Main table with removed pages on database rio
- 219 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_catalog.pg_attribute 1 1 5629 154 contagem.pg_toast.pg_toast_2619 1 1 107 32 brasilia.pg_toast.pg_toast_2619 1 1 140 24 rio.pg_catalog.pg_type 1 1 539 9 rio.pg_catalog.pg_class 1 1 163 0 rio.public.temp0000285094 1 0 0 0 brasilia.pg_catalog.pg_statistic 1 1 3853 0 rio.public.logs 1 0 0 0 rio.pg_catalog.pg_depend 1 1 2893 0 rio.pg_toast.pg_toast_2619 1 1 740 0 rio.pg_catalog.pg_statistic 1 1 4420 0 contagem.pg_catalog.pg_statistic 1 1 4346 0 rio.pg_catalog.pg_index 1 1 350 0 Total 13 11 23,180 219 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 11 00 0 1 01 0 2 02 0 0 03 0 0 04 0 5 05 6 4 06 0 0 07 6 6 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 1 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0.80 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
- 176 Total read queries
- 413 Total write queries
Queries by database
Key values
- rio Main database
- 472 Requests
- 2h52m27s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,797 Requests
User Request type Count Duration etiquetas Total 43 9s759ms select 43 9s759ms intelifix Total 6,797 12h22s copy to 734 1h38m28s ddl 1,030 37m30s others 829 1h18m19s select 4,201 8h26m1s lenon Total 124 1m36s ddl 3 939ms others 3 3s66ms select 118 1m32s Duration by user
Key values
- 12h22s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 43 9s759ms select 43 9s759ms intelifix Total 6,797 12h22s copy to 734 1h38m28s ddl 1,030 37m30s others 829 1h18m19s select 4,201 8h26m1s lenon Total 124 1m36s ddl 3 939ms others 3 3s66ms select 118 1m32s Queries by host
Key values
- [local] Main host
- 6,958 Requests
- 12h2m4s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 471 Requests
- 3h27m27s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-11 22:14:54 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 378 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 10m7s analyze verbose;[ Date: 2026-07-11 05:10:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-11 07:13:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-11 20:12:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-11 21:11:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-11 11:11:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-11 13:11:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-11 18:11:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-11 14:11:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-11 17:11:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-11 08:11:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-11 19:10:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-11 12:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-11 09:10:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-11 15:10:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-11 16:10:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-11 10:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-11 22:10:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m8s analyze verbose;[ Date: 2026-07-11 05:15:17 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
19 3m55s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-07-11 07:19:22 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m48s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-07-11 13:15:55 - 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 1h45m46s 48 1s439ms 8m43s 2m12s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 11 07 3 9m21s 3m7s 08 3 6m19s 2m6s 09 3 6m6s 2m2s 10 3 6m1s 2m 11 3 6m31s 2m10s 12 3 6m9s 2m3s 13 3 6m31s 2m10s 14 3 6m29s 2m9s 15 3 6m6s 2m2s 16 3 6m6s 2m2s 17 3 6m25s 2m8s 18 3 6m28s 2m9s 19 3 6m13s 2m4s 20 3 7m57s 2m39s 21 3 7m7s 2m22s 22 3 5m48s 1m56s [ User: intelifix - Total duration: 1h45m46s - Times executed: 48 ]
[ Application: psql - Total duration: 1h45m46s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-11 07:13:45 Duration: 8m43s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-11 20:12:30 Duration: 7m28s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-11 21:11:52 Duration: 6m50s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
2 1h6m58s 48 266ms 3m55s 1m23s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 11 07 3 5m4s 1m41s 08 3 4m2s 1m20s 09 3 4m4s 1m21s 10 3 3m54s 1m18s 11 3 3m56s 1m18s 12 3 4m4s 1m21s 13 3 4m23s 1m27s 14 3 4m7s 1m22s 15 3 4m21s 1m27s 16 3 4m11s 1m23s 17 3 4m5s 1m21s 18 3 4m12s 1m24s 19 3 3m54s 1m18s 20 3 4m40s 1m33s 21 3 3m45s 1m15s 22 3 4m9s 1m23s [ User: intelifix - Total duration: 1h6m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h6m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-11 07:19:22 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-11 13:15:55 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-11 15:15:28 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
3 18m1s 3 2m45s 10m7s 6m analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 11 05 3 18m1s 6m [ User: intelifix - Total duration: 18m1s - Times executed: 3 ]
[ Application: psql - Total duration: 18m1s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-11 05:10:09 Duration: 10m7s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
analyze verbose;
Date: 2026-07-11 05:15:17 Duration: 5m8s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
analyze verbose;
Date: 2026-07-11 05:18:02 Duration: 2m45s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
4 10m40s 273 152ms 12s596ms 2s345ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 11 00 12 34s343ms 2s861ms 01 12 24s338ms 2s28ms 02 12 25s495ms 2s124ms 03 12 26s616ms 2s218ms 04 12 26s273ms 2s189ms 05 12 27s524ms 2s293ms 06 12 26s704ms 2s225ms 07 12 29s577ms 2s464ms 08 12 28s709ms 2s392ms 09 11 25s934ms 2s357ms 10 11 24s923ms 2s265ms 11 12 29s552ms 2s462ms 12 12 28s490ms 2s374ms 13 12 30s232ms 2s519ms 14 12 27s958ms 2s329ms 15 12 26s489ms 2s207ms 16 12 25s885ms 2s157ms 17 12 28s679ms 2s389ms 18 12 28s562ms 2s380ms 19 12 25s954ms 2s162ms 20 12 39s671ms 3s305ms 21 12 24s849ms 2s70ms 22 11 23s685ms 2s153ms [ User: intelifix - Total duration: 10m40s - Times executed: 273 ]
[ Application: psql - Total duration: 10m40s - Times executed: 273 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-11 00:05:27 Duration: 12s596ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-11 20:05:13 Duration: 11s727ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-11 20:15:09 Duration: 7s843ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
5 2m56s 4 4s264ms 1m26s 44s60ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 11 20 2 1m30s 45s302ms 23 2 1m25s 42s817ms [ User: intelifix - Total duration: 2m56s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m56s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-11 20:08:28 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-11 23:37:30 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-11 20:10:13 Duration: 4s521ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
6 2m12s 2 19s697ms 1m53s 1m6s 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 #6
Day Hour Count Duration Avg duration Jul 11 23 2 2m12s 1m6s [ User: intelifix - Total duration: 2m12s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m12s - 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-11 23:13:17 Duration: 1m53s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 23:48:47 Duration: 19s697ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
7 2m 3 5s278ms 1m36s 40s298ms 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 11 23 3 2m 40s298ms [ User: intelifix - Total duration: 2m - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m - 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-11 23:14:53 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 23:49:06 Duration: 19s195ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 23:38:05 Duration: 5s278ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
8 1m51s 4 407ms 57s619ms 27s945ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 11 20 2 58s57ms 29s28ms 23 2 53s722ms 26s861ms [ 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-11 20:05:22 Duration: 57s619ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-11 23:18:49 Duration: 53s314ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-11 20:09:39 Duration: 438ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
9 1m36s 2 17s209ms 1m19s 48s119ms copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 11 23 2 1m36s 48s119ms [ User: intelifix - Total duration: 1m36s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m36s - 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-11 23:11:24 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 23:48:27 Duration: 17s209ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
10 1m32s 1 1m32s 1m32s 1m32s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 11 05 1 1m32s 1m32s [ User: intelifix - Total duration: 1m32s - Times executed: 1 ]
[ Application: psql - Total duration: 1m32s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-11 05:32:16 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-11 05:32:07 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
11 1m26s 6 2s569ms 31s703ms 14s350ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 11 20 3 43s113ms 14s371ms 23 3 42s987ms 14s329ms [ 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-11 23:19:23 Duration: 31s703ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 20:05:55 Duration: 31s215ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 20:09:49 Duration: 9s320ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
12 1m20s 6 8s467ms 18s3ms 13s383ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 11 00 3 53s98ms 17s699ms 06 3 27s202ms 9s67ms [ User: intelifix - Total duration: 1m20s - Times executed: 6 ]
[ Application: psql - Total duration: 1m20s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-11 00:05:55 Duration: 18s3ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-11 00:05:20 Duration: 17s885ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-11 00:05:37 Duration: 17s209ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
13 1m13s 6 1s814ms 29s503ms 12s240ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 11 20 3 37s767ms 12s589ms 23 3 35s672ms 11s890ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-11 20:06:27 Duration: 29s503ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-11 23:19:54 Duration: 27s585ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-11 20:09:56 Duration: 6s450ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
14 1m9s 6 2s511ms 26s777ms 11s513ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 11 20 3 34s232ms 11s410ms 23 3 34s847ms 11s615ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - 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-11 20:08:55 Duration: 26s777ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 23:37:56 Duration: 26s425ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 23:48:04 Duration: 5s522ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
15 1m4s 31 520ms 12s775ms 2s67ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 11 00 6 20s24ms 3s337ms 01 5 10s906ms 2s181ms 02 5 9s501ms 1s900ms 03 5 8s253ms 1s650ms 04 6 8s635ms 1s439ms 05 4 6s781ms 1s695ms [ User: intelifix - Total duration: 1m4s - Times executed: 31 ]
[ Application: psql - Total duration: 1m4s - Times executed: 31 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-11 00:05:14 Duration: 12s775ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-11 01:05:06 Duration: 4s702ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-11 03:15:05 Duration: 4s415ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
16 57s405ms 6 1s674ms 19s651ms 9s567ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 11 20 3 28s175ms 9s391ms 23 3 29s229ms 9s743ms [ User: intelifix - Total duration: 57s405ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s405ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 23:16:09 Duration: 19s651ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 20:02:42 Duration: 18s164ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 20:09:14 Duration: 8s336ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
17 56s549ms 1 56s549ms 56s549ms 56s549ms select * from rs_fast_excel (?, ?) / 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 #17
Day Hour Count Duration Avg duration Jul 11 07 1 56s549ms 56s549ms [ User: intelifix - Total duration: 56s549ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 56s549ms - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026929, 0433 )', '/var/www/html/tmp/nf_carga_lotes_0433.xlsx') / 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-11 07:59:50 Duration: 56s549ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-11.log
18 56s427ms 6 1s523ms 20s613ms 9s404ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 11 20 3 29s248ms 9s749ms 23 3 27s179ms 9s59ms [ User: intelifix - Total duration: 56s427ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 56s427ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 20:03:17 Duration: 20s613ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 23:16:42 Duration: 18s481ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 23:38:36 Duration: 7s174ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
19 52s253ms 6 1s272ms 20s560ms 8s708ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 11 20 3 26s108ms 8s702ms 23 3 26s145ms 8s715ms [ User: intelifix - Total duration: 52s253ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 52s253ms - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-07-11 20:04:06 Duration: 20s560ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-07-11 23:17:36 Duration: 20s531ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-07-11 23:38:49 Duration: 4s340ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
20 47s509ms 3 5s375ms 34s625ms 15s836ms copy auditor.auditor_2026_07 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 11 23 3 47s509ms 15s836ms [ User: intelifix - Total duration: 47s509ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 47s509ms - Times executed: 3 ]
-
COPY auditor.auditor_2026_07 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-11 23:15:28 Duration: 34s625ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY auditor.auditor_2026_07 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-11 23:38:13 Duration: 7s508ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY auditor.auditor_2026_07 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-11 23:49:11 Duration: 5s375ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 273 10m40s 152ms 12s596ms 2s345ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 11 00 12 34s343ms 2s861ms 01 12 24s338ms 2s28ms 02 12 25s495ms 2s124ms 03 12 26s616ms 2s218ms 04 12 26s273ms 2s189ms 05 12 27s524ms 2s293ms 06 12 26s704ms 2s225ms 07 12 29s577ms 2s464ms 08 12 28s709ms 2s392ms 09 11 25s934ms 2s357ms 10 11 24s923ms 2s265ms 11 12 29s552ms 2s462ms 12 12 28s490ms 2s374ms 13 12 30s232ms 2s519ms 14 12 27s958ms 2s329ms 15 12 26s489ms 2s207ms 16 12 25s885ms 2s157ms 17 12 28s679ms 2s389ms 18 12 28s562ms 2s380ms 19 12 25s954ms 2s162ms 20 12 39s671ms 3s305ms 21 12 24s849ms 2s70ms 22 11 23s685ms 2s153ms [ User: intelifix - Total duration: 10m40s - Times executed: 273 ]
[ Application: psql - Total duration: 10m40s - Times executed: 273 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-11 00:05:27 Duration: 12s596ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-11 20:05:13 Duration: 11s727ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-11 20:15:09 Duration: 7s843ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
2 48 1h45m46s 1s439ms 8m43s 2m12s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 11 07 3 9m21s 3m7s 08 3 6m19s 2m6s 09 3 6m6s 2m2s 10 3 6m1s 2m 11 3 6m31s 2m10s 12 3 6m9s 2m3s 13 3 6m31s 2m10s 14 3 6m29s 2m9s 15 3 6m6s 2m2s 16 3 6m6s 2m2s 17 3 6m25s 2m8s 18 3 6m28s 2m9s 19 3 6m13s 2m4s 20 3 7m57s 2m39s 21 3 7m7s 2m22s 22 3 5m48s 1m56s [ User: intelifix - Total duration: 1h45m46s - Times executed: 48 ]
[ Application: psql - Total duration: 1h45m46s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-11 07:13:45 Duration: 8m43s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-11 20:12:30 Duration: 7m28s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-11 21:11:52 Duration: 6m50s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
3 48 1h6m58s 266ms 3m55s 1m23s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 11 07 3 5m4s 1m41s 08 3 4m2s 1m20s 09 3 4m4s 1m21s 10 3 3m54s 1m18s 11 3 3m56s 1m18s 12 3 4m4s 1m21s 13 3 4m23s 1m27s 14 3 4m7s 1m22s 15 3 4m21s 1m27s 16 3 4m11s 1m23s 17 3 4m5s 1m21s 18 3 4m12s 1m24s 19 3 3m54s 1m18s 20 3 4m40s 1m33s 21 3 3m45s 1m15s 22 3 4m9s 1m23s [ User: intelifix - Total duration: 1h6m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h6m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-11 07:19:22 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-11 13:15:55 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-11 15:15:28 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
4 36 43s849ms 645ms 6s147ms 1s218ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 11 08 3 4s495ms 1s498ms 09 3 3s771ms 1s257ms 10 2 2s90ms 1s45ms 11 2 6s811ms 3s405ms 12 2 2s8ms 1s4ms 13 2 1s941ms 970ms 14 3 2s726ms 908ms 15 3 3s13ms 1s4ms 16 2 1s812ms 906ms 17 1 785ms 785ms 18 1 766ms 766ms 19 3 2s744ms 914ms 20 3 4s679ms 1s559ms 21 3 3s623ms 1s207ms 22 3 2s579ms 859ms [ User: intelifix - Total duration: 43s849ms - Times executed: 36 ]
[ Application: psql - Total duration: 43s849ms - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-11 11:20:07 Duration: 6s147ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 20:20:03 Duration: 2s356ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 08:00:03 Duration: 2s227ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
5 31 1m4s 520ms 12s775ms 2s67ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 11 00 6 20s24ms 3s337ms 01 5 10s906ms 2s181ms 02 5 9s501ms 1s900ms 03 5 8s253ms 1s650ms 04 6 8s635ms 1s439ms 05 4 6s781ms 1s695ms [ User: intelifix - Total duration: 1m4s - Times executed: 31 ]
[ Application: psql - Total duration: 1m4s - Times executed: 31 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-11 00:05:14 Duration: 12s775ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-11 01:05:06 Duration: 4s702ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-11 03:15:05 Duration: 4s415ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
6 16 4s335ms 169ms 758ms 270ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 11 01 12 2s526ms 210ms 04 1 531ms 531ms 05 3 1s278ms 426ms [ User: intelifix - Total duration: 4s335ms - Times executed: 16 ]
[ Application: [unknown] - Total duration: 4s335ms - Times executed: 16 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229651449406,229654864857,229681135872,229652472828,229651631826,229653512436,229653515163,229762128198,229762908487,229651216779,216917511125,229758617990,229654370107,229760349090,229682031527,229682652025,229680586065,229684146682,229762581633,229652393752,229680898598,229680439710,229761056163,229650377999,229683895468,229651224255,229682325876,229759374866,229652087986,229679823354,229684069806,229757614144,229680923248,229653629797,229650967383,229653705866,229757366263,229761414560,229682990218,229650430912,216917591335,229682160103,229683873951,229650262534,229680024159,229682923443,229758090510,229680548081,229757075876,229679505971,229756291120,229758043333,229680348185,229684067987,229683895771,229762135270,229680325153,229680390817', NULL, NULL, 0159, 00);
Date: 2026-07-11 05:02:34 Duration: 758ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229759338701,229680896376,229684061523,229680238197,229757520926,229683247593,229683257897,229682763551,229681616581,216917591638,229651447082,229761991519,229681777887,229681032630,229680459712,229757043146,229757108203,229757097797,229651399198,229649883956,229679387979,229652472929,229680440721,229683897084,229650174343,229681252629,229681891536,229760367577,229680873445,229758172740,229682231827,229756297382,229762835574,229654075173', NULL, NULL, 0159, 00);
Date: 2026-07-11 04:53:36 Duration: 531ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229683296868,229651011732,229654015167,229761621932,229650249299,229684301625,229762934450,229653372950,229681686161,229682322846,229653116583', NULL, NULL, 0159, 00);
Date: 2026-07-11 05:33:31 Duration: 302ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-11.log
7 9 9s272ms 774ms 1s204ms 1s30ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 11 10 1 774ms 774ms 11 1 1s68ms 1s68ms 12 1 1s138ms 1s138ms 13 1 1s65ms 1s65ms 16 1 1s73ms 1s73ms 17 2 2s277ms 1s138ms 18 2 1s874ms 937ms [ User: intelifix - Total duration: 9s272ms - Times executed: 9 ]
[ Application: psql - Total duration: 9s272ms - Times executed: 9 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-11 17:20:02 Duration: 1s204ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-11 12:20:02 Duration: 1s138ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-11 18:20:03 Duration: 1s82ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
8 8 3s616ms 370ms 591ms 452ms 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 #8
Day Hour Count Duration Avg duration Jul 11 00 1 521ms 521ms 01 1 445ms 445ms 03 1 370ms 370ms 04 2 997ms 498ms 05 1 373ms 373ms 07 2 908ms 454ms [ User: lenon - Total duration: 3s616ms - Times executed: 8 ]
[ Application: [unknown] - Total duration: 3s616ms - Times executed: 8 ]
-
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-11 04:44:37 Duration: 591ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 00:58:53 Duration: 521ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 07:24:04 Duration: 480ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-11.log
9 6 1m26s 2s569ms 31s703ms 14s350ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 11 20 3 43s113ms 14s371ms 23 3 42s987ms 14s329ms [ 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-11 23:19:23 Duration: 31s703ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 20:05:55 Duration: 31s215ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 20:09:49 Duration: 9s320ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
10 6 1m20s 8s467ms 18s3ms 13s383ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 11 00 3 53s98ms 17s699ms 06 3 27s202ms 9s67ms [ User: intelifix - Total duration: 1m20s - Times executed: 6 ]
[ Application: psql - Total duration: 1m20s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-11 00:05:55 Duration: 18s3ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-11 00:05:20 Duration: 17s885ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-11 00:05:37 Duration: 17s209ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
11 6 1m13s 1s814ms 29s503ms 12s240ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 11 20 3 37s767ms 12s589ms 23 3 35s672ms 11s890ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-11 20:06:27 Duration: 29s503ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-11 23:19:54 Duration: 27s585ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-11 20:09:56 Duration: 6s450ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
12 6 1m9s 2s511ms 26s777ms 11s513ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 11 20 3 34s232ms 11s410ms 23 3 34s847ms 11s615ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - 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-11 20:08:55 Duration: 26s777ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 23:37:56 Duration: 26s425ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 23:48:04 Duration: 5s522ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
13 6 57s405ms 1s674ms 19s651ms 9s567ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 11 20 3 28s175ms 9s391ms 23 3 29s229ms 9s743ms [ User: intelifix - Total duration: 57s405ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s405ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 23:16:09 Duration: 19s651ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 20:02:42 Duration: 18s164ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 20:09:14 Duration: 8s336ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
14 6 56s427ms 1s523ms 20s613ms 9s404ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 11 20 3 29s248ms 9s749ms 23 3 27s179ms 9s59ms [ User: intelifix - Total duration: 56s427ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 56s427ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 20:03:17 Duration: 20s613ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 23:16:42 Duration: 18s481ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 23:38:36 Duration: 7s174ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
15 6 52s253ms 1s272ms 20s560ms 8s708ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 11 20 3 26s108ms 8s702ms 23 3 26s145ms 8s715ms [ User: intelifix - Total duration: 52s253ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 52s253ms - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-07-11 20:04:06 Duration: 20s560ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-07-11 23:17:36 Duration: 20s531ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-07-11 23:38:49 Duration: 4s340ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
16 6 43s716ms 1s169ms 16s37ms 7s286ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 11 20 3 20s629ms 6s876ms 23 3 23s87ms 7s695ms [ User: intelifix - Total duration: 43s716ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 43s716ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-07-11 23:16:58 Duration: 16s37ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-07-11 20:03:30 Duration: 13s170ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-07-11 20:09:29 Duration: 6s289ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
17 6 33s227ms 809ms 13s842ms 5s537ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 11 20 3 16s636ms 5s545ms 23 3 16s591ms 5s530ms [ User: intelifix - Total duration: 33s227ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 33s227ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-11 23:16:23 Duration: 13s842ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-11 20:02:56 Duration: 13s731ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-11 20:09:16 Duration: 2s94ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
18 6 32s921ms 3s80ms 7s734ms 5s486ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 11 20 3 17s977ms 5s992ms 23 3 14s943ms 4s981ms [ User: intelifix - Total duration: 32s921ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 32s921ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-11 20:10:07 Duration: 7s734ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-11 20:06:50 Duration: 6s855ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-11 23:47:52 Duration: 6s690ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
19 6 28s617ms 832ms 12s184ms 4s769ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 11 20 3 13s457ms 4s485ms 23 3 15s159ms 5s53ms [ User: intelifix - Total duration: 28s617ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 28s617ms - Times executed: 6 ]
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-07-11 23:15:46 Duration: 12s184ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-07-11 20:02:20 Duration: 10s487ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-07-11 23:38:19 Duration: 2s142ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
20 6 26s367ms 700ms 11s663ms 4s394ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 11 20 3 13s173ms 4s391ms 23 3 13s193ms 4s397ms [ User: intelifix - Total duration: 26s367ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 26s367ms - Times executed: 6 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-07-11 23:17:15 Duration: 11s663ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-07-11 20:03:46 Duration: 11s582ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-07-11 20:09:32 Duration: 885ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m45s 10m7s 6m 3 18m1s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 11 05 3 18m1s 6m [ User: intelifix - Total duration: 18m1s - Times executed: 3 ]
[ Application: psql - Total duration: 18m1s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-11 05:10:09 Duration: 10m7s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
analyze verbose;
Date: 2026-07-11 05:15:17 Duration: 5m8s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
analyze verbose;
Date: 2026-07-11 05:18:02 Duration: 2m45s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
2 1s439ms 8m43s 2m12s 48 1h45m46s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 11 07 3 9m21s 3m7s 08 3 6m19s 2m6s 09 3 6m6s 2m2s 10 3 6m1s 2m 11 3 6m31s 2m10s 12 3 6m9s 2m3s 13 3 6m31s 2m10s 14 3 6m29s 2m9s 15 3 6m6s 2m2s 16 3 6m6s 2m2s 17 3 6m25s 2m8s 18 3 6m28s 2m9s 19 3 6m13s 2m4s 20 3 7m57s 2m39s 21 3 7m7s 2m22s 22 3 5m48s 1m56s [ User: intelifix - Total duration: 1h45m46s - Times executed: 48 ]
[ Application: psql - Total duration: 1h45m46s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-11 07:13:45 Duration: 8m43s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-11 20:12:30 Duration: 7m28s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-11 21:11:52 Duration: 6m50s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
3 1m32s 1m32s 1m32s 1 1m32s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 11 05 1 1m32s 1m32s [ User: intelifix - Total duration: 1m32s - Times executed: 1 ]
[ Application: psql - Total duration: 1m32s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-11 05:32:16 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-11 05:32:07 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 266ms 3m55s 1m23s 48 1h6m58s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 11 07 3 5m4s 1m41s 08 3 4m2s 1m20s 09 3 4m4s 1m21s 10 3 3m54s 1m18s 11 3 3m56s 1m18s 12 3 4m4s 1m21s 13 3 4m23s 1m27s 14 3 4m7s 1m22s 15 3 4m21s 1m27s 16 3 4m11s 1m23s 17 3 4m5s 1m21s 18 3 4m12s 1m24s 19 3 3m54s 1m18s 20 3 4m40s 1m33s 21 3 3m45s 1m15s 22 3 4m9s 1m23s [ User: intelifix - Total duration: 1h6m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h6m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-11 07:19:22 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-11 13:15:55 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-11 15:15:28 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
5 19s697ms 1m53s 1m6s 2 2m12s 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 11 23 2 2m12s 1m6s [ User: intelifix - Total duration: 2m12s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m12s - 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-11 23:13:17 Duration: 1m53s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 23:48:47 Duration: 19s697ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
6 56s549ms 56s549ms 56s549ms 1 56s549ms select * from rs_fast_excel (?, ?) / 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 11 07 1 56s549ms 56s549ms [ User: intelifix - Total duration: 56s549ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 56s549ms - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026929, 0433 )', '/var/www/html/tmp/nf_carga_lotes_0433.xlsx') / 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-11 07:59:50 Duration: 56s549ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-11.log
7 17s209ms 1m19s 48s119ms 2 1m36s copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 11 23 2 1m36s 48s119ms [ User: intelifix - Total duration: 1m36s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m36s - 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-11 23:11:24 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 23:48:27 Duration: 17s209ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
8 4s264ms 1m26s 44s60ms 4 2m56s 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 11 20 2 1m30s 45s302ms 23 2 1m25s 42s817ms [ User: intelifix - Total duration: 2m56s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m56s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-11 20:08:28 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-11 23:37:30 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-11 20:10:13 Duration: 4s521ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
9 5s278ms 1m36s 40s298ms 3 2m 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 #9
Day Hour Count Duration Avg duration Jul 11 23 3 2m 40s298ms [ User: intelifix - Total duration: 2m - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m - 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-11 23:14:53 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 23:49:06 Duration: 19s195ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 23:38:05 Duration: 5s278ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
10 407ms 57s619ms 27s945ms 4 1m51s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 11 20 2 58s57ms 29s28ms 23 2 53s722ms 26s861ms [ 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-11 20:05:22 Duration: 57s619ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-11 23:18:49 Duration: 53s314ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-11 20:09:39 Duration: 438ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
11 5s375ms 34s625ms 15s836ms 3 47s509ms copy auditor.auditor_2026_07 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 11 23 3 47s509ms 15s836ms [ User: intelifix - Total duration: 47s509ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 47s509ms - Times executed: 3 ]
-
COPY auditor.auditor_2026_07 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-11 23:15:28 Duration: 34s625ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY auditor.auditor_2026_07 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-11 23:38:13 Duration: 7s508ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY auditor.auditor_2026_07 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-11 23:49:11 Duration: 5s375ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
12 2s569ms 31s703ms 14s350ms 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 #12
Day Hour Count Duration Avg duration Jul 11 20 3 43s113ms 14s371ms 23 3 42s987ms 14s329ms [ 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-11 23:19:23 Duration: 31s703ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 20:05:55 Duration: 31s215ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 20:09:49 Duration: 9s320ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
13 8s467ms 18s3ms 13s383ms 6 1m20s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 11 00 3 53s98ms 17s699ms 06 3 27s202ms 9s67ms [ User: intelifix - Total duration: 1m20s - Times executed: 6 ]
[ Application: psql - Total duration: 1m20s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-11 00:05:55 Duration: 18s3ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-11 00:05:20 Duration: 17s885ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-11 00:05:37 Duration: 17s209ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-11.log
14 1s814ms 29s503ms 12s240ms 6 1m13s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 11 20 3 37s767ms 12s589ms 23 3 35s672ms 11s890ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-11 20:06:27 Duration: 29s503ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-11 23:19:54 Duration: 27s585ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-11 20:09:56 Duration: 6s450ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
15 2s511ms 26s777ms 11s513ms 6 1m9s 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 #15
Day Hour Count Duration Avg duration Jul 11 20 3 34s232ms 11s410ms 23 3 34s847ms 11s615ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - 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-11 20:08:55 Duration: 26s777ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 23:37:56 Duration: 26s425ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 23:48:04 Duration: 5s522ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
16 1s674ms 19s651ms 9s567ms 6 57s405ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 11 20 3 28s175ms 9s391ms 23 3 29s229ms 9s743ms [ User: intelifix - Total duration: 57s405ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s405ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 23:16:09 Duration: 19s651ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 20:02:42 Duration: 18s164ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 20:09:14 Duration: 8s336ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
17 1s523ms 20s613ms 9s404ms 6 56s427ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 11 20 3 29s248ms 9s749ms 23 3 27s179ms 9s59ms [ User: intelifix - Total duration: 56s427ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 56s427ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 20:03:17 Duration: 20s613ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 23:16:42 Duration: 18s481ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-11 23:38:36 Duration: 7s174ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
18 1s272ms 20s560ms 8s708ms 6 52s253ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 11 20 3 26s108ms 8s702ms 23 3 26s145ms 8s715ms [ User: intelifix - Total duration: 52s253ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 52s253ms - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-07-11 20:04:06 Duration: 20s560ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-07-11 23:17:36 Duration: 20s531ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-07-11 23:38:49 Duration: 4s340ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
19 1s169ms 16s37ms 7s286ms 6 43s716ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 11 20 3 20s629ms 6s876ms 23 3 23s87ms 7s695ms [ User: intelifix - Total duration: 43s716ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 43s716ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-07-11 23:16:58 Duration: 16s37ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-07-11 20:03:30 Duration: 13s170ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-07-11 20:09:29 Duration: 6s289ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
20 809ms 13s842ms 5s537ms 6 33s227ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 11 20 3 16s636ms 5s545ms 23 3 16s591ms 5s530ms [ User: intelifix - Total duration: 33s227ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 33s227ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-11 23:16:23 Duration: 13s842ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-11 20:02:56 Duration: 13s731ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.log
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-11 20:09:16 Duration: 2s94ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-11.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 15 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 10 13 2 0ms 0ms 16 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms Jul 11 11 1 0ms 0ms 16 1 0ms 0ms 17 3 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms [ User: intelifix - Total duration: 12m15s - Times executed: 15 ]
[ Application: psql - Total duration: 12m15s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 668ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 5,249 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 15 FATAL entries
- 1507 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,412 Max number of times the same event was reported
- 1,523 Total events found
Rank Times reported Error 1 1,412 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 11 00 59 01 60 02 59 03 54 04 60 05 59 06 59 07 60 08 59 09 60 10 59 11 60 12 59 13 60 14 59 15 60 16 59 17 60 18 59 19 60 20 60 21 59 22 59 23 50 - ERROR: prepared statement "_PLAN0000000029D33110" does not exist
- ERROR: prepared statement "_PLAN0000000029F750E0" does not exist
- ERROR: prepared statement "_PLAN0000000029D2CCB0" does not exist
Statement: DEALLOCATE "_PLAN0000000029D33110"
Date: 2026-07-11 00:00:51 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
Statement: DEALLOCATE "_PLAN0000000029F750E0"
Date: 2026-07-11 00:01:52 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
Statement: DEALLOCATE "_PLAN0000000029D2CCB0"
Date: 2026-07-11 00:02:52 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 11 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 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-11 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
3 44 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 11 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 2 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-11 08:00:05 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 08:20:05 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.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-11 08:40:05 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
4 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 11 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-11 03:05:02 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
Date: 2026-07-11 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
Date: 2026-07-11 03:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
5 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 11 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-11 05:32:16 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-11 05:32:16 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-11 05:32:16 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
6 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 11 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-11 03:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
Date: 2026-07-11 03:05:02 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
Date: 2026-07-11 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
7 3 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 11 00 1 06 1 13 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-11 00:02:13 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
Date: 2026-07-11 06:02:14 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
Date: 2026-07-11 13:49:01 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
8 1 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 11 17 1 - ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-11 17:40:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-11.log
9 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 11 03 1 - LOG: database system was shut down at 2026-07-11 03:05:02 -03
Date: 2026-07-11 03:05:03 Log file: /usr/local/pgsql/data/log/serverlog-11.log