pgBadger-
Global information
- Generated on Sat Sep 12 23:50:12 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 21,497 log entries in 10s
- Log start from 2026-09-12 00:00:10 to 2026-09-12 23:49:42
-
Overview
Global Stats
- 153 Number of unique normalized queries
- 928 Number of queries
- 3h47m47s Total query duration
- 2026-09-12 00:02:10 First query
- 2026-09-12 23:43:17 Last query
- 5 queries/s at 2026-09-12 23:42:54 Query peak
- 3h47m47s Total query duration
- 404ms Prepare/parse total duration
- 0ms Bind total duration
- 3h47m46s Execute total duration
- 4,123 Number of events
- 7 Number of unique normalized events
- 4,065 Max number of times the same event was reported
- 0 Number of cancellation
- 7 Total number of automatic vacuums
- 1 Total number of automatic analyzes
- 20 Number temporary file
- 245.55 MiB Max size of temporary file
- 66.83 MiB Average size of temporary file
- 438 Total number of sessions
- 7 sessions at 2026-09-12 06:43:11 Session peak
- 9d23h58m18s Total duration of sessions
- 32m52s Average duration of sessions
- 2 Average queries per session
- 31s203ms Average queries duration per session
- 32m21s Average idle time per session
- 462 Total number of connections
- 5 connections/s at 2026-09-12 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-12 23:42:54 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-09-12 23:17:12 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-12 23:42:54 Date
Queries duration
Key values
- 3h47m47s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 12 00 23 0ms 20s33ms 3s947ms 4s13ms 6s372ms 56s546ms 01 16 0ms 3s140ms 1s670ms 3s522ms 4s835ms 5s333ms 02 16 0ms 3s78ms 1s624ms 3s836ms 4s22ms 5s660ms 03 17 0ms 3s955ms 1s806ms 4s40ms 5s116ms 6s674ms 04 14 0ms 3s57ms 1s876ms 3s505ms 4s548ms 5s317ms 05 19 0ms 10m14s 1m7s 8s915ms 2m46s 10m14s 06 17 0ms 7s722ms 2s695ms 2s435ms 2s655ms 22s560ms 07 15 0ms 6m52s 51s52ms 2s497ms 1m5s 6m52s 08 31 0ms 4m49s 18s585ms 2s434ms 43s441ms 4m49s 09 21 0ms 4m47s 26s844ms 2s316ms 43s758ms 4m47s 10 23 0ms 4m47s 24s511ms 2s327ms 43s124ms 4m47s 11 22 0ms 4m51s 25s938ms 2s398ms 43s383ms 4m51s 12 23 0ms 4m47s 24s623ms 2s414ms 43s936ms 4m47s 13 28 0ms 4m50s 20s603ms 2s348ms 43s2ms 4m50s 14 23 0ms 4m49s 24s722ms 2s468ms 43s396ms 4m49s 15 31 0ms 4m51s 18s592ms 2s275ms 43s435ms 4m51s 16 23 0ms 4m46s 24s423ms 2s292ms 43s688ms 4m46s 17 21 0ms 4m46s 26s887ms 2s445ms 44s232ms 4m46s 18 24 0ms 4m57s 24s362ms 2s312ms 45s751ms 4m57s 19 23 0ms 4m58s 25s128ms 2s476ms 2s775ms 5m42s 20 108 0ms 6m35s 11s991ms 1m3s 1m12s 6m58s 21 23 0ms 6m4s 28s222ms 2s528ms 2s835ms 6m47s 22 20 0ms 4m59s 29s391ms 2s158ms 2s630ms 5m43s 23 347 0ms 1m2s 5s734ms 1m7s 1m8s 1m15s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 12 00 3 0 3s612ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 3s607ms 0ms 0ms 0ms 07 6 0 2m5s 0ms 0ms 4m3s 08 14 0 39s587ms 0ms 0ms 3m38s 09 6 0 1m30s 0ms 0ms 3m33s 10 8 0 1m8s 0ms 0ms 3m33s 11 8 0 1m8s 0ms 0ms 3m35s 12 7 0 1m18s 0ms 0ms 3m34s 13 10 0 55s558ms 0ms 0ms 3m39s 14 9 0 1m1s 0ms 0ms 3m35s 15 15 0 36s898ms 0ms 221ms 3m37s 16 6 0 1m30s 0ms 0ms 3m32s 17 6 0 1m30s 0ms 0ms 3m33s 18 9 0 1m2s 0ms 0ms 3m41s 19 6 0 1m33s 0ms 0ms 3m36s 20 10 78 14s408ms 42s756ms 1m2s 3m53s 21 7 0 1m29s 0ms 0ms 3m41s 22 6 0 1m34s 0ms 0ms 3m45s 23 27 320 5s734ms 1m2s 1m7s 1m13s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 12 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 12 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 2 2.00 0.00% 09 0 0 0.00 0.00% 10 0 2 2.00 0.00% 11 0 1 1.00 0.00% 12 0 1 1.00 0.00% 13 0 1 1.00 0.00% 14 0 1 1.00 0.00% 15 0 3 3.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 2 9 4.50 0.58% Day Hour Count Average / Second Sep 12 00 30 0.01/s 01 15 0.00/s 02 18 0.01/s 03 33 0.01/s 04 17 0.00/s 05 21 0.01/s 06 21 0.01/s 07 16 0.00/s 08 23 0.01/s 09 12 0.00/s 10 15 0.00/s 11 19 0.01/s 12 17 0.00/s 13 18 0.01/s 14 18 0.01/s 15 19 0.01/s 16 18 0.01/s 17 17 0.00/s 18 18 0.01/s 19 19 0.01/s 20 23 0.01/s 21 18 0.01/s 22 21 0.01/s 23 16 0.00/s Day Hour Count Average Duration Average idle time Sep 12 00 16 26m10s 26m4s 01 21 43m17s 43m16s 02 18 29m49s 29m48s 03 28 13m42s 13m41s 04 17 32m52s 32m50s 05 19 31m31s 30m24s 06 17 37m8s 37m5s 07 21 40m36s 40m 08 15 35m52s 35m13s 09 17 46m1s 45m28s 10 13 37m19s 36m35s 11 17 35m30s 34m57s 12 20 38m53s 38m24s 13 15 31m50s 31m12s 14 20 33m27s 32m58s 15 17 31m43s 31m9s 16 19 34m45s 34m15s 17 16 33m41s 33m6s 18 17 35m10s 34m35s 19 19 31m30s 31m 20 20 27m19s 26m14s 21 19 31m39s 31m5s 22 18 26m46s 26m14s 23 19 31m59s 30m14s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-09-12 03:05:16 Date
Connections per database
Key values
- brasilia Main Database
- 462 connections Total
Connections per user
Key values
- etiquetas Main User
- 462 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-09-12 06:43:11 Date
Histogram of session times
Key values
- 208 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 438 sessions Total
Sessions per user
Key values
- etiquetas Main User
- 438 sessions Total
Sessions per host
Key values
- [local] Main Host
- 438 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 39,388 buffers Checkpoint Peak
- 2026-09-12 00:09:47 Date
- 269.866 seconds Highest write time
- 0.145 seconds Sync time
Checkpoints Wal files
Key values
- 5 files Wal files usage Peak
- 2026-09-12 00:09:47 Date
Checkpoints distance
Key values
- 173.22 Mo Distance Peak
- 2026-09-12 00:09:47 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 12 00 50,358 706.154s 0.021s 706.26s 01 2,688 269.419s 0.082s 269.522s 02 2,594 259.791s 0.026s 259.843s 03 2,698 270.245s 0.044s 270.318s 04 2,766 277.017s 0.025s 277.064s 05 9,516 952.076s 0.188s 952.302s 06 4,819 269.116s 0.062s 269.182s 07 1,633 163.601s 0.01s 163.68s 08 37 3.732s 0.007s 3.75s 09 26 2.63s 0.016s 2.656s 10 25 2.519s 0.006s 2.535s 11 38 3.85s 0.022s 3.889s 12 28 2.827s 0.008s 2.846s 13 95 9.553s 0.035s 9.601s 14 57 5.736s 0.068s 5.813s 15 99 9.945s 0.075s 10.029s 16 24 2.419s 0.006s 2.432s 17 26 2.619s 0.007s 2.633s 18 478 47.837s 0.037s 47.882s 19 26 2.621s 0.005s 2.632s 20 255 25.571s 0.071s 25.652s 21 199 19.971s 0.008s 19.995s 22 25 2.521s 0.015s 2.556s 23 27 2.729s 0.017s 2.766s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 12 00 0 0 9 466 0.006s 0.006s 01 0 0 1 422 0.063s 0.006s 02 0 0 1 462 0.006s 0.006s 03 0 0 1 342 0.009s 0.006s 04 0 0 1 432 0.003s 0.006s 05 0 0 4 637 0.080s 0.011s 06 0 0 1 11 0.061s 0.006s 07 0 0 0 25 0.003s 0.004s 08 0 0 0 17 0.003s 0.004s 09 0 0 0 6 0.010s 0.007s 10 0 0 0 5 0.002s 0.003s 11 0 0 0 20 0.012s 0.008s 12 0 0 0 7 0.002s 0.004s 13 0 0 0 57 0.015s 0.005s 14 0 0 0 38 0.061s 0.023s 15 0 0 0 72 0.062s 0.008s 16 0 0 0 5 0.002s 0.003s 17 0 0 0 5 0.002s 0.003s 18 0 0 0 52 0.022s 0.015s 19 0 0 0 5 0.002s 0.002s 20 0 0 0 24 0.063s 0.008s 21 0 0 1 22 0.002s 0.004s 22 0 0 0 5 0.007s 0.007s 23 0 0 0 5 0.013s 0.016s Day Hour Count Avg time (sec) Sep 12 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 12 00 25,478.17 kB 73,375.17 kB 01 2,359.83 kB 40,593.83 kB 02 2,201.00 kB 22,673.17 kB 03 2,205.43 kB 5,043.57 kB 04 2,579.00 kB 3,791.50 kB 05 8,080.00 kB 15,761.44 kB 06 7,235.00 kB 13,493.00 kB 07 2,751.00 kB 11,701.67 kB 08 76.67 kB 8,555.33 kB 09 64.67 kB 6,262.00 kB 10 94.00 kB 4,817.00 kB 11 46.60 kB 3,383.80 kB 12 66.33 kB 2,222.67 kB 13 110.50 kB 1,565.75 kB 14 183.00 kB 1,138.33 kB 15 145.00 kB 868.00 kB 16 94.00 kB 690.00 kB 17 94.50 kB 577.00 kB 18 579.00 kB 1,356.67 kB 19 94.00 kB 1,066.00 kB 20 531.00 kB 932.00 kB 21 157.67 kB 744.33 kB 22 94.00 kB 600.00 kB 23 29.33 kB 472.00 kB -
Temporary Files
Size of temporary files
Key values
- 491.11 MiB Temp Files size Peak
- 2026-09-12 05:31:54 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-12 05:32:01 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 12 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.31 GiB 66.83 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.01 GiB 36.62 MiB 245.55 MiB 64.44 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-12 05:32:03 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-12 05:31:54 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 305.51 MiB 56.79 MiB 93.45 MiB 76.38 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-12 05:30:40 Duration: 38s533ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-12 05:30:36 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 245.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-12 05:31:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 245.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-12 05:31:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 93.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-12 05:30:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 93.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-12 05:30:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 61.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-12 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 56.79 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-12 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.56 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-12 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.50 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-12 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.50 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-12 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-12 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-12 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.48 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-12 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.48 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-12 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 36.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-12 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.64 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-12 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.63 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-12 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.63 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-12 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-12 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-12 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-12 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.23 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-09-12 05:10:34 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.23 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-09-12 05:10:34 Date
Analyzes per table
Key values
- auditor.auditor_2026_09 (1) Main table analyzed (database brasilia)
- 1 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_statistic (1) Main table vacuumed on database rio
- 7 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,479 1,165 4,106,376 1,104 6,611 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 170 42 118,698 10 20 brasilia.pg_catalog.pg_attribute 1 1 0 0 0 0 0 531 196 228,234 0 0 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 836 238 1,188,113 131 344 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 140 6 29,919 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,919 952 3,420,262 905 6,226 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,152 7 156,383 0 0 Total 7 7 0 0 0 0 0 10,227 2,606 9,247,985 2,150 13,201 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.23) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_statistic 0 0 0.23 brasilia.pg_toast.pg_toast_2619 0 0 0 brasilia.pg_catalog.pg_attribute 0 0 0.22 rio.pg_toast.pg_toast_2619 0 0 0.04 contagem.pg_toast.pg_toast_2619 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.21 contagem.pg_catalog.pg_statistic 0 0 0.03 Total 0 0 0.73 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4476) Main table with removed tuples on database rio
- 15597 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,476 7,464 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,356 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,799 7,360 0 0 1,072 brasilia.pg_catalog.pg_attribute 1 1 2,050 20,549 0 0 549 rio.pg_toast.pg_toast_2619 1 1 636 671 0 0 272 brasilia.pg_toast.pg_toast_2619 1 1 154 132 0 0 68 contagem.pg_toast.pg_toast_2619 1 1 126 117 0 0 59 Total 7 7 15,597 43,567 0 0 4,317 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_catalog.pg_statistic 1 1 4476 0 brasilia.pg_toast.pg_toast_2619 1 1 154 0 brasilia.pg_catalog.pg_attribute 1 1 2050 0 rio.pg_toast.pg_toast_2619 1 1 636 0 contagem.pg_toast.pg_toast_2619 1 1 126 0 brasilia.pg_catalog.pg_statistic 1 1 3799 0 contagem.pg_catalog.pg_statistic 1 1 4356 0 Total 7 7 15,597 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 12 00 0 1 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 1 0 22 0 0 23 0 0 - 0.23 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
- 166 Total read queries
- 402 Total write queries
Queries by database
Key values
- rio Main database
- 421 Requests
- 2h22m2s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 898 Requests
User Request type Count Duration etiquetas Total 16 7s731ms select 16 7s731ms intelifix Total 898 3h47m15s copy to 398 42m7s ddl 4 3s317ms others 360 30m20s select 136 2h34m43s lenon Total 14 24s168ms select 14 24s168ms Duration by user
Key values
- 3h47m15s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 16 7s731ms select 16 7s731ms intelifix Total 898 3h47m15s copy to 398 42m7s ddl 4 3s317ms others 360 30m20s select 136 2h34m43s lenon Total 14 24s168ms select 14 24s168ms Queries by host
Key values
- [local] Main host
- 928 Requests
- 3h47m46s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 466 Requests
- 3h5m10s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-12 06:58:37 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 374 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 10m14s analyze verbose;[ Date: 2026-09-12 05:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 6m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-12 07:11:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 6m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-12 20:11:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-12 21:11:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m49s analyze verbose;[ Date: 2026-09-12 05:16:05 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
6 4m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-12 22:10:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 4m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-12 19:10:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 4m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-12 18:09:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 4m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-12 11:09:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 4m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-12 15:09:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 4m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-12 13:09:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 4m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-12 14:09:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 4m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-12 08:09:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 4m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-12 12:09:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 4m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-12 09:09:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 4m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-12 10:09:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 4m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-12 16:09:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-12 17:09:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 3m55s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-12 07:17:26 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m48s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-12 20:16:52 - 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 1h27m24s 48 1s419ms 6m52s 1m49s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 12 07 3 7m28s 2m29s 08 3 5m5s 1m41s 09 3 5m3s 1m41s 10 3 5m3s 1m41s 11 3 5m7s 1m42s 12 3 5m3s 1m41s 13 3 5m6s 1m42s 14 3 5m5s 1m41s 15 3 5m7s 1m42s 16 3 5m2s 1m40s 17 3 5m2s 1m40s 18 3 5m14s 1m44s 19 3 5m14s 1m44s 20 3 7m2s 2m20s 21 3 6m20s 2m6s 22 3 5m15s 1m45s [ User: intelifix - Total duration: 1h27m24s - Times executed: 48 ]
[ Application: psql - Total duration: 1h27m24s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-12 07:11:54 Duration: 6m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-12 20:11:37 Duration: 6m35s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-12 21:11:05 Duration: 6m4s Database: rio User: intelifix Remote: [local] Application: psql
2 1h7m2s 48 209ms 3m55s 1m23s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 12 07 3 5m3s 1m41s 08 3 4m5s 1m21s 09 3 4m 1m20s 10 3 4m 1m20s 11 3 4m2s 1m20s 12 3 4m2s 1m20s 13 3 4m6s 1m22s 14 3 4m2s 1m20s 15 3 4m 1m20s 16 3 4m 1m20s 17 3 4m2s 1m20s 18 3 4m11s 1m23s 19 3 4m4s 1m21s 20 3 4m56s 1m38s 21 3 4m8s 1m22s 22 3 4m13s 1m24s [ User: intelifix - Total duration: 1h7m2s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m2s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-12 07:17:26 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-12 20:16:52 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-12 22:14:28 Duration: 3m43s Database: brasilia User: intelifix Remote: [local] Application: psql
3 18m50s 3 2m46s 10m14s 6m16s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 12 05 3 18m50s 6m16s [ User: intelifix - Total duration: 18m50s - Times executed: 3 ]
[ Application: psql - Total duration: 18m50s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-12 05:10:15 Duration: 10m14s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-12 05:16:05 Duration: 5m49s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-12 05:18:51 Duration: 2m46s Database: contagem User: intelifix Remote: [local] Application: psql
4 5m31s 219 150ms 5s796ms 1s514ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 12 00 9 16s65ms 1s785ms 01 10 13s991ms 1s399ms 02 10 14s480ms 1s448ms 03 11 15s476ms 1s406ms 04 8 13s32ms 1s629ms 05 9 15s310ms 1s701ms 06 11 14s849ms 1s349ms 07 9 13s861ms 1s540ms 08 11 13s965ms 1s269ms 09 9 14s210ms 1s578ms 10 9 13s258ms 1s473ms 11 8 13s707ms 1s713ms 12 10 13s766ms 1s376ms 13 9 13s586ms 1s509ms 14 8 13s662ms 1s707ms 15 9 13s551ms 1s505ms 16 11 13s763ms 1s251ms 17 9 14s205ms 1s578ms 18 9 13s447ms 1s494ms 19 11 15s121ms 1s374ms 20 11 19s906ms 1s809ms 21 10 14s888ms 1s488ms 22 8 13s512ms 1s689ms [ User: intelifix - Total duration: 5m31s - Times executed: 219 ]
[ Application: psql - Total duration: 5m31s - Times executed: 219 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-12 20:05:08 Duration: 5s796ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-12 00:05:25 Duration: 4s14ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-12 05:25:07 Duration: 3s749ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m14s 4 4s239ms 1m2s 33s596ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 12 20 2 1m7s 33s667ms 23 2 1m7s 33s524ms [ User: intelifix - Total duration: 2m14s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m14s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-12 20:08:40 Duration: 1m2s 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-09-12 23:16:39 Duration: 1m2s 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-09-12 20:10:39 Duration: 4s359ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 1m47s 4 334ms 53s508ms 26s755ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 12 20 2 53s863ms 26s931ms 23 2 53s158ms 26s579ms [ User: intelifix - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-12 20:05:44 Duration: 53s508ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-12 23:13:44 Duration: 52s824ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-12 20:10:04 Duration: 355ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 1m46s 6 3s138ms 40s89ms 17s810ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 12 20 3 53s805ms 17s935ms 23 3 53s60ms 17s686ms [ User: intelifix - Total duration: 1m46s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-12 20:06:26 Duration: 40s89ms 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-09-12 23:14:26 Duration: 39s440ms 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-09-12 20:10:15 Duration: 10s577ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m38s 36 172ms 20s33ms 2s744ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 12 00 7 32s201ms 4s600ms 01 6 12s731ms 2s121ms 02 6 11s511ms 1s918ms 03 5 14s634ms 2s926ms 04 6 13s240ms 2s206ms 05 5 14s37ms 2s807ms 20 1 432ms 432ms [ User: intelifix - Total duration: 1m38s - Times executed: 36 ]
[ Application: psql - Total duration: 1m38s - Times executed: 36 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-12 00:05:21 Duration: 20s33ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-12 05:05:08 Duration: 6s693ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-12 05:35:06 Duration: 4s177ms Database: rio User: intelifix Remote: [local] Application: psql
9 1m24s 6 3s14ms 33s548ms 14s39ms 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 #9
Day Hour Count Duration Avg duration Sep 12 20 3 43s600ms 14s533ms 23 3 40s637ms 13s545ms [ User: intelifix - Total duration: 1m24s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-12 20:09:13 Duration: 33s548ms 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-09-12 23:17:10 Duration: 31s202ms 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-09-12 20:10:46 Duration: 6s938ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 1m23s 1 1m23s 1m23s 1m23s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 12 05 1 1m23s 1m23s [ User: intelifix - Total duration: 1m23s - Times executed: 1 ]
[ Application: psql - Total duration: 1m23s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-12 05:32:03 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-12 05:31:54 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
11 1m22s 6 2s164ms 31s439ms 13s797ms 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 Sep 12 20 3 41s349ms 13s783ms 23 3 41s435ms 13s811ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-12 20:07:00 Duration: 31s439ms 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-09-12 23:15:00 Duration: 31s311ms 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-09-12 23:33:57 Duration: 7s959ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1m11s 6 2s517ms 23s676ms 11s970ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 12 20 3 35s705ms 11s901ms 23 3 36s120ms 12s40ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-12 23:10:48 Duration: 23s676ms 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-09-12 20:02:48 Duration: 23s227ms 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-09-12 23:33:06 Duration: 9s925ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1m10s 6 2s246ms 23s832ms 11s734ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 12 20 3 35s216ms 11s738ms 23 3 35s191ms 11s730ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-12 23:11:29 Duration: 23s832ms 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-09-12 20:03:29 Duration: 23s823ms 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-09-12 20:09:45 Duration: 9s124ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1m2s 6 1s650ms 24s813ms 10s465ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 12 20 3 31s237ms 10s412ms 23 3 31s555ms 10s518ms [ User: intelifix - Total duration: 1m2s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m2s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-12 23:12:27 Duration: 24s813ms 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-09-12 20:04:27 Duration: 24s676ms 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-09-12 23:33:33 Duration: 5s90ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 55s294ms 4 4s105ms 23s592ms 13s823ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 12 20 2 27s596ms 13s798ms 23 2 27s697ms 13s848ms [ User: intelifix - Total duration: 55s294ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s294ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-12 23:12:51 Duration: 23s592ms 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-09-12 20:04:50 Duration: 23s173ms 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-09-12 20:10:04 Duration: 4s423ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 53s548ms 56 558ms 2s912ms 956ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 12 08 3 2s284ms 761ms 09 3 2s335ms 778ms 10 4 3s449ms 862ms 11 3 3s60ms 1s20ms 12 3 3s332ms 1s110ms 13 4 3s214ms 803ms 14 5 4s957ms 991ms 15 4 7s403ms 1s850ms 16 3 2s309ms 769ms 17 4 4s78ms 1s19ms 18 5 3s901ms 780ms 19 4 3s71ms 767ms 20 4 4s503ms 1s125ms 21 3 2s408ms 802ms 22 4 3s237ms 809ms [ User: intelifix - Total duration: 53s548ms - Times executed: 56 ]
[ Application: psql - Total duration: 53s548ms - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-12 15:20:04 Duration: 2s912ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-12 15:20:06 Duration: 2s861ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-12 20:20:03 Duration: 2s310ms Database: rio User: intelifix Remote: [local] Application: psql
17 51s431ms 6 1s841ms 16s508ms 8s571ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 12 20 3 25s716ms 8s572ms 23 3 25s715ms 8s571ms [ User: intelifix - Total duration: 51s431ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s431ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-12 20:03:45 Duration: 16s508ms 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-09-12 23:11:45 Duration: 16s396ms 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-09-12 23:33:25 Duration: 7s478ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 51s263ms 6 6s53ms 12s40ms 8s543ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 12 00 3 31s113ms 10s371ms 06 3 20s149ms 6s716ms [ User: intelifix - Total duration: 51s263ms - Times executed: 6 ]
[ Application: psql - Total duration: 51s263ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-12 00:05:13 Duration: 12s40ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-12 00:05:23 Duration: 9s610ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-12 00:05:32 Duration: 9s462ms Database: contagem User: intelifix Remote: [local] Application: psql
19 41s46ms 6 1s55ms 17s49ms 6s841ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 12 20 3 20s397ms 6s799ms 23 3 20s648ms 6s882ms [ User: intelifix - Total duration: 41s46ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s46ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-12 23:11:05 Duration: 17s49ms 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-09-12 20:03:05 Duration: 16s783ms 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-09-12 23:33:09 Duration: 2s543ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 38s533ms 1 38s533ms 38s533ms 38s533ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 12 05 1 38s533ms 38s533ms [ User: intelifix - Total duration: 38s533ms - Times executed: 1 ]
[ Application: psql - Total duration: 38s533ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-12 05:30:40 Duration: 38s533ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-12 05:30:36 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 219 5m31s 150ms 5s796ms 1s514ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 12 00 9 16s65ms 1s785ms 01 10 13s991ms 1s399ms 02 10 14s480ms 1s448ms 03 11 15s476ms 1s406ms 04 8 13s32ms 1s629ms 05 9 15s310ms 1s701ms 06 11 14s849ms 1s349ms 07 9 13s861ms 1s540ms 08 11 13s965ms 1s269ms 09 9 14s210ms 1s578ms 10 9 13s258ms 1s473ms 11 8 13s707ms 1s713ms 12 10 13s766ms 1s376ms 13 9 13s586ms 1s509ms 14 8 13s662ms 1s707ms 15 9 13s551ms 1s505ms 16 11 13s763ms 1s251ms 17 9 14s205ms 1s578ms 18 9 13s447ms 1s494ms 19 11 15s121ms 1s374ms 20 11 19s906ms 1s809ms 21 10 14s888ms 1s488ms 22 8 13s512ms 1s689ms [ User: intelifix - Total duration: 5m31s - Times executed: 219 ]
[ Application: psql - Total duration: 5m31s - Times executed: 219 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-12 20:05:08 Duration: 5s796ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-12 00:05:25 Duration: 4s14ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-12 05:25:07 Duration: 3s749ms Database: rio User: intelifix Remote: [local] Application: psql
2 56 53s548ms 558ms 2s912ms 956ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 12 08 3 2s284ms 761ms 09 3 2s335ms 778ms 10 4 3s449ms 862ms 11 3 3s60ms 1s20ms 12 3 3s332ms 1s110ms 13 4 3s214ms 803ms 14 5 4s957ms 991ms 15 4 7s403ms 1s850ms 16 3 2s309ms 769ms 17 4 4s78ms 1s19ms 18 5 3s901ms 780ms 19 4 3s71ms 767ms 20 4 4s503ms 1s125ms 21 3 2s408ms 802ms 22 4 3s237ms 809ms [ User: intelifix - Total duration: 53s548ms - Times executed: 56 ]
[ Application: psql - Total duration: 53s548ms - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-12 15:20:04 Duration: 2s912ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-12 15:20:06 Duration: 2s861ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-12 20:20:03 Duration: 2s310ms Database: rio User: intelifix Remote: [local] Application: psql
3 48 1h27m24s 1s419ms 6m52s 1m49s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 12 07 3 7m28s 2m29s 08 3 5m5s 1m41s 09 3 5m3s 1m41s 10 3 5m3s 1m41s 11 3 5m7s 1m42s 12 3 5m3s 1m41s 13 3 5m6s 1m42s 14 3 5m5s 1m41s 15 3 5m7s 1m42s 16 3 5m2s 1m40s 17 3 5m2s 1m40s 18 3 5m14s 1m44s 19 3 5m14s 1m44s 20 3 7m2s 2m20s 21 3 6m20s 2m6s 22 3 5m15s 1m45s [ User: intelifix - Total duration: 1h27m24s - Times executed: 48 ]
[ Application: psql - Total duration: 1h27m24s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-12 07:11:54 Duration: 6m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-12 20:11:37 Duration: 6m35s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-12 21:11:05 Duration: 6m4s Database: rio User: intelifix Remote: [local] Application: psql
4 48 1h7m2s 209ms 3m55s 1m23s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 12 07 3 5m3s 1m41s 08 3 4m5s 1m21s 09 3 4m 1m20s 10 3 4m 1m20s 11 3 4m2s 1m20s 12 3 4m2s 1m20s 13 3 4m6s 1m22s 14 3 4m2s 1m20s 15 3 4m 1m20s 16 3 4m 1m20s 17 3 4m2s 1m20s 18 3 4m11s 1m23s 19 3 4m4s 1m21s 20 3 4m56s 1m38s 21 3 4m8s 1m22s 22 3 4m13s 1m24s [ User: intelifix - Total duration: 1h7m2s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m2s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-12 07:17:26 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-12 20:16:52 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-12 22:14:28 Duration: 3m43s Database: brasilia User: intelifix Remote: [local] Application: psql
5 36 1m38s 172ms 20s33ms 2s744ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 12 00 7 32s201ms 4s600ms 01 6 12s731ms 2s121ms 02 6 11s511ms 1s918ms 03 5 14s634ms 2s926ms 04 6 13s240ms 2s206ms 05 5 14s37ms 2s807ms 20 1 432ms 432ms [ User: intelifix - Total duration: 1m38s - Times executed: 36 ]
[ Application: psql - Total duration: 1m38s - Times executed: 36 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-12 00:05:21 Duration: 20s33ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-12 05:05:08 Duration: 6s693ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-12 05:35:06 Duration: 4s177ms Database: rio User: intelifix Remote: [local] Application: psql
6 34 31s714ms 616ms 4s73ms 932ms 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 #6
Day Hour Count Duration Avg duration Sep 12 08 3 5s681ms 1s893ms 09 3 2s490ms 830ms 10 2 2s757ms 1s378ms 11 3 2s276ms 758ms 12 3 2s591ms 863ms 13 2 1s451ms 725ms 14 1 741ms 741ms 15 2 1s659ms 829ms 16 3 2s176ms 725ms 17 2 1s613ms 806ms 18 1 943ms 943ms 19 2 1s473ms 736ms 20 2 1s669ms 834ms 21 3 2s501ms 833ms 22 2 1s685ms 842ms [ User: intelifix - Total duration: 31s714ms - Times executed: 34 ]
[ Application: psql - Total duration: 31s714ms - Times executed: 34 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-12 08:00:05 Duration: 4s73ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-12 10:20:02 Duration: 1s888ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-12 18:20:02 Duration: 943ms Database: rio User: intelifix Remote: [local] Application: psql
7 8 2s510ms 302ms 345ms 313ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 12 08 2 623ms 311ms 11 1 306ms 306ms 13 1 302ms 302ms 14 1 312ms 312ms 15 3 965ms 321ms [ User: lenon - Total duration: 2s510ms - Times executed: 8 ]
[ Application: [unknown] - Total duration: 2s510ms - Times executed: 8 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-12 15:48:57 Duration: 345ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-12 08:13:08 Duration: 314ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-12 15:08:59 Duration: 314ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
8 7 4s203ms 177ms 1s574ms 600ms select * from rs_etiqueta (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 12 20 1 259ms 259ms 23 6 3s944ms 657ms [ User: etiquetas - Total duration: 4s203ms - Times executed: 7 ]
[ Application: [unknown] - Total duration: 4s203ms - Times executed: 7 ]
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-09-12 23:42:37 Duration: 1s574ms Database: brasilia User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-09-12 23:26:35 Duration: 598ms Database: brasilia User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-09-12 23:23:29 Duration: 568ms Database: brasilia User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
9 6 1m46s 3s138ms 40s89ms 17s810ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 12 20 3 53s805ms 17s935ms 23 3 53s60ms 17s686ms [ User: intelifix - Total duration: 1m46s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-12 20:06:26 Duration: 40s89ms 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-09-12 23:14:26 Duration: 39s440ms 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-09-12 20:10:15 Duration: 10s577ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 6 1m24s 3s14ms 33s548ms 14s39ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 12 20 3 43s600ms 14s533ms 23 3 40s637ms 13s545ms [ User: intelifix - Total duration: 1m24s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-12 20:09:13 Duration: 33s548ms 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-09-12 23:17:10 Duration: 31s202ms 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-09-12 20:10:46 Duration: 6s938ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 1m22s 2s164ms 31s439ms 13s797ms 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 Sep 12 20 3 41s349ms 13s783ms 23 3 41s435ms 13s811ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-12 20:07:00 Duration: 31s439ms 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-09-12 23:15:00 Duration: 31s311ms 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-09-12 23:33:57 Duration: 7s959ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 6 1m11s 2s517ms 23s676ms 11s970ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 12 20 3 35s705ms 11s901ms 23 3 36s120ms 12s40ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-12 23:10:48 Duration: 23s676ms 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-09-12 20:02:48 Duration: 23s227ms 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-09-12 23:33:06 Duration: 9s925ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 1m10s 2s246ms 23s832ms 11s734ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 12 20 3 35s216ms 11s738ms 23 3 35s191ms 11s730ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-12 23:11:29 Duration: 23s832ms 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-09-12 20:03:29 Duration: 23s823ms 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-09-12 20:09:45 Duration: 9s124ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 1m2s 1s650ms 24s813ms 10s465ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 12 20 3 31s237ms 10s412ms 23 3 31s555ms 10s518ms [ User: intelifix - Total duration: 1m2s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m2s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-12 23:12:27 Duration: 24s813ms 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-09-12 20:04:27 Duration: 24s676ms 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-09-12 23:33:33 Duration: 5s90ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 51s431ms 1s841ms 16s508ms 8s571ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 12 20 3 25s716ms 8s572ms 23 3 25s715ms 8s571ms [ User: intelifix - Total duration: 51s431ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s431ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-12 20:03:45 Duration: 16s508ms 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-09-12 23:11:45 Duration: 16s396ms 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-09-12 23:33:25 Duration: 7s478ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 51s263ms 6s53ms 12s40ms 8s543ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 12 00 3 31s113ms 10s371ms 06 3 20s149ms 6s716ms [ User: intelifix - Total duration: 51s263ms - Times executed: 6 ]
[ Application: psql - Total duration: 51s263ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-12 00:05:13 Duration: 12s40ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-12 00:05:23 Duration: 9s610ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-12 00:05:32 Duration: 9s462ms Database: contagem User: intelifix Remote: [local] Application: psql
17 6 41s46ms 1s55ms 17s49ms 6s841ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 12 20 3 20s397ms 6s799ms 23 3 20s648ms 6s882ms [ User: intelifix - Total duration: 41s46ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s46ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-12 23:11:05 Duration: 17s49ms 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-09-12 20:03:05 Duration: 16s783ms 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-09-12 23:33:09 Duration: 2s543ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 28s540ms 829ms 12s494ms 4s756ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 12 20 3 14s242ms 4s747ms 23 3 14s298ms 4s766ms [ User: intelifix - Total duration: 28s540ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 28s540ms - Times executed: 6 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-09-12 20:04:02 Duration: 12s494ms 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-09-12 23:12:02 Duration: 12s416ms 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-09-12 23:33:28 Duration: 1s48ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 27s501ms 2s792ms 5s576ms 4s583ms 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 Sep 12 20 3 13s730ms 4s576ms 23 3 13s771ms 4s590ms [ User: intelifix - Total duration: 27s501ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s501ms - 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-09-12 23:15:24 Duration: 5s576ms 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-09-12 20:07:24 Duration: 5s515ms 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-09-12 23:34:07 Duration: 5s403ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 27s71ms 951ms 10s371ms 4s511ms 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 Sep 12 20 3 13s631ms 4s543ms 23 3 13s440ms 4s480ms [ User: intelifix - Total duration: 27s71ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s71ms - 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-09-12 20:02:21 Duration: 10s371ms 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-09-12 23:10:20 Duration: 10s308ms 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-09-12 20:09:23 Duration: 2s196ms 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 2m46s 10m14s 6m16s 3 18m50s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 12 05 3 18m50s 6m16s [ User: intelifix - Total duration: 18m50s - Times executed: 3 ]
[ Application: psql - Total duration: 18m50s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-12 05:10:15 Duration: 10m14s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-12 05:16:05 Duration: 5m49s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-12 05:18:51 Duration: 2m46s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s419ms 6m52s 1m49s 48 1h27m24s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 12 07 3 7m28s 2m29s 08 3 5m5s 1m41s 09 3 5m3s 1m41s 10 3 5m3s 1m41s 11 3 5m7s 1m42s 12 3 5m3s 1m41s 13 3 5m6s 1m42s 14 3 5m5s 1m41s 15 3 5m7s 1m42s 16 3 5m2s 1m40s 17 3 5m2s 1m40s 18 3 5m14s 1m44s 19 3 5m14s 1m44s 20 3 7m2s 2m20s 21 3 6m20s 2m6s 22 3 5m15s 1m45s [ User: intelifix - Total duration: 1h27m24s - Times executed: 48 ]
[ Application: psql - Total duration: 1h27m24s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-12 07:11:54 Duration: 6m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-12 20:11:37 Duration: 6m35s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-12 21:11:05 Duration: 6m4s Database: rio User: intelifix Remote: [local] Application: psql
3 209ms 3m55s 1m23s 48 1h7m2s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 12 07 3 5m3s 1m41s 08 3 4m5s 1m21s 09 3 4m 1m20s 10 3 4m 1m20s 11 3 4m2s 1m20s 12 3 4m2s 1m20s 13 3 4m6s 1m22s 14 3 4m2s 1m20s 15 3 4m 1m20s 16 3 4m 1m20s 17 3 4m2s 1m20s 18 3 4m11s 1m23s 19 3 4m4s 1m21s 20 3 4m56s 1m38s 21 3 4m8s 1m22s 22 3 4m13s 1m24s [ User: intelifix - Total duration: 1h7m2s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m2s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-12 07:17:26 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-12 20:16:52 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-12 22:14:28 Duration: 3m43s Database: brasilia User: intelifix Remote: [local] Application: psql
4 1m23s 1m23s 1m23s 1 1m23s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 12 05 1 1m23s 1m23s [ User: intelifix - Total duration: 1m23s - Times executed: 1 ]
[ Application: psql - Total duration: 1m23s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-12 05:32:03 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-12 05:31:54 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
5 38s533ms 38s533ms 38s533ms 1 38s533ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 12 05 1 38s533ms 38s533ms [ User: intelifix - Total duration: 38s533ms - Times executed: 1 ]
[ Application: psql - Total duration: 38s533ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-12 05:30:40 Duration: 38s533ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-12 05:30:36 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
6 4s239ms 1m2s 33s596ms 4 2m14s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 12 20 2 1m7s 33s667ms 23 2 1m7s 33s524ms [ User: intelifix - Total duration: 2m14s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m14s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-12 20:08:40 Duration: 1m2s 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-09-12 23:16:39 Duration: 1m2s 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-09-12 20:10:39 Duration: 4s359ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 334ms 53s508ms 26s755ms 4 1m47s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 12 20 2 53s863ms 26s931ms 23 2 53s158ms 26s579ms [ User: intelifix - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-12 20:05:44 Duration: 53s508ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-12 23:13:44 Duration: 52s824ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-12 20:10:04 Duration: 355ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 3s138ms 40s89ms 17s810ms 6 1m46s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 12 20 3 53s805ms 17s935ms 23 3 53s60ms 17s686ms [ User: intelifix - Total duration: 1m46s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-12 20:06:26 Duration: 40s89ms 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-09-12 23:14:26 Duration: 39s440ms 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-09-12 20:10:15 Duration: 10s577ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 3s14ms 33s548ms 14s39ms 6 1m24s 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 #9
Day Hour Count Duration Avg duration Sep 12 20 3 43s600ms 14s533ms 23 3 40s637ms 13s545ms [ User: intelifix - Total duration: 1m24s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-12 20:09:13 Duration: 33s548ms 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-09-12 23:17:10 Duration: 31s202ms 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-09-12 20:10:46 Duration: 6s938ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 4s105ms 23s592ms 13s823ms 4 55s294ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 12 20 2 27s596ms 13s798ms 23 2 27s697ms 13s848ms [ User: intelifix - Total duration: 55s294ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s294ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-12 23:12:51 Duration: 23s592ms 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-09-12 20:04:50 Duration: 23s173ms 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-09-12 20:10:04 Duration: 4s423ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 2s164ms 31s439ms 13s797ms 6 1m22s 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 Sep 12 20 3 41s349ms 13s783ms 23 3 41s435ms 13s811ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-12 20:07:00 Duration: 31s439ms 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-09-12 23:15:00 Duration: 31s311ms 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-09-12 23:33:57 Duration: 7s959ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s517ms 23s676ms 11s970ms 6 1m11s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 12 20 3 35s705ms 11s901ms 23 3 36s120ms 12s40ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-12 23:10:48 Duration: 23s676ms 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-09-12 20:02:48 Duration: 23s227ms 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-09-12 23:33:06 Duration: 9s925ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s246ms 23s832ms 11s734ms 6 1m10s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 12 20 3 35s216ms 11s738ms 23 3 35s191ms 11s730ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-12 23:11:29 Duration: 23s832ms 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-09-12 20:03:29 Duration: 23s823ms 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-09-12 20:09:45 Duration: 9s124ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1s650ms 24s813ms 10s465ms 6 1m2s copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 12 20 3 31s237ms 10s412ms 23 3 31s555ms 10s518ms [ User: intelifix - Total duration: 1m2s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m2s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-12 23:12:27 Duration: 24s813ms 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-09-12 20:04:27 Duration: 24s676ms 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-09-12 23:33:33 Duration: 5s90ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1s841ms 16s508ms 8s571ms 6 51s431ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 12 20 3 25s716ms 8s572ms 23 3 25s715ms 8s571ms [ User: intelifix - Total duration: 51s431ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s431ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-12 20:03:45 Duration: 16s508ms 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-09-12 23:11:45 Duration: 16s396ms 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-09-12 23:33:25 Duration: 7s478ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6s53ms 12s40ms 8s543ms 6 51s263ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 12 00 3 31s113ms 10s371ms 06 3 20s149ms 6s716ms [ User: intelifix - Total duration: 51s263ms - Times executed: 6 ]
[ Application: psql - Total duration: 51s263ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-12 00:05:13 Duration: 12s40ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-12 00:05:23 Duration: 9s610ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-12 00:05:32 Duration: 9s462ms Database: contagem User: intelifix Remote: [local] Application: psql
17 1s55ms 17s49ms 6s841ms 6 41s46ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 12 20 3 20s397ms 6s799ms 23 3 20s648ms 6s882ms [ User: intelifix - Total duration: 41s46ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s46ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-12 23:11:05 Duration: 17s49ms 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-09-12 20:03:05 Duration: 16s783ms 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-09-12 23:33:09 Duration: 2s543ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 829ms 12s494ms 4s756ms 6 28s540ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 12 20 3 14s242ms 4s747ms 23 3 14s298ms 4s766ms [ User: intelifix - Total duration: 28s540ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 28s540ms - Times executed: 6 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-09-12 20:04:02 Duration: 12s494ms 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-09-12 23:12:02 Duration: 12s416ms 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-09-12 23:33:28 Duration: 1s48ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 2s792ms 5s576ms 4s583ms 6 27s501ms 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 Sep 12 20 3 13s730ms 4s576ms 23 3 13s771ms 4s590ms [ User: intelifix - Total duration: 27s501ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s501ms - 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-09-12 23:15:24 Duration: 5s576ms 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-09-12 20:07:24 Duration: 5s515ms 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-09-12 23:34:07 Duration: 5s403ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 951ms 10s371ms 4s511ms 6 27s71ms 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 Sep 12 20 3 13s631ms 4s543ms 23 3 13s440ms 4s480ms [ User: intelifix - Total duration: 27s71ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s71ms - 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-09-12 20:02:21 Duration: 10s371ms 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-09-12 23:10:20 Duration: 10s308ms 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-09-12 20:09:23 Duration: 2s196ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 404ms 2 199ms 205ms 202ms select * from rs_caixa_qr ();Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Sep 12 23 2 404ms 202ms [ User: etiquetas - Total duration: 1s912ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 1s912ms - Times executed: 2 ]
-
select * from rs_caixa_qr ();
Date: 2026-09-12 23:21:31 Duration: 205ms Database: postgres User: rio Remote: etiquetas Application: [local] Queryid: [unknown]
-
select * from rs_caixa_qr ();
Date: 2026-09-12 23:39:37 Duration: 199ms Database: postgres User: rio Remote: etiquetas Application: [local] Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 10 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 12 10 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 18 1 0ms 0ms 19 2 0ms 0ms 20 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 15m28s - Times executed: 10 ]
[ Application: psql - Total duration: 15m28s - Times executed: 10 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 11,235 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 35 FATAL entries
- 4087 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,065 Max number of times the same event was reported
- 4,123 Total events found
Rank Times reported Error 1 4,065 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 12 00 168 01 168 02 167 03 152 04 164 05 169 06 168 07 169 08 170 09 184 10 191 11 175 12 177 13 183 14 181 15 167 16 167 17 167 18 169 19 166 20 168 21 166 22 166 23 143 - ERROR: prepared statement "_PLAN0000000029C254C0" does not exist
- ERROR: prepared statement "_PLAN0000000029CABB70" does not exist
- ERROR: prepared statement "_PLAN00000000569BDE40" does not exist
Statement: DEALLOCATE "_PLAN0000000029C254C0"
Date: 2026-09-12 00:00:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029CABB70"
Date: 2026-09-12 00:00:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000569BDE40"
Date: 2026-09-12 00:00:31 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
2 23 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 12 00 5 03 5 06 1 08 4 12 1 16 1 18 1 19 1 20 2 21 1 22 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-12 00:02:13 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-12 00:48:13 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-12 00:48:28 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 18 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 12 14 18 - ERROR: column "e84368540690" does not exist at character 27
- ERROR: column "e84368540690" does not exist at character 27
- ERROR: column "e84368540690" does not exist at character 27
Statement: select * from rs_caixa_qr(E84368540690)
Date: 2026-09-12 14:11:38 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(E84368540690)
Date: 2026-09-12 14:11:39 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(E84368540690)
Date: 2026-09-12 14:11:39 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
4 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 12 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-12 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-12 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-12 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
5 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 12 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-12 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-12 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-12 05:32:03 Database: contagem Application: psql User: intelifix Remote: [local]
6 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 12 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-12 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-12 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-12 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
7 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 12 03 1 - LOG: database system was shut down at 2026-09-12 03:05:01 -03
Date: 2026-09-12 03:05:02