pgBadger-
Global information
- Generated on Sat May 16 23:50:05 2026
- Log file: /usr/local/pgsql/data/log/serverlog-04.log, ..., /usr/local/pgsql/data/log/serverlog-26.log
- Parsed 2,639 log entries in 4s
- Log start from 2026-05-11 15:30:02 to 2026-05-16 20:13:27
-
Overview
Global Stats
- 89 Number of unique normalized queries
- 441 Number of queries
- 49m58s Total query duration
- 2026-05-11 15:33:04 First query
- 2026-05-16 20:13:27 Last query
- 4 queries/s at 2026-05-15 10:46:57 Query peak
- 49m58s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 49m58s Execute total duration
- 23 Number of events
- 3 Number of unique normalized events
- 18 Max number of times the same event was reported
- 0 Number of cancellation
- 47 Total number of automatic vacuums
- 63 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 113 Total number of sessions
- 11 sessions at 2026-05-15 09:34:49 Session peak
- 2d16h24m35s Total duration of sessions
- 34m11s Average duration of sessions
- 3 Average queries per session
- 26s532ms Average queries duration per session
- 33m45s Average idle time per session
- 113 Total number of connections
- 4 connections/s at 2026-05-15 10:05:06 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-05-15 10:46:57 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-05-15 09:32:05 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-05-15 10:46:57 Date
Queries duration
Key values
- 49m58s 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) May 11 15 6 0ms 745ms 388ms 2s329ms 2s329ms 2s329ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms May 12 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms May 13 10 4 0ms 40s989ms 12s849ms 42s424ms 42s424ms 42s424ms 11 6 0ms 10s275ms 8s69ms 19s746ms 19s746ms 19s746ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms May 14 14 12 0ms 9s63ms 4s518ms 9s435ms 17s265ms 17s265ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 17 2 0ms 606ms 533ms 1s66ms 1s66ms 1s66ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms May 15 09 55 0ms 12s595ms 2s279ms 23s144ms 40s908ms 40s908ms 10 101 0ms 1m46s 6s860ms 1m10s 1m18s 1m47s 11 9 0ms 895ms 563ms 1s736ms 2s891ms 2s891ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 73 0ms 9m58s 9s468ms 11s478ms 30s720ms 10m2s 16 0 0ms 0ms 0ms 0ms 0ms 0ms 20 85 0ms 1m41s 7s677ms 1m33s 2m24s 2m24s May 16 20 88 151ms 1m46s 7s654ms 1m23s 2m21s 2m21s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 11 15 2 0 619ms 1s238ms 1s238ms 1s238ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms May 12 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms May 13 10 2 0 717ms 0ms 1s435ms 1s435ms 11 1 0 1s781ms 0ms 1s781ms 1s781ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms May 14 14 6 0 326ms 195ms 556ms 1s29ms 15 0 0 0ms 0ms 0ms 0ms 17 2 0 533ms 1s66ms 1s66ms 1s66ms 18 0 0 0ms 0ms 0ms 0ms May 15 09 33 0 1s972ms 6s493ms 18s335ms 21s342ms 10 13 84 7s133ms 1m1s 1m10s 1m47s 11 8 0 584ms 444ms 1s339ms 2s891ms 12 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 47 0 13s441ms 1s989ms 2s993ms 9m58s 16 0 0 0ms 0ms 0ms 0ms 20 4 81 7s677ms 1m20s 1m33s 2m24s May 16 20 2 86 7s654ms 1m16s 1m23s 2m21s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 11 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 May 12 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms May 13 10 0 0 0 0 0ms 0ms 0ms 0ms 11 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 May 14 14 0 0 0 0 0ms 0ms 0ms 0ms 15 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 May 15 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 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 20 0 0 0 0 0ms 0ms 0ms 0ms May 16 20 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 11 15 0 1 1.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% May 12 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% May 13 10 0 1 1.00 0.00% 11 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% May 14 14 0 1 1.00 0.00% 15 0 0 0.00 0.00% 17 0 1 1.00 0.00% 18 0 0 0.00 0.00% May 15 09 0 6 6.00 0.00% 10 0 3 3.00 0.00% 11 0 2 2.00 0.00% 12 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 8 8.00 0.00% 16 0 0 0.00 0.00% 20 0 0 0.00 0.00% May 16 20 0 0 0.00 0.00% Day Hour Count Average / Second May 11 15 4 0.00/s 16 6 0.00/s 17 0 0.00/s May 12 09 2 0.00/s 10 0 0.00/s May 13 10 4 0.00/s 11 0 0.00/s 17 12 0.00/s 18 0 0.00/s May 14 14 4 0.00/s 15 0 0.00/s 17 4 0.00/s 18 0 0.00/s May 15 09 32 0.01/s 10 16 0.00/s 11 5 0.00/s 12 0 0.00/s 14 4 0.00/s 15 14 0.00/s 16 0 0.00/s 20 3 0.00/s May 16 20 3 0.00/s Day Hour Count Average Duration Average idle time May 11 15 0 0ms 0ms 16 8 30m28s 30m28s 17 2 1h7m30s 1h7m30s May 12 09 0 0ms 0ms 10 2 1h7m30s 1h7m30s May 13 10 0 0ms 0ms 11 4 1h1m27s 1h1m15s 17 10 15s292ms 15s292ms 18 2 1h1m27s 1h1m27s May 14 14 0 0ms 0ms 15 4 1h1m29s 1h1m29s 17 0 0ms 0ms 18 4 1h1m30s 1h1m30s May 15 09 32 15m57s 15m53s 10 4 2m55s 1s929ms 11 13 57m31s 57m31s 12 4 1h1m30s 1h1m30s 14 1 10m32s 10m32s 15 5 41m5s 38m47s 16 12 1h1m2s 1h1m2s 20 3 3m41s 4s75ms May 16 20 3 3m48s 4s16ms -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-05-15 10:05:06 Date
Connections per database
Key values
- rio Main Database
- 113 connections Total
Connections per user
Key values
- lenon Main User
- 113 connections Total
-
Sessions
Simultaneous sessions
Key values
- 11 sessions Session Peak
- 2026-05-15 09:34:49 Date
Histogram of session times
Key values
- 52 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 113 sessions Total
Sessions per user
Key values
- lenon Main User
- 113 sessions Total
Sessions per host
Key values
- [local] Main Host
- 113 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 113 sessions Total
Application Count Total Duration Average Duration [unknown] 76 2d12h10m51s 47m30s pgAdmin 4 - CONN:317375 1 16m52s 16m52s pgAdmin 4 - CONN:4169423 4 31s709ms 7s927ms pgAdmin 4 - CONN:4698698 1 22s84ms 22s84ms pgAdmin 4 - CONN:4928586 1 37s27ms 37s27ms pgAdmin 4 - CONN:5792648 4 5s60ms 1s265ms pgAdmin 4 - CONN:6961207 2 18m34s 9m17s pgAdmin 4 - CONN:7113132 1 12s314ms 12s314ms pgAdmin 4 - DB:brasilia 3 22m7s 7m22s pgAdmin 4 - DB:contagem 2 21m57s 10m58s pgAdmin 4 - DB:etiqueta_rio 1 1h 1h pgAdmin 4 - DB:postgres 5 39m34s 7m54s pgAdmin 4 - DB:rio 3 38m38s 12m52s pg_dump 9 34m11s 3m47s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,532 buffers Checkpoint Peak
- 2026-05-15 09:44:34 Date
- 269.994 seconds Highest write time
- 0.014 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-05-15 09:32:33 Date
Checkpoints distance
Key values
- 92.48 Mo Distance Peak
- 2026-05-13 11:04:30 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 11 15 164 16.506s 0.014s 16.531s 16 0 0s 0s 0s 17 0 0s 0s 0s May 12 09 0 0s 0s 0s 10 0 0s 0s 0s May 13 10 2,995 300.329s 0.006s 300.348s 11 1,548 154.884s 0.006s 154.917s 17 94 9.473s 0.007s 9.488s 18 0 0s 0s 0s May 14 14 1,831 301.225s 0.003s 301.253s 15 1,492 149.226s 0.002s 149.238s 17 1 0.121s 0.002s 0.127s 18 0 0s 0s 0s May 15 09 7,323 695.914s 0.04s 696.023s 10 922 92.593s 0.015s 92.64s 11 94 9.486s 0.007s 9.502s 12 0 0s 0s 0s 14 0 0s 0s 0s 15 2,717 294.145s 0.04s 294.224s 16 0 0s 0s 0s 20 322 32.406s 0.009s 32.433s May 16 20 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 11 15 0 0 0 110 0.002s 0.002s 16 0 0 0 0 0s 0s 17 0 0 0 0 0s 0s May 12 09 0 0 0 0 0s 0s 10 0 0 0 0 0s 0s May 13 10 0 1 0 75 0.002s 0.002s 11 0 4 0 70 0.002s 0.002s 17 0 0 0 37 0.002s 0.003s 18 0 0 0 0 0s 0s May 14 14 0 3 0 87 0.002s 0.002s 15 0 1 0 32 0.002s 0.001s 17 0 0 0 1 0.002s 0.002s 18 0 0 0 0 0s 0s May 15 09 0 7 0 880 0.002s 0.009s 10 0 0 0 185 0.002s 0.006s 11 0 0 0 70 0.002s 0.002s 12 0 0 0 0 0s 0s 14 0 0 0 0 0s 0s 15 0 3 0 701 0.003s 0.006s 16 0 0 0 0 0s 0s 20 0 0 0 188 0.002s 0.003s May 16 20 0 0 0 0 0s 0s Day Hour Count Avg time (sec) May 11 15 0 0s 16 0 0s 17 0 0s May 12 09 0 0s 10 0 0s May 13 10 0 0s 11 0 0s 17 0 0s 18 0 0s May 14 14 0 0s 15 0 0s 17 0 0s 18 0 0s May 15 09 0 0s 10 0 0s 11 0 0s 12 0 0s 14 0 0s 15 0 0s 16 0 0s 20 0 0s May 16 20 0 0s Day Hour Mean distance Mean estimate May 11 15 618.50 kB 952.00 kB 16 0.00 kB 0.00 kB 17 0.00 kB 0.00 kB May 12 09 0.00 kB 0.00 kB 10 0.00 kB 0.00 kB May 13 10 11,908.50 kB 11,908.50 kB 11 29,576.00 kB 45,572.50 kB 17 155.00 kB 37,460.50 kB 18 0.00 kB 0.00 kB May 14 14 29,517.00 kB 40,143.00 kB 15 11,904.00 kB 43,618.00 kB 17 5.00 kB 39,257.00 kB 18 0.00 kB 0.00 kB May 15 09 13,341.00 kB 22,983.12 kB 10 518.17 kB 697.50 kB 11 150.00 kB 1,444.00 kB 12 0.00 kB 0.00 kB 14 0.00 kB 0.00 kB 15 8,750.17 kB 14,362.33 kB 16 0.00 kB 0.00 kB 20 494.00 kB 17,336.33 kB May 16 20 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 11 15 0 0 0 16 0 0 0 17 0 0 0 May 12 09 0 0 0 10 0 0 0 May 13 10 0 0 0 11 0 0 0 17 0 0 0 18 0 0 0 May 14 14 0 0 0 15 0 0 0 17 0 0 0 18 0 0 0 May 15 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 20 0 0 0 May 16 20 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.08 sec Highest CPU-cost vacuum
Table pg_catalog.pg_shdepend
Database template1 - 2026-05-15 09:39:20 Date
- 0 sec Highest CPU-cost analyze
Table
Database template1 - Date
Average Autovacuum Duration
Key values
- 0.08 sec Highest CPU-cost vacuum
Table pg_catalog.pg_shdepend
Database template1 - 2026-05-15 09:39:20 Date
Analyzes per table
Key values
- public.temp0000232294 (10) Main table analyzed (database brasilia)
- 63 analyzes Total
Table Number of analyzes brasilia.public.temp0000232294 10 rio.public.temp0000277702 6 contagem.public.temp0000226040 6 brasilia.auditor.auditor_2026_05 4 rio.public.temp0000277704 4 contagem.auditor.auditor_2026_05 3 rio.pg_catalog.pg_attribute 3 rio.public.temp0000277706 3 brasilia.public.temp0000232296 2 rio.auditor.auditor_2026_05 2 brasilia.pg_catalog.pg_shdepend 2 brasilia.pg_catalog.pg_attribute 2 contagem.pg_catalog.pg_index 1 brasilia.pg_catalog.pg_index 1 rio.pg_catalog.pg_depend 1 brasilia.pg_catalog.pg_class 1 contagem.pg_catalog.pg_attribute 1 brasilia.public.nf_entrada 1 brasilia.pg_catalog.pg_depend 1 rio.pg_catalog.pg_index 1 rio.pg_catalog.pg_type 1 contagem.public.nf_entrada 1 rio.pg_catalog.pg_class 1 contagem.pg_catalog.pg_type 1 rio.public.temp0000277700 1 contagem.pg_catalog.pg_class 1 brasilia.pg_catalog.pg_type 1 contagem.pg_catalog.pg_depend 1 Total 63 Vacuums per table
Key values
- public.temp0000232294 (10) Main table vacuumed on database brasilia
- 47 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples brasilia.public.temp0000232294 10 0 0 0 0 0 0 2,182 60 139,648 0 0 rio.public.temp0000277702 6 0 0 0 0 0 0 8,712 24 517,626 0 0 rio.public.temp0000277704 4 0 0 0 0 0 0 5,808 16 345,084 0 0 rio.public.temp0000277706 3 0 0 0 0 0 0 4,356 12 258,813 0 0 brasilia.auditor.auditor_2026_05 3 0 0 0 0 0 0 301 34 63,112 2 96 contagem.auditor.auditor_2026_05 3 0 0 0 0 0 0 229 9 16,527 0 0 brasilia.public.temp0000232296 2 0 0 0 0 0 0 436 12 27,900 0 0 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 302 105 399,212 76 647 rio.auditor.auditor_2026_05 1 0 0 0 0 0 0 123 5 10,506 1 33 contagem.pg_catalog.pg_type 1 1 0 0 0 0 0 75 6 15,800 1 35 rio.pg_catalog.pg_class 1 1 0 0 0 0 0 243 63 161,571 0 0 brasilia.pg_catalog.pg_type 1 1 0 0 0 0 0 70 3 13,714 0 0 contagem.pg_catalog.pg_class 1 1 0 0 0 0 0 240 62 160,445 0 0 brasilia.pg_catalog.pg_attribute 1 1 0 0 0 0 0 682 103 276,176 4 168 contagem.pg_catalog.pg_index 1 1 0 0 0 0 0 69 31 55,848 0 0 template1.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 96 38 89,476 34 4,176 brasilia.pg_catalog.pg_index 1 1 0 0 0 0 0 70 32 56,061 1 44 brasilia.pg_catalog.pg_class 1 1 0 0 0 0 0 238 57 153,062 0 0 rio.pg_catalog.pg_depend 1 1 0 0 0 0 0 188 35 113,272 9 1,147 rio.pg_catalog.pg_type 1 1 0 0 0 0 0 79 7 17,590 2 56 rio.pg_catalog.pg_index 1 1 0 0 0 0 0 69 32 56,548 1 40 rio.pg_catalog.pg_attribute 1 1 0 0 0 0 0 782 143 323,837 10 278 contagem.pg_catalog.pg_attribute 1 1 0 0 0 0 0 694 109 286,532 2 66 Total 47 15 0 0 0 0 0 26,044 998 3,558,360 143 6,786 Vacuum throughput per table
Key values
- public.temp0000277702 (0.24) 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 brasilia.public.temp0000232294 0 0 0.2 rio.public.temp0000277702 0 0 0.24 rio.public.temp0000277704 0 0 0.16 rio.public.temp0000277706 0 0 0.12 brasilia.auditor.auditor_2026_05 0 0 0.02 contagem.auditor.auditor_2026_05 0 0 0 brasilia.public.temp0000232296 0 0 0.04 rio.pg_catalog.pg_statistic 0 0 0.02 rio.auditor.auditor_2026_05 0 0 0 contagem.pg_catalog.pg_type 0 0 0 rio.pg_catalog.pg_class 0 0 0.03 brasilia.pg_catalog.pg_type 0 0 0.01 contagem.pg_catalog.pg_class 0 0 0.02 brasilia.pg_catalog.pg_attribute 0 0 0.08 contagem.pg_catalog.pg_index 0 0 0 template1.pg_catalog.pg_shdepend 0 0 0.08 brasilia.pg_catalog.pg_index 0 0 0 brasilia.pg_catalog.pg_class 0 0 0.03 rio.pg_catalog.pg_depend 0 0 0.07 rio.pg_catalog.pg_type 0 0 0.04 rio.pg_catalog.pg_index 0 0 0.01 rio.pg_catalog.pg_attribute 0 0 0.07 contagem.pg_catalog.pg_attribute 0 0 0.05 Total 0 0 1.29 Tuples removed per table
Key values
- pg_catalog.pg_attribute (8331) Main table with removed tuples on database rio
- 28215 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 1 1 8,331 16,938 0 0 459 brasilia.pg_catalog.pg_attribute 1 1 7,866 16,905 0 0 430 contagem.pg_catalog.pg_attribute 1 1 7,840 17,355 0 0 441 brasilia.pg_catalog.pg_type 1 1 772 1,988 0 0 65 contagem.pg_catalog.pg_type 1 1 762 2,024 0 0 67 rio.pg_catalog.pg_type 1 1 756 1,997 0 0 67 contagem.pg_catalog.pg_index 1 1 391 1,211 0 0 37 rio.pg_catalog.pg_index 1 1 387 1,201 0 0 37 brasilia.pg_catalog.pg_index 1 1 366 1,186 0 0 37 template1.pg_catalog.pg_shdepend 1 1 313 13,058 0 0 100 rio.pg_catalog.pg_statistic 1 1 305 1,537 0 0 156 rio.pg_catalog.pg_depend 1 1 67 18,264 0 0 154 rio.pg_catalog.pg_class 1 1 26 2,521 0 0 109 contagem.pg_catalog.pg_class 1 1 21 2,541 0 0 109 brasilia.pg_catalog.pg_class 1 1 12 2,481 0 0 108 rio.public.temp0000277706 3 0 0 61,253 0 0 4,416 rio.auditor.auditor_2026_05 1 0 0 4,467 0 0 118 brasilia.auditor.auditor_2026_05 3 0 0 22,812 0 0 559 rio.public.temp0000277704 4 0 0 81,668 0 0 5,888 brasilia.public.temp0000232296 2 0 0 5,601 0 92 420 rio.public.temp0000277702 6 0 0 122,502 0 0 8,832 contagem.auditor.auditor_2026_05 3 0 0 20,314 0 0 498 brasilia.public.temp0000232294 10 0 0 27,999 0 458 2,102 Total 47 15 28,215 447,823 0 550 25,209 Pages removed per table
Key values
- public.temp0000232294 (458) Main table with removed pages on database brasilia
- 550 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed brasilia.public.temp0000232294 10 0 0 458 brasilia.public.temp0000232296 2 0 0 92 rio.public.temp0000277706 3 0 0 0 rio.pg_catalog.pg_statistic 1 1 305 0 rio.auditor.auditor_2026_05 1 0 0 0 brasilia.auditor.auditor_2026_05 3 0 0 0 contagem.pg_catalog.pg_type 1 1 762 0 rio.pg_catalog.pg_class 1 1 26 0 brasilia.pg_catalog.pg_type 1 1 772 0 contagem.pg_catalog.pg_class 1 1 21 0 rio.public.temp0000277704 4 0 0 0 brasilia.pg_catalog.pg_attribute 1 1 7866 0 rio.public.temp0000277702 6 0 0 0 contagem.pg_catalog.pg_index 1 1 391 0 template1.pg_catalog.pg_shdepend 1 1 313 0 brasilia.pg_catalog.pg_index 1 1 366 0 contagem.auditor.auditor_2026_05 3 0 0 0 brasilia.pg_catalog.pg_class 1 1 12 0 rio.pg_catalog.pg_depend 1 1 67 0 rio.pg_catalog.pg_type 1 1 756 0 rio.pg_catalog.pg_index 1 1 387 0 rio.pg_catalog.pg_attribute 1 1 8331 0 contagem.pg_catalog.pg_attribute 1 1 7840 0 Total 47 15 28,215 550 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 11 15 0 2 16 0 0 17 0 0 May 12 09 0 0 10 0 0 May 13 10 2 2 11 4 4 17 0 0 18 0 0 May 14 14 4 4 15 0 0 17 0 0 18 0 0 May 15 09 26 35 10 0 0 11 0 0 12 0 0 14 0 0 15 11 16 16 0 0 20 0 0 May 16 20 0 0 - 0.08 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
- 120 Total read queries
- 321 Total write queries
Queries by database
Key values
- rio Main database
- 191 Requests
- 40m57s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 506 Requests
User Request type Count Duration intelifix Total 506 1h58s copy to 337 44m45s ddl 70 4m30s select 99 11m42s lenon Total 23 12s968ms select 23 12s968ms Duration by user
Key values
- 1h58s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 506 1h58s copy to 337 44m45s ddl 70 4m30s select 99 11m42s lenon Total 23 12s968ms select 23 12s968ms Queries by host
Key values
- [local] Main host
- 529 Requests
- 1h1m11s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 264 Requests
- 33m34s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-13 11:04:32 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 162 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 9m58s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2025-12-01''),DATE(''2026-01-06'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-05-15 15:36:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1m46s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-05-16 20:10:20 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
3 1m46s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-05-15 10:46:57 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
4 1m41s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-05-15 20:10:09 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
5 1m18s COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-15 20:06:23 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
6 1m16s COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-15 10:42:53 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
7 1m14s COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-16 20:06:23 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
8 43s201ms 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-05-15 10:43:38 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
9 41s172ms 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-05-15 10:47:39 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
10 40s989ms CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);[ Date: 2026-05-13 10:48:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 39s911ms COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;[ Date: 2026-05-16 20:07:48 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
12 39s293ms 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-05-15 20:07:04 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
13 38s640ms 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-05-16 20:07:03 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
14 38s66ms COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;[ Date: 2026-05-15 10:44:21 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
15 34s259ms 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-05-16 20:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
16 34s254ms COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;[ Date: 2026-05-15 20:07:43 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
17 33s798ms 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-05-15 20:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
18 29s388ms CREATE TABLE temp0000277706 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);[ Date: 2026-05-15 15:09:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 28s409ms COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;[ Date: 2026-05-16 20:05:08 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
20 28s141ms COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-15 10:39:22 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 10m14s 6 229ms 9m58s 1m42s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 15 09 3 15s421ms 5s140ms 15 3 9m58s 3m19s [ User: intelifix - Total duration: 10m14s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 10m14s - Times executed: 6 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2025-12-01''),DATE(''2026-01-06'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-05-15 15:36:21 Duration: 9m58s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(7,80,''/var/www/html/uploads/LOTE AUTOMATICO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');
Date: 2026-05-15 09:40:27 Duration: 6s155ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,80,''/var/www/html/uploads/LOTE AUTOMATICO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');
Date: 2026-05-15 09:39:12 Duration: 5s790ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
2 5m30s 6 4s944ms 1m46s 55s87ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 15 10 2 1m51s 55s850ms 20 2 1m46s 53s122ms May 16 20 2 1m52s 56s291ms [ User: intelifix - Total duration: 5m30s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 5m30s - Times executed: 6 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-16 20:10:20 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-15 10:46:57 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-15 20:10:09 Duration: 1m41s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
3 3m51s 6 485ms 1m18s 38s564ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 15 10 2 1m16s 38s454ms 20 2 1m19s 39s610ms May 16 20 2 1m15s 37s628ms [ User: intelifix - Total duration: 3m51s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 3m51s - Times executed: 6 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-15 20:06:23 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-15 10:42:53 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-16 20:06:23 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 2m42s 9 2s418ms 43s201ms 18s71ms 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 #4
Day Hour Count Duration Avg duration May 15 10 3 56s252ms 18s750ms 20 3 53s50ms 17s683ms May 16 20 3 53s337ms 17s779ms [ User: intelifix - Total duration: 2m42s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 2m42s - Times executed: 9 ]
-
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-05-15 10:43:38 Duration: 43s201ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-15 20:07:04 Duration: 39s293ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-16 20:07:03 Duration: 38s640ms Database: rio User: intelifix Remote: [local] Application: pg_dump
5 2m25s 9 1s877ms 39s911ms 16s170ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 15 10 3 48s545ms 16s181ms 20 3 46s208ms 15s402ms May 16 20 3 50s784ms 16s928ms [ User: intelifix - Total duration: 2m25s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 2m25s - Times executed: 9 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-16 20:07:48 Duration: 39s911ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-15 10:44:21 Duration: 38s66ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-15 20:07:43 Duration: 34s254ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
6 2m24s 9 3s928ms 41s172ms 16s33ms 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 #6
Day Hour Count Duration Avg duration May 15 10 3 52s914ms 17s638ms 20 3 46s221ms 15s407ms May 16 20 3 45s163ms 15s54ms [ User: intelifix - Total duration: 2m24s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 2m24s - Times executed: 9 ]
-
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-05-15 10:47:39 Duration: 41s172ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-16 20:10:55 Duration: 34s259ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-15 20:10:43 Duration: 33s798ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
7 1m56s 9 2s81ms 28s141ms 12s976ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 15 10 3 40s683ms 13s561ms 20 3 37s914ms 12s638ms May 16 20 3 38s193ms 12s731ms [ User: intelifix - Total duration: 1m56s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m56s - Times executed: 9 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 10:39:22 Duration: 28s141ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 20:02:53 Duration: 23s849ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-16 20:02:52 Duration: 22s993ms Database: rio User: intelifix Remote: [local] Application: pg_dump
8 1m48s 9 1s752ms 25s355ms 12s70ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 15 10 3 38s468ms 12s822ms 20 3 32s987ms 10s995ms May 16 20 3 37s179ms 12s393ms [ User: intelifix - Total duration: 1m48s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 9 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 10:40:05 Duration: 25s355ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-16 20:03:34 Duration: 23s607ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 20:03:31 Duration: 22s52ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
9 1m36s 9 1s638ms 27s142ms 10s769ms 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 #9
Day Hour Count Duration Avg duration May 15 10 3 31s599ms 10s533ms 20 3 31s428ms 10s476ms May 16 20 3 33s898ms 11s299ms [ User: intelifix - Total duration: 1m36s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m36s - Times executed: 9 ]
-
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-05-16 20:04:40 Duration: 27s142ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-15 20:04:37 Duration: 25s66ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-15 10:41:11 Duration: 24s917ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
10 1m36s 7 8s390ms 40s989ms 13s800ms create table temp0000277702 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 13 10 2 49s963ms 24s981ms 11 5 46s636ms 9s327ms [ User: intelifix - Total duration: 1m36s - Times executed: 7 ]
[ Application: [unknown] - Total duration: 1m36s - Times executed: 7 ]
-
CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-13 10:48:58 Duration: 40s989ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-13 11:01:41 Duration: 10s275ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-13 11:04:32 Duration: 9s806ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
11 1m34s 6 4s243ms 28s409ms 15s786ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 15 10 2 29s85ms 14s542ms 20 2 31s888ms 15s944ms May 16 20 2 33s743ms 16s871ms [ User: intelifix - Total duration: 1m34s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m34s - Times executed: 6 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-16 20:05:08 Duration: 28s409ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-15 20:05:05 Duration: 27s33ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-15 10:41:36 Duration: 24s841ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
12 1m27s 9 1s147ms 19s253ms 9s776ms 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 #12
Day Hour Count Duration Avg duration May 15 10 3 29s447ms 9s815ms 20 3 27s949ms 9s316ms May 16 20 3 30s589ms 10s196ms [ User: intelifix - Total duration: 1m27s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m27s - Times executed: 9 ]
-
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-05-15 10:40:25 Duration: 19s253ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-16 20:03:53 Duration: 19s229ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-15 20:03:50 Duration: 18s722ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
13 1m3s 9 908ms 17s890ms 7s98ms 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 #13
Day Hour Count Duration Avg duration May 15 10 3 22s242ms 7s414ms 20 3 19s768ms 6s589ms May 16 20 3 21s871ms 7s290ms [ User: intelifix - Total duration: 1m3s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 9 ]
-
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-05-16 20:03:10 Duration: 17s890ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-15 10:39:40 Duration: 17s842ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-15 20:03:09 Duration: 16s64ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
14 1m2s 4 9s855ms 29s388ms 15s739ms create table temp0000277706 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 15 09 3 33s569ms 11s189ms 15 1 29s388ms 29s388ms [ User: intelifix - Total duration: 1m2s - Times executed: 4 ]
[ Application: [unknown] - Total duration: 1m2s - Times executed: 4 ]
-
CREATE TABLE temp0000277706 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-15 15:09:57 Duration: 29s388ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000277706 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-15 09:29:22 Duration: 12s194ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000277706 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-15 09:35:30 Duration: 11s519ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
15 55s821ms 9 2s931ms 8s806ms 6s202ms 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 May 15 10 3 18s502ms 6s167ms 20 3 19s109ms 6s369ms May 16 20 3 18s209ms 6s69ms [ User: intelifix - Total duration: 55s821ms - Times executed: 9 ]
[ Application: pg_dump - Total duration: 55s821ms - Times executed: 9 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-15 20:08:13 Duration: 8s806ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-15 10:44:51 Duration: 8s600ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-16 20:12:34 Duration: 7s825ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 52s567ms 9 877ms 14s863ms 5s840ms 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 #16
Day Hour Count Duration Avg duration May 15 10 3 18s793ms 6s264ms 20 3 16s470ms 5s490ms May 16 20 3 17s303ms 5s767ms [ User: intelifix - Total duration: 52s567ms - Times executed: 9 ]
[ Application: pg_dump - Total duration: 52s567ms - Times executed: 9 ]
-
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-05-15 10:38:50 Duration: 14s863ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-16 20:02:26 Duration: 13s962ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-05-15 20:02:26 Duration: 12s889ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
17 50s441ms 9 734ms 16s323ms 5s604ms 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 #17
Day Hour Count Duration Avg duration May 15 10 3 16s490ms 5s496ms 20 3 18s236ms 6s78ms May 16 20 3 15s714ms 5s238ms [ User: intelifix - Total duration: 50s441ms - Times executed: 9 ]
[ Application: pg_dump - Total duration: 50s441ms - Times executed: 9 ]
-
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-05-15 20:04:12 Duration: 16s323ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-15 10:40:46 Duration: 14s750ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-16 20:04:13 Duration: 14s68ms Database: rio User: intelifix Remote: [local] Application: pg_dump
18 47s774ms 3 15s335ms 16s701ms 15s924ms copy public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 15 10 1 16s701ms 16s701ms 20 1 15s738ms 15s738ms May 16 20 1 15s335ms 15s335ms [ User: intelifix - Total duration: 47s774ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 47s774ms - Times executed: 3 ]
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-15 10:44:38 Duration: 16s701ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-15 20:07:59 Duration: 15s738ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-16 20:08:04 Duration: 15s335ms Database: rio User: intelifix Remote: [local] Application: pg_dump
19 44s66ms 6 416ms 16s244ms 7s344ms copy public.tcia_lote_fluxos (tl_id, flu_id, criacao) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 15 10 2 16s701ms 8s350ms 20 2 12s348ms 6s174ms May 16 20 2 15s17ms 7s508ms [ User: intelifix - Total duration: 44s66ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 44s66ms - Times executed: 6 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-15 10:45:10 Duration: 16s244ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-16 20:08:33 Duration: 14s552ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-15 20:08:27 Duration: 11s931ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
20 43s624ms 5 8s202ms 9s63ms 8s724ms create table temp0000277704 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 14 14 5 43s624ms 8s724ms [ User: intelifix - Total duration: 43s624ms - Times executed: 5 ]
[ Application: [unknown] - Total duration: 43s624ms - Times executed: 5 ]
-
CREATE TABLE temp0000277704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-14 14:40:44 Duration: 9s63ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000277704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-14 14:35:27 Duration: 8s879ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000277704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-14 14:31:01 Duration: 8s756ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 23 12s968ms 440ms 812ms 563ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 11 15 1 493ms 493ms May 13 10 1 624ms 624ms May 14 14 1 440ms 440ms 17 1 460ms 460ms May 15 09 6 3s499ms 583ms 10 3 1s613ms 537ms 11 2 1s343ms 671ms 15 8 4s492ms 561ms [ User: lenon - Total duration: 12s968ms - Times executed: 23 ]
[ Application: [unknown] - Total duration: 12s968ms - Times executed: 23 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-05-15 11:16:10 Duration: 812ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-05-15 09:39:14 Duration: 684ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-05-15 15:42:29 Duration: 649ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-15.log
2 17 37s290ms 1s225ms 9s710ms 2s193ms create table temp0000232294 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 15 09 7 19s66ms 2s723ms 15 10 18s223ms 1s822ms [ User: intelifix - Total duration: 37s290ms - Times executed: 17 ]
[ Application: [unknown] - Total duration: 37s290ms - Times executed: 17 ]
-
CREATE TABLE temp0000232294 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 07);
Date: 2026-05-15 09:32:54 Duration: 9s710ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000232294 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 07);
Date: 2026-05-15 15:27:07 Duration: 4s686ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000232294 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 07);
Date: 2026-05-15 09:39:16 Duration: 1s868ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
3 16 11s619ms 606ms 895ms 726ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 14 17 1 606ms 606ms May 15 09 3 2s67ms 689ms 10 2 1s535ms 767ms 11 2 1s705ms 852ms 15 8 5s705ms 713ms [ User: intelifix - Total duration: 11s619ms - Times executed: 16 ]
[ Application: [unknown] - Total duration: 11s619ms - Times executed: 16 ]
-
select * from rs_menu_grants (80, 18, 1);
Date: 2026-05-15 11:16:10 Duration: 895ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
select * from rs_menu_grants (80, 18, 1);
Date: 2026-05-15 15:26:58 Duration: 873ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
select * from rs_menu_grants (80, 72, 1);
Date: 2026-05-15 15:09:28 Duration: 810ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
4 11 7s902ms 399ms 2s117ms 718ms create table temp0000226040 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 15 09 8 5s517ms 689ms 15 3 2s384ms 794ms [ User: intelifix - Total duration: 7s902ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 7s902ms - Times executed: 11 ]
-
CREATE TABLE temp0000226040 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-05-15 09:33:16 Duration: 2s117ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000226040 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-05-15 15:08:16 Duration: 1s518ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000226040 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-05-15 09:43:14 Duration: 566ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
5 9 2m42s 2s418ms 43s201ms 18s71ms 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 #5
Day Hour Count Duration Avg duration May 15 10 3 56s252ms 18s750ms 20 3 53s50ms 17s683ms May 16 20 3 53s337ms 17s779ms [ User: intelifix - Total duration: 2m42s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 2m42s - Times executed: 9 ]
-
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-05-15 10:43:38 Duration: 43s201ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-15 20:07:04 Duration: 39s293ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-16 20:07:03 Duration: 38s640ms Database: rio User: intelifix Remote: [local] Application: pg_dump
6 9 2m25s 1s877ms 39s911ms 16s170ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 15 10 3 48s545ms 16s181ms 20 3 46s208ms 15s402ms May 16 20 3 50s784ms 16s928ms [ User: intelifix - Total duration: 2m25s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 2m25s - Times executed: 9 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-16 20:07:48 Duration: 39s911ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-15 10:44:21 Duration: 38s66ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-15 20:07:43 Duration: 34s254ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
7 9 2m24s 3s928ms 41s172ms 16s33ms 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 #7
Day Hour Count Duration Avg duration May 15 10 3 52s914ms 17s638ms 20 3 46s221ms 15s407ms May 16 20 3 45s163ms 15s54ms [ User: intelifix - Total duration: 2m24s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 2m24s - Times executed: 9 ]
-
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-05-15 10:47:39 Duration: 41s172ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-16 20:10:55 Duration: 34s259ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-15 20:10:43 Duration: 33s798ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
8 9 1m56s 2s81ms 28s141ms 12s976ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 15 10 3 40s683ms 13s561ms 20 3 37s914ms 12s638ms May 16 20 3 38s193ms 12s731ms [ User: intelifix - Total duration: 1m56s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m56s - Times executed: 9 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 10:39:22 Duration: 28s141ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 20:02:53 Duration: 23s849ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-16 20:02:52 Duration: 22s993ms Database: rio User: intelifix Remote: [local] Application: pg_dump
9 9 1m48s 1s752ms 25s355ms 12s70ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 15 10 3 38s468ms 12s822ms 20 3 32s987ms 10s995ms May 16 20 3 37s179ms 12s393ms [ User: intelifix - Total duration: 1m48s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 9 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 10:40:05 Duration: 25s355ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-16 20:03:34 Duration: 23s607ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 20:03:31 Duration: 22s52ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
10 9 1m36s 1s638ms 27s142ms 10s769ms 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 #10
Day Hour Count Duration Avg duration May 15 10 3 31s599ms 10s533ms 20 3 31s428ms 10s476ms May 16 20 3 33s898ms 11s299ms [ User: intelifix - Total duration: 1m36s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m36s - Times executed: 9 ]
-
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-05-16 20:04:40 Duration: 27s142ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-15 20:04:37 Duration: 25s66ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-15 10:41:11 Duration: 24s917ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
11 9 1m27s 1s147ms 19s253ms 9s776ms 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 #11
Day Hour Count Duration Avg duration May 15 10 3 29s447ms 9s815ms 20 3 27s949ms 9s316ms May 16 20 3 30s589ms 10s196ms [ User: intelifix - Total duration: 1m27s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m27s - Times executed: 9 ]
-
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-05-15 10:40:25 Duration: 19s253ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-16 20:03:53 Duration: 19s229ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-15 20:03:50 Duration: 18s722ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
12 9 1m3s 908ms 17s890ms 7s98ms 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 #12
Day Hour Count Duration Avg duration May 15 10 3 22s242ms 7s414ms 20 3 19s768ms 6s589ms May 16 20 3 21s871ms 7s290ms [ User: intelifix - Total duration: 1m3s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 9 ]
-
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-05-16 20:03:10 Duration: 17s890ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-15 10:39:40 Duration: 17s842ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-15 20:03:09 Duration: 16s64ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
13 9 55s821ms 2s931ms 8s806ms 6s202ms 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 #13
Day Hour Count Duration Avg duration May 15 10 3 18s502ms 6s167ms 20 3 19s109ms 6s369ms May 16 20 3 18s209ms 6s69ms [ User: intelifix - Total duration: 55s821ms - Times executed: 9 ]
[ Application: pg_dump - Total duration: 55s821ms - Times executed: 9 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-15 20:08:13 Duration: 8s806ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-15 10:44:51 Duration: 8s600ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-16 20:12:34 Duration: 7s825ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 9 52s567ms 877ms 14s863ms 5s840ms 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 #14
Day Hour Count Duration Avg duration May 15 10 3 18s793ms 6s264ms 20 3 16s470ms 5s490ms May 16 20 3 17s303ms 5s767ms [ User: intelifix - Total duration: 52s567ms - Times executed: 9 ]
[ Application: pg_dump - Total duration: 52s567ms - Times executed: 9 ]
-
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-05-15 10:38:50 Duration: 14s863ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-16 20:02:26 Duration: 13s962ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-05-15 20:02:26 Duration: 12s889ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
15 9 50s441ms 734ms 16s323ms 5s604ms 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 #15
Day Hour Count Duration Avg duration May 15 10 3 16s490ms 5s496ms 20 3 18s236ms 6s78ms May 16 20 3 15s714ms 5s238ms [ User: intelifix - Total duration: 50s441ms - Times executed: 9 ]
[ Application: pg_dump - Total duration: 50s441ms - Times executed: 9 ]
-
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-05-15 20:04:12 Duration: 16s323ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-15 10:40:46 Duration: 14s750ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-16 20:04:13 Duration: 14s68ms Database: rio User: intelifix Remote: [local] Application: pg_dump
16 9 31s422ms 3s15ms 4s505ms 3s491ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 15 10 3 11s674ms 3s891ms 20 3 9s514ms 3s171ms May 16 20 3 10s234ms 3s411ms [ User: intelifix - Total duration: 31s422ms - Times executed: 9 ]
[ Application: pg_dump - Total duration: 31s422ms - Times executed: 9 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-15 10:47:49 Duration: 4s505ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-15 10:49:37 Duration: 3s648ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-15 10:38:33 Duration: 3s520ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
17 9 27s460ms 472ms 6s835ms 3s51ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 15 10 3 9s599ms 3s199ms 20 3 8s741ms 2s913ms May 16 20 3 9s120ms 3s40ms [ User: intelifix - Total duration: 27s460ms - Times executed: 9 ]
[ Application: pg_dump - Total duration: 27s460ms - Times executed: 9 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-15 10:40:32 Duration: 6s835ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-15 20:03:56 Duration: 6s226ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-16 20:03:59 Duration: 5s693ms Database: rio User: intelifix Remote: [local] Application: pg_dump
18 9 14s906ms 1s528ms 1s881ms 1s656ms copy ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 15 10 3 4s879ms 1s626ms 20 3 4s913ms 1s637ms May 16 20 3 5s113ms 1s704ms [ User: intelifix - Total duration: 14s906ms - Times executed: 9 ]
[ Application: pg_dump - Total duration: 14s906ms - Times executed: 9 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-16 20:11:00 Duration: 1s881ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-15 10:47:44 Duration: 1s820ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-15 20:02:07 Duration: 1s781ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
19 9 3s816ms 163ms 756ms 424ms copy public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 15 10 3 1s161ms 387ms 20 3 1s263ms 421ms May 16 20 3 1s390ms 463ms [ User: intelifix - Total duration: 3s816ms - Times executed: 9 ]
[ Application: pg_dump - Total duration: 3s816ms - Times executed: 9 ]
-
COPY public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) TO stdout;
Date: 2026-05-16 20:07:04 Duration: 756ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) TO stdout;
Date: 2026-05-15 10:43:39 Duration: 752ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) TO stdout;
Date: 2026-05-15 20:07:05 Duration: 703ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
20 8 7s654ms 212ms 2s144ms 956ms copy public.lote_caixas (cai_id, lot_id, cai_criacao, usu_id, mod_id, is_id, novo, qtd, cai_obs, cai_check, cai_check_data, cai_check_user, cai_check_mens) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 15 10 3 2s902ms 967ms 20 2 2s180ms 1s90ms May 16 20 3 2s571ms 857ms [ User: intelifix - Total duration: 7s654ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 7s654ms - Times executed: 8 ]
-
COPY public.lote_caixas (cai_id, lot_id, cai_criacao, usu_id, mod_id, is_id, novo, qtd, cai_obs, cai_check, cai_check_data, cai_check_user, cai_check_mens) TO stdout;
Date: 2026-05-15 10:42:55 Duration: 2s144ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.lote_caixas (cai_id, lot_id, cai_criacao, usu_id, mod_id, is_id, novo, qtd, cai_obs, cai_check, cai_check_data, cai_check_user, cai_check_mens) TO stdout;
Date: 2026-05-15 20:06:25 Duration: 1s834ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.lote_caixas (cai_id, lot_id, cai_criacao, usu_id, mod_id, is_id, novo, qtd, cai_obs, cai_check, cai_check_data, cai_check_user, cai_check_mens) TO stdout;
Date: 2026-05-16 20:06:25 Duration: 1s799ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 229ms 9m58s 1m42s 6 10m14s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 15 09 3 15s421ms 5s140ms 15 3 9m58s 3m19s [ User: intelifix - Total duration: 10m14s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 10m14s - Times executed: 6 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2025-12-01''),DATE(''2026-01-06'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-05-15 15:36:21 Duration: 9m58s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(7,80,''/var/www/html/uploads/LOTE AUTOMATICO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');
Date: 2026-05-15 09:40:27 Duration: 6s155ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,80,''/var/www/html/uploads/LOTE AUTOMATICO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');
Date: 2026-05-15 09:39:12 Duration: 5s790ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
2 4s944ms 1m46s 55s87ms 6 5m30s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 15 10 2 1m51s 55s850ms 20 2 1m46s 53s122ms May 16 20 2 1m52s 56s291ms [ User: intelifix - Total duration: 5m30s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 5m30s - Times executed: 6 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-16 20:10:20 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-15 10:46:57 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-15 20:10:09 Duration: 1m41s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
3 485ms 1m18s 38s564ms 6 3m51s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 15 10 2 1m16s 38s454ms 20 2 1m19s 39s610ms May 16 20 2 1m15s 37s628ms [ User: intelifix - Total duration: 3m51s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 3m51s - Times executed: 6 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-15 20:06:23 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-15 10:42:53 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-16 20:06:23 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 2s418ms 43s201ms 18s71ms 9 2m42s 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 #4
Day Hour Count Duration Avg duration May 15 10 3 56s252ms 18s750ms 20 3 53s50ms 17s683ms May 16 20 3 53s337ms 17s779ms [ User: intelifix - Total duration: 2m42s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 2m42s - Times executed: 9 ]
-
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-05-15 10:43:38 Duration: 43s201ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-15 20:07:04 Duration: 39s293ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-16 20:07:03 Duration: 38s640ms Database: rio User: intelifix Remote: [local] Application: pg_dump
5 1s877ms 39s911ms 16s170ms 9 2m25s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 15 10 3 48s545ms 16s181ms 20 3 46s208ms 15s402ms May 16 20 3 50s784ms 16s928ms [ User: intelifix - Total duration: 2m25s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 2m25s - Times executed: 9 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-16 20:07:48 Duration: 39s911ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-15 10:44:21 Duration: 38s66ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-15 20:07:43 Duration: 34s254ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
6 3s928ms 41s172ms 16s33ms 9 2m24s 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 #6
Day Hour Count Duration Avg duration May 15 10 3 52s914ms 17s638ms 20 3 46s221ms 15s407ms May 16 20 3 45s163ms 15s54ms [ User: intelifix - Total duration: 2m24s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 2m24s - Times executed: 9 ]
-
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-05-15 10:47:39 Duration: 41s172ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-16 20:10:55 Duration: 34s259ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-15 20:10:43 Duration: 33s798ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
7 15s335ms 16s701ms 15s924ms 3 47s774ms copy public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 15 10 1 16s701ms 16s701ms 20 1 15s738ms 15s738ms May 16 20 1 15s335ms 15s335ms [ User: intelifix - Total duration: 47s774ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 47s774ms - Times executed: 3 ]
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-15 10:44:38 Duration: 16s701ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-15 20:07:59 Duration: 15s738ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-16 20:08:04 Duration: 15s335ms Database: rio User: intelifix Remote: [local] Application: pg_dump
8 4s243ms 28s409ms 15s786ms 6 1m34s copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 15 10 2 29s85ms 14s542ms 20 2 31s888ms 15s944ms May 16 20 2 33s743ms 16s871ms [ User: intelifix - Total duration: 1m34s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m34s - Times executed: 6 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-16 20:05:08 Duration: 28s409ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-15 20:05:05 Duration: 27s33ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-15 10:41:36 Duration: 24s841ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
9 9s855ms 29s388ms 15s739ms 4 1m2s create table temp0000277706 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 15 09 3 33s569ms 11s189ms 15 1 29s388ms 29s388ms [ User: intelifix - Total duration: 1m2s - Times executed: 4 ]
[ Application: [unknown] - Total duration: 1m2s - Times executed: 4 ]
-
CREATE TABLE temp0000277706 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-15 15:09:57 Duration: 29s388ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000277706 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-15 09:29:22 Duration: 12s194ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000277706 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-15 09:35:30 Duration: 11s519ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
10 8s390ms 40s989ms 13s800ms 7 1m36s create table temp0000277702 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 13 10 2 49s963ms 24s981ms 11 5 46s636ms 9s327ms [ User: intelifix - Total duration: 1m36s - Times executed: 7 ]
[ Application: [unknown] - Total duration: 1m36s - Times executed: 7 ]
-
CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-13 10:48:58 Duration: 40s989ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-13 11:01:41 Duration: 10s275ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000277702 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-13 11:04:32 Duration: 9s806ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
11 2s81ms 28s141ms 12s976ms 9 1m56s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 15 10 3 40s683ms 13s561ms 20 3 37s914ms 12s638ms May 16 20 3 38s193ms 12s731ms [ User: intelifix - Total duration: 1m56s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m56s - Times executed: 9 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 10:39:22 Duration: 28s141ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 20:02:53 Duration: 23s849ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-16 20:02:52 Duration: 22s993ms Database: rio User: intelifix Remote: [local] Application: pg_dump
12 1s752ms 25s355ms 12s70ms 9 1m48s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 15 10 3 38s468ms 12s822ms 20 3 32s987ms 10s995ms May 16 20 3 37s179ms 12s393ms [ User: intelifix - Total duration: 1m48s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 9 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 10:40:05 Duration: 25s355ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-16 20:03:34 Duration: 23s607ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 20:03:31 Duration: 22s52ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
13 1s638ms 27s142ms 10s769ms 9 1m36s 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 May 15 10 3 31s599ms 10s533ms 20 3 31s428ms 10s476ms May 16 20 3 33s898ms 11s299ms [ User: intelifix - Total duration: 1m36s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m36s - Times executed: 9 ]
-
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-05-16 20:04:40 Duration: 27s142ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-15 20:04:37 Duration: 25s66ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-15 10:41:11 Duration: 24s917ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
14 1s147ms 19s253ms 9s776ms 9 1m27s 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 May 15 10 3 29s447ms 9s815ms 20 3 27s949ms 9s316ms May 16 20 3 30s589ms 10s196ms [ User: intelifix - Total duration: 1m27s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m27s - Times executed: 9 ]
-
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-05-15 10:40:25 Duration: 19s253ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-16 20:03:53 Duration: 19s229ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-15 20:03:50 Duration: 18s722ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
15 8s202ms 9s63ms 8s724ms 5 43s624ms create table temp0000277704 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 14 14 5 43s624ms 8s724ms [ User: intelifix - Total duration: 43s624ms - Times executed: 5 ]
[ Application: [unknown] - Total duration: 43s624ms - Times executed: 5 ]
-
CREATE TABLE temp0000277704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-14 14:40:44 Duration: 9s63ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000277704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-14 14:35:27 Duration: 8s879ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000277704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-14 14:31:01 Duration: 8s756ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
16 416ms 16s244ms 7s344ms 6 44s66ms copy public.tcia_lote_fluxos (tl_id, flu_id, criacao) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 15 10 2 16s701ms 8s350ms 20 2 12s348ms 6s174ms May 16 20 2 15s17ms 7s508ms [ User: intelifix - Total duration: 44s66ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 44s66ms - Times executed: 6 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-15 10:45:10 Duration: 16s244ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-16 20:08:33 Duration: 14s552ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-15 20:08:27 Duration: 11s931ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
17 908ms 17s890ms 7s98ms 9 1m3s copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 15 10 3 22s242ms 7s414ms 20 3 19s768ms 6s589ms May 16 20 3 21s871ms 7s290ms [ User: intelifix - Total duration: 1m3s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 9 ]
-
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-05-16 20:03:10 Duration: 17s890ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-15 10:39:40 Duration: 17s842ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-15 20:03:09 Duration: 16s64ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
18 2s931ms 8s806ms 6s202ms 9 55s821ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 15 10 3 18s502ms 6s167ms 20 3 19s109ms 6s369ms May 16 20 3 18s209ms 6s69ms [ User: intelifix - Total duration: 55s821ms - Times executed: 9 ]
[ Application: pg_dump - Total duration: 55s821ms - Times executed: 9 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-15 20:08:13 Duration: 8s806ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-15 10:44:51 Duration: 8s600ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-16 20:12:34 Duration: 7s825ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 877ms 14s863ms 5s840ms 9 52s567ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 15 10 3 18s793ms 6s264ms 20 3 16s470ms 5s490ms May 16 20 3 17s303ms 5s767ms [ User: intelifix - Total duration: 52s567ms - Times executed: 9 ]
[ Application: pg_dump - Total duration: 52s567ms - Times executed: 9 ]
-
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-05-15 10:38:50 Duration: 14s863ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-16 20:02:26 Duration: 13s962ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-05-15 20:02:26 Duration: 12s889ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
20 734ms 16s323ms 5s604ms 9 50s441ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 15 10 3 16s490ms 5s496ms 20 3 18s236ms 6s78ms May 16 20 3 15s714ms 5s238ms [ User: intelifix - Total duration: 50s441ms - Times executed: 9 ]
[ Application: pg_dump - Total duration: 50s441ms - Times executed: 9 ]
-
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-05-15 20:04:12 Duration: 16s323ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-15 10:40:46 Duration: 14s750ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.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-05-16 20:04:13 Duration: 14s68ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 1,164 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 19 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 18 Max number of times the same event was reported
- 23 Total events found
Rank Times reported Error 1 18 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #1
Day Hour Count May 15 09 18 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-05-15 09:56:46 Database: contagem Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-15.log
Date: 2026-05-15 09:56:46 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-15.log
Date: 2026-05-15 09:56:46 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-15.log
2 4 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #2
Day Hour Count May 15 09 3 10 1 - LOG: database system was shut down at 2026-05-15 09:56:46 -03
- LOG: database system was shut down at 2026-05-15 09:57:42 -03
- LOG: database system was shut down at 2026-05-15 09:58:17 -03
Date: 2026-05-15 09:57:07 Log file: /usr/local/pgsql/data/log/serverlog-15.log
Date: 2026-05-15 09:57:43 Log file: /usr/local/pgsql/data/log/serverlog-15.log
Date: 2026-05-15 09:58:25 Log file: /usr/local/pgsql/data/log/serverlog-15.log
3 1 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #3
Day Hour Count May 11 16 1 - FATAL: no pg_hba.conf entry for host "172.20.0.3", user "etiquetas", database "rio", no encryption
Date: 2026-05-11 16:50:38 Database: rio Application: [unknown] User: etiquetas Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-11.log