pgBadger-
Global information
- Generated on Fri Sep 25 23:50:15 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 39,054 log entries in 12s
- Log start from 2026-09-25 00:00:31 to 2026-09-25 23:49:55
-
Overview
Global Stats
- 383 Number of unique normalized queries
- 4,783 Number of queries
- 7h52m7s Total query duration
- 2026-09-25 00:02:15 First query
- 2026-09-25 23:49:55 Last query
- 5 queries/s at 2026-09-25 23:42:33 Query peak
- 7h52m7s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h52m7s Execute total duration
- 4,077 Number of events
- 16 Number of unique normalized events
- 3,975 Max number of times the same event was reported
- 0 Number of cancellation
- 545 Total number of automatic vacuums
- 900 Total number of automatic analyzes
- 24 Number temporary file
- 247.45 MiB Max size of temporary file
- 70.62 MiB Average size of temporary file
- 416 Total number of sessions
- 8 sessions at 2026-09-25 01:05:15 Session peak
- 13d8h58m4s Total duration of sessions
- 46m17s Average duration of sessions
- 11 Average queries per session
- 1m8s Average queries duration per session
- 45m9s Average idle time per session
- 437 Total number of connections
- 7 connections/s at 2026-09-25 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-25 23:42:33 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-09-25 15:04:40 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-25 23:42:33 Date
Queries duration
Key values
- 7h52m7s 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 25 00 22 0ms 15s611ms 4s238ms 3s893ms 6s705ms 48s157ms 01 37 0ms 3s721ms 985ms 4s529ms 5s289ms 6s493ms 02 12 0ms 4s154ms 2s347ms 2s923ms 4s339ms 6s963ms 03 13 0ms 4s518ms 2s199ms 2s670ms 4s672ms 6s506ms 04 45 0ms 4s450ms 875ms 3s628ms 5s290ms 7s892ms 05 19 0ms 11m11s 1m14s 3s948ms 2m56s 11m11s 06 32 0ms 12s589ms 2s505ms 4s729ms 10s599ms 23s336ms 07 329 0ms 7m47s 7s30ms 1m35s 5m20s 8m20s 08 466 150ms 5m37s 6s193ms 3m34s 5m45s 8m5s 09 581 151ms 5m35s 3s200ms 1m26s 3m24s 5m50s 10 606 150ms 30m35s 8s290ms 1m36s 5m40s 50m48s 11 404 151ms 5m59s 4s201ms 44s630ms 4m22s 6m53s 12 158 0ms 5m44s 7s752ms 12s834ms 3m51s 7m22s 13 279 0ms 5m16s 3s982ms 38s211ms 41s435ms 5m49s 14 470 150ms 5m31s 4s926ms 1m7s 5m43s 5m58s 15 349 151ms 5m15s 2s937ms 25s705ms 38s407ms 5m48s 16 189 0ms 5m18s 4s154ms 16s744ms 25s538ms 6m8s 17 187 0ms 5m13s 4s302ms 25s86ms 30s520ms 5m43s 18 53 0ms 5m15s 11s416ms 3s294ms 14s743ms 5m45s 19 18 0ms 5m17s 32s660ms 3s47ms 14s907ms 5m46s 20 118 0ms 5m27s 10s70ms 1m6s 1m22s 6m23s 21 28 0ms 5m21s 21s943ms 5s382ms 14s924ms 5m51s 22 24 0ms 5m13s 24s952ms 5s167ms 6s215ms 5m56s 23 344 0ms 1m2s 5s730ms 1m5s 1m7s 1m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 25 00 4 0 5s417ms 0ms 0ms 615ms 01 25 0 242ms 263ms 364ms 663ms 02 0 0 0ms 0ms 0ms 0ms 03 2 0 410ms 0ms 0ms 0ms 04 32 0 238ms 216ms 584ms 728ms 05 2 0 442ms 0ms 0ms 0ms 06 16 0 2s172ms 0ms 179ms 4s888ms 07 239 0 7s705ms 12s2ms 56s695ms 6m12s 08 351 0 6s159ms 14s42ms 3m31s 5m39s 09 493 0 3s162ms 11s495ms 1m25s 5m45s 10 493 0 9s171ms 13s892ms 1m7s 5m55s 11 305 0 4s343ms 6s420ms 26s80ms 5m40s 12 106 0 9s443ms 2s226ms 3s509ms 5m44s 13 202 0 3s886ms 5s885ms 17s870ms 3m26s 14 392 0 5s141ms 21s339ms 46s77ms 5m55s 15 293 0 2s900ms 8s315ms 20s661ms 3m31s 16 151 0 4s871ms 3s96ms 16s744ms 3m22s 17 140 0 5s238ms 3s815ms 15s909ms 3m28s 18 38 0 15s231ms 591ms 780ms 3m25s 19 6 0 1m34s 0ms 0ms 3m22s 20 15 85 11s567ms 42s754ms 1m2s 3m36s 21 11 0 52s659ms 0ms 263ms 3m30s 22 6 0 1m33s 0ms 0ms 3m25s 23 23 321 5s730ms 1m2s 1m4s 1m13s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 25 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 25 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 3 3.00 0.00% 05 0 1 1.00 0.00% 06 0 3 3.00 0.00% 07 0 11 11.00 0.00% 08 0 11 11.00 0.00% 09 0 11 11.00 0.00% 10 0 13 13.00 0.00% 11 0 9 9.00 0.00% 12 0 6 6.00 0.00% 13 0 9 9.00 0.00% 14 0 18 18.00 0.00% 15 0 19 19.00 0.00% 16 0 14 14.00 0.00% 17 0 4 4.00 0.00% 18 0 2 2.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 3 3.00 0.00% Day Hour Count Average / Second Sep 25 00 16 0.00/s 01 11 0.00/s 02 9 0.00/s 03 19 0.01/s 04 10 0.00/s 05 13 0.00/s 06 15 0.00/s 07 22 0.01/s 08 24 0.01/s 09 22 0.01/s 10 22 0.01/s 11 20 0.01/s 12 12 0.00/s 13 21 0.01/s 14 25 0.01/s 15 53 0.01/s 16 34 0.01/s 17 13 0.00/s 18 11 0.00/s 19 11 0.00/s 20 14 0.00/s 21 12 0.00/s 22 12 0.00/s 23 16 0.00/s Day Hour Count Average Duration Average idle time Sep 25 00 9 55m26s 55m16s 01 14 1h1m3s 1h1m 02 11 1h38s 1h35s 03 18 19m52s 19m50s 04 10 1h2m24s 1h2m20s 05 9 1h40s 58m3s 06 8 56m52s 56m42s 07 15 51m33s 48m59s 08 21 50m45s 48m27s 09 23 54m22s 53m1s 10 20 57m22s 53m11s 11 23 55m45s 54m32s 12 18 56m41s 55m33s 13 11 1h16s 58m35s 14 26 49m57s 48m28s 15 55 19m39s 19m21s 16 33 27m32s 27m8s 17 18 55m14s 54m29s 18 13 56m58s 56m12s 19 11 55m48s 54m55s 20 13 43m2s 41m31s 21 10 1h18s 59m17s 22 13 56m38s 55m52s 23 14 36m42s 34m21s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-09-25 03:05:17 Date
Connections per database
Key values
- brasilia Main Database
- 437 connections Total
Connections per user
Key values
- intelifix Main User
- 437 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-09-25 01:05:15 Date
Histogram of session times
Key values
- 292 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 416 sessions Total
Sessions per user
Key values
- intelifix Main User
- 416 sessions Total
Sessions per host
Key values
- [local] Main Host
- 416 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 36,893 buffers Checkpoint Peak
- 2026-09-25 00:09:45 Date
- 270.056 seconds Highest write time
- 0.188 seconds Sync time
Checkpoints Wal files
Key values
- 14 files Wal files usage Peak
- 2026-09-25 10:09:36 Date
Checkpoints distance
Key values
- 427.76 Mo Distance Peak
- 2026-09-25 10:09:36 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 25 00 64,092 671.319s 0.08s 671.439s 01 3,560 356.57s 0.156s 356.76s 02 1,645 164.832s 0.092s 164.946s 03 994 99.692s 0.045s 99.76s 04 4,791 479.842s 0.092s 479.964s 05 8,844 876.824s 0.229s 877.124s 06 7,601 581.622s 0.094s 581.74s 07 44,050 2,794.489s 0.219s 2,794.776s 08 66,710 3,156.121s 0.56s 3,156.803s 09 65,332 3,208.165s 0.324s 3,208.59s 10 116,036 3,238.909s 0.5s 3,239.582s 11 44,832 3,219.357s 0.298s 3,219.748s 12 24,843 2,063.992s 0.231s 2,064.308s 13 21,415 2,159.604s 0.275s 2,159.946s 14 62,753 3,217.632s 0.381s 3,218.103s 15 41,314 3,106.377s 0.255s 3,106.724s 16 19,587 2,081.512s 0.23s 2,081.847s 17 31,992 2,093.651s 0.259s 2,093.972s 18 5,107 547.295s 0.26s 547.59s 19 31 3.117s 0.025s 3.145s 20 457 308.898s 0.004s 308.911s 21 3,070 307.157s 0.077s 307.262s 22 1,923 192.605s 0.082s 192.719s 23 394 44.027s 0.071s 44.123s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 25 00 0 0 11 471 0.063s 0.006s 01 0 0 1 629 0.062s 0.011s 02 0 0 0 397 0.063s 0.006s 03 0 0 1 297 0.007s 0.006s 04 0 0 1 761 0.063s 0.01s 05 0 0 4 721 0.063s 0.012s 06 0 0 2 464 0.062s 0.006s 07 0 0 34 4,238 0.033s 0.012s 08 0 0 58 6,676 0.038s 0.012s 09 0 0 39 7,976 0.059s 0.012s 10 0 0 77 8,125 0.016s 0.012s 11 0 0 42 6,510 0.062s 0.012s 12 0 0 17 3,014 0.063s 0.012s 13 0 0 28 4,819 0.062s 0.012s 14 0 0 42 6,537 0.062s 0.012s 15 0 0 27 5,045 0.061s 0.012s 16 0 0 7 3,095 0.062s 0.012s 17 0 0 18 3,706 0.062s 0.012s 18 0 0 1 1,119 0.062s 0.013s 19 0 0 0 10 0.023s 0.003s 20 0 0 1 61 0.001s 0.002s 21 0 0 1 471 0.062s 0.006s 22 0 0 1 405 0.063s 0.009s 23 0 0 0 85 0.063s 0.012s Day Hour Count Avg time (sec) Sep 25 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 25 00 29,479.50 kB 73,768.67 kB 01 1,994.00 kB 35,885.33 kB 02 1,396.00 kB 16,877.00 kB 03 798.14 kB 2,600.86 kB 04 2,568.30 kB 3,626.30 kB 05 6,997.00 kB 12,829.11 kB 06 4,016.17 kB 9,733.00 kB 07 46,849.08 kB 87,386.08 kB 08 79,439.25 kB 135,367.08 kB 09 53,634.75 kB 117,681.75 kB 10 104,522.17 kB 179,031.92 kB 11 57,600.50 kB 120,283.33 kB 12 22,409.75 kB 85,516.83 kB 13 38,893.67 kB 86,013.33 kB 14 57,563.33 kB 107,594.75 kB 15 36,010.75 kB 85,825.67 kB 16 9,384.50 kB 39,891.33 kB 17 24,925.67 kB 67,905.42 kB 18 2,169.50 kB 25,106.83 kB 19 212.00 kB 12,564.00 kB 20 8,108.50 kB 12,019.00 kB 21 2,366.00 kB 8,926.67 kB 22 1,276.88 kB 5,125.75 kB 23 247.80 kB 2,924.80 kB -
Temporary Files
Size of temporary files
Key values
- 494.89 MiB Temp Files size Peak
- 2026-09-25 05:31:56 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-25 05:32:01 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 25 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.32 GiB 67.34 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 2 140.00 MiB 70.00 MiB 10 2 207.99 MiB 104.00 MiB 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.01 GiB 36.90 MiB 247.45 MiB 64.95 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-25 05:32:04 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-25 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 347.99 MiB 36.00 MiB 104.00 MiB 87.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030428, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-25 10:39:08 Duration: 30m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030428, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-25 10:39:18 Duration: 18m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030397, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-25 07:17:26 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 4 307.72 MiB 57.19 MiB 94.12 MiB 76.93 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-25 05:30:42 Duration: 38s793ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-25 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 247.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-25 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 247.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-25 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx');[ Date: 2026-09-25 09:57:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-09-25 10:08:00 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,508,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-09-25 10:39:08 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 94.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-25 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 94.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-25 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 62.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-25 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 57.19 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-25 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-25 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-25 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-25 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.82 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-25 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 40.82 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-25 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 40.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-25 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 40.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-25 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.97 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-25 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-25 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-25 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-25 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 9.39 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database contagem - 2026-09-25 17:27:37 Date
- 0 sec Highest CPU-cost analyze
Table
Database contagem - Date
Average Autovacuum Duration
Key values
- 9.39 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database contagem - 2026-09-25 17:27:37 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (117) Main table analyzed (database rio)
- 900 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 117 rio.pg_catalog.pg_class 59 rio.pg_catalog.pg_type 50 rio.public.usuarios 47 rio.public.temp0000292470 46 brasilia.pg_catalog.pg_attribute 37 contagem.public.usuarios 32 contagem.pg_catalog.pg_attribute 31 rio.pg_catalog.pg_index 31 rio.pg_catalog.pg_depend 23 rio.public.temp0000292486 22 rio.public.temp0000292546 21 brasilia.public.temp0000240924 19 brasilia.pg_catalog.pg_class 19 brasilia.pg_catalog.pg_type 16 contagem.pg_catalog.pg_class 14 rio.public.temp0000292056 13 rio.public.temp0000290026 13 rio.public.temp0000292494 13 rio.public.temp0000291977 13 contagem.public.temp0000227300 12 contagem.pg_catalog.pg_type 12 rio.public.temp0000292462 12 rio.public.temp0000292498 11 brasilia.pg_catalog.pg_index 11 rio.public.temp0000292538 11 brasilia.public.temp0000240916 11 rio.public.temp0000292554 10 rio.public.temp0000292476 10 rio.public.temp0000292432 9 brasilia.public.usuarios 9 brasilia.pg_catalog.pg_depend 9 contagem.pg_catalog.pg_index 8 rio.public.temp0000292466 7 contagem.pg_catalog.pg_depend 6 rio.public.temp0000292454 6 brasilia.public.temp0000240978 5 rio.public.temp0000290230 5 contagem.public.temp0000227314 5 contagem.public.temp0000227308 4 rio.public.temp0000292522 4 postgres.pg_catalog.pg_shdepend 4 brasilia.public.temp0000240922 4 rio.pg_catalog.pg_shdepend 4 rio.public.temp0000292520 4 rio.public.temp0000292510 4 brasilia.public.nf_entrada 4 rio.public.temp0000292514 3 rio.public.temp0000292480 3 rio.public.temp0000292464 3 rio.public.temp0000292552 3 brasilia.public.temp0000240942 3 contagem.public.nf_entrada 3 rio.public.tmp_drill_0302 3 contagem.pg_catalog.pg_shdepend 3 brasilia.public.temp0000240934 2 brasilia.public.temp0000240932 2 rio.public.temp0000292456 2 rio.public.temp0000292534 2 rio.public.temp0000292468 2 brasilia.public.temp0000240968 2 brasilia.public.temp0000240980 2 contagem.public.temp0000227310 2 brasilia.public.temp0000240982 1 rio.public.temp0000292528 1 contagem.public.temp0000227298 1 rio.public.temp0000292572 1 rio.public.temp0000292524 1 rio.public.temp0000292502 1 brasilia.pg_catalog.pg_shdepend 1 rio.public.temp0000292548 1 contagem.public.temp0000227312 1 brasilia.public.temp0000240918 1 brasilia.public.temp0000240976 1 brasilia.public.temp0000240990 1 brasilia.public.temp0000240958 1 rio.public.tmp_drill_0320 1 rio.public.temp0000292506 1 brasilia.public.temp0000240962 1 rio.public.temp0000292558 1 contagem.public.temp0000227302 1 brasilia.public.temp0000240954 1 rio.public.temp0000292550 1 rio.public.temp0000292500 1 rio.public.temp0000292478 1 brasilia.public.temp0000240928 1 Total 900 Vacuums per table
Key values
- pg_catalog.pg_attribute (78) Main table vacuumed on database rio
- 545 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 78 42 0 0 0 0 0 21,514 5,694 8,607,741 267 6,676 rio.pg_catalog.pg_class 59 23 0 0 0 0 0 4,105 1,327 1,873,868 72 282 rio.pg_catalog.pg_type 51 21 0 0 0 0 0 1,927 658 841,760 63 221 rio.public.temp0000292470 47 0 0 0 0 0 0 43,448 2,040 4,959,068 0 0 contagem.public.usuarios 33 0 0 0 0 0 0 125 90 55,343 1 1 rio.public.usuarios 29 5 0 0 0 0 0 176 70 146,126 13 24 rio.pg_catalog.pg_index 19 13 0 0 0 0 0 682 225 219,526 31 62 rio.public.temp0000290026 13 0 0 0 0 0 0 923 165 227,195 0 0 rio.public.temp0000292056 13 0 0 0 0 0 0 857 171 220,874 0 0 rio.public.temp0000292546 13 0 0 0 0 0 0 8,241 166 700,125 0 0 brasilia.pg_catalog.pg_attribute 12 12 0 0 0 0 0 6,189 1,474 2,551,697 50 1,374 contagem.pg_catalog.pg_attribute 12 12 0 0 0 0 0 8,557 1,688 3,354,129 31 875 rio.pg_catalog.pg_depend 10 10 0 0 0 0 0 3,283 1,278 1,879,947 68 450 rio.public.temp0000292486 10 0 0 0 0 0 0 4,100 52 249,671 0 0 rio.public.temp0000292432 9 0 0 0 0 0 0 7,330 1,855 2,796,916 0 0 rio.public.temp0000292538 8 0 0 0 0 0 0 4,231 44 256,397 0 0 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 9,430 2,549 10,942,834 1,294 5,808 brasilia.pg_catalog.pg_shdepend 7 7 0 0 0 0 0 1,360 404 688,262 65 113 brasilia.pg_catalog.pg_type 7 7 0 0 0 0 0 743 176 297,144 14 44 brasilia.pg_catalog.pg_class 7 7 0 0 0 0 0 1,558 391 654,100 24 72 contagem.pg_catalog.pg_class 5 5 0 0 0 0 0 1,495 133 306,336 6 19 rio.public.temp0000291977 5 0 0 0 0 0 0 407 29 28,566 0 0 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 741 101 201,842 4 12 brasilia.pg_catalog.pg_index 5 5 0 0 0 0 0 232 58 53,686 11 26 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,065 511 2,683,184 170 494 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,273 472 659,586 14 132 rio.public.temp0000292510 4 0 0 0 0 0 0 3,662 14 218,340 0 0 rio.public.temp0000292522 4 0 0 0 0 0 0 16 12 3,096 0 0 rio.public.temp0000290230 3 0 0 0 0 0 0 115 68 97,765 0 0 rio.public.tmp_drill_0302 3 3 0 0 0 0 0 89 9 19,260 0 0 brasilia.public.temp0000240978 3 0 0 0 0 0 0 556 50 102,523 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,214 875 3,654,413 586 3,694 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 1,413 199 557,867 5 35 rio.public.temp0000292514 3 0 0 0 0 0 0 107 14 8,635 0 0 brasilia.public.temp0000240942 3 0 0 0 0 0 0 765 516 831,994 0 0 contagem.pg_catalog.pg_index 3 3 0 0 0 0 0 276 31 68,704 2 5 contagem.public.nf_entrada 3 3 0 0 0 0 0 288 82 161,820 4 9 rio.public.temp0000292468 2 0 0 0 0 0 0 175 12 12,154 0 0 brasilia.public.temp0000240968 2 0 0 0 0 0 0 510 8 31,296 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 348 88 353,352 29 68 rio.public.temp0000292498 2 0 0 0 0 0 0 178 12 12,344 0 0 brasilia.public.nf_entrada 2 2 0 0 0 0 0 296 111 292,194 1 1 rio.public.temp0000292534 2 0 0 0 0 0 0 1,832 7 109,229 0 0 rio.public.temp0000292476 1 0 0 0 0 0 0 8 5 1,304 0 0 brasilia.auditor.auditor_2026_09 1 0 0 0 0 0 0 23,846 23,450 29,004,752 125 636 contagem.auditor.auditor_2026_09 1 0 0 0 0 0 0 47,123 28,409 35,452,543 9,283 195,466 brasilia.public.temp0000240962 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000292558 1 0 0 0 0 0 0 1,830 4 108,573 0 0 rio.public.temp0000292502 1 0 0 0 0 0 0 89 88 175,671 0 0 contagem.public.temp0000227314 1 0 0 0 0 0 0 51 6 3,849 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,339 219 892,922 193 1,531 brasilia.public.temp0000240954 1 0 0 0 0 0 0 255 4 15,648 0 0 brasilia.public.temp0000240918 1 0 0 0 0 0 0 255 4 15,648 0 0 contagem.public.temp0000227312 1 0 0 0 0 0 0 48 6 3,660 0 0 rio.public.temp0000292550 1 0 0 0 0 0 0 101 6 6,906 0 0 rio.public.temp0000292500 1 0 0 0 0 0 0 8 5 1,225 0 0 brasilia.public.temp0000240976 1 0 0 0 0 0 0 255 4 15,648 0 0 contagem.public.temp0000227310 1 0 0 0 0 0 0 117 6 7,879 0 0 brasilia.public.temp0000240928 1 0 0 0 0 0 0 255 4 15,648 0 0 rio.public.temp0000292466 1 0 0 0 0 0 0 87 6 6,047 0 0 brasilia.public.temp0000240982 1 0 0 0 0 0 0 256 4 15,707 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 113 27 81,466 8 12 rio.public.temp0000292528 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.tmp_drill_0320 1 1 0 0 0 0 0 32 3 7,202 0 0 rio.public.temp0000292572 1 0 0 0 0 0 0 103 6 7,024 0 0 rio.public.temp0000292520 1 0 0 0 0 0 0 8 5 1,322 0 0 rio.public.temp0000292480 1 0 0 0 0 0 0 8 5 1,305 0 0 rio.public.temp0000292554 1 0 0 0 0 0 0 101 6 6,903 0 0 Total 545 212 0 0 0 0 0 227,128 76,217 117,841,309 12,434 218,142 Vacuum throughput per table
Key values
- auditor.auditor_2026_09 (9.39) Max CPU elapsed for vacuum on database contagem
- unknown (0 ms) Max I/O read time for vacuum on database contagem
- unknown (0 ms) Max I/O write time for vacuum on database contagem
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.17 rio.pg_catalog.pg_class 0 0 0.8 rio.pg_catalog.pg_type 0 0 0.32 rio.public.temp0000292470 0 0 2.45 contagem.public.usuarios 0 0 0.02 rio.public.usuarios 0 0 0.05 rio.pg_catalog.pg_index 0 0 0.16 rio.public.temp0000290026 0 0 0.01 rio.public.temp0000292056 0 0 0.01 rio.public.temp0000292546 0 0 0.2 brasilia.pg_catalog.pg_attribute 0 0 1.26 contagem.pg_catalog.pg_attribute 0 0 1.92 rio.pg_catalog.pg_depend 0 0 0.73 rio.public.temp0000292486 0 0 0.1 rio.public.temp0000292432 0 0 0.39 rio.public.temp0000292538 0 0 0.09 rio.pg_catalog.pg_statistic 0 0 1.41 brasilia.pg_catalog.pg_shdepend 0 0 0.48 brasilia.pg_catalog.pg_type 0 0 0.38 brasilia.pg_catalog.pg_class 0 0 0.56 contagem.pg_catalog.pg_class 0 0 0.53 rio.public.temp0000291977 0 0 0.02 contagem.pg_catalog.pg_type 0 0 0.4 brasilia.pg_catalog.pg_index 0 0 0.28 rio.pg_toast.pg_toast_2619 0 0 0.19 brasilia.pg_catalog.pg_depend 0 0 0.57 rio.public.temp0000292510 0 0 0.16 rio.public.temp0000292522 0 0 0.16 rio.public.temp0000290230 0 0 0 rio.public.tmp_drill_0302 0 0 0 brasilia.public.temp0000240978 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.51 contagem.pg_catalog.pg_depend 0 0 0.5 rio.public.temp0000292514 0 0 0.04 brasilia.public.temp0000240942 0 0 0 contagem.pg_catalog.pg_index 0 0 0.25 contagem.public.nf_entrada 0 0 0.04 rio.public.temp0000292468 0 0 0 brasilia.public.temp0000240968 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.02 rio.public.temp0000292498 0 0 0.01 brasilia.public.nf_entrada 0 0 0.19 rio.public.temp0000292534 0 0 0.09 rio.public.temp0000292476 0 0 0 brasilia.auditor.auditor_2026_09 0 0 4.7 contagem.auditor.auditor_2026_09 0 0 9.39 brasilia.public.temp0000240962 0 0 0 rio.public.temp0000292558 0 0 0.04 rio.public.temp0000292502 0 0 0.01 contagem.public.temp0000227314 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.1 brasilia.public.temp0000240954 0 0 0 brasilia.public.temp0000240918 0 0 0 contagem.public.temp0000227312 0 0 0 rio.public.temp0000292550 0 0 0 rio.public.temp0000292500 0 0 0 brasilia.public.temp0000240976 0 0 0 contagem.public.temp0000227310 0 0 0 brasilia.public.temp0000240928 0 0 0 rio.public.temp0000292466 0 0 0 brasilia.public.temp0000240982 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000292528 0 0 0.04 rio.public.tmp_drill_0320 0 0 0 rio.public.temp0000292572 0 0 0 rio.public.temp0000292520 0 0 0 rio.public.temp0000292480 0 0 0 rio.public.temp0000292554 0 0 0 Total 0 0 32.75 Tuples removed per table
Key values
- pg_catalog.pg_attribute (159736) Main table with removed tuples on database rio
- 366642 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 78 42 159,736 2,192,411 446,567 332 51,068 contagem.pg_catalog.pg_attribute 12 12 74,029 311,718 0 434 8,127 brasilia.pg_catalog.pg_attribute 12 12 52,824 267,989 68 128 6,728 rio.pg_catalog.pg_statistic 8 8 13,264 66,172 1,035 0 10,288 rio.pg_catalog.pg_depend 10 10 9,093 195,066 5,497 0 1,870 brasilia.pg_catalog.pg_shdepend 7 7 7,009 95,195 80 0 875 brasilia.pg_catalog.pg_statistic 3 3 6,431 23,679 63 0 3,216 rio.pg_catalog.pg_type 51 21 5,172 141,013 25,376 12 3,755 contagem.pg_catalog.pg_type 5 5 4,865 12,324 0 54 416 contagem.pg_catalog.pg_statistic 1 1 4,164 7,274 0 0 1,011 contagem.pg_catalog.pg_depend 3 3 3,623 58,655 0 37 580 brasilia.pg_catalog.pg_type 7 7 3,296 15,533 4 13 477 rio.pg_catalog.pg_class 59 23 3,226 272,796 66,377 40 7,460 rio.pg_catalog.pg_index 19 13 2,573 40,414 4,040 7 1,039 contagem.pg_catalog.pg_class 5 5 2,519 19,610 0 100 914 contagem.pg_catalog.pg_index 3 3 2,366 5,696 0 15 189 brasilia.auditor.auditor_2026_09 1 0 1,954 4,010,962 0 0 178,866 contagem.public.usuarios 33 0 1,941 792 0 0 66 brasilia.pg_catalog.pg_depend 4 4 1,900 72,391 0 0 702 brasilia.pg_catalog.pg_class 7 7 1,723 26,534 9 29 951 brasilia.pg_catalog.pg_index 5 5 1,338 9,447 2 0 271 rio.pg_toast.pg_toast_2619 4 4 1,208 2,737 10 0 1,116 contagem.public.nf_entrada 3 3 1,126 5,389 922 0 261 rio.public.usuarios 29 5 642 22,205 7,444 0 551 brasilia.pg_toast.pg_toast_2619 2 2 217 273 0 14 122 rio.public.tmp_drill_0302 3 3 159 825 0 0 24 brasilia.public.nf_entrada 2 2 147 10,100 0 0 304 contagem.pg_toast.pg_toast_2619 1 1 97 115 0 0 52 rio.public.temp0000292476 1 0 0 1,286 0 49 79 contagem.auditor.auditor_2026_09 1 0 0 3,325,772 0 0 152,847 rio.public.temp0000290230 3 0 0 6,972 0 33 159 rio.public.temp0000292468 2 0 0 2,603 0 97 159 brasilia.public.temp0000240962 1 0 0 3,349 0 0 256 rio.public.temp0000292558 1 0 0 25,947 0 0 1,856 brasilia.public.temp0000240968 2 0 0 6,698 0 0 512 rio.public.temp0000292486 10 0 0 66,732 0 212 4,204 rio.public.temp0000292502 1 0 0 1,317 0 47 81 contagem.public.temp0000227314 1 0 0 1,103 0 21 43 rio.public.temp0000292470 47 0 0 777,761 0 707 55,421 brasilia.public.temp0000240954 1 0 0 3,349 0 0 256 rio.public.temp0000292432 9 0 0 233,098 0 0 16,704 rio.public.temp0000291977 5 0 0 21,367 0 162 478 brasilia.public.temp0000240918 1 0 0 3,348 0 0 256 contagem.public.temp0000227312 1 0 0 1,021 0 24 40 rio.public.temp0000292550 1 0 0 1,518 0 35 93 rio.public.temp0000292500 1 0 0 1,977 0 20 44 brasilia.public.temp0000240976 1 0 0 3,351 0 0 256 contagem.public.temp0000227310 1 0 0 1,393 0 19 109 brasilia.public.temp0000240928 1 0 0 3,349 0 0 256 rio.public.temp0000292538 8 0 0 64,676 0 242 4,238 rio.public.temp0000292466 1 0 0 1,286 0 49 79 brasilia.public.temp0000240978 3 0 0 8,455 0 28 548 brasilia.public.temp0000240982 1 0 0 3,355 0 0 256 rio.public.temp0000290026 13 0 0 39,642 0 265 887 rio.public.temp0000292528 1 0 0 25,917 0 0 1,856 rio.public.temp0000292498 2 0 0 2,634 0 94 162 rio.public.temp0000292514 3 0 0 28,864 0 80 2,032 rio.public.tmp_drill_0320 1 1 0 347 0 0 10 rio.public.temp0000292056 13 0 0 38,256 0 298 854 rio.public.temp0000292572 1 0 0 1,521 0 33 95 rio.public.temp0000292520 1 0 0 1,460 0 40 88 rio.public.temp0000292480 1 0 0 1,310 0 49 79 brasilia.public.temp0000240942 3 0 0 10,047 0 0 768 rio.public.temp0000292546 13 0 0 123,059 0 299 8,277 rio.public.temp0000292510 4 0 0 103,600 0 0 7,424 rio.public.temp0000292522 4 0 0 103,667 0 0 7,424 rio.public.temp0000292554 1 0 0 1,520 0 35 93 rio.public.temp0000292534 2 0 0 51,837 0 0 3,712 Total 545 212 366,642 12,992,079 557,494 4,153 554,290 Pages removed per table
Key values
- public.temp0000292470 (707) Main table with removed pages on database rio
- 4153 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000292470 47 0 0 707 contagem.pg_catalog.pg_attribute 12 12 74029 434 rio.pg_catalog.pg_attribute 78 42 159736 332 rio.public.temp0000292546 13 0 0 299 rio.public.temp0000292056 13 0 0 298 rio.public.temp0000290026 13 0 0 265 rio.public.temp0000292538 8 0 0 242 rio.public.temp0000292486 10 0 0 212 rio.public.temp0000291977 5 0 0 162 brasilia.pg_catalog.pg_attribute 12 12 52824 128 contagem.pg_catalog.pg_class 5 5 2519 100 rio.public.temp0000292468 2 0 0 97 rio.public.temp0000292498 2 0 0 94 rio.public.temp0000292514 3 0 0 80 contagem.pg_catalog.pg_type 5 5 4865 54 rio.public.temp0000292476 1 0 0 49 rio.public.temp0000292466 1 0 0 49 rio.public.temp0000292480 1 0 0 49 rio.public.temp0000292502 1 0 0 47 rio.public.temp0000292520 1 0 0 40 rio.pg_catalog.pg_class 59 23 3226 40 contagem.pg_catalog.pg_depend 3 3 3623 37 rio.public.temp0000292550 1 0 0 35 rio.public.temp0000292554 1 0 0 35 rio.public.temp0000290230 3 0 0 33 rio.public.temp0000292572 1 0 0 33 brasilia.pg_catalog.pg_class 7 7 1723 29 brasilia.public.temp0000240978 3 0 0 28 contagem.public.temp0000227312 1 0 0 24 contagem.public.temp0000227314 1 0 0 21 rio.public.temp0000292500 1 0 0 20 contagem.public.temp0000227310 1 0 0 19 contagem.pg_catalog.pg_index 3 3 2366 15 brasilia.pg_toast.pg_toast_2619 2 2 217 14 brasilia.pg_catalog.pg_type 7 7 3296 13 rio.pg_catalog.pg_type 51 21 5172 12 rio.pg_catalog.pg_index 19 13 2573 7 rio.public.usuarios 29 5 642 0 brasilia.auditor.auditor_2026_09 1 0 1954 0 contagem.auditor.auditor_2026_09 1 0 0 0 rio.pg_catalog.pg_depend 10 10 9093 0 brasilia.public.temp0000240962 1 0 0 0 rio.public.temp0000292558 1 0 0 0 brasilia.public.temp0000240968 2 0 0 0 brasilia.pg_catalog.pg_shdepend 7 7 7009 0 contagem.public.usuarios 33 0 1941 0 rio.public.tmp_drill_0302 3 3 159 0 contagem.pg_catalog.pg_statistic 1 1 4164 0 brasilia.public.temp0000240954 1 0 0 0 rio.public.temp0000292432 9 0 0 0 brasilia.public.temp0000240918 1 0 0 0 brasilia.public.temp0000240976 1 0 0 0 brasilia.public.temp0000240928 1 0 0 0 brasilia.public.temp0000240982 1 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 97 0 rio.pg_catalog.pg_statistic 8 8 13264 0 brasilia.pg_catalog.pg_statistic 3 3 6431 0 rio.public.temp0000292528 1 0 0 0 rio.public.tmp_drill_0320 1 1 0 0 rio.pg_toast.pg_toast_2619 4 4 1208 0 brasilia.pg_catalog.pg_depend 4 4 1900 0 brasilia.public.temp0000240942 3 0 0 0 rio.public.temp0000292510 4 0 0 0 brasilia.pg_catalog.pg_index 5 5 1338 0 rio.public.temp0000292522 4 0 0 0 contagem.public.nf_entrada 3 3 1126 0 brasilia.public.nf_entrada 2 2 147 0 rio.public.temp0000292534 2 0 0 0 Total 545 212 366,642 4,153 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 25 00 1 0 01 0 1 02 0 0 03 0 0 04 0 8 05 6 2 06 1 3 07 55 81 08 77 129 09 41 132 10 182 130 11 38 73 12 9 20 13 29 68 14 35 88 15 25 59 16 10 27 17 32 71 18 2 5 19 0 0 20 0 0 21 2 3 22 0 0 23 0 0 - 9.39 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 5 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 18m44s 18m44s 18m44s 18m44s select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030428, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-25 10:39:08 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030428, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-25 10:39:18 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030397, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-25 07:17:26 Database: rio User: intelifix Remote: [local] Application: [unknown]
2 2 3m55s 1m34s 2m21s 1m57s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-25 08:57:38 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-25 12:16:43 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-25 07:15:09 Database: rio User: intelifix Remote: [local] Application: psql
3 1 1s155ms 1s155ms 1s155ms 1s155ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289588, 503, '176666218608', '',014,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-25 09:22:32 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (290997, 449, '921401048371,E4C0E2977666,841EA369C1D3,506F0C3B945B,C4EB42EC0101,E4C0E298E84E,B0FC88E9FB44,CC5830E237C8,841EA398095B,943C96AB7769,5447CC491523,E8D2FFA74C7D,5447CCCAA0C8,209A7DBC42CC,64FD965E6955,345D9EBD7EE7,186A81D5AC1D,C4EB42EAB0D0,48295245A1E7,841EA3886C01,209A7DBB1B28,5CFA2580B2D4,94988F306ABC,E4C0E2404202,E4C0E290CC0A,582FF797BBE7,841EA39769F8,841EA38CFA6F,ACD75BB54B44,C03C048BC6AB,94988F94CC41,20B82BF9EB0F,5CFA259BFBA7,C4EB42A03267,94988F93C30C,94988F958DC4,ACD75BB5DB2D,94988F30931F', '',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":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-25 15:24:39 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (290997, 503, '922011061236,D06DC9640243,5CFA259BF72B,D0CF0EFCC0A5,6CBAB8EB5C63,582FF796DB00,582FF716F03A,44D45493D77A,D833B73084B9,CC5830E29759,94988F95A3F1,582FF716F06B,D833B7A4408A,64FD966AC266,6CBAB8FF1463,5CFA25167E58,CC5830E29274,5447CC4A2209,5447CC493D78,5447CCCA4980,506F0C3B815A,5447CCCA251B,44D454FFCF78,CC5830E2174C,209A7DBC3C12,582FF71EB8F4,44D4546052FD,B0BBE549BBB4,94988F30ECE4,582FF79C5514,B0BBE53D4DA1,94988F307C51,44D4546058C2,F081751CCC8E,582FF78CE271,6CBAB8EA7EBD,209A7DB5801E,841EA38DD8EE,D0CF0EFDB9FE,94988F305974,D833B7CA5881', '',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":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-25 11:59:09 Database: rio User: intelifix Remote: [local] Application: [unknown]
4 1 1s2ms 1s2ms 1s2ms 1s2ms drop table if exists temp0000292470;-
DROP TABLE IF EXISTS temp0000292470;
Date: 2026-09-25 11:55:39 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000292470;
Date: 2026-09-25 10:02:38 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000292470;
Date: 2026-09-25 07:09:36 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 18m44s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030428, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-09-25 10:39:08 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 2m21s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-25 08:57:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1m34s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-25 12:16:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 1s155ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (59501, 413, '71620285850026701684,216701542236$71731085850047305055,216816648283$71711785850038200394,216750374465$71426085850005321525,216336165353$7152408787H010952567,216631031718$71501985850010802616,216410199818$71422685850004506069,184328697981$71422685850004522042,184330653650$71609285850022503156,216635786783$71819185850055710353,216867920505$71428685850006802613,216350928387$71630885850030601656,216731344549', '',062,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":""}]','$$$$$$$$$$$','', 00);[ Date: 2026-09-25 17:27:19 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
5 1s2ms DROP TABLE IF EXISTS temp0000292470;[ Date: 2026-09-25 11:55:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,345 Total read queries
- 1,029 Total write queries
Queries by database
Key values
- rio Main database
- 2,943 Requests
- 6h6m3s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 4,631 Requests
User Request type Count Duration etiquetas Total 42 11s648ms select 42 11s648ms intelifix Total 4,631 7h50m38s copy to 406 41m51s ddl 623 43m37s others 409 44m56s select 3,193 5h40m13s lenon Total 110 1m16s select 110 1m16s Duration by user
Key values
- 7h50m38s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 42 11s648ms select 42 11s648ms intelifix Total 4,631 7h50m38s copy to 406 41m51s ddl 623 43m37s others 409 44m56s select 3,193 5h40m13s lenon Total 110 1m16s select 110 1m16s Queries by host
Key values
- [local] Main host
- 4,783 Requests
- 7h52m7s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,743 Requests
- 3h36m40s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-25 17:28:32 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,392 100-500ms duration
Slowest individual queries
Rank Duration Query 1 30m35s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030428, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-09-25 10:39:08 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 18m54s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030428, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-09-25 10:39:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 11m11s analyze verbose;[ Date: 2026-09-25 05:11:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-25 07:12:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m59s analyze verbose;[ Date: 2026-09-25 05:18:11 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
6 6m11s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030397, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-25 07:17:26 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 5m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-25 11:11:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m44s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030446, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-25 12:16:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 5m39s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030431, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-25 10:41:23 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m38s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030434, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-25 11:02:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 5m37s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030405, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-25 08:29:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 5m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-25 10:10:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m35s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030427, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-25 09:44:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m31s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030417, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-25 08:57:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m31s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030465, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-25 14:37:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 5m28s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030468, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-25 14:53:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m27s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030463, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-25 14:22:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-25 20:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m23s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030408, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-25 08:42:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-25 21:10:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h15m3s 195 151ms 30m35s 41s558ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 25 07 21 13m29s 38s548ms 08 23 22m54s 59s755ms 09 43 10m30s 14s656ms 10 36 57m36s 1m36s 11 11 5m46s 31s541ms 12 3 5m49s 1m56s 13 8 32s100ms 4s12ms 14 20 17m17s 51s862ms 15 12 27s423ms 2s285ms 16 7 16s827ms 2s403ms 17 10 23s186ms 2s318ms 18 1 409ms 409ms [ User: intelifix - Total duration: 2h15m3s - Times executed: 195 ]
[ Application: [unknown] - Total duration: 2h15m3s - Times executed: 195 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030428, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-25 10:39:08 Duration: 30m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030428, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-25 10:39:18 Duration: 18m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030397, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-25 07:17:26 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h34m7s 48 2s280ms 7m47s 1m57s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 25 07 3 8m38s 2m52s 08 3 5m37s 1m52s 09 3 5m32s 1m50s 10 3 5m58s 1m59s 11 3 6m34s 2m11s 12 3 5m42s 1m54s 13 3 5m34s 1m51s 14 3 5m38s 1m52s 15 3 5m32s 1m50s 16 3 5m37s 1m52s 17 3 5m31s 1m50s 18 3 5m33s 1m51s 19 3 5m34s 1m51s 20 3 5m51s 1m57s 21 3 5m39s 1m53s 22 3 5m29s 1m49s [ User: intelifix - Total duration: 1h34m7s - Times executed: 48 ]
[ Application: psql - Total duration: 1h34m7s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-25 07:12:49 Duration: 7m47s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-25 11:11:01 Duration: 5m59s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-25 10:10:39 Duration: 5m37s Database: rio User: intelifix Remote: [local] Application: psql
3 1h5m31s 48 230ms 4m4s 1m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 25 07 3 5m18s 1m46s 08 3 3m53s 1m17s 09 3 3m50s 1m16s 10 3 4m11s 1m23s 11 3 4m55s 1m38s 12 3 4m10s 1m23s 13 3 3m55s 1m18s 14 3 4m 1m20s 15 3 3m55s 1m18s 16 3 3m47s 1m15s 17 3 3m53s 1m17s 18 3 3m51s 1m17s 19 3 3m49s 1m16s 20 3 4m8s 1m22s 21 3 3m58s 1m19s 22 3 3m52s 1m17s [ User: intelifix - Total duration: 1h5m31s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m31s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-25 11:16:16 Duration: 4m4s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-25 07:18:41 Duration: 3m57s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-25 12:14:48 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql
4 21m7s 3 2m56s 11m11s 7m2s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 25 05 3 21m7s 7m2s [ User: intelifix - Total duration: 21m7s - Times executed: 3 ]
[ Application: psql - Total duration: 21m7s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-25 05:11:12 Duration: 11m11s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-25 05:18:11 Duration: 6m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-25 05:21:08 Duration: 2m56s Database: contagem User: intelifix Remote: [local] Application: psql
5 14m53s 77 10s166ms 52s740ms 11s607ms create table temp0000292470 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 25 07 17 3m42s 13s99ms 08 13 2m23s 11s17ms 09 3 31s925ms 10s641ms 10 14 2m44s 11s733ms 11 8 1m30s 11s315ms 12 6 1m6s 11s136ms 14 16 2m54s 10s895ms [ User: intelifix - Total duration: 14m53s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 14m53s - Times executed: 77 ]
-
CREATE TABLE temp0000292470 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 07:09:09 Duration: 52s740ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292470 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 10:34:06 Duration: 18s41ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292470 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 10:54:48 Duration: 15s304ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 13m24s 1,299 151ms 5s775ms 619ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 25 07 34 17s903ms 526ms 08 132 1m4s 489ms 09 186 1m35s 514ms 10 225 1m54s 510ms 11 117 1m24s 725ms 12 28 19s911ms 711ms 13 75 48s565ms 647ms 14 212 2m25s 686ms 15 118 1m43s 875ms 16 74 55s119ms 744ms 17 74 42s272ms 571ms 18 24 12s7ms 500ms [ User: intelifix - Total duration: 13m24s - Times executed: 1299 ]
[ Application: [unknown] - Total duration: 13m24s - Times executed: 1299 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289588, 503, '176666218608', '',014,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-25 09:22:32 Duration: 5s775ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (290997, 449, '921401048371,E4C0E2977666,841EA369C1D3,506F0C3B945B,C4EB42EC0101,E4C0E298E84E,B0FC88E9FB44,CC5830E237C8,841EA398095B,943C96AB7769,5447CC491523,E8D2FFA74C7D,5447CCCAA0C8,209A7DBC42CC,64FD965E6955,345D9EBD7EE7,186A81D5AC1D,C4EB42EAB0D0,48295245A1E7,841EA3886C01,209A7DBB1B28,5CFA2580B2D4,94988F306ABC,E4C0E2404202,E4C0E290CC0A,582FF797BBE7,841EA39769F8,841EA38CFA6F,ACD75BB54B44,C03C048BC6AB,94988F94CC41,20B82BF9EB0F,5CFA259BFBA7,C4EB42A03267,94988F93C30C,94988F958DC4,ACD75BB5DB2D,94988F30931F', '',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":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-25 15:24:39 Duration: 2s874ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (290997, 503, '922011061236,D06DC9640243,5CFA259BF72B,D0CF0EFCC0A5,6CBAB8EB5C63,582FF796DB00,582FF716F03A,44D45493D77A,D833B73084B9,CC5830E29759,94988F95A3F1,582FF716F06B,D833B7A4408A,64FD966AC266,6CBAB8FF1463,5CFA25167E58,CC5830E29274,5447CC4A2209,5447CC493D78,5447CCCA4980,506F0C3B815A,5447CCCA251B,44D454FFCF78,CC5830E2174C,209A7DBC3C12,582FF71EB8F4,44D4546052FD,B0BBE549BBB4,94988F30ECE4,582FF79C5514,B0BBE53D4DA1,94988F307C51,44D4546058C2,F081751CCC8E,582FF78CE271,6CBAB8EA7EBD,209A7DB5801E,841EA38DD8EE,D0CF0EFDB9FE,94988F305974,D833B7CA5881', '',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":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-25 11:59:09 Duration: 2s871ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 11m55s 57 1s830ms 1m24s 12s547ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 25 07 2 11s418ms 5s709ms 08 3 21s922ms 7s307ms 09 2 1m29s 44s683ms 10 5 40s173ms 8s34ms 11 3 1m36s 32s284ms 12 6 13s305ms 2s217ms 13 6 1m12s 12s30ms 14 11 3m10s 17s362ms 15 9 1m31s 10s136ms 16 6 1m16s 12s703ms 17 4 11s571ms 2s892ms [ User: intelifix - Total duration: 11m55s - Times executed: 57 ]
[ Application: [unknown] - Total duration: 11m55s - Times executed: 57 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-25', 0173, '', '', 0, 6, '2026-09-01');
Date: 2026-09-25 09:45:16 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-25', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-25 11:03:44 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-25', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-25 11:51:36 Duration: 23s126ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 11m7s 148 164ms 2m25s 4s506ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 25 00 7 18s637ms 2s662ms 01 6 16s989ms 2s831ms 02 6 16s732ms 2s788ms 03 6 18s187ms 3s31ms 04 6 16s688ms 2s781ms 05 6 16s755ms 2s792ms 06 6 16s704ms 2s784ms 07 8 21s65ms 2s633ms 08 6 2m40s 26s822ms 09 6 17s696ms 2s949ms 10 8 21s229ms 2s653ms 11 6 19s84ms 3s180ms 12 8 1m53s 14s184ms 13 7 18s859ms 2s694ms 14 6 18s483ms 3s80ms 15 6 19s136ms 3s189ms 16 6 18s840ms 3s140ms 17 6 19s918ms 3s319ms 18 6 18s680ms 3s113ms 19 6 18s354ms 3s59ms 20 8 22s988ms 2s873ms 21 6 18s853ms 3s142ms 22 6 18s718ms 3s119ms [ User: intelifix - Total duration: 11m7s - Times executed: 148 ]
[ Application: psql - Total duration: 11m7s - Times executed: 148 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-25 08:57:38 Duration: 2m25s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-25 12:16:43 Duration: 1m37s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-25 07:15:09 Duration: 6s225ms Database: rio User: intelifix Remote: [local] Application: psql
9 6m22s 762 150ms 3s502ms 501ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 25 06 2 4s888ms 2s444ms 07 90 59s120ms 656ms 08 87 40s297ms 463ms 09 120 1m4s 535ms 10 119 1m8s 572ms 11 78 36s504ms 468ms 12 24 10s116ms 421ms 13 63 32s952ms 523ms 14 67 26s52ms 388ms 15 87 30s595ms 351ms 16 14 5s447ms 389ms 17 11 3s988ms 362ms [ User: intelifix - Total duration: 6m22s - Times executed: 762 ]
[ Application: [unknown] - Total duration: 6m22s - Times executed: 762 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "290731", "modelo" : "320", "itens" : "241667838501,241620543941,241663143441,241730267780,241680728401,241713058996,241669562833,241593096279,241646650519,241593859394,241671566182,241673000004,241713660325,241696803449,241713084151,241697165661,241628186067,241694859397,241695070912,241693104558,230043681536,241651068907,241603799399,241713843653,241695116572,241690553445,230040234869,241708707584,241731193741,241618196888,241654900617,241653904851,241670262632,241665406265,241607767183,241631457284,241672307881,241672824150,241637589296,241732123944,241651291836,241619300521,241675352433,241619467382,241671953044,241707112738,241710981219,241706953654", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-25 06:59:18 Duration: 3s502ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "290757", "modelo" : "320", "itens" : "241699116076,241699314861,241654522039,241631029106,241622664451,241730537582,241732861424,241631478599,241608116566,241714595555,241734134567,241651451829,241667029296,241632190522,241657657080,241651471225,241690970411,241691024557,241652896077,241676592442,241674470518,241674407884,241703568283,241657078203,241616950920,241674417380,241597923148,241619872832,241593933443,241639058902,241676497886,241651659200,241629195066,241595691617,241669177890,241655609103,241691005464,241603569298,230049303644,241619912735,241730262629,241638356678,241709078888,241628226273,241634801315,241595336475,241635751015,241614593136", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-25 07:02:57 Duration: 2s182ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "96938", "modelo" : "46", "itens" : "BC9B689B189A,70037E9B3D08,905851446304,10C25A3C0B45,90585144DCA4,10C25A3B8EE9,54A65C90C504,383FB3A467BB,D4B92F2CFD24,B42A0E1B2BC4,A456CCE43ACF,14B7F8E0D179", "usuario" : "414", "caixa" : "1121501", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-25 09:58:53 Duration: 2s40ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 6m18s 155 160ms 15s611ms 2s443ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 25 00 6 25s832ms 4s305ms 01 6 13s406ms 2s234ms 02 6 11s441ms 1s906ms 03 4 8s802ms 2s200ms 04 6 14s356ms 2s392ms 05 6 3s167ms 527ms 06 5 10s42ms 2s8ms 07 12 34s569ms 2s880ms 08 12 46s507ms 3s875ms 09 12 38s439ms 3s203ms 10 12 33s750ms 2s812ms 11 12 25s435ms 2s119ms 12 10 22s933ms 2s293ms 13 7 7s46ms 1s6ms 14 9 22s153ms 2s461ms 15 12 31s767ms 2s647ms 16 4 3s673ms 918ms 17 1 318ms 318ms 20 2 606ms 303ms 21 5 11s513ms 2s302ms 22 6 12s945ms 2s157ms [ User: intelifix - Total duration: 6m18s - Times executed: 155 ]
[ Application: psql - Total duration: 6m18s - Times executed: 155 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-25 00:05:17 Duration: 15s611ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-25 08:55:12 Duration: 11s200ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-25 08:35:10 Duration: 9s89ms Database: rio User: intelifix Remote: [local] Application: psql
11 4m3s 22 10s549ms 13s435ms 11s71ms create table temp0000292546 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 25 13 15 2m45s 11s14ms 15 7 1m18s 11s193ms [ User: intelifix - Total duration: 4m3s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 4m3s - Times executed: 22 ]
-
CREATE TABLE temp0000292546 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 15:33:28 Duration: 13s435ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292546 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 13:25:12 Duration: 12s890ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292546 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 13:34:38 Duration: 11s201ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 3m41s 44 164ms 34s681ms 5s43ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 25 07 6 47s929ms 7s988ms 08 10 41s688ms 4s168ms 09 3 23s373ms 7s791ms 10 5 1m 12s87ms 11 4 3s784ms 946ms 12 1 3s849ms 3s849ms 13 3 8s731ms 2s910ms 14 4 13s396ms 3s349ms 15 2 2s237ms 1s118ms 17 6 16s503ms 2s750ms [ User: intelifix - Total duration: 3m41s - Times executed: 44 ]
[ Application: psql - Total duration: 3m41s - Times executed: 44 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030397);
Date: 2026-09-25 07:11:21 Duration: 34s681ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030431);
Date: 2026-09-25 10:35:39 Duration: 21s373ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030429);
Date: 2026-09-25 10:02:56 Duration: 18s133ms Database: rio User: intelifix Remote: [local] Application: psql
13 3m1s 17 10s306ms 10s919ms 10s700ms create table temp0000292486 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 25 08 8 1m26s 10s752ms 09 9 1m35s 10s655ms [ User: intelifix - Total duration: 3m1s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m1s - Times executed: 17 ]
-
CREATE TABLE temp0000292486 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 08:35:07 Duration: 10s919ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292486 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 08:40:17 Duration: 10s912ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292486 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 09:15:44 Duration: 10s870ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 2m31s 39 151ms 1m6s 3s882ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 25 07 8 4s974ms 621ms 08 10 10s605ms 1s60ms 09 3 2s968ms 989ms 10 7 2m10s 18s575ms 11 4 770ms 192ms 12 2 558ms 279ms 14 4 1s221ms 305ms 15 1 288ms 288ms [ User: intelifix - Total duration: 2m31s - Times executed: 39 ]
[ Application: psql - Total duration: 2m31s - Times executed: 39 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030428);
Date: 2026-09-25 10:01:59 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030432);
Date: 2026-09-25 10:40:56 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030416);
Date: 2026-09-25 08:50:36 Duration: 2s600ms Database: rio User: intelifix Remote: [local] Application: psql
15 2m17s 4 4s926ms 1m4s 34s340ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 25 20 2 1m9s 34s943ms 23 2 1m7s 33s736ms [ User: intelifix - Total duration: 2m17s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m17s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-25 20:08:44 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-25 23:16:37 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-25 20:10:47 Duration: 5s109ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1m58s 36 699ms 15s823ms 3s297ms 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 25 08 2 21s694ms 10s847ms 09 3 18s245ms 6s81ms 10 2 7s755ms 3s877ms 11 3 16s566ms 5s522ms 12 2 1s664ms 832ms 13 2 5s94ms 2s547ms 14 3 16s33ms 5s344ms 15 2 11s317ms 5s658ms 16 2 6s727ms 3s363ms 17 2 1s460ms 730ms 18 2 1s700ms 850ms 19 2 1s594ms 797ms 20 3 3s704ms 1s234ms 21 3 2s472ms 824ms 22 3 2s695ms 898ms [ User: intelifix - Total duration: 1m58s - Times executed: 36 ]
[ Application: psql - Total duration: 1m58s - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-25 08:00:17 Duration: 15s823ms 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-25 14:00:09 Duration: 8s331ms 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-25 11:20:09 Duration: 7s267ms Database: rio User: intelifix Remote: [local] Application: psql
17 1m54s 10 10s420ms 17s538ms 11s457ms create table temp0000292538 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 25 11 10 1m54s 11s457ms [ User: intelifix - Total duration: 1m54s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1m54s - Times executed: 10 ]
-
CREATE TABLE temp0000292538 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 11:36:45 Duration: 17s538ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292538 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 11:40:21 Duration: 11s174ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292538 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 11:49:41 Duration: 11s36ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 1m50s 30 2s978ms 4s756ms 3s670ms create table temp0000292470 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 25 07 5 15s607ms 3s121ms 08 6 20s76ms 3s346ms 10 9 33s515ms 3s723ms 11 7 28s667ms 4s95ms 12 1 3s848ms 3s848ms 14 2 8s391ms 4s195ms [ User: intelifix - Total duration: 1m50s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 1m50s - Times executed: 30 ]
-
CREATE TABLE temp0000292470 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-09-2026", "ate" :"25-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-25 11:05:14 Duration: 4s756ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292470 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-09-2026", "ate" :"25-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-25 14:23:28 Duration: 4s458ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292470 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"20-09-2026", "ate" :"25-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-25 11:05:29 Duration: 4s311ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 1m47s 6 3s157ms 40s190ms 17s878ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 25 20 3 54s4ms 18s1ms 23 3 53s267ms 17s755ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-25 20:06:28 Duration: 40s190ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-25 23:14:24 Duration: 39s456ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-25 23:33:30 Duration: 10s653ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 1m46s 4 371ms 53s520ms 26s659ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 25 20 2 53s903ms 26s951ms 23 2 52s734ms 26s367ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-25 20:05:47 Duration: 53s520ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-25 23:13:43 Duration: 52s363ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-25 20:10:10 Duration: 382ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,299 13m24s 151ms 5s775ms 619ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 25 07 34 17s903ms 526ms 08 132 1m4s 489ms 09 186 1m35s 514ms 10 225 1m54s 510ms 11 117 1m24s 725ms 12 28 19s911ms 711ms 13 75 48s565ms 647ms 14 212 2m25s 686ms 15 118 1m43s 875ms 16 74 55s119ms 744ms 17 74 42s272ms 571ms 18 24 12s7ms 500ms [ User: intelifix - Total duration: 13m24s - Times executed: 1299 ]
[ Application: [unknown] - Total duration: 13m24s - Times executed: 1299 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289588, 503, '176666218608', '',014,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-25 09:22:32 Duration: 5s775ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (290997, 449, '921401048371,E4C0E2977666,841EA369C1D3,506F0C3B945B,C4EB42EC0101,E4C0E298E84E,B0FC88E9FB44,CC5830E237C8,841EA398095B,943C96AB7769,5447CC491523,E8D2FFA74C7D,5447CCCAA0C8,209A7DBC42CC,64FD965E6955,345D9EBD7EE7,186A81D5AC1D,C4EB42EAB0D0,48295245A1E7,841EA3886C01,209A7DBB1B28,5CFA2580B2D4,94988F306ABC,E4C0E2404202,E4C0E290CC0A,582FF797BBE7,841EA39769F8,841EA38CFA6F,ACD75BB54B44,C03C048BC6AB,94988F94CC41,20B82BF9EB0F,5CFA259BFBA7,C4EB42A03267,94988F93C30C,94988F958DC4,ACD75BB5DB2D,94988F30931F', '',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":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-25 15:24:39 Duration: 2s874ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (290997, 503, '922011061236,D06DC9640243,5CFA259BF72B,D0CF0EFCC0A5,6CBAB8EB5C63,582FF796DB00,582FF716F03A,44D45493D77A,D833B73084B9,CC5830E29759,94988F95A3F1,582FF716F06B,D833B7A4408A,64FD966AC266,6CBAB8FF1463,5CFA25167E58,CC5830E29274,5447CC4A2209,5447CC493D78,5447CCCA4980,506F0C3B815A,5447CCCA251B,44D454FFCF78,CC5830E2174C,209A7DBC3C12,582FF71EB8F4,44D4546052FD,B0BBE549BBB4,94988F30ECE4,582FF79C5514,B0BBE53D4DA1,94988F307C51,44D4546058C2,F081751CCC8E,582FF78CE271,6CBAB8EA7EBD,209A7DB5801E,841EA38DD8EE,D0CF0EFDB9FE,94988F305974,D833B7CA5881', '',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":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-25 11:59:09 Duration: 2s871ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 762 6m22s 150ms 3s502ms 501ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 25 06 2 4s888ms 2s444ms 07 90 59s120ms 656ms 08 87 40s297ms 463ms 09 120 1m4s 535ms 10 119 1m8s 572ms 11 78 36s504ms 468ms 12 24 10s116ms 421ms 13 63 32s952ms 523ms 14 67 26s52ms 388ms 15 87 30s595ms 351ms 16 14 5s447ms 389ms 17 11 3s988ms 362ms [ User: intelifix - Total duration: 6m22s - Times executed: 762 ]
[ Application: [unknown] - Total duration: 6m22s - Times executed: 762 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "290731", "modelo" : "320", "itens" : "241667838501,241620543941,241663143441,241730267780,241680728401,241713058996,241669562833,241593096279,241646650519,241593859394,241671566182,241673000004,241713660325,241696803449,241713084151,241697165661,241628186067,241694859397,241695070912,241693104558,230043681536,241651068907,241603799399,241713843653,241695116572,241690553445,230040234869,241708707584,241731193741,241618196888,241654900617,241653904851,241670262632,241665406265,241607767183,241631457284,241672307881,241672824150,241637589296,241732123944,241651291836,241619300521,241675352433,241619467382,241671953044,241707112738,241710981219,241706953654", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-25 06:59:18 Duration: 3s502ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "290757", "modelo" : "320", "itens" : "241699116076,241699314861,241654522039,241631029106,241622664451,241730537582,241732861424,241631478599,241608116566,241714595555,241734134567,241651451829,241667029296,241632190522,241657657080,241651471225,241690970411,241691024557,241652896077,241676592442,241674470518,241674407884,241703568283,241657078203,241616950920,241674417380,241597923148,241619872832,241593933443,241639058902,241676497886,241651659200,241629195066,241595691617,241669177890,241655609103,241691005464,241603569298,230049303644,241619912735,241730262629,241638356678,241709078888,241628226273,241634801315,241595336475,241635751015,241614593136", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-25 07:02:57 Duration: 2s182ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "96938", "modelo" : "46", "itens" : "BC9B689B189A,70037E9B3D08,905851446304,10C25A3C0B45,90585144DCA4,10C25A3B8EE9,54A65C90C504,383FB3A467BB,D4B92F2CFD24,B42A0E1B2BC4,A456CCE43ACF,14B7F8E0D179", "usuario" : "414", "caixa" : "1121501", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-25 09:58:53 Duration: 2s40ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 195 2h15m3s 151ms 30m35s 41s558ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 25 07 21 13m29s 38s548ms 08 23 22m54s 59s755ms 09 43 10m30s 14s656ms 10 36 57m36s 1m36s 11 11 5m46s 31s541ms 12 3 5m49s 1m56s 13 8 32s100ms 4s12ms 14 20 17m17s 51s862ms 15 12 27s423ms 2s285ms 16 7 16s827ms 2s403ms 17 10 23s186ms 2s318ms 18 1 409ms 409ms [ User: intelifix - Total duration: 2h15m3s - Times executed: 195 ]
[ Application: [unknown] - Total duration: 2h15m3s - Times executed: 195 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030428, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-25 10:39:08 Duration: 30m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030428, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-25 10:39:18 Duration: 18m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030397, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-25 07:17:26 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 155 6m18s 160ms 15s611ms 2s443ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 25 00 6 25s832ms 4s305ms 01 6 13s406ms 2s234ms 02 6 11s441ms 1s906ms 03 4 8s802ms 2s200ms 04 6 14s356ms 2s392ms 05 6 3s167ms 527ms 06 5 10s42ms 2s8ms 07 12 34s569ms 2s880ms 08 12 46s507ms 3s875ms 09 12 38s439ms 3s203ms 10 12 33s750ms 2s812ms 11 12 25s435ms 2s119ms 12 10 22s933ms 2s293ms 13 7 7s46ms 1s6ms 14 9 22s153ms 2s461ms 15 12 31s767ms 2s647ms 16 4 3s673ms 918ms 17 1 318ms 318ms 20 2 606ms 303ms 21 5 11s513ms 2s302ms 22 6 12s945ms 2s157ms [ User: intelifix - Total duration: 6m18s - Times executed: 155 ]
[ Application: psql - Total duration: 6m18s - Times executed: 155 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-25 00:05:17 Duration: 15s611ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-25 08:55:12 Duration: 11s200ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-25 08:35:10 Duration: 9s89ms Database: rio User: intelifix Remote: [local] Application: psql
5 148 11m7s 164ms 2m25s 4s506ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 25 00 7 18s637ms 2s662ms 01 6 16s989ms 2s831ms 02 6 16s732ms 2s788ms 03 6 18s187ms 3s31ms 04 6 16s688ms 2s781ms 05 6 16s755ms 2s792ms 06 6 16s704ms 2s784ms 07 8 21s65ms 2s633ms 08 6 2m40s 26s822ms 09 6 17s696ms 2s949ms 10 8 21s229ms 2s653ms 11 6 19s84ms 3s180ms 12 8 1m53s 14s184ms 13 7 18s859ms 2s694ms 14 6 18s483ms 3s80ms 15 6 19s136ms 3s189ms 16 6 18s840ms 3s140ms 17 6 19s918ms 3s319ms 18 6 18s680ms 3s113ms 19 6 18s354ms 3s59ms 20 8 22s988ms 2s873ms 21 6 18s853ms 3s142ms 22 6 18s718ms 3s119ms [ User: intelifix - Total duration: 11m7s - Times executed: 148 ]
[ Application: psql - Total duration: 11m7s - Times executed: 148 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-25 08:57:38 Duration: 2m25s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-25 12:16:43 Duration: 1m37s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-25 07:15:09 Duration: 6s225ms Database: rio User: intelifix Remote: [local] Application: psql
6 104 32s580ms 297ms 371ms 313ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 25 01 2 600ms 300ms 03 1 304ms 304ms 04 3 916ms 305ms 05 1 302ms 302ms 06 3 895ms 298ms 07 11 3s433ms 312ms 08 10 3s113ms 311ms 09 10 3s277ms 327ms 10 10 3s117ms 311ms 11 8 2s534ms 316ms 12 6 1s948ms 324ms 13 7 2s262ms 323ms 14 10 3s103ms 310ms 15 7 2s146ms 306ms 16 9 2s798ms 310ms 17 3 912ms 304ms 18 2 605ms 302ms 21 1 307ms 307ms [ User: lenon - Total duration: 32s580ms - Times executed: 104 ]
[ Application: [unknown] - Total duration: 32s580ms - 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-25 09:39:53 Duration: 371ms 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-25 12:11:27 Duration: 359ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-25 09:27:00 Duration: 358ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
7 92 35s59ms 328ms 646ms 381ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 25 01 2 720ms 360ms 03 1 515ms 515ms 04 3 1s74ms 358ms 06 2 677ms 338ms 07 8 2s896ms 362ms 08 10 3s843ms 384ms 09 10 3s858ms 385ms 10 10 4s418ms 441ms 11 7 2s634ms 376ms 12 6 2s249ms 374ms 13 6 2s488ms 414ms 14 10 3s591ms 359ms 15 6 2s171ms 361ms 16 7 2s516ms 359ms 17 2 676ms 338ms 18 2 725ms 362ms [ User: intelifix - Total duration: 35s59ms - Times executed: 92 ]
[ Application: [unknown] - Total duration: 35s59ms - Times executed: 92 ]
-
select * from rs_menu_grants (449, 81, 1);
Date: 2026-09-25 10:07:09 Duration: 646ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (416, 19, 1);
Date: 2026-09-25 13:13:16 Duration: 584ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (304, 18, 1);
Date: 2026-09-25 09:27:00 Duration: 537ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 86 25s50ms 255ms 1s581ms 291ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 25 07 8 2s199ms 274ms 08 19 5s188ms 273ms 09 8 2s245ms 280ms 10 10 4s69ms 406ms 11 7 2s10ms 287ms 12 3 839ms 279ms 13 2 554ms 277ms 14 6 1s654ms 275ms 15 7 2s15ms 287ms 16 3 810ms 270ms 17 12 3s204ms 267ms 18 1 257ms 257ms [ User: intelifix - Total duration: 25s50ms - Times executed: 86 ]
[ Application: [unknown] - Total duration: 25s50ms - Times executed: 86 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-25 10:32:55 Duration: 1s581ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-25 15:08:42 Duration: 364ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-25 11:05:40 Duration: 345ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
9 83 1m23s 153ms 6s455ms 1s7ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 25 07 14 4s208ms 300ms 08 4 7s152ms 1s788ms 09 27 53s585ms 1s984ms 10 9 5s399ms 599ms 11 3 1s244ms 414ms 13 3 2s151ms 717ms 14 8 3s904ms 488ms 15 14 5s97ms 364ms 16 1 880ms 880ms [ User: intelifix - Total duration: 1m23s - Times executed: 83 ]
[ Application: [unknown] - Total duration: 1m23s - Times executed: 83 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059277) LIMIT 1;
Date: 2026-09-25 08:21:17 Duration: 6s455ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0133893) LIMIT 1;
Date: 2026-09-25 09:25:08 Duration: 6s117ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0135624) LIMIT 1;
Date: 2026-09-25 09:11:02 Duration: 4s559ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
10 77 14m53s 10s166ms 52s740ms 11s607ms create table temp0000292470 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 25 07 17 3m42s 13s99ms 08 13 2m23s 11s17ms 09 3 31s925ms 10s641ms 10 14 2m44s 11s733ms 11 8 1m30s 11s315ms 12 6 1m6s 11s136ms 14 16 2m54s 10s895ms [ User: intelifix - Total duration: 14m53s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 14m53s - Times executed: 77 ]
-
CREATE TABLE temp0000292470 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 07:09:09 Duration: 52s740ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292470 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 10:34:06 Duration: 18s41ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292470 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 10:54:48 Duration: 15s304ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 75 27s178ms 151ms 1s14ms 362ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 25 08 6 3s615ms 602ms 09 24 9s576ms 399ms 10 9 2s622ms 291ms 11 17 5s558ms 326ms 12 8 2s650ms 331ms 14 7 1s692ms 241ms 16 4 1s462ms 365ms [ User: intelifix - Total duration: 27s178ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 27s178ms - Times executed: 75 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '921451055928,923461088764,922481048343,841EA3971E25,506F0C3D4305,5CFA25807FC7,20B82BF9390D,921141103540,943C96ABDCCD,D833B71F8C48', '138;1', 'DEFAULT', 09, 0155, '','', '', 00);
Date: 2026-09-25 08:36:07 Duration: 1s14ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'F09BB8C4EEFA,BC76C5B475F9,CCB1828108B1,04E7959885C3,A4178B00A302,BC76C5B486E8,88892FFEAB11,20AB48C2832E,F09BB8C4F180,482CD08F91FE,30C50FB5AE96,A4178B023491,F82E3F771A4F,C40D96B10606,30C50FB5B5E4,482CD08E199D', '138;1', 'DEFAULT', 09, 0189, '','', '', 00);
Date: 2026-09-25 08:46:34 Duration: 870ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '3CF9F06FB685,D83139969A64,48D6822EDE4E,D89A0D84E3C7,D89A0DACD335,D831399679FA,843C992F155D,3CF9F0A56A9C,843C99329A4D,14CA56D5156B,843C992228A5,C4EBFF89EC0E,5872C98AF33B,D8313924243C,D831399B521A', '','DEFAULT',09,0323,'', '','', 00);
Date: 2026-09-25 11:27:22 Duration: 774ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
12 57 11m55s 1s830ms 1m24s 12s547ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 25 07 2 11s418ms 5s709ms 08 3 21s922ms 7s307ms 09 2 1m29s 44s683ms 10 5 40s173ms 8s34ms 11 3 1m36s 32s284ms 12 6 13s305ms 2s217ms 13 6 1m12s 12s30ms 14 11 3m10s 17s362ms 15 9 1m31s 10s136ms 16 6 1m16s 12s703ms 17 4 11s571ms 2s892ms [ User: intelifix - Total duration: 11m55s - Times executed: 57 ]
[ Application: [unknown] - Total duration: 11m55s - Times executed: 57 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-25', 0173, '', '', 0, 6, '2026-09-01');
Date: 2026-09-25 09:45:16 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-25', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-25 11:03:44 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-25', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-25 11:51:36 Duration: 23s126ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 55 12s274ms 152ms 391ms 223ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 25 01 17 3s979ms 234ms 04 16 3s305ms 206ms 07 3 588ms 196ms 08 4 1s59ms 264ms 09 3 717ms 239ms 10 3 672ms 224ms 11 3 549ms 183ms 12 3 643ms 214ms 14 1 211ms 211ms 15 1 225ms 225ms 16 1 321ms 321ms [ User: intelifix - Total duration: 12s274ms - Times executed: 55 ]
[ Application: [unknown] - Total duration: 12s274ms - Times executed: 55 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241636081025,241631250419,241647341933,241629197995,241598086474,241661099100,241703714359,241637701430,241668288702,241783797999,241661145367,241618166683,241654291433', NULL, NULL, 0320, 00);
Date: 2026-09-25 01:26:52 Duration: 391ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (410, 5, '113', 3, '241695087175,241726930520,241653954452,241596579717,241703810609,241658192543,241694773352,241603276060,241607327488,241637645060', NULL, NULL, 0320, 00);
Date: 2026-09-25 08:53:31 Duration: 366ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241703732139,241593963547,241691833940,241707292127,241654917991,241601683739,241708378507,241676540417,241669562833,241713058996,241697165661,241713084151,241696803449,241713660325,241673000004', NULL, NULL, 0320, 00);
Date: 2026-09-25 01:34:21 Duration: 364ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 50 1m23s 566ms 22s526ms 1s674ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 25 08 4 6s485ms 1s621ms 09 3 2s300ms 766ms 10 3 9s467ms 3s155ms 11 2 1s429ms 714ms 12 3 4s654ms 1s551ms 13 4 3s101ms 775ms 14 3 2s330ms 776ms 15 4 7s437ms 1s859ms 16 4 7s320ms 1s830ms 17 3 23s893ms 7s964ms 18 4 3s416ms 854ms 19 4 3s919ms 979ms 20 3 3s254ms 1s84ms 21 3 2s327ms 775ms 22 3 2s366ms 788ms [ User: intelifix - Total duration: 1m23s - Times executed: 50 ]
[ Application: psql - Total duration: 1m23s - Times executed: 50 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-25 17:40:25 Duration: 22s526ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-25 15:20:06 Duration: 5s326ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-25 10:20:08 Duration: 4s947ms Database: brasilia User: intelifix Remote: [local] Application: psql
15 48 1h34m7s 2s280ms 7m47s 1m57s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 25 07 3 8m38s 2m52s 08 3 5m37s 1m52s 09 3 5m32s 1m50s 10 3 5m58s 1m59s 11 3 6m34s 2m11s 12 3 5m42s 1m54s 13 3 5m34s 1m51s 14 3 5m38s 1m52s 15 3 5m32s 1m50s 16 3 5m37s 1m52s 17 3 5m31s 1m50s 18 3 5m33s 1m51s 19 3 5m34s 1m51s 20 3 5m51s 1m57s 21 3 5m39s 1m53s 22 3 5m29s 1m49s [ User: intelifix - Total duration: 1h34m7s - Times executed: 48 ]
[ Application: psql - Total duration: 1h34m7s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-25 07:12:49 Duration: 7m47s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-25 11:11:01 Duration: 5m59s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-25 10:10:39 Duration: 5m37s Database: rio User: intelifix Remote: [local] Application: psql
16 48 1h5m31s 230ms 4m4s 1m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 25 07 3 5m18s 1m46s 08 3 3m53s 1m17s 09 3 3m50s 1m16s 10 3 4m11s 1m23s 11 3 4m55s 1m38s 12 3 4m10s 1m23s 13 3 3m55s 1m18s 14 3 4m 1m20s 15 3 3m55s 1m18s 16 3 3m47s 1m15s 17 3 3m53s 1m17s 18 3 3m51s 1m17s 19 3 3m49s 1m16s 20 3 4m8s 1m22s 21 3 3m58s 1m19s 22 3 3m52s 1m17s [ User: intelifix - Total duration: 1h5m31s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m31s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-25 11:16:16 Duration: 4m4s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-25 07:18:41 Duration: 3m57s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-25 12:14:48 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql
17 44 3m41s 164ms 34s681ms 5s43ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 25 07 6 47s929ms 7s988ms 08 10 41s688ms 4s168ms 09 3 23s373ms 7s791ms 10 5 1m 12s87ms 11 4 3s784ms 946ms 12 1 3s849ms 3s849ms 13 3 8s731ms 2s910ms 14 4 13s396ms 3s349ms 15 2 2s237ms 1s118ms 17 6 16s503ms 2s750ms [ User: intelifix - Total duration: 3m41s - Times executed: 44 ]
[ Application: psql - Total duration: 3m41s - Times executed: 44 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030397);
Date: 2026-09-25 07:11:21 Duration: 34s681ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030431);
Date: 2026-09-25 10:35:39 Duration: 21s373ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030429);
Date: 2026-09-25 10:02:56 Duration: 18s133ms Database: rio User: intelifix Remote: [local] Application: psql
18 39 2m31s 151ms 1m6s 3s882ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 25 07 8 4s974ms 621ms 08 10 10s605ms 1s60ms 09 3 2s968ms 989ms 10 7 2m10s 18s575ms 11 4 770ms 192ms 12 2 558ms 279ms 14 4 1s221ms 305ms 15 1 288ms 288ms [ User: intelifix - Total duration: 2m31s - Times executed: 39 ]
[ Application: psql - Total duration: 2m31s - Times executed: 39 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030428);
Date: 2026-09-25 10:01:59 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030432);
Date: 2026-09-25 10:40:56 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030416);
Date: 2026-09-25 08:50:36 Duration: 2s600ms Database: rio User: intelifix Remote: [local] Application: psql
19 39 11s902ms 150ms 2s503ms 305ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 25 00 1 615ms 615ms 01 4 756ms 189ms 04 7 1s431ms 204ms 08 3 515ms 171ms 09 2 798ms 399ms 10 6 2s297ms 382ms 11 8 1s716ms 214ms 12 2 349ms 174ms 13 1 157ms 157ms 14 3 496ms 165ms 21 1 263ms 263ms 23 1 2s503ms 2s503ms [ User: intelifix - Total duration: 11s902ms - Times executed: 39 ]
[ Application: [unknown] - Total duration: 11s902ms - Times executed: 39 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('241658478484');
Date: 2026-09-25 23:39:01 Duration: 2s503ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229913413547');
Date: 2026-09-25 10:56:32 Duration: 1s35ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229977081018');
Date: 2026-09-25 09:45:18 Duration: 642ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 36 1m58s 699ms 15s823ms 3s297ms 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 25 08 2 21s694ms 10s847ms 09 3 18s245ms 6s81ms 10 2 7s755ms 3s877ms 11 3 16s566ms 5s522ms 12 2 1s664ms 832ms 13 2 5s94ms 2s547ms 14 3 16s33ms 5s344ms 15 2 11s317ms 5s658ms 16 2 6s727ms 3s363ms 17 2 1s460ms 730ms 18 2 1s700ms 850ms 19 2 1s594ms 797ms 20 3 3s704ms 1s234ms 21 3 2s472ms 824ms 22 3 2s695ms 898ms [ User: intelifix - Total duration: 1m58s - Times executed: 36 ]
[ Application: psql - Total duration: 1m58s - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-25 08:00:17 Duration: 15s823ms 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-25 14:00:09 Duration: 8s331ms 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-25 11:20:09 Duration: 7s267ms 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 2m56s 11m11s 7m2s 3 21m7s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 25 05 3 21m7s 7m2s [ User: intelifix - Total duration: 21m7s - Times executed: 3 ]
[ Application: psql - Total duration: 21m7s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-25 05:11:12 Duration: 11m11s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-25 05:18:11 Duration: 6m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-25 05:21:08 Duration: 2m56s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s280ms 7m47s 1m57s 48 1h34m7s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 25 07 3 8m38s 2m52s 08 3 5m37s 1m52s 09 3 5m32s 1m50s 10 3 5m58s 1m59s 11 3 6m34s 2m11s 12 3 5m42s 1m54s 13 3 5m34s 1m51s 14 3 5m38s 1m52s 15 3 5m32s 1m50s 16 3 5m37s 1m52s 17 3 5m31s 1m50s 18 3 5m33s 1m51s 19 3 5m34s 1m51s 20 3 5m51s 1m57s 21 3 5m39s 1m53s 22 3 5m29s 1m49s [ User: intelifix - Total duration: 1h34m7s - Times executed: 48 ]
[ Application: psql - Total duration: 1h34m7s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-25 07:12:49 Duration: 7m47s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-25 11:11:01 Duration: 5m59s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-25 10:10:39 Duration: 5m37s Database: rio User: intelifix Remote: [local] Application: psql
3 230ms 4m4s 1m21s 48 1h5m31s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 25 07 3 5m18s 1m46s 08 3 3m53s 1m17s 09 3 3m50s 1m16s 10 3 4m11s 1m23s 11 3 4m55s 1m38s 12 3 4m10s 1m23s 13 3 3m55s 1m18s 14 3 4m 1m20s 15 3 3m55s 1m18s 16 3 3m47s 1m15s 17 3 3m53s 1m17s 18 3 3m51s 1m17s 19 3 3m49s 1m16s 20 3 4m8s 1m22s 21 3 3m58s 1m19s 22 3 3m52s 1m17s [ User: intelifix - Total duration: 1h5m31s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m31s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-25 11:16:16 Duration: 4m4s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-25 07:18:41 Duration: 3m57s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-25 12:14:48 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql
4 151ms 30m35s 41s558ms 195 2h15m3s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 25 07 21 13m29s 38s548ms 08 23 22m54s 59s755ms 09 43 10m30s 14s656ms 10 36 57m36s 1m36s 11 11 5m46s 31s541ms 12 3 5m49s 1m56s 13 8 32s100ms 4s12ms 14 20 17m17s 51s862ms 15 12 27s423ms 2s285ms 16 7 16s827ms 2s403ms 17 10 23s186ms 2s318ms 18 1 409ms 409ms [ User: intelifix - Total duration: 2h15m3s - Times executed: 195 ]
[ Application: [unknown] - Total duration: 2h15m3s - Times executed: 195 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030428, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-25 10:39:08 Duration: 30m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030428, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-25 10:39:18 Duration: 18m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030397, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-25 07:17:26 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 4s926ms 1m4s 34s340ms 4 2m17s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 25 20 2 1m9s 34s943ms 23 2 1m7s 33s736ms [ User: intelifix - Total duration: 2m17s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m17s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-25 20:08:44 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-25 23:16:37 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-25 20:10:47 Duration: 5s109ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 371ms 53s520ms 26s659ms 4 1m46s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 25 20 2 53s903ms 26s951ms 23 2 52s734ms 26s367ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-25 20:05:47 Duration: 53s520ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-25 23:13:43 Duration: 52s363ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-25 20:10:10 Duration: 382ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 3s157ms 40s190ms 17s878ms 6 1m47s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 25 20 3 54s4ms 18s1ms 23 3 53s267ms 17s755ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-25 20:06:28 Duration: 40s190ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-25 23:14:24 Duration: 39s456ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-25 23:33:30 Duration: 10s653ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1s830ms 1m24s 12s547ms 57 11m55s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 25 07 2 11s418ms 5s709ms 08 3 21s922ms 7s307ms 09 2 1m29s 44s683ms 10 5 40s173ms 8s34ms 11 3 1m36s 32s284ms 12 6 13s305ms 2s217ms 13 6 1m12s 12s30ms 14 11 3m10s 17s362ms 15 9 1m31s 10s136ms 16 6 1m16s 12s703ms 17 4 11s571ms 2s892ms [ User: intelifix - Total duration: 11m55s - Times executed: 57 ]
[ Application: [unknown] - Total duration: 11m55s - Times executed: 57 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-25', 0173, '', '', 0, 6, '2026-09-01');
Date: 2026-09-25 09:45:16 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-25', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-25 11:03:44 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-25', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-25 11:51:36 Duration: 23s126ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s166ms 52s740ms 11s607ms 77 14m53s create table temp0000292470 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 25 07 17 3m42s 13s99ms 08 13 2m23s 11s17ms 09 3 31s925ms 10s641ms 10 14 2m44s 11s733ms 11 8 1m30s 11s315ms 12 6 1m6s 11s136ms 14 16 2m54s 10s895ms [ User: intelifix - Total duration: 14m53s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 14m53s - Times executed: 77 ]
-
CREATE TABLE temp0000292470 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 07:09:09 Duration: 52s740ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292470 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 10:34:06 Duration: 18s41ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292470 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 10:54:48 Duration: 15s304ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s420ms 17s538ms 11s457ms 10 1m54s create table temp0000292538 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 25 11 10 1m54s 11s457ms [ User: intelifix - Total duration: 1m54s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1m54s - Times executed: 10 ]
-
CREATE TABLE temp0000292538 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 11:36:45 Duration: 17s538ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292538 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 11:40:21 Duration: 11s174ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292538 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 11:49:41 Duration: 11s36ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s549ms 13s435ms 11s71ms 22 4m3s create table temp0000292546 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 25 13 15 2m45s 11s14ms 15 7 1m18s 11s193ms [ User: intelifix - Total duration: 4m3s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 4m3s - Times executed: 22 ]
-
CREATE TABLE temp0000292546 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 15:33:28 Duration: 13s435ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292546 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 13:25:12 Duration: 12s890ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292546 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 13:34:38 Duration: 11s201ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 10s306ms 10s919ms 10s700ms 17 3m1s create table temp0000292486 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 25 08 8 1m26s 10s752ms 09 9 1m35s 10s655ms [ User: intelifix - Total duration: 3m1s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m1s - Times executed: 17 ]
-
CREATE TABLE temp0000292486 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 08:35:07 Duration: 10s919ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292486 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 08:40:17 Duration: 10s912ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292486 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-25 09:15:44 Duration: 10s870ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 164ms 34s681ms 5s43ms 44 3m41s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 25 07 6 47s929ms 7s988ms 08 10 41s688ms 4s168ms 09 3 23s373ms 7s791ms 10 5 1m 12s87ms 11 4 3s784ms 946ms 12 1 3s849ms 3s849ms 13 3 8s731ms 2s910ms 14 4 13s396ms 3s349ms 15 2 2s237ms 1s118ms 17 6 16s503ms 2s750ms [ User: intelifix - Total duration: 3m41s - Times executed: 44 ]
[ Application: psql - Total duration: 3m41s - Times executed: 44 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030397);
Date: 2026-09-25 07:11:21 Duration: 34s681ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030431);
Date: 2026-09-25 10:35:39 Duration: 21s373ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030429);
Date: 2026-09-25 10:02:56 Duration: 18s133ms Database: rio User: intelifix Remote: [local] Application: psql
14 164ms 2m25s 4s506ms 148 11m7s call rs_giga_triagem (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 25 00 7 18s637ms 2s662ms 01 6 16s989ms 2s831ms 02 6 16s732ms 2s788ms 03 6 18s187ms 3s31ms 04 6 16s688ms 2s781ms 05 6 16s755ms 2s792ms 06 6 16s704ms 2s784ms 07 8 21s65ms 2s633ms 08 6 2m40s 26s822ms 09 6 17s696ms 2s949ms 10 8 21s229ms 2s653ms 11 6 19s84ms 3s180ms 12 8 1m53s 14s184ms 13 7 18s859ms 2s694ms 14 6 18s483ms 3s80ms 15 6 19s136ms 3s189ms 16 6 18s840ms 3s140ms 17 6 19s918ms 3s319ms 18 6 18s680ms 3s113ms 19 6 18s354ms 3s59ms 20 8 22s988ms 2s873ms 21 6 18s853ms 3s142ms 22 6 18s718ms 3s119ms [ User: intelifix - Total duration: 11m7s - Times executed: 148 ]
[ Application: psql - Total duration: 11m7s - Times executed: 148 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-25 08:57:38 Duration: 2m25s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-25 12:16:43 Duration: 1m37s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-25 07:15:09 Duration: 6s225ms Database: rio User: intelifix Remote: [local] Application: psql
15 151ms 1m6s 3s882ms 39 2m31s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 25 07 8 4s974ms 621ms 08 10 10s605ms 1s60ms 09 3 2s968ms 989ms 10 7 2m10s 18s575ms 11 4 770ms 192ms 12 2 558ms 279ms 14 4 1s221ms 305ms 15 1 288ms 288ms [ User: intelifix - Total duration: 2m31s - Times executed: 39 ]
[ Application: psql - Total duration: 2m31s - Times executed: 39 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030428);
Date: 2026-09-25 10:01:59 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030432);
Date: 2026-09-25 10:40:56 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030416);
Date: 2026-09-25 08:50:36 Duration: 2s600ms Database: rio User: intelifix Remote: [local] Application: psql
16 2s978ms 4s756ms 3s670ms 30 1m50s create table temp0000292470 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 25 07 5 15s607ms 3s121ms 08 6 20s76ms 3s346ms 10 9 33s515ms 3s723ms 11 7 28s667ms 4s95ms 12 1 3s848ms 3s848ms 14 2 8s391ms 4s195ms [ User: intelifix - Total duration: 1m50s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 1m50s - Times executed: 30 ]
-
CREATE TABLE temp0000292470 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-09-2026", "ate" :"25-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-25 11:05:14 Duration: 4s756ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292470 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-09-2026", "ate" :"25-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-25 14:23:28 Duration: 4s458ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292470 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"20-09-2026", "ate" :"25-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-25 11:05:29 Duration: 4s311ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 699ms 15s823ms 3s297ms 36 1m58s 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 #17
Day Hour Count Duration Avg duration Sep 25 08 2 21s694ms 10s847ms 09 3 18s245ms 6s81ms 10 2 7s755ms 3s877ms 11 3 16s566ms 5s522ms 12 2 1s664ms 832ms 13 2 5s94ms 2s547ms 14 3 16s33ms 5s344ms 15 2 11s317ms 5s658ms 16 2 6s727ms 3s363ms 17 2 1s460ms 730ms 18 2 1s700ms 850ms 19 2 1s594ms 797ms 20 3 3s704ms 1s234ms 21 3 2s472ms 824ms 22 3 2s695ms 898ms [ User: intelifix - Total duration: 1m58s - Times executed: 36 ]
[ Application: psql - Total duration: 1m58s - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-25 08:00:17 Duration: 15s823ms 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-25 14:00:09 Duration: 8s331ms 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-25 11:20:09 Duration: 7s267ms Database: rio User: intelifix Remote: [local] Application: psql
18 160ms 15s611ms 2s443ms 155 6m18s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 25 00 6 25s832ms 4s305ms 01 6 13s406ms 2s234ms 02 6 11s441ms 1s906ms 03 4 8s802ms 2s200ms 04 6 14s356ms 2s392ms 05 6 3s167ms 527ms 06 5 10s42ms 2s8ms 07 12 34s569ms 2s880ms 08 12 46s507ms 3s875ms 09 12 38s439ms 3s203ms 10 12 33s750ms 2s812ms 11 12 25s435ms 2s119ms 12 10 22s933ms 2s293ms 13 7 7s46ms 1s6ms 14 9 22s153ms 2s461ms 15 12 31s767ms 2s647ms 16 4 3s673ms 918ms 17 1 318ms 318ms 20 2 606ms 303ms 21 5 11s513ms 2s302ms 22 6 12s945ms 2s157ms [ User: intelifix - Total duration: 6m18s - Times executed: 155 ]
[ Application: psql - Total duration: 6m18s - Times executed: 155 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-25 00:05:17 Duration: 15s611ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-25 08:55:12 Duration: 11s200ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-25 08:35:10 Duration: 9s89ms Database: rio User: intelifix Remote: [local] Application: psql
19 566ms 22s526ms 1s674ms 50 1m23s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 25 08 4 6s485ms 1s621ms 09 3 2s300ms 766ms 10 3 9s467ms 3s155ms 11 2 1s429ms 714ms 12 3 4s654ms 1s551ms 13 4 3s101ms 775ms 14 3 2s330ms 776ms 15 4 7s437ms 1s859ms 16 4 7s320ms 1s830ms 17 3 23s893ms 7s964ms 18 4 3s416ms 854ms 19 4 3s919ms 979ms 20 3 3s254ms 1s84ms 21 3 2s327ms 775ms 22 3 2s366ms 788ms [ User: intelifix - Total duration: 1m23s - Times executed: 50 ]
[ Application: psql - Total duration: 1m23s - Times executed: 50 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-25 17:40:25 Duration: 22s526ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-25 15:20:06 Duration: 5s326ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-25 10:20:08 Duration: 4s947ms Database: brasilia User: intelifix Remote: [local] Application: psql
20 153ms 6s455ms 1s7ms 83 1m23s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 25 07 14 4s208ms 300ms 08 4 7s152ms 1s788ms 09 27 53s585ms 1s984ms 10 9 5s399ms 599ms 11 3 1s244ms 414ms 13 3 2s151ms 717ms 14 8 3s904ms 488ms 15 14 5s97ms 364ms 16 1 880ms 880ms [ User: intelifix - Total duration: 1m23s - Times executed: 83 ]
[ Application: [unknown] - Total duration: 1m23s - Times executed: 83 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059277) LIMIT 1;
Date: 2026-09-25 08:21:17 Duration: 6s455ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0133893) LIMIT 1;
Date: 2026-09-25 09:25:08 Duration: 6s117ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0135624) LIMIT 1;
Date: 2026-09-25 09:11:02 Duration: 4s559ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 6 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 25 12 1 0ms 0ms 13 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 2 0ms 0ms [ User: intelifix - Total duration: 16m4s - Times executed: 5 ]
[ User: lenon - Total duration: 307ms - Times executed: 1 ]
[ Application: psql - Total duration: 16m4s - Times executed: 5 ]
[ Application: [unknown] - Total duration: 307ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 16,741 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 30 FATAL entries
- 4036 ERROR entries
- 0 WARNING entries
- 11 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,975 Max number of times the same event was reported
- 4,077 Total events found
Rank Times reported Error 1 3,975 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 25 00 60 01 59 02 60 03 54 04 60 05 59 06 60 07 214 08 293 09 377 10 360 11 328 12 126 13 176 14 329 15 405 16 271 17 230 18 147 19 78 20 60 21 59 22 60 23 50 - ERROR: prepared statement "_PLAN0000000029DE6910" does not exist
- ERROR: prepared statement "_PLAN0000000029DE8900" does not exist
- ERROR: prepared statement "_PLAN0000000029CABB70" does not exist
Statement: DEALLOCATE "_PLAN0000000029DE6910"
Date: 2026-09-25 00:00:31 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029DE8900"
Date: 2026-09-25 00:01:31 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029CABB70"
Date: 2026-09-25 00:02:32 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 31 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 25 11 2 13 12 14 7 17 10 - ERROR: column "seig607078082cd8ae503d86" does not exist at character 27
- ERROR: column "seig607078082cd8ae503d86" does not exist at character 27
- ERROR: column "seig607094222cd8ae5082e0" does not exist at character 27
Statement: select * from rs_caixa_qr(SEIG607078082CD8AE503D86)
Date: 2026-09-25 11:59:07 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(SEIG607078082CD8AE503D86)
Date: 2026-09-25 11:59:07 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(SEIG607094222CD8AE5082E0)
Date: 2026-09-25 13:24:18 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
3 19 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 25 00 1 04 1 05 5 06 3 08 2 09 1 13 2 19 1 22 2 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-25 00:02:24 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-25 04:51:40 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-25 05:20:04 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
4 17 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 25 07 1 08 11 09 2 12 1 15 2 - ERROR: syntax error at or near ""},{"" at character 81
- ERROR: syntax error at or near "1" at character 95
- ERROR: syntax error at or near "15" at character 95
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"290618","seriais":[{"serial":"'"},{"serial":""}]}')
Date: 2026-09-25 07:26:42 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT MOD_ID AS ID, MOD_LEGADO || ' | ' || TCN_NOME AS NOME FROM RS_MODELOS_LISTA('{"nome":"'1","cliente":"0","status":"S","grupo":0,"tipo":0}')
Date: 2026-09-25 08:09:16 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT MOD_ID AS ID, MOD_LEGADO || ' | ' || TCN_NOME AS NOME FROM RS_MODELOS_LISTA('{"nome":"'15","cliente":"0","status":"S","grupo":0,"tipo":0}')
Date: 2026-09-25 08:09:16 Database: rio Application: [unknown] User: intelifix Remote: [local]
5 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 25 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-25 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-25 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-25 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
6 9 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 25 08 3 10 3 12 2 17 1 - LOG: process 3076477 still waiting for ShareLock on transaction 6758834 after 1000.051 ms
- LOG: process 3076477 still waiting for ShareLock on transaction 6758834 after 6130.594 ms
- LOG: process 3076477 still waiting for ShareLock on transaction 6758834 after 109347.246 ms
Detail: Process holding the lock: 3079572. Wait queue: 3076477.
Context: while updating tuple (80840,99) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-25 08:55:17 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 3079572. Wait queue: 3076477.
Context: while updating tuple (80840,99) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-25 08:55:22 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 3079572. Wait queue: 3076477.
Context: while updating tuple (80840,99) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-25 08:57:05 Database: rio Application: psql User: intelifix Remote: [local]
7 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 25 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-25 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-25 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-25 05:32:04 Database: contagem Application: psql User: intelifix Remote: [local]
8 2 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 25 13 2 - ERROR: trailing junk after numeric literal at or near "582FF71E32C0" at character 27
- ERROR: trailing junk after numeric literal at or near "582FF71E32C0" at character 27
Statement: select * from rs_caixa_qr(582FF71E32C0)
Date: 2026-09-25 13:47:46 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(582FF71E32C0)
Date: 2026-09-25 13:47:47 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
9 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 25 07 1 09 1 - ERROR: unterminated quoted string at or near "'D4D42A6372'');" at character 39
- ERROR: unterminated quoted string at or near "''' )" at character 44
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('D4D42A6372'');
Date: 2026-09-25 07:32:08 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 0129, ''' )
Date: 2026-09-25 09:47:55 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 25 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-25 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-25 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 2 ERROR: unterminated quoted identifier at or near ""..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 25 07 2 - ERROR: unterminated quoted identifier at or near ""}]}')" at character 115
- ERROR: unterminated quoted identifier at or near ""}]}');" at character 106
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"290618","seriais":[{"serial":"14121785850098204892"},{"serial":"'"}]}')
Date: 2026-09-25 07:27:16 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_CASA_MASCARAS('{"modelo":"151","seriais":[{"serial":"14121785850098204892"},{"serial":"'"}]}');
Date: 2026-09-25 07:27:16 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 1 ERROR: function rs_fluxos_lista(...) does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 25 04 1 - ERROR: function rs_fluxos_lista(integer, integer, integer, unknown, unknown, integer, unknown, bigint) does not exist at character 46
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: CREATE TABLE temp0000292456 AS SELECT * FROM RS_FLUXOS_LISTA(06,00,0429,'25-09-2026','25-09-2026',0,'',00241652463959);Date: 2026-09-25 04:56:57 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 25 11 1 - LOG: process 3282933 still waiting for AccessExclusiveLock on relation 5445872 of database 358220 after 1000.103 ms
Detail: Process holding the lock: 3309648. Wait queue: 3282933.
Statement: DROP TABLE IF EXISTS temp0000292470;Date: 2026-09-25 11:55:39 Database: rio Application: [unknown] User: intelifix Remote: [local]
14 1 ERROR: invalid byte sequence for encoding
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 25 11 1 - ERROR: invalid byte sequence for encoding "UTF8": 0x99
Date: 2026-09-25 11:33:52 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
15 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 25 03 1 - LOG: database system was shut down at 2026-09-25 03:05:01 -03
Date: 2026-09-25 03:05:02
16 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #16
Day Hour Count Sep 25 11 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000292470"
Date: 2026-09-25 11:55:39