pgBadger-
Global information
- Generated on Mon Jul 20 23:50:11 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 9,297 log entries in 10s
- Log start from 2026-07-19 00:00:16 to 2026-07-19 23:59:17
-
Overview
Global Stats
- 140 Number of unique normalized queries
- 870 Number of queries
- 4h23s Total query duration
- 2026-07-19 00:02:12 First query
- 2026-07-19 23:41:59 Last query
- 4 queries/s at 2026-07-19 23:41:54 Query peak
- 4h23s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h23s Execute total duration
- 1,535 Number of events
- 8 Number of unique normalized events
- 1,426 Max number of times the same event was reported
- 0 Number of cancellation
- 7 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 10 Number temporary file
- 236.02 MiB Max size of temporary file
- 109.76 MiB Average size of temporary file
- 211 Total number of sessions
- 7 sessions at 2026-07-19 06:25:05 Session peak
- 7d20h49m30s Total duration of sessions
- 53m41s Average duration of sessions
- 4 Average queries per session
- 1m8s Average queries duration per session
- 52m33s Average idle time per session
- 213 Total number of connections
- 4 connections/s at 2026-07-19 00:05:02 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-19 23:41:54 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-07-19 09:14:15 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-19 23:41:54 Date
Queries duration
Key values
- 4h23s 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) Jul 19 00 23 0ms 18s736ms 4s903ms 4s87ms 4s399ms 1m12s 01 15 0ms 4s930ms 1s811ms 3s827ms 4s91ms 5s144ms 02 12 0ms 4s289ms 2s133ms 3s986ms 4s303ms 4s547ms 03 14 0ms 4s693ms 1s865ms 3s713ms 4s78ms 5s677ms 04 11 0ms 4s397ms 2s324ms 3s663ms 4s459ms 4s634ms 05 17 0ms 9m23s 1m5s 5s334ms 2m27s 9m23s 06 18 0ms 10s395ms 4s8ms 3s987ms 4s912ms 32s163ms 07 18 0ms 11m24s 59s809ms 4s672ms 1m30s 11m24s 08 21 0ms 5m35s 29s223ms 4s328ms 42s416ms 5m35s 09 21 0ms 5m11s 27s770ms 4s161ms 4s961ms 5m55s 10 21 0ms 5m37s 29s36ms 4s408ms 44s864ms 5m37s 11 21 0ms 5m46s 29s458ms 5s457ms 43s722ms 5m46s 12 21 0ms 5m21s 28s80ms 4s286ms 15s377ms 5m51s 13 20 0ms 5m39s 30s945ms 4s617ms 46s717ms 5m39s 14 20 0ms 5m47s 31s7ms 4s367ms 46s655ms 5m47s 15 20 0ms 5m48s 31s388ms 4s919ms 46s331ms 5m48s 16 21 0ms 5m30s 28s849ms 4s902ms 46s329ms 5m30s 17 20 0ms 5m46s 31s259ms 4s461ms 44s676ms 5m46s 18 23 0ms 5m38s 26s712ms 4s330ms 44s944ms 5m38s 19 21 0ms 5m43s 29s550ms 4s493ms 45s696ms 5m43s 20 112 0ms 7m3s 12s215ms 1m7s 1m34s 7m3s 21 22 0ms 7m29s 32s355ms 4s354ms 14s470ms 7m56s 22 19 0ms 5m22s 32s47ms 4s177ms 14s445ms 5m51s 23 339 0ms 1m24s 5s622ms 1m3s 1m7s 2m Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 19 00 5 0 3s991ms 0ms 0ms 559ms 01 2 0 574ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 201ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 6s202ms 0ms 0ms 0ms 07 6 0 2m54s 0ms 0ms 3m56s 08 6 0 1m36s 0ms 0ms 3m22s 09 6 0 1m32s 0ms 0ms 3m18s 10 6 0 1m36s 0ms 0ms 3m18s 11 6 0 1m37s 0ms 0ms 3m15s 12 6 0 1m33s 0ms 0ms 3m13s 13 6 0 1m37s 0ms 0ms 3m21s 14 6 0 1m38s 0ms 0ms 3m15s 15 6 0 1m39s 0ms 0ms 3m22s 16 6 0 1m35s 0ms 0ms 3m17s 17 6 0 1m39s 0ms 0ms 3m23s 18 9 0 1m5s 0ms 0ms 3m19s 19 6 0 1m38s 0ms 0ms 3m23s 20 19 79 13s536ms 38s620ms 1m6s 3m47s 21 7 0 1m37s 0ms 0ms 3m12s 22 6 0 1m36s 0ms 0ms 3m35s 23 17 322 5s622ms 1m1s 1m3s 1m30s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 19 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 Jul 19 00 0 1 1.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 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 Jul 19 00 15 0.00/s 01 10 0.00/s 02 8 0.00/s 03 15 0.00/s 04 8 0.00/s 05 9 0.00/s 06 15 0.00/s 07 7 0.00/s 08 8 0.00/s 09 7 0.00/s 10 7 0.00/s 11 9 0.00/s 12 7 0.00/s 13 8 0.00/s 14 7 0.00/s 15 9 0.00/s 16 8 0.00/s 17 7 0.00/s 18 8 0.00/s 19 8 0.00/s 20 12 0.00/s 21 6 0.00/s 22 7 0.00/s 23 8 0.00/s Day Hour Count Average Duration Average idle time Jul 19 00 4 47m30s 47m2s 01 13 1h1m9s 1h1m7s 02 10 1h54s 1h52s 03 16 22m12s 22m11s 04 7 1h3m 1h2m56s 05 8 1h45s 58m25s 06 9 58m21s 58m13s 07 14 1h52s 59m35s 08 7 56m8s 54m41s 09 8 1h39s 59m26s 10 8 54m8s 52m51s 11 7 52m51s 51m23s 12 8 1h1m2s 59m49s 13 8 53m45s 52m27s 14 7 1h 58m32s 15 8 54m7s 52m49s 16 8 1h46s 59m31s 17 8 1h43s 59m25s 18 8 53m45s 52m28s 19 7 1h1s 58m33s 20 11 45m8s 43m3s 21 8 1h24s 58m55s 22 6 1h54s 59m12s 23 13 34m59s 32m33s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-07-19 00:05:02 Date
Connections per database
Key values
- rio Main Database
- 213 connections Total
Connections per user
Key values
- intelifix Main User
- 213 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-07-19 06:25:05 Date
Histogram of session times
Key values
- 177 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 211 sessions Total
Sessions per user
Key values
- intelifix Main User
- 211 sessions Total
Sessions per host
Key values
- [local] Main Host
- 211 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 10,130 buffers Checkpoint Peak
- 2026-07-19 01:14:56 Date
- 269.928 seconds Highest write time
- 0.285 seconds Sync time
Checkpoints Wal files
Key values
- 25 files Wal files usage Peak
- 2026-07-19 05:14:10 Date
Checkpoints distance
Key values
- 797.75 Mo Distance Peak
- 2026-07-19 05:14:10 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 19 00 7,795 269.235s 0.005s 269.251s 01 10,130 269.928s 0.003s 269.941s 02 0 0s 0s 0s 03 0 0.06s 0.005s 0.083s 04 0 0s 0s 0s 05 6,717 673.434s 0.309s 673.894s 06 3,019 269.233s 0.003s 269.245s 07 1,152 115.434s 0.002s 115.441s 08 22 2.231s 0.003s 2.24s 09 21 2.13s 0.004s 2.141s 10 21 2.136s 0.003s 2.147s 11 22 2.235s 0.003s 2.245s 12 21 2.129s 0.004s 2.14s 13 21 2.133s 0.004s 2.144s 14 21 2.131s 0.004s 2.142s 15 22 2.233s 0.004s 2.244s 16 21 2.131s 0.004s 2.143s 17 21 2.133s 0.004s 2.145s 18 819 82.166s 0.009s 82.206s 19 21 2.13s 0.004s 2.144s 20 101 10.202s 0.011s 10.241s 21 45 4.585s 0.009s 4.611s 22 21 2.131s 0.004s 2.142s 23 4 0.438s 0.003s 0.454s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 19 00 0 0 3 32 0.001s 0.001s 01 0 0 3 47 0.001s 0.001s 02 0 0 0 0 0s 0s 03 0 0 0 3 0.003s 0.002s 04 0 0 0 0 0s 0s 05 0 0 26 159 0.133s 0.016s 06 0 0 1 10 0.001s 0.001s 07 0 0 0 13 0.001s 0.001s 08 0 0 0 3 0.002s 0.001s 09 0 0 0 3 0.002s 0.002s 10 0 0 0 3 0.002s 0.001s 11 0 0 0 3 0.002s 0.001s 12 0 0 0 3 0.002s 0.002s 13 0 0 0 3 0.003s 0.002s 14 0 0 0 3 0.002s 0.002s 15 0 0 0 3 0.003s 0.002s 16 0 0 0 3 0.002s 0.002s 17 0 0 0 3 0.002s 0.002s 18 0 0 1 78 0.002s 0.004s 19 0 0 0 3 0.002s 0.002s 20 0 0 0 11 0.003s 0.004s 21 0 0 0 18 0.003s 0.003s 22 0 0 0 3 0.003s 0.002s 23 0 0 0 5 0.002s 0.003s Day Hour Count Avg time (sec) Jul 19 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 Jul 19 00 39,174.00 kB 39,174.00 kB 01 54,106.00 kB 54,106.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 24,347.50 kB 04 0.00 kB 0.00 kB 05 72,554.33 kB 236,186.17 kB 06 6,322.00 kB 270,058.00 kB 07 6,313.00 kB 243,684.00 kB 08 169.00 kB 219,332.00 kB 09 168.00 kB 197,416.00 kB 10 168.00 kB 177,691.00 kB 11 169.00 kB 159,939.00 kB 12 168.00 kB 143,962.00 kB 13 168.00 kB 129,582.00 kB 14 169.00 kB 116,641.00 kB 15 169.00 kB 104,994.00 kB 16 168.00 kB 94,511.00 kB 17 169.00 kB 85,077.00 kB 18 844.25 kB 66,101.75 kB 19 168.00 kB 50,483.00 kB 20 252.33 kB 41,080.33 kB 21 74.33 kB 29,996.67 kB 22 168.00 kB 24,227.00 kB 23 38.00 kB 20,718.00 kB -
Temporary Files
Size of temporary files
Key values
- 472.03 MiB Temp Files size Peak
- 2026-07-19 05:31:58 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-19 05:32:03 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 19 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.07 GiB 109.76 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 917.06 MiB 70.40 MiB 236.02 MiB 114.63 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-19 05:32:05 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-19 05:31:58 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 180.58 MiB 90.29 MiB 90.29 MiB 90.29 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-19 05:30:41 Duration: 39s195ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-19 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 236.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-19 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 236.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-19 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 90.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-19 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 90.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-19 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 77.98 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-19 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 77.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-19 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 77.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-19 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 70.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-19 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 70.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-19 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 70.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-19 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 44.63 sec Highest CPU-cost vacuum
Table public.fluxos
Database rio - 2026-07-19 05:07:24 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 44.63 sec Highest CPU-cost vacuum
Table public.fluxos
Database rio - 2026-07-19 05:07:24 Date
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database brasilia
- 7 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 181 22 89,513 9 42 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,317 37 283,761 30 266 rio.public.fluxos 1 1 0 0 0 0 0 154,188 105,306 400,180,383 5,665 183,820 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 124 23 70,000 9 17 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,294 228 927,632 208 1,712 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,038 283 1,434,941 261 1,630 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 829 114 750,074 81 292 Total 7 7 0 0 0 0 0 162,971 106,013 403,736,304 6,263 187,779 Vacuum throughput per table
Key values
- public.fluxos (44.63) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed brasilia.pg_toast.pg_toast_2619 0 0 0.03 brasilia.pg_catalog.pg_statistic 0 0 0.1 rio.public.fluxos 0 0 44.63 contagem.pg_toast.pg_toast_2619 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.13 rio.pg_catalog.pg_statistic 0 0 0.2 rio.pg_toast.pg_toast_2619 0 0 0.07 Total 0 0 45.16 Tuples removed per table
Key values
- public.fluxos (66268) Main table with removed tuples on database rio
- 80030 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.public.fluxos 1 1 66,268 5,068,101 0 0 62,234 rio.pg_catalog.pg_statistic 1 1 4,490 7,510 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,415 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 4,000 7,332 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 634 676 0 37 247 brasilia.pg_toast.pg_toast_2619 1 1 126 129 0 26 40 contagem.pg_toast.pg_toast_2619 1 1 97 116 0 0 51 Total 7 7 80,030 5,091,138 0 63 65,941 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (37) Main table with removed pages on database rio
- 63 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_toast.pg_toast_2619 1 1 634 37 brasilia.pg_toast.pg_toast_2619 1 1 126 26 brasilia.pg_catalog.pg_statistic 1 1 4000 0 rio.public.fluxos 1 1 66268 0 contagem.pg_toast.pg_toast_2619 1 1 97 0 contagem.pg_catalog.pg_statistic 1 1 4415 0 rio.pg_catalog.pg_statistic 1 1 4490 0 Total 7 7 80,030 63 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 19 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 7 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 - 44.63 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
- 141 Total read queries
- 402 Total write queries
Queries by database
Key values
- rio Main database
- 393 Requests
- 2h40m59s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 853 Requests
User Request type Count Duration etiquetas Total 10 3s311ms select 10 3s311ms intelifix Total 853 3h59m41s copy to 401 40m51s ddl 1 762ms others 327 30m49s select 124 2h48m lenon Total 7 38s414ms select 7 38s414ms Duration by user
Key values
- 3h59m41s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 10 3s311ms select 10 3s311ms intelifix Total 853 3h59m41s copy to 401 40m51s ddl 1 762ms others 327 30m49s select 124 2h48m lenon Total 7 38s414ms select 7 38s414ms Queries by host
Key values
- [local] Main host
- 870 Requests
- 4h23s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 433 Requests
- 3h19m21s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-19 14:37:10 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 356 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 11m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-19 07:16:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m23s analyze verbose;[ Date: 2026-07-19 05:09:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-19 21:12:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-19 20:12:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-19 15:10:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-19 14:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-19 17:10:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-19 11:10:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-19 19:10:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-19 13:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-19 18:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-19 10:10:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-19 08:10:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-19 16:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-19 22:10:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-19 12:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-19 09:10:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m10s analyze verbose;[ Date: 2026-07-19 05:13:35 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
19 3m48s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-07-19 07:22:23 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m40s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-07-19 20:17:48 - 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 1h43m55s 48 1s217ms 11m24s 2m9s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 07 3 12m7s 4m2s 08 3 5m53s 1m57s 09 3 5m29s 1m49s 10 3 5m53s 1m57s 11 3 6m1s 2m 12 3 5m38s 1m52s 13 3 5m56s 1m58s 14 3 6m4s 2m1s 15 3 6m4s 2m1s 16 3 5m49s 1m56s 17 3 6m3s 2m1s 18 3 5m54s 1m58s 19 3 5m59s 1m59s 20 3 7m35s 2m31s 21 3 7m44s 2m34s 22 3 5m38s 1m52s [ User: intelifix - Total duration: 1h43m55s - Times executed: 48 ]
[ Application: psql - Total duration: 1h43m55s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-19 07:16:26 Duration: 11m24s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-19 21:12:30 Duration: 7m29s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-19 20:12:04 Duration: 7m3s Database: rio User: intelifix Remote: [local] Application: psql
2 1h3m55s 48 173ms 3m48s 1m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 07 3 5m21s 1m47s 08 3 3m47s 1m15s 09 3 3m45s 1m15s 10 3 3m47s 1m15s 11 3 3m43s 1m14s 12 3 3m42s 1m14s 13 3 3m50s 1m16s 14 3 3m45s 1m15s 15 3 3m53s 1m17s 16 3 3m45s 1m15s 17 3 3m51s 1m17s 18 3 3m48s 1m16s 19 3 3m52s 1m17s 20 3 5m17s 1m45s 21 3 3m38s 1m12s 22 3 4m2s 1m20s [ User: intelifix - Total duration: 1h3m55s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m55s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-19 07:22:23 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-19 20:17:48 Duration: 3m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-19 22:14:40 Duration: 3m32s Database: brasilia User: intelifix Remote: [local] Application: psql
3 16m2s 3 2m27s 9m23s 5m20s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 05 3 16m2s 5m20s [ User: intelifix - Total duration: 16m2s - Times executed: 3 ]
[ Application: psql - Total duration: 16m2s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-19 05:09:25 Duration: 9m23s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-19 05:13:35 Duration: 4m10s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-19 05:16:03 Duration: 2m27s Database: contagem User: intelifix Remote: [local] Application: psql
4 10m32s 267 153ms 18s8ms 2s368ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 19 00 12 40s791ms 3s399ms 01 12 25s266ms 2s105ms 02 12 25s600ms 2s133ms 03 12 25s599ms 2s133ms 04 11 25s572ms 2s324ms 05 12 28s522ms 2s376ms 06 12 25s720ms 2s143ms 07 12 27s168ms 2s264ms 08 12 26s430ms 2s202ms 09 12 26s344ms 2s195ms 10 12 25s595ms 2s132ms 11 12 30s350ms 2s529ms 12 12 26s149ms 2s179ms 13 11 28s976ms 2s634ms 14 11 25s739ms 2s339ms 15 11 26s481ms 2s407ms 16 12 28s122ms 2s343ms 17 11 27s306ms 2s482ms 18 11 25s568ms 2s324ms 19 12 25s512ms 2s126ms 20 11 36s369ms 3s306ms 21 12 24s803ms 2s66ms 22 10 24s520ms 2s452ms [ User: intelifix - Total duration: 10m32s - Times executed: 267 ]
[ Application: psql - Total duration: 10m32s - Times executed: 267 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-19 00:05:20 Duration: 18s8ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-19 20:15:15 Duration: 13s685ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-19 20:35:06 Duration: 5s714ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m59s 4 4s379ms 1m26s 44s822ms 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 Jul 19 20 2 1m30s 45s355ms 23 2 1m28s 44s289ms [ User: intelifix - Total duration: 2m59s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m59s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-19 20:08:59 Duration: 1m26s 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-07-19 23:16:15 Duration: 1m24s 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-07-19 23:33:04 Duration: 4s568ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 2m 4 300ms 1m4s 30s69ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 19 20 2 1m5s 32s524ms 23 2 55s231ms 27s615ms [ User: intelifix - Total duration: 2m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-19 20:05:45 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-19 23:13:15 Duration: 54s930ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-19 20:10:14 Duration: 409ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 1m30s 6 2s536ms 36s404ms 15s11ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 19 20 3 48s11ms 16s3ms 23 3 42s56ms 14s18ms [ User: intelifix - Total duration: 1m30s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m30s - 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-07-19 20:06:23 Duration: 36s404ms 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-07-19 23:13:47 Duration: 30s724ms 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-07-19 20:10:23 Duration: 8s868ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m24s 1 1m24s 1m24s 1m24s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 19 05 1 1m24s 1m24s [ User: intelifix - Total duration: 1m24s - Times executed: 1 ]
[ Application: psql - Total duration: 1m24s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-19 05:32:05 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-19 05:31:58 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
9 1m18s 6 8s408ms 18s736ms 13s106ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 19 00 3 50s807ms 16s935ms 06 3 27s830ms 9s276ms [ User: intelifix - Total duration: 1m18s - Times executed: 6 ]
[ Application: psql - Total duration: 1m18s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-19 00:05:21 Duration: 18s736ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-19 00:05:53 Duration: 16s908ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-19 00:05:36 Duration: 15s161ms Database: brasilia User: intelifix Remote: [local] Application: psql
10 1m10s 6 1s745ms 27s267ms 11s779ms 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 Jul 19 20 3 35s609ms 11s869ms 23 3 35s68ms 11s689ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-19 23:14:18 Duration: 27s267ms 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-07-19 20:06:53 Duration: 27s47ms 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-07-19 20:10:30 Duration: 6s679ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 1m8s 6 2s595ms 27s48ms 11s422ms 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 Jul 19 20 3 35s256ms 11s752ms 23 3 33s277ms 11s92ms [ 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-07-19 20:09:26 Duration: 27s48ms 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-07-19 23:16:40 Duration: 25s88ms 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-07-19 23:33:10 Duration: 5s592ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1m 6 1s712ms 21s189ms 10s106ms 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 Jul 19 20 3 30s530ms 10s176ms 23 3 30s108ms 10s36ms [ User: intelifix - Total duration: 1m - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-19 20:02:47 Duration: 21s189ms 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-07-19 23:10:42 Duration: 19s610ms 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-07-19 23:32:07 Duration: 8s47ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 58s49ms 6 1s441ms 21s811ms 9s674ms 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 Jul 19 20 3 30s877ms 10s292ms 23 3 27s172ms 9s57ms [ User: intelifix - Total duration: 58s49ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s49ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-19 20:03:24 Duration: 21s811ms 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-07-19 23:11:14 Duration: 18s503ms 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-07-19 20:09:55 Duration: 7s396ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 54s486ms 6 1s454ms 23s515ms 9s81ms 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 Jul 19 20 3 30s604ms 10s201ms 23 3 23s881ms 7s960ms [ User: intelifix - Total duration: 54s486ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 54s486ms - 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-07-19 20:04:18 Duration: 23s515ms 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-07-19 23:12:01 Duration: 18s571ms 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-07-19 20:10:09 Duration: 5s587ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 48s676ms 4 3s127ms 22s730ms 12s169ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 19 20 2 26s461ms 13s230ms 23 2 22s214ms 11s107ms [ User: intelifix - Total duration: 48s676ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 48s676ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-19 20:04:40 Duration: 22s730ms 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-07-19 23:12:20 Duration: 19s87ms 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-07-19 20:10:13 Duration: 3s731ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 41s307ms 6 1s314ms 13s633ms 6s884ms 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 Jul 19 20 3 20s423ms 6s807ms 23 3 20s884ms 6s961ms [ User: intelifix - Total duration: 41s307ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s307ms - 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-07-19 20:03:37 Duration: 13s633ms 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-07-19 23:11:27 Duration: 12s831ms 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-07-19 23:32:23 Duration: 6s626ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 40s258ms 37 620ms 4s266ms 1s88ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 19 08 3 6s236ms 2s78ms 09 3 2s593ms 864ms 10 3 3s45ms 1s15ms 11 2 1s967ms 983ms 12 2 1s722ms 861ms 13 2 2s277ms 1s138ms 14 3 3s989ms 1s329ms 15 3 2s787ms 929ms 16 3 3s7ms 1s2ms 17 3 3s91ms 1s30ms 18 1 1s36ms 1s36ms 19 2 1s811ms 905ms 20 2 1s730ms 865ms 21 2 1s869ms 934ms 22 3 3s91ms 1s30ms [ User: intelifix - Total duration: 40s258ms - Times executed: 37 ]
[ Application: psql - Total duration: 40s258ms - Times executed: 37 ]
-
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-07-19 08:00:05 Duration: 4s266ms 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-07-19 14:20:03 Duration: 2s215ms 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-07-19 13:40:02 Duration: 1s214ms Database: rio User: intelifix Remote: [local] Application: psql
18 39s195ms 1 39s195ms 39s195ms 39s195ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 19 05 1 39s195ms 39s195ms [ User: intelifix - Total duration: 39s195ms - Times executed: 1 ]
[ Application: psql - Total duration: 39s195ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-19 05:30:41 Duration: 39s195ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-19 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
19 38s4ms 6 4s78ms 10s189ms 6s334ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 19 00 3 19s397ms 6s465ms 06 3 18s607ms 6s202ms [ User: lenon - Total duration: 38s4ms - Times executed: 6 ]
[ Application: psql - Total duration: 38s4ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-19 06:02:11 Duration: 10s189ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-19 00:02:12 Duration: 10s157ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-19 00:02:21 Duration: 5s148ms Database: contagem User: lenon Remote: [local] Application: psql
20 34s15ms 6 955ms 14s857ms 5s669ms 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 #20
Day Hour Count Duration Avg duration Jul 19 20 3 17s850ms 5s950ms 23 3 16s164ms 5s388ms [ User: intelifix - Total duration: 34s15ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 34s15ms - 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-07-19 20:03:02 Duration: 14s857ms 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-07-19 23:10:55 Duration: 13s192ms 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-07-19 23:32:09 Duration: 2s16ms 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 267 10m32s 153ms 18s8ms 2s368ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 00 12 40s791ms 3s399ms 01 12 25s266ms 2s105ms 02 12 25s600ms 2s133ms 03 12 25s599ms 2s133ms 04 11 25s572ms 2s324ms 05 12 28s522ms 2s376ms 06 12 25s720ms 2s143ms 07 12 27s168ms 2s264ms 08 12 26s430ms 2s202ms 09 12 26s344ms 2s195ms 10 12 25s595ms 2s132ms 11 12 30s350ms 2s529ms 12 12 26s149ms 2s179ms 13 11 28s976ms 2s634ms 14 11 25s739ms 2s339ms 15 11 26s481ms 2s407ms 16 12 28s122ms 2s343ms 17 11 27s306ms 2s482ms 18 11 25s568ms 2s324ms 19 12 25s512ms 2s126ms 20 11 36s369ms 3s306ms 21 12 24s803ms 2s66ms 22 10 24s520ms 2s452ms [ User: intelifix - Total duration: 10m32s - Times executed: 267 ]
[ Application: psql - Total duration: 10m32s - Times executed: 267 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-19 00:05:20 Duration: 18s8ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-19 20:15:15 Duration: 13s685ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-19 20:35:06 Duration: 5s714ms Database: rio User: intelifix Remote: [local] Application: psql
2 48 1h43m55s 1s217ms 11m24s 2m9s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 07 3 12m7s 4m2s 08 3 5m53s 1m57s 09 3 5m29s 1m49s 10 3 5m53s 1m57s 11 3 6m1s 2m 12 3 5m38s 1m52s 13 3 5m56s 1m58s 14 3 6m4s 2m1s 15 3 6m4s 2m1s 16 3 5m49s 1m56s 17 3 6m3s 2m1s 18 3 5m54s 1m58s 19 3 5m59s 1m59s 20 3 7m35s 2m31s 21 3 7m44s 2m34s 22 3 5m38s 1m52s [ User: intelifix - Total duration: 1h43m55s - Times executed: 48 ]
[ Application: psql - Total duration: 1h43m55s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-19 07:16:26 Duration: 11m24s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-19 21:12:30 Duration: 7m29s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-19 20:12:04 Duration: 7m3s Database: rio User: intelifix Remote: [local] Application: psql
3 48 1h3m55s 173ms 3m48s 1m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 07 3 5m21s 1m47s 08 3 3m47s 1m15s 09 3 3m45s 1m15s 10 3 3m47s 1m15s 11 3 3m43s 1m14s 12 3 3m42s 1m14s 13 3 3m50s 1m16s 14 3 3m45s 1m15s 15 3 3m53s 1m17s 16 3 3m45s 1m15s 17 3 3m51s 1m17s 18 3 3m48s 1m16s 19 3 3m52s 1m17s 20 3 5m17s 1m45s 21 3 3m38s 1m12s 22 3 4m2s 1m20s [ User: intelifix - Total duration: 1h3m55s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m55s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-19 07:22:23 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-19 20:17:48 Duration: 3m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-19 22:14:40 Duration: 3m32s Database: brasilia User: intelifix Remote: [local] Application: psql
4 37 40s258ms 620ms 4s266ms 1s88ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 19 08 3 6s236ms 2s78ms 09 3 2s593ms 864ms 10 3 3s45ms 1s15ms 11 2 1s967ms 983ms 12 2 1s722ms 861ms 13 2 2s277ms 1s138ms 14 3 3s989ms 1s329ms 15 3 2s787ms 929ms 16 3 3s7ms 1s2ms 17 3 3s91ms 1s30ms 18 1 1s36ms 1s36ms 19 2 1s811ms 905ms 20 2 1s730ms 865ms 21 2 1s869ms 934ms 22 3 3s91ms 1s30ms [ User: intelifix - Total duration: 40s258ms - Times executed: 37 ]
[ Application: psql - Total duration: 40s258ms - Times executed: 37 ]
-
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-07-19 08:00:05 Duration: 4s266ms 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-07-19 14:20:03 Duration: 2s215ms 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-07-19 13:40:02 Duration: 1s214ms Database: rio User: intelifix Remote: [local] Application: psql
5 8 10s31ms 659ms 3s466ms 1s253ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 19 11 1 783ms 783ms 12 1 1s203ms 1s203ms 13 1 659ms 659ms 18 2 1s718ms 859ms 19 1 1s160ms 1s160ms 20 1 3s466ms 3s466ms 21 1 1s38ms 1s38ms [ User: intelifix - Total duration: 10s31ms - Times executed: 8 ]
[ Application: psql - Total duration: 10s31ms - Times executed: 8 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-19 20:20:05 Duration: 3s466ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-19 12:40:02 Duration: 1s203ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-19 19:20:02 Duration: 1s160ms Database: rio User: intelifix Remote: [local] Application: psql
6 7 1s843ms 169ms 313ms 263ms 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 #6
Day Hour Count Duration Avg duration Jul 19 20 3 758ms 252ms 23 4 1s85ms 271ms [ User: intelifix - Total duration: 1s843ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 1s843ms - 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-07-19 20:02:02 Duration: 313ms 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-07-19 23:10:02 Duration: 294ms 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-07-19 23:41:01 Duration: 288ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 6 1m30s 2s536ms 36s404ms 15s11ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 19 20 3 48s11ms 16s3ms 23 3 42s56ms 14s18ms [ User: intelifix - Total duration: 1m30s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m30s - 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-07-19 20:06:23 Duration: 36s404ms 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-07-19 23:13:47 Duration: 30s724ms 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-07-19 20:10:23 Duration: 8s868ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 6 1m18s 8s408ms 18s736ms 13s106ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 19 00 3 50s807ms 16s935ms 06 3 27s830ms 9s276ms [ User: intelifix - Total duration: 1m18s - Times executed: 6 ]
[ Application: psql - Total duration: 1m18s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-19 00:05:21 Duration: 18s736ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-19 00:05:53 Duration: 16s908ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-19 00:05:36 Duration: 15s161ms Database: brasilia User: intelifix Remote: [local] Application: psql
9 6 1m10s 1s745ms 27s267ms 11s779ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 19 20 3 35s609ms 11s869ms 23 3 35s68ms 11s689ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-19 23:14:18 Duration: 27s267ms 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-07-19 20:06:53 Duration: 27s47ms 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-07-19 20:10:30 Duration: 6s679ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 6 1m8s 2s595ms 27s48ms 11s422ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 19 20 3 35s256ms 11s752ms 23 3 33s277ms 11s92ms [ 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-07-19 20:09:26 Duration: 27s48ms 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-07-19 23:16:40 Duration: 25s88ms 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-07-19 23:33:10 Duration: 5s592ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 1m 1s712ms 21s189ms 10s106ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 19 20 3 30s530ms 10s176ms 23 3 30s108ms 10s36ms [ User: intelifix - Total duration: 1m - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-19 20:02:47 Duration: 21s189ms 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-07-19 23:10:42 Duration: 19s610ms 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-07-19 23:32:07 Duration: 8s47ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 6 58s49ms 1s441ms 21s811ms 9s674ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 19 20 3 30s877ms 10s292ms 23 3 27s172ms 9s57ms [ User: intelifix - Total duration: 58s49ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s49ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-19 20:03:24 Duration: 21s811ms 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-07-19 23:11:14 Duration: 18s503ms 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-07-19 20:09:55 Duration: 7s396ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 54s486ms 1s454ms 23s515ms 9s81ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 19 20 3 30s604ms 10s201ms 23 3 23s881ms 7s960ms [ User: intelifix - Total duration: 54s486ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 54s486ms - 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-07-19 20:04:18 Duration: 23s515ms 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-07-19 23:12:01 Duration: 18s571ms 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-07-19 20:10:09 Duration: 5s587ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 41s307ms 1s314ms 13s633ms 6s884ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 19 20 3 20s423ms 6s807ms 23 3 20s884ms 6s961ms [ User: intelifix - Total duration: 41s307ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s307ms - 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-07-19 20:03:37 Duration: 13s633ms 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-07-19 23:11:27 Duration: 12s831ms 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-07-19 23:32:23 Duration: 6s626ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 38s4ms 4s78ms 10s189ms 6s334ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 19 00 3 19s397ms 6s465ms 06 3 18s607ms 6s202ms [ User: lenon - Total duration: 38s4ms - Times executed: 6 ]
[ Application: psql - Total duration: 38s4ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-19 06:02:11 Duration: 10s189ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-19 00:02:12 Duration: 10s157ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-19 00:02:21 Duration: 5s148ms Database: contagem User: lenon Remote: [local] Application: psql
16 6 34s15ms 955ms 14s857ms 5s669ms 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 Jul 19 20 3 17s850ms 5s950ms 23 3 16s164ms 5s388ms [ User: intelifix - Total duration: 34s15ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 34s15ms - 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-07-19 20:03:02 Duration: 14s857ms 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-07-19 23:10:55 Duration: 13s192ms 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-07-19 23:32:09 Duration: 2s16ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 6 32s255ms 2s103ms 8s295ms 5s375ms 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 Jul 19 20 3 18s572ms 6s190ms 23 3 13s683ms 4s561ms [ User: intelifix - Total duration: 32s255ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 32s255ms - 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-07-19 20:07:20 Duration: 8s295ms 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-07-19 20:10:40 Duration: 6s893ms 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-07-19 23:14:39 Duration: 6s692ms Database: rio User: intelifix Remote: [local] Application: pg_dump
18 6 27s467ms 964ms 11s974ms 4s577ms 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 #18
Day Hour Count Duration Avg duration Jul 19 20 3 15s361ms 5s120ms 23 3 12s106ms 4s35ms [ User: intelifix - Total duration: 27s467ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s467ms - 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-07-19 20:02:22 Duration: 11s974ms 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-07-19 23:10:19 Duration: 9s203ms 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-07-19 20:09:37 Duration: 2s352ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 25s944ms 735ms 11s342ms 4s324ms 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 Jul 19 20 3 13s248ms 4s416ms 23 3 12s696ms 4s232ms [ User: intelifix - Total duration: 25s944ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 25s944ms - 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-07-19 20:03:54 Duration: 11s342ms 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-07-19 23:11:42 Duration: 11s141ms 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-07-19 20:10:04 Duration: 1s169ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 15s220ms 497ms 5s463ms 2s536ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 19 20 3 8s399ms 2s799ms 23 3 6s821ms 2s273ms [ User: intelifix - Total duration: 15s220ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 15s220ms - Times executed: 6 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-07-19 20:03:43 Duration: 5s463ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-07-19 23:11:31 Duration: 4s370ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-07-19 20:10:03 Duration: 2s438ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m27s 9m23s 5m20s 3 16m2s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 05 3 16m2s 5m20s [ User: intelifix - Total duration: 16m2s - Times executed: 3 ]
[ Application: psql - Total duration: 16m2s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-19 05:09:25 Duration: 9m23s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-19 05:13:35 Duration: 4m10s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-19 05:16:03 Duration: 2m27s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s217ms 11m24s 2m9s 48 1h43m55s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 07 3 12m7s 4m2s 08 3 5m53s 1m57s 09 3 5m29s 1m49s 10 3 5m53s 1m57s 11 3 6m1s 2m 12 3 5m38s 1m52s 13 3 5m56s 1m58s 14 3 6m4s 2m1s 15 3 6m4s 2m1s 16 3 5m49s 1m56s 17 3 6m3s 2m1s 18 3 5m54s 1m58s 19 3 5m59s 1m59s 20 3 7m35s 2m31s 21 3 7m44s 2m34s 22 3 5m38s 1m52s [ User: intelifix - Total duration: 1h43m55s - Times executed: 48 ]
[ Application: psql - Total duration: 1h43m55s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-19 07:16:26 Duration: 11m24s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-19 21:12:30 Duration: 7m29s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-19 20:12:04 Duration: 7m3s Database: rio User: intelifix Remote: [local] Application: psql
3 1m24s 1m24s 1m24s 1 1m24s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 05 1 1m24s 1m24s [ User: intelifix - Total duration: 1m24s - Times executed: 1 ]
[ Application: psql - Total duration: 1m24s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-19 05:32:05 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-19 05:31:58 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 173ms 3m48s 1m19s 48 1h3m55s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 19 07 3 5m21s 1m47s 08 3 3m47s 1m15s 09 3 3m45s 1m15s 10 3 3m47s 1m15s 11 3 3m43s 1m14s 12 3 3m42s 1m14s 13 3 3m50s 1m16s 14 3 3m45s 1m15s 15 3 3m53s 1m17s 16 3 3m45s 1m15s 17 3 3m51s 1m17s 18 3 3m48s 1m16s 19 3 3m52s 1m17s 20 3 5m17s 1m45s 21 3 3m38s 1m12s 22 3 4m2s 1m20s [ User: intelifix - Total duration: 1h3m55s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m55s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-19 07:22:23 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-19 20:17:48 Duration: 3m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-19 22:14:40 Duration: 3m32s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s379ms 1m26s 44s822ms 4 2m59s 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 Jul 19 20 2 1m30s 45s355ms 23 2 1m28s 44s289ms [ User: intelifix - Total duration: 2m59s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m59s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-19 20:08:59 Duration: 1m26s 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-07-19 23:16:15 Duration: 1m24s 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-07-19 23:33:04 Duration: 4s568ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 39s195ms 39s195ms 39s195ms 1 39s195ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 19 05 1 39s195ms 39s195ms [ User: intelifix - Total duration: 39s195ms - Times executed: 1 ]
[ Application: psql - Total duration: 39s195ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-19 05:30:41 Duration: 39s195ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-19 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
7 300ms 1m4s 30s69ms 4 2m copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 19 20 2 1m5s 32s524ms 23 2 55s231ms 27s615ms [ User: intelifix - Total duration: 2m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-19 20:05:45 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-19 23:13:15 Duration: 54s930ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-19 20:10:14 Duration: 409ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 2s536ms 36s404ms 15s11ms 6 1m30s 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 Jul 19 20 3 48s11ms 16s3ms 23 3 42s56ms 14s18ms [ User: intelifix - Total duration: 1m30s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m30s - 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-07-19 20:06:23 Duration: 36s404ms 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-07-19 23:13:47 Duration: 30s724ms 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-07-19 20:10:23 Duration: 8s868ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 8s408ms 18s736ms 13s106ms 6 1m18s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 19 00 3 50s807ms 16s935ms 06 3 27s830ms 9s276ms [ User: intelifix - Total duration: 1m18s - Times executed: 6 ]
[ Application: psql - Total duration: 1m18s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-19 00:05:21 Duration: 18s736ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-19 00:05:53 Duration: 16s908ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-19 00:05:36 Duration: 15s161ms Database: brasilia User: intelifix Remote: [local] Application: psql
10 3s127ms 22s730ms 12s169ms 4 48s676ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 19 20 2 26s461ms 13s230ms 23 2 22s214ms 11s107ms [ User: intelifix - Total duration: 48s676ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 48s676ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-19 20:04:40 Duration: 22s730ms 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-07-19 23:12:20 Duration: 19s87ms 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-07-19 20:10:13 Duration: 3s731ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 1s745ms 27s267ms 11s779ms 6 1m10s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 19 20 3 35s609ms 11s869ms 23 3 35s68ms 11s689ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-19 23:14:18 Duration: 27s267ms 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-07-19 20:06:53 Duration: 27s47ms 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-07-19 20:10:30 Duration: 6s679ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s595ms 27s48ms 11s422ms 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 Jul 19 20 3 35s256ms 11s752ms 23 3 33s277ms 11s92ms [ 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-07-19 20:09:26 Duration: 27s48ms 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-07-19 23:16:40 Duration: 25s88ms 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-07-19 23:33:10 Duration: 5s592ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1s712ms 21s189ms 10s106ms 6 1m 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 Jul 19 20 3 30s530ms 10s176ms 23 3 30s108ms 10s36ms [ User: intelifix - Total duration: 1m - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-19 20:02:47 Duration: 21s189ms 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-07-19 23:10:42 Duration: 19s610ms 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-07-19 23:32:07 Duration: 8s47ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1s441ms 21s811ms 9s674ms 6 58s49ms 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 Jul 19 20 3 30s877ms 10s292ms 23 3 27s172ms 9s57ms [ User: intelifix - Total duration: 58s49ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s49ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-19 20:03:24 Duration: 21s811ms 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-07-19 23:11:14 Duration: 18s503ms 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-07-19 20:09:55 Duration: 7s396ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1s454ms 23s515ms 9s81ms 6 54s486ms 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 Jul 19 20 3 30s604ms 10s201ms 23 3 23s881ms 7s960ms [ User: intelifix - Total duration: 54s486ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 54s486ms - 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-07-19 20:04:18 Duration: 23s515ms 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-07-19 23:12:01 Duration: 18s571ms 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-07-19 20:10:09 Duration: 5s587ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1s314ms 13s633ms 6s884ms 6 41s307ms 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 Jul 19 20 3 20s423ms 6s807ms 23 3 20s884ms 6s961ms [ User: intelifix - Total duration: 41s307ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s307ms - 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-07-19 20:03:37 Duration: 13s633ms 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-07-19 23:11:27 Duration: 12s831ms 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-07-19 23:32:23 Duration: 6s626ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 4s78ms 10s189ms 6s334ms 6 38s4ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 19 00 3 19s397ms 6s465ms 06 3 18s607ms 6s202ms [ User: lenon - Total duration: 38s4ms - Times executed: 6 ]
[ Application: psql - Total duration: 38s4ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-19 06:02:11 Duration: 10s189ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-19 00:02:12 Duration: 10s157ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-19 00:02:21 Duration: 5s148ms Database: contagem User: lenon Remote: [local] Application: psql
18 955ms 14s857ms 5s669ms 6 34s15ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 19 20 3 17s850ms 5s950ms 23 3 16s164ms 5s388ms [ User: intelifix - Total duration: 34s15ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 34s15ms - 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-07-19 20:03:02 Duration: 14s857ms 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-07-19 23:10:55 Duration: 13s192ms 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-07-19 23:32:09 Duration: 2s16ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 2s103ms 8s295ms 5s375ms 6 32s255ms 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 #19
Day Hour Count Duration Avg duration Jul 19 20 3 18s572ms 6s190ms 23 3 13s683ms 4s561ms [ User: intelifix - Total duration: 32s255ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 32s255ms - 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-07-19 20:07:20 Duration: 8s295ms 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-07-19 20:10:40 Duration: 6s893ms 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-07-19 23:14:39 Duration: 6s692ms Database: rio User: intelifix Remote: [local] Application: pg_dump
20 964ms 11s974ms 4s577ms 6 27s467ms 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 Jul 19 20 3 15s361ms 5s120ms 23 3 12s106ms 4s35ms [ User: intelifix - Total duration: 27s467ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s467ms - 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-07-19 20:02:22 Duration: 11s974ms 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-07-19 23:10:19 Duration: 9s203ms 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-07-19 20:09:37 Duration: 2s352ms 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 9 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 19 11 2 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 2 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 4m3s - Times executed: 9 ]
[ Application: psql - Total duration: 4m3s - Times executed: 9 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 5,038 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 13 FATAL entries
- 1521 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,426 Max number of times the same event was reported
- 1,535 Total events found
Rank Times reported Error 1 1,426 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 19 00 59 01 60 02 59 03 59 04 60 05 59 06 59 07 59 08 60 09 59 10 59 11 60 12 59 13 60 14 59 15 60 16 59 17 60 18 59 19 60 20 60 21 59 22 60 23 59 - ERROR: prepared statement "_PLAN0000000029A529A0" does not exist
- ERROR: prepared statement "_PLAN0000000029A54E20" does not exist
- ERROR: prepared statement "_PLAN0000000029A50520" does not exist
Statement: DEALLOCATE "_PLAN0000000029A529A0"
Date: 2026-07-19 00:00:16 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029A54E20"
Date: 2026-07-19 00:01:17 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029A50520"
Date: 2026-07-19 00:02:18 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 19 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 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-07-19 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-07-19 00:35: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-07-19 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 19 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-19 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-07-19 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-07-19 08:40:03 Database: brasilia Application: psql User: intelifix Remote: [local]
4 8 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 19 03 8 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-19 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-19 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-19 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
5 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 19 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-07-19 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-19 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-19 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
6 3 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 19 00 1 06 1 20 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-19 00:02:21 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-19 06:02:20 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-19 20:04:26 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
7 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 19 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-19 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-19 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
8 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 19 03 1 - LOG: database system was shut down at 2026-07-19 03:05:01 -03
Date: 2026-07-19 03:05:02