-
Global information
- Generated on Sun May 17 23:50:04 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-Wed.log
- Parsed 15,928 log entries in 2s
- Log start from 2026-05-17 00:00:08 to 2026-05-17 23:50:00
-
Overview
Global Stats
- 131 Number of unique normalized queries
- 707 Number of queries
- 2h21m56s Total query duration
- 2026-05-17 00:02:04 First query
- 2026-05-17 23:40:39 Last query
- 5 queries/s at 2026-05-17 23:40:32 Query peak
- 2h21m56s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h21m56s Execute total duration
- 2,587 Number of events
- 7 Number of unique normalized events
- 2,540 Max number of times the same event was reported
- 0 Number of cancellation
- 6 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 12 Number temporary file
- 223.41 MiB Max size of temporary file
- 95.69 MiB Average size of temporary file
- 394 Total number of sessions
- 26 sessions at 2026-05-17 17:09:57 Session peak
- 9d12h5m48s Total duration of sessions
- 34m44s Average duration of sessions
- 1 Average queries per session
- 21s616ms Average queries duration per session
- 34m22s Average idle time per session
- 412 Total number of connections
- 5 connections/s at 2026-05-17 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-05-17 23:40:32 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-05-17 16:11:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-05-17 23:40:32 Date
Queries duration
Key values
- 2h21m56s 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) May 17 00 13 0ms 4s472ms 1s910ms 1s253ms 1s357ms 14s786ms 01 6 0ms 1s340ms 1s281ms 1s230ms 1s275ms 1s340ms 02 6 0ms 1s368ms 1s278ms 1s228ms 1s272ms 1s368ms 03 6 0ms 1s329ms 1s280ms 1s234ms 1s291ms 1s329ms 04 6 0ms 1s344ms 1s258ms 1s219ms 1s237ms 1s344ms 05 11 0ms 1m55s 30s54ms 1s372ms 1m 1m55s 06 13 0ms 2s886ms 1s422ms 1s325ms 1s761ms 7s306ms 07 17 0ms 3m32s 22s949ms 1s572ms 10s242ms 3m54s 08 17 0ms 3m18s 21s636ms 1s332ms 1s566ms 3m45s 09 19 0ms 3m19s 19s505ms 1s380ms 1s748ms 3m47s 10 17 0ms 3m18s 21s703ms 1s300ms 1s730ms 3m46s 11 16 0ms 3m21s 23s174ms 1s288ms 1s397ms 3m48s 12 15 0ms 3m18s 24s467ms 1s266ms 1s324ms 3m45s 13 17 0ms 3m18s 21s614ms 1s317ms 1s491ms 3m44s 14 14 0ms 3m18s 26s215ms 1s292ms 1s314ms 3m45s 15 16 0ms 3m15s 23s164ms 1s286ms 7s31ms 3m42s 16 17 0ms 3m18s 21s630ms 1s291ms 1s336ms 3m45s 17 15 0ms 3m19s 24s540ms 1s265ms 1s316ms 3m46s 18 17 0ms 3m17s 21s578ms 1s309ms 1s402ms 3m44s 19 15 0ms 3m18s 24s475ms 1s284ms 1s369ms 3m45s 20 90 0ms 3m29s 8s362ms 55s231ms 1m13s 4m4s 21 16 0ms 3m19s 23s5ms 1s275ms 1s491ms 3m46s 22 16 0ms 3m20s 23s75ms 1s253ms 1s340ms 3m47s 23 312 0ms 1m1s 5s808ms 1m3s 1m8s 1m13s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 17 00 3 0 1s222ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 1s386ms 0ms 0ms 0ms 07 6 0 1m3s 0ms 0ms 2m15s 08 6 0 59s740ms 0ms 0ms 2m12s 09 8 0 45s158ms 0ms 0ms 2m13s 10 6 0 59s987ms 0ms 0ms 2m13s 11 6 0 1m 0ms 0ms 2m13s 12 6 0 59s764ms 0ms 0ms 2m12s 13 6 0 59s730ms 0ms 0ms 2m13s 14 6 0 59s800ms 0ms 0ms 2m13s 15 6 0 59s260ms 0ms 0ms 2m12s 16 6 0 59s805ms 0ms 0ms 2m13s 17 6 0 59s970ms 0ms 0ms 2m13s 18 6 0 59s628ms 0ms 0ms 2m13s 19 6 0 59s786ms 0ms 0ms 2m13s 20 6 73 9s406ms 0ms 55s231ms 2m15s 21 6 0 59s881ms 0ms 0ms 2m13s 22 6 0 1m 0ms 0ms 2m13s 23 0 312 5s808ms 1m1s 1m3s 1m12s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 17 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 May 17 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second May 17 00 24 0.01/s 01 16 0.00/s 02 17 0.00/s 03 23 0.01/s 04 14 0.00/s 05 21 0.01/s 06 25 0.01/s 07 19 0.01/s 08 15 0.00/s 09 20 0.01/s 10 15 0.00/s 11 18 0.01/s 12 16 0.00/s 13 15 0.00/s 14 12 0.00/s 15 16 0.00/s 16 18 0.01/s 17 17 0.00/s 18 15 0.00/s 19 15 0.00/s 20 19 0.01/s 21 15 0.00/s 22 17 0.00/s 23 10 0.00/s Day Hour Count Average Duration Average idle time May 17 00 11 22m3s 22m 01 23 41m56s 41m56s 02 16 33m43s 33m42s 03 23 17m55s 17m54s 04 14 39m26s 39m25s 05 14 37m30s 37m6s 06 19 35m 35m 07 21 46m 45m42s 08 14 34m10s 33m44s 09 17 31m57s 31m35s 10 17 38m18s 37m56s 11 17 32m23s 32m1s 12 16 35m6s 34m43s 13 14 36m52s 36m25s 14 14 43m7s 42m41s 15 14 34m5s 33m39s 16 17 31m55s 31m34s 17 17 34m57s 34m36s 18 15 39m35s 39m11s 19 16 37m53s 37m30s 20 19 28m20s 27m41s 21 15 39m8s 38m43s 22 17 31m31s 31m9s 23 14 31m10s 29m1s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-05-17 03:05:17 Date
Connections per database
Key values
- brasilia Main Database
- 412 connections Total
Connections per user
Key values
- etiquetas Main User
- 412 connections Total
-
Sessions
Simultaneous sessions
Key values
- 26 sessions Session Peak
- 2026-05-17 17:09:57 Date
Histogram of session times
Key values
- 196 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 394 sessions Total
Sessions per user
Key values
- etiquetas Main User
- 394 sessions Total
Sessions per host
Key values
- [local] Main Host
- 394 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 394 sessions Total
Application Count Total Duration Average Duration [unknown] 124 4d20h35m12s 56m24s app - 177.99.204.34:49474 1 7m20s 7m20s app - 177.99.204.34:49509 2 1h45s 30m22s app - 177.99.204.34:49633 1 15m40s 15m40s app - 177.99.204.34:49655 1 18m53s 18m53s app - 177.99.204.34:49994 1 9m24s 9m24s app - 177.99.204.34:49999 1 4m11s 4m11s app - 177.99.204.34:50021 1 3m6s 3m6s app - 177.99.204.34:50075 1 13m39s 13m39s app - 177.99.204.34:50188 1 5m13s 5m13s app - 177.99.204.34:50312 1 3m7s 3m7s app - 177.99.204.34:50331 1 7m19s 7m19s app - 177.99.204.34:50352 1 7m20s 7m20s app - 177.99.204.34:50495 1 4m10s 4m10s app - 177.99.204.34:50726 1 11m10s 11m10s app - 177.99.204.34:50970 1 4m9s 4m9s app - 177.99.204.34:51042 1 5m15s 5m15s app - 177.99.204.34:51087 1 7m20s 7m20s app - 177.99.204.34:51131 1 9m25s 9m25s app - 177.99.204.34:51173 1 7m7s 7m7s app - 177.99.204.34:51216 1 6m16s 6m16s app - 177.99.204.34:51428 1 3m7s 3m7s app - 177.99.204.34:51442 1 8m22s 8m22s app - 177.99.204.34:51577 1 1h 1h app - 177.99.204.34:51583 1 6m16s 6m16s app - 177.99.204.34:51606 1 10m32s 10m32s app - 177.99.204.34:51613 1 1h 1h app - 177.99.204.34:51725 1 9m24s 9m24s app - 177.99.204.34:51955 1 8m24s 8m24s app - 177.99.204.34:51962 2 1h2m45s 31m22s app - 177.99.204.34:52041 1 9m28s 9m28s app - 177.99.204.34:52048 1 2m4s 2m4s app - 177.99.204.34:52138 1 7m20s 7m20s app - 177.99.204.34:52376 1 10m28s 10m28s app - 177.99.204.34:52438 1 10m28s 10m28s app - 177.99.204.34:52498 1 15m42s 15m42s app - 177.99.204.34:52746 2 29m20s 14m40s app - 177.99.204.34:52757 1 4m10s 4m10s app - 177.99.204.34:52834 1 8m24s 8m24s app - 177.99.204.34:52837 1 7m21s 7m21s app - 177.99.204.34:52894 1 8m22s 8m22s app - 177.99.204.34:53125 1 12m36s 12m36s app - 177.99.204.34:53241 1 7m20s 7m20s app - 177.99.204.34:53376 1 5m12s 5m12s app - 177.99.204.34:53646 1 8m21s 8m21s app - 177.99.204.34:53777 1 7m20s 7m20s app - 177.99.204.34:54206 1 12m34s 12m34s app - 177.99.204.34:54357 1 6m15s 6m15s app - 177.99.204.34:54480 1 8m21s 8m21s app - 177.99.204.34:54513 1 9m24s 9m24s app - 177.99.204.34:54713 1 7m20s 7m20s app - 177.99.204.34:54826 1 7m19s 7m19s app - 177.99.204.34:54841 1 8m23s 8m23s app - 177.99.204.34:54852 1 4m11s 4m11s app - 177.99.204.34:54879 2 1h4m59s 32m29s app - 177.99.204.34:54997 1 4m10s 4m10s app - 177.99.204.34:55053 2 1h2m49s 31m24s app - 177.99.204.34:55142 2 1h5m 32m30s app - 177.99.204.34:55523 2 1h5m3s 32m31s app - 177.99.204.34:55605 1 10m28s 10m28s app - 177.99.204.34:55714 1 15m46s 15m46s app - 177.99.204.34:55724 1 12m38s 12m38s app - 177.99.204.34:55743 1 14m40s 14m40s app - 177.99.204.34:55772 1 7m19s 7m19s app - 177.99.204.34:56099 1 10m31s 10m31s app - 177.99.204.34:56183 1 9m26s 9m26s app - 177.99.204.34:56270 1 6m17s 6m17s app - 177.99.204.34:56285 1 4m10s 4m10s app - 177.99.204.34:56317 1 8m21s 8m21s app - 177.99.204.34:56348 1 8m21s 8m21s app - 177.99.204.34:56417 1 9m26s 9m26s app - 177.99.204.34:56461 1 6m15s 6m15s app - 177.99.204.34:56549 1 10m28s 10m28s app - 177.99.204.34:56550 1 4m1s 4m1s app - 177.99.204.34:56587 1 5m15s 5m15s app - 177.99.204.34:57237 2 1h6m3s 33m1s app - 177.99.204.34:57249 1 7m21s 7m21s app - 177.99.204.34:57367 1 3m7s 3m7s app - 177.99.204.34:57375 1 7m21s 7m21s app - 177.99.204.34:57387 1 9m26s 9m26s app - 177.99.204.34:57472 1 8m22s 8m22s app - 177.99.204.34:57635 1 9m25s 9m25s app - 177.99.204.34:57743 1 10m28s 10m28s app - 177.99.204.34:57757 1 3m7s 3m7s app - 177.99.204.34:57775 1 6m16s 6m16s app - 177.99.204.34:57795 1 13m37s 13m37s app - 177.99.204.34:57930 1 10m29s 10m29s app - 177.99.204.34:58011 1 13m40s 13m40s app - 177.99.204.34:58055 1 10m28s 10m28s app - 177.99.204.34:58378 1 3m7s 3m7s app - 177.99.204.34:58400 1 6m17s 6m17s app - 177.99.204.34:58460 2 1h4m50s 32m25s app - 177.99.204.34:58606 1 9m24s 9m24s app - 177.99.204.34:58628 1 3m8s 3m8s app - 177.99.204.34:58639 1 1h 1h app - 177.99.204.34:58744 1 1h 1h app - 177.99.204.34:58846 1 13m38s 13m38s app - 177.99.204.34:59235 1 6m15s 6m15s app - 177.99.204.34:59261 1 14m39s 14m39s app - 177.99.204.34:59277 1 10m27s 10m27s app - 177.99.204.34:59279 1 9m26s 9m26s app - 177.99.204.34:59348 1 2m4s 2m4s app - 177.99.204.34:59462 2 1h1m50s 30m55s app - 177.99.204.34:59680 2 1h1m43s 30m51s app - 177.99.204.34:59718 2 1h2m54s 31m27s app - 177.99.204.34:59809 1 5m12s 5m12s app - 177.99.204.34:59865 1 6m18s 6m18s app - 177.99.204.34:59967 1 10m28s 10m28s app - 177.99.204.34:60076 1 4m12s 4m12s app - 177.99.204.34:60077 1 4m9s 4m9s app - 177.99.204.34:60122 1 3m6s 3m6s app - 177.99.204.34:60145 2 1h44s 30m22s app - 177.99.204.34:60337 1 5m13s 5m13s app - 177.99.204.34:60432 1 9m25s 9m25s app - 177.99.204.34:60568 1 17m55s 17m55s app - 177.99.204.34:60608 1 8m22s 8m22s app - 177.99.204.34:60878 1 6m19s 6m19s app - 177.99.204.34:60898 1 4m9s 4m9s app - 177.99.204.34:60905 1 5m12s 5m12s app - 177.99.204.34:60956 1 12m32s 12m32s app - 177.99.204.34:61053 1 8m22s 8m22s app - 177.99.204.34:61240 1 7m21s 7m21s app - 177.99.204.34:61319 1 6m14s 6m14s app - 177.99.204.34:61351 1 4m10s 4m10s app - 177.99.204.34:61545 1 6m16s 6m16s app - 177.99.204.34:61587 1 4m10s 4m10s app - 177.99.204.34:61593 1 2m4s 2m4s app - 177.99.204.34:61603 1 8m22s 8m22s app - 177.99.204.34:61618 1 9m27s 9m27s app - 177.99.204.34:61629 1 16m49s 16m49s app - 177.99.204.34:61676 1 3m8s 3m8s app - 177.99.204.34:61796 1 5m59s 5m59s app - 177.99.204.34:62116 1 6m14s 6m14s app - 177.99.204.34:62156 1 8m23s 8m23s app - 177.99.204.34:62316 1 5m13s 5m13s app - 177.99.204.34:62322 1 14m38s 14m38s app - 177.99.204.34:62531 1 4m10s 4m10s app - 177.99.204.34:62610 1 6m19s 6m19s app - 177.99.204.34:62721 1 8m11s 8m11s app - 177.99.204.34:62794 1 9m27s 9m27s app - 177.99.204.34:62814 1 3m8s 3m8s app - 177.99.204.34:62888 1 10m28s 10m28s app - 177.99.204.34:63031 1 6m15s 6m15s app - 177.99.204.34:63083 1 2m4s 2m4s app - 177.99.204.34:63377 1 2m4s 2m4s app - 177.99.204.34:63470 1 1h 1h app - 177.99.204.34:63500 1 2m4s 2m4s app - 177.99.204.34:63565 1 11m31s 11m31s app - 177.99.204.34:63568 1 4m10s 4m10s app - 177.99.204.34:63617 1 9m25s 9m25s app - 177.99.204.34:63733 1 6m16s 6m16s app - 177.99.204.34:63746 1 5m14s 5m14s app - 177.99.204.34:63839 1 8m22s 8m22s app - 177.99.204.34:63850 1 7m22s 7m22s app - 177.99.204.34:63916 2 1h3m43s 31m51s app - 177.99.204.34:63958 1 3m9s 3m9s app - 177.99.204.34:64003 1 4m9s 4m9s app - 177.99.204.34:64087 1 14m37s 14m37s app - 177.99.204.34:64098 2 1h40s 30m20s app - 177.99.204.34:64200 2 1h48s 30m24s app - 177.99.204.34:64202 1 8m25s 8m25s app - 177.99.204.34:64251 1 22m6s 22m6s app - 177.99.204.34:64450 1 12m34s 12m34s app - 177.99.204.34:64578 1 24m9s 24m9s app - 177.99.204.34:64735 1 5m3s 5m3s app - 177.99.204.34:64794 1 4m10s 4m10s app - 177.99.204.34:64811 1 9m24s 9m24s app - 177.99.204.34:64868 1 15m42s 15m42s app - 177.99.204.34:64902 1 10m29s 10m29s app - 177.99.204.34:65019 1 7m17s 7m17s app - 177.99.204.34:65027 1 7m20s 7m20s app - 177.99.204.34:65111 1 9m27s 9m27s app - 177.99.204.34:65244 1 3m6s 3m6s app - 177.99.204.34:65278 1 4m9s 4m9s app - 177.99.204.34:65402 1 7m21s 7m21s app - 177.99.204.34:65419 1 16m48s 16m48s app - 177.99.204.34:65436 1 6m44s 6m44s app - 177.99.204.34:65529 2 49m51s 24m55s app - 186.249.229.55:49238 1 1h 1h app - 186.249.229.55:49831 1 1h 1h app - 186.249.229.55:64810 1 1h 1h app - 186.249.229.55:65405 1 1h 1h app - 187.111.31.238:49299 1 1h12s 1h12s app - 187.111.31.238:49483 1 1h 1h app - 187.111.31.238:50015 1 1h 1h app - 187.111.31.238:50087 1 1h12s 1h12s app - 187.111.31.238:50279 1 1h 1h app - 187.111.31.238:50620 1 1h 1h app - 187.111.31.238:50811 1 55m30s 55m30s app - 187.111.31.238:50862 1 1h13s 1h13s app - 187.111.31.238:51328 1 39m37s 39m37s app - 187.111.31.238:51342 1 6m26s 6m26s app - 187.111.31.238:51355 1 6m26s 6m26s app - 187.111.31.238:52414 1 1h15m 1h15m app - 187.111.31.238:52427 1 1h 1h app - 187.111.31.238:53029 1 1h12s 1h12s app - 187.111.31.238:53217 1 1h 1h app - 187.111.31.238:53823 1 1h12s 1h12s app - 187.111.31.238:54013 1 1h 1h app - 187.111.31.238:54595 1 1h12s 1h12s app - 187.111.31.238:54790 1 1h 1h app - 187.111.31.238:55394 1 1h12s 1h12s app - 187.111.31.238:55584 1 1h 1h app - 187.111.31.238:56176 1 1h13s 1h13s app - 187.111.31.238:56366 1 1h 1h app - 187.111.31.238:56959 1 1h12s 1h12s app - 187.111.31.238:57138 1 1h 1h app - 187.111.31.238:57728 1 1h13s 1h13s app - 187.111.31.238:57922 1 1h 1h app - 187.111.31.238:58527 1 1h12s 1h12s app - 187.111.31.238:58720 1 1h 1h app - 187.111.31.238:59320 1 1h12s 1h12s app - 187.111.31.238:59495 1 1h 1h app - 187.111.31.238:60098 1 1h13s 1h13s app - 187.111.31.238:60291 1 1h 1h app - 187.111.31.238:60889 1 1h12s 1h12s app - 187.111.31.238:61078 1 1h 1h app - 187.111.31.238:61676 1 1h13s 1h13s app - 187.111.31.238:61848 1 1h 1h app - 187.111.31.238:62491 1 1h12s 1h12s app - 187.111.31.238:62703 1 1h 1h app - 187.111.31.238:63314 1 1h12s 1h12s app - 187.111.31.238:63505 1 1h 1h app - 187.111.31.238:64105 1 1h13s 1h13s app - 187.111.31.238:64296 1 1h 1h app - 187.111.31.238:64888 1 1h12s 1h12s app - 187.111.31.238:65077 1 1h 1h pg_dump 6 36m48s 6m8s postgres_fdw 1 55m 55m psql - unix(576016@a2tech):8963 1 1h 1h psql - unix(576408@a2tech):8963 1 1h 1h psql - unix(577894@a2tech):8963 1 1h 1h psql - unix(578725@a2tech):8963 1 1h 1h psql - unix(578840@a2tech):8963 1 1h1s 1h1s psql - unix(579826@a2tech):8963 1 1h 1h psql - unix(581876@a2tech):8963 1 1h 1h psql - unix(582920@a2tech):8963 1 1h7s 1h7s psql - unix(582957@a2tech):8963 1 1h 1h psql - unix(583279@a2tech):8963 1 1h1s 1h1s psql - unix(584636@a2tech):8963 1 1h 1h psql - unix(585044@a2tech):8963 1 1h 1h psql - unix(588855@a2tech):8963 1 1h 1h psql - unix(588901@a2tech):8963 1 1h4s 1h4s psql - unix(588991@a2tech):8963 1 1h 1h psql - unix(590494@a2tech):8963 1 1h15s 1h15s psql - unix(590816@a2tech):8963 1 1h1s 1h1s psql - unix(592620@a2tech):8963 1 1h 1h psql - unix(593046@a2tech):8963 1 1h1s 1h1s psql - unix(593688@a2tech):8963 1 1h 1h -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 16,906 buffers Checkpoint Peak
- 2026-05-17 00:09:46 Date
- 269.815 seconds Highest write time
- 0.006 seconds Sync time
Checkpoints Wal files
Key values
- 8 files Wal files usage Peak
- 2026-05-17 00:09:46 Date
Checkpoints distance
Key values
- 250.61 Mo Distance Peak
- 2026-05-17 00:09:46 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 17 00 16,906 269.815s 0.003s 269.826s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 2 0.01s 0.002s 0.019s 04 0 0s 0s 0s 05 4,517 345.564s 0.011s 345.59s 06 5,471 480.836s 0.007s 480.85s 07 1,064 104.57s 0.025s 104.614s 08 418 40.912s 0.01s 40.933s 09 1,120 110.473s 0.023s 110.514s 10 553 54.444s 0.016s 54.473s 11 34 3.311s 0.002s 3.316s 12 22 2.108s 0.002s 2.114s 13 259 25.469s 0.007s 25.483s 14 32 3.111s 0.002s 3.118s 15 22 2.107s 0.002s 2.113s 16 21 2.008s 0.002s 2.013s 17 21 2.007s 0.002s 2.012s 18 691 69.076s 0.009s 69.095s 19 22 2.109s 0.003s 2.118s 20 196 32.06s 0.005s 32.071s 21 21 2.007s 0.002s 2.011s 22 22 2.107s 0.003s 2.113s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 17 00 0 0 8 47 0.001s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 3 0.001s 0.001s 04 0 0 0 0 0s 0s 05 0 0 2 127 0.002s 0.004s 06 0 0 2 91 0.002s 0.002s 07 0 0 0 327 0.002s 0.006s 08 0 0 0 134 0.002s 0.003s 09 0 0 1 284 0.002s 0.005s 10 0 0 0 137 0.002s 0.004s 11 0 0 0 5 0.001s 0.001s 12 0 0 0 3 0.002s 0.001s 13 0 0 0 80 0.002s 0.002s 14 0 0 0 7 0.002s 0.001s 15 0 0 0 3 0.002s 0.001s 16 0 0 0 3 0.002s 0.001s 17 0 0 0 3 0.002s 0.001s 18 0 0 0 69 0.002s 0.005s 19 0 0 0 3 0.003s 0.001s 20 0 0 1 21 0.001s 0.002s 21 0 0 0 3 0.001s 0.001s 22 0 0 0 3 0.002s 0.001s 23 0 0 0 0 0s 0s Day Hour Count Avg time (sec) May 17 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 May 17 00 128,313.00 kB 128,313.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 57,741.00 kB 04 0.00 kB 0.00 kB 05 9,919.50 kB 23,949.50 kB 06 13,212.50 kB 25,982.50 kB 07 1,200.83 kB 18,260.67 kB 08 902.67 kB 11,633.00 kB 09 1,537.60 kB 8,082.80 kB 10 876.50 kB 5,483.50 kB 11 224.00 kB 4,418.00 kB 12 165.00 kB 3,992.00 kB 13 836.00 kB 3,504.00 kB 14 201.00 kB 3,080.00 kB 15 165.00 kB 2,788.00 kB 16 159.00 kB 2,525.00 kB 17 161.00 kB 2,289.00 kB 18 1,136.75 kB 3,758.50 kB 19 166.00 kB 2,893.00 kB 20 477.00 kB 2,529.00 kB 21 163.00 kB 2,210.00 kB 22 165.00 kB 2,005.00 kB 23 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 446.83 MiB Temp Files size Peak
- 2026-05-17 05:31:04 Date
Number of temporary files
Key values
- 3 per second Temp Files Peak
- 2026-05-17 05:31:08 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 17 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 12 1.12 GiB 95.69 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 868.09 MiB 66.64 MiB 223.41 MiB 108.51 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-17 05:31:09 Duration: 46s135ms Database: rio User: intelifix Remote: [local] Application: psql - unix(578932@a2tech):8963
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-17 05:31:04 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(578932@a2tech):8963
2 4 280.18 MiB 52.07 MiB 85.70 MiB 70.05 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-05-17 05:30:23 Duration: 21s162ms Database: rio User: intelifix Remote: [local] Application: psql - unix(578926@a2tech):8963
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-05-17 05:30:21 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(578926@a2tech):8963
Queries generating the largest temporary files
Rank Size Query 1 223.41 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-17 05:31:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(578932@a2tech):8963 ]
2 223.41 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-17 05:31:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(578932@a2tech):8963 ]
3 85.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-05-17 05:30:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(578926@a2tech):8963 ]
4 85.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-05-17 05:30:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(578926@a2tech):8963 ]
5 73.80 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-17 05:31:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(578932@a2tech):8963 ]
6 73.75 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-17 05:31:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(578932@a2tech):8963 ]
7 73.74 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-17 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(578932@a2tech):8963 ]
8 66.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-17 05:31:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(578932@a2tech):8963 ]
9 66.65 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-17 05:31:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(578932@a2tech):8963 ]
10 66.64 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-17 05:31:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(578932@a2tech):8963 ]
11 56.72 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-05-17 05:30:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(578926@a2tech):8963 ]
12 52.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-05-17 05:30:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(578926@a2tech):8963 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.04 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-05-17 05:02:03 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.04 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-05-17 05:02:03 Date
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_statistic (1) Main table vacuumed on database contagem
- 6 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes contagem.pg_catalog.pg_statistic 1 1 2,208 0 0 0 0 2,126 1 148,428 brasilia.pg_toast.pg_toast_2619 1 1 262 0 1 0 0 168 2 25,957 rio.pg_catalog.pg_statistic 1 1 2,913 0 20 0 0 2,739 16 213,149 contagem.pg_toast.pg_toast_2619 1 1 200 0 1 0 0 145 2 24,946 rio.pg_toast.pg_toast_2619 1 1 812 0 14 0 0 657 7 64,853 brasilia.pg_catalog.pg_statistic 1 1 2,301 0 1 0 0 2,226 2 159,667 Total 6 6 8,696 250 37 0 0 8,061 30 637,000 Tuples removed per table
Key values
- pg_catalog.pg_statistic (3569) Main table with removed tuples on database rio
- 10505 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 3,569 7,688 0 0 1,279 contagem.pg_catalog.pg_statistic 1 1 3,095 7,336 0 0 922 brasilia.pg_catalog.pg_statistic 1 1 2,966 7,358 0 0 943 rio.pg_toast.pg_toast_2619 1 1 619 676 0 19 251 contagem.pg_toast.pg_toast_2619 1 1 134 120 0 0 58 brasilia.pg_toast.pg_toast_2619 1 1 122 137 0 27 49 Total 6 6 10,505 23,315 0 46 3,502 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (27) Main table with removed pages on database brasilia
- 46 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed brasilia.pg_toast.pg_toast_2619 1 1 122 27 rio.pg_toast.pg_toast_2619 1 1 619 19 contagem.pg_catalog.pg_statistic 1 1 3095 0 rio.pg_catalog.pg_statistic 1 1 3569 0 contagem.pg_toast.pg_toast_2619 1 1 134 0 brasilia.pg_catalog.pg_statistic 1 1 2966 0 Total 6 6 10,505 46 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 17 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0.04 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
- 104 Total read queries
- 385 Total write queries
Queries by database
Key values
- rio Main database
- 370 Requests
- 1h30m27s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 701 Requests
User Request type Count Duration intelifix Total 701 2h21m49s copy to 385 36m18s others 218 9m4s select 98 1h36m26s lenon Total 6 7s828ms select 6 7s828ms Duration by user
Key values
- 2h21m49s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 701 2h21m49s copy to 385 36m18s others 218 9m4s select 98 1h36m26s lenon Total 6 7s828ms select 6 7s828ms Queries by host
Key values
- [local] Main host
- 707 Requests
- 2h21m56s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 385 Requests
- 36m18s (pg_dump)
- Main time consuming application
Application Request type Count Duration app - 127.0.0.1:51872 Total 1 338ms select 1 338ms app - 127.0.0.1:56694 Total 1 220ms select 1 220ms pg_dump Total 385 36m18s copy to 385 36m18s psql - unix(574267@a2tech):8963 Total 1 2s671ms select 1 2s671ms psql - unix(574270@a2tech):8963 Total 1 676ms select 1 676ms psql - unix(574274@a2tech):8963 Total 1 320ms select 1 320ms psql - unix(574339@a2tech):8963 Total 1 2s115ms others 1 2s115ms psql - unix(574340@a2tech):8963 Total 1 4s472ms others 1 4s472ms psql - unix(574353@a2tech):8963 Total 1 210ms others 1 210ms psql - unix(574371@a2tech):8963 Total 1 3s664ms others 1 3s664ms psql - unix(574372@a2tech):8963 Total 1 4s322ms others 1 4s322ms psql - unix(574479@a2tech):8963 Total 1 1s357ms others 1 1s357ms psql - unix(574597@a2tech):8963 Total 1 1s270ms others 1 1s270ms psql - unix(574726@a2tech):8963 Total 1 1s266ms others 1 1s266ms psql - unix(574846@a2tech):8963 Total 1 1s238ms others 1 1s238ms psql - unix(574962@a2tech):8963 Total 1 1s253ms others 1 1s253ms psql - unix(575098@a2tech):8963 Total 1 1s340ms others 1 1s340ms psql - unix(575222@a2tech):8963 Total 1 1s303ms others 1 1s303ms psql - unix(575388@a2tech):8963 Total 1 1s267ms others 1 1s267ms psql - unix(575518@a2tech):8963 Total 1 1s272ms others 1 1s272ms psql - unix(575639@a2tech):8963 Total 1 1s230ms others 1 1s230ms psql - unix(575756@a2tech):8963 Total 1 1s275ms others 1 1s275ms psql - unix(575893@a2tech):8963 Total 1 1s368ms others 1 1s368ms psql - unix(576016@a2tech):8963 Total 1 1s272ms others 1 1s272ms psql - unix(576133@a2tech):8963 Total 1 1s306ms others 1 1s306ms psql - unix(576260@a2tech):8963 Total 1 1s256ms others 1 1s256ms psql - unix(576400@a2tech):8963 Total 1 1s238ms others 1 1s238ms psql - unix(576521@a2tech):8963 Total 1 1s228ms others 1 1s228ms psql - unix(576985@a2tech):8963 Total 1 1s329ms others 1 1s329ms psql - unix(577119@a2tech):8963 Total 1 1s291ms others 1 1s291ms psql - unix(577242@a2tech):8963 Total 1 1s262ms others 1 1s262ms psql - unix(577369@a2tech):8963 Total 1 1s249ms others 1 1s249ms psql - unix(577497@a2tech):8963 Total 1 1s234ms others 1 1s234ms psql - unix(577619@a2tech):8963 Total 1 1s316ms others 1 1s316ms psql - unix(577754@a2tech):8963 Total 1 1s237ms others 1 1s237ms psql - unix(577876@a2tech):8963 Total 1 1s220ms others 1 1s220ms psql - unix(577996@a2tech):8963 Total 1 1s308ms others 1 1s308ms psql - unix(578128@a2tech):8963 Total 1 1s344ms others 1 1s344ms psql - unix(578296@a2tech):8963 Total 1 1s220ms others 1 1s220ms psql - unix(578415@a2tech):8963 Total 1 1s219ms others 1 1s219ms psql - unix(578485@a2tech):8963 Total 1 1m55s others 1 1m55s psql - unix(578514@a2tech):8963 Total 1 1m19s others 1 1m19s psql - unix(578528@a2tech):8963 Total 1 1m others 1 1m psql - unix(578600@a2tech):8963 Total 1 1s279ms others 1 1s279ms psql - unix(578725@a2tech):8963 Total 1 1s266ms others 1 1s266ms psql - unix(578840@a2tech):8963 Total 1 1s372ms others 1 1s372ms psql - unix(578926@a2tech):8963 Total 1 21s162ms others 1 21s162ms psql - unix(578932@a2tech):8963 Total 1 46s135ms others 1 46s135ms psql - unix(578996@a2tech):8963 Total 1 1s367ms others 1 1s367ms psql - unix(579118@a2tech):8963 Total 1 1s286ms others 1 1s286ms psql - unix(579237@a2tech):8963 Total 1 1s342ms others 1 1s342ms psql - unix(579349@a2tech):8963 Total 1 2s886ms select 1 2s886ms psql - unix(579353@a2tech):8963 Total 1 724ms select 1 724ms psql - unix(579356@a2tech):8963 Total 1 549ms select 1 549ms psql - unix(579421@a2tech):8963 Total 1 2s159ms others 1 2s159ms psql - unix(579424@a2tech):8963 Total 1 1s396ms others 1 1s396ms psql - unix(579442@a2tech):8963 Total 1 1s783ms others 1 1s783ms psql - unix(579453@a2tech):8963 Total 1 1s967ms others 1 1s967ms psql - unix(579560@a2tech):8963 Total 1 1s269ms others 1 1s269ms psql - unix(579681@a2tech):8963 Total 1 1s325ms others 1 1s325ms psql - unix(579809@a2tech):8963 Total 1 1s328ms others 1 1s328ms psql - unix(579940@a2tech):8963 Total 1 1s346ms others 1 1s346ms psql - unix(580064@a2tech):8963 Total 1 486ms others 1 486ms psql - unix(580067@a2tech):8963 Total 1 1s274ms others 1 1s274ms psql - unix(580215@a2tech):8963 Total 1 3m32s select 1 3m32s psql - unix(580218@a2tech):8963 Total 1 326ms others 1 326ms psql - unix(580224@a2tech):8963 Total 1 1s362ms others 1 1s362ms psql - unix(580314@a2tech):8963 Total 1 22s523ms select 1 22s523ms psql - unix(580322@a2tech):8963 Total 1 10s242ms select 1 10s242ms psql - unix(580326@a2tech):8963 Total 1 2m14s select 1 2m14s psql - unix(580351@a2tech):8963 Total 1 756ms select 1 756ms psql - unix(580356@a2tech):8963 Total 1 497ms select 1 497ms psql - unix(580406@a2tech):8963 Total 1 1s308ms others 1 1s308ms psql - unix(580531@a2tech):8963 Total 1 231ms others 1 231ms psql - unix(580534@a2tech):8963 Total 1 1s259ms others 1 1s259ms psql - unix(580669@a2tech):8963 Total 1 340ms others 1 340ms psql - unix(580675@a2tech):8963 Total 1 1s313ms others 1 1s313ms psql - unix(580808@a2tech):8963 Total 1 236ms others 1 236ms psql - unix(580811@a2tech):8963 Total 1 1s336ms others 1 1s336ms psql - unix(580932@a2tech):8963 Total 1 210ms others 1 210ms psql - unix(580935@a2tech):8963 Total 1 1s300ms others 1 1s300ms psql - unix(581008@a2tech):8963 Total 1 586ms others 1 586ms psql - unix(581010@a2tech):8963 Total 1 258ms others 1 258ms psql - unix(581089@a2tech):8963 Total 1 3m18s select 1 3m18s psql - unix(581092@a2tech):8963 Total 1 1s332ms others 1 1s332ms psql - unix(581149@a2tech):8963 Total 1 18s416ms select 1 18s416ms psql - unix(581156@a2tech):8963 Total 1 8s566ms select 1 8s566ms psql - unix(581161@a2tech):8963 Total 1 2m11s select 1 2m11s psql - unix(581187@a2tech):8963 Total 1 547ms select 1 547ms psql - unix(581190@a2tech):8963 Total 1 338ms select 1 338ms psql - unix(581242@a2tech):8963 Total 1 1s267ms others 1 1s267ms psql - unix(581370@a2tech):8963 Total 1 1s285ms others 1 1s285ms psql - unix(581498@a2tech):8963 Total 1 1s367ms others 1 1s367ms psql - unix(581571@a2tech):8963 Total 1 257ms others 1 257ms psql - unix(581630@a2tech):8963 Total 1 183ms others 1 183ms psql - unix(581633@a2tech):8963 Total 1 1s277ms others 1 1s277ms psql - unix(581788@a2tech):8963 Total 1 236ms others 1 236ms psql - unix(581791@a2tech):8963 Total 1 1s329ms others 1 1s329ms psql - unix(582002@a2tech):8963 Total 1 3m19s select 1 3m19s psql - unix(582006@a2tech):8963 Total 1 1s380ms others 1 1s380ms psql - unix(582063@a2tech):8963 Total 1 18s692ms select 1 18s692ms psql - unix(582069@a2tech):8963 Total 1 8s665ms select 1 8s665ms psql - unix(582075@a2tech):8963 Total 1 2m12s select 1 2m12s psql - unix(582103@a2tech):8963 Total 1 592ms select 1 592ms psql - unix(582107@a2tech):8963 Total 1 358ms select 1 358ms psql - unix(582166@a2tech):8963 Total 1 266ms others 1 266ms psql - unix(582169@a2tech):8963 Total 1 1s303ms others 1 1s303ms psql - unix(582256@a2tech):8963 Total 1 222ms others 1 222ms psql - unix(582306@a2tech):8963 Total 1 150ms others 1 150ms psql - unix(582309@a2tech):8963 Total 1 1s345ms others 1 1s345ms psql - unix(582451@a2tech):8963 Total 1 460ms others 1 460ms psql - unix(582458@a2tech):8963 Total 1 1s287ms others 1 1s287ms psql - unix(582529@a2tech):8963 Total 1 252ms others 1 252ms psql - unix(582585@a2tech):8963 Total 1 1s366ms others 1 1s366ms psql - unix(582703@a2tech):8963 Total 1 1s295ms others 1 1s295ms psql - unix(582777@a2tech):8963 Total 1 226ms others 1 226ms psql - unix(582854@a2tech):8963 Total 1 3m18s select 1 3m18s psql - unix(582857@a2tech):8963 Total 1 1s300ms others 1 1s300ms psql - unix(582914@a2tech):8963 Total 1 19s256ms select 1 19s256ms psql - unix(582920@a2tech):8963 Total 1 8s632ms select 1 8s632ms psql - unix(582925@a2tech):8963 Total 1 2m12s select 1 2m12s psql - unix(582953@a2tech):8963 Total 1 568ms select 1 568ms psql - unix(582957@a2tech):8963 Total 1 359ms select 1 359ms psql - unix(583011@a2tech):8963 Total 1 1s279ms others 1 1s279ms psql - unix(583087@a2tech):8963 Total 1 205ms others 1 205ms psql - unix(583146@a2tech):8963 Total 1 1s253ms others 1 1s253ms psql - unix(583275@a2tech):8963 Total 1 163ms others 1 163ms psql - unix(583279@a2tech):8963 Total 1 1s269ms others 1 1s269ms psql - unix(583360@a2tech):8963 Total 1 273ms others 1 273ms psql - unix(583423@a2tech):8963 Total 1 436ms others 1 436ms psql - unix(583426@a2tech):8963 Total 1 1s294ms others 1 1s294ms psql - unix(583544@a2tech):8963 Total 1 1s336ms others 1 1s336ms psql - unix(583623@a2tech):8963 Total 1 243ms others 1 243ms psql - unix(583704@a2tech):8963 Total 1 3m21s select 1 3m21s psql - unix(583707@a2tech):8963 Total 1 1s388ms others 1 1s388ms psql - unix(583766@a2tech):8963 Total 1 18s633ms select 1 18s633ms psql - unix(583772@a2tech):8963 Total 1 8s573ms select 1 8s573ms psql - unix(583777@a2tech):8963 Total 1 2m12s select 1 2m12s psql - unix(583802@a2tech):8963 Total 1 564ms select 1 564ms psql - unix(583806@a2tech):8963 Total 1 360ms select 1 360ms psql - unix(583864@a2tech):8963 Total 1 1s272ms others 1 1s272ms psql - unix(583974@a2tech):8963 Total 1 224ms others 1 224ms psql - unix(584038@a2tech):8963 Total 1 1s265ms others 1 1s265ms psql - unix(584173@a2tech):8963 Total 1 1s288ms others 1 1s288ms psql - unix(584247@a2tech):8963 Total 1 157ms others 1 157ms psql - unix(584250@a2tech):8963 Total 1 258ms others 1 258ms psql - unix(584308@a2tech):8963 Total 1 1s295ms others 1 1s295ms psql - unix(584435@a2tech):8963 Total 1 1s397ms others 1 1s397ms psql - unix(584537@a2tech):8963 Total 1 258ms others 1 258ms psql - unix(584611@a2tech):8963 Total 1 3m18s select 1 3m18s psql - unix(584619@a2tech):8963 Total 1 1s297ms others 1 1s297ms psql - unix(584677@a2tech):8963 Total 1 18s613ms select 1 18s613ms psql - unix(584683@a2tech):8963 Total 1 8s317ms select 1 8s317ms psql - unix(584688@a2tech):8963 Total 1 2m11s select 1 2m11s psql - unix(584722@a2tech):8963 Total 1 582ms select 1 582ms psql - unix(584726@a2tech):8963 Total 1 354ms select 1 354ms psql - unix(584776@a2tech):8963 Total 1 1s266ms others 1 1s266ms psql - unix(584908@a2tech):8963 Total 1 1s244ms others 1 1s244ms psql - unix(585036@a2tech):8963 Total 1 1s265ms others 1 1s265ms psql - unix(585112@a2tech):8963 Total 1 245ms others 1 245ms psql - unix(585114@a2tech):8963 Total 1 240ms others 1 240ms psql - unix(585172@a2tech):8963 Total 1 1s280ms others 1 1s280ms psql - unix(585298@a2tech):8963 Total 1 1s324ms others 1 1s324ms psql - unix(585377@a2tech):8963 Total 1 222ms others 1 222ms psql - unix(585452@a2tech):8963 Total 1 3m18s select 1 3m18s psql - unix(585460@a2tech):8963 Total 1 1s418ms others 1 1s418ms psql - unix(585520@a2tech):8963 Total 1 18s274ms select 1 18s274ms psql - unix(585528@a2tech):8963 Total 1 8s505ms select 1 8s505ms psql - unix(585533@a2tech):8963 Total 1 2m12s select 1 2m12s psql - unix(585560@a2tech):8963 Total 1 593ms select 1 593ms psql - unix(585565@a2tech):8963 Total 1 376ms select 1 376ms psql - unix(585611@a2tech):8963 Total 1 217ms others 1 217ms psql - unix(585614@a2tech):8963 Total 1 1s274ms others 1 1s274ms psql - unix(585686@a2tech):8963 Total 1 270ms others 1 270ms psql - unix(585747@a2tech):8963 Total 1 1s317ms others 1 1s317ms psql - unix(585875@a2tech):8963 Total 1 1s300ms others 1 1s300ms psql - unix(585946@a2tech):8963 Total 1 155ms others 1 155ms psql - unix(585948@a2tech):8963 Total 1 248ms others 1 248ms psql - unix(586006@a2tech):8963 Total 1 1s271ms others 1 1s271ms psql - unix(586127@a2tech):8963 Total 1 1s363ms others 1 1s363ms psql - unix(586200@a2tech):8963 Total 1 204ms others 1 204ms psql - unix(586279@a2tech):8963 Total 1 3m18s select 1 3m18s psql - unix(586283@a2tech):8963 Total 1 1s309ms others 1 1s309ms psql - unix(586341@a2tech):8963 Total 1 18s398ms select 1 18s398ms psql - unix(586349@a2tech):8963 Total 1 8s637ms select 1 8s637ms psql - unix(586354@a2tech):8963 Total 1 2m12s select 1 2m12s psql - unix(586382@a2tech):8963 Total 1 554ms select 1 554ms psql - unix(586386@a2tech):8963 Total 1 368ms select 1 368ms psql - unix(586438@a2tech):8963 Total 1 1s292ms others 1 1s292ms psql - unix(586511@a2tech):8963 Total 1 235ms others 1 235ms psql - unix(586574@a2tech):8963 Total 1 1s256ms others 1 1s256ms psql - unix(586696@a2tech):8963 Total 1 1s283ms others 1 1s283ms psql - unix(586829@a2tech):8963 Total 1 1s311ms others 1 1s311ms psql - unix(587002@a2tech):8963 Total 1 1s314ms others 1 1s314ms psql - unix(587078@a2tech):8963 Total 1 206ms others 1 206ms psql - unix(587157@a2tech):8963 Total 1 3m15s select 1 3m15s psql - unix(587160@a2tech):8963 Total 1 1s288ms others 1 1s288ms psql - unix(587216@a2tech):8963 Total 1 18s266ms select 1 18s266ms psql - unix(587223@a2tech):8963 Total 1 8s518ms select 1 8s518ms psql - unix(587229@a2tech):8963 Total 1 2m11s select 1 2m11s psql - unix(587255@a2tech):8963 Total 1 567ms select 1 567ms psql - unix(587260@a2tech):8963 Total 1 352ms select 1 352ms psql - unix(587320@a2tech):8963 Total 1 1s304ms others 1 1s304ms psql - unix(587397@a2tech):8963 Total 1 3s723ms others 1 3s723ms psql - unix(587399@a2tech):8963 Total 1 3s308ms others 1 3s308ms psql - unix(587453@a2tech):8963 Total 1 1s268ms others 1 1s268ms psql - unix(587575@a2tech):8963 Total 1 1s286ms others 1 1s286ms psql - unix(587648@a2tech):8963 Total 1 152ms others 1 152ms psql - unix(587707@a2tech):8963 Total 1 1s263ms others 1 1s263ms psql - unix(587833@a2tech):8963 Total 1 1s265ms others 1 1s265ms psql - unix(587903@a2tech):8963 Total 1 153ms others 1 153ms psql - unix(587905@a2tech):8963 Total 1 222ms others 1 222ms psql - unix(587984@a2tech):8963 Total 1 3m18s select 1 3m18s psql - unix(587991@a2tech):8963 Total 1 1s310ms others 1 1s310ms psql - unix(588048@a2tech):8963 Total 1 18s342ms select 1 18s342ms psql - unix(588056@a2tech):8963 Total 1 8s585ms select 1 8s585ms psql - unix(588060@a2tech):8963 Total 1 2m12s select 1 2m12s psql - unix(588088@a2tech):8963 Total 1 559ms select 1 559ms psql - unix(588092@a2tech):8963 Total 1 369ms select 1 369ms psql - unix(588144@a2tech):8963 Total 1 1s281ms others 1 1s281ms psql - unix(588248@a2tech):8963 Total 1 247ms others 1 247ms psql - unix(588250@a2tech):8963 Total 1 199ms others 1 199ms psql - unix(588305@a2tech):8963 Total 1 1s291ms others 1 1s291ms psql - unix(588429@a2tech):8963 Total 1 1s335ms others 1 1s335ms psql - unix(588505@a2tech):8963 Total 1 223ms others 1 223ms psql - unix(588562@a2tech):8963 Total 1 1s336ms others 1 1s336ms psql - unix(588680@a2tech):8963 Total 1 1s284ms others 1 1s284ms psql - unix(588752@a2tech):8963 Total 1 151ms others 1 151ms psql - unix(588833@a2tech):8963 Total 1 3m19s select 1 3m19s psql - unix(588837@a2tech):8963 Total 1 1s316ms others 1 1s316ms psql - unix(588893@a2tech):8963 Total 1 18s289ms select 1 18s289ms psql - unix(588901@a2tech):8963 Total 1 8s427ms select 1 8s427ms psql - unix(588906@a2tech):8963 Total 1 2m12s select 1 2m12s psql - unix(588933@a2tech):8963 Total 1 573ms select 1 573ms psql - unix(588939@a2tech):8963 Total 1 363ms select 1 363ms psql - unix(588991@a2tech):8963 Total 1 1s238ms others 1 1s238ms psql - unix(589062@a2tech):8963 Total 1 269ms others 1 269ms psql - unix(589064@a2tech):8963 Total 1 215ms others 1 215ms psql - unix(589119@a2tech):8963 Total 1 1s274ms others 1 1s274ms psql - unix(589255@a2tech):8963 Total 1 1s306ms others 1 1s306ms psql - unix(589387@a2tech):8963 Total 1 1s265ms others 1 1s265ms psql - unix(589509@a2tech):8963 Total 1 1s245ms others 1 1s245ms psql - unix(589588@a2tech):8963 Total 1 246ms others 1 246ms psql - unix(589668@a2tech):8963 Total 1 3m17s select 1 3m17s psql - unix(589672@a2tech):8963 Total 1 1s314ms others 1 1s314ms psql - unix(589730@a2tech):8963 Total 1 18s143ms select 1 18s143ms psql - unix(589738@a2tech):8963 Total 1 8s540ms select 1 8s540ms psql - unix(589742@a2tech):8963 Total 1 2m12s select 1 2m12s psql - unix(589768@a2tech):8963 Total 1 599ms select 1 599ms psql - unix(589771@a2tech):8963 Total 1 337ms select 1 337ms psql - unix(589824@a2tech):8963 Total 1 1s258ms others 1 1s258ms psql - unix(589898@a2tech):8963 Total 1 223ms others 1 223ms psql - unix(589900@a2tech):8963 Total 1 212ms others 1 212ms psql - unix(589957@a2tech):8963 Total 1 1s309ms others 1 1s309ms psql - unix(590087@a2tech):8963 Total 1 1s323ms others 1 1s323ms psql - unix(590163@a2tech):8963 Total 1 247ms others 1 247ms psql - unix(590165@a2tech):8963 Total 1 227ms others 1 227ms psql - unix(590222@a2tech):8963 Total 1 1s402ms others 1 1s402ms psql - unix(590347@a2tech):8963 Total 1 1s302ms others 1 1s302ms psql - unix(590418@a2tech):8963 Total 1 151ms others 1 151ms psql - unix(590494@a2tech):8963 Total 1 3m18s select 1 3m18s psql - unix(590501@a2tech):8963 Total 1 1s315ms others 1 1s315ms psql - unix(590558@a2tech):8963 Total 1 18s519ms select 1 18s519ms psql - unix(590567@a2tech):8963 Total 1 8s550ms select 1 8s550ms psql - unix(590571@a2tech):8963 Total 1 2m12s select 1 2m12s psql - unix(590595@a2tech):8963 Total 1 553ms select 1 553ms psql - unix(590598@a2tech):8963 Total 1 366ms select 1 366ms psql - unix(590651@a2tech):8963 Total 1 1s274ms others 1 1s274ms psql - unix(590727@a2tech):8963 Total 1 235ms others 1 235ms psql - unix(590816@a2tech):8963 Total 1 1s242ms others 1 1s242ms psql - unix(590946@a2tech):8963 Total 1 1s369ms others 1 1s369ms psql - unix(591020@a2tech):8963 Total 1 255ms others 1 255ms psql - unix(591077@a2tech):8963 Total 1 1s289ms others 1 1s289ms psql - unix(591196@a2tech):8963 Total 1 1s284ms others 1 1s284ms psql - unix(591267@a2tech):8963 Total 1 152ms others 1 152ms psql - unix(591269@a2tech):8963 Total 1 215ms others 1 215ms psql - unix(591364@a2tech):8963 Total 1 3m29s select 1 3m29s psql - unix(591368@a2tech):8963 Total 1 1s344ms others 1 1s344ms psql - unix(591434@a2tech):8963 Total 1 22s441ms select 1 22s441ms psql - unix(591441@a2tech):8963 Total 1 9s377ms select 1 9s377ms psql - unix(591446@a2tech):8963 Total 1 2m14s select 1 2m14s psql - unix(591472@a2tech):8963 Total 1 765ms select 1 765ms psql - unix(591476@a2tech):8963 Total 1 499ms select 1 499ms psql - unix(591525@a2tech):8963 Total 1 1s852ms others 1 1s852ms psql - unix(591599@a2tech):8963 Total 1 163ms others 1 163ms psql - unix(591656@a2tech):8963 Total 1 1s243ms others 1 1s243ms psql - unix(591781@a2tech):8963 Total 1 1s495ms others 1 1s495ms psql - unix(591858@a2tech):8963 Total 1 255ms others 1 255ms psql - unix(591860@a2tech):8963 Total 1 250ms others 1 250ms psql - unix(591925@a2tech):8963 Total 1 1s277ms others 1 1s277ms psql - unix(592042@a2tech):8963 Total 1 1s255ms others 1 1s255ms psql - unix(592115@a2tech):8963 Total 1 164ms others 1 164ms psql - unix(592117@a2tech):8963 Total 1 205ms others 1 205ms psql - unix(592194@a2tech):8963 Total 1 1s491ms others 1 1s491ms psql - unix(592197@a2tech):8963 Total 1 3m19s select 1 3m19s psql - unix(592258@a2tech):8963 Total 1 18s491ms select 1 18s491ms psql - unix(592266@a2tech):8963 Total 1 8s536ms select 1 8s536ms psql - unix(592269@a2tech):8963 Total 1 2m12s select 1 2m12s psql - unix(592297@a2tech):8963 Total 1 567ms select 1 567ms psql - unix(592301@a2tech):8963 Total 1 370ms select 1 370ms psql - unix(592356@a2tech):8963 Total 1 1s270ms others 1 1s270ms psql - unix(592431@a2tech):8963 Total 1 231ms others 1 231ms psql - unix(592495@a2tech):8963 Total 1 1s304ms others 1 1s304ms psql - unix(592620@a2tech):8963 Total 1 1s275ms others 1 1s275ms psql - unix(592693@a2tech):8963 Total 1 244ms others 1 244ms psql - unix(592756@a2tech):8963 Total 1 1s344ms others 1 1s344ms psql - unix(592873@a2tech):8963 Total 1 1s268ms others 1 1s268ms psql - unix(592948@a2tech):8963 Total 1 153ms others 1 153ms psql - unix(592951@a2tech):8963 Total 1 262ms others 1 262ms psql - unix(593046@a2tech):8963 Total 1 3m20s select 1 3m20s psql - unix(593053@a2tech):8963 Total 1 1s340ms others 1 1s340ms psql - unix(593199@a2tech):8963 Total 1 18s807ms select 1 18s807ms psql - unix(593208@a2tech):8963 Total 1 8s486ms select 1 8s486ms psql - unix(593212@a2tech):8963 Total 1 2m12s select 1 2m12s psql - unix(593238@a2tech):8963 Total 1 571ms select 1 571ms psql - unix(593243@a2tech):8963 Total 1 358ms select 1 358ms psql - unix(593296@a2tech):8963 Total 1 1s251ms others 1 1s251ms psql - unix(593365@a2tech):8963 Total 1 239ms others 1 239ms psql - unix(593424@a2tech):8963 Total 1 1s253ms others 1 1s253ms psql - unix(593551@a2tech):8963 Total 1 1s267ms others 1 1s267ms psql - unix(593628@a2tech):8963 Total 1 153ms others 1 153ms psql - unix(593688@a2tech):8963 Total 1 1s253ms others 1 1s253ms psql - unix(593807@a2tech):8963 Total 1 1s299ms others 1 1s299ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-17 22:55:03 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 392 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 3m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-17 07:08:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(580215@a2tech):8963 ]
2 3m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-17 20:08:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(591364@a2tech):8963 ]
3 3m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-17 11:08:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(583704@a2tech):8963 ]
4 3m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-17 22:08:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(593046@a2tech):8963 ]
5 3m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-17 09:08:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(582002@a2tech):8963 ]
6 3m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-17 17:08:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(588833@a2tech):8963 ]
7 3m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-17 21:08:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(592197@a2tech):8963 ]
8 3m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-17 12:08:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(584611@a2tech):8963 ]
9 3m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-17 08:08:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(581089@a2tech):8963 ]
10 3m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-17 10:08:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(582854@a2tech):8963 ]
11 3m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-17 16:08:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(587984@a2tech):8963 ]
12 3m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-17 19:08:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(590494@a2tech):8963 ]
13 3m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-17 14:08:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(586279@a2tech):8963 ]
14 3m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-17 13:08:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(585452@a2tech):8963 ]
15 3m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-17 18:08:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(589668@a2tech):8963 ]
16 3m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-17 15:08:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(587157@a2tech):8963 ]
17 2m14s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-05-17 07:11:23 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(580326@a2tech):8963 ]
18 2m14s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-05-17 20:11:19 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(591446@a2tech):8963 ]
19 2m12s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-05-17 09:11:03 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(582075@a2tech):8963 ]
20 2m12s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-05-17 14:11:02 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(586354@a2tech):8963 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 55m53s 48 547ms 3m32s 1m9s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 17 07 3 3m43s 1m14s 08 3 3m27s 1m9s 09 3 3m28s 1m9s 10 3 3m27s 1m9s 11 3 3m30s 1m10s 12 3 3m27s 1m9s 13 3 3m27s 1m9s 14 3 3m27s 1m9s 15 3 3m24s 1m8s 16 3 3m27s 1m9s 17 3 3m28s 1m9s 18 3 3m26s 1m8s 19 3 3m27s 1m9s 20 3 3m39s 1m13s 21 3 3m28s 1m9s 22 3 3m29s 1m9s [ User: intelifix - Total duration: 55m53s - Times executed: 48 ]
[ Application: psql - unix(580215@a2tech):8963 - Total duration: 3m32s - Times executed: 1 ]
[ Application: psql - unix(591364@a2tech):8963 - Total duration: 3m29s - Times executed: 1 ]
[ Application: psql - unix(583704@a2tech):8963 - Total duration: 3m21s - Times executed: 1 ]
[ Application: psql - unix(593046@a2tech):8963 - Total duration: 3m20s - Times executed: 1 ]
[ Application: psql - unix(582002@a2tech):8963 - Total duration: 3m19s - Times executed: 1 ]
[ Application: psql - unix(588833@a2tech):8963 - Total duration: 3m19s - Times executed: 1 ]
[ Application: psql - unix(592197@a2tech):8963 - Total duration: 3m19s - Times executed: 1 ]
[ Application: psql - unix(584611@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(581089@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(582854@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(587984@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(590494@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(586279@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(585452@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(589668@a2tech):8963 - Total duration: 3m17s - Times executed: 1 ]
[ Application: psql - unix(587157@a2tech):8963 - Total duration: 3m15s - Times executed: 1 ]
[ Application: psql - unix(580322@a2tech):8963 - Total duration: 10s242ms - Times executed: 1 ]
[ Application: psql - unix(591441@a2tech):8963 - Total duration: 9s377ms - Times executed: 1 ]
[ Application: psql - unix(582069@a2tech):8963 - Total duration: 8s665ms - Times executed: 1 ]
[ Application: psql - unix(586349@a2tech):8963 - Total duration: 8s637ms - Times executed: 1 ]
[ Application: psql - unix(582920@a2tech):8963 - Total duration: 8s632ms - Times executed: 1 ]
[ Application: psql - unix(588056@a2tech):8963 - Total duration: 8s585ms - Times executed: 1 ]
[ Application: psql - unix(583772@a2tech):8963 - Total duration: 8s573ms - Times executed: 1 ]
[ Application: psql - unix(581156@a2tech):8963 - Total duration: 8s566ms - Times executed: 1 ]
[ Application: psql - unix(590567@a2tech):8963 - Total duration: 8s550ms - Times executed: 1 ]
[ Application: psql - unix(589738@a2tech):8963 - Total duration: 8s540ms - Times executed: 1 ]
[ Application: psql - unix(592266@a2tech):8963 - Total duration: 8s536ms - Times executed: 1 ]
[ Application: psql - unix(587223@a2tech):8963 - Total duration: 8s518ms - Times executed: 1 ]
[ Application: psql - unix(585528@a2tech):8963 - Total duration: 8s505ms - Times executed: 1 ]
[ Application: psql - unix(593208@a2tech):8963 - Total duration: 8s486ms - Times executed: 1 ]
[ Application: psql - unix(588901@a2tech):8963 - Total duration: 8s427ms - Times executed: 1 ]
[ Application: psql - unix(584683@a2tech):8963 - Total duration: 8s317ms - Times executed: 1 ]
[ Application: psql - unix(591472@a2tech):8963 - Total duration: 765ms - Times executed: 1 ]
[ Application: psql - unix(580351@a2tech):8963 - Total duration: 756ms - Times executed: 1 ]
[ Application: psql - unix(589768@a2tech):8963 - Total duration: 599ms - Times executed: 1 ]
[ Application: psql - unix(585560@a2tech):8963 - Total duration: 593ms - Times executed: 1 ]
[ Application: psql - unix(582103@a2tech):8963 - Total duration: 592ms - Times executed: 1 ]
[ Application: psql - unix(584722@a2tech):8963 - Total duration: 582ms - Times executed: 1 ]
[ Application: psql - unix(588933@a2tech):8963 - Total duration: 573ms - Times executed: 1 ]
[ Application: psql - unix(593238@a2tech):8963 - Total duration: 571ms - Times executed: 1 ]
[ Application: psql - unix(582953@a2tech):8963 - Total duration: 568ms - Times executed: 1 ]
[ Application: psql - unix(592297@a2tech):8963 - Total duration: 567ms - Times executed: 1 ]
[ Application: psql - unix(587255@a2tech):8963 - Total duration: 567ms - Times executed: 1 ]
[ Application: psql - unix(583802@a2tech):8963 - Total duration: 564ms - Times executed: 1 ]
[ Application: psql - unix(588088@a2tech):8963 - Total duration: 559ms - Times executed: 1 ]
[ Application: psql - unix(586382@a2tech):8963 - Total duration: 554ms - Times executed: 1 ]
[ Application: psql - unix(590595@a2tech):8963 - Total duration: 553ms - Times executed: 1 ]
[ Application: psql - unix(581187@a2tech):8963 - Total duration: 547ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-17 07:08:34 Duration: 3m32s Database: rio User: intelifix Remote: [local] Application: psql - unix(580215@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-17 20:08:32 Duration: 3m29s Database: rio User: intelifix Remote: [local] Application: psql - unix(591364@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-17 11:08:23 Duration: 3m21s Database: rio User: intelifix Remote: [local] Application: psql - unix(583704@a2tech):8963
2 40m31s 48 337ms 2m14s 50s664ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 17 07 3 2m37s 52s485ms 08 3 2m30s 50s213ms 09 3 2m31s 50s587ms 10 3 2m32s 50s701ms 11 3 2m31s 50s511ms 12 3 2m30s 50s275ms 13 3 2m31s 50s399ms 14 3 2m31s 50s489ms 15 3 2m30s 50s205ms 16 3 2m31s 50s422ms 17 3 2m31s 50s441ms 18 3 2m30s 50s260ms 19 3 2m31s 50s461ms 20 3 2m37s 52s377ms 21 3 2m31s 50s374ms 22 3 2m31s 50s427ms [ User: intelifix - Total duration: 40m31s - Times executed: 48 ]
[ Application: psql - unix(580326@a2tech):8963 - Total duration: 2m14s - Times executed: 1 ]
[ Application: psql - unix(591446@a2tech):8963 - Total duration: 2m14s - Times executed: 1 ]
[ Application: psql - unix(582075@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(586354@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(588906@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(588060@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(585533@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(583777@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(590571@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(582925@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(589742@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(592269@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(593212@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(587229@a2tech):8963 - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - unix(581161@a2tech):8963 - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - unix(584688@a2tech):8963 - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - unix(580314@a2tech):8963 - Total duration: 22s523ms - Times executed: 1 ]
[ Application: psql - unix(591434@a2tech):8963 - Total duration: 22s441ms - Times executed: 1 ]
[ Application: psql - unix(582914@a2tech):8963 - Total duration: 19s256ms - Times executed: 1 ]
[ Application: psql - unix(593199@a2tech):8963 - Total duration: 18s807ms - Times executed: 1 ]
[ Application: psql - unix(582063@a2tech):8963 - Total duration: 18s692ms - Times executed: 1 ]
[ Application: psql - unix(583766@a2tech):8963 - Total duration: 18s633ms - Times executed: 1 ]
[ Application: psql - unix(584677@a2tech):8963 - Total duration: 18s613ms - Times executed: 1 ]
[ Application: psql - unix(590558@a2tech):8963 - Total duration: 18s519ms - Times executed: 1 ]
[ Application: psql - unix(592258@a2tech):8963 - Total duration: 18s491ms - Times executed: 1 ]
[ Application: psql - unix(581149@a2tech):8963 - Total duration: 18s416ms - Times executed: 1 ]
[ Application: psql - unix(586341@a2tech):8963 - Total duration: 18s398ms - Times executed: 1 ]
[ Application: psql - unix(588048@a2tech):8963 - Total duration: 18s342ms - Times executed: 1 ]
[ Application: psql - unix(588893@a2tech):8963 - Total duration: 18s289ms - Times executed: 1 ]
[ Application: psql - unix(585520@a2tech):8963 - Total duration: 18s274ms - Times executed: 1 ]
[ Application: psql - unix(587216@a2tech):8963 - Total duration: 18s266ms - Times executed: 1 ]
[ Application: psql - unix(589730@a2tech):8963 - Total duration: 18s143ms - Times executed: 1 ]
[ Application: psql - unix(591476@a2tech):8963 - Total duration: 499ms - Times executed: 1 ]
[ Application: psql - unix(580356@a2tech):8963 - Total duration: 497ms - Times executed: 1 ]
[ Application: psql - unix(585565@a2tech):8963 - Total duration: 376ms - Times executed: 1 ]
[ Application: psql - unix(592301@a2tech):8963 - Total duration: 370ms - Times executed: 1 ]
[ Application: psql - unix(588092@a2tech):8963 - Total duration: 369ms - Times executed: 1 ]
[ Application: psql - unix(586386@a2tech):8963 - Total duration: 368ms - Times executed: 1 ]
[ Application: psql - unix(590598@a2tech):8963 - Total duration: 366ms - Times executed: 1 ]
[ Application: psql - unix(588939@a2tech):8963 - Total duration: 363ms - Times executed: 1 ]
[ Application: psql - unix(583806@a2tech):8963 - Total duration: 360ms - Times executed: 1 ]
[ Application: psql - unix(582957@a2tech):8963 - Total duration: 359ms - Times executed: 1 ]
[ Application: psql - unix(593243@a2tech):8963 - Total duration: 358ms - Times executed: 1 ]
[ Application: psql - unix(582107@a2tech):8963 - Total duration: 358ms - Times executed: 1 ]
[ Application: psql - unix(584726@a2tech):8963 - Total duration: 354ms - Times executed: 1 ]
[ Application: psql - unix(587260@a2tech):8963 - Total duration: 352ms - Times executed: 1 ]
[ Application: psql - unix(581190@a2tech):8963 - Total duration: 338ms - Times executed: 1 ]
[ Application: psql - unix(589771@a2tech):8963 - Total duration: 337ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-17 07:11:23 Duration: 2m14s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(580326@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-17 20:11:19 Duration: 2m14s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(591446@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-17 09:11:03 Duration: 2m12s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(582075@a2tech):8963
3 4m15s 3 1m 1m55s 1m25s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 17 05 3 4m15s 1m25s [ User: intelifix - Total duration: 4m15s - Times executed: 3 ]
[ Application: psql - unix(578485@a2tech):8963 - Total duration: 1m55s - Times executed: 1 ]
[ Application: psql - unix(578514@a2tech):8963 - Total duration: 1m19s - Times executed: 1 ]
[ Application: psql - unix(578528@a2tech):8963 - Total duration: 1m - Times executed: 1 ]
-
analyze verbose;
Date: 2026-05-17 05:01:57 Duration: 1m55s Database: rio User: intelifix Remote: [local] Application: psql - unix(578485@a2tech):8963
-
analyze verbose;
Date: 2026-05-17 05:03:17 Duration: 1m19s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(578514@a2tech):8963
-
analyze verbose;
Date: 2026-05-17 05:04:17 Duration: 1m Database: contagem User: intelifix Remote: [local] Application: psql - unix(578528@a2tech):8963
4 3m 139 210ms 2s115ms 1s301ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 17 00 7 8s714ms 1s244ms 01 6 7s689ms 1s281ms 02 6 7s672ms 1s278ms 03 6 7s683ms 1s280ms 04 6 7s552ms 1s258ms 05 6 7s914ms 1s319ms 06 6 7s941ms 1s323ms 07 6 7s881ms 1s313ms 08 6 7s860ms 1s310ms 09 6 7s979ms 1s329ms 10 6 7s734ms 1s289ms 11 6 7s907ms 1s317ms 12 6 7s677ms 1s279ms 13 6 7s946ms 1s324ms 14 6 7s768ms 1s294ms 15 6 7s677ms 1s279ms 16 6 7s838ms 1s306ms 17 6 7s645ms 1s274ms 18 6 7s909ms 1s318ms 19 6 7s776ms 1s296ms 20 6 8s467ms 1s411ms 21 6 7s955ms 1s325ms 22 6 7s667ms 1s277ms [ User: intelifix - Total duration: 3m - Times executed: 139 ]
[ Application: psql - unix(574339@a2tech):8963 - Total duration: 2s115ms - Times executed: 1 ]
[ Application: psql - unix(591525@a2tech):8963 - Total duration: 1s852ms - Times executed: 1 ]
[ Application: psql - unix(591781@a2tech):8963 - Total duration: 1s495ms - Times executed: 1 ]
[ Application: psql - unix(592194@a2tech):8963 - Total duration: 1s491ms - Times executed: 1 ]
[ Application: psql - unix(585460@a2tech):8963 - Total duration: 1s418ms - Times executed: 1 ]
[ Application: psql - unix(590222@a2tech):8963 - Total duration: 1s402ms - Times executed: 1 ]
[ Application: psql - unix(584435@a2tech):8963 - Total duration: 1s397ms - Times executed: 1 ]
[ Application: psql - unix(579424@a2tech):8963 - Total duration: 1s396ms - Times executed: 1 ]
[ Application: psql - unix(583707@a2tech):8963 - Total duration: 1s388ms - Times executed: 1 ]
[ Application: psql - unix(582006@a2tech):8963 - Total duration: 1s380ms - Times executed: 1 ]
[ Application: psql - unix(578840@a2tech):8963 - Total duration: 1s372ms - Times executed: 1 ]
[ Application: psql - unix(590946@a2tech):8963 - Total duration: 1s369ms - Times executed: 1 ]
[ Application: psql - unix(575893@a2tech):8963 - Total duration: 1s368ms - Times executed: 1 ]
[ Application: psql - unix(581498@a2tech):8963 - Total duration: 1s367ms - Times executed: 1 ]
[ Application: psql - unix(578996@a2tech):8963 - Total duration: 1s367ms - Times executed: 1 ]
[ Application: psql - unix(582585@a2tech):8963 - Total duration: 1s366ms - Times executed: 1 ]
[ Application: psql - unix(586127@a2tech):8963 - Total duration: 1s363ms - Times executed: 1 ]
[ Application: psql - unix(580224@a2tech):8963 - Total duration: 1s362ms - Times executed: 1 ]
[ Application: psql - unix(574479@a2tech):8963 - Total duration: 1s357ms - Times executed: 1 ]
[ Application: psql - unix(579940@a2tech):8963 - Total duration: 1s346ms - Times executed: 1 ]
[ Application: psql - unix(582309@a2tech):8963 - Total duration: 1s345ms - Times executed: 1 ]
[ Application: psql - unix(578128@a2tech):8963 - Total duration: 1s344ms - Times executed: 1 ]
[ Application: psql - unix(592756@a2tech):8963 - Total duration: 1s344ms - Times executed: 1 ]
[ Application: psql - unix(591368@a2tech):8963 - Total duration: 1s344ms - Times executed: 1 ]
[ Application: psql - unix(579237@a2tech):8963 - Total duration: 1s342ms - Times executed: 1 ]
[ Application: psql - unix(593053@a2tech):8963 - Total duration: 1s340ms - Times executed: 1 ]
[ Application: psql - unix(575098@a2tech):8963 - Total duration: 1s340ms - Times executed: 1 ]
[ Application: psql - unix(580811@a2tech):8963 - Total duration: 1s336ms - Times executed: 1 ]
[ Application: psql - unix(588562@a2tech):8963 - Total duration: 1s336ms - Times executed: 1 ]
[ Application: psql - unix(583544@a2tech):8963 - Total duration: 1s336ms - Times executed: 1 ]
[ Application: psql - unix(588429@a2tech):8963 - Total duration: 1s335ms - Times executed: 1 ]
[ Application: psql - unix(581092@a2tech):8963 - Total duration: 1s332ms - Times executed: 1 ]
[ Application: psql - unix(581791@a2tech):8963 - Total duration: 1s329ms - Times executed: 1 ]
[ Application: psql - unix(576985@a2tech):8963 - Total duration: 1s329ms - Times executed: 1 ]
[ Application: psql - unix(579809@a2tech):8963 - Total duration: 1s328ms - Times executed: 1 ]
[ Application: psql - unix(579681@a2tech):8963 - Total duration: 1s325ms - Times executed: 1 ]
[ Application: psql - unix(585298@a2tech):8963 - Total duration: 1s324ms - Times executed: 1 ]
[ Application: psql - unix(590087@a2tech):8963 - Total duration: 1s323ms - Times executed: 1 ]
[ Application: psql - unix(585747@a2tech):8963 - Total duration: 1s317ms - Times executed: 1 ]
[ Application: psql - unix(588837@a2tech):8963 - Total duration: 1s316ms - Times executed: 1 ]
[ Application: psql - unix(577619@a2tech):8963 - Total duration: 1s316ms - Times executed: 1 ]
[ Application: psql - unix(590501@a2tech):8963 - Total duration: 1s315ms - Times executed: 1 ]
[ Application: psql - unix(587002@a2tech):8963 - Total duration: 1s314ms - Times executed: 1 ]
[ Application: psql - unix(589672@a2tech):8963 - Total duration: 1s314ms - Times executed: 1 ]
[ Application: psql - unix(580675@a2tech):8963 - Total duration: 1s313ms - Times executed: 1 ]
[ Application: psql - unix(586829@a2tech):8963 - Total duration: 1s311ms - Times executed: 1 ]
[ Application: psql - unix(587991@a2tech):8963 - Total duration: 1s310ms - Times executed: 1 ]
[ Application: psql - unix(586283@a2tech):8963 - Total duration: 1s309ms - Times executed: 1 ]
[ Application: psql - unix(589957@a2tech):8963 - Total duration: 1s309ms - Times executed: 1 ]
[ Application: psql - unix(577996@a2tech):8963 - Total duration: 1s308ms - Times executed: 1 ]
[ Application: psql - unix(580406@a2tech):8963 - Total duration: 1s308ms - Times executed: 1 ]
[ Application: psql - unix(576133@a2tech):8963 - Total duration: 1s306ms - Times executed: 1 ]
[ Application: psql - unix(589255@a2tech):8963 - Total duration: 1s306ms - Times executed: 1 ]
[ Application: psql - unix(587320@a2tech):8963 - Total duration: 1s304ms - Times executed: 1 ]
[ Application: psql - unix(592495@a2tech):8963 - Total duration: 1s304ms - Times executed: 1 ]
[ Application: psql - unix(575222@a2tech):8963 - Total duration: 1s303ms - Times executed: 1 ]
[ Application: psql - unix(582169@a2tech):8963 - Total duration: 1s303ms - Times executed: 1 ]
[ Application: psql - unix(590347@a2tech):8963 - Total duration: 1s302ms - Times executed: 1 ]
[ Application: psql - unix(582857@a2tech):8963 - Total duration: 1s300ms - Times executed: 1 ]
[ Application: psql - unix(580935@a2tech):8963 - Total duration: 1s300ms - Times executed: 1 ]
[ Application: psql - unix(585875@a2tech):8963 - Total duration: 1s300ms - Times executed: 1 ]
[ Application: psql - unix(593807@a2tech):8963 - Total duration: 1s299ms - Times executed: 1 ]
[ Application: psql - unix(584619@a2tech):8963 - Total duration: 1s297ms - Times executed: 1 ]
[ Application: psql - unix(582703@a2tech):8963 - Total duration: 1s295ms - Times executed: 1 ]
[ Application: psql - unix(584308@a2tech):8963 - Total duration: 1s295ms - Times executed: 1 ]
[ Application: psql - unix(583426@a2tech):8963 - Total duration: 1s294ms - Times executed: 1 ]
[ Application: psql - unix(586438@a2tech):8963 - Total duration: 1s292ms - Times executed: 1 ]
[ Application: psql - unix(577119@a2tech):8963 - Total duration: 1s291ms - Times executed: 1 ]
[ Application: psql - unix(588305@a2tech):8963 - Total duration: 1s291ms - Times executed: 1 ]
[ Application: psql - unix(591077@a2tech):8963 - Total duration: 1s289ms - Times executed: 1 ]
[ Application: psql - unix(587160@a2tech):8963 - Total duration: 1s288ms - Times executed: 1 ]
[ Application: psql - unix(584173@a2tech):8963 - Total duration: 1s288ms - Times executed: 1 ]
[ Application: psql - unix(582458@a2tech):8963 - Total duration: 1s287ms - Times executed: 1 ]
[ Application: psql - unix(579118@a2tech):8963 - Total duration: 1s286ms - Times executed: 1 ]
[ Application: psql - unix(587575@a2tech):8963 - Total duration: 1s286ms - Times executed: 1 ]
[ Application: psql - unix(581370@a2tech):8963 - Total duration: 1s285ms - Times executed: 1 ]
[ Application: psql - unix(588680@a2tech):8963 - Total duration: 1s284ms - Times executed: 1 ]
[ Application: psql - unix(591196@a2tech):8963 - Total duration: 1s284ms - Times executed: 1 ]
[ Application: psql - unix(586696@a2tech):8963 - Total duration: 1s283ms - Times executed: 1 ]
[ Application: psql - unix(588144@a2tech):8963 - Total duration: 1s281ms - Times executed: 1 ]
[ Application: psql - unix(585172@a2tech):8963 - Total duration: 1s280ms - Times executed: 1 ]
[ Application: psql - unix(583011@a2tech):8963 - Total duration: 1s279ms - Times executed: 1 ]
[ Application: psql - unix(578600@a2tech):8963 - Total duration: 1s279ms - Times executed: 1 ]
[ Application: psql - unix(581633@a2tech):8963 - Total duration: 1s277ms - Times executed: 1 ]
[ Application: psql - unix(591925@a2tech):8963 - Total duration: 1s277ms - Times executed: 1 ]
[ Application: psql - unix(592620@a2tech):8963 - Total duration: 1s275ms - Times executed: 1 ]
[ Application: psql - unix(575756@a2tech):8963 - Total duration: 1s275ms - Times executed: 1 ]
[ Application: psql - unix(580067@a2tech):8963 - Total duration: 1s274ms - Times executed: 1 ]
[ Application: psql - unix(585614@a2tech):8963 - Total duration: 1s274ms - Times executed: 1 ]
[ Application: psql - unix(590651@a2tech):8963 - Total duration: 1s274ms - Times executed: 1 ]
[ Application: psql - unix(589119@a2tech):8963 - Total duration: 1s274ms - Times executed: 1 ]
[ Application: psql - unix(576016@a2tech):8963 - Total duration: 1s272ms - Times executed: 1 ]
[ Application: psql - unix(583864@a2tech):8963 - Total duration: 1s272ms - Times executed: 1 ]
[ Application: psql - unix(575518@a2tech):8963 - Total duration: 1s272ms - Times executed: 1 ]
[ Application: psql - unix(586006@a2tech):8963 - Total duration: 1s271ms - Times executed: 1 ]
[ Application: psql - unix(592356@a2tech):8963 - Total duration: 1s270ms - Times executed: 1 ]
[ Application: psql - unix(574597@a2tech):8963 - Total duration: 1s270ms - Times executed: 1 ]
[ Application: psql - unix(583279@a2tech):8963 - Total duration: 1s269ms - Times executed: 1 ]
[ Application: psql - unix(579560@a2tech):8963 - Total duration: 1s269ms - Times executed: 1 ]
[ Application: psql - unix(587453@a2tech):8963 - Total duration: 1s268ms - Times executed: 1 ]
[ Application: psql - unix(592873@a2tech):8963 - Total duration: 1s268ms - Times executed: 1 ]
[ Application: psql - unix(593551@a2tech):8963 - Total duration: 1s267ms - Times executed: 1 ]
[ Application: psql - unix(575388@a2tech):8963 - Total duration: 1s267ms - Times executed: 1 ]
[ Application: psql - unix(581242@a2tech):8963 - Total duration: 1s267ms - Times executed: 1 ]
[ Application: psql - unix(574726@a2tech):8963 - Total duration: 1s266ms - Times executed: 1 ]
[ Application: psql - unix(578725@a2tech):8963 - Total duration: 1s266ms - Times executed: 1 ]
[ Application: psql - unix(584776@a2tech):8963 - Total duration: 1s266ms - Times executed: 1 ]
[ Application: psql - unix(587833@a2tech):8963 - Total duration: 1s265ms - Times executed: 1 ]
[ Application: psql - unix(584038@a2tech):8963 - Total duration: 1s265ms - Times executed: 1 ]
[ Application: psql - unix(589387@a2tech):8963 - Total duration: 1s265ms - Times executed: 1 ]
[ Application: psql - unix(585036@a2tech):8963 - Total duration: 1s265ms - Times executed: 1 ]
[ Application: psql - unix(587707@a2tech):8963 - Total duration: 1s263ms - Times executed: 1 ]
[ Application: psql - unix(577242@a2tech):8963 - Total duration: 1s262ms - Times executed: 1 ]
[ Application: psql - unix(580534@a2tech):8963 - Total duration: 1s259ms - Times executed: 1 ]
[ Application: psql - unix(589824@a2tech):8963 - Total duration: 1s258ms - Times executed: 1 ]
[ Application: psql - unix(576260@a2tech):8963 - Total duration: 1s256ms - Times executed: 1 ]
[ Application: psql - unix(586574@a2tech):8963 - Total duration: 1s256ms - Times executed: 1 ]
[ Application: psql - unix(592042@a2tech):8963 - Total duration: 1s255ms - Times executed: 1 ]
[ Application: psql - unix(574962@a2tech):8963 - Total duration: 1s253ms - Times executed: 1 ]
[ Application: psql - unix(593688@a2tech):8963 - Total duration: 1s253ms - Times executed: 1 ]
[ Application: psql - unix(583146@a2tech):8963 - Total duration: 1s253ms - Times executed: 1 ]
[ Application: psql - unix(593424@a2tech):8963 - Total duration: 1s253ms - Times executed: 1 ]
[ Application: psql - unix(593296@a2tech):8963 - Total duration: 1s251ms - Times executed: 1 ]
[ Application: psql - unix(577369@a2tech):8963 - Total duration: 1s249ms - Times executed: 1 ]
[ Application: psql - unix(589509@a2tech):8963 - Total duration: 1s245ms - Times executed: 1 ]
[ Application: psql - unix(584908@a2tech):8963 - Total duration: 1s244ms - Times executed: 1 ]
[ Application: psql - unix(591656@a2tech):8963 - Total duration: 1s243ms - Times executed: 1 ]
[ Application: psql - unix(590816@a2tech):8963 - Total duration: 1s242ms - Times executed: 1 ]
[ Application: psql - unix(574846@a2tech):8963 - Total duration: 1s238ms - Times executed: 1 ]
[ Application: psql - unix(576400@a2tech):8963 - Total duration: 1s238ms - Times executed: 1 ]
[ Application: psql - unix(588991@a2tech):8963 - Total duration: 1s238ms - Times executed: 1 ]
[ Application: psql - unix(577754@a2tech):8963 - Total duration: 1s237ms - Times executed: 1 ]
[ Application: psql - unix(577497@a2tech):8963 - Total duration: 1s234ms - Times executed: 1 ]
[ Application: psql - unix(575639@a2tech):8963 - Total duration: 1s230ms - Times executed: 1 ]
[ Application: psql - unix(576521@a2tech):8963 - Total duration: 1s228ms - Times executed: 1 ]
[ Application: psql - unix(577876@a2tech):8963 - Total duration: 1s220ms - Times executed: 1 ]
[ Application: psql - unix(578296@a2tech):8963 - Total duration: 1s220ms - Times executed: 1 ]
[ Application: psql - unix(578415@a2tech):8963 - Total duration: 1s219ms - Times executed: 1 ]
[ Application: psql - unix(574353@a2tech):8963 - Total duration: 210ms - Times executed: 1 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-17 00:05:04 Duration: 2s115ms Database: rio User: intelifix Remote: [local] Application: psql - unix(574339@a2tech):8963
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-17 20:15:03 Duration: 1s852ms Database: rio User: intelifix Remote: [local] Application: psql - unix(591525@a2tech):8963
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-17 20:35:04 Duration: 1s495ms Database: rio User: intelifix Remote: [local] Application: psql - unix(591781@a2tech):8963
5 1m43s 4 2s110ms 50s650ms 25s996ms 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 May 17 20 2 51s37ms 25s518ms 23 2 52s946ms 26s473ms [ User: intelifix - Total duration: 1m43s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m43s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-17 23:30:17 Duration: 50s650ms 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-05-17 20:06:33 Duration: 48s927ms 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-05-17 23:39:02 Duration: 2s295ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 1m36s 3 14s99ms 1m1s 32s62ms copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 17 23 3 1m36s 32s62ms [ User: intelifix - Total duration: 1m36s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m36s - Times executed: 3 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:11:49 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:31:28 Duration: 20s93ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:39:42 Duration: 14s99ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 1m24s 4 273ms 43s271ms 21s20ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 17 20 2 40s532ms 20s266ms 23 2 43s548ms 21s774ms [ User: intelifix - Total duration: 1m24s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-17 23:15:53 Duration: 43s271ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-17 20:04:31 Duration: 40s258ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-17 23:32:28 Duration: 277ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m19s 3 12s728ms 50s655ms 26s584ms copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 17 23 3 1m19s 26s584ms [ User: intelifix - Total duration: 1m19s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m19s - Times executed: 3 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:12:40 Duration: 50s655ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:31:44 Duration: 16s369ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:39:55 Duration: 12s728ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 1m13s 3 11s209ms 44s304ms 24s515ms copy auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 17 23 3 1m13s 24s515ms [ User: intelifix - Total duration: 1m13s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 3 ]
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:10:47 Duration: 44s304ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:31:08 Duration: 18s33ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:39:28 Duration: 11s209ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1m9s 6 1s670ms 27s101ms 11s653ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 17 20 3 33s415ms 11s138ms 23 3 36s502ms 12s167ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-17 23:16:21 Duration: 27s101ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-17 20:04:57 Duration: 24s911ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-17 23:32:36 Duration: 7s602ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 58s2ms 6 1s218ms 23s198ms 9s667ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 17 20 3 27s626ms 9s208ms 23 3 30s376ms 10s125ms [ User: intelifix - Total duration: 58s2ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s2ms - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-17 23:16:46 Duration: 23s198ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-17 20:05:20 Duration: 21s167ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-17 23:32:42 Duration: 5s824ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 57s659ms 6 2s266ms 23s240ms 9s609ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 17 20 3 27s333ms 9s111ms 23 3 30s325ms 10s108ms [ User: intelifix - Total duration: 57s659ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s659ms - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-17 23:30:40 Duration: 23s240ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-17 20:06:54 Duration: 20s991ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-17 23:39:07 Duration: 4s604ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 47s629ms 6 1s144ms 16s838ms 7s938ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 17 20 3 22s791ms 7s597ms 23 3 24s838ms 8s279ms [ User: intelifix - Total duration: 47s629ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 47s629ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 23:14:10 Duration: 16s838ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 20:02:57 Duration: 15s563ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 23:32:14 Duration: 6s760ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 47s550ms 6 1s266ms 16s378ms 7s925ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 17 20 3 22s815ms 7s605ms 23 3 24s735ms 8s245ms [ User: intelifix - Total duration: 47s550ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 47s550ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 23:13:41 Duration: 16s378ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 20:02:30 Duration: 15s140ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 23:32:06 Duration: 7s6ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 46s960ms 3 7s591ms 30s467ms 15s653ms copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 17 23 3 46s960ms 15s653ms [ User: intelifix - Total duration: 46s960ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 46s960ms - Times executed: 3 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:13:10 Duration: 30s467ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:31:53 Duration: 8s901ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:40:02 Duration: 7s591ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 46s135ms 1 46s135ms 46s135ms 46s135ms refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 17 05 1 46s135ms 46s135ms [ User: intelifix - Total duration: 46s135ms - Times executed: 1 ]
[ Application: psql - unix(578932@a2tech):8963 - Total duration: 46s135ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-17 05:31:09 Duration: 46s135ms Database: rio User: intelifix Remote: [local] Application: psql - unix(578932@a2tech):8963
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-17 05:31:04 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(578932@a2tech):8963
17 42s389ms 6 883ms 17s979ms 7s64ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 17 20 3 20s22ms 6s674ms 23 3 22s367ms 7s455ms [ User: intelifix - Total duration: 42s389ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 42s389ms - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-17 23:14:53 Duration: 17s979ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-17 20:03:36 Duration: 16s95ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-17 23:32:25 Duration: 3s413ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 37s424ms 4 2s533ms 16s805ms 9s356ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 17 20 2 17s766ms 8s883ms 23 2 19s658ms 9s829ms [ User: intelifix - Total duration: 37s424ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 37s424ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-17 23:15:10 Duration: 16s805ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-17 20:03:51 Duration: 15s233ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-17 23:32:28 Duration: 2s852ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 35s535ms 6 929ms 12s208ms 5s922ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 17 20 3 16s769ms 5s589ms 23 3 18s765ms 6s255ms [ User: intelifix - Total duration: 35s535ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s535ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-17 23:14:22 Duration: 12s208ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-17 20:03:08 Duration: 10s940ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-17 23:32:20 Duration: 5s537ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 27s496ms 3 174ms 22s787ms 9s165ms copy public.posicao_oficina_21 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 17 23 3 27s496ms 9s165ms [ User: intelifix - Total duration: 27s496ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 27s496ms - Times executed: 3 ]
-
COPY public.posicao_oficina_21 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) TO stdout;
Date: 2026-05-17 23:27:45 Duration: 22s787ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.posicao_oficina_21 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) TO stdout;
Date: 2026-05-17 23:38:10 Duration: 4s534ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.posicao_oficina_21 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) TO stdout;
Date: 2026-05-17 23:40:32 Duration: 174ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 139 3m 210ms 2s115ms 1s301ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 17 00 7 8s714ms 1s244ms 01 6 7s689ms 1s281ms 02 6 7s672ms 1s278ms 03 6 7s683ms 1s280ms 04 6 7s552ms 1s258ms 05 6 7s914ms 1s319ms 06 6 7s941ms 1s323ms 07 6 7s881ms 1s313ms 08 6 7s860ms 1s310ms 09 6 7s979ms 1s329ms 10 6 7s734ms 1s289ms 11 6 7s907ms 1s317ms 12 6 7s677ms 1s279ms 13 6 7s946ms 1s324ms 14 6 7s768ms 1s294ms 15 6 7s677ms 1s279ms 16 6 7s838ms 1s306ms 17 6 7s645ms 1s274ms 18 6 7s909ms 1s318ms 19 6 7s776ms 1s296ms 20 6 8s467ms 1s411ms 21 6 7s955ms 1s325ms 22 6 7s667ms 1s277ms [ User: intelifix - Total duration: 3m - Times executed: 139 ]
[ Application: psql - unix(574339@a2tech):8963 - Total duration: 2s115ms - Times executed: 1 ]
[ Application: psql - unix(591525@a2tech):8963 - Total duration: 1s852ms - Times executed: 1 ]
[ Application: psql - unix(591781@a2tech):8963 - Total duration: 1s495ms - Times executed: 1 ]
[ Application: psql - unix(592194@a2tech):8963 - Total duration: 1s491ms - Times executed: 1 ]
[ Application: psql - unix(585460@a2tech):8963 - Total duration: 1s418ms - Times executed: 1 ]
[ Application: psql - unix(590222@a2tech):8963 - Total duration: 1s402ms - Times executed: 1 ]
[ Application: psql - unix(584435@a2tech):8963 - Total duration: 1s397ms - Times executed: 1 ]
[ Application: psql - unix(579424@a2tech):8963 - Total duration: 1s396ms - Times executed: 1 ]
[ Application: psql - unix(583707@a2tech):8963 - Total duration: 1s388ms - Times executed: 1 ]
[ Application: psql - unix(582006@a2tech):8963 - Total duration: 1s380ms - Times executed: 1 ]
[ Application: psql - unix(578840@a2tech):8963 - Total duration: 1s372ms - Times executed: 1 ]
[ Application: psql - unix(590946@a2tech):8963 - Total duration: 1s369ms - Times executed: 1 ]
[ Application: psql - unix(575893@a2tech):8963 - Total duration: 1s368ms - Times executed: 1 ]
[ Application: psql - unix(581498@a2tech):8963 - Total duration: 1s367ms - Times executed: 1 ]
[ Application: psql - unix(578996@a2tech):8963 - Total duration: 1s367ms - Times executed: 1 ]
[ Application: psql - unix(582585@a2tech):8963 - Total duration: 1s366ms - Times executed: 1 ]
[ Application: psql - unix(586127@a2tech):8963 - Total duration: 1s363ms - Times executed: 1 ]
[ Application: psql - unix(580224@a2tech):8963 - Total duration: 1s362ms - Times executed: 1 ]
[ Application: psql - unix(574479@a2tech):8963 - Total duration: 1s357ms - Times executed: 1 ]
[ Application: psql - unix(579940@a2tech):8963 - Total duration: 1s346ms - Times executed: 1 ]
[ Application: psql - unix(582309@a2tech):8963 - Total duration: 1s345ms - Times executed: 1 ]
[ Application: psql - unix(578128@a2tech):8963 - Total duration: 1s344ms - Times executed: 1 ]
[ Application: psql - unix(592756@a2tech):8963 - Total duration: 1s344ms - Times executed: 1 ]
[ Application: psql - unix(591368@a2tech):8963 - Total duration: 1s344ms - Times executed: 1 ]
[ Application: psql - unix(579237@a2tech):8963 - Total duration: 1s342ms - Times executed: 1 ]
[ Application: psql - unix(593053@a2tech):8963 - Total duration: 1s340ms - Times executed: 1 ]
[ Application: psql - unix(575098@a2tech):8963 - Total duration: 1s340ms - Times executed: 1 ]
[ Application: psql - unix(580811@a2tech):8963 - Total duration: 1s336ms - Times executed: 1 ]
[ Application: psql - unix(588562@a2tech):8963 - Total duration: 1s336ms - Times executed: 1 ]
[ Application: psql - unix(583544@a2tech):8963 - Total duration: 1s336ms - Times executed: 1 ]
[ Application: psql - unix(588429@a2tech):8963 - Total duration: 1s335ms - Times executed: 1 ]
[ Application: psql - unix(581092@a2tech):8963 - Total duration: 1s332ms - Times executed: 1 ]
[ Application: psql - unix(581791@a2tech):8963 - Total duration: 1s329ms - Times executed: 1 ]
[ Application: psql - unix(576985@a2tech):8963 - Total duration: 1s329ms - Times executed: 1 ]
[ Application: psql - unix(579809@a2tech):8963 - Total duration: 1s328ms - Times executed: 1 ]
[ Application: psql - unix(579681@a2tech):8963 - Total duration: 1s325ms - Times executed: 1 ]
[ Application: psql - unix(585298@a2tech):8963 - Total duration: 1s324ms - Times executed: 1 ]
[ Application: psql - unix(590087@a2tech):8963 - Total duration: 1s323ms - Times executed: 1 ]
[ Application: psql - unix(585747@a2tech):8963 - Total duration: 1s317ms - Times executed: 1 ]
[ Application: psql - unix(588837@a2tech):8963 - Total duration: 1s316ms - Times executed: 1 ]
[ Application: psql - unix(577619@a2tech):8963 - Total duration: 1s316ms - Times executed: 1 ]
[ Application: psql - unix(590501@a2tech):8963 - Total duration: 1s315ms - Times executed: 1 ]
[ Application: psql - unix(587002@a2tech):8963 - Total duration: 1s314ms - Times executed: 1 ]
[ Application: psql - unix(589672@a2tech):8963 - Total duration: 1s314ms - Times executed: 1 ]
[ Application: psql - unix(580675@a2tech):8963 - Total duration: 1s313ms - Times executed: 1 ]
[ Application: psql - unix(586829@a2tech):8963 - Total duration: 1s311ms - Times executed: 1 ]
[ Application: psql - unix(587991@a2tech):8963 - Total duration: 1s310ms - Times executed: 1 ]
[ Application: psql - unix(586283@a2tech):8963 - Total duration: 1s309ms - Times executed: 1 ]
[ Application: psql - unix(589957@a2tech):8963 - Total duration: 1s309ms - Times executed: 1 ]
[ Application: psql - unix(577996@a2tech):8963 - Total duration: 1s308ms - Times executed: 1 ]
[ Application: psql - unix(580406@a2tech):8963 - Total duration: 1s308ms - Times executed: 1 ]
[ Application: psql - unix(576133@a2tech):8963 - Total duration: 1s306ms - Times executed: 1 ]
[ Application: psql - unix(589255@a2tech):8963 - Total duration: 1s306ms - Times executed: 1 ]
[ Application: psql - unix(587320@a2tech):8963 - Total duration: 1s304ms - Times executed: 1 ]
[ Application: psql - unix(592495@a2tech):8963 - Total duration: 1s304ms - Times executed: 1 ]
[ Application: psql - unix(575222@a2tech):8963 - Total duration: 1s303ms - Times executed: 1 ]
[ Application: psql - unix(582169@a2tech):8963 - Total duration: 1s303ms - Times executed: 1 ]
[ Application: psql - unix(590347@a2tech):8963 - Total duration: 1s302ms - Times executed: 1 ]
[ Application: psql - unix(582857@a2tech):8963 - Total duration: 1s300ms - Times executed: 1 ]
[ Application: psql - unix(580935@a2tech):8963 - Total duration: 1s300ms - Times executed: 1 ]
[ Application: psql - unix(585875@a2tech):8963 - Total duration: 1s300ms - Times executed: 1 ]
[ Application: psql - unix(593807@a2tech):8963 - Total duration: 1s299ms - Times executed: 1 ]
[ Application: psql - unix(584619@a2tech):8963 - Total duration: 1s297ms - Times executed: 1 ]
[ Application: psql - unix(582703@a2tech):8963 - Total duration: 1s295ms - Times executed: 1 ]
[ Application: psql - unix(584308@a2tech):8963 - Total duration: 1s295ms - Times executed: 1 ]
[ Application: psql - unix(583426@a2tech):8963 - Total duration: 1s294ms - Times executed: 1 ]
[ Application: psql - unix(586438@a2tech):8963 - Total duration: 1s292ms - Times executed: 1 ]
[ Application: psql - unix(577119@a2tech):8963 - Total duration: 1s291ms - Times executed: 1 ]
[ Application: psql - unix(588305@a2tech):8963 - Total duration: 1s291ms - Times executed: 1 ]
[ Application: psql - unix(591077@a2tech):8963 - Total duration: 1s289ms - Times executed: 1 ]
[ Application: psql - unix(587160@a2tech):8963 - Total duration: 1s288ms - Times executed: 1 ]
[ Application: psql - unix(584173@a2tech):8963 - Total duration: 1s288ms - Times executed: 1 ]
[ Application: psql - unix(582458@a2tech):8963 - Total duration: 1s287ms - Times executed: 1 ]
[ Application: psql - unix(579118@a2tech):8963 - Total duration: 1s286ms - Times executed: 1 ]
[ Application: psql - unix(587575@a2tech):8963 - Total duration: 1s286ms - Times executed: 1 ]
[ Application: psql - unix(581370@a2tech):8963 - Total duration: 1s285ms - Times executed: 1 ]
[ Application: psql - unix(588680@a2tech):8963 - Total duration: 1s284ms - Times executed: 1 ]
[ Application: psql - unix(591196@a2tech):8963 - Total duration: 1s284ms - Times executed: 1 ]
[ Application: psql - unix(586696@a2tech):8963 - Total duration: 1s283ms - Times executed: 1 ]
[ Application: psql - unix(588144@a2tech):8963 - Total duration: 1s281ms - Times executed: 1 ]
[ Application: psql - unix(585172@a2tech):8963 - Total duration: 1s280ms - Times executed: 1 ]
[ Application: psql - unix(583011@a2tech):8963 - Total duration: 1s279ms - Times executed: 1 ]
[ Application: psql - unix(578600@a2tech):8963 - Total duration: 1s279ms - Times executed: 1 ]
[ Application: psql - unix(581633@a2tech):8963 - Total duration: 1s277ms - Times executed: 1 ]
[ Application: psql - unix(591925@a2tech):8963 - Total duration: 1s277ms - Times executed: 1 ]
[ Application: psql - unix(592620@a2tech):8963 - Total duration: 1s275ms - Times executed: 1 ]
[ Application: psql - unix(575756@a2tech):8963 - Total duration: 1s275ms - Times executed: 1 ]
[ Application: psql - unix(580067@a2tech):8963 - Total duration: 1s274ms - Times executed: 1 ]
[ Application: psql - unix(585614@a2tech):8963 - Total duration: 1s274ms - Times executed: 1 ]
[ Application: psql - unix(590651@a2tech):8963 - Total duration: 1s274ms - Times executed: 1 ]
[ Application: psql - unix(589119@a2tech):8963 - Total duration: 1s274ms - Times executed: 1 ]
[ Application: psql - unix(576016@a2tech):8963 - Total duration: 1s272ms - Times executed: 1 ]
[ Application: psql - unix(583864@a2tech):8963 - Total duration: 1s272ms - Times executed: 1 ]
[ Application: psql - unix(575518@a2tech):8963 - Total duration: 1s272ms - Times executed: 1 ]
[ Application: psql - unix(586006@a2tech):8963 - Total duration: 1s271ms - Times executed: 1 ]
[ Application: psql - unix(592356@a2tech):8963 - Total duration: 1s270ms - Times executed: 1 ]
[ Application: psql - unix(574597@a2tech):8963 - Total duration: 1s270ms - Times executed: 1 ]
[ Application: psql - unix(583279@a2tech):8963 - Total duration: 1s269ms - Times executed: 1 ]
[ Application: psql - unix(579560@a2tech):8963 - Total duration: 1s269ms - Times executed: 1 ]
[ Application: psql - unix(587453@a2tech):8963 - Total duration: 1s268ms - Times executed: 1 ]
[ Application: psql - unix(592873@a2tech):8963 - Total duration: 1s268ms - Times executed: 1 ]
[ Application: psql - unix(593551@a2tech):8963 - Total duration: 1s267ms - Times executed: 1 ]
[ Application: psql - unix(575388@a2tech):8963 - Total duration: 1s267ms - Times executed: 1 ]
[ Application: psql - unix(581242@a2tech):8963 - Total duration: 1s267ms - Times executed: 1 ]
[ Application: psql - unix(574726@a2tech):8963 - Total duration: 1s266ms - Times executed: 1 ]
[ Application: psql - unix(578725@a2tech):8963 - Total duration: 1s266ms - Times executed: 1 ]
[ Application: psql - unix(584776@a2tech):8963 - Total duration: 1s266ms - Times executed: 1 ]
[ Application: psql - unix(587833@a2tech):8963 - Total duration: 1s265ms - Times executed: 1 ]
[ Application: psql - unix(584038@a2tech):8963 - Total duration: 1s265ms - Times executed: 1 ]
[ Application: psql - unix(589387@a2tech):8963 - Total duration: 1s265ms - Times executed: 1 ]
[ Application: psql - unix(585036@a2tech):8963 - Total duration: 1s265ms - Times executed: 1 ]
[ Application: psql - unix(587707@a2tech):8963 - Total duration: 1s263ms - Times executed: 1 ]
[ Application: psql - unix(577242@a2tech):8963 - Total duration: 1s262ms - Times executed: 1 ]
[ Application: psql - unix(580534@a2tech):8963 - Total duration: 1s259ms - Times executed: 1 ]
[ Application: psql - unix(589824@a2tech):8963 - Total duration: 1s258ms - Times executed: 1 ]
[ Application: psql - unix(576260@a2tech):8963 - Total duration: 1s256ms - Times executed: 1 ]
[ Application: psql - unix(586574@a2tech):8963 - Total duration: 1s256ms - Times executed: 1 ]
[ Application: psql - unix(592042@a2tech):8963 - Total duration: 1s255ms - Times executed: 1 ]
[ Application: psql - unix(574962@a2tech):8963 - Total duration: 1s253ms - Times executed: 1 ]
[ Application: psql - unix(593688@a2tech):8963 - Total duration: 1s253ms - Times executed: 1 ]
[ Application: psql - unix(583146@a2tech):8963 - Total duration: 1s253ms - Times executed: 1 ]
[ Application: psql - unix(593424@a2tech):8963 - Total duration: 1s253ms - Times executed: 1 ]
[ Application: psql - unix(593296@a2tech):8963 - Total duration: 1s251ms - Times executed: 1 ]
[ Application: psql - unix(577369@a2tech):8963 - Total duration: 1s249ms - Times executed: 1 ]
[ Application: psql - unix(589509@a2tech):8963 - Total duration: 1s245ms - Times executed: 1 ]
[ Application: psql - unix(584908@a2tech):8963 - Total duration: 1s244ms - Times executed: 1 ]
[ Application: psql - unix(591656@a2tech):8963 - Total duration: 1s243ms - Times executed: 1 ]
[ Application: psql - unix(590816@a2tech):8963 - Total duration: 1s242ms - Times executed: 1 ]
[ Application: psql - unix(574846@a2tech):8963 - Total duration: 1s238ms - Times executed: 1 ]
[ Application: psql - unix(576400@a2tech):8963 - Total duration: 1s238ms - Times executed: 1 ]
[ Application: psql - unix(588991@a2tech):8963 - Total duration: 1s238ms - Times executed: 1 ]
[ Application: psql - unix(577754@a2tech):8963 - Total duration: 1s237ms - Times executed: 1 ]
[ Application: psql - unix(577497@a2tech):8963 - Total duration: 1s234ms - Times executed: 1 ]
[ Application: psql - unix(575639@a2tech):8963 - Total duration: 1s230ms - Times executed: 1 ]
[ Application: psql - unix(576521@a2tech):8963 - Total duration: 1s228ms - Times executed: 1 ]
[ Application: psql - unix(577876@a2tech):8963 - Total duration: 1s220ms - Times executed: 1 ]
[ Application: psql - unix(578296@a2tech):8963 - Total duration: 1s220ms - Times executed: 1 ]
[ Application: psql - unix(578415@a2tech):8963 - Total duration: 1s219ms - Times executed: 1 ]
[ Application: psql - unix(574353@a2tech):8963 - Total duration: 210ms - Times executed: 1 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-17 00:05:04 Duration: 2s115ms Database: rio User: intelifix Remote: [local] Application: psql - unix(574339@a2tech):8963
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-17 20:15:03 Duration: 1s852ms Database: rio User: intelifix Remote: [local] Application: psql - unix(591525@a2tech):8963
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-17 20:35:04 Duration: 1s495ms Database: rio User: intelifix Remote: [local] Application: psql - unix(591781@a2tech):8963
2 48 55m53s 547ms 3m32s 1m9s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 17 07 3 3m43s 1m14s 08 3 3m27s 1m9s 09 3 3m28s 1m9s 10 3 3m27s 1m9s 11 3 3m30s 1m10s 12 3 3m27s 1m9s 13 3 3m27s 1m9s 14 3 3m27s 1m9s 15 3 3m24s 1m8s 16 3 3m27s 1m9s 17 3 3m28s 1m9s 18 3 3m26s 1m8s 19 3 3m27s 1m9s 20 3 3m39s 1m13s 21 3 3m28s 1m9s 22 3 3m29s 1m9s [ User: intelifix - Total duration: 55m53s - Times executed: 48 ]
[ Application: psql - unix(580215@a2tech):8963 - Total duration: 3m32s - Times executed: 1 ]
[ Application: psql - unix(591364@a2tech):8963 - Total duration: 3m29s - Times executed: 1 ]
[ Application: psql - unix(583704@a2tech):8963 - Total duration: 3m21s - Times executed: 1 ]
[ Application: psql - unix(593046@a2tech):8963 - Total duration: 3m20s - Times executed: 1 ]
[ Application: psql - unix(582002@a2tech):8963 - Total duration: 3m19s - Times executed: 1 ]
[ Application: psql - unix(588833@a2tech):8963 - Total duration: 3m19s - Times executed: 1 ]
[ Application: psql - unix(592197@a2tech):8963 - Total duration: 3m19s - Times executed: 1 ]
[ Application: psql - unix(584611@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(581089@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(582854@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(587984@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(590494@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(586279@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(585452@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(589668@a2tech):8963 - Total duration: 3m17s - Times executed: 1 ]
[ Application: psql - unix(587157@a2tech):8963 - Total duration: 3m15s - Times executed: 1 ]
[ Application: psql - unix(580322@a2tech):8963 - Total duration: 10s242ms - Times executed: 1 ]
[ Application: psql - unix(591441@a2tech):8963 - Total duration: 9s377ms - Times executed: 1 ]
[ Application: psql - unix(582069@a2tech):8963 - Total duration: 8s665ms - Times executed: 1 ]
[ Application: psql - unix(586349@a2tech):8963 - Total duration: 8s637ms - Times executed: 1 ]
[ Application: psql - unix(582920@a2tech):8963 - Total duration: 8s632ms - Times executed: 1 ]
[ Application: psql - unix(588056@a2tech):8963 - Total duration: 8s585ms - Times executed: 1 ]
[ Application: psql - unix(583772@a2tech):8963 - Total duration: 8s573ms - Times executed: 1 ]
[ Application: psql - unix(581156@a2tech):8963 - Total duration: 8s566ms - Times executed: 1 ]
[ Application: psql - unix(590567@a2tech):8963 - Total duration: 8s550ms - Times executed: 1 ]
[ Application: psql - unix(589738@a2tech):8963 - Total duration: 8s540ms - Times executed: 1 ]
[ Application: psql - unix(592266@a2tech):8963 - Total duration: 8s536ms - Times executed: 1 ]
[ Application: psql - unix(587223@a2tech):8963 - Total duration: 8s518ms - Times executed: 1 ]
[ Application: psql - unix(585528@a2tech):8963 - Total duration: 8s505ms - Times executed: 1 ]
[ Application: psql - unix(593208@a2tech):8963 - Total duration: 8s486ms - Times executed: 1 ]
[ Application: psql - unix(588901@a2tech):8963 - Total duration: 8s427ms - Times executed: 1 ]
[ Application: psql - unix(584683@a2tech):8963 - Total duration: 8s317ms - Times executed: 1 ]
[ Application: psql - unix(591472@a2tech):8963 - Total duration: 765ms - Times executed: 1 ]
[ Application: psql - unix(580351@a2tech):8963 - Total duration: 756ms - Times executed: 1 ]
[ Application: psql - unix(589768@a2tech):8963 - Total duration: 599ms - Times executed: 1 ]
[ Application: psql - unix(585560@a2tech):8963 - Total duration: 593ms - Times executed: 1 ]
[ Application: psql - unix(582103@a2tech):8963 - Total duration: 592ms - Times executed: 1 ]
[ Application: psql - unix(584722@a2tech):8963 - Total duration: 582ms - Times executed: 1 ]
[ Application: psql - unix(588933@a2tech):8963 - Total duration: 573ms - Times executed: 1 ]
[ Application: psql - unix(593238@a2tech):8963 - Total duration: 571ms - Times executed: 1 ]
[ Application: psql - unix(582953@a2tech):8963 - Total duration: 568ms - Times executed: 1 ]
[ Application: psql - unix(592297@a2tech):8963 - Total duration: 567ms - Times executed: 1 ]
[ Application: psql - unix(587255@a2tech):8963 - Total duration: 567ms - Times executed: 1 ]
[ Application: psql - unix(583802@a2tech):8963 - Total duration: 564ms - Times executed: 1 ]
[ Application: psql - unix(588088@a2tech):8963 - Total duration: 559ms - Times executed: 1 ]
[ Application: psql - unix(586382@a2tech):8963 - Total duration: 554ms - Times executed: 1 ]
[ Application: psql - unix(590595@a2tech):8963 - Total duration: 553ms - Times executed: 1 ]
[ Application: psql - unix(581187@a2tech):8963 - Total duration: 547ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-17 07:08:34 Duration: 3m32s Database: rio User: intelifix Remote: [local] Application: psql - unix(580215@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-17 20:08:32 Duration: 3m29s Database: rio User: intelifix Remote: [local] Application: psql - unix(591364@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-17 11:08:23 Duration: 3m21s Database: rio User: intelifix Remote: [local] Application: psql - unix(583704@a2tech):8963
3 48 40m31s 337ms 2m14s 50s664ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 17 07 3 2m37s 52s485ms 08 3 2m30s 50s213ms 09 3 2m31s 50s587ms 10 3 2m32s 50s701ms 11 3 2m31s 50s511ms 12 3 2m30s 50s275ms 13 3 2m31s 50s399ms 14 3 2m31s 50s489ms 15 3 2m30s 50s205ms 16 3 2m31s 50s422ms 17 3 2m31s 50s441ms 18 3 2m30s 50s260ms 19 3 2m31s 50s461ms 20 3 2m37s 52s377ms 21 3 2m31s 50s374ms 22 3 2m31s 50s427ms [ User: intelifix - Total duration: 40m31s - Times executed: 48 ]
[ Application: psql - unix(580326@a2tech):8963 - Total duration: 2m14s - Times executed: 1 ]
[ Application: psql - unix(591446@a2tech):8963 - Total duration: 2m14s - Times executed: 1 ]
[ Application: psql - unix(582075@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(586354@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(588906@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(588060@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(585533@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(583777@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(590571@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(582925@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(589742@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(592269@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(593212@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(587229@a2tech):8963 - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - unix(581161@a2tech):8963 - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - unix(584688@a2tech):8963 - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - unix(580314@a2tech):8963 - Total duration: 22s523ms - Times executed: 1 ]
[ Application: psql - unix(591434@a2tech):8963 - Total duration: 22s441ms - Times executed: 1 ]
[ Application: psql - unix(582914@a2tech):8963 - Total duration: 19s256ms - Times executed: 1 ]
[ Application: psql - unix(593199@a2tech):8963 - Total duration: 18s807ms - Times executed: 1 ]
[ Application: psql - unix(582063@a2tech):8963 - Total duration: 18s692ms - Times executed: 1 ]
[ Application: psql - unix(583766@a2tech):8963 - Total duration: 18s633ms - Times executed: 1 ]
[ Application: psql - unix(584677@a2tech):8963 - Total duration: 18s613ms - Times executed: 1 ]
[ Application: psql - unix(590558@a2tech):8963 - Total duration: 18s519ms - Times executed: 1 ]
[ Application: psql - unix(592258@a2tech):8963 - Total duration: 18s491ms - Times executed: 1 ]
[ Application: psql - unix(581149@a2tech):8963 - Total duration: 18s416ms - Times executed: 1 ]
[ Application: psql - unix(586341@a2tech):8963 - Total duration: 18s398ms - Times executed: 1 ]
[ Application: psql - unix(588048@a2tech):8963 - Total duration: 18s342ms - Times executed: 1 ]
[ Application: psql - unix(588893@a2tech):8963 - Total duration: 18s289ms - Times executed: 1 ]
[ Application: psql - unix(585520@a2tech):8963 - Total duration: 18s274ms - Times executed: 1 ]
[ Application: psql - unix(587216@a2tech):8963 - Total duration: 18s266ms - Times executed: 1 ]
[ Application: psql - unix(589730@a2tech):8963 - Total duration: 18s143ms - Times executed: 1 ]
[ Application: psql - unix(591476@a2tech):8963 - Total duration: 499ms - Times executed: 1 ]
[ Application: psql - unix(580356@a2tech):8963 - Total duration: 497ms - Times executed: 1 ]
[ Application: psql - unix(585565@a2tech):8963 - Total duration: 376ms - Times executed: 1 ]
[ Application: psql - unix(592301@a2tech):8963 - Total duration: 370ms - Times executed: 1 ]
[ Application: psql - unix(588092@a2tech):8963 - Total duration: 369ms - Times executed: 1 ]
[ Application: psql - unix(586386@a2tech):8963 - Total duration: 368ms - Times executed: 1 ]
[ Application: psql - unix(590598@a2tech):8963 - Total duration: 366ms - Times executed: 1 ]
[ Application: psql - unix(588939@a2tech):8963 - Total duration: 363ms - Times executed: 1 ]
[ Application: psql - unix(583806@a2tech):8963 - Total duration: 360ms - Times executed: 1 ]
[ Application: psql - unix(582957@a2tech):8963 - Total duration: 359ms - Times executed: 1 ]
[ Application: psql - unix(593243@a2tech):8963 - Total duration: 358ms - Times executed: 1 ]
[ Application: psql - unix(582107@a2tech):8963 - Total duration: 358ms - Times executed: 1 ]
[ Application: psql - unix(584726@a2tech):8963 - Total duration: 354ms - Times executed: 1 ]
[ Application: psql - unix(587260@a2tech):8963 - Total duration: 352ms - Times executed: 1 ]
[ Application: psql - unix(581190@a2tech):8963 - Total duration: 338ms - Times executed: 1 ]
[ Application: psql - unix(589771@a2tech):8963 - Total duration: 337ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-17 07:11:23 Duration: 2m14s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(580326@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-17 20:11:19 Duration: 2m14s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(591446@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-17 09:11:03 Duration: 2m12s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(582075@a2tech):8963
4 29 9s967ms 153ms 3s308ms 343ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 17 08 2 844ms 422ms 09 1 222ms 222ms 10 1 205ms 205ms 11 2 482ms 241ms 12 2 486ms 243ms 13 3 625ms 208ms 14 1 204ms 204ms 15 2 3s515ms 1s757ms 16 3 575ms 191ms 17 1 215ms 215ms 18 4 908ms 227ms 19 2 491ms 245ms 20 3 721ms 240ms 21 1 205ms 205ms 22 1 262ms 262ms [ User: intelifix - Total duration: 9s967ms - Times executed: 29 ]
[ Application: psql - unix(587399@a2tech):8963 - Total duration: 3s308ms - Times executed: 1 ]
[ Application: psql - unix(581008@a2tech):8963 - Total duration: 586ms - Times executed: 1 ]
[ Application: psql - unix(592951@a2tech):8963 - Total duration: 262ms - Times executed: 1 ]
[ Application: psql - unix(581010@a2tech):8963 - Total duration: 258ms - Times executed: 1 ]
[ Application: psql - unix(584250@a2tech):8963 - Total duration: 258ms - Times executed: 1 ]
[ Application: psql - unix(591020@a2tech):8963 - Total duration: 255ms - Times executed: 1 ]
[ Application: psql - unix(591858@a2tech):8963 - Total duration: 255ms - Times executed: 1 ]
[ Application: psql - unix(591860@a2tech):8963 - Total duration: 250ms - Times executed: 1 ]
[ Application: psql - unix(585948@a2tech):8963 - Total duration: 248ms - Times executed: 1 ]
[ Application: psql - unix(589588@a2tech):8963 - Total duration: 246ms - Times executed: 1 ]
[ Application: psql - unix(585112@a2tech):8963 - Total duration: 245ms - Times executed: 1 ]
[ Application: psql - unix(585114@a2tech):8963 - Total duration: 240ms - Times executed: 1 ]
[ Application: psql - unix(590727@a2tech):8963 - Total duration: 235ms - Times executed: 1 ]
[ Application: psql - unix(590165@a2tech):8963 - Total duration: 227ms - Times executed: 1 ]
[ Application: psql - unix(583974@a2tech):8963 - Total duration: 224ms - Times executed: 1 ]
[ Application: psql - unix(589898@a2tech):8963 - Total duration: 223ms - Times executed: 1 ]
[ Application: psql - unix(582256@a2tech):8963 - Total duration: 222ms - Times executed: 1 ]
[ Application: psql - unix(587905@a2tech):8963 - Total duration: 222ms - Times executed: 1 ]
[ Application: psql - unix(585377@a2tech):8963 - Total duration: 222ms - Times executed: 1 ]
[ Application: psql - unix(591269@a2tech):8963 - Total duration: 215ms - Times executed: 1 ]
[ Application: psql - unix(589064@a2tech):8963 - Total duration: 215ms - Times executed: 1 ]
[ Application: psql - unix(589900@a2tech):8963 - Total duration: 212ms - Times executed: 1 ]
[ Application: psql - unix(587078@a2tech):8963 - Total duration: 206ms - Times executed: 1 ]
[ Application: psql - unix(592117@a2tech):8963 - Total duration: 205ms - Times executed: 1 ]
[ Application: psql - unix(583087@a2tech):8963 - Total duration: 205ms - Times executed: 1 ]
[ Application: psql - unix(586200@a2tech):8963 - Total duration: 204ms - Times executed: 1 ]
[ Application: psql - unix(588250@a2tech):8963 - Total duration: 199ms - Times executed: 1 ]
[ Application: psql - unix(585946@a2tech):8963 - Total duration: 155ms - Times executed: 1 ]
[ Application: psql - unix(587903@a2tech):8963 - Total duration: 153ms - Times executed: 1 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-17 15:20:08 Duration: 3s308ms Database: brasilia User: intelifix Remote: [local] Application: psql - unix(587399@a2tech):8963
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-17 08:00:02 Duration: 586ms Database: rio User: intelifix Remote: [local] Application: psql - unix(581008@a2tech):8963
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-17 22:00:02 Duration: 262ms Database: brasilia User: intelifix Remote: [local] Application: psql - unix(592951@a2tech):8963
5 24 8s571ms 151ms 3s723ms 357ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 17 08 1 257ms 257ms 09 1 252ms 252ms 10 1 226ms 226ms 11 2 400ms 200ms 12 1 258ms 258ms 13 1 270ms 270ms 14 1 235ms 235ms 15 2 3s875ms 1s937ms 16 2 470ms 235ms 17 2 420ms 210ms 18 1 247ms 247ms 19 1 151ms 151ms 20 2 316ms 158ms 21 3 641ms 213ms 22 3 546ms 182ms [ User: intelifix - Total duration: 8s571ms - Times executed: 24 ]
[ Application: psql - unix(587397@a2tech):8963 - Total duration: 3s723ms - Times executed: 1 ]
[ Application: psql - unix(585686@a2tech):8963 - Total duration: 270ms - Times executed: 1 ]
[ Application: psql - unix(589062@a2tech):8963 - Total duration: 269ms - Times executed: 1 ]
[ Application: psql - unix(584537@a2tech):8963 - Total duration: 258ms - Times executed: 1 ]
[ Application: psql - unix(581571@a2tech):8963 - Total duration: 257ms - Times executed: 1 ]
[ Application: psql - unix(582529@a2tech):8963 - Total duration: 252ms - Times executed: 1 ]
[ Application: psql - unix(590163@a2tech):8963 - Total duration: 247ms - Times executed: 1 ]
[ Application: psql - unix(588248@a2tech):8963 - Total duration: 247ms - Times executed: 1 ]
[ Application: psql - unix(592693@a2tech):8963 - Total duration: 244ms - Times executed: 1 ]
[ Application: psql - unix(583623@a2tech):8963 - Total duration: 243ms - Times executed: 1 ]
[ Application: psql - unix(593365@a2tech):8963 - Total duration: 239ms - Times executed: 1 ]
[ Application: psql - unix(586511@a2tech):8963 - Total duration: 235ms - Times executed: 1 ]
[ Application: psql - unix(592431@a2tech):8963 - Total duration: 231ms - Times executed: 1 ]
[ Application: psql - unix(582777@a2tech):8963 - Total duration: 226ms - Times executed: 1 ]
[ Application: psql - unix(588505@a2tech):8963 - Total duration: 223ms - Times executed: 1 ]
[ Application: psql - unix(592115@a2tech):8963 - Total duration: 164ms - Times executed: 1 ]
[ Application: psql - unix(591599@a2tech):8963 - Total duration: 163ms - Times executed: 1 ]
[ Application: psql - unix(584247@a2tech):8963 - Total duration: 157ms - Times executed: 1 ]
[ Application: psql - unix(592948@a2tech):8963 - Total duration: 153ms - Times executed: 1 ]
[ Application: psql - unix(593628@a2tech):8963 - Total duration: 153ms - Times executed: 1 ]
[ Application: psql - unix(591267@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
[ Application: psql - unix(587648@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
[ Application: psql - unix(588752@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
[ Application: psql - unix(590418@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'cq.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-05-17 15:20:05 Duration: 3s723ms Database: rio User: intelifix Remote: [local] Application: psql - unix(587397@a2tech):8963
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'cq.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-05-17 13:20:02 Duration: 270ms Database: rio User: intelifix Remote: [local] Application: psql - unix(585686@a2tech):8963
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'cq.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-05-17 17:20:01 Duration: 269ms Database: rio User: intelifix Remote: [local] Application: psql - unix(589062@a2tech):8963
6 14 3s947ms 150ms 486ms 281ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 17 06 1 486ms 486ms 07 5 1s345ms 269ms 08 2 420ms 210ms 09 3 877ms 292ms 10 2 599ms 299ms 13 1 217ms 217ms [ User: intelifix - Total duration: 3s947ms - Times executed: 14 ]
[ Application: psql - unix(580064@a2tech):8963 - Total duration: 486ms - Times executed: 1 ]
[ Application: psql - unix(582451@a2tech):8963 - Total duration: 460ms - Times executed: 1 ]
[ Application: psql - unix(583423@a2tech):8963 - Total duration: 436ms - Times executed: 1 ]
[ Application: psql - unix(580669@a2tech):8963 - Total duration: 340ms - Times executed: 1 ]
[ Application: psql - unix(580218@a2tech):8963 - Total duration: 326ms - Times executed: 1 ]
[ Application: psql - unix(582166@a2tech):8963 - Total duration: 266ms - Times executed: 1 ]
[ Application: psql - unix(581788@a2tech):8963 - Total duration: 236ms - Times executed: 1 ]
[ Application: psql - unix(580808@a2tech):8963 - Total duration: 236ms - Times executed: 1 ]
[ Application: psql - unix(580531@a2tech):8963 - Total duration: 231ms - Times executed: 1 ]
[ Application: psql - unix(585611@a2tech):8963 - Total duration: 217ms - Times executed: 1 ]
[ Application: psql - unix(580932@a2tech):8963 - Total duration: 210ms - Times executed: 1 ]
[ Application: psql - unix(581630@a2tech):8963 - Total duration: 183ms - Times executed: 1 ]
[ Application: psql - unix(583275@a2tech):8963 - Total duration: 163ms - Times executed: 1 ]
[ Application: psql - unix(582306@a2tech):8963 - Total duration: 150ms - Times executed: 1 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-17 06:55:02 Duration: 486ms Database: rio User: intelifix Remote: [local] Application: psql - unix(580064@a2tech):8963
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-17 09:35:02 Duration: 460ms Database: rio User: intelifix Remote: [local] Application: psql - unix(582451@a2tech):8963
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-17 10:45:02 Duration: 436ms Database: rio User: intelifix Remote: [local] Application: psql - unix(583423@a2tech):8963
7 6 1m9s 1s670ms 27s101ms 11s653ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 17 20 3 33s415ms 11s138ms 23 3 36s502ms 12s167ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-17 23:16:21 Duration: 27s101ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-17 20:04:57 Duration: 24s911ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-17 23:32:36 Duration: 7s602ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 6 58s2ms 1s218ms 23s198ms 9s667ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 17 20 3 27s626ms 9s208ms 23 3 30s376ms 10s125ms [ User: intelifix - Total duration: 58s2ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s2ms - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-17 23:16:46 Duration: 23s198ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-17 20:05:20 Duration: 21s167ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-17 23:32:42 Duration: 5s824ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 6 57s659ms 2s266ms 23s240ms 9s609ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 17 20 3 27s333ms 9s111ms 23 3 30s325ms 10s108ms [ User: intelifix - Total duration: 57s659ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s659ms - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-17 23:30:40 Duration: 23s240ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-17 20:06:54 Duration: 20s991ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-17 23:39:07 Duration: 4s604ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 6 47s629ms 1s144ms 16s838ms 7s938ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 17 20 3 22s791ms 7s597ms 23 3 24s838ms 8s279ms [ User: intelifix - Total duration: 47s629ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 47s629ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 23:14:10 Duration: 16s838ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 20:02:57 Duration: 15s563ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 23:32:14 Duration: 6s760ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 47s550ms 1s266ms 16s378ms 7s925ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 17 20 3 22s815ms 7s605ms 23 3 24s735ms 8s245ms [ User: intelifix - Total duration: 47s550ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 47s550ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 23:13:41 Duration: 16s378ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 20:02:30 Duration: 15s140ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 23:32:06 Duration: 7s6ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 6 42s389ms 883ms 17s979ms 7s64ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 17 20 3 20s22ms 6s674ms 23 3 22s367ms 7s455ms [ User: intelifix - Total duration: 42s389ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 42s389ms - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-17 23:14:53 Duration: 17s979ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-17 20:03:36 Duration: 16s95ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-17 23:32:25 Duration: 3s413ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 35s535ms 929ms 12s208ms 5s922ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 17 20 3 16s769ms 5s589ms 23 3 18s765ms 6s255ms [ User: intelifix - Total duration: 35s535ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s535ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-17 23:14:22 Duration: 12s208ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-17 20:03:08 Duration: 10s940ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-17 23:32:20 Duration: 5s537ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 27s251ms 514ms 11s828ms 4s541ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 17 20 3 13s264ms 4s421ms 23 3 13s987ms 4s662ms [ User: intelifix - Total duration: 27s251ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s251ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-17 23:13:53 Duration: 11s828ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-17 20:02:42 Duration: 11s280ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-17 23:32:07 Duration: 1s596ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 19s829ms 454ms 9s297ms 3s304ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 17 20 3 9s526ms 3s175ms 23 3 10s303ms 3s434ms [ User: intelifix - Total duration: 19s829ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 19s829ms - Times executed: 6 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-05-17 23:14:35 Duration: 9s297ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-05-17 20:03:20 Duration: 8s602ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-05-17 23:32:22 Duration: 518ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 18s879ms 512ms 7s699ms 3s146ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 17 20 3 9s100ms 3s33ms 23 3 9s778ms 3s259ms [ User: intelifix - Total duration: 18s879ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 18s879ms - Times executed: 6 ]
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-05-17 23:13:23 Duration: 7s699ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-05-17 20:02:13 Duration: 7s198ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-05-17 23:31:58 Duration: 1s531ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 6 18s369ms 1s783ms 4s472ms 3s61ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 17 00 3 12s459ms 4s153ms 06 3 5s909ms 1s969ms [ User: intelifix - Total duration: 18s369ms - Times executed: 6 ]
[ Application: psql - unix(574340@a2tech):8963 - Total duration: 4s472ms - Times executed: 1 ]
[ Application: psql - unix(574372@a2tech):8963 - Total duration: 4s322ms - Times executed: 1 ]
[ Application: psql - unix(574371@a2tech):8963 - Total duration: 3s664ms - Times executed: 1 ]
[ Application: psql - unix(579421@a2tech):8963 - Total duration: 2s159ms - Times executed: 1 ]
[ Application: psql - unix(579453@a2tech):8963 - Total duration: 1s967ms - Times executed: 1 ]
[ Application: psql - unix(579442@a2tech):8963 - Total duration: 1s783ms - Times executed: 1 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-17 00:05:07 Duration: 4s472ms Database: rio User: intelifix Remote: [local] Application: psql - unix(574340@a2tech):8963
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-17 00:05:15 Duration: 4s322ms Database: contagem User: intelifix Remote: [local] Application: psql - unix(574372@a2tech):8963
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-17 00:05:10 Duration: 3s664ms Database: brasilia User: intelifix Remote: [local] Application: psql - unix(574371@a2tech):8963
18 6 17s770ms 1s548ms 3s837ms 2s961ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 17 20 3 8s566ms 2s855ms 23 3 9s204ms 3s68ms [ User: intelifix - Total duration: 17s770ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 17s770ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-17 23:29:17 Duration: 3s837ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-17 20:05:35 Duration: 3s684ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-17 23:38:59 Duration: 3s673ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 12s243ms 1s940ms 2s162ms 2s40ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 17 20 3 5s829ms 1s943ms 23 3 6s413ms 2s137ms [ User: intelifix - Total duration: 12s243ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 12s243ms - Times executed: 6 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-17 23:31:56 Duration: 2s162ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-17 23:40:05 Duration: 2s127ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-17 23:13:14 Duration: 2s124ms Database: rio User: intelifix Remote: [local] Application: pg_dump
20 6 8s974ms 242ms 3s82ms 1s495ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 17 20 3 4s301ms 1s433ms 23 3 4s672ms 1s557ms [ User: intelifix - Total duration: 8s974ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 8s974ms - Times executed: 6 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-17 23:14:25 Duration: 3s82ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-17 20:03:11 Duration: 2s840ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-17 23:32:21 Duration: 1s327ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1m 1m55s 1m25s 3 4m15s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 17 05 3 4m15s 1m25s [ User: intelifix - Total duration: 4m15s - Times executed: 3 ]
[ Application: psql - unix(578485@a2tech):8963 - Total duration: 1m55s - Times executed: 1 ]
[ Application: psql - unix(578514@a2tech):8963 - Total duration: 1m19s - Times executed: 1 ]
[ Application: psql - unix(578528@a2tech):8963 - Total duration: 1m - Times executed: 1 ]
-
analyze verbose;
Date: 2026-05-17 05:01:57 Duration: 1m55s Database: rio User: intelifix Remote: [local] Application: psql - unix(578485@a2tech):8963
-
analyze verbose;
Date: 2026-05-17 05:03:17 Duration: 1m19s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(578514@a2tech):8963
-
analyze verbose;
Date: 2026-05-17 05:04:17 Duration: 1m Database: contagem User: intelifix Remote: [local] Application: psql - unix(578528@a2tech):8963
2 547ms 3m32s 1m9s 48 55m53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 17 07 3 3m43s 1m14s 08 3 3m27s 1m9s 09 3 3m28s 1m9s 10 3 3m27s 1m9s 11 3 3m30s 1m10s 12 3 3m27s 1m9s 13 3 3m27s 1m9s 14 3 3m27s 1m9s 15 3 3m24s 1m8s 16 3 3m27s 1m9s 17 3 3m28s 1m9s 18 3 3m26s 1m8s 19 3 3m27s 1m9s 20 3 3m39s 1m13s 21 3 3m28s 1m9s 22 3 3m29s 1m9s [ User: intelifix - Total duration: 55m53s - Times executed: 48 ]
[ Application: psql - unix(580215@a2tech):8963 - Total duration: 3m32s - Times executed: 1 ]
[ Application: psql - unix(591364@a2tech):8963 - Total duration: 3m29s - Times executed: 1 ]
[ Application: psql - unix(583704@a2tech):8963 - Total duration: 3m21s - Times executed: 1 ]
[ Application: psql - unix(593046@a2tech):8963 - Total duration: 3m20s - Times executed: 1 ]
[ Application: psql - unix(582002@a2tech):8963 - Total duration: 3m19s - Times executed: 1 ]
[ Application: psql - unix(588833@a2tech):8963 - Total duration: 3m19s - Times executed: 1 ]
[ Application: psql - unix(592197@a2tech):8963 - Total duration: 3m19s - Times executed: 1 ]
[ Application: psql - unix(584611@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(581089@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(582854@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(587984@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(590494@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(586279@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(585452@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(589668@a2tech):8963 - Total duration: 3m17s - Times executed: 1 ]
[ Application: psql - unix(587157@a2tech):8963 - Total duration: 3m15s - Times executed: 1 ]
[ Application: psql - unix(580322@a2tech):8963 - Total duration: 10s242ms - Times executed: 1 ]
[ Application: psql - unix(591441@a2tech):8963 - Total duration: 9s377ms - Times executed: 1 ]
[ Application: psql - unix(582069@a2tech):8963 - Total duration: 8s665ms - Times executed: 1 ]
[ Application: psql - unix(586349@a2tech):8963 - Total duration: 8s637ms - Times executed: 1 ]
[ Application: psql - unix(582920@a2tech):8963 - Total duration: 8s632ms - Times executed: 1 ]
[ Application: psql - unix(588056@a2tech):8963 - Total duration: 8s585ms - Times executed: 1 ]
[ Application: psql - unix(583772@a2tech):8963 - Total duration: 8s573ms - Times executed: 1 ]
[ Application: psql - unix(581156@a2tech):8963 - Total duration: 8s566ms - Times executed: 1 ]
[ Application: psql - unix(590567@a2tech):8963 - Total duration: 8s550ms - Times executed: 1 ]
[ Application: psql - unix(589738@a2tech):8963 - Total duration: 8s540ms - Times executed: 1 ]
[ Application: psql - unix(592266@a2tech):8963 - Total duration: 8s536ms - Times executed: 1 ]
[ Application: psql - unix(587223@a2tech):8963 - Total duration: 8s518ms - Times executed: 1 ]
[ Application: psql - unix(585528@a2tech):8963 - Total duration: 8s505ms - Times executed: 1 ]
[ Application: psql - unix(593208@a2tech):8963 - Total duration: 8s486ms - Times executed: 1 ]
[ Application: psql - unix(588901@a2tech):8963 - Total duration: 8s427ms - Times executed: 1 ]
[ Application: psql - unix(584683@a2tech):8963 - Total duration: 8s317ms - Times executed: 1 ]
[ Application: psql - unix(591472@a2tech):8963 - Total duration: 765ms - Times executed: 1 ]
[ Application: psql - unix(580351@a2tech):8963 - Total duration: 756ms - Times executed: 1 ]
[ Application: psql - unix(589768@a2tech):8963 - Total duration: 599ms - Times executed: 1 ]
[ Application: psql - unix(585560@a2tech):8963 - Total duration: 593ms - Times executed: 1 ]
[ Application: psql - unix(582103@a2tech):8963 - Total duration: 592ms - Times executed: 1 ]
[ Application: psql - unix(584722@a2tech):8963 - Total duration: 582ms - Times executed: 1 ]
[ Application: psql - unix(588933@a2tech):8963 - Total duration: 573ms - Times executed: 1 ]
[ Application: psql - unix(593238@a2tech):8963 - Total duration: 571ms - Times executed: 1 ]
[ Application: psql - unix(582953@a2tech):8963 - Total duration: 568ms - Times executed: 1 ]
[ Application: psql - unix(592297@a2tech):8963 - Total duration: 567ms - Times executed: 1 ]
[ Application: psql - unix(587255@a2tech):8963 - Total duration: 567ms - Times executed: 1 ]
[ Application: psql - unix(583802@a2tech):8963 - Total duration: 564ms - Times executed: 1 ]
[ Application: psql - unix(588088@a2tech):8963 - Total duration: 559ms - Times executed: 1 ]
[ Application: psql - unix(586382@a2tech):8963 - Total duration: 554ms - Times executed: 1 ]
[ Application: psql - unix(590595@a2tech):8963 - Total duration: 553ms - Times executed: 1 ]
[ Application: psql - unix(581187@a2tech):8963 - Total duration: 547ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-17 07:08:34 Duration: 3m32s Database: rio User: intelifix Remote: [local] Application: psql - unix(580215@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-17 20:08:32 Duration: 3m29s Database: rio User: intelifix Remote: [local] Application: psql - unix(591364@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-17 11:08:23 Duration: 3m21s Database: rio User: intelifix Remote: [local] Application: psql - unix(583704@a2tech):8963
3 337ms 2m14s 50s664ms 48 40m31s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 17 07 3 2m37s 52s485ms 08 3 2m30s 50s213ms 09 3 2m31s 50s587ms 10 3 2m32s 50s701ms 11 3 2m31s 50s511ms 12 3 2m30s 50s275ms 13 3 2m31s 50s399ms 14 3 2m31s 50s489ms 15 3 2m30s 50s205ms 16 3 2m31s 50s422ms 17 3 2m31s 50s441ms 18 3 2m30s 50s260ms 19 3 2m31s 50s461ms 20 3 2m37s 52s377ms 21 3 2m31s 50s374ms 22 3 2m31s 50s427ms [ User: intelifix - Total duration: 40m31s - Times executed: 48 ]
[ Application: psql - unix(580326@a2tech):8963 - Total duration: 2m14s - Times executed: 1 ]
[ Application: psql - unix(591446@a2tech):8963 - Total duration: 2m14s - Times executed: 1 ]
[ Application: psql - unix(582075@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(586354@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(588906@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(588060@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(585533@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(583777@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(590571@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(582925@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(589742@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(592269@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(593212@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(587229@a2tech):8963 - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - unix(581161@a2tech):8963 - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - unix(584688@a2tech):8963 - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - unix(580314@a2tech):8963 - Total duration: 22s523ms - Times executed: 1 ]
[ Application: psql - unix(591434@a2tech):8963 - Total duration: 22s441ms - Times executed: 1 ]
[ Application: psql - unix(582914@a2tech):8963 - Total duration: 19s256ms - Times executed: 1 ]
[ Application: psql - unix(593199@a2tech):8963 - Total duration: 18s807ms - Times executed: 1 ]
[ Application: psql - unix(582063@a2tech):8963 - Total duration: 18s692ms - Times executed: 1 ]
[ Application: psql - unix(583766@a2tech):8963 - Total duration: 18s633ms - Times executed: 1 ]
[ Application: psql - unix(584677@a2tech):8963 - Total duration: 18s613ms - Times executed: 1 ]
[ Application: psql - unix(590558@a2tech):8963 - Total duration: 18s519ms - Times executed: 1 ]
[ Application: psql - unix(592258@a2tech):8963 - Total duration: 18s491ms - Times executed: 1 ]
[ Application: psql - unix(581149@a2tech):8963 - Total duration: 18s416ms - Times executed: 1 ]
[ Application: psql - unix(586341@a2tech):8963 - Total duration: 18s398ms - Times executed: 1 ]
[ Application: psql - unix(588048@a2tech):8963 - Total duration: 18s342ms - Times executed: 1 ]
[ Application: psql - unix(588893@a2tech):8963 - Total duration: 18s289ms - Times executed: 1 ]
[ Application: psql - unix(585520@a2tech):8963 - Total duration: 18s274ms - Times executed: 1 ]
[ Application: psql - unix(587216@a2tech):8963 - Total duration: 18s266ms - Times executed: 1 ]
[ Application: psql - unix(589730@a2tech):8963 - Total duration: 18s143ms - Times executed: 1 ]
[ Application: psql - unix(591476@a2tech):8963 - Total duration: 499ms - Times executed: 1 ]
[ Application: psql - unix(580356@a2tech):8963 - Total duration: 497ms - Times executed: 1 ]
[ Application: psql - unix(585565@a2tech):8963 - Total duration: 376ms - Times executed: 1 ]
[ Application: psql - unix(592301@a2tech):8963 - Total duration: 370ms - Times executed: 1 ]
[ Application: psql - unix(588092@a2tech):8963 - Total duration: 369ms - Times executed: 1 ]
[ Application: psql - unix(586386@a2tech):8963 - Total duration: 368ms - Times executed: 1 ]
[ Application: psql - unix(590598@a2tech):8963 - Total duration: 366ms - Times executed: 1 ]
[ Application: psql - unix(588939@a2tech):8963 - Total duration: 363ms - Times executed: 1 ]
[ Application: psql - unix(583806@a2tech):8963 - Total duration: 360ms - Times executed: 1 ]
[ Application: psql - unix(582957@a2tech):8963 - Total duration: 359ms - Times executed: 1 ]
[ Application: psql - unix(593243@a2tech):8963 - Total duration: 358ms - Times executed: 1 ]
[ Application: psql - unix(582107@a2tech):8963 - Total duration: 358ms - Times executed: 1 ]
[ Application: psql - unix(584726@a2tech):8963 - Total duration: 354ms - Times executed: 1 ]
[ Application: psql - unix(587260@a2tech):8963 - Total duration: 352ms - Times executed: 1 ]
[ Application: psql - unix(581190@a2tech):8963 - Total duration: 338ms - Times executed: 1 ]
[ Application: psql - unix(589771@a2tech):8963 - Total duration: 337ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-17 07:11:23 Duration: 2m14s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(580326@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-17 20:11:19 Duration: 2m14s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(591446@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-17 09:11:03 Duration: 2m12s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(582075@a2tech):8963
4 46s135ms 46s135ms 46s135ms 1 46s135ms refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 17 05 1 46s135ms 46s135ms [ User: intelifix - Total duration: 46s135ms - Times executed: 1 ]
[ Application: psql - unix(578932@a2tech):8963 - Total duration: 46s135ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-17 05:31:09 Duration: 46s135ms Database: rio User: intelifix Remote: [local] Application: psql - unix(578932@a2tech):8963
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-17 05:31:04 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(578932@a2tech):8963
5 14s99ms 1m1s 32s62ms 3 1m36s copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 17 23 3 1m36s 32s62ms [ User: intelifix - Total duration: 1m36s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m36s - Times executed: 3 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:11:49 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:31:28 Duration: 20s93ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:39:42 Duration: 14s99ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 12s728ms 50s655ms 26s584ms 3 1m19s copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 17 23 3 1m19s 26s584ms [ User: intelifix - Total duration: 1m19s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m19s - Times executed: 3 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:12:40 Duration: 50s655ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:31:44 Duration: 16s369ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:39:55 Duration: 12s728ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 2s110ms 50s650ms 25s996ms 4 1m43s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 17 20 2 51s37ms 25s518ms 23 2 52s946ms 26s473ms [ User: intelifix - Total duration: 1m43s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m43s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-17 23:30:17 Duration: 50s650ms 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-05-17 20:06:33 Duration: 48s927ms 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-05-17 23:39:02 Duration: 2s295ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 11s209ms 44s304ms 24s515ms 3 1m13s copy auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 17 23 3 1m13s 24s515ms [ User: intelifix - Total duration: 1m13s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 3 ]
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:10:47 Duration: 44s304ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:31:08 Duration: 18s33ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:39:28 Duration: 11s209ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 273ms 43s271ms 21s20ms 4 1m24s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 17 20 2 40s532ms 20s266ms 23 2 43s548ms 21s774ms [ User: intelifix - Total duration: 1m24s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-17 23:15:53 Duration: 43s271ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-17 20:04:31 Duration: 40s258ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-17 23:32:28 Duration: 277ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 7s591ms 30s467ms 15s653ms 3 46s960ms copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 17 23 3 46s960ms 15s653ms [ User: intelifix - Total duration: 46s960ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 46s960ms - Times executed: 3 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:13:10 Duration: 30s467ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:31:53 Duration: 8s901ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-17 23:40:02 Duration: 7s591ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 1s670ms 27s101ms 11s653ms 6 1m9s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 17 20 3 33s415ms 11s138ms 23 3 36s502ms 12s167ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-17 23:16:21 Duration: 27s101ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-17 20:04:57 Duration: 24s911ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-17 23:32:36 Duration: 7s602ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1s218ms 23s198ms 9s667ms 6 58s2ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 17 20 3 27s626ms 9s208ms 23 3 30s376ms 10s125ms [ User: intelifix - Total duration: 58s2ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s2ms - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-17 23:16:46 Duration: 23s198ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-17 20:05:20 Duration: 21s167ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-17 23:32:42 Duration: 5s824ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s266ms 23s240ms 9s609ms 6 57s659ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 17 20 3 27s333ms 9s111ms 23 3 30s325ms 10s108ms [ User: intelifix - Total duration: 57s659ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s659ms - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-17 23:30:40 Duration: 23s240ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-17 20:06:54 Duration: 20s991ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-17 23:39:07 Duration: 4s604ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 2s533ms 16s805ms 9s356ms 4 37s424ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 17 20 2 17s766ms 8s883ms 23 2 19s658ms 9s829ms [ User: intelifix - Total duration: 37s424ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 37s424ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-17 23:15:10 Duration: 16s805ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-17 20:03:51 Duration: 15s233ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-17 23:32:28 Duration: 2s852ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 174ms 22s787ms 9s165ms 3 27s496ms copy public.posicao_oficina_21 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 17 23 3 27s496ms 9s165ms [ User: intelifix - Total duration: 27s496ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 27s496ms - Times executed: 3 ]
-
COPY public.posicao_oficina_21 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) TO stdout;
Date: 2026-05-17 23:27:45 Duration: 22s787ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.posicao_oficina_21 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) TO stdout;
Date: 2026-05-17 23:38:10 Duration: 4s534ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.posicao_oficina_21 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) TO stdout;
Date: 2026-05-17 23:40:32 Duration: 174ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 1s144ms 16s838ms 7s938ms 6 47s629ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 17 20 3 22s791ms 7s597ms 23 3 24s838ms 8s279ms [ User: intelifix - Total duration: 47s629ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 47s629ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 23:14:10 Duration: 16s838ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 20:02:57 Duration: 15s563ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 23:32:14 Duration: 6s760ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1s266ms 16s378ms 7s925ms 6 47s550ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 17 20 3 22s815ms 7s605ms 23 3 24s735ms 8s245ms [ User: intelifix - Total duration: 47s550ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 47s550ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 23:13:41 Duration: 16s378ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 20:02:30 Duration: 15s140ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 23:32:06 Duration: 7s6ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 883ms 17s979ms 7s64ms 6 42s389ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 17 20 3 20s22ms 6s674ms 23 3 22s367ms 7s455ms [ User: intelifix - Total duration: 42s389ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 42s389ms - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-17 23:14:53 Duration: 17s979ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-17 20:03:36 Duration: 16s95ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-17 23:32:25 Duration: 3s413ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 929ms 12s208ms 5s922ms 6 35s535ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 17 20 3 16s769ms 5s589ms 23 3 18s765ms 6s255ms [ User: intelifix - Total duration: 35s535ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s535ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-17 23:14:22 Duration: 12s208ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-17 20:03:08 Duration: 10s940ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-17 23:32:20 Duration: 5s537ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 514ms 11s828ms 4s541ms 6 27s251ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 17 20 3 13s264ms 4s421ms 23 3 13s987ms 4s662ms [ User: intelifix - Total duration: 27s251ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s251ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-17 23:13:53 Duration: 11s828ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-17 20:02:42 Duration: 11s280ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-17 23:32:07 Duration: 1s596ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 7 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration May 17 08 1 0ms 0ms 10 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 18 1 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 9s909ms - Times executed: 7 ]
[ Application: psql - unix(587223@a2tech):8963 - Total duration: 8s518ms - Times executed: 1 ]
[ Application: psql - unix(583360@a2tech):8963 - Total duration: 273ms - Times executed: 1 ]
[ Application: psql - unix(581010@a2tech):8963 - Total duration: 258ms - Times executed: 1 ]
[ Application: psql - unix(590165@a2tech):8963 - Total duration: 227ms - Times executed: 1 ]
[ Application: psql - unix(585377@a2tech):8963 - Total duration: 222ms - Times executed: 1 ]
[ Application: psql - unix(592117@a2tech):8963 - Total duration: 205ms - Times executed: 1 ]
[ Application: psql - unix(586200@a2tech):8963 - Total duration: 204ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql - unix(592117@a2tech):8963
-
Events
Log levels
Key values
- 7,783 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 31 FATAL entries
- 2544 ERROR entries
- 0 WARNING entries
- 12 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,540 Max number of times the same event was reported
- 2,587 Total events found
Rank Times reported Error 1 2,540 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count May 17 00 106 01 106 02 106 03 102 04 108 05 108 06 105 07 108 08 107 09 105 10 107 11 105 12 107 13 109 14 109 15 106 16 105 17 106 18 109 19 106 20 106 21 108 22 106 23 90 - ERROR: prepared statement "_PLAN000000002A3EC710" does not exist
- ERROR: prepared statement "_PLAN0000000059F37F10" does not exist
- ERROR: prepared statement "_PLAN000000002A582500" does not exist
Statement: DEALLOCATE "_PLAN000000002A3EC710"
Date: 2026-05-17 00:00:08 Database: contagem Application: app - 186.249.229.55:65307 User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000059F37F10"
Date: 2026-05-17 00:00:49 Database: brasilia Application: app - 177.99.204.34:49474 User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002A582500"
Date: 2026-05-17 00:01:11 Database: contagem Application: app - 186.249.229.55:65323 User: etiquetas Remote: [local]
2 17 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count May 17 00 1 02 1 05 5 06 2 07 5 09 1 12 1 15 1 3 11 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count May 17 11 4 14 7 4 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count May 17 03 9 5 5 FATAL: unsupported frontend protocol 27265.28208: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #5
Day Hour Count May 17 11 2 14 3 6 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count May 17 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-05-17 05:31:09 Database: brasilia Application: psql - unix(578940@a2tech):8963 User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-17 05:31:09 Database: brasilia Application: psql - unix(578941@a2tech):8963 User: intelifix Remote: [local]
7 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #7
Day Hour Count May 17 03 1