pgBadger-
Global information
- Generated on Fri Sep 18 23:50:18 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 40,768 log entries in 15s
- Log start from 2026-09-18 00:00:07 to 2026-09-18 23:50:05
-
Overview
Global Stats
- 362 Number of unique normalized queries
- 4,904 Number of queries
- 7h21m4s Total query duration
- 2026-09-18 00:02:16 First query
- 2026-09-18 23:43:09 Last query
- 7 queries/s at 2026-09-18 10:12:53 Query peak
- 7h21m4s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h21m4s Execute total duration
- 4,388 Number of events
- 17 Number of unique normalized events
- 4,259 Max number of times the same event was reported
- 0 Number of cancellation
- 467 Total number of automatic vacuums
- 1,034 Total number of automatic analyzes
- 20 Number temporary file
- 246.45 MiB Max size of temporary file
- 67.07 MiB Average size of temporary file
- 386 Total number of sessions
- 10 sessions at 2026-09-18 21:26:06 Session peak
- 12d17h43m43s Total duration of sessions
- 47m31s Average duration of sessions
- 12 Average queries per session
- 1m8s Average queries duration per session
- 46m22s Average idle time per session
- 413 Total number of connections
- 3 connections/s at 2026-09-18 16:07:03 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 7 queries/s Query Peak
- 2026-09-18 10:12:53 Date
SELECT Traffic
Key values
- 7 queries/s Query Peak
- 2026-09-18 10:12:53 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-18 23:42:46 Date
Queries duration
Key values
- 7h21m4s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 18 00 22 0ms 27s865ms 5s674ms 4s947ms 6s588ms 1m15s 01 13 0ms 4s215ms 2s298ms 3s516ms 5s331ms 5s699ms 02 12 0ms 7s505ms 2s555ms 2s767ms 4s527ms 9s110ms 03 11 0ms 7s554ms 2s654ms 2s498ms 5s140ms 9s186ms 04 18 0ms 5s317ms 1s688ms 2s909ms 4s698ms 6s753ms 05 16 0ms 11m50s 1m36s 10s83ms 3m11s 11m50s 06 21 0ms 31s839ms 4s320ms 1s760ms 21s294ms 31s839ms 07 314 152ms 9m11s 6s660ms 1m5s 4m27s 12m 08 473 150ms 5m43s 4s130ms 44s415ms 5m38s 5m55s 09 641 150ms 7m35s 3s844ms 1m29s 5m52s 7m59s 10 673 150ms 5m55s 2s969ms 57s622ms 5m32s 6m1s 11 572 150ms 6m 3s812ms 1m12s 5m3s 6m58s 12 87 0ms 5m41s 9s457ms 19s130ms 1m11s 5m41s 13 229 0ms 5m9s 3s833ms 24s734ms 57s321ms 5m40s 14 444 150ms 5m33s 4s283ms 55s886ms 5m35s 5m58s 15 417 0ms 5m26s 3s708ms 42s553ms 3m36s 6m 16 205 0ms 6m16s 7s584ms 33s549ms 4m2s 7m4s 17 165 0ms 5m15s 4s826ms 19s142ms 29s215ms 5m47s 18 20 0ms 5m4s 28s566ms 1s631ms 2s598ms 5m50s 19 18 0ms 5m7s 32s129ms 1s669ms 1s847ms 5m52s 20 119 0ms 5m31s 10s471ms 1m8s 3m30s 6m35s 21 37 0ms 10m51s 27s39ms 50s995ms 1m59s 10m58s 22 26 0ms 9m13s 39s620ms 6s745ms 1m51s 9m13s 23 351 0ms 1m3s 5s620ms 1m3s 1m5s 1m6s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 18 00 3 0 7s110ms 0ms 0ms 0ms 01 1 0 476ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 6 0 387ms 0ms 0ms 989ms 05 0 0 0ms 0ms 0ms 0ms 06 10 0 2s875ms 0ms 0ms 5s961ms 07 256 0 7s96ms 7s126ms 49s605ms 6m57s 08 391 0 4s351ms 11s778ms 36s816ms 5m47s 09 504 0 4s230ms 19s296ms 1m26s 6m6s 10 551 0 3s107ms 11s552ms 20s123ms 6m 11 419 0 3s411ms 8s712ms 28s749ms 5m50s 12 55 0 13s748ms 1s672ms 11s36ms 3m59s 13 183 0 4s186ms 4s405ms 11s656ms 3m31s 14 362 0 4s501ms 18s462ms 53s700ms 5m34s 15 312 0 3s977ms 7s653ms 19s995ms 5m30s 16 160 0 8s626ms 15s75ms 33s549ms 6m53s 17 120 0 6s119ms 6s478ms 15s103ms 3m28s 18 8 0 1m9s 0ms 0ms 3m25s 19 6 0 1m33s 0ms 0ms 3m31s 20 15 79 12s273ms 1m1s 1m6s 5m31s 21 11 0 1m19s 0ms 31s932ms 10m51s 22 6 0 2m43s 0ms 0ms 4m36s 23 26 325 5s620ms 1m1s 1m3s 1m5s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 18 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 18 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 2 2.00 0.00% 05 0 0 0.00 0.00% 06 0 2 2.00 0.00% 07 0 10 10.00 0.00% 08 0 13 13.00 0.00% 09 0 14 14.00 0.00% 10 0 18 18.00 0.00% 11 0 17 17.00 0.00% 12 0 5 5.00 0.00% 13 0 12 12.00 0.00% 14 0 11 11.00 0.00% 15 0 10 10.00 0.00% 16 0 8 8.00 0.00% 17 0 4 4.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Sep 18 00 15 0.00/s 01 10 0.00/s 02 8 0.00/s 03 20 0.01/s 04 10 0.00/s 05 9 0.00/s 06 14 0.00/s 07 20 0.01/s 08 25 0.01/s 09 27 0.01/s 10 30 0.01/s 11 16 0.00/s 12 26 0.01/s 13 20 0.01/s 14 20 0.01/s 15 18 0.01/s 16 19 0.01/s 17 18 0.01/s 18 9 0.00/s 19 10 0.00/s 20 24 0.01/s 21 31 0.01/s 22 7 0.00/s 23 7 0.00/s Day Hour Count Average Duration Average idle time Sep 18 00 8 1h22s 1h7s 01 14 1h50s 1h47s 02 10 1h18s 1h15s 03 17 19m43s 19m41s 04 7 1h3m 1h2m55s 05 9 1h20s 57m29s 06 9 57m33s 57m23s 07 17 50m11s 48m8s 08 17 52m27s 50m33s 09 26 48m51s 47m17s 10 25 50m45s 49m25s 11 23 54m38s 53m3s 12 26 35m7s 34m35s 13 14 57m13s 56m11s 14 21 56m15s 54m45s 15 17 1h32s 59m1s 16 20 56m46s 55m28s 17 17 1h34s 59m47s 18 18 1h20s 59m49s 19 10 55m18s 54m20s 20 17 27m52s 26m39s 21 29 9m31s 8m56s 22 8 54m52s 52m43s 23 7 15m26s 10m45s -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2026-09-18 16:07:03 Date
Connections per database
Key values
- rio Main Database
- 413 connections Total
Connections per user
Key values
- intelifix Main User
- 413 connections Total
-
Sessions
Simultaneous sessions
Key values
- 10 sessions Session Peak
- 2026-09-18 21:26:06 Date
Histogram of session times
Key values
- 270 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 386 sessions Total
Sessions per user
Key values
- intelifix Main User
- 386 sessions Total
Sessions per host
Key values
- [local] Main Host
- 386 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 386 sessions Total
Application Count Total Duration Average Duration [unknown] 347 11d22h42m26s 49m34s pgAdmin 4 - CONN:8542389 2 30m36s 15m18s pgAdmin 4 - CONN:8565160 2 4s425ms 2s212ms pgAdmin 4 - CONN:99293 2 4s327ms 2s163ms pgAdmin 4 - DB:brasilia 1 9s739ms 9s739ms pgAdmin 4 - DB:contagem 1 9s891ms 9s891ms pgAdmin 4 - DB:postgres 1 31m12s 31m12s pgAdmin 4 - DB:rio 1 30m43s 30m43s pg_dump 9 42m37s 4m44s postgres_fdw 1 34m58s 34m58s psql 19 16h10m40s 51m5s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 53,206 buffers Checkpoint Peak
- 2026-09-18 21:26:52 Date
- 270.046 seconds Highest write time
- 0.705 seconds Sync time
Checkpoints Wal files
Key values
- 11 files Wal files usage Peak
- 2026-09-18 10:39:37 Date
Checkpoints distance
Key values
- 341.60 Mo Distance Peak
- 2026-09-18 16:19:40 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 18 00 39,957 693.145s 0.085s 693.268s 01 2,202 220.565s 0.207s 220.861s 02 2,271 227.574s 0.033s 227.633s 03 2,341 234.523s 0.03s 234.581s 04 2,730 273.403s 0.145s 273.634s 05 11,590 1,152.494s 0.135s 1,152.687s 06 7,151 413.364s 0.008s 413.382s 07 44,696 2,424.318s 0.288s 2,424.666s 08 62,337 3,239.17s 0.337s 3,239.661s 09 63,479 3,238.954s 0.721s 3,239.789s 10 67,216 3,239.056s 0.395s 3,239.673s 11 53,187 3,239.199s 0.412s 3,239.715s 12 13,949 1,351.311s 0.18s 1,351.609s 13 17,906 1,522.35s 0.26s 1,522.664s 14 51,882 3,062.311s 0.264s 3,062.658s 15 43,604 3,188.321s 0.365s 3,188.779s 16 27,240 2,115.924s 0.265s 2,116.374s 17 16,721 1,158.727s 0.102s 1,158.874s 18 5,781 288.146s 0.016s 288.177s 19 28 2.82s 0.006s 2.836s 20 1,963 285.513s 0.2s 285.765s 21 55,017 166.504s 0.778s 167.437s 22 3,204 320.697s 0.155s 321.023s 23 362 40.407s 0.043s 40.586s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 18 00 0 0 8 457 0.062s 0.006s 01 0 0 1 404 0.063s 0.007s 02 0 0 0 391 0.012s 0.006s 03 0 0 1 376 0.008s 0.008s 04 0 0 1 543 0.062s 0.007s 05 0 0 5 730 0.061s 0.012s 06 0 0 1 98 0.002s 0.003s 07 0 0 20 3,295 0.063s 0.012s 08 0 0 35 6,074 0.060s 0.012s 09 0 0 39 7,554 0.064s 0.012s 10 0 0 41 7,963 0.035s 0.012s 11 0 0 51 7,576 0.061s 0.012s 12 0 0 9 2,903 0.064s 0.012s 13 0 0 7 3,957 0.063s 0.012s 14 0 0 32 6,828 0.028s 0.012s 15 0 0 32 7,162 0.060s 0.012s 16 0 0 31 4,059 0.062s 0.012s 17 0 0 9 2,663 0.022s 0.011s 18 0 0 5 249 0.005s 0.003s 19 0 0 0 8 0.003s 0.003s 20 0 0 1 126 0.065s 0.011s 21 0 0 5 346 0.678s 0.02s 22 0 0 2 506 0.062s 0.007s 23 0 0 0 43 0.015s 0.007s Day Hour Count Avg time (sec) Sep 18 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 18 00 22,807.67 kB 57,520.17 kB 01 1,610.57 kB 31,568.29 kB 02 1,964.83 kB 16,656.00 kB 03 1,600.88 kB 3,566.25 kB 04 2,091.29 kB 2,831.86 kB 05 8,887.22 kB 14,054.00 kB 06 5,121.00 kB 12,115.67 kB 07 27,926.08 kB 64,486.67 kB 08 46,581.92 kB 83,058.50 kB 09 54,149.50 kB 108,728.75 kB 10 56,201.42 kB 127,521.92 kB 11 69,431.92 kB 103,673.08 kB 12 11,417.92 kB 56,244.58 kB 13 9,784.92 kB 21,743.00 kB 14 44,392.75 kB 78,008.75 kB 15 43,603.83 kB 84,204.58 kB 16 41,757.58 kB 116,519.75 kB 17 14,119.27 kB 59,261.09 kB 18 26,247.67 kB 91,782.33 kB 19 101.50 kB 70,421.00 kB 20 3,699.33 kB 28,931.00 kB 21 13,668.00 kB 14,212.67 kB 22 2,519.57 kB 7,099.00 kB 23 204.80 kB 4,490.60 kB -
Temporary Files
Size of temporary files
Key values
- 492.89 MiB Temp Files size Peak
- 2026-09-18 05:32:02 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-18 05:32:08 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 18 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.31 GiB 67.07 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.01 GiB 36.75 MiB 246.45 MiB 64.67 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-18 05:32:12 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-18 05:32:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 306.55 MiB 56.98 MiB 93.77 MiB 76.64 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-18 05:30:44 Duration: 41s796ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-18 05:30:40 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 246.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-18 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 246.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-18 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 93.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-18 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 93.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-18 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 62.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-18 05:30:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 56.98 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-18 05:30:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.71 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-18 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.65 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-18 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.64 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-18 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.64 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-18 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.64 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-18 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.63 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-18 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.63 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-18 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 36.82 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-18 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-18 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-18 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-18 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-18 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.75 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-18 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.75 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-18 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 6.21 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database brasilia - 2026-09-18 17:51:20 Date
- 0 sec Highest CPU-cost analyze
Table
Database brasilia - Date
Average Autovacuum Duration
Key values
- 6.21 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database brasilia - 2026-09-18 17:51:20 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (115) Main table analyzed (database rio)
- 1,034 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 115 rio.public.temp0000291807 62 rio.pg_catalog.pg_class 57 rio.public.usuarios 53 rio.pg_catalog.pg_type 49 rio.public.temp0000291795 41 contagem.pg_catalog.pg_attribute 38 rio.public.temp0000291575 37 brasilia.pg_catalog.pg_attribute 34 rio.pg_catalog.pg_index 32 contagem.public.usuarios 29 brasilia.public.temp0000240442 28 rio.pg_catalog.pg_depend 25 rio.public.temp0000291831 24 rio.public.temp0000291585 24 brasilia.pg_catalog.pg_class 18 contagem.pg_catalog.pg_class 17 rio.public.temp0000291799 17 rio.public.temp0000291755 17 rio.public.temp0000291791 17 brasilia.pg_catalog.pg_type 16 rio.public.temp0000291877 15 brasilia.public.temp0000240440 14 contagem.pg_catalog.pg_type 13 rio.public.temp0000291873 13 brasilia.pg_catalog.pg_index 12 contagem.public.temp0000227186 11 brasilia.public.usuarios 10 rio.public.temp0000291823 10 brasilia.pg_catalog.pg_depend 10 contagem.pg_catalog.pg_index 9 rio.public.temp0000290026 9 rio.public.temp0000291853 8 rio.public.temp0000291803 7 rio.public.temp0000290230 7 contagem.public.temp0000227210 7 rio.public.temp0000291817 7 rio.public.temp0000291875 6 rio.public.temp0000291895 6 contagem.pg_catalog.pg_depend 6 rio.public.temp0000291805 6 rio.public.temp0000291811 6 rio.public.temp0000291083 5 contagem.pg_catalog.pg_shdepend 5 contagem.public.temp0000227190 5 rio.public.tmp_drill_0320 4 rio.pg_catalog.pg_shdepend 4 brasilia.public.temp0000240436 4 brasilia.public.temp0000240444 4 rio.public.temp0000291815 4 contagem.public.temp0000227188 4 brasilia.public.nf_entrada 4 rio.public.temp0000291797 3 rio.public.temp0000291825 3 contagem.public.nf_entrada 3 rio.public.temp0000291871 3 brasilia.pg_catalog.pg_shdepend 3 brasilia.public.temp0000240462 2 brasilia.public.temp0000240524 2 rio.public.temp0000291819 2 rio.public.temp0000291879 2 brasilia.public.temp0000240450 2 brasilia.public.temp0000240514 2 contagem.public.temp0000227202 1 brasilia.public.temp0000240508 1 brasilia.public.temp0000240472 1 rio.public.temp0000291863 1 brasilia.public.temp0000240482 1 brasilia.public.temp0000240438 1 rio.public.temp0000291861 1 rio.public.temp0000291901 1 rio.public.temp0000291813 1 postgres.pg_catalog.pg_shdepend 1 contagem.public.temp0000227216 1 brasilia.public.temp0000240490 1 brasilia.public.temp0000240448 1 rio.public.temp0000291821 1 brasilia.public.temp0000240502 1 brasilia.public.temp0000240518 1 rio.public.temp0000291893 1 brasilia.public.temp0000240474 1 brasilia.public.temp0000240464 1 brasilia.public.temp0000240484 1 brasilia.public.temp0000240500 1 brasilia.public.temp0000240476 1 Total 1,034 Vacuums per table
Key values
- public.temp0000291807 (62) Main table vacuumed on database rio
- 467 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000291807 62 0 0 0 0 0 0 39,532 5,738 9,386,956 0 0 rio.pg_catalog.pg_attribute 47 40 0 0 0 0 0 23,013 6,503 9,435,330 399 10,138 rio.public.temp0000291795 41 0 0 0 0 0 0 2,219 381 424,751 0 0 contagem.public.usuarios 28 0 0 0 0 0 0 143 108 60,207 3 14 rio.pg_catalog.pg_class 28 22 0 0 0 0 0 4,793 1,498 2,262,228 79 313 rio.pg_catalog.pg_type 27 21 0 0 0 0 0 2,193 751 1,024,938 87 260 rio.pg_catalog.pg_index 20 14 0 0 0 0 0 785 243 218,685 39 84 rio.public.temp0000291755 17 0 0 0 0 0 0 23,543 1,870 3,734,998 0 0 rio.public.temp0000291585 13 0 0 0 0 0 0 4,485 161 427,304 0 0 rio.pg_catalog.pg_depend 13 13 0 0 0 0 0 4,018 1,427 2,208,704 78 770 contagem.pg_catalog.pg_attribute 12 12 0 0 0 0 0 8,457 1,904 3,694,620 31 614 brasilia.pg_catalog.pg_attribute 12 12 0 0 0 0 0 6,732 1,284 2,314,214 56 1,439 rio.public.usuarios 12 6 0 0 0 0 0 188 82 166,845 25 45 brasilia.pg_catalog.pg_class 10 10 0 0 0 0 0 1,842 282 568,468 21 73 rio.pg_catalog.pg_statistic 9 9 0 0 0 0 0 9,691 2,180 9,354,768 1,165 5,454 rio.public.temp0000290026 8 0 0 0 0 0 0 543 48 40,658 0 0 brasilia.pg_catalog.pg_type 8 8 0 0 0 0 0 701 103 204,338 10 93 rio.public.temp0000290230 6 0 0 0 0 0 0 423 35 30,201 0 0 contagem.public.temp0000227210 5 0 0 0 0 0 0 575 30 38,780 0 0 postgres.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 780 281 408,046 32 60 contagem.pg_catalog.pg_class 5 5 0 0 0 0 0 1,298 174 328,408 9 26 rio.public.temp0000291083 5 0 0 0 0 0 0 194 28 15,587 0 0 brasilia.pg_catalog.pg_index 5 5 0 0 0 0 0 238 49 53,557 7 35 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 683 117 218,550 5 10 contagem.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,460 279 632,963 8 55 rio.public.temp0000291831 4 0 0 0 0 0 0 133 22 11,060 0 0 rio.public.tmp_drill_0320 4 4 0 0 0 0 0 2,136 12 353,292 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,824 437 2,423,140 152 447 rio.public.temp0000291877 4 0 0 0 0 0 0 399 24 27,232 0 0 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,137 218 431,975 13 366 rio.public.temp0000291575 3 0 0 0 0 0 0 1,899 15 114,405 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,760 530 2,160,936 364 2,356 brasilia.public.temp0000240444 3 0 0 0 0 0 0 760 12 46,648 0 0 brasilia.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 492 129 240,193 19 31 contagem.pg_catalog.pg_index 3 3 0 0 0 0 0 286 65 78,681 4 4 rio.public.temp0000291811 2 0 0 0 0 0 0 92 11 7,164 0 0 brasilia.public.temp0000240524 2 0 0 0 0 0 0 508 8 31,178 0 0 brasilia.public.temp0000240462 2 0 0 0 0 0 0 2,180 10 130,161 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 331 63 342,087 28 74 rio.public.temp0000291879 1 0 0 0 0 0 0 94 6 6,476 0 0 rio.public.temp0000291799 1 0 0 0 0 0 0 82 6 5,745 0 0 brasilia.auditor.auditor_2026_09 1 0 0 0 0 0 0 34,069 17,245 23,331,820 8,295 159,366 rio.public.temp0000291815 1 0 0 0 0 0 0 8 5 1,299 0 0 brasilia.public.temp0000240484 1 0 0 0 0 0 0 4 3 774 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 128 11 53,693 3 12 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,197 12 174,676 5 40 rio.pg_toast.pg_toast_365051 1 0 0 0 0 0 0 831 283 1,921,968 275 1,183 brasilia.public.temp0000240464 1 0 0 0 0 0 0 253 4 15,530 0 0 rio.public.temp0000291821 1 0 0 0 0 0 0 91 6 6,292 0 0 rio.public.temp0000291893 1 0 0 0 0 0 0 103 6 7,007 0 0 brasilia.public.temp0000240518 1 0 0 0 0 0 0 253 4 15,530 0 0 rio.public.temp0000291823 1 0 0 0 0 0 0 90 6 6,233 0 0 rio.public.temp0000291803 1 0 0 0 0 0 0 8 5 1,297 0 0 rio.public.temp0000291875 1 0 0 0 0 0 0 94 6 6,476 0 0 rio.public.temp0000291853 1 0 0 0 0 0 0 81 6 5,672 0 0 rio.public.temp0000291861 1 0 0 0 0 0 0 1,810 4 107,393 0 0 Total 467 216 0 0 0 0 0 194,662 44,730 79,320,137 11,212 183,362 Vacuum throughput per table
Key values
- auditor.auditor_2026_09 (6.21) Max CPU elapsed for vacuum on database brasilia
- unknown (0 ms) Max I/O read time for vacuum on database brasilia
- unknown (0 ms) Max I/O write time for vacuum on database brasilia
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000291807 0 0 1.51 rio.pg_catalog.pg_attribute 0 0 3.11 rio.public.temp0000291795 0 0 0.06 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_class 0 0 0.78 rio.pg_catalog.pg_type 0 0 0.32 rio.pg_catalog.pg_index 0 0 0.25 rio.public.temp0000291755 0 0 1.18 rio.public.temp0000291585 0 0 0.12 rio.pg_catalog.pg_depend 0 0 0.96 contagem.pg_catalog.pg_attribute 0 0 1.05 brasilia.pg_catalog.pg_attribute 0 0 1.55 rio.public.usuarios 0 0 0.06 brasilia.pg_catalog.pg_class 0 0 0.48 rio.pg_catalog.pg_statistic 0 0 1.29 rio.public.temp0000290026 0 0 0.01 brasilia.pg_catalog.pg_type 0 0 0.22 rio.public.temp0000290230 0 0 0 contagem.public.temp0000227210 0 0 0 postgres.pg_catalog.pg_shdepend 0 0 0.62 contagem.pg_catalog.pg_class 0 0 0.75 rio.public.temp0000291083 0 0 0 brasilia.pg_catalog.pg_index 0 0 0.15 contagem.pg_catalog.pg_type 0 0 0.17 contagem.pg_catalog.pg_depend 0 0 0.58 rio.public.temp0000291831 0 0 0.01 rio.public.tmp_drill_0320 0 0 0.05 rio.pg_toast.pg_toast_2619 0 0 0.2 rio.public.temp0000291877 0 0 0 brasilia.pg_catalog.pg_depend 0 0 0.24 rio.public.temp0000291575 0 0 0.05 brasilia.pg_catalog.pg_statistic 0 0 0.36 brasilia.public.temp0000240444 0 0 0 brasilia.pg_catalog.pg_shdepend 0 0 0.06 contagem.pg_catalog.pg_index 0 0 0.18 rio.public.temp0000291811 0 0 0 brasilia.public.temp0000240524 0 0 0 brasilia.public.temp0000240462 0 0 0.05 brasilia.pg_toast.pg_toast_2619 0 0 0.02 rio.public.temp0000291879 0 0 0.01 rio.public.temp0000291799 0 0 0 brasilia.auditor.auditor_2026_09 0 0 6.21 rio.public.temp0000291815 0 0 0 brasilia.public.temp0000240484 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.05 rio.pg_toast.pg_toast_365051 0 0 0.18 brasilia.public.temp0000240464 0 0 0 rio.public.temp0000291821 0 0 0 rio.public.temp0000291893 0 0 0 brasilia.public.temp0000240518 0 0 0 rio.public.temp0000291823 0 0 0 rio.public.temp0000291803 0 0 0 rio.public.temp0000291875 0 0 0 rio.public.temp0000291853 0 0 0 rio.public.temp0000291861 0 0 0.05 Total 0 0 22.94 Tuples removed per table
Key values
- pg_catalog.pg_attribute (178666) Main table with removed tuples on database rio
- 424932 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 47 40 178,666 1,203,696 100,866 753 30,569 contagem.pg_catalog.pg_attribute 12 12 67,748 290,527 0 519 6,811 brasilia.pg_catalog.pg_attribute 12 12 61,991 263,433 68 50 6,878 rio.public.tmp_drill_0320 4 4 31,271 32,454 0 0 819 rio.pg_catalog.pg_statistic 9 9 15,059 73,913 260 0 11,574 rio.pg_catalog.pg_depend 13 13 11,840 256,004 9,092 0 2,431 rio.pg_catalog.pg_type 27 21 8,511 70,013 8,738 43 2,061 brasilia.pg_catalog.pg_statistic 3 3 6,314 23,368 0 0 3,216 rio.pg_catalog.pg_class 28 22 5,355 128,120 21,484 62 4,050 postgres.pg_catalog.pg_shdepend 5 5 5,145 68,483 646 0 625 contagem.pg_catalog.pg_statistic 1 1 4,499 7,274 0 0 1,011 contagem.pg_catalog.pg_type 5 5 4,019 11,255 0 63 367 rio.pg_catalog.pg_index 20 14 3,529 42,612 4,343 11 1,111 brasilia.pg_catalog.pg_shdepend 3 3 3,196 40,819 2 0 375 brasilia.pg_catalog.pg_type 8 8 3,021 17,896 10 16 505 brasilia.auditor.auditor_2026_09 1 0 2,811 3,102,685 0 0 136,419 contagem.pg_catalog.pg_index 3 3 1,949 5,694 0 31 185 contagem.pg_catalog.pg_depend 4 4 1,777 73,263 0 70 731 contagem.public.usuarios 28 0 1,705 672 0 0 56 brasilia.pg_catalog.pg_index 5 5 1,591 9,474 0 13 250 brasilia.pg_catalog.pg_depend 4 4 1,220 73,331 60 0 708 rio.pg_toast.pg_toast_2619 4 4 1,045 2,238 4 0 1,012 brasilia.pg_catalog.pg_class 10 10 940 34,209 52 0 1,265 rio.public.usuarios 12 6 920 7,253 1,145 0 228 contagem.pg_catalog.pg_class 5 5 491 18,977 0 61 914 brasilia.pg_toast.pg_toast_2619 2 2 217 264 0 3 135 contagem.pg_toast.pg_toast_2619 1 1 102 113 0 29 28 rio.public.temp0000291879 1 0 0 1,546 0 42 86 rio.public.temp0000291575 3 0 0 28,631 0 91 2,021 rio.public.temp0000291755 17 0 0 435,475 0 0 31,552 rio.public.temp0000291799 1 0 0 1,340 0 54 74 brasilia.public.temp0000240444 3 0 0 9,978 0 0 768 rio.public.temp0000291815 1 0 0 1,391 0 53 75 rio.public.temp0000290026 8 0 0 25,129 0 233 567 contagem.public.temp0000227210 5 0 0 6,902 0 105 535 rio.public.temp0000291807 62 0 0 628,064 0 1,784 44,168 rio.public.temp0000291811 2 0 0 2,782 0 105 151 brasilia.public.temp0000240484 1 0 0 3,326 0 0 256 rio.pg_toast.pg_toast_365051 1 0 0 175,437 0 0 38,991 brasilia.public.temp0000240464 1 0 0 3,326 0 0 256 rio.public.temp0000291821 1 0 0 1,504 0 45 83 rio.public.temp0000291893 1 0 0 4,193 0 33 95 brasilia.public.temp0000240518 1 0 0 3,326 0 0 256 rio.public.temp0000291831 4 0 0 8,259 0 69 187 rio.public.temp0000291823 1 0 0 1,476 0 46 82 rio.public.temp0000290230 6 0 0 19,147 0 208 432 brasilia.public.temp0000240524 2 0 0 6,661 0 0 512 brasilia.public.temp0000240462 2 0 0 27,187 0 38 2,202 rio.public.temp0000291803 1 0 0 1,340 0 54 74 rio.public.temp0000291875 1 0 0 1,546 0 42 86 rio.public.temp0000291853 1 0 0 3,235 0 55 73 rio.public.temp0000291795 41 0 0 106,976 0 1,318 2,426 rio.public.temp0000291083 5 0 0 12,623 0 98 286 rio.public.temp0000291877 4 0 0 16,211 0 145 367 rio.public.temp0000291861 1 0 0 25,614 0 0 1,856 rio.public.temp0000291585 13 0 0 76,495 0 406 4,586 Total 467 216 424,932 7,497,160 146,770 6,748 347,437 Pages removed per table
Key values
- public.temp0000291807 (1784) Main table with removed pages on database rio
- 6748 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000291807 62 0 0 1784 rio.public.temp0000291795 41 0 0 1318 rio.pg_catalog.pg_attribute 47 40 178666 753 contagem.pg_catalog.pg_attribute 12 12 67748 519 rio.public.temp0000291585 13 0 0 406 rio.public.temp0000290026 8 0 0 233 rio.public.temp0000290230 6 0 0 208 rio.public.temp0000291877 4 0 0 145 contagem.public.temp0000227210 5 0 0 105 rio.public.temp0000291811 2 0 0 105 rio.public.temp0000291083 5 0 0 98 rio.public.temp0000291575 3 0 0 91 contagem.pg_catalog.pg_depend 4 4 1777 70 rio.public.temp0000291831 4 0 0 69 contagem.pg_catalog.pg_type 5 5 4019 63 rio.pg_catalog.pg_class 28 22 5355 62 contagem.pg_catalog.pg_class 5 5 491 61 rio.public.temp0000291853 1 0 0 55 rio.public.temp0000291799 1 0 0 54 rio.public.temp0000291803 1 0 0 54 rio.public.temp0000291815 1 0 0 53 brasilia.pg_catalog.pg_attribute 12 12 61991 50 rio.public.temp0000291823 1 0 0 46 rio.public.temp0000291821 1 0 0 45 rio.pg_catalog.pg_type 27 21 8511 43 rio.public.temp0000291879 1 0 0 42 rio.public.temp0000291875 1 0 0 42 brasilia.public.temp0000240462 2 0 0 38 rio.public.temp0000291893 1 0 0 33 contagem.pg_catalog.pg_index 3 3 1949 31 contagem.pg_toast.pg_toast_2619 1 1 102 29 brasilia.pg_catalog.pg_type 8 8 3021 16 brasilia.pg_catalog.pg_index 5 5 1591 13 rio.pg_catalog.pg_index 20 14 3529 11 brasilia.pg_toast.pg_toast_2619 2 2 217 3 rio.pg_catalog.pg_statistic 9 9 15059 0 rio.public.temp0000291755 17 0 0 0 brasilia.pg_catalog.pg_statistic 3 3 6314 0 brasilia.auditor.auditor_2026_09 1 0 2811 0 brasilia.public.temp0000240444 3 0 0 0 brasilia.pg_catalog.pg_shdepend 3 3 3196 0 contagem.public.usuarios 28 0 1705 0 brasilia.public.temp0000240484 1 0 0 0 brasilia.pg_catalog.pg_class 10 10 940 0 contagem.pg_catalog.pg_statistic 1 1 4499 0 rio.pg_toast.pg_toast_365051 1 0 0 0 brasilia.public.temp0000240464 1 0 0 0 brasilia.public.temp0000240518 1 0 0 0 brasilia.public.temp0000240524 2 0 0 0 rio.public.tmp_drill_0320 4 4 31271 0 rio.pg_toast.pg_toast_2619 4 4 1045 0 postgres.pg_catalog.pg_shdepend 5 5 5145 0 rio.public.temp0000291861 1 0 0 0 brasilia.pg_catalog.pg_depend 4 4 1220 0 rio.pg_catalog.pg_depend 13 13 11840 0 rio.public.usuarios 12 6 920 0 Total 467 216 424,932 6,748 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 18 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 7 0 06 1 1 07 26 54 08 34 110 09 90 177 10 54 121 11 77 151 12 5 19 13 20 44 14 49 107 15 44 130 16 27 59 17 33 61 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 6.21 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 28s727ms 28s727ms 28s727ms 28s727ms call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-18 14:45:36 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-18 20:25:17 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-18 20:55:16 Database: rio User: intelifix Remote: [local] Application: psql
Queries that waited the most
Rank Wait time Query 1 28s727ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-18 14:45:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 3,405 Total read queries
- 1,071 Total write queries
Queries by database
Key values
- rio Main database
- 3,107 Requests
- 5h25m39s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 4,748 Requests
User Request type Count Duration etiquetas Total 49 19s898ms select 49 19s898ms intelifix Total 4,748 7h18m55s copy to 404 42m1s ddl 665 37m53s others 428 45m30s select 3,251 5h13m29s lenon Total 107 1m49s ddl 2 345ms select 105 1m49s Duration by user
Key values
- 7h18m55s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 49 19s898ms select 49 19s898ms intelifix Total 4,748 7h18m55s copy to 404 42m1s ddl 665 37m53s others 428 45m30s select 3,251 5h13m29s lenon Total 107 1m49s ddl 2 345ms select 105 1m49s Queries by host
Key values
- [local] Main host
- 4,902 Requests
- 7h21m4s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,844 Requests
- 3h53m28s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-18 07:45:06 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,285 100-500ms duration
Slowest individual queries
Rank Duration Query 1 11m50s analyze verbose;[ Date: 2026-09-18 05:11:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 10m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-18 21:15:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-18 22:14:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-18 07:14:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 7m51s analyze verbose;[ Date: 2026-09-18 05:19:43 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
6 7m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-18 09:12:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m55s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030044, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-18 07:52:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 6m16s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030084, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');[ Date: 2026-09-18 16:22:20 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 6m1s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030050, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-18 09:16:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 6m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-18 11:11:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-18 10:10:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m54s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030055, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-18 10:07:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m48s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030059, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-18 11:09:27 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m43s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030049, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-18 08:40:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-18 12:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m37s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030052, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-18 09:38:08 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m33s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030075, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-18 14:24:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-18 20:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-18 14:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030080, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-18 15:30:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h49m16s 46 1s415ms 10m51s 2m22s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 18 07 3 10m7s 3m22s 08 3 5m47s 1m55s 09 3 7m56s 2m38s 10 3 6m13s 2m4s 11 3 6m23s 2m7s 12 3 6m8s 2m2s 13 3 5m29s 1m49s 14 3 5m48s 1m56s 15 3 5m40s 1m53s 16 2 5m12s 2m36s 17 3 5m31s 1m50s 18 3 5m22s 1m47s 19 3 5m23s 1m47s 20 3 5m49s 1m56s 21 2 11m59s 5m59s 22 3 10m20s 3m26s [ User: intelifix - Total duration: 1h49m16s - Times executed: 46 ]
[ Application: psql - Total duration: 1h49m16s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-18 21:15:53 Duration: 10m51s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-18 22:14:15 Duration: 9m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-18 07:14:12 Duration: 9m11s Database: rio User: intelifix Remote: [local] Application: psql
2 1h20m37s 187 150ms 6m55s 25s868ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 18 07 18 8m7s 27s68ms 08 12 13m34s 1m7s 09 19 12m21s 39s38ms 10 30 11m54s 23s830ms 11 15 5m59s 23s997ms 12 3 1m15s 25s281ms 13 12 19s853ms 1s654ms 14 28 11m33s 24s784ms 15 12 5m58s 29s849ms 16 19 8m55s 28s163ms 17 19 36s446ms 1s918ms [ User: intelifix - Total duration: 1h20m37s - Times executed: 187 ]
[ Application: [unknown] - Total duration: 1h20m37s - Times executed: 187 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030044, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-18 07:52:09 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030084, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');
Date: 2026-09-18 16:22:20 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030050, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-18 09:16:39 Duration: 6m1s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h7m55s 46 246ms 4m15s 1m28s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 18 07 3 5m44s 1m54s 08 3 4m18s 1m26s 09 3 4m47s 1m35s 10 3 4m18s 1m26s 11 3 4m15s 1m25s 12 3 4m26s 1m28s 13 3 3m58s 1m19s 14 3 4m6s 1m22s 15 3 4m3s 1m21s 16 3 4m2s 1m20s 17 3 3m57s 1m19s 18 3 3m53s 1m17s 19 3 4m 1m20s 20 3 4m1s 1m20s 21 1 1m59s 1m59s 22 3 6m 2m [ User: intelifix - Total duration: 1h7m55s - Times executed: 46 ]
[ Application: psql - Total duration: 1h7m55s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-18 22:21:02 Duration: 4m15s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-18 07:20:42 Duration: 4m14s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-18 09:17:42 Duration: 3m52s Database: brasilia User: intelifix Remote: [local] Application: psql
4 22m53s 3 3m11s 11m50s 7m37s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 18 05 3 22m53s 7m37s [ User: intelifix - Total duration: 22m53s - Times executed: 3 ]
[ Application: psql - Total duration: 22m53s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-18 05:11:51 Duration: 11m50s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-18 05:19:43 Duration: 7m51s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-18 05:22:54 Duration: 3m11s Database: contagem User: intelifix Remote: [local] Application: psql
5 17m3s 78 1s573ms 1m20s 13s120ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 18 07 4 1m45s 26s274ms 08 1 7s822ms 7s822ms 09 11 3m29s 19s80ms 10 5 26s412ms 5s282ms 11 5 2m40s 32s98ms 12 4 14s959ms 3s739ms 13 5 1m3s 12s634ms 14 9 1m38s 10s998ms 15 10 2m9s 12s966ms 16 16 3m1s 11s345ms 17 8 25s352ms 3s169ms [ User: intelifix - Total duration: 17m3s - Times executed: 78 ]
[ Application: [unknown] - Total duration: 17m3s - Times executed: 78 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-18', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-18 09:04:34 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-18', 0184, '', '', 0, 6, '2026-09-01');
Date: 2026-09-18 07:25:05 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-18', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-18 11:06:24 Duration: 1m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 15m51s 1,217 150ms 7s992ms 781ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 18 07 79 57s901ms 732ms 08 164 2m27s 898ms 09 183 3m1s 990ms 10 194 2m48s 867ms 11 173 2m16s 789ms 12 15 11s236ms 749ms 13 70 46s675ms 666ms 14 132 1m23s 631ms 15 140 1m26s 619ms 16 43 22s715ms 528ms 17 24 9s40ms 376ms [ User: intelifix - Total duration: 15m51s - Times executed: 1217 ]
[ Application: [unknown] - Total duration: 15m51s - Times executed: 1217 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (58206, 407, '836066910001284,241732104144,241662993651,241604293343,230048512647,241678346170,241609652744,241602087190,241676706066,241646321620,241607247278,241604981727,230048512041,241726923549,241631317899,241727092230,241659701018,241619569413,241714068602,241696975261,241656691016,241593318602,241636065669,241632343948,241607206365,230043524752,241593986175,241661489698,241614536183,241717131213,241698666784,241663061840,241659754760,241677634350,241622531330,230048510223,241632305156,241704334655,241608661525,241728540015,241698671028,241654884857,241617429406,241679131332,241676789509,241617452944,241708756478,241660129094,241621408099,241698682443,241664839409', '',0321,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":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-18 08:29:54 Duration: 7s992ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (288487, 404, '270911029504103338,229783452738,229781243353,229671769919,229667826885,229786832024,216945272330,229743763354,229836352435,216941817076,229734474759,216942010710,229689580513,229810799604,229661612744,229737315272,229670566883,229865251619,229746655465', '246586232223,246601126785,246494746167,246497649111,246598186969,246484013549,246538649700,246640591524,246482184560,246538718595,246471313241,246520641232,246640393446,246487128790,246528061114,246515186669,246649646885,246569516573,,,,,,,,,,,,,,,,,,,,,,', 0141, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-09-18 09:59:35 Duration: 7s879ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (58165, 407, '226400441229', '',0172,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":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-18 09:40:30 Duration: 3s794ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
7 13m43s 71 10s420ms 32s791ms 11s597ms create table temp0000291807 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 18 07 7 1m21s 11s574ms 08 6 1m7s 11s238ms 09 6 1m29s 14s931ms 10 11 2m10s 11s881ms 11 20 3m44s 11s236ms 14 9 1m37s 10s887ms 15 12 2m11s 10s996ms [ User: intelifix - Total duration: 13m43s - Times executed: 71 ]
[ Application: [unknown] - Total duration: 13m43s - Times executed: 71 ]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 09:10:01 Duration: 32s791ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 07:44:17 Duration: 13s84ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 10:00:08 Duration: 12s993ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 8m43s 160 160ms 27s865ms 3s273ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 18 00 6 48s891ms 8s148ms 01 6 20s469ms 3s411ms 02 6 21s695ms 3s615ms 03 5 19s61ms 3s812ms 04 6 18s988ms 3s164ms 05 5 29s939ms 5s987ms 07 10 32s868ms 3s286ms 08 11 40s450ms 3s677ms 09 12 46s910ms 3s909ms 10 12 34s101ms 2s841ms 11 12 52s331ms 4s360ms 12 10 17s662ms 1s766ms 13 8 7s332ms 916ms 14 11 29s986ms 2s726ms 15 12 32s843ms 2s736ms 16 8 9s386ms 1s173ms 17 3 3s535ms 1s178ms 20 7 2s75ms 296ms 21 4 26s644ms 6s661ms 22 6 28s659ms 4s776ms [ User: intelifix - Total duration: 8m43s - Times executed: 160 ]
[ Application: psql - Total duration: 8m43s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-18 00:05:29 Duration: 27s865ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-18 21:25:13 Duration: 11s899ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-18 22:15:11 Duration: 10s576ms Database: rio User: intelifix Remote: [local] Application: psql
9 7m54s 783 150ms 19s447ms 605ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 18 07 76 49s929ms 656ms 08 119 1m2s 524ms 09 126 1m10s 561ms 10 142 1m13s 521ms 11 90 53s862ms 598ms 12 13 10s744ms 826ms 13 34 41s74ms 1s208ms 14 89 50s280ms 564ms 15 68 49s769ms 731ms 16 17 7s442ms 437ms 17 9 3s851ms 427ms [ User: intelifix - Total duration: 7m54s - Times executed: 783 ]
[ Application: [unknown] - Total duration: 7m54s - Times executed: 783 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288728", "modelo" : "305", "itens" : "241639763954,241681610115,229998838203,,229999428192,229999130005", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-18 13:43:57 Duration: 19s447ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288473", "modelo" : "463", "itens" : "241782614259,241719975463,241755926985,241718773842,241756000304,241751893640,241783300623,241736771929,241792111718,241782152946,241720781132,241720378992,241720865662,241748558702,241722907578,241789568204,241736712024,241722571228,241722343652,241755859201,241754683037,241755914257,241754675258,241784727192,241735753939,241758848493,241736624361,241750487677,241794547589,241755095961,241780602121,241736709700,241751998397,241736497681,241751792845,241736743138,241794394466,241735110207,241756951014,241736761019,241721344048,241720492237,241753769198,241748864646,241781470321,241755158290,241737807192,241721018607,241735835462,241755814752,241720501329,241786147981,241755848391,241748501727,241721376980,241781580309,241758546062,241724491819,241758060000,241722979000", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-18 09:24:12 Duration: 4s190ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288467", "modelo" : "463", "itens" : "241783267891,241755841119,241781435064,241718966868,241790262424,241783273246,241720042844,241787551116,241782666486,241751834768,241756979399,241752245369,241735361926,241736468789,241758071516,241782608399,241752954058,241724000324,241754638587,241756863755,241735606775,241756887898,241751821838,241794094459,241706117275,241750216585,241724114453,241753693535,241719193535,241794160729,241754249403,241706138085,241754656670,241720323455,241756960712,241706136267,241737370708,241723244761,241752090910,241758201529,241751104865,241753178704,241736760817,241736787182,241722568398,241754659903,241719961422,241748336783,241787702949,241786815454,241758957595,241753569606,241753702021,241782684748,241736588701,241736411535,241758536364,241790265757,241784496485,241736800316", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-18 07:48:34 Duration: 3s807ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 5m28s 147 153ms 30s651ms 2s235ms call rs_giga_triagem (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 18 00 7 19s624ms 2s803ms 01 6 8s930ms 1s488ms 02 6 8s964ms 1s494ms 03 6 10s136ms 1s689ms 04 6 9s74ms 1s512ms 05 6 8s810ms 1s468ms 06 6 9s332ms 1s555ms 07 7 14s156ms 2s22ms 08 6 10s103ms 1s683ms 09 7 12s785ms 1s826ms 10 6 10s919ms 1s819ms 11 8 13s314ms 1s664ms 12 6 10s20ms 1s670ms 13 6 10s378ms 1s729ms 14 6 39s791ms 6s631ms 15 6 10s161ms 1s693ms 16 7 11s237ms 1s605ms 17 6 9s861ms 1s643ms 18 6 9s714ms 1s619ms 19 6 9s659ms 1s609ms 20 8 43s38ms 5s379ms 21 7 28s443ms 4s63ms 22 6 10s143ms 1s690ms [ User: intelifix - Total duration: 5m28s - Times executed: 147 ]
[ Application: psql - Total duration: 5m28s - Times executed: 147 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-18 14:45:36 Duration: 30s651ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-18 20:25:17 Duration: 16s114ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-18 20:55:16 Duration: 15s75ms Database: rio User: intelifix Remote: [local] Application: psql
11 4m18s 17 10s775ms 1m2s 15s189ms create table temp0000291755 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 18 07 1 1m2s 1m2s 08 1 14s671ms 14s671ms 09 1 11s442ms 11s442ms 11 2 22s793ms 11s396ms 13 1 23s899ms 23s899ms 14 4 44s168ms 11s42ms 16 7 1m18s 11s209ms [ User: intelifix - Total duration: 4m18s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 4m18s - Times executed: 17 ]
-
CREATE TABLE temp0000291755 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 07:14:34 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291755 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 13:50:29 Duration: 23s899ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291755 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 08:23:24 Duration: 14s671ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 4m5s 39 158ms 40s660ms 6s284ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 18 07 2 1m2s 31s139ms 08 2 28s508ms 14s254ms 09 6 40s477ms 6s746ms 10 3 19s791ms 6s597ms 11 7 40s111ms 5s730ms 12 1 896ms 896ms 13 1 1s418ms 1s418ms 14 5 25s741ms 5s148ms 15 3 7s764ms 2s588ms 16 1 571ms 571ms 17 8 17s522ms 2s190ms [ User: intelifix - Total duration: 4m5s - Times executed: 39 ]
[ Application: psql - Total duration: 4m5s - Times executed: 39 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030044);
Date: 2026-09-18 07:45:21 Duration: 40s660ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030049);
Date: 2026-09-18 08:35:06 Duration: 28s51ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030043);
Date: 2026-09-18 07:15:06 Duration: 21s618ms Database: rio User: intelifix Remote: [local] Application: psql
13 3m48s 62 2s728ms 21s630ms 3s682ms create table temp0000291807 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 18 07 3 8s343ms 2s781ms 08 1 21s630ms 21s630ms 09 11 34s219ms 3s110ms 10 9 30s606ms 3s400ms 11 22 1m14s 3s400ms 14 8 30s344ms 3s793ms 15 8 28s347ms 3s543ms [ User: intelifix - Total duration: 3m48s - Times executed: 62 ]
[ Application: [unknown] - Total duration: 3m48s - Times executed: 62 ]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"13-09-2026", "ate" :"18-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-18 08:45:08 Duration: 21s630ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"13-09-2026", "ate" :"18-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-18 11:09:57 Duration: 4s381ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"13-09-2026", "ate" :"18-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-18 14:29:02 Duration: 3s909ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 3m41s 38 152ms 1m13s 5s836ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 18 07 4 1m14s 18s528ms 08 3 3s410ms 1s136ms 09 4 54s91ms 13s522ms 10 4 1s65ms 266ms 11 10 5s766ms 576ms 12 1 3s655ms 3s655ms 13 1 4s23ms 4s23ms 14 6 46s147ms 7s691ms 15 2 370ms 185ms 16 3 29s160ms 9s720ms [ User: intelifix - Total duration: 3m41s - Times executed: 38 ]
[ Application: psql - Total duration: 3m41s - Times executed: 38 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030043);
Date: 2026-09-18 07:14:44 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030051);
Date: 2026-09-18 09:13:20 Duration: 53s115ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030072);
Date: 2026-09-18 14:07:34 Duration: 41s80ms Database: rio User: intelifix Remote: [local] Application: psql
15 3m37s 6 388ms 2m42s 36s212ms create table temp0000240462 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 18 11 6 3m37s 36s212ms [ User: intelifix - Total duration: 3m37s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 3m37s - Times executed: 6 ]
-
CREATE TABLE temp0000240462 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "", "data-ate" : "18-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-18 11:14:55 Duration: 2m42s Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000240462 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "", "data-ate" : "18-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-18 11:15:23 Duration: 27s679ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000240462 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "", "data-ate" : "18-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-18 11:15:48 Duration: 24s755ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 2m34s 20 5s75ms 12s652ms 7s737ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 18 00 3 33s456ms 11s152ms 06 3 19s826ms 6s608ms 20 6 45s290ms 7s548ms 21 8 56s167ms 7s20ms [ User: intelifix - Total duration: 2m34s - Times executed: 20 ]
[ Application: psql - Total duration: 2m34s - Times executed: 20 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-18 00:05:14 Duration: 12s652ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-18 00:05:35 Duration: 10s994ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-18 21:51:00 Duration: 10s70ms Database: rio User: intelifix Remote: [local] Application: psql
17 2m19s 4 4s679ms 1m6s 34s750ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 18 20 2 1m10s 35s495ms 23 2 1m8s 34s6ms [ User: intelifix - Total duration: 2m19s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m19s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-18 20:08:47 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-18 23:16:41 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-18 23:34:07 Duration: 4s816ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 2m16s 12 10s751ms 14s854ms 11s406ms create table temp0000291585 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 18 09 2 26s172ms 13s86ms 11 4 44s446ms 11s111ms 15 2 22s239ms 11s119ms 16 4 44s24ms 11s6ms [ User: intelifix - Total duration: 2m16s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m16s - Times executed: 12 ]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 09:44:39 Duration: 14s854ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 11:25:22 Duration: 11s381ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 16:11:21 Duration: 11s325ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 1m54s 55 257ms 19s261ms 2s89ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 18 08 4 3s28ms 757ms 09 4 8s284ms 2s71ms 10 4 14s634ms 3s658ms 11 5 17s940ms 3s588ms 12 4 5s188ms 1s297ms 13 4 7s702ms 1s925ms 14 3 2s310ms 770ms 15 4 16s813ms 4s203ms 16 3 3s424ms 1s141ms 17 3 20s875ms 6s958ms 18 5 3s901ms 780ms 19 5 4s372ms 874ms 20 2 1s498ms 749ms 21 2 2s188ms 1s94ms 22 3 2s768ms 922ms [ User: intelifix - Total duration: 1m54s - Times executed: 55 ]
[ Application: psql - Total duration: 1m54s - Times executed: 55 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-18 17:40:21 Duration: 19s261ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-18 10:20:09 Duration: 8s368ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-18 11:00:09 Duration: 8s159ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m49s 6 3s79ms 40s602ms 18s201ms 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 #20
Day Hour Count Duration Avg duration Sep 18 20 3 54s249ms 18s83ms 23 3 54s960ms 18s320ms [ User: intelifix - Total duration: 1m49s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m49s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-18 23:14:27 Duration: 40s602ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-18 20:06:28 Duration: 40s455ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-18 23:33:42 Duration: 10s825ms 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 1,217 15m51s 150ms 7s992ms 781ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 18 07 79 57s901ms 732ms 08 164 2m27s 898ms 09 183 3m1s 990ms 10 194 2m48s 867ms 11 173 2m16s 789ms 12 15 11s236ms 749ms 13 70 46s675ms 666ms 14 132 1m23s 631ms 15 140 1m26s 619ms 16 43 22s715ms 528ms 17 24 9s40ms 376ms [ User: intelifix - Total duration: 15m51s - Times executed: 1217 ]
[ Application: [unknown] - Total duration: 15m51s - Times executed: 1217 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (58206, 407, '836066910001284,241732104144,241662993651,241604293343,230048512647,241678346170,241609652744,241602087190,241676706066,241646321620,241607247278,241604981727,230048512041,241726923549,241631317899,241727092230,241659701018,241619569413,241714068602,241696975261,241656691016,241593318602,241636065669,241632343948,241607206365,230043524752,241593986175,241661489698,241614536183,241717131213,241698666784,241663061840,241659754760,241677634350,241622531330,230048510223,241632305156,241704334655,241608661525,241728540015,241698671028,241654884857,241617429406,241679131332,241676789509,241617452944,241708756478,241660129094,241621408099,241698682443,241664839409', '',0321,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":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-18 08:29:54 Duration: 7s992ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (288487, 404, '270911029504103338,229783452738,229781243353,229671769919,229667826885,229786832024,216945272330,229743763354,229836352435,216941817076,229734474759,216942010710,229689580513,229810799604,229661612744,229737315272,229670566883,229865251619,229746655465', '246586232223,246601126785,246494746167,246497649111,246598186969,246484013549,246538649700,246640591524,246482184560,246538718595,246471313241,246520641232,246640393446,246487128790,246528061114,246515186669,246649646885,246569516573,,,,,,,,,,,,,,,,,,,,,,', 0141, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-09-18 09:59:35 Duration: 7s879ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (58165, 407, '226400441229', '',0172,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":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-18 09:40:30 Duration: 3s794ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 783 7m54s 150ms 19s447ms 605ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 18 07 76 49s929ms 656ms 08 119 1m2s 524ms 09 126 1m10s 561ms 10 142 1m13s 521ms 11 90 53s862ms 598ms 12 13 10s744ms 826ms 13 34 41s74ms 1s208ms 14 89 50s280ms 564ms 15 68 49s769ms 731ms 16 17 7s442ms 437ms 17 9 3s851ms 427ms [ User: intelifix - Total duration: 7m54s - Times executed: 783 ]
[ Application: [unknown] - Total duration: 7m54s - Times executed: 783 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288728", "modelo" : "305", "itens" : "241639763954,241681610115,229998838203,,229999428192,229999130005", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-18 13:43:57 Duration: 19s447ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288473", "modelo" : "463", "itens" : "241782614259,241719975463,241755926985,241718773842,241756000304,241751893640,241783300623,241736771929,241792111718,241782152946,241720781132,241720378992,241720865662,241748558702,241722907578,241789568204,241736712024,241722571228,241722343652,241755859201,241754683037,241755914257,241754675258,241784727192,241735753939,241758848493,241736624361,241750487677,241794547589,241755095961,241780602121,241736709700,241751998397,241736497681,241751792845,241736743138,241794394466,241735110207,241756951014,241736761019,241721344048,241720492237,241753769198,241748864646,241781470321,241755158290,241737807192,241721018607,241735835462,241755814752,241720501329,241786147981,241755848391,241748501727,241721376980,241781580309,241758546062,241724491819,241758060000,241722979000", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-18 09:24:12 Duration: 4s190ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288467", "modelo" : "463", "itens" : "241783267891,241755841119,241781435064,241718966868,241790262424,241783273246,241720042844,241787551116,241782666486,241751834768,241756979399,241752245369,241735361926,241736468789,241758071516,241782608399,241752954058,241724000324,241754638587,241756863755,241735606775,241756887898,241751821838,241794094459,241706117275,241750216585,241724114453,241753693535,241719193535,241794160729,241754249403,241706138085,241754656670,241720323455,241756960712,241706136267,241737370708,241723244761,241752090910,241758201529,241751104865,241753178704,241736760817,241736787182,241722568398,241754659903,241719961422,241748336783,241787702949,241786815454,241758957595,241753569606,241753702021,241782684748,241736588701,241736411535,241758536364,241790265757,241784496485,241736800316", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-18 07:48:34 Duration: 3s807ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 187 1h20m37s 150ms 6m55s 25s868ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 18 07 18 8m7s 27s68ms 08 12 13m34s 1m7s 09 19 12m21s 39s38ms 10 30 11m54s 23s830ms 11 15 5m59s 23s997ms 12 3 1m15s 25s281ms 13 12 19s853ms 1s654ms 14 28 11m33s 24s784ms 15 12 5m58s 29s849ms 16 19 8m55s 28s163ms 17 19 36s446ms 1s918ms [ User: intelifix - Total duration: 1h20m37s - Times executed: 187 ]
[ Application: [unknown] - Total duration: 1h20m37s - Times executed: 187 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030044, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-18 07:52:09 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030084, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');
Date: 2026-09-18 16:22:20 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030050, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-18 09:16:39 Duration: 6m1s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 160 8m43s 160ms 27s865ms 3s273ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 18 00 6 48s891ms 8s148ms 01 6 20s469ms 3s411ms 02 6 21s695ms 3s615ms 03 5 19s61ms 3s812ms 04 6 18s988ms 3s164ms 05 5 29s939ms 5s987ms 07 10 32s868ms 3s286ms 08 11 40s450ms 3s677ms 09 12 46s910ms 3s909ms 10 12 34s101ms 2s841ms 11 12 52s331ms 4s360ms 12 10 17s662ms 1s766ms 13 8 7s332ms 916ms 14 11 29s986ms 2s726ms 15 12 32s843ms 2s736ms 16 8 9s386ms 1s173ms 17 3 3s535ms 1s178ms 20 7 2s75ms 296ms 21 4 26s644ms 6s661ms 22 6 28s659ms 4s776ms [ User: intelifix - Total duration: 8m43s - Times executed: 160 ]
[ Application: psql - Total duration: 8m43s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-18 00:05:29 Duration: 27s865ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-18 21:25:13 Duration: 11s899ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-18 22:15:11 Duration: 10s576ms Database: rio User: intelifix Remote: [local] Application: psql
5 147 5m28s 153ms 30s651ms 2s235ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 18 00 7 19s624ms 2s803ms 01 6 8s930ms 1s488ms 02 6 8s964ms 1s494ms 03 6 10s136ms 1s689ms 04 6 9s74ms 1s512ms 05 6 8s810ms 1s468ms 06 6 9s332ms 1s555ms 07 7 14s156ms 2s22ms 08 6 10s103ms 1s683ms 09 7 12s785ms 1s826ms 10 6 10s919ms 1s819ms 11 8 13s314ms 1s664ms 12 6 10s20ms 1s670ms 13 6 10s378ms 1s729ms 14 6 39s791ms 6s631ms 15 6 10s161ms 1s693ms 16 7 11s237ms 1s605ms 17 6 9s861ms 1s643ms 18 6 9s714ms 1s619ms 19 6 9s659ms 1s609ms 20 8 43s38ms 5s379ms 21 7 28s443ms 4s63ms 22 6 10s143ms 1s690ms [ User: intelifix - Total duration: 5m28s - Times executed: 147 ]
[ Application: psql - Total duration: 5m28s - Times executed: 147 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-18 14:45:36 Duration: 30s651ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-18 20:25:17 Duration: 16s114ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-18 20:55:16 Duration: 15s75ms Database: rio User: intelifix Remote: [local] Application: psql
6 100 48s237ms 168ms 999ms 482ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 18 09 49 23s609ms 481ms 10 51 24s627ms 482ms [ User: intelifix - Total duration: 48s237ms - Times executed: 100 ]
[ Application: [unknown] - Total duration: 48s237ms - Times executed: 100 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57787","seriais":"4075C3284940,F8D2AC4A58BC,C4509CBF4624,3C82C0CA7CBC,3C82C0CCA9EC,B85E71E18DB8,C4509CECBFC4,3C82C066EB08,08A7C06F5744,80DAC2CD2020,4075C3C2E100,00CB7ADC1074,484BD4B1F50C,484BD4B53BBC,4075C3BB3D4C,4075C3B3B784,D4E2CB93B84C,B85E71D951C0,3C82C066EE50,00CB7AE611F0,B85E71EB95EC,ECA81F20A314,8C6A8DC28044,484BD49C5714,B85E71C7225C,B85E71C44244","usuario":"416","observacao":""}');
Date: 2026-09-18 09:06:44 Duration: 999ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57785","seriais":"229701118596,229701119809,229701119708,229835918699,229675385367,229713973443,229732844454,229675387286,216922523645,229775117681,229831304153,229829871118,229776320516,229763601620,229712738686,229701106777,229692028305,229713739806,229707608400,229778281313,229703668396,229777931425,229701091928,229733470913,229704969297,229776682324,229776485458,216922606582,229697368084,229701092130,229710820824,229700462237,216922117690,229794639800,229698454465","usuario":"416","observacao":""}');
Date: 2026-09-18 10:05:33 Duration: 961ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57785","seriais":"1062D0278FFA,A456CCE638E8,383FB3A878DF,BC9B689B02C8,383FB3A1CF24,BC9B689ACCB2,80D04A9439DB,087E64845381,D4B92F2BDC48,54A65C1299DE,54A65C8A76F8,14B7F8E15212,B42A0E1C9054,54A65C105196,54A65C8D0379,70037E9F5FF9,80D04AB9F43F,80D04A92B6EA,905851A7E7AA,A456CCDF9A94,70037E9CFAD8,383FB3AA6BC9,80D04AB7EDF9,54A65C8C74A8","usuario":"416","observacao":""}');
Date: 2026-09-18 10:03:57 Duration: 908ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
7 96 31s49ms 298ms 416ms 323ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 18 04 2 625ms 312ms 06 1 312ms 312ms 07 10 3s273ms 327ms 08 10 3s234ms 323ms 09 11 3s523ms 320ms 10 14 4s497ms 321ms 11 7 2s318ms 331ms 12 3 986ms 328ms 13 10 3s198ms 319ms 14 8 2s637ms 329ms 15 8 2s542ms 317ms 16 8 2s655ms 331ms 17 4 1s243ms 310ms [ User: lenon - Total duration: 31s49ms - Times executed: 96 ]
[ Application: [unknown] - Total duration: 31s49ms - Times executed: 96 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-18 14:07:30 Duration: 416ms 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-09-18 07:45:06 Duration: 389ms 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-09-18 16:44:02 Duration: 381ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
8 85 34s264ms 331ms 1s104ms 403ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 18 04 2 1s21ms 510ms 07 8 3s118ms 389ms 08 9 4s100ms 455ms 09 11 4s207ms 382ms 10 11 4s133ms 375ms 11 6 2s731ms 455ms 12 3 1s209ms 403ms 13 9 3s626ms 402ms 14 7 2s724ms 389ms 15 7 2s623ms 374ms 16 8 3s285ms 410ms 17 4 1s480ms 370ms [ User: intelifix - Total duration: 34s264ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 34s264ms - Times executed: 85 ]
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-09-18 08:14:20 Duration: 1s104ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (397, 5, 1);
Date: 2026-09-18 11:13:52 Duration: 884ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (477, 19, 1);
Date: 2026-09-18 04:07:51 Duration: 683ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 84 24s699ms 252ms 433ms 294ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 18 07 7 1s984ms 283ms 08 6 1s757ms 292ms 09 5 1s491ms 298ms 10 7 2s165ms 309ms 11 15 4s561ms 304ms 13 6 1s716ms 286ms 14 9 2s490ms 276ms 15 10 3s73ms 307ms 16 6 1s758ms 293ms 17 13 3s700ms 284ms [ User: intelifix - Total duration: 24s699ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 24s699ms - Times executed: 84 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-09-18 15:39:01 Duration: 433ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-18 10:07:42 Duration: 426ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-18 11:10:32 Duration: 421ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
10 82 58s719ms 151ms 2s334ms 716ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 18 07 16 11s488ms 718ms 08 1 859ms 859ms 09 6 5s803ms 967ms 10 15 13s178ms 878ms 11 5 2s167ms 433ms 13 10 7s136ms 713ms 14 16 10s75ms 629ms 15 3 2s212ms 737ms 16 5 2s849ms 569ms 17 5 2s947ms 589ms [ User: intelifix - Total duration: 58s719ms - Times executed: 82 ]
[ Application: [unknown] - Total duration: 58s719ms - Times executed: 82 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0288373) LIMIT 1;
Date: 2026-09-18 09:57:26 Duration: 2s334ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0288373) LIMIT 1;
Date: 2026-09-18 14:44:14 Duration: 2s101ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0288324) LIMIT 1;
Date: 2026-09-18 07:34:03 Duration: 1s954ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 78 17m3s 1s573ms 1m20s 13s120ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 18 07 4 1m45s 26s274ms 08 1 7s822ms 7s822ms 09 11 3m29s 19s80ms 10 5 26s412ms 5s282ms 11 5 2m40s 32s98ms 12 4 14s959ms 3s739ms 13 5 1m3s 12s634ms 14 9 1m38s 10s998ms 15 10 2m9s 12s966ms 16 16 3m1s 11s345ms 17 8 25s352ms 3s169ms [ User: intelifix - Total duration: 17m3s - Times executed: 78 ]
[ Application: [unknown] - Total duration: 17m3s - Times executed: 78 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-18', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-18 09:04:34 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-18', 0184, '', '', 0, 6, '2026-09-01');
Date: 2026-09-18 07:25:05 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-18', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-18 11:06:24 Duration: 1m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
12 71 13m43s 10s420ms 32s791ms 11s597ms create table temp0000291807 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 18 07 7 1m21s 11s574ms 08 6 1m7s 11s238ms 09 6 1m29s 14s931ms 10 11 2m10s 11s881ms 11 20 3m44s 11s236ms 14 9 1m37s 10s887ms 15 12 2m11s 10s996ms [ User: intelifix - Total duration: 13m43s - Times executed: 71 ]
[ Application: [unknown] - Total duration: 13m43s - Times executed: 71 ]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 09:10:01 Duration: 32s791ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 07:44:17 Duration: 13s84ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 10:00:08 Duration: 12s993ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 67 19s770ms 154ms 1s28ms 295ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 18 07 1 690ms 690ms 08 12 3s359ms 279ms 09 19 6s19ms 316ms 10 6 1s599ms 266ms 11 7 2s4ms 286ms 12 2 521ms 260ms 14 11 2s750ms 250ms 15 5 1s353ms 270ms 16 4 1s471ms 367ms [ User: intelifix - Total duration: 19s770ms - Times executed: 67 ]
[ Application: [unknown] - Total duration: 19s770ms - Times executed: 67 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'E8436853EF30,E84368544194,E8436854524C,E843685453F4,E84368544A6C,E84368544F3C,E84368540974,E84368544EBC', '','DEFAULT',09,0317,'', '','', 00);
Date: 2026-09-18 09:35:38 Duration: 1s28ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '241750097684,241781624656,241754568301,241755999898,241755780507,241736637089,241792254257,241754661621,241784530204,241782126579,241736699800,241753652241,241750450324,241723229204,241750462345,241750599507,241750459516,241750534147,241782147288,241723235467,241719974857,241719998697,241736583145,241753506771,241754581333,241721641833,241754596990,241781966788,241735960223,241754653640', '70;1', 'DEFAULT', 09, 0463, '','', '', 00);
Date: 2026-09-18 16:21:53 Duration: 743ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '920121021964,919391148510,918451089048,919121094756,919411029556,919241191618,920041055124,3093BC4CCA87,920121003075', '138;1', 'DEFAULT', 09, 0129, '','', '', 00);
Date: 2026-09-18 07:57:51 Duration: 690ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
14 62 3m48s 2s728ms 21s630ms 3s682ms create table temp0000291807 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 18 07 3 8s343ms 2s781ms 08 1 21s630ms 21s630ms 09 11 34s219ms 3s110ms 10 9 30s606ms 3s400ms 11 22 1m14s 3s400ms 14 8 30s344ms 3s793ms 15 8 28s347ms 3s543ms [ User: intelifix - Total duration: 3m48s - Times executed: 62 ]
[ Application: [unknown] - Total duration: 3m48s - Times executed: 62 ]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"13-09-2026", "ate" :"18-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-18 08:45:08 Duration: 21s630ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"13-09-2026", "ate" :"18-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-18 11:09:57 Duration: 4s381ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"13-09-2026", "ate" :"18-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-18 14:29:02 Duration: 3s909ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 62 14s588ms 150ms 491ms 235ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 18 07 5 1s514ms 302ms 08 13 2s783ms 214ms 09 3 703ms 234ms 10 10 2s511ms 251ms 11 14 3s19ms 215ms 14 9 1s893ms 210ms 15 3 755ms 251ms 16 5 1s406ms 281ms [ User: intelifix - Total duration: 14s588ms - Times executed: 62 ]
[ Application: [unknown] - Total duration: 14s588ms - Times executed: 62 ]
-
SELECT * FROM RS_TRIAGEM (373, 5, '70', 2, '241706277998,241706270120,241721619810,241735811016,241723255469,241723260521,241736768695,241736690911,241722539709,241706278908', NULL, NULL, 0463, 00);
Date: 2026-09-18 07:53:12 Duration: 491ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (410, 5, '113', 3, '230005960122,229976672639,229963340721,229988850820,229971135566,229976759920,230027474555,229988573946,230014853649,230011295557,229977412341', NULL, NULL, 0295, 00);
Date: 2026-09-18 16:28:28 Duration: 421ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (410, 5, '113', 3, '229976808891,230032491824,230047064357,229980087079,229971707193,230027300319,230019429000,229966166080,230014365868,230055467275', NULL, NULL, 0295, 00);
Date: 2026-09-18 16:27:17 Duration: 379ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 55 1m54s 257ms 19s261ms 2s89ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 18 08 4 3s28ms 757ms 09 4 8s284ms 2s71ms 10 4 14s634ms 3s658ms 11 5 17s940ms 3s588ms 12 4 5s188ms 1s297ms 13 4 7s702ms 1s925ms 14 3 2s310ms 770ms 15 4 16s813ms 4s203ms 16 3 3s424ms 1s141ms 17 3 20s875ms 6s958ms 18 5 3s901ms 780ms 19 5 4s372ms 874ms 20 2 1s498ms 749ms 21 2 2s188ms 1s94ms 22 3 2s768ms 922ms [ User: intelifix - Total duration: 1m54s - Times executed: 55 ]
[ Application: psql - Total duration: 1m54s - Times executed: 55 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-18 17:40:21 Duration: 19s261ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-18 10:20:09 Duration: 8s368ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-18 11:00:09 Duration: 8s159ms Database: rio User: intelifix Remote: [local] Application: psql
17 51 18s527ms 152ms 1s536ms 363ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 18 06 1 424ms 424ms 07 1 224ms 224ms 08 5 3s755ms 751ms 09 7 2s14ms 287ms 10 7 1s627ms 232ms 11 12 4s183ms 348ms 13 3 915ms 305ms 14 8 3s767ms 470ms 15 2 584ms 292ms 16 1 173ms 173ms 17 4 855ms 213ms [ User: intelifix - Total duration: 18s527ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 18s527ms - Times executed: 51 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "363", "data-de" : "2026-09-17", "data-ate" : "2026-09-17", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 415 }');
Date: 2026-09-18 08:35:54 Duration: 1s536ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "398", "data-de" : "2026-09-17", "data-ate" : "2026-09-17", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 452 }');
Date: 2026-09-18 08:06:46 Duration: 960ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "307", "data-de" : "2026-09-18", "data-ate" : "2026-09-18", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 304 }');
Date: 2026-09-18 11:34:37 Duration: 829ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 46 1h49m16s 1s415ms 10m51s 2m22s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 18 07 3 10m7s 3m22s 08 3 5m47s 1m55s 09 3 7m56s 2m38s 10 3 6m13s 2m4s 11 3 6m23s 2m7s 12 3 6m8s 2m2s 13 3 5m29s 1m49s 14 3 5m48s 1m56s 15 3 5m40s 1m53s 16 2 5m12s 2m36s 17 3 5m31s 1m50s 18 3 5m22s 1m47s 19 3 5m23s 1m47s 20 3 5m49s 1m56s 21 2 11m59s 5m59s 22 3 10m20s 3m26s [ User: intelifix - Total duration: 1h49m16s - Times executed: 46 ]
[ Application: psql - Total duration: 1h49m16s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-18 21:15:53 Duration: 10m51s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-18 22:14:15 Duration: 9m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-18 07:14:12 Duration: 9m11s Database: rio User: intelifix Remote: [local] Application: psql
19 46 1h7m55s 246ms 4m15s 1m28s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 18 07 3 5m44s 1m54s 08 3 4m18s 1m26s 09 3 4m47s 1m35s 10 3 4m18s 1m26s 11 3 4m15s 1m25s 12 3 4m26s 1m28s 13 3 3m58s 1m19s 14 3 4m6s 1m22s 15 3 4m3s 1m21s 16 3 4m2s 1m20s 17 3 3m57s 1m19s 18 3 3m53s 1m17s 19 3 4m 1m20s 20 3 4m1s 1m20s 21 1 1m59s 1m59s 22 3 6m 2m [ User: intelifix - Total duration: 1h7m55s - Times executed: 46 ]
[ Application: psql - Total duration: 1h7m55s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-18 22:21:02 Duration: 4m15s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-18 07:20:42 Duration: 4m14s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-18 09:17:42 Duration: 3m52s Database: brasilia User: intelifix Remote: [local] Application: psql
20 44 9s616ms 150ms 476ms 218ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 18 01 1 476ms 476ms 04 2 677ms 338ms 06 1 270ms 270ms 07 1 175ms 175ms 08 9 1s765ms 196ms 09 7 1s416ms 202ms 10 2 371ms 185ms 11 8 1s580ms 197ms 12 2 369ms 184ms 13 1 196ms 196ms 14 2 635ms 317ms 15 7 1s496ms 213ms 16 1 185ms 185ms [ User: intelifix - Total duration: 9s616ms - Times executed: 44 ]
[ Application: [unknown] - Total duration: 9s616ms - Times executed: 44 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('8CE5EFD226A1');
Date: 2026-09-18 01:35:50 Duration: 476ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('D4B92F27FF49');
Date: 2026-09-18 14:15:24 Duration: 471ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('00953006207047');
Date: 2026-09-18 09:31:32 Duration: 392ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m11s 11m50s 7m37s 3 22m53s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 18 05 3 22m53s 7m37s [ User: intelifix - Total duration: 22m53s - Times executed: 3 ]
[ Application: psql - Total duration: 22m53s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-18 05:11:51 Duration: 11m50s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-18 05:19:43 Duration: 7m51s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-18 05:22:54 Duration: 3m11s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s415ms 10m51s 2m22s 46 1h49m16s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 18 07 3 10m7s 3m22s 08 3 5m47s 1m55s 09 3 7m56s 2m38s 10 3 6m13s 2m4s 11 3 6m23s 2m7s 12 3 6m8s 2m2s 13 3 5m29s 1m49s 14 3 5m48s 1m56s 15 3 5m40s 1m53s 16 2 5m12s 2m36s 17 3 5m31s 1m50s 18 3 5m22s 1m47s 19 3 5m23s 1m47s 20 3 5m49s 1m56s 21 2 11m59s 5m59s 22 3 10m20s 3m26s [ User: intelifix - Total duration: 1h49m16s - Times executed: 46 ]
[ Application: psql - Total duration: 1h49m16s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-18 21:15:53 Duration: 10m51s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-18 22:14:15 Duration: 9m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-18 07:14:12 Duration: 9m11s Database: rio User: intelifix Remote: [local] Application: psql
3 246ms 4m15s 1m28s 46 1h7m55s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 18 07 3 5m44s 1m54s 08 3 4m18s 1m26s 09 3 4m47s 1m35s 10 3 4m18s 1m26s 11 3 4m15s 1m25s 12 3 4m26s 1m28s 13 3 3m58s 1m19s 14 3 4m6s 1m22s 15 3 4m3s 1m21s 16 3 4m2s 1m20s 17 3 3m57s 1m19s 18 3 3m53s 1m17s 19 3 4m 1m20s 20 3 4m1s 1m20s 21 1 1m59s 1m59s 22 3 6m 2m [ User: intelifix - Total duration: 1h7m55s - Times executed: 46 ]
[ Application: psql - Total duration: 1h7m55s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-18 22:21:02 Duration: 4m15s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-18 07:20:42 Duration: 4m14s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-18 09:17:42 Duration: 3m52s Database: brasilia User: intelifix Remote: [local] Application: psql
4 388ms 2m42s 36s212ms 6 3m37s create table temp0000240462 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 18 11 6 3m37s 36s212ms [ User: intelifix - Total duration: 3m37s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 3m37s - Times executed: 6 ]
-
CREATE TABLE temp0000240462 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "", "data-ate" : "18-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-18 11:14:55 Duration: 2m42s Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000240462 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "", "data-ate" : "18-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-18 11:15:23 Duration: 27s679ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000240462 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "", "data-ate" : "18-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-18 11:15:48 Duration: 24s755ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
5 4s679ms 1m6s 34s750ms 4 2m19s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 18 20 2 1m10s 35s495ms 23 2 1m8s 34s6ms [ User: intelifix - Total duration: 2m19s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m19s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-18 20:08:47 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-18 23:16:41 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-18 23:34:07 Duration: 4s816ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 150ms 6m55s 25s868ms 187 1h20m37s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 18 07 18 8m7s 27s68ms 08 12 13m34s 1m7s 09 19 12m21s 39s38ms 10 30 11m54s 23s830ms 11 15 5m59s 23s997ms 12 3 1m15s 25s281ms 13 12 19s853ms 1s654ms 14 28 11m33s 24s784ms 15 12 5m58s 29s849ms 16 19 8m55s 28s163ms 17 19 36s446ms 1s918ms [ User: intelifix - Total duration: 1h20m37s - Times executed: 187 ]
[ Application: [unknown] - Total duration: 1h20m37s - Times executed: 187 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030044, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-18 07:52:09 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030084, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');
Date: 2026-09-18 16:22:20 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030050, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-18 09:16:39 Duration: 6m1s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 3s79ms 40s602ms 18s201ms 6 1m49s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 18 20 3 54s249ms 18s83ms 23 3 54s960ms 18s320ms [ User: intelifix - Total duration: 1m49s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m49s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-18 23:14:27 Duration: 40s602ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-18 20:06:28 Duration: 40s455ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-18 23:33:42 Duration: 10s825ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 10s775ms 1m2s 15s189ms 17 4m18s create table temp0000291755 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 18 07 1 1m2s 1m2s 08 1 14s671ms 14s671ms 09 1 11s442ms 11s442ms 11 2 22s793ms 11s396ms 13 1 23s899ms 23s899ms 14 4 44s168ms 11s42ms 16 7 1m18s 11s209ms [ User: intelifix - Total duration: 4m18s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 4m18s - Times executed: 17 ]
-
CREATE TABLE temp0000291755 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 07:14:34 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291755 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 13:50:29 Duration: 23s899ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291755 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 08:23:24 Duration: 14s671ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 1s573ms 1m20s 13s120ms 78 17m3s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 18 07 4 1m45s 26s274ms 08 1 7s822ms 7s822ms 09 11 3m29s 19s80ms 10 5 26s412ms 5s282ms 11 5 2m40s 32s98ms 12 4 14s959ms 3s739ms 13 5 1m3s 12s634ms 14 9 1m38s 10s998ms 15 10 2m9s 12s966ms 16 16 3m1s 11s345ms 17 8 25s352ms 3s169ms [ User: intelifix - Total duration: 17m3s - Times executed: 78 ]
[ Application: [unknown] - Total duration: 17m3s - Times executed: 78 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-18', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-18 09:04:34 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-18', 0184, '', '', 0, 6, '2026-09-01');
Date: 2026-09-18 07:25:05 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-18', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-18 11:06:24 Duration: 1m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s420ms 32s791ms 11s597ms 71 13m43s create table temp0000291807 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 18 07 7 1m21s 11s574ms 08 6 1m7s 11s238ms 09 6 1m29s 14s931ms 10 11 2m10s 11s881ms 11 20 3m44s 11s236ms 14 9 1m37s 10s887ms 15 12 2m11s 10s996ms [ User: intelifix - Total duration: 13m43s - Times executed: 71 ]
[ Application: [unknown] - Total duration: 13m43s - Times executed: 71 ]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 09:10:01 Duration: 32s791ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 07:44:17 Duration: 13s84ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 10:00:08 Duration: 12s993ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s751ms 14s854ms 11s406ms 12 2m16s create table temp0000291585 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 18 09 2 26s172ms 13s86ms 11 4 44s446ms 11s111ms 15 2 22s239ms 11s119ms 16 4 44s24ms 11s6ms [ User: intelifix - Total duration: 2m16s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m16s - Times executed: 12 ]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 09:44:39 Duration: 14s854ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 11:25:22 Duration: 11s381ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-18 16:11:21 Duration: 11s325ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 5s75ms 12s652ms 7s737ms 20 2m34s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 18 00 3 33s456ms 11s152ms 06 3 19s826ms 6s608ms 20 6 45s290ms 7s548ms 21 8 56s167ms 7s20ms [ User: intelifix - Total duration: 2m34s - Times executed: 20 ]
[ Application: psql - Total duration: 2m34s - Times executed: 20 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-18 00:05:14 Duration: 12s652ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-18 00:05:35 Duration: 10s994ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-18 21:51:00 Duration: 10s70ms Database: rio User: intelifix Remote: [local] Application: psql
13 158ms 40s660ms 6s284ms 39 4m5s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 18 07 2 1m2s 31s139ms 08 2 28s508ms 14s254ms 09 6 40s477ms 6s746ms 10 3 19s791ms 6s597ms 11 7 40s111ms 5s730ms 12 1 896ms 896ms 13 1 1s418ms 1s418ms 14 5 25s741ms 5s148ms 15 3 7s764ms 2s588ms 16 1 571ms 571ms 17 8 17s522ms 2s190ms [ User: intelifix - Total duration: 4m5s - Times executed: 39 ]
[ Application: psql - Total duration: 4m5s - Times executed: 39 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030044);
Date: 2026-09-18 07:45:21 Duration: 40s660ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030049);
Date: 2026-09-18 08:35:06 Duration: 28s51ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030043);
Date: 2026-09-18 07:15:06 Duration: 21s618ms Database: rio User: intelifix Remote: [local] Application: psql
14 152ms 1m13s 5s836ms 38 3m41s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 18 07 4 1m14s 18s528ms 08 3 3s410ms 1s136ms 09 4 54s91ms 13s522ms 10 4 1s65ms 266ms 11 10 5s766ms 576ms 12 1 3s655ms 3s655ms 13 1 4s23ms 4s23ms 14 6 46s147ms 7s691ms 15 2 370ms 185ms 16 3 29s160ms 9s720ms [ User: intelifix - Total duration: 3m41s - Times executed: 38 ]
[ Application: psql - Total duration: 3m41s - Times executed: 38 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030043);
Date: 2026-09-18 07:14:44 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030051);
Date: 2026-09-18 09:13:20 Duration: 53s115ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030072);
Date: 2026-09-18 14:07:34 Duration: 41s80ms Database: rio User: intelifix Remote: [local] Application: psql
15 2s728ms 21s630ms 3s682ms 62 3m48s create table temp0000291807 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 18 07 3 8s343ms 2s781ms 08 1 21s630ms 21s630ms 09 11 34s219ms 3s110ms 10 9 30s606ms 3s400ms 11 22 1m14s 3s400ms 14 8 30s344ms 3s793ms 15 8 28s347ms 3s543ms [ User: intelifix - Total duration: 3m48s - Times executed: 62 ]
[ Application: [unknown] - Total duration: 3m48s - Times executed: 62 ]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"13-09-2026", "ate" :"18-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-18 08:45:08 Duration: 21s630ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"13-09-2026", "ate" :"18-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-18 11:09:57 Duration: 4s381ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291807 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"13-09-2026", "ate" :"18-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-18 14:29:02 Duration: 3s909ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 160ms 27s865ms 3s273ms 160 8m43s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 18 00 6 48s891ms 8s148ms 01 6 20s469ms 3s411ms 02 6 21s695ms 3s615ms 03 5 19s61ms 3s812ms 04 6 18s988ms 3s164ms 05 5 29s939ms 5s987ms 07 10 32s868ms 3s286ms 08 11 40s450ms 3s677ms 09 12 46s910ms 3s909ms 10 12 34s101ms 2s841ms 11 12 52s331ms 4s360ms 12 10 17s662ms 1s766ms 13 8 7s332ms 916ms 14 11 29s986ms 2s726ms 15 12 32s843ms 2s736ms 16 8 9s386ms 1s173ms 17 3 3s535ms 1s178ms 20 7 2s75ms 296ms 21 4 26s644ms 6s661ms 22 6 28s659ms 4s776ms [ User: intelifix - Total duration: 8m43s - Times executed: 160 ]
[ Application: psql - Total duration: 8m43s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-18 00:05:29 Duration: 27s865ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-18 21:25:13 Duration: 11s899ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-18 22:15:11 Duration: 10s576ms Database: rio User: intelifix Remote: [local] Application: psql
17 153ms 30s651ms 2s235ms 147 5m28s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 18 00 7 19s624ms 2s803ms 01 6 8s930ms 1s488ms 02 6 8s964ms 1s494ms 03 6 10s136ms 1s689ms 04 6 9s74ms 1s512ms 05 6 8s810ms 1s468ms 06 6 9s332ms 1s555ms 07 7 14s156ms 2s22ms 08 6 10s103ms 1s683ms 09 7 12s785ms 1s826ms 10 6 10s919ms 1s819ms 11 8 13s314ms 1s664ms 12 6 10s20ms 1s670ms 13 6 10s378ms 1s729ms 14 6 39s791ms 6s631ms 15 6 10s161ms 1s693ms 16 7 11s237ms 1s605ms 17 6 9s861ms 1s643ms 18 6 9s714ms 1s619ms 19 6 9s659ms 1s609ms 20 8 43s38ms 5s379ms 21 7 28s443ms 4s63ms 22 6 10s143ms 1s690ms [ User: intelifix - Total duration: 5m28s - Times executed: 147 ]
[ Application: psql - Total duration: 5m28s - Times executed: 147 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-18 14:45:36 Duration: 30s651ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-18 20:25:17 Duration: 16s114ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-18 20:55:16 Duration: 15s75ms Database: rio User: intelifix Remote: [local] Application: psql
18 257ms 19s261ms 2s89ms 55 1m54s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 18 08 4 3s28ms 757ms 09 4 8s284ms 2s71ms 10 4 14s634ms 3s658ms 11 5 17s940ms 3s588ms 12 4 5s188ms 1s297ms 13 4 7s702ms 1s925ms 14 3 2s310ms 770ms 15 4 16s813ms 4s203ms 16 3 3s424ms 1s141ms 17 3 20s875ms 6s958ms 18 5 3s901ms 780ms 19 5 4s372ms 874ms 20 2 1s498ms 749ms 21 2 2s188ms 1s94ms 22 3 2s768ms 922ms [ User: intelifix - Total duration: 1m54s - Times executed: 55 ]
[ Application: psql - Total duration: 1m54s - Times executed: 55 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-18 17:40:21 Duration: 19s261ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-18 10:20:09 Duration: 8s368ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-18 11:00:09 Duration: 8s159ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 7s992ms 781ms 1,217 15m51s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 18 07 79 57s901ms 732ms 08 164 2m27s 898ms 09 183 3m1s 990ms 10 194 2m48s 867ms 11 173 2m16s 789ms 12 15 11s236ms 749ms 13 70 46s675ms 666ms 14 132 1m23s 631ms 15 140 1m26s 619ms 16 43 22s715ms 528ms 17 24 9s40ms 376ms [ User: intelifix - Total duration: 15m51s - Times executed: 1217 ]
[ Application: [unknown] - Total duration: 15m51s - Times executed: 1217 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (58206, 407, '836066910001284,241732104144,241662993651,241604293343,230048512647,241678346170,241609652744,241602087190,241676706066,241646321620,241607247278,241604981727,230048512041,241726923549,241631317899,241727092230,241659701018,241619569413,241714068602,241696975261,241656691016,241593318602,241636065669,241632343948,241607206365,230043524752,241593986175,241661489698,241614536183,241717131213,241698666784,241663061840,241659754760,241677634350,241622531330,230048510223,241632305156,241704334655,241608661525,241728540015,241698671028,241654884857,241617429406,241679131332,241676789509,241617452944,241708756478,241660129094,241621408099,241698682443,241664839409', '',0321,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":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-18 08:29:54 Duration: 7s992ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (288487, 404, '270911029504103338,229783452738,229781243353,229671769919,229667826885,229786832024,216945272330,229743763354,229836352435,216941817076,229734474759,216942010710,229689580513,229810799604,229661612744,229737315272,229670566883,229865251619,229746655465', '246586232223,246601126785,246494746167,246497649111,246598186969,246484013549,246538649700,246640591524,246482184560,246538718595,246471313241,246520641232,246640393446,246487128790,246528061114,246515186669,246649646885,246569516573,,,,,,,,,,,,,,,,,,,,,,', 0141, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-09-18 09:59:35 Duration: 7s879ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (58165, 407, '226400441229', '',0172,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":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-18 09:40:30 Duration: 3s794ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 151ms 2s334ms 716ms 82 58s719ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 18 07 16 11s488ms 718ms 08 1 859ms 859ms 09 6 5s803ms 967ms 10 15 13s178ms 878ms 11 5 2s167ms 433ms 13 10 7s136ms 713ms 14 16 10s75ms 629ms 15 3 2s212ms 737ms 16 5 2s849ms 569ms 17 5 2s947ms 589ms [ User: intelifix - Total duration: 58s719ms - Times executed: 82 ]
[ Application: [unknown] - Total duration: 58s719ms - Times executed: 82 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0288373) LIMIT 1;
Date: 2026-09-18 09:57:26 Duration: 2s334ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0288373) LIMIT 1;
Date: 2026-09-18 14:44:14 Duration: 2s101ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0288324) LIMIT 1;
Date: 2026-09-18 07:34:03 Duration: 1s954ms Database: rio 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 5 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 18 08 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 19 2 0ms 0ms [ User: intelifix - Total duration: 5m15s - Times executed: 5 ]
[ Application: psql - Total duration: 5m14s - Times executed: 3 ]
[ Application: [unknown] - Total duration: 1s153ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 17,383 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 72 FATAL entries
- 4304 ERROR entries
- 0 WARNING entries
- 12 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,259 Max number of times the same event was reported
- 4,388 Total events found
Rank Times reported Error 1 4,259 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 18 00 60 01 60 02 59 03 55 04 59 05 60 06 60 07 246 08 435 09 406 10 526 11 425 12 197 13 157 14 441 15 390 16 225 17 103 18 59 19 60 20 34 21 33 22 59 23 50 - ERROR: prepared statement "_PLAN0000000029BCF900" does not exist
- ERROR: prepared statement "_PLAN0000000029DE7B50" does not exist
- ERROR: prepared statement "_PLAN0000000029DEA460" does not exist
Statement: DEALLOCATE "_PLAN0000000029BCF900"
Date: 2026-09-18 00:00:07 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029DE7B50"
Date: 2026-09-18 00:01:08 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029DEA460"
Date: 2026-09-18 00:02:08 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 47 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 18 03 9 20 10 21 28 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-18 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-18 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-18 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
3 21 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 18 00 1 03 4 04 1 06 1 08 4 09 1 10 4 12 1 15 1 21 2 22 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-18 00:02:24 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-18 03:39:29 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-18 03:39:44 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
4 20 ERROR: permission denied for schema ...
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 18 10 20 - ERROR: permission denied for schema auditor at character 52
- ERROR: permission denied for schema auditor at character 15
- ERROR: permission denied for schema auditor at character 52
Statement: select reltuples::bigint n from pg_class where oid='"auditor"."auditor_2026_06"'::regclass
Date: 2026-09-18 10:26:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from "auditor"."auditor_2026_06" limit 3
Date: 2026-09-18 10:26:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select reltuples::bigint n from pg_class where oid='"auditor"."auditor_2026_07"'::regclass
Date: 2026-09-18 10:26:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
5 11 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 18 09 1 10 7 12 3 - ERROR: trailing junk after numeric literal at or near "24E4CE8D69F" at character 27
- ERROR: trailing junk after numeric literal at or near "9877E7C06BA5" at character 32
- ERROR: trailing junk after numeric literal at or near "9877E7C06BA5" at character 44
Statement: select * from rs_caixa_qr(24E4CE8D69F)
Date: 2026-09-18 09:27:28 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( ''9877E7C06BA5' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''9877E7C06BA5' )
Date: 2026-09-18 10:52:37 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 00, ''9877E7C06BA5' )
Date: 2026-09-18 10:52:37 Database: rio Application: [unknown] User: intelifix Remote: [local]
6 5 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 18 03 1 20 1 21 3 - LOG: database system was shut down at 2026-09-18 03:05:01 -03
- LOG: database system was shut down at 2026-09-18 20:15:11 -03
- LOG: database system was shut down at 2026-09-18 21:20:20 -03
Date: 2026-09-18 03:05:02
Date: 2026-09-18 20:21:29
Date: 2026-09-18 21:21:47
7 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 18 05 4 10 1 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-18 05:32:12 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-18 05:32:12 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-18 05:32:12 Database: contagem Application: psql User: intelifix Remote: [local]
8 4 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 18 03 3 20 1 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-18 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-18 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-18 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
9 4 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 18 10 2 11 2 - ERROR: syntax error at or near ")" at character 34
- ERROR: syntax error at or near ")" at character 34
- ERROR: syntax error at or near "[" at character 33
Statement: select * from rs_caixa_qr(400499,)
Date: 2026-09-18 10:52:11 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(400499,)
Date: 2026-09-18 10:52:11 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(138559[])
Date: 2026-09-18 11:56:18 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
10 2 LOG: database system was interrupted; last known up at ...
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 18 20 1 21 1 - LOG: database system was interrupted; last known up at 2026-09-18 20:27:59 -03
- LOG: database system was interrupted; last known up at 2026-09-18 21:21:47 -03
Date: 2026-09-18 20:50:54
Date: 2026-09-18 21:22:53
11 2 LOG: database system was not properly shut down; automatic recovery in progress
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 18 20 1 21 1 - LOG: database system was not properly shut down; automatic recovery in progress
- LOG: database system was not properly shut down; automatic recovery in progress
Date: 2026-09-18 20:50:56
Date: 2026-09-18 21:22:54
12 2 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 18 14 2 - LOG: process 1949727 still waiting for ShareLock on transaction 6326718 after 1000.090 ms
- LOG: process 1949727 still waiting for ShareLock on transaction 6326718 after 8777.417 ms
Detail: Process holding the lock: 1940846. Wait queue: 1949727.
Context: while updating tuple (80224,12) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-18 14:45:07 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1940846. Wait queue: 1949727.
Context: while updating tuple (80224,12) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-18 14:45:15 Database: rio Application: psql User: intelifix Remote: [local]
13 2 ERROR: spiexceptions.UndefinedColumn: record "..." has no field "..."
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 18 14 2 - ERROR: spiexceptions.UndefinedColumn: record "rec" has no field "row_num"
- ERROR: spiexceptions.UndefinedColumn: record "rec" has no field "row_num"
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/LEONARDA.txt'') ;' , '/var/www/html/tmp/temp_83.xlsx' )Date: 2026-09-18 14:36:23 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/LEONARDA.txt'') ;' , '/var/www/html/tmp/temp_83.xlsx' )Date: 2026-09-18 14:36:43 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
14 1 ERROR: permission denied for table ...
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 18 10 1 - ERROR: permission denied for table modelo_partes
Context: SQL statement "SELECT * FROM MODELO_PARTES WHERE MOD_ID = nModelo ORDER BY MP_ORDEM , MP_ID" PL/pgSQL function rs_modelo_partes(integer,boolean) line 42 at FOR over SELECT rows
Statement: select * from "public"."rs_modelos" limit 3Date: 2026-09-18 10:27:03 Database: rio Application: [unknown] User: etiquetas Remote: [local]
15 1 ERROR: trailing junk after parameter at or near "..."
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 18 15 1 - ERROR: trailing junk after parameter at or near "N_CAIXA" at character 27
Statement: select * from rs_caixa_qr($1N_CAIXA)
Date: 2026-09-18 15:48:46 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
16 1 ERROR: function rs_parametros(...) does not exist
Times Reported Most Frequent Error / Event #16
Day Hour Count Sep 18 12 1 - ERROR: function rs_parametros(character varying) does not exist at character 8
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select rs_parametros(par_nome) from parametrosDate: 2026-09-18 12:10:41 Database: rio Application: pgAdmin 4 - CONN:8542389 User: lenon Remote: 172.20.0.3
17 1 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #17
Day Hour Count Sep 18 21 1 - LOG: could not send data to client: Broken pipe
Context: SQL statement "UPDATE PROD_ESTOQUES SET PE_ENTRADAS = nEntradas , PE_SAIDAS = nSaidas , PE_AJUSTES = nAjustes WHERE OFI_ID = nOficina AND PRO_ID = nProd AND EST_DATA = dData" PL/pgSQL function rs_atualiza_estoque(integer,integer,date) line 42 at SQL statement PL/pgSQL function rs_atualiza_estoque_automatico() line 23 at assignment
Statement: CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO()Date: 2026-09-18 21:23:29 Database: contagem Application: psql User: intelifix Remote: [local]