pgBadger-
Global information
- Generated on Sat Aug 8 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 12,312 log entries in 8s
- Log start from 2026-08-08 00:00:01 to 2026-08-08 23:49:22
-
Overview
Global Stats
- 164 Number of unique normalized queries
- 1,276 Number of queries
- 4h26m1s Total query duration
- 2026-08-08 00:02:08 First query
- 2026-08-08 23:48:05 Last query
- 4 queries/s at 2026-08-08 23:47:58 Query peak
- 4h26m1s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h26m1s Execute total duration
- 1,542 Number of events
- 9 Number of unique normalized events
- 1,473 Max number of times the same event was reported
- 0 Number of cancellation
- 74 Total number of automatic vacuums
- 143 Total number of automatic analyzes
- 10 Number temporary file
- 239.57 MiB Max size of temporary file
- 111.36 MiB Average size of temporary file
- 255 Total number of sessions
- 7 sessions at 2026-08-08 03:05:59 Session peak
- 9d16h32m5s Total duration of sessions
- 54m42s Average duration of sessions
- 5 Average queries per session
- 1m2s Average queries duration per session
- 53m40s Average idle time per session
- 253 Total number of connections
- 7 connections/s at 2026-08-08 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-08 23:47:58 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-08 13:15:37 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-08 23:47:58 Date
Queries duration
Key values
- 4h26m1s 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 08 00 32 0ms 20s197ms 4s294ms 6s860ms 8s372ms 1m30s 01 27 0ms 19s12ms 2s468ms 7s8ms 8s593ms 19s913ms 02 17 0ms 5s171ms 2s230ms 4s521ms 5s717ms 8s640ms 03 25 0ms 12s151ms 2s122ms 6s343ms 7s206ms 16s30ms 04 53 0ms 4s996ms 1s58ms 6s86ms 7s830ms 9s398ms 05 24 0ms 9m45s 49s447ms 8s772ms 2m37s 9m45s 06 18 0ms 9s326ms 3s321ms 4s480ms 5s490ms 29s840ms 07 21 0ms 9m37s 47s68ms 5s353ms 2m2s 9m37s 08 46 0ms 6m31s 15s955ms 7s407ms 48s359ms 6m31s 09 59 0ms 6m1s 13s299ms 7s364ms 1m19s 6m52s 10 65 0ms 6m17s 11s356ms 7s631ms 17s650ms 6m49s 11 84 0ms 6m7s 8s394ms 6s585ms 17s232ms 6m44s 12 24 0ms 5m53s 28s58ms 6s645ms 49s770ms 5m53s 13 104 0ms 5m59s 7s51ms 6s375ms 9s18ms 6m49s 14 39 0ms 5m52s 16s832ms 6s675ms 48s57ms 5m52s 15 30 0ms 5m45s 22s218ms 6s71ms 48s664ms 5m45s 16 24 0ms 5m43s 26s793ms 6s227ms 47s412ms 5m43s 17 24 0ms 6m20s 29s473ms 5s918ms 18s183ms 6m54s 18 25 0ms 5m46s 25s631ms 6s517ms 50s318ms 5m46s 19 24 0ms 5m50s 26s836ms 6s398ms 46s857ms 5m50s 20 118 0ms 7m32s 12s24ms 1m14s 1m54s 7m32s 21 26 0ms 6m55s 27s361ms 6s332ms 47s562ms 6m55s 22 24 0ms 5m43s 26s993ms 7s634ms 46s543ms 5m43s 23 343 0ms 1m27s 6s619ms 1m5s 1m13s 1m27s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 08 00 10 0 1s137ms 0ms 0ms 1s21ms 01 8 0 398ms 0ms 0ms 1s45ms 02 0 0 0ms 0ms 0ms 0ms 03 7 0 385ms 0ms 0ms 831ms 04 34 0 319ms 298ms 533ms 1s331ms 05 4 0 527ms 0ms 0ms 1s6ms 06 3 0 1s820ms 0ms 0ms 0ms 07 8 0 1m59s 0ms 0ms 4m12s 08 28 0 24s332ms 631ms 2s14ms 3m45s 09 37 0 19s621ms 864ms 2s392ms 3m30s 10 27 0 24s838ms 1s732ms 2s553ms 3m39s 11 35 0 18s87ms 698ms 1s167ms 3m17s 12 6 0 1m43s 0ms 0ms 3m35s 13 46 0 14s232ms 674ms 1s148ms 3m47s 14 13 0 46s463ms 0ms 976ms 3m17s 15 10 0 1m1s 0ms 0ms 3m35s 16 6 0 1m39s 0ms 0ms 3m24s 17 6 0 1m50s 0ms 0ms 3m49s 18 7 0 1m25s 0ms 0ms 3m17s 19 6 0 1m39s 0ms 0ms 3m19s 20 14 82 14s48ms 24s718ms 1m7s 3m51s 21 8 0 1m22s 0ms 0ms 3m18s 22 6 0 1m38s 0ms 0ms 3m22s 23 19 324 6s619ms 1m3s 1m5s 1m27s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 08 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 08 00 0 1 1.00 0.00% 01 0 3 3.00 0.00% 02 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 3 3.00 0.00% 05 0 2 2.00 0.00% 06 0 0 0.00 0.00% 07 0 1 1.00 0.00% 08 0 3 3.00 0.00% 09 0 4 4.00 0.00% 10 0 1 1.00 0.00% 11 0 3 3.00 0.00% 12 0 0 0.00 0.00% 13 0 2 2.00 0.00% 14 0 1 1.00 0.00% 15 0 1 1.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 08 00 15 0.00/s 01 11 0.00/s 02 9 0.00/s 03 22 0.01/s 04 7 0.00/s 05 10 0.00/s 06 12 0.00/s 07 10 0.00/s 08 13 0.00/s 09 14 0.00/s 10 11 0.00/s 11 14 0.00/s 12 8 0.00/s 13 12 0.00/s 14 10 0.00/s 15 11 0.00/s 16 7 0.00/s 17 9 0.00/s 18 7 0.00/s 19 7 0.00/s 20 11 0.00/s 21 8 0.00/s 22 7 0.00/s 23 8 0.00/s Day Hour Count Average Duration Average idle time Aug 08 00 8 1h22s 1h5s 01 14 1h51s 1h47s 02 11 1h16s 1h13s 03 21 20m36s 20m33s 04 10 1h2m42s 1h2m36s 05 7 1h50s 58m 06 10 57m49s 57m43s 07 11 1h1m25s 59m55s 08 10 1h18s 59m4s 09 13 1h1m37s 1h37s 10 15 57m23s 56m34s 11 10 1h37s 59m26s 12 14 1h53s 1h5s 13 8 53m45s 52m13s 14 11 1h2m11s 1h1m11s 15 10 55m20s 54m13s 16 10 1h1m10s 1h6s 17 8 54m29s 53m1s 18 8 1h1m5s 59m45s 19 7 1h50s 59m18s 20 10 43m23s 41m1s 21 8 1h 58m31s 22 8 1h1m5s 59m44s 23 13 35m14s 32m19s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-08-08 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 253 connections Total
Connections per user
Key values
- intelifix Main User
- 253 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-08-08 03:05:59 Date
Histogram of session times
Key values
- 216 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 255 sessions Total
Sessions per user
Key values
- intelifix Main User
- 255 sessions Total
Sessions per host
Key values
- [local] Main Host
- 255 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 24,355 buffers Checkpoint Peak
- 2026-08-08 00:09:47 Date
- 270.013 seconds Highest write time
- 0.167 seconds Sync time
Checkpoints Wal files
Key values
- 5 files Wal files usage Peak
- 2026-08-08 00:19:47 Date
Checkpoints distance
Key values
- 174.15 Mo Distance Peak
- 2026-08-08 00:19:47 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 08 00 41,787 712.876s 0.124s 713.062s 01 3,143 315.538s 0.079s 315.762s 02 1,691 169.9s 0.148s 170.096s 03 2,338 233.863s 0.2s 234.159s 04 6,181 620.605s 0.172s 620.882s 05 8,634 868.158s 0.31s 868.559s 06 3,453 269.369s 0.006s 269.384s 07 1,498 150.338s 0.017s 150.39s 08 2,228 224.234s 0.075s 224.373s 09 3,448 347.003s 0.096s 347.183s 10 4,539 464.946s 0.146s 465.175s 11 2,859 287.655s 0.219s 287.972s 12 563 56.585s 0.026s 56.656s 13 3,522 363.057s 0.13s 363.265s 14 1,130 113.403s 0.04s 113.483s 15 448 45.531s 0.073s 45.617s 16 22 2.231s 0.013s 2.25s 17 23 2.327s 0.01s 2.343s 18 464 46.606s 0.01s 46.63s 19 23 2.329s 0.004s 2.34s 20 298 32.836s 0.016s 32.879s 21 347 34.927s 0.019s 34.979s 22 24 2.439s 0.007s 2.452s 23 90 9.082s 0.009s 9.11s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 08 00 0 0 10 631 0.059s 0.007s 01 0 0 1 675 0.010s 0.01s 02 0 0 0 384 0.062s 0.006s 03 0 0 1 562 0.062s 0.015s 04 0 0 2 1,123 0.064s 0.012s 05 0 0 4 654 0.075s 0.009s 06 0 0 0 10 0.004s 0.001s 07 0 0 1 71 0.003s 0.006s 08 0 0 0 926 0.007s 0.01s 09 0 0 1 1,225 0.011s 0.012s 10 0 0 2 1,344 0.063s 0.011s 11 0 0 1 1,139 0.062s 0.022s 12 0 0 0 189 0.003s 0.008s 13 0 0 2 1,509 0.019s 0.01s 14 0 0 1 384 0.007s 0.004s 15 0 0 0 93 0.062s 0.004s 16 0 0 0 3 0.010s 0.005s 17 0 0 0 3 0.008s 0.004s 18 0 0 0 49 0.004s 0.002s 19 0 0 0 3 0.002s 0.002s 20 0 0 0 34 0.003s 0.003s 21 0 0 0 50 0.007s 0.008s 22 0 0 0 4 0.006s 0.002s 23 0 0 0 14 0.003s 0.005s Day Hour Count Avg time (sec) Aug 08 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 08 00 21,741.57 kB 67,769.71 kB 01 1,608.60 kB 31,882.30 kB 02 1,492.50 kB 14,212.50 kB 03 1,135.27 kB 2,474.27 kB 04 2,638.25 kB 3,522.25 kB 05 9,070.57 kB 14,669.57 kB 06 7,961.00 kB 14,293.00 kB 07 1,411.40 kB 11,064.40 kB 08 1,126.00 kB 5,839.33 kB 09 1,488.36 kB 3,078.55 kB 10 2,362.36 kB 3,108.18 kB 11 2,053.00 kB 4,131.82 kB 12 936.20 kB 3,901.20 kB 13 2,837.60 kB 3,602.90 kB 14 2,705.00 kB 5,176.25 kB 15 1,002.00 kB 4,375.50 kB 16 180.00 kB 3,776.00 kB 17 181.00 kB 3,416.00 kB 18 1,022.00 kB 3,103.50 kB 19 181.00 kB 2,677.00 kB 20 539.00 kB 2,275.67 kB 21 165.80 kB 1,600.40 kB 22 183.00 kB 1,189.00 kB 23 42.33 kB 973.33 kB -
Temporary Files
Size of temporary files
Key values
- 479.14 MiB Temp Files size Peak
- 2026-08-08 05:32:04 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-08 05:32:04 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 08 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.36 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 930.66 MiB 71.46 MiB 239.57 MiB 116.33 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-08 05:32:14 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-08 05:32:04 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 182.94 MiB 91.47 MiB 91.47 MiB 91.47 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-08 05:30:41 Duration: 38s693ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-08 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 239.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-08 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 239.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-08 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 91.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-08 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 91.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-08 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 79.08 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-08 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 79.00 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-08 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 78.99 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-08 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 71.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-08 05:32:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 71.46 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-08 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.46 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-08 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 2.10 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-08 00:05:41 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 2.10 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-08 00:05:41 Date
Analyzes per table
Key values
- public.temp0000226778 (59) Main table analyzed (database contagem)
- 143 analyzes Total
Table Number of analyzes contagem.public.temp0000226778 59 rio.public.temp0000287845 20 contagem.pg_catalog.pg_attribute 14 contagem.pg_catalog.pg_class 13 contagem.pg_catalog.pg_type 10 contagem.public.usuarios 6 rio.public.temp0000287843 5 contagem.pg_catalog.pg_index 5 contagem.pg_catalog.pg_depend 4 rio.pg_catalog.pg_attribute 1 brasilia.public.temp0000237788 1 brasilia.public.temp0000237790 1 rio.pg_catalog.pg_class 1 contagem.public.temp0000226796 1 brasilia.pg_catalog.pg_shdepend 1 rio.pg_catalog.pg_type 1 Total 143 Vacuums per table
Key values
- public.temp0000226778 (38) Main table vacuumed on database contagem
- 74 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples contagem.public.temp0000226778 38 0 0 0 0 0 0 1,894 396 429,222 0 0 contagem.public.usuarios 6 0 0 0 0 0 0 28 22 13,462 0 0 contagem.pg_catalog.pg_attribute 5 5 0 0 0 0 0 2,493 858 1,432,357 3 82 contagem.pg_catalog.pg_type 3 3 0 0 0 0 0 270 119 156,589 1 2 contagem.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,402 317 1,235,894 214 1,470 contagem.pg_catalog.pg_class 3 3 0 0 0 0 0 459 173 226,483 1 3 contagem.pg_catalog.pg_depend 2 2 0 0 0 0 0 561 219 414,489 1 6 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 127 53 38,891 1 1 rio.pg_catalog.pg_statistic 2 2 0 0 0 0 0 4,285 1,601 5,715,665 1,347 7,518 rio.pg_catalog.pg_type 1 1 0 0 0 0 0 137 53 50,646 0 0 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 867 285 1,366,325 165 478 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 172 7 26,804 3 9 brasilia.public.temp0000237788 1 0 0 0 0 0 0 50 6 3,792 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,621 30 233,656 14 125 rio.auditor.auditor_2026_08 1 0 0 0 0 0 0 19,604 19,358 23,842,365 116 612 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 180 23 114,600 8 39 postgres.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 208 82 120,118 5 6 rio.public.temp0000287845 1 0 0 0 0 0 0 100 6 6,842 0 0 rio.pg_catalog.pg_attribute 1 1 0 0 0 0 0 705 247 225,163 0 0 Total 74 27 0 0 0 0 0 38,163 23,855 35,653,363 1,879 10,351 Vacuum throughput per table
Key values
- auditor.auditor_2026_08 (2.1) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed contagem.public.temp0000226778 0 0 0.63 contagem.public.usuarios 0 0 0 contagem.pg_catalog.pg_attribute 0 0 0.48 contagem.pg_catalog.pg_type 0 0 0.12 contagem.pg_catalog.pg_statistic 0 0 0.16 contagem.pg_catalog.pg_class 0 0 0.11 contagem.pg_catalog.pg_depend 0 0 0.16 contagem.pg_catalog.pg_index 0 0 0.04 rio.pg_catalog.pg_statistic 0 0 0.46 rio.pg_catalog.pg_type 0 0 0.03 rio.pg_toast.pg_toast_2619 0 0 0.06 contagem.pg_toast.pg_toast_2619 0 0 0 brasilia.public.temp0000237788 0 0 0.02 brasilia.pg_catalog.pg_statistic 0 0 0.08 rio.auditor.auditor_2026_08 0 0 2.1 brasilia.pg_toast.pg_toast_2619 0 0 0.03 postgres.pg_catalog.pg_shdepend 0 0 0.14 rio.public.temp0000287845 0 0 0.02 rio.pg_catalog.pg_attribute 0 0 0.35 Total 0 0 4.99 Tuples removed per table
Key values
- pg_catalog.pg_attribute (14028) Main table with removed tuples on database contagem
- 38073 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain contagem.pg_catalog.pg_attribute 5 5 14,028 120,044 0 113 2,610 contagem.pg_catalog.pg_statistic 3 3 6,200 22,488 0 0 3,033 rio.pg_catalog.pg_statistic 2 2 5,701 15,755 0 0 2,572 brasilia.pg_catalog.pg_statistic 1 1 3,955 7,346 0 0 1,072 rio.auditor.auditor_2026_08 1 0 2,850 4,394,252 0 0 210,428 rio.pg_catalog.pg_attribute 1 1 1,998 20,890 0 0 587 contagem.pg_catalog.pg_depend 2 2 877 37,652 0 0 352 rio.pg_toast.pg_toast_2619 1 1 654 683 0 0 279 contagem.public.usuarios 6 0 367 144 0 0 12 contagem.pg_catalog.pg_class 3 3 305 10,160 0 34 321 postgres.pg_catalog.pg_shdepend 1 1 279 13,526 0 0 119 contagem.pg_catalog.pg_type 3 3 232 6,725 0 20 184 contagem.pg_catalog.pg_index 2 2 188 3,787 0 7 107 rio.pg_catalog.pg_type 1 1 180 2,209 0 5 69 contagem.pg_toast.pg_toast_2619 1 1 154 118 0 0 65 brasilia.pg_toast.pg_toast_2619 1 1 105 138 0 34 36 contagem.public.temp0000226778 38 0 0 47,370 0 842 1,590 brasilia.public.temp0000237788 1 0 0 1,115 0 22 42 rio.public.temp0000287845 1 0 0 1,669 0 36 92 Total 74 27 38,073 4,706,071 0 1,113 223,570 Pages removed per table
Key values
- public.temp0000226778 (842) Main table with removed pages on database contagem
- 1113 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed contagem.public.temp0000226778 38 0 0 842 contagem.pg_catalog.pg_attribute 5 5 14028 113 rio.public.temp0000287845 1 0 0 36 contagem.pg_catalog.pg_class 3 3 305 34 brasilia.pg_toast.pg_toast_2619 1 1 105 34 brasilia.public.temp0000237788 1 0 0 22 contagem.pg_catalog.pg_type 3 3 232 20 contagem.pg_catalog.pg_index 2 2 188 7 rio.pg_catalog.pg_type 1 1 180 5 contagem.pg_catalog.pg_statistic 3 3 6200 0 rio.pg_toast.pg_toast_2619 1 1 654 0 contagem.pg_catalog.pg_depend 2 2 877 0 contagem.pg_toast.pg_toast_2619 1 1 154 0 contagem.public.usuarios 6 0 367 0 brasilia.pg_catalog.pg_statistic 1 1 3955 0 rio.auditor.auditor_2026_08 1 0 2850 0 postgres.pg_catalog.pg_shdepend 1 1 279 0 rio.pg_catalog.pg_attribute 1 1 1998 0 rio.pg_catalog.pg_statistic 2 2 5701 0 Total 74 27 38,073 1,113 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 08 00 1 0 01 2 1 02 0 0 03 0 2 04 1 19 05 6 6 06 0 0 07 1 1 08 2 16 09 5 20 10 18 19 11 14 21 12 1 1 13 18 28 14 3 7 15 1 1 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 1 1 22 0 0 23 0 0 - 2.10 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
- 348 Total read queries
- 514 Total write queries
Queries by database
Key values
- rio Main database
- 483 Requests
- 2h52m18s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 1,238 Requests
User Request type Count Duration etiquetas Total 5 2s404ms select 5 2s404ms intelifix Total 1,238 4h25m32s copy to 406 46m52s ddl 108 1m57s others 414 38m50s select 310 2h57m53s lenon Total 33 26s573ms select 33 26s573ms Duration by user
Key values
- 4h25m32s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 5 2s404ms select 5 2s404ms intelifix Total 1,238 4h25m32s copy to 406 46m52s ddl 108 1m57s others 414 38m50s select 310 2h57m53s lenon Total 33 26s573ms select 33 26s573ms Queries by host
Key values
- [local] Main host
- 1,276 Requests
- 4h26m1s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 519 Requests
- 3h33m29s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-08 04:27:11 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 498 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 9m45s analyze verbose;[ Date: 2026-08-08 05:09:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-08 07:14:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-08 20:12:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-08 21:11:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-08 08:11:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-08 17:11:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-08 10:11:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-08 11:11:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-08 09:11:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-08 13:11:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-08 12:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-08 14:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-08 19:10:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-08 18:10:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-08 15:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-08 16:10:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-08 22:10:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m37s analyze verbose;[ Date: 2026-08-08 05:14:24 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
19 4m1s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-08 07:20:42 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m47s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-08 17:16:01 - 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 1h47m32s 48 1s562ms 9m37s 2m14s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 08 07 3 10m23s 3m27s 08 3 6m49s 2m16s 09 3 6m20s 2m6s 10 3 6m37s 2m12s 11 3 6m26s 2m8s 12 3 6m10s 2m3s 13 3 6m17s 2m5s 14 3 6m9s 2m3s 15 3 6m3s 2m1s 16 3 6m1s 2m 17 3 6m39s 2m13s 18 3 6m4s 2m1s 19 3 6m7s 2m2s 20 3 8m5s 2m41s 21 3 7m12s 2m24s 22 3 6m 2m [ User: intelifix - Total duration: 1h47m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h47m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-08 07:14:38 Duration: 9m37s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-08 20:12:34 Duration: 7m32s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-08 21:11:57 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: psql
2 1h6m52s 48 241ms 4m1s 1m23s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 08 07 3 5m28s 1m49s 08 3 4m14s 1m24s 09 3 4m2s 1m20s 10 3 4m9s 1m23s 11 3 3m52s 1m17s 12 3 4m8s 1m22s 13 3 4m18s 1m26s 14 3 3m50s 1m16s 15 3 3m56s 1m18s 16 3 3m53s 1m17s 17 3 4m21s 1m27s 18 3 3m50s 1m16s 19 3 3m51s 1m17s 20 3 5m13s 1m44s 21 3 3m48s 1m16s 22 3 3m51s 1m17s [ User: intelifix - Total duration: 1h6m52s - Times executed: 48 ]
[ Application: psql - Total duration: 1h6m52s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-08 07:20:42 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-08 17:16:01 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-08 20:18:13 Duration: 3m45s Database: brasilia User: intelifix Remote: [local] Application: psql
3 17m 3 2m37s 9m45s 5m40s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 08 05 3 17m 5m40s [ User: intelifix - Total duration: 17m - Times executed: 3 ]
[ Application: psql - Total duration: 17m - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-08 05:09:47 Duration: 9m45s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-08 05:14:24 Duration: 4m37s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-08 05:17:01 Duration: 2m37s Database: contagem User: intelifix Remote: [local] Application: psql
4 11m14s 276 240ms 13s392ms 2s444ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 08 00 12 39s184ms 3s265ms 01 12 30s181ms 2s515ms 02 12 27s808ms 2s317ms 03 12 38s121ms 3s176ms 04 12 27s72ms 2s256ms 05 12 28s541ms 2s378ms 06 12 28s563ms 2s380ms 07 12 29s944ms 2s495ms 08 12 30s475ms 2s539ms 09 12 26s784ms 2s232ms 10 12 28s328ms 2s360ms 11 12 27s234ms 2s269ms 12 12 28s895ms 2s407ms 13 12 26s907ms 2s242ms 14 12 26s65ms 2s172ms 15 12 27s983ms 2s331ms 16 12 27s900ms 2s325ms 17 12 26s240ms 2s186ms 18 12 25s769ms 2s147ms 19 12 25s950ms 2s162ms 20 12 43s245ms 3s603ms 21 12 27s227ms 2s268ms 22 12 26s224ms 2s185ms [ User: intelifix - Total duration: 11m14s - Times executed: 276 ]
[ Application: psql - Total duration: 11m14s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-08 00:05:32 Duration: 13s392ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-08 20:05:14 Duration: 12s549ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-08 03:05:29 Duration: 12s151ms Database: rio User: intelifix Remote: [local] Application: psql
5 3m35s 56 2s870ms 9s89ms 3s850ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 08 08 4 14s906ms 3s726ms 09 5 22s360ms 4s472ms 10 4 14s946ms 3s736ms 11 3 9s235ms 3s78ms 12 3 15s645ms 5s215ms 13 3 9s925ms 3s308ms 14 4 13s11ms 3s252ms 15 3 10s457ms 3s485ms 16 4 13s90ms 3s272ms 17 4 13s343ms 3s335ms 18 4 13s527ms 3s381ms 19 3 10s26ms 3s342ms 20 4 18s651ms 4s662ms 21 4 15s388ms 3s847ms 22 4 21s130ms 5s282ms [ User: intelifix - Total duration: 3m35s - Times executed: 56 ]
[ Application: psql - Total duration: 3m35s - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-08 12:00:13 Duration: 9s89ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-08 09:40:13 Duration: 8s354ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-08 22:20:13 Duration: 8s18ms Database: brasilia User: intelifix Remote: [local] Application: psql
6 3m6s 4 4s679ms 1m29s 46s661ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 08 20 2 1m34s 47s33ms 23 2 1m32s 46s289ms [ User: intelifix - Total duration: 3m6s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m6s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-08 20:08:49 Duration: 1m29s 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-08 23:16:43 Duration: 1m27s 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-08 23:36:34 Duration: 4s917ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 1m57s 4 415ms 59s240ms 29s468ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 08 20 2 58s104ms 29s52ms 23 2 59s769ms 29s884ms [ User: intelifix - Total duration: 1m57s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m57s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-08 23:13:32 Duration: 59s240ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-08 20:05:33 Duration: 57s688ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-08 23:35:59 Duration: 529ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m55s 34 2s873ms 4s532ms 3s399ms 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 08 08 2 7s282ms 3s641ms 09 1 3s258ms 3s258ms 10 2 6s335ms 3s167ms 11 3 10s124ms 3s374ms 12 3 10s163ms 3s387ms 13 3 10s720ms 3s573ms 14 2 7s573ms 3s786ms 15 3 10s126ms 3s375ms 16 2 6s727ms 3s363ms 17 2 5s941ms 2s970ms 18 2 6s464ms 3s232ms 19 3 9s341ms 3s113ms 20 2 7s32ms 3s516ms 21 2 6s550ms 3s275ms 22 2 7s927ms 3s963ms [ User: intelifix - Total duration: 1m55s - Times executed: 34 ]
[ Application: psql - Total duration: 1m55s - Times executed: 34 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-08 22:40:05 Duration: 4s532ms 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-08 14:40:05 Duration: 4s232ms 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-08 08:00:05 Duration: 3s918ms Database: rio User: intelifix Remote: [local] Application: psql
9 1m32s 1 1m32s 1m32s 1m32s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 08 05 1 1m32s 1m32s [ User: intelifix - Total duration: 1m32s - Times executed: 1 ]
[ Application: psql - Total duration: 1m32s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-08 05:32:14 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-08 05:32:04 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
10 1m30s 6 3s76ms 33s701ms 15s2ms 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 08 20 3 45s932ms 15s310ms 23 3 44s83ms 14s694ms [ User: intelifix - Total duration: 1m30s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m30s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-08 20:06:08 Duration: 33s701ms 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-08 23:14:05 Duration: 31s992ms 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-08 20:10:15 Duration: 9s154ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 1m28s 33 151ms 17s822ms 2s696ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 08 00 6 30s260ms 5s43ms 01 6 14s264ms 2s377ms 02 5 10s110ms 2s22ms 03 5 11s709ms 2s341ms 04 6 17s728ms 2s954ms 05 3 4s532ms 1s510ms 20 2 384ms 192ms [ User: intelifix - Total duration: 1m28s - Times executed: 33 ]
[ Application: psql - Total duration: 1m28s - Times executed: 33 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-08 00:05:19 Duration: 17s822ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-08 04:45:05 Duration: 4s409ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-08 00:25:05 Duration: 4s92ms Database: rio User: intelifix Remote: [local] Application: psql
12 1m22s 6 7s651ms 20s197ms 13s687ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 08 00 3 56s369ms 18s789ms 06 3 25s757ms 8s585ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: psql - Total duration: 1m22s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-08 00:05:58 Duration: 20s197ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-08 00:05:22 Duration: 20s34ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-08 00:05:38 Duration: 16s137ms Database: brasilia User: intelifix Remote: [local] Application: psql
13 1m19s 1 1m19s 1m19s 1m19s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 08 09 1 1m19s 1m19s [ User: intelifix - Total duration: 1m19s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 1m19s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_modelo_recebimento(7,''2030'') ;', '/var/www/html/tmp/RECEBIMENTO_BSB_NF_2030.xlsx');
Date: 2026-08-08 09:36:19 Duration: 1m19s Database: brasilia User: intelifix Remote: [local] Application: [unknown]
14 1m18s 96 523ms 3s618ms 822ms create table temp0000226778 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 08 09 2 4s883ms 2s441ms 10 20 17s908ms 895ms 11 26 19s232ms 739ms 13 40 31s130ms 778ms 14 8 5s783ms 722ms [ User: intelifix - Total duration: 1m18s - Times executed: 96 ]
[ Application: [unknown] - Total duration: 1m18s - Times executed: 96 ]
-
CREATE TABLE temp0000226778 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"03-08-2026", "ate" :"08-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-08 09:54:17 Duration: 3s618ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226778 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"1", "desde" :"03-08-2026", "ate" :"08-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-08 10:05:14 Duration: 1s819ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226778 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"03-08-2026", "ate" :"08-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-08 10:00:07 Duration: 1s278ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
15 1m17s 64 169ms 3s662ms 1s210ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 08 08 8 12s294ms 1s536ms 09 11 17s255ms 1s568ms 10 11 21s933ms 1s993ms 11 13 9s558ms 735ms 13 19 13s910ms 732ms 14 2 2s540ms 1s270ms [ User: intelifix - Total duration: 1m17s - Times executed: 64 ]
[ Application: [unknown] - Total duration: 1m17s - Times executed: 64 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52256, 407, '2102313BFARYMB922954,F82E3F7C9A10,48575443474E21A8,F82E3F7C9A13BFARYMB915286,F82E3F6E7C9B,48575443455D4FA8,F82E3F6E7C9EBFARYM8952999,2868D2169434,48575443FA94B6A6,2868D2169437BFARYM8943265,E8136E925459,48575443F30514A6,E8136E92545CBFARYN2903565,88892F874706,48575443E52998A8,88892F874709BFARYN2927248,A4178B0198C7,48575443EBAE2FA8,A4178B0198CABFARYMA918932,6C442A92F3C3,485754439F725DA7,6C442A92F3C6BFARYM7915479,345840ED1774,48575443928D5CA6,345840ED1777BFARYN2923966,88892FFEDDAB,48575443EB9451A8,88892FFEDDAEBFARYM3905321,80E1BF0A8F05,48575443B5A81DA5,80E1BF0A8F08BFARYMA957977,C40D96A65035,48575443E23C23A7,C40D96A65038BFARYN7907305,6CE87400769A,48575443A6E17DAA,6CE87400769DBFARYN1914425,C4FBAAFBDBB1,48575443D3DBA4A8,C4FBAAFBDBB4BFARYMA942815,C40D969C3B33,48575443E107F9A7,C40D969C3B36BFARYM7931612,30C50FB66A61,48575443CEC0FDA6,30C50FB66A64BFARYM8953459,2868D2166A4B,48575443FA9251A6,2868D2166A4E', '',0189,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""}]','$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-08 09:29:44 Duration: 3s662ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52269, 407, 'ZTE3ANNR3J00626,F4E84F865D0C,F4E84F865D0D,ZTEGD97B643C$ZTE3ANNT4P17009,F00C514D3544,F00C514D3545,ZTEGDE343907$ZTE3ANNR9W08033,D89A0DA91869,D89A0DA9186A,ZTEGDB16310C$ZTE3ANNRC556497,6C11BA6755FD,6C11BA6755FE,ZTEGDC6EF270$ZTE3ANNR2Q00718,F4E84F80C4D4,F4E84F80C4D5,ZTEGD97A7588$ZTE3ANNQ8M34809,843C9921F7C1,843C9921F7C2,ZTEGD7BACF66$ZTE3ANNR9W14607,D89A0DA9B27D,D89A0DA9B27E,ZTEGDB164ABA$ZTE3ANNT3H68415,D831399D0712,D831399D0713,ZTEGDD32DBDE$ZTE3ANNRAM40024,5872C98AE249,5872C98AE24A,ZTEGDC609C57$ZTE3ANNQ7T02918,C4EBFF8F2FA4,C4EBFF8F2FA5,ZTEGD70B035C$ZTE3ANNQ7L06903,C4EBFF8E2672,C4EBFF8E2673,ZTEGD70AD729$ZTE3ANNQ8F05218,689E29FC9D29,689E29FC9D2A,ZTEGD7BA1132$ZTE3ANNR3Y24646,4896D952025C,4896D952025D,ZTEGD97E90FB$ZTE3ANNT4P16483,F00C514D28F0,F00C514D28F1,ZTEGDE3436F9$ZTE3ANNR9329959,D89A0D851E35,D89A0D851E36,ZTEGDB14E906$ZTE3ANNR6R51035,48D6823A30E4,48D6823A30E5,ZTEGDB01F22E$ZTE3ANNRCP03629,6C11BA697FDD,6C11BA697FDE,ZTEGDC6F4EC0$ZTE3ANNR6R26293,48D68237ED00,48D68237ED01,ZTEGDB019188$ZTE3ANNRB744989,5872C992579F,5872C99257A0,ZTEGDC61DA90$ZTE3ANNT2V49764,D83139901D30,D83139901D31,ZTEGDD30B4E3', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""}]','$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-08 10:37:19 Duration: 3s345ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52263, 407, '83350060823098A,241785740715,DC97E6BC247E,241755149906,DC97E6B4B0AB,241751170102,DC97E6B209FD,241782504147,DC97E6BA2021,241751053749,DC97E6B1E4E0B,241752011632,DC97E6B2A4D7,241736511219,DC97E6AF3178A,241782532534,DC97E6BA255B,241736413757,DC97E6AF24AC,241785854867,DC97E6BC3855,241751123958,DC97E6B1F17CB,241758933452,DC97E6B75993A,241724179510,DC97E6AD570CA,241720710014,DC97E6AB4865,241781503152,DC97E6B91D6DB,241757029102,DC97E6B5F424,241789750018,DC97E6BE4D14A,241724181430,DC97E6AD575DC,241720701326,DC97E6AB4691,241785656183,DC97E6BC1866,241785819005,DC97E6BC31A7', '',0333,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-08 09:59:48 Duration: 2s874ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
16 1m14s 6 1s831ms 29s68ms 12s480ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 08 20 3 36s780ms 12s260ms 23 3 38s102ms 12s700ms [ User: intelifix - Total duration: 1m14s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m14s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-08 23:14:38 Duration: 29s68ms 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-08 20:06:40 Duration: 28s485ms 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-08 23:36:16 Duration: 7s168ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1m9s 6 2s822ms 26s695ms 11s592ms 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 #17
Day Hour Count Duration Avg duration Aug 08 20 3 34s501ms 11s500ms 23 3 35s51ms 11s683ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - 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-08 20:09:16 Duration: 26s695ms 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-08 23:17:08 Duration: 25s676ms 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-08 23:36:41 Duration: 6s490ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 1m4s 6 1s881ms 21s623ms 10s730ms 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 08 20 3 32s828ms 10s942ms 23 3 31s555ms 10s518ms [ 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-08 20:02:46 Duration: 21s623ms 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-08 23:10:44 Duration: 20s367ms 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-08 20:09:37 Duration: 9s315ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 59s417ms 6 1s904ms 19s764ms 9s902ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 08 20 3 29s293ms 9s764ms 23 3 30s124ms 10s41ms [ User: intelifix - Total duration: 59s417ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s417ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-08 20:03:20 Duration: 19s764ms 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-08 23:11:19 Duration: 19s431ms 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-08 23:35:41 Duration: 8s646ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 57s219ms 6 1s585ms 22s631ms 9s536ms 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 #20
Day Hour Count Duration Avg duration Aug 08 20 3 28s698ms 9s566ms 23 3 28s520ms 9s506ms [ User: intelifix - Total duration: 57s219ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s219ms - 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-08 23:12:12 Duration: 22s631ms 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-08 20:04:15 Duration: 22s51ms 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-08 20:10:01 Duration: 5s61ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 276 11m14s 240ms 13s392ms 2s444ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 08 00 12 39s184ms 3s265ms 01 12 30s181ms 2s515ms 02 12 27s808ms 2s317ms 03 12 38s121ms 3s176ms 04 12 27s72ms 2s256ms 05 12 28s541ms 2s378ms 06 12 28s563ms 2s380ms 07 12 29s944ms 2s495ms 08 12 30s475ms 2s539ms 09 12 26s784ms 2s232ms 10 12 28s328ms 2s360ms 11 12 27s234ms 2s269ms 12 12 28s895ms 2s407ms 13 12 26s907ms 2s242ms 14 12 26s65ms 2s172ms 15 12 27s983ms 2s331ms 16 12 27s900ms 2s325ms 17 12 26s240ms 2s186ms 18 12 25s769ms 2s147ms 19 12 25s950ms 2s162ms 20 12 43s245ms 3s603ms 21 12 27s227ms 2s268ms 22 12 26s224ms 2s185ms [ User: intelifix - Total duration: 11m14s - Times executed: 276 ]
[ Application: psql - Total duration: 11m14s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-08 00:05:32 Duration: 13s392ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-08 20:05:14 Duration: 12s549ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-08 03:05:29 Duration: 12s151ms Database: rio User: intelifix Remote: [local] Application: psql
2 96 1m18s 523ms 3s618ms 822ms create table temp0000226778 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 08 09 2 4s883ms 2s441ms 10 20 17s908ms 895ms 11 26 19s232ms 739ms 13 40 31s130ms 778ms 14 8 5s783ms 722ms [ User: intelifix - Total duration: 1m18s - Times executed: 96 ]
[ Application: [unknown] - Total duration: 1m18s - Times executed: 96 ]
-
CREATE TABLE temp0000226778 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"03-08-2026", "ate" :"08-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-08 09:54:17 Duration: 3s618ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226778 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"1", "desde" :"03-08-2026", "ate" :"08-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-08 10:05:14 Duration: 1s819ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226778 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"03-08-2026", "ate" :"08-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-08 10:00:07 Duration: 1s278ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
3 64 1m17s 169ms 3s662ms 1s210ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 08 08 8 12s294ms 1s536ms 09 11 17s255ms 1s568ms 10 11 21s933ms 1s993ms 11 13 9s558ms 735ms 13 19 13s910ms 732ms 14 2 2s540ms 1s270ms [ User: intelifix - Total duration: 1m17s - Times executed: 64 ]
[ Application: [unknown] - Total duration: 1m17s - Times executed: 64 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52256, 407, '2102313BFARYMB922954,F82E3F7C9A10,48575443474E21A8,F82E3F7C9A13BFARYMB915286,F82E3F6E7C9B,48575443455D4FA8,F82E3F6E7C9EBFARYM8952999,2868D2169434,48575443FA94B6A6,2868D2169437BFARYM8943265,E8136E925459,48575443F30514A6,E8136E92545CBFARYN2903565,88892F874706,48575443E52998A8,88892F874709BFARYN2927248,A4178B0198C7,48575443EBAE2FA8,A4178B0198CABFARYMA918932,6C442A92F3C3,485754439F725DA7,6C442A92F3C6BFARYM7915479,345840ED1774,48575443928D5CA6,345840ED1777BFARYN2923966,88892FFEDDAB,48575443EB9451A8,88892FFEDDAEBFARYM3905321,80E1BF0A8F05,48575443B5A81DA5,80E1BF0A8F08BFARYMA957977,C40D96A65035,48575443E23C23A7,C40D96A65038BFARYN7907305,6CE87400769A,48575443A6E17DAA,6CE87400769DBFARYN1914425,C4FBAAFBDBB1,48575443D3DBA4A8,C4FBAAFBDBB4BFARYMA942815,C40D969C3B33,48575443E107F9A7,C40D969C3B36BFARYM7931612,30C50FB66A61,48575443CEC0FDA6,30C50FB66A64BFARYM8953459,2868D2166A4B,48575443FA9251A6,2868D2166A4E', '',0189,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""}]','$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-08 09:29:44 Duration: 3s662ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52269, 407, 'ZTE3ANNR3J00626,F4E84F865D0C,F4E84F865D0D,ZTEGD97B643C$ZTE3ANNT4P17009,F00C514D3544,F00C514D3545,ZTEGDE343907$ZTE3ANNR9W08033,D89A0DA91869,D89A0DA9186A,ZTEGDB16310C$ZTE3ANNRC556497,6C11BA6755FD,6C11BA6755FE,ZTEGDC6EF270$ZTE3ANNR2Q00718,F4E84F80C4D4,F4E84F80C4D5,ZTEGD97A7588$ZTE3ANNQ8M34809,843C9921F7C1,843C9921F7C2,ZTEGD7BACF66$ZTE3ANNR9W14607,D89A0DA9B27D,D89A0DA9B27E,ZTEGDB164ABA$ZTE3ANNT3H68415,D831399D0712,D831399D0713,ZTEGDD32DBDE$ZTE3ANNRAM40024,5872C98AE249,5872C98AE24A,ZTEGDC609C57$ZTE3ANNQ7T02918,C4EBFF8F2FA4,C4EBFF8F2FA5,ZTEGD70B035C$ZTE3ANNQ7L06903,C4EBFF8E2672,C4EBFF8E2673,ZTEGD70AD729$ZTE3ANNQ8F05218,689E29FC9D29,689E29FC9D2A,ZTEGD7BA1132$ZTE3ANNR3Y24646,4896D952025C,4896D952025D,ZTEGD97E90FB$ZTE3ANNT4P16483,F00C514D28F0,F00C514D28F1,ZTEGDE3436F9$ZTE3ANNR9329959,D89A0D851E35,D89A0D851E36,ZTEGDB14E906$ZTE3ANNR6R51035,48D6823A30E4,48D6823A30E5,ZTEGDB01F22E$ZTE3ANNRCP03629,6C11BA697FDD,6C11BA697FDE,ZTEGDC6F4EC0$ZTE3ANNR6R26293,48D68237ED00,48D68237ED01,ZTEGDB019188$ZTE3ANNRB744989,5872C992579F,5872C99257A0,ZTEGDC61DA90$ZTE3ANNT2V49764,D83139901D30,D83139901D31,ZTEGDD30B4E3', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""}]','$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-08 10:37:19 Duration: 3s345ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52263, 407, '83350060823098A,241785740715,DC97E6BC247E,241755149906,DC97E6B4B0AB,241751170102,DC97E6B209FD,241782504147,DC97E6BA2021,241751053749,DC97E6B1E4E0B,241752011632,DC97E6B2A4D7,241736511219,DC97E6AF3178A,241782532534,DC97E6BA255B,241736413757,DC97E6AF24AC,241785854867,DC97E6BC3855,241751123958,DC97E6B1F17CB,241758933452,DC97E6B75993A,241724179510,DC97E6AD570CA,241720710014,DC97E6AB4865,241781503152,DC97E6B91D6DB,241757029102,DC97E6B5F424,241789750018,DC97E6BE4D14A,241724181430,DC97E6AD575DC,241720701326,DC97E6AB4691,241785656183,DC97E6BC1866,241785819005,DC97E6BC31A7', '',0333,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-08 09:59:48 Duration: 2s874ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 56 3m35s 2s870ms 9s89ms 3s850ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 08 08 4 14s906ms 3s726ms 09 5 22s360ms 4s472ms 10 4 14s946ms 3s736ms 11 3 9s235ms 3s78ms 12 3 15s645ms 5s215ms 13 3 9s925ms 3s308ms 14 4 13s11ms 3s252ms 15 3 10s457ms 3s485ms 16 4 13s90ms 3s272ms 17 4 13s343ms 3s335ms 18 4 13s527ms 3s381ms 19 3 10s26ms 3s342ms 20 4 18s651ms 4s662ms 21 4 15s388ms 3s847ms 22 4 21s130ms 5s282ms [ User: intelifix - Total duration: 3m35s - Times executed: 56 ]
[ Application: psql - Total duration: 3m35s - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-08 12:00:13 Duration: 9s89ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-08 09:40:13 Duration: 8s354ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-08 22:20:13 Duration: 8s18ms Database: brasilia User: intelifix Remote: [local] Application: psql
5 54 9s975ms 150ms 633ms 184ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 08 08 7 1s698ms 242ms 09 10 1s868ms 186ms 10 8 1s368ms 171ms 11 10 1s698ms 169ms 13 16 2s873ms 179ms 14 3 469ms 156ms [ User: intelifix - Total duration: 9s975ms - Times executed: 54 ]
[ Application: [unknown] - Total duration: 9s975ms - Times executed: 54 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"302", "usuario" :"407", "tipo" :"N", "itens" :"007", "nota-fiscal" :"11220", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-08 08:21:17 Duration: 633ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"189", "usuario" :"407", "tipo" :"N", "itens" :"0016", "nota-fiscal" :"11220", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-08 09:18:12 Duration: 238ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"39", "usuario" :"407", "tipo" :"N", "itens" :"0010", "nota-fiscal" :"11220", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-08 10:25:44 Duration: 213ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
6 48 1h47m32s 1s562ms 9m37s 2m14s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 08 07 3 10m23s 3m27s 08 3 6m49s 2m16s 09 3 6m20s 2m6s 10 3 6m37s 2m12s 11 3 6m26s 2m8s 12 3 6m10s 2m3s 13 3 6m17s 2m5s 14 3 6m9s 2m3s 15 3 6m3s 2m1s 16 3 6m1s 2m 17 3 6m39s 2m13s 18 3 6m4s 2m1s 19 3 6m7s 2m2s 20 3 8m5s 2m41s 21 3 7m12s 2m24s 22 3 6m 2m [ User: intelifix - Total duration: 1h47m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h47m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-08 07:14:38 Duration: 9m37s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-08 20:12:34 Duration: 7m32s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-08 21:11:57 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: psql
7 48 1h6m52s 241ms 4m1s 1m23s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 08 07 3 5m28s 1m49s 08 3 4m14s 1m24s 09 3 4m2s 1m20s 10 3 4m9s 1m23s 11 3 3m52s 1m17s 12 3 4m8s 1m22s 13 3 4m18s 1m26s 14 3 3m50s 1m16s 15 3 3m56s 1m18s 16 3 3m53s 1m17s 17 3 4m21s 1m27s 18 3 3m50s 1m16s 19 3 3m51s 1m17s 20 3 5m13s 1m44s 21 3 3m48s 1m16s 22 3 3m51s 1m17s [ User: intelifix - Total duration: 1h6m52s - Times executed: 48 ]
[ Application: psql - Total duration: 1h6m52s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-08 07:20:42 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-08 17:16:01 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-08 20:18:13 Duration: 3m45s Database: brasilia User: intelifix Remote: [local] Application: psql
8 34 1m55s 2s873ms 4s532ms 3s399ms 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 08 08 2 7s282ms 3s641ms 09 1 3s258ms 3s258ms 10 2 6s335ms 3s167ms 11 3 10s124ms 3s374ms 12 3 10s163ms 3s387ms 13 3 10s720ms 3s573ms 14 2 7s573ms 3s786ms 15 3 10s126ms 3s375ms 16 2 6s727ms 3s363ms 17 2 5s941ms 2s970ms 18 2 6s464ms 3s232ms 19 3 9s341ms 3s113ms 20 2 7s32ms 3s516ms 21 2 6s550ms 3s275ms 22 2 7s927ms 3s963ms [ User: intelifix - Total duration: 1m55s - Times executed: 34 ]
[ Application: psql - Total duration: 1m55s - Times executed: 34 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-08 22:40:05 Duration: 4s532ms 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-08 14:40:05 Duration: 4s232ms 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-08 08:00:05 Duration: 3s918ms Database: rio User: intelifix Remote: [local] Application: psql
9 33 1m28s 151ms 17s822ms 2s696ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 08 00 6 30s260ms 5s43ms 01 6 14s264ms 2s377ms 02 5 10s110ms 2s22ms 03 5 11s709ms 2s341ms 04 6 17s728ms 2s954ms 05 3 4s532ms 1s510ms 20 2 384ms 192ms [ User: intelifix - Total duration: 1m28s - Times executed: 33 ]
[ Application: psql - Total duration: 1m28s - Times executed: 33 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-08 00:05:19 Duration: 17s822ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-08 04:45:05 Duration: 4s409ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-08 00:25:05 Duration: 4s92ms Database: rio User: intelifix Remote: [local] Application: psql
10 27 12s165ms 306ms 801ms 450ms 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 #10
Day Hour Count Duration Avg duration Aug 08 00 1 402ms 402ms 01 3 1s192ms 397ms 03 2 806ms 403ms 04 3 1s794ms 598ms 05 2 927ms 463ms 07 1 544ms 544ms 08 3 1s362ms 454ms 09 4 1s659ms 414ms 10 1 306ms 306ms 11 3 1s242ms 414ms 13 2 954ms 477ms 14 1 370ms 370ms 15 1 601ms 601ms [ User: lenon - Total duration: 12s165ms - Times executed: 27 ]
[ Application: [unknown] - Total duration: 12s165ms - Times executed: 27 ]
-
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-08 04:35:21 Duration: 801ms 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-08 04:16:18 Duration: 627ms 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-08 15:14:38 Duration: 601ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
11 27 7s157ms 152ms 533ms 265ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 08 00 2 702ms 351ms 01 1 174ms 174ms 03 1 152ms 152ms 04 23 6s128ms 266ms [ User: intelifix - Total duration: 7s157ms - Times executed: 27 ]
[ Application: [unknown] - Total duration: 7s157ms - Times executed: 27 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229680425971,229683802631,229653646971,229680563235,229680441125,229680697591,229654332022,229650030817,229650211822,229757692435,229683127278,229683353238,229762696267,229679923240,229679738901,229759129713,229757705870', NULL, NULL, 0159, 00);
Date: 2026-08-08 04:30:10 Duration: 533ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '73', 2, '229757655966,229654896577,229759797690,229653637172,229761995054,229760175258,229654036684,229761130313,216901178801,229680308282,229756682931', NULL, NULL, 0159, 00);
Date: 2026-08-08 00:15:08 Duration: 520ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229682279205,229757518096,229654844552,229762179618,229654505776,229759702126,229680446882,229650504555,229762554458,229654553839,229653459298,229757490519,229761987982,229680258301,229758003150,229680858695,229762863961', NULL, NULL, 0159, 00);
Date: 2026-08-08 04:28:22 Duration: 364ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 21 12s258ms 437ms 889ms 583ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 08 00 1 618ms 618ms 01 3 1s652ms 550ms 03 1 493ms 493ms 04 3 2s92ms 697ms 05 2 1s181ms 590ms 08 2 1s312ms 656ms 09 3 1s644ms 548ms 10 1 440ms 440ms 11 2 1s155ms 577ms 13 2 1s161ms 580ms 14 1 506ms 506ms [ User: intelifix - Total duration: 12s258ms - Times executed: 21 ]
[ Application: [unknown] - Total duration: 12s258ms - Times executed: 21 ]
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-08-08 04:35:21 Duration: 889ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-08-08 09:29:45 Duration: 724ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-08-08 04:16:18 Duration: 703ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 8 1s784ms 155ms 359ms 223ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 08 00 2 413ms 206ms 03 1 359ms 359ms 04 3 508ms 169ms 08 1 244ms 244ms 15 1 258ms 258ms [ User: intelifix - Total duration: 1s784ms - Times executed: 8 ]
[ Application: [unknown] - Total duration: 1s784ms - Times executed: 8 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229908423453');
Date: 2026-08-08 03:12:03 Duration: 359ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('246630355676');
Date: 2026-08-08 15:14:43 Duration: 258ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229683364653');
Date: 2026-08-08 00:13:14 Duration: 248ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 7 2s17ms 168ms 491ms 288ms 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 #14
Day Hour Count Duration Avg duration Aug 08 20 3 975ms 325ms 23 4 1s41ms 260ms [ User: intelifix - Total duration: 2s17ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s17ms - 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-08 20:02:03 Duration: 491ms 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-08 23:10:02 Duration: 362ms 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-08 20:10:50 Duration: 315ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 6 1m30s 3s76ms 33s701ms 15s2ms 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 #15
Day Hour Count Duration Avg duration Aug 08 20 3 45s932ms 15s310ms 23 3 44s83ms 14s694ms [ User: intelifix - Total duration: 1m30s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m30s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-08 20:06:08 Duration: 33s701ms 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-08 23:14:05 Duration: 31s992ms 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-08 20:10:15 Duration: 9s154ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 1m22s 7s651ms 20s197ms 13s687ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 08 00 3 56s369ms 18s789ms 06 3 25s757ms 8s585ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: psql - Total duration: 1m22s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-08 00:05:58 Duration: 20s197ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-08 00:05:22 Duration: 20s34ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-08 00:05:38 Duration: 16s137ms Database: brasilia User: intelifix Remote: [local] Application: psql
17 6 1m14s 1s831ms 29s68ms 12s480ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 08 20 3 36s780ms 12s260ms 23 3 38s102ms 12s700ms [ User: intelifix - Total duration: 1m14s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m14s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-08 23:14:38 Duration: 29s68ms 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-08 20:06:40 Duration: 28s485ms 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-08 23:36:16 Duration: 7s168ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 1m9s 2s822ms 26s695ms 11s592ms 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 #18
Day Hour Count Duration Avg duration Aug 08 20 3 34s501ms 11s500ms 23 3 35s51ms 11s683ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - 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-08 20:09:16 Duration: 26s695ms 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-08 23:17:08 Duration: 25s676ms 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-08 23:36:41 Duration: 6s490ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 1m4s 1s881ms 21s623ms 10s730ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 08 20 3 32s828ms 10s942ms 23 3 31s555ms 10s518ms [ 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-08 20:02:46 Duration: 21s623ms 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-08 23:10:44 Duration: 20s367ms 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-08 20:09:37 Duration: 9s315ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 59s417ms 1s904ms 19s764ms 9s902ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 08 20 3 29s293ms 9s764ms 23 3 30s124ms 10s41ms [ User: intelifix - Total duration: 59s417ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s417ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-08 20:03:20 Duration: 19s764ms 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-08 23:11:19 Duration: 19s431ms 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-08 23:35:41 Duration: 8s646ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m37s 9m45s 5m40s 3 17m analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 08 05 3 17m 5m40s [ User: intelifix - Total duration: 17m - Times executed: 3 ]
[ Application: psql - Total duration: 17m - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-08 05:09:47 Duration: 9m45s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-08 05:14:24 Duration: 4m37s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-08 05:17:01 Duration: 2m37s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s562ms 9m37s 2m14s 48 1h47m32s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 08 07 3 10m23s 3m27s 08 3 6m49s 2m16s 09 3 6m20s 2m6s 10 3 6m37s 2m12s 11 3 6m26s 2m8s 12 3 6m10s 2m3s 13 3 6m17s 2m5s 14 3 6m9s 2m3s 15 3 6m3s 2m1s 16 3 6m1s 2m 17 3 6m39s 2m13s 18 3 6m4s 2m1s 19 3 6m7s 2m2s 20 3 8m5s 2m41s 21 3 7m12s 2m24s 22 3 6m 2m [ User: intelifix - Total duration: 1h47m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h47m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-08 07:14:38 Duration: 9m37s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-08 20:12:34 Duration: 7m32s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-08 21:11:57 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: psql
3 1m32s 1m32s 1m32s 1 1m32s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 08 05 1 1m32s 1m32s [ User: intelifix - Total duration: 1m32s - Times executed: 1 ]
[ Application: psql - Total duration: 1m32s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-08 05:32:14 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-08 05:32:04 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 241ms 4m1s 1m23s 48 1h6m52s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 08 07 3 5m28s 1m49s 08 3 4m14s 1m24s 09 3 4m2s 1m20s 10 3 4m9s 1m23s 11 3 3m52s 1m17s 12 3 4m8s 1m22s 13 3 4m18s 1m26s 14 3 3m50s 1m16s 15 3 3m56s 1m18s 16 3 3m53s 1m17s 17 3 4m21s 1m27s 18 3 3m50s 1m16s 19 3 3m51s 1m17s 20 3 5m13s 1m44s 21 3 3m48s 1m16s 22 3 3m51s 1m17s [ User: intelifix - Total duration: 1h6m52s - Times executed: 48 ]
[ Application: psql - Total duration: 1h6m52s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-08 07:20:42 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-08 17:16:01 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-08 20:18:13 Duration: 3m45s Database: brasilia User: intelifix Remote: [local] Application: psql
5 1m19s 1m19s 1m19s 1 1m19s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 08 09 1 1m19s 1m19s [ User: intelifix - Total duration: 1m19s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 1m19s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_modelo_recebimento(7,''2030'') ;', '/var/www/html/tmp/RECEBIMENTO_BSB_NF_2030.xlsx');
Date: 2026-08-08 09:36:19 Duration: 1m19s Database: brasilia User: intelifix Remote: [local] Application: [unknown]
6 4s679ms 1m29s 46s661ms 4 3m6s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 08 20 2 1m34s 47s33ms 23 2 1m32s 46s289ms [ User: intelifix - Total duration: 3m6s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m6s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-08 20:08:49 Duration: 1m29s 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-08 23:16:43 Duration: 1m27s 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-08 23:36:34 Duration: 4s917ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 415ms 59s240ms 29s468ms 4 1m57s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 08 20 2 58s104ms 29s52ms 23 2 59s769ms 29s884ms [ User: intelifix - Total duration: 1m57s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m57s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-08 23:13:32 Duration: 59s240ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-08 20:05:33 Duration: 57s688ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-08 23:35:59 Duration: 529ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 3s76ms 33s701ms 15s2ms 6 1m30s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 08 20 3 45s932ms 15s310ms 23 3 44s83ms 14s694ms [ User: intelifix - Total duration: 1m30s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m30s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-08 20:06:08 Duration: 33s701ms 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-08 23:14:05 Duration: 31s992ms 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-08 20:10:15 Duration: 9s154ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 7s651ms 20s197ms 13s687ms 6 1m22s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 08 00 3 56s369ms 18s789ms 06 3 25s757ms 8s585ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: psql - Total duration: 1m22s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-08 00:05:58 Duration: 20s197ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-08 00:05:22 Duration: 20s34ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-08 00:05:38 Duration: 16s137ms Database: brasilia User: intelifix Remote: [local] Application: psql
10 1s831ms 29s68ms 12s480ms 6 1m14s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 08 20 3 36s780ms 12s260ms 23 3 38s102ms 12s700ms [ User: intelifix - Total duration: 1m14s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m14s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-08 23:14:38 Duration: 29s68ms 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-08 20:06:40 Duration: 28s485ms 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-08 23:36:16 Duration: 7s168ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 2s822ms 26s695ms 11s592ms 6 1m9s 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 08 20 3 34s501ms 11s500ms 23 3 35s51ms 11s683ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - 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-08 20:09:16 Duration: 26s695ms 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-08 23:17:08 Duration: 25s676ms 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-08 23:36:41 Duration: 6s490ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1s881ms 21s623ms 10s730ms 6 1m4s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 08 20 3 32s828ms 10s942ms 23 3 31s555ms 10s518ms [ 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-08 20:02:46 Duration: 21s623ms 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-08 23:10:44 Duration: 20s367ms 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-08 20:09:37 Duration: 9s315ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1s904ms 19s764ms 9s902ms 6 59s417ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 08 20 3 29s293ms 9s764ms 23 3 30s124ms 10s41ms [ User: intelifix - Total duration: 59s417ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s417ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-08 20:03:20 Duration: 19s764ms 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-08 23:11:19 Duration: 19s431ms 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-08 23:35:41 Duration: 8s646ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1s585ms 22s631ms 9s536ms 6 57s219ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 08 20 3 28s698ms 9s566ms 23 3 28s520ms 9s506ms [ User: intelifix - Total duration: 57s219ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s219ms - 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-08 23:12:12 Duration: 22s631ms 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-08 20:04:15 Duration: 22s51ms 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-08 20:10:01 Duration: 5s61ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 2s870ms 9s89ms 3s850ms 56 3m35s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 08 08 4 14s906ms 3s726ms 09 5 22s360ms 4s472ms 10 4 14s946ms 3s736ms 11 3 9s235ms 3s78ms 12 3 15s645ms 5s215ms 13 3 9s925ms 3s308ms 14 4 13s11ms 3s252ms 15 3 10s457ms 3s485ms 16 4 13s90ms 3s272ms 17 4 13s343ms 3s335ms 18 4 13s527ms 3s381ms 19 3 10s26ms 3s342ms 20 4 18s651ms 4s662ms 21 4 15s388ms 3s847ms 22 4 21s130ms 5s282ms [ User: intelifix - Total duration: 3m35s - Times executed: 56 ]
[ Application: psql - Total duration: 3m35s - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-08 12:00:13 Duration: 9s89ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-08 09:40:13 Duration: 8s354ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-08 22:20:13 Duration: 8s18ms Database: brasilia User: intelifix Remote: [local] Application: psql
16 2s873ms 4s532ms 3s399ms 34 1m55s 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 #16
Day Hour Count Duration Avg duration Aug 08 08 2 7s282ms 3s641ms 09 1 3s258ms 3s258ms 10 2 6s335ms 3s167ms 11 3 10s124ms 3s374ms 12 3 10s163ms 3s387ms 13 3 10s720ms 3s573ms 14 2 7s573ms 3s786ms 15 3 10s126ms 3s375ms 16 2 6s727ms 3s363ms 17 2 5s941ms 2s970ms 18 2 6s464ms 3s232ms 19 3 9s341ms 3s113ms 20 2 7s32ms 3s516ms 21 2 6s550ms 3s275ms 22 2 7s927ms 3s963ms [ User: intelifix - Total duration: 1m55s - Times executed: 34 ]
[ Application: psql - Total duration: 1m55s - Times executed: 34 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-08 22:40:05 Duration: 4s532ms 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-08 14:40:05 Duration: 4s232ms 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-08 08:00:05 Duration: 3s918ms Database: rio User: intelifix Remote: [local] Application: psql
17 151ms 17s822ms 2s696ms 33 1m28s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 08 00 6 30s260ms 5s43ms 01 6 14s264ms 2s377ms 02 5 10s110ms 2s22ms 03 5 11s709ms 2s341ms 04 6 17s728ms 2s954ms 05 3 4s532ms 1s510ms 20 2 384ms 192ms [ User: intelifix - Total duration: 1m28s - Times executed: 33 ]
[ Application: psql - Total duration: 1m28s - Times executed: 33 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-08 00:05:19 Duration: 17s822ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-08 04:45:05 Duration: 4s409ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-08 00:25:05 Duration: 4s92ms Database: rio User: intelifix Remote: [local] Application: psql
18 240ms 13s392ms 2s444ms 276 11m14s call rs_giga_triagem (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 08 00 12 39s184ms 3s265ms 01 12 30s181ms 2s515ms 02 12 27s808ms 2s317ms 03 12 38s121ms 3s176ms 04 12 27s72ms 2s256ms 05 12 28s541ms 2s378ms 06 12 28s563ms 2s380ms 07 12 29s944ms 2s495ms 08 12 30s475ms 2s539ms 09 12 26s784ms 2s232ms 10 12 28s328ms 2s360ms 11 12 27s234ms 2s269ms 12 12 28s895ms 2s407ms 13 12 26s907ms 2s242ms 14 12 26s65ms 2s172ms 15 12 27s983ms 2s331ms 16 12 27s900ms 2s325ms 17 12 26s240ms 2s186ms 18 12 25s769ms 2s147ms 19 12 25s950ms 2s162ms 20 12 43s245ms 3s603ms 21 12 27s227ms 2s268ms 22 12 26s224ms 2s185ms [ User: intelifix - Total duration: 11m14s - Times executed: 276 ]
[ Application: psql - Total duration: 11m14s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-08 00:05:32 Duration: 13s392ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-08 20:05:14 Duration: 12s549ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-08 03:05:29 Duration: 12s151ms Database: rio User: intelifix Remote: [local] Application: psql
19 169ms 3s662ms 1s210ms 64 1m17s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 08 08 8 12s294ms 1s536ms 09 11 17s255ms 1s568ms 10 11 21s933ms 1s993ms 11 13 9s558ms 735ms 13 19 13s910ms 732ms 14 2 2s540ms 1s270ms [ User: intelifix - Total duration: 1m17s - Times executed: 64 ]
[ Application: [unknown] - Total duration: 1m17s - Times executed: 64 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52256, 407, '2102313BFARYMB922954,F82E3F7C9A10,48575443474E21A8,F82E3F7C9A13BFARYMB915286,F82E3F6E7C9B,48575443455D4FA8,F82E3F6E7C9EBFARYM8952999,2868D2169434,48575443FA94B6A6,2868D2169437BFARYM8943265,E8136E925459,48575443F30514A6,E8136E92545CBFARYN2903565,88892F874706,48575443E52998A8,88892F874709BFARYN2927248,A4178B0198C7,48575443EBAE2FA8,A4178B0198CABFARYMA918932,6C442A92F3C3,485754439F725DA7,6C442A92F3C6BFARYM7915479,345840ED1774,48575443928D5CA6,345840ED1777BFARYN2923966,88892FFEDDAB,48575443EB9451A8,88892FFEDDAEBFARYM3905321,80E1BF0A8F05,48575443B5A81DA5,80E1BF0A8F08BFARYMA957977,C40D96A65035,48575443E23C23A7,C40D96A65038BFARYN7907305,6CE87400769A,48575443A6E17DAA,6CE87400769DBFARYN1914425,C4FBAAFBDBB1,48575443D3DBA4A8,C4FBAAFBDBB4BFARYMA942815,C40D969C3B33,48575443E107F9A7,C40D969C3B36BFARYM7931612,30C50FB66A61,48575443CEC0FDA6,30C50FB66A64BFARYM8953459,2868D2166A4B,48575443FA9251A6,2868D2166A4E', '',0189,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""}]','$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-08 09:29:44 Duration: 3s662ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52269, 407, 'ZTE3ANNR3J00626,F4E84F865D0C,F4E84F865D0D,ZTEGD97B643C$ZTE3ANNT4P17009,F00C514D3544,F00C514D3545,ZTEGDE343907$ZTE3ANNR9W08033,D89A0DA91869,D89A0DA9186A,ZTEGDB16310C$ZTE3ANNRC556497,6C11BA6755FD,6C11BA6755FE,ZTEGDC6EF270$ZTE3ANNR2Q00718,F4E84F80C4D4,F4E84F80C4D5,ZTEGD97A7588$ZTE3ANNQ8M34809,843C9921F7C1,843C9921F7C2,ZTEGD7BACF66$ZTE3ANNR9W14607,D89A0DA9B27D,D89A0DA9B27E,ZTEGDB164ABA$ZTE3ANNT3H68415,D831399D0712,D831399D0713,ZTEGDD32DBDE$ZTE3ANNRAM40024,5872C98AE249,5872C98AE24A,ZTEGDC609C57$ZTE3ANNQ7T02918,C4EBFF8F2FA4,C4EBFF8F2FA5,ZTEGD70B035C$ZTE3ANNQ7L06903,C4EBFF8E2672,C4EBFF8E2673,ZTEGD70AD729$ZTE3ANNQ8F05218,689E29FC9D29,689E29FC9D2A,ZTEGD7BA1132$ZTE3ANNR3Y24646,4896D952025C,4896D952025D,ZTEGD97E90FB$ZTE3ANNT4P16483,F00C514D28F0,F00C514D28F1,ZTEGDE3436F9$ZTE3ANNR9329959,D89A0D851E35,D89A0D851E36,ZTEGDB14E906$ZTE3ANNR6R51035,48D6823A30E4,48D6823A30E5,ZTEGDB01F22E$ZTE3ANNRCP03629,6C11BA697FDD,6C11BA697FDE,ZTEGDC6F4EC0$ZTE3ANNR6R26293,48D68237ED00,48D68237ED01,ZTEGDB019188$ZTE3ANNRB744989,5872C992579F,5872C99257A0,ZTEGDC61DA90$ZTE3ANNT2V49764,D83139901D30,D83139901D31,ZTEGDD30B4E3', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""}]','$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-08 10:37:19 Duration: 3s345ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52263, 407, '83350060823098A,241785740715,DC97E6BC247E,241755149906,DC97E6B4B0AB,241751170102,DC97E6B209FD,241782504147,DC97E6BA2021,241751053749,DC97E6B1E4E0B,241752011632,DC97E6B2A4D7,241736511219,DC97E6AF3178A,241782532534,DC97E6BA255B,241736413757,DC97E6AF24AC,241785854867,DC97E6BC3855,241751123958,DC97E6B1F17CB,241758933452,DC97E6B75993A,241724179510,DC97E6AD570CA,241720710014,DC97E6AB4865,241781503152,DC97E6B91D6DB,241757029102,DC97E6B5F424,241789750018,DC97E6BE4D14A,241724181430,DC97E6AD575DC,241720701326,DC97E6AB4691,241785656183,DC97E6BC1866,241785819005,DC97E6BC31A7', '',0333,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-08 09:59:48 Duration: 2s874ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 523ms 3s618ms 822ms 96 1m18s create table temp0000226778 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 08 09 2 4s883ms 2s441ms 10 20 17s908ms 895ms 11 26 19s232ms 739ms 13 40 31s130ms 778ms 14 8 5s783ms 722ms [ User: intelifix - Total duration: 1m18s - Times executed: 96 ]
[ Application: [unknown] - Total duration: 1m18s - Times executed: 96 ]
-
CREATE TABLE temp0000226778 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"03-08-2026", "ate" :"08-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-08 09:54:17 Duration: 3s618ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226778 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"1", "desde" :"03-08-2026", "ate" :"08-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-08 10:05:14 Duration: 1s819ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226778 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"03-08-2026", "ate" :"08-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-08 10:00:07 Duration: 1s278ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 8 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 08 09 2 0ms 0ms 10 1 0ms 0ms 14 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 3m28s - Times executed: 8 ]
[ Application: psql - Total duration: 3m28s - Times executed: 8 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 5,970 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 16 FATAL entries
- 1525 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,473 Max number of times the same event was reported
- 1,542 Total events found
Rank Times reported Error 1 1,473 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 08 00 60 01 59 02 60 03 55 04 59 05 59 06 59 07 59 08 70 09 69 10 68 11 72 12 59 13 79 14 61 15 60 16 59 17 60 18 59 19 60 20 59 21 60 22 59 23 49 - ERROR: prepared statement "_PLAN0000000029B189F0" does not exist
- ERROR: prepared statement "_PLAN0000000029858870" does not exist
- ERROR: prepared statement "_PLAN00000000296C3CB0" does not exist
Statement: DEALLOCATE "_PLAN0000000029B189F0"
Date: 2026-08-08 00:00:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029858870"
Date: 2026-08-08 00:01:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000296C3CB0"
Date: 2026-08-08 00:02:02 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 45 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 08 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 1 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-08 00:05: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-08 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-08 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 08 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-08 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-08 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-08 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 08 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-08 05:32:14 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-08 05:32:14 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-08 05:32:14 Database: contagem Application: psql User: intelifix Remote: [local]
5 4 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 08 00 1 06 1 12 1 14 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-08 00:02:11 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-08 06:02:07 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-08 12:51:59 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
6 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 08 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-08 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-08 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-08 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
7 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 08 13 2 - ERROR: column "e4c0e2e847f0" does not exist at character 27
- ERROR: column "e4c0e2e847f0" does not exist at character 27
Statement: select * from rs_caixa_qr(E4C0E2E847F0)
Date: 2026-08-08 13:42:57 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(E4C0E2E847F0)
Date: 2026-08-08 13:42:57 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
8 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 08 03 1 - LOG: database system was shut down at 2026-08-08 03:05:01 -03
Date: 2026-08-08 03:05:03
9 1 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 08 21 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-08 21:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]