pgBadger-
Global information
- Generated on Sat Aug 29 23:50:16 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 10,253 log entries in 14s
- Log start from 2026-08-29 00:00:46 to 2026-08-29 23:49:38
-
Overview
Global Stats
- 162 Number of unique normalized queries
- 1,136 Number of queries
- 4h29m38s Total query duration
- 2026-08-29 00:02:38 First query
- 2026-08-29 23:47:51 Last query
- 4 queries/s at 2026-08-29 23:47:23 Query peak
- 4h29m38s Total query duration
- 201ms Prepare/parse total duration
- 0ms Bind total duration
- 4h29m38s Execute total duration
- 1,445 Number of events
- 6 Number of unique normalized events
- 1,412 Max number of times the same event was reported
- 0 Number of cancellation
- 8 Total number of automatic vacuums
- 17 Total number of automatic analyzes
- 12 Number temporary file
- 243.33 MiB Max size of temporary file
- 104.03 MiB Average size of temporary file
- 235 Total number of sessions
- 8 sessions at 2026-08-29 00:52:12 Session peak
- 8d19h23m19s Total duration of sessions
- 53m58s Average duration of sessions
- 4 Average queries per session
- 1m8s Average queries duration per session
- 52m49s Average idle time per session
- 249 Total number of connections
- 6 connections/s at 2026-08-29 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-29 23:47:23 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-08-29 23:46:46 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-29 23:47:23 Date
Queries duration
Key values
- 4h29m38s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 29 00 27 0ms 36s596ms 7s949ms 9s321ms 20s55ms 1m30s 01 87 0ms 5s954ms 876ms 8s582ms 10s311ms 11s422ms 02 18 0ms 5s262ms 2s673ms 5s804ms 8s360ms 9s749ms 03 20 0ms 6s253ms 2s691ms 6s236ms 9s233ms 11s615ms 04 28 0ms 5s840ms 2s27ms 6s486ms 10s206ms 11s449ms 05 34 0ms 10m29s 41s215ms 21s4ms 2m56s 10m29s 06 18 0ms 38s856ms 7s137ms 5s564ms 14s42ms 49s2ms 07 35 0ms 11m24s 32s415ms 5s770ms 1m48s 11m24s 08 30 0ms 5m31s 20s270ms 5s260ms 46s302ms 5m31s 09 47 0ms 5m31s 12s963ms 5s270ms 46s615ms 5m31s 10 33 0ms 8m36s 34s574ms 5s672ms 3m16s 8m36s 11 28 0ms 5m44s 22s598ms 5s815ms 50s794ms 5m44s 12 24 0ms 5m35s 25s202ms 5s116ms 48s352ms 5m35s 13 24 0ms 5m42s 25s831ms 5s841ms 48s919ms 5m42s 14 24 0ms 5m31s 25s66ms 5s504ms 45s675ms 5m31s 15 24 0ms 5m29s 25s397ms 5s471ms 48s460ms 5m29s 16 24 0ms 5m35s 25s254ms 5s299ms 45s614ms 5m35s 17 24 0ms 5m31s 25s173ms 5s289ms 47s430ms 5m31s 18 27 0ms 5m35s 22s468ms 5s413ms 46s415ms 5m35s 19 25 0ms 5m42s 24s691ms 5s460ms 47s749ms 5m42s 20 122 0ms 11m1s 13s441ms 1m19s 1m56s 11m1s 21 25 0ms 6m24s 26s544ms 5s755ms 16s868ms 6m55s 22 24 0ms 5m41s 26s560ms 5s735ms 51s528ms 5m41s 23 364 0ms 1m36s 6s216ms 1m8s 1m10s 2m5s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 29 00 3 0 19s697ms 0ms 0ms 12s707ms 01 66 0 298ms 778ms 953ms 1s622ms 02 0 0 0ms 0ms 0ms 0ms 03 3 0 317ms 0ms 0ms 154ms 04 9 0 240ms 0ms 169ms 438ms 05 13 0 370ms 0ms 195ms 1s14ms 06 3 0 21s14ms 0ms 0ms 14s42ms 07 23 0 47s906ms 175ms 901ms 4m14s 08 12 0 47s260ms 0ms 192ms 3m7s 09 29 0 19s778ms 159ms 765ms 3m9s 10 14 0 1m18s 0ms 0ms 5m36s 11 10 0 59s74ms 0ms 153ms 3m13s 12 6 0 1m34s 0ms 0ms 3m4s 13 6 0 1m36s 0ms 0ms 3m8s 14 6 0 1m34s 0ms 0ms 3m7s 15 6 0 1m35s 0ms 0ms 3m13s 16 6 0 1m34s 0ms 0ms 3m8s 17 6 0 1m34s 0ms 0ms 3m7s 18 9 0 1m3s 0ms 0ms 3m4s 19 6 0 1m36s 0ms 0ms 3m7s 20 17 83 15s631ms 26s458ms 1m 3m53s 21 7 0 1m28s 0ms 0ms 3m10s 22 6 0 1m39s 0ms 0ms 3m22s 23 36 328 6s216ms 1m3s 1m8s 2m2s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 29 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 29 00 0 0 0.00 0.00% 01 0 3 3.00 0.00% 02 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 1 1.00 0.00% 05 0 3 3.00 0.00% 06 0 0 0.00 0.00% 07 0 2 2.00 0.00% 08 0 2 2.00 0.00% 09 0 2 2.00 0.00% 10 0 2 2.00 0.00% 11 0 1 1.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 1 4 4.00 0.27% Day Hour Count Average / Second Aug 29 00 16 0.00/s 01 11 0.00/s 02 10 0.00/s 03 18 0.01/s 04 10 0.00/s 05 10 0.00/s 06 15 0.00/s 07 11 0.00/s 08 11 0.00/s 09 9 0.00/s 10 9 0.00/s 11 12 0.00/s 12 6 0.00/s 13 8 0.00/s 14 10 0.00/s 15 8 0.00/s 16 7 0.00/s 17 8 0.00/s 18 8 0.00/s 19 9 0.00/s 20 11 0.00/s 21 8 0.00/s 22 8 0.00/s 23 16 0.00/s Day Hour Count Average Duration Average idle time Aug 29 00 9 56m40s 56m16s 01 15 1h36s 1h31s 02 11 1h16s 1h12s 03 19 22m45s 22m42s 04 9 1h2m40s 1h2m33s 05 10 1h56s 58m36s 06 9 58m21s 58m7s 07 13 1h55s 59m28s 08 11 55m44s 54m49s 09 10 55m19s 54m18s 10 9 53m40s 51m33s 11 8 57m46s 56m27s 12 10 1h52s 59m51s 13 6 1h 58m16s 14 7 1h4s 58m38s 15 8 1h1m1s 59m44s 16 8 1h 58m44s 17 7 1h34s 59m8s 18 7 1h 58m33s 19 8 1h1s 58m44s 20 11 45m47s 43m18s 21 9 54m47s 53m33s 22 8 53m45s 52m25s 23 13 35m13s 32m19s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-08-29 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 249 connections Total
Connections per user
Key values
- intelifix Main User
- 249 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-08-29 00:52:12 Date
Histogram of session times
Key values
- 198 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 235 sessions Total
Sessions per user
Key values
- intelifix Main User
- 235 sessions Total
Sessions per host
Key values
- [local] Main Host
- 235 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 56,721 buffers Checkpoint Peak
- 2026-08-29 00:09:46 Date
- 269.858 seconds Highest write time
- 0.088 seconds Sync time
Checkpoints Wal files
Key values
- 6 files Wal files usage Peak
- 2026-08-29 00:09:46 Date
Checkpoints distance
Key values
- 173.25 Mo Distance Peak
- 2026-08-29 00:09:46 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 29 00 73,658 672.62s 0.033s 672.773s 01 5,149 515.895s 0.247s 516.314s 02 2,015 202.249s 0.097s 202.503s 03 1,531 152.812s 0.15s 153.027s 04 3,101 311.502s 0.108s 311.649s 05 10,320 987.791s 0.076s 987.96s 06 4,497 269.242s 0.003s 269.257s 07 2,794 280.276s 0.143s 280.522s 08 39 3.954s 0.079s 4.046s 09 58 5.922s 0.042s 6.12s 10 453 45.567s 0.098s 45.769s 11 25 2.532s 0.018s 2.559s 12 23 2.342s 0.004s 2.351s 13 23 2.337s 0.003s 2.345s 14 24 2.422s 0.003s 2.429s 15 23 2.321s 0.004s 2.33s 16 23 2.321s 0.005s 2.33s 17 23 2.324s 0.003s 2.333s 18 648 65.022s 0.007s 65.039s 19 99 9.951s 0.006s 9.961s 20 58 5.86s 0.011s 5.889s 21 79 7.967s 0.009s 7.99s 22 23 2.322s 0.032s 2.369s 23 131 13.205s 0.013s 13.285s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 29 00 0 0 11 471 0.014s 0.006s 01 0 0 2 857 0.065s 0.009s 02 0 0 1 505 0.059s 0.008s 03 0 0 0 366 0.061s 0.009s 04 0 0 1 623 0.067s 0.007s 05 0 0 5 662 0.012s 0.007s 06 0 0 0 49 0.002s 0.001s 07 0 0 1 36 0.062s 0.057s 08 0 0 0 6 0.073s 0.041s 09 0 0 0 15 0.015s 0.022s 10 0 0 0 76 0.070s 0.048s 11 0 0 0 4 0.014s 0.016s 12 0 0 0 3 0.003s 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.003s 0.002s 16 0 0 0 3 0.003s 0.002s 17 0 0 0 3 0.002s 0.001s 18 0 0 0 50 0.002s 0.002s 19 0 0 0 64 0.002s 0.001s 20 0 0 0 28 0.003s 0.005s 21 0 0 0 19 0.004s 0.003s 22 0 0 1 3 0.030s 0.011s 23 0 0 0 72 0.007s 0.006s Day Hour Count Avg time (sec) Aug 29 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Aug 29 00 29,911.33 kB 75,283.00 kB 01 2,966.89 kB 36,895.67 kB 02 1,426.86 kB 16,897.71 kB 03 1,144.88 kB 2,943.62 kB 04 2,421.86 kB 2,833.57 kB 05 10,477.14 kB 13,508.00 kB 06 6,889.00 kB 15,164.00 kB 07 1,772.38 kB 10,705.25 kB 08 76.33 kB 5,892.00 kB 09 43.43 kB 3,562.71 kB 10 250.12 kB 1,729.25 kB 11 95.50 kB 1,064.00 kB 12 186.00 kB 935.00 kB 13 186.00 kB 860.00 kB 14 187.00 kB 792.00 kB 15 186.00 kB 732.00 kB 16 186.00 kB 677.00 kB 17 186.00 kB 628.00 kB 18 1,434.00 kB 2,442.00 kB 19 426.00 kB 2,140.00 kB 20 286.00 kB 1,724.75 kB 21 106.33 kB 1,243.67 kB 22 186.00 kB 1,028.00 kB 23 168.33 kB 855.33 kB -
Temporary Files
Size of temporary files
Key values
- 486.66 MiB Temp Files size Peak
- 2026-08-29 05:32:03 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-29 05:32:03 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 29 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 12 1.22 GiB 104.03 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 945.19 MiB 72.58 MiB 243.33 MiB 118.15 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-29 05:32:11 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-29 05:32:03 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 303.12 MiB 56.35 MiB 92.73 MiB 75.78 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-29 05:30:43 Duration: 41s623ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-29 05:30:40 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 243.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-29 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 243.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-29 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 92.73 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-29 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 92.73 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-29 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 80.30 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-29 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 80.21 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-29 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 80.21 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-29 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 72.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-29 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 72.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-29 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 72.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-29 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 61.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-29 05:30:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 56.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-29 05:30:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.33 sec Highest CPU-cost vacuum
Table pg_catalog.pg_attribute
Database rio - 2026-08-29 01:37:20 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.33 sec Highest CPU-cost vacuum
Table pg_catalog.pg_attribute
Database rio - 2026-08-29 01:37:20 Date
Analyzes per table
Key values
- public.temp0000290004 (7) Main table analyzed (database rio)
- 17 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_attribute (1) Main table vacuumed on database rio
- 8 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_attribute 1 1 0 0 0 0 0 655 238 240,531 2 28 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 141 36 126,516 5 15 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,379 1,028 3,180,368 989 7,158 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 841 230 1,102,500 104 290 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,480 1,054 3,812,500 994 6,052 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 140 64 173,230 9 23 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,918 523 2,216,714 488 3,427 brasilia.pg_catalog.pg_type 1 1 0 0 0 0 0 101 48 56,909 0 0 Total 8 8 0 0 0 0 0 10,655 3,221 10,909,268 2,591 16,993 Vacuum throughput per table
Key values
- pg_catalog.pg_attribute (0.33) 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_attribute 0 0 0.33 brasilia.pg_toast.pg_toast_2619 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.11 rio.pg_toast.pg_toast_2619 0 0 0.04 rio.pg_catalog.pg_statistic 0 0 0.31 contagem.pg_toast.pg_toast_2619 0 0 0.01 brasilia.pg_catalog.pg_statistic 0 0 0.3 brasilia.pg_catalog.pg_type 0 0 0.05 Total 0 0 1.15 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4499) Main table with removed tuples on database rio
- 15525 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,499 7,506 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,324 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,753 7,346 0 0 1,072 rio.pg_catalog.pg_attribute 1 1 1,909 21,863 0 99 559 rio.pg_toast.pg_toast_2619 1 1 661 669 0 0 281 brasilia.pg_catalog.pg_type 1 1 149 2,177 0 34 57 brasilia.pg_toast.pg_toast_2619 1 1 118 137 0 0 62 contagem.pg_toast.pg_toast_2619 1 1 112 110 0 32 29 Total 8 8 15,525 47,082 0 165 4,357 Pages removed per table
Key values
- pg_catalog.pg_attribute (99) Main table with removed pages on database rio
- 165 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_catalog.pg_attribute 1 1 1909 99 brasilia.pg_catalog.pg_type 1 1 149 34 contagem.pg_toast.pg_toast_2619 1 1 112 32 brasilia.pg_toast.pg_toast_2619 1 1 118 0 contagem.pg_catalog.pg_statistic 1 1 4324 0 rio.pg_toast.pg_toast_2619 1 1 661 0 rio.pg_catalog.pg_statistic 1 1 4499 0 brasilia.pg_catalog.pg_statistic 1 1 3753 0 Total 8 8 15,525 165 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 29 00 0 0 01 1 9 02 0 2 03 0 0 04 0 5 05 7 1 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0.33 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
- 302 Total read queries
- 416 Total write queries
Queries by database
Key values
- rio Main database
- 585 Requests
- 3h4m55s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,477 Requests
User Request type Count Duration etiquetas Total 24 11s143ms select 24 11s143ms intelifix Total 6,477 12h25m14s copy to 769 1h36m6s ddl 814 39m56s others 941 1h33m27s select 3,953 8h35m44s lenon Total 123 4m25s select 123 4m25s Duration by user
Key values
- 12h25m14s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 24 11s143ms select 24 11s143ms intelifix Total 6,477 12h25m14s copy to 769 1h36m6s ddl 814 39m56s others 941 1h33m27s select 3,953 8h35m44s lenon Total 123 4m25s select 123 4m25s Queries by host
Key values
- [local] Main host
- 6,624 Requests
- 12h29m51s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 526 Requests
- 3h33m26s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-29 22:39:01 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 440 100-500ms duration
Slowest individual queries
Rank Duration Query 1 11m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-29 07:16:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 11m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-29 20:16:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 10m29s analyze verbose;[ Date: 2026-08-29 05:10:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m36s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-28'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-08-29 10:22:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 6m37s analyze verbose;[ Date: 2026-08-29 05:17:07 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
6 6m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-29 21:11:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-29 11:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-29 13:10:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-29 19:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-29 22:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-29 10:10:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-29 18:10:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-29 16:10:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-29 12:10:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-29 17:10:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-29 08:10:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-29 14:10:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-29 09:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-29 15:10:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 4m5s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-29 07:23:10 - 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 1h47m34s 48 1s362ms 11m24s 2m14s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 29 07 3 12m20s 4m6s 08 3 5m49s 1m56s 09 3 5m48s 1m56s 10 3 5m54s 1m58s 11 3 6m8s 2m2s 12 3 5m52s 1m57s 13 3 6m1s 2m 14 3 5m48s 1m56s 15 3 5m46s 1m55s 16 3 5m52s 1m57s 17 3 5m49s 1m56s 18 3 5m52s 1m57s 19 3 5m59s 1m59s 20 3 11m44s 3m54s 21 3 6m43s 2m14s 22 3 6m1s 2m [ User: intelifix - Total duration: 1h47m34s - Times executed: 48 ]
[ Application: psql - Total duration: 1h47m34s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-29 07:16:25 Duration: 11m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-29 20:16:02 Duration: 11m1s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-29 21:11:26 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
2 1h2m21s 48 240ms 4m5s 1m17s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 29 07 3 5m57s 1m59s 08 3 3m35s 1m11s 09 3 3m38s 1m12s 10 3 3m47s 1m15s 11 3 3m41s 1m13s 12 3 3m34s 1m11s 13 3 3m39s 1m13s 14 3 3m35s 1m11s 15 3 3m44s 1m14s 16 3 3m37s 1m12s 17 3 3m37s 1m12s 18 3 3m33s 1m11s 19 3 3m38s 1m12s 20 3 5m7s 1m42s 21 3 3m38s 1m12s 22 3 3m54s 1m18s [ User: intelifix - Total duration: 1h2m21s - Times executed: 48 ]
[ Application: psql - Total duration: 1h2m21s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-29 07:23:10 Duration: 4m5s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-29 20:21:44 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-29 22:14:56 Duration: 3m20s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
3 20m2s 3 2m56s 10m29s 6m40s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 29 05 3 20m2s 6m40s [ User: intelifix - Total duration: 20m2s - Times executed: 3 ]
[ Application: psql - Total duration: 20m2s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-29 05:10:30 Duration: 10m29s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
analyze verbose;
Date: 2026-08-29 05:17:07 Duration: 6m37s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
analyze verbose;
Date: 2026-08-29 05:20:04 Duration: 2m56s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
4 13m18s 276 175ms 19s617ms 2s891ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 29 00 12 46s536ms 3s878ms 01 12 32s632ms 2s719ms 02 12 31s412ms 2s617ms 03 12 32s373ms 2s697ms 04 12 31s293ms 2s607ms 05 12 36s437ms 3s36ms 06 12 34s88ms 2s840ms 07 12 32s701ms 2s725ms 08 12 31s297ms 2s608ms 09 12 30s548ms 2s545ms 10 12 33s693ms 2s807ms 11 12 31s757ms 2s646ms 12 12 31s489ms 2s624ms 13 12 34s141ms 2s845ms 14 12 31s902ms 2s658ms 15 12 32s57ms 2s671ms 16 12 31s21ms 2s585ms 17 12 31s907ms 2s658ms 18 12 32s307ms 2s692ms 19 12 31s577ms 2s631ms 20 12 1m7s 5s619ms 21 12 33s999ms 2s833ms 22 12 35s429ms 2s952ms [ User: intelifix - Total duration: 13m18s - Times executed: 276 ]
[ Application: psql - Total duration: 13m18s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-29 20:15:21 Duration: 19s617ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-29 20:05:20 Duration: 19s138ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-29 00:05:47 Duration: 16s669ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
5 8m36s 1 8m36s 8m36s 8m36s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 29 10 1 8m36s 8m36s [ User: intelifix - Total duration: 8m36s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 8m36s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-28'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-29 10:22:37 Duration: 8m36s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
6 3m18s 4 5s711ms 1m36s 49s576ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 29 20 2 1m34s 47s262ms 23 2 1m43s 51s889ms [ User: intelifix - Total duration: 3m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-29 23:17:20 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-29 20:08:52 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-29 23:37:14 Duration: 7s87ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
7 2m40s 36 163ms 28s901ms 4s447ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 29 00 6 46s605ms 7s767ms 01 6 22s869ms 3s811ms 02 6 16s717ms 2s786ms 03 5 20s493ms 4s98ms 04 6 23s95ms 3s849ms 05 4 27s741ms 6s935ms 19 1 2s50ms 2s50ms 20 2 543ms 271ms [ User: intelifix - Total duration: 2m40s - Times executed: 36 ]
[ Application: psql - Total duration: 2m40s - Times executed: 36 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-29 00:05:30 Duration: 28s901ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-29 05:25:15 Duration: 14s672ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-29 05:15:11 Duration: 9s415ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
8 2m2s 6 9s788ms 38s856ms 20s356ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 29 00 3 59s92ms 19s697ms 06 3 1m3s 21s14ms [ User: lenon - Total duration: 2m2s - Times executed: 6 ]
[ Application: psql - Total duration: 2m2s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-29 06:02:40 Duration: 38s856ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-29 00:02:38 Duration: 36s596ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-29 06:03:04 Duration: 14s42ms Database: contagem User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
9 1m58s 4 377ms 1m1s 29s587ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 29 20 2 56s18ms 28s9ms 23 2 1m2s 31s166ms [ User: intelifix - Total duration: 1m58s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m58s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-29 23:13:45 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-29 20:05:32 Duration: 55s565ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-29 20:10:06 Duration: 453ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
10 1m32s 6 10s222ms 22s409ms 15s399ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 29 00 3 1m1s 20s354ms 06 3 31s333ms 10s444ms [ User: intelifix - Total duration: 1m32s - Times executed: 6 ]
[ Application: psql - Total duration: 1m32s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-29 00:05:24 Duration: 22s409ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-29 00:06:03 Duration: 20s55ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-29 00:05:43 Duration: 18s598ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
11 1m31s 6 2s599ms 33s788ms 15s209ms 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 Aug 29 20 3 45s600ms 15s200ms 23 3 45s656ms 15s218ms [ User: intelifix - Total duration: 1m31s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m31s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-29 20:06:08 Duration: 33s788ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 23:14:21 Duration: 33s457ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 20:10:15 Duration: 9s211ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
12 1m27s 1 1m27s 1m27s 1m27s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 29 05 1 1m27s 1m27s [ User: intelifix - Total duration: 1m27s - Times executed: 1 ]
[ Application: psql - Total duration: 1m27s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-29 05:32:11 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-29 05:32:03 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
13 1m22s 6 1s865ms 31s783ms 13s716ms 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 Aug 29 20 3 40s819ms 13s606ms 23 3 41s478ms 13s826ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-29 20:06:44 Duration: 31s783ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-29 23:14:57 Duration: 31s414ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-29 23:36:52 Duration: 8s153ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
14 1m9s 6 2s892ms 26s473ms 11s624ms 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 Aug 29 20 3 35s320ms 11s773ms 23 3 34s424ms 11s474ms [ 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-08-29 20:09:19 Duration: 26s473ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 23:17:46 Duration: 25s833ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 23:37:19 Duration: 5s698ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
15 1m1s 6 1s980ms 20s516ms 10s198ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 29 20 3 30s501ms 10s167ms 23 3 30s692ms 10s230ms [ User: intelifix - Total duration: 1m1s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m1s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 20:02:44 Duration: 20s516ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 23:10:49 Duration: 20s186ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 23:36:06 Duration: 8s506ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
16 59s964ms 6 2s16ms 21s762ms 9s994ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 29 20 3 31s341ms 10s447ms 23 3 28s622ms 9s540ms [ User: intelifix - Total duration: 59s964ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s964ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 20:03:21 Duration: 21s762ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 23:11:26 Duration: 19s382ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 20:09:49 Duration: 7s368ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
17 59s564ms 6 1s873ms 23s899ms 9s927ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 29 20 3 28s826ms 9s608ms 23 3 30s738ms 10s246ms [ User: intelifix - Total duration: 59s564ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s564ms - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-29 23:12:23 Duration: 23s899ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 20:04:15 Duration: 22s298ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 23:36:29 Duration: 4s942ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
18 57s182ms 55 590ms 6s68ms 1s39ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 29 08 4 3s678ms 919ms 09 4 3s616ms 904ms 10 4 3s25ms 756ms 11 4 8s129ms 2s32ms 12 3 3s118ms 1s39ms 13 4 3s268ms 817ms 14 4 3s320ms 830ms 15 4 4s725ms 1s181ms 16 3 2s450ms 816ms 17 3 2s518ms 839ms 18 4 3s744ms 936ms 19 3 3s448ms 1s149ms 20 3 2s890ms 963ms 21 4 4s660ms 1s165ms 22 4 4s584ms 1s146ms [ User: intelifix - Total duration: 57s182ms - Times executed: 55 ]
[ Application: psql - Total duration: 57s182ms - Times executed: 55 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-29 11:00:08 Duration: 6s68ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-29 15:20:04 Duration: 1s936ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-29 19:20:04 Duration: 1s847ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
19 49s232ms 4 3s504ms 21s108ms 12s308ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 29 20 2 24s613ms 12s306ms 23 2 24s619ms 12s309ms [ User: intelifix - Total duration: 49s232ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 49s232ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-29 20:04:37 Duration: 21s108ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-29 23:12:43 Duration: 20s492ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-29 23:36:33 Duration: 4s126ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
20 46s682ms 6 1s774ms 16s221ms 7s780ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 29 20 3 22s411ms 7s470ms 23 3 24s270ms 8s90ms [ User: intelifix - Total duration: 46s682ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 46s682ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-29 23:11:42 Duration: 16s221ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 20:03:36 Duration: 14s835ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 23:36:21 Duration: 6s274ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 276 13m18s 175ms 19s617ms 2s891ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 29 00 12 46s536ms 3s878ms 01 12 32s632ms 2s719ms 02 12 31s412ms 2s617ms 03 12 32s373ms 2s697ms 04 12 31s293ms 2s607ms 05 12 36s437ms 3s36ms 06 12 34s88ms 2s840ms 07 12 32s701ms 2s725ms 08 12 31s297ms 2s608ms 09 12 30s548ms 2s545ms 10 12 33s693ms 2s807ms 11 12 31s757ms 2s646ms 12 12 31s489ms 2s624ms 13 12 34s141ms 2s845ms 14 12 31s902ms 2s658ms 15 12 32s57ms 2s671ms 16 12 31s21ms 2s585ms 17 12 31s907ms 2s658ms 18 12 32s307ms 2s692ms 19 12 31s577ms 2s631ms 20 12 1m7s 5s619ms 21 12 33s999ms 2s833ms 22 12 35s429ms 2s952ms [ User: intelifix - Total duration: 13m18s - Times executed: 276 ]
[ Application: psql - Total duration: 13m18s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-29 20:15:21 Duration: 19s617ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-29 20:05:20 Duration: 19s138ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-29 00:05:47 Duration: 16s669ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
2 55 57s182ms 590ms 6s68ms 1s39ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 29 08 4 3s678ms 919ms 09 4 3s616ms 904ms 10 4 3s25ms 756ms 11 4 8s129ms 2s32ms 12 3 3s118ms 1s39ms 13 4 3s268ms 817ms 14 4 3s320ms 830ms 15 4 4s725ms 1s181ms 16 3 2s450ms 816ms 17 3 2s518ms 839ms 18 4 3s744ms 936ms 19 3 3s448ms 1s149ms 20 3 2s890ms 963ms 21 4 4s660ms 1s165ms 22 4 4s584ms 1s146ms [ User: intelifix - Total duration: 57s182ms - Times executed: 55 ]
[ Application: psql - Total duration: 57s182ms - Times executed: 55 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-29 11:00:08 Duration: 6s68ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-29 15:20:04 Duration: 1s936ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-29 19:20:04 Duration: 1s847ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
3 51 14s91ms 151ms 816ms 276ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 29 01 45 12s910ms 286ms 04 4 845ms 211ms 05 2 335ms 167ms [ User: intelifix - Total duration: 14s91ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 14s91ms - Times executed: 51 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241631499006,241601012731,241652271011,241664666889,241651369092,241697012942,241661128799,241620619504,241676356683,241599261831,241710938587,241593297993,241654350305,241731437479,241677368285', NULL, NULL, 0320, 00);
Date: 2026-08-29 01:31:00 Duration: 816ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '230043531824,241728377798,241607229599,241700850107,241669582532,241689981212,241654518705,241620297878,241616051326,241614498200,241606023860,241637820914,230047931928,241676413333', NULL, NULL, 0320, 00);
Date: 2026-08-29 01:19:53 Duration: 646ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241599424248,241629324248,241728036777,241682771328,241676210407,241730342738,241675852841,241653989506,241637773535,241666654053,241679176161,241607293748,241667850018,241649673350,241631097092,241654477892,241659778499', NULL, NULL, 0320, 00);
Date: 2026-08-29 01:33:19 Duration: 557ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
4 48 1h47m34s 1s362ms 11m24s 2m14s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 29 07 3 12m20s 4m6s 08 3 5m49s 1m56s 09 3 5m48s 1m56s 10 3 5m54s 1m58s 11 3 6m8s 2m2s 12 3 5m52s 1m57s 13 3 6m1s 2m 14 3 5m48s 1m56s 15 3 5m46s 1m55s 16 3 5m52s 1m57s 17 3 5m49s 1m56s 18 3 5m52s 1m57s 19 3 5m59s 1m59s 20 3 11m44s 3m54s 21 3 6m43s 2m14s 22 3 6m1s 2m [ User: intelifix - Total duration: 1h47m34s - Times executed: 48 ]
[ Application: psql - Total duration: 1h47m34s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-29 07:16:25 Duration: 11m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-29 20:16:02 Duration: 11m1s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-29 21:11:26 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
5 48 1h2m21s 240ms 4m5s 1m17s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 29 07 3 5m57s 1m59s 08 3 3m35s 1m11s 09 3 3m38s 1m12s 10 3 3m47s 1m15s 11 3 3m41s 1m13s 12 3 3m34s 1m11s 13 3 3m39s 1m13s 14 3 3m35s 1m11s 15 3 3m44s 1m14s 16 3 3m37s 1m12s 17 3 3m37s 1m12s 18 3 3m33s 1m11s 19 3 3m38s 1m12s 20 3 5m7s 1m42s 21 3 3m38s 1m12s 22 3 3m54s 1m18s [ User: intelifix - Total duration: 1h2m21s - Times executed: 48 ]
[ Application: psql - Total duration: 1h2m21s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-29 07:23:10 Duration: 4m5s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-29 20:21:44 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-29 22:14:56 Duration: 3m20s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
6 48 10s565ms 150ms 664ms 220ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 29 01 8 2s5ms 250ms 04 2 343ms 171ms 07 13 2s389ms 183ms 08 2 342ms 171ms 09 19 4s821ms 253ms 10 2 339ms 169ms 11 2 322ms 161ms [ User: intelifix - Total duration: 10s565ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 10s565ms - Times executed: 48 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('6877DA617A07');
Date: 2026-08-29 09:05:14 Duration: 664ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('ZTEAH7VPC806720');
Date: 2026-08-29 09:05:22 Duration: 619ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('241616726576');
Date: 2026-08-29 01:25:08 Duration: 401ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
7 36 2m40s 163ms 28s901ms 4s447ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 29 00 6 46s605ms 7s767ms 01 6 22s869ms 3s811ms 02 6 16s717ms 2s786ms 03 5 20s493ms 4s98ms 04 6 23s95ms 3s849ms 05 4 27s741ms 6s935ms 19 1 2s50ms 2s50ms 20 2 543ms 271ms [ User: intelifix - Total duration: 2m40s - Times executed: 36 ]
[ Application: psql - Total duration: 2m40s - Times executed: 36 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-29 00:05:30 Duration: 28s901ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-29 05:25:15 Duration: 14s672ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-29 05:15:11 Duration: 9s415ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
8 35 38s707ms 645ms 5s225ms 1s105ms 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 #8
Day Hour Count Duration Avg duration Aug 29 08 2 5s995ms 2s997ms 09 2 1s530ms 765ms 10 2 1s750ms 875ms 11 2 2s112ms 1s56ms 12 3 2s650ms 883ms 13 2 2s144ms 1s72ms 14 2 2s22ms 1s11ms 15 2 2s69ms 1s34ms 16 3 2s926ms 975ms 17 3 2s608ms 869ms 18 2 2s10ms 1s5ms 19 3 2s598ms 866ms 20 3 4s929ms 1s643ms 21 2 1s940ms 970ms 22 2 1s416ms 708ms [ User: intelifix - Total duration: 38s707ms - Times executed: 35 ]
[ Application: psql - Total duration: 38s707ms - Times executed: 35 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-29 08:00:06 Duration: 5s225ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-29 20:20:04 Duration: 2s844ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-29 20:40:02 Duration: 1s264ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
9 17 6s524ms 321ms 497ms 383ms 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 #9
Day Hour Count Duration Avg duration Aug 29 01 3 1s353ms 451ms 03 1 331ms 331ms 04 1 344ms 344ms 05 3 1s197ms 399ms 07 2 830ms 415ms 08 2 713ms 356ms 09 2 670ms 335ms 10 2 717ms 358ms 11 1 365ms 365ms [ User: lenon - Total duration: 6s524ms - Times executed: 17 ]
[ Application: [unknown] - Total duration: 6s524ms - Times executed: 17 ]
-
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-08-29 01:15:05 Duration: 497ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 01:16:43 Duration: 470ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 07:38:54 Duration: 449ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-29.log
10 15 7s247ms 416ms 542ms 483ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 29 01 2 979ms 489ms 03 1 468ms 468ms 04 1 470ms 470ms 05 3 1s519ms 506ms 07 2 1s40ms 520ms 08 2 973ms 486ms 09 2 875ms 437ms 10 1 438ms 438ms 11 1 482ms 482ms [ User: intelifix - Total duration: 7s247ms - Times executed: 15 ]
[ Application: [unknown] - Total duration: 7s247ms - Times executed: 15 ]
-
select * from rs_menu_grants (500, 19, 1);
Date: 2026-08-29 05:19:44 Duration: 542ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
select * from rs_menu_grants (500, 19, 1);
Date: 2026-08-29 01:16:43 Duration: 535ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
select * from rs_menu_grants (414, 16, 1);
Date: 2026-08-29 07:21:43 Duration: 520ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
11 8 2s357ms 152ms 442ms 294ms select c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( case when c.relkind = ? then ?::"char" else ?::"char" end, c.relowner) as acldefault, case when c.relkind = ? then ( select ftserver from pg_catalog.pg_foreign_table where ftrelid = c.oid) else ? end as foreignserver, c.relfrozenxid, tc.relfrozenxid as tfrozenxid, tc.oid as toid, tc.relpages as toastpages, tc.reloptions as toast_reloptions, d.refobjid as owning_tab, d.refobjsubid as owning_col, tsp.spcname as reltablespace, false as relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid as tminmxid, array_remove(array_remove(c.reloptions, ?), ?) as reloptions, case when ? = any (c.reloptions) then ?::text when ? = any (c.reloptions) then ?::text else null end as checkoption, am.amname, (d.deptype = ?) is true as is_identity_sequence, c.relispartition as ispartition from pg_class c left join pg_depend d on (c.relkind = ? and d.classid = ?::regclass and d.objid = c.oid and d.objsubid = ? and d.refclassid = ?::regclass and d.deptype in (...)) left join pg_tablespace tsp on (tsp.oid = c.reltablespace) left join pg_am am on (c.relam = am.oid) left join pg_class tc on (c.reltoastrelid = tc.oid and tc.relkind = ? and c.relkind <> ?) where c.relkind in (...) order by c.oid;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 29 20 3 599ms 199ms 23 5 1s758ms 351ms [ User: intelifix - Total duration: 2s357ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 2s357ms - Times executed: 8 ]
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-08-29 23:10:01 Duration: 442ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-08-29 23:35:46 Duration: 394ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-08-29 23:46:45 Duration: 394ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
12 8 1s663ms 152ms 446ms 207ms select t.tableoid, t.oid, i.indrelid, t.relname as indexname, t.relpages, t.reltuples, t.relallvisible, t.relallfrozen, pg_catalog.pg_get_indexdef(i.indexrelid) as indexdef, i.indkey, i.indisclustered, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid as contableoid, c.oid as conoid, pg_catalog.pg_get_constraintdef(c.oid, false) as condef, case when i.indexprs is not null then ( select pg_catalog.array_agg(attname order by attnum) from pg_catalog.pg_attribute where attrelid = i.indexrelid) else null end as indattnames, ( select spcname from pg_catalog.pg_tablespace s where s.oid = t.reltablespace) as tablespace, t.reloptions as indreloptions, i.indisreplident, inh.inhparent as parentidx, i.indnkeyatts as indnkeyatts, i.indnatts as indnatts, ( select pg_catalog.array_agg(attnum order by attnum) from pg_catalog.pg_attribute where attrelid = i.indexrelid and attstattarget >= ?) as indstatcols, ( select pg_catalog.array_agg(attstattarget order by attnum) from pg_catalog.pg_attribute where attrelid = i.indexrelid and attstattarget >= ?) as indstatvals, i.indnullsnotdistinct, c.conperiod from unnest(?::pg_catalog.oid[]) as src (tbloid) join pg_catalog.pg_index i on (src.tbloid = i.indrelid) join pg_catalog.pg_class t on (t.oid = i.indexrelid) join pg_catalog.pg_class t2 on (t2.oid = i.indrelid) left join pg_catalog.pg_constraint c on (i.indrelid = c.conrelid and i.indexrelid = c.conindid and c.contype in (...)) left join pg_catalog.pg_inherits inh on (inh.inhrelid = indexrelid) where (i.indisvalid or t2.relkind = ?) and i.indisready order by i.indrelid, indexname;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 29 20 3 502ms 167ms 23 5 1s161ms 232ms [ User: intelifix - Total duration: 1s663ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1s663ms - Times executed: 8 ]
-
SELECT t.tableoid, t.oid, i.indrelid, t.relname AS indexname, t.relpages, t.reltuples, t.relallvisible, t.relallfrozen, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indkey, i.indisclustered, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid AS contableoid, c.oid AS conoid, pg_catalog.pg_get_constraintdef(c.oid, false) AS condef, CASE WHEN i.indexprs IS NOT NULL THEN ( SELECT pg_catalog.array_agg(attname ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid) ELSE NULL END AS indattnames, ( SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) AS tablespace, t.reloptions AS indreloptions, i.indisreplident, inh.inhparent AS parentidx, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, ( SELECT pg_catalog.array_agg(attnum ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatcols, ( SELECT pg_catalog.array_agg(attstattarget ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatvals, i.indnullsnotdistinct, c.conperiod FROM unnest('{41081,362498,364164,364174,364179,364184,364189,364194,364199,364204,364209,364214,364219,364224,364229,364234,364239,364244,364249,364254,364259,364264,364269,364274,364279,364284,364289,364294,364299,364304,364309,364314,364319,364324,364329,364334,364339,364344,364349,364354,364359,364364,364369,364374,364379,364384,364389,364394,364399,364404,364409,364414,364419,364424,364429,364434,364439,364444,364449,364454,364459,364464,364469,364474,364479,364484,364489,364494,364499,364504,364509,364514,364519,364524,364529,364534,364539,364544,364549,364554,364559,364564,364569}'::pg_catalog.oid[]) AS src (tbloid) JOIN pg_catalog.pg_index i ON (src.tbloid = i.indrelid) JOIN pg_catalog.pg_class t ON (t.oid = i.indexrelid) JOIN pg_catalog.pg_class t2 ON (t2.oid = i.indrelid) LEFT JOIN pg_catalog.pg_constraint c ON (i.indrelid = c.conrelid AND i.indexrelid = c.conindid AND c.contype IN ('p', 'u', 'x')) LEFT JOIN pg_catalog.pg_inherits inh ON (inh.inhrelid = indexrelid) WHERE (i.indisvalid OR t2.relkind = 'p') AND i.indisready ORDER BY i.indrelid, indexname;
Date: 2026-08-29 23:17:49 Duration: 446ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT t.tableoid, t.oid, i.indrelid, t.relname AS indexname, t.relpages, t.reltuples, t.relallvisible, t.relallfrozen, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indkey, i.indisclustered, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid AS contableoid, c.oid AS conoid, pg_catalog.pg_get_constraintdef(c.oid, false) AS condef, CASE WHEN i.indexprs IS NOT NULL THEN ( SELECT pg_catalog.array_agg(attname ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid) ELSE NULL END AS indattnames, ( SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) AS tablespace, t.reloptions AS indreloptions, i.indisreplident, inh.inhparent AS parentidx, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, ( SELECT pg_catalog.array_agg(attnum ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatcols, ( SELECT pg_catalog.array_agg(attstattarget ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatvals, i.indnullsnotdistinct, c.conperiod FROM unnest('{41081,362383,362392,362398,362401,362422,362430,362438,362445,362451,362457,362467,362473,362480,362485,362491,362498,362503,362512,362519,362525,362532,362538,362551,362560,362570,362578,362584,362591,362596,362608,362613,362620,362625,362633,362642,362648,362655,362662,362670,362678,362685,362694,362704,362711,362721,362731,362738,362744,362752,362760,362767,362774,362784,362789,362794,362802,362807,362812,362817,362824,362833,362841,362847,362855,362864,362872,362879,362886,362893,362900,362909,362915,362925,362936,362947,362954,362961,362968,362977,362987,362997,363007,363016,363023,363034,363046,363058,363069,363074,363080,363087,363094,363099,363114,363123,363127,363136,363144,363266,363274,363280,363286,363291,363304,363314,363321,363329,363343,363351,363355,363363,363369,363376,363383,363392,363399,363404,363428,363436,363443,363449,363454,363462,363469,363472,363479,363489,363502,363512,363521,363526,363533,363542,363550,363565,363598,363606,363614,363626,363631,363636,363644,363649,363656,363664,363672,363677,363682,363691,363697,363704,363717,363722,363736,363750,363763,363771,363776,363800,363810,363822,363829,363837,363844,363850,363858,363866,363872,363880,363888,363899,363906,363913,363920,363928,363936,363947,363954,363964,363973,363979,363986,363991,363998,364005,364014,364023,364039,364048,364058,364064,364071,364078,364094,364113,364122,364127,364141,364149,364157,364574,364582,364591,364600,364607,364615,364625,364632,364643,364652,364661,364670,364681,364687,364695,364709,364717,364724,364730,364739,364745,364751,364759,364768,364777,364782,364787,364794,364801,364841,364847,364860,364866,364883,364903,364910,364917,364924,364936,364964,364970,364977,364984,364991,364998,365005,365013,365023,365029,365040,365045,365051,365060,365351,365366,365377,365382,365389,365400,365408}'::pg_catalog.oid[]) AS src (tbloid) JOIN pg_catalog.pg_index i ON (src.tbloid = i.indrelid) JOIN pg_catalog.pg_class t ON (t.oid = i.indexrelid) JOIN pg_catalog.pg_class t2 ON (t2.oid = i.indrelid) LEFT JOIN pg_catalog.pg_constraint c ON (i.indrelid = c.conrelid AND i.indexrelid = c.conindid AND c.contype IN ('p', 'u', 'x')) LEFT JOIN pg_catalog.pg_inherits inh ON (inh.inhrelid = indexrelid) WHERE (i.indisvalid OR t2.relkind = 'p') AND i.indisready ORDER BY i.indrelid, indexname;
Date: 2026-08-29 23:10:03 Duration: 212ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT t.tableoid, t.oid, i.indrelid, t.relname AS indexname, t.relpages, t.reltuples, t.relallvisible, t.relallfrozen, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indkey, i.indisclustered, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid AS contableoid, c.oid AS conoid, pg_catalog.pg_get_constraintdef(c.oid, false) AS condef, CASE WHEN i.indexprs IS NOT NULL THEN ( SELECT pg_catalog.array_agg(attname ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid) ELSE NULL END AS indattnames, ( SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) AS tablespace, t.reloptions AS indreloptions, i.indisreplident, inh.inhparent AS parentidx, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, ( SELECT pg_catalog.array_agg(attnum ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatcols, ( SELECT pg_catalog.array_agg(attstattarget ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatvals, i.indnullsnotdistinct, c.conperiod FROM unnest('{41081,1440132,1440141,1440147,1440150,1440161,1440169,1440177,1440184,1440190,1440196,1440206,1440212,1440219,1440224,1440230,1440237,1440242,1440251,1440258,1440264,1440271,1440277,1440290,1440299,1440309,1440317,1440323,1440330,1440335,1440347,1440352,1440359,1440364,1440372,1440381,1440387,1440394,1440401,1440409,1440417,1440424,1440433,1440443,1440450,1440460,1440470,1440477,1440483,1440491,1440499,1440506,1440513,1440523,1440528,1440533,1440541,1440546,1440551,1440556,1440563,1440572,1440580,1440586,1440594,1440603,1440611,1440618,1440625,1440632,1440639,1440648,1440654,1440664,1440675,1440686,1440693,1440700,1440707,1440716,1440726,1440736,1440746,1440755,1440762,1440773,1440785,1440797,1440808,1440813,1440819,1440826,1440833,1440838,1440847,1440856,1440860,1440869,1440877,1440999,1441007,1441013,1441019,1441024,1441037,1441047,1441054,1441062,1441076,1441084,1441088,1441096,1441102,1441109,1441116,1441125,1441132,1441156,1441164,1441171,1441177,1441182,1441190,1441197,1441204,1441214,1441227,1441237,1441246,1441251,1441258,1441267,1441275,1441290,1441323,1441331,1441339,1441351,1441356,1441361,1441369,1441374,1441381,1441389,1441397,1441402,1441407,1441416,1441422,1441429,1441442,1441447,1441461,1441475,1441488,1441496,1441501,1441525,1441535,1441547,1441554,1441562,1441569,1441575,1441583,1441591,1441597,1441605,1441613,1441624,1441631,1441638,1441645,1441653,1441661,1441672,1441679,1441689,1441698,1441704,1441711,1441718,1441725,1441734,1441743,1441759,1441768,1441778,1441784,1441791,1441798,1441814,1441833,1441842,1441847,1441861,1441869,1441877,1442294,1442302,1442311,1442320,1442327,1442335,1442345,1442352,1442363,1442372,1442381,1442390,1442401,1442407,1442415,1442429,1442437,1442444,1442450,1442459,1442465,1442471,1442479,1442488,1442497,1442502,1442507,1442514,1442521,1442570,1442576,1442593,1442613,1442620,1442627,1442634,1442646,1442674,1442680,1442687,1442694,1442701,1442708,1442715,1442723,1442733,1442739,1442750,1442755,1442761,1442770,1442891,1442906,1442912,1442917,1442924,1442935,1442943}'::pg_catalog.oid[]) AS src (tbloid) JOIN pg_catalog.pg_index i ON (src.tbloid = i.indrelid) JOIN pg_catalog.pg_class t ON (t.oid = i.indexrelid) JOIN pg_catalog.pg_class t2 ON (t2.oid = i.indrelid) LEFT JOIN pg_catalog.pg_constraint c ON (i.indrelid = c.conrelid AND i.indexrelid = c.conindid AND c.contype IN ('p', 'u', 'x')) LEFT JOIN pg_catalog.pg_inherits inh ON (inh.inhrelid = indexrelid) WHERE (i.indisvalid OR t2.relkind = 'p') AND i.indisready ORDER BY i.indrelid, indexname;
Date: 2026-08-29 20:09:22 Duration: 186ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
13 7 2s807ms 271ms 529ms 401ms select p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault(?, p.proowner) as acldefault, p.pronamespace, p.proowner from pg_proc p left join pg_init_privs pip on (p.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?) where p.prokind <> ? and not exists ( select ? from pg_depend where classid = ?::regclass and objid = p.oid and deptype = ?) and (pronamespace != ( select oid from pg_namespace where nspname = ?) or exists ( select ? from pg_cast where pg_cast.oid > ? and p.oid = pg_cast.castfunc) or exists ( select ? from pg_transform where pg_transform.oid > ? and (p.oid = pg_transform.trffromsql or p.oid = pg_transform.trftosql)) or p.proacl is distinct from pip.initprivs);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 29 20 3 1s142ms 380ms 23 4 1s665ms 416ms [ User: intelifix - Total duration: 2s807ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s807ms - Times executed: 7 ]
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-29 20:02:03 Duration: 529ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-29 23:17:48 Duration: 509ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-29 23:10:02 Duration: 451ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
14 6 2m2s 9s788ms 38s856ms 20s356ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 29 00 3 59s92ms 19s697ms 06 3 1m3s 21s14ms [ User: lenon - Total duration: 2m2s - Times executed: 6 ]
[ Application: psql - Total duration: 2m2s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-29 06:02:40 Duration: 38s856ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-29 00:02:38 Duration: 36s596ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-29 06:03:04 Duration: 14s42ms Database: contagem User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
15 6 1m32s 10s222ms 22s409ms 15s399ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 29 00 3 1m1s 20s354ms 06 3 31s333ms 10s444ms [ User: intelifix - Total duration: 1m32s - Times executed: 6 ]
[ Application: psql - Total duration: 1m32s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-29 00:05:24 Duration: 22s409ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-29 00:06:03 Duration: 20s55ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-29 00:05:43 Duration: 18s598ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
16 6 1m31s 2s599ms 33s788ms 15s209ms 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 #16
Day Hour Count Duration Avg duration Aug 29 20 3 45s600ms 15s200ms 23 3 45s656ms 15s218ms [ User: intelifix - Total duration: 1m31s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m31s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-29 20:06:08 Duration: 33s788ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 23:14:21 Duration: 33s457ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 20:10:15 Duration: 9s211ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
17 6 1m22s 1s865ms 31s783ms 13s716ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 29 20 3 40s819ms 13s606ms 23 3 41s478ms 13s826ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-29 20:06:44 Duration: 31s783ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-29 23:14:57 Duration: 31s414ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-29 23:36:52 Duration: 8s153ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
18 6 1m9s 2s892ms 26s473ms 11s624ms 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 #18
Day Hour Count Duration Avg duration Aug 29 20 3 35s320ms 11s773ms 23 3 34s424ms 11s474ms [ 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-08-29 20:09:19 Duration: 26s473ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 23:17:46 Duration: 25s833ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 23:37:19 Duration: 5s698ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
19 6 1m1s 1s980ms 20s516ms 10s198ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 29 20 3 30s501ms 10s167ms 23 3 30s692ms 10s230ms [ User: intelifix - Total duration: 1m1s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m1s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 20:02:44 Duration: 20s516ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 23:10:49 Duration: 20s186ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 23:36:06 Duration: 8s506ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
20 6 59s964ms 2s16ms 21s762ms 9s994ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 29 20 3 31s341ms 10s447ms 23 3 28s622ms 9s540ms [ User: intelifix - Total duration: 59s964ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s964ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 20:03:21 Duration: 21s762ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 23:11:26 Duration: 19s382ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 20:09:49 Duration: 7s368ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 8m36s 8m36s 8m36s 1 8m36s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 29 10 1 8m36s 8m36s [ User: intelifix - Total duration: 8m36s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 8m36s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-28'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-29 10:22:37 Duration: 8m36s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
2 2m56s 10m29s 6m40s 3 20m2s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 29 05 3 20m2s 6m40s [ User: intelifix - Total duration: 20m2s - Times executed: 3 ]
[ Application: psql - Total duration: 20m2s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-29 05:10:30 Duration: 10m29s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
analyze verbose;
Date: 2026-08-29 05:17:07 Duration: 6m37s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
analyze verbose;
Date: 2026-08-29 05:20:04 Duration: 2m56s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
3 1s362ms 11m24s 2m14s 48 1h47m34s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 29 07 3 12m20s 4m6s 08 3 5m49s 1m56s 09 3 5m48s 1m56s 10 3 5m54s 1m58s 11 3 6m8s 2m2s 12 3 5m52s 1m57s 13 3 6m1s 2m 14 3 5m48s 1m56s 15 3 5m46s 1m55s 16 3 5m52s 1m57s 17 3 5m49s 1m56s 18 3 5m52s 1m57s 19 3 5m59s 1m59s 20 3 11m44s 3m54s 21 3 6m43s 2m14s 22 3 6m1s 2m [ User: intelifix - Total duration: 1h47m34s - Times executed: 48 ]
[ Application: psql - Total duration: 1h47m34s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-29 07:16:25 Duration: 11m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-29 20:16:02 Duration: 11m1s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-29 21:11:26 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
4 1m27s 1m27s 1m27s 1 1m27s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 29 05 1 1m27s 1m27s [ User: intelifix - Total duration: 1m27s - Times executed: 1 ]
[ Application: psql - Total duration: 1m27s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-29 05:32:11 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-29 05:32:03 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
5 240ms 4m5s 1m17s 48 1h2m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 29 07 3 5m57s 1m59s 08 3 3m35s 1m11s 09 3 3m38s 1m12s 10 3 3m47s 1m15s 11 3 3m41s 1m13s 12 3 3m34s 1m11s 13 3 3m39s 1m13s 14 3 3m35s 1m11s 15 3 3m44s 1m14s 16 3 3m37s 1m12s 17 3 3m37s 1m12s 18 3 3m33s 1m11s 19 3 3m38s 1m12s 20 3 5m7s 1m42s 21 3 3m38s 1m12s 22 3 3m54s 1m18s [ User: intelifix - Total duration: 1h2m21s - Times executed: 48 ]
[ Application: psql - Total duration: 1h2m21s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-29 07:23:10 Duration: 4m5s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-29 20:21:44 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-29 22:14:56 Duration: 3m20s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
6 5s711ms 1m36s 49s576ms 4 3m18s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 29 20 2 1m34s 47s262ms 23 2 1m43s 51s889ms [ User: intelifix - Total duration: 3m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-29 23:17:20 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-29 20:08:52 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-29 23:37:14 Duration: 7s87ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
7 377ms 1m1s 29s587ms 4 1m58s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 29 20 2 56s18ms 28s9ms 23 2 1m2s 31s166ms [ User: intelifix - Total duration: 1m58s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m58s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-29 23:13:45 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-29 20:05:32 Duration: 55s565ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-29 20:10:06 Duration: 453ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
8 9s788ms 38s856ms 20s356ms 6 2m2s select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 29 00 3 59s92ms 19s697ms 06 3 1m3s 21s14ms [ User: lenon - Total duration: 2m2s - Times executed: 6 ]
[ Application: psql - Total duration: 2m2s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-29 06:02:40 Duration: 38s856ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-29 00:02:38 Duration: 36s596ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-29 06:03:04 Duration: 14s42ms Database: contagem User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
9 10s222ms 22s409ms 15s399ms 6 1m32s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 29 00 3 1m1s 20s354ms 06 3 31s333ms 10s444ms [ User: intelifix - Total duration: 1m32s - Times executed: 6 ]
[ Application: psql - Total duration: 1m32s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-29 00:05:24 Duration: 22s409ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-29 00:06:03 Duration: 20s55ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-29 00:05:43 Duration: 18s598ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
10 2s599ms 33s788ms 15s209ms 6 1m31s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 29 20 3 45s600ms 15s200ms 23 3 45s656ms 15s218ms [ User: intelifix - Total duration: 1m31s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m31s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-29 20:06:08 Duration: 33s788ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 23:14:21 Duration: 33s457ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 20:10:15 Duration: 9s211ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
11 1s865ms 31s783ms 13s716ms 6 1m22s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 29 20 3 40s819ms 13s606ms 23 3 41s478ms 13s826ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-29 20:06:44 Duration: 31s783ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-29 23:14:57 Duration: 31s414ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-29 23:36:52 Duration: 8s153ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
12 3s504ms 21s108ms 12s308ms 4 49s232ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 29 20 2 24s613ms 12s306ms 23 2 24s619ms 12s309ms [ User: intelifix - Total duration: 49s232ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 49s232ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-29 20:04:37 Duration: 21s108ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-29 23:12:43 Duration: 20s492ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-29 23:36:33 Duration: 4s126ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
13 2s892ms 26s473ms 11s624ms 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 #13
Day Hour Count Duration Avg duration Aug 29 20 3 35s320ms 11s773ms 23 3 34s424ms 11s474ms [ 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-08-29 20:09:19 Duration: 26s473ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 23:17:46 Duration: 25s833ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 23:37:19 Duration: 5s698ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
14 1s980ms 20s516ms 10s198ms 6 1m1s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 29 20 3 30s501ms 10s167ms 23 3 30s692ms 10s230ms [ User: intelifix - Total duration: 1m1s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m1s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 20:02:44 Duration: 20s516ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 23:10:49 Duration: 20s186ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 23:36:06 Duration: 8s506ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
15 2s16ms 21s762ms 9s994ms 6 59s964ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 29 20 3 31s341ms 10s447ms 23 3 28s622ms 9s540ms [ User: intelifix - Total duration: 59s964ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s964ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 20:03:21 Duration: 21s762ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 23:11:26 Duration: 19s382ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-29 20:09:49 Duration: 7s368ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
16 1s873ms 23s899ms 9s927ms 6 59s564ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 29 20 3 28s826ms 9s608ms 23 3 30s738ms 10s246ms [ User: intelifix - Total duration: 59s564ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s564ms - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-29 23:12:23 Duration: 23s899ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 20:04:15 Duration: 22s298ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 23:36:29 Duration: 4s942ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
17 1s774ms 16s221ms 7s780ms 6 46s682ms 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 #17
Day Hour Count Duration Avg duration Aug 29 20 3 22s411ms 7s470ms 23 3 24s270ms 8s90ms [ User: intelifix - Total duration: 46s682ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 46s682ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-29 23:11:42 Duration: 16s221ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 20:03:36 Duration: 14s835ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-08-29 23:36:21 Duration: 6s274ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
18 163ms 28s901ms 4s447ms 36 2m40s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 29 00 6 46s605ms 7s767ms 01 6 22s869ms 3s811ms 02 6 16s717ms 2s786ms 03 5 20s493ms 4s98ms 04 6 23s95ms 3s849ms 05 4 27s741ms 6s935ms 19 1 2s50ms 2s50ms 20 2 543ms 271ms [ User: intelifix - Total duration: 2m40s - Times executed: 36 ]
[ Application: psql - Total duration: 2m40s - Times executed: 36 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-29 00:05:30 Duration: 28s901ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-29 05:25:15 Duration: 14s672ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-29 05:15:11 Duration: 9s415ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
19 175ms 19s617ms 2s891ms 276 13m18s call rs_giga_triagem (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 29 00 12 46s536ms 3s878ms 01 12 32s632ms 2s719ms 02 12 31s412ms 2s617ms 03 12 32s373ms 2s697ms 04 12 31s293ms 2s607ms 05 12 36s437ms 3s36ms 06 12 34s88ms 2s840ms 07 12 32s701ms 2s725ms 08 12 31s297ms 2s608ms 09 12 30s548ms 2s545ms 10 12 33s693ms 2s807ms 11 12 31s757ms 2s646ms 12 12 31s489ms 2s624ms 13 12 34s141ms 2s845ms 14 12 31s902ms 2s658ms 15 12 32s57ms 2s671ms 16 12 31s21ms 2s585ms 17 12 31s907ms 2s658ms 18 12 32s307ms 2s692ms 19 12 31s577ms 2s631ms 20 12 1m7s 5s619ms 21 12 33s999ms 2s833ms 22 12 35s429ms 2s952ms [ User: intelifix - Total duration: 13m18s - Times executed: 276 ]
[ Application: psql - Total duration: 13m18s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-29 20:15:21 Duration: 19s617ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-29 20:05:20 Duration: 19s138ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-29 00:05:47 Duration: 16s669ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
20 645ms 5s225ms 1s105ms 35 38s707ms 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 #20
Day Hour Count Duration Avg duration Aug 29 08 2 5s995ms 2s997ms 09 2 1s530ms 765ms 10 2 1s750ms 875ms 11 2 2s112ms 1s56ms 12 3 2s650ms 883ms 13 2 2s144ms 1s72ms 14 2 2s22ms 1s11ms 15 2 2s69ms 1s34ms 16 3 2s926ms 975ms 17 3 2s608ms 869ms 18 2 2s10ms 1s5ms 19 3 2s598ms 866ms 20 3 4s929ms 1s643ms 21 2 1s940ms 970ms 22 2 1s416ms 708ms [ User: intelifix - Total duration: 38s707ms - Times executed: 35 ]
[ Application: psql - Total duration: 38s707ms - Times executed: 35 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-29 08:00:06 Duration: 5s225ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-29 20:20:04 Duration: 2s844ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-29 20:40:02 Duration: 1s264ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 201ms 1 201ms 201ms 201ms select * from rs_caixa_qr ();Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Aug 29 23 1 201ms 201ms [ User: etiquetas - Total duration: 314ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 314ms - Times executed: 1 ]
-
select * from rs_caixa_qr ();
Date: 2026-08-29 23:25:17 Duration: 201ms Database: postgres User: rio Remote: etiquetas Application: [local] Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 12 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 28 11 1 0ms 0ms 21 1 0ms 0ms Aug 29 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 18 1 0ms 0ms 21 1 0ms 0ms 22 2 0ms 0ms [ User: intelifix - Total duration: 3m33s - Times executed: 12 ]
[ Application: psql - Total duration: 3m32s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 865ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 5,261 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 28 FATAL entries
- 1416 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,445 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 Aug 29 00 59 01 60 02 59 03 55 04 59 05 59 06 60 07 59 08 59 09 60 10 59 11 60 12 60 13 59 14 59 15 60 16 60 17 59 18 60 19 59 20 60 21 59 22 60 23 49 - ERROR: prepared statement "_PLAN0000000029C1DB90" does not exist
- ERROR: prepared statement "_PLAN0000000029C1E020" does not exist
- ERROR: prepared statement "_PLAN0000000029C1C950" does not exist
Statement: DEALLOCATE "_PLAN0000000029C1DB90"
Date: 2026-08-29 00:00:46 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: DEALLOCATE "_PLAN0000000029C1E020"
Date: 2026-08-29 00:01:47 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: DEALLOCATE "_PLAN0000000029C1C950"
Date: 2026-08-29 00:02:47 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
2 15 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 29 00 1 05 1 06 2 07 1 08 1 11 2 13 1 14 2 17 1 19 1 23 2 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-08-29 00:03:01 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Date: 2026-08-29 05:18:36 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Date: 2026-08-29 06:03:05 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
3 10 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 29 03 10 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-29 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Date: 2026-08-29 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Date: 2026-08-29 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 29 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-29 05:32:11 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-29 05:32:11 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-29 05:32:11 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
5 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 29 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-08-29 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Date: 2026-08-29 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Date: 2026-08-29 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
6 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 29 03 1 - LOG: database system was shut down at 2026-08-29 03:05:01 -03
Date: 2026-08-29 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-29.log