pgBadger-
Global information
- Generated on Tue Sep 22 23:50:16 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 40,992 log entries in 14s
- Log start from 2026-09-22 00:00:57 to 2026-09-22 23:49:16
-
Overview
Global Stats
- 381 Number of unique normalized queries
- 5,149 Number of queries
- 7h11m18s Total query duration
- 2026-09-22 00:02:28 First query
- 2026-09-22 23:45:12 Last query
- 5 queries/s at 2026-09-22 16:58:40 Query peak
- 7h11m18s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h11m18s Execute total duration
- 4,343 Number of events
- 13 Number of unique normalized events
- 3,969 Max number of times the same event was reported
- 0 Number of cancellation
- 407 Total number of automatic vacuums
- 1,029 Total number of automatic analyzes
- 26 Number temporary file
- 246.81 MiB Max size of temporary file
- 55.65 MiB Average size of temporary file
- 357 Total number of sessions
- 9 sessions at 2026-09-22 01:05:21 Session peak
- 13d6h35m31s Total duration of sessions
- 53m32s Average duration of sessions
- 14 Average queries per session
- 1m12s Average queries duration per session
- 52m20s Average idle time per session
- 397 Total number of connections
- 6 connections/s at 2026-09-22 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-22 16:58:40 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-22 16:58:40 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-22 23:42:34 Date
Queries duration
Key values
- 7h11m18s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 22 00 22 0ms 47s534ms 8s40ms 8s251ms 17s358ms 1m19s 01 22 0ms 7s946ms 2s363ms 5s553ms 8s377ms 10s502ms 02 12 0ms 10s966ms 4s352ms 3s712ms 9s634ms 13s490ms 03 12 0ms 13s146ms 4s562ms 3s77ms 9s556ms 15s964ms 04 12 0ms 8s872ms 4s108ms 5s679ms 7s570ms 11s313ms 05 15 0ms 10m56s 1m35s 10s428ms 3m1s 10m56s 06 22 0ms 35s17ms 4s921ms 2s517ms 20s942ms 36s635ms 07 140 0ms 8m11s 13s940ms 1m17s 5m18s 8m12s 08 362 0ms 5m30s 6s705ms 1m41s 5m36s 6m8s 09 562 151ms 6m29s 3s441ms 51s304ms 4m5s 7m8s 10 617 150ms 5m32s 3s755ms 1m20s 5m34s 6m24s 11 566 150ms 5m35s 2s596ms 1m2s 1m49s 5m40s 12 129 0ms 6m10s 6s117ms 10s221ms 27s102ms 6m45s 13 417 0ms 5m13s 2s595ms 28s681ms 44s22ms 7m15s 14 512 150ms 5m44s 3s63ms 48s375ms 3m52s 5m58s 15 500 150ms 5m26s 2s811ms 41s513ms 1m6s 6m25s 16 384 151ms 6m6s 4s119ms 39s17ms 3m38s 6m9s 17 299 0ms 8m20s 6s494ms 50s779ms 4m16s 8m49s 18 20 0ms 5m8s 30s574ms 3s65ms 23s769ms 5m53s 19 18 0ms 4m56s 31s226ms 2s866ms 43s126ms 4m56s 20 110 0ms 5m6s 10s342ms 1m2s 1m11s 6m51s 21 30 0ms 4m59s 19s751ms 7s15ms 8s750ms 5m44s 22 24 0ms 5m2s 25s301ms 7s319ms 12s192ms 5m46s 23 342 0ms 1m5s 5s744ms 1m6s 1m10s 1m15s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 22 00 3 0 11s517ms 0ms 0ms 0ms 01 9 0 442ms 0ms 0ms 1s119ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 183ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 12 0 3s297ms 0ms 0ms 5s81ms 07 100 0 16s701ms 3s147ms 45s239ms 6m19s 08 269 0 7s452ms 10s387ms 1m6s 5m40s 09 458 0 3s147ms 11s625ms 22s866ms 6m33s 10 501 0 4s83ms 9s675ms 35s407ms 5m34s 11 444 0 2s842ms 12s988ms 44s558ms 3m50s 12 95 0 7s591ms 2s660ms 4s310ms 3m40s 13 299 0 2s921ms 5s492ms 13s221ms 3m28s 14 418 0 3s85ms 7s736ms 31s758ms 5m36s 15 400 0 2s600ms 13s712ms 26s497ms 3m55s 16 294 0 4s458ms 10s709ms 24s169ms 6m4s 17 189 0 7s250ms 9s592ms 20s47ms 5m59s 18 8 0 1m11s 0ms 0ms 3m32s 19 6 0 1m29s 0ms 0ms 3m17s 20 14 82 11s561ms 25s682ms 1m2s 3m23s 21 13 0 42s74ms 0ms 0ms 3m20s 22 6 0 1m32s 0ms 0ms 3m25s 23 17 324 5s760ms 1m3s 1m6s 1m15s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 22 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 22 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 1 1.00 0.00% 07 0 9 9.00 0.00% 08 0 13 13.00 0.00% 09 0 13 13.00 0.00% 10 0 12 12.00 0.00% 11 0 14 14.00 0.00% 12 0 4 4.00 0.00% 13 0 11 11.00 0.00% 14 0 13 13.00 0.00% 15 0 8 8.00 0.00% 16 0 10 10.00 0.00% 17 0 7 7.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 3 3.00 0.00% Day Hour Count Average / Second Sep 22 00 17 0.00/s 01 11 0.00/s 02 8 0.00/s 03 21 0.01/s 04 12 0.00/s 05 11 0.00/s 06 16 0.00/s 07 17 0.00/s 08 21 0.01/s 09 22 0.01/s 10 22 0.01/s 11 27 0.01/s 12 13 0.00/s 13 20 0.01/s 14 28 0.01/s 15 23 0.01/s 16 23 0.01/s 17 19 0.01/s 18 9 0.00/s 19 9 0.00/s 20 13 0.00/s 21 11 0.00/s 22 13 0.00/s 23 11 0.00/s Day Hour Count Average Duration Average idle time Sep 22 00 8 54m7s 53m45s 01 15 1h48s 1h44s 02 11 1h17s 1h12s 03 18 22m27s 22m24s 04 8 1h2m15s 1h2m9s 05 7 1h1s 56m35s 06 6 55m50s 55m32s 07 13 1h1m22s 58m52s 08 16 58m28s 55m57s 09 23 51m51s 50m26s 10 22 55m51s 54m6s 11 20 53m45s 52m32s 12 19 59m14s 58m33s 13 15 55m31s 54m19s 14 20 52m17s 50m58s 15 23 54m 52m59s 16 22 57m12s 56m 17 21 51m 49m27s 18 13 57m22s 56m35s 19 9 55m33s 54m31s 20 12 46m13s 44m38s 21 10 1h2s 59m3s 22 11 1h16s 59m21s 23 15 38m35s 36m24s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-09-22 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 397 connections Total
Connections per user
Key values
- intelifix Main User
- 397 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-09-22 01:05:21 Date
Histogram of session times
Key values
- 293 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 357 sessions Total
Sessions per user
Key values
- intelifix Main User
- 357 sessions Total
Sessions per host
Key values
- [local] Main Host
- 357 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 74,247 buffers Checkpoint Peak
- 2026-09-22 00:09:50 Date
- 270.041 seconds Highest write time
- 0.183 seconds Sync time
Checkpoints Wal files
Key values
- 19 files Wal files usage Peak
- 2026-09-22 11:44:39 Date
Checkpoints distance
Key values
- 617.25 Mo Distance Peak
- 2026-09-22 11:44:39 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 22 00 87,175 726.243s 0.027s 726.311s 01 2,720 272.447s 0.114s 272.645s 02 2,948 294.928s 0.164s 295.121s 03 2,809 281.417s 0.115s 281.561s 04 3,394 340.032s 0.149s 340.216s 05 9,586 956.784s 0.16s 957.005s 06 7,271 382.408s 0.068s 382.485s 07 20,308 1,412.706s 0.11s 1,412.932s 08 57,807 2,883.912s 0.484s 2,884.481s 09 52,734 3,239.153s 0.464s 3,239.769s 10 61,567 3,238.998s 0.405s 3,239.677s 11 62,130 3,239.036s 0.505s 3,239.728s 12 19,462 1,809.931s 0.149s 1,810.252s 13 23,664 2,304.869s 0.236s 2,305.233s 14 54,651 3,239.265s 0.456s 3,239.814s 15 57,118 3,239.222s 0.437s 3,239.771s 16 47,946 3,239.232s 0.378s 3,239.685s 17 31,518 2,717.05s 0.429s 2,717.559s 18 1,473 147.681s 0.078s 147.788s 19 36 3.622s 0.005s 3.64s 20 926 134.269s 0.022s 134.308s 21 3,172 317.752s 0.144s 317.986s 22 3,568 357.218s 0.091s 357.426s 23 276 27.685s 0.009s 27.71s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 22 00 0 0 13 515 0.008s 0.006s 01 0 0 0 577 0.076s 0.006s 02 0 0 1 493 0.063s 0.006s 03 0 0 1 369 0.031s 0.01s 04 0 0 2 462 0.063s 0.006s 05 0 0 4 543 0.063s 0.011s 06 0 0 1 72 0.060s 0.004s 07 0 0 16 1,862 0.018s 0.012s 08 0 0 37 4,255 0.063s 0.012s 09 0 0 48 5,566 0.045s 0.012s 10 0 0 31 6,776 0.016s 0.012s 11 0 0 47 7,235 0.064s 0.012s 12 0 0 7 3,269 0.063s 0.012s 13 0 0 15 5,485 0.063s 0.012s 14 0 0 35 7,556 0.066s 0.012s 15 0 0 39 7,572 0.090s 0.012s 16 0 0 32 5,959 0.063s 0.012s 17 0 0 64 5,378 0.061s 0.014s 18 0 0 0 168 0.060s 0.006s 19 0 0 0 9 0.002s 0.002s 20 0 0 1 84 0.007s 0.004s 21 0 0 1 437 0.043s 0.008s 22 0 0 1 476 0.062s 0.007s 23 0 0 0 37 0.003s 0.005s Day Hour Count Avg time (sec) Sep 22 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 22 00 34,070.67 kB 107,202.67 kB 01 2,340.17 kB 58,695.67 kB 02 2,672.00 kB 32,364.67 kB 03 2,438.86 kB 6,485.86 kB 04 3,303.83 kB 4,748.00 kB 05 7,438.44 kB 13,373.56 kB 06 5,405.00 kB 11,263.33 kB 07 22,577.50 kB 43,056.83 kB 08 50,470.08 kB 99,191.42 kB 09 65,607.50 kB 114,996.33 kB 10 42,225.58 kB 76,263.08 kB 11 63,751.42 kB 132,403.92 kB 12 9,667.25 kB 138,894.58 kB 13 21,055.25 kB 54,478.83 kB 14 47,141.17 kB 84,326.08 kB 15 53,287.08 kB 94,954.25 kB 16 44,212.33 kB 84,748.50 kB 17 86,862.25 kB 160,689.67 kB 18 1,086.33 kB 80,111.17 kB 19 108.00 kB 51,891.50 kB 20 3,896.00 kB 39,274.00 kB 21 2,281.29 kB 23,128.43 kB 22 2,742.71 kB 12,436.71 kB 23 178.80 kB 7,191.80 kB -
Temporary Files
Size of temporary files
Key values
- 493.62 MiB Temp Files size Peak
- 2026-09-22 05:31:55 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2026-09-22 11:27:56 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 22 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.31 GiB 67.16 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 6 103.68 MiB 17.28 MiB 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.01 GiB 36.80 MiB 246.81 MiB 64.77 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-22 05:32:04 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-22 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 306.94 MiB 57.05 MiB 93.89 MiB 76.74 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-22 05:30:42 Duration: 39s743ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-22 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 246.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-22 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 246.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-22 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 93.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-22 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 93.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-22 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 62.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-22 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 57.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-22 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-22 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-22 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-22 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-22 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-22 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-22 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-22 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 36.88 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-22 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.82 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-22 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-22 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-22 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-22 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.80 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-22 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.80 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-22 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 42.72 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-22 11:38:12 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 42.72 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-22 11:38:12 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (101) Main table analyzed (database rio)
- 1,029 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 101 rio.pg_catalog.pg_class 53 rio.public.usuarios 49 contagem.pg_catalog.pg_attribute 47 rio.pg_catalog.pg_type 45 contagem.public.temp0000227230 42 rio.public.temp0000292050 42 brasilia.pg_catalog.pg_attribute 37 contagem.pg_catalog.pg_class 36 rio.public.temp0000292160 33 contagem.pg_catalog.pg_type 30 contagem.public.temp0000227244 30 rio.pg_catalog.pg_index 29 contagem.public.usuarios 25 rio.public.temp0000292118 23 rio.public.temp0000292132 22 rio.pg_catalog.pg_depend 20 contagem.public.temp0000227250 20 rio.public.temp0000291977 18 brasilia.pg_catalog.pg_class 18 contagem.public.temp0000227252 17 rio.public.temp0000292056 17 contagem.pg_catalog.pg_index 17 contagem.public.temp0000227236 15 brasilia.pg_catalog.pg_type 15 rio.public.temp0000290230 14 contagem.pg_catalog.pg_depend 14 rio.public.temp0000292040 11 brasilia.pg_catalog.pg_index 10 rio.public.temp0000292064 10 rio.public.temp0000292102 10 brasilia.pg_catalog.pg_depend 9 rio.public.temp0000292146 9 brasilia.public.usuarios 8 rio.public.temp0000290026 8 rio.public.temp0000292114 8 rio.public.temp0000292060 8 contagem.public.temp0000227256 7 contagem.pg_catalog.pg_shdepend 6 brasilia.public.temp0000240688 5 brasilia.public.temp0000240668 5 rio.public.temp0000292104 5 brasilia.public.temp0000240706 5 brasilia.public.nf_entrada 4 brasilia.pg_catalog.pg_shdepend 4 brasilia.public.temp0000240634 3 rio.public.temp0000292164 3 rio.public.tmp_drill_0175 3 rio.public.temp0000292062 3 rio.public.temp0000292144 3 contagem.public.nf_entrada 3 rio.public.temp0000292174 3 rio.pg_catalog.pg_shdepend 3 rio.public.temp0000292046 3 rio.public.temp0000292068 2 rio.public.temp0000292158 2 brasilia.public.temp0000240664 2 rio.public.temp0000292126 2 brasilia.public.temp0000240660 2 rio.public.tmp_drill_0302 2 rio.public.temp0000292074 2 brasilia.public.temp0000240680 2 brasilia.public.temp0000240654 2 rio.public.tmp_drill_0320 2 contagem.public.temp0000227254 2 rio.public.temp0000292054 1 rio.public.temp0000292124 1 rio.public.temp0000292072 1 rio.public.temp0000292112 1 brasilia.public.temp0000240694 1 brasilia.public.temp0000240686 1 brasilia.public.temp0000240672 1 brasilia.public.temp0000240704 1 rio.public.temp0000292122 1 rio.public.temp0000290921 1 contagem.public.parametros 1 brasilia.public.temp0000240656 1 rio.public.temp0000292044 1 rio.public.temp0000292142 1 brasilia.public.temp0000240702 1 brasilia.public.temp0000240646 1 brasilia.public.temp0000240644 1 rio.public.temp0000292076 1 brasilia.public.temp0000240698 1 Total 1,029 Vacuums per table
Key values
- pg_catalog.pg_attribute (37) Main table vacuumed on database rio
- 407 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 37 33 0 0 0 0 0 17,657 5,147 7,575,637 284 7,288 rio.public.temp0000292160 30 0 0 0 0 0 0 9,160 381 933,415 0 0 contagem.public.usuarios 25 0 0 0 0 0 0 114 82 44,613 0 0 rio.public.temp0000292050 23 0 0 0 0 0 0 34,496 3,710 6,733,641 0 0 rio.public.temp0000292132 22 0 0 0 0 0 0 12,080 282 1,039,215 0 0 rio.pg_catalog.pg_class 21 17 0 0 0 0 0 3,418 1,244 1,921,530 77 308 contagem.pg_catalog.pg_attribute 18 18 0 0 0 0 0 11,220 2,975 5,532,888 31 801 rio.pg_catalog.pg_type 18 15 0 0 0 0 0 1,494 563 762,724 52 178 rio.public.temp0000292056 14 0 0 0 0 0 0 913 159 204,867 0 0 brasilia.pg_catalog.pg_attribute 13 13 0 0 0 0 0 7,271 1,559 2,683,114 45 1,329 rio.public.temp0000292118 13 0 0 0 0 0 0 4,444 251 574,995 0 0 rio.public.temp0000290230 12 0 0 0 0 0 0 832 281 419,168 0 0 contagem.pg_catalog.pg_class 11 11 0 0 0 0 0 2,218 629 969,932 14 46 contagem.pg_catalog.pg_type 10 10 0 0 0 0 0 1,141 369 603,095 10 26 rio.pg_catalog.pg_index 9 9 0 0 0 0 0 532 173 184,083 36 91 rio.public.temp0000291977 8 0 0 0 0 0 0 2,447 130 292,671 0 0 rio.pg_catalog.pg_depend 7 7 0 0 0 0 0 2,379 932 1,327,060 57 579 contagem.pg_catalog.pg_index 7 7 0 0 0 0 0 375 146 158,844 3 5 rio.public.temp0000292060 7 0 0 0 0 0 0 7,274 1,837 2,776,648 0 0 rio.public.temp0000290026 7 0 0 0 0 0 0 505 87 114,016 0 0 brasilia.pg_catalog.pg_type 7 7 0 0 0 0 0 625 93 188,896 10 36 brasilia.pg_catalog.pg_class 7 7 0 0 0 0 0 1,495 252 506,771 8 36 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 9,313 2,360 10,248,377 1,401 6,320 contagem.pg_catalog.pg_depend 6 6 0 0 0 0 0 2,064 705 1,409,874 10 61 brasilia.pg_catalog.pg_shdepend 6 6 0 0 0 0 0 1,012 366 586,423 56 131 rio.public.temp0000292102 5 0 0 0 0 0 0 384 98 142,206 0 0 contagem.pg_catalog.pg_statistic 5 5 0 0 0 0 0 4,632 808 2,915,388 484 2,369 brasilia.public.temp0000240706 4 0 0 0 0 0 0 1,020 268 454,306 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,887 474 2,472,217 141 350 brasilia.pg_catalog.pg_index 4 4 0 0 0 0 0 181 21 40,825 4 6 contagem.public.temp0000227250 3 0 0 0 0 0 0 348 18 23,446 0 0 rio.public.temp0000292174 3 0 0 0 0 0 0 3,638 1,824 2,560,842 0 0 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 965 242 451,722 6 77 rio.public.tmp_drill_0175 3 3 0 0 0 0 0 242 67 110,803 0 0 rio.public.usuarios 3 3 0 0 0 0 0 98 45 106,690 14 29 rio.public.temp0000292104 2 0 0 0 0 0 0 148 12 10,512 0 0 rio.public.tmp_drill_0320 2 1 0 0 0 0 0 35 5 7,925 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,462 542 2,339,815 422 2,949 brasilia.public.temp0000240660 2 0 0 0 0 0 0 508 8 31,178 0 0 rio.public.tmp_drill_0302 2 2 0 0 0 0 0 2,016 6 330,943 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 305 66 268,632 23 51 rio.public.temp0000292064 2 0 0 0 0 0 0 102 54 77,558 0 0 brasilia.public.temp0000240664 2 0 0 0 0 0 0 508 8 31,178 0 0 brasilia.public.temp0000240644 1 0 0 0 0 0 0 254 4 15,589 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 136 25 88,991 1 3 rio.public.temp0000292074 1 0 0 0 0 0 0 74 6 5,256 0 0 rio.auditor.auditor_2026_09 1 0 0 0 0 0 0 177,095 133,717 164,895,761 21,601 391,843 brasilia.public.temp0000240686 1 0 0 0 0 0 0 254 4 15,589 0 0 contagem.public.parametros 1 1 0 0 0 0 0 140 63 18,807 0 0 rio.public.temp0000292124 1 0 0 0 0 0 0 74 6 5,256 0 0 brasilia.auditor.auditor_2026_09 1 0 0 0 0 0 0 34,715 19,512 25,351,679 7,334 153,574 brasilia.public.temp0000240694 1 0 0 0 0 0 0 255 4 15,648 0 0 Total 407 204 0 0 0 0 0 367,955 182,620 250,581,259 32,124 568,486 Vacuum throughput per table
Key values
- auditor.auditor_2026_09 (42.72) 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.pg_catalog.pg_attribute 0 0 2.53 rio.public.temp0000292160 0 0 0.27 contagem.public.usuarios 0 0 0.04 rio.public.temp0000292050 0 0 1.07 rio.public.temp0000292132 0 0 0.38 rio.pg_catalog.pg_class 0 0 0.89 contagem.pg_catalog.pg_attribute 0 0 1.59 rio.pg_catalog.pg_type 0 0 0.28 rio.public.temp0000292056 0 0 0.02 brasilia.pg_catalog.pg_attribute 0 0 1.54 rio.public.temp0000292118 0 0 0.18 rio.public.temp0000290230 0 0 0.05 contagem.pg_catalog.pg_class 0 0 0.65 contagem.pg_catalog.pg_type 0 0 0.49 rio.pg_catalog.pg_index 0 0 0.16 rio.public.temp0000291977 0 0 0.05 rio.pg_catalog.pg_depend 0 0 0.53 contagem.pg_catalog.pg_index 0 0 0.25 rio.public.temp0000292060 0 0 0.33 rio.public.temp0000290026 0 0 0.01 brasilia.pg_catalog.pg_type 0 0 0.27 brasilia.pg_catalog.pg_class 0 0 0.66 rio.pg_catalog.pg_statistic 0 0 1.12 contagem.pg_catalog.pg_depend 0 0 0.83 brasilia.pg_catalog.pg_shdepend 0 0 0.49 rio.public.temp0000292102 0 0 0.04 contagem.pg_catalog.pg_statistic 0 0 0.38 brasilia.public.temp0000240706 0 0 0 rio.pg_toast.pg_toast_2619 0 0 0.29 brasilia.pg_catalog.pg_index 0 0 0.25 contagem.public.temp0000227250 0 0 0 rio.public.temp0000292174 0 0 0.15 brasilia.pg_catalog.pg_depend 0 0 0.56 rio.public.tmp_drill_0175 0 0 0 rio.public.usuarios 0 0 0.02 rio.public.temp0000292104 0 0 0 rio.public.tmp_drill_0320 0 0 0.02 brasilia.pg_catalog.pg_statistic 0 0 0.32 brasilia.public.temp0000240660 0 0 0 rio.public.tmp_drill_0302 0 0 0.05 brasilia.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000292064 0 0 0.01 brasilia.public.temp0000240664 0 0 0 brasilia.public.temp0000240644 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000292074 0 0 0 rio.auditor.auditor_2026_09 0 0 42.72 brasilia.public.temp0000240686 0 0 0 contagem.public.parametros 0 0 0.02 rio.public.temp0000292124 0 0 0.01 brasilia.auditor.auditor_2026_09 0 0 6.4 brasilia.public.temp0000240694 0 0 0 Total 0 0 65.92 Tuples removed per table
Key values
- pg_catalog.pg_attribute (128368) Main table with removed tuples on database rio
- 386745 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 37 33 128,368 898,002 36,599 268 22,253 contagem.pg_catalog.pg_attribute 18 18 72,406 435,327 0 93 10,857 brasilia.pg_catalog.pg_attribute 13 13 62,315 280,621 0 133 7,480 rio.public.tmp_drill_0302 2 2 30,153 30,777 0 0 774 rio.auditor.auditor_2026_09 1 0 17,380 14,574,933 0 0 687,384 rio.pg_catalog.pg_statistic 7 7 13,010 57,464 58 0 9,002 contagem.pg_catalog.pg_statistic 5 5 8,715 38,628 0 0 5,055 rio.pg_catalog.pg_depend 7 7 6,671 134,749 1,612 0 1,309 brasilia.pg_catalog.pg_shdepend 6 6 6,639 82,458 932 0 750 brasilia.pg_catalog.pg_statistic 2 2 5,131 15,366 0 0 2,144 contagem.pg_catalog.pg_type 10 10 4,251 22,534 40 36 707 rio.pg_catalog.pg_type 18 15 4,162 42,864 2,112 21 1,339 brasilia.auditor.auditor_2026_09 1 0 3,769 3,539,337 0 0 155,989 contagem.pg_catalog.pg_class 11 11 3,678 39,246 0 0 1,581 rio.pg_catalog.pg_class 21 17 2,859 89,429 6,457 39 2,936 brasilia.pg_catalog.pg_type 7 7 2,613 15,473 0 0 470 contagem.pg_catalog.pg_depend 6 6 2,557 112,072 0 20 1,085 rio.pg_catalog.pg_index 9 9 2,126 17,411 108 9 491 rio.public.tmp_drill_0175 3 3 1,745 2,912 0 0 79 contagem.pg_catalog.pg_index 7 7 1,614 13,282 0 15 365 contagem.public.usuarios 25 0 1,539 600 0 0 50 brasilia.pg_catalog.pg_index 4 4 1,385 7,530 0 0 214 brasilia.pg_catalog.pg_class 7 7 1,286 24,517 0 12 880 rio.pg_toast.pg_toast_2619 4 4 1,159 2,490 0 0 1,068 brasilia.pg_catalog.pg_depend 3 3 446 55,161 6 0 537 rio.public.usuarios 3 3 406 1,527 0 0 57 brasilia.pg_toast.pg_toast_2619 2 2 222 273 0 0 142 contagem.pg_toast.pg_toast_2619 1 1 118 115 0 0 57 contagem.public.parametros 1 1 22 384 0 0 64 brasilia.public.temp0000240644 1 0 0 3,334 0 0 256 rio.public.temp0000292056 14 0 0 44,097 0 421 987 rio.public.temp0000292104 2 0 0 2,084 0 124 132 rio.public.tmp_drill_0320 2 1 0 57,958 28,802 0 734 brasilia.public.temp0000240706 4 0 0 13,360 0 0 1,024 contagem.public.temp0000227250 3 0 0 4,158 0 60 324 brasilia.public.temp0000240660 2 0 0 6,672 0 0 512 rio.public.temp0000292174 3 0 0 77,177 0 0 5,568 rio.public.temp0000292050 23 0 0 590,895 0 0 42,688 rio.public.temp0000292074 1 0 0 1,040 0 62 66 rio.public.temp0000292102 5 0 0 15,479 0 296 344 rio.public.temp0000292060 7 0 0 179,895 0 0 12,992 rio.public.temp0000290230 12 0 0 33,695 0 277 747 rio.public.temp0000290026 7 0 0 20,544 0 122 454 brasilia.public.temp0000240686 1 0 0 3,338 0 0 256 rio.public.temp0000292064 2 0 0 3,953 0 42 86 rio.public.temp0000292118 13 0 0 82,752 0 536 4,584 rio.public.temp0000292160 30 0 0 171,898 0 1,120 9,632 brasilia.public.temp0000240664 2 0 0 6,672 0 0 512 rio.public.temp0000292124 1 0 0 1,041 0 62 66 rio.public.temp0000291977 8 0 0 47,653 0 321 2,431 rio.public.temp0000292132 22 0 0 202,138 0 863 14,049 brasilia.public.temp0000240694 1 0 0 3,340 0 0 256 Total 407 204 386,745 22,108,655 76,726 4,952 1,013,819 Pages removed per table
Key values
- public.temp0000292160 (1120) Main table with removed pages on database rio
- 4952 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000292160 30 0 0 1120 rio.public.temp0000292132 22 0 0 863 rio.public.temp0000292118 13 0 0 536 rio.public.temp0000292056 14 0 0 421 rio.public.temp0000291977 8 0 0 321 rio.public.temp0000292102 5 0 0 296 rio.public.temp0000290230 12 0 0 277 rio.pg_catalog.pg_attribute 37 33 128368 268 brasilia.pg_catalog.pg_attribute 13 13 62315 133 rio.public.temp0000292104 2 0 0 124 rio.public.temp0000290026 7 0 0 122 contagem.pg_catalog.pg_attribute 18 18 72406 93 rio.public.temp0000292074 1 0 0 62 rio.public.temp0000292124 1 0 0 62 contagem.public.temp0000227250 3 0 0 60 rio.public.temp0000292064 2 0 0 42 rio.pg_catalog.pg_class 21 17 2859 39 contagem.pg_catalog.pg_type 10 10 4251 36 rio.pg_catalog.pg_type 18 15 4162 21 contagem.pg_catalog.pg_depend 6 6 2557 20 contagem.pg_catalog.pg_index 7 7 1614 15 brasilia.pg_catalog.pg_class 7 7 1286 12 rio.pg_catalog.pg_index 9 9 2126 9 brasilia.public.temp0000240644 1 0 0 0 rio.public.tmp_drill_0320 2 1 0 0 rio.pg_catalog.pg_depend 7 7 6671 0 brasilia.pg_catalog.pg_statistic 2 2 5131 0 brasilia.public.temp0000240706 4 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 118 0 brasilia.public.temp0000240660 2 0 0 0 rio.public.temp0000292174 3 0 0 0 rio.public.tmp_drill_0302 2 2 30153 0 rio.public.temp0000292050 23 0 0 0 contagem.pg_catalog.pg_statistic 5 5 8715 0 contagem.pg_catalog.pg_class 11 11 3678 0 rio.public.temp0000292060 7 0 0 0 brasilia.pg_catalog.pg_shdepend 6 6 6639 0 brasilia.pg_toast.pg_toast_2619 2 2 222 0 contagem.public.usuarios 25 0 1539 0 rio.auditor.auditor_2026_09 1 0 17380 0 brasilia.pg_catalog.pg_depend 3 3 446 0 brasilia.public.temp0000240686 1 0 0 0 brasilia.pg_catalog.pg_type 7 7 2613 0 rio.public.tmp_drill_0175 3 3 1745 0 contagem.public.parametros 1 1 22 0 rio.public.usuarios 3 3 406 0 brasilia.public.temp0000240664 2 0 0 0 rio.pg_toast.pg_toast_2619 4 4 1159 0 brasilia.auditor.auditor_2026_09 1 0 3769 0 brasilia.pg_catalog.pg_index 4 4 1385 0 rio.pg_catalog.pg_statistic 7 7 13010 0 brasilia.public.temp0000240694 1 0 0 0 Total 407 204 386,745 4,952 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 22 00 0 0 01 0 1 02 0 0 03 0 0 04 0 0 05 6 0 06 0 1 07 7 19 08 29 72 09 44 89 10 27 104 11 49 121 12 6 20 13 36 111 14 44 131 15 65 160 16 37 98 17 55 97 18 0 0 19 0 0 20 0 0 21 2 5 22 0 0 23 0 0 - 42.72 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
- 3,556 Total read queries
- 1,180 Total write queries
Queries by database
Key values
- rio Main database
- 3,044 Requests
- 5h20m6s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,016 Requests
User Request type Count Duration etiquetas Total 36 11s866ms others 2 435ms select 34 11s430ms intelifix Total 5,016 7h9m30s copy to 406 41m48s ddl 774 45m50s others 411 45m36s select 3,425 4h56m15s lenon Total 97 1m36s select 97 1m36s Duration by user
Key values
- 7h9m30s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 36 11s866ms others 2 435ms select 34 11s430ms intelifix Total 5,016 7h9m30s copy to 406 41m48s ddl 774 45m50s others 411 45m36s select 3,425 4h56m15s lenon Total 97 1m36s select 97 1m36s Queries by host
Key values
- [local] Main host
- 5,149 Requests
- 7h11m18s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,114 Requests
- 3h36m44s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 1 per second Cancelled query Peak
- 2026-09-22 11:27:56 Date
Number of cancelled queries (5 minutes period)
NO DATASET
Queries generating the most cancellation (N)
Rank Count Query 1 1 select distinct mod_mnemonico, macaddress, caid from rs_equipamento_etiquetas where mod_mnemonico ilike ? limit ?; -
Top Queries
Histogram of query times
Key values
- 2,317 100-500ms duration
Slowest individual queries
Rank Duration Query 1 10m56s analyze verbose;[ Date: 2026-09-22 05:10:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m20s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030206, 0503 )', '/var/www/html/tmp/nf_carga_lotes_0503.xlsx');[ Date: 2026-09-22 17:13:45 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 8m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-22 07:13:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m26s analyze verbose;[ Date: 2026-09-22 05:18:23 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
5 6m29s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030176, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-22 09:52:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 6m18s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030155, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-22 07:32:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 6m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-22 09:11:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-22 12:11:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m6s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030196, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-22 16:08:55 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-22 14:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-22 11:10:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m32s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030178, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-22 10:11:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m31s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030177, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-22 10:02:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m31s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030179, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-22 10:50:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m30s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030162, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-22 08:44:00 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-22 10:10:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m29s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030164, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-22 08:54:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m28s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030188, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-22 14:28:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-22 15:10:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030160, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-22 08:32:17 - 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 1h34m46s 48 1s504ms 8m11s 1m58s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 22 07 3 9m 3m 08 3 5m35s 1m51s 09 3 6m35s 2m11s 10 3 5m47s 1m55s 11 3 6m5s 2m1s 12 3 6m37s 2m12s 13 3 5m32s 1m50s 14 3 6m3s 2m1s 15 3 5m45s 1m55s 16 3 5m29s 1m49s 17 3 5m30s 1m50s 18 3 5m27s 1m49s 19 3 5m13s 1m44s 20 3 5m25s 1m48s 21 3 5m16s 1m45s 22 3 5m19s 1m46s [ User: intelifix - Total duration: 1h34m46s - Times executed: 48 ]
[ Application: psql - Total duration: 1h34m46s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-22 07:13:13 Duration: 8m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-22 09:11:18 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-22 12:11:12 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: psql
2 1h21m33s 190 150ms 8m20s 25s754ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 22 06 1 902ms 902ms 07 18 11m47s 39s289ms 08 19 20m28s 1m4s 09 22 7m34s 20s642ms 10 13 17m8s 1m19s 11 13 1m32s 7s86ms 12 6 2s793ms 465ms 13 12 14s308ms 1s192ms 14 34 5m49s 10s279ms 15 17 28s445ms 1s673ms 16 18 7m6s 23s667ms 17 17 9m20s 32s992ms [ User: intelifix - Total duration: 1h21m33s - Times executed: 190 ]
[ Application: [unknown] - Total duration: 1h21m33s - Times executed: 190 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030206, 0503 )', '/var/www/html/tmp/nf_carga_lotes_0503.xlsx');
Date: 2026-09-22 17:13:45 Duration: 8m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030176, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-22 09:52:21 Duration: 6m29s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030155, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-22 07:32:57 Duration: 6m18s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h2m9s 47 252ms 3m40s 1m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 22 07 3 5m11s 1m43s 08 2 31s171ms 15s585ms 09 3 4m14s 1m24s 10 3 4m5s 1m21s 11 3 4m15s 1m25s 12 3 4m11s 1m23s 13 3 3m58s 1m19s 14 3 4m13s 1m24s 15 3 4m12s 1m24s 16 3 3m59s 1m19s 17 3 3m57s 1m19s 18 3 3m58s 1m19s 19 3 3m45s 1m15s 20 3 3m53s 1m17s 21 3 3m47s 1m15s 22 3 3m53s 1m17s [ User: intelifix - Total duration: 1h2m9s - Times executed: 47 ]
[ Application: psql - Total duration: 1h2m9s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-22 11:15:15 Duration: 3m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-22 15:14:57 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-22 07:19:01 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql
4 21m23s 3 3m1s 10m56s 7m7s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 22 05 3 21m23s 7m7s [ User: intelifix - Total duration: 21m23s - Times executed: 3 ]
[ Application: psql - Total duration: 21m23s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-22 05:10:57 Duration: 10m56s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-22 05:18:23 Duration: 7m26s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-22 05:21:25 Duration: 3m1s Database: contagem User: intelifix Remote: [local] Application: psql
5 15m52s 1,114 150ms 6s292ms 855ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 22 07 4 889ms 222ms 08 83 1m27s 1s57ms 09 121 1m42s 845ms 10 145 2m1s 834ms 11 140 1m50s 791ms 12 35 40s305ms 1s151ms 13 66 54s220ms 821ms 14 182 2m20s 771ms 15 157 2m5s 801ms 16 127 1m56s 916ms 17 54 53s40ms 982ms [ User: intelifix - Total duration: 15m52s - Times executed: 1114 ]
[ Application: [unknown] - Total duration: 15m52s - Times executed: 1114 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289154, 452, '835099915004793,241667730208,241596819112,241697280522,241658232446,241704794756,241661653857,241608254257,241660472238,241712803237,241680747190,241667789809,241709400515,230040273941,230040276264', '',0320,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-22 09:44:53 Duration: 6s292ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289675, 507, 'ZTEEQNNPAU00059,9C635B995B28,9C635B995B2D,KAOND3A8C579', '',0319,00,'[{"item":"0","qrcode":""}]','$$','', 00);
Date: 2026-09-22 16:25:06 Duration: 6s138ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (138056, 397, 'ZTE3ANNR3J07095,F4E84F86F4AA,F4E84F86F4AB,ZTEGD97B7D81$ZTE3ANNRB757868,5872C9938579,5872C993857A,ZTEGDC620CDF$ZTE3ANNQ4A12137,3CF9F0AB14BC,3CF9F0AB14BD,ZTEGD6416E28$ZTE3ANNRCB42348,D8313921AF86,D8313921AF87,ZTEGDD2A5B01$ZTE3ANNRB735528,5872C99179E1,5872C99179E2,ZTEGDC61B59B$ZTE3ANNR2Q15383,F4E84F821C8A,F4E84F821C8B,ZTEGD97AAED1$ZTE3ANNRB748213,5872C992A32F,5872C992A330,ZTEGDC61E728$ZTE3ANNR5W29768,48D682313D7A,48D682313D7B,ZTEGDB007447$ZTE3ANNQ9300216,843C99329A4D,843C99329A4E,ZTEGD7BBBCCF$ZTE3ANNQ9J02929,843C992C15DB,843C992C15DC,ZTEGD7BB141C$ZTE3ANNR6R54055,48D6823A77AC,48D6823A77AD,ZTEGDB01FDFA$ZTE3ANNQ8103138,689E29BC2857,689E29BC2858,ZTEGD7B746D2$ZTE3ANNR5W38106,48D6823200E6,48D6823200E7,ZTEGDB0094D9$ZTE3ANNR4N25780,4896D957B750,4896D957B751,ZTEGD97F8479$ZTE3ANNR9W02754,D89A0DA89CAF,D89A0DA89CB0,ZTEGDB161C6D$ZTE3ANNR4N34553,4896D95884EE,4896D95884EF,ZTEGD97FA6BE$ZTE3ANNT3H79076,D831399E00F0,D831399E00F1,ZTEGDD330583$ZTE3ANNR6R26402,48D68237EF8E,48D68237EF8F,ZTEGDB0191F5$ZTE3ANNR2Q03288,F4E84F810110,F4E84F810111,ZTEGD97A7F92$ZTE3ANNRCB40369,D83139218124,D83139218125,ZTEGDD2A5346', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-22 15:54:43 Duration: 5s69ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
6 13m28s 63 10s266ms 1m6s 12s840ms create table temp0000292050 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 22 07 11 2m52s 15s681ms 08 22 4m1s 10s976ms 09 24 4m36s 11s511ms 10 6 1m58s 19s788ms [ User: intelifix - Total duration: 13m28s - Times executed: 63 ]
[ Application: [unknown] - Total duration: 13m28s - Times executed: 63 ]
-
CREATE TABLE temp0000292050 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 07:24:35 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292050 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 10:44:28 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292050 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 09:34:37 Duration: 12s837ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 11m43s 68 985ms 1m22s 10s340ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 22 07 3 25s807ms 8s602ms 08 1 5s399ms 5s399ms 09 4 16s944ms 4s236ms 10 7 2m21s 20s213ms 11 5 1m46s 21s380ms 12 3 5s154ms 1s718ms 13 6 44s289ms 7s381ms 14 9 1m25s 9s459ms 15 10 1m42s 10s244ms 16 6 1m23s 13s963ms 17 14 1m25s 6s127ms [ User: intelifix - Total duration: 11m43s - Times executed: 68 ]
[ Application: [unknown] - Total duration: 11m43s - Times executed: 68 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-21', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-22 10:14:03 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-22', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-22 11:12:17 Duration: 40s720ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-22', 0416, '', '', 0, 6, '2026-09-01');
Date: 2026-09-22 11:39:44 Duration: 32s299ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10m41s 154 229ms 47s534ms 4s168ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 22 00 6 1m20s 13s406ms 01 6 32s638ms 5s439ms 02 6 36s861ms 6s143ms 03 5 38s391ms 7s678ms 04 6 34s432ms 5s738ms 05 4 16s686ms 4s171ms 07 9 38s133ms 4s237ms 08 13 50s938ms 3s918ms 09 12 44s331ms 3s694ms 10 12 45s48ms 3s754ms 11 12 40s46ms 3s337ms 12 10 20s657ms 2s65ms 13 7 6s912ms 987ms 14 9 32s778ms 3s642ms 15 12 44s628ms 3s719ms 16 10 22s632ms 2s263ms 17 4 2s506ms 626ms 21 5 22s742ms 4s548ms 22 6 31s158ms 5s193ms [ User: intelifix - Total duration: 10m41s - Times executed: 154 ]
[ Application: psql - Total duration: 10m41s - Times executed: 154 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-22 00:05:49 Duration: 47s534ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-22 03:15:14 Duration: 13s146ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-22 02:45:12 Duration: 10s966ms Database: rio User: intelifix Remote: [local] Application: psql
9 7m23s 663 150ms 5s799ms 669ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 22 07 2 1s540ms 770ms 08 56 45s293ms 808ms 09 99 1m3s 642ms 10 93 1m1s 658ms 11 105 1m9s 665ms 12 10 5s912ms 591ms 13 66 40s588ms 614ms 14 79 43s594ms 551ms 15 75 44s766ms 596ms 16 53 52s222ms 985ms 17 25 15s260ms 610ms [ User: intelifix - Total duration: 7m23s - Times executed: 663 ]
[ Application: [unknown] - Total duration: 7m23s - Times executed: 663 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "289427", "modelo" : "463", "itens" : "241758303940,241748756173,241724398701,241736769908,241784076163,241780504356,241748963444,241783478899,241753718284,241734387071,241719448789,241753703031,241723120103,241722911822,241789429402,241723145660,241756965156,241719298595,241725541630,241752968908,241737081634,241748965161,241722322539,241749931429,241734621517,241784588289,241755715977,241749972645,241751832445,241719175374,241720330224,241737029810,241781737900,241719259197,241781861930,241719273846,241758258403,241752388693,241736416383,241736954954,241753851632,241757058094,241722091327,241758023554,241785731219,241723948803,241754316884,241722047887,241720426977,241720356970,241754220815,241750283539,241720705770,241755716987,241750321422,241783437178,241753767279,241720286380,241750363042,241754725667", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-22 08:13:08 Duration: 5s799ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "289672", "modelo" : "463", "itens" : "241783558504,241783541937,241782502834,241782577790,241794062537,241725359715,241748196062,241706159299,241784128592,241748914045,241754724152,241758634253,241751061326,241723051634,241748279101,241784105661,241753204666,241751973244,241781546163,241720706174,241719066676,241735000623,241704939696,241723826568,241789198492,241755627584,241720317494,241754174244,241753877694,241722082235,241781480221,241794437275,241784601524,241782563850,241751508697,241784525556,241751063144,241750748892,241756873352,241720872936,241720500420,241721492828,241720064361,241784488707,241722517080,241779508792,241736627896,241751743446,241753754147,241781973355,241794481725,241735349297,241751080722,241789895261,241755636474,241736841835,241758560105,241735445570,241786281228,241722428990", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-22 16:03:00 Duration: 3s366ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "289672", "modelo" : "463", "itens" : "241720460214,241782561527,241755531414,241755846472,241754632628,241754158989,241784695270,241755918095,241735036181,241725791228,241736774858,241722579713,241779562435,241757300218,241725807592,241718859002,241719194747,241750549401,241736952025,241750512832,241736654667,241758584450,241705065669,241721720404,241784569196,241784168293,241737867276,241783547896,241758815359,241755909408,241705908085,241719465963,241736838703,241755111620,241790293639,241757110020,241782677171,241782077483,241787350715,241751067487,241794364564,241720724257,241758029312,241750063540,241724060307,241748557691,241750234769,241758646173,241721002242,241757404144,241723269006,241735452137,241750553038,241735730223,241784451734,241784462947,241755936077,241753552736,241758614857,241781571823", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-22 16:19:15 Duration: 3s264ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7m20s 148 162ms 14s808ms 2s974ms call rs_giga_triagem (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 22 00 7 29s847ms 4s263ms 01 6 15s227ms 2s537ms 02 6 15s364ms 2s560ms 03 6 16s171ms 2s695ms 04 6 14s871ms 2s478ms 05 6 18s736ms 3s122ms 06 6 15s271ms 2s545ms 07 7 19s183ms 2s740ms 08 8 21s559ms 2s694ms 09 6 16s957ms 2s826ms 10 7 20s459ms 2s922ms 11 7 23s253ms 3s321ms 12 7 17s640ms 2s520ms 13 6 18s550ms 3s91ms 14 8 22s101ms 2s762ms 15 6 20s57ms 3s342ms 16 6 19s902ms 3s317ms 17 6 20s703ms 3s450ms 18 6 18s472ms 3s78ms 19 6 17s203ms 2s867ms 20 7 22s563ms 3s223ms 21 6 17s915ms 2s985ms 22 6 18s278ms 3s46ms [ User: intelifix - Total duration: 7m20s - Times executed: 148 ]
[ Application: psql - Total duration: 7m20s - Times executed: 148 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-22 00:06:04 Duration: 14s808ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-22 11:15:11 Duration: 7s115ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-22 08:15:16 Duration: 7s8ms Database: rio User: intelifix Remote: [local] Application: psql
11 7m3s 39 10s162ms 12s271ms 10s866ms create table temp0000292160 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 22 16 10 1m46s 10s677ms 17 29 5m17s 10s932ms [ User: intelifix - Total duration: 7m3s - Times executed: 39 ]
[ Application: [unknown] - Total duration: 7m3s - Times executed: 39 ]
-
CREATE TABLE temp0000292160 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 17:06:00 Duration: 12s271ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292160 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 16:47:20 Duration: 11s879ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292160 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 17:05:22 Duration: 11s697ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 5m24s 26 10s933ms 36s16ms 12s489ms create table temp0000292132 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 22 14 9 1m42s 11s366ms 15 15 3m20s 13s341ms 16 2 22s314ms 11s157ms [ User: intelifix - Total duration: 5m24s - Times executed: 26 ]
[ Application: [unknown] - Total duration: 5m24s - Times executed: 26 ]
-
CREATE TABLE temp0000292132 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 15:09:15 Duration: 36s16ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292132 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 15:58:07 Duration: 13s658ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292132 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 15:21:08 Duration: 12s458ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 4m51s 44 179ms 43s376ms 6s620ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 22 07 2 46s201ms 23s100ms 08 5 19s588ms 3s917ms 09 9 1m9s 7s679ms 10 2 28s170ms 14s85ms 11 5 42s334ms 8s466ms 13 2 20s613ms 10s306ms 14 5 11s265ms 2s253ms 15 7 33s372ms 4s767ms 16 3 8s666ms 2s888ms 17 4 11s955ms 2s988ms [ User: intelifix - Total duration: 4m51s - Times executed: 44 ]
[ Application: psql - Total duration: 4m51s - Times executed: 44 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030155);
Date: 2026-09-22 07:26:53 Duration: 43s376ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030171);
Date: 2026-09-22 09:29:38 Duration: 27s267ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030179);
Date: 2026-09-22 10:45:00 Duration: 24s737ms Database: rio User: intelifix Remote: [local] Application: psql
14 3m36s 1 3m36s 3m36s 3m36s select * from rs_smart_fiscal_saida () notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 22 08 1 3m36s 3m36s [ User: intelifix - Total duration: 3m36s - Times executed: 1 ]
[ Application: psql - Total duration: 3m36s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-09-22 08:14:35 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql
15 3m12s 39 151ms 1m24s 4s925ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 22 07 4 1s227ms 306ms 08 8 2s598ms 324ms 09 11 20s789ms 1s889ms 10 1 227ms 227ms 11 3 2m29s 49s965ms 13 1 229ms 229ms 14 3 862ms 287ms 15 3 777ms 259ms 16 1 199ms 199ms 17 4 15s282ms 3s820ms [ User: intelifix - Total duration: 3m12s - Times executed: 39 ]
[ Application: psql - Total duration: 3m12s - Times executed: 39 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030182);
Date: 2026-09-22 11:42:34 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030180);
Date: 2026-09-22 11:36:39 Duration: 57s780ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030206);
Date: 2026-09-22 17:05:23 Duration: 14s678ms Database: rio User: intelifix Remote: [local] Application: psql
16 2m19s 4 4s953ms 1m5s 34s755ms 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 Sep 22 20 2 1m9s 34s517ms 23 2 1m9s 34s992ms [ User: intelifix - Total duration: 2m19s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m19s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-22 23:16:40 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-22 20:08:44 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-22 20:10:44 Duration: 4s954ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 2m10s 399 150ms 1s494ms 326ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 22 09 81 31s122ms 384ms 10 141 46s142ms 327ms 11 68 23s904ms 351ms 12 3 797ms 265ms 13 69 18s861ms 273ms 14 27 5s287ms 195ms 15 10 4s99ms 409ms [ User: intelifix - Total duration: 2m10s - Times executed: 399 ]
[ Application: [unknown] - Total duration: 2m10s - Times executed: 399 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57786","seriais":"216382048697,216589335774,216578867479,184283662835,216774560204,216577757988,216487964343,216780627989,216382426366,216763161527,216806101217","usuario":"420","observacao":""}');
Date: 2026-09-22 09:41:59 Duration: 1s494ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57785","seriais":"229661544858,216942059097,229664624867,229808875656,229811163860,229668560123,229669064750,216936625470,229780370204,229690810319,229813814556,229811095772,229748344665,229786457082,229784241334,229733788294,229754473748,229809344748,229736484450,229781128189,229751824466,229726823238,229752855060,229808150525,229737199907,229755915471,229686519494,216935989920,229753875575,216944730325,229673462430,229662632630,229667876385,229815886576,216943435259,229879747174","usuario":"416","observacao":""}');
Date: 2026-09-22 09:47:33 Duration: 1s476ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57786","seriais":"241730938081,241727040104,241726858390,241728554864,241636039808,241692618696,241704290409,241731214753,241704363547,241622542038,241600967799,241730926161,241695582937,241676730312,241656810927,241695495779,241692689310,241700946479,230049403654,241676676164,241708853536,241676756879,241713690103,241713748895,241653874141,241717160307,241651612529,241622543250,241654350709,241680478803,241601115064,241680013954,241653124966,241646314144,241727490810,241606698303,241713044349,241728649294,241659799007,241731250010,241729485471,241647375471,241680341517,241728718695,241717127575,241731246978,241598860928,241704164358,241689204761","usuario":"416","observacao":""}');
Date: 2026-09-22 11:59:46 Duration: 1s451ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
18 2m3s 9 10s762ms 33s433ms 13s764ms create table temp0000292060 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 22 09 4 45s590ms 11s397ms 11 5 1m18s 15s658ms [ User: intelifix - Total duration: 2m3s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 2m3s - Times executed: 9 ]
-
CREATE TABLE temp0000292060 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 11:34:40 Duration: 33s433ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292060 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 09:40:24 Duration: 11s853ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292060 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 11:41:21 Duration: 11s651ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 2m 9 11s19ms 29s482ms 13s336ms create table temp0000292118 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 22 13 6 1m25s 14s329ms 14 3 34s54ms 11s351ms [ User: intelifix - Total duration: 2m - Times executed: 9 ]
[ Application: [unknown] - Total duration: 2m - Times executed: 9 ]
-
CREATE TABLE temp0000292118 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 13:27:26 Duration: 29s482ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292118 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 13:30:16 Duration: 11s895ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292118 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 14:05:12 Duration: 11s817ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 1m53s 36 2s799ms 6s233ms 3s150ms create table temp0000292160 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 22 16 11 32s13ms 2s910ms 17 25 1m21s 3s256ms [ User: intelifix - Total duration: 1m53s - Times executed: 36 ]
[ Application: [unknown] - Total duration: 1m53s - Times executed: 36 ]
-
CREATE TABLE temp0000292160 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"17-09-2026", "ate" :"22-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-22 17:08:25 Duration: 6s233ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292160 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"17-09-2026", "ate" :"22-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-22 17:11:03 Duration: 3s734ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292160 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"17-09-2026", "ate" :"22-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-22 17:36:01 Duration: 3s544ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,114 15m52s 150ms 6s292ms 855ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 22 07 4 889ms 222ms 08 83 1m27s 1s57ms 09 121 1m42s 845ms 10 145 2m1s 834ms 11 140 1m50s 791ms 12 35 40s305ms 1s151ms 13 66 54s220ms 821ms 14 182 2m20s 771ms 15 157 2m5s 801ms 16 127 1m56s 916ms 17 54 53s40ms 982ms [ User: intelifix - Total duration: 15m52s - Times executed: 1114 ]
[ Application: [unknown] - Total duration: 15m52s - Times executed: 1114 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289154, 452, '835099915004793,241667730208,241596819112,241697280522,241658232446,241704794756,241661653857,241608254257,241660472238,241712803237,241680747190,241667789809,241709400515,230040273941,230040276264', '',0320,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-22 09:44:53 Duration: 6s292ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289675, 507, 'ZTEEQNNPAU00059,9C635B995B28,9C635B995B2D,KAOND3A8C579', '',0319,00,'[{"item":"0","qrcode":""}]','$$','', 00);
Date: 2026-09-22 16:25:06 Duration: 6s138ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (138056, 397, 'ZTE3ANNR3J07095,F4E84F86F4AA,F4E84F86F4AB,ZTEGD97B7D81$ZTE3ANNRB757868,5872C9938579,5872C993857A,ZTEGDC620CDF$ZTE3ANNQ4A12137,3CF9F0AB14BC,3CF9F0AB14BD,ZTEGD6416E28$ZTE3ANNRCB42348,D8313921AF86,D8313921AF87,ZTEGDD2A5B01$ZTE3ANNRB735528,5872C99179E1,5872C99179E2,ZTEGDC61B59B$ZTE3ANNR2Q15383,F4E84F821C8A,F4E84F821C8B,ZTEGD97AAED1$ZTE3ANNRB748213,5872C992A32F,5872C992A330,ZTEGDC61E728$ZTE3ANNR5W29768,48D682313D7A,48D682313D7B,ZTEGDB007447$ZTE3ANNQ9300216,843C99329A4D,843C99329A4E,ZTEGD7BBBCCF$ZTE3ANNQ9J02929,843C992C15DB,843C992C15DC,ZTEGD7BB141C$ZTE3ANNR6R54055,48D6823A77AC,48D6823A77AD,ZTEGDB01FDFA$ZTE3ANNQ8103138,689E29BC2857,689E29BC2858,ZTEGD7B746D2$ZTE3ANNR5W38106,48D6823200E6,48D6823200E7,ZTEGDB0094D9$ZTE3ANNR4N25780,4896D957B750,4896D957B751,ZTEGD97F8479$ZTE3ANNR9W02754,D89A0DA89CAF,D89A0DA89CB0,ZTEGDB161C6D$ZTE3ANNR4N34553,4896D95884EE,4896D95884EF,ZTEGD97FA6BE$ZTE3ANNT3H79076,D831399E00F0,D831399E00F1,ZTEGDD330583$ZTE3ANNR6R26402,48D68237EF8E,48D68237EF8F,ZTEGDB0191F5$ZTE3ANNR2Q03288,F4E84F810110,F4E84F810111,ZTEGD97A7F92$ZTE3ANNRCB40369,D83139218124,D83139218125,ZTEGDD2A5346', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-22 15:54:43 Duration: 5s69ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
2 663 7m23s 150ms 5s799ms 669ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 22 07 2 1s540ms 770ms 08 56 45s293ms 808ms 09 99 1m3s 642ms 10 93 1m1s 658ms 11 105 1m9s 665ms 12 10 5s912ms 591ms 13 66 40s588ms 614ms 14 79 43s594ms 551ms 15 75 44s766ms 596ms 16 53 52s222ms 985ms 17 25 15s260ms 610ms [ User: intelifix - Total duration: 7m23s - Times executed: 663 ]
[ Application: [unknown] - Total duration: 7m23s - Times executed: 663 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "289427", "modelo" : "463", "itens" : "241758303940,241748756173,241724398701,241736769908,241784076163,241780504356,241748963444,241783478899,241753718284,241734387071,241719448789,241753703031,241723120103,241722911822,241789429402,241723145660,241756965156,241719298595,241725541630,241752968908,241737081634,241748965161,241722322539,241749931429,241734621517,241784588289,241755715977,241749972645,241751832445,241719175374,241720330224,241737029810,241781737900,241719259197,241781861930,241719273846,241758258403,241752388693,241736416383,241736954954,241753851632,241757058094,241722091327,241758023554,241785731219,241723948803,241754316884,241722047887,241720426977,241720356970,241754220815,241750283539,241720705770,241755716987,241750321422,241783437178,241753767279,241720286380,241750363042,241754725667", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-22 08:13:08 Duration: 5s799ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "289672", "modelo" : "463", "itens" : "241783558504,241783541937,241782502834,241782577790,241794062537,241725359715,241748196062,241706159299,241784128592,241748914045,241754724152,241758634253,241751061326,241723051634,241748279101,241784105661,241753204666,241751973244,241781546163,241720706174,241719066676,241735000623,241704939696,241723826568,241789198492,241755627584,241720317494,241754174244,241753877694,241722082235,241781480221,241794437275,241784601524,241782563850,241751508697,241784525556,241751063144,241750748892,241756873352,241720872936,241720500420,241721492828,241720064361,241784488707,241722517080,241779508792,241736627896,241751743446,241753754147,241781973355,241794481725,241735349297,241751080722,241789895261,241755636474,241736841835,241758560105,241735445570,241786281228,241722428990", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-22 16:03:00 Duration: 3s366ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "289672", "modelo" : "463", "itens" : "241720460214,241782561527,241755531414,241755846472,241754632628,241754158989,241784695270,241755918095,241735036181,241725791228,241736774858,241722579713,241779562435,241757300218,241725807592,241718859002,241719194747,241750549401,241736952025,241750512832,241736654667,241758584450,241705065669,241721720404,241784569196,241784168293,241737867276,241783547896,241758815359,241755909408,241705908085,241719465963,241736838703,241755111620,241790293639,241757110020,241782677171,241782077483,241787350715,241751067487,241794364564,241720724257,241758029312,241750063540,241724060307,241748557691,241750234769,241758646173,241721002242,241757404144,241723269006,241735452137,241750553038,241735730223,241784451734,241784462947,241755936077,241753552736,241758614857,241781571823", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-22 16:19:15 Duration: 3s264ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 399 2m10s 150ms 1s494ms 326ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 22 09 81 31s122ms 384ms 10 141 46s142ms 327ms 11 68 23s904ms 351ms 12 3 797ms 265ms 13 69 18s861ms 273ms 14 27 5s287ms 195ms 15 10 4s99ms 409ms [ User: intelifix - Total duration: 2m10s - Times executed: 399 ]
[ Application: [unknown] - Total duration: 2m10s - Times executed: 399 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57786","seriais":"216382048697,216589335774,216578867479,184283662835,216774560204,216577757988,216487964343,216780627989,216382426366,216763161527,216806101217","usuario":"420","observacao":""}');
Date: 2026-09-22 09:41:59 Duration: 1s494ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57785","seriais":"229661544858,216942059097,229664624867,229808875656,229811163860,229668560123,229669064750,216936625470,229780370204,229690810319,229813814556,229811095772,229748344665,229786457082,229784241334,229733788294,229754473748,229809344748,229736484450,229781128189,229751824466,229726823238,229752855060,229808150525,229737199907,229755915471,229686519494,216935989920,229753875575,216944730325,229673462430,229662632630,229667876385,229815886576,216943435259,229879747174","usuario":"416","observacao":""}');
Date: 2026-09-22 09:47:33 Duration: 1s476ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57786","seriais":"241730938081,241727040104,241726858390,241728554864,241636039808,241692618696,241704290409,241731214753,241704363547,241622542038,241600967799,241730926161,241695582937,241676730312,241656810927,241695495779,241692689310,241700946479,230049403654,241676676164,241708853536,241676756879,241713690103,241713748895,241653874141,241717160307,241651612529,241622543250,241654350709,241680478803,241601115064,241680013954,241653124966,241646314144,241727490810,241606698303,241713044349,241728649294,241659799007,241731250010,241729485471,241647375471,241680341517,241728718695,241717127575,241731246978,241598860928,241704164358,241689204761","usuario":"416","observacao":""}');
Date: 2026-09-22 11:59:46 Duration: 1s451ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 190 1h21m33s 150ms 8m20s 25s754ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 22 06 1 902ms 902ms 07 18 11m47s 39s289ms 08 19 20m28s 1m4s 09 22 7m34s 20s642ms 10 13 17m8s 1m19s 11 13 1m32s 7s86ms 12 6 2s793ms 465ms 13 12 14s308ms 1s192ms 14 34 5m49s 10s279ms 15 17 28s445ms 1s673ms 16 18 7m6s 23s667ms 17 17 9m20s 32s992ms [ User: intelifix - Total duration: 1h21m33s - Times executed: 190 ]
[ Application: [unknown] - Total duration: 1h21m33s - Times executed: 190 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030206, 0503 )', '/var/www/html/tmp/nf_carga_lotes_0503.xlsx');
Date: 2026-09-22 17:13:45 Duration: 8m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030176, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-22 09:52:21 Duration: 6m29s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030155, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-22 07:32:57 Duration: 6m18s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 154 10m41s 229ms 47s534ms 4s168ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 22 00 6 1m20s 13s406ms 01 6 32s638ms 5s439ms 02 6 36s861ms 6s143ms 03 5 38s391ms 7s678ms 04 6 34s432ms 5s738ms 05 4 16s686ms 4s171ms 07 9 38s133ms 4s237ms 08 13 50s938ms 3s918ms 09 12 44s331ms 3s694ms 10 12 45s48ms 3s754ms 11 12 40s46ms 3s337ms 12 10 20s657ms 2s65ms 13 7 6s912ms 987ms 14 9 32s778ms 3s642ms 15 12 44s628ms 3s719ms 16 10 22s632ms 2s263ms 17 4 2s506ms 626ms 21 5 22s742ms 4s548ms 22 6 31s158ms 5s193ms [ User: intelifix - Total duration: 10m41s - Times executed: 154 ]
[ Application: psql - Total duration: 10m41s - Times executed: 154 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-22 00:05:49 Duration: 47s534ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-22 03:15:14 Duration: 13s146ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-22 02:45:12 Duration: 10s966ms Database: rio User: intelifix Remote: [local] Application: psql
6 148 7m20s 162ms 14s808ms 2s974ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 22 00 7 29s847ms 4s263ms 01 6 15s227ms 2s537ms 02 6 15s364ms 2s560ms 03 6 16s171ms 2s695ms 04 6 14s871ms 2s478ms 05 6 18s736ms 3s122ms 06 6 15s271ms 2s545ms 07 7 19s183ms 2s740ms 08 8 21s559ms 2s694ms 09 6 16s957ms 2s826ms 10 7 20s459ms 2s922ms 11 7 23s253ms 3s321ms 12 7 17s640ms 2s520ms 13 6 18s550ms 3s91ms 14 8 22s101ms 2s762ms 15 6 20s57ms 3s342ms 16 6 19s902ms 3s317ms 17 6 20s703ms 3s450ms 18 6 18s472ms 3s78ms 19 6 17s203ms 2s867ms 20 7 22s563ms 3s223ms 21 6 17s915ms 2s985ms 22 6 18s278ms 3s46ms [ User: intelifix - Total duration: 7m20s - Times executed: 148 ]
[ Application: psql - Total duration: 7m20s - Times executed: 148 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-22 00:06:04 Duration: 14s808ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-22 11:15:11 Duration: 7s115ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-22 08:15:16 Duration: 7s8ms Database: rio User: intelifix Remote: [local] Application: psql
7 146 31s404ms 150ms 771ms 215ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 22 01 4 1s816ms 454ms 07 6 1s516ms 252ms 08 19 4s651ms 244ms 09 24 4s909ms 204ms 10 27 5s365ms 198ms 11 27 5s920ms 219ms 12 1 198ms 198ms 13 2 384ms 192ms 14 1 159ms 159ms 15 28 4s904ms 175ms 16 6 1s241ms 206ms 21 1 335ms 335ms [ User: intelifix - Total duration: 31s404ms - Times executed: 146 ]
[ Application: [unknown] - Total duration: 31s404ms - Times executed: 146 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('C412ECEA1C42');
Date: 2026-09-22 08:57:12 Duration: 771ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('CCF3C87B100B');
Date: 2026-09-22 01:04:02 Duration: 618ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('C85D38A01102');
Date: 2026-09-22 01:04:08 Duration: 501ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 91 29s642ms 297ms 477ms 325ms 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 #8
Day Hour Count Duration Avg duration Sep 22 01 2 641ms 320ms 06 1 299ms 299ms 07 5 1s576ms 315ms 08 8 2s571ms 321ms 09 11 3s534ms 321ms 10 9 2s972ms 330ms 11 10 3s387ms 338ms 12 3 923ms 307ms 13 9 2s986ms 331ms 14 10 3s366ms 336ms 15 8 2s549ms 318ms 16 8 2s505ms 313ms 17 6 1s991ms 331ms 21 1 335ms 335ms [ User: lenon - Total duration: 29s642ms - Times executed: 91 ]
[ Application: [unknown] - Total duration: 29s642ms - Times executed: 91 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-22 14:41:02 Duration: 477ms 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-09-22 11:10:02 Duration: 466ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-22 17:42:07 Duration: 433ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 86 1m6s 551ms 2s345ms 771ms create table temp0000227252 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 22 10 15 12s78ms 805ms 11 16 13s370ms 835ms 13 41 30s757ms 750ms 14 13 9s554ms 734ms 16 1 551ms 551ms [ User: intelifix - Total duration: 1m6s - Times executed: 86 ]
[ Application: [unknown] - Total duration: 1m6s - Times executed: 86 ]
-
CREATE TABLE temp0000227252 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"17-09-2026", "ate" :"22-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-22 11:38:15 Duration: 2s345ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000227252 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"17-09-2026", "ate" :"22-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-22 10:37:02 Duration: 2s180ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000227252 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"17-09-2026", "ate" :"22-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-22 13:12:19 Duration: 1s35ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
10 85 34s172ms 171ms 1s107ms 402ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 22 01 1 363ms 363ms 07 4 1s524ms 381ms 08 8 3s780ms 472ms 09 10 3s792ms 379ms 10 9 3s621ms 402ms 11 10 4s452ms 445ms 12 3 1s325ms 441ms 13 9 3s637ms 404ms 14 10 3s947ms 394ms 15 8 3s8ms 376ms 16 8 2s836ms 354ms 17 5 1s883ms 376ms [ User: intelifix - Total duration: 34s172ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 34s172ms - Times executed: 85 ]
-
select * from rs_menu_grants (416, 53, 1);
Date: 2026-09-22 08:14:19 Duration: 1s107ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (449, 81, 1);
Date: 2026-09-22 11:45:32 Duration: 649ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (416, 21, 1);
Date: 2026-09-22 10:22:38 Duration: 641ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
11 84 24s476ms 168ms 1s503ms 291ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 22 07 2 520ms 260ms 08 10 2s705ms 270ms 09 13 3s645ms 280ms 10 5 1s304ms 260ms 11 6 2s898ms 483ms 12 4 1s127ms 281ms 13 6 1s530ms 255ms 14 9 2s454ms 272ms 15 10 3s40ms 304ms 16 4 1s106ms 276ms 17 15 4s141ms 276ms [ User: intelifix - Total duration: 24s476ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 24s476ms - Times executed: 84 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-09-22 11:34:45 Duration: 1s503ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-09-22 15:48:02 Duration: 388ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-22 14:42:32 Duration: 328ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
12 78 1m 163ms 4s179ms 779ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 22 06 3 5s243ms 1s747ms 07 21 22s609ms 1s76ms 08 1 245ms 245ms 09 4 2s915ms 728ms 10 3 1s791ms 597ms 11 1 961ms 961ms 12 4 5s521ms 1s380ms 13 11 5s742ms 522ms 14 13 8s628ms 663ms 15 6 1s645ms 274ms 16 10 5s286ms 528ms 17 1 232ms 232ms [ User: intelifix - Total duration: 1m - Times executed: 78 ]
[ Application: [unknown] - Total duration: 1m - Times executed: 78 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0289005) LIMIT 1;
Date: 2026-09-22 06:55:29 Duration: 4s179ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0289029) LIMIT 1;
Date: 2026-09-22 07:12:20 Duration: 3s853ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0137947) LIMIT 1;
Date: 2026-09-22 12:06:02 Duration: 2s933ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
13 68 11m43s 985ms 1m22s 10s340ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 22 07 3 25s807ms 8s602ms 08 1 5s399ms 5s399ms 09 4 16s944ms 4s236ms 10 7 2m21s 20s213ms 11 5 1m46s 21s380ms 12 3 5s154ms 1s718ms 13 6 44s289ms 7s381ms 14 9 1m25s 9s459ms 15 10 1m42s 10s244ms 16 6 1m23s 13s963ms 17 14 1m25s 6s127ms [ User: intelifix - Total duration: 11m43s - Times executed: 68 ]
[ Application: [unknown] - Total duration: 11m43s - Times executed: 68 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-21', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-22 10:14:03 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-22', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-22 11:12:17 Duration: 40s720ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-22', 0416, '', '', 0, 6, '2026-09-01');
Date: 2026-09-22 11:39:44 Duration: 32s299ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 65 17s319ms 151ms 915ms 266ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 22 07 9 2s832ms 314ms 08 5 1s162ms 232ms 09 7 1s710ms 244ms 10 8 2s215ms 276ms 11 7 1s437ms 205ms 12 12 3s433ms 286ms 13 3 475ms 158ms 14 2 560ms 280ms 15 7 2s30ms 290ms 16 3 875ms 291ms 17 2 586ms 293ms [ User: intelifix - Total duration: 17s319ms - Times executed: 65 ]
[ Application: [unknown] - Total duration: 17s319ms - Times executed: 65 ]
-
SELECT * FROM RS_TRIAGEM (401, 5, '113', 3, 'C4447D0AF727,40EEDDA4877D,AC751D12F296,4857028AF5A2,485702A73FCA,2841C68A2DA6,C4447D45BD36,3C15FB38D8A9,AC751D1749AA', NULL, NULL, 0126, 00);
Date: 2026-09-22 15:48:19 Duration: 915ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '229952821030,229955163233,229939414053,229906311126,229906757891,230008517777,229992639820,229958959911,229945492525,229970384651', NULL, NULL, 0287, 00);
Date: 2026-09-22 07:39:18 Duration: 686ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '241642759409,241634286079,241624654466,241632474567,241626620820,241613700311,241600375362,241613868384', NULL, NULL, 0454, 00);
Date: 2026-09-22 12:49:29 Duration: 520ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 63 13m28s 10s266ms 1m6s 12s840ms create table temp0000292050 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 22 07 11 2m52s 15s681ms 08 22 4m1s 10s976ms 09 24 4m36s 11s511ms 10 6 1m58s 19s788ms [ User: intelifix - Total duration: 13m28s - Times executed: 63 ]
[ Application: [unknown] - Total duration: 13m28s - Times executed: 63 ]
-
CREATE TABLE temp0000292050 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 07:24:35 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292050 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 10:44:28 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292050 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 09:34:37 Duration: 12s837ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 54 1m26s 568ms 20s614ms 1s604ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 22 08 3 2s577ms 859ms 09 3 2s458ms 819ms 10 5 11s556ms 2s311ms 11 4 7s630ms 1s907ms 12 4 5s544ms 1s386ms 13 4 7s186ms 1s796ms 14 4 8s350ms 2s87ms 15 3 2s435ms 811ms 16 3 2s666ms 888ms 17 3 2s147ms 715ms 18 4 22s877ms 5s719ms 19 3 2s407ms 802ms 20 4 3s183ms 795ms 21 3 2s372ms 790ms 22 4 3s269ms 817ms [ User: intelifix - Total duration: 1m26s - Times executed: 54 ]
[ Application: psql - Total duration: 1m26s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-22 18:00:22 Duration: 20s614ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-22 10:40:08 Duration: 7s237ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-22 14:20:06 Duration: 5s5ms Database: rio User: intelifix Remote: [local] Application: psql
17 48 1h34m46s 1s504ms 8m11s 1m58s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 22 07 3 9m 3m 08 3 5m35s 1m51s 09 3 6m35s 2m11s 10 3 5m47s 1m55s 11 3 6m5s 2m1s 12 3 6m37s 2m12s 13 3 5m32s 1m50s 14 3 6m3s 2m1s 15 3 5m45s 1m55s 16 3 5m29s 1m49s 17 3 5m30s 1m50s 18 3 5m27s 1m49s 19 3 5m13s 1m44s 20 3 5m25s 1m48s 21 3 5m16s 1m45s 22 3 5m19s 1m46s [ User: intelifix - Total duration: 1h34m46s - Times executed: 48 ]
[ Application: psql - Total duration: 1h34m46s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-22 07:13:13 Duration: 8m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-22 09:11:18 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-22 12:11:12 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: psql
18 47 1h2m9s 252ms 3m40s 1m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 22 07 3 5m11s 1m43s 08 2 31s171ms 15s585ms 09 3 4m14s 1m24s 10 3 4m5s 1m21s 11 3 4m15s 1m25s 12 3 4m11s 1m23s 13 3 3m58s 1m19s 14 3 4m13s 1m24s 15 3 4m12s 1m24s 16 3 3m59s 1m19s 17 3 3m57s 1m19s 18 3 3m58s 1m19s 19 3 3m45s 1m15s 20 3 3m53s 1m17s 21 3 3m47s 1m15s 22 3 3m53s 1m17s [ User: intelifix - Total duration: 1h2m9s - Times executed: 47 ]
[ Application: psql - Total duration: 1h2m9s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-22 11:15:15 Duration: 3m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-22 15:14:57 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-22 07:19:01 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql
19 44 4m51s 179ms 43s376ms 6s620ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 22 07 2 46s201ms 23s100ms 08 5 19s588ms 3s917ms 09 9 1m9s 7s679ms 10 2 28s170ms 14s85ms 11 5 42s334ms 8s466ms 13 2 20s613ms 10s306ms 14 5 11s265ms 2s253ms 15 7 33s372ms 4s767ms 16 3 8s666ms 2s888ms 17 4 11s955ms 2s988ms [ User: intelifix - Total duration: 4m51s - Times executed: 44 ]
[ Application: psql - Total duration: 4m51s - Times executed: 44 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030155);
Date: 2026-09-22 07:26:53 Duration: 43s376ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030171);
Date: 2026-09-22 09:29:38 Duration: 27s267ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030179);
Date: 2026-09-22 10:45:00 Duration: 24s737ms Database: rio User: intelifix Remote: [local] Application: psql
20 39 7m3s 10s162ms 12s271ms 10s866ms create table temp0000292160 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 22 16 10 1m46s 10s677ms 17 29 5m17s 10s932ms [ User: intelifix - Total duration: 7m3s - Times executed: 39 ]
[ Application: [unknown] - Total duration: 7m3s - Times executed: 39 ]
-
CREATE TABLE temp0000292160 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 17:06:00 Duration: 12s271ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292160 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 16:47:20 Duration: 11s879ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292160 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 17:05:22 Duration: 11s697ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m1s 10m56s 7m7s 3 21m23s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 22 05 3 21m23s 7m7s [ User: intelifix - Total duration: 21m23s - Times executed: 3 ]
[ Application: psql - Total duration: 21m23s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-22 05:10:57 Duration: 10m56s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-22 05:18:23 Duration: 7m26s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-22 05:21:25 Duration: 3m1s Database: contagem User: intelifix Remote: [local] Application: psql
2 3m36s 3m36s 3m36s 1 3m36s select * from rs_smart_fiscal_saida () notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 22 08 1 3m36s 3m36s [ User: intelifix - Total duration: 3m36s - Times executed: 1 ]
[ Application: psql - Total duration: 3m36s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-09-22 08:14:35 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql
3 1s504ms 8m11s 1m58s 48 1h34m46s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 22 07 3 9m 3m 08 3 5m35s 1m51s 09 3 6m35s 2m11s 10 3 5m47s 1m55s 11 3 6m5s 2m1s 12 3 6m37s 2m12s 13 3 5m32s 1m50s 14 3 6m3s 2m1s 15 3 5m45s 1m55s 16 3 5m29s 1m49s 17 3 5m30s 1m50s 18 3 5m27s 1m49s 19 3 5m13s 1m44s 20 3 5m25s 1m48s 21 3 5m16s 1m45s 22 3 5m19s 1m46s [ User: intelifix - Total duration: 1h34m46s - Times executed: 48 ]
[ Application: psql - Total duration: 1h34m46s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-22 07:13:13 Duration: 8m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-22 09:11:18 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-22 12:11:12 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: psql
4 252ms 3m40s 1m19s 47 1h2m9s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 22 07 3 5m11s 1m43s 08 2 31s171ms 15s585ms 09 3 4m14s 1m24s 10 3 4m5s 1m21s 11 3 4m15s 1m25s 12 3 4m11s 1m23s 13 3 3m58s 1m19s 14 3 4m13s 1m24s 15 3 4m12s 1m24s 16 3 3m59s 1m19s 17 3 3m57s 1m19s 18 3 3m58s 1m19s 19 3 3m45s 1m15s 20 3 3m53s 1m17s 21 3 3m47s 1m15s 22 3 3m53s 1m17s [ User: intelifix - Total duration: 1h2m9s - Times executed: 47 ]
[ Application: psql - Total duration: 1h2m9s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-22 11:15:15 Duration: 3m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-22 15:14:57 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-22 07:19:01 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s953ms 1m5s 34s755ms 4 2m19s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 22 20 2 1m9s 34s517ms 23 2 1m9s 34s992ms [ User: intelifix - Total duration: 2m19s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m19s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-22 23:16:40 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-22 20:08:44 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-22 20:10:44 Duration: 4s954ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 150ms 8m20s 25s754ms 190 1h21m33s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 22 06 1 902ms 902ms 07 18 11m47s 39s289ms 08 19 20m28s 1m4s 09 22 7m34s 20s642ms 10 13 17m8s 1m19s 11 13 1m32s 7s86ms 12 6 2s793ms 465ms 13 12 14s308ms 1s192ms 14 34 5m49s 10s279ms 15 17 28s445ms 1s673ms 16 18 7m6s 23s667ms 17 17 9m20s 32s992ms [ User: intelifix - Total duration: 1h21m33s - Times executed: 190 ]
[ Application: [unknown] - Total duration: 1h21m33s - Times executed: 190 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030206, 0503 )', '/var/www/html/tmp/nf_carga_lotes_0503.xlsx');
Date: 2026-09-22 17:13:45 Duration: 8m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030176, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-22 09:52:21 Duration: 6m29s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030155, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-22 07:32:57 Duration: 6m18s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 10s762ms 33s433ms 13s764ms 9 2m3s create table temp0000292060 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 22 09 4 45s590ms 11s397ms 11 5 1m18s 15s658ms [ User: intelifix - Total duration: 2m3s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 2m3s - Times executed: 9 ]
-
CREATE TABLE temp0000292060 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 11:34:40 Duration: 33s433ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292060 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 09:40:24 Duration: 11s853ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292060 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 11:41:21 Duration: 11s651ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 11s19ms 29s482ms 13s336ms 9 2m create table temp0000292118 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 22 13 6 1m25s 14s329ms 14 3 34s54ms 11s351ms [ User: intelifix - Total duration: 2m - Times executed: 9 ]
[ Application: [unknown] - Total duration: 2m - Times executed: 9 ]
-
CREATE TABLE temp0000292118 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 13:27:26 Duration: 29s482ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292118 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 13:30:16 Duration: 11s895ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292118 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 14:05:12 Duration: 11s817ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s266ms 1m6s 12s840ms 63 13m28s create table temp0000292050 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 22 07 11 2m52s 15s681ms 08 22 4m1s 10s976ms 09 24 4m36s 11s511ms 10 6 1m58s 19s788ms [ User: intelifix - Total duration: 13m28s - Times executed: 63 ]
[ Application: [unknown] - Total duration: 13m28s - Times executed: 63 ]
-
CREATE TABLE temp0000292050 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 07:24:35 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292050 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 10:44:28 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292050 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 09:34:37 Duration: 12s837ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s933ms 36s16ms 12s489ms 26 5m24s create table temp0000292132 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 22 14 9 1m42s 11s366ms 15 15 3m20s 13s341ms 16 2 22s314ms 11s157ms [ User: intelifix - Total duration: 5m24s - Times executed: 26 ]
[ Application: [unknown] - Total duration: 5m24s - Times executed: 26 ]
-
CREATE TABLE temp0000292132 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 15:09:15 Duration: 36s16ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292132 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 15:58:07 Duration: 13s658ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292132 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 15:21:08 Duration: 12s458ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s162ms 12s271ms 10s866ms 39 7m3s create table temp0000292160 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 22 16 10 1m46s 10s677ms 17 29 5m17s 10s932ms [ User: intelifix - Total duration: 7m3s - Times executed: 39 ]
[ Application: [unknown] - Total duration: 7m3s - Times executed: 39 ]
-
CREATE TABLE temp0000292160 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 17:06:00 Duration: 12s271ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292160 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 16:47:20 Duration: 11s879ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292160 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-22 17:05:22 Duration: 11s697ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 985ms 1m22s 10s340ms 68 11m43s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 22 07 3 25s807ms 8s602ms 08 1 5s399ms 5s399ms 09 4 16s944ms 4s236ms 10 7 2m21s 20s213ms 11 5 1m46s 21s380ms 12 3 5s154ms 1s718ms 13 6 44s289ms 7s381ms 14 9 1m25s 9s459ms 15 10 1m42s 10s244ms 16 6 1m23s 13s963ms 17 14 1m25s 6s127ms [ User: intelifix - Total duration: 11m43s - Times executed: 68 ]
[ Application: [unknown] - Total duration: 11m43s - Times executed: 68 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-21', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-22 10:14:03 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-22', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-22 11:12:17 Duration: 40s720ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-22', 0416, '', '', 0, 6, '2026-09-01');
Date: 2026-09-22 11:39:44 Duration: 32s299ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 179ms 43s376ms 6s620ms 44 4m51s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 22 07 2 46s201ms 23s100ms 08 5 19s588ms 3s917ms 09 9 1m9s 7s679ms 10 2 28s170ms 14s85ms 11 5 42s334ms 8s466ms 13 2 20s613ms 10s306ms 14 5 11s265ms 2s253ms 15 7 33s372ms 4s767ms 16 3 8s666ms 2s888ms 17 4 11s955ms 2s988ms [ User: intelifix - Total duration: 4m51s - Times executed: 44 ]
[ Application: psql - Total duration: 4m51s - Times executed: 44 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030155);
Date: 2026-09-22 07:26:53 Duration: 43s376ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030171);
Date: 2026-09-22 09:29:38 Duration: 27s267ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030179);
Date: 2026-09-22 10:45:00 Duration: 24s737ms Database: rio User: intelifix Remote: [local] Application: psql
14 151ms 1m24s 4s925ms 39 3m12s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 22 07 4 1s227ms 306ms 08 8 2s598ms 324ms 09 11 20s789ms 1s889ms 10 1 227ms 227ms 11 3 2m29s 49s965ms 13 1 229ms 229ms 14 3 862ms 287ms 15 3 777ms 259ms 16 1 199ms 199ms 17 4 15s282ms 3s820ms [ User: intelifix - Total duration: 3m12s - Times executed: 39 ]
[ Application: psql - Total duration: 3m12s - Times executed: 39 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030182);
Date: 2026-09-22 11:42:34 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030180);
Date: 2026-09-22 11:36:39 Duration: 57s780ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030206);
Date: 2026-09-22 17:05:23 Duration: 14s678ms Database: rio User: intelifix Remote: [local] Application: psql
15 229ms 47s534ms 4s168ms 154 10m41s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 22 00 6 1m20s 13s406ms 01 6 32s638ms 5s439ms 02 6 36s861ms 6s143ms 03 5 38s391ms 7s678ms 04 6 34s432ms 5s738ms 05 4 16s686ms 4s171ms 07 9 38s133ms 4s237ms 08 13 50s938ms 3s918ms 09 12 44s331ms 3s694ms 10 12 45s48ms 3s754ms 11 12 40s46ms 3s337ms 12 10 20s657ms 2s65ms 13 7 6s912ms 987ms 14 9 32s778ms 3s642ms 15 12 44s628ms 3s719ms 16 10 22s632ms 2s263ms 17 4 2s506ms 626ms 21 5 22s742ms 4s548ms 22 6 31s158ms 5s193ms [ User: intelifix - Total duration: 10m41s - Times executed: 154 ]
[ Application: psql - Total duration: 10m41s - Times executed: 154 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-22 00:05:49 Duration: 47s534ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-22 03:15:14 Duration: 13s146ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-22 02:45:12 Duration: 10s966ms Database: rio User: intelifix Remote: [local] Application: psql
16 2s799ms 6s233ms 3s150ms 36 1m53s create table temp0000292160 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 22 16 11 32s13ms 2s910ms 17 25 1m21s 3s256ms [ User: intelifix - Total duration: 1m53s - Times executed: 36 ]
[ Application: [unknown] - Total duration: 1m53s - Times executed: 36 ]
-
CREATE TABLE temp0000292160 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"17-09-2026", "ate" :"22-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-22 17:08:25 Duration: 6s233ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292160 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"17-09-2026", "ate" :"22-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-22 17:11:03 Duration: 3s734ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292160 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"17-09-2026", "ate" :"22-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-22 17:36:01 Duration: 3s544ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 162ms 14s808ms 2s974ms 148 7m20s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 22 00 7 29s847ms 4s263ms 01 6 15s227ms 2s537ms 02 6 15s364ms 2s560ms 03 6 16s171ms 2s695ms 04 6 14s871ms 2s478ms 05 6 18s736ms 3s122ms 06 6 15s271ms 2s545ms 07 7 19s183ms 2s740ms 08 8 21s559ms 2s694ms 09 6 16s957ms 2s826ms 10 7 20s459ms 2s922ms 11 7 23s253ms 3s321ms 12 7 17s640ms 2s520ms 13 6 18s550ms 3s91ms 14 8 22s101ms 2s762ms 15 6 20s57ms 3s342ms 16 6 19s902ms 3s317ms 17 6 20s703ms 3s450ms 18 6 18s472ms 3s78ms 19 6 17s203ms 2s867ms 20 7 22s563ms 3s223ms 21 6 17s915ms 2s985ms 22 6 18s278ms 3s46ms [ User: intelifix - Total duration: 7m20s - Times executed: 148 ]
[ Application: psql - Total duration: 7m20s - Times executed: 148 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-22 00:06:04 Duration: 14s808ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-22 11:15:11 Duration: 7s115ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-22 08:15:16 Duration: 7s8ms Database: rio User: intelifix Remote: [local] Application: psql
18 568ms 20s614ms 1s604ms 54 1m26s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 22 08 3 2s577ms 859ms 09 3 2s458ms 819ms 10 5 11s556ms 2s311ms 11 4 7s630ms 1s907ms 12 4 5s544ms 1s386ms 13 4 7s186ms 1s796ms 14 4 8s350ms 2s87ms 15 3 2s435ms 811ms 16 3 2s666ms 888ms 17 3 2s147ms 715ms 18 4 22s877ms 5s719ms 19 3 2s407ms 802ms 20 4 3s183ms 795ms 21 3 2s372ms 790ms 22 4 3s269ms 817ms [ User: intelifix - Total duration: 1m26s - Times executed: 54 ]
[ Application: psql - Total duration: 1m26s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-22 18:00:22 Duration: 20s614ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-22 10:40:08 Duration: 7s237ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-22 14:20:06 Duration: 5s5ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 6s292ms 855ms 1,114 15m52s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 22 07 4 889ms 222ms 08 83 1m27s 1s57ms 09 121 1m42s 845ms 10 145 2m1s 834ms 11 140 1m50s 791ms 12 35 40s305ms 1s151ms 13 66 54s220ms 821ms 14 182 2m20s 771ms 15 157 2m5s 801ms 16 127 1m56s 916ms 17 54 53s40ms 982ms [ User: intelifix - Total duration: 15m52s - Times executed: 1114 ]
[ Application: [unknown] - Total duration: 15m52s - Times executed: 1114 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289154, 452, '835099915004793,241667730208,241596819112,241697280522,241658232446,241704794756,241661653857,241608254257,241660472238,241712803237,241680747190,241667789809,241709400515,230040273941,230040276264', '',0320,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-22 09:44:53 Duration: 6s292ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289675, 507, 'ZTEEQNNPAU00059,9C635B995B28,9C635B995B2D,KAOND3A8C579', '',0319,00,'[{"item":"0","qrcode":""}]','$$','', 00);
Date: 2026-09-22 16:25:06 Duration: 6s138ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (138056, 397, 'ZTE3ANNR3J07095,F4E84F86F4AA,F4E84F86F4AB,ZTEGD97B7D81$ZTE3ANNRB757868,5872C9938579,5872C993857A,ZTEGDC620CDF$ZTE3ANNQ4A12137,3CF9F0AB14BC,3CF9F0AB14BD,ZTEGD6416E28$ZTE3ANNRCB42348,D8313921AF86,D8313921AF87,ZTEGDD2A5B01$ZTE3ANNRB735528,5872C99179E1,5872C99179E2,ZTEGDC61B59B$ZTE3ANNR2Q15383,F4E84F821C8A,F4E84F821C8B,ZTEGD97AAED1$ZTE3ANNRB748213,5872C992A32F,5872C992A330,ZTEGDC61E728$ZTE3ANNR5W29768,48D682313D7A,48D682313D7B,ZTEGDB007447$ZTE3ANNQ9300216,843C99329A4D,843C99329A4E,ZTEGD7BBBCCF$ZTE3ANNQ9J02929,843C992C15DB,843C992C15DC,ZTEGD7BB141C$ZTE3ANNR6R54055,48D6823A77AC,48D6823A77AD,ZTEGDB01FDFA$ZTE3ANNQ8103138,689E29BC2857,689E29BC2858,ZTEGD7B746D2$ZTE3ANNR5W38106,48D6823200E6,48D6823200E7,ZTEGDB0094D9$ZTE3ANNR4N25780,4896D957B750,4896D957B751,ZTEGD97F8479$ZTE3ANNR9W02754,D89A0DA89CAF,D89A0DA89CB0,ZTEGDB161C6D$ZTE3ANNR4N34553,4896D95884EE,4896D95884EF,ZTEGD97FA6BE$ZTE3ANNT3H79076,D831399E00F0,D831399E00F1,ZTEGDD330583$ZTE3ANNR6R26402,48D68237EF8E,48D68237EF8F,ZTEGDB0191F5$ZTE3ANNR2Q03288,F4E84F810110,F4E84F810111,ZTEGD97A7F92$ZTE3ANNRCB40369,D83139218124,D83139218125,ZTEGDD2A5346', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-22 15:54:43 Duration: 5s69ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
20 163ms 4s179ms 779ms 78 1m select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 22 06 3 5s243ms 1s747ms 07 21 22s609ms 1s76ms 08 1 245ms 245ms 09 4 2s915ms 728ms 10 3 1s791ms 597ms 11 1 961ms 961ms 12 4 5s521ms 1s380ms 13 11 5s742ms 522ms 14 13 8s628ms 663ms 15 6 1s645ms 274ms 16 10 5s286ms 528ms 17 1 232ms 232ms [ User: intelifix - Total duration: 1m - Times executed: 78 ]
[ Application: [unknown] - Total duration: 1m - Times executed: 78 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0289005) LIMIT 1;
Date: 2026-09-22 06:55:29 Duration: 4s179ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0289029) LIMIT 1;
Date: 2026-09-22 07:12:20 Duration: 3s853ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0137947) LIMIT 1;
Date: 2026-09-22 12:06:02 Duration: 2s933ms 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 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 22 12 1 0ms 0ms 13 1 0ms 0ms 18 1 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 3m18s - Times executed: 4 ]
[ Application: psql - Total duration: 3m17s - Times executed: 2 ]
[ Application: [unknown] - Total duration: 1s46ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 17,357 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 52 FATAL entries
- 4290 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,969 Max number of times the same event was reported
- 4,343 Total events found
Rank Times reported Error 1 3,969 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 22 00 59 01 60 02 59 03 55 04 59 05 60 06 59 07 223 08 288 09 402 10 394 11 363 12 179 13 180 14 404 15 333 16 298 17 147 18 60 19 59 20 59 21 60 22 60 23 49 - ERROR: prepared statement "_PLAN0000000029BE0020" does not exist
- ERROR: prepared statement "_PLAN0000000029DE9220" does not exist
- ERROR: prepared statement "_PLAN0000000029DE7B50" does not exist
Statement: DEALLOCATE "_PLAN0000000029BE0020"
Date: 2026-09-22 00:00:57 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029DE9220"
Date: 2026-09-22 00:01:57 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029DE7B50"
Date: 2026-09-22 00:02:58 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 299 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 22 08 43 09 63 10 62 11 60 12 60 13 7 14 1 15 3 - ERROR: syntax error at or near "," at character 28
- ERROR: syntax error at or near "," at character 28
- ERROR: syntax error at or near "," at character 28
Statement: select * from rs_caixa_qr(-,)
Date: 2026-09-22 08:17:07 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(-,)
Date: 2026-09-22 08:18:08 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(-,)
Date: 2026-09-22 08:19:08 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
3 40 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 22 00 1 03 3 04 5 05 5 06 3 07 2 10 2 11 4 12 1 14 6 16 3 17 3 22 2 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-22 00:02:37 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-22 03:45:44 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-22 03:46:00 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
4 8 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 22 09 8 - ERROR: trailing junk after numeric literal at or near "840112C4CDD0" at character 27
- ERROR: trailing junk after numeric literal at or near "840112C4CDD0" at character 27
- ERROR: trailing junk after numeric literal at or near "840112C4CDD0" at character 27
Statement: select * from rs_caixa_qr(840112C4CDD0)
Date: 2026-09-22 09:14:24 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(840112C4CDD0)
Date: 2026-09-22 09:14:24 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(840112C4CDD0)
Date: 2026-09-22 09:14:33 Database: rio Application: [unknown] User: etiquetas Remote: [local]
5 8 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 22 03 8 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-22 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-22 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-22 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
6 6 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 22 09 3 13 2 15 1 - ERROR: column "ib2" does not exist at character 27
- ERROR: column "ib2" does not exist at character 27
- ERROR: column "ib2" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(IB2)
Date: 2026-09-22 09:53:47 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(IB2)
Date: 2026-09-22 09:53:47 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(IB2)
Date: 2026-09-22 09:53:48 Database: rio Application: [unknown] User: etiquetas Remote: [local]
7 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 22 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-22 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-22 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-22 05:32:04 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 Sep 22 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-09-22 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-22 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-22 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
9 2 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 22 10 2 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73904485850065311050)Date: 2026-09-22 10:12:55 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73904485850065311050)Date: 2026-09-22 10:12:56 Database: rio Application: [unknown] User: etiquetas Remote: [local]
10 1 FATAL: database "..." does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 22 22 1 - FATAL: database "jaboatao" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-09-22 22:19:52 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
11 1 ERROR: canceling statement due to statement timeout
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 22 11 1 - ERROR: canceling statement due to statement timeout
Context: PL/pgSQL function rs_equipamento_senha(character varying) line 92 at assignment PL/pgSQL function rs_etiqueta(character varying,integer,boolean) line 164 at assignment
Statement: SELECT DISTINCT mod_mnemonico, macaddress, caidDate: 2026-09-22 11:27:56 Database: rio Application: [unknown] User: etiquetas Remote: [local]
12 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 22 08 1 - ERROR: unterminated quoted string at or near "''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-09-22 08:10:26 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 22 03 1 - LOG: database system was shut down at 2026-09-22 03:05:01 -03
Date: 2026-09-22 03:05:02