pgBadger-
Global information
- Generated on Mon Aug 3 23:50:14 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 9,100 log entries in 12s
- Log start from 2026-08-02 00:00:45 to 2026-08-02 23:59:17
-
Overview
Global Stats
- 138 Number of unique normalized queries
- 885 Number of queries
- 4h30m41s Total query duration
- 2026-08-02 00:02:03 First query
- 2026-08-02 23:45:01 Last query
- 3 queries/s at 2026-08-02 23:44:29 Query peak
- 4h30m41s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h30m41s Execute total duration
- 1,439 Number of events
- 10 Number of unique normalized events
- 1,320 Max number of times the same event was reported
- 0 Number of cancellation
- 9 Total number of automatic vacuums
- 3 Total number of automatic analyzes
- 10 Number temporary file
- 238.45 MiB Max size of temporary file
- 110.87 MiB Average size of temporary file
- 210 Total number of sessions
- 7 sessions at 2026-08-02 11:22:44 Session peak
- 7d20h12m46s Total duration of sessions
- 53m46s Average duration of sessions
- 4 Average queries per session
- 1m17s Average queries duration per session
- 52m29s Average idle time per session
- 217 Total number of connections
- 7 connections/s at 2026-08-02 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2026-08-02 23:44:29 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-08-02 20:02:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2026-08-02 23:44:29 Date
Queries duration
Key values
- 4h30m41s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 02 00 22 0ms 29s143ms 5s54ms 4s74ms 4s790ms 1m27s 01 12 0ms 4s738ms 2s322ms 4s341ms 4s607ms 5s300ms 02 12 0ms 4s946ms 2s378ms 4s265ms 4s784ms 5s272ms 03 13 0ms 4s627ms 2s161ms 4s29ms 4s903ms 5s342ms 04 12 0ms 4s739ms 2s284ms 4s121ms 4s581ms 5s242ms 05 18 0ms 9m46s 1m4s 5s170ms 2m30s 9m46s 06 17 0ms 10s774ms 3s376ms 3s870ms 4s887ms 33s505ms 07 18 0ms 16m13s 1m22s 6s843ms 2m28s 16m13s 08 21 0ms 6m16s 33s424ms 5s346ms 20s704ms 6m51s 09 21 0ms 6m9s 32s846ms 5s50ms 17s789ms 6m45s 10 21 0ms 6m1s 32s228ms 4s715ms 6s120ms 6m52s 11 25 0ms 5m52s 19s724ms 11s649ms 30s204ms 5m52s 12 21 0ms 17m12s 1m14s 5s350ms 2m30s 17m12s 13 21 0ms 6m11s 32s515ms 4s531ms 16s669ms 6m47s 14 21 0ms 5m39s 29s268ms 3s949ms 45s513ms 5m39s 15 21 0ms 5m30s 28s992ms 3s917ms 44s540ms 5m30s 16 21 0ms 5m43s 29s281ms 3s819ms 44s519ms 5m43s 17 21 0ms 5m22s 28s164ms 4s127ms 15s117ms 5m51s 18 24 0ms 5m33s 25s776ms 4s254ms 50s83ms 5m33s 19 21 0ms 5m42s 29s291ms 4s25ms 45s368ms 5m42s 20 114 0ms 8m32s 12s946ms 1m15s 2m37s 8m32s 21 22 0ms 6m51s 31s116ms 3s825ms 46s937ms 6m51s 22 21 0ms 5m27s 28s482ms 3s862ms 15s46ms 5m57s 23 345 0ms 1m22s 6s39ms 1m3s 1m10s 2m1s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 02 00 4 0 434ms 0ms 0ms 231ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 2 0 159ms 0ms 0ms 0ms 07 6 0 4m1s 0ms 0ms 4m33s 08 6 0 1m50s 0ms 0ms 3m51s 09 6 0 1m49s 0ms 0ms 3m52s 10 6 0 1m46s 0ms 0ms 3m46s 11 6 0 1m7s 0ms 0ms 5m52s 12 6 0 4m13s 0ms 0ms 4m56s 13 6 0 1m48s 0ms 0ms 3m48s 14 6 0 1m37s 0ms 0ms 3m21s 15 6 0 1m37s 0ms 0ms 3m27s 16 6 0 1m37s 0ms 0ms 3m19s 17 6 0 1m34s 0ms 0ms 3m17s 18 9 0 1m5s 0ms 0ms 3m22s 19 6 0 1m38s 0ms 0ms 3m20s 20 16 83 14s464ms 24s97ms 1m14s 3m38s 21 7 0 1m33s 0ms 0ms 3m19s 22 6 0 1m35s 0ms 0ms 3m19s 23 19 326 6s39ms 1m 1m3s 1m29s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 02 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 02 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.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 1 1.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 3 3.00 0.00% Day Hour Count Average / Second Aug 02 00 15 0.00/s 01 8 0.00/s 02 7 0.00/s 03 15 0.00/s 04 8 0.00/s 05 10 0.00/s 06 14 0.00/s 07 8 0.00/s 08 6 0.00/s 09 8 0.00/s 10 8 0.00/s 11 16 0.00/s 12 8 0.00/s 13 7 0.00/s 14 8 0.00/s 15 8 0.00/s 16 8 0.00/s 17 8 0.00/s 18 6 0.00/s 19 8 0.00/s 20 10 0.00/s 21 7 0.00/s 22 7 0.00/s 23 9 0.00/s Day Hour Count Average Duration Average idle time Aug 02 00 3 43m20s 42m43s 01 13 1h1m6s 1h1m4s 02 8 1h23s 1h20s 03 15 23m19s 23m17s 04 7 1h3m 1h2m56s 05 8 54m8s 51m43s 06 9 59m47s 59m41s 07 12 58m50s 56m46s 08 8 1h 58m32s 09 6 56m40s 54m45s 10 8 1h45s 59m20s 11 9 39m54s 38m59s 12 13 1h2m19s 1h19s 13 8 59m34s 58m9s 14 7 58m34s 57m6s 15 8 1h44s 59m28s 16 8 1h23s 59m6s 17 8 55m4s 53m50s 18 8 1h41s 59m24s 19 6 1h1s 58m19s 20 11 44m43s 42m29s 21 7 1h59s 59m21s 22 7 1h18s 58m53s 23 13 35m13s 32m33s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-08-02 03:05:17 Date
Connections per database
Key values
- brasilia Main Database
- 217 connections Total
Connections per user
Key values
- intelifix Main User
- 217 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-08-02 11:22:44 Date
Histogram of session times
Key values
- 171 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 210 sessions Total
Sessions per user
Key values
- intelifix Main User
- 210 sessions Total
Sessions per host
Key values
- [local] Main Host
- 210 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 9,820 buffers Checkpoint Peak
- 2026-08-02 03:05:02 Date
- 269.679 seconds Highest write time
- 0.131 seconds Sync time
Checkpoints Wal files
Key values
- 4 files Wal files usage Peak
- 2026-08-02 03:05:02 Date
Checkpoints distance
Key values
- 104.84 Mo Distance Peak
- 2026-08-02 03:05:02 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 02 00 4,508 269.679s 0.007s 269.707s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 9,820 0.557s 0.006s 0.588s 04 0 0s 0s 0s 05 6,115 612.895s 0.166s 613.133s 06 1,475 147.733s 0.003s 147.745s 07 1,134 113.577s 0.003s 113.587s 08 22 2.236s 0.004s 2.25s 09 22 2.238s 0.003s 2.247s 10 23 2.328s 0.003s 2.337s 11 1,960 194.136s 0.029s 194.272s 12 22 2.226s 0.023s 2.262s 13 25 2.554s 0.024s 2.636s 14 22 2.226s 0.016s 2.268s 15 22 2.243s 0.017s 2.279s 16 23 2.333s 0.005s 2.351s 17 22 2.228s 0.012s 2.26s 18 896 89.87s 0.213s 90.141s 19 23 2.324s 0.011s 2.376s 20 344 34.552s 0.08s 34.71s 21 22 2.226s 0.071s 2.32s 22 23 2.328s 0.019s 2.354s 23 0 0.017s 0.001s 0.067s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 02 00 0 0 1 28 0.001s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 4 48 0.003s 0.002s 04 0 0 0 0 0s 0s 05 0 0 3 145 0.042s 0.01s 06 0 0 0 7 0.001s 0.001s 07 0 0 0 13 0.002s 0.001s 08 0 0 0 3 0.003s 0.002s 09 0 0 0 3 0.002s 0.001s 10 0 0 0 3 0.002s 0.001s 11 0 0 1 19 0.013s 0.008s 12 0 0 0 3 0.015s 0.008s 13 0 0 0 5 0.011s 0.011s 14 0 0 0 3 0.009s 0.006s 15 0 0 0 3 0.010s 0.006s 16 0 0 0 3 0.004s 0.002s 17 0 0 0 3 0.007s 0.004s 18 0 0 0 79 0.068s 0.042s 19 0 0 0 3 0.008s 0.004s 20 0 0 0 16 0.034s 0.019s 21 0 0 0 3 0.065s 0.024s 22 0 0 0 3 0.012s 0.007s 23 0 0 0 1 0.001s 0.001s Day Hour Count Avg time (sec) Aug 02 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Aug 02 00 25,370.00 kB 25,370.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 26,840.00 kB 26,840.00 kB 04 0.00 kB 0.00 kB 05 8,184.67 kB 12,604.00 kB 06 5,106.00 kB 15,115.00 kB 07 5,835.00 kB 14,187.00 kB 08 177.00 kB 12,786.00 kB 09 178.00 kB 11,525.00 kB 10 178.00 kB 10,390.00 kB 11 3,966.50 kB 8,562.50 kB 12 178.00 kB 6,998.00 kB 13 90.00 kB 5,996.00 kB 14 177.00 kB 5,135.00 kB 15 178.00 kB 4,639.00 kB 16 178.00 kB 4,193.00 kB 17 177.00 kB 3,792.00 kB 18 892.75 kB 3,226.75 kB 19 178.00 kB 2,497.00 kB 20 258.00 kB 2,082.67 kB 21 178.00 kB 1,717.00 kB 22 178.00 kB 1,563.00 kB 23 72.00 kB 1,414.00 kB -
Temporary Files
Size of temporary files
Key values
- 476.91 MiB Temp Files size Peak
- 2026-08-02 05:32:00 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-02 05:30:38 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 02 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.08 GiB 110.87 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 926.53 MiB 71.12 MiB 238.45 MiB 115.82 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-02 05:32:08 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-02 05:32:00 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 182.17 MiB 91.09 MiB 91.09 MiB 91.09 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-02 05:30:42 Duration: 39s816ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-02 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 238.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-02 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 238.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-02 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 91.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-02 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 91.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-02 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 78.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-02 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 78.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-02 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 78.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-02 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 71.20 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-02 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 71.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-02 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-02 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.29 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-08-02 05:10:41 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.29 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-08-02 05:10:41 Date
Analyzes per table
Key values
- auditor.auditor_2026_08 (1) Main table analyzed (database contagem)
- 3 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_statistic (1) Main table vacuumed on database rio
- 9 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,321 1,304 4,468,038 1,250 7,453 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 170 20 90,134 5 18 brasilia.auditor.auditor_2026_08 1 0 0 0 0 0 0 661 10 52,747 0 0 contagem.auditor.auditor_2026_08 1 0 0 0 0 0 0 774 16 65,443 0 0 rio.auditor.auditor_2026_08 1 0 0 0 0 0 0 1,343 1,042 1,400,194 120 3,868 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,168 9 167,061 5 44 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,265 16 200,358 11 100 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 136 9 24,849 0 0 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 813 270 1,369,229 159 464 Total 9 6 0 0 0 0 0 11,651 2,696 7,838,053 1,550 11,947 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.29) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_statistic 0 0 0.29 brasilia.pg_toast.pg_toast_2619 0 0 0.02 brasilia.auditor.auditor_2026_08 0 0 0.04 contagem.auditor.auditor_2026_08 0 0 0.1 rio.auditor.auditor_2026_08 0 0 0.21 contagem.pg_catalog.pg_statistic 0 0 0.07 brasilia.pg_catalog.pg_statistic 0 0 0.1 contagem.pg_toast.pg_toast_2619 0 0 0.01 rio.pg_toast.pg_toast_2619 0 0 0.09 Total 0 0 0.93 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4463) Main table with removed tuples on database rio
- 13546 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,463 7,472 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,318 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,939 7,346 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 617 673 0 0 263 contagem.pg_toast.pg_toast_2619 1 1 107 112 0 7 47 brasilia.pg_toast.pg_toast_2619 1 1 102 133 0 29 39 brasilia.auditor.auditor_2026_08 1 0 0 45,530 0 0 1,302 contagem.auditor.auditor_2026_08 1 0 0 53,234 0 0 1,520 rio.auditor.auditor_2026_08 1 0 0 96,802 0 0 3,909 Total 9 6 13,546 218,576 0 36 10,449 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (29) Main table with removed pages on database brasilia
- 36 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed brasilia.pg_toast.pg_toast_2619 1 1 102 29 contagem.pg_toast.pg_toast_2619 1 1 107 7 rio.pg_catalog.pg_statistic 1 1 4463 0 brasilia.auditor.auditor_2026_08 1 0 0 0 contagem.auditor.auditor_2026_08 1 0 0 0 rio.auditor.auditor_2026_08 1 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4318 0 brasilia.pg_catalog.pg_statistic 1 1 3939 0 rio.pg_toast.pg_toast_2619 1 1 617 0 Total 9 6 13,546 36 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 02 00 3 3 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 - 0.29 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 135 Total read queries
- 409 Total write queries
Queries by database
Key values
- rio Main database
- 385 Requests
- 3h6m38s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 872 Requests
User Request type Count Duration etiquetas Total 6 3s277ms select 6 3s277ms intelifix Total 872 4h30m34s copy to 409 43m22s others 341 33m32s select 122 3h13m39s lenon Total 7 2s735ms select 7 2s735ms Duration by user
Key values
- 4h30m34s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 6 3s277ms select 6 3s277ms intelifix Total 872 4h30m34s copy to 409 43m22s others 341 33m32s select 122 3h13m39s lenon Total 7 2s735ms select 7 2s735ms Queries by host
Key values
- [local] Main host
- 885 Requests
- 4h30m41s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 445 Requests
- 3h47m7s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-02 20:06:56 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 345 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 17m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-02 12:22:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 16m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-02 07:21:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m46s analyze verbose;[ Date: 2026-08-02 05:09:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-02 20:13:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-02 21:11:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-02 08:11:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-02 13:11:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-02 09:11:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-02 10:11:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-02 11:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-02 16:10:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-02 19:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-02 14:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-02 18:10:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-02 15:10:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-02 22:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-02 17:10:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m41s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-02 12:30:06 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
19 4m33s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-02 07:28:58 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 4m30s analyze verbose;[ Date: 2026-08-02 05:14:18 - 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 2h4m15s 46 1s306ms 17m12s 2m42s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 02 07 3 17m1s 5m40s 08 3 6m38s 2m12s 09 3 6m28s 2m9s 10 3 6m20s 2m6s 11 2 6m9s 3m4s 12 3 18m6s 6m2s 13 3 6m29s 2m9s 14 3 5m56s 1m58s 15 3 5m46s 1m55s 16 3 5m59s 1m59s 17 3 5m39s 1m53s 18 3 5m52s 1m57s 19 3 5m58s 1m59s 20 2 8m57s 4m28s 21 3 7m8s 2m22s 22 3 5m44s 1m54s [ User: intelifix - Total duration: 2h4m15s - Times executed: 46 ]
[ Application: psql - Total duration: 2h4m15s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-02 12:22:14 Duration: 17m12s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-02 07:21:14 Duration: 16m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-02 20:13:34 Duration: 8m32s Database: rio User: intelifix Remote: [local] Application: psql
2 1h9m7s 46 189ms 4m41s 1m30s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 02 07 3 7m4s 2m21s 08 3 4m25s 1m28s 09 3 4m27s 1m29s 10 3 4m18s 1m26s 11 1 31s369ms 31s369ms 12 3 7m13s 2m24s 13 3 4m23s 1m27s 14 3 3m49s 1m16s 15 3 3m55s 1m18s 16 3 3m48s 1m16s 17 3 3m44s 1m14s 18 3 3m54s 1m18s 19 3 3m49s 1m16s 20 3 6m 2m 21 3 3m49s 1m16s 22 3 3m48s 1m16s [ User: intelifix - Total duration: 1h9m7s - Times executed: 46 ]
[ Application: psql - Total duration: 1h9m7s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-02 12:30:06 Duration: 4m41s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-02 07:28:58 Duration: 4m33s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-02 09:15:55 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
3 16m47s 3 2m30s 9m46s 5m35s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 02 05 3 16m47s 5m35s [ User: intelifix - Total duration: 16m47s - Times executed: 3 ]
[ Application: psql - Total duration: 16m47s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-02 05:09:48 Duration: 9m46s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-02 05:14:18 Duration: 4m30s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-02 05:16:49 Duration: 2m30s Database: contagem User: intelifix Remote: [local] Application: psql
4 11m18s 274 163ms 29s143ms 2s475ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 02 00 12 53s702ms 4s475ms 01 12 27s873ms 2s322ms 02 12 28s542ms 2s378ms 03 12 27s641ms 2s303ms 04 12 27s418ms 2s284ms 05 12 26s769ms 2s230ms 06 12 28s70ms 2s339ms 07 12 31s866ms 2s655ms 08 12 31s13ms 2s584ms 09 12 29s801ms 2s483ms 10 12 29s774ms 2s481ms 11 10 47s512ms 4s751ms 12 12 29s851ms 2s487ms 13 12 26s766ms 2s230ms 14 12 23s784ms 1s982ms 15 12 23s649ms 1s970ms 16 12 24s527ms 2s43ms 17 12 24s615ms 2s51ms 18 12 26s346ms 2s195ms 19 12 24s26ms 2s2ms 20 12 38s61ms 3s171ms 21 12 23s673ms 1s972ms 22 12 23s88ms 1s924ms [ User: intelifix - Total duration: 11m18s - Times executed: 274 ]
[ Application: psql - Total duration: 11m18s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-02 00:05:31 Duration: 29s143ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-02 11:25:28 Duration: 27s374ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-02 20:15:17 Duration: 16s129ms Database: rio User: intelifix Remote: [local] Application: psql
5 3m2s 4 4s812ms 1m30s 45s665ms 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 Aug 02 20 2 1m35s 47s688ms 23 2 1m27s 43s642ms [ User: intelifix - Total duration: 3m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m2s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-02 20:08:39 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-02 23:16:18 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-02 23:34:11 Duration: 4s976ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 1m59s 9 9s47ms 19s691ms 13s327ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 02 00 3 53s975ms 17s991ms 06 3 29s13ms 9s671ms 11 3 36s954ms 12s318ms [ User: intelifix - Total duration: 1m59s - Times executed: 9 ]
[ Application: psql - Total duration: 1m59s - Times executed: 9 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-02 00:05:21 Duration: 19s691ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-02 00:05:56 Duration: 17s983ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-02 00:05:38 Duration: 16s299ms Database: brasilia User: intelifix Remote: [local] Application: psql
7 1m51s 4 404ms 56s630ms 27s990ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 02 20 2 57s70ms 28s535ms 23 2 54s892ms 27s446ms [ User: intelifix - Total duration: 1m51s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m51s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-02 20:05:23 Duration: 56s630ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-02 23:13:19 Duration: 54s487ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-02 20:09:49 Duration: 439ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m28s 6 2s923ms 33s247ms 14s681ms 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 Aug 02 20 3 44s596ms 14s865ms 23 3 43s492ms 14s497ms [ User: intelifix - Total duration: 1m28s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m28s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-02 20:05:57 Duration: 33s247ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-02 23:13:52 Duration: 30s282ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-02 23:33:44 Duration: 9s886ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1m26s 1 1m26s 1m26s 1m26s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 02 05 1 1m26s 1m26s [ User: intelifix - Total duration: 1m26s - Times executed: 1 ]
[ Application: psql - Total duration: 1m26s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-02 05:32:08 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-02 05:32:00 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
10 1m12s 6 1s734ms 28s393ms 12s117ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 02 20 3 35s368ms 11s789ms 23 3 37s336ms 12s445ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m12s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-02 23:14:23 Duration: 28s393ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-02 20:06:29 Duration: 27s564ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-02 23:33:51 Duration: 7s40ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 1m8s 6 2s658ms 26s525ms 11s451ms 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 Aug 02 20 3 33s340ms 11s113ms 23 3 35s368ms 11s789ms [ User: intelifix - Total duration: 1m8s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m8s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-02 23:16:45 Duration: 26s525ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-02 20:09:04 Duration: 24s893ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-02 23:34:17 Duration: 6s185ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1m8s 35 635ms 18s328ms 1s954ms 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 #12
Day Hour Count Duration Avg duration Aug 02 08 2 6s11ms 3s5ms 09 1 1s3ms 1s3ms 10 3 7s911ms 2s637ms 11 2 5s143ms 2s571ms 12 3 20s212ms 6s737ms 13 3 2s957ms 985ms 14 2 3s984ms 1s992ms 15 2 1s705ms 852ms 16 2 1s905ms 952ms 17 3 2s637ms 879ms 18 3 2s505ms 835ms 19 2 2s272ms 1s136ms 20 3 5s928ms 1s976ms 21 2 2s242ms 1s121ms 22 2 1s993ms 996ms [ User: intelifix - Total duration: 1m8s - Times executed: 35 ]
[ Application: psql - Total duration: 1m8s - Times executed: 35 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-02 12:40:19 Duration: 18s328ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-02 10:20:07 Duration: 5s956ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-02 08:00:06 Duration: 4s576ms Database: rio User: intelifix Remote: [local] Application: psql
13 57s932ms 6 1s789ms 19s161ms 9s655ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 02 20 3 28s601ms 9s533ms 23 3 29s331ms 9s777ms [ User: intelifix - Total duration: 57s932ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s932ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 20:02:42 Duration: 19s161ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 23:10:42 Duration: 18s609ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 23:33:05 Duration: 8s751ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 57s436ms 6 1s663ms 19s893ms 9s572ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 02 20 3 27s7ms 9s2ms 23 3 30s428ms 10s142ms [ User: intelifix - Total duration: 57s436ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s436ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 23:11:16 Duration: 19s893ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 20:03:16 Duration: 18s103ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 23:33:16 Duration: 8s872ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 53s454ms 6 1s527ms 21s675ms 8s909ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 02 20 3 25s922ms 8s640ms 23 3 27s531ms 9s177ms [ User: intelifix - Total duration: 53s454ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 53s454ms - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-02 23:12:06 Duration: 21s675ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-02 20:04:05 Duration: 19s883ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-02 23:33:29 Duration: 4s328ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 45s920ms 4 3s360ms 20s308ms 11s480ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 02 20 2 23s668ms 11s834ms 23 2 22s251ms 11s125ms [ User: intelifix - Total duration: 45s920ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 45s920ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-02 20:04:26 Duration: 20s308ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-02 23:12:25 Duration: 18s662ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-02 23:33:33 Duration: 3s588ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 42s256ms 6 1s314ms 13s897ms 7s42ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 02 20 3 21s537ms 7s179ms 23 3 20s719ms 6s906ms [ User: intelifix - Total duration: 42s256ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 42s256ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-02 20:03:30 Duration: 13s897ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-02 23:11:29 Duration: 13s313ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-02 23:33:22 Duration: 6s91ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 39s816ms 1 39s816ms 39s816ms 39s816ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 02 05 1 39s816ms 39s816ms [ User: intelifix - Total duration: 39s816ms - Times executed: 1 ]
[ Application: psql - Total duration: 39s816ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-02 05:30:42 Duration: 39s816ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-02 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
19 36s271ms 6 1s141ms 15s776ms 6s45ms 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 Aug 02 20 3 19s168ms 6s389ms 23 3 17s102ms 5s700ms [ User: intelifix - Total duration: 36s271ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 36s271ms - 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-08-02 20:02:58 Duration: 15s776ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-08-02 23:10:56 Duration: 13s720ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-08-02 20:09:25 Duration: 2s249ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 34s28ms 6 2s690ms 7s718ms 5s671ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 02 20 3 18s85ms 6s28ms 23 3 15s942ms 5s314ms [ User: intelifix - Total duration: 34s28ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 34s28ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-02 20:10:16 Duration: 7s718ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-02 20:06:55 Duration: 7s676ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-02 23:34:04 Duration: 7s670ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 274 11m18s 163ms 29s143ms 2s475ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 02 00 12 53s702ms 4s475ms 01 12 27s873ms 2s322ms 02 12 28s542ms 2s378ms 03 12 27s641ms 2s303ms 04 12 27s418ms 2s284ms 05 12 26s769ms 2s230ms 06 12 28s70ms 2s339ms 07 12 31s866ms 2s655ms 08 12 31s13ms 2s584ms 09 12 29s801ms 2s483ms 10 12 29s774ms 2s481ms 11 10 47s512ms 4s751ms 12 12 29s851ms 2s487ms 13 12 26s766ms 2s230ms 14 12 23s784ms 1s982ms 15 12 23s649ms 1s970ms 16 12 24s527ms 2s43ms 17 12 24s615ms 2s51ms 18 12 26s346ms 2s195ms 19 12 24s26ms 2s2ms 20 12 38s61ms 3s171ms 21 12 23s673ms 1s972ms 22 12 23s88ms 1s924ms [ User: intelifix - Total duration: 11m18s - Times executed: 274 ]
[ Application: psql - Total duration: 11m18s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-02 00:05:31 Duration: 29s143ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-02 11:25:28 Duration: 27s374ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-02 20:15:17 Duration: 16s129ms Database: rio User: intelifix Remote: [local] Application: psql
2 46 2h4m15s 1s306ms 17m12s 2m42s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 02 07 3 17m1s 5m40s 08 3 6m38s 2m12s 09 3 6m28s 2m9s 10 3 6m20s 2m6s 11 2 6m9s 3m4s 12 3 18m6s 6m2s 13 3 6m29s 2m9s 14 3 5m56s 1m58s 15 3 5m46s 1m55s 16 3 5m59s 1m59s 17 3 5m39s 1m53s 18 3 5m52s 1m57s 19 3 5m58s 1m59s 20 2 8m57s 4m28s 21 3 7m8s 2m22s 22 3 5m44s 1m54s [ User: intelifix - Total duration: 2h4m15s - Times executed: 46 ]
[ Application: psql - Total duration: 2h4m15s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-02 12:22:14 Duration: 17m12s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-02 07:21:14 Duration: 16m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-02 20:13:34 Duration: 8m32s Database: rio User: intelifix Remote: [local] Application: psql
3 46 1h9m7s 189ms 4m41s 1m30s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 02 07 3 7m4s 2m21s 08 3 4m25s 1m28s 09 3 4m27s 1m29s 10 3 4m18s 1m26s 11 1 31s369ms 31s369ms 12 3 7m13s 2m24s 13 3 4m23s 1m27s 14 3 3m49s 1m16s 15 3 3m55s 1m18s 16 3 3m48s 1m16s 17 3 3m44s 1m14s 18 3 3m54s 1m18s 19 3 3m49s 1m16s 20 3 6m 2m 21 3 3m49s 1m16s 22 3 3m48s 1m16s [ User: intelifix - Total duration: 1h9m7s - Times executed: 46 ]
[ Application: psql - Total duration: 1h9m7s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-02 12:30:06 Duration: 4m41s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-02 07:28:58 Duration: 4m33s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-02 09:15:55 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
4 35 1m8s 635ms 18s328ms 1s954ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 02 08 2 6s11ms 3s5ms 09 1 1s3ms 1s3ms 10 3 7s911ms 2s637ms 11 2 5s143ms 2s571ms 12 3 20s212ms 6s737ms 13 3 2s957ms 985ms 14 2 3s984ms 1s992ms 15 2 1s705ms 852ms 16 2 1s905ms 952ms 17 3 2s637ms 879ms 18 3 2s505ms 835ms 19 2 2s272ms 1s136ms 20 3 5s928ms 1s976ms 21 2 2s242ms 1s121ms 22 2 1s993ms 996ms [ User: intelifix - Total duration: 1m8s - Times executed: 35 ]
[ Application: psql - Total duration: 1m8s - Times executed: 35 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-02 12:40:19 Duration: 18s328ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-02 10:20:07 Duration: 5s956ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-02 08:00:06 Duration: 4s576ms Database: rio User: intelifix Remote: [local] Application: psql
5 9 1m59s 9s47ms 19s691ms 13s327ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 02 00 3 53s975ms 17s991ms 06 3 29s13ms 9s671ms 11 3 36s954ms 12s318ms [ User: intelifix - Total duration: 1m59s - Times executed: 9 ]
[ Application: psql - Total duration: 1m59s - Times executed: 9 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-02 00:05:21 Duration: 19s691ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-02 00:05:56 Duration: 17s983ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-02 00:05:38 Duration: 16s299ms Database: brasilia User: intelifix Remote: [local] Application: psql
6 9 8s436ms 677ms 1s797ms 937ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 02 08 1 1s12ms 1s12ms 09 2 2s623ms 1s311ms 14 1 735ms 735ms 15 1 1s81ms 1s81ms 16 1 758ms 758ms 19 1 807ms 807ms 21 1 739ms 739ms 22 1 677ms 677ms [ User: intelifix - Total duration: 8s436ms - Times executed: 9 ]
[ Application: psql - Total duration: 8s436ms - Times executed: 9 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-02 09:00:03 Duration: 1s797ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-02 15:40:02 Duration: 1s81ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-02 08:40:02 Duration: 1s12ms Database: rio User: intelifix Remote: [local] Application: psql
7 7 2s735ms 158ms 1s95ms 390ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 02 00 3 1s505ms 501ms 06 2 318ms 159ms 11 2 911ms 455ms [ User: lenon - Total duration: 2s735ms - Times executed: 7 ]
[ Application: psql - Total duration: 2s735ms - Times executed: 7 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-02 00:02:03 Duration: 1s95ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-02 11:21:42 Duration: 492ms Database: contagem User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-02 11:21:41 Duration: 419ms Database: rio User: lenon Remote: [local] Application: psql
8 7 2s27ms 157ms 387ms 289ms 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 #8
Day Hour Count Duration Avg duration Aug 02 20 3 882ms 294ms 23 4 1s145ms 286ms [ User: intelifix - Total duration: 2s27ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s27ms - Times executed: 7 ]
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-02 23:10:03 Duration: 387ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-02 20:02:02 Duration: 378ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-02 23:16:46 Duration: 315ms Database: rio User: intelifix Remote: [local] Application: pg_dump
9 6 1m28s 2s923ms 33s247ms 14s681ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 02 20 3 44s596ms 14s865ms 23 3 43s492ms 14s497ms [ User: intelifix - Total duration: 1m28s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m28s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-02 20:05:57 Duration: 33s247ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-02 23:13:52 Duration: 30s282ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-02 23:33:44 Duration: 9s886ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 6 1m12s 1s734ms 28s393ms 12s117ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 02 20 3 35s368ms 11s789ms 23 3 37s336ms 12s445ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m12s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-02 23:14:23 Duration: 28s393ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-02 20:06:29 Duration: 27s564ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-02 23:33:51 Duration: 7s40ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 1m8s 2s658ms 26s525ms 11s451ms 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 Aug 02 20 3 33s340ms 11s113ms 23 3 35s368ms 11s789ms [ User: intelifix - Total duration: 1m8s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m8s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-02 23:16:45 Duration: 26s525ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-02 20:09:04 Duration: 24s893ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-02 23:34:17 Duration: 6s185ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 6 57s932ms 1s789ms 19s161ms 9s655ms 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 Aug 02 20 3 28s601ms 9s533ms 23 3 29s331ms 9s777ms [ User: intelifix - Total duration: 57s932ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s932ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 20:02:42 Duration: 19s161ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 23:10:42 Duration: 18s609ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 23:33:05 Duration: 8s751ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 57s436ms 1s663ms 19s893ms 9s572ms 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 Aug 02 20 3 27s7ms 9s2ms 23 3 30s428ms 10s142ms [ User: intelifix - Total duration: 57s436ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s436ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 23:11:16 Duration: 19s893ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 20:03:16 Duration: 18s103ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 23:33:16 Duration: 8s872ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 53s454ms 1s527ms 21s675ms 8s909ms 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 Aug 02 20 3 25s922ms 8s640ms 23 3 27s531ms 9s177ms [ User: intelifix - Total duration: 53s454ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 53s454ms - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-02 23:12:06 Duration: 21s675ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-02 20:04:05 Duration: 19s883ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-02 23:33:29 Duration: 4s328ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 42s256ms 1s314ms 13s897ms 7s42ms 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 #15
Day Hour Count Duration Avg duration Aug 02 20 3 21s537ms 7s179ms 23 3 20s719ms 6s906ms [ User: intelifix - Total duration: 42s256ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 42s256ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-02 20:03:30 Duration: 13s897ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-02 23:11:29 Duration: 13s313ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-02 23:33:22 Duration: 6s91ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 36s271ms 1s141ms 15s776ms 6s45ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 02 20 3 19s168ms 6s389ms 23 3 17s102ms 5s700ms [ User: intelifix - Total duration: 36s271ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 36s271ms - 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-08-02 20:02:58 Duration: 15s776ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-08-02 23:10:56 Duration: 13s720ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-08-02 20:09:25 Duration: 2s249ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 6 34s28ms 2s690ms 7s718ms 5s671ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 02 20 3 18s85ms 6s28ms 23 3 15s942ms 5s314ms [ User: intelifix - Total duration: 34s28ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 34s28ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-02 20:10:16 Duration: 7s718ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-02 20:06:55 Duration: 7s676ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-02 23:34:04 Duration: 7s670ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 25s714ms 799ms 11s98ms 4s285ms 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 Aug 02 20 3 12s955ms 4s318ms 23 3 12s758ms 4s252ms [ User: intelifix - Total duration: 25s714ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 25s714ms - 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-08-02 20:03:46 Duration: 11s98ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-08-02 23:11:45 Duration: 11s22ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-08-02 20:09:41 Duration: 1s58ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 25s103ms 781ms 9s150ms 4s183ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 02 20 3 11s859ms 3s953ms 23 3 13s244ms 4s414ms [ User: intelifix - Total duration: 25s103ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 25s103ms - Times executed: 6 ]
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-08-02 23:10:20 Duration: 9s150ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-08-02 20:02:19 Duration: 8s987ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-08-02 23:32:55 Duration: 3s182ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 14s864ms 2s287ms 2s685ms 2s477ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 02 20 3 7s229ms 2s409ms 23 3 7s635ms 2s545ms [ User: intelifix - Total duration: 14s864ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 14s864ms - Times executed: 6 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-08-02 23:32:51 Duration: 2s685ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-08-02 23:43:59 Duration: 2s534ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-08-02 20:02:09 Duration: 2s516ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m30s 9m46s 5m35s 3 16m47s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 02 05 3 16m47s 5m35s [ User: intelifix - Total duration: 16m47s - Times executed: 3 ]
[ Application: psql - Total duration: 16m47s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-02 05:09:48 Duration: 9m46s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-02 05:14:18 Duration: 4m30s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-02 05:16:49 Duration: 2m30s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s306ms 17m12s 2m42s 46 2h4m15s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 02 07 3 17m1s 5m40s 08 3 6m38s 2m12s 09 3 6m28s 2m9s 10 3 6m20s 2m6s 11 2 6m9s 3m4s 12 3 18m6s 6m2s 13 3 6m29s 2m9s 14 3 5m56s 1m58s 15 3 5m46s 1m55s 16 3 5m59s 1m59s 17 3 5m39s 1m53s 18 3 5m52s 1m57s 19 3 5m58s 1m59s 20 2 8m57s 4m28s 21 3 7m8s 2m22s 22 3 5m44s 1m54s [ User: intelifix - Total duration: 2h4m15s - Times executed: 46 ]
[ Application: psql - Total duration: 2h4m15s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-02 12:22:14 Duration: 17m12s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-02 07:21:14 Duration: 16m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-02 20:13:34 Duration: 8m32s Database: rio User: intelifix Remote: [local] Application: psql
3 189ms 4m41s 1m30s 46 1h9m7s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 02 07 3 7m4s 2m21s 08 3 4m25s 1m28s 09 3 4m27s 1m29s 10 3 4m18s 1m26s 11 1 31s369ms 31s369ms 12 3 7m13s 2m24s 13 3 4m23s 1m27s 14 3 3m49s 1m16s 15 3 3m55s 1m18s 16 3 3m48s 1m16s 17 3 3m44s 1m14s 18 3 3m54s 1m18s 19 3 3m49s 1m16s 20 3 6m 2m 21 3 3m49s 1m16s 22 3 3m48s 1m16s [ User: intelifix - Total duration: 1h9m7s - Times executed: 46 ]
[ Application: psql - Total duration: 1h9m7s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-02 12:30:06 Duration: 4m41s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-02 07:28:58 Duration: 4m33s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-02 09:15:55 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
4 1m26s 1m26s 1m26s 1 1m26s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 02 05 1 1m26s 1m26s [ User: intelifix - Total duration: 1m26s - Times executed: 1 ]
[ Application: psql - Total duration: 1m26s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-02 05:32:08 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-02 05:32:00 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
5 4s812ms 1m30s 45s665ms 4 3m2s 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 Aug 02 20 2 1m35s 47s688ms 23 2 1m27s 43s642ms [ User: intelifix - Total duration: 3m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m2s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-02 20:08:39 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-02 23:16:18 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-02 23:34:11 Duration: 4s976ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 39s816ms 39s816ms 39s816ms 1 39s816ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 02 05 1 39s816ms 39s816ms [ User: intelifix - Total duration: 39s816ms - Times executed: 1 ]
[ Application: psql - Total duration: 39s816ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-02 05:30:42 Duration: 39s816ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-02 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
7 404ms 56s630ms 27s990ms 4 1m51s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 02 20 2 57s70ms 28s535ms 23 2 54s892ms 27s446ms [ User: intelifix - Total duration: 1m51s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m51s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-02 20:05:23 Duration: 56s630ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-02 23:13:19 Duration: 54s487ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-02 20:09:49 Duration: 439ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 2s923ms 33s247ms 14s681ms 6 1m28s 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 Aug 02 20 3 44s596ms 14s865ms 23 3 43s492ms 14s497ms [ User: intelifix - Total duration: 1m28s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m28s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-02 20:05:57 Duration: 33s247ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-02 23:13:52 Duration: 30s282ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-02 23:33:44 Duration: 9s886ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 9s47ms 19s691ms 13s327ms 9 1m59s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 02 00 3 53s975ms 17s991ms 06 3 29s13ms 9s671ms 11 3 36s954ms 12s318ms [ User: intelifix - Total duration: 1m59s - Times executed: 9 ]
[ Application: psql - Total duration: 1m59s - Times executed: 9 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-02 00:05:21 Duration: 19s691ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-02 00:05:56 Duration: 17s983ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-02 00:05:38 Duration: 16s299ms Database: brasilia User: intelifix Remote: [local] Application: psql
10 1s734ms 28s393ms 12s117ms 6 1m12s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 02 20 3 35s368ms 11s789ms 23 3 37s336ms 12s445ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m12s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-02 23:14:23 Duration: 28s393ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-02 20:06:29 Duration: 27s564ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-02 23:33:51 Duration: 7s40ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 3s360ms 20s308ms 11s480ms 4 45s920ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 02 20 2 23s668ms 11s834ms 23 2 22s251ms 11s125ms [ User: intelifix - Total duration: 45s920ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 45s920ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-02 20:04:26 Duration: 20s308ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-02 23:12:25 Duration: 18s662ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-02 23:33:33 Duration: 3s588ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s658ms 26s525ms 11s451ms 6 1m8s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 02 20 3 33s340ms 11s113ms 23 3 35s368ms 11s789ms [ User: intelifix - Total duration: 1m8s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m8s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-02 23:16:45 Duration: 26s525ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-02 20:09:04 Duration: 24s893ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-02 23:34:17 Duration: 6s185ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1s789ms 19s161ms 9s655ms 6 57s932ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 02 20 3 28s601ms 9s533ms 23 3 29s331ms 9s777ms [ User: intelifix - Total duration: 57s932ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s932ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 20:02:42 Duration: 19s161ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 23:10:42 Duration: 18s609ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 23:33:05 Duration: 8s751ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1s663ms 19s893ms 9s572ms 6 57s436ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 02 20 3 27s7ms 9s2ms 23 3 30s428ms 10s142ms [ User: intelifix - Total duration: 57s436ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s436ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 23:11:16 Duration: 19s893ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 20:03:16 Duration: 18s103ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-02 23:33:16 Duration: 8s872ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1s527ms 21s675ms 8s909ms 6 53s454ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 02 20 3 25s922ms 8s640ms 23 3 27s531ms 9s177ms [ User: intelifix - Total duration: 53s454ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 53s454ms - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-02 23:12:06 Duration: 21s675ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-02 20:04:05 Duration: 19s883ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-02 23:33:29 Duration: 4s328ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1s314ms 13s897ms 7s42ms 6 42s256ms 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 Aug 02 20 3 21s537ms 7s179ms 23 3 20s719ms 6s906ms [ User: intelifix - Total duration: 42s256ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 42s256ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-02 20:03:30 Duration: 13s897ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-02 23:11:29 Duration: 13s313ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-02 23:33:22 Duration: 6s91ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1s141ms 15s776ms 6s45ms 6 36s271ms 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 Aug 02 20 3 19s168ms 6s389ms 23 3 17s102ms 5s700ms [ User: intelifix - Total duration: 36s271ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 36s271ms - 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-08-02 20:02:58 Duration: 15s776ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-08-02 23:10:56 Duration: 13s720ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-08-02 20:09:25 Duration: 2s249ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 2s690ms 7s718ms 5s671ms 6 34s28ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 02 20 3 18s85ms 6s28ms 23 3 15s942ms 5s314ms [ User: intelifix - Total duration: 34s28ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 34s28ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-02 20:10:16 Duration: 7s718ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-02 20:06:55 Duration: 7s676ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-02 23:34:04 Duration: 7s670ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 799ms 11s98ms 4s285ms 6 25s714ms 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 #19
Day Hour Count Duration Avg duration Aug 02 20 3 12s955ms 4s318ms 23 3 12s758ms 4s252ms [ User: intelifix - Total duration: 25s714ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 25s714ms - 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-08-02 20:03:46 Duration: 11s98ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-08-02 23:11:45 Duration: 11s22ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-08-02 20:09:41 Duration: 1s58ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 781ms 9s150ms 4s183ms 6 25s103ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 02 20 3 11s859ms 3s953ms 23 3 13s244ms 4s414ms [ User: intelifix - Total duration: 25s103ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 25s103ms - Times executed: 6 ]
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-08-02 23:10:20 Duration: 9s150ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-08-02 20:02:19 Duration: 8s987ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-08-02 23:32:55 Duration: 3s182ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 8 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 02 09 2 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 19 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 18s787ms - Times executed: 8 ]
[ Application: psql - Total duration: 18s787ms - Times executed: 8 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 4,871 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 23 FATAL entries
- 1414 ERROR entries
- 0 WARNING entries
- 2 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,320 Max number of times the same event was reported
- 1,439 Total events found
Rank Times reported Error 1 1,320 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 02 00 57 01 55 02 54 03 51 04 54 05 55 06 55 07 57 08 55 09 57 10 56 11 49 12 56 13 53 14 55 15 57 16 56 17 56 18 58 19 56 20 56 21 56 22 52 23 54 - ERROR: prepared statement "_PLAN000000004115F4F0" does not exist
- ERROR: prepared statement "_PLAN0000000041160730" does not exist
- ERROR: prepared statement "_PLAN0000000041160BC0" does not exist
Statement: DEALLOCATE "_PLAN000000004115F4F0"
Date: 2026-08-02 00:00:45 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000041160730"
Date: 2026-08-02 00:01:48 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000041160BC0"
Date: 2026-08-02 00:02:51 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
2 44 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 02 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 1 10 1 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-02 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-02 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-02 01:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
3 42 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 02 08 3 09 2 10 3 11 2 12 3 13 3 14 3 15 3 16 2 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-08-02 08:00:07 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-08-02 08:20:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-08-02 08:40:03 Database: brasilia Application: psql User: intelifix Remote: [local]
4 13 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 02 03 7 11 6 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-02 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-02 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-02 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
5 6 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 02 00 1 04 1 06 2 10 1 11 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-08-02 00:02:04 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-02 04:07:08 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-02 06:02:02 Database: testes Application: [unknown] User: lenon Remote: [local]
6 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 02 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-02 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-02 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-02 05:32:08 Database: contagem Application: psql User: intelifix Remote: [local]
7 4 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 02 03 3 11 1 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-02 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-02 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-02 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 2 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 02 03 1 11 1 - LOG: database system was shut down at 2026-08-02 03:05:02 -03
- LOG: database system was shut down at 2026-08-02 11:13:16 -03
Date: 2026-08-02 03:05:03
Date: 2026-08-02 11:21:26
9 2 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 02 09 1 10 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-02 09:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-02 10:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
10 2 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 02 09 1 16 1 - ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
- ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-08-02 09:00:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-08-02 16:40:03 Database: brasilia Application: psql User: intelifix Remote: [local]