pgBadger-
Global information
- Generated on Wed Sep 9 23:50:13 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 34,573 log entries in 11s
- Log start from 2026-09-09 00:00:47 to 2026-09-09 23:45:16
-
Overview
Global Stats
- 365 Number of unique normalized queries
- 4,983 Number of queries
- 7h32m28s Total query duration
- 2026-09-09 00:02:08 First query
- 2026-09-09 23:42:43 Last query
- 7 queries/s at 2026-09-09 14:32:50 Query peak
- 7h32m28s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h32m28s Execute total duration
- 2,701 Number of events
- 14 Number of unique normalized events
- 2,658 Max number of times the same event was reported
- 0 Number of cancellation
- 507 Total number of automatic vacuums
- 1,064 Total number of automatic analyzes
- 22 Number temporary file
- 244.90 MiB Max size of temporary file
- 63.87 MiB Average size of temporary file
- 341 Total number of sessions
- 8 sessions at 2026-09-09 01:05:02 Session peak
- 12d14h40m6s Total duration of sessions
- 53m15s Average duration of sessions
- 14 Average queries per session
- 1m19s Average queries duration per session
- 51m55s Average idle time per session
- 351 Total number of connections
- 5 connections/s at 2026-09-09 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 7 queries/s Query Peak
- 2026-09-09 14:32:50 Date
SELECT Traffic
Key values
- 7 queries/s Query Peak
- 2026-09-09 14:32:50 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-09 20:08:40 Date
Queries duration
Key values
- 7h32m28s 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 09 00 26 0ms 23s169ms 4s172ms 4s234ms 6s419ms 1m11s 01 17 0ms 3s291ms 1s831ms 5s700ms 5s822ms 5s822ms 02 15 0ms 4s565ms 2s310ms 6s611ms 7s27ms 7s27ms 03 13 0ms 4s446ms 2s179ms 7s86ms 7s86ms 7s86ms 04 19 0ms 4s319ms 1s864ms 6s965ms 6s965ms 6s965ms 05 20 0ms 9m28s 1m3s 2m41s 6m24s 9m28s 06 15 0ms 7s416ms 2s869ms 22s114ms 22s114ms 22s114ms 07 132 0ms 7m38s 13s265ms 49s421ms 4m15s 7m58s 08 556 0ms 5m38s 3s679ms 1m11s 3m51s 5m43s 09 625 151ms 6m40s 5s43ms 1m28s 6m16s 7m8s 10 486 150ms 5m45s 4s845ms 46s48ms 5m41s 6m4s 11 438 150ms 5m35s 4s500ms 47s793ms 5m36s 5m40s 12 180 0ms 5m28s 6s546ms 26s859ms 3m39s 5m50s 13 299 0ms 4m53s 2s658ms 10s617ms 44s296ms 4m53s 14 522 150ms 5m54s 3s915ms 49s715ms 5m44s 6m5s 15 442 153ms 5m35s 3s656ms 31s378ms 4m26s 5m55s 16 395 0ms 5m30s 5s539ms 1m42s 5m34s 5m53s 17 203 0ms 5m13s 5s43ms 33s217ms 2m20s 6m 18 62 0ms 4m46s 10s537ms 42s694ms 3m50s 4m46s 19 19 0ms 4m57s 30s512ms 3m37s 4m57s 4m57s 20 114 0ms 5m5s 9s976ms 1m14s 3m27s 6m50s 21 25 0ms 4m50s 22s574ms 3m21s 4m50s 4m50s 22 27 0ms 4m50s 21s956ms 3m36s 4m50s 4m50s 23 333 0ms 1m3s 5s855ms 1m10s 1m13s 1m15s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 09 00 6 0 1s979ms 0ms 0ms 856ms 01 2 0 336ms 0ms 0ms 673ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 5 0 304ms 660ms 689ms 689ms 05 2 0 363ms 0ms 0ms 726ms 06 3 0 2s687ms 0ms 8s63ms 8s63ms 07 67 0 22s431ms 3s135ms 32s482ms 6m10s 08 450 0 3s573ms 27s808ms 59s121ms 5m1s 09 457 0 4s860ms 16s673ms 58s3ms 6m13s 10 386 0 5s91ms 12s375ms 43s521ms 5m48s 11 339 0 4s834ms 14s730ms 36s544ms 5m37s 12 122 0 8s361ms 3s798ms 5s911ms 5m28s 13 243 0 3s6ms 5s813ms 7s686ms 3m39s 14 435 0 3s787ms 12s935ms 19s683ms 5m56s 15 359 0 3s530ms 6s738ms 26s195ms 5m37s 16 305 0 5s853ms 13s189ms 1m39s 5m40s 17 158 0 5s423ms 3s854ms 14s42ms 3m46s 18 31 0 20s18ms 3s582ms 42s694ms 4m46s 19 6 0 1m33s 44s394ms 3m37s 4m57s 20 12 84 11s518ms 1m3s 1m14s 5m53s 21 8 0 1m6s 827ms 3m21s 4m50s 22 6 0 1m31s 0ms 3m36s 4m50s 23 13 320 5s855ms 1m5s 1m10s 1m14s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 09 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 09 00 0 1 1.00 0.00% 01 0 1 1.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 1 1.00 0.00% 06 0 0 0.00 0.00% 07 0 7 7.00 0.00% 08 0 14 14.00 0.00% 09 0 14 14.00 0.00% 10 0 12 12.00 0.00% 11 0 10 10.00 0.00% 12 0 5 5.00 0.00% 13 0 9 9.00 0.00% 14 0 16 16.00 0.00% 15 0 8 8.00 0.00% 16 0 10 10.00 0.00% 17 0 6 6.00 0.00% 18 0 3 3.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Sep 09 00 18 0.01/s 01 9 0.00/s 02 8 0.00/s 03 14 0.00/s 04 6 0.00/s 05 9 0.00/s 06 12 0.00/s 07 15 0.00/s 08 26 0.01/s 09 20 0.01/s 10 21 0.01/s 11 21 0.01/s 12 12 0.00/s 13 22 0.01/s 14 29 0.01/s 15 19 0.01/s 16 20 0.01/s 17 18 0.01/s 18 10 0.00/s 19 8 0.00/s 20 9 0.00/s 21 10 0.00/s 22 7 0.00/s 23 8 0.00/s Day Hour Count Average Duration Average idle time Sep 09 00 5 50m 49m38s 01 16 1h1m6s 1h1m4s 02 9 1h40s 1h36s 03 14 27m42s 27m40s 04 5 1h36s 1h29s 05 6 1h30s 56m58s 06 8 57m17s 57m11s 07 10 55m36s 52m41s 08 19 46m38s 44m51s 09 22 59m29s 57m6s 10 20 57m38s 55m40s 11 21 57m4s 55m30s 12 21 56m1s 55m5s 13 12 55m11s 54m5s 14 25 48m27s 47m5s 15 26 52m27s 51m24s 16 17 56m7s 53m58s 17 21 53m43s 52m55s 18 15 56m47s 56m4s 19 10 1h2m17s 1h1m19s 20 11 44m45s 43m1s 21 7 52m51s 51m31s 22 8 1h36s 59m22s 23 13 34m49s 32m19s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-09-09 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 351 connections Total
Connections per user
Key values
- intelifix Main User
- 351 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-09-09 01:05:02 Date
Histogram of session times
Key values
- 272 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 341 sessions Total
Sessions per user
Key values
- intelifix Main User
- 341 sessions Total
Sessions per host
Key values
- [local] Main Host
- 341 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 20,946 buffers Checkpoint Peak
- 2026-09-09 08:39:37 Date
- 270.042 seconds Highest write time
- 0.096 seconds Sync time
Checkpoints Wal files
Key values
- 18 files Wal files usage Peak
- 2026-09-09 08:39:37 Date
Checkpoints distance
Key values
- 577.41 Mo Distance Peak
- 2026-09-09 08:39:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 09 00 34,034 659.313s 0.104s 659.441s 01 1,616 161.994s 0.148s 162.165s 02 1,859 186.36s 0.044s 186.429s 03 909 91.156s 0.091s 91.272s 04 2,126 213.115s 0.048s 213.186s 05 9,357 936.19s 0.132s 936.381s 06 3,484 269.203s 0.002s 269.219s 07 30,838 1,744.543s 0.196s 1,744.857s 08 88,912 3,027.703s 0.269s 3,028.075s 09 87,225 3,238.966s 0.477s 3,239.627s 10 77,070 3,239.193s 0.38s 3,239.755s 11 73,569 3,191.171s 0.313s 3,191.643s 12 35,057 2,526.007s 0.304s 2,526.449s 13 27,911 2,460.835s 0.248s 2,461.151s 14 73,723 3,239.149s 0.458s 3,239.712s 15 65,563 3,239.082s 0.455s 3,239.631s 16 46,689 3,188.101s 0.333s 3,188.626s 17 20,272 2,127.868s 0.178s 2,128.114s 18 12,088 410.831s 0.014s 410.949s 19 35 3.528s 0.006s 3.546s 20 2,102 349.352s 0.003s 349.365s 21 2,638 264.613s 0.106s 264.804s 22 3,368 337.319s 0.047s 337.515s 23 292 31.997s 0.074s 32.092s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 09 00 0 0 8 577 0.062s 0.007s 01 0 0 0 434 0.061s 0.006s 02 0 0 1 452 0.009s 0.006s 03 0 0 0 268 0.026s 0.005s 04 0 0 1 450 0.015s 0.006s 05 0 0 4 599 0.050s 0.013s 06 0 0 0 10 0.001s 0.001s 07 0 0 17 2,253 0.062s 0.01s 08 0 0 57 6,901 0.049s 0.012s 09 0 0 87 8,658 0.034s 0.012s 10 0 0 60 7,690 0.034s 0.012s 11 0 0 46 7,022 0.063s 0.012s 12 0 0 20 3,819 0.082s 0.012s 13 0 0 10 4,973 0.059s 0.012s 14 0 0 48 7,433 0.062s 0.012s 15 0 0 38 7,197 0.061s 0.012s 16 0 0 47 6,634 0.062s 0.012s 17 0 0 23 4,724 0.062s 0.012s 18 0 0 7 420 0.003s 0.005s 19 0 0 0 10 0.002s 0.004s 20 0 0 2 69 0.002s 0.002s 21 0 0 1 391 0.062s 0.006s 22 0 0 1 521 0.014s 0.007s 23 0 0 0 34 0.065s 0.016s Day Hour Count Avg time (sec) Sep 09 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 09 00 18,201.14 kB 50,526.29 kB 01 1,336.17 kB 26,701.50 kB 02 1,600.33 kB 14,882.17 kB 03 859.67 kB 2,844.33 kB 04 1,991.83 kB 2,365.83 kB 05 7,427.44 kB 14,202.22 kB 06 6,874.00 kB 12,358.00 kB 07 27,467.70 kB 57,793.90 kB 08 77,185.58 kB 149,024.58 kB 09 118,730.92 kB 176,354.58 kB 10 82,909.33 kB 161,289.08 kB 11 62,296.50 kB 125,651.50 kB 12 27,173.42 kB 82,498.67 kB 13 13,837.50 kB 33,508.83 kB 14 65,347.17 kB 90,189.92 kB 15 51,901.42 kB 169,923.83 kB 16 64,635.08 kB 121,034.75 kB 17 30,514.33 kB 106,267.25 kB 18 23,809.00 kB 73,136.20 kB 19 74.67 kB 80,934.33 kB 20 16,751.50 kB 65,020.00 kB 21 2,658.80 kB 46,264.20 kB 22 2,612.71 kB 26,063.29 kB 23 208.00 kB 14,360.40 kB -
Temporary Files
Size of temporary files
Key values
- 489.80 MiB Temp Files size Peak
- 2026-09-09 05:31:53 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-09 05:32:00 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 09 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.30 GiB 66.66 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 1 36.00 MiB 36.00 MiB 17 1 36.00 MiB 36.00 MiB 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.00 GiB 36.52 MiB 244.90 MiB 64.27 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-09 05:32:01 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-09 05:31:53 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 304.80 MiB 56.66 MiB 93.23 MiB 76.20 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-09 05:30:40 Duration: 37s566ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-09 05:30:36 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 72.00 MiB 36.00 MiB 36.00 MiB 36.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029609, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-09 09:03:30 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029602, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-09 07:28:56 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029654, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-09 14:36:05 Duration: 5m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 244.90 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-09 05:31:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 244.90 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-09 05:31:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 93.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-09 05:30:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 93.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-09 05:30:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 61.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-09 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 56.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-09 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.46 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-09 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-09 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-09 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-09 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-09 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.37 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-09 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.37 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-09 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 36.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-09 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.54 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-09 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-09 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-09 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-09 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-09 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-09 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 9.56 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-09 12:24:48 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 9.56 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-09 12:24:48 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (126) Main table analyzed (database rio)
- 1,064 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 126 rio.public.temp0000290887 75 rio.pg_catalog.pg_class 64 rio.pg_catalog.pg_type 55 rio.public.usuarios 48 contagem.pg_catalog.pg_attribute 47 brasilia.pg_catalog.pg_attribute 47 rio.pg_catalog.pg_index 33 contagem.public.usuarios 30 rio.public.temp0000290929 30 contagem.pg_catalog.pg_class 30 brasilia.pg_catalog.pg_class 25 rio.pg_catalog.pg_depend 25 contagem.pg_catalog.pg_type 24 rio.public.temp0000290965 21 brasilia.pg_catalog.pg_type 21 rio.public.temp0000290885 21 rio.public.temp0000290899 16 contagem.pg_catalog.pg_index 15 brasilia.pg_catalog.pg_index 15 rio.public.temp0000290769 15 brasilia.public.temp0000239772 14 rio.public.temp0000290026 14 rio.public.temp0000290997 13 brasilia.public.temp0000239780 13 rio.public.temp0000290881 13 brasilia.public.temp0000239768 13 rio.public.temp0000290230 12 rio.public.temp0000290953 11 brasilia.pg_catalog.pg_depend 11 contagem.pg_catalog.pg_depend 11 contagem.public.temp0000227077 9 brasilia.public.temp0000239784 8 rio.public.temp0000290985 8 brasilia.public.usuarios 7 contagem.public.temp0000227079 7 rio.public.temp0000290883 6 rio.public.temp0000290907 5 brasilia.public.nf_entrada 5 rio.public.temp0000290893 4 postgres.pg_catalog.pg_shdepend 4 brasilia.pg_catalog.pg_shdepend 4 rio.public.temp0000290923 4 rio.public.temp0000290943 4 rio.public.temp0000290957 3 rio.public.temp0000290993 3 rio.public.temp0000290787 3 contagem.pg_catalog.pg_shdepend 3 brasilia.public.temp0000239812 3 rio.public.temp0000290897 3 brasilia.public.temp0000239852 3 rio.pg_catalog.pg_shdepend 3 rio.public.tmp_drill_0175 3 rio.public.tmp_drill_0302 3 brasilia.public.temp0000239818 3 brasilia.public.temp0000239856 3 brasilia.public.temp0000239830 3 brasilia.public.temp0000239792 2 brasilia.public.temp0000239838 2 brasilia.public.temp0000239832 2 contagem.public.nf_entrada 2 brasilia.public.temp0000239806 2 rio.public.temp0000290913 2 rio.public.temp0000290895 2 rio.public.temp0000290226 2 contagem.public.temp0000227085 2 rio.auditor.auditor_2026_09 2 rio.public.temp0000290939 2 rio.public.temp0000290925 2 rio.public.temp0000290995 1 rio.public.temp0000290945 1 brasilia.public.temp0000239774 1 contagem.auditor.auditor_2026_09 1 brasilia.public.temp0000239786 1 brasilia.public.temp0000239848 1 brasilia.public.temp0000239798 1 brasilia.public.temp0000239814 1 brasilia.auditor.auditor_2026_09 1 contagem.public.temp0000227091 1 contagem.public.parametros 1 rio.public.temp0000290911 1 brasilia.public.temp0000239820 1 rio.public.temp0000290915 1 rio.public.temp0000290917 1 rio.public.temp0000290949 1 brasilia.public.temp0000239802 1 brasilia.public.temp0000239790 1 Total 1,064 Vacuums per table
Key values
- public.temp0000290887 (75) Main table vacuumed on database rio
- 507 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.temp0000290887 75 0 0 0 0 0 0 60,791 4,039 8,501,042 0 0 rio.pg_catalog.pg_attribute 41 40 0 0 0 0 0 21,509 5,678 8,500,950 296 7,401 contagem.public.usuarios 30 0 0 0 0 0 0 164 126 58,849 0 0 rio.pg_catalog.pg_class 23 22 0 0 0 0 0 4,593 1,637 2,291,544 93 362 rio.public.temp0000290929 21 0 0 0 0 0 0 9,631 106 585,548 0 0 rio.pg_catalog.pg_type 20 19 0 0 0 0 0 1,672 543 735,117 65 213 contagem.pg_catalog.pg_attribute 17 17 0 0 0 0 0 9,550 2,242 4,179,980 21 539 brasilia.pg_catalog.pg_attribute 17 16 0 0 0 0 0 8,930 2,026 3,579,661 78 2,300 rio.public.temp0000290899 15 0 0 0 0 0 0 17,865 1,836 3,363,850 0 0 rio.public.temp0000290769 15 0 0 0 0 0 0 958 117 123,267 0 0 rio.public.temp0000290026 13 0 0 0 0 0 0 601 146 169,576 0 0 rio.public.temp0000290881 13 0 0 0 0 0 0 10,749 46 642,897 0 0 rio.pg_catalog.pg_index 12 12 0 0 0 0 0 799 247 252,631 34 76 rio.public.temp0000290230 10 0 0 0 0 0 0 532 179 251,077 0 0 brasilia.pg_catalog.pg_class 10 9 0 0 0 0 0 1,965 507 871,711 26 100 brasilia.pg_catalog.pg_type 10 9 0 0 0 0 0 857 193 327,381 21 66 rio.pg_catalog.pg_depend 10 10 0 0 0 0 0 3,238 1,301 1,751,690 56 519 rio.public.temp0000290997 8 0 0 0 0 0 0 4,274 229 595,821 0 0 contagem.pg_catalog.pg_type 8 8 0 0 0 0 0 859 228 364,972 6 14 contagem.pg_catalog.pg_class 8 8 0 0 0 0 0 1,708 373 601,748 6 19 rio.public.temp0000290985 8 0 0 0 0 0 0 10,736 30 638,118 0 0 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 9,286 1,854 8,499,353 843 3,912 rio.public.tmp_drill_0175 7 2 0 0 0 0 0 59 8 12,981 0 0 brasilia.pg_catalog.pg_index 6 6 0 0 0 0 0 265 69 73,151 10 24 rio.public.usuarios 6 4 0 0 0 0 0 126 43 87,294 10 14 brasilia.pg_catalog.pg_depend 5 4 0 0 0 0 0 1,269 294 504,976 17 147 contagem.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,475 378 857,132 6 36 contagem.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 779 232 418,856 37 75 rio.public.temp0000290965 5 0 0 0 0 0 0 387 29 27,315 0 0 contagem.pg_catalog.pg_index 5 5 0 0 0 0 0 235 64 74,787 2 3 brasilia.public.temp0000239784 5 0 0 0 0 0 0 1,255 20 77,060 0 0 rio.public.temp0000290907 5 0 0 0 0 0 0 244 29 18,529 0 0 rio.public.temp0000290943 5 0 0 0 0 0 0 7,146 19 424,564 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,165 473 2,654,205 133 438 brasilia.pg_catalog.pg_statistic 4 4 0 0 0 0 0 5,038 1,726 6,309,837 1,277 7,409 rio.public.tmp_drill_0302 3 3 0 0 0 0 0 87 22 37,648 0 0 brasilia.public.temp0000239818 3 0 0 0 0 0 0 753 12 46,236 0 0 brasilia.public.temp0000239856 3 0 0 0 0 0 0 507 11 31,657 0 0 brasilia.public.temp0000239830 3 0 0 0 0 0 0 754 260 433,856 0 0 postgres.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 377 121 195,567 9 15 brasilia.public.temp0000239838 2 0 0 0 0 0 0 502 8 30,824 0 0 rio.public.temp0000290993 2 0 0 0 0 0 0 1,792 7 106,869 0 0 rio.public.temp0000290787 2 0 0 0 0 0 0 131 61 93,486 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 334 97 447,487 32 89 contagem.public.temp0000227085 2 0 0 0 0 0 0 122 11 9,058 0 0 rio.auditor.auditor_2026_09 2 0 0 0 0 0 0 114,070 43,204 60,457,790 33,086 703,620 rio.public.temp0000290939 2 0 0 0 0 0 0 3,570 8 211,836 0 0 brasilia.public.temp0000239852 2 0 0 0 0 0 0 256 7 16,245 0 0 brasilia.public.nf_entrada 2 1 0 0 0 0 0 163 81 179,306 4 5 brasilia.auditor.auditor_2026_09 1 0 0 0 0 0 0 17,266 7,371 10,503,115 4,876 104,368 rio.public.temp0000290957 1 0 0 0 0 0 0 67 68 128,353 0 0 contagem.public.temp0000227091 1 0 0 0 0 0 0 114 6 7,696 0 0 rio.public.temp0000290953 1 0 0 0 0 0 0 66 4 4,497 0 0 brasilia.public.temp0000239774 1 0 0 0 0 0 0 251 4 15,412 0 0 contagem.auditor.auditor_2026_09 1 0 0 0 0 0 0 9,022 7,982 9,553,924 0 0 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 684 646 2,027,749 12 504 rio.public.temp0000290893 1 0 0 0 0 0 0 80 6 5,601 0 0 contagem.public.fluxos 1 1 0 0 0 0 0 8,628 5,650 15,631,072 455 21,108 brasilia.public.temp0000239820 1 0 0 0 0 0 0 251 252 402,429 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 133 2 10,385 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,221 3 155,330 0 0 brasilia.public.temp0000239802 1 0 0 0 0 0 0 251 4 15,412 0 0 rio.public.temp0000290949 1 0 0 0 0 0 0 1,787 4 106,036 0 0 rio.public.temp0000290913 1 0 0 0 0 0 0 64 6 4,642 0 0 rio.public.temp0000290897 1 0 0 0 0 0 0 63 6 4,579 0 0 rio.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 152 36 81,970 3 3 Total 507 228 0 0 0 0 0 366,228 93,027 159,383,537 41,514 853,379 Vacuum throughput per table
Key values
- auditor.auditor_2026_09 (14.65) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000290887 0 0 1.5 rio.pg_catalog.pg_attribute 0 0 2.81 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_class 0 0 1.07 rio.public.temp0000290929 0 0 0.31 rio.pg_catalog.pg_type 0 0 0.26 contagem.pg_catalog.pg_attribute 0 0 1.31 brasilia.pg_catalog.pg_attribute 0 0 1.18 rio.public.temp0000290899 0 0 0.64 rio.public.temp0000290769 0 0 0.01 rio.public.temp0000290026 0 0 0.03 rio.public.temp0000290881 0 0 0.51 rio.pg_catalog.pg_index 0 0 0.27 rio.public.temp0000290230 0 0 0.02 brasilia.pg_catalog.pg_class 0 0 0.78 brasilia.pg_catalog.pg_type 0 0 0.24 rio.pg_catalog.pg_depend 0 0 0.73 rio.public.temp0000290997 0 0 0.12 contagem.pg_catalog.pg_type 0 0 0.17 contagem.pg_catalog.pg_class 0 0 0.26 rio.public.temp0000290985 0 0 0.33 rio.pg_catalog.pg_statistic 0 0 1.18 rio.public.tmp_drill_0175 0 0 0 brasilia.pg_catalog.pg_index 0 0 0.2 rio.public.usuarios 0 0 0.04 brasilia.pg_catalog.pg_depend 0 0 0.46 contagem.pg_catalog.pg_depend 0 0 0.33 contagem.pg_catalog.pg_shdepend 0 0 0.37 rio.public.temp0000290965 0 0 0.02 contagem.pg_catalog.pg_index 0 0 0.06 brasilia.public.temp0000239784 0 0 0 rio.public.temp0000290907 0 0 0 rio.public.temp0000290943 0 0 0.22 rio.pg_toast.pg_toast_2619 0 0 0.34 brasilia.pg_catalog.pg_statistic 0 0 0.56 rio.public.tmp_drill_0302 0 0 0 brasilia.public.temp0000239818 0 0 0 brasilia.public.temp0000239856 0 0 0 brasilia.public.temp0000239830 0 0 0.01 postgres.pg_catalog.pg_shdepend 0 0 0.34 brasilia.public.temp0000239838 0 0 0 rio.public.temp0000290993 0 0 0.08 rio.public.temp0000290787 0 0 0.01 brasilia.pg_toast.pg_toast_2619 0 0 0.01 contagem.public.temp0000227085 0 0 0.01 rio.auditor.auditor_2026_09 0 0 14.65 rio.public.temp0000290939 0 0 0.09 brasilia.public.temp0000239852 0 0 0 brasilia.public.nf_entrada 0 0 0.12 brasilia.auditor.auditor_2026_09 0 0 3.14 rio.public.temp0000290957 0 0 0 contagem.public.temp0000227091 0 0 0 rio.public.temp0000290953 0 0 0 brasilia.public.temp0000239774 0 0 0 contagem.auditor.auditor_2026_09 0 0 1.53 brasilia.public.nf_entrada_arquivo_erros 0 0 0.44 rio.public.temp0000290893 0 0 0 contagem.public.fluxos 0 0 4.14 brasilia.public.temp0000239820 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.03 brasilia.public.temp0000239802 0 0 0 rio.public.temp0000290949 0 0 0.05 rio.public.temp0000290913 0 0 0 rio.public.temp0000290897 0 0 0 rio.pg_catalog.pg_shdepend 0 0 0.01 Total 0 0 40.99 Tuples removed per table
Key values
- pg_catalog.pg_attribute (148367) Main table with removed tuples on database rio
- 382709 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 41 40 148,367 984,362 21,103 120 24,075 brasilia.pg_catalog.pg_attribute 17 16 81,809 392,565 21,269 318 9,931 contagem.pg_catalog.pg_attribute 17 17 65,771 406,945 68 212 9,114 rio.pg_catalog.pg_statistic 7 7 12,845 57,693 0 0 9,002 rio.pg_catalog.pg_depend 10 10 8,536 192,224 2,313 0 1,870 brasilia.pg_catalog.pg_statistic 4 4 7,008 32,090 0 0 4,288 contagem.public.fluxos 1 1 5,312 491,451 0 0 6,135 rio.pg_catalog.pg_type 20 19 5,177 46,696 1,244 0 1,457 brasilia.pg_catalog.pg_depend 5 4 4,657 96,514 6,711 12 909 contagem.pg_catalog.pg_shdepend 5 5 4,547 68,231 334 0 625 contagem.pg_catalog.pg_statistic 1 1 4,226 7,274 0 0 1,011 rio.pg_catalog.pg_class 23 22 3,463 84,083 2,852 50 2,758 contagem.pg_catalog.pg_class 8 8 3,421 29,977 8 42 1,149 brasilia.pg_catalog.pg_type 10 9 3,159 24,298 2,068 38 724 contagem.pg_catalog.pg_type 8 8 3,048 18,000 4 43 530 rio.auditor.auditor_2026_09 2 0 2,560 11,829,998 0 0 521,756 rio.pg_catalog.pg_index 12 12 2,477 23,019 60 15 646 brasilia.pg_catalog.pg_class 10 9 2,450 42,119 5,149 97 1,322 contagem.public.usuarios 30 0 1,899 720 0 0 60 brasilia.pg_catalog.pg_index 6 6 1,772 12,059 731 3 326 contagem.pg_catalog.pg_depend 5 5 1,736 95,099 12 16 863 postgres.pg_catalog.pg_shdepend 2 2 1,525 27,479 374 0 250 rio.pg_catalog.pg_shdepend 1 1 1,396 13,612 0 0 125 brasilia.public.nf_entrada_arquivo_erros 1 0 1,282 1,720,406 0 0 31,324 rio.pg_toast.pg_toast_2619 4 4 1,185 2,998 0 0 1,076 contagem.pg_catalog.pg_index 5 5 1,132 9,486 2 12 253 brasilia.auditor.auditor_2026_09 1 0 902 1,380,593 0 0 59,888 rio.public.usuarios 6 4 493 3,502 448 0 114 brasilia.pg_toast.pg_toast_2619 2 2 193 278 4 0 132 rio.public.tmp_drill_0175 7 2 192 6,586 3,060 0 94 contagem.pg_toast.pg_toast_2619 1 1 117 118 0 0 57 brasilia.public.nf_entrada 2 1 52 12,819 3,385 0 304 rio.public.temp0000290230 10 0 0 32,275 0 230 730 rio.public.temp0000290957 1 0 0 1,148 0 0 64 contagem.public.temp0000227091 1 0 0 1,366 0 22 106 rio.public.temp0000290929 21 0 0 197,846 0 244 13,196 rio.public.temp0000290953 1 0 0 2,775 0 0 64 brasilia.public.temp0000239774 1 0 0 3,297 0 0 256 rio.public.tmp_drill_0302 3 3 0 886 0 0 25 contagem.auditor.auditor_2026_09 1 0 0 1,043,236 0 0 48,271 brasilia.public.temp0000239838 2 0 0 6,594 0 0 512 rio.public.temp0000290993 2 0 0 50,543 0 0 3,584 rio.public.temp0000290893 1 0 0 3,205 0 56 72 rio.public.temp0000290997 8 0 0 77,178 0 118 4,234 rio.public.temp0000290787 2 0 0 5,128 0 77 115 brasilia.public.temp0000239820 1 0 0 3,297 0 0 256 rio.public.temp0000290026 13 0 0 30,723 0 401 687 brasilia.public.temp0000239818 3 0 0 9,891 0 0 768 rio.public.temp0000290881 13 0 0 304,228 0 0 21,568 contagem.public.temp0000227085 2 0 0 2,730 0 44 212 rio.public.temp0000290965 5 0 0 19,628 0 196 444 rio.public.temp0000290899 15 0 0 378,347 0 0 26,880 brasilia.public.temp0000239856 3 0 0 9,900 0 0 768 brasilia.public.temp0000239802 1 0 0 3,297 0 0 256 rio.public.temp0000290949 1 0 0 25,257 0 0 1,792 brasilia.public.temp0000239784 5 0 0 16,485 0 0 1,280 rio.public.temp0000290939 2 0 0 50,457 0 0 3,584 rio.public.temp0000290913 1 0 0 1,013 0 8 56 brasilia.public.temp0000239852 2 0 0 6,598 0 0 512 brasilia.public.temp0000239830 3 0 0 9,891 0 0 768 rio.public.temp0000290907 5 0 0 11,235 0 71 249 rio.public.temp0000290897 1 0 0 2,493 0 9 55 rio.public.temp0000290887 75 0 0 905,097 0 1,412 63,548 rio.public.temp0000290769 15 0 0 46,587 0 359 1,049 rio.public.temp0000290985 8 0 0 202,163 0 0 14,336 rio.public.temp0000290943 5 0 0 126,200 0 0 8,960 Total 507 228 382,709 21,704,288 71,199 4,225 911,425 Pages removed per table
Key values
- public.temp0000290887 (1412) Main table with removed pages on database rio
- 4225 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000290887 75 0 0 1412 rio.public.temp0000290026 13 0 0 401 rio.public.temp0000290769 15 0 0 359 brasilia.pg_catalog.pg_attribute 17 16 81809 318 rio.public.temp0000290929 21 0 0 244 rio.public.temp0000290230 10 0 0 230 contagem.pg_catalog.pg_attribute 17 17 65771 212 rio.public.temp0000290965 5 0 0 196 rio.pg_catalog.pg_attribute 41 40 148367 120 rio.public.temp0000290997 8 0 0 118 brasilia.pg_catalog.pg_class 10 9 2450 97 rio.public.temp0000290787 2 0 0 77 rio.public.temp0000290907 5 0 0 71 rio.public.temp0000290893 1 0 0 56 rio.pg_catalog.pg_class 23 22 3463 50 contagem.public.temp0000227085 2 0 0 44 contagem.pg_catalog.pg_type 8 8 3048 43 contagem.pg_catalog.pg_class 8 8 3421 42 brasilia.pg_catalog.pg_type 10 9 3159 38 contagem.public.temp0000227091 1 0 0 22 contagem.pg_catalog.pg_depend 5 5 1736 16 rio.pg_catalog.pg_index 12 12 2477 15 brasilia.pg_catalog.pg_depend 5 4 4657 12 contagem.pg_catalog.pg_index 5 5 1132 12 rio.public.temp0000290897 1 0 0 9 rio.public.temp0000290913 1 0 0 8 brasilia.pg_catalog.pg_index 6 6 1772 3 brasilia.auditor.auditor_2026_09 1 0 902 0 rio.public.temp0000290957 1 0 0 0 rio.pg_catalog.pg_type 20 19 5177 0 rio.pg_toast.pg_toast_2619 4 4 1185 0 rio.public.temp0000290953 1 0 0 0 brasilia.public.temp0000239774 1 0 0 0 rio.public.tmp_drill_0302 3 3 0 0 contagem.public.usuarios 30 0 1899 0 contagem.auditor.auditor_2026_09 1 0 0 0 postgres.pg_catalog.pg_shdepend 2 2 1525 0 brasilia.public.nf_entrada_arquivo_erros 1 0 1282 0 brasilia.public.temp0000239838 2 0 0 0 rio.public.temp0000290993 2 0 0 0 contagem.public.fluxos 1 1 5312 0 brasilia.public.temp0000239820 1 0 0 0 brasilia.public.temp0000239818 3 0 0 0 contagem.pg_catalog.pg_shdepend 5 5 4547 0 brasilia.pg_toast.pg_toast_2619 2 2 193 0 brasilia.pg_catalog.pg_statistic 4 4 7008 0 rio.public.temp0000290881 13 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 117 0 rio.public.temp0000290899 15 0 0 0 brasilia.public.temp0000239856 3 0 0 0 rio.auditor.auditor_2026_09 2 0 2560 0 contagem.pg_catalog.pg_statistic 1 1 4226 0 rio.public.usuarios 6 4 493 0 brasilia.public.temp0000239802 1 0 0 0 rio.public.temp0000290949 1 0 0 0 brasilia.public.temp0000239784 5 0 0 0 rio.public.temp0000290939 2 0 0 0 brasilia.public.temp0000239852 2 0 0 0 brasilia.public.temp0000239830 3 0 0 0 brasilia.public.nf_entrada 2 1 52 0 rio.pg_catalog.pg_statistic 7 7 12845 0 rio.public.temp0000290985 8 0 0 0 rio.public.temp0000290943 5 0 0 0 rio.public.tmp_drill_0175 7 2 192 0 rio.pg_catalog.pg_depend 10 10 8536 0 rio.pg_catalog.pg_shdepend 1 1 1396 0 Total 507 228 382,709 4,225 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 09 00 1 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 7 20 08 58 132 09 105 199 10 64 132 11 50 112 12 21 40 13 26 56 14 41 106 15 37 77 16 38 100 17 23 54 18 26 32 19 0 0 20 0 0 21 4 3 22 0 1 23 0 0 - 9.56 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1s2ms 1s2ms 1s2ms 1s2ms drop table if exists temp0000290887;-
DROP TABLE IF EXISTS temp0000290887;
Date: 2026-09-09 16:13:14 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000290887;
Date: 2026-09-09 08:54:38 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000290887;
Date: 2026-09-09 12:39:40 Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1 1s 1s 1s 1s drop table if exists temp0000290943;-
DROP TABLE IF EXISTS temp0000290943;
Date: 2026-09-09 09:45:38 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000290943;
Date: 2026-09-09 09:45:38 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1s2ms DROP TABLE IF EXISTS temp0000290887;[ Date: 2026-09-09 16:13:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1s DROP TABLE IF EXISTS temp0000290943;[ Date: 2026-09-09 09:45:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,415 Total read queries
- 1,086 Total write queries
Queries by database
Key values
- rio Main database
- 3,107 Requests
- 5h46m15s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 4,858 Requests
User Request type Count Duration etiquetas Total 15 3s409ms select 15 3s409ms intelifix Total 4,858 7h31m32s copy to 404 41m30s ddl 682 53m others 482 39m40s select 3,290 5h17m21s lenon Total 110 53s7ms select 110 53s7ms Duration by user
Key values
- 7h31m32s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 15 3s409ms select 15 3s409ms intelifix Total 4,858 7h31m32s copy to 404 41m30s ddl 682 53m others 482 39m40s select 3,290 5h17m21s lenon Total 110 53s7ms select 110 53s7ms Queries by host
Key values
- [local] Main host
- 4,983 Requests
- 7h32m28s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,855 Requests
- 3h29m22s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-09 21:35:02 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,330 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m28s analyze verbose;[ Date: 2026-09-09 05:09:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-09 07:12:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 6m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-09 09:11:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m19s analyze verbose;[ Date: 2026-09-09 05:15:49 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
5 6m12s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029609, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-09 09:03:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 6m10s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029602, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-09 07:28:56 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 5m54s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029654, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-09 14:36:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 5m45s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029641, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-09 10:20:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 5m40s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029626, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-09 09:45:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m40s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029657, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-09 14:57:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 5m38s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029606, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;[ Date: 2026-09-09 08:40:01 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 5m38s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029613, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-09 09:25:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m38s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029637, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-09 10:03:32 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m35s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029663, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-09 15:27:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m35s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029650, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-09 11:58:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 5m34s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029645, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-09 10:48:50 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-09 11:10:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m31s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029648, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-09 11:22:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m30s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029666, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-09 16:02:55 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m28s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029651, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-09 12:23:55 - 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 1h45m53s 290 150ms 6m12s 21s908ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 09 07 5 10m27s 2m5s 08 68 2m17s 2s23ms 09 32 19m11s 35s987ms 10 20 17m31s 52s572ms 11 23 12m12s 31s849ms 12 14 5m59s 25s669ms 13 20 17s584ms 879ms 14 31 12m35s 24s366ms 15 21 6m21s 18s148ms 16 33 15m56s 28s995ms 17 19 2m49s 8s915ms 18 4 13s311ms 3s327ms [ User: intelifix - Total duration: 1h45m53s - Times executed: 290 ]
[ Application: [unknown] - Total duration: 1h45m53s - Times executed: 290 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029609, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-09 09:03:30 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029602, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-09 07:28:56 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029654, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-09 14:36:05 Duration: 5m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h30m42s 48 1s393ms 7m38s 1m53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 09 07 3 8m15s 2m45s 08 3 5m17s 1m45s 09 3 7m3s 2m21s 10 3 5m35s 1m51s 11 3 5m52s 1m57s 12 3 5m20s 1m46s 13 3 5m9s 1m43s 14 3 5m29s 1m49s 15 3 5m42s 1m54s 16 3 5m36s 1m52s 17 3 5m29s 1m49s 18 3 5m1s 1m40s 19 3 5m13s 1m44s 20 3 5m22s 1m47s 21 3 5m6s 1m42s 22 3 5m6s 1m42s [ User: intelifix - Total duration: 1h30m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h30m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-09 07:12:39 Duration: 7m38s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-09 09:11:42 Duration: 6m40s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-09 11:10:35 Duration: 5m34s Database: rio User: intelifix Remote: [local] Application: psql
3 1h7m58s 48 295ms 4m1s 1m24s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 09 07 3 5m14s 1m44s 08 3 4m12s 1m24s 09 3 4m31s 1m30s 10 3 4m18s 1m26s 11 3 4m29s 1m29s 12 3 4m8s 1m22s 13 3 4m6s 1m22s 14 3 4m11s 1m23s 15 3 4m21s 1m27s 16 3 4m13s 1m24s 17 3 4m9s 1m23s 18 3 4m5s 1m21s 19 3 4m6s 1m22s 20 3 3m57s 1m19s 21 3 3m47s 1m15s 22 3 4m3s 1m21s [ User: intelifix - Total duration: 1h7m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-09 07:18:22 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-09 09:16:31 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-09 11:15:20 Duration: 3m54s Database: brasilia User: intelifix Remote: [local] Application: psql
4 18m29s 3 2m41s 9m28s 6m9s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 09 05 3 18m29s 6m9s [ User: intelifix - Total duration: 18m29s - Times executed: 3 ]
[ Application: psql - Total duration: 18m29s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-09 05:09:29 Duration: 9m28s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-09 05:15:49 Duration: 6m19s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-09 05:18:31 Duration: 2m41s Database: contagem User: intelifix Remote: [local] Application: psql
5 16m49s 89 10s319ms 18s623ms 11s346ms create table temp0000290887 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 09 07 4 43s135ms 10s783ms 08 12 2m17s 11s494ms 09 7 1m17s 11s94ms 10 10 1m52s 11s243ms 11 14 2m46s 11s876ms 12 5 55s919ms 11s183ms 14 12 2m16s 11s412ms 15 10 1m50s 11s59ms 16 15 2m48s 11s263ms [ User: intelifix - Total duration: 16m49s - Times executed: 89 ]
[ Application: [unknown] - Total duration: 16m49s - Times executed: 89 ]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 11:50:20 Duration: 18s623ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 11:14:59 Duration: 14s855ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 08:56:21 Duration: 12s385ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 16m3s 1,284 150ms 6s851ms 750ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 09 07 1 216ms 216ms 08 93 54s771ms 588ms 09 168 1m56s 692ms 10 162 2m11s 808ms 11 126 1m38s 780ms 12 54 34s747ms 643ms 13 104 1m21s 780ms 14 201 2m37s 782ms 15 177 2m30s 849ms 16 127 1m42s 805ms 17 71 36s503ms 514ms [ User: intelifix - Total duration: 16m3s - Times executed: 1284 ]
[ Application: [unknown] - Total duration: 16m3s - Times executed: 1284 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (285719, 433, '921171213335,38A65921E2C8,345D9EB3D68F,582FF716C1C5,CC5830E311E7,C4EB42A2BB22,94988F93E039,841EA38CA079,C4EB42A29DC4,C4EB42EA7BFC,44D454C22EC8,44D45460E413,506F0C3D9116,C03C04857FD7,3453D2A7375C,3453D2A96D67,209A7DB3A82A,,8CFDDE877792,44ADB13240B6,943C96ACE3C4,8CFDDE876413,841EA369C2C8,582FF70A6F82,C4EB429F872D,94988F92DB41,209A7DB3B86F,8CFDDE87D134,186A81D4E8E8,B0BBE54C16F8,,44D45460E849,20B82BFAD294,8CFDDE87F92E,6CFFCE695FF9', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-09 13:55:27 Duration: 6s851ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (285799, 449, 'CP2317321U9,D4925E94A576,544D4242006820A8,D4925E94A579$CP24093245G,08C7F52BDE0E,544D42420078110B,08C7F52BDE11$CP2302320WQ,D4925E0644B7,544D424200619A04,D4925E0644BA$CP232532PSJ,D4925ECF21D2,544D4242006D7898,D4925ECF21D5$CP2303328FC,D4925E14D9B0,544D42420062D741,D4925E14D9B3$CP2411326AA,08C7F530720F,544D424200789344,08C7F5307212$CP2301324KB,D4925E0212A8,544D424200612367,D4925E0212AB$CP2233320EV,A0B53C965B20,544D4242005C1A97,A0B53C965B23$CP2409326EW,08C7F52C358F,544D424200781AC4,08C7F52C3592$CP2320328BD,D4925EA4C2AD,544D42420069D3AB,D4925EA4C2B0$CP2217320KC,A0B53C3FE17F,544D4242005832A9,A0B53C3FE182$CP24113277G,08C7F5309513,544D424200789728,08C7F5309516$CP230132JW2,D4925E04370F,544D424200616056,D4925E043712$CP240932RMQ,08C7F52F14E3,544D424200786C78,08C7F52F14E6$CP2302327PS,D4925E074861,544D42420061B6DE,D4925E074864$CP2305325DL,D4925E195989,544D424200638E5C,D4925E19598C$CP234232PSJ,D4925EF90723,544D424200724688,D4925EF90726$CP2322320T9,D4925EB2F532,544D4242006B8F42,D4925EB2F535$CP232232GSE,D4925EBDF1D3,544D4242006BD336,D4925EBDF1D6$CP240432LNK,08C7F52804E7,544D424200776E80,08C7F52804EA$CP2320325BG,D4925EA44FED,544D42420069C6EB,D4925EA44FF0', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-09 09:29:49 Duration: 5s555ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (285789, 450, '73927685850070807022,229733483641,229733569104,229701590720,229711163842,229830581423,229824960426,229705235160,216926081838,229645693648,229707018487,229799379006,229708272539,216925237579,229792998103,229733631939,229733561124,229824930019,216927114048,229774809818,229641622746,216922571529,229826691122,229823951326,229766474964,216927492323,216929198998,229676678186,229645774161,229798832735,229733423961,229835966381,229712473555,229676957484,216927118997,229715885066,229768164141,229678332434,229832409906,229697088608,229641172848', '246567248900,246565605159,246507782042,,246639044257,246623236687,,246459199511,246478830507,246476596169,246616797091,246534414461,246431148300,246606417795,246584537994,246565605058,246623811222,246469090724,246575433840,246481151923,246449949405,246623755155,246136616367,246553750928,246451515461,246450776971,246490057191,246479536164,246652007575,246567197379,246044571010,246534954749,246459909210,246451707679,246550454253,246553501229,246489896872,226336081738,246521594949,246477260006', 0137, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-09-09 14:23:39 Duration: 3s909ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 8m11s 72 1s126ms 32s289ms 6s822ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 09 07 6 14s429ms 2s404ms 08 6 49s151ms 8s191ms 09 4 54s692ms 13s673ms 10 6 57s351ms 9s558ms 11 6 52s811ms 8s801ms 12 3 15s702ms 5s234ms 13 5 13s292ms 2s658ms 14 12 59s325ms 4s943ms 15 7 1m3s 9s52ms 16 10 1m19s 7s954ms 17 7 31s554ms 4s507ms [ User: intelifix - Total duration: 8m11s - Times executed: 72 ]
[ Application: [unknown] - Total duration: 8m11s - Times executed: 72 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-09', 0302, '', '', 0, 6, '2026-09-01');
Date: 2026-09-09 08:41:09 Duration: 32s289ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-08', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-09 09:42:15 Duration: 30s337ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-08', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-09 10:11:58 Duration: 24s40ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 7m44s 161 213ms 23s169ms 2s886ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 09 00 6 35s810ms 5s968ms 01 6 14s783ms 2s463ms 02 6 18s946ms 3s157ms 03 4 12s810ms 3s202ms 04 6 18s793ms 3s132ms 05 5 22s882ms 4s576ms 07 10 36s255ms 3s625ms 08 13 39s265ms 3s20ms 09 11 32s29ms 2s911ms 10 12 36s52ms 3s4ms 11 12 40s982ms 3s415ms 12 12 29s594ms 2s466ms 13 8 9s682ms 1s210ms 14 12 28s82ms 2s340ms 15 11 28s981ms 2s634ms 16 10 26s685ms 2s668ms 17 5 2s156ms 431ms 20 2 584ms 292ms 21 4 9s642ms 2s410ms 22 6 20s767ms 3s461ms [ User: intelifix - Total duration: 7m44s - Times executed: 161 ]
[ Application: psql - Total duration: 7m44s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-09 00:05:24 Duration: 23s169ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-09 05:35:13 Duration: 12s665ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-09 07:45:12 Duration: 11s426ms Database: rio User: intelifix Remote: [local] Application: psql
9 6m56s 212 150ms 12s227ms 1s966ms call rs_giga_triagem (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 09 00 9 29s126ms 3s236ms 01 9 15s683ms 1s742ms 02 9 15s712ms 1s745ms 03 9 15s522ms 1s724ms 04 8 15s112ms 1s889ms 05 8 17s859ms 2s232ms 06 9 15s244ms 1s693ms 07 11 17s496ms 1s590ms 08 11 28s774ms 2s615ms 09 10 24s681ms 2s468ms 10 10 19s258ms 1s925ms 11 9 17s704ms 1s967ms 12 8 16s498ms 2s62ms 13 10 15s890ms 1s589ms 14 12 16s375ms 1s364ms 15 11 16s850ms 1s531ms 16 11 16s441ms 1s494ms 17 8 17s809ms 2s226ms 18 10 15s673ms 1s567ms 19 6 15s352ms 2s558ms 20 8 22s849ms 2s856ms 21 7 14s745ms 2s106ms 22 9 16s215ms 1s801ms [ User: intelifix - Total duration: 6m56s - Times executed: 212 ]
[ Application: psql - Total duration: 6m56s - Times executed: 212 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-09 00:05:37 Duration: 12s227ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-09 08:45:17 Duration: 7s574ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-09 20:05:08 Duration: 7s290ms Database: rio User: intelifix Remote: [local] Application: psql
10 6m38s 781 151ms 3s721ms 510ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 09 07 11 11s830ms 1s75ms 08 123 1m7s 551ms 09 125 1m5s 525ms 10 94 53s82ms 564ms 11 91 43s284ms 475ms 12 12 5s758ms 479ms 13 65 35s704ms 549ms 14 102 45s389ms 444ms 15 87 39s917ms 458ms 16 53 20s938ms 395ms 17 18 9s26ms 501ms [ User: intelifix - Total duration: 6m38s - Times executed: 781 ]
[ Application: [unknown] - Total duration: 6m38s - Times executed: 781 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "285700", "modelo" : "463", "itens" : "241751234451,241782052936,241754100927,241755712038,241755857079,241722903033,241779542736,241787353139,241724982832,241750358697,241757869093,241723980625,241720942943,241749948298,241724314551,241723131013,241756986774,241704915677,241789765069,241754282841,241783307188,241734379797,241758861324,241735601523,241725609414,241783258800,241754130021,241758858696,241758072930,241748406363,241723058200,241757659196,241757256778,241720241831,241721636680,241754750519,241782331729,241779570618,241750014141,241719084658,241718808592,241725604969,241721585463,241735057092,241735957191,241781812834,241719271321,241783379899,241781863849,241794284253,241735391626,241719109408,241789689607,241752236479,241720255569,241754249807,241719242025,241720419805,241720282441,241789594850", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-09 13:23:59 Duration: 3s721ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "285707", "modelo" : "320", "itens" : "241605365355,241591958806,241607413131,230049395269,230048473451,241665964457,241610005864,241618322030,241621190324,241628030419,241630919599,241731088602,241679551833,241676238085,241656369009,241698565461,241637575154,241601582136,241712713049,241651739107,241655562735,241679181819,241645529309,241651959308,241628852631,241708252737,241639342847,241677678293,241667791931,241688952638,241663355560,241655585969,241714398790,241646115864,241675598191,241617023654,241731896065,241714392124,241607407597,241694660614,241675328692,241628322041,241700888190,241616732840,241689916783,241712788992,241620661428,241706969615", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-09 07:52:07 Duration: 2s980ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "285670", "modelo" : "463", "itens" : "241755105861,241722902225,241758856575,241737838990,241735757878,241750100918,241790240526,241718888803,241757942536,241723751029,241736474851,241757008392,241753736064,241757976579,241723791818,241751735869,241704916283,241789670818,241779559202,241748215559,241781956484,241752445972,241787761316,241751042031,241794447579,241748372444,241748469298,241719198585,241753530310,241794117895,241752938703,241757048396,241748486371,241782632140,241722382343,241725786075,241794238389,241748250715,241734401619,241753878907,241754325471,241758801823,241758078788,241722339510,241758266989,241736502329,241722431517,241758899206,241782124559,241784539193,241755613139,241779374156,241720757189,241754305570,241755104952,241725725867,241753880625,241781635566,241794120624,241722579107", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-09 13:27:48 Duration: 2s804ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 6m27s 32 10s497ms 32s797ms 12s111ms create table temp0000290929 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 09 09 32 6m27s 12s111ms [ User: intelifix - Total duration: 6m27s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 6m27s - Times executed: 32 ]
-
CREATE TABLE temp0000290929 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 09:10:18 Duration: 32s797ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290929 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 09:44:40 Duration: 14s492ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290929 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 09:28:33 Duration: 12s468ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 5m38s 1 5m38s 5m38s 5m38s select * from rs_fast_excel (?, ?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 09 08 1 5m38s 5m38s [ User: intelifix - Total duration: 5m38s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 5m38s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029606, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-09 08:40:01 Duration: 5m38s Database: rio User: intelifix Remote: [local] Application: [unknown]
13 4m59s 26 10s918ms 15s779ms 11s513ms create table temp0000290881 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 09 09 3 33s954ms 11s318ms 10 11 2m9s 11s736ms 14 10 1m52s 11s244ms 15 2 23s841ms 11s920ms [ User: intelifix - Total duration: 4m59s - Times executed: 26 ]
[ Application: [unknown] - Total duration: 4m59s - Times executed: 26 ]
-
CREATE TABLE temp0000290881 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 10:09:19 Duration: 15s779ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290881 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 15:03:41 Duration: 12s276ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290881 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 10:09:53 Duration: 11s828ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 4m54s 58 153ms 2m2s 5s69ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 09 07 2 953ms 476ms 08 8 4m4s 30s518ms 09 12 30s115ms 2s509ms 10 7 3s33ms 433ms 11 5 1s457ms 291ms 12 2 574ms 287ms 14 7 6s428ms 918ms 15 7 3s814ms 544ms 16 7 3s217ms 459ms 17 1 281ms 281ms [ User: intelifix - Total duration: 4m54s - Times executed: 58 ]
[ Application: psql - Total duration: 4m54s - Times executed: 58 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029604);
Date: 2026-09-09 08:31:53 Duration: 2m2s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029603);
Date: 2026-09-09 08:20:35 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029607);
Date: 2026-09-09 08:43:25 Duration: 45s859ms Database: rio User: intelifix Remote: [local] Application: psql
15 4m26s 48 182ms 27s433ms 5s556ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 09 07 1 27s433ms 27s433ms 08 6 1m38s 16s477ms 09 16 47s386ms 2s961ms 10 5 24s249ms 4s849ms 11 4 17s711ms 4s427ms 12 2 7s85ms 3s542ms 14 2 7s400ms 3s700ms 15 3 8s222ms 2s740ms 16 4 11s89ms 2s772ms 17 1 3s408ms 3s408ms 18 4 13s865ms 3s466ms [ User: intelifix - Total duration: 4m26s - Times executed: 48 ]
[ Application: psql - Total duration: 4m26s - Times executed: 48 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029602);
Date: 2026-09-09 07:22:33 Duration: 27s433ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029609);
Date: 2026-09-09 08:57:12 Duration: 26s702ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029606);
Date: 2026-09-09 08:34:19 Duration: 26s572ms Database: rio User: intelifix Remote: [local] Application: psql
16 3m33s 74 1s964ms 10s898ms 2s888ms create table temp0000290887 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 09 07 2 12s863ms 6s431ms 09 13 28s509ms 2s193ms 10 8 27s727ms 3s465ms 11 6 20s682ms 3s447ms 12 15 37s947ms 2s529ms 14 12 33s654ms 2s804ms 15 8 23s117ms 2s889ms 16 10 29s281ms 2s928ms [ User: intelifix - Total duration: 3m33s - Times executed: 74 ]
[ Application: [unknown] - Total duration: 3m33s - Times executed: 74 ]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-09-2026", "ate" :"09-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-09 07:56:36 Duration: 10s898ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-09-2026", "ate" :"09-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-09 10:20:50 Duration: 9s246ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-09-2026", "ate" :"09-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-09 11:29:55 Duration: 8s191ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 3m24s 18 10s472ms 12s735ms 11s363ms create table temp0000290899 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 09 07 3 33s3ms 11s1ms 08 14 2m40s 11s451ms 09 1 11s225ms 11s225ms [ User: intelifix - Total duration: 3m24s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m24s - Times executed: 18 ]
-
CREATE TABLE temp0000290899 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 08:20:23 Duration: 12s735ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290899 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 08:18:18 Duration: 12s13ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290899 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 08:30:02 Duration: 11s908ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 3m20s 18 10s216ms 12s921ms 11s148ms create table temp0000290985 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 09 14 3 33s561ms 11s187ms 15 6 1m8s 11s425ms 16 5 56s503ms 11s300ms 17 4 42s61ms 10s515ms [ User: intelifix - Total duration: 3m20s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m20s - Times executed: 18 ]
-
CREATE TABLE temp0000290985 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 15:49:11 Duration: 12s921ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290985 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 16:51:02 Duration: 12s512ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290985 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 15:15:48 Duration: 11s785ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 2m25s 10 10s814ms 41s819ms 14s518ms create table temp0000290887 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?) notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 09 07 2 52s880ms 26s440ms 09 1 11s325ms 11s325ms 10 2 22s761ms 11s380ms 11 1 10s814ms 10s814ms 15 1 12s176ms 12s176ms 16 3 35s231ms 11s743ms [ User: intelifix - Total duration: 2m25s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 2m25s - Times executed: 10 ]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-09-09 07:20:50 Duration: 41s819ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-09-09 16:11:46 Duration: 12s576ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-09-09 15:19:42 Duration: 12s176ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 2m17s 12 10s686ms 12s372ms 11s498ms create table temp0000290943 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 09 09 12 2m17s 11s498ms [ User: intelifix - Total duration: 2m17s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m17s - Times executed: 12 ]
-
CREATE TABLE temp0000290943 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 09:40:08 Duration: 12s372ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290943 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 09:45:05 Duration: 11s991ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290943 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 09:45:50 Duration: 11s872ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,284 16m3s 150ms 6s851ms 750ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 09 07 1 216ms 216ms 08 93 54s771ms 588ms 09 168 1m56s 692ms 10 162 2m11s 808ms 11 126 1m38s 780ms 12 54 34s747ms 643ms 13 104 1m21s 780ms 14 201 2m37s 782ms 15 177 2m30s 849ms 16 127 1m42s 805ms 17 71 36s503ms 514ms [ User: intelifix - Total duration: 16m3s - Times executed: 1284 ]
[ Application: [unknown] - Total duration: 16m3s - Times executed: 1284 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (285719, 433, '921171213335,38A65921E2C8,345D9EB3D68F,582FF716C1C5,CC5830E311E7,C4EB42A2BB22,94988F93E039,841EA38CA079,C4EB42A29DC4,C4EB42EA7BFC,44D454C22EC8,44D45460E413,506F0C3D9116,C03C04857FD7,3453D2A7375C,3453D2A96D67,209A7DB3A82A,,8CFDDE877792,44ADB13240B6,943C96ACE3C4,8CFDDE876413,841EA369C2C8,582FF70A6F82,C4EB429F872D,94988F92DB41,209A7DB3B86F,8CFDDE87D134,186A81D4E8E8,B0BBE54C16F8,,44D45460E849,20B82BFAD294,8CFDDE87F92E,6CFFCE695FF9', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-09 13:55:27 Duration: 6s851ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (285799, 449, 'CP2317321U9,D4925E94A576,544D4242006820A8,D4925E94A579$CP24093245G,08C7F52BDE0E,544D42420078110B,08C7F52BDE11$CP2302320WQ,D4925E0644B7,544D424200619A04,D4925E0644BA$CP232532PSJ,D4925ECF21D2,544D4242006D7898,D4925ECF21D5$CP2303328FC,D4925E14D9B0,544D42420062D741,D4925E14D9B3$CP2411326AA,08C7F530720F,544D424200789344,08C7F5307212$CP2301324KB,D4925E0212A8,544D424200612367,D4925E0212AB$CP2233320EV,A0B53C965B20,544D4242005C1A97,A0B53C965B23$CP2409326EW,08C7F52C358F,544D424200781AC4,08C7F52C3592$CP2320328BD,D4925EA4C2AD,544D42420069D3AB,D4925EA4C2B0$CP2217320KC,A0B53C3FE17F,544D4242005832A9,A0B53C3FE182$CP24113277G,08C7F5309513,544D424200789728,08C7F5309516$CP230132JW2,D4925E04370F,544D424200616056,D4925E043712$CP240932RMQ,08C7F52F14E3,544D424200786C78,08C7F52F14E6$CP2302327PS,D4925E074861,544D42420061B6DE,D4925E074864$CP2305325DL,D4925E195989,544D424200638E5C,D4925E19598C$CP234232PSJ,D4925EF90723,544D424200724688,D4925EF90726$CP2322320T9,D4925EB2F532,544D4242006B8F42,D4925EB2F535$CP232232GSE,D4925EBDF1D3,544D4242006BD336,D4925EBDF1D6$CP240432LNK,08C7F52804E7,544D424200776E80,08C7F52804EA$CP2320325BG,D4925EA44FED,544D42420069C6EB,D4925EA44FF0', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-09 09:29:49 Duration: 5s555ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (285789, 450, '73927685850070807022,229733483641,229733569104,229701590720,229711163842,229830581423,229824960426,229705235160,216926081838,229645693648,229707018487,229799379006,229708272539,216925237579,229792998103,229733631939,229733561124,229824930019,216927114048,229774809818,229641622746,216922571529,229826691122,229823951326,229766474964,216927492323,216929198998,229676678186,229645774161,229798832735,229733423961,229835966381,229712473555,229676957484,216927118997,229715885066,229768164141,229678332434,229832409906,229697088608,229641172848', '246567248900,246565605159,246507782042,,246639044257,246623236687,,246459199511,246478830507,246476596169,246616797091,246534414461,246431148300,246606417795,246584537994,246565605058,246623811222,246469090724,246575433840,246481151923,246449949405,246623755155,246136616367,246553750928,246451515461,246450776971,246490057191,246479536164,246652007575,246567197379,246044571010,246534954749,246459909210,246451707679,246550454253,246553501229,246489896872,226336081738,246521594949,246477260006', 0137, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-09-09 14:23:39 Duration: 3s909ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 781 6m38s 151ms 3s721ms 510ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 09 07 11 11s830ms 1s75ms 08 123 1m7s 551ms 09 125 1m5s 525ms 10 94 53s82ms 564ms 11 91 43s284ms 475ms 12 12 5s758ms 479ms 13 65 35s704ms 549ms 14 102 45s389ms 444ms 15 87 39s917ms 458ms 16 53 20s938ms 395ms 17 18 9s26ms 501ms [ User: intelifix - Total duration: 6m38s - Times executed: 781 ]
[ Application: [unknown] - Total duration: 6m38s - Times executed: 781 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "285700", "modelo" : "463", "itens" : "241751234451,241782052936,241754100927,241755712038,241755857079,241722903033,241779542736,241787353139,241724982832,241750358697,241757869093,241723980625,241720942943,241749948298,241724314551,241723131013,241756986774,241704915677,241789765069,241754282841,241783307188,241734379797,241758861324,241735601523,241725609414,241783258800,241754130021,241758858696,241758072930,241748406363,241723058200,241757659196,241757256778,241720241831,241721636680,241754750519,241782331729,241779570618,241750014141,241719084658,241718808592,241725604969,241721585463,241735057092,241735957191,241781812834,241719271321,241783379899,241781863849,241794284253,241735391626,241719109408,241789689607,241752236479,241720255569,241754249807,241719242025,241720419805,241720282441,241789594850", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-09 13:23:59 Duration: 3s721ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "285707", "modelo" : "320", "itens" : "241605365355,241591958806,241607413131,230049395269,230048473451,241665964457,241610005864,241618322030,241621190324,241628030419,241630919599,241731088602,241679551833,241676238085,241656369009,241698565461,241637575154,241601582136,241712713049,241651739107,241655562735,241679181819,241645529309,241651959308,241628852631,241708252737,241639342847,241677678293,241667791931,241688952638,241663355560,241655585969,241714398790,241646115864,241675598191,241617023654,241731896065,241714392124,241607407597,241694660614,241675328692,241628322041,241700888190,241616732840,241689916783,241712788992,241620661428,241706969615", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-09 07:52:07 Duration: 2s980ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "285670", "modelo" : "463", "itens" : "241755105861,241722902225,241758856575,241737838990,241735757878,241750100918,241790240526,241718888803,241757942536,241723751029,241736474851,241757008392,241753736064,241757976579,241723791818,241751735869,241704916283,241789670818,241779559202,241748215559,241781956484,241752445972,241787761316,241751042031,241794447579,241748372444,241748469298,241719198585,241753530310,241794117895,241752938703,241757048396,241748486371,241782632140,241722382343,241725786075,241794238389,241748250715,241734401619,241753878907,241754325471,241758801823,241758078788,241722339510,241758266989,241736502329,241722431517,241758899206,241782124559,241784539193,241755613139,241779374156,241720757189,241754305570,241755104952,241725725867,241753880625,241781635566,241794120624,241722579107", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-09 13:27:48 Duration: 2s804ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 290 1h45m53s 150ms 6m12s 21s908ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 09 07 5 10m27s 2m5s 08 68 2m17s 2s23ms 09 32 19m11s 35s987ms 10 20 17m31s 52s572ms 11 23 12m12s 31s849ms 12 14 5m59s 25s669ms 13 20 17s584ms 879ms 14 31 12m35s 24s366ms 15 21 6m21s 18s148ms 16 33 15m56s 28s995ms 17 19 2m49s 8s915ms 18 4 13s311ms 3s327ms [ User: intelifix - Total duration: 1h45m53s - Times executed: 290 ]
[ Application: [unknown] - Total duration: 1h45m53s - Times executed: 290 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029609, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-09 09:03:30 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029602, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-09 07:28:56 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029654, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-09 14:36:05 Duration: 5m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 212 6m56s 150ms 12s227ms 1s966ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 09 00 9 29s126ms 3s236ms 01 9 15s683ms 1s742ms 02 9 15s712ms 1s745ms 03 9 15s522ms 1s724ms 04 8 15s112ms 1s889ms 05 8 17s859ms 2s232ms 06 9 15s244ms 1s693ms 07 11 17s496ms 1s590ms 08 11 28s774ms 2s615ms 09 10 24s681ms 2s468ms 10 10 19s258ms 1s925ms 11 9 17s704ms 1s967ms 12 8 16s498ms 2s62ms 13 10 15s890ms 1s589ms 14 12 16s375ms 1s364ms 15 11 16s850ms 1s531ms 16 11 16s441ms 1s494ms 17 8 17s809ms 2s226ms 18 10 15s673ms 1s567ms 19 6 15s352ms 2s558ms 20 8 22s849ms 2s856ms 21 7 14s745ms 2s106ms 22 9 16s215ms 1s801ms [ User: intelifix - Total duration: 6m56s - Times executed: 212 ]
[ Application: psql - Total duration: 6m56s - Times executed: 212 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-09 00:05:37 Duration: 12s227ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-09 08:45:17 Duration: 7s574ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-09 20:05:08 Duration: 7s290ms Database: rio User: intelifix Remote: [local] Application: psql
5 161 7m44s 213ms 23s169ms 2s886ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 09 00 6 35s810ms 5s968ms 01 6 14s783ms 2s463ms 02 6 18s946ms 3s157ms 03 4 12s810ms 3s202ms 04 6 18s793ms 3s132ms 05 5 22s882ms 4s576ms 07 10 36s255ms 3s625ms 08 13 39s265ms 3s20ms 09 11 32s29ms 2s911ms 10 12 36s52ms 3s4ms 11 12 40s982ms 3s415ms 12 12 29s594ms 2s466ms 13 8 9s682ms 1s210ms 14 12 28s82ms 2s340ms 15 11 28s981ms 2s634ms 16 10 26s685ms 2s668ms 17 5 2s156ms 431ms 20 2 584ms 292ms 21 4 9s642ms 2s410ms 22 6 20s767ms 3s461ms [ User: intelifix - Total duration: 7m44s - Times executed: 161 ]
[ Application: psql - Total duration: 7m44s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-09 00:05:24 Duration: 23s169ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-09 05:35:13 Duration: 12s665ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-09 07:45:12 Duration: 11s426ms Database: rio User: intelifix Remote: [local] Application: psql
6 151 1m12s 150ms 3s306ms 482ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 09 08 66 18s129ms 274ms 09 3 2s325ms 775ms 10 2 2s380ms 1s190ms 11 14 5s389ms 384ms 12 5 9s857ms 1s971ms 13 16 17s187ms 1s74ms 14 12 5s264ms 438ms 15 10 3s542ms 354ms 16 19 7s165ms 377ms 17 4 1s558ms 389ms [ User: intelifix - Total duration: 1m12s - Times executed: 151 ]
[ Application: [unknown] - Total duration: 1m12s - Times executed: 151 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0135349) LIMIT 1;
Date: 2026-09-09 13:24:34 Duration: 3s306ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0134712) LIMIT 1;
Date: 2026-09-09 13:25:56 Duration: 3s293ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0136138) LIMIT 1;
Date: 2026-09-09 12:17:47 Duration: 3s110ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
7 104 34s137ms 295ms 515ms 328ms 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 09 00 1 322ms 322ms 01 1 295ms 295ms 04 2 616ms 308ms 05 1 300ms 300ms 07 7 2s143ms 306ms 08 12 3s906ms 325ms 09 10 3s375ms 337ms 10 9 2s912ms 323ms 11 10 3s326ms 332ms 12 4 1s240ms 310ms 13 8 2s776ms 347ms 14 15 4s877ms 325ms 15 7 2s511ms 358ms 16 8 2s532ms 316ms 17 6 2s12ms 335ms 18 3 987ms 329ms [ User: lenon - Total duration: 34s137ms - Times executed: 104 ]
[ Application: [unknown] - Total duration: 34s137ms - Times executed: 104 ]
-
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-09 09:00:23 Duration: 515ms 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-09 15:06:43 Duration: 484ms 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-09 13:10:40 Duration: 439ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
8 103 30s836ms 250ms 635ms 299ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 09 07 2 567ms 283ms 08 17 5s341ms 314ms 09 20 6s194ms 309ms 10 8 2s306ms 288ms 11 8 2s515ms 314ms 12 6 1s689ms 281ms 13 3 878ms 292ms 14 8 2s541ms 317ms 15 9 2s532ms 281ms 16 11 3s158ms 287ms 17 7 1s917ms 273ms 18 4 1s193ms 298ms [ User: intelifix - Total duration: 30s836ms - Times executed: 103 ]
[ Application: [unknown] - Total duration: 30s836ms - Times executed: 103 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-09 08:52:53 Duration: 635ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-09-09 09:21:48 Duration: 573ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-09 11:13:37 Duration: 519ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 100 39s533ms 338ms 676ms 395ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 09 00 1 534ms 534ms 01 1 378ms 378ms 04 2 733ms 366ms 05 1 426ms 426ms 07 4 1s478ms 369ms 08 12 4s933ms 411ms 09 10 3s940ms 394ms 10 9 3s666ms 407ms 11 9 3s610ms 401ms 12 4 1s493ms 373ms 13 8 3s185ms 398ms 14 15 5s661ms 377ms 15 7 2s875ms 410ms 16 8 3s115ms 389ms 17 6 2s346ms 391ms 18 3 1s153ms 384ms [ User: intelifix - Total duration: 39s533ms - Times executed: 100 ]
[ Application: [unknown] - Total duration: 39s533ms - Times executed: 100 ]
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-09-09 08:17:28 Duration: 676ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (401, 5, 1);
Date: 2026-09-09 10:56:30 Duration: 645ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (414, 19, 1);
Date: 2026-09-09 09:00:23 Duration: 558ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 89 16m49s 10s319ms 18s623ms 11s346ms create table temp0000290887 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 09 07 4 43s135ms 10s783ms 08 12 2m17s 11s494ms 09 7 1m17s 11s94ms 10 10 1m52s 11s243ms 11 14 2m46s 11s876ms 12 5 55s919ms 11s183ms 14 12 2m16s 11s412ms 15 10 1m50s 11s59ms 16 15 2m48s 11s263ms [ User: intelifix - Total duration: 16m49s - Times executed: 89 ]
[ Application: [unknown] - Total duration: 16m49s - Times executed: 89 ]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 11:50:20 Duration: 18s623ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 11:14:59 Duration: 14s855ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 08:56:21 Duration: 12s385ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 74 3m33s 1s964ms 10s898ms 2s888ms create table temp0000290887 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 09 07 2 12s863ms 6s431ms 09 13 28s509ms 2s193ms 10 8 27s727ms 3s465ms 11 6 20s682ms 3s447ms 12 15 37s947ms 2s529ms 14 12 33s654ms 2s804ms 15 8 23s117ms 2s889ms 16 10 29s281ms 2s928ms [ User: intelifix - Total duration: 3m33s - Times executed: 74 ]
[ Application: [unknown] - Total duration: 3m33s - Times executed: 74 ]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-09-2026", "ate" :"09-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-09 07:56:36 Duration: 10s898ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-09-2026", "ate" :"09-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-09 10:20:50 Duration: 9s246ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-09-2026", "ate" :"09-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-09 11:29:55 Duration: 8s191ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 72 8m11s 1s126ms 32s289ms 6s822ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 09 07 6 14s429ms 2s404ms 08 6 49s151ms 8s191ms 09 4 54s692ms 13s673ms 10 6 57s351ms 9s558ms 11 6 52s811ms 8s801ms 12 3 15s702ms 5s234ms 13 5 13s292ms 2s658ms 14 12 59s325ms 4s943ms 15 7 1m3s 9s52ms 16 10 1m19s 7s954ms 17 7 31s554ms 4s507ms [ User: intelifix - Total duration: 8m11s - Times executed: 72 ]
[ Application: [unknown] - Total duration: 8m11s - Times executed: 72 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-09', 0302, '', '', 0, 6, '2026-09-01');
Date: 2026-09-09 08:41:09 Duration: 32s289ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-08', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-09 09:42:15 Duration: 30s337ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-08', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-09 10:11:58 Duration: 24s40ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 58 4m54s 153ms 2m2s 5s69ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 09 07 2 953ms 476ms 08 8 4m4s 30s518ms 09 12 30s115ms 2s509ms 10 7 3s33ms 433ms 11 5 1s457ms 291ms 12 2 574ms 287ms 14 7 6s428ms 918ms 15 7 3s814ms 544ms 16 7 3s217ms 459ms 17 1 281ms 281ms [ User: intelifix - Total duration: 4m54s - Times executed: 58 ]
[ Application: psql - Total duration: 4m54s - Times executed: 58 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029604);
Date: 2026-09-09 08:31:53 Duration: 2m2s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029603);
Date: 2026-09-09 08:20:35 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029607);
Date: 2026-09-09 08:43:25 Duration: 45s859ms Database: rio User: intelifix Remote: [local] Application: psql
14 58 18s133ms 151ms 651ms 312ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 09 08 3 819ms 273ms 09 12 4s22ms 335ms 10 15 4s385ms 292ms 11 11 3s655ms 332ms 12 1 394ms 394ms 14 6 1s948ms 324ms 15 8 2s359ms 294ms 16 2 548ms 274ms [ User: intelifix - Total duration: 18s133ms - Times executed: 58 ]
[ Application: [unknown] - Total duration: 18s133ms - Times executed: 58 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'D89A0DACF4C5,843C99338927,4896D950645C,843C993342E9,6C11BA65407B,D89A0DAC9E13,3CF9F0A53EBC,F4E84F839E16,843C9933A84D,5872C98CE691,843C99339CEF,48D682305B54,D89A0DABF319,4896D958B2D8,843C992142FB,4896D957DCD6,3891484AC545,6C11BA636B4F,D89A0DACF2A9,48D68231F3D8', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-09-09 11:09:14 Duration: 651ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '6802B8628332,6802B8A3A218,6802B8F7F187,6802B8624C90,B4F2672095AA,6802B8BF2D2B,6802B8A2899B,6802B85B235A,6802B8988ED1,6802B8A2A6F9,6802B8A3857A,6802B8F08777,B4F2674EE58C,6802B8CAAC40,6802B86491DF,6802B8649BE1,6802B8AAA7B0,6802B8A105BD,6802B8A2824B,6802B8A3B1D2,6802B8650E71', '','DEFAULT',056,0156,'', '','', 00);
Date: 2026-09-09 09:56:38 Duration: 645ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '08A7C07291F4,4075C3BBEBE8,484BD4ADC81C,3C82C067EE18,4075C3B924D0,00CB7ADD1D34,4075C3B1D720,B85E71E5E4E4,8C6A8DC06CE4,B85E71BFEEB0,F8D2ACC991EC,E4BFFAFBC474,C4509CF1C70C,484BD4A5F4DC', '138;1', 'DEFAULT', 09, 0185, '','', '', 00);
Date: 2026-09-09 09:40:22 Duration: 600ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 57 1m44s 571ms 18s352ms 1s827ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 09 08 4 7s572ms 1s893ms 09 4 10s54ms 2s513ms 10 3 2s9ms 669ms 11 5 14s815ms 2s963ms 12 3 2s317ms 772ms 13 4 6s419ms 1s604ms 14 3 2s235ms 745ms 15 4 16s453ms 4s113ms 16 3 2s123ms 707ms 17 4 24s534ms 6s133ms 18 4 2s747ms 686ms 19 4 2s830ms 707ms 20 4 3s53ms 763ms 21 4 3s19ms 754ms 22 4 3s964ms 991ms [ User: intelifix - Total duration: 1m44s - Times executed: 57 ]
[ Application: psql - Total duration: 1m44s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-09 17:40:20 Duration: 18s352ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-09 15:20:12 Duration: 11s458ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-09 11:20:07 Duration: 6s446ms Database: rio User: intelifix Remote: [local] Application: psql
16 48 1h30m42s 1s393ms 7m38s 1m53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 09 07 3 8m15s 2m45s 08 3 5m17s 1m45s 09 3 7m3s 2m21s 10 3 5m35s 1m51s 11 3 5m52s 1m57s 12 3 5m20s 1m46s 13 3 5m9s 1m43s 14 3 5m29s 1m49s 15 3 5m42s 1m54s 16 3 5m36s 1m52s 17 3 5m29s 1m49s 18 3 5m1s 1m40s 19 3 5m13s 1m44s 20 3 5m22s 1m47s 21 3 5m6s 1m42s 22 3 5m6s 1m42s [ User: intelifix - Total duration: 1h30m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h30m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-09 07:12:39 Duration: 7m38s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-09 09:11:42 Duration: 6m40s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-09 11:10:35 Duration: 5m34s Database: rio User: intelifix Remote: [local] Application: psql
17 48 1h7m58s 295ms 4m1s 1m24s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 09 07 3 5m14s 1m44s 08 3 4m12s 1m24s 09 3 4m31s 1m30s 10 3 4m18s 1m26s 11 3 4m29s 1m29s 12 3 4m8s 1m22s 13 3 4m6s 1m22s 14 3 4m11s 1m23s 15 3 4m21s 1m27s 16 3 4m13s 1m24s 17 3 4m9s 1m23s 18 3 4m5s 1m21s 19 3 4m6s 1m22s 20 3 3m57s 1m19s 21 3 3m47s 1m15s 22 3 4m3s 1m21s [ User: intelifix - Total duration: 1h7m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-09 07:18:22 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-09 09:16:31 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-09 11:15:20 Duration: 3m54s Database: brasilia User: intelifix Remote: [local] Application: psql
18 48 4m26s 182ms 27s433ms 5s556ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 09 07 1 27s433ms 27s433ms 08 6 1m38s 16s477ms 09 16 47s386ms 2s961ms 10 5 24s249ms 4s849ms 11 4 17s711ms 4s427ms 12 2 7s85ms 3s542ms 14 2 7s400ms 3s700ms 15 3 8s222ms 2s740ms 16 4 11s89ms 2s772ms 17 1 3s408ms 3s408ms 18 4 13s865ms 3s466ms [ User: intelifix - Total duration: 4m26s - Times executed: 48 ]
[ Application: psql - Total duration: 4m26s - Times executed: 48 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029602);
Date: 2026-09-09 07:22:33 Duration: 27s433ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029609);
Date: 2026-09-09 08:57:12 Duration: 26s702ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029606);
Date: 2026-09-09 08:34:19 Duration: 26s572ms Database: rio User: intelifix Remote: [local] Application: psql
19 32 6m27s 10s497ms 32s797ms 12s111ms create table temp0000290929 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 09 09 32 6m27s 12s111ms [ User: intelifix - Total duration: 6m27s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 6m27s - Times executed: 32 ]
-
CREATE TABLE temp0000290929 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 09:10:18 Duration: 32s797ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290929 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 09:44:40 Duration: 14s492ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290929 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 09:28:33 Duration: 12s468ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 31 1m41s 589ms 8s44ms 3s286ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 09 08 2 11s617ms 5s808ms 09 1 7s136ms 7s136ms 10 3 16s320ms 5s440ms 11 1 7s576ms 7s576ms 12 3 3s769ms 1s256ms 13 2 8s477ms 4s238ms 14 3 18s198ms 6s66ms 15 2 7s398ms 3s699ms 16 3 8s567ms 2s855ms 17 1 1s726ms 1s726ms 18 2 1s817ms 908ms 19 2 1s626ms 813ms 20 2 4s344ms 2s172ms 21 2 1s729ms 864ms 22 2 1s563ms 781ms [ User: intelifix - Total duration: 1m41s - Times executed: 31 ]
[ Application: psql - Total duration: 1m41s - Times executed: 31 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-09 10:00:10 Duration: 8s44ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-09 14:20:09 Duration: 8s23ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-09 08:20:09 Duration: 7s973ms Database: rio User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m41s 9m28s 6m9s 3 18m29s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 09 05 3 18m29s 6m9s [ User: intelifix - Total duration: 18m29s - Times executed: 3 ]
[ Application: psql - Total duration: 18m29s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-09 05:09:29 Duration: 9m28s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-09 05:15:49 Duration: 6m19s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-09 05:18:31 Duration: 2m41s Database: contagem User: intelifix Remote: [local] Application: psql
2 5m38s 5m38s 5m38s 1 5m38s select * from rs_fast_excel (?, ?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 09 08 1 5m38s 5m38s [ User: intelifix - Total duration: 5m38s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 5m38s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029606, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-09 08:40:01 Duration: 5m38s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1s393ms 7m38s 1m53s 48 1h30m42s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 09 07 3 8m15s 2m45s 08 3 5m17s 1m45s 09 3 7m3s 2m21s 10 3 5m35s 1m51s 11 3 5m52s 1m57s 12 3 5m20s 1m46s 13 3 5m9s 1m43s 14 3 5m29s 1m49s 15 3 5m42s 1m54s 16 3 5m36s 1m52s 17 3 5m29s 1m49s 18 3 5m1s 1m40s 19 3 5m13s 1m44s 20 3 5m22s 1m47s 21 3 5m6s 1m42s 22 3 5m6s 1m42s [ User: intelifix - Total duration: 1h30m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h30m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-09 07:12:39 Duration: 7m38s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-09 09:11:42 Duration: 6m40s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-09 11:10:35 Duration: 5m34s Database: rio User: intelifix Remote: [local] Application: psql
4 295ms 4m1s 1m24s 48 1h7m58s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 09 07 3 5m14s 1m44s 08 3 4m12s 1m24s 09 3 4m31s 1m30s 10 3 4m18s 1m26s 11 3 4m29s 1m29s 12 3 4m8s 1m22s 13 3 4m6s 1m22s 14 3 4m11s 1m23s 15 3 4m21s 1m27s 16 3 4m13s 1m24s 17 3 4m9s 1m23s 18 3 4m5s 1m21s 19 3 4m6s 1m22s 20 3 3m57s 1m19s 21 3 3m47s 1m15s 22 3 4m3s 1m21s [ User: intelifix - Total duration: 1h7m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-09 07:18:22 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-09 09:16:31 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-09 11:15:20 Duration: 3m54s Database: brasilia User: intelifix Remote: [local] Application: psql
5 150ms 6m12s 21s908ms 290 1h45m53s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 09 07 5 10m27s 2m5s 08 68 2m17s 2s23ms 09 32 19m11s 35s987ms 10 20 17m31s 52s572ms 11 23 12m12s 31s849ms 12 14 5m59s 25s669ms 13 20 17s584ms 879ms 14 31 12m35s 24s366ms 15 21 6m21s 18s148ms 16 33 15m56s 28s995ms 17 19 2m49s 8s915ms 18 4 13s311ms 3s327ms [ User: intelifix - Total duration: 1h45m53s - Times executed: 290 ]
[ Application: [unknown] - Total duration: 1h45m53s - Times executed: 290 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029609, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-09 09:03:30 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029602, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-09 07:28:56 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029654, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-09 14:36:05 Duration: 5m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 10s814ms 41s819ms 14s518ms 10 2m25s create table temp0000290887 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?) notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 09 07 2 52s880ms 26s440ms 09 1 11s325ms 11s325ms 10 2 22s761ms 11s380ms 11 1 10s814ms 10s814ms 15 1 12s176ms 12s176ms 16 3 35s231ms 11s743ms [ User: intelifix - Total duration: 2m25s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 2m25s - Times executed: 10 ]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-09-09 07:20:50 Duration: 41s819ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-09-09 16:11:46 Duration: 12s576ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-09-09 15:19:42 Duration: 12s176ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 10s497ms 32s797ms 12s111ms 32 6m27s create table temp0000290929 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 09 09 32 6m27s 12s111ms [ User: intelifix - Total duration: 6m27s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 6m27s - Times executed: 32 ]
-
CREATE TABLE temp0000290929 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 09:10:18 Duration: 32s797ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290929 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 09:44:40 Duration: 14s492ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290929 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 09:28:33 Duration: 12s468ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s918ms 15s779ms 11s513ms 26 4m59s create table temp0000290881 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 09 09 3 33s954ms 11s318ms 10 11 2m9s 11s736ms 14 10 1m52s 11s244ms 15 2 23s841ms 11s920ms [ User: intelifix - Total duration: 4m59s - Times executed: 26 ]
[ Application: [unknown] - Total duration: 4m59s - Times executed: 26 ]
-
CREATE TABLE temp0000290881 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 10:09:19 Duration: 15s779ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290881 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 15:03:41 Duration: 12s276ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290881 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 10:09:53 Duration: 11s828ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s686ms 12s372ms 11s498ms 12 2m17s create table temp0000290943 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 09 09 12 2m17s 11s498ms [ User: intelifix - Total duration: 2m17s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m17s - Times executed: 12 ]
-
CREATE TABLE temp0000290943 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 09:40:08 Duration: 12s372ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290943 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 09:45:05 Duration: 11s991ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290943 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 09:45:50 Duration: 11s872ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s472ms 12s735ms 11s363ms 18 3m24s create table temp0000290899 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 09 07 3 33s3ms 11s1ms 08 14 2m40s 11s451ms 09 1 11s225ms 11s225ms [ User: intelifix - Total duration: 3m24s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m24s - Times executed: 18 ]
-
CREATE TABLE temp0000290899 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 08:20:23 Duration: 12s735ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290899 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 08:18:18 Duration: 12s13ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290899 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 08:30:02 Duration: 11s908ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s319ms 18s623ms 11s346ms 89 16m49s create table temp0000290887 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 09 07 4 43s135ms 10s783ms 08 12 2m17s 11s494ms 09 7 1m17s 11s94ms 10 10 1m52s 11s243ms 11 14 2m46s 11s876ms 12 5 55s919ms 11s183ms 14 12 2m16s 11s412ms 15 10 1m50s 11s59ms 16 15 2m48s 11s263ms [ User: intelifix - Total duration: 16m49s - Times executed: 89 ]
[ Application: [unknown] - Total duration: 16m49s - Times executed: 89 ]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 11:50:20 Duration: 18s623ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 11:14:59 Duration: 14s855ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 08:56:21 Duration: 12s385ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 10s216ms 12s921ms 11s148ms 18 3m20s create table temp0000290985 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 09 14 3 33s561ms 11s187ms 15 6 1m8s 11s425ms 16 5 56s503ms 11s300ms 17 4 42s61ms 10s515ms [ User: intelifix - Total duration: 3m20s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m20s - Times executed: 18 ]
-
CREATE TABLE temp0000290985 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 15:49:11 Duration: 12s921ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290985 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 16:51:02 Duration: 12s512ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290985 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-09 15:15:48 Duration: 11s785ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 1s126ms 32s289ms 6s822ms 72 8m11s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 09 07 6 14s429ms 2s404ms 08 6 49s151ms 8s191ms 09 4 54s692ms 13s673ms 10 6 57s351ms 9s558ms 11 6 52s811ms 8s801ms 12 3 15s702ms 5s234ms 13 5 13s292ms 2s658ms 14 12 59s325ms 4s943ms 15 7 1m3s 9s52ms 16 10 1m19s 7s954ms 17 7 31s554ms 4s507ms [ User: intelifix - Total duration: 8m11s - Times executed: 72 ]
[ Application: [unknown] - Total duration: 8m11s - Times executed: 72 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-09', 0302, '', '', 0, 6, '2026-09-01');
Date: 2026-09-09 08:41:09 Duration: 32s289ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-08', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-09 09:42:15 Duration: 30s337ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-08', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-09 10:11:58 Duration: 24s40ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 182ms 27s433ms 5s556ms 48 4m26s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 09 07 1 27s433ms 27s433ms 08 6 1m38s 16s477ms 09 16 47s386ms 2s961ms 10 5 24s249ms 4s849ms 11 4 17s711ms 4s427ms 12 2 7s85ms 3s542ms 14 2 7s400ms 3s700ms 15 3 8s222ms 2s740ms 16 4 11s89ms 2s772ms 17 1 3s408ms 3s408ms 18 4 13s865ms 3s466ms [ User: intelifix - Total duration: 4m26s - Times executed: 48 ]
[ Application: psql - Total duration: 4m26s - Times executed: 48 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029602);
Date: 2026-09-09 07:22:33 Duration: 27s433ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029609);
Date: 2026-09-09 08:57:12 Duration: 26s702ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029606);
Date: 2026-09-09 08:34:19 Duration: 26s572ms Database: rio User: intelifix Remote: [local] Application: psql
15 153ms 2m2s 5s69ms 58 4m54s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 09 07 2 953ms 476ms 08 8 4m4s 30s518ms 09 12 30s115ms 2s509ms 10 7 3s33ms 433ms 11 5 1s457ms 291ms 12 2 574ms 287ms 14 7 6s428ms 918ms 15 7 3s814ms 544ms 16 7 3s217ms 459ms 17 1 281ms 281ms [ User: intelifix - Total duration: 4m54s - Times executed: 58 ]
[ Application: psql - Total duration: 4m54s - Times executed: 58 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029604);
Date: 2026-09-09 08:31:53 Duration: 2m2s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029603);
Date: 2026-09-09 08:20:35 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029607);
Date: 2026-09-09 08:43:25 Duration: 45s859ms Database: rio User: intelifix Remote: [local] Application: psql
16 589ms 8s44ms 3s286ms 31 1m41s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 09 08 2 11s617ms 5s808ms 09 1 7s136ms 7s136ms 10 3 16s320ms 5s440ms 11 1 7s576ms 7s576ms 12 3 3s769ms 1s256ms 13 2 8s477ms 4s238ms 14 3 18s198ms 6s66ms 15 2 7s398ms 3s699ms 16 3 8s567ms 2s855ms 17 1 1s726ms 1s726ms 18 2 1s817ms 908ms 19 2 1s626ms 813ms 20 2 4s344ms 2s172ms 21 2 1s729ms 864ms 22 2 1s563ms 781ms [ User: intelifix - Total duration: 1m41s - Times executed: 31 ]
[ Application: psql - Total duration: 1m41s - Times executed: 31 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-09 10:00:10 Duration: 8s44ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-09 14:20:09 Duration: 8s23ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-09 08:20:09 Duration: 7s973ms Database: rio User: intelifix Remote: [local] Application: psql
17 1s964ms 10s898ms 2s888ms 74 3m33s create table temp0000290887 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 09 07 2 12s863ms 6s431ms 09 13 28s509ms 2s193ms 10 8 27s727ms 3s465ms 11 6 20s682ms 3s447ms 12 15 37s947ms 2s529ms 14 12 33s654ms 2s804ms 15 8 23s117ms 2s889ms 16 10 29s281ms 2s928ms [ User: intelifix - Total duration: 3m33s - Times executed: 74 ]
[ Application: [unknown] - Total duration: 3m33s - Times executed: 74 ]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-09-2026", "ate" :"09-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-09 07:56:36 Duration: 10s898ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-09-2026", "ate" :"09-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-09 10:20:50 Duration: 9s246ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290887 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-09-2026", "ate" :"09-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-09 11:29:55 Duration: 8s191ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 213ms 23s169ms 2s886ms 161 7m44s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 09 00 6 35s810ms 5s968ms 01 6 14s783ms 2s463ms 02 6 18s946ms 3s157ms 03 4 12s810ms 3s202ms 04 6 18s793ms 3s132ms 05 5 22s882ms 4s576ms 07 10 36s255ms 3s625ms 08 13 39s265ms 3s20ms 09 11 32s29ms 2s911ms 10 12 36s52ms 3s4ms 11 12 40s982ms 3s415ms 12 12 29s594ms 2s466ms 13 8 9s682ms 1s210ms 14 12 28s82ms 2s340ms 15 11 28s981ms 2s634ms 16 10 26s685ms 2s668ms 17 5 2s156ms 431ms 20 2 584ms 292ms 21 4 9s642ms 2s410ms 22 6 20s767ms 3s461ms [ User: intelifix - Total duration: 7m44s - Times executed: 161 ]
[ Application: psql - Total duration: 7m44s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-09 00:05:24 Duration: 23s169ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-09 05:35:13 Duration: 12s665ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-09 07:45:12 Duration: 11s426ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 12s227ms 1s966ms 212 6m56s call rs_giga_triagem (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 09 00 9 29s126ms 3s236ms 01 9 15s683ms 1s742ms 02 9 15s712ms 1s745ms 03 9 15s522ms 1s724ms 04 8 15s112ms 1s889ms 05 8 17s859ms 2s232ms 06 9 15s244ms 1s693ms 07 11 17s496ms 1s590ms 08 11 28s774ms 2s615ms 09 10 24s681ms 2s468ms 10 10 19s258ms 1s925ms 11 9 17s704ms 1s967ms 12 8 16s498ms 2s62ms 13 10 15s890ms 1s589ms 14 12 16s375ms 1s364ms 15 11 16s850ms 1s531ms 16 11 16s441ms 1s494ms 17 8 17s809ms 2s226ms 18 10 15s673ms 1s567ms 19 6 15s352ms 2s558ms 20 8 22s849ms 2s856ms 21 7 14s745ms 2s106ms 22 9 16s215ms 1s801ms [ User: intelifix - Total duration: 6m56s - Times executed: 212 ]
[ Application: psql - Total duration: 6m56s - Times executed: 212 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-09 00:05:37 Duration: 12s227ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-09 08:45:17 Duration: 7s574ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-09 20:05:08 Duration: 7s290ms Database: rio User: intelifix Remote: [local] Application: psql
20 571ms 18s352ms 1s827ms 57 1m44s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 09 08 4 7s572ms 1s893ms 09 4 10s54ms 2s513ms 10 3 2s9ms 669ms 11 5 14s815ms 2s963ms 12 3 2s317ms 772ms 13 4 6s419ms 1s604ms 14 3 2s235ms 745ms 15 4 16s453ms 4s113ms 16 3 2s123ms 707ms 17 4 24s534ms 6s133ms 18 4 2s747ms 686ms 19 4 2s830ms 707ms 20 4 3s53ms 763ms 21 4 3s19ms 754ms 22 4 3s964ms 991ms [ User: intelifix - Total duration: 1m44s - Times executed: 57 ]
[ Application: psql - Total duration: 1m44s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-09 17:40:20 Duration: 18s352ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-09 15:20:12 Duration: 11s458ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-09 11:20:07 Duration: 6s446ms Database: rio User: intelifix Remote: [local] Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 7 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 09 13 2 0ms 0ms 15 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 2s531ms - Times executed: 7 ]
[ Application: [unknown] - Total duration: 1s344ms - Times executed: 3 ]
[ Application: psql - Total duration: 1s187ms - Times executed: 4 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 13,919 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 21 FATAL entries
- 2676 ERROR entries
- 0 WARNING entries
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,658 Max number of times the same event was reported
- 2,701 Total events found
Rank Times reported Error 1 2,658 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 09 00 59 01 9 07 134 08 432 09 385 10 331 11 253 12 108 13 129 14 224 15 332 16 166 17 93 18 3 - ERROR: prepared statement "_PLAN000000002992F010" does not exist
- ERROR: prepared statement "_PLAN0000000029931000" does not exist
- ERROR: prepared statement "_PLAN000000002992E6F0" does not exist
Statement: DEALLOCATE "_PLAN000000002992F010"
Date: 2026-09-09 00:00:47 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029931000"
Date: 2026-09-09 00:01:47 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002992E6F0"
Date: 2026-09-09 00:02:48 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 12 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 09 00 1 02 1 03 2 05 1 06 3 13 2 16 1 21 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-09 00:02:13 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-09 02:34:58 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-09 03:44:27 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 09 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-09 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-09 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-09 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
4 4 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 09 08 1 11 3 - ERROR: syntax error at or near "241598857290" at character 41
- ERROR: syntax error at or near "453113301822" at character 32
- ERROR: syntax error at or near "453113301822" at character 80
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''241598857290');
Date: 2026-09-09 08:13:26 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( ''453113301822' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''453113301822' )
Date: 2026-09-09 11:04:36 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"57178","seriais":[{"serial":"'453113301822"},{"serial":"183989472732"}]}')
Date: 2026-09-09 11:04:40 Database: contagem Application: [unknown] User: intelifix Remote: [local]
5 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 09 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-09 05:32:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-09 05:32:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-09 05:32:02 Database: contagem Application: psql User: intelifix Remote: [local]
6 3 ERROR: update or delete on table "..." violates foreign key constraint "..." on table "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 09 10 3 - ERROR: update or delete on table "lote_itens" violates foreign key constraint "nf_entrada_itens_li_id_fkey" on table "nf_entrada_itens"
- ERROR: update or delete on table "lote_itens" violates foreign key constraint "nf_entrada_itens_li_id_fkey" on table "nf_entrada_itens"
- ERROR: update or delete on table "lote_itens" violates foreign key constraint "nf_entrada_itens_li_id_fkey" on table "nf_entrada_itens"
Detail: Key (li_id)=(1651186) is still referenced from table "nf_entrada_itens".
Context: SQL statement "DELETE FROM LOTE_ITENS WHERE EQ_ID = REC.EQ_ID" PL/pgSQL function rs_lote_exclui(integer) line 82 at SQL statement
Statement: SELECT * FROM RS_LOTE_EXCLUI(0136307);Date: 2026-09-09 10:09:59 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Detail: Key (li_id)=(1651186) is still referenced from table "nf_entrada_itens".
Context: SQL statement "DELETE FROM LOTE_ITENS WHERE EQ_ID = REC.EQ_ID" PL/pgSQL function rs_lote_exclui(integer) line 82 at SQL statement
Statement: SELECT * FROM RS_LOTE_EXCLUI(0136307);Date: 2026-09-09 10:10:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Detail: Key (li_id)=(1651186) is still referenced from table "nf_entrada_itens".
Context: SQL statement "DELETE FROM LOTE_ITENS WHERE EQ_ID = REC.EQ_ID" PL/pgSQL function rs_lote_exclui(integer) line 82 at SQL statement
Statement: SELECT * FROM RS_LOTE_EXCLUI(0136307);Date: 2026-09-09 10:11:09 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
7 2 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 09 09 1 16 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000290943"
Date: 2026-09-09 09:45:38
Context: automatic vacuum of table "rio.public.temp0000290887"
Date: 2026-09-09 16:13:14
8 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 09 07 1 12 1 - ERROR: unterminated quoted string at or near "'518247272834'');" at character 39
- ERROR: unterminated quoted string at or near "'241755787072'');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('518247272834'');
Date: 2026-09-09 07:12:12 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('241755787072'');
Date: 2026-09-09 12:50:14 Database: rio Application: [unknown] User: intelifix Remote: [local]
9 2 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 09 09 1 16 1 - LOG: process 1541298 still waiting for AccessExclusiveLock on relation 4819391 of database 358220 after 1000.131 ms
- LOG: process 1949509 still waiting for AccessExclusiveLock on relation 4846248 of database 358220 after 1000.072 ms
Detail: Process holding the lock: 1594518. Wait queue: 1541298.
Statement: DROP TABLE IF EXISTS temp0000290943;Date: 2026-09-09 09:45:38 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1954964. Wait queue: 1949509.
Statement: DROP TABLE IF EXISTS temp0000290887;Date: 2026-09-09 16:13:14 Database: rio Application: [unknown] User: intelifix Remote: [local]
10 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 09 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-09 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-09 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 09 12 2 - ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
Statement: select * from rs_caixa_qr(V)
Date: 2026-09-09 12:14:14 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(V)
Date: 2026-09-09 12:14:14 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
12 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 09 03 1 - LOG: database system was shut down at 2026-09-09 03:05:01 -03
Date: 2026-09-09 03:05:02
13 1 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 09 07 1 - ERROR: invalid input syntax for type date: "N-Na--N-Na" at character 40
Statement: SELECT * FROM RS_RESUMO_PERIODO_GERAL( 'N-Na--N-Na', 0404 ,'', '',0,7,'2026-09-01');
Date: 2026-09-09 07:09:36 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
14 1 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 09 09 1 - LOG: skipping analyze of "temp0000290929" --- lock not available
Date: 2026-09-09 09:37:36