pgBadger-
Global information
- Generated on Mon Jun 29 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 9,056 log entries in 9s
- Log start from 2026-06-28 00:00:19 to 2026-06-28 23:59:35
-
Overview
Global Stats
- 145 Number of unique normalized queries
- 771 Number of queries
- 4h4m24s Total query duration
- 2026-06-28 00:00:19 First query
- 2026-06-28 23:52:45 Last query
- 4 queries/s at 2026-06-28 23:52:32 Query peak
- 4h4m24s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h4m24s Execute total duration
- 1,542 Number of events
- 10 Number of unique normalized events
- 1,427 Max number of times the same event was reported
- 0 Number of cancellation
- 8 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 10 Number temporary file
- 232.38 MiB Max size of temporary file
- 108.08 MiB Average size of temporary file
- 203 Total number of sessions
- 7 sessions at 2026-06-28 06:02:34 Session peak
- 7d16h59m23s Total duration of sessions
- 54m40s Average duration of sessions
- 3 Average queries per session
- 1m12s Average queries duration per session
- 53m28s Average idle time per session
- 213 Total number of connections
- 3 connections/s at 2026-06-28 23:45:03 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-28 23:52:32 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-06-28 23:10:03 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-28 23:52:32 Date
Queries duration
Key values
- 4h4m24s 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) Jun 28 00 17 0ms 34s190ms 7s226ms 3s168ms 3s536ms 1m7s 01 7 0ms 3s866ms 2s850ms 3s14ms 3s156ms 4s22ms 02 8 0ms 3s514ms 2s538ms 3s93ms 3s514ms 3s601ms 03 10 0ms 3s717ms 1s688ms 745ms 3s120ms 3s911ms 04 8 0ms 3s929ms 2s613ms 2s889ms 3s485ms 4s120ms 05 12 0ms 8m49s 1m31s 4s194ms 2m34s 8m49s 06 14 0ms 29s684ms 5s934ms 3s328ms 3s913ms 34s573ms 07 13 0ms 6m53s 56s82ms 3s400ms 51s420ms 6m53s 08 15 0ms 5m31s 40s381ms 3s392ms 43s586ms 5m31s 09 15 0ms 6m2s 42s944ms 3s164ms 3s424ms 6m45s 10 17 0ms 5m39s 35s414ms 3s314ms 43s777ms 5m39s 11 17 0ms 5m35s 36s32ms 3s523ms 45s866ms 5m35s 12 15 0ms 5m46s 40s945ms 3s348ms 44s995ms 5m46s 13 17 0ms 5m28s 34s580ms 3s452ms 14s916ms 5m56s 14 16 0ms 5m32s 36s945ms 3s355ms 41s576ms 5m32s 15 16 0ms 5m32s 37s367ms 3s525ms 43s49ms 5m32s 16 15 0ms 5m41s 40s339ms 3s651ms 43s869ms 5m41s 17 16 0ms 5m42s 37s951ms 3s724ms 44s899ms 5m42s 18 19 0ms 5m49s 32s492ms 4s65ms 45s73ms 5m49s 19 16 0ms 5m31s 37s133ms 3s840ms 44s234ms 5m31s 20 103 0ms 6m20s 13s38ms 1m7s 2m12s 7m7s 21 17 0ms 7m51s 43s964ms 3s778ms 46s554ms 7m51s 22 16 0ms 5m49s 39s412ms 3s526ms 49s167ms 5m49s 23 352 0ms 1m47s 7s257ms 1m14s 1m47s 2m13s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 28 00 5 0 7s778ms 0ms 0ms 266ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 305ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 11s524ms 0ms 0ms 0ms 07 6 0 1m58s 0ms 0ms 3m36s 08 6 0 1m36s 0ms 0ms 3m25s 09 6 0 1m43s 0ms 0ms 3m34s 10 6 0 1m36s 0ms 0ms 3m16s 11 6 0 1m38s 0ms 0ms 3m27s 12 6 0 1m38s 0ms 0ms 3m20s 13 6 0 1m34s 0ms 0ms 3m12s 14 6 0 1m34s 0ms 0ms 3m13s 15 6 0 1m35s 0ms 0ms 3m17s 16 6 0 1m36s 0ms 0ms 3m13s 17 6 0 1m37s 0ms 0ms 3m14s 18 9 0 1m5s 0ms 0ms 3m14s 19 6 0 1m34s 0ms 0ms 3m13s 20 11 82 14s95ms 40s621ms 1m4s 4m22s 21 7 0 1m43s 0ms 0ms 3m22s 22 6 0 1m40s 0ms 0ms 3m27s 23 21 331 7s257ms 1m2s 1m14s 2m4s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 28 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 Jun 28 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 3 3.00 0.00% Day Hour Count Average / Second Jun 28 00 15 0.00/s 01 4 0.00/s 02 8 0.00/s 03 12 0.00/s 04 7 0.00/s 05 8 0.00/s 06 14 0.00/s 07 10 0.00/s 08 8 0.00/s 09 9 0.00/s 10 8 0.00/s 11 7 0.00/s 12 8 0.00/s 13 8 0.00/s 14 8 0.00/s 15 9 0.00/s 16 7 0.00/s 17 9 0.00/s 18 8 0.00/s 19 8 0.00/s 20 12 0.00/s 21 7 0.00/s 22 7 0.00/s 23 12 0.00/s Day Hour Count Average Duration Average idle time Jun 28 00 8 1h45s 1h29s 01 13 1h42s 1h40s 02 4 1h 59m55s 03 12 23m16s 23m14s 04 7 1h3m 1h2m57s 05 7 1h25s 57m49s 06 8 56m53s 56m43s 07 13 56m51s 55m55s 08 8 1h1m5s 59m50s 09 9 54m28s 53m17s 10 9 54m46s 53m40s 11 8 53m45s 52m28s 12 6 1h58s 59m15s 13 8 1h23s 59m9s 14 9 54m26s 53m21s 15 7 52m51s 51m26s 16 8 1h 58m44s 17 8 53m45s 52m29s 18 8 54m7s 52m50s 19 7 1h1m14s 59m49s 20 11 45m6s 43m4s 21 8 1h 58m26s 22 7 1h15s 58m44s 23 10 46m34s 42m19s -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2026-06-28 23:45:03 Date
Connections per database
Key values
- rio Main Database
- 213 connections Total
Connections per user
Key values
- intelifix Main User
- 213 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-06-28 06:02:34 Date
Histogram of session times
Key values
- 175 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 203 sessions Total
Sessions per user
Key values
- intelifix Main User
- 203 sessions Total
Sessions per host
Key values
- [local] Main Host
- 203 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 10,749 buffers Checkpoint Peak
- 2026-06-28 00:49:50 Date
- 269.476 seconds Highest write time
- 0.024 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-06-28 00:49:50 Date
Checkpoints distance
Key values
- 113.81 Mo Distance Peak
- 2026-06-28 00:49:50 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 28 00 16,929 538.799s 0.015s 538.834s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0.041s 0.009s 0.061s 04 0 0s 0s 0s 05 6,370 638.408s 0.049s 638.509s 06 2,172 217.143s 0.004s 217.155s 07 1,194 119.781s 0.003s 119.791s 08 21 2.121s 0.003s 2.131s 09 21 2.132s 0.003s 2.141s 10 21 2.133s 0.003s 2.142s 11 20 2.03s 0.003s 2.039s 12 20 2.03s 0.003s 2.04s 13 394 39.457s 0.002s 39.466s 14 25 2.539s 0.003s 2.55s 15 21 2.13s 0.003s 2.139s 16 20 2.029s 0.003s 2.039s 17 21 2.131s 0.003s 2.141s 18 1,285 128.771s 0.013s 128.807s 19 21 2.133s 0.003s 2.143s 20 93 9.385s 0.007s 9.412s 21 21 2.126s 0.002s 2.132s 22 22 2.238s 0.003s 2.25s 23 427 42.961s 0.031s 43.019s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 28 00 0 0 5 62 0.002s 0.002s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 3 0.006s 0.003s 04 0 0 0 0 0s 0s 05 0 0 3 172 0.010s 0.006s 06 0 0 0 10 0.001s 0.001s 07 0 0 1 14 0.001s 0.001s 08 0 0 0 3 0.003s 0.001s 09 0 0 0 3 0.002s 0.001s 10 0 0 0 3 0.002s 0.001s 11 0 0 0 3 0.002s 0.001s 12 0 0 0 3 0.003s 0.001s 13 0 0 0 5 0.001s 0.001s 14 0 0 0 4 0.003s 0.001s 15 0 0 0 3 0.002s 0.001s 16 0 0 0 3 0.003s 0.001s 17 0 0 0 3 0.003s 0.001s 18 0 0 0 79 0.003s 0.004s 19 0 0 0 3 0.003s 0.001s 20 0 0 0 19 0.002s 0.003s 21 0 0 0 3 0.002s 0.001s 22 0 0 0 3 0.003s 0.001s 23 0 0 0 93 0.012s 0.008s Day Hour Count Avg time (sec) Jun 28 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 Jun 28 00 43,476.00 kB 43,476.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 26,222.00 kB 04 0.00 kB 0.00 kB 05 7,864.50 kB 13,042.67 kB 06 3,919.00 kB 14,236.00 kB 07 6,310.00 kB 13,443.00 kB 08 165.00 kB 12,115.00 kB 09 165.00 kB 10,920.00 kB 10 165.00 kB 9,845.00 kB 11 165.00 kB 8,877.00 kB 12 164.00 kB 8,005.00 kB 13 1,918.00 kB 7,397.00 kB 14 167.00 kB 6,674.00 kB 15 165.00 kB 6,023.00 kB 16 165.00 kB 5,437.00 kB 17 166.00 kB 4,910.00 kB 18 1,314.00 kB 4,228.50 kB 19 165.00 kB 3,270.00 kB 20 206.33 kB 2,687.33 kB 21 165.00 kB 2,215.00 kB 22 165.00 kB 2,010.00 kB 23 248.80 kB 1,547.40 kB -
Temporary Files
Size of temporary files
Key values
- 464.77 MiB Temp Files size Peak
- 2026-06-28 05:32:02 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-06-28 05:32:09 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 28 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.06 GiB 108.08 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 902.96 MiB 69.31 MiB 232.38 MiB 112.87 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-28 05:32:10 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-28 05:32:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 177.84 MiB 88.92 MiB 88.92 MiB 88.92 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-28 05:30:43 Duration: 40s556ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-28 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 232.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-28 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 232.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-28 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 88.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-06-28 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 88.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-06-28 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 76.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-28 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 76.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-28 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 76.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-28 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 69.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-28 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 69.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-28 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 69.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-28 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.62 sec Highest CPU-cost vacuum
Table public.logs
Database rio - 2026-06-28 13:11:09 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.62 sec Highest CPU-cost vacuum
Table public.logs
Database rio - 2026-06-28 13:11:09 Date
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_statistic (1) Main table vacuumed on database contagem
- 8 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,233 336 1,198,349 310 2,377 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 850 143 926,655 86 300 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,131 345 1,602,171 316 1,963 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 135 29 107,900 6 10 rio.public.logs 1 0 0 0 0 0 0 1,712 1,467 1,782,561 113 2,817 rio.pg_catalog.pg_type 1 1 0 0 0 0 0 92 42 49,059 0 0 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 161 24 67,950 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,695 76 460,541 67 493 Total 8 7 0 0 0 0 0 11,009 2,462 6,195,186 898 7,960 Vacuum throughput per table
Key values
- public.logs (0.62) 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 contagem.pg_catalog.pg_statistic 0 0 0.08 rio.pg_toast.pg_toast_2619 0 0 0.08 rio.pg_catalog.pg_statistic 0 0 0.2 contagem.pg_toast.pg_toast_2619 0 0 0.01 rio.public.logs 0 0 0.62 rio.pg_catalog.pg_type 0 0 0.12 brasilia.pg_toast.pg_toast_2619 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.12 Total 0 0 1.23 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4380) Main table with removed tuples on database rio
- 13349 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,380 7,458 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,278 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,642 7,318 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 658 673 0 42 249 rio.pg_catalog.pg_type 1 1 146 2,199 0 0 69 brasilia.pg_toast.pg_toast_2619 1 1 141 130 0 0 67 contagem.pg_toast.pg_toast_2619 1 1 104 119 0 3 51 rio.public.logs 1 0 0 15,984,776 0 0 638,679 Total 8 7 13,349 16,009,947 0 45 642,484 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (42) Main table with removed pages on database rio
- 45 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_toast.pg_toast_2619 1 1 658 42 contagem.pg_toast.pg_toast_2619 1 1 104 3 contagem.pg_catalog.pg_statistic 1 1 4278 0 rio.pg_catalog.pg_statistic 1 1 4380 0 rio.public.logs 1 0 0 0 rio.pg_catalog.pg_type 1 1 146 0 brasilia.pg_toast.pg_toast_2619 1 1 141 0 brasilia.pg_catalog.pg_statistic 1 1 3642 0 Total 8 7 13,349 45 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 28 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 1 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 1 0 - 0.62 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
- 135 Total read queries
- 413 Total write queries
Queries by database
Key values
- rio Main database
- 388 Requests
- 2h42m23s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 759 Requests
User Request type Count Duration etiquetas Total 6 1s940ms select 6 1s940ms intelifix Total 759 4h3m9s copy to 413 52m2s others 223 28m19s select 123 2h42m48s lenon Total 6 1m13s select 6 1m13s Duration by user
Key values
- 4h3m9s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 6 1s940ms select 6 1s940ms intelifix Total 759 4h3m9s copy to 413 52m2s others 223 28m19s select 123 2h42m48s lenon Total 6 1m13s select 6 1m13s Queries by host
Key values
- [local] Main host
- 771 Requests
- 4h4m24s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 432 Requests
- 3h12m14s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-28 00:56:13 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 348 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 8m49s analyze verbose;[ Date: 2026-06-28 05:08:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-28 21:12:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 6m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-28 07:11:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-28 20:11:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-28 09:11:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-28 18:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-28 22:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-28 12:10:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-28 17:10:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-28 16:10:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-28 10:10:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-28 11:10:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-28 14:10:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-28 15:10:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-28 08:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-28 19:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-28 13:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m26s analyze verbose;[ Date: 2026-06-28 05:13:17 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
19 4m16s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-06-28 20:17:08 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m32s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-06-28 09:15:20 - 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 1h39m42s 48 1s136ms 7m51s 2m4s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 28 07 3 7m26s 2m28s 08 3 5m47s 1m55s 09 3 6m17s 2m5s 10 3 5m56s 1m58s 11 3 5m52s 1m57s 12 3 6m2s 2m 13 3 5m44s 1m54s 14 3 5m48s 1m56s 15 3 5m49s 1m56s 16 3 5m57s 1m59s 17 3 5m59s 1m59s 18 3 6m6s 2m2s 19 3 5m47s 1m55s 20 3 6m49s 2m16s 21 3 8m8s 2m42s 22 3 6m7s 2m2s [ User: intelifix - Total duration: 1h39m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h39m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-28 21:12:53 Duration: 7m51s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-28 07:11:55 Duration: 6m53s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-28 20:11:21 Duration: 6m20s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
2 1h2m53s 48 229ms 4m16s 1m18s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 28 07 3 4m22s 1m27s 08 3 3m52s 1m17s 09 3 4m2s 1m20s 10 3 3m42s 1m14s 11 3 3m57s 1m19s 12 3 3m49s 1m16s 13 3 3m39s 1m13s 14 3 3m39s 1m13s 15 3 3m44s 1m14s 16 3 3m40s 1m13s 17 3 3m43s 1m14s 18 3 3m42s 1m14s 19 3 3m41s 1m13s 20 3 5m23s 1m47s 21 3 3m52s 1m17s 22 3 3m58s 1m19s [ User: intelifix - Total duration: 1h2m53s - Times executed: 48 ]
[ Application: psql - Total duration: 1h2m53s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-28 20:17:08 Duration: 4m16s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-28 09:15:20 Duration: 3m32s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-28 07:16:44 Duration: 3m30s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
3 15m46s 3 2m30s 8m49s 5m15s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 28 05 3 15m46s 5m15s [ User: intelifix - Total duration: 15m46s - Times executed: 3 ]
[ Application: psql - Total duration: 15m46s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-28 05:08:50 Duration: 8m49s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
analyze verbose;
Date: 2026-06-28 05:13:17 Duration: 4m26s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
analyze verbose;
Date: 2026-06-28 05:15:47 Duration: 2m30s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
4 8m10s 164 150ms 10s865ms 2s992ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 28 00 8 28s277ms 3s534ms 01 7 19s955ms 2s850ms 02 8 20s307ms 2s538ms 03 8 16s362ms 2s45ms 04 8 20s907ms 2s613ms 05 7 22s842ms 3s263ms 06 8 21s120ms 2s640ms 07 7 19s773ms 2s824ms 08 6 19s783ms 3s297ms 09 6 20s118ms 3s353ms 10 8 19s885ms 2s485ms 11 8 20s391ms 2s548ms 12 6 19s642ms 3s273ms 13 8 20s514ms 2s564ms 14 7 20s591ms 2s941ms 15 6 21s1ms 3s500ms 16 6 21s517ms 3s586ms 17 7 21s870ms 3s124ms 18 7 21s991ms 3s141ms 19 7 22s470ms 3s210ms 20 7 27s651ms 3s950ms 21 7 22s213ms 3s173ms 22 7 21s615ms 3s87ms [ User: intelifix - Total duration: 8m10s - Times executed: 164 ]
[ Application: psql - Total duration: 8m10s - Times executed: 164 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-28 00:05:12 Duration: 10s865ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-28 20:15:11 Duration: 10s260ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-28 18:55:06 Duration: 4s556ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
5 3m15s 4 5s380ms 1m35s 48s993ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 28 20 2 1m40s 50s351ms 23 2 1m35s 47s635ms [ User: intelifix - Total duration: 3m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-28 20:09:11 Duration: 1m35s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-28 23:39:19 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-28 20:11:06 Duration: 5s654ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
6 2m8s 2 21s465ms 1m47s 1m4s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 28 23 2 2m8s 1m4s [ User: intelifix - Total duration: 2m8s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m8s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:14:39 Duration: 1m47s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:51:27 Duration: 21s465ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
7 2m 3 4s421ms 1m36s 40s220ms copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 28 23 3 2m 40s220ms [ User: intelifix - Total duration: 2m - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m - Times executed: 3 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:16:16 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:51:47 Duration: 19s298ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:39:54 Duration: 4s421ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
8 1m53s 4 338ms 1m3s 28s457ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 28 20 2 1m3s 31s888ms 23 2 50s53ms 25s26ms [ User: intelifix - Total duration: 1m53s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m53s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-28 20:05:50 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-28 23:19:24 Duration: 49s715ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-28 20:10:29 Duration: 401ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
9 1m53s 2 19s126ms 1m34s 56s673ms copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 28 23 2 1m53s 56s673ms [ User: intelifix - Total duration: 1m53s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m53s - Times executed: 2 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:11:40 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:50:47 Duration: 19s126ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
10 1m30s 2 18s473ms 1m11s 45s155ms copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 28 23 2 1m30s 45s155ms [ User: intelifix - Total duration: 1m30s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m30s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:12:52 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:51:06 Duration: 18s473ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
11 1m26s 1 1m26s 1m26s 1m26s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 28 05 1 1m26s 1m26s [ User: intelifix - Total duration: 1m26s - Times executed: 1 ]
[ Application: psql - Total duration: 1m26s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-28 05:32:10 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-28 05:32:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
12 1m22s 6 2s550ms 30s134ms 13s822ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 28 20 3 42s178ms 14s59ms 23 3 40s754ms 13s584ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - 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-06-28 20:06:21 Duration: 30s134ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 23:19:55 Duration: 29s767ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 20:10:39 Duration: 9s279ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
13 1m22s 6 7s670ms 21s319ms 13s799ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 28 00 3 55s406ms 18s468ms 06 3 27s391ms 9s130ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: psql - Total duration: 1m22s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-28 00:05:57 Duration: 21s319ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-28 00:05:21 Duration: 18s707ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-28 00:05:36 Duration: 15s379ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
14 1m13s 6 3s13ms 29s241ms 12s310ms 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 Jun 28 20 3 40s11ms 13s337ms 23 3 33s850ms 11s283ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - 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-06-28 20:09:40 Duration: 29s241ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 23:39:45 Duration: 25s922ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 20:11:13 Duration: 7s74ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
15 1m13s 6 1s781ms 28s466ms 12s297ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 28 20 3 37s425ms 12s475ms 23 3 36s358ms 12s119ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-28 20:06:54 Duration: 28s466ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-28 23:20:26 Duration: 28s443ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-28 20:10:46 Duration: 7s177ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
16 1m13s 6 762ms 34s190ms 12s173ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 28 00 3 38s467ms 12s822ms 06 3 34s573ms 11s524ms [ User: lenon - Total duration: 1m13s - Times executed: 6 ]
[ Application: psql - Total duration: 1m13s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-28 00:02:36 Duration: 34s190ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-28 06:02:32 Duration: 29s684ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-28 06:02:37 Duration: 4s125ms Database: contagem User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
17 59s815ms 6 1s594ms 21s214ms 9s969ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 28 20 3 32s225ms 10s741ms 23 3 27s589ms 9s196ms [ User: intelifix - Total duration: 59s815ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s815ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 20:03:27 Duration: 21s214ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 23:17:26 Duration: 18s380ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 20:10:10 Duration: 8s554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
18 58s530ms 6 1s910ms 20s707ms 9s755ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 28 20 3 30s781ms 10s260ms 23 3 27s748ms 9s249ms [ User: intelifix - Total duration: 58s530ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s530ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 20:02:49 Duration: 20s707ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 23:16:53 Duration: 17s952ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 20:10:00 Duration: 8s58ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
19 54s742ms 6 1s273ms 23s743ms 9s123ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 28 20 3 29s795ms 9s931ms 23 3 24s947ms 8s315ms [ User: intelifix - Total duration: 54s742ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 54s742ms - 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-06-28 20:04:25 Duration: 23s743ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 23:18:15 Duration: 19s693ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 20:10:25 Duration: 4s364ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
20 47s521ms 4 3s604ms 21s324ms 11s880ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 28 20 2 24s960ms 12s480ms 23 2 22s561ms 11s280ms [ User: intelifix - Total duration: 47s521ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 47s521ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-28 20:04:47 Duration: 21s324ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-28 23:18:34 Duration: 18s957ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-28 20:10:28 Duration: 3s635ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 164 8m10s 150ms 10s865ms 2s992ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 28 00 8 28s277ms 3s534ms 01 7 19s955ms 2s850ms 02 8 20s307ms 2s538ms 03 8 16s362ms 2s45ms 04 8 20s907ms 2s613ms 05 7 22s842ms 3s263ms 06 8 21s120ms 2s640ms 07 7 19s773ms 2s824ms 08 6 19s783ms 3s297ms 09 6 20s118ms 3s353ms 10 8 19s885ms 2s485ms 11 8 20s391ms 2s548ms 12 6 19s642ms 3s273ms 13 8 20s514ms 2s564ms 14 7 20s591ms 2s941ms 15 6 21s1ms 3s500ms 16 6 21s517ms 3s586ms 17 7 21s870ms 3s124ms 18 7 21s991ms 3s141ms 19 7 22s470ms 3s210ms 20 7 27s651ms 3s950ms 21 7 22s213ms 3s173ms 22 7 21s615ms 3s87ms [ User: intelifix - Total duration: 8m10s - Times executed: 164 ]
[ Application: psql - Total duration: 8m10s - Times executed: 164 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-28 00:05:12 Duration: 10s865ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-28 20:15:11 Duration: 10s260ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-28 18:55:06 Duration: 4s556ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
2 48 1h39m42s 1s136ms 7m51s 2m4s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 28 07 3 7m26s 2m28s 08 3 5m47s 1m55s 09 3 6m17s 2m5s 10 3 5m56s 1m58s 11 3 5m52s 1m57s 12 3 6m2s 2m 13 3 5m44s 1m54s 14 3 5m48s 1m56s 15 3 5m49s 1m56s 16 3 5m57s 1m59s 17 3 5m59s 1m59s 18 3 6m6s 2m2s 19 3 5m47s 1m55s 20 3 6m49s 2m16s 21 3 8m8s 2m42s 22 3 6m7s 2m2s [ User: intelifix - Total duration: 1h39m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h39m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-28 21:12:53 Duration: 7m51s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-28 07:11:55 Duration: 6m53s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-28 20:11:21 Duration: 6m20s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
3 48 1h2m53s 229ms 4m16s 1m18s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 28 07 3 4m22s 1m27s 08 3 3m52s 1m17s 09 3 4m2s 1m20s 10 3 3m42s 1m14s 11 3 3m57s 1m19s 12 3 3m49s 1m16s 13 3 3m39s 1m13s 14 3 3m39s 1m13s 15 3 3m44s 1m14s 16 3 3m40s 1m13s 17 3 3m43s 1m14s 18 3 3m42s 1m14s 19 3 3m41s 1m13s 20 3 5m23s 1m47s 21 3 3m52s 1m17s 22 3 3m58s 1m19s [ User: intelifix - Total duration: 1h2m53s - Times executed: 48 ]
[ Application: psql - Total duration: 1h2m53s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-28 20:17:08 Duration: 4m16s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-28 09:15:20 Duration: 3m32s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-28 07:16:44 Duration: 3m30s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
4 32 34s845ms 728ms 2s824ms 1s88ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 28 08 2 3s468ms 1s734ms 09 1 822ms 822ms 10 2 1s915ms 957ms 11 3 2s875ms 958ms 12 1 980ms 980ms 13 2 1s774ms 887ms 14 3 2s630ms 876ms 15 2 1s983ms 991ms 16 3 4s856ms 1s618ms 17 3 2s648ms 882ms 18 3 3s132ms 1s44ms 19 1 1s152ms 1s152ms 20 2 1s742ms 871ms 21 3 4s23ms 1s341ms 22 1 837ms 837ms [ User: intelifix - Total duration: 34s845ms - Times executed: 32 ]
[ Application: psql - Total duration: 34s845ms - Times executed: 32 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-28 16:20:04 Duration: 2s824ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-28 21:20:03 Duration: 2s203ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-28 08:00:03 Duration: 2s190ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
5 13 15s878ms 643ms 2s606ms 1s221ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 28 08 1 1s651ms 1s651ms 09 2 2s584ms 1s292ms 10 1 935ms 935ms 12 2 1s664ms 832ms 13 1 1s125ms 1s125ms 15 1 1s218ms 1s218ms 19 2 1s891ms 945ms 20 1 2s606ms 2s606ms 22 2 2s201ms 1s100ms [ User: intelifix - Total duration: 15s878ms - Times executed: 13 ]
[ Application: psql - Total duration: 15s878ms - Times executed: 13 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-28 20:20:04 Duration: 2s606ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-28 09:40:03 Duration: 1s940ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-28 08:40:03 Duration: 1s651ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
6 6 1m22s 2s550ms 30s134ms 13s822ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 28 20 3 42s178ms 14s59ms 23 3 40s754ms 13s584ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - 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-06-28 20:06:21 Duration: 30s134ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 23:19:55 Duration: 29s767ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 20:10:39 Duration: 9s279ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
7 6 1m22s 7s670ms 21s319ms 13s799ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 28 00 3 55s406ms 18s468ms 06 3 27s391ms 9s130ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: psql - Total duration: 1m22s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-28 00:05:57 Duration: 21s319ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-28 00:05:21 Duration: 18s707ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-28 00:05:36 Duration: 15s379ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
8 6 1m13s 3s13ms 29s241ms 12s310ms 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 #8
Day Hour Count Duration Avg duration Jun 28 20 3 40s11ms 13s337ms 23 3 33s850ms 11s283ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - 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-06-28 20:09:40 Duration: 29s241ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 23:39:45 Duration: 25s922ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 20:11:13 Duration: 7s74ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
9 6 1m13s 1s781ms 28s466ms 12s297ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 28 20 3 37s425ms 12s475ms 23 3 36s358ms 12s119ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-28 20:06:54 Duration: 28s466ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-28 23:20:26 Duration: 28s443ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-28 20:10:46 Duration: 7s177ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
10 6 1m13s 762ms 34s190ms 12s173ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 28 00 3 38s467ms 12s822ms 06 3 34s573ms 11s524ms [ User: lenon - Total duration: 1m13s - Times executed: 6 ]
[ Application: psql - Total duration: 1m13s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-28 00:02:36 Duration: 34s190ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-28 06:02:32 Duration: 29s684ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-28 06:02:37 Duration: 4s125ms Database: contagem User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
11 6 59s815ms 1s594ms 21s214ms 9s969ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 28 20 3 32s225ms 10s741ms 23 3 27s589ms 9s196ms [ User: intelifix - Total duration: 59s815ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s815ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 20:03:27 Duration: 21s214ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 23:17:26 Duration: 18s380ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 20:10:10 Duration: 8s554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
12 6 58s530ms 1s910ms 20s707ms 9s755ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 28 20 3 30s781ms 10s260ms 23 3 27s748ms 9s249ms [ User: intelifix - Total duration: 58s530ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s530ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 20:02:49 Duration: 20s707ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 23:16:53 Duration: 17s952ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 20:10:00 Duration: 8s58ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
13 6 54s742ms 1s273ms 23s743ms 9s123ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 28 20 3 29s795ms 9s931ms 23 3 24s947ms 8s315ms [ User: intelifix - Total duration: 54s742ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 54s742ms - 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-06-28 20:04:25 Duration: 23s743ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 23:18:15 Duration: 19s693ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 20:10:25 Duration: 4s364ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
14 6 46s538ms 1s390ms 16s309ms 7s756ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 28 20 3 24s717ms 8s239ms 23 3 21s820ms 7s273ms [ User: intelifix - Total duration: 46s538ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 46s538ms - 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-06-28 20:03:43 Duration: 16s309ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 23:17:40 Duration: 13s748ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 20:10:17 Duration: 6s846ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
15 6 38s850ms 2s781ms 8s851ms 6s475ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 28 20 3 20s385ms 6s795ms 23 3 18s464ms 6s154ms [ User: intelifix - Total duration: 38s850ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 38s850ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-06-28 23:50:10 Duration: 8s851ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-06-28 20:07:22 Duration: 8s437ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-06-28 20:10:59 Duration: 7s973ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
16 6 37s79ms 896ms 15s932ms 6s179ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 28 20 3 19s125ms 6s375ms 23 3 17s953ms 5s984ms [ User: intelifix - Total duration: 37s79ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 37s79ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-06-28 20:03:06 Duration: 15s932ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-06-28 23:17:08 Duration: 14s443ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-06-28 23:40:12 Duration: 2s613ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
17 6 30s553ms 950ms 13s557ms 5s92ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 28 20 3 17s507ms 5s835ms 23 3 13s46ms 4s348ms [ User: intelifix - Total duration: 30s553ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 30s553ms - Times executed: 6 ]
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-06-28 20:02:24 Duration: 13s557ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-06-28 23:16:32 Duration: 9s908ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-06-28 20:09:51 Duration: 2s842ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
18 6 26s147ms 794ms 12s342ms 4s357ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 28 20 3 14s291ms 4s763ms 23 3 11s856ms 3s952ms [ User: intelifix - Total duration: 26s147ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 26s147ms - Times executed: 6 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-06-28 20:04:01 Duration: 12s342ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-06-28 23:17:55 Duration: 10s186ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-06-28 20:11:33 Duration: 984ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
19 6 16s137ms 542ms 5s832ms 2s689ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 28 20 3 8s659ms 2s886ms 23 3 7s478ms 2s492ms [ User: intelifix - Total duration: 16s137ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 16s137ms - Times executed: 6 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-06-28 20:03:49 Duration: 5s832ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-06-28 23:17:45 Duration: 5s115ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-06-28 20:10:19 Duration: 2s283ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
20 6 15s199ms 2s377ms 2s802ms 2s533ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 28 20 3 7s483ms 2s494ms 23 3 7s716ms 2s572ms [ User: intelifix - Total duration: 15s199ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 15s199ms - Times executed: 6 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-06-28 23:39:58 Duration: 2s802ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-06-28 20:11:23 Duration: 2s675ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-06-28 23:51:51 Duration: 2s486ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m30s 8m49s 5m15s 3 15m46s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 28 05 3 15m46s 5m15s [ User: intelifix - Total duration: 15m46s - Times executed: 3 ]
[ Application: psql - Total duration: 15m46s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-28 05:08:50 Duration: 8m49s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
analyze verbose;
Date: 2026-06-28 05:13:17 Duration: 4m26s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
analyze verbose;
Date: 2026-06-28 05:15:47 Duration: 2m30s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
2 1s136ms 7m51s 2m4s 48 1h39m42s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 28 07 3 7m26s 2m28s 08 3 5m47s 1m55s 09 3 6m17s 2m5s 10 3 5m56s 1m58s 11 3 5m52s 1m57s 12 3 6m2s 2m 13 3 5m44s 1m54s 14 3 5m48s 1m56s 15 3 5m49s 1m56s 16 3 5m57s 1m59s 17 3 5m59s 1m59s 18 3 6m6s 2m2s 19 3 5m47s 1m55s 20 3 6m49s 2m16s 21 3 8m8s 2m42s 22 3 6m7s 2m2s [ User: intelifix - Total duration: 1h39m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h39m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-28 21:12:53 Duration: 7m51s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-28 07:11:55 Duration: 6m53s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-28 20:11:21 Duration: 6m20s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
3 1m26s 1m26s 1m26s 1 1m26s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 28 05 1 1m26s 1m26s [ User: intelifix - Total duration: 1m26s - Times executed: 1 ]
[ Application: psql - Total duration: 1m26s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-28 05:32:10 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-28 05:32:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 229ms 4m16s 1m18s 48 1h2m53s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 28 07 3 4m22s 1m27s 08 3 3m52s 1m17s 09 3 4m2s 1m20s 10 3 3m42s 1m14s 11 3 3m57s 1m19s 12 3 3m49s 1m16s 13 3 3m39s 1m13s 14 3 3m39s 1m13s 15 3 3m44s 1m14s 16 3 3m40s 1m13s 17 3 3m43s 1m14s 18 3 3m42s 1m14s 19 3 3m41s 1m13s 20 3 5m23s 1m47s 21 3 3m52s 1m17s 22 3 3m58s 1m19s [ User: intelifix - Total duration: 1h2m53s - Times executed: 48 ]
[ Application: psql - Total duration: 1h2m53s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-28 20:17:08 Duration: 4m16s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-28 09:15:20 Duration: 3m32s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-28 07:16:44 Duration: 3m30s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
5 21s465ms 1m47s 1m4s 2 2m8s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 28 23 2 2m8s 1m4s [ User: intelifix - Total duration: 2m8s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m8s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:14:39 Duration: 1m47s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:51:27 Duration: 21s465ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
6 19s126ms 1m34s 56s673ms 2 1m53s copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 28 23 2 1m53s 56s673ms [ User: intelifix - Total duration: 1m53s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m53s - Times executed: 2 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:11:40 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:50:47 Duration: 19s126ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
7 5s380ms 1m35s 48s993ms 4 3m15s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 28 20 2 1m40s 50s351ms 23 2 1m35s 47s635ms [ User: intelifix - Total duration: 3m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-28 20:09:11 Duration: 1m35s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-28 23:39:19 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-28 20:11:06 Duration: 5s654ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
8 18s473ms 1m11s 45s155ms 2 1m30s copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 28 23 2 1m30s 45s155ms [ User: intelifix - Total duration: 1m30s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m30s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:12:52 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:51:06 Duration: 18s473ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
9 4s421ms 1m36s 40s220ms 3 2m copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 28 23 3 2m 40s220ms [ User: intelifix - Total duration: 2m - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m - Times executed: 3 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:16:16 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:51:47 Duration: 19s298ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-28 23:39:54 Duration: 4s421ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
10 338ms 1m3s 28s457ms 4 1m53s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 28 20 2 1m3s 31s888ms 23 2 50s53ms 25s26ms [ User: intelifix - Total duration: 1m53s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m53s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-28 20:05:50 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-28 23:19:24 Duration: 49s715ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-28 20:10:29 Duration: 401ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
11 2s550ms 30s134ms 13s822ms 6 1m22s 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 Jun 28 20 3 42s178ms 14s59ms 23 3 40s754ms 13s584ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - 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-06-28 20:06:21 Duration: 30s134ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 23:19:55 Duration: 29s767ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 20:10:39 Duration: 9s279ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
12 7s670ms 21s319ms 13s799ms 6 1m22s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 28 00 3 55s406ms 18s468ms 06 3 27s391ms 9s130ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: psql - Total duration: 1m22s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-28 00:05:57 Duration: 21s319ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-28 00:05:21 Duration: 18s707ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-28 00:05:36 Duration: 15s379ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
13 3s13ms 29s241ms 12s310ms 6 1m13s 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 Jun 28 20 3 40s11ms 13s337ms 23 3 33s850ms 11s283ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - 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-06-28 20:09:40 Duration: 29s241ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 23:39:45 Duration: 25s922ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 20:11:13 Duration: 7s74ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
14 1s781ms 28s466ms 12s297ms 6 1m13s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 28 20 3 37s425ms 12s475ms 23 3 36s358ms 12s119ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-28 20:06:54 Duration: 28s466ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-28 23:20:26 Duration: 28s443ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-28 20:10:46 Duration: 7s177ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
15 762ms 34s190ms 12s173ms 6 1m13s select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 28 00 3 38s467ms 12s822ms 06 3 34s573ms 11s524ms [ User: lenon - Total duration: 1m13s - Times executed: 6 ]
[ Application: psql - Total duration: 1m13s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-28 00:02:36 Duration: 34s190ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-28 06:02:32 Duration: 29s684ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-28 06:02:37 Duration: 4s125ms Database: contagem User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
16 3s604ms 21s324ms 11s880ms 4 47s521ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 28 20 2 24s960ms 12s480ms 23 2 22s561ms 11s280ms [ User: intelifix - Total duration: 47s521ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 47s521ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-28 20:04:47 Duration: 21s324ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-28 23:18:34 Duration: 18s957ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-28 20:10:28 Duration: 3s635ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
17 1s594ms 21s214ms 9s969ms 6 59s815ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 28 20 3 32s225ms 10s741ms 23 3 27s589ms 9s196ms [ User: intelifix - Total duration: 59s815ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s815ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 20:03:27 Duration: 21s214ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 23:17:26 Duration: 18s380ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 20:10:10 Duration: 8s554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
18 1s910ms 20s707ms 9s755ms 6 58s530ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 28 20 3 30s781ms 10s260ms 23 3 27s748ms 9s249ms [ User: intelifix - Total duration: 58s530ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s530ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 20:02:49 Duration: 20s707ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 23:16:53 Duration: 17s952ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-28 20:10:00 Duration: 8s58ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
19 1s273ms 23s743ms 9s123ms 6 54s742ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 28 20 3 29s795ms 9s931ms 23 3 24s947ms 8s315ms [ User: intelifix - Total duration: 54s742ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 54s742ms - 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-06-28 20:04:25 Duration: 23s743ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 23:18:15 Duration: 19s693ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 20:10:25 Duration: 4s364ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
20 1s390ms 16s309ms 7s756ms 6 46s538ms 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 Jun 28 20 3 24s717ms 8s239ms 23 3 21s820ms 7s273ms [ User: intelifix - Total duration: 46s538ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 46s538ms - 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-06-28 20:03:43 Duration: 16s309ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 23:17:40 Duration: 13s748ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.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-06-28 20:10:17 Duration: 6s846ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 10 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 28 10 2 0ms 0ms 12 1 0ms 0ms 13 2 0ms 0ms 15 1 0ms 0ms 18 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 6m45s - Times executed: 10 ]
[ Application: psql - Total duration: 6m45s - Times executed: 10 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 4,940 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 20 FATAL entries
- 1521 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,427 Max number of times the same event was reported
- 1,542 Total events found
Rank Times reported Error 1 1,427 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 28 00 59 01 60 02 59 03 59 04 60 05 59 06 59 07 60 08 59 09 60 10 59 11 60 12 59 13 60 14 60 15 59 16 60 17 59 18 60 19 60 20 59 21 60 22 58 23 60 - ERROR: prepared statement "_PLAN0000000029EA6650" does not exist
- ERROR: prepared statement "_PLAN0000000029C43220" does not exist
- ERROR: prepared statement "_PLAN0000000029EE34F0" does not exist
Statement: DEALLOCATE "_PLAN0000000029EA6650"
Date: 2026-06-28 00:00:39 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Statement: DEALLOCATE "_PLAN0000000029C43220"
Date: 2026-06-28 00:01:40 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Statement: DEALLOCATE "_PLAN0000000029EE34F0"
Date: 2026-06-28 00:02:40 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
2 40 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 28 00 2 01 2 02 2 03 1 04 2 05 2 06 2 07 2 08 2 09 1 11 2 12 1 13 1 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-28 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-28 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-28 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
3 38 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 28 08 3 09 1 11 3 12 2 13 2 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-28 08:00:05 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-28 08:20:04 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-28 08:40:04 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
4 10 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 28 00 2 02 1 06 2 07 1 14 1 17 1 20 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-06-28 00:02:40 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Date: 2026-06-28 00:48:55 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Date: 2026-06-28 02:32:43 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
5 7 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 28 09 2 10 3 12 1 13 1 - ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
- ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
- ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-28 09:20:04 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-28 09:40:05 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-28 10:00:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
6 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 28 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-28 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Date: 2026-06-28 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Date: 2026-06-28 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
7 5 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 28 09 1 10 2 12 1 13 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-28 09:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-28 10:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-28 10:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
8 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 28 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-06-28 05:32:10 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-28 05:32:10 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-28 05:32:10 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
9 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 28 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-06-28 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Date: 2026-06-28 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Date: 2026-06-28 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
10 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 28 03 1 - LOG: database system was shut down at 2026-06-28 03:05:01 -03
Date: 2026-06-28 03:05:03 Log file: /usr/local/pgsql/data/log/serverlog-28.log