pgBadger-
Global information
- Generated on Fri Jul 24 23:50:12 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 45,513 log entries in 10s
- Log start from 2026-07-24 00:02:30 to 2026-07-24 23:49:37
-
Overview
Global Stats
- 390 Number of unique normalized queries
- 7,235 Number of queries
- 8h51m11s Total query duration
- 2026-07-24 00:02:30 First query
- 2026-07-24 23:46:17 Last query
- 5 queries/s at 2026-07-24 23:46:12 Query peak
- 8h51m11s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h51m11s Execute total duration
- 3,793 Number of events
- 12 Number of unique normalized events
- 3,646 Max number of times the same event was reported
- 0 Number of cancellation
- 567 Total number of automatic vacuums
- 1,056 Total number of automatic analyzes
- 12 Number temporary file
- 236.86 MiB Max size of temporary file
- 113.45 MiB Average size of temporary file
- 371 Total number of sessions
- 8 sessions at 2026-07-24 10:49:36 Session peak
- 13d12h45m14s Total duration of sessions
- 52m31s Average duration of sessions
- 19 Average queries per session
- 1m25s Average queries duration per session
- 51m5s Average idle time per session
- 402 Total number of connections
- 4 connections/s at 2026-07-24 04:25:06 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-24 23:46:12 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-24 08:33:23 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-24 23:46:12 Date
Queries duration
Key values
- 8h51m11s 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) Jul 24 00 32 0ms 27s938ms 4s489ms 6s85ms 37s787ms 1m19s 01 24 0ms 3s220ms 1s124ms 4s436ms 4s508ms 4s919ms 02 18 0ms 3s891ms 1s471ms 6s283ms 6s283ms 6s283ms 03 23 0ms 3s572ms 1s354ms 5s135ms 6s89ms 6s89ms 04 24 0ms 4s485ms 1s480ms 6s228ms 7s850ms 7s850ms 05 40 0ms 8m57s 27s992ms 2m39s 4m14s 8m57s 06 26 0ms 22s842ms 3s444ms 27s364ms 29s456ms 29s456ms 07 538 150ms 9m7s 4s580ms 56s631ms 5m42s 9m14s 08 978 150ms 8m27s 3s851ms 4m36s 5m52s 8m31s 09 669 150ms 8m48s 3s716ms 1m6s 1m32s 14m24s 10 725 150ms 9m16s 3s790ms 1m 5m42s 9m19s 11 685 150ms 9m56s 3s254ms 55s770ms 5m16s 10m1s 12 185 0ms 8m56s 5s929ms 15s325ms 53s516ms 9m14s 13 609 0ms 6m21s 2s83ms 26s170ms 59s187ms 6m23s 14 817 150ms 8m59s 3s260ms 1m1s 6m7s 10m6s 15 755 150ms 9m43s 4s136ms 2m6s 5m33s 10m15s 16 355 0ms 8m7s 4s173ms 39s264ms 1m44s 8m15s 17 169 0ms 6m31s 5s25ms 11s743ms 54s238ms 6m31s 18 24 0ms 6m7s 27s721ms 3s689ms 3s815ms 6m57s 19 21 0ms 6m4s 30s992ms 3s408ms 3s954ms 6m52s 20 119 0ms 7m11s 11s755ms 1m5s 2m23s 7m11s 21 31 0ms 6m26s 22s662ms 5s375ms 52s700ms 6m26s 22 31 0ms 5m45s 20s580ms 4s562ms 46s334ms 5m45s 23 337 0ms 1m34s 6s425ms 1m7s 1m10s 2m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 24 00 9 0 4s474ms 154ms 278ms 37s787ms 01 6 0 313ms 0ms 314ms 993ms 02 0 0 0ms 0ms 0ms 0ms 03 5 0 361ms 0ms 793ms 1s15ms 04 6 0 343ms 0ms 669ms 1s239ms 05 20 0 262ms 346ms 429ms 1s489ms 06 9 0 4s583ms 1s191ms 10s599ms 29s456ms 07 409 0 4s832ms 9s363ms 43s897ms 6m36s 08 797 0 4s18ms 55s5ms 4m35s 5m56s 09 537 0 3s736ms 27s613ms 57s280ms 4m33s 10 577 0 3s745ms 17s802ms 37s411ms 6m1s 11 529 0 3s506ms 18s934ms 37s801ms 5m46s 12 127 0 7s632ms 2s559ms 6s426ms 4m42s 13 480 0 2s237ms 10s992ms 14s710ms 4m36s 14 627 0 3s408ms 15s359ms 29s667ms 6m2s 15 557 0 4s455ms 25s391ms 1m51s 5m46s 16 273 0 4s471ms 11s749ms 28s625ms 4m56s 17 79 0 9s899ms 5s576ms 6s695ms 3m42s 18 9 0 1m11s 0ms 0ms 3m42s 19 6 0 1m44s 0ms 0ms 3m33s 20 14 89 13s295ms 27s292ms 1m5s 4m10s 21 11 0 1m 0ms 160ms 3m48s 22 10 0 1m 0ms 178ms 3m33s 23 12 325 6s425ms 1m1s 1m7s 2m14s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 24 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 Jul 24 00 0 1 1.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 1 1.00 0.00% 05 0 2 2.00 0.00% 06 0 2 2.00 0.00% 07 0 16 16.00 0.00% 08 0 20 20.00 0.00% 09 0 16 16.00 0.00% 10 0 15 15.00 0.00% 11 0 18 18.00 0.00% 12 0 7 7.00 0.00% 13 0 11 11.00 0.00% 14 0 16 16.00 0.00% 15 0 13 13.00 0.00% 16 0 11 11.00 0.00% 17 0 2 2.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 1 1.00 0.00% 22 0 2 2.00 0.00% 23 0 7 7.00 0.00% Day Hour Count Average / Second Jul 24 00 21 0.01/s 01 10 0.00/s 02 7 0.00/s 03 16 0.00/s 04 8 0.00/s 05 7 0.00/s 06 15 0.00/s 07 25 0.01/s 08 32 0.01/s 09 27 0.01/s 10 24 0.01/s 11 22 0.01/s 12 15 0.00/s 13 22 0.01/s 14 23 0.01/s 15 17 0.00/s 16 19 0.01/s 17 14 0.00/s 18 10 0.00/s 19 11 0.00/s 20 15 0.00/s 21 12 0.00/s 22 16 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time Jul 24 00 6 1h1m 1h36s 01 14 1h1m15s 1h1m14s 02 8 1h22s 1h19s 03 15 20m40s 20m38s 04 8 1h1m27s 1h1m23s 05 8 1h1m12s 58m52s 06 7 56m25s 56m13s 07 14 52m50s 49m54s 08 31 43m29s 41m28s 09 28 50m13s 48m44s 10 23 50m21s 48m21s 11 22 56m4s 54m22s 12 21 54m31s 53m39s 13 15 51m45s 50m20s 14 21 58m52s 56m45s 15 21 58m22s 55m53s 16 16 57m31s 55m59s 17 20 55m18s 54m36s 18 12 56m5s 55m9s 19 9 1h 58m48s 20 13 46m55s 45m7s 21 12 55m50s 54m51s 22 11 1h16s 59m18s 23 16 39m57s 37m42s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-07-24 04:25:06 Date
Connections per database
Key values
- rio Main Database
- 402 connections Total
Connections per user
Key values
- intelifix Main User
- 402 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-07-24 10:49:36 Date
Histogram of session times
Key values
- 294 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 371 sessions Total
Sessions per user
Key values
- intelifix Main User
- 371 sessions Total
Sessions per host
Key values
- [local] Main Host
- 371 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 60,300 buffers Checkpoint Peak
- 2026-07-24 00:09:43 Date
- 270.034 seconds Highest write time
- 0.125 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-07-24 09:34:36 Date
Checkpoints distance
Key values
- 371.18 Mo Distance Peak
- 2026-07-24 09:34:36 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 24 00 97,487 735.043s 0.071s 735.207s 01 2,570 258.358s 0.087s 258.518s 02 1,283 129.14s 0.06s 129.245s 03 1,524 152.648s 0.058s 152.765s 04 3,777 379.379s 0.081s 379.525s 05 10,996 1,035.692s 0.088s 1,035.87s 06 4,585 269.321s 0.005s 269.344s 07 51,122 2,901.309s 0.565s 2,902.074s 08 100,252 3,238.38s 0.876s 3,239.525s 09 71,953 3,238.878s 0.609s 3,239.716s 10 82,208 3,238.907s 0.653s 3,239.81s 11 69,689 3,238.716s 0.729s 3,239.672s 12 24,993 1,936.81s 0.245s 1,937.212s 13 31,385 2,602.632s 0.524s 2,603.333s 14 73,380 3,238.688s 0.727s 3,239.664s 15 89,645 3,238.594s 0.733s 3,239.608s 16 25,569 2,402.866s 0.405s 2,403.422s 17 11,540 1,040.391s 0.196s 1,040.704s 18 1,111 111.421s 0.01s 111.464s 19 23 2.33s 0.003s 2.339s 20 1,300 142.141s 0.022s 142.188s 21 2,846 286.353s 0.049s 286.509s 22 2,136 214.718s 0.034s 214.811s 23 289 29.494s 0.014s 29.543s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 24 00 0 0 12 539 0.007s 0.009s 01 0 0 1 760 0.008s 0.012s 02 0 0 1 393 0.007s 0.006s 03 0 0 0 393 0.007s 0.009s 04 0 0 1 840 0.007s 0.009s 05 0 0 5 765 0.007s 0.008s 06 0 0 0 12 0.002s 0.001s 07 0 0 28 5,477 0.006s 0.012s 08 0 0 63 7,760 0.017s 0.012s 09 0 0 51 6,733 0.005s 0.012s 10 0 0 54 6,788 0.019s 0.012s 11 0 0 35 7,079 0.009s 0.012s 12 0 0 11 2,965 0.004s 0.012s 13 0 0 13 5,622 0.004s 0.012s 14 0 0 45 6,777 0.005s 0.012s 15 0 0 59 7,233 0.009s 0.012s 16 0 0 20 4,716 0.006s 0.012s 17 0 0 7 2,223 0.008s 0.011s 18 0 0 0 84 0.002s 0.005s 19 0 0 0 4 0.002s 0.001s 20 0 0 1 92 0.005s 0.003s 21 0 0 1 461 0.007s 0.01s 22 0 0 1 471 0.003s 0.009s 23 0 0 0 29 0.003s 0.006s Day Hour Count Avg time (sec) Jul 24 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 Jul 24 00 23,023.11 kB 75,927.33 kB 01 967.00 kB 27,231.58 kB 02 1,080.83 kB 10,760.00 kB 03 881.67 kB 2,371.56 kB 04 2,158.44 kB 2,500.78 kB 05 9,173.25 kB 17,122.62 kB 06 8,095.00 kB 15,566.00 kB 07 37,711.25 kB 67,405.92 kB 08 86,531.08 kB 114,384.50 kB 09 68,911.33 kB 132,221.42 kB 10 73,910.00 kB 119,557.83 kB 11 47,603.00 kB 90,732.83 kB 12 15,361.08 kB 55,766.92 kB 13 17,786.92 kB 32,203.92 kB 14 61,040.42 kB 78,640.25 kB 15 81,328.25 kB 127,957.42 kB 16 27,104.58 kB 79,419.25 kB 17 10,469.36 kB 38,711.82 kB 18 768.40 kB 20,717.20 kB 19 177.00 kB 14,974.00 kB 20 5,792.67 kB 13,581.33 kB 21 1,313.90 kB 7,666.20 kB 22 1,374.75 kB 3,829.75 kB 23 160.67 kB 2,256.83 kB -
Temporary Files
Size of temporary files
Key values
- 473.72 MiB Temp Files size Peak
- 2026-07-24 05:32:13 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-24 05:32:21 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 24 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.08 GiB 110.14 MiB 06 0 0 0 07 0 0 0 08 1 156.01 MiB 156.01 MiB 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 1 104.00 MiB 104.00 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 920.20 MiB 70.65 MiB 236.86 MiB 115.03 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-24 05:32:22 Duration: 1m37s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-24 05:32:13 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 181.17 MiB 90.59 MiB 90.59 MiB 90.59 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-24 05:30:45 Duration: 43s206ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-24 05:30:41 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 1 156.01 MiB 156.01 MiB 156.01 MiB 156.01 MiB select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04432);
Date: 2026-07-24 08:21:32 Duration: 1m7s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04437);
Date: 2026-07-24 08:44:01 Duration: 13s52ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01580);
Date: 2026-07-24 10:47:44 Duration: 12s11ms Database: contagem User: intelifix Remote: [local] Application: psql
4 1 104.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027504, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-24 07:18:32 Duration: 6m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027533, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-24 10:34:19 Duration: 5m57s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027545, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-24 14:31:42 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 236.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-24 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 236.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-24 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 156.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04432);[ Date: 2026-07-24 08:21:28 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
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-07-24 15:11:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 90.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-24 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 90.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-24 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 78.21 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-24 05:32:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 78.13 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-24 05:32:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 78.13 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-24 05:32:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 70.72 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-24 05:32:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 70.65 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-24 05:32:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 70.65 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-24 05:32:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 38.66 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-24 09:26:21 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 38.66 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-24 09:26:21 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (124) Main table analyzed (database rio)
- 1,056 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 124 rio.pg_catalog.pg_class 66 rio.public.temp0000286344 62 rio.pg_catalog.pg_type 55 brasilia.pg_catalog.pg_attribute 55 rio.public.usuarios 53 rio.pg_catalog.pg_index 38 rio.public.temp0000286372 31 rio.pg_catalog.pg_depend 30 brasilia.pg_catalog.pg_class 29 rio.public.temp0000286352 27 brasilia.pg_catalog.pg_type 26 contagem.public.usuarios 24 rio.public.temp0000286342 21 brasilia.pg_catalog.pg_index 19 contagem.pg_catalog.pg_attribute 18 rio.public.temp0000284750 18 rio.public.temp0000286390 15 rio.public.temp0000286448 15 brasilia.pg_catalog.pg_depend 14 contagem.public.temp0000226620 14 contagem.public.temp0000226678 14 rio.public.temp0000286362 14 rio.public.temp0000285404 14 brasilia.public.temp0000236842 12 rio.public.temp0000286332 11 brasilia.public.usuarios 10 rio.public.temp0000286354 10 rio.public.temp0000286112 9 rio.public.temp0000286170 8 contagem.pg_catalog.pg_class 8 rio.public.temp0000286334 8 rio.public.temp0000286370 7 rio.public.temp0000286438 7 brasilia.public.temp0000236796 6 brasilia.public.temp0000236806 6 contagem.pg_catalog.pg_type 6 rio.public.temp0000286450 6 rio.public.temp0000286436 6 rio.public.temp0000286404 5 rio.public.temp0000286384 5 rio.public.temp0000286366 5 brasilia.public.temp0000236800 5 rio.public.temp0000286430 5 brasilia.public.temp0000236794 5 rio.public.temp0000286428 5 brasilia.public.temp0000236808 4 brasilia.public.temp0000236822 4 brasilia.public.nf_entrada 4 rio.public.temp0000286192 4 brasilia.public.temp0000236876 4 postgres.pg_catalog.pg_shdepend 4 rio.public.temp0000286464 3 rio.public.temp0000286432 3 contagem.pg_catalog.pg_depend 3 rio.pg_catalog.pg_shdepend 3 contagem.pg_catalog.pg_shdepend 3 brasilia.public.temp0000236864 3 contagem.pg_catalog.pg_index 3 rio.public.temp0000286412 3 template1.pg_catalog.pg_shdepend 3 brasilia.public.temp0000236848 3 rio.public.temp0000286400 3 rio.public.tmp_drill_0302 3 contagem.public.temp0000226690 3 rio.public.temp0000286350 3 rio.public.temp0000286380 2 rio.public.temp0000286458 2 rio.public.temp0000286358 2 rio.public.temp0000286116 2 brasilia.public.temp0000236810 2 brasilia.public.temp0000236824 2 rio.public.temp0000286346 2 brasilia.pg_catalog.pg_shdepend 2 brasilia.public.temp0000236820 2 contagem.public.temp0000226688 2 brasilia.public.temp0000236874 2 brasilia.public.temp0000236812 1 brasilia.public.temp0000236828 1 rio.public.temp0000285960 1 rio.public.temp0000286462 1 rio.public.temp0000286236 1 rio.public.temp0000286248 1 brasilia.public.temp0000236818 1 brasilia.public.temp0000236860 1 brasilia.public.temp0000236838 1 brasilia.public.temp0000236872 1 brasilia.public.temp0000236802 1 rio.public.temp0000286410 1 rio.public.temp0000286444 1 contagem.public.nf_entrada 1 rio.public.temp0000286396 1 brasilia.public.temp0000236870 1 brasilia.public.temp0000236814 1 Total 1,056 Vacuums per table
Key values
- public.temp0000286344 (62) Main table vacuumed on database rio
- 567 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000286344 62 0 0 0 0 0 0 29,032 2,180 4,291,953 0 0 rio.pg_catalog.pg_attribute 62 45 0 0 0 0 0 24,949 6,872 10,025,968 356 8,549 rio.pg_catalog.pg_class 54 33 0 0 0 0 0 6,164 1,717 2,524,928 88 317 rio.pg_catalog.pg_type 43 29 0 0 0 0 0 2,699 784 1,015,676 81 267 rio.public.temp0000286372 30 0 0 0 0 0 0 32,066 1,788 4,064,650 0 0 contagem.public.usuarios 25 0 0 0 0 0 0 117 87 44,261 1 1 rio.pg_catalog.pg_index 22 17 0 0 0 0 0 996 268 253,520 45 93 brasilia.pg_catalog.pg_attribute 20 20 0 0 0 0 0 10,907 2,264 4,035,671 76 2,036 rio.public.temp0000284750 16 0 0 0 0 0 0 1,181 183 231,985 0 0 rio.public.temp0000286448 15 0 0 0 0 0 0 12,707 76 761,766 0 0 rio.public.temp0000285404 14 0 0 0 0 0 0 1,212 122 148,805 0 0 brasilia.pg_catalog.pg_class 14 14 0 0 0 0 0 2,798 551 962,658 24 76 brasilia.pg_catalog.pg_type 13 13 0 0 0 0 0 1,290 290 406,975 24 60 rio.pg_catalog.pg_depend 13 13 0 0 0 0 0 3,862 1,415 1,950,896 76 663 rio.public.usuarios 11 6 0 0 0 0 0 204 70 144,112 18 50 rio.public.tmp_drill_0302 9 3 0 0 0 0 0 1,678 26 305,651 1 73 rio.pg_catalog.pg_statistic 9 9 0 0 0 0 0 10,223 2,311 9,680,240 1,078 3,967 rio.public.temp0000286112 9 0 0 0 0 0 0 1,153 46 75,193 0 0 brasilia.pg_catalog.pg_index 9 9 0 0 0 0 0 537 169 122,144 20 27 brasilia.public.temp0000236806 6 0 0 0 0 0 0 1,461 36 93,234 0 0 contagem.pg_catalog.pg_attribute 6 6 0 0 0 0 0 4,548 956 1,935,900 4 122 rio.public.temp0000286390 6 0 0 0 0 0 0 2,089 33 128,397 0 0 brasilia.pg_catalog.pg_depend 6 6 0 0 0 0 0 1,823 505 719,648 19 134 brasilia.pg_catalog.pg_shdepend 6 6 0 0 0 0 0 814 290 468,093 50 110 rio.public.temp0000286384 5 0 0 0 0 0 0 8,388 20 497,907 0 0 rio.public.temp0000286170 4 0 0 0 0 0 0 166 22 13,327 0 0 rio.public.temp0000286436 4 0 0 0 0 0 0 2,036 22 123,668 0 0 template1.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 605 194 302,166 50 103 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,077 462 2,542,538 125 388 brasilia.public.temp0000236808 4 0 0 0 0 0 0 974 24 62,176 0 0 brasilia.public.temp0000236822 4 0 0 0 0 0 0 973 260 430,603 0 0 rio.public.temp0000286192 4 0 0 0 0 0 0 5,167 18 307,657 0 0 brasilia.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 565 128 527,284 36 88 rio.public.temp0000286350 3 0 0 0 0 0 0 1,693 14 102,208 0 0 rio.public.temp0000286464 3 0 0 0 0 0 0 5,040 12 299,169 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,087 539 2,365,249 303 2,475 rio.public.temp0000286400 3 0 0 0 0 0 0 141 13 10,415 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,851 559 1,994,115 456 3,130 contagem.public.temp0000226688 2 0 0 0 0 0 0 213 12 14,469 0 0 brasilia.public.temp0000236824 2 0 0 0 0 0 0 488 12 31,142 0 0 brasilia.public.temp0000236874 2 0 0 0 0 0 0 486 12 30,958 0 0 rio.public.temp0000286354 2 0 0 0 0 0 0 43 9 3,870 0 0 rio.public.temp0000286450 2 0 0 0 0 0 0 153 11 10,880 0 0 rio.public.temp0000286458 2 0 0 0 0 0 0 8 6 1,548 0 0 rio.pg_toast.pg_toast_362323 1 0 0 0 0 0 0 614 208 1,460,548 203 998 contagem.pg_catalog.pg_index 1 1 0 0 0 0 0 124 10 24,691 0 0 rio.public.temp0000286410 1 0 0 0 0 0 0 67 4 4,556 0 0 rio.public.temp0000285960 1 0 0 0 0 0 0 90 6 6,217 0 0 brasilia.public.temp0000236860 1 0 0 0 0 0 0 243 6 15,482 0 0 brasilia.public.temp0000236864 1 0 0 0 0 0 0 243 6 15,482 0 0 brasilia.auditor.auditor_2026_07 1 0 0 0 0 0 0 28,032 27,384 34,381,590 105 559 rio.auditor.auditor_2026_07 1 0 0 0 0 0 0 141,637 114,188 143,396,214 14,053 268,292 contagem.public.nf_entrada 1 1 0 0 0 0 0 151 50 69,687 4 9 contagem.pg_catalog.pg_type 1 1 0 0 0 0 0 258 17 53,828 0 0 rio.public.temp0000286366 1 0 0 0 0 0 0 8 5 1,328 0 0 rio.public.temp0000286396 1 0 0 0 0 0 0 65 4 4,438 0 0 rio.public.temp0000286428 1 0 0 0 0 0 0 111 6 7,514 0 0 rio.public.temp0000286412 1 0 0 0 0 0 0 129 4 8,214 0 0 contagem.pg_catalog.pg_class 1 1 0 0 0 0 0 740 28 115,603 0 0 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 214 157 494,458 20 1,087 brasilia.public.notas_fiscais 1 1 0 0 0 0 0 97 66 199,394 7 467 brasilia.public.nf_entrada 1 1 0 0 0 0 0 236 123 292,373 12 19 rio.public.temp0000286248 1 0 0 0 0 0 0 1,677 4 99,546 0 0 rio.public.temp0000286346 1 0 0 0 0 0 0 8 5 1,327 0 0 rio.public.temp0000286236 1 0 0 0 0 0 0 123 6 8,245 0 0 rio.public.temp0000286404 1 0 0 0 0 0 0 118 6 7,896 0 0 contagem.pg_catalog.pg_depend 1 1 0 0 0 0 0 655 63 210,895 0 0 rio.public.temp0000286438 1 0 0 0 0 0 0 111 6 7,514 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 146 31 104,146 5 13 Total 567 253 0 0 0 0 0 366,561 167,781 235,054,859 17,340 294,173 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (38.66) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000286344 0 0 1.95 rio.pg_catalog.pg_attribute 0 0 3.97 rio.pg_catalog.pg_class 0 0 1 rio.pg_catalog.pg_type 0 0 0.38 rio.public.temp0000286372 0 0 1.6 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_index 0 0 0.27 brasilia.pg_catalog.pg_attribute 0 0 1.41 rio.public.temp0000284750 0 0 0.19 rio.public.temp0000286448 0 0 0.51 rio.public.temp0000285404 0 0 0.25 brasilia.pg_catalog.pg_class 0 0 0.38 brasilia.pg_catalog.pg_type 0 0 0.26 rio.pg_catalog.pg_depend 0 0 0.93 rio.public.usuarios 0 0 0 rio.public.tmp_drill_0302 0 0 0.09 rio.pg_catalog.pg_statistic 0 0 1.51 rio.public.temp0000286112 0 0 0.1 brasilia.pg_catalog.pg_index 0 0 0.1 brasilia.public.temp0000236806 0 0 0.11 contagem.pg_catalog.pg_attribute 0 0 0.7 rio.public.temp0000286390 0 0 0.14 brasilia.pg_catalog.pg_depend 0 0 0.29 brasilia.pg_catalog.pg_shdepend 0 0 0.2 rio.public.temp0000286384 0 0 0.26 rio.public.temp0000286170 0 0 0.07 rio.public.temp0000286436 0 0 0.1 template1.pg_catalog.pg_shdepend 0 0 0.16 rio.pg_toast.pg_toast_2619 0 0 0.22 brasilia.public.temp0000236808 0 0 0.1 brasilia.public.temp0000236822 0 0 0.09 rio.public.temp0000286192 0 0 0.2 brasilia.pg_toast.pg_toast_2619 0 0 0.08 rio.public.temp0000286350 0 0 0.1 rio.public.temp0000286464 0 0 0.17 brasilia.pg_catalog.pg_statistic 0 0 0.34 rio.public.temp0000286400 0 0 0.02 contagem.pg_catalog.pg_statistic 0 0 0.25 contagem.public.temp0000226688 0 0 0.03 brasilia.public.temp0000236824 0 0 0.05 brasilia.public.temp0000236874 0 0 0.05 rio.public.temp0000286354 0 0 0.01 rio.public.temp0000286450 0 0 0.04 rio.public.temp0000286458 0 0 0.1 rio.pg_toast.pg_toast_362323 0 0 0.07 contagem.pg_catalog.pg_index 0 0 0.05 rio.public.temp0000286410 0 0 0 rio.public.temp0000285960 0 0 0.02 brasilia.public.temp0000236860 0 0 0.02 brasilia.public.temp0000236864 0 0 0.04 brasilia.auditor.auditor_2026_07 0 0 6.61 rio.auditor.auditor_2026_07 0 0 38.66 contagem.public.nf_entrada 0 0 0.02 contagem.pg_catalog.pg_type 0 0 0.02 rio.public.temp0000286366 0 0 0.02 rio.public.temp0000286396 0 0 0 rio.public.temp0000286428 0 0 0.02 rio.public.temp0000286412 0 0 0 contagem.pg_catalog.pg_class 0 0 0.09 brasilia.public.nf_entrada_arquivo_erros 0 0 0.11 brasilia.public.notas_fiscais 0 0 0.07 brasilia.public.nf_entrada 0 0 0.06 rio.public.temp0000286248 0 0 0.05 rio.public.temp0000286346 0 0 0.05 rio.public.temp0000286236 0 0 0.02 rio.public.temp0000286404 0 0 0.02 contagem.pg_catalog.pg_depend 0 0 0.06 rio.public.temp0000286438 0 0 0.03 contagem.pg_toast.pg_toast_2619 0 0 0 Total 0 0 64.89 Tuples removed per table
Key values
- pg_catalog.pg_attribute (185394) Main table with removed tuples on database rio
- 469093 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 62 45 185,394 1,592,512 178,007 384 37,586 brasilia.pg_catalog.pg_attribute 20 20 105,100 448,883 5,172 446 11,805 contagem.pg_catalog.pg_attribute 6 6 38,843 145,828 0 517 3,529 rio.public.tmp_drill_0302 9 3 25,250 77,800 26,275 0 1,303 rio.pg_catalog.pg_statistic 9 9 15,390 74,440 256 0 11,574 rio.pg_catalog.pg_depend 13 13 11,909 244,014 8,403 0 2,431 rio.pg_catalog.pg_type 43 29 9,489 110,970 13,068 13 3,085 rio.auditor.auditor_2026_07 1 0 9,077 17,058,887 0 0 789,903 contagem.pg_catalog.pg_depend 1 1 7,850 18,660 0 0 210 brasilia.pg_catalog.pg_statistic 3 3 6,312 24,041 0 0 3,216 brasilia.pg_catalog.pg_depend 6 6 6,311 107,115 0 17 1,077 contagem.pg_catalog.pg_class 1 1 5,952 3,401 0 0 221 brasilia.pg_catalog.pg_type 13 13 5,638 29,016 514 29 887 contagem.pg_catalog.pg_statistic 2 2 5,356 14,906 0 0 2,022 brasilia.pg_catalog.pg_shdepend 6 6 4,821 83,360 1,803 0 714 rio.pg_catalog.pg_index 22 17 4,011 45,794 3,456 3 1,230 rio.pg_catalog.pg_class 54 33 3,647 229,558 41,333 38 6,901 brasilia.pg_catalog.pg_class 14 14 2,676 47,632 1,264 68 1,725 template1.pg_catalog.pg_shdepend 4 4 2,563 54,348 124 0 476 brasilia.auditor.auditor_2026_07 1 0 2,468 3,942,160 0 0 175,792 contagem.pg_catalog.pg_type 1 1 2,385 2,245 0 0 109 brasilia.pg_catalog.pg_index 9 9 2,368 17,105 253 24 470 contagem.public.usuarios 25 0 1,516 575 0 0 50 contagem.pg_catalog.pg_index 1 1 1,193 1,895 0 0 70 rio.pg_toast.pg_toast_2619 4 4 1,175 2,659 8 0 1,132 rio.public.usuarios 11 6 616 6,642 1,043 0 198 contagem.public.nf_entrada 1 1 604 963 0 0 69 brasilia.public.nf_entrada 1 1 506 4,406 0 0 152 brasilia.pg_toast.pg_toast_2619 3 3 299 431 0 0 207 brasilia.public.notas_fiscais 1 1 192 95,716 0 0 544 contagem.pg_toast.pg_toast_2619 1 1 126 116 0 0 60 brasilia.public.nf_entrada_arquivo_erros 1 0 56 1,669,727 0 0 30,038 rio.public.temp0000285404 14 0 0 48,735 0 400 1,104 brasilia.public.temp0000236806 6 0 0 18,800 0 126 1,410 rio.pg_toast.pg_toast_362323 1 0 0 1,002 0 0 204 rio.public.temp0000286344 62 0 0 634,905 0 1,236 45,100 rio.public.temp0000286384 5 0 0 118,088 0 0 8,640 rio.public.temp0000286410 1 0 0 1,201 0 0 64 rio.public.temp0000286170 4 0 0 18,251 0 128 416 rio.public.temp0000285960 1 0 0 3,656 0 46 82 brasilia.public.temp0000236860 1 0 0 3,135 0 21 235 brasilia.public.temp0000236864 1 0 0 3,135 0 21 235 rio.public.temp0000284750 16 0 0 45,129 0 326 1,146 contagem.public.temp0000226688 2 0 0 2,562 0 60 196 rio.public.temp0000286366 1 0 0 1,719 0 36 92 rio.public.temp0000286112 9 0 0 48,105 0 118 1,098 rio.public.temp0000286396 1 0 0 1,151 0 0 64 brasilia.public.temp0000236824 2 0 0 6,272 0 42 470 rio.public.temp0000286436 4 0 0 29,952 0 51 2,061 rio.public.temp0000286428 1 0 0 1,980 0 25 103 rio.public.temp0000286350 3 0 0 27,080 0 71 1,913 brasilia.public.temp0000236874 2 0 0 6,274 0 42 470 rio.public.temp0000286412 1 0 0 5,521 0 0 128 rio.public.temp0000286354 2 0 0 2,913 0 30 66 rio.public.temp0000286248 1 0 0 23,606 0 0 1,728 rio.public.temp0000286450 2 0 0 11,791 0 115 269 rio.public.temp0000286346 1 0 0 1,714 0 37 91 rio.public.temp0000286236 1 0 0 2,169 0 13 115 brasilia.public.temp0000236808 4 0 0 12,537 0 84 940 rio.public.temp0000286464 3 0 0 70,950 0 0 5,184 rio.public.temp0000286390 6 0 0 39,323 0 175 2,193 brasilia.public.temp0000236822 4 0 0 12,544 0 84 940 rio.public.temp0000286404 1 0 0 4,857 0 18 110 rio.public.temp0000286400 3 0 0 8,286 0 57 263 rio.public.temp0000286458 2 0 0 47,280 0 0 3,456 rio.public.temp0000286438 1 0 0 1,980 0 25 103 rio.public.temp0000286372 30 0 0 687,651 0 10 50,230 rio.public.temp0000286192 4 0 0 73,205 0 9 5,303 rio.public.temp0000286448 15 0 0 182,464 0 134 12,986 Total 567 253 469,093 28,365,728 280,979 5,079 1,237,994 Pages removed per table
Key values
- public.temp0000286344 (1236) Main table with removed pages on database rio
- 5079 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000286344 62 0 0 1236 contagem.pg_catalog.pg_attribute 6 6 38843 517 brasilia.pg_catalog.pg_attribute 20 20 105100 446 rio.public.temp0000285404 14 0 0 400 rio.pg_catalog.pg_attribute 62 45 185394 384 rio.public.temp0000284750 16 0 0 326 rio.public.temp0000286390 6 0 0 175 rio.public.temp0000286448 15 0 0 134 rio.public.temp0000286170 4 0 0 128 brasilia.public.temp0000236806 6 0 0 126 rio.public.temp0000286112 9 0 0 118 rio.public.temp0000286450 2 0 0 115 brasilia.public.temp0000236808 4 0 0 84 brasilia.public.temp0000236822 4 0 0 84 rio.public.temp0000286350 3 0 0 71 brasilia.pg_catalog.pg_class 14 14 2676 68 contagem.public.temp0000226688 2 0 0 60 rio.public.temp0000286400 3 0 0 57 rio.public.temp0000286436 4 0 0 51 rio.public.temp0000285960 1 0 0 46 brasilia.public.temp0000236824 2 0 0 42 brasilia.public.temp0000236874 2 0 0 42 rio.pg_catalog.pg_class 54 33 3647 38 rio.public.temp0000286346 1 0 0 37 rio.public.temp0000286366 1 0 0 36 rio.public.temp0000286354 2 0 0 30 brasilia.pg_catalog.pg_type 13 13 5638 29 rio.public.temp0000286428 1 0 0 25 rio.public.temp0000286438 1 0 0 25 brasilia.pg_catalog.pg_index 9 9 2368 24 brasilia.public.temp0000236860 1 0 0 21 brasilia.public.temp0000236864 1 0 0 21 rio.public.temp0000286404 1 0 0 18 brasilia.pg_catalog.pg_depend 6 6 6311 17 rio.pg_catalog.pg_type 43 29 9489 13 rio.public.temp0000286236 1 0 0 13 rio.public.temp0000286372 30 0 0 10 rio.public.temp0000286192 4 0 0 9 rio.pg_catalog.pg_index 22 17 4011 3 rio.pg_toast.pg_toast_362323 1 0 0 0 contagem.pg_catalog.pg_index 1 1 1193 0 contagem.pg_catalog.pg_statistic 2 2 5356 0 rio.public.temp0000286384 5 0 0 0 rio.public.temp0000286410 1 0 0 0 rio.public.tmp_drill_0302 9 3 25250 0 rio.pg_catalog.pg_statistic 9 9 15390 0 brasilia.auditor.auditor_2026_07 1 0 2468 0 rio.auditor.auditor_2026_07 1 0 9077 0 contagem.public.nf_entrada 1 1 604 0 contagem.pg_catalog.pg_type 1 1 2385 0 brasilia.pg_toast.pg_toast_2619 3 3 299 0 rio.public.temp0000286396 1 0 0 0 template1.pg_catalog.pg_shdepend 4 4 2563 0 rio.public.temp0000286412 1 0 0 0 contagem.pg_catalog.pg_class 1 1 5952 0 brasilia.public.nf_entrada_arquivo_erros 1 0 56 0 brasilia.public.notas_fiscais 1 1 192 0 brasilia.public.nf_entrada 1 1 506 0 rio.pg_toast.pg_toast_2619 4 4 1175 0 rio.public.temp0000286248 1 0 0 0 rio.public.temp0000286464 3 0 0 0 rio.public.usuarios 11 6 616 0 contagem.pg_catalog.pg_depend 1 1 7850 0 brasilia.pg_catalog.pg_statistic 3 3 6312 0 rio.public.temp0000286458 2 0 0 0 rio.pg_catalog.pg_depend 13 13 11909 0 brasilia.pg_catalog.pg_shdepend 6 6 4821 0 contagem.public.usuarios 25 0 1516 0 contagem.pg_toast.pg_toast_2619 1 1 126 0 Total 567 253 469,093 5,079 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 24 00 1 0 01 0 2 02 0 0 03 0 0 04 0 6 05 6 11 06 0 1 07 47 89 08 107 160 09 44 97 10 75 111 11 49 108 12 7 29 13 35 76 14 60 125 15 87 129 16 24 64 17 22 44 18 0 0 19 0 0 20 0 0 21 3 4 22 0 0 23 0 0 - 38.66 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 5,109 Total read queries
- 1,628 Total write queries
Queries by database
Key values
- rio Main database
- 4,782 Requests
- 6h34m37s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,841 2h3m31s copy to 142 10m58s ddl 362 3m49s others 200 7m13s select 1,137 1h41m29s contagem Total 612 13m1s copy to 120 1m28s ddl 96 29s888ms others 5 2m58s select 391 8m5s rio Total 4,782 6h34m37s copy to 152 33m16s ddl 755 53m32s others 290 29m8s select 3,581 4h38m37s tcl 1 1s282ms Queries by user
Key values
- intelifix Main user
- 7,063 Requests
User Request type Count Duration etiquetas Total 55 12s548ms select 55 12s548ms intelifix Total 7,063 8h48m57s copy to 414 45m43s ddl 1,213 57m51s others 495 39m20s select 4,937 6h25m59s tcl 1 1s282ms lenon Total 117 2m select 117 2m Duration by user
Key values
- 8h48m57s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 55 12s548ms select 55 12s548ms intelifix Total 7,063 8h48m57s copy to 414 45m43s ddl 1,213 57m51s others 495 39m20s select 4,937 6h25m59s tcl 1 1s282ms lenon Total 117 2m select 117 2m Queries by host
Key values
- [local] Main host
- 7,235 Requests
- 8h51m11s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 6,096 Requests
- 4h23m (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-24 08:20:38 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,618 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-24 11:14:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-24 15:14:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-24 10:14:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-24 07:14:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-24 14:14:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m57s analyze verbose;[ Date: 2026-07-24 05:08:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-24 12:13:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-24 09:13:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-24 08:13:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 8m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-24 16:13:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-24 20:12:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-24 17:11:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-24 21:11:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-24 13:11:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m19s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027504, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-24 07:18:32 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 6m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-24 18:11:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 6m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-24 19:11:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m57s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027533, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-24 10:34:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m48s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027545, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-24 14:31:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m45s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027547, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-24 14:46:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h13m16s 47 1s969ms 9m56s 2m50s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 24 07 3 9m47s 3m15s 08 3 8m53s 2m57s 09 3 9m22s 3m7s 10 3 9m52s 3m17s 11 3 10m26s 3m28s 12 3 9m27s 3m9s 13 3 6m40s 2m13s 14 3 9m23s 3m7s 15 2 10m21s 5m10s 16 3 8m44s 2m54s 17 3 6m56s 2m18s 18 3 6m26s 2m8s 19 3 6m21s 2m7s 20 3 7m43s 2m34s 21 3 6m45s 2m15s 22 3 6m2s 2m [ User: intelifix - Total duration: 2h13m16s - Times executed: 47 ]
[ Application: psql - Total duration: 2h13m16s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-24 11:14:58 Duration: 9m56s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-24 15:14:45 Duration: 9m43s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-24 10:14:18 Duration: 9m16s Database: rio User: intelifix Remote: [local] Application: psql
2 1h37m35s 353 150ms 6m19s 16s587ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 24 07 26 13m6s 30s249ms 08 50 25m35s 30s712ms 09 44 7m40s 10s457ms 10 44 12m30s 17s61ms 11 32 6m35s 12s351ms 12 10 7s420ms 742ms 13 35 22s423ms 640ms 14 35 12m53s 22s94ms 15 46 17m7s 22s344ms 16 18 1m2s 3s498ms 17 13 33s131ms 2s548ms [ User: intelifix - Total duration: 1h37m35s - Times executed: 353 ]
[ Application: [unknown] - Total duration: 1h37m35s - Times executed: 353 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027504, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-24 07:18:32 Duration: 6m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027533, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-24 10:34:19 Duration: 5m57s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027545, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-24 14:31:42 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h22m31s 46 259ms 5m3s 1m47s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 24 07 3 5m49s 1m56s 08 3 5m19s 1m46s 09 3 5m15s 1m45s 10 2 5m53s 2m56s 11 3 6m1s 2m 12 2 5m30s 2m45s 13 3 5m11s 1m43s 14 3 5m23s 1m47s 15 3 6m10s 2m3s 16 3 5m42s 1m54s 17 3 4m10s 1m23s 18 3 4m13s 1m24s 19 3 4m3s 1m21s 20 3 5m21s 1m47s 21 3 4m22s 1m27s 22 3 4m2s 1m20s [ User: intelifix - Total duration: 1h22m31s - Times executed: 46 ]
[ Application: psql - Total duration: 1h22m31s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-24 11:21:27 Duration: 5m3s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-24 10:20:40 Duration: 4m58s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-24 15:21:32 Duration: 4m57s Database: brasilia User: intelifix Remote: [local] Application: psql
4 22m51s 1,503 150ms 8s656ms 912ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 24 07 108 1m15s 702ms 08 169 3m3s 1s84ms 09 181 3m19s 1s102ms 10 229 3m51s 1s9ms 11 194 3m8s 972ms 12 62 38s579ms 622ms 13 102 1m32s 902ms 14 202 2m48s 832ms 15 205 2m43s 795ms 16 49 28s184ms 575ms 17 2 2s520ms 1s260ms [ User: intelifix - Total duration: 22m51s - Times executed: 1503 ]
[ Application: [unknown] - Total duration: 22m51s - Times executed: 1503 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (47791, 418, 'ZTEAH7VPBU17603,F42D0645BE93$ZTEKH7VP3E10081,D8E8448D68EE$ZTEAH7VPBU17819,F42D0645C1F3$ZTEKH7VP3Q00514,CC29BDEADCBD$ZTEAH7VQ1Y10110,6877DA58C497$ZTEAH7VQ1Y27421,6877DA59D313$ZTEAH7VQA314445,802D1A207BB0$ZTEKH7VP3U01638,CC29BDEB8A8D$ZTEAH7VQ8P09577,802D1A1EF0E0$ZTEAH7VQ3E13632,6877DA5E95FF$ZTEKH7VP3800324,D8E8448A07FA$ZTEEH7VP3H09760,D8E844AAE356$ZTEAH7VQA317046,802D1A20A454$ZTEYH7VP6M08860,E84368539170$ZTEKH7VP2P04657,CC29BDED5729$ZTEAH7VQ5H02595,6877DA60B6BB$ZTEAH7VQ8C05138,802D1A013F54$ZTEAH7VQ3L04234,6877DA5EF237$ZTEAH7VQ2V01562,6877DA5BFB47$ZTEKH7VP3A11932,D8E8448BAC6A$ZTEEH7VM8E15906,C094AD99F8CB$ZTEKH7VP3A11940,D8E8448BAC8A$ZTEAH7VQ5H00488,6877DA6095CF$ZTEKH7VP3A11927,D8E8448BAC56$ZTEKH7VP3811303,D8E8448AB386$ZTEAH7VQ8C05127,802D1A013F28$ZTEAH7VQA318474,802D1A20BAA4$ZTEAH7VQAQ27172,203AEBA72D7E$ZTEAH7VPC809823,F42D064719C3$ZTEKH7VP3C11578,D8E8448C9142$ZTEAH7VQ1Y27424,6877DA59D31F$ZTEAH7VQ8P09566,802D1A1EF0B4$ZTEAH7VQ6L10112,6877DA62D287$ZTEAH7VQ3L12826,6877DA5F7877$ZTEAH7VQ8P10048,802D1A1EF83C$ZTEAH7VQ2V18662,6877DA5D0677$ZTEKH7VP2P09868,CC29BDEDA895$ZTEYH7VP7M04238,E0B66809D874$ZTEAH7VPBU17875,F42D0645C2D3$ZTEAH7VPCD00007,F42D06477923$ZTEAH7VPC808858,F42D06470AAF$ZTEKH7VP2P04840,CC29BDED5A05$ZTEAH7VQAQ26476,203AEBA7229E$ZTEAH7VQAQ29190,203AEBA74D06$ZTEAH7VQAQ29164,203AEBA74C9E$ZTEAH7VQ3B06993,6877DA5D9ED3$ZTEAH7VQ5H08037,6877DA610BC3$ZTEEH7VM1L12993,304240931350$ZTEKH7VP3808710,D8E8448A8B02$ZTEKH7VP5P00272,CC29BDEC425D', '',0301,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-24 13:23:37 Duration: 8s656ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (270202, 450, '71505685850012212133,216544960625,216739921324,216910769197,216348456070,216407217293,216799608305,216515617075,216547780709,216739229404,216834899302,216360450620,216949046581,216800041838H010969886,216632763548,216337032139,216552481931,216614875674,216837303858,184269843136,216338292531,184270833648,216724214953,216513440018,216800164655,216559579806,216502454949,216680139305,216834961935,216700061923,216407264750,216629457175,216818297984,216838395569,216681144869H011710093,216637075663,216558201423H010903577,216563060820,216739861823,216398798390,216405764660', '',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":""},{"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-07-24 11:21:40 Duration: 5s279ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (270202, 450, '7152338787H010947376,216630512644H010999282,216628111321,184272052948,216405975668,216724732535,216335136476,216875762426,216614848702,216356896669,216859756475,216607910618,216334308203,216868796583,216868685764,216816928793,216333689398,216513783541,216405171112,216868599920,216832685169,216627273652,216400473145,216868584868,216862990114,216358158296,216396429797,216835954545,216560446467,216348780323,216864482627,216910771926,216838894159,216518832126,216908179797,216910403248,216870270510,216859616484,216864409915,216641115777,216507418295', '',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":""},{"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-07-24 11:02:50 Duration: 5s194ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 16m26s 76 2s147ms 46s964ms 12s975ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 24 06 1 9s631ms 9s631ms 07 1 14s762ms 14s762ms 08 6 2m41s 26s841ms 09 6 1m54s 19s66ms 10 5 44s40ms 8s808ms 11 4 2m2s 30s632ms 13 4 45s821ms 11s455ms 14 10 1m38s 9s863ms 15 11 2m40s 14s585ms 16 17 2m46s 9s785ms 17 11 48s431ms 4s402ms [ User: intelifix - Total duration: 16m26s - Times executed: 76 ]
[ Application: [unknown] - Total duration: 16m26s - Times executed: 76 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-24', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-24 11:26:57 Duration: 46s964ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-24', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-24 15:28:34 Duration: 43s484ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-24', 0418, '', '', 0, 6, '2026-07-01');
Date: 2026-07-24 08:08:53 Duration: 43s87ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 15m48s 70 9s900ms 42s157ms 13s545ms create table temp0000286344 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 24 07 17 4m16s 15s80ms 08 17 3m36s 12s735ms 09 11 2m17s 12s485ms 10 19 4m13s 13s363ms 11 6 1m24s 14s5ms [ User: intelifix - Total duration: 15m48s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 15m48s - Times executed: 70 ]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 07:08:45 Duration: 42s157ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 07:39:36 Duration: 15s596ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 09:25:15 Duration: 15s184ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 15m43s 3 2m31s 8m57s 5m14s analyze verbose;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 24 05 3 15m43s 5m14s [ User: intelifix - Total duration: 15m43s - Times executed: 3 ]
[ Application: psql - Total duration: 15m43s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-24 05:08:58 Duration: 8m57s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-24 05:13:12 Duration: 4m14s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-24 05:15:44 Duration: 2m31s Database: contagem User: intelifix Remote: [local] Application: psql
8 9m48s 1,110 150ms 3s594ms 530ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 24 07 125 1m16s 611ms 08 132 1m 457ms 09 134 1m11s 531ms 10 137 1m8s 499ms 11 127 1m1s 484ms 12 1 734ms 734ms 13 135 1m29s 666ms 14 144 1m18s 544ms 15 96 49s46ms 510ms 16 64 27s537ms 430ms 17 15 5s273ms 351ms [ User: intelifix - Total duration: 9m48s - Times executed: 1110 ]
[ Application: [unknown] - Total duration: 9m48s - Times executed: 1110 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243786", "modelo" : "39", "itens" : "E820E206BF3B,942CB3774AC3,E820E262C1CC,E820E2378360,90F3055C4E1E,942CB39B150B,E820E23F8001,E820E259413E,E820E203D807", "usuario" : "414", "caixa" : "2923832", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-24 13:22:47 Duration: 3s594ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "270340", "modelo" : "464", "itens" : "241745394768,241779071220,241767726262,241743166065,241764786772,241744048485,241744016182,241745375069,241745399112,241761629304,241779073644,241688086380,241767625366,241767530812,241779061219,241742869516,241779071321,241771323651,241764809300,241767770813,241738377079,241762793447,241767529497,241688104766,241762780214,241760744156,241747506668,241760157577,241688039204,241770943636,241767818392,241761062223,241738459007,241779083140,241761251939,241768759102,241813899411,241774104057,241779168401,241746182937,241779108293,241768695560,241771280011,241764892238,241745656869,241760129719,241762737178,241779029700,241765299606,241745978999", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-24 07:06:01 Duration: 3s211ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "270744", "modelo" : "464", "itens" : "241765499502,241777858384,241779272934,241779164562,241778927389,241740647985,241747505456,241761542932,241743169500,241746093052,241760215058,241767868701,241764837080,241764668703,241747470931,241765570924,241745778700,241772626269,241770576978,241738542427,241773889513,241768776073,241769982544,241739110923,241764051415,241742344459,241771193941,241770137889,241770139607,241744014061,241779334960,241759880425,241778832734,241772746887,241740667280,241765498087,241770583949,241738629809,241740655764,241762648910,241740657986,241777700514,241762876081,241765535768,241742281726,241761513232,241779207192,241759503743,241761031233,241745772841,241764030527,241770124656,241777793452,241767902240,241767564148,241739471620,241745927479,241771196466,241764819200,241747474567", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-24 13:24:40 Duration: 3s21ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9m44s 43 10s803ms 30s6ms 13s585ms create table temp0000286372 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 24 08 2 24s546ms 12s273ms 10 7 1m32s 13s242ms 11 4 55s564ms 13s891ms 12 4 55s803ms 13s950ms 14 8 2m7s 15s973ms 15 17 3m35s 12s701ms 16 1 11s847ms 11s847ms [ User: intelifix - Total duration: 9m44s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 9m44s - Times executed: 43 ]
-
CREATE TABLE temp0000286372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 14:15:13 Duration: 30s6ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 11:42:36 Duration: 15s661ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 12:13:21 Duration: 15s380ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9m5s 276 207ms 11s115ms 1s975ms call rs_giga_triagem (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 24 00 12 27s880ms 2s323ms 01 12 19s583ms 1s631ms 02 12 21s110ms 1s759ms 03 12 21s4ms 1s750ms 04 12 19s557ms 1s629ms 05 12 21s387ms 1s782ms 06 12 20s964ms 1s747ms 07 12 23s453ms 1s954ms 08 12 27s710ms 2s309ms 09 12 30s590ms 2s549ms 10 12 30s524ms 2s543ms 11 12 30s567ms 2s547ms 12 12 23s264ms 1s938ms 13 12 23s926ms 1s993ms 14 12 21s350ms 1s779ms 15 12 26s338ms 2s194ms 16 12 27s279ms 2s273ms 17 12 20s312ms 1s692ms 18 12 21s252ms 1s771ms 19 12 21s658ms 1s804ms 20 12 26s153ms 2s179ms 21 12 20s84ms 1s673ms 22 12 19s225ms 1s602ms [ User: intelifix - Total duration: 9m5s - Times executed: 276 ]
[ Application: psql - Total duration: 9m5s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-24 00:05:24 Duration: 11s115ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-24 08:15:14 Duration: 7s838ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-24 09:15:12 Duration: 7s718ms Database: rio User: intelifix Remote: [local] Application: psql
11 7m41s 159 152ms 12s30ms 2s899ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 24 00 6 20s596ms 3s432ms 01 6 5s517ms 919ms 02 6 5s382ms 897ms 03 5 8s102ms 1s620ms 04 6 13s911ms 2s318ms 05 3 9s7ms 3s2ms 07 9 30s189ms 3s354ms 08 11 37s569ms 3s415ms 09 12 47s269ms 3s939ms 10 12 49s256ms 4s104ms 11 12 52s150ms 4s345ms 12 8 30s721ms 3s840ms 13 11 17s234ms 1s566ms 14 12 41s176ms 3s431ms 15 12 45s911ms 3s825ms 16 10 19s593ms 1s959ms 17 6 7s382ms 1s230ms 20 1 152ms 152ms 21 5 10s406ms 2s81ms 22 6 9s561ms 1s593ms [ User: intelifix - Total duration: 7m41s - Times executed: 159 ]
[ Application: psql - Total duration: 7m41s - Times executed: 159 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-24 00:05:13 Duration: 12s30ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-24 14:35:10 Duration: 9s70ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-24 10:35:09 Duration: 8s587ms Database: rio User: intelifix Remote: [local] Application: psql
12 5m22s 61 3s523ms 11s417ms 5s285ms create table temp0000286344 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 24 07 15 1m9s 4s600ms 08 21 1m45s 5s11ms 09 5 23s357ms 4s671ms 10 11 1m4s 5s874ms 11 9 1m 6s687ms [ User: intelifix - Total duration: 5m22s - Times executed: 61 ]
[ Application: [unknown] - Total duration: 5m22s - Times executed: 61 ]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-07-2026", "ate" :"24-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-24 11:22:38 Duration: 11s417ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-07-2026", "ate" :"24-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-24 08:16:58 Duration: 11s85ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"19-07-2026", "ate" :"24-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-24 10:35:35 Duration: 7s584ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 5m11s 24 10s648ms 15s666ms 12s969ms create table temp0000286448 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 24 14 12 2m38s 13s216ms 15 12 2m32s 12s723ms [ User: intelifix - Total duration: 5m11s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 5m11s - Times executed: 24 ]
-
CREATE TABLE temp0000286448 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 15:02:17 Duration: 15s666ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286448 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 15:01:55 Duration: 15s11ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286448 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 14:38:48 Duration: 14s995ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 4m44s 127 155ms 12s916ms 2s238ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 24 07 16 6s591ms 411ms 08 13 1m26s 6s626ms 09 23 2m1s 5s296ms 10 23 25s270ms 1s98ms 11 8 13s66ms 1s633ms 12 1 2s829ms 2s829ms 13 24 15s786ms 657ms 14 9 4s309ms 478ms 15 1 1s11ms 1s11ms 16 8 6s637ms 829ms 17 1 764ms 764ms [ User: intelifix - Total duration: 4m44s - Times executed: 127 ]
[ Application: [unknown] - Total duration: 4m44s - Times executed: 127 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0129779) LIMIT 1;
Date: 2026-07-24 09:01:18 Duration: 12s916ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0129779) LIMIT 1;
Date: 2026-07-24 08:58:09 Duration: 12s489ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0129779) LIMIT 1;
Date: 2026-07-24 09:02:18 Duration: 11s743ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 3m52s 411 151ms 2s335ms 565ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 24 07 29 24s222ms 835ms 08 284 2m40s 563ms 13 98 48s361ms 493ms [ User: intelifix - Total duration: 3m52s - Times executed: 411 ]
[ Application: [unknown] - Total duration: 3m52s - Times executed: 411 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"129779","seriais":"241728520013,241696066979,241615085058,241655139506,241691772341,241706432436,241672686785,241711024455,241629608596,241715238503,241606088186,241711017989,241657777799,241604524959,241711075066,241677416876,241665938090,241728518395,241604565771,241658624459,241658585364,241608572021,241667612441,241709419708,241727323442,241706859402,241676759506,241619342949,241711019909,241621993039,241660496381,241730231515,241675447896,241665460514,241704764652,241709163847,241711019101,241716425678,241650464549,241597955575","usuario":"399","observacao":""}');
Date: 2026-07-24 08:15:17 Duration: 2s335ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"129779","seriais":"241765542739,241746462437,241743359900,241746634451,241764152536,241743241427,241746418492,241777898792,241740280319,241771175252,241813268383,241763501833,241746518200,241746395258,241758976587,241745442528,241740581212,241746464053,241745670508,241771248592,241745664951,241762348195,241746583133,241814609413,241767863044,241745664446,241758995556,241761360412,241738837382,241742622646,241739659416,241739920508,241759831127,241740796485,241762609411,241740684252,241740180208,241743379194,241772485167,241765532536","usuario":"399","observacao":""}');
Date: 2026-07-24 08:48:18 Duration: 2s311ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"129779","seriais":"241680792324,241667593954,241691614345,241616732840,241680781717,241603903552,241689916783,241667791931,241645800324,241620675065,241700888190,241604691822,241706969615,241672723052,241620541618,241691720720,241658617387,241595668203,241672700626,241680789393,241620661428,241712788992,241620669004,241656943038,241674092950,241704819405,241667748996,241674199301,230048511839,241706924964,241663238096,241667597691,241710975460,241602988805,241658606174,241709167483,241667747481,241709216882,241680794546,241680788080","usuario":"399","observacao":""}');
Date: 2026-07-24 07:52:42 Duration: 2s242ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 3m28s 4 4s813ms 1m43s 52s1ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 24 20 2 1m49s 54s544ms 23 2 1m38s 49s457ms [ User: intelifix - Total duration: 3m28s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m28s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-24 20:09:08 Duration: 1m43s 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-07-24 23:17:11 Duration: 1m34s 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-07-24 20:11:12 Duration: 5s669ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 2m27s 33 648ms 13s310ms 4s472ms 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 Jul 24 08 2 8s29ms 4s14ms 09 3 23s750ms 7s916ms 10 2 9s314ms 4s657ms 11 2 13s647ms 6s823ms 12 3 8s475ms 2s825ms 13 3 16s538ms 5s512ms 14 3 26s463ms 8s821ms 15 2 18s514ms 9s257ms 16 2 11s768ms 5s884ms 17 3 2s995ms 998ms 19 1 774ms 774ms 20 2 2s297ms 1s148ms 21 2 1s999ms 999ms 22 3 3s24ms 1s8ms [ User: intelifix - Total duration: 2m27s - Times executed: 33 ]
[ Application: psql - Total duration: 2m27s - Times executed: 33 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-07-24 13:40:15 Duration: 13s310ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-07-24 14:00:14 Duration: 12s776ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-07-24 15:20:12 Duration: 11s370ms Database: rio User: intelifix Remote: [local] Application: psql
18 2m22s 62 235ms 33s153ms 2s291ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 24 07 6 4s392ms 732ms 08 8 9s530ms 1s191ms 09 9 16s152ms 1s794ms 10 10 17s978ms 1s797ms 11 4 38s284ms 9s571ms 12 1 5s728ms 5s728ms 13 1 321ms 321ms 14 7 22s249ms 3s178ms 15 11 19s918ms 1s810ms 16 5 7s512ms 1s502ms [ User: intelifix - Total duration: 2m22s - Times executed: 62 ]
[ Application: psql - Total duration: 2m22s - Times executed: 62 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027538);
Date: 2026-07-24 11:37:35 Duration: 33s153ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027543);
Date: 2026-07-24 14:20:09 Duration: 11s899ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 504); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027527);
Date: 2026-07-24 10:10:38 Duration: 7s459ms Database: rio User: intelifix Remote: [local] Application: psql
19 2m8s 38 153ms 13s859ms 3s390ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 24 07 3 22s255ms 7s418ms 08 7 14s448ms 2s64ms 09 6 26s44ms 4s340ms 10 7 22s595ms 3s227ms 11 3 5s274ms 1s758ms 12 1 642ms 642ms 13 1 7s249ms 7s249ms 14 3 17s239ms 5s746ms 15 3 11s852ms 3s950ms 16 2 590ms 295ms 17 2 647ms 323ms [ User: intelifix - Total duration: 2m8s - Times executed: 38 ]
[ Application: psql - Total duration: 2m8s - Times executed: 38 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027504);
Date: 2026-07-24 07:11:52 Duration: 13s859ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027545);
Date: 2026-07-24 14:25:38 Duration: 13s56ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027533);
Date: 2026-07-24 10:27:55 Duration: 9s604ms Database: rio User: intelifix Remote: [local] Application: psql
20 2m4s 4 462ms 1m3s 31s214ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 24 20 2 1m1s 30s653ms 23 2 1m3s 31s775ms [ User: intelifix - Total duration: 2m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m4s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-24 23:13:43 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-24 20:05:34 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-24 23:36:37 Duration: 466ms 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,503 22m51s 150ms 8s656ms 912ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 24 07 108 1m15s 702ms 08 169 3m3s 1s84ms 09 181 3m19s 1s102ms 10 229 3m51s 1s9ms 11 194 3m8s 972ms 12 62 38s579ms 622ms 13 102 1m32s 902ms 14 202 2m48s 832ms 15 205 2m43s 795ms 16 49 28s184ms 575ms 17 2 2s520ms 1s260ms [ User: intelifix - Total duration: 22m51s - Times executed: 1503 ]
[ Application: [unknown] - Total duration: 22m51s - Times executed: 1503 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (47791, 418, 'ZTEAH7VPBU17603,F42D0645BE93$ZTEKH7VP3E10081,D8E8448D68EE$ZTEAH7VPBU17819,F42D0645C1F3$ZTEKH7VP3Q00514,CC29BDEADCBD$ZTEAH7VQ1Y10110,6877DA58C497$ZTEAH7VQ1Y27421,6877DA59D313$ZTEAH7VQA314445,802D1A207BB0$ZTEKH7VP3U01638,CC29BDEB8A8D$ZTEAH7VQ8P09577,802D1A1EF0E0$ZTEAH7VQ3E13632,6877DA5E95FF$ZTEKH7VP3800324,D8E8448A07FA$ZTEEH7VP3H09760,D8E844AAE356$ZTEAH7VQA317046,802D1A20A454$ZTEYH7VP6M08860,E84368539170$ZTEKH7VP2P04657,CC29BDED5729$ZTEAH7VQ5H02595,6877DA60B6BB$ZTEAH7VQ8C05138,802D1A013F54$ZTEAH7VQ3L04234,6877DA5EF237$ZTEAH7VQ2V01562,6877DA5BFB47$ZTEKH7VP3A11932,D8E8448BAC6A$ZTEEH7VM8E15906,C094AD99F8CB$ZTEKH7VP3A11940,D8E8448BAC8A$ZTEAH7VQ5H00488,6877DA6095CF$ZTEKH7VP3A11927,D8E8448BAC56$ZTEKH7VP3811303,D8E8448AB386$ZTEAH7VQ8C05127,802D1A013F28$ZTEAH7VQA318474,802D1A20BAA4$ZTEAH7VQAQ27172,203AEBA72D7E$ZTEAH7VPC809823,F42D064719C3$ZTEKH7VP3C11578,D8E8448C9142$ZTEAH7VQ1Y27424,6877DA59D31F$ZTEAH7VQ8P09566,802D1A1EF0B4$ZTEAH7VQ6L10112,6877DA62D287$ZTEAH7VQ3L12826,6877DA5F7877$ZTEAH7VQ8P10048,802D1A1EF83C$ZTEAH7VQ2V18662,6877DA5D0677$ZTEKH7VP2P09868,CC29BDEDA895$ZTEYH7VP7M04238,E0B66809D874$ZTEAH7VPBU17875,F42D0645C2D3$ZTEAH7VPCD00007,F42D06477923$ZTEAH7VPC808858,F42D06470AAF$ZTEKH7VP2P04840,CC29BDED5A05$ZTEAH7VQAQ26476,203AEBA7229E$ZTEAH7VQAQ29190,203AEBA74D06$ZTEAH7VQAQ29164,203AEBA74C9E$ZTEAH7VQ3B06993,6877DA5D9ED3$ZTEAH7VQ5H08037,6877DA610BC3$ZTEEH7VM1L12993,304240931350$ZTEKH7VP3808710,D8E8448A8B02$ZTEKH7VP5P00272,CC29BDEC425D', '',0301,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-24 13:23:37 Duration: 8s656ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (270202, 450, '71505685850012212133,216544960625,216739921324,216910769197,216348456070,216407217293,216799608305,216515617075,216547780709,216739229404,216834899302,216360450620,216949046581,216800041838H010969886,216632763548,216337032139,216552481931,216614875674,216837303858,184269843136,216338292531,184270833648,216724214953,216513440018,216800164655,216559579806,216502454949,216680139305,216834961935,216700061923,216407264750,216629457175,216818297984,216838395569,216681144869H011710093,216637075663,216558201423H010903577,216563060820,216739861823,216398798390,216405764660', '',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":""},{"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-07-24 11:21:40 Duration: 5s279ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (270202, 450, '7152338787H010947376,216630512644H010999282,216628111321,184272052948,216405975668,216724732535,216335136476,216875762426,216614848702,216356896669,216859756475,216607910618,216334308203,216868796583,216868685764,216816928793,216333689398,216513783541,216405171112,216868599920,216832685169,216627273652,216400473145,216868584868,216862990114,216358158296,216396429797,216835954545,216560446467,216348780323,216864482627,216910771926,216838894159,216518832126,216908179797,216910403248,216870270510,216859616484,216864409915,216641115777,216507418295', '',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":""},{"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-07-24 11:02:50 Duration: 5s194ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1,110 9m48s 150ms 3s594ms 530ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 24 07 125 1m16s 611ms 08 132 1m 457ms 09 134 1m11s 531ms 10 137 1m8s 499ms 11 127 1m1s 484ms 12 1 734ms 734ms 13 135 1m29s 666ms 14 144 1m18s 544ms 15 96 49s46ms 510ms 16 64 27s537ms 430ms 17 15 5s273ms 351ms [ User: intelifix - Total duration: 9m48s - Times executed: 1110 ]
[ Application: [unknown] - Total duration: 9m48s - Times executed: 1110 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243786", "modelo" : "39", "itens" : "E820E206BF3B,942CB3774AC3,E820E262C1CC,E820E2378360,90F3055C4E1E,942CB39B150B,E820E23F8001,E820E259413E,E820E203D807", "usuario" : "414", "caixa" : "2923832", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-24 13:22:47 Duration: 3s594ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "270340", "modelo" : "464", "itens" : "241745394768,241779071220,241767726262,241743166065,241764786772,241744048485,241744016182,241745375069,241745399112,241761629304,241779073644,241688086380,241767625366,241767530812,241779061219,241742869516,241779071321,241771323651,241764809300,241767770813,241738377079,241762793447,241767529497,241688104766,241762780214,241760744156,241747506668,241760157577,241688039204,241770943636,241767818392,241761062223,241738459007,241779083140,241761251939,241768759102,241813899411,241774104057,241779168401,241746182937,241779108293,241768695560,241771280011,241764892238,241745656869,241760129719,241762737178,241779029700,241765299606,241745978999", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-24 07:06:01 Duration: 3s211ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "270744", "modelo" : "464", "itens" : "241765499502,241777858384,241779272934,241779164562,241778927389,241740647985,241747505456,241761542932,241743169500,241746093052,241760215058,241767868701,241764837080,241764668703,241747470931,241765570924,241745778700,241772626269,241770576978,241738542427,241773889513,241768776073,241769982544,241739110923,241764051415,241742344459,241771193941,241770137889,241770139607,241744014061,241779334960,241759880425,241778832734,241772746887,241740667280,241765498087,241770583949,241738629809,241740655764,241762648910,241740657986,241777700514,241762876081,241765535768,241742281726,241761513232,241779207192,241759503743,241761031233,241745772841,241764030527,241770124656,241777793452,241767902240,241767564148,241739471620,241745927479,241771196466,241764819200,241747474567", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-24 13:24:40 Duration: 3s21ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 411 3m52s 151ms 2s335ms 565ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 24 07 29 24s222ms 835ms 08 284 2m40s 563ms 13 98 48s361ms 493ms [ User: intelifix - Total duration: 3m52s - Times executed: 411 ]
[ Application: [unknown] - Total duration: 3m52s - Times executed: 411 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"129779","seriais":"241728520013,241696066979,241615085058,241655139506,241691772341,241706432436,241672686785,241711024455,241629608596,241715238503,241606088186,241711017989,241657777799,241604524959,241711075066,241677416876,241665938090,241728518395,241604565771,241658624459,241658585364,241608572021,241667612441,241709419708,241727323442,241706859402,241676759506,241619342949,241711019909,241621993039,241660496381,241730231515,241675447896,241665460514,241704764652,241709163847,241711019101,241716425678,241650464549,241597955575","usuario":"399","observacao":""}');
Date: 2026-07-24 08:15:17 Duration: 2s335ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"129779","seriais":"241765542739,241746462437,241743359900,241746634451,241764152536,241743241427,241746418492,241777898792,241740280319,241771175252,241813268383,241763501833,241746518200,241746395258,241758976587,241745442528,241740581212,241746464053,241745670508,241771248592,241745664951,241762348195,241746583133,241814609413,241767863044,241745664446,241758995556,241761360412,241738837382,241742622646,241739659416,241739920508,241759831127,241740796485,241762609411,241740684252,241740180208,241743379194,241772485167,241765532536","usuario":"399","observacao":""}');
Date: 2026-07-24 08:48:18 Duration: 2s311ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"129779","seriais":"241680792324,241667593954,241691614345,241616732840,241680781717,241603903552,241689916783,241667791931,241645800324,241620675065,241700888190,241604691822,241706969615,241672723052,241620541618,241691720720,241658617387,241595668203,241672700626,241680789393,241620661428,241712788992,241620669004,241656943038,241674092950,241704819405,241667748996,241674199301,230048511839,241706924964,241663238096,241667597691,241710975460,241602988805,241658606174,241709167483,241667747481,241709216882,241680794546,241680788080","usuario":"399","observacao":""}');
Date: 2026-07-24 07:52:42 Duration: 2s242ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
4 353 1h37m35s 150ms 6m19s 16s587ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 24 07 26 13m6s 30s249ms 08 50 25m35s 30s712ms 09 44 7m40s 10s457ms 10 44 12m30s 17s61ms 11 32 6m35s 12s351ms 12 10 7s420ms 742ms 13 35 22s423ms 640ms 14 35 12m53s 22s94ms 15 46 17m7s 22s344ms 16 18 1m2s 3s498ms 17 13 33s131ms 2s548ms [ User: intelifix - Total duration: 1h37m35s - Times executed: 353 ]
[ Application: [unknown] - Total duration: 1h37m35s - Times executed: 353 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027504, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-24 07:18:32 Duration: 6m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027533, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-24 10:34:19 Duration: 5m57s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027545, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-24 14:31:42 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 276 9m5s 207ms 11s115ms 1s975ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 24 00 12 27s880ms 2s323ms 01 12 19s583ms 1s631ms 02 12 21s110ms 1s759ms 03 12 21s4ms 1s750ms 04 12 19s557ms 1s629ms 05 12 21s387ms 1s782ms 06 12 20s964ms 1s747ms 07 12 23s453ms 1s954ms 08 12 27s710ms 2s309ms 09 12 30s590ms 2s549ms 10 12 30s524ms 2s543ms 11 12 30s567ms 2s547ms 12 12 23s264ms 1s938ms 13 12 23s926ms 1s993ms 14 12 21s350ms 1s779ms 15 12 26s338ms 2s194ms 16 12 27s279ms 2s273ms 17 12 20s312ms 1s692ms 18 12 21s252ms 1s771ms 19 12 21s658ms 1s804ms 20 12 26s153ms 2s179ms 21 12 20s84ms 1s673ms 22 12 19s225ms 1s602ms [ User: intelifix - Total duration: 9m5s - Times executed: 276 ]
[ Application: psql - Total duration: 9m5s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-24 00:05:24 Duration: 11s115ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-24 08:15:14 Duration: 7s838ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-24 09:15:12 Duration: 7s718ms Database: rio User: intelifix Remote: [local] Application: psql
6 179 38s702ms 150ms 4s557ms 216ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 24 05 1 153ms 153ms 07 4 1s679ms 419ms 08 3 512ms 170ms 09 3 522ms 174ms 10 7 1s174ms 167ms 11 17 2s923ms 171ms 12 5 911ms 182ms 13 7 1s333ms 190ms 14 33 5s720ms 173ms 15 61 10s972ms 179ms 16 37 12s631ms 341ms 17 1 167ms 167ms [ User: intelifix - Total duration: 38s702ms - Times executed: 179 ]
[ Application: [unknown] - Total duration: 38s702ms - Times executed: 179 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "405", "data-de" : "2026-01-01", "data-ate" : "2026-07-24", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 472 }');
Date: 2026-07-24 16:19:53 Duration: 4s557ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "405", "data-de" : "2026-06-01", "data-ate" : "2026-07-24", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 472 }');
Date: 2026-07-24 16:19:11 Duration: 1s394ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "358", "data-de" : "2026-07-01", "data-ate" : "2026-07-23", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 427 }');
Date: 2026-07-24 07:01:49 Duration: 735ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
7 159 7m41s 152ms 12s30ms 2s899ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 24 00 6 20s596ms 3s432ms 01 6 5s517ms 919ms 02 6 5s382ms 897ms 03 5 8s102ms 1s620ms 04 6 13s911ms 2s318ms 05 3 9s7ms 3s2ms 07 9 30s189ms 3s354ms 08 11 37s569ms 3s415ms 09 12 47s269ms 3s939ms 10 12 49s256ms 4s104ms 11 12 52s150ms 4s345ms 12 8 30s721ms 3s840ms 13 11 17s234ms 1s566ms 14 12 41s176ms 3s431ms 15 12 45s911ms 3s825ms 16 10 19s593ms 1s959ms 17 6 7s382ms 1s230ms 20 1 152ms 152ms 21 5 10s406ms 2s81ms 22 6 9s561ms 1s593ms [ User: intelifix - Total duration: 7m41s - Times executed: 159 ]
[ Application: psql - Total duration: 7m41s - Times executed: 159 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-24 00:05:13 Duration: 12s30ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-24 14:35:10 Duration: 9s70ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-24 10:35:09 Duration: 8s587ms Database: rio User: intelifix Remote: [local] Application: psql
8 127 4m44s 155ms 12s916ms 2s238ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 24 07 16 6s591ms 411ms 08 13 1m26s 6s626ms 09 23 2m1s 5s296ms 10 23 25s270ms 1s98ms 11 8 13s66ms 1s633ms 12 1 2s829ms 2s829ms 13 24 15s786ms 657ms 14 9 4s309ms 478ms 15 1 1s11ms 1s11ms 16 8 6s637ms 829ms 17 1 764ms 764ms [ User: intelifix - Total duration: 4m44s - Times executed: 127 ]
[ Application: [unknown] - Total duration: 4m44s - Times executed: 127 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0129779) LIMIT 1;
Date: 2026-07-24 09:01:18 Duration: 12s916ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0129779) LIMIT 1;
Date: 2026-07-24 08:58:09 Duration: 12s489ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0129779) LIMIT 1;
Date: 2026-07-24 09:02:18 Duration: 11s743ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
9 125 26s386ms 150ms 516ms 211ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 24 00 2 492ms 246ms 01 4 1s86ms 271ms 04 4 1s108ms 277ms 05 9 2s219ms 246ms 07 10 1s886ms 188ms 08 14 2s844ms 203ms 09 14 3s74ms 219ms 10 21 4s478ms 213ms 11 11 2s247ms 204ms 12 14 2s904ms 207ms 14 6 1s183ms 197ms 15 10 1s780ms 178ms 16 6 1s77ms 179ms [ User: intelifix - Total duration: 26s386ms - Times executed: 125 ]
[ Application: [unknown] - Total duration: 26s386ms - Times executed: 125 ]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '229824905268,229823753955,229708375556,229792236378,229697665768,229827774145,229641274855,229775121622,229710020914', NULL, NULL, 0137, 00);
Date: 2026-07-24 09:26:15 Duration: 516ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229909994459,229897439394,229901963653,229917912830,229896351624,229910139298,229919245676,229913034060,229914652950,229919086771,229897307485,229896513233,229908002323,229899157486,229897764354,229897605270,229874096275,229892400812,229911197191,229871377592,229915064561,229910449711,229903096176', NULL, NULL, 0263, 00);
Date: 2026-07-24 04:20:07 Duration: 411ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '229815774242,216940760218,229784177488,229879735658,229865185069,229811341734,229933101821,229743435162,229859251112,229752618796', NULL, NULL, 0141, 00);
Date: 2026-07-24 12:42:56 Duration: 398ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 111 53s550ms 315ms 823ms 482ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 24 00 1 698ms 698ms 01 1 360ms 360ms 03 2 672ms 336ms 04 1 399ms 399ms 05 2 831ms 415ms 06 2 826ms 413ms 07 12 5s519ms 459ms 08 12 5s545ms 462ms 09 9 4s220ms 468ms 10 11 5s344ms 485ms 11 12 5s714ms 476ms 12 4 2s85ms 521ms 13 11 5s808ms 528ms 14 11 5s723ms 520ms 15 7 3s418ms 488ms 16 8 4s329ms 541ms 17 2 769ms 384ms 20 1 462ms 462ms 22 1 399ms 399ms 23 1 419ms 419ms [ User: lenon - Total duration: 53s550ms - Times executed: 111 ]
[ Application: [unknown] - Total duration: 53s550ms - Times executed: 111 ]
-
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-07-24 13:48:28 Duration: 823ms 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-07-24 11:41:57 Duration: 810ms Database: contagem 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-07-24 14:15:22 Duration: 752ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
11 110 57s815ms 151ms 1s52ms 525ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 24 07 1 188ms 188ms 09 13 4s502ms 346ms 13 9 3s142ms 349ms 14 87 49s982ms 574ms [ User: intelifix - Total duration: 57s815ms - Times executed: 110 ]
[ Application: [unknown] - Total duration: 57s815ms - Times executed: 110 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-07-24 14:50:34 Duration: 1s52ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-07-24 14:52:47 Duration: 970ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-07-24 14:51:23 Duration: 918ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 106 44s156ms 218ms 671ms 416ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 24 07 7 2s710ms 387ms 08 17 7s169ms 421ms 09 12 4s403ms 366ms 10 12 5s524ms 460ms 11 11 5s129ms 466ms 12 4 1s664ms 416ms 13 4 1s727ms 431ms 14 7 2s857ms 408ms 15 16 6s815ms 425ms 16 7 2s753ms 393ms 17 9 3s400ms 377ms [ User: intelifix - Total duration: 44s156ms - Times executed: 106 ]
[ Application: [unknown] - Total duration: 44s156ms - Times executed: 106 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-24 10:56:09 Duration: 671ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-24 11:42:05 Duration: 652ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-24 12:16:29 Duration: 650ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
13 103 30s784ms 150ms 5s36ms 298ms create table temp0000286366 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 24 07 2 5s396ms 2s698ms 08 8 3s147ms 393ms 09 13 5s839ms 449ms 10 11 4s164ms 378ms 11 8 1s411ms 176ms 12 8 1s305ms 163ms 13 12 2s47ms 170ms 14 21 3s675ms 175ms 15 20 3s795ms 189ms [ User: intelifix - Total duration: 30s784ms - Times executed: 103 ]
[ Application: [unknown] - Total duration: 30s784ms - Times executed: 103 ]
-
CREATE TABLE temp0000286366 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-07-2026", "ate" :"24-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-24 07:42:19 Duration: 5s36ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286366 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-07-2026", "ate" :"24-07-2026", "nota-fiscal":"82160", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-24 10:02:31 Duration: 626ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286366 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-07-2026", "ate" :"24-07-2026", "nota-fiscal":"82160", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-24 09:17:18 Duration: 595ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 98 15s831ms 150ms 206ms 161ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 24 05 3 545ms 181ms 07 9 1s492ms 165ms 08 3 481ms 160ms 09 5 794ms 158ms 10 11 1s755ms 159ms 11 25 4s74ms 162ms 12 4 623ms 155ms 13 5 809ms 161ms 14 12 1s917ms 159ms 15 17 2s694ms 158ms 16 4 642ms 160ms [ User: intelifix - Total duration: 15s831ms - Times executed: 98 ]
[ Application: [unknown] - Total duration: 15s831ms - Times executed: 98 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-24 11:48:53 Duration: 206ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0263;
Date: 2026-07-24 14:11:16 Duration: 189ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0302;
Date: 2026-07-24 10:54:26 Duration: 188ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 97 59s485ms 414ms 1s11ms 613ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 24 00 1 907ms 907ms 01 1 431ms 431ms 04 1 550ms 550ms 05 2 1s4ms 502ms 07 8 4s549ms 568ms 08 12 7s107ms 592ms 09 9 5s200ms 577ms 10 11 6s783ms 616ms 11 11 6s483ms 589ms 12 3 1s856ms 618ms 13 9 6s91ms 676ms 14 11 7s86ms 644ms 15 7 4s237ms 605ms 16 8 5s449ms 681ms 17 2 1s14ms 507ms 23 1 733ms 733ms [ User: intelifix - Total duration: 59s485ms - Times executed: 97 ]
[ Application: [unknown] - Total duration: 59s485ms - Times executed: 97 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-07-24 11:41:57 Duration: 1s11ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (414, 21, 1);
Date: 2026-07-24 13:48:28 Duration: 979ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (474, 81, 1);
Date: 2026-07-24 10:52:32 Duration: 929ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 76 16m26s 2s147ms 46s964ms 12s975ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 24 06 1 9s631ms 9s631ms 07 1 14s762ms 14s762ms 08 6 2m41s 26s841ms 09 6 1m54s 19s66ms 10 5 44s40ms 8s808ms 11 4 2m2s 30s632ms 13 4 45s821ms 11s455ms 14 10 1m38s 9s863ms 15 11 2m40s 14s585ms 16 17 2m46s 9s785ms 17 11 48s431ms 4s402ms [ User: intelifix - Total duration: 16m26s - Times executed: 76 ]
[ Application: [unknown] - Total duration: 16m26s - Times executed: 76 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-24', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-24 11:26:57 Duration: 46s964ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-24', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-24 15:28:34 Duration: 43s484ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-24', 0418, '', '', 0, 6, '2026-07-01');
Date: 2026-07-24 08:08:53 Duration: 43s87ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 70 15m48s 9s900ms 42s157ms 13s545ms create table temp0000286344 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 24 07 17 4m16s 15s80ms 08 17 3m36s 12s735ms 09 11 2m17s 12s485ms 10 19 4m13s 13s363ms 11 6 1m24s 14s5ms [ User: intelifix - Total duration: 15m48s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 15m48s - Times executed: 70 ]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 07:08:45 Duration: 42s157ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 07:39:36 Duration: 15s596ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 09:25:15 Duration: 15s184ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 62 2m22s 235ms 33s153ms 2s291ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 24 07 6 4s392ms 732ms 08 8 9s530ms 1s191ms 09 9 16s152ms 1s794ms 10 10 17s978ms 1s797ms 11 4 38s284ms 9s571ms 12 1 5s728ms 5s728ms 13 1 321ms 321ms 14 7 22s249ms 3s178ms 15 11 19s918ms 1s810ms 16 5 7s512ms 1s502ms [ User: intelifix - Total duration: 2m22s - Times executed: 62 ]
[ Application: psql - Total duration: 2m22s - Times executed: 62 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027538);
Date: 2026-07-24 11:37:35 Duration: 33s153ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027543);
Date: 2026-07-24 14:20:09 Duration: 11s899ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 504); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027527);
Date: 2026-07-24 10:10:38 Duration: 7s459ms Database: rio User: intelifix Remote: [local] Application: psql
19 61 5m22s 3s523ms 11s417ms 5s285ms create table temp0000286344 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 24 07 15 1m9s 4s600ms 08 21 1m45s 5s11ms 09 5 23s357ms 4s671ms 10 11 1m4s 5s874ms 11 9 1m 6s687ms [ User: intelifix - Total duration: 5m22s - Times executed: 61 ]
[ Application: [unknown] - Total duration: 5m22s - Times executed: 61 ]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-07-2026", "ate" :"24-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-24 11:22:38 Duration: 11s417ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-07-2026", "ate" :"24-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-24 08:16:58 Duration: 11s85ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"19-07-2026", "ate" :"24-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-24 10:35:35 Duration: 7s584ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 52 13s809ms 150ms 1s670ms 265ms create table temp0000226678 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 24 07 4 1s884ms 471ms 08 16 3s110ms 194ms 09 9 1s856ms 206ms 10 17 4s234ms 249ms 11 2 470ms 235ms 13 1 159ms 159ms 14 2 1s924ms 962ms 16 1 168ms 168ms [ User: intelifix - Total duration: 13s809ms - Times executed: 52 ]
[ Application: [unknown] - Total duration: 13s809ms - Times executed: 52 ]
-
CREATE TABLE temp0000226678 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"19-07-2026", "ate" :"24-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-24 14:23:15 Duration: 1s670ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226678 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"19-07-2026", "ate" :"24-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-24 07:04:58 Duration: 1s364ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226678 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"19-07-2026", "ate" :"24-07-2026", "nota-fiscal":"2823", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-24 08:14:33 Duration: 412ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m31s 8m57s 5m14s 3 15m43s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 24 05 3 15m43s 5m14s [ User: intelifix - Total duration: 15m43s - Times executed: 3 ]
[ Application: psql - Total duration: 15m43s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-24 05:08:58 Duration: 8m57s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-24 05:13:12 Duration: 4m14s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-24 05:15:44 Duration: 2m31s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s969ms 9m56s 2m50s 47 2h13m16s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 24 07 3 9m47s 3m15s 08 3 8m53s 2m57s 09 3 9m22s 3m7s 10 3 9m52s 3m17s 11 3 10m26s 3m28s 12 3 9m27s 3m9s 13 3 6m40s 2m13s 14 3 9m23s 3m7s 15 2 10m21s 5m10s 16 3 8m44s 2m54s 17 3 6m56s 2m18s 18 3 6m26s 2m8s 19 3 6m21s 2m7s 20 3 7m43s 2m34s 21 3 6m45s 2m15s 22 3 6m2s 2m [ User: intelifix - Total duration: 2h13m16s - Times executed: 47 ]
[ Application: psql - Total duration: 2h13m16s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-24 11:14:58 Duration: 9m56s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-24 15:14:45 Duration: 9m43s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-24 10:14:18 Duration: 9m16s Database: rio User: intelifix Remote: [local] Application: psql
3 259ms 5m3s 1m47s 46 1h22m31s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 24 07 3 5m49s 1m56s 08 3 5m19s 1m46s 09 3 5m15s 1m45s 10 2 5m53s 2m56s 11 3 6m1s 2m 12 2 5m30s 2m45s 13 3 5m11s 1m43s 14 3 5m23s 1m47s 15 3 6m10s 2m3s 16 3 5m42s 1m54s 17 3 4m10s 1m23s 18 3 4m13s 1m24s 19 3 4m3s 1m21s 20 3 5m21s 1m47s 21 3 4m22s 1m27s 22 3 4m2s 1m20s [ User: intelifix - Total duration: 1h22m31s - Times executed: 46 ]
[ Application: psql - Total duration: 1h22m31s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-24 11:21:27 Duration: 5m3s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-24 10:20:40 Duration: 4m58s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-24 15:21:32 Duration: 4m57s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s813ms 1m43s 52s1ms 4 3m28s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 24 20 2 1m49s 54s544ms 23 2 1m38s 49s457ms [ User: intelifix - Total duration: 3m28s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m28s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-24 20:09:08 Duration: 1m43s 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-07-24 23:17:11 Duration: 1m34s 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-07-24 20:11:12 Duration: 5s669ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 462ms 1m3s 31s214ms 4 2m4s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 24 20 2 1m1s 30s653ms 23 2 1m3s 31s775ms [ User: intelifix - Total duration: 2m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m4s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-24 23:13:43 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-24 20:05:34 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-24 23:36:37 Duration: 466ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 150ms 6m19s 16s587ms 353 1h37m35s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 24 07 26 13m6s 30s249ms 08 50 25m35s 30s712ms 09 44 7m40s 10s457ms 10 44 12m30s 17s61ms 11 32 6m35s 12s351ms 12 10 7s420ms 742ms 13 35 22s423ms 640ms 14 35 12m53s 22s94ms 15 46 17m7s 22s344ms 16 18 1m2s 3s498ms 17 13 33s131ms 2s548ms [ User: intelifix - Total duration: 1h37m35s - Times executed: 353 ]
[ Application: [unknown] - Total duration: 1h37m35s - Times executed: 353 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027504, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-24 07:18:32 Duration: 6m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027533, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-24 10:34:19 Duration: 5m57s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027545, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-24 14:31:42 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 10s803ms 30s6ms 13s585ms 43 9m44s create table temp0000286372 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 24 08 2 24s546ms 12s273ms 10 7 1m32s 13s242ms 11 4 55s564ms 13s891ms 12 4 55s803ms 13s950ms 14 8 2m7s 15s973ms 15 17 3m35s 12s701ms 16 1 11s847ms 11s847ms [ User: intelifix - Total duration: 9m44s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 9m44s - Times executed: 43 ]
-
CREATE TABLE temp0000286372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 14:15:13 Duration: 30s6ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 11:42:36 Duration: 15s661ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 12:13:21 Duration: 15s380ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9s900ms 42s157ms 13s545ms 70 15m48s create table temp0000286344 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 24 07 17 4m16s 15s80ms 08 17 3m36s 12s735ms 09 11 2m17s 12s485ms 10 19 4m13s 13s363ms 11 6 1m24s 14s5ms [ User: intelifix - Total duration: 15m48s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 15m48s - Times executed: 70 ]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 07:08:45 Duration: 42s157ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 07:39:36 Duration: 15s596ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 09:25:15 Duration: 15s184ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 2s147ms 46s964ms 12s975ms 76 16m26s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 24 06 1 9s631ms 9s631ms 07 1 14s762ms 14s762ms 08 6 2m41s 26s841ms 09 6 1m54s 19s66ms 10 5 44s40ms 8s808ms 11 4 2m2s 30s632ms 13 4 45s821ms 11s455ms 14 10 1m38s 9s863ms 15 11 2m40s 14s585ms 16 17 2m46s 9s785ms 17 11 48s431ms 4s402ms [ User: intelifix - Total duration: 16m26s - Times executed: 76 ]
[ Application: [unknown] - Total duration: 16m26s - Times executed: 76 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-24', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-24 11:26:57 Duration: 46s964ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-24', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-24 15:28:34 Duration: 43s484ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-24', 0418, '', '', 0, 6, '2026-07-01');
Date: 2026-07-24 08:08:53 Duration: 43s87ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s648ms 15s666ms 12s969ms 24 5m11s create table temp0000286448 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 24 14 12 2m38s 13s216ms 15 12 2m32s 12s723ms [ User: intelifix - Total duration: 5m11s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 5m11s - Times executed: 24 ]
-
CREATE TABLE temp0000286448 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 15:02:17 Duration: 15s666ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286448 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 15:01:55 Duration: 15s11ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286448 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-24 14:38:48 Duration: 14s995ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 3s523ms 11s417ms 5s285ms 61 5m22s create table temp0000286344 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 24 07 15 1m9s 4s600ms 08 21 1m45s 5s11ms 09 5 23s357ms 4s671ms 10 11 1m4s 5s874ms 11 9 1m 6s687ms [ User: intelifix - Total duration: 5m22s - Times executed: 61 ]
[ Application: [unknown] - Total duration: 5m22s - Times executed: 61 ]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-07-2026", "ate" :"24-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-24 11:22:38 Duration: 11s417ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-07-2026", "ate" :"24-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-24 08:16:58 Duration: 11s85ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286344 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"19-07-2026", "ate" :"24-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-24 10:35:35 Duration: 7s584ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 648ms 13s310ms 4s472ms 33 2m27s 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 #12
Day Hour Count Duration Avg duration Jul 24 08 2 8s29ms 4s14ms 09 3 23s750ms 7s916ms 10 2 9s314ms 4s657ms 11 2 13s647ms 6s823ms 12 3 8s475ms 2s825ms 13 3 16s538ms 5s512ms 14 3 26s463ms 8s821ms 15 2 18s514ms 9s257ms 16 2 11s768ms 5s884ms 17 3 2s995ms 998ms 19 1 774ms 774ms 20 2 2s297ms 1s148ms 21 2 1s999ms 999ms 22 3 3s24ms 1s8ms [ User: intelifix - Total duration: 2m27s - Times executed: 33 ]
[ Application: psql - Total duration: 2m27s - Times executed: 33 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-07-24 13:40:15 Duration: 13s310ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-07-24 14:00:14 Duration: 12s776ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-07-24 15:20:12 Duration: 11s370ms Database: rio User: intelifix Remote: [local] Application: psql
13 153ms 13s859ms 3s390ms 38 2m8s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 24 07 3 22s255ms 7s418ms 08 7 14s448ms 2s64ms 09 6 26s44ms 4s340ms 10 7 22s595ms 3s227ms 11 3 5s274ms 1s758ms 12 1 642ms 642ms 13 1 7s249ms 7s249ms 14 3 17s239ms 5s746ms 15 3 11s852ms 3s950ms 16 2 590ms 295ms 17 2 647ms 323ms [ User: intelifix - Total duration: 2m8s - Times executed: 38 ]
[ Application: psql - Total duration: 2m8s - Times executed: 38 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027504);
Date: 2026-07-24 07:11:52 Duration: 13s859ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027545);
Date: 2026-07-24 14:25:38 Duration: 13s56ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027533);
Date: 2026-07-24 10:27:55 Duration: 9s604ms Database: rio User: intelifix Remote: [local] Application: psql
14 152ms 12s30ms 2s899ms 159 7m41s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 24 00 6 20s596ms 3s432ms 01 6 5s517ms 919ms 02 6 5s382ms 897ms 03 5 8s102ms 1s620ms 04 6 13s911ms 2s318ms 05 3 9s7ms 3s2ms 07 9 30s189ms 3s354ms 08 11 37s569ms 3s415ms 09 12 47s269ms 3s939ms 10 12 49s256ms 4s104ms 11 12 52s150ms 4s345ms 12 8 30s721ms 3s840ms 13 11 17s234ms 1s566ms 14 12 41s176ms 3s431ms 15 12 45s911ms 3s825ms 16 10 19s593ms 1s959ms 17 6 7s382ms 1s230ms 20 1 152ms 152ms 21 5 10s406ms 2s81ms 22 6 9s561ms 1s593ms [ User: intelifix - Total duration: 7m41s - Times executed: 159 ]
[ Application: psql - Total duration: 7m41s - Times executed: 159 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-24 00:05:13 Duration: 12s30ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-24 14:35:10 Duration: 9s70ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-24 10:35:09 Duration: 8s587ms Database: rio User: intelifix Remote: [local] Application: psql
15 235ms 33s153ms 2s291ms 62 2m22s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 24 07 6 4s392ms 732ms 08 8 9s530ms 1s191ms 09 9 16s152ms 1s794ms 10 10 17s978ms 1s797ms 11 4 38s284ms 9s571ms 12 1 5s728ms 5s728ms 13 1 321ms 321ms 14 7 22s249ms 3s178ms 15 11 19s918ms 1s810ms 16 5 7s512ms 1s502ms [ User: intelifix - Total duration: 2m22s - Times executed: 62 ]
[ Application: psql - Total duration: 2m22s - Times executed: 62 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027538);
Date: 2026-07-24 11:37:35 Duration: 33s153ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027543);
Date: 2026-07-24 14:20:09 Duration: 11s899ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 504); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027527);
Date: 2026-07-24 10:10:38 Duration: 7s459ms Database: rio User: intelifix Remote: [local] Application: psql
16 155ms 12s916ms 2s238ms 127 4m44s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 24 07 16 6s591ms 411ms 08 13 1m26s 6s626ms 09 23 2m1s 5s296ms 10 23 25s270ms 1s98ms 11 8 13s66ms 1s633ms 12 1 2s829ms 2s829ms 13 24 15s786ms 657ms 14 9 4s309ms 478ms 15 1 1s11ms 1s11ms 16 8 6s637ms 829ms 17 1 764ms 764ms [ User: intelifix - Total duration: 4m44s - Times executed: 127 ]
[ Application: [unknown] - Total duration: 4m44s - Times executed: 127 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0129779) LIMIT 1;
Date: 2026-07-24 09:01:18 Duration: 12s916ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0129779) LIMIT 1;
Date: 2026-07-24 08:58:09 Duration: 12s489ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0129779) LIMIT 1;
Date: 2026-07-24 09:02:18 Duration: 11s743ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
17 207ms 11s115ms 1s975ms 276 9m5s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 24 00 12 27s880ms 2s323ms 01 12 19s583ms 1s631ms 02 12 21s110ms 1s759ms 03 12 21s4ms 1s750ms 04 12 19s557ms 1s629ms 05 12 21s387ms 1s782ms 06 12 20s964ms 1s747ms 07 12 23s453ms 1s954ms 08 12 27s710ms 2s309ms 09 12 30s590ms 2s549ms 10 12 30s524ms 2s543ms 11 12 30s567ms 2s547ms 12 12 23s264ms 1s938ms 13 12 23s926ms 1s993ms 14 12 21s350ms 1s779ms 15 12 26s338ms 2s194ms 16 12 27s279ms 2s273ms 17 12 20s312ms 1s692ms 18 12 21s252ms 1s771ms 19 12 21s658ms 1s804ms 20 12 26s153ms 2s179ms 21 12 20s84ms 1s673ms 22 12 19s225ms 1s602ms [ User: intelifix - Total duration: 9m5s - Times executed: 276 ]
[ Application: psql - Total duration: 9m5s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-24 00:05:24 Duration: 11s115ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-24 08:15:14 Duration: 7s838ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-24 09:15:12 Duration: 7s718ms Database: rio User: intelifix Remote: [local] Application: psql
18 150ms 8s656ms 912ms 1,503 22m51s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 24 07 108 1m15s 702ms 08 169 3m3s 1s84ms 09 181 3m19s 1s102ms 10 229 3m51s 1s9ms 11 194 3m8s 972ms 12 62 38s579ms 622ms 13 102 1m32s 902ms 14 202 2m48s 832ms 15 205 2m43s 795ms 16 49 28s184ms 575ms 17 2 2s520ms 1s260ms [ User: intelifix - Total duration: 22m51s - Times executed: 1503 ]
[ Application: [unknown] - Total duration: 22m51s - Times executed: 1503 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (47791, 418, 'ZTEAH7VPBU17603,F42D0645BE93$ZTEKH7VP3E10081,D8E8448D68EE$ZTEAH7VPBU17819,F42D0645C1F3$ZTEKH7VP3Q00514,CC29BDEADCBD$ZTEAH7VQ1Y10110,6877DA58C497$ZTEAH7VQ1Y27421,6877DA59D313$ZTEAH7VQA314445,802D1A207BB0$ZTEKH7VP3U01638,CC29BDEB8A8D$ZTEAH7VQ8P09577,802D1A1EF0E0$ZTEAH7VQ3E13632,6877DA5E95FF$ZTEKH7VP3800324,D8E8448A07FA$ZTEEH7VP3H09760,D8E844AAE356$ZTEAH7VQA317046,802D1A20A454$ZTEYH7VP6M08860,E84368539170$ZTEKH7VP2P04657,CC29BDED5729$ZTEAH7VQ5H02595,6877DA60B6BB$ZTEAH7VQ8C05138,802D1A013F54$ZTEAH7VQ3L04234,6877DA5EF237$ZTEAH7VQ2V01562,6877DA5BFB47$ZTEKH7VP3A11932,D8E8448BAC6A$ZTEEH7VM8E15906,C094AD99F8CB$ZTEKH7VP3A11940,D8E8448BAC8A$ZTEAH7VQ5H00488,6877DA6095CF$ZTEKH7VP3A11927,D8E8448BAC56$ZTEKH7VP3811303,D8E8448AB386$ZTEAH7VQ8C05127,802D1A013F28$ZTEAH7VQA318474,802D1A20BAA4$ZTEAH7VQAQ27172,203AEBA72D7E$ZTEAH7VPC809823,F42D064719C3$ZTEKH7VP3C11578,D8E8448C9142$ZTEAH7VQ1Y27424,6877DA59D31F$ZTEAH7VQ8P09566,802D1A1EF0B4$ZTEAH7VQ6L10112,6877DA62D287$ZTEAH7VQ3L12826,6877DA5F7877$ZTEAH7VQ8P10048,802D1A1EF83C$ZTEAH7VQ2V18662,6877DA5D0677$ZTEKH7VP2P09868,CC29BDEDA895$ZTEYH7VP7M04238,E0B66809D874$ZTEAH7VPBU17875,F42D0645C2D3$ZTEAH7VPCD00007,F42D06477923$ZTEAH7VPC808858,F42D06470AAF$ZTEKH7VP2P04840,CC29BDED5A05$ZTEAH7VQAQ26476,203AEBA7229E$ZTEAH7VQAQ29190,203AEBA74D06$ZTEAH7VQAQ29164,203AEBA74C9E$ZTEAH7VQ3B06993,6877DA5D9ED3$ZTEAH7VQ5H08037,6877DA610BC3$ZTEEH7VM1L12993,304240931350$ZTEKH7VP3808710,D8E8448A8B02$ZTEKH7VP5P00272,CC29BDEC425D', '',0301,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-24 13:23:37 Duration: 8s656ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (270202, 450, '71505685850012212133,216544960625,216739921324,216910769197,216348456070,216407217293,216799608305,216515617075,216547780709,216739229404,216834899302,216360450620,216949046581,216800041838H010969886,216632763548,216337032139,216552481931,216614875674,216837303858,184269843136,216338292531,184270833648,216724214953,216513440018,216800164655,216559579806,216502454949,216680139305,216834961935,216700061923,216407264750,216629457175,216818297984,216838395569,216681144869H011710093,216637075663,216558201423H010903577,216563060820,216739861823,216398798390,216405764660', '',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":""},{"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-07-24 11:21:40 Duration: 5s279ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (270202, 450, '7152338787H010947376,216630512644H010999282,216628111321,184272052948,216405975668,216724732535,216335136476,216875762426,216614848702,216356896669,216859756475,216607910618,216334308203,216868796583,216868685764,216816928793,216333689398,216513783541,216405171112,216868599920,216832685169,216627273652,216400473145,216868584868,216862990114,216358158296,216396429797,216835954545,216560446467,216348780323,216864482627,216910771926,216838894159,216518832126,216908179797,216910403248,216870270510,216859616484,216864409915,216641115777,216507418295', '',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":""},{"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-07-24 11:02:50 Duration: 5s194ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 414ms 1s11ms 613ms 97 59s485ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 24 00 1 907ms 907ms 01 1 431ms 431ms 04 1 550ms 550ms 05 2 1s4ms 502ms 07 8 4s549ms 568ms 08 12 7s107ms 592ms 09 9 5s200ms 577ms 10 11 6s783ms 616ms 11 11 6s483ms 589ms 12 3 1s856ms 618ms 13 9 6s91ms 676ms 14 11 7s86ms 644ms 15 7 4s237ms 605ms 16 8 5s449ms 681ms 17 2 1s14ms 507ms 23 1 733ms 733ms [ User: intelifix - Total duration: 59s485ms - Times executed: 97 ]
[ Application: [unknown] - Total duration: 59s485ms - Times executed: 97 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-07-24 11:41:57 Duration: 1s11ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (414, 21, 1);
Date: 2026-07-24 13:48:28 Duration: 979ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (474, 81, 1);
Date: 2026-07-24 10:52:32 Duration: 929ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 151ms 2s335ms 565ms 411 3m52s select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 24 07 29 24s222ms 835ms 08 284 2m40s 563ms 13 98 48s361ms 493ms [ User: intelifix - Total duration: 3m52s - Times executed: 411 ]
[ Application: [unknown] - Total duration: 3m52s - Times executed: 411 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"129779","seriais":"241728520013,241696066979,241615085058,241655139506,241691772341,241706432436,241672686785,241711024455,241629608596,241715238503,241606088186,241711017989,241657777799,241604524959,241711075066,241677416876,241665938090,241728518395,241604565771,241658624459,241658585364,241608572021,241667612441,241709419708,241727323442,241706859402,241676759506,241619342949,241711019909,241621993039,241660496381,241730231515,241675447896,241665460514,241704764652,241709163847,241711019101,241716425678,241650464549,241597955575","usuario":"399","observacao":""}');
Date: 2026-07-24 08:15:17 Duration: 2s335ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"129779","seriais":"241765542739,241746462437,241743359900,241746634451,241764152536,241743241427,241746418492,241777898792,241740280319,241771175252,241813268383,241763501833,241746518200,241746395258,241758976587,241745442528,241740581212,241746464053,241745670508,241771248592,241745664951,241762348195,241746583133,241814609413,241767863044,241745664446,241758995556,241761360412,241738837382,241742622646,241739659416,241739920508,241759831127,241740796485,241762609411,241740684252,241740180208,241743379194,241772485167,241765532536","usuario":"399","observacao":""}');
Date: 2026-07-24 08:48:18 Duration: 2s311ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"129779","seriais":"241680792324,241667593954,241691614345,241616732840,241680781717,241603903552,241689916783,241667791931,241645800324,241620675065,241700888190,241604691822,241706969615,241672723052,241620541618,241691720720,241658617387,241595668203,241672700626,241680789393,241620661428,241712788992,241620669004,241656943038,241674092950,241704819405,241667748996,241674199301,230048511839,241706924964,241663238096,241667597691,241710975460,241602988805,241658606174,241709167483,241667747481,241709216882,241680794546,241680788080","usuario":"399","observacao":""}');
Date: 2026-07-24 07:52:42 Duration: 2s242ms 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 8 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 24 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 2 0ms 0ms 20 1 0ms 0ms 21 2 0ms 0ms [ User: intelifix - Total duration: 8s857ms - Times executed: 8 ]
[ Application: psql - Total duration: 8s309ms - Times executed: 7 ]
[ Application: [unknown] - Total duration: 547ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 18,717 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 38 FATAL entries
- 3754 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,646 Max number of times the same event was reported
- 3,793 Total events found
Rank Times reported Error 1 3,646 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 24 07 240 08 336 09 436 10 424 11 397 12 237 13 217 14 337 15 287 16 213 17 76 18 59 19 60 20 59 21 84 22 94 23 90 - ERROR: prepared statement "_PLAN0000000030C0CCF0" does not exist
- ERROR: prepared statement "_PLAN00000000254A2860" does not exist
- ERROR: prepared statement "_PLAN00000000313A5970" does not exist
Statement: DEALLOCATE "_PLAN0000000030C0CCF0"
Date: 2026-07-24 07:02:36 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000254A2860"
Date: 2026-07-24 07:02:39 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000313A5970"
Date: 2026-07-24 07:02:52 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 24 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-24 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-24 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-24 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 43 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 24 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 2 19 2 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-24 08:00:24 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-24 08:20:07 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-24 08:40:05 Database: brasilia Application: psql User: intelifix Remote: [local]
4 28 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 24 00 7 01 2 06 4 07 2 09 1 10 1 14 1 15 2 17 1 19 1 21 1 22 5 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-24 00:02:40 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-24 00:23:55 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-24 00:48:43 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
5 10 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 24 11 3 14 7 - ERROR: syntax error at or near "1804085850049502466" at character 33
- ERROR: syntax error at or near "1804085850049502466" at character 33
- ERROR: syntax error at or near "1804085850049502466" at character 33
Statement: SELECT RS_SERIAL_TEMPORARIO( '7'1804085850049502466' ) OR RS_SERIAL_TEMPORARIO_VIVO( '7'1804085850049502466' )
Date: 2026-07-24 11:40:34 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( '7'1804085850049502466' ) OR RS_SERIAL_TEMPORARIO_VIVO( '7'1804085850049502466' )
Date: 2026-07-24 11:41:37 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( '7'1804085850049502466' ) OR RS_SERIAL_TEMPORARIO_VIVO( '7'1804085850049502466' )
Date: 2026-07-24 11:41:49 Database: rio Application: [unknown] User: intelifix Remote: [local]
6 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 24 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Statement: CALL RS_GIGA_TECNICOS()
Date: 2026-07-24 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
Date: 2026-07-24 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-24 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
7 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 24 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-07-24 05:32:22 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-24 05:32:22 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-24 05:32:22 Database: contagem Application: psql User: intelifix Remote: [local]
8 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 24 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-24 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-24 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-24 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
9 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 24 15 2 - ERROR: column "b42a0ed21481" does not exist at character 27
- ERROR: column "b42a0ed21481" does not exist at character 27
Statement: select * from rs_caixa_qr(B42A0ED21481)
Date: 2026-07-24 15:12:53 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(B42A0ED21481)
Date: 2026-07-24 15:12:53 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
10 2 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 24 18 1 19 1 - ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
- ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-24 18:40:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-24 19:40:04 Database: brasilia Application: psql User: intelifix Remote: [local]
11 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 24 14 1 - ERROR: unterminated quoted string at or near "''' )" at character 44
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 0141, ''' )
Date: 2026-07-24 14:16:25 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
12 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 24 03 1 - LOG: database system was shut down at 2026-07-24 03:05:01 -03
Date: 2026-07-24 03:05:02