pgBadger-
Global information
- Generated on Sun Aug 16 23:50:14 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 14,699 log entries in 12s
- Log start from 2026-08-15 00:00:08 to 2026-08-15 23:59:32
-
Overview
Global Stats
- 154 Number of unique normalized queries
- 1,053 Number of queries
- 4h47m37s Total query duration
- 2026-08-15 00:02:14 First query
- 2026-08-15 23:54:31 Last query
- 3 queries/s at 2026-08-15 23:53:23 Query peak
- 4h47m37s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h47m37s Execute total duration
- 2,848 Number of events
- 7 Number of unique normalized events
- 2,775 Max number of times the same event was reported
- 0 Number of cancellation
- 10 Total number of automatic vacuums
- 18 Total number of automatic analyzes
- 10 Number temporary file
- 240.82 MiB Max size of temporary file
- 111.93 MiB Average size of temporary file
- 277 Total number of sessions
- 8 sessions at 2026-08-15 03:05:17 Session peak
- 8d18h6m27s Total duration of sessions
- 45m30s Average duration of sessions
- 3 Average queries per session
- 1m2s Average queries duration per session
- 44m28s Average idle time per session
- 278 Total number of connections
- 8 connections/s at 2026-08-15 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2026-08-15 23:53:23 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-08-15 23:10:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2026-08-15 23:53:23 Date
Queries duration
Key values
- 4h47m37s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 15 00 57 0ms 20s919ms 2s869ms 7s180ms 11s283ms 1m38s 01 18 0ms 5s632ms 2s659ms 6s620ms 8s607ms 9s40ms 02 20 0ms 5s692ms 2s445ms 6s247ms 8s334ms 9s483ms 03 33 0ms 7s274ms 1s772ms 7s114ms 8s53ms 12s880ms 04 22 0ms 6s680ms 2s313ms 6s510ms 9s53ms 9s717ms 05 41 0ms 10m45s 34s968ms 12s243ms 3m5s 10m45s 06 18 0ms 11s436ms 4s584ms 5s937ms 6s666ms 36s207ms 07 26 0ms 11m24s 46s637ms 7s91ms 2m29s 11m24s 08 26 0ms 6m17s 27s118ms 6s553ms 16s623ms 6m54s 09 27 0ms 6m25s 26s72ms 6s291ms 58s551ms 6m25s 10 24 0ms 6m43s 30s504ms 6s443ms 53s536ms 6m43s 11 27 0ms 6m51s 27s378ms 6s349ms 53s91ms 6m51s 12 24 0ms 6m13s 28s175ms 6s252ms 17s121ms 6m48s 13 24 0ms 6m31s 30s10ms 6s634ms 54s343ms 6m31s 14 24 0ms 6m39s 30s79ms 6s438ms 58s878ms 6m39s 15 24 0ms 6m21s 29s480ms 6s290ms 57s492ms 6m21s 16 24 0ms 6m24s 29s211ms 6s157ms 54s404ms 6m24s 17 24 0ms 6m11s 28s379ms 6s229ms 16s510ms 6m48s 18 26 0ms 6m13s 26s591ms 6s700ms 17s532ms 6m46s 19 24 0ms 6m19s 28s850ms 6s410ms 17s34ms 6m53s 20 126 0ms 8m25s 12s596ms 1m12s 2m34s 8m25s 21 26 0ms 8m28s 31s59ms 6s560ms 48s840ms 8m28s 22 24 0ms 6m50s 32s493ms 6s835ms 57s477ms 6m50s 23 344 0ms 1m46s 7s303ms 1m7s 1m14s 1m46s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 15 00 34 0 757ms 296ms 461ms 1s360ms 01 0 0 0ms 0ms 0ms 0ms 02 2 0 669ms 0ms 0ms 0ms 03 15 0 411ms 150ms 373ms 1s34ms 04 4 0 287ms 0ms 0ms 184ms 05 19 0 289ms 0ms 232ms 1s131ms 06 3 0 5s204ms 0ms 0ms 0ms 07 11 0 1m43s 0ms 0ms 5m1s 08 7 0 1m30s 0ms 0ms 3m25s 09 9 0 1m12s 0ms 0ms 3m24s 10 6 0 1m52s 0ms 0ms 3m39s 11 8 0 1m24s 0ms 0ms 3m28s 12 6 0 1m44s 0ms 0ms 3m20s 13 6 0 1m50s 0ms 0ms 3m38s 14 6 0 1m51s 0ms 0ms 3m28s 15 6 0 1m48s 0ms 0ms 3m33s 16 6 0 1m48s 0ms 0ms 3m31s 17 6 0 1m44s 0ms 0ms 3m22s 18 8 0 1m19s 0ms 0ms 3m32s 19 6 0 1m46s 0ms 0ms 3m26s 20 21 83 14s610ms 37s475ms 1m7s 4m36s 21 8 0 1m34s 0ms 0ms 3m17s 22 6 0 1m58s 0ms 0ms 4m5s 23 25 319 7s303ms 1m2s 1m7s 1m14s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 15 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 15 00 0 4 4.00 0.00% 01 0 0 0.00 0.00% 02 0 1 1.00 0.00% 03 0 3 3.00 0.00% 04 0 1 1.00 0.00% 05 0 4 4.00 0.00% 06 0 0 0.00 0.00% 07 0 2 2.00 0.00% 08 0 0 0.00 0.00% 09 0 1 1.00 0.00% 10 0 0 0.00 0.00% 11 0 1 1.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Aug 15 00 18 0.01/s 01 13 0.00/s 02 16 0.00/s 03 22 0.01/s 04 13 0.00/s 05 10 0.00/s 06 15 0.00/s 07 15 0.00/s 08 9 0.00/s 09 11 0.00/s 10 10 0.00/s 11 10 0.00/s 12 8 0.00/s 13 12 0.00/s 14 11 0.00/s 15 7 0.00/s 16 8 0.00/s 17 8 0.00/s 18 11 0.00/s 19 8 0.00/s 20 13 0.00/s 21 9 0.00/s 22 13 0.00/s 23 8 0.00/s Day Hour Count Average Duration Average idle time Aug 15 00 7 51m40s 51m17s 01 19 52m31s 52m29s 02 14 41m25s 41m22s 03 24 25m7s 25m5s 04 13 43m46s 43m42s 05 11 51m26s 49m16s 06 9 55m29s 55m20s 07 17 47m 45m48s 08 12 49m24s 48m25s 09 8 53m37s 52m9s 10 13 45m48s 44m52s 11 8 51m52s 50m19s 12 9 56m11s 54m56s 13 10 45m31s 44m19s 14 11 42m59s 41m53s 15 9 53m27s 52m8s 16 7 52m52s 51m12s 17 8 49m46s 48m21s 18 10 47m9s 46m 19 8 1h37s 59m10s 20 13 39m2s 37m 21 10 48m15s 46m54s 22 12 34m19s 33m14s 23 15 37m4s 34m16s -
Connections
Established Connections
Key values
- 8 connections Connection Peak
- 2026-08-15 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 278 connections Total
Connections per user
Key values
- intelifix Main User
- 278 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-08-15 03:05:17 Date
Histogram of session times
Key values
- 175 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 277 sessions Total
Sessions per user
Key values
- intelifix Main User
- 277 sessions Total
Sessions per host
Key values
- [local] Main Host
- 277 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 33,448 buffers Checkpoint Peak
- 2026-08-15 00:09:38 Date
- 269.770 seconds Highest write time
- 0.122 seconds Sync time
Checkpoints Wal files
Key values
- 7 files Wal files usage Peak
- 2026-08-15 00:19:38 Date
Checkpoints distance
Key values
- 202.42 Mo Distance Peak
- 2026-08-15 00:19:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 15 00 58,994 856.112s 0.208s 856.439s 01 2,213 222.683s 0.147s 222.909s 02 2,120 213.105s 0.072s 213.237s 03 3,552 356.159s 0.105s 356.347s 04 2,460 247.203s 0.119s 247.379s 05 10,272 974.261s 0.326s 974.659s 06 5,417 269.662s 0.012s 269.685s 07 3,449 346.291s 0.049s 346.39s 08 224 22.561s 0.011s 22.591s 09 33 3.395s 0.016s 3.435s 10 23 2.333s 0.005s 2.346s 11 73 7.416s 0.085s 7.526s 12 23 2.331s 0.005s 2.344s 13 24 2.43s 0.004s 2.441s 14 23 2.331s 0.005s 2.345s 15 23 2.33s 0.004s 2.341s 16 24 2.431s 0.003s 2.441s 17 23 2.329s 0.005s 2.34s 18 1,110 111.183s 0.011s 111.22s 19 24 2.432s 0.005s 2.443s 20 327 35.172s 0.027s 35.232s 21 81 8.207s 0.077s 8.32s 22 25 2.574s 0.007s 2.596s 23 83 8.364s 0.006s 8.393s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 15 00 0 0 11 834 0.040s 0.012s 01 0 0 0 522 0.064s 0.012s 02 0 0 1 452 0.007s 0.008s 03 0 0 1 607 0.019s 0.009s 04 0 0 1 412 0.061s 0.006s 05 0 0 4 759 0.059s 0.008s 06 0 0 1 53 0.007s 0.001s 07 0 0 1 226 0.011s 0.007s 08 0 0 0 54 0.003s 0.006s 09 0 0 0 14 0.007s 0.005s 10 0 0 0 3 0.003s 0.002s 11 0 0 0 46 0.061s 0.024s 12 0 0 0 3 0.003s 0.002s 13 0 0 0 3 0.002s 0.002s 14 0 0 0 3 0.003s 0.002s 15 0 0 0 3 0.002s 0.002s 16 0 0 0 3 0.002s 0.001s 17 0 0 0 3 0.003s 0.002s 18 0 0 1 54 0.002s 0.003s 19 0 0 0 3 0.003s 0.002s 20 0 0 0 24 0.008s 0.005s 21 0 0 0 17 0.065s 0.027s 22 0 0 0 4 0.003s 0.005s 23 0 0 0 6 0.004s 0.003s Day Hour Count Avg time (sec) Aug 15 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Aug 15 00 16,765.80 kB 64,511.70 kB 01 1,174.00 kB 31,473.56 kB 02 1,493.86 kB 14,139.86 kB 03 2,037.22 kB 4,195.33 kB 04 2,053.50 kB 3,185.67 kB 05 9,471.25 kB 16,081.12 kB 06 13,064.00 kB 15,693.00 kB 07 2,703.83 kB 12,122.33 kB 08 458.00 kB 7,766.33 kB 09 72.33 kB 5,690.67 kB 10 187.00 kB 4,613.00 kB 11 436.00 kB 3,838.00 kB 12 187.00 kB 3,150.00 kB 13 187.00 kB 2,854.00 kB 14 187.00 kB 2,587.00 kB 15 187.00 kB 2,347.00 kB 16 187.00 kB 2,131.00 kB 17 187.00 kB 1,937.00 kB 18 1,139.33 kB 2,802.00 kB 19 187.00 kB 2,294.00 kB 20 542.33 kB 1,972.00 kB 21 129.00 kB 1,506.67 kB 22 96.00 kB 1,171.00 kB 23 58.00 kB 964.50 kB -
Temporary Files
Size of temporary files
Key values
- 481.64 MiB Temp Files size Peak
- 2026-08-15 05:32:08 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-15 05:32:15 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 15 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.09 GiB 111.93 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 935.51 MiB 71.83 MiB 240.82 MiB 116.94 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-15 05:32:17 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-15 05:32:08 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 183.78 MiB 91.89 MiB 91.89 MiB 91.89 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-15 05:30:44 Duration: 41s570ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-15 05:30:40 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 240.82 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-15 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 240.82 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-15 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 91.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-15 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 91.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-15 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 79.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-15 05:32:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 79.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-15 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 79.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-15 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 71.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-15 05:32:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 71.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-15 05:32:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-15 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 2.35 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database brasilia - 2026-08-15 00:06:06 Date
- 0 sec Highest CPU-cost analyze
Table
Database brasilia - Date
Average Autovacuum Duration
Key values
- 2.35 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database brasilia - 2026-08-15 00:06:06 Date
Analyzes per table
Key values
- public.temp0000288542 (11) Main table analyzed (database rio)
- 18 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_statistic (1) Main table vacuumed on database rio
- 10 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,586 945 3,969,842 884 5,453 rio.pg_catalog.pg_class 1 1 0 0 0 0 0 466 176 162,306 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,632 378 1,524,371 345 2,413 rio.public.temp0000288548 1 0 0 0 0 0 0 8 5 1,376 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 157 34 107,170 4 9 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,429 437 1,557,413 402 2,951 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 915 247 1,138,591 147 489 brasilia.auditor.auditor_2026_08 1 0 0 0 0 0 0 13,581 12,904 16,707,868 64 250 rio.public.temp0000288552 1 0 0 0 0 0 0 122 6 8,185 0 0 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 177 34 107,300 15 38 Total 10 7 0 0 0 0 0 24,073 15,166 25,284,422 1,861 11,603 Vacuum throughput per table
Key values
- auditor.auditor_2026_08 (2.35) Max CPU elapsed for vacuum on database brasilia
- unknown (0 ms) Max I/O read time for vacuum on database brasilia
- unknown (0 ms) Max I/O write time for vacuum on database brasilia
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_statistic 0 0 0.37 rio.pg_catalog.pg_class 0 0 0.23 brasilia.pg_catalog.pg_statistic 0 0 0.21 rio.public.temp0000288548 0 0 0.02 contagem.pg_toast.pg_toast_2619 0 0 0.01 contagem.pg_catalog.pg_statistic 0 0 0.11 rio.pg_toast.pg_toast_2619 0 0 0.05 brasilia.auditor.auditor_2026_08 0 0 2.35 rio.public.temp0000288552 0 0 0.02 brasilia.pg_toast.pg_toast_2619 0 0 0 Total 0 0 3.37 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4313) Main table with removed tuples on database rio
- 15315 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,313 7,506 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,233 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,922 7,346 0 0 1,072 brasilia.auditor.auditor_2026_08 1 0 1,519 2,295,597 0 0 101,280 rio.pg_toast.pg_toast_2619 1 1 702 676 0 0 287 rio.pg_catalog.pg_class 1 1 335 4,132 0 108 133 brasilia.pg_toast.pg_toast_2619 1 1 147 136 0 0 68 contagem.pg_toast.pg_toast_2619 1 1 144 117 0 0 62 rio.public.temp0000288548 1 0 0 2,118 0 14 114 rio.public.temp0000288552 1 0 0 2,118 0 14 114 Total 10 7 15,315 2,327,020 0 136 105,427 Pages removed per table
Key values
- pg_catalog.pg_class (108) Main table with removed pages on database rio
- 136 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_catalog.pg_class 1 1 335 108 rio.public.temp0000288548 1 0 0 14 rio.public.temp0000288552 1 0 0 14 rio.pg_catalog.pg_statistic 1 1 4313 0 brasilia.pg_catalog.pg_statistic 1 1 3922 0 contagem.pg_toast.pg_toast_2619 1 1 144 0 contagem.pg_catalog.pg_statistic 1 1 4233 0 rio.pg_toast.pg_toast_2619 1 1 702 0 brasilia.auditor.auditor_2026_08 1 0 1519 0 brasilia.pg_toast.pg_toast_2619 1 1 147 0 Total 10 7 15,315 136 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 15 00 2 7 01 0 1 02 0 0 03 0 2 04 0 0 05 6 6 06 0 0 07 1 1 08 1 1 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 2.35 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
- 228 Total read queries
- 405 Total write queries
Queries by database
Key values
- rio Main database
- 512 Requests
- 3h12m54s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 1,026 Requests
User Request type Count Duration etiquetas Total 7 3s394ms select 7 3s394ms intelifix Total 1,026 4h46m55s copy to 402 51m37s ddl 3 49s244ms others 420 45m15s select 201 3h9m13s lenon Total 20 39s98ms select 20 39s98ms Duration by user
Key values
- 4h46m55s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 7 3s394ms select 7 3s394ms intelifix Total 1,026 4h46m55s copy to 402 51m37s ddl 3 49s244ms others 420 45m15s select 201 3h9m13s lenon Total 20 39s98ms select 20 39s98ms Queries by host
Key values
- [local] Main host
- 1,053 Requests
- 4h47m37s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 526 Requests
- 3h54m31s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-15 12:57:35 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 438 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 11m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-15 07:16:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 10m45s analyze verbose;[ Date: 2026-08-15 05:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-15 21:13:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-15 20:13:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m56s analyze verbose;[ Date: 2026-08-15 05:17:43 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
6 6m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-15 11:11:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-15 22:11:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-15 10:11:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-15 14:11:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-15 13:11:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-15 09:11:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-15 16:11:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-15 15:11:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-15 19:11:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-15 08:11:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 6m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-15 12:11:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 6m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-15 18:11:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 6m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-15 17:11:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 4m48s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-15 07:23:43 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 4m28s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-15 20:20:15 - 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 1h58m36s 48 1s450ms 11m24s 2m28s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 15 07 3 12m21s 4m7s 08 3 6m35s 2m11s 09 3 6m45s 2m15s 10 3 7m2s 2m20s 11 3 7m11s 2m23s 12 3 6m32s 2m10s 13 3 6m52s 2m17s 14 3 6m58s 2m19s 15 3 6m41s 2m13s 16 3 6m43s 2m14s 17 3 6m29s 2m9s 18 3 6m32s 2m10s 19 3 6m37s 2m12s 20 3 9m10s 3m3s 21 3 8m47s 2m55s 22 3 7m12s 2m24s [ User: intelifix - Total duration: 1h58m36s - Times executed: 48 ]
[ Application: psql - Total duration: 1h58m36s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-15 07:16:26 Duration: 11m24s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-15 21:13:30 Duration: 8m28s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-15 20:13:27 Duration: 8m25s Database: rio User: intelifix Remote: [local] Application: psql
2 1h10m4s 48 248ms 4m48s 1m27s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 15 07 3 6m32s 2m10s 08 3 4m 1m20s 09 3 4m2s 1m20s 10 3 4m13s 1m24s 11 3 4m1s 1m20s 12 3 3m52s 1m17s 13 3 4m11s 1m23s 14 3 4m8s 1m22s 15 3 4m11s 1m23s 16 3 4m7s 1m22s 17 3 3m58s 1m19s 18 3 4m3s 1m21s 19 3 3m58s 1m19s 20 3 6m11s 2m3s 21 3 3m47s 1m15s 22 3 4m40s 1m33s [ User: intelifix - Total duration: 1h10m4s - Times executed: 48 ]
[ Application: psql - Total duration: 1h10m4s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-15 07:23:43 Duration: 4m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-15 20:20:15 Duration: 4m28s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-15 22:16:51 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
3 20m46s 3 3m5s 10m45s 6m55s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 15 05 3 20m46s 6m55s [ User: intelifix - Total duration: 20m46s - Times executed: 3 ]
[ Application: psql - Total duration: 20m46s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-15 05:10:46 Duration: 10m45s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-15 05:17:43 Duration: 6m56s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-15 05:20:48 Duration: 3m5s Database: contagem User: intelifix Remote: [local] Application: psql
4 13m39s 276 230ms 17s380ms 2s970ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 15 00 12 47s301ms 3s941ms 01 12 33s753ms 2s812ms 02 12 33s21ms 2s751ms 03 12 37s503ms 3s125ms 04 12 36s137ms 3s11ms 05 12 34s229ms 2s852ms 06 12 37s777ms 3s148ms 07 12 34s45ms 2s837ms 08 12 35s520ms 2s960ms 09 12 34s369ms 2s864ms 10 12 36s176ms 3s14ms 11 12 34s721ms 2s893ms 12 12 30s940ms 2s578ms 13 12 36s617ms 3s51ms 14 12 34s927ms 2s910ms 15 12 35s53ms 2s921ms 16 12 30s914ms 2s576ms 17 12 34s6ms 2s833ms 18 12 32s776ms 2s731ms 19 12 35s145ms 2s928ms 20 12 45s645ms 3s803ms 21 12 32s421ms 2s701ms 22 12 36s956ms 3s79ms [ User: intelifix - Total duration: 13m39s - Times executed: 276 ]
[ Application: psql - Total duration: 13m39s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-15 00:05:40 Duration: 17s380ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-15 20:15:15 Duration: 13s926ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-15 03:15:13 Duration: 7s274ms Database: rio User: intelifix Remote: [local] Application: psql
5 3m38s 4 5s287ms 1m46s 54s569ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 15 20 2 1m46s 53s185ms 23 2 1m51s 55s953ms [ User: intelifix - Total duration: 3m38s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m38s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-15 23:17:41 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-15 20:09:31 Duration: 1m41s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-15 23:40:25 Duration: 5s567ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 3m17s 54 2s816ms 13s444ms 3s655ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 15 08 4 18s747ms 4s686ms 09 5 16s579ms 3s315ms 10 3 9s609ms 3s203ms 11 3 14s954ms 4s984ms 12 4 12s351ms 3s87ms 13 3 9s643ms 3s214ms 14 3 9s645ms 3s215ms 15 3 9s878ms 3s292ms 16 4 13s93ms 3s273ms 17 4 12s472ms 3s118ms 18 4 13s158ms 3s289ms 19 3 11s208ms 3s736ms 20 3 9s638ms 3s212ms 21 4 12s900ms 3s225ms 22 4 23s494ms 5s873ms [ User: intelifix - Total duration: 3m17s - Times executed: 54 ]
[ Application: psql - Total duration: 3m17s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-15 22:40:18 Duration: 13s444ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-15 08:00:14 Duration: 9s202ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-15 11:00:13 Duration: 8s608ms Database: brasilia User: intelifix Remote: [local] Application: psql
7 2m9s 4 418ms 1m4s 32s270ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 15 20 2 1m5s 32s656ms 23 2 1m3s 31s884ms [ User: intelifix - Total duration: 2m9s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m9s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-15 20:05:57 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-15 23:13:57 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-15 23:39:45 Duration: 462ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 2m1s 36 2s880ms 4s355ms 3s362ms 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 #8
Day Hour Count Duration Avg duration Aug 15 08 2 7s396ms 3s698ms 09 1 3s554ms 3s554ms 10 3 9s747ms 3s249ms 11 3 10s136ms 3s378ms 12 2 7s110ms 3s555ms 13 3 9s767ms 3s255ms 14 3 10s365ms 3s455ms 15 3 9s926ms 3s308ms 16 2 6s329ms 3s164ms 17 2 7s14ms 3s507ms 18 2 6s496ms 3s248ms 19 3 9s405ms 3s135ms 20 3 10s777ms 3s592ms 21 2 6s683ms 3s341ms 22 2 6s332ms 3s166ms [ User: intelifix - Total duration: 2m1s - Times executed: 36 ]
[ Application: psql - Total duration: 2m1s - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-15 08:00:05 Duration: 4s355ms 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-08-15 20:20:05 Duration: 4s47ms 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-08-15 14:40:05 Duration: 3s986ms Database: rio User: intelifix Remote: [local] Application: psql
9 1m47s 38 181ms 20s919ms 2s829ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 15 00 6 33s255ms 5s542ms 01 6 14s112ms 2s352ms 02 6 14s550ms 2s425ms 03 5 14s159ms 2s831ms 04 6 13s605ms 2s267ms 05 5 12s844ms 2s568ms 07 2 4s418ms 2s209ms 20 2 584ms 292ms [ User: intelifix - Total duration: 1m47s - Times executed: 38 ]
[ Application: psql - Total duration: 1m47s - Times executed: 38 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-15 00:05:22 Duration: 20s919ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-15 05:35:07 Duration: 6s385ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-15 03:15:06 Duration: 4s572ms Database: rio User: intelifix Remote: [local] Application: psql
10 1m37s 6 3s802ms 35s998ms 16s201ms 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 #10
Day Hour Count Duration Avg duration Aug 15 20 3 47s341ms 15s780ms 23 3 49s868ms 16s622ms [ User: intelifix - Total duration: 1m37s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m37s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-15 23:14:35 Duration: 35s998ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-15 20:06:32 Duration: 33s190ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-15 20:10:59 Duration: 10s348ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 1m33s 1 1m33s 1m33s 1m33s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 15 05 1 1m33s 1m33s [ User: intelifix - Total duration: 1m33s - Times executed: 1 ]
[ Application: psql - Total duration: 1m33s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-15 05:32:17 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-15 05:32:08 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
12 1m25s 6 8s936ms 20s572ms 14s293ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 15 00 3 56s620ms 18s873ms 06 3 29s139ms 9s713ms [ User: intelifix - Total duration: 1m25s - Times executed: 6 ]
[ Application: psql - Total duration: 1m25s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-15 00:05:23 Duration: 20s572ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-15 00:05:59 Duration: 19s25ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-15 00:05:40 Duration: 17s22ms Database: brasilia User: intelifix Remote: [local] Application: psql
13 1m21s 6 2s240ms 32s347ms 13s570ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 15 20 3 39s969ms 13s323ms 23 3 41s454ms 13s818ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-15 23:15:12 Duration: 32s347ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-15 20:07:07 Duration: 30s580ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-15 20:11:07 Duration: 7s148ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1m13s 6 2s933ms 28s903ms 12s232ms 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 #14
Day Hour Count Duration Avg duration Aug 15 20 3 34s823ms 11s607ms 23 3 38s571ms 12s857ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-15 23:18:10 Duration: 28s903ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-15 20:09:57 Duration: 25s759ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-15 23:40:31 Duration: 6s733ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1m6s 6 1s930ms 22s564ms 11s65ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 15 20 3 32s745ms 10s915ms 23 3 33s645ms 11s215ms [ User: intelifix - Total duration: 1m6s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m6s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 20:03:29 Duration: 22s564ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 23:11:29 Duration: 22s336ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 23:39:25 Duration: 9s256ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1m4s 6 1s771ms 26s377ms 10s794ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 15 20 3 31s269ms 10s423ms 23 3 33s499ms 11s166ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-15 23:12:31 Duration: 26s377ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-15 20:04:30 Duration: 24s931ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-15 23:39:41 Duration: 5s290ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1m4s 6 2s167ms 21s655ms 10s743ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 15 20 3 31s897ms 10s632ms 23 3 32s565ms 10s855ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 20:02:48 Duration: 21s655ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 23:10:50 Duration: 21s594ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 23:39:13 Duration: 8s804ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 51s455ms 6 1s526ms 17s578ms 8s575ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 15 20 3 26s5ms 8s668ms 23 3 25s449ms 8s483ms [ User: intelifix - Total duration: 51s455ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s455ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-15 20:03:47 Duration: 17s578ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-15 23:11:45 Duration: 16s450ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-15 23:39:32 Duration: 7s40ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 51s332ms 4 3s648ms 22s356ms 12s833ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 15 20 2 25s88ms 12s544ms 23 2 26s243ms 13s121ms [ User: intelifix - Total duration: 51s332ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 51s332ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-15 23:12:53 Duration: 22s356ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-15 20:04:52 Duration: 21s440ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-15 23:39:45 Duration: 3s886ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 44s971ms 6 4s52ms 9s595ms 7s495ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 15 20 3 22s304ms 7s434ms 23 3 22s667ms 7s555ms [ User: intelifix - Total duration: 44s971ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 44s971ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-15 20:07:36 Duration: 9s595ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-15 23:40:17 Duration: 9s422ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-15 23:15:38 Duration: 9s103ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 276 13m39s 230ms 17s380ms 2s970ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 15 00 12 47s301ms 3s941ms 01 12 33s753ms 2s812ms 02 12 33s21ms 2s751ms 03 12 37s503ms 3s125ms 04 12 36s137ms 3s11ms 05 12 34s229ms 2s852ms 06 12 37s777ms 3s148ms 07 12 34s45ms 2s837ms 08 12 35s520ms 2s960ms 09 12 34s369ms 2s864ms 10 12 36s176ms 3s14ms 11 12 34s721ms 2s893ms 12 12 30s940ms 2s578ms 13 12 36s617ms 3s51ms 14 12 34s927ms 2s910ms 15 12 35s53ms 2s921ms 16 12 30s914ms 2s576ms 17 12 34s6ms 2s833ms 18 12 32s776ms 2s731ms 19 12 35s145ms 2s928ms 20 12 45s645ms 3s803ms 21 12 32s421ms 2s701ms 22 12 36s956ms 3s79ms [ User: intelifix - Total duration: 13m39s - Times executed: 276 ]
[ Application: psql - Total duration: 13m39s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-15 00:05:40 Duration: 17s380ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-15 20:15:15 Duration: 13s926ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-15 03:15:13 Duration: 7s274ms Database: rio User: intelifix Remote: [local] Application: psql
2 54 3m17s 2s816ms 13s444ms 3s655ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 15 08 4 18s747ms 4s686ms 09 5 16s579ms 3s315ms 10 3 9s609ms 3s203ms 11 3 14s954ms 4s984ms 12 4 12s351ms 3s87ms 13 3 9s643ms 3s214ms 14 3 9s645ms 3s215ms 15 3 9s878ms 3s292ms 16 4 13s93ms 3s273ms 17 4 12s472ms 3s118ms 18 4 13s158ms 3s289ms 19 3 11s208ms 3s736ms 20 3 9s638ms 3s212ms 21 4 12s900ms 3s225ms 22 4 23s494ms 5s873ms [ User: intelifix - Total duration: 3m17s - Times executed: 54 ]
[ Application: psql - Total duration: 3m17s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-15 22:40:18 Duration: 13s444ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-15 08:00:14 Duration: 9s202ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-15 11:00:13 Duration: 8s608ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 48 1h58m36s 1s450ms 11m24s 2m28s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 15 07 3 12m21s 4m7s 08 3 6m35s 2m11s 09 3 6m45s 2m15s 10 3 7m2s 2m20s 11 3 7m11s 2m23s 12 3 6m32s 2m10s 13 3 6m52s 2m17s 14 3 6m58s 2m19s 15 3 6m41s 2m13s 16 3 6m43s 2m14s 17 3 6m29s 2m9s 18 3 6m32s 2m10s 19 3 6m37s 2m12s 20 3 9m10s 3m3s 21 3 8m47s 2m55s 22 3 7m12s 2m24s [ User: intelifix - Total duration: 1h58m36s - Times executed: 48 ]
[ Application: psql - Total duration: 1h58m36s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-15 07:16:26 Duration: 11m24s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-15 21:13:30 Duration: 8m28s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-15 20:13:27 Duration: 8m25s Database: rio User: intelifix Remote: [local] Application: psql
4 48 1h10m4s 248ms 4m48s 1m27s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 15 07 3 6m32s 2m10s 08 3 4m 1m20s 09 3 4m2s 1m20s 10 3 4m13s 1m24s 11 3 4m1s 1m20s 12 3 3m52s 1m17s 13 3 4m11s 1m23s 14 3 4m8s 1m22s 15 3 4m11s 1m23s 16 3 4m7s 1m22s 17 3 3m58s 1m19s 18 3 4m3s 1m21s 19 3 3m58s 1m19s 20 3 6m11s 2m3s 21 3 3m47s 1m15s 22 3 4m40s 1m33s [ User: intelifix - Total duration: 1h10m4s - Times executed: 48 ]
[ Application: psql - Total duration: 1h10m4s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-15 07:23:43 Duration: 4m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-15 20:20:15 Duration: 4m28s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-15 22:16:51 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
5 38 1m47s 181ms 20s919ms 2s829ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 15 00 6 33s255ms 5s542ms 01 6 14s112ms 2s352ms 02 6 14s550ms 2s425ms 03 5 14s159ms 2s831ms 04 6 13s605ms 2s267ms 05 5 12s844ms 2s568ms 07 2 4s418ms 2s209ms 20 2 584ms 292ms [ User: intelifix - Total duration: 1m47s - Times executed: 38 ]
[ Application: psql - Total duration: 1m47s - Times executed: 38 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-15 00:05:22 Duration: 20s919ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-15 05:35:07 Duration: 6s385ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-15 03:15:06 Duration: 4s572ms Database: rio User: intelifix Remote: [local] Application: psql
6 38 9s881ms 154ms 754ms 260ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 15 00 17 3s496ms 205ms 03 8 3s679ms 459ms 04 2 340ms 170ms 05 11 2s364ms 214ms [ User: intelifix - Total duration: 9s881ms - Times executed: 38 ]
[ Application: [unknown] - Total duration: 9s881ms - Times executed: 38 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241779559202,241721636680,241753719395,241706270827,241725725867,241734608686,241704907595,241750295661,241784591422,241752947087,241720030318,241784452037,241750535157,241755814348,241750568897,241784444157,241753647189,241736620018,241752241228,241723239508,241752272645,241736667698,241753571425,241758123743,241753898606,241753728184,241725616687,241755653042,241754919299,241755965272,241723847984,241748281526,241735389403,241784554347,241748257078,241758175869,241758580309,241735962849,241706121923,241721604051,241720354647,241752287494,241779526067,241721728080,241781551619,241755582328,241784495475,241784742828,241719985262,241722499301,241721590919,241750453455,241725817694,241737107494,241722357794,241720303655,241722350522,241752382936,241757193338,241753878907,241752227892,241736766473,241725749607,241725656163,241753626177,241752389300,241725814967,241750552937,241750117686,241722420910,241750436483,241758966586', NULL, NULL, 0463, 00);
Date: 2026-08-15 03:22:13 Duration: 754ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241758612837,241722478793,241722533143,241752950220,241735388695,241784608594,241751216570,241780590527,241755922945,241751071125,241784102934,241748420406,241719158908,241794149717,241724215978,241781505677,241755158290,241724411834,241789449303,241751451723,241782493540,241736402544,241751957686,241755095961', NULL, NULL, 0463, 00);
Date: 2026-08-15 03:13:51 Duration: 720ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241748596483,241781577176,241722343652,241722571228,241736858200,241720100729,241755828894,241753619813,241780524459,241725662528,241748938491,241758292323,241783551029,241781711029,241750258485,241736586680,241757653439,241783365151,241783349819,241757682028,241783362121,241789456677,241751550218,241748874445,241752225367,241736773141,241750448404,241752209103,241736620927,241737144243,241784646578,241720378487,241750014141,241784505880,241722555973,241758630314,241755689005,241783259507,241737871419,241784603948,241720418794,241721054547,241757295267,241784508204,241784475877,241722557387,241754706776,241734698089,241705073751,241750517074,241754702231,241735739314,241751499909,241718772832,241718989597,241748747990,241783295975,241781864859,241757868689', NULL, NULL, 0463, 00);
Date: 2026-08-15 03:18:22 Duration: 652ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 36 2m1s 2s880ms 4s355ms 3s362ms 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 #7
Day Hour Count Duration Avg duration Aug 15 08 2 7s396ms 3s698ms 09 1 3s554ms 3s554ms 10 3 9s747ms 3s249ms 11 3 10s136ms 3s378ms 12 2 7s110ms 3s555ms 13 3 9s767ms 3s255ms 14 3 10s365ms 3s455ms 15 3 9s926ms 3s308ms 16 2 6s329ms 3s164ms 17 2 7s14ms 3s507ms 18 2 6s496ms 3s248ms 19 3 9s405ms 3s135ms 20 3 10s777ms 3s592ms 21 2 6s683ms 3s341ms 22 2 6s332ms 3s166ms [ User: intelifix - Total duration: 2m1s - Times executed: 36 ]
[ Application: psql - Total duration: 2m1s - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-15 08:00:05 Duration: 4s355ms 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-08-15 20:20:05 Duration: 4s47ms 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-08-15 14:40:05 Duration: 3s986ms Database: rio User: intelifix Remote: [local] Application: psql
8 14 5s870ms 316ms 583ms 419ms 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 #8
Day Hour Count Duration Avg duration Aug 15 00 3 1s278ms 426ms 02 1 583ms 583ms 03 2 854ms 427ms 04 1 340ms 340ms 05 3 1s205ms 401ms 07 2 846ms 423ms 09 1 349ms 349ms 11 1 412ms 412ms [ User: lenon - Total duration: 5s870ms - Times executed: 14 ]
[ Application: [unknown] - Total duration: 5s870ms - Times executed: 14 ]
-
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-08-15 02:18:46 Duration: 583ms Database: rio 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-08-15 00:29:47 Duration: 529ms Database: rio 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-08-15 03:47:34 Duration: 481ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 10 5s567ms 391ms 831ms 556ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 15 00 3 1s737ms 579ms 02 1 755ms 755ms 03 1 553ms 553ms 04 1 468ms 468ms 05 3 1s554ms 518ms 09 1 498ms 498ms [ User: intelifix - Total duration: 5s567ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 5s567ms - Times executed: 10 ]
-
select * from rs_menu_grants (499, 0, 1);
Date: 2026-08-15 00:29:47 Duration: 831ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (499, 81, 1);
Date: 2026-08-15 02:18:46 Duration: 755ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-08-15 05:04:13 Duration: 564ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7 2s520ms 186ms 489ms 360ms select p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault(?, p.proowner) as acldefault, p.pronamespace, p.proowner from pg_proc p left join pg_init_privs pip on (p.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?) where p.prokind <> ? and not exists ( select ? from pg_depend where classid = ?::regclass and objid = p.oid and deptype = ?) and (pronamespace != ( select oid from pg_namespace where nspname = ?) or exists ( select ? from pg_cast where pg_cast.oid > ? and p.oid = pg_cast.castfunc) or exists ( select ? from pg_transform where pg_transform.oid > ? and (p.oid = pg_transform.trffromsql or p.oid = pg_transform.trftosql)) or p.proacl is distinct from pip.initprivs);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 15 20 3 921ms 307ms 23 4 1s598ms 399ms [ User: intelifix - Total duration: 2s520ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s520ms - Times executed: 7 ]
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-15 20:02:03 Duration: 489ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-15 23:10:02 Duration: 472ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-15 23:38:51 Duration: 405ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 7 1s862ms 179ms 436ms 266ms select c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( case when c.relkind = ? then ?::"char" else ?::"char" end, c.relowner) as acldefault, case when c.relkind = ? then ( select ftserver from pg_catalog.pg_foreign_table where ftrelid = c.oid) else ? end as foreignserver, c.relfrozenxid, tc.relfrozenxid as tfrozenxid, tc.oid as toid, tc.relpages as toastpages, tc.reloptions as toast_reloptions, d.refobjid as owning_tab, d.refobjsubid as owning_col, tsp.spcname as reltablespace, false as relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid as tminmxid, array_remove(array_remove(c.reloptions, ?), ?) as reloptions, case when ? = any (c.reloptions) then ?::text when ? = any (c.reloptions) then ?::text else null end as checkoption, am.amname, (d.deptype = ?) is true as is_identity_sequence, c.relispartition as ispartition from pg_class c left join pg_depend d on (c.relkind = ? and d.classid = ?::regclass and d.objid = c.oid and d.objsubid = ? and d.refclassid = ?::regclass and d.deptype in (...)) left join pg_tablespace tsp on (tsp.oid = c.reltablespace) left join pg_am am on (c.relam = am.oid) left join pg_class tc on (c.reltoastrelid = tc.oid and tc.relkind = ? and c.relkind <> ?) where c.relkind in (...) order by c.oid;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 15 20 3 684ms 228ms 23 4 1s178ms 294ms [ User: intelifix - Total duration: 1s862ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 1s862ms - Times executed: 7 ]
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-08-15 23:10:02 Duration: 436ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-08-15 23:18:11 Duration: 351ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-08-15 20:02:02 Duration: 301ms Database: rio User: intelifix Remote: [local] Application: pg_dump
12 6 1m37s 3s802ms 35s998ms 16s201ms 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 #12
Day Hour Count Duration Avg duration Aug 15 20 3 47s341ms 15s780ms 23 3 49s868ms 16s622ms [ User: intelifix - Total duration: 1m37s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m37s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-15 23:14:35 Duration: 35s998ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-15 20:06:32 Duration: 33s190ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-15 20:10:59 Duration: 10s348ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 1m25s 8s936ms 20s572ms 14s293ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 15 00 3 56s620ms 18s873ms 06 3 29s139ms 9s713ms [ User: intelifix - Total duration: 1m25s - Times executed: 6 ]
[ Application: psql - Total duration: 1m25s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-15 00:05:23 Duration: 20s572ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-15 00:05:59 Duration: 19s25ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-15 00:05:40 Duration: 17s22ms Database: brasilia User: intelifix Remote: [local] Application: psql
14 6 1m21s 2s240ms 32s347ms 13s570ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 15 20 3 39s969ms 13s323ms 23 3 41s454ms 13s818ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-15 23:15:12 Duration: 32s347ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-15 20:07:07 Duration: 30s580ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-15 20:11:07 Duration: 7s148ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 1m13s 2s933ms 28s903ms 12s232ms 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 #15
Day Hour Count Duration Avg duration Aug 15 20 3 34s823ms 11s607ms 23 3 38s571ms 12s857ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-15 23:18:10 Duration: 28s903ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-15 20:09:57 Duration: 25s759ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-15 23:40:31 Duration: 6s733ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 1m6s 1s930ms 22s564ms 11s65ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 15 20 3 32s745ms 10s915ms 23 3 33s645ms 11s215ms [ User: intelifix - Total duration: 1m6s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m6s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 20:03:29 Duration: 22s564ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 23:11:29 Duration: 22s336ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 23:39:25 Duration: 9s256ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 6 1m4s 1s771ms 26s377ms 10s794ms 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 #17
Day Hour Count Duration Avg duration Aug 15 20 3 31s269ms 10s423ms 23 3 33s499ms 11s166ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-15 23:12:31 Duration: 26s377ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-15 20:04:30 Duration: 24s931ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-15 23:39:41 Duration: 5s290ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 1m4s 2s167ms 21s655ms 10s743ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 15 20 3 31s897ms 10s632ms 23 3 32s565ms 10s855ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 20:02:48 Duration: 21s655ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 23:10:50 Duration: 21s594ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 23:39:13 Duration: 8s804ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 51s455ms 1s526ms 17s578ms 8s575ms 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 #19
Day Hour Count Duration Avg duration Aug 15 20 3 26s5ms 8s668ms 23 3 25s449ms 8s483ms [ User: intelifix - Total duration: 51s455ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s455ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-15 20:03:47 Duration: 17s578ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-15 23:11:45 Duration: 16s450ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-15 23:39:32 Duration: 7s40ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 44s971ms 4s52ms 9s595ms 7s495ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 15 20 3 22s304ms 7s434ms 23 3 22s667ms 7s555ms [ User: intelifix - Total duration: 44s971ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 44s971ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-15 20:07:36 Duration: 9s595ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-15 23:40:17 Duration: 9s422ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-15 23:15:38 Duration: 9s103ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m5s 10m45s 6m55s 3 20m46s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 15 05 3 20m46s 6m55s [ User: intelifix - Total duration: 20m46s - Times executed: 3 ]
[ Application: psql - Total duration: 20m46s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-15 05:10:46 Duration: 10m45s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-15 05:17:43 Duration: 6m56s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-15 05:20:48 Duration: 3m5s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s450ms 11m24s 2m28s 48 1h58m36s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 15 07 3 12m21s 4m7s 08 3 6m35s 2m11s 09 3 6m45s 2m15s 10 3 7m2s 2m20s 11 3 7m11s 2m23s 12 3 6m32s 2m10s 13 3 6m52s 2m17s 14 3 6m58s 2m19s 15 3 6m41s 2m13s 16 3 6m43s 2m14s 17 3 6m29s 2m9s 18 3 6m32s 2m10s 19 3 6m37s 2m12s 20 3 9m10s 3m3s 21 3 8m47s 2m55s 22 3 7m12s 2m24s [ User: intelifix - Total duration: 1h58m36s - Times executed: 48 ]
[ Application: psql - Total duration: 1h58m36s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-15 07:16:26 Duration: 11m24s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-15 21:13:30 Duration: 8m28s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-15 20:13:27 Duration: 8m25s Database: rio User: intelifix Remote: [local] Application: psql
3 1m33s 1m33s 1m33s 1 1m33s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 15 05 1 1m33s 1m33s [ User: intelifix - Total duration: 1m33s - Times executed: 1 ]
[ Application: psql - Total duration: 1m33s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-15 05:32:17 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-15 05:32:08 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 248ms 4m48s 1m27s 48 1h10m4s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 15 07 3 6m32s 2m10s 08 3 4m 1m20s 09 3 4m2s 1m20s 10 3 4m13s 1m24s 11 3 4m1s 1m20s 12 3 3m52s 1m17s 13 3 4m11s 1m23s 14 3 4m8s 1m22s 15 3 4m11s 1m23s 16 3 4m7s 1m22s 17 3 3m58s 1m19s 18 3 4m3s 1m21s 19 3 3m58s 1m19s 20 3 6m11s 2m3s 21 3 3m47s 1m15s 22 3 4m40s 1m33s [ User: intelifix - Total duration: 1h10m4s - Times executed: 48 ]
[ Application: psql - Total duration: 1h10m4s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-15 07:23:43 Duration: 4m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-15 20:20:15 Duration: 4m28s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-15 22:16:51 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
5 5s287ms 1m46s 54s569ms 4 3m38s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 15 20 2 1m46s 53s185ms 23 2 1m51s 55s953ms [ User: intelifix - Total duration: 3m38s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m38s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-15 23:17:41 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-15 20:09:31 Duration: 1m41s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-15 23:40:25 Duration: 5s567ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 418ms 1m4s 32s270ms 4 2m9s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 15 20 2 1m5s 32s656ms 23 2 1m3s 31s884ms [ User: intelifix - Total duration: 2m9s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m9s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-15 20:05:57 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-15 23:13:57 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-15 23:39:45 Duration: 462ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 3s802ms 35s998ms 16s201ms 6 1m37s 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 Aug 15 20 3 47s341ms 15s780ms 23 3 49s868ms 16s622ms [ User: intelifix - Total duration: 1m37s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m37s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-15 23:14:35 Duration: 35s998ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-15 20:06:32 Duration: 33s190ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-15 20:10:59 Duration: 10s348ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 8s936ms 20s572ms 14s293ms 6 1m25s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 15 00 3 56s620ms 18s873ms 06 3 29s139ms 9s713ms [ User: intelifix - Total duration: 1m25s - Times executed: 6 ]
[ Application: psql - Total duration: 1m25s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-15 00:05:23 Duration: 20s572ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-15 00:05:59 Duration: 19s25ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-15 00:05:40 Duration: 17s22ms Database: brasilia User: intelifix Remote: [local] Application: psql
9 2s240ms 32s347ms 13s570ms 6 1m21s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 15 20 3 39s969ms 13s323ms 23 3 41s454ms 13s818ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-15 23:15:12 Duration: 32s347ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-15 20:07:07 Duration: 30s580ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-15 20:11:07 Duration: 7s148ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 3s648ms 22s356ms 12s833ms 4 51s332ms 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 Aug 15 20 2 25s88ms 12s544ms 23 2 26s243ms 13s121ms [ User: intelifix - Total duration: 51s332ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 51s332ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-15 23:12:53 Duration: 22s356ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-15 20:04:52 Duration: 21s440ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-15 23:39:45 Duration: 3s886ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 2s933ms 28s903ms 12s232ms 6 1m13s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 15 20 3 34s823ms 11s607ms 23 3 38s571ms 12s857ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-15 23:18:10 Duration: 28s903ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-15 20:09:57 Duration: 25s759ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-15 23:40:31 Duration: 6s733ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1s930ms 22s564ms 11s65ms 6 1m6s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 15 20 3 32s745ms 10s915ms 23 3 33s645ms 11s215ms [ User: intelifix - Total duration: 1m6s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m6s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 20:03:29 Duration: 22s564ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 23:11:29 Duration: 22s336ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 23:39:25 Duration: 9s256ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1s771ms 26s377ms 10s794ms 6 1m4s copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 15 20 3 31s269ms 10s423ms 23 3 33s499ms 11s166ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-15 23:12:31 Duration: 26s377ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-15 20:04:30 Duration: 24s931ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-15 23:39:41 Duration: 5s290ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 2s167ms 21s655ms 10s743ms 6 1m4s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 15 20 3 31s897ms 10s632ms 23 3 32s565ms 10s855ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 20:02:48 Duration: 21s655ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 23:10:50 Duration: 21s594ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-15 23:39:13 Duration: 8s804ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1s526ms 17s578ms 8s575ms 6 51s455ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 15 20 3 26s5ms 8s668ms 23 3 25s449ms 8s483ms [ User: intelifix - Total duration: 51s455ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s455ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-15 20:03:47 Duration: 17s578ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-15 23:11:45 Duration: 16s450ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-15 23:39:32 Duration: 7s40ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 4s52ms 9s595ms 7s495ms 6 44s971ms 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 #16
Day Hour Count Duration Avg duration Aug 15 20 3 22s304ms 7s434ms 23 3 22s667ms 7s555ms [ User: intelifix - Total duration: 44s971ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 44s971ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-15 20:07:36 Duration: 9s595ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-15 23:40:17 Duration: 9s422ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-15 23:15:38 Duration: 9s103ms Database: rio User: intelifix Remote: [local] Application: pg_dump
17 2s816ms 13s444ms 3s655ms 54 3m17s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 15 08 4 18s747ms 4s686ms 09 5 16s579ms 3s315ms 10 3 9s609ms 3s203ms 11 3 14s954ms 4s984ms 12 4 12s351ms 3s87ms 13 3 9s643ms 3s214ms 14 3 9s645ms 3s215ms 15 3 9s878ms 3s292ms 16 4 13s93ms 3s273ms 17 4 12s472ms 3s118ms 18 4 13s158ms 3s289ms 19 3 11s208ms 3s736ms 20 3 9s638ms 3s212ms 21 4 12s900ms 3s225ms 22 4 23s494ms 5s873ms [ User: intelifix - Total duration: 3m17s - Times executed: 54 ]
[ Application: psql - Total duration: 3m17s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-15 22:40:18 Duration: 13s444ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-15 08:00:14 Duration: 9s202ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-15 11:00:13 Duration: 8s608ms Database: brasilia User: intelifix Remote: [local] Application: psql
18 2s880ms 4s355ms 3s362ms 36 2m1s 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 #18
Day Hour Count Duration Avg duration Aug 15 08 2 7s396ms 3s698ms 09 1 3s554ms 3s554ms 10 3 9s747ms 3s249ms 11 3 10s136ms 3s378ms 12 2 7s110ms 3s555ms 13 3 9s767ms 3s255ms 14 3 10s365ms 3s455ms 15 3 9s926ms 3s308ms 16 2 6s329ms 3s164ms 17 2 7s14ms 3s507ms 18 2 6s496ms 3s248ms 19 3 9s405ms 3s135ms 20 3 10s777ms 3s592ms 21 2 6s683ms 3s341ms 22 2 6s332ms 3s166ms [ User: intelifix - Total duration: 2m1s - Times executed: 36 ]
[ Application: psql - Total duration: 2m1s - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-15 08:00:05 Duration: 4s355ms 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-08-15 20:20:05 Duration: 4s47ms 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-08-15 14:40:05 Duration: 3s986ms Database: rio User: intelifix Remote: [local] Application: psql
19 230ms 17s380ms 2s970ms 276 13m39s call rs_giga_triagem (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 15 00 12 47s301ms 3s941ms 01 12 33s753ms 2s812ms 02 12 33s21ms 2s751ms 03 12 37s503ms 3s125ms 04 12 36s137ms 3s11ms 05 12 34s229ms 2s852ms 06 12 37s777ms 3s148ms 07 12 34s45ms 2s837ms 08 12 35s520ms 2s960ms 09 12 34s369ms 2s864ms 10 12 36s176ms 3s14ms 11 12 34s721ms 2s893ms 12 12 30s940ms 2s578ms 13 12 36s617ms 3s51ms 14 12 34s927ms 2s910ms 15 12 35s53ms 2s921ms 16 12 30s914ms 2s576ms 17 12 34s6ms 2s833ms 18 12 32s776ms 2s731ms 19 12 35s145ms 2s928ms 20 12 45s645ms 3s803ms 21 12 32s421ms 2s701ms 22 12 36s956ms 3s79ms [ User: intelifix - Total duration: 13m39s - Times executed: 276 ]
[ Application: psql - Total duration: 13m39s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-15 00:05:40 Duration: 17s380ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-15 20:15:15 Duration: 13s926ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-15 03:15:13 Duration: 7s274ms Database: rio User: intelifix Remote: [local] Application: psql
20 181ms 20s919ms 2s829ms 38 1m47s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 15 00 6 33s255ms 5s542ms 01 6 14s112ms 2s352ms 02 6 14s550ms 2s425ms 03 5 14s159ms 2s831ms 04 6 13s605ms 2s267ms 05 5 12s844ms 2s568ms 07 2 4s418ms 2s209ms 20 2 584ms 292ms [ User: intelifix - Total duration: 1m47s - Times executed: 38 ]
[ Application: psql - Total duration: 1m47s - Times executed: 38 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-15 00:05:22 Duration: 20s919ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-15 05:35:07 Duration: 6s385ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-15 03:15:06 Duration: 4s572ms Database: rio User: intelifix Remote: [local] Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 11 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 15 08 1 0ms 0ms 09 3 0ms 0ms 12 1 0ms 0ms 16 1 0ms 0ms 17 2 0ms 0ms 18 1 0ms 0ms 22 2 0ms 0ms [ User: intelifix - Total duration: 3m57s - Times executed: 11 ]
[ Application: psql - Total duration: 3m57s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 185ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 8,145 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 22 FATAL entries
- 2825 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,775 Max number of times the same event was reported
- 2,848 Total events found
Rank Times reported Error 1 2,775 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 15 00 118 01 115 02 114 03 108 04 115 05 116 06 118 07 113 08 116 09 118 10 115 11 117 12 118 13 116 14 114 15 118 16 119 17 116 18 113 19 120 20 117 21 117 22 112 23 112 - ERROR: prepared statement "_PLAN0000000029980990" does not exist
- ERROR: prepared statement "_PLAN000000002A418BD0" does not exist
- ERROR: prepared statement "_PLAN0000000029B6E0A0" does not exist
Statement: DEALLOCATE "_PLAN0000000029980990"
Date: 2026-08-15 00:00:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002A418BD0"
Date: 2026-08-15 00:00:23 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029B6E0A0"
Date: 2026-08-15 00:01:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 15 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-15 00:05:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-15 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-15 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 12 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 15 03 12 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-15 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-15 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-15 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
4 6 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 15 00 1 04 1 06 1 07 1 12 1 13 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-08-15 00:02:20 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-15 04:43:18 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-15 06:02:17 Database: testes Application: [unknown] User: lenon Remote: [local]
5 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 15 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-15 05:32:17 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-15 05:32:17 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-15 05:32:17 Database: contagem Application: psql User: intelifix Remote: [local]
6 4 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 15 03 4 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-15 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-15 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-15 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 Aug 15 03 1 - LOG: database system was shut down at 2026-08-15 03:05:01 -03
Date: 2026-08-15 03:05:03