pgBadger-
Global information
- Generated on Sun Sep 6 23:50:20 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 8,797 log entries in 17s
- Log start from 2026-09-06 00:01:00 to 2026-09-06 23:50:03
-
Overview
Global Stats
- 144 Number of unique normalized queries
- 870 Number of queries
- 3h51m27s Total query duration
- 2026-09-06 00:02:09 First query
- 2026-09-06 23:50:03 Last query
- 5 queries/s at 2026-09-06 23:42:32 Query peak
- 3h51m27s Total query duration
- 593ms Prepare/parse total duration
- 0ms Bind total duration
- 3h51m26s Execute total duration
- 1,443 Number of events
- 7 Number of unique normalized events
- 1,418 Max number of times the same event was reported
- 0 Number of cancellation
- 7 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 20 Number temporary file
- 244.71 MiB Max size of temporary file
- 66.62 MiB Average size of temporary file
- 201 Total number of sessions
- 6 sessions at 2026-09-06 06:02:08 Session peak
- 7d13h21m19s Total duration of sessions
- 54m8s Average duration of sessions
- 4 Average queries per session
- 1m9s Average queries duration per session
- 52m59s Average idle time per session
- 212 Total number of connections
- 3 connections/s at 2026-09-06 00:05:02 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-06 23:42:32 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-09-06 20:09:11 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-06 23:42:32 Date
Queries duration
Key values
- 3h51m27s 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) Sep 06 00 20 0ms 25s60ms 4s718ms 2s841ms 3s294ms 1m8s 01 11 0ms 2s998ms 1s647ms 2s845ms 3s90ms 3s197ms 02 9 0ms 3s59ms 2s32ms 2s916ms 3s2ms 3s229ms 03 10 0ms 2s971ms 1s512ms 412ms 2s961ms 3s158ms 04 9 0ms 2s801ms 1s879ms 2s701ms 2s840ms 2s934ms 05 13 0ms 10m50s 1m43s 3s33ms 2m49s 10m50s 06 14 0ms 9s459ms 3s422ms 2s684ms 2s936ms 26s495ms 07 13 0ms 9m45s 1m18s 2s970ms 1m52s 9m45s 08 19 0ms 4m39s 29s579ms 2s913ms 41s511ms 4m39s 09 20 0ms 4m41s 27s943ms 2s798ms 41s906ms 4m41s 10 20 0ms 4m40s 27s894ms 2s894ms 41s830ms 4m40s 11 20 0ms 4m44s 28s263ms 2s882ms 43s755ms 4m44s 12 21 0ms 4m41s 26s722ms 2s980ms 42s103ms 4m41s 13 19 0ms 4m37s 29s134ms 2s851ms 42s206ms 4m37s 14 21 0ms 4m34s 26s83ms 2s821ms 41s320ms 4m34s 15 21 0ms 4m34s 26s133ms 2s914ms 42s41ms 4m34s 16 20 0ms 4m36s 27s763ms 2s834ms 41s656ms 4m36s 17 19 0ms 4m38s 29s91ms 2s905ms 42s189ms 4m38s 18 24 0ms 4m37s 23s294ms 3s14ms 41s722ms 4m37s 19 19 0ms 4m37s 29s328ms 2s845ms 43s561ms 4m37s 20 122 0ms 7m38s 11s746ms 1m12s 2m8s 7m38s 21 24 0ms 6m27s 27s656ms 3s41ms 13s819ms 6m55s 22 21 0ms 4m43s 27s50ms 2s910ms 41s377ms 4m43s 23 361 0ms 1m2s 5s447ms 1m5s 1m11s 1m15s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 06 00 3 0 3s804ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 169ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 2s521ms 0ms 0ms 0ms 07 6 0 2m46s 0ms 0ms 4m20s 08 6 0 1m29s 0ms 0ms 3m33s 09 6 0 1m29s 0ms 0ms 3m32s 10 6 0 1m29s 0ms 0ms 3m33s 11 6 0 1m30s 0ms 0ms 3m35s 12 6 0 1m29s 0ms 0ms 3m34s 13 6 0 1m28s 0ms 0ms 3m31s 14 6 0 1m27s 0ms 0ms 3m29s 15 6 0 1m27s 0ms 0ms 3m29s 16 6 0 1m28s 0ms 0ms 3m34s 17 6 0 1m28s 0ms 0ms 3m29s 18 9 0 59s621ms 0ms 0ms 3m32s 19 6 0 1m29s 0ms 0ms 3m34s 20 23 78 13s577ms 35s9ms 1m2s 3m59s 21 8 0 1m20s 0ms 0ms 3m30s 22 6 0 1m30s 0ms 0ms 3m40s 23 39 320 5s476ms 1m1s 1m5s 1m12s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 06 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 06 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 1 1 1.00 0.99% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 1 8 8.00 0.28% Day Hour Count Average / Second Sep 06 00 16 0.00/s 01 6 0.00/s 02 7 0.00/s 03 14 0.00/s 04 7 0.00/s 05 9 0.00/s 06 13 0.00/s 07 8 0.00/s 08 8 0.00/s 09 8 0.00/s 10 8 0.00/s 11 8 0.00/s 12 12 0.00/s 13 6 0.00/s 14 9 0.00/s 15 7 0.00/s 16 8 0.00/s 17 7 0.00/s 18 8 0.00/s 19 8 0.00/s 20 11 0.00/s 21 8 0.00/s 22 8 0.00/s 23 8 0.00/s Day Hour Count Average Duration Average idle time Sep 06 00 3 43m20s 42m49s 01 14 1h1m17s 1h1m16s 02 6 1h 59m57s 03 13 24m55s 24m53s 04 7 1h2m34s 1h2m32s 05 7 58m34s 55m22s 06 9 57m15s 57m10s 07 13 56m51s 55m32s 08 8 53m45s 52m35s 09 7 59m17s 57m57s 10 7 1h2s 58m42s 11 9 55m11s 54m8s 12 7 1h1m31s 1h11s 13 7 1h40s 59m21s 14 7 52m51s 51m33s 15 8 1h54s 59m45s 16 8 53m45s 52m35s 17 7 1h1m6s 59m47s 18 7 1h1m15s 59m55s 19 8 1h35s 59m25s 20 11 44m45s 42m34s 21 8 1h58s 59m35s 22 7 1h40s 59m19s 23 13 35m4s 32m32s -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2026-09-06 00:05:02 Date
Connections per database
Key values
- rio Main Database
- 212 connections Total
Connections per user
Key values
- intelifix Main User
- 212 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-09-06 06:02:08 Date
Histogram of session times
Key values
- 171 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 201 sessions Total
Sessions per user
Key values
- intelifix Main User
- 201 sessions Total
Sessions per host
Key values
- [local] Main Host
- 201 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 13,396 buffers Checkpoint Peak
- 2026-09-06 03:05:02 Date
- 269.465 seconds Highest write time
- 0.223 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-09-06 03:05:02 Date
Checkpoints distance
Key values
- 103.78 Mo Distance Peak
- 2026-09-06 03:05:02 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 06 00 7,653 269.465s 0.003s 269.476s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 13,396 0.31s 0.225s 0.556s 04 0 0s 0s 0s 05 7,445 745.008s 0.172s 745.212s 06 1,952 195.646s 0.002s 195.654s 07 713 71.479s 0.064s 71.545s 08 23 2.312s 0.063s 2.378s 09 24 2.412s 0.003s 2.419s 10 23 2.312s 0.003s 2.318s 11 25 2.519s 0.014s 2.542s 12 23 2.311s 0.003s 2.317s 13 24 2.414s 0.003s 2.42s 14 23 2.311s 0.003s 2.317s 15 24 2.411s 0.004s 2.419s 16 23 2.312s 0.003s 2.318s 17 24 2.412s 0.003s 2.418s 18 1,709 171.103s 0.086s 171.2s 19 24 2.412s 0.003s 2.418s 20 28 2.827s 0.015s 2.853s 21 24 2.412s 0.01s 2.431s 22 23 2.311s 0.003s 2.317s 23 22 2.21s 0.002s 2.214s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 06 00 0 0 2 32 0.002s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 27 0.202s 0.011s 04 0 0 0 0 0s 0s 05 0 0 4 145 0.062s 0.014s 06 0 0 0 9 0.001s 0.001s 07 0 0 0 14 0.062s 0.005s 08 0 0 0 3 0.062s 0.021s 09 0 0 0 3 0.002s 0.001s 10 0 0 0 3 0.001s 0.001s 11 0 0 0 5 0.009s 0.007s 12 0 0 0 3 0.002s 0.001s 13 0 0 0 3 0.002s 0.001s 14 0 0 0 3 0.002s 0.001s 15 0 0 0 3 0.002s 0.002s 16 0 0 0 3 0.002s 0.001s 17 0 0 0 3 0.002s 0.001s 18 0 0 1 80 0.061s 0.012s 19 0 0 0 3 0.002s 0.001s 20 0 0 0 11 0.009s 0.005s 21 0 0 0 3 0.009s 0.004s 22 0 0 0 3 0.002s 0.001s 23 0 0 0 1 0.002s 0.002s Day Hour Count Avg time (sec) Sep 06 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 06 00 40,354.00 kB 40,354.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 26,568.50 kB 26,568.50 kB 04 0.00 kB 0.00 kB 05 7,675.00 kB 10,869.14 kB 06 4,696.00 kB 11,435.00 kB 07 6,482.00 kB 10,940.00 kB 08 187.00 kB 9,865.00 kB 09 188.00 kB 8,897.00 kB 10 187.00 kB 8,026.00 kB 11 95.00 kB 6,879.00 kB 12 187.00 kB 5,885.00 kB 13 188.00 kB 5,315.00 kB 14 187.00 kB 4,803.00 kB 15 188.00 kB 4,341.00 kB 16 187.00 kB 3,926.00 kB 17 188.00 kB 3,552.00 kB 18 1,490.00 kB 4,636.50 kB 19 188.00 kB 3,588.00 kB 20 264.67 kB 2,956.33 kB 21 188.00 kB 2,440.00 kB 22 187.00 kB 2,215.00 kB 23 76.00 kB 2,001.00 kB -
Temporary Files
Size of temporary files
Key values
- 489.42 MiB Temp Files size Peak
- 2026-09-06 05:31:56 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-06 05:32:02 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 06 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.30 GiB 66.62 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.00 GiB 36.49 MiB 244.71 MiB 64.23 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-06 05:32:05 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-06 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 304.66 MiB 56.62 MiB 93.18 MiB 76.16 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-06 05:30:42 Duration: 38s974ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-06 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 244.71 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-06 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 244.71 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-06 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 93.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-06 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 93.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-06 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 61.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-06 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 56.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-06 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.46 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-06 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-06 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-06 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-06 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-06 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.37 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-06 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.37 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-06 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 36.56 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-06 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.51 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-06 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.51 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-06 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.50 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-06 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.50 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-06 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-06 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-06 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 1.69 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database contagem - 2026-09-06 00:06:33 Date
- 0 sec Highest CPU-cost analyze
Table
Database contagem - Date
Average Autovacuum Duration
Key values
- 1.69 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database contagem - 2026-09-06 00:06:33 Date
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database brasilia
- 7 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 141 33 115,170 8 15 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,646 483 1,987,727 454 3,184 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,578 880 3,747,240 826 5,005 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 121 41 129,380 6 14 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,349 970 2,993,807 935 6,767 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 779 215 1,102,100 103 288 contagem.auditor.auditor_2026_09 1 0 0 0 0 0 0 6,898 6,140 7,463,992 5 48 Total 7 6 0 0 0 0 0 16,512 8,762 17,539,416 2,337 15,321 Vacuum throughput per table
Key values
- auditor.auditor_2026_09 (1.69) Max CPU elapsed for vacuum on database contagem
- unknown (0 ms) Max I/O read time for vacuum on database contagem
- unknown (0 ms) Max I/O write time for vacuum on database contagem
I/O timing (ms) CPU (s) Table read write elapsed brasilia.pg_toast.pg_toast_2619 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.25 rio.pg_catalog.pg_statistic 0 0 0.44 contagem.pg_toast.pg_toast_2619 0 0 0.05 contagem.pg_catalog.pg_statistic 0 0 0.09 rio.pg_toast.pg_toast_2619 0 0 0.06 contagem.auditor.auditor_2026_09 0 0 1.69 Total 0 0 2.58 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4561) Main table with removed tuples on database rio
- 13890 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,561 7,472 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,468 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,953 7,360 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 632 680 0 24 265 contagem.pg_toast.pg_toast_2619 1 1 104 120 0 7 47 brasilia.pg_toast.pg_toast_2619 1 1 103 140 0 0 62 contagem.auditor.auditor_2026_09 1 0 69 858,489 0 0 39,757 Total 7 6 13,890 881,535 0 31 43,500 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (24) Main table with removed pages on database rio
- 31 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_toast.pg_toast_2619 1 1 632 24 contagem.pg_toast.pg_toast_2619 1 1 104 7 brasilia.pg_toast.pg_toast_2619 1 1 103 0 brasilia.pg_catalog.pg_statistic 1 1 3953 0 rio.pg_catalog.pg_statistic 1 1 4561 0 contagem.pg_catalog.pg_statistic 1 1 4468 0 contagem.auditor.auditor_2026_09 1 0 69 0 Total 7 6 13,890 31 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 06 00 1 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 1.69 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
- 164 Total read queries
- 398 Total write queries
Queries by database
Key values
- rio Main database
- 404 Requests
- 2h25m36s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 1,748 Requests
User Request type Count Duration etiquetas Total 25 18s677ms others 2 587ms select 23 18s90ms intelifix Total 1,748 7h38m54s copy to 796 1h22m57s ddl 1 332ms others 662 1h4m18s select 289 5h11m37s lenon Total 18 32s815ms select 18 32s815ms Duration by user
Key values
- 7h38m54s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 25 18s677ms others 2 587ms select 23 18s90ms intelifix Total 1,748 7h38m54s copy to 796 1h22m57s ddl 1 332ms others 662 1h4m18s select 289 5h11m37s lenon Total 18 32s815ms select 18 32s815ms Queries by host
Key values
- [local] Main host
- 1,791 Requests
- 7h39m45s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 441 Requests
- 3h9m34s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-06 04:26:55 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 340 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 10m50s analyze verbose;[ Date: 2026-09-06 05:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-06 07:14:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-06 20:12:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-06 21:11:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m26s analyze verbose;[ Date: 2026-09-06 05:17:18 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
6 4m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-06 11:09:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 4m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-06 22:09:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 4m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-06 12:09:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 4m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-06 09:09:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 4m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-06 10:09:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 4m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-06 08:09:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 4m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-06 17:09:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 4m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-06 19:09:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 4m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-06 13:09:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 4m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-06 18:09:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 4m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-06 16:09:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 4m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-06 14:09:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-06 15:09:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 4m11s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-06 07:21:33 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m51s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-06 20:18:38 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h29m19s 48 1s338ms 9m45s 1m51s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 06 07 3 10m33s 3m31s 08 3 4m55s 1m38s 09 3 4m57s 1m39s 10 3 4m56s 1m38s 11 3 5m 1m40s 12 3 4m57s 1m39s 13 3 4m53s 1m37s 14 3 4m50s 1m36s 15 3 4m50s 1m36s 16 3 4m52s 1m37s 17 3 4m54s 1m38s 18 3 4m53s 1m37s 19 3 4m53s 1m37s 20 3 8m10s 2m43s 21 3 6m42s 2m14s 22 3 4m59s 1m39s [ User: intelifix - Total duration: 1h29m19s - Times executed: 48 ]
[ Application: psql - Total duration: 1h29m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-06 07:14:47 Duration: 9m45s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-06 20:12:39 Duration: 7m38s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-06 21:11:29 Duration: 6m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
2 1h7m36s 48 260ms 4m11s 1m24s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 06 07 3 6m7s 2m2s 08 3 3m59s 1m19s 09 3 3m59s 1m19s 10 3 3m59s 1m19s 11 3 4m2s 1m20s 12 3 4m1s 1m20s 13 3 3m58s 1m19s 14 3 3m55s 1m18s 15 3 3m56s 1m18s 16 3 4m 1m20s 17 3 3m56s 1m18s 18 3 3m58s 1m19s 19 3 4m1s 1m20s 20 3 5m35s 1m51s 21 3 3m56s 1m18s 22 3 4m6s 1m22s [ User: intelifix - Total duration: 1h7m36s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m36s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-06 07:21:33 Duration: 4m11s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-06 20:18:38 Duration: 3m51s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-06 22:14:05 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
3 20m6s 3 2m49s 10m50s 6m42s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 06 05 3 20m6s 6m42s [ User: intelifix - Total duration: 20m6s - Times executed: 3 ]
[ Application: psql - Total duration: 20m6s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-06 05:10:51 Duration: 10m50s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
analyze verbose;
Date: 2026-09-06 05:17:18 Duration: 6m26s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
analyze verbose;
Date: 2026-09-06 05:20:07 Duration: 2m49s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
4 7m39s 193 150ms 25s60ms 2s379ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 06 00 10 45s591ms 4s559ms 01 11 18s125ms 1s647ms 02 9 18s293ms 2s32ms 03 9 14s960ms 1s662ms 04 9 16s914ms 1s879ms 05 7 17s321ms 2s474ms 06 8 16s893ms 2s111ms 07 7 17s811ms 2s544ms 08 7 17s23ms 2s431ms 09 8 16s766ms 2s95ms 10 8 17s299ms 2s162ms 11 8 17s598ms 2s199ms 12 9 17s654ms 1s961ms 13 7 17s12ms 2s430ms 14 9 16s884ms 1s876ms 15 9 17s405ms 1s933ms 16 8 16s990ms 2s123ms 17 7 17s103ms 2s443ms 18 9 17s674ms 1s963ms 19 7 16s918ms 2s416ms 20 10 51s693ms 5s169ms 21 8 17s693ms 2s211ms 22 9 17s549ms 1s949ms [ User: intelifix - Total duration: 7m39s - Times executed: 193 ]
[ Application: psql - Total duration: 7m39s - Times executed: 193 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-06 00:05:27 Duration: 25s60ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-06 20:05:20 Duration: 18s542ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-06 20:15:16 Duration: 14s300ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
5 2m13s 4 4s182ms 1m2s 33s408ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 06 20 2 1m6s 33s323ms 23 2 1m6s 33s492ms [ User: intelifix - Total duration: 2m13s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m13s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-06 23:16:37 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-06 20:08:37 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-06 20:10:35 Duration: 4s382ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
6 1m46s 4 367ms 53s81ms 26s595ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 06 20 2 53s456ms 26s728ms 23 2 52s923ms 26s461ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-06 20:05:44 Duration: 53s81ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-06 23:13:43 Duration: 52s556ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-06 20:10:00 Duration: 374ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
7 1m44s 6 2s998ms 39s250ms 17s376ms 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 #7
Day Hour Count Duration Avg duration Sep 06 20 3 52s652ms 17s550ms 23 3 51s607ms 17s202ms [ User: intelifix - Total duration: 1m44s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m44s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-06 20:06:26 Duration: 39s250ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:14:25 Duration: 38s418ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 20:10:11 Duration: 10s373ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
8 1m22s 1 1m22s 1m22s 1m22s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 06 05 1 1m22s 1m22s [ User: intelifix - Total duration: 1m22s - Times executed: 1 ]
[ Application: psql - Total duration: 1m22s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-06 05:32:05 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-06 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
9 1m21s 6 2s161ms 31s307ms 13s579ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 06 20 3 41s94ms 13s698ms 23 3 40s384ms 13s461ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-06 20:06:59 Duration: 31s307ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-06 23:14:59 Duration: 30s769ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-06 20:10:19 Duration: 7s569ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
10 1m20s 6 3s3ms 31s23ms 13s451ms 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 #10
Day Hour Count Duration Avg duration Sep 06 20 3 40s373ms 13s457ms 23 3 40s337ms 13s445ms [ User: intelifix - Total duration: 1m20s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m20s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-06 23:17:09 Duration: 31s23ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 20:09:08 Duration: 30s851ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 20:10:41 Duration: 6s507ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
11 1m9s 6 2s333ms 23s56ms 11s592ms 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 Sep 06 20 3 34s845ms 11s615ms 23 3 34s711ms 11s570ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 20:02:48 Duration: 23s56ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 23:10:48 Duration: 22s866ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 23:32:47 Duration: 9s512ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
12 1m9s 6 2s152ms 23s801ms 11s560ms 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 Sep 06 20 3 35s26ms 11s675ms 23 3 34s335ms 11s445ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 20:03:29 Duration: 23s801ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 23:11:28 Duration: 23s270ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 20:09:41 Duration: 9s46ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
13 1m5s 6 1s665ms 26s543ms 10s981ms 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 Sep 06 20 3 32s352ms 10s784ms 23 3 33s537ms 11s179ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m5s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-06 23:12:27 Duration: 26s543ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 20:04:28 Duration: 25s946ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:33:13 Duration: 4s966ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
14 58s518ms 6 6s655ms 13s391ms 9s753ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 06 00 3 35s59ms 11s686ms 06 3 23s459ms 7s819ms [ User: intelifix - Total duration: 58s518ms - Times executed: 6 ]
[ Application: psql - Total duration: 58s518ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-06 00:05:15 Duration: 13s391ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-06 00:05:26 Duration: 10s931ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-06 00:05:37 Duration: 10s736ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
15 53s976ms 4 4s10ms 22s945ms 13s494ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 06 20 2 27s72ms 13s536ms 23 2 26s903ms 13s451ms [ User: intelifix - Total duration: 53s976ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 53s976ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-06 20:04:51 Duration: 22s945ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-06 23:12:50 Duration: 22s893ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-06 20:10:00 Duration: 4s126ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
16 51s85ms 54 569ms 6s128ms 946ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 06 08 4 8s723ms 2s180ms 09 3 3s352ms 1s117ms 10 3 2s306ms 768ms 11 4 2s927ms 731ms 12 3 2s393ms 797ms 13 4 3s387ms 846ms 14 4 3s178ms 794ms 15 3 2s143ms 714ms 16 3 2s282ms 760ms 17 4 2s994ms 748ms 18 4 3s133ms 783ms 19 4 3s97ms 774ms 20 4 5s466ms 1s366ms 21 4 3s371ms 842ms 22 3 2s327ms 775ms [ User: intelifix - Total duration: 51s85ms - Times executed: 54 ]
[ Application: psql - Total duration: 51s85ms - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-06 08:00:07 Duration: 6s128ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-06 20:20:04 Duration: 3s142ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-06 09:20:04 Duration: 1s898ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
17 50s313ms 6 1s726ms 16s453ms 8s385ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 06 20 3 25s296ms 8s432ms 23 3 25s17ms 8s339ms [ User: intelifix - Total duration: 50s313ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 50s313ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-06 20:03:46 Duration: 16s453ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:11:44 Duration: 16s135ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:33:06 Duration: 7s154ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
18 40s165ms 6 1s33ms 16s606ms 6s694ms 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 #18
Day Hour Count Duration Avg duration Sep 06 20 3 20s130ms 6s710ms 23 3 20s35ms 6s678ms [ User: intelifix - Total duration: 40s165ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s165ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-06 20:03:05 Duration: 16s606ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:11:05 Duration: 16s528ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 20:09:32 Duration: 2s489ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
19 38s974ms 1 38s974ms 38s974ms 38s974ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 06 05 1 38s974ms 38s974ms [ User: intelifix - Total duration: 38s974ms - Times executed: 1 ]
[ Application: psql - Total duration: 38s974ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-06 05:30:42 Duration: 38s974ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-06 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
20 30s922ms 36 584ms 1s221ms 858ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 06 08 2 1s852ms 926ms 09 3 2s401ms 800ms 10 3 2s540ms 846ms 11 2 1s635ms 817ms 12 3 2s738ms 912ms 13 2 1s628ms 814ms 14 2 1s495ms 747ms 15 3 2s361ms 787ms 16 3 2s555ms 851ms 17 2 1s858ms 929ms 18 2 1s674ms 837ms 19 2 1s805ms 902ms 20 2 1s666ms 833ms 21 2 2s129ms 1s64ms 22 3 2s577ms 859ms [ User: intelifix - Total duration: 30s922ms - Times executed: 36 ]
[ Application: psql - Total duration: 30s922ms - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-06 21:00:02 Duration: 1s221ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-06 10:40:02 Duration: 1s30ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-06 17:20:02 Duration: 1s7ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 193 7m39s 150ms 25s60ms 2s379ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 06 00 10 45s591ms 4s559ms 01 11 18s125ms 1s647ms 02 9 18s293ms 2s32ms 03 9 14s960ms 1s662ms 04 9 16s914ms 1s879ms 05 7 17s321ms 2s474ms 06 8 16s893ms 2s111ms 07 7 17s811ms 2s544ms 08 7 17s23ms 2s431ms 09 8 16s766ms 2s95ms 10 8 17s299ms 2s162ms 11 8 17s598ms 2s199ms 12 9 17s654ms 1s961ms 13 7 17s12ms 2s430ms 14 9 16s884ms 1s876ms 15 9 17s405ms 1s933ms 16 8 16s990ms 2s123ms 17 7 17s103ms 2s443ms 18 9 17s674ms 1s963ms 19 7 16s918ms 2s416ms 20 10 51s693ms 5s169ms 21 8 17s693ms 2s211ms 22 9 17s549ms 1s949ms [ User: intelifix - Total duration: 7m39s - Times executed: 193 ]
[ Application: psql - Total duration: 7m39s - Times executed: 193 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-06 00:05:27 Duration: 25s60ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-06 20:05:20 Duration: 18s542ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-06 20:15:16 Duration: 14s300ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
2 54 51s85ms 569ms 6s128ms 946ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 06 08 4 8s723ms 2s180ms 09 3 3s352ms 1s117ms 10 3 2s306ms 768ms 11 4 2s927ms 731ms 12 3 2s393ms 797ms 13 4 3s387ms 846ms 14 4 3s178ms 794ms 15 3 2s143ms 714ms 16 3 2s282ms 760ms 17 4 2s994ms 748ms 18 4 3s133ms 783ms 19 4 3s97ms 774ms 20 4 5s466ms 1s366ms 21 4 3s371ms 842ms 22 3 2s327ms 775ms [ User: intelifix - Total duration: 51s85ms - Times executed: 54 ]
[ Application: psql - Total duration: 51s85ms - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-06 08:00:07 Duration: 6s128ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-06 20:20:04 Duration: 3s142ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-06 09:20:04 Duration: 1s898ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
3 48 1h29m19s 1s338ms 9m45s 1m51s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 06 07 3 10m33s 3m31s 08 3 4m55s 1m38s 09 3 4m57s 1m39s 10 3 4m56s 1m38s 11 3 5m 1m40s 12 3 4m57s 1m39s 13 3 4m53s 1m37s 14 3 4m50s 1m36s 15 3 4m50s 1m36s 16 3 4m52s 1m37s 17 3 4m54s 1m38s 18 3 4m53s 1m37s 19 3 4m53s 1m37s 20 3 8m10s 2m43s 21 3 6m42s 2m14s 22 3 4m59s 1m39s [ User: intelifix - Total duration: 1h29m19s - Times executed: 48 ]
[ Application: psql - Total duration: 1h29m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-06 07:14:47 Duration: 9m45s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-06 20:12:39 Duration: 7m38s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-06 21:11:29 Duration: 6m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
4 48 1h7m36s 260ms 4m11s 1m24s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 06 07 3 6m7s 2m2s 08 3 3m59s 1m19s 09 3 3m59s 1m19s 10 3 3m59s 1m19s 11 3 4m2s 1m20s 12 3 4m1s 1m20s 13 3 3m58s 1m19s 14 3 3m55s 1m18s 15 3 3m56s 1m18s 16 3 4m 1m20s 17 3 3m56s 1m18s 18 3 3m58s 1m19s 19 3 4m1s 1m20s 20 3 5m35s 1m51s 21 3 3m56s 1m18s 22 3 4m6s 1m22s [ User: intelifix - Total duration: 1h7m36s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m36s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-06 07:21:33 Duration: 4m11s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-06 20:18:38 Duration: 3m51s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-06 22:14:05 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
5 36 30s922ms 584ms 1s221ms 858ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 06 08 2 1s852ms 926ms 09 3 2s401ms 800ms 10 3 2s540ms 846ms 11 2 1s635ms 817ms 12 3 2s738ms 912ms 13 2 1s628ms 814ms 14 2 1s495ms 747ms 15 3 2s361ms 787ms 16 3 2s555ms 851ms 17 2 1s858ms 929ms 18 2 1s674ms 837ms 19 2 1s805ms 902ms 20 2 1s666ms 833ms 21 2 2s129ms 1s64ms 22 3 2s577ms 859ms [ User: intelifix - Total duration: 30s922ms - Times executed: 36 ]
[ Application: psql - Total duration: 30s922ms - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-06 21:00:02 Duration: 1s221ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-06 10:40:02 Duration: 1s30ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-06 17:20:02 Duration: 1s7ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
6 10 8s603ms 168ms 2s824ms 860ms select * from rs_caixa_qr ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 06 03 1 169ms 169ms 20 1 1s244ms 1s244ms 23 8 7s189ms 898ms [ User: etiquetas - Total duration: 8s603ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 8s603ms - Times executed: 10 ]
-
select * from rs_caixa_qr ();
Date: 2026-09-06 23:27:49 Duration: 2s824ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
select * from rs_caixa_qr ();
Date: 2026-09-06 23:50:03 Duration: 2s584ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
select * from rs_caixa_qr ();
Date: 2026-09-06 20:25:24 Duration: 1s244ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-06.log
7 10 5s4ms 150ms 1s82ms 500ms call rs_giga_tecnicos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 06 00 3 2s24ms 674ms 05 1 150ms 150ms 20 4 2s318ms 579ms 21 2 511ms 255ms [ User: intelifix - Total duration: 5s4ms - Times executed: 10 ]
[ Application: psql - Total duration: 5s4ms - Times executed: 10 ]
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-06 00:05:03 Duration: 1s82ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-06 20:05:02 Duration: 1s47ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-06 20:05:03 Duration: 810ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
8 8 3s232ms 250ms 626ms 404ms select c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( case when c.relkind = ? then ?::"char" else ?::"char" end, c.relowner) as acldefault, case when c.relkind = ? then ( select ftserver from pg_catalog.pg_foreign_table where ftrelid = c.oid) else ? end as foreignserver, c.relfrozenxid, tc.relfrozenxid as tfrozenxid, tc.oid as toid, tc.relpages as toastpages, tc.reloptions as toast_reloptions, d.refobjid as owning_tab, d.refobjsubid as owning_col, tsp.spcname as reltablespace, false as relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid as tminmxid, array_remove(array_remove(c.reloptions, ?), ?) as reloptions, case when ? = any (c.reloptions) then ?::text when ? = any (c.reloptions) then ?::text else null end as checkoption, am.amname, (d.deptype = ?) is true as is_identity_sequence, c.relispartition as ispartition from pg_class c left join pg_depend d on (c.relkind = ? and d.classid = ?::regclass and d.objid = c.oid and d.objsubid = ? and d.refclassid = ?::regclass and d.deptype in (...)) left join pg_tablespace tsp on (tsp.oid = c.reltablespace) left join pg_am am on (c.relam = am.oid) left join pg_class tc on (c.reltoastrelid = tc.oid and tc.relkind = ? and c.relkind <> ?) where c.relkind in (...) order by c.oid;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 06 20 3 1s30ms 343ms 23 5 2s202ms 440ms [ User: intelifix - Total duration: 3s232ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 3s232ms - Times executed: 8 ]
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-09-06 23:41:56 Duration: 626ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-09-06 23:10:02 Duration: 479ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-09-06 20:09:10 Duration: 454ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
9 8 1s922ms 162ms 502ms 240ms select seqrelid, format_type(seqtypid, null), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle, last_value, is_called from pg_catalog.pg_sequence, pg_get_sequence_data (seqrelid) order by seqrelid;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 06 20 3 709ms 236ms 23 5 1s212ms 242ms [ User: intelifix - Total duration: 1s922ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1s922ms - Times executed: 8 ]
-
SELECT seqrelid, format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle, last_value, is_called FROM pg_catalog.pg_sequence, pg_get_sequence_data (seqrelid) ORDER BY seqrelid;
Date: 2026-09-06 23:41:59 Duration: 502ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT seqrelid, format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle, last_value, is_called FROM pg_catalog.pg_sequence, pg_get_sequence_data (seqrelid) ORDER BY seqrelid;
Date: 2026-09-06 20:10:45 Duration: 292ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT seqrelid, format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle, last_value, is_called FROM pg_catalog.pg_sequence, pg_get_sequence_data (seqrelid) ORDER BY seqrelid;
Date: 2026-09-06 20:09:12 Duration: 236ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
10 7 3s708ms 302ms 784ms 529ms select p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault(?, p.proowner) as acldefault, p.pronamespace, p.proowner from pg_proc p left join pg_init_privs pip on (p.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?) where p.prokind <> ? and not exists ( select ? from pg_depend where classid = ?::regclass and objid = p.oid and deptype = ?) and (pronamespace != ( select oid from pg_namespace where nspname = ?) or exists ( select ? from pg_cast where pg_cast.oid > ? and p.oid = pg_cast.castfunc) or exists ( select ? from pg_transform where pg_transform.oid > ? and (p.oid = pg_transform.trffromsql or p.oid = pg_transform.trftosql)) or p.proacl is distinct from pip.initprivs);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 06 20 3 1s438ms 479ms 23 4 2s269ms 567ms [ User: intelifix - Total duration: 3s708ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 3s708ms - Times executed: 7 ]
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-09-06 20:02:03 Duration: 784ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-09-06 23:17:11 Duration: 754ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-09-06 23:10:03 Duration: 657ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
11 6 1m44s 2s998ms 39s250ms 17s376ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 06 20 3 52s652ms 17s550ms 23 3 51s607ms 17s202ms [ User: intelifix - Total duration: 1m44s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m44s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-06 20:06:26 Duration: 39s250ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:14:25 Duration: 38s418ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 20:10:11 Duration: 10s373ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
12 6 1m21s 2s161ms 31s307ms 13s579ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 06 20 3 41s94ms 13s698ms 23 3 40s384ms 13s461ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-06 20:06:59 Duration: 31s307ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-06 23:14:59 Duration: 30s769ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-06 20:10:19 Duration: 7s569ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
13 6 1m20s 3s3ms 31s23ms 13s451ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 06 20 3 40s373ms 13s457ms 23 3 40s337ms 13s445ms [ User: intelifix - Total duration: 1m20s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m20s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-06 23:17:09 Duration: 31s23ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 20:09:08 Duration: 30s851ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 20:10:41 Duration: 6s507ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
14 6 1m9s 2s333ms 23s56ms 11s592ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 06 20 3 34s845ms 11s615ms 23 3 34s711ms 11s570ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 20:02:48 Duration: 23s56ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 23:10:48 Duration: 22s866ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 23:32:47 Duration: 9s512ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
15 6 1m9s 2s152ms 23s801ms 11s560ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 06 20 3 35s26ms 11s675ms 23 3 34s335ms 11s445ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 20:03:29 Duration: 23s801ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 23:11:28 Duration: 23s270ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 20:09:41 Duration: 9s46ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
16 6 1m5s 1s665ms 26s543ms 10s981ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 06 20 3 32s352ms 10s784ms 23 3 33s537ms 11s179ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m5s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-06 23:12:27 Duration: 26s543ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 20:04:28 Duration: 25s946ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:33:13 Duration: 4s966ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
17 6 58s518ms 6s655ms 13s391ms 9s753ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 06 00 3 35s59ms 11s686ms 06 3 23s459ms 7s819ms [ User: intelifix - Total duration: 58s518ms - Times executed: 6 ]
[ Application: psql - Total duration: 58s518ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-06 00:05:15 Duration: 13s391ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-06 00:05:26 Duration: 10s931ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-06 00:05:37 Duration: 10s736ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
18 6 50s313ms 1s726ms 16s453ms 8s385ms 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 #18
Day Hour Count Duration Avg duration Sep 06 20 3 25s296ms 8s432ms 23 3 25s17ms 8s339ms [ User: intelifix - Total duration: 50s313ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 50s313ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-06 20:03:46 Duration: 16s453ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:11:44 Duration: 16s135ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:33:06 Duration: 7s154ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
19 6 40s165ms 1s33ms 16s606ms 6s694ms 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 #19
Day Hour Count Duration Avg duration Sep 06 20 3 20s130ms 6s710ms 23 3 20s35ms 6s678ms [ User: intelifix - Total duration: 40s165ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s165ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-06 20:03:05 Duration: 16s606ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:11:05 Duration: 16s528ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 20:09:32 Duration: 2s489ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
20 6 28s26ms 799ms 12s487ms 4s671ms 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 Sep 06 20 3 14s171ms 4s723ms 23 3 13s854ms 4s618ms [ User: intelifix - Total duration: 28s26ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 28s26ms - Times executed: 6 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-09-06 20:04:02 Duration: 12s487ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:12:00 Duration: 12s163ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:33:08 Duration: 892ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m49s 10m50s 6m42s 3 20m6s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 06 05 3 20m6s 6m42s [ User: intelifix - Total duration: 20m6s - Times executed: 3 ]
[ Application: psql - Total duration: 20m6s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-06 05:10:51 Duration: 10m50s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
analyze verbose;
Date: 2026-09-06 05:17:18 Duration: 6m26s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
analyze verbose;
Date: 2026-09-06 05:20:07 Duration: 2m49s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
2 1s338ms 9m45s 1m51s 48 1h29m19s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 06 07 3 10m33s 3m31s 08 3 4m55s 1m38s 09 3 4m57s 1m39s 10 3 4m56s 1m38s 11 3 5m 1m40s 12 3 4m57s 1m39s 13 3 4m53s 1m37s 14 3 4m50s 1m36s 15 3 4m50s 1m36s 16 3 4m52s 1m37s 17 3 4m54s 1m38s 18 3 4m53s 1m37s 19 3 4m53s 1m37s 20 3 8m10s 2m43s 21 3 6m42s 2m14s 22 3 4m59s 1m39s [ User: intelifix - Total duration: 1h29m19s - Times executed: 48 ]
[ Application: psql - Total duration: 1h29m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-06 07:14:47 Duration: 9m45s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-06 20:12:39 Duration: 7m38s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-06 21:11:29 Duration: 6m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
3 260ms 4m11s 1m24s 48 1h7m36s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 06 07 3 6m7s 2m2s 08 3 3m59s 1m19s 09 3 3m59s 1m19s 10 3 3m59s 1m19s 11 3 4m2s 1m20s 12 3 4m1s 1m20s 13 3 3m58s 1m19s 14 3 3m55s 1m18s 15 3 3m56s 1m18s 16 3 4m 1m20s 17 3 3m56s 1m18s 18 3 3m58s 1m19s 19 3 4m1s 1m20s 20 3 5m35s 1m51s 21 3 3m56s 1m18s 22 3 4m6s 1m22s [ User: intelifix - Total duration: 1h7m36s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m36s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-06 07:21:33 Duration: 4m11s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-06 20:18:38 Duration: 3m51s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-06 22:14:05 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
4 1m22s 1m22s 1m22s 1 1m22s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 06 05 1 1m22s 1m22s [ User: intelifix - Total duration: 1m22s - Times executed: 1 ]
[ Application: psql - Total duration: 1m22s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-06 05:32:05 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-06 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
5 38s974ms 38s974ms 38s974ms 1 38s974ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 06 05 1 38s974ms 38s974ms [ User: intelifix - Total duration: 38s974ms - Times executed: 1 ]
[ Application: psql - Total duration: 38s974ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-06 05:30:42 Duration: 38s974ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-06 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
6 4s182ms 1m2s 33s408ms 4 2m13s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 06 20 2 1m6s 33s323ms 23 2 1m6s 33s492ms [ User: intelifix - Total duration: 2m13s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m13s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-06 23:16:37 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-06 20:08:37 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-06 20:10:35 Duration: 4s382ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
7 367ms 53s81ms 26s595ms 4 1m46s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 06 20 2 53s456ms 26s728ms 23 2 52s923ms 26s461ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-06 20:05:44 Duration: 53s81ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-06 23:13:43 Duration: 52s556ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-06 20:10:00 Duration: 374ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
8 2s998ms 39s250ms 17s376ms 6 1m44s 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 #8
Day Hour Count Duration Avg duration Sep 06 20 3 52s652ms 17s550ms 23 3 51s607ms 17s202ms [ User: intelifix - Total duration: 1m44s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m44s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-06 20:06:26 Duration: 39s250ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:14:25 Duration: 38s418ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 20:10:11 Duration: 10s373ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
9 2s161ms 31s307ms 13s579ms 6 1m21s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 06 20 3 41s94ms 13s698ms 23 3 40s384ms 13s461ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-06 20:06:59 Duration: 31s307ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-06 23:14:59 Duration: 30s769ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-06 20:10:19 Duration: 7s569ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
10 4s10ms 22s945ms 13s494ms 4 53s976ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 06 20 2 27s72ms 13s536ms 23 2 26s903ms 13s451ms [ User: intelifix - Total duration: 53s976ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 53s976ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-06 20:04:51 Duration: 22s945ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-06 23:12:50 Duration: 22s893ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-06 20:10:00 Duration: 4s126ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
11 3s3ms 31s23ms 13s451ms 6 1m20s 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 #11
Day Hour Count Duration Avg duration Sep 06 20 3 40s373ms 13s457ms 23 3 40s337ms 13s445ms [ User: intelifix - Total duration: 1m20s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m20s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-06 23:17:09 Duration: 31s23ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 20:09:08 Duration: 30s851ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 20:10:41 Duration: 6s507ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
12 2s333ms 23s56ms 11s592ms 6 1m9s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 06 20 3 34s845ms 11s615ms 23 3 34s711ms 11s570ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 20:02:48 Duration: 23s56ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 23:10:48 Duration: 22s866ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 23:32:47 Duration: 9s512ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
13 2s152ms 23s801ms 11s560ms 6 1m9s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 06 20 3 35s26ms 11s675ms 23 3 34s335ms 11s445ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 20:03:29 Duration: 23s801ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 23:11:28 Duration: 23s270ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-06 20:09:41 Duration: 9s46ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
14 1s665ms 26s543ms 10s981ms 6 1m5s 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 #14
Day Hour Count Duration Avg duration Sep 06 20 3 32s352ms 10s784ms 23 3 33s537ms 11s179ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m5s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-06 23:12:27 Duration: 26s543ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 20:04:28 Duration: 25s946ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:33:13 Duration: 4s966ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
15 6s655ms 13s391ms 9s753ms 6 58s518ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 06 00 3 35s59ms 11s686ms 06 3 23s459ms 7s819ms [ User: intelifix - Total duration: 58s518ms - Times executed: 6 ]
[ Application: psql - Total duration: 58s518ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-06 00:05:15 Duration: 13s391ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-06 00:05:26 Duration: 10s931ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-06 00:05:37 Duration: 10s736ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
16 1s726ms 16s453ms 8s385ms 6 50s313ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 06 20 3 25s296ms 8s432ms 23 3 25s17ms 8s339ms [ User: intelifix - Total duration: 50s313ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 50s313ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-06 20:03:46 Duration: 16s453ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:11:44 Duration: 16s135ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:33:06 Duration: 7s154ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
17 1s33ms 16s606ms 6s694ms 6 40s165ms 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 Sep 06 20 3 20s130ms 6s710ms 23 3 20s35ms 6s678ms [ User: intelifix - Total duration: 40s165ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s165ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-06 20:03:05 Duration: 16s606ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:11:05 Duration: 16s528ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 20:09:32 Duration: 2s489ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
18 799ms 12s487ms 4s671ms 6 28s26ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 06 20 3 14s171ms 4s723ms 23 3 13s854ms 4s618ms [ User: intelifix - Total duration: 28s26ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 28s26ms - Times executed: 6 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-09-06 20:04:02 Duration: 12s487ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:12:00 Duration: 12s163ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.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-09-06 23:33:08 Duration: 892ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
19 150ms 25s60ms 2s379ms 193 7m39s call rs_giga_triagem (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 06 00 10 45s591ms 4s559ms 01 11 18s125ms 1s647ms 02 9 18s293ms 2s32ms 03 9 14s960ms 1s662ms 04 9 16s914ms 1s879ms 05 7 17s321ms 2s474ms 06 8 16s893ms 2s111ms 07 7 17s811ms 2s544ms 08 7 17s23ms 2s431ms 09 8 16s766ms 2s95ms 10 8 17s299ms 2s162ms 11 8 17s598ms 2s199ms 12 9 17s654ms 1s961ms 13 7 17s12ms 2s430ms 14 9 16s884ms 1s876ms 15 9 17s405ms 1s933ms 16 8 16s990ms 2s123ms 17 7 17s103ms 2s443ms 18 9 17s674ms 1s963ms 19 7 16s918ms 2s416ms 20 10 51s693ms 5s169ms 21 8 17s693ms 2s211ms 22 9 17s549ms 1s949ms [ User: intelifix - Total duration: 7m39s - Times executed: 193 ]
[ Application: psql - Total duration: 7m39s - Times executed: 193 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-06 00:05:27 Duration: 25s60ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-06 20:05:20 Duration: 18s542ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-06 20:15:16 Duration: 14s300ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
20 569ms 6s128ms 946ms 54 51s85ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 06 08 4 8s723ms 2s180ms 09 3 3s352ms 1s117ms 10 3 2s306ms 768ms 11 4 2s927ms 731ms 12 3 2s393ms 797ms 13 4 3s387ms 846ms 14 4 3s178ms 794ms 15 3 2s143ms 714ms 16 3 2s282ms 760ms 17 4 2s994ms 748ms 18 4 3s133ms 783ms 19 4 3s97ms 774ms 20 4 5s466ms 1s366ms 21 4 3s371ms 842ms 22 3 2s327ms 775ms [ User: intelifix - Total duration: 51s85ms - Times executed: 54 ]
[ Application: psql - Total duration: 51s85ms - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-06 08:00:07 Duration: 6s128ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-06 20:20:04 Duration: 3s142ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-06 09:20:04 Duration: 1s898ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 797ms 3 159ms 434ms 265ms select * from rs_caixa_qr ();Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Sep 06 23 1 204ms 204ms Sep 06 20 1 159ms 159ms 23 1 434ms 434ms [ User: etiquetas - Total duration: 3s150ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 3s150ms - Times executed: 3 ]
-
select * from rs_caixa_qr ();
Date: 2026-09-06 23:49:59 Duration: 434ms Database: postgres User: rio Remote: etiquetas Application: [local] Queryid: [unknown]
-
select * from rs_caixa_qr ();
Date: 2026-09-05 23:38:45 Duration: 204ms Database: postgres User: rio Remote: etiquetas Application: [local] Queryid: [unknown]
-
select * from rs_caixa_qr ();
Date: 2026-09-06 20:25:22 Duration: 159ms Database: postgres User: rio Remote: etiquetas Application: [local] Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 24 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 05 08 1 0ms 0ms 09 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 17 1 0ms 0ms 19 1 0ms 0ms 20 2 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms Sep 06 08 2 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 14 2 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 20 1 0ms 0ms 21 2 0ms 0ms [ User: intelifix - Total duration: 28m45s - Times executed: 24 ]
[ Application: psql - Total duration: 28m45s - Times executed: 24 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 4,722 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 18 FATAL entries
- 1424 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,418 Max number of times the same event was reported
- 1,443 Total events found
Rank Times reported Error 1 1,418 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 06 00 59 01 60 02 59 03 60 04 59 05 60 06 59 07 60 08 59 09 60 10 60 11 59 12 60 13 60 14 59 15 60 16 60 17 59 18 59 19 58 20 60 21 59 22 60 23 50 - ERROR: prepared statement "_PLAN00000000297DF140" does not exist
- ERROR: prepared statement "_PLAN0000000029973A10" does not exist
- ERROR: prepared statement "_PLAN000000002996F110" does not exist
Statement: DEALLOCATE "_PLAN00000000297DF140"
Date: 2026-09-06 00:01:00 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Statement: DEALLOCATE "_PLAN0000000029973A10"
Date: 2026-09-06 00:02:00 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Statement: DEALLOCATE "_PLAN000000002996F110"
Date: 2026-09-06 00:03:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
2 11 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 06 00 1 03 1 06 1 09 1 12 5 21 1 22 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-09-06 00:02:14 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Date: 2026-09-06 03:44:16 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Date: 2026-09-06 06:02:09 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
3 6 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 06 03 6 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-06 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Date: 2026-09-06 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Date: 2026-09-06 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 06 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-06 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-06 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-06 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
5 2 ERROR: prepared statement "..." does not exist/usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 06 18 1 19 1 - ERROR: prepared statement "_PLAN00000000297DACD0" does not exist/usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
- ERROR: prepared statement "_PLAN0000000029973A10" does not exist/usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Statement: DEALLOCATE "_PLAN00000000297DACD0"
Date: 2026-09-06 18:59:52 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Statement: DEALLOCATE "_PLAN0000000029973A10"
Date: 2026-09-06 19:19:59 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
6 1 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 06 03 1 - FATAL: the database system is shutting down
Date: 2026-09-06 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
7 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 06 03 1 - LOG: database system was shut down at 2026-09-06 03:05:02 -03
Date: 2026-09-06 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-06.log