-
Global information
- Generated on Sun May 3 23:50:05 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-Wed.log
- Parsed 8,892 log entries in 4s
- Log start from 2026-05-02 00:00:45 to 2026-05-02 23:59:44
-
Overview
Global Stats
- 126 Number of unique normalized queries
- 715 Number of queries
- 2h15m10s Total query duration
- 2026-05-02 00:05:03 First query
- 2026-05-02 23:39:14 Last query
- 6 queries/s at 2026-05-02 23:38:56 Query peak
- 2h15m10s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h15m10s Execute total duration
- 1,175 Number of events
- 7 Number of unique normalized events
- 1,152 Max number of times the same event was reported
- 0 Number of cancellation
- 9 Total number of automatic vacuums
- 3 Total number of automatic analyzes
- 12 Number temporary file
- 221.07 MiB Max size of temporary file
- 94.71 MiB Average size of temporary file
- 382 Total number of sessions
- 7 sessions at 2026-05-02 00:05:02 Session peak
- 7d6h21m27s Total duration of sessions
- 27m23s Average duration of sessions
- 1 Average queries per session
- 21s231ms Average queries duration per session
- 27m1s Average idle time per session
- 391 Total number of connections
- 3 connections/s at 2026-05-02 06:02:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-05-02 23:38:56 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-05-02 21:10:48 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 6 queries/s Query Peak
- 2026-05-02 23:38:56 Date
Queries duration
Key values
- 2h15m10s 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 02 00 10 0ms 4s533ms 1s936ms 1s44ms 1s63ms 14s20ms 01 7 0ms 1s162ms 945ms 1s39ms 1s93ms 1s215ms 02 8 0ms 1s83ms 833ms 1s38ms 1s81ms 1s238ms 03 9 0ms 1s179ms 786ms 1s39ms 1s264ms 1s336ms 04 7 0ms 1s235ms 968ms 1s58ms 1s94ms 1s386ms 05 11 0ms 1m53s 29s378ms 1s203ms 57s318ms 1m53s 06 11 0ms 2s82ms 1s144ms 1s16ms 1s130ms 7s99ms 07 12 0ms 3m17s 30s652ms 1s69ms 1s193ms 3m47s 08 20 0ms 3m6s 17s591ms 1s108ms 1s468ms 3m32s 09 18 0ms 3m6s 19s538ms 1s50ms 1s221ms 3m32s 10 16 0ms 3m6s 21s902ms 1s42ms 1s201ms 3m32s 11 16 0ms 3m5s 21s826ms 1s98ms 1s261ms 3m31s 12 16 0ms 3m5s 21s808ms 1s103ms 1s204ms 3m30s 13 16 0ms 3m7s 21s958ms 1s59ms 1s294ms 3m32s 14 16 0ms 3m4s 21s791ms 1s59ms 1s167ms 3m30s 15 17 0ms 3m5s 20s584ms 1s37ms 1s387ms 3m31s 16 17 0ms 3m3s 20s424ms 1s45ms 1s301ms 3m29s 17 15 0ms 3m4s 23s247ms 1s63ms 1s209ms 3m30s 18 18 0ms 3m5s 19s481ms 1s165ms 1s226ms 3m32s 19 17 0ms 3m6s 20s605ms 1s71ms 1s133ms 3m32s 20 91 0ms 3m13s 8s1ms 54s714ms 1m15s 3m53s 21 18 0ms 3m7s 19s552ms 1s75ms 1s266ms 3m33s 22 18 0ms 3m6s 19s565ms 1s119ms 1s342ms 3m32s 23 311 0ms 1m2s 5s559ms 1m2s 1m6s 1m13s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 02 00 0 0 0ms 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 0 0 0ms 0ms 0ms 0ms 07 6 0 1m 0ms 0ms 2m13s 08 6 0 57s174ms 0ms 0ms 2m10s 09 6 0 57s341ms 0ms 0ms 2m11s 10 6 0 57s170ms 0ms 0ms 2m10s 11 6 0 56s961ms 0ms 0ms 2m10s 12 6 0 56s922ms 0ms 0ms 2m10s 13 6 0 57s297ms 0ms 0ms 2m10s 14 6 0 56s873ms 0ms 0ms 2m10s 15 6 0 57s89ms 0ms 0ms 2m11s 16 6 0 56s617ms 0ms 0ms 2m10s 17 6 0 56s930ms 0ms 0ms 2m10s 18 6 0 57s117ms 0ms 0ms 2m10s 19 6 0 57s130ms 0ms 0ms 2m10s 20 6 73 9s111ms 0ms 54s714ms 2m12s 21 6 0 57s371ms 0ms 0ms 2m11s 22 6 0 57s373ms 0ms 0ms 2m11s 23 0 311 5s559ms 1m2s 1m2s 1m13s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 02 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 02 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 02 00 23 0.01/s 01 14 0.00/s 02 14 0.00/s 03 25 0.01/s 04 13 0.00/s 05 16 0.00/s 06 19 0.01/s 07 15 0.00/s 08 14 0.00/s 09 16 0.00/s 10 18 0.01/s 11 12 0.00/s 12 14 0.00/s 13 16 0.00/s 14 16 0.00/s 15 16 0.00/s 16 18 0.01/s 17 14 0.00/s 18 18 0.01/s 19 17 0.00/s 20 18 0.01/s 21 15 0.00/s 22 16 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time May 02 00 13 9m13s 9m11s 01 18 36m12s 36m12s 02 13 32m22s 32m21s 03 25 13m26s 13m26s 04 13 31m57s 31m57s 05 15 28m17s 27m56s 06 15 26m46s 26m45s 07 17 37m35s 37m14s 08 15 31m34s 31m11s 09 16 26m36s 26m14s 10 15 28m37s 28m14s 11 12 34m38s 34m9s 12 14 29m48s 29m23s 13 15 28m15s 27m52s 14 18 26m46s 26m26s 15 15 23m44s 23m21s 16 16 22m12s 21m51s 17 15 31m51s 31m28s 18 17 24m52s 24m31s 19 17 31m25s 31m4s 20 17 25m26s 24m43s 21 16 29m39s 29m17s 22 15 28m1s 27m37s 23 20 25m31s 24m5s -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2026-05-02 06:02:01 Date
Connections per database
Key values
- brasilia Main Database
- 391 connections Total
Connections per user
Key values
- etiquetas Main User
- 391 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-05-02 00:05:02 Date
Histogram of session times
Key values
- 192 60000-600000ms duration
Sessions per database
Key values
- brasilia Main Database
- 382 sessions Total
Sessions per user
Key values
- etiquetas Main User
- 382 sessions Total
Sessions per host
Key values
- [local] Main Host
- 382 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 382 sessions Total
Application Count Total Duration Average Duration [unknown] 115 4d9h34m18s 55m4s app - 177.99.204.34:49160 1 7m22s 7m22s app - 177.99.204.34:49294 1 4m19s 4m19s app - 177.99.204.34:49303 1 4m13s 4m13s app - 177.99.204.34:49307 1 1h 1h app - 177.99.204.34:49669 1 7m22s 7m22s app - 177.99.204.34:49678 1 9m30s 9m30s app - 177.99.204.34:49714 1 4m9s 4m9s app - 177.99.204.34:49717 1 8m28s 8m28s app - 177.99.204.34:49745 1 4m10s 4m10s app - 177.99.204.34:49837 1 5m14s 5m14s app - 177.99.204.34:49870 1 6m16s 6m16s app - 177.99.204.34:49877 2 1h3m7s 31m33s app - 177.99.204.34:49882 1 7m21s 7m21s app - 177.99.204.34:49896 1 2m10s 2m10s app - 177.99.204.34:49932 1 11m37s 11m37s app - 177.99.204.34:50037 1 9m26s 9m26s app - 177.99.204.34:50263 1 11m35s 11m35s app - 177.99.204.34:50381 1 5m14s 5m14s app - 177.99.204.34:50406 1 4m5s 4m5s app - 177.99.204.34:50415 1 4m12s 4m12s app - 177.99.204.34:50512 1 3m7s 3m7s app - 177.99.204.34:50750 1 2m4s 2m4s app - 177.99.204.34:50988 1 2m4s 2m4s app - 177.99.204.34:51113 1 2m4s 2m4s app - 177.99.204.34:51145 1 15m50s 15m50s app - 177.99.204.34:51155 1 10m29s 10m29s app - 177.99.204.34:51174 1 4m10s 4m10s app - 177.99.204.34:51353 1 20m14s 20m14s app - 177.99.204.34:51466 1 1h 1h app - 177.99.204.34:51472 1 5m15s 5m15s app - 177.99.204.34:51494 1 8m25s 8m25s app - 177.99.204.34:51559 1 5m15s 5m15s app - 177.99.204.34:51706 1 2m4s 2m4s app - 177.99.204.34:51816 1 4m12s 4m12s app - 177.99.204.34:51845 1 2m4s 2m4s app - 177.99.204.34:51913 1 6m19s 6m19s app - 177.99.204.34:51968 1 4m10s 4m10s app - 177.99.204.34:52222 1 4m12s 4m12s app - 177.99.204.34:52434 1 2m4s 2m4s app - 177.99.204.34:52465 1 7m24s 7m24s app - 177.99.204.34:52536 1 1m3s 1m3s app - 177.99.204.34:52558 2 1h1m 30m30s app - 177.99.204.34:52629 1 3m8s 3m8s app - 177.99.204.34:52777 1 6m18s 6m18s app - 177.99.204.34:52872 1 9m26s 9m26s app - 177.99.204.34:52881 1 2m4s 2m4s app - 177.99.204.34:53111 1 6m16s 6m16s app - 177.99.204.34:53120 2 1h1m23s 30m41s app - 177.99.204.34:53311 1 6m18s 6m18s app - 177.99.204.34:53341 1 1h 1h app - 177.99.204.34:53416 1 4m10s 4m10s app - 177.99.204.34:53458 1 16m58s 16m58s app - 177.99.204.34:53486 1 4m12s 4m12s app - 177.99.204.34:53518 1 11m45s 11m45s app - 177.99.204.34:53594 1 5m14s 5m14s app - 177.99.204.34:53699 1 4m11s 4m11s app - 177.99.204.34:53755 1 9m29s 9m29s app - 177.99.204.34:53769 1 8m24s 8m24s app - 177.99.204.34:53823 1 17m49s 17m49s app - 177.99.204.34:53938 1 5m15s 5m15s app - 177.99.204.34:53989 1 4m9s 4m9s app - 177.99.204.34:54088 1 8m37s 8m37s app - 177.99.204.34:54206 1 14m52s 14m52s app - 177.99.204.34:54247 1 8m26s 8m26s app - 177.99.204.34:54309 1 4m10s 4m10s app - 177.99.204.34:54318 1 3m7s 3m7s app - 177.99.204.34:54366 1 13m46s 13m46s app - 177.99.204.34:54439 1 8m27s 8m27s app - 177.99.204.34:54526 1 13m40s 13m40s app - 177.99.204.34:54527 1 12m34s 12m34s app - 177.99.204.34:54544 1 8m24s 8m24s app - 177.99.204.34:54570 1 5m15s 5m15s app - 177.99.204.34:54611 1 4m10s 4m10s app - 177.99.204.34:54704 1 13m46s 13m46s app - 177.99.204.34:54758 1 5m14s 5m14s app - 177.99.204.34:54761 1 7m23s 7m23s app - 177.99.204.34:54803 1 4m11s 4m11s app - 177.99.204.34:54925 1 6m17s 6m17s app - 177.99.204.34:55021 1 2m4s 2m4s app - 177.99.204.34:55075 1 4m12s 4m12s app - 177.99.204.34:55116 1 10m34s 10m34s app - 177.99.204.34:55218 1 6m20s 6m20s app - 177.99.204.34:55252 1 10m29s 10m29s app - 177.99.204.34:55297 1 13m40s 13m40s app - 177.99.204.34:55419 1 2m4s 2m4s app - 177.99.204.34:55432 1 6m16s 6m16s app - 177.99.204.34:55731 1 1h 1h app - 177.99.204.34:55740 1 3m8s 3m8s app - 177.99.204.34:55798 1 8m24s 8m24s app - 177.99.204.34:55818 1 5m14s 5m14s app - 177.99.204.34:55883 1 10m31s 10m31s app - 177.99.204.34:56044 1 5m13s 5m13s app - 177.99.204.34:56071 1 5m14s 5m14s app - 177.99.204.34:56169 1 1h 1h app - 177.99.204.34:56204 1 6m18s 6m18s app - 177.99.204.34:56223 1 5m11s 5m11s app - 177.99.204.34:56441 1 5m9s 5m9s app - 177.99.204.34:56513 1 7m22s 7m22s app - 177.99.204.34:56632 1 7m26s 7m26s app - 177.99.204.34:56667 1 6m18s 6m18s app - 177.99.204.34:56681 1 5m15s 5m15s app - 177.99.204.34:56717 1 6m18s 6m18s app - 177.99.204.34:56823 1 3m7s 3m7s app - 177.99.204.34:56878 1 4m13s 4m13s app - 177.99.204.34:56900 1 4m12s 4m12s app - 177.99.204.34:56922 1 13m47s 13m47s app - 177.99.204.34:57085 1 3m7s 3m7s app - 177.99.204.34:57203 1 8m24s 8m24s app - 177.99.204.34:57206 1 3m8s 3m8s app - 177.99.204.34:57316 1 4m12s 4m12s app - 177.99.204.34:57391 1 5m14s 5m14s app - 177.99.204.34:57627 1 5m14s 5m14s app - 177.99.204.34:57631 1 6m36s 6m36s app - 177.99.204.34:57634 1 9m15s 9m15s app - 177.99.204.34:57758 1 2m4s 2m4s app - 177.99.204.34:57845 1 5m14s 5m14s app - 177.99.204.34:57846 1 2m4s 2m4s app - 177.99.204.34:57905 1 5m15s 5m15s app - 177.99.204.34:57918 1 7m21s 7m21s app - 177.99.204.34:57976 1 8m23s 8m23s app - 177.99.204.34:57984 1 8m24s 8m24s app - 177.99.204.34:58017 1 1h 1h app - 177.99.204.34:58043 1 3m8s 3m8s app - 177.99.204.34:58114 1 4m10s 4m10s app - 177.99.204.34:58115 1 5m14s 5m14s app - 177.99.204.34:58124 1 4m12s 4m12s app - 177.99.204.34:58145 1 10m34s 10m34s app - 177.99.204.34:58290 1 4m10s 4m10s app - 177.99.204.34:58593 1 5m13s 5m13s app - 177.99.204.34:58621 1 4m10s 4m10s app - 177.99.204.34:58833 1 7m20s 7m20s app - 177.99.204.34:58838 1 2m4s 2m4s app - 177.99.204.34:58857 1 5m2s 5m2s app - 177.99.204.34:58877 1 10m32s 10m32s app - 177.99.204.34:59021 1 3m7s 3m7s app - 177.99.204.34:59070 1 6m20s 6m20s app - 177.99.204.34:59105 1 3m7s 3m7s app - 177.99.204.34:59264 2 1h3m5s 31m32s app - 177.99.204.34:59401 1 2m57s 2m57s app - 177.99.204.34:59571 1 1h 1h app - 177.99.204.34:59589 1 9m27s 9m27s app - 177.99.204.34:59714 1 5m15s 5m15s app - 177.99.204.34:59761 1 10m30s 10m30s app - 177.99.204.34:59919 1 1h 1h app - 177.99.204.34:59937 1 2m26s 2m26s app - 177.99.204.34:60026 1 4m10s 4m10s app - 177.99.204.34:60115 1 4m12s 4m12s app - 177.99.204.34:60193 1 9m25s 9m25s app - 177.99.204.34:60223 1 3m7s 3m7s app - 177.99.204.34:60273 1 5m18s 5m18s app - 177.99.204.34:60279 1 20m6s 20m6s app - 177.99.204.34:60301 1 4m11s 4m11s app - 177.99.204.34:60378 1 4m10s 4m10s app - 177.99.204.34:60446 1 9m28s 9m28s app - 177.99.204.34:60455 1 5m15s 5m15s app - 177.99.204.34:60548 1 7m23s 7m23s app - 177.99.204.34:60621 1 8m18s 8m18s app - 177.99.204.34:60646 1 10m31s 10m31s app - 177.99.204.34:60869 1 5m12s 5m12s app - 177.99.204.34:60870 1 4m12s 4m12s app - 177.99.204.34:60872 1 3m8s 3m8s app - 177.99.204.34:60897 1 7m22s 7m22s app - 177.99.204.34:61017 2 26m16s 13m8s app - 177.99.204.34:61032 1 6m20s 6m20s app - 177.99.204.34:61103 1 1h 1h app - 177.99.204.34:61158 1 6m15s 6m15s app - 177.99.204.34:61186 1 1h 1h app - 177.99.204.34:61461 1 2m4s 2m4s app - 177.99.204.34:61528 1 4m10s 4m10s app - 177.99.204.34:61531 1 5m15s 5m15s app - 177.99.204.34:61574 1 20m6s 20m6s app - 177.99.204.34:61667 1 7m20s 7m20s app - 177.99.204.34:61735 1 14m47s 14m47s app - 177.99.204.34:61744 1 3m8s 3m8s app - 177.99.204.34:61758 1 3m7s 3m7s app - 177.99.204.34:61882 1 10m32s 10m32s app - 177.99.204.34:61907 1 1m4s 1m4s app - 177.99.204.34:61975 1 5m13s 5m13s app - 177.99.204.34:61991 2 1h1m3s 30m31s app - 177.99.204.34:62065 1 2m4s 2m4s app - 177.99.204.34:62110 1 3m12s 3m12s app - 177.99.204.34:62124 1 4m10s 4m10s app - 177.99.204.34:62138 1 3m7s 3m7s app - 177.99.204.34:62143 1 12m38s 12m38s app - 177.99.204.34:62165 1 2m4s 2m4s app - 177.99.204.34:62493 1 6m21s 6m21s app - 177.99.204.34:62643 1 9m31s 9m31s app - 177.99.204.34:62650 1 2m21s 2m21s app - 177.99.204.34:62672 1 5m14s 5m14s app - 177.99.204.34:62766 2 6m15s 3m7s app - 177.99.204.34:62768 1 3m7s 3m7s app - 177.99.204.34:62786 1 7m24s 7m24s app - 177.99.204.34:62891 1 7m21s 7m21s app - 177.99.204.34:62950 1 2m4s 2m4s app - 177.99.204.34:62979 1 2m4s 2m4s app - 177.99.204.34:63083 1 1m37s 1m37s app - 177.99.204.34:63148 1 2m4s 2m4s app - 177.99.204.34:63172 1 4m11s 4m11s app - 177.99.204.34:63316 1 2m3s 2m3s app - 177.99.204.34:63328 1 5m13s 5m13s app - 177.99.204.34:63338 1 1h 1h app - 177.99.204.34:63501 1 2m4s 2m4s app - 177.99.204.34:63687 1 12m38s 12m38s app - 177.99.204.34:63733 1 7m23s 7m23s app - 177.99.204.34:63860 1 3m7s 3m7s app - 177.99.204.34:64038 1 3m8s 3m8s app - 177.99.204.34:64126 1 4m11s 4m11s app - 177.99.204.34:64213 1 3m7s 3m7s app - 177.99.204.34:64217 1 1h 1h app - 177.99.204.34:64275 1 1h 1h app - 177.99.204.34:64310 1 9m29s 9m29s app - 177.99.204.34:64347 1 12m35s 12m35s app - 177.99.204.34:64364 1 5m14s 5m14s app - 177.99.204.34:64452 1 13m40s 13m40s app - 177.99.204.34:64609 1 7m35s 7m35s app - 177.99.204.34:64610 1 4m10s 4m10s app - 177.99.204.34:64672 1 9m30s 9m30s app - 177.99.204.34:64796 1 5m15s 5m15s app - 177.99.204.34:64827 1 7m22s 7m22s app - 177.99.204.34:64843 1 4m11s 4m11s app - 177.99.204.34:64940 1 9m26s 9m26s app - 177.99.204.34:65060 1 1h 1h app - 177.99.204.34:65082 1 7m19s 7m19s app - 177.99.204.34:65089 1 47m38s 47m38s app - 177.99.204.34:65159 2 1h4m1s 32m app - 177.99.204.34:65287 1 4m11s 4m11s app - 177.99.204.34:65375 1 2m4s 2m4s app - 177.99.204.34:65437 1 6m15s 6m15s pg_dump 6 35m23s 5m53s postgres_fdw 1 45m 45m psql - unix(3151031@a2tech):8963 1 1h 1h psql - unix(3151141@a2tech):8963 1 1h 1h psql - unix(3154827@a2tech):8963 1 1h 1h psql - unix(3156193@a2tech):8963 1 1h 1h psql - unix(3156271@a2tech):8963 1 1h2m5s 1h2m5s psql - unix(3156614@a2tech):8963 1 1h 1h psql - unix(3157197@a2tech):8963 1 1h 1h psql - unix(3157205@a2tech):8963 1 1h 1h psql - unix(3157911@a2tech):8963 1 1h 1h psql - unix(3158774@a2tech):8963 1 1h3m4s 1h3m4s psql - unix(3158873@a2tech):8963 1 1h 1h psql - unix(3159681@a2tech):8963 1 1h16s 1h16s psql - unix(3159724@a2tech):8963 1 1h 1h psql - unix(3160186@a2tech):8963 1 1h 1h psql - unix(3161337@a2tech):8963 1 1h3m4s 1h3m4s psql - unix(3162865@a2tech):8963 1 1h 1h psql - unix(3163853@a2tech):8963 1 1h3m4s 1h3m4s psql - unix(3163923@a2tech):8963 1 1h3s 1h3s psql - unix(3164318@a2tech):8963 1 1h 1h psql - unix(3164739@a2tech):8963 1 1h3m6s 1h3m6s psql - unix(3165567@a2tech):8963 1 1h 1h psql - unix(3167381@a2tech):8963 1 1h2m10s 1h2m10s psql - unix(3168362@a2tech):8963 1 1h 1h psql - unix(3168421@a2tech):8963 1 1h 1h -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 14,408 buffers Checkpoint Peak
- 2026-05-02 00:09:51 Date
- 269.880 seconds Highest write time
- 0.003 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-05-02 10:10:09 Date
Checkpoints distance
Key values
- 211.85 Mo Distance Peak
- 2026-05-02 00:09:51 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 02 00 14,408 269.88s 0.003s 269.905s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 55 0.012s 0.003s 0.021s 04 0 0s 0s 0s 05 4,265 322.082s 0.009s 322.107s 06 2,072 207.008s 0.002s 207.013s 07 951 94.909s 0.002s 94.918s 08 21 2.007s 0.002s 2.012s 09 21 2.007s 0.002s 2.013s 10 21 2.009s 0.002s 2.014s 11 20 1.907s 0.002s 1.913s 12 20 1.907s 0.002s 1.913s 13 21 2.008s 0.002s 2.014s 14 21 2.007s 0.003s 2.013s 15 21 2.008s 0.003s 2.014s 16 20 1.908s 0.002s 1.915s 17 21 2.008s 0.002s 2.013s 18 417 41.619s 0.007s 41.636s 19 21 2.007s 0.002s 2.013s 20 47 4.613s 0.002s 4.618s 21 20 1.909s 0.002s 1.916s 22 21 2.008s 0.003s 2.014s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 02 00 0 7 0 47 0.001s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 18 0.001s 0.002s 04 0 0 0 0 0s 0s 05 0 2 0 110 0.002s 0.004s 06 0 1 0 6 0.002s 0.001s 07 0 1 0 13 0.001s 0.001s 08 0 0 0 3 0.002s 0.001s 09 0 0 0 3 0.002s 0.001s 10 0 0 0 3 0.001s 0.001s 11 0 0 0 3 0.002s 0.001s 12 0 0 0 3 0.002s 0.001s 13 0 0 0 3 0.002s 0.001s 14 0 0 0 3 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 50 0.002s 0.003s 19 0 0 0 3 0.002s 0.001s 20 0 0 0 16 0.001s 0.001s 21 0 0 0 3 0.002s 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 02 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 02 00 108,468.00 kB 221,709.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 115.50 kB 99,780.50 kB 04 0.00 kB 0.00 kB 05 9,490.75 kB 23,944.25 kB 06 11,791.00 kB 26,425.00 kB 07 6,916.00 kB 24,474.00 kB 08 161.00 kB 22,043.00 kB 09 159.00 kB 19,855.00 kB 10 158.00 kB 17,885.00 kB 11 156.00 kB 16,112.00 kB 12 153.00 kB 14,516.00 kB 13 160.00 kB 13,081.00 kB 14 158.00 kB 11,788.00 kB 15 157.00 kB 10,625.00 kB 16 155.00 kB 9,578.00 kB 17 161.00 kB 8,636.00 kB 18 896.67 kB 7,253.33 kB 19 158.00 kB 5,881.00 kB 20 644.00 kB 5,358.00 kB 21 153.00 kB 4,837.00 kB 22 160.00 kB 4,369.00 kB 23 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 442.14 MiB Temp Files size Peak
- 2026-05-02 05:31:03 Date
Number of temporary files
Key values
- 3 per second Temp Files Peak
- 2026-05-02 05:31:08 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 02 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 12 1.11 GiB 94.71 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 858.99 MiB 65.94 MiB 221.07 MiB 107.37 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-02 05:31:09 Duration: 45s670ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3154076@a2tech):8963
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-02 05:31:03 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3154076@a2tech):8963
2 4 277.53 MiB 51.58 MiB 84.88 MiB 69.38 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-05-02 05:30:23 Duration: 20s939ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3154067@a2tech):8963
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-05-02 05:30:21 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3154067@a2tech):8963
Queries generating the largest temporary files
Rank Size Query 1 221.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-02 05:31:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3154076@a2tech):8963 ]
2 221.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-02 05:31:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3154076@a2tech):8963 ]
3 84.88 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-05-02 05:30:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3154067@a2tech):8963 ]
4 84.88 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-05-02 05:30:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3154067@a2tech):8963 ]
5 73.03 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-02 05:31:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3154076@a2tech):8963 ]
6 72.97 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-02 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3154076@a2tech):8963 ]
7 72.96 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-02 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3154076@a2tech):8963 ]
8 66.00 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-02 05:31:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3154076@a2tech):8963 ]
9 65.95 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-02 05:31:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3154076@a2tech):8963 ]
10 65.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-02 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3154076@a2tech):8963 ]
11 56.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-05-02 05:30:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3154067@a2tech):8963 ]
12 51.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-05-02 05:30:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3154067@a2tech):8963 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.17 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_05
Database rio - 2026-05-02 00:05:18 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.17 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_05
Database rio - 2026-05-02 00:05:18 Date
Analyzes per table
Key values
- auditor.auditor_2026_05 (1) Main table analyzed (database brasilia)
- 3 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_statistic (1) Main table vacuumed on database contagem
- 9 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,377 0 6 0 0 2,301 5 165,989 brasilia.auditor.auditor_2026_05 1 0 1,435 0 14 0 0 662 2 54,469 contagem.pg_toast.pg_toast_2619 1 1 188 0 1 0 0 127 2 23,830 brasilia.pg_toast.pg_toast_2619 1 1 251 0 1 0 0 162 2 25,365 rio.auditor.auditor_2026_05 1 0 3,162 0 564 0 0 1,331 2 89,356 rio.pg_catalog.pg_statistic 1 1 3,110 0 18 0 0 2,922 18 227,025 brasilia.pg_catalog.pg_statistic 1 1 2,542 0 5 0 0 2,460 4 166,913 rio.pg_toast.pg_toast_2619 1 1 776 0 20 0 0 651 13 62,985 contagem.auditor.auditor_2026_05 1 0 1,706 0 18 0 0 774 2 61,245 Total 9 6 15,547 671 647 0 0 11,390 50 877,177 Tuples removed per table
Key values
- pg_catalog.pg_statistic (3463) Main table with removed tuples on database rio
- 10291 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 3,463 7,688 0 0 1,279 brasilia.pg_catalog.pg_statistic 1 1 3,005 7,358 0 0 951 contagem.pg_catalog.pg_statistic 1 1 2,993 7,336 0 0 922 rio.pg_toast.pg_toast_2619 1 1 601 668 0 0 264 brasilia.pg_toast.pg_toast_2619 1 1 126 134 0 20 55 contagem.pg_toast.pg_toast_2619 1 1 103 122 0 0 56 brasilia.auditor.auditor_2026_05 1 0 0 45,604 0 0 1,303 rio.auditor.auditor_2026_05 1 0 0 86,273 0 0 3,609 contagem.auditor.auditor_2026_05 1 0 0 53,231 0 0 1,520 Total 9 6 10,291 208,414 0 20 9,959 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (20) Main table with removed pages on database brasilia
- 20 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed brasilia.pg_toast.pg_toast_2619 1 1 126 20 contagem.pg_catalog.pg_statistic 1 1 2993 0 brasilia.auditor.auditor_2026_05 1 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 103 0 rio.auditor.auditor_2026_05 1 0 0 0 rio.pg_catalog.pg_statistic 1 1 3463 0 brasilia.pg_catalog.pg_statistic 1 1 3005 0 rio.pg_toast.pg_toast_2619 1 1 601 0 contagem.auditor.auditor_2026_05 1 0 0 0 Total 9 6 10,291 20 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 02 00 3 3 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.17 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
- 96 Total read queries
- 384 Total write queries
Queries by database
Key values
- rio Main database
- 358 Requests
- 1h24m55s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 715 Requests
User Request type Count Duration intelifix Total 715 2h15m10s copy to 384 34m53s others 235 8m23s select 96 1h31m53s Duration by user
Key values
- 2h15m10s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 715 2h15m10s copy to 384 34m53s others 235 8m23s select 96 1h31m53s Queries by host
Key values
- [local] Main host
- 715 Requests
- 2h15m10s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 384 Requests
- 34m53s (pg_dump)
- Main time consuming application
Application Request type Count Duration pg_dump Total 384 34m53s copy to 384 34m53s psql - unix(3149473@a2tech):8963 Total 1 4s533ms others 1 4s533ms psql - unix(3149476@a2tech):8963 Total 1 1s331ms others 1 1s331ms psql - unix(3149490@a2tech):8963 Total 1 162ms others 1 162ms psql - unix(3149508@a2tech):8963 Total 1 3s763ms others 1 3s763ms psql - unix(3149509@a2tech):8963 Total 1 4s229ms others 1 4s229ms psql - unix(3149621@a2tech):8963 Total 1 1s140ms others 1 1s140ms psql - unix(3149742@a2tech):8963 Total 1 1s63ms others 1 1s63ms psql - unix(3149867@a2tech):8963 Total 1 1s52ms others 1 1s52ms psql - unix(3149992@a2tech):8963 Total 1 1s44ms others 1 1s44ms psql - unix(3150118@a2tech):8963 Total 1 1s47ms others 1 1s47ms psql - unix(3150256@a2tech):8963 Total 1 1s50ms others 1 1s50ms psql - unix(3150384@a2tech):8963 Total 1 1s93ms others 1 1s93ms psql - unix(3150500@a2tech):8963 Total 1 1s56ms others 1 1s56ms psql - unix(3150508@a2tech):8963 Total 1 158ms others 1 158ms psql - unix(3150622@a2tech):8963 Total 1 1s162ms others 1 1s162ms psql - unix(3150743@a2tech):8963 Total 1 1s57ms others 1 1s57ms psql - unix(3150862@a2tech):8963 Total 1 1s39ms others 1 1s39ms psql - unix(3151013@a2tech):8963 Total 1 1s46ms others 1 1s46ms psql - unix(3151141@a2tech):8963 Total 1 1s81ms others 1 1s81ms psql - unix(3151300@a2tech):8963 Total 1 1s83ms others 1 1s83ms psql - unix(3151309@a2tech):8963 Total 1 154ms others 1 154ms psql - unix(3151429@a2tech):8963 Total 1 1s63ms others 1 1s63ms psql - unix(3151554@a2tech):8963 Total 1 1s38ms others 1 1s38ms psql - unix(3151676@a2tech):8963 Total 1 1s43ms others 1 1s43ms psql - unix(3151684@a2tech):8963 Total 1 153ms others 1 153ms psql - unix(3152153@a2tech):8963 Total 1 1s156ms others 1 1s156ms psql - unix(3152166@a2tech):8963 Total 1 179ms others 1 179ms psql - unix(3152293@a2tech):8963 Total 1 1s106ms others 1 1s106ms psql - unix(3152304@a2tech):8963 Total 1 158ms others 1 158ms psql - unix(3152415@a2tech):8963 Total 1 1s39ms others 1 1s39ms psql - unix(3152548@a2tech):8963 Total 1 1s179ms others 1 1s179ms psql - unix(3152560@a2tech):8963 Total 1 151ms others 1 151ms psql - unix(3152671@a2tech):8963 Total 1 1s57ms others 1 1s57ms psql - unix(3152793@a2tech):8963 Total 1 1s46ms others 1 1s46ms psql - unix(3152934@a2tech):8963 Total 1 1s64ms others 1 1s64ms psql - unix(3153067@a2tech):8963 Total 1 1s94ms others 1 1s94ms psql - unix(3153183@a2tech):8963 Total 1 1s235ms others 1 1s235ms psql - unix(3153193@a2tech):8963 Total 1 151ms others 1 151ms psql - unix(3153317@a2tech):8963 Total 1 1s105ms others 1 1s105ms psql - unix(3153439@a2tech):8963 Total 1 1s71ms others 1 1s71ms psql - unix(3153561@a2tech):8963 Total 1 1s58ms others 1 1s58ms psql - unix(3153636@a2tech):8963 Total 1 1m53s others 1 1m53s psql - unix(3153666@a2tech):8963 Total 1 1m19s others 1 1m19s psql - unix(3153678@a2tech):8963 Total 1 57s318ms others 1 57s318ms psql - unix(3153720@a2tech):8963 Total 1 1s203ms others 1 1s203ms psql - unix(3153854@a2tech):8963 Total 1 1s61ms others 1 1s61ms psql - unix(3153983@a2tech):8963 Total 1 1s98ms others 1 1s98ms psql - unix(3154067@a2tech):8963 Total 1 20s939ms others 1 20s939ms psql - unix(3154076@a2tech):8963 Total 1 45s670ms others 1 45s670ms psql - unix(3154138@a2tech):8963 Total 1 1s53ms others 1 1s53ms psql - unix(3154258@a2tech):8963 Total 1 1s35ms others 1 1s35ms psql - unix(3154374@a2tech):8963 Total 1 1s43ms others 1 1s43ms psql - unix(3154565@a2tech):8963 Total 1 1s49ms others 1 1s49ms psql - unix(3154567@a2tech):8963 Total 1 2s82ms others 1 2s82ms psql - unix(3154578@a2tech):8963 Total 1 155ms others 1 155ms psql - unix(3154590@a2tech):8963 Total 1 1s810ms others 1 1s810ms psql - unix(3154598@a2tech):8963 Total 1 2s2ms others 1 2s2ms psql - unix(3154697@a2tech):8963 Total 1 1s89ms others 1 1s89ms psql - unix(3154827@a2tech):8963 Total 1 1s16ms others 1 1s16ms psql - unix(3154993@a2tech):8963 Total 1 1s130ms others 1 1s130ms psql - unix(3155121@a2tech):8963 Total 1 1s49ms others 1 1s49ms psql - unix(3155242@a2tech):8963 Total 1 1s53ms others 1 1s53ms psql - unix(3155250@a2tech):8963 Total 1 152ms others 1 152ms psql - unix(3155383@a2tech):8963 Total 1 3m17s select 1 3m17s psql - unix(3155390@a2tech):8963 Total 1 1s193ms others 1 1s193ms psql - unix(3155448@a2tech):8963 Total 1 19s871ms select 1 19s871ms psql - unix(3155455@a2tech):8963 Total 1 10s204ms select 1 10s204ms psql - unix(3155462@a2tech):8963 Total 1 2m12s select 1 2m12s psql - unix(3155486@a2tech):8963 Total 1 871ms select 1 871ms psql - unix(3155491@a2tech):8963 Total 1 461ms select 1 461ms psql - unix(3155546@a2tech):8963 Total 1 1s96ms others 1 1s96ms psql - unix(3155666@a2tech):8963 Total 1 1s34ms others 1 1s34ms psql - unix(3155789@a2tech):8963 Total 1 1s31ms others 1 1s31ms psql - unix(3155916@a2tech):8963 Total 1 1s78ms others 1 1s78ms psql - unix(3156031@a2tech):8963 Total 1 1s69ms others 1 1s69ms psql - unix(3156108@a2tech):8963 Total 1 643ms others 1 643ms psql - unix(3156110@a2tech):8963 Total 1 254ms others 1 254ms psql - unix(3156194@a2tech):8963 Total 1 3m6s select 1 3m6s psql - unix(3156201@a2tech):8963 Total 1 1s308ms others 1 1s308ms psql - unix(3156212@a2tech):8963 Total 1 159ms others 1 159ms psql - unix(3156257@a2tech):8963 Total 1 17s333ms select 1 17s333ms psql - unix(3156265@a2tech):8963 Total 1 8s358ms select 1 8s358ms psql - unix(3156271@a2tech):8963 Total 1 2m10s select 1 2m10s psql - unix(3156295@a2tech):8963 Total 1 520ms select 1 520ms psql - unix(3156298@a2tech):8963 Total 1 318ms select 1 318ms psql - unix(3156353@a2tech):8963 Total 1 1s71ms others 1 1s71ms psql - unix(3156361@a2tech):8963 Total 1 152ms others 1 152ms psql - unix(3156423@a2tech):8963 Total 1 254ms others 1 254ms psql - unix(3156425@a2tech):8963 Total 1 227ms others 1 227ms psql - unix(3156482@a2tech):8963 Total 1 1s47ms others 1 1s47ms psql - unix(3156491@a2tech):8963 Total 1 150ms others 1 150ms psql - unix(3156614@a2tech):8963 Total 1 1s81ms others 1 1s81ms psql - unix(3156690@a2tech):8963 Total 1 253ms others 1 253ms psql - unix(3156749@a2tech):8963 Total 1 1s72ms others 1 1s72ms psql - unix(3156875@a2tech):8963 Total 1 1s108ms others 1 1s108ms psql - unix(3156947@a2tech):8963 Total 1 156ms others 1 156ms psql - unix(3157033@a2tech):8963 Total 1 3m6s select 1 3m6s psql - unix(3157038@a2tech):8963 Total 1 1s166ms others 1 1s166ms psql - unix(3157091@a2tech):8963 Total 1 17s446ms select 1 17s446ms psql - unix(3157100@a2tech):8963 Total 1 8s386ms select 1 8s386ms psql - unix(3157105@a2tech):8963 Total 1 2m10s select 1 2m10s psql - unix(3157130@a2tech):8963 Total 1 577ms select 1 577ms psql - unix(3157134@a2tech):8963 Total 1 363ms select 1 363ms psql - unix(3157189@a2tech):8963 Total 1 1s34ms others 1 1s34ms psql - unix(3157256@a2tech):8963 Total 1 236ms others 1 236ms psql - unix(3157258@a2tech):8963 Total 1 229ms others 1 229ms psql - unix(3157332@a2tech):8963 Total 1 1s70ms others 1 1s70ms psql - unix(3157340@a2tech):8963 Total 1 151ms others 1 151ms psql - unix(3157455@a2tech):8963 Total 1 1s50ms others 1 1s50ms psql - unix(3157569@a2tech):8963 Total 1 227ms others 1 227ms psql - unix(3157571@a2tech):8963 Total 1 211ms others 1 211ms psql - unix(3157636@a2tech):8963 Total 1 1s76ms others 1 1s76ms psql - unix(3157757@a2tech):8963 Total 1 1s28ms others 1 1s28ms psql - unix(3157907@a2tech):8963 Total 1 3m6s select 1 3m6s psql - unix(3157911@a2tech):8963 Total 1 1s201ms others 1 1s201ms psql - unix(3157971@a2tech):8963 Total 1 17s338ms select 1 17s338ms psql - unix(3157980@a2tech):8963 Total 1 8s618ms select 1 8s618ms psql - unix(3157985@a2tech):8963 Total 1 2m9s select 1 2m9s psql - unix(3158013@a2tech):8963 Total 1 542ms select 1 542ms psql - unix(3158017@a2tech):8963 Total 1 351ms select 1 351ms psql - unix(3158076@a2tech):8963 Total 1 1s46ms others 1 1s46ms psql - unix(3158145@a2tech):8963 Total 1 221ms others 1 221ms psql - unix(3158147@a2tech):8963 Total 1 229ms others 1 229ms psql - unix(3158215@a2tech):8963 Total 1 1s40ms others 1 1s40ms psql - unix(3158352@a2tech):8963 Total 1 1s100ms others 1 1s100ms psql - unix(3158432@a2tech):8963 Total 1 268ms others 1 268ms psql - unix(3158434@a2tech):8963 Total 1 229ms others 1 229ms psql - unix(3158493@a2tech):8963 Total 1 1s37ms others 1 1s37ms psql - unix(3158622@a2tech):8963 Total 1 1s42ms others 1 1s42ms psql - unix(3158774@a2tech):8963 Total 1 3m5s select 1 3m5s psql - unix(3158778@a2tech):8963 Total 1 1s157ms others 1 1s157ms psql - unix(3158832@a2tech):8963 Total 1 17s395ms select 1 17s395ms psql - unix(3158839@a2tech):8963 Total 1 8s312ms select 1 8s312ms psql - unix(3158846@a2tech):8963 Total 1 2m9s select 1 2m9s psql - unix(3158869@a2tech):8963 Total 1 524ms select 1 524ms psql - unix(3158873@a2tech):8963 Total 1 351ms select 1 351ms psql - unix(3158937@a2tech):8963 Total 1 1s59ms others 1 1s59ms psql - unix(3159014@a2tech):8963 Total 1 219ms others 1 219ms psql - unix(3159069@a2tech):8963 Total 1 1s68ms others 1 1s68ms psql - unix(3159077@a2tech):8963 Total 1 193ms others 1 193ms psql - unix(3159200@a2tech):8963 Total 1 1s131ms others 1 1s131ms psql - unix(3159279@a2tech):8963 Total 1 265ms others 1 265ms psql - unix(3159281@a2tech):8963 Total 1 216ms others 1 216ms psql - unix(3159345@a2tech):8963 Total 1 1s41ms others 1 1s41ms psql - unix(3159464@a2tech):8963 Total 1 1s98ms others 1 1s98ms psql - unix(3159536@a2tech):8963 Total 1 242ms others 1 242ms psql - unix(3159613@a2tech):8963 Total 1 3m5s select 1 3m5s psql - unix(3159621@a2tech):8963 Total 1 1s103ms others 1 1s103ms psql - unix(3159681@a2tech):8963 Total 1 17s425ms select 1 17s425ms psql - unix(3159688@a2tech):8963 Total 1 8s305ms select 1 8s305ms psql - unix(3159693@a2tech):8963 Total 1 2m9s select 1 2m9s psql - unix(3159719@a2tech):8963 Total 1 549ms select 1 549ms psql - unix(3159724@a2tech):8963 Total 1 341ms select 1 341ms psql - unix(3159785@a2tech):8963 Total 1 1s117ms others 1 1s117ms psql - unix(3159859@a2tech):8963 Total 1 237ms others 1 237ms psql - unix(3159915@a2tech):8963 Total 1 1s155ms others 1 1s155ms psql - unix(3160049@a2tech):8963 Total 1 1s41ms others 1 1s41ms psql - unix(3160060@a2tech):8963 Total 1 162ms others 1 162ms psql - unix(3160123@a2tech):8963 Total 1 221ms others 1 221ms psql - unix(3160186@a2tech):8963 Total 1 1s48ms others 1 1s48ms psql - unix(3160307@a2tech):8963 Total 1 1s64ms others 1 1s64ms psql - unix(3160383@a2tech):8963 Total 1 223ms others 1 223ms psql - unix(3160458@a2tech):8963 Total 1 3m7s select 1 3m7s psql - unix(3160467@a2tech):8963 Total 1 1s294ms others 1 1s294ms psql - unix(3160531@a2tech):8963 Total 1 17s307ms select 1 17s307ms psql - unix(3160537@a2tech):8963 Total 1 8s269ms select 1 8s269ms psql - unix(3160546@a2tech):8963 Total 1 2m9s select 1 2m9s psql - unix(3160572@a2tech):8963 Total 1 533ms select 1 533ms psql - unix(3160578@a2tech):8963 Total 1 348ms select 1 348ms psql - unix(3160631@a2tech):8963 Total 1 1s34ms others 1 1s34ms psql - unix(3160698@a2tech):8963 Total 1 218ms others 1 218ms psql - unix(3160796@a2tech):8963 Total 1 1s59ms others 1 1s59ms psql - unix(3160921@a2tech):8963 Total 1 1s45ms others 1 1s45ms psql - unix(3160993@a2tech):8963 Total 1 251ms others 1 251ms psql - unix(3160995@a2tech):8963 Total 1 250ms others 1 250ms psql - unix(3161054@a2tech):8963 Total 1 1s89ms others 1 1s89ms psql - unix(3161177@a2tech):8963 Total 1 1s80ms others 1 1s80ms psql - unix(3161253@a2tech):8963 Total 1 156ms others 1 156ms psql - unix(3161255@a2tech):8963 Total 1 220ms others 1 220ms psql - unix(3161336@a2tech):8963 Total 1 1s155ms others 1 1s155ms psql - unix(3161337@a2tech):8963 Total 1 3m4s select 1 3m4s psql - unix(3161392@a2tech):8963 Total 1 17s390ms select 1 17s390ms psql - unix(3161399@a2tech):8963 Total 1 8s297ms select 1 8s297ms psql - unix(3161404@a2tech):8963 Total 1 2m10s select 1 2m10s psql - unix(3161430@a2tech):8963 Total 1 553ms select 1 553ms psql - unix(3161433@a2tech):8963 Total 1 322ms select 1 322ms psql - unix(3161492@a2tech):8963 Total 1 1s59ms others 1 1s59ms psql - unix(3161568@a2tech):8963 Total 1 258ms others 1 258ms psql - unix(3161625@a2tech):8963 Total 1 1s41ms others 1 1s41ms psql - unix(3161757@a2tech):8963 Total 1 1s167ms others 1 1s167ms psql - unix(3161828@a2tech):8963 Total 1 242ms others 1 242ms psql - unix(3161890@a2tech):8963 Total 1 1s103ms others 1 1s103ms psql - unix(3162007@a2tech):8963 Total 1 1s27ms others 1 1s27ms psql - unix(3162079@a2tech):8963 Total 1 225ms others 1 225ms psql - unix(3162169@a2tech):8963 Total 1 3m5s select 1 3m5s psql - unix(3162172@a2tech):8963 Total 1 1s227ms others 1 1s227ms psql - unix(3162184@a2tech):8963 Total 1 160ms others 1 160ms psql - unix(3162228@a2tech):8963 Total 1 17s420ms select 1 17s420ms psql - unix(3162236@a2tech):8963 Total 1 8s423ms select 1 8s423ms psql - unix(3162241@a2tech):8963 Total 1 2m10s select 1 2m10s psql - unix(3162264@a2tech):8963 Total 1 540ms select 1 540ms psql - unix(3162269@a2tech):8963 Total 1 346ms select 1 346ms psql - unix(3162329@a2tech):8963 Total 1 1s36ms others 1 1s36ms psql - unix(3162396@a2tech):8963 Total 1 236ms others 1 236ms psql - unix(3162399@a2tech):8963 Total 1 195ms others 1 195ms psql - unix(3162458@a2tech):8963 Total 1 1s38ms others 1 1s38ms psql - unix(3162596@a2tech):8963 Total 1 1s63ms others 1 1s63ms psql - unix(3162674@a2tech):8963 Total 1 155ms others 1 155ms psql - unix(3162737@a2tech):8963 Total 1 1s37ms others 1 1s37ms psql - unix(3162865@a2tech):8963 Total 1 1s28ms others 1 1s28ms psql - unix(3162938@a2tech):8963 Total 1 236ms others 1 236ms psql - unix(3162941@a2tech):8963 Total 1 239ms others 1 239ms psql - unix(3163019@a2tech):8963 Total 1 3m3s select 1 3m3s psql - unix(3163027@a2tech):8963 Total 1 1s127ms others 1 1s127ms psql - unix(3163037@a2tech):8963 Total 1 174ms others 1 174ms psql - unix(3163083@a2tech):8963 Total 1 17s201ms select 1 17s201ms psql - unix(3163090@a2tech):8963 Total 1 8s269ms select 1 8s269ms psql - unix(3163094@a2tech):8963 Total 1 2m9s select 1 2m9s psql - unix(3163122@a2tech):8963 Total 1 513ms select 1 513ms psql - unix(3163126@a2tech):8963 Total 1 341ms select 1 341ms psql - unix(3163186@a2tech):8963 Total 1 1s45ms others 1 1s45ms psql - unix(3163254@a2tech):8963 Total 1 228ms others 1 228ms psql - unix(3163256@a2tech):8963 Total 1 201ms others 1 201ms psql - unix(3163316@a2tech):8963 Total 1 1s39ms others 1 1s39ms psql - unix(3163440@a2tech):8963 Total 1 1s83ms others 1 1s83ms psql - unix(3163582@a2tech):8963 Total 1 1s108ms others 1 1s108ms psql - unix(3163705@a2tech):8963 Total 1 1s25ms others 1 1s25ms psql - unix(3163775@a2tech):8963 Total 1 160ms others 1 160ms psql - unix(3163853@a2tech):8963 Total 1 3m4s select 1 3m4s psql - unix(3163862@a2tech):8963 Total 1 1s209ms others 1 1s209ms psql - unix(3163916@a2tech):8963 Total 1 17s426ms select 1 17s426ms psql - unix(3163923@a2tech):8963 Total 1 8s331ms select 1 8s331ms psql - unix(3163927@a2tech):8963 Total 1 2m10s select 1 2m10s psql - unix(3163951@a2tech):8963 Total 1 544ms select 1 544ms psql - unix(3163955@a2tech):8963 Total 1 352ms select 1 352ms psql - unix(3164012@a2tech):8963 Total 1 1s78ms others 1 1s78ms psql - unix(3164084@a2tech):8963 Total 1 235ms others 1 235ms psql - unix(3164086@a2tech):8963 Total 1 222ms others 1 222ms psql - unix(3164144@a2tech):8963 Total 1 1s63ms others 1 1s63ms psql - unix(3164302@a2tech):8963 Total 1 1s75ms others 1 1s75ms psql - unix(3164439@a2tech):8963 Total 1 1s23ms others 1 1s23ms psql - unix(3164578@a2tech):8963 Total 1 1s48ms others 1 1s48ms psql - unix(3164652@a2tech):8963 Total 1 250ms others 1 250ms psql - unix(3164739@a2tech):8963 Total 1 3m5s select 1 3m5s psql - unix(3164747@a2tech):8963 Total 1 1s165ms others 1 1s165ms psql - unix(3164803@a2tech):8963 Total 1 17s658ms select 1 17s658ms psql - unix(3164811@a2tech):8963 Total 1 8s835ms select 1 8s835ms psql - unix(3164816@a2tech):8963 Total 1 2m9s select 1 2m9s psql - unix(3164841@a2tech):8963 Total 1 558ms select 1 558ms psql - unix(3164846@a2tech):8963 Total 1 354ms select 1 354ms psql - unix(3164905@a2tech):8963 Total 1 1s25ms others 1 1s25ms psql - unix(3164975@a2tech):8963 Total 1 234ms others 1 234ms psql - unix(3164977@a2tech):8963 Total 1 219ms others 1 219ms psql - unix(3165035@a2tech):8963 Total 1 1s22ms others 1 1s22ms psql - unix(3165043@a2tech):8963 Total 1 154ms others 1 154ms psql - unix(3165158@a2tech):8963 Total 1 1s171ms others 1 1s171ms psql - unix(3165229@a2tech):8963 Total 1 223ms others 1 223ms psql - unix(3165231@a2tech):8963 Total 1 207ms others 1 207ms psql - unix(3165290@a2tech):8963 Total 1 1s226ms others 1 1s226ms psql - unix(3165408@a2tech):8963 Total 1 1s57ms others 1 1s57ms psql - unix(3165477@a2tech):8963 Total 1 154ms others 1 154ms psql - unix(3165566@a2tech):8963 Total 1 1s133ms others 1 1s133ms psql - unix(3165567@a2tech):8963 Total 1 3m6s select 1 3m6s psql - unix(3165623@a2tech):8963 Total 1 17s533ms select 1 17s533ms psql - unix(3165633@a2tech):8963 Total 1 8s302ms select 1 8s302ms psql - unix(3165637@a2tech):8963 Total 1 2m9s select 1 2m9s psql - unix(3165664@a2tech):8963 Total 1 537ms select 1 537ms psql - unix(3165668@a2tech):8963 Total 1 365ms select 1 365ms psql - unix(3165734@a2tech):8963 Total 1 1s92ms others 1 1s92ms psql - unix(3165803@a2tech):8963 Total 1 249ms others 1 249ms psql - unix(3165805@a2tech):8963 Total 1 246ms others 1 246ms psql - unix(3165860@a2tech):8963 Total 1 1s101ms others 1 1s101ms psql - unix(3165992@a2tech):8963 Total 1 1s71ms others 1 1s71ms psql - unix(3166063@a2tech):8963 Total 1 161ms others 1 161ms psql - unix(3166067@a2tech):8963 Total 1 228ms others 1 228ms psql - unix(3166128@a2tech):8963 Total 1 1s53ms others 1 1s53ms psql - unix(3166247@a2tech):8963 Total 1 1s19ms others 1 1s19ms psql - unix(3166331@a2tech):8963 Total 1 164ms others 1 164ms psql - unix(3166435@a2tech):8963 Total 1 3m13s select 1 3m13s psql - unix(3166443@a2tech):8963 Total 1 1s339ms others 1 1s339ms psql - unix(3166454@a2tech):8963 Total 1 155ms others 1 155ms psql - unix(3166509@a2tech):8963 Total 1 20s198ms select 1 20s198ms psql - unix(3166518@a2tech):8963 Total 1 9s6ms select 1 9s6ms psql - unix(3166523@a2tech):8963 Total 1 2m11s select 1 2m11s psql - unix(3166551@a2tech):8963 Total 1 746ms select 1 746ms psql - unix(3166555@a2tech):8963 Total 1 472ms select 1 472ms psql - unix(3166608@a2tech):8963 Total 1 1s251ms others 1 1s251ms psql - unix(3166681@a2tech):8963 Total 1 277ms others 1 277ms psql - unix(3166738@a2tech):8963 Total 1 1s22ms others 1 1s22ms psql - unix(3166748@a2tech):8963 Total 1 184ms others 1 184ms psql - unix(3166864@a2tech):8963 Total 1 1s120ms others 1 1s120ms psql - unix(3166937@a2tech):8963 Total 1 257ms others 1 257ms psql - unix(3166939@a2tech):8963 Total 1 227ms others 1 227ms psql - unix(3166998@a2tech):8963 Total 1 1s97ms others 1 1s97ms psql - unix(3167122@a2tech):8963 Total 1 1s197ms others 1 1s197ms psql - unix(3167193@a2tech):8963 Total 1 155ms others 1 155ms psql - unix(3167311@a2tech):8963 Total 1 3m7s select 1 3m7s psql - unix(3167315@a2tech):8963 Total 1 1s75ms others 1 1s75ms psql - unix(3167371@a2tech):8963 Total 1 17s444ms select 1 17s444ms psql - unix(3167378@a2tech):8963 Total 1 8s281ms select 1 8s281ms psql - unix(3167381@a2tech):8963 Total 1 2m10s select 1 2m10s psql - unix(3167410@a2tech):8963 Total 1 563ms select 1 563ms psql - unix(3167414@a2tech):8963 Total 1 346ms select 1 346ms psql - unix(3167468@a2tech):8963 Total 1 1s112ms others 1 1s112ms psql - unix(3167540@a2tech):8963 Total 1 226ms others 1 226ms psql - unix(3167542@a2tech):8963 Total 1 218ms others 1 218ms psql - unix(3167603@a2tech):8963 Total 1 1s113ms others 1 1s113ms psql - unix(3167616@a2tech):8963 Total 1 152ms others 1 152ms psql - unix(3167732@a2tech):8963 Total 1 1s59ms others 1 1s59ms psql - unix(3167810@a2tech):8963 Total 1 230ms others 1 230ms psql - unix(3167812@a2tech):8963 Total 1 237ms others 1 237ms psql - unix(3167869@a2tech):8963 Total 1 1s65ms others 1 1s65ms psql - unix(3167992@a2tech):8963 Total 1 1s75ms others 1 1s75ms psql - unix(3168065@a2tech):8963 Total 1 155ms others 1 155ms psql - unix(3168156@a2tech):8963 Total 1 3m6s select 1 3m6s psql - unix(3168189@a2tech):8963 Total 1 1s85ms others 1 1s85ms psql - unix(3168324@a2tech):8963 Total 1 17s361ms select 1 17s361ms psql - unix(3168332@a2tech):8963 Total 1 8s921ms select 1 8s921ms psql - unix(3168336@a2tech):8963 Total 1 2m10s select 1 2m10s psql - unix(3168362@a2tech):8963 Total 1 537ms select 1 537ms psql - unix(3168365@a2tech):8963 Total 1 375ms select 1 375ms psql - unix(3168421@a2tech):8963 Total 1 1s101ms others 1 1s101ms psql - unix(3168492@a2tech):8963 Total 1 281ms others 1 281ms psql - unix(3168554@a2tech):8963 Total 1 1s243ms others 1 1s243ms psql - unix(3168676@a2tech):8963 Total 1 1s180ms others 1 1s180ms psql - unix(3168688@a2tech):8963 Total 1 161ms others 1 161ms psql - unix(3168761@a2tech):8963 Total 1 230ms others 1 230ms psql - unix(3168763@a2tech):8963 Total 1 200ms others 1 200ms psql - unix(3168823@a2tech):8963 Total 1 1s119ms others 1 1s119ms psql - unix(3168947@a2tech):8963 Total 1 1s34ms others 1 1s34ms psql - unix(3168955@a2tech):8963 Total 1 151ms others 1 151ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-02 23:50:18 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 383 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 3m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-02 07:08:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3155383@a2tech):8963 ]
2 3m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-02 20:08:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3166435@a2tech):8963 ]
3 3m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-02 21:08:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3167311@a2tech):8963 ]
4 3m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-02 13:08:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3160458@a2tech):8963 ]
5 3m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-02 10:08:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3157907@a2tech):8963 ]
6 3m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-02 09:08:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3157033@a2tech):8963 ]
7 3m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-02 08:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3156194@a2tech):8963 ]
8 3m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-02 19:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3165567@a2tech):8963 ]
9 3m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-02 22:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3168156@a2tech):8963 ]
10 3m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-02 18:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3164739@a2tech):8963 ]
11 3m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-02 11:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3158774@a2tech):8963 ]
12 3m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-02 15:08:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3162169@a2tech):8963 ]
13 3m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-02 12:08:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3159613@a2tech):8963 ]
14 3m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-02 17:08:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3163853@a2tech):8963 ]
15 3m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-02 14:08:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3161337@a2tech):8963 ]
16 3m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-02 16:08:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3163019@a2tech):8963 ]
17 2m12s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-05-02 07:11:03 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3155462@a2tech):8963 ]
18 2m11s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-05-02 20:10:57 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3166523@a2tech):8963 ]
19 2m10s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-05-02 22:10:47 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3168336@a2tech):8963 ]
20 2m10s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-05-02 09:10:46 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3157105@a2tech):8963 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 52m19s 48 513ms 3m17s 1m5s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 02 07 3 3m28s 1m9s 08 3 3m15s 1m5s 09 3 3m15s 1m5s 10 3 3m15s 1m5s 11 3 3m14s 1m4s 12 3 3m13s 1m4s 13 3 3m16s 1m5s 14 3 3m13s 1m4s 15 3 3m14s 1m4s 16 3 3m12s 1m4s 17 3 3m13s 1m4s 18 3 3m15s 1m5s 19 3 3m15s 1m5s 20 3 3m23s 1m7s 21 3 3m16s 1m5s 22 3 3m15s 1m5s [ User: intelifix - Total duration: 52m19s - Times executed: 48 ]
[ Application: psql - unix(3155383@a2tech):8963 - Total duration: 3m17s - Times executed: 1 ]
[ Application: psql - unix(3166435@a2tech):8963 - Total duration: 3m13s - Times executed: 1 ]
[ Application: psql - unix(3167311@a2tech):8963 - Total duration: 3m7s - Times executed: 1 ]
[ Application: psql - unix(3160458@a2tech):8963 - Total duration: 3m7s - Times executed: 1 ]
[ Application: psql - unix(3157907@a2tech):8963 - Total duration: 3m6s - Times executed: 1 ]
[ Application: psql - unix(3157033@a2tech):8963 - Total duration: 3m6s - Times executed: 1 ]
[ Application: psql - unix(3156194@a2tech):8963 - Total duration: 3m6s - Times executed: 1 ]
[ Application: psql - unix(3165567@a2tech):8963 - Total duration: 3m6s - Times executed: 1 ]
[ Application: psql - unix(3168156@a2tech):8963 - Total duration: 3m6s - Times executed: 1 ]
[ Application: psql - unix(3164739@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3158774@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3162169@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3159613@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3163853@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3161337@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3163019@a2tech):8963 - Total duration: 3m3s - Times executed: 1 ]
[ Application: psql - unix(3155455@a2tech):8963 - Total duration: 10s204ms - Times executed: 1 ]
[ Application: psql - unix(3166518@a2tech):8963 - Total duration: 9s6ms - Times executed: 1 ]
[ Application: psql - unix(3168332@a2tech):8963 - Total duration: 8s921ms - Times executed: 1 ]
[ Application: psql - unix(3164811@a2tech):8963 - Total duration: 8s835ms - Times executed: 1 ]
[ Application: psql - unix(3157980@a2tech):8963 - Total duration: 8s618ms - Times executed: 1 ]
[ Application: psql - unix(3162236@a2tech):8963 - Total duration: 8s423ms - Times executed: 1 ]
[ Application: psql - unix(3157100@a2tech):8963 - Total duration: 8s386ms - Times executed: 1 ]
[ Application: psql - unix(3156265@a2tech):8963 - Total duration: 8s358ms - Times executed: 1 ]
[ Application: psql - unix(3163923@a2tech):8963 - Total duration: 8s331ms - Times executed: 1 ]
[ Application: psql - unix(3158839@a2tech):8963 - Total duration: 8s312ms - Times executed: 1 ]
[ Application: psql - unix(3159688@a2tech):8963 - Total duration: 8s305ms - Times executed: 1 ]
[ Application: psql - unix(3165633@a2tech):8963 - Total duration: 8s302ms - Times executed: 1 ]
[ Application: psql - unix(3161399@a2tech):8963 - Total duration: 8s297ms - Times executed: 1 ]
[ Application: psql - unix(3167378@a2tech):8963 - Total duration: 8s281ms - Times executed: 1 ]
[ Application: psql - unix(3163090@a2tech):8963 - Total duration: 8s269ms - Times executed: 1 ]
[ Application: psql - unix(3160537@a2tech):8963 - Total duration: 8s269ms - Times executed: 1 ]
[ Application: psql - unix(3155486@a2tech):8963 - Total duration: 871ms - Times executed: 1 ]
[ Application: psql - unix(3166551@a2tech):8963 - Total duration: 746ms - Times executed: 1 ]
[ Application: psql - unix(3157130@a2tech):8963 - Total duration: 577ms - Times executed: 1 ]
[ Application: psql - unix(3167410@a2tech):8963 - Total duration: 563ms - Times executed: 1 ]
[ Application: psql - unix(3164841@a2tech):8963 - Total duration: 558ms - Times executed: 1 ]
[ Application: psql - unix(3161430@a2tech):8963 - Total duration: 553ms - Times executed: 1 ]
[ Application: psql - unix(3159719@a2tech):8963 - Total duration: 549ms - Times executed: 1 ]
[ Application: psql - unix(3163951@a2tech):8963 - Total duration: 544ms - Times executed: 1 ]
[ Application: psql - unix(3158013@a2tech):8963 - Total duration: 542ms - Times executed: 1 ]
[ Application: psql - unix(3162264@a2tech):8963 - Total duration: 540ms - Times executed: 1 ]
[ Application: psql - unix(3165664@a2tech):8963 - Total duration: 537ms - Times executed: 1 ]
[ Application: psql - unix(3168362@a2tech):8963 - Total duration: 537ms - Times executed: 1 ]
[ Application: psql - unix(3160572@a2tech):8963 - Total duration: 533ms - Times executed: 1 ]
[ Application: psql - unix(3158869@a2tech):8963 - Total duration: 524ms - Times executed: 1 ]
[ Application: psql - unix(3156295@a2tech):8963 - Total duration: 520ms - Times executed: 1 ]
[ Application: psql - unix(3163122@a2tech):8963 - Total duration: 513ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-02 07:08:20 Duration: 3m17s Database: rio User: intelifix Remote: [local] Application: psql - unix(3155383@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-02 20:08:15 Duration: 3m13s Database: rio User: intelifix Remote: [local] Application: psql - unix(3166435@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-02 21:08:10 Duration: 3m7s Database: rio User: intelifix Remote: [local] Application: psql - unix(3167311@a2tech):8963
2 39m33s 48 318ms 2m12s 49s454ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 02 07 3 2m32s 50s844ms 08 3 2m27s 49s265ms 09 3 2m28s 49s561ms 10 3 2m27s 49s27ms 11 3 2m27s 49s77ms 12 3 2m27s 49s202ms 13 3 2m27s 49s189ms 14 3 2m27s 49s261ms 15 3 2m28s 49s394ms 16 3 2m27s 49s111ms 17 3 2m27s 49s286ms 18 3 2m27s 49s155ms 19 3 2m27s 49s222ms 20 3 2m32s 50s803ms 21 3 2m27s 49s300ms 22 3 2m28s 49s569ms [ User: intelifix - Total duration: 39m33s - Times executed: 48 ]
[ Application: psql - unix(3155462@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(3166523@a2tech):8963 - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - unix(3168336@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3157105@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3162241@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3156271@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3167381@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3163927@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3161404@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3160546@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3159693@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3163094@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3165637@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3158846@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3164816@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3157985@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3166509@a2tech):8963 - Total duration: 20s198ms - Times executed: 1 ]
[ Application: psql - unix(3155448@a2tech):8963 - Total duration: 19s871ms - Times executed: 1 ]
[ Application: psql - unix(3164803@a2tech):8963 - Total duration: 17s658ms - Times executed: 1 ]
[ Application: psql - unix(3165623@a2tech):8963 - Total duration: 17s533ms - Times executed: 1 ]
[ Application: psql - unix(3157091@a2tech):8963 - Total duration: 17s446ms - Times executed: 1 ]
[ Application: psql - unix(3167371@a2tech):8963 - Total duration: 17s444ms - Times executed: 1 ]
[ Application: psql - unix(3163916@a2tech):8963 - Total duration: 17s426ms - Times executed: 1 ]
[ Application: psql - unix(3159681@a2tech):8963 - Total duration: 17s425ms - Times executed: 1 ]
[ Application: psql - unix(3162228@a2tech):8963 - Total duration: 17s420ms - Times executed: 1 ]
[ Application: psql - unix(3158832@a2tech):8963 - Total duration: 17s395ms - Times executed: 1 ]
[ Application: psql - unix(3161392@a2tech):8963 - Total duration: 17s390ms - Times executed: 1 ]
[ Application: psql - unix(3168324@a2tech):8963 - Total duration: 17s361ms - Times executed: 1 ]
[ Application: psql - unix(3157971@a2tech):8963 - Total duration: 17s338ms - Times executed: 1 ]
[ Application: psql - unix(3156257@a2tech):8963 - Total duration: 17s333ms - Times executed: 1 ]
[ Application: psql - unix(3160531@a2tech):8963 - Total duration: 17s307ms - Times executed: 1 ]
[ Application: psql - unix(3163083@a2tech):8963 - Total duration: 17s201ms - Times executed: 1 ]
[ Application: psql - unix(3166555@a2tech):8963 - Total duration: 472ms - Times executed: 1 ]
[ Application: psql - unix(3155491@a2tech):8963 - Total duration: 461ms - Times executed: 1 ]
[ Application: psql - unix(3168365@a2tech):8963 - Total duration: 375ms - Times executed: 1 ]
[ Application: psql - unix(3165668@a2tech):8963 - Total duration: 365ms - Times executed: 1 ]
[ Application: psql - unix(3157134@a2tech):8963 - Total duration: 363ms - Times executed: 1 ]
[ Application: psql - unix(3164846@a2tech):8963 - Total duration: 354ms - Times executed: 1 ]
[ Application: psql - unix(3163955@a2tech):8963 - Total duration: 352ms - Times executed: 1 ]
[ Application: psql - unix(3158873@a2tech):8963 - Total duration: 351ms - Times executed: 1 ]
[ Application: psql - unix(3158017@a2tech):8963 - Total duration: 351ms - Times executed: 1 ]
[ Application: psql - unix(3160578@a2tech):8963 - Total duration: 348ms - Times executed: 1 ]
[ Application: psql - unix(3167414@a2tech):8963 - Total duration: 346ms - Times executed: 1 ]
[ Application: psql - unix(3162269@a2tech):8963 - Total duration: 346ms - Times executed: 1 ]
[ Application: psql - unix(3159724@a2tech):8963 - Total duration: 341ms - Times executed: 1 ]
[ Application: psql - unix(3163126@a2tech):8963 - Total duration: 341ms - Times executed: 1 ]
[ Application: psql - unix(3161433@a2tech):8963 - Total duration: 322ms - Times executed: 1 ]
[ Application: psql - unix(3156298@a2tech):8963 - Total duration: 318ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-02 07:11:03 Duration: 2m12s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3155462@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-02 20:10:57 Duration: 2m11s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3166523@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-02 22:10:47 Duration: 2m10s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3168336@a2tech):8963
3 4m10s 3 57s318ms 1m53s 1m23s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 02 05 3 4m10s 1m23s [ User: intelifix - Total duration: 4m10s - Times executed: 3 ]
[ Application: psql - unix(3153636@a2tech):8963 - Total duration: 1m53s - Times executed: 1 ]
[ Application: psql - unix(3153666@a2tech):8963 - Total duration: 1m19s - Times executed: 1 ]
[ Application: psql - unix(3153678@a2tech):8963 - Total duration: 57s318ms - Times executed: 1 ]
-
analyze verbose;
Date: 2026-05-02 05:01:54 Duration: 1m53s Database: rio User: intelifix Remote: [local] Application: psql - unix(3153636@a2tech):8963
-
analyze verbose;
Date: 2026-05-02 05:03:14 Duration: 1m19s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3153666@a2tech):8963
-
analyze verbose;
Date: 2026-05-02 05:04:11 Duration: 57s318ms Database: contagem User: intelifix Remote: [local] Application: psql - unix(3153678@a2tech):8963
4 2m34s 162 150ms 1s339ms 954ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 02 00 7 6s842ms 977ms 01 7 6s616ms 945ms 02 8 6s666ms 833ms 03 9 7s74ms 786ms 04 7 6s780ms 968ms 05 6 6s495ms 1s82ms 06 8 6s696ms 837ms 07 6 6s504ms 1s84ms 08 9 7s152ms 794ms 09 7 6s577ms 939ms 10 6 6s468ms 1s78ms 11 7 6s751ms 964ms 12 7 6s694ms 956ms 13 6 6s603ms 1s100ms 14 6 6s553ms 1s92ms 15 7 6s593ms 941ms 16 7 6s604ms 943ms 17 6 6s500ms 1s83ms 18 7 6s823ms 974ms 19 6 6s472ms 1s78ms 20 8 7s369ms 921ms 21 7 6s654ms 950ms 22 8 7s77ms 884ms [ User: intelifix - Total duration: 2m34s - Times executed: 162 ]
[ Application: psql - unix(3166443@a2tech):8963 - Total duration: 1s339ms - Times executed: 1 ]
[ Application: psql - unix(3149476@a2tech):8963 - Total duration: 1s331ms - Times executed: 1 ]
[ Application: psql - unix(3156201@a2tech):8963 - Total duration: 1s308ms - Times executed: 1 ]
[ Application: psql - unix(3160467@a2tech):8963 - Total duration: 1s294ms - Times executed: 1 ]
[ Application: psql - unix(3166608@a2tech):8963 - Total duration: 1s251ms - Times executed: 1 ]
[ Application: psql - unix(3168554@a2tech):8963 - Total duration: 1s243ms - Times executed: 1 ]
[ Application: psql - unix(3153183@a2tech):8963 - Total duration: 1s235ms - Times executed: 1 ]
[ Application: psql - unix(3162172@a2tech):8963 - Total duration: 1s227ms - Times executed: 1 ]
[ Application: psql - unix(3165290@a2tech):8963 - Total duration: 1s226ms - Times executed: 1 ]
[ Application: psql - unix(3163862@a2tech):8963 - Total duration: 1s209ms - Times executed: 1 ]
[ Application: psql - unix(3153720@a2tech):8963 - Total duration: 1s203ms - Times executed: 1 ]
[ Application: psql - unix(3157911@a2tech):8963 - Total duration: 1s201ms - Times executed: 1 ]
[ Application: psql - unix(3167122@a2tech):8963 - Total duration: 1s197ms - Times executed: 1 ]
[ Application: psql - unix(3155390@a2tech):8963 - Total duration: 1s193ms - Times executed: 1 ]
[ Application: psql - unix(3168676@a2tech):8963 - Total duration: 1s180ms - Times executed: 1 ]
[ Application: psql - unix(3152548@a2tech):8963 - Total duration: 1s179ms - Times executed: 1 ]
[ Application: psql - unix(3165158@a2tech):8963 - Total duration: 1s171ms - Times executed: 1 ]
[ Application: psql - unix(3161757@a2tech):8963 - Total duration: 1s167ms - Times executed: 1 ]
[ Application: psql - unix(3157038@a2tech):8963 - Total duration: 1s166ms - Times executed: 1 ]
[ Application: psql - unix(3164747@a2tech):8963 - Total duration: 1s165ms - Times executed: 1 ]
[ Application: psql - unix(3150622@a2tech):8963 - Total duration: 1s162ms - Times executed: 1 ]
[ Application: psql - unix(3158778@a2tech):8963 - Total duration: 1s157ms - Times executed: 1 ]
[ Application: psql - unix(3152153@a2tech):8963 - Total duration: 1s156ms - Times executed: 1 ]
[ Application: psql - unix(3161336@a2tech):8963 - Total duration: 1s155ms - Times executed: 1 ]
[ Application: psql - unix(3159915@a2tech):8963 - Total duration: 1s155ms - Times executed: 1 ]
[ Application: psql - unix(3149621@a2tech):8963 - Total duration: 1s140ms - Times executed: 1 ]
[ Application: psql - unix(3165566@a2tech):8963 - Total duration: 1s133ms - Times executed: 1 ]
[ Application: psql - unix(3159200@a2tech):8963 - Total duration: 1s131ms - Times executed: 1 ]
[ Application: psql - unix(3154993@a2tech):8963 - Total duration: 1s130ms - Times executed: 1 ]
[ Application: psql - unix(3163027@a2tech):8963 - Total duration: 1s127ms - Times executed: 1 ]
[ Application: psql - unix(3166864@a2tech):8963 - Total duration: 1s120ms - Times executed: 1 ]
[ Application: psql - unix(3168823@a2tech):8963 - Total duration: 1s119ms - Times executed: 1 ]
[ Application: psql - unix(3159785@a2tech):8963 - Total duration: 1s117ms - Times executed: 1 ]
[ Application: psql - unix(3167603@a2tech):8963 - Total duration: 1s113ms - Times executed: 1 ]
[ Application: psql - unix(3167468@a2tech):8963 - Total duration: 1s112ms - Times executed: 1 ]
[ Application: psql - unix(3156875@a2tech):8963 - Total duration: 1s108ms - Times executed: 1 ]
[ Application: psql - unix(3163582@a2tech):8963 - Total duration: 1s108ms - Times executed: 1 ]
[ Application: psql - unix(3152293@a2tech):8963 - Total duration: 1s106ms - Times executed: 1 ]
[ Application: psql - unix(3153317@a2tech):8963 - Total duration: 1s105ms - Times executed: 1 ]
[ Application: psql - unix(3161890@a2tech):8963 - Total duration: 1s103ms - Times executed: 1 ]
[ Application: psql - unix(3159621@a2tech):8963 - Total duration: 1s103ms - Times executed: 1 ]
[ Application: psql - unix(3168421@a2tech):8963 - Total duration: 1s101ms - Times executed: 1 ]
[ Application: psql - unix(3165860@a2tech):8963 - Total duration: 1s101ms - Times executed: 1 ]
[ Application: psql - unix(3158352@a2tech):8963 - Total duration: 1s100ms - Times executed: 1 ]
[ Application: psql - unix(3159464@a2tech):8963 - Total duration: 1s98ms - Times executed: 1 ]
[ Application: psql - unix(3153983@a2tech):8963 - Total duration: 1s98ms - Times executed: 1 ]
[ Application: psql - unix(3166998@a2tech):8963 - Total duration: 1s97ms - Times executed: 1 ]
[ Application: psql - unix(3155546@a2tech):8963 - Total duration: 1s96ms - Times executed: 1 ]
[ Application: psql - unix(3153067@a2tech):8963 - Total duration: 1s94ms - Times executed: 1 ]
[ Application: psql - unix(3150384@a2tech):8963 - Total duration: 1s93ms - Times executed: 1 ]
[ Application: psql - unix(3165734@a2tech):8963 - Total duration: 1s92ms - Times executed: 1 ]
[ Application: psql - unix(3161054@a2tech):8963 - Total duration: 1s89ms - Times executed: 1 ]
[ Application: psql - unix(3154697@a2tech):8963 - Total duration: 1s89ms - Times executed: 1 ]
[ Application: psql - unix(3168189@a2tech):8963 - Total duration: 1s85ms - Times executed: 1 ]
[ Application: psql - unix(3163440@a2tech):8963 - Total duration: 1s83ms - Times executed: 1 ]
[ Application: psql - unix(3151300@a2tech):8963 - Total duration: 1s83ms - Times executed: 1 ]
[ Application: psql - unix(3156614@a2tech):8963 - Total duration: 1s81ms - Times executed: 1 ]
[ Application: psql - unix(3151141@a2tech):8963 - Total duration: 1s81ms - Times executed: 1 ]
[ Application: psql - unix(3161177@a2tech):8963 - Total duration: 1s80ms - Times executed: 1 ]
[ Application: psql - unix(3155916@a2tech):8963 - Total duration: 1s78ms - Times executed: 1 ]
[ Application: psql - unix(3164012@a2tech):8963 - Total duration: 1s78ms - Times executed: 1 ]
[ Application: psql - unix(3157636@a2tech):8963 - Total duration: 1s76ms - Times executed: 1 ]
[ Application: psql - unix(3164302@a2tech):8963 - Total duration: 1s75ms - Times executed: 1 ]
[ Application: psql - unix(3167992@a2tech):8963 - Total duration: 1s75ms - Times executed: 1 ]
[ Application: psql - unix(3167315@a2tech):8963 - Total duration: 1s75ms - Times executed: 1 ]
[ Application: psql - unix(3156749@a2tech):8963 - Total duration: 1s72ms - Times executed: 1 ]
[ Application: psql - unix(3165992@a2tech):8963 - Total duration: 1s71ms - Times executed: 1 ]
[ Application: psql - unix(3156353@a2tech):8963 - Total duration: 1s71ms - Times executed: 1 ]
[ Application: psql - unix(3153439@a2tech):8963 - Total duration: 1s71ms - Times executed: 1 ]
[ Application: psql - unix(3157332@a2tech):8963 - Total duration: 1s70ms - Times executed: 1 ]
[ Application: psql - unix(3156031@a2tech):8963 - Total duration: 1s69ms - Times executed: 1 ]
[ Application: psql - unix(3159069@a2tech):8963 - Total duration: 1s68ms - Times executed: 1 ]
[ Application: psql - unix(3167869@a2tech):8963 - Total duration: 1s65ms - Times executed: 1 ]
[ Application: psql - unix(3160307@a2tech):8963 - Total duration: 1s64ms - Times executed: 1 ]
[ Application: psql - unix(3152934@a2tech):8963 - Total duration: 1s64ms - Times executed: 1 ]
[ Application: psql - unix(3149742@a2tech):8963 - Total duration: 1s63ms - Times executed: 1 ]
[ Application: psql - unix(3164144@a2tech):8963 - Total duration: 1s63ms - Times executed: 1 ]
[ Application: psql - unix(3151429@a2tech):8963 - Total duration: 1s63ms - Times executed: 1 ]
[ Application: psql - unix(3162596@a2tech):8963 - Total duration: 1s63ms - Times executed: 1 ]
[ Application: psql - unix(3153854@a2tech):8963 - Total duration: 1s61ms - Times executed: 1 ]
[ Application: psql - unix(3160796@a2tech):8963 - Total duration: 1s59ms - Times executed: 1 ]
[ Application: psql - unix(3167732@a2tech):8963 - Total duration: 1s59ms - Times executed: 1 ]
[ Application: psql - unix(3158937@a2tech):8963 - Total duration: 1s59ms - Times executed: 1 ]
[ Application: psql - unix(3161492@a2tech):8963 - Total duration: 1s59ms - Times executed: 1 ]
[ Application: psql - unix(3153561@a2tech):8963 - Total duration: 1s58ms - Times executed: 1 ]
[ Application: psql - unix(3165408@a2tech):8963 - Total duration: 1s57ms - Times executed: 1 ]
[ Application: psql - unix(3152671@a2tech):8963 - Total duration: 1s57ms - Times executed: 1 ]
[ Application: psql - unix(3150743@a2tech):8963 - Total duration: 1s57ms - Times executed: 1 ]
[ Application: psql - unix(3150500@a2tech):8963 - Total duration: 1s56ms - Times executed: 1 ]
[ Application: psql - unix(3155242@a2tech):8963 - Total duration: 1s53ms - Times executed: 1 ]
[ Application: psql - unix(3166128@a2tech):8963 - Total duration: 1s53ms - Times executed: 1 ]
[ Application: psql - unix(3154138@a2tech):8963 - Total duration: 1s53ms - Times executed: 1 ]
[ Application: psql - unix(3149867@a2tech):8963 - Total duration: 1s52ms - Times executed: 1 ]
[ Application: psql - unix(3157455@a2tech):8963 - Total duration: 1s50ms - Times executed: 1 ]
[ Application: psql - unix(3150256@a2tech):8963 - Total duration: 1s50ms - Times executed: 1 ]
[ Application: psql - unix(3155121@a2tech):8963 - Total duration: 1s49ms - Times executed: 1 ]
[ Application: psql - unix(3154565@a2tech):8963 - Total duration: 1s49ms - Times executed: 1 ]
[ Application: psql - unix(3160186@a2tech):8963 - Total duration: 1s48ms - Times executed: 1 ]
[ Application: psql - unix(3164578@a2tech):8963 - Total duration: 1s48ms - Times executed: 1 ]
[ Application: psql - unix(3156482@a2tech):8963 - Total duration: 1s47ms - Times executed: 1 ]
[ Application: psql - unix(3150118@a2tech):8963 - Total duration: 1s47ms - Times executed: 1 ]
[ Application: psql - unix(3151013@a2tech):8963 - Total duration: 1s46ms - Times executed: 1 ]
[ Application: psql - unix(3158076@a2tech):8963 - Total duration: 1s46ms - Times executed: 1 ]
[ Application: psql - unix(3152793@a2tech):8963 - Total duration: 1s46ms - Times executed: 1 ]
[ Application: psql - unix(3163186@a2tech):8963 - Total duration: 1s45ms - Times executed: 1 ]
[ Application: psql - unix(3160921@a2tech):8963 - Total duration: 1s45ms - Times executed: 1 ]
[ Application: psql - unix(3149992@a2tech):8963 - Total duration: 1s44ms - Times executed: 1 ]
[ Application: psql - unix(3151676@a2tech):8963 - Total duration: 1s43ms - Times executed: 1 ]
[ Application: psql - unix(3154374@a2tech):8963 - Total duration: 1s43ms - Times executed: 1 ]
[ Application: psql - unix(3158622@a2tech):8963 - Total duration: 1s42ms - Times executed: 1 ]
[ Application: psql - unix(3159345@a2tech):8963 - Total duration: 1s41ms - Times executed: 1 ]
[ Application: psql - unix(3160049@a2tech):8963 - Total duration: 1s41ms - Times executed: 1 ]
[ Application: psql - unix(3161625@a2tech):8963 - Total duration: 1s41ms - Times executed: 1 ]
[ Application: psql - unix(3158215@a2tech):8963 - Total duration: 1s40ms - Times executed: 1 ]
[ Application: psql - unix(3163316@a2tech):8963 - Total duration: 1s39ms - Times executed: 1 ]
[ Application: psql - unix(3152415@a2tech):8963 - Total duration: 1s39ms - Times executed: 1 ]
[ Application: psql - unix(3150862@a2tech):8963 - Total duration: 1s39ms - Times executed: 1 ]
[ Application: psql - unix(3162458@a2tech):8963 - Total duration: 1s38ms - Times executed: 1 ]
[ Application: psql - unix(3151554@a2tech):8963 - Total duration: 1s38ms - Times executed: 1 ]
[ Application: psql - unix(3162737@a2tech):8963 - Total duration: 1s37ms - Times executed: 1 ]
[ Application: psql - unix(3158493@a2tech):8963 - Total duration: 1s37ms - Times executed: 1 ]
[ Application: psql - unix(3162329@a2tech):8963 - Total duration: 1s36ms - Times executed: 1 ]
[ Application: psql - unix(3154258@a2tech):8963 - Total duration: 1s35ms - Times executed: 1 ]
[ Application: psql - unix(3160631@a2tech):8963 - Total duration: 1s34ms - Times executed: 1 ]
[ Application: psql - unix(3155666@a2tech):8963 - Total duration: 1s34ms - Times executed: 1 ]
[ Application: psql - unix(3168947@a2tech):8963 - Total duration: 1s34ms - Times executed: 1 ]
[ Application: psql - unix(3157189@a2tech):8963 - Total duration: 1s34ms - Times executed: 1 ]
[ Application: psql - unix(3155789@a2tech):8963 - Total duration: 1s31ms - Times executed: 1 ]
[ Application: psql - unix(3157757@a2tech):8963 - Total duration: 1s28ms - Times executed: 1 ]
[ Application: psql - unix(3162865@a2tech):8963 - Total duration: 1s28ms - Times executed: 1 ]
[ Application: psql - unix(3162007@a2tech):8963 - Total duration: 1s27ms - Times executed: 1 ]
[ Application: psql - unix(3164905@a2tech):8963 - Total duration: 1s25ms - Times executed: 1 ]
[ Application: psql - unix(3163705@a2tech):8963 - Total duration: 1s25ms - Times executed: 1 ]
[ Application: psql - unix(3164439@a2tech):8963 - Total duration: 1s23ms - Times executed: 1 ]
[ Application: psql - unix(3165035@a2tech):8963 - Total duration: 1s22ms - Times executed: 1 ]
[ Application: psql - unix(3166738@a2tech):8963 - Total duration: 1s22ms - Times executed: 1 ]
[ Application: psql - unix(3166247@a2tech):8963 - Total duration: 1s19ms - Times executed: 1 ]
[ Application: psql - unix(3154827@a2tech):8963 - Total duration: 1s16ms - Times executed: 1 ]
[ Application: psql - unix(3159077@a2tech):8963 - Total duration: 193ms - Times executed: 1 ]
[ Application: psql - unix(3166748@a2tech):8963 - Total duration: 184ms - Times executed: 1 ]
[ Application: psql - unix(3152166@a2tech):8963 - Total duration: 179ms - Times executed: 1 ]
[ Application: psql - unix(3163037@a2tech):8963 - Total duration: 174ms - Times executed: 1 ]
[ Application: psql - unix(3160060@a2tech):8963 - Total duration: 162ms - Times executed: 1 ]
[ Application: psql - unix(3149490@a2tech):8963 - Total duration: 162ms - Times executed: 1 ]
[ Application: psql - unix(3168688@a2tech):8963 - Total duration: 161ms - Times executed: 1 ]
[ Application: psql - unix(3162184@a2tech):8963 - Total duration: 160ms - Times executed: 1 ]
[ Application: psql - unix(3156212@a2tech):8963 - Total duration: 159ms - Times executed: 1 ]
[ Application: psql - unix(3150508@a2tech):8963 - Total duration: 158ms - Times executed: 1 ]
[ Application: psql - unix(3152304@a2tech):8963 - Total duration: 158ms - Times executed: 1 ]
[ Application: psql - unix(3166454@a2tech):8963 - Total duration: 155ms - Times executed: 1 ]
[ Application: psql - unix(3154578@a2tech):8963 - Total duration: 155ms - Times executed: 1 ]
[ Application: psql - unix(3151309@a2tech):8963 - Total duration: 154ms - Times executed: 1 ]
[ Application: psql - unix(3165043@a2tech):8963 - Total duration: 154ms - Times executed: 1 ]
[ Application: psql - unix(3151684@a2tech):8963 - Total duration: 153ms - Times executed: 1 ]
[ Application: psql - unix(3155250@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
[ Application: psql - unix(3167616@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
[ Application: psql - unix(3156361@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
[ Application: psql - unix(3157340@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
[ Application: psql - unix(3168955@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
[ Application: psql - unix(3153193@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
[ Application: psql - unix(3152560@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
[ Application: psql - unix(3156491@a2tech):8963 - Total duration: 150ms - Times executed: 1 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-02 20:05:03 Duration: 1s339ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3166443@a2tech):8963
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-02 00:05:03 Duration: 1s331ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3149476@a2tech):8963
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-02 08:05:04 Duration: 1s308ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3156201@a2tech):8963
5 1m44s 4 2s85ms 50s352ms 26s9ms 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 02 20 2 51s488ms 25s744ms 23 2 52s550ms 26s275ms [ User: intelifix - Total duration: 1m44s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m44s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-02 23:29:22 Duration: 50s352ms 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-02 20:06:31 Duration: 49s403ms 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-02 23:37:47 Duration: 2s197ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 1m36s 3 14s177ms 1m2s 32s153ms 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 02 23 3 1m36s 32s153ms [ 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-02 23:11:48 Duration: 1m2s 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-02 23:30:32 Duration: 20s25ms 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-02 23:38:27 Duration: 14s177ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 1m24s 4 274ms 43s36ms 21s51ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 02 20 2 40s893ms 20s446ms 23 2 43s313ms 21s656ms [ 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-02 23:15:21 Duration: 43s36ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-02 20:04:30 Duration: 40s619ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-02 23:31:23 Duration: 276ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m20s 3 13s9ms 50s913ms 26s739ms 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 02 23 3 1m20s 26s739ms [ User: intelifix - Total duration: 1m20s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m20s - 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-02 23:12:39 Duration: 50s913ms 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-02 23:30:48 Duration: 16s296ms 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-02 23:38:40 Duration: 13s9ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 1m13s 3 11s418ms 44s270ms 24s600ms 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 02 23 3 1m13s 24s600ms [ 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-02 23:10:46 Duration: 44s270ms 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-02 23:30:12 Duration: 18s112ms 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-02 23:38:13 Duration: 11s418ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1m9s 6 1s581ms 27s177ms 11s504ms 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 02 20 3 32s980ms 10s993ms 23 3 36s47ms 12s15ms [ 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-02 23:15:49 Duration: 27s177ms 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-02 20:04:56 Duration: 24s538ms 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-02 23:31:30 Duration: 7s181ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 57s340ms 6 1s176ms 23s2ms 9s556ms 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 02 20 3 27s331ms 9s110ms 23 3 30s9ms 10s3ms [ User: intelifix - Total duration: 57s340ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s340ms - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-02 23:16:14 Duration: 23s2ms 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-02 20:05:19 Duration: 20s975ms 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-02 23:31:36 Duration: 5s699ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 57s89ms 6 2s284ms 22s860ms 9s514ms 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 02 20 3 27s351ms 9s117ms 23 3 29s738ms 9s912ms [ User: intelifix - Total duration: 57s89ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s89ms - 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-02 23:29:45 Duration: 22s860ms 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-02 20:06:53 Duration: 21s26ms 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-02 23:37:52 Duration: 4s374ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 47s172ms 6 1s111ms 16s929ms 7s862ms 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 02 20 3 22s632ms 7s544ms 23 3 24s539ms 8s179ms [ User: intelifix - Total duration: 47s172ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 47s172ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-02 23:13:39 Duration: 16s929ms 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-02 20:02:56 Duration: 15s494ms 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-02 23:31:09 Duration: 6s419ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 46s945ms 6 1s201ms 16s170ms 7s824ms 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 02 20 3 22s613ms 7s537ms 23 3 24s332ms 8s110ms [ User: intelifix - Total duration: 46s945ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 46s945ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-02 23:13:10 Duration: 16s170ms 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-02 20:02:30 Duration: 15s58ms 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-02 23:31:01 Duration: 6s863ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 45s670ms 1 45s670ms 45s670ms 45s670ms refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 02 05 1 45s670ms 45s670ms [ User: intelifix - Total duration: 45s670ms - Times executed: 1 ]
[ Application: psql - unix(3154076@a2tech):8963 - Total duration: 45s670ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-02 05:31:09 Duration: 45s670ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3154076@a2tech):8963
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-02 05:31:03 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3154076@a2tech):8963
16 41s264ms 6 827ms 17s360ms 6s877ms 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 #16
Day Hour Count Duration Avg duration May 02 20 3 19s712ms 6s570ms 23 3 21s552ms 7s184ms [ User: intelifix - Total duration: 41s264ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s264ms - 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-02 23:14:21 Duration: 17s360ms 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-02 20:03:35 Duration: 15s882ms 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-02 23:31:20 Duration: 3s284ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 37s146ms 4 2s489ms 16s801ms 9s286ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 02 20 2 17s655ms 8s827ms 23 2 19s490ms 9s745ms [ User: intelifix - Total duration: 37s146ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 37s146ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-02 23:14:38 Duration: 16s801ms 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-02 20:03:50 Duration: 15s166ms 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-02 23:31:22 Duration: 2s689ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 35s436ms 6 898ms 12s244ms 5s906ms 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 #18
Day Hour Count Duration Avg duration May 02 20 3 16s672ms 5s557ms 23 3 18s763ms 6s254ms [ User: intelifix - Total duration: 35s436ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s436ms - 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-02 23:13:51 Duration: 12s244ms 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-02 20:03:07 Duration: 10s910ms 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-02 23:31:15 Duration: 5s521ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 31s992ms 3 226ms 27s386ms 10s664ms copy public.posicao_oficina_26 (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 #19
Day Hour Count Duration Avg duration May 02 23 3 31s992ms 10s664ms [ User: intelifix - Total duration: 31s992ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 31s992ms - Times executed: 3 ]
-
COPY public.posicao_oficina_26 (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-02 23:27:34 Duration: 27s386ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.posicao_oficina_26 (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-02 23:37:18 Duration: 4s378ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.posicao_oficina_26 (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-02 23:39:08 Duration: 226ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 26s713ms 6 491ms 11s705ms 4s452ms 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 02 20 3 12s899ms 4s299ms 23 3 13s813ms 4s604ms [ User: intelifix - Total duration: 26s713ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 26s713ms - 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-02 23:13:22 Duration: 11s705ms 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-02 20:02:41 Duration: 10s977ms 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-02 23:31:03 Duration: 1s571ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 162 2m34s 150ms 1s339ms 954ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 02 00 7 6s842ms 977ms 01 7 6s616ms 945ms 02 8 6s666ms 833ms 03 9 7s74ms 786ms 04 7 6s780ms 968ms 05 6 6s495ms 1s82ms 06 8 6s696ms 837ms 07 6 6s504ms 1s84ms 08 9 7s152ms 794ms 09 7 6s577ms 939ms 10 6 6s468ms 1s78ms 11 7 6s751ms 964ms 12 7 6s694ms 956ms 13 6 6s603ms 1s100ms 14 6 6s553ms 1s92ms 15 7 6s593ms 941ms 16 7 6s604ms 943ms 17 6 6s500ms 1s83ms 18 7 6s823ms 974ms 19 6 6s472ms 1s78ms 20 8 7s369ms 921ms 21 7 6s654ms 950ms 22 8 7s77ms 884ms [ User: intelifix - Total duration: 2m34s - Times executed: 162 ]
[ Application: psql - unix(3166443@a2tech):8963 - Total duration: 1s339ms - Times executed: 1 ]
[ Application: psql - unix(3149476@a2tech):8963 - Total duration: 1s331ms - Times executed: 1 ]
[ Application: psql - unix(3156201@a2tech):8963 - Total duration: 1s308ms - Times executed: 1 ]
[ Application: psql - unix(3160467@a2tech):8963 - Total duration: 1s294ms - Times executed: 1 ]
[ Application: psql - unix(3166608@a2tech):8963 - Total duration: 1s251ms - Times executed: 1 ]
[ Application: psql - unix(3168554@a2tech):8963 - Total duration: 1s243ms - Times executed: 1 ]
[ Application: psql - unix(3153183@a2tech):8963 - Total duration: 1s235ms - Times executed: 1 ]
[ Application: psql - unix(3162172@a2tech):8963 - Total duration: 1s227ms - Times executed: 1 ]
[ Application: psql - unix(3165290@a2tech):8963 - Total duration: 1s226ms - Times executed: 1 ]
[ Application: psql - unix(3163862@a2tech):8963 - Total duration: 1s209ms - Times executed: 1 ]
[ Application: psql - unix(3153720@a2tech):8963 - Total duration: 1s203ms - Times executed: 1 ]
[ Application: psql - unix(3157911@a2tech):8963 - Total duration: 1s201ms - Times executed: 1 ]
[ Application: psql - unix(3167122@a2tech):8963 - Total duration: 1s197ms - Times executed: 1 ]
[ Application: psql - unix(3155390@a2tech):8963 - Total duration: 1s193ms - Times executed: 1 ]
[ Application: psql - unix(3168676@a2tech):8963 - Total duration: 1s180ms - Times executed: 1 ]
[ Application: psql - unix(3152548@a2tech):8963 - Total duration: 1s179ms - Times executed: 1 ]
[ Application: psql - unix(3165158@a2tech):8963 - Total duration: 1s171ms - Times executed: 1 ]
[ Application: psql - unix(3161757@a2tech):8963 - Total duration: 1s167ms - Times executed: 1 ]
[ Application: psql - unix(3157038@a2tech):8963 - Total duration: 1s166ms - Times executed: 1 ]
[ Application: psql - unix(3164747@a2tech):8963 - Total duration: 1s165ms - Times executed: 1 ]
[ Application: psql - unix(3150622@a2tech):8963 - Total duration: 1s162ms - Times executed: 1 ]
[ Application: psql - unix(3158778@a2tech):8963 - Total duration: 1s157ms - Times executed: 1 ]
[ Application: psql - unix(3152153@a2tech):8963 - Total duration: 1s156ms - Times executed: 1 ]
[ Application: psql - unix(3161336@a2tech):8963 - Total duration: 1s155ms - Times executed: 1 ]
[ Application: psql - unix(3159915@a2tech):8963 - Total duration: 1s155ms - Times executed: 1 ]
[ Application: psql - unix(3149621@a2tech):8963 - Total duration: 1s140ms - Times executed: 1 ]
[ Application: psql - unix(3165566@a2tech):8963 - Total duration: 1s133ms - Times executed: 1 ]
[ Application: psql - unix(3159200@a2tech):8963 - Total duration: 1s131ms - Times executed: 1 ]
[ Application: psql - unix(3154993@a2tech):8963 - Total duration: 1s130ms - Times executed: 1 ]
[ Application: psql - unix(3163027@a2tech):8963 - Total duration: 1s127ms - Times executed: 1 ]
[ Application: psql - unix(3166864@a2tech):8963 - Total duration: 1s120ms - Times executed: 1 ]
[ Application: psql - unix(3168823@a2tech):8963 - Total duration: 1s119ms - Times executed: 1 ]
[ Application: psql - unix(3159785@a2tech):8963 - Total duration: 1s117ms - Times executed: 1 ]
[ Application: psql - unix(3167603@a2tech):8963 - Total duration: 1s113ms - Times executed: 1 ]
[ Application: psql - unix(3167468@a2tech):8963 - Total duration: 1s112ms - Times executed: 1 ]
[ Application: psql - unix(3156875@a2tech):8963 - Total duration: 1s108ms - Times executed: 1 ]
[ Application: psql - unix(3163582@a2tech):8963 - Total duration: 1s108ms - Times executed: 1 ]
[ Application: psql - unix(3152293@a2tech):8963 - Total duration: 1s106ms - Times executed: 1 ]
[ Application: psql - unix(3153317@a2tech):8963 - Total duration: 1s105ms - Times executed: 1 ]
[ Application: psql - unix(3161890@a2tech):8963 - Total duration: 1s103ms - Times executed: 1 ]
[ Application: psql - unix(3159621@a2tech):8963 - Total duration: 1s103ms - Times executed: 1 ]
[ Application: psql - unix(3168421@a2tech):8963 - Total duration: 1s101ms - Times executed: 1 ]
[ Application: psql - unix(3165860@a2tech):8963 - Total duration: 1s101ms - Times executed: 1 ]
[ Application: psql - unix(3158352@a2tech):8963 - Total duration: 1s100ms - Times executed: 1 ]
[ Application: psql - unix(3159464@a2tech):8963 - Total duration: 1s98ms - Times executed: 1 ]
[ Application: psql - unix(3153983@a2tech):8963 - Total duration: 1s98ms - Times executed: 1 ]
[ Application: psql - unix(3166998@a2tech):8963 - Total duration: 1s97ms - Times executed: 1 ]
[ Application: psql - unix(3155546@a2tech):8963 - Total duration: 1s96ms - Times executed: 1 ]
[ Application: psql - unix(3153067@a2tech):8963 - Total duration: 1s94ms - Times executed: 1 ]
[ Application: psql - unix(3150384@a2tech):8963 - Total duration: 1s93ms - Times executed: 1 ]
[ Application: psql - unix(3165734@a2tech):8963 - Total duration: 1s92ms - Times executed: 1 ]
[ Application: psql - unix(3161054@a2tech):8963 - Total duration: 1s89ms - Times executed: 1 ]
[ Application: psql - unix(3154697@a2tech):8963 - Total duration: 1s89ms - Times executed: 1 ]
[ Application: psql - unix(3168189@a2tech):8963 - Total duration: 1s85ms - Times executed: 1 ]
[ Application: psql - unix(3163440@a2tech):8963 - Total duration: 1s83ms - Times executed: 1 ]
[ Application: psql - unix(3151300@a2tech):8963 - Total duration: 1s83ms - Times executed: 1 ]
[ Application: psql - unix(3156614@a2tech):8963 - Total duration: 1s81ms - Times executed: 1 ]
[ Application: psql - unix(3151141@a2tech):8963 - Total duration: 1s81ms - Times executed: 1 ]
[ Application: psql - unix(3161177@a2tech):8963 - Total duration: 1s80ms - Times executed: 1 ]
[ Application: psql - unix(3155916@a2tech):8963 - Total duration: 1s78ms - Times executed: 1 ]
[ Application: psql - unix(3164012@a2tech):8963 - Total duration: 1s78ms - Times executed: 1 ]
[ Application: psql - unix(3157636@a2tech):8963 - Total duration: 1s76ms - Times executed: 1 ]
[ Application: psql - unix(3164302@a2tech):8963 - Total duration: 1s75ms - Times executed: 1 ]
[ Application: psql - unix(3167992@a2tech):8963 - Total duration: 1s75ms - Times executed: 1 ]
[ Application: psql - unix(3167315@a2tech):8963 - Total duration: 1s75ms - Times executed: 1 ]
[ Application: psql - unix(3156749@a2tech):8963 - Total duration: 1s72ms - Times executed: 1 ]
[ Application: psql - unix(3165992@a2tech):8963 - Total duration: 1s71ms - Times executed: 1 ]
[ Application: psql - unix(3156353@a2tech):8963 - Total duration: 1s71ms - Times executed: 1 ]
[ Application: psql - unix(3153439@a2tech):8963 - Total duration: 1s71ms - Times executed: 1 ]
[ Application: psql - unix(3157332@a2tech):8963 - Total duration: 1s70ms - Times executed: 1 ]
[ Application: psql - unix(3156031@a2tech):8963 - Total duration: 1s69ms - Times executed: 1 ]
[ Application: psql - unix(3159069@a2tech):8963 - Total duration: 1s68ms - Times executed: 1 ]
[ Application: psql - unix(3167869@a2tech):8963 - Total duration: 1s65ms - Times executed: 1 ]
[ Application: psql - unix(3160307@a2tech):8963 - Total duration: 1s64ms - Times executed: 1 ]
[ Application: psql - unix(3152934@a2tech):8963 - Total duration: 1s64ms - Times executed: 1 ]
[ Application: psql - unix(3149742@a2tech):8963 - Total duration: 1s63ms - Times executed: 1 ]
[ Application: psql - unix(3164144@a2tech):8963 - Total duration: 1s63ms - Times executed: 1 ]
[ Application: psql - unix(3151429@a2tech):8963 - Total duration: 1s63ms - Times executed: 1 ]
[ Application: psql - unix(3162596@a2tech):8963 - Total duration: 1s63ms - Times executed: 1 ]
[ Application: psql - unix(3153854@a2tech):8963 - Total duration: 1s61ms - Times executed: 1 ]
[ Application: psql - unix(3160796@a2tech):8963 - Total duration: 1s59ms - Times executed: 1 ]
[ Application: psql - unix(3167732@a2tech):8963 - Total duration: 1s59ms - Times executed: 1 ]
[ Application: psql - unix(3158937@a2tech):8963 - Total duration: 1s59ms - Times executed: 1 ]
[ Application: psql - unix(3161492@a2tech):8963 - Total duration: 1s59ms - Times executed: 1 ]
[ Application: psql - unix(3153561@a2tech):8963 - Total duration: 1s58ms - Times executed: 1 ]
[ Application: psql - unix(3165408@a2tech):8963 - Total duration: 1s57ms - Times executed: 1 ]
[ Application: psql - unix(3152671@a2tech):8963 - Total duration: 1s57ms - Times executed: 1 ]
[ Application: psql - unix(3150743@a2tech):8963 - Total duration: 1s57ms - Times executed: 1 ]
[ Application: psql - unix(3150500@a2tech):8963 - Total duration: 1s56ms - Times executed: 1 ]
[ Application: psql - unix(3155242@a2tech):8963 - Total duration: 1s53ms - Times executed: 1 ]
[ Application: psql - unix(3166128@a2tech):8963 - Total duration: 1s53ms - Times executed: 1 ]
[ Application: psql - unix(3154138@a2tech):8963 - Total duration: 1s53ms - Times executed: 1 ]
[ Application: psql - unix(3149867@a2tech):8963 - Total duration: 1s52ms - Times executed: 1 ]
[ Application: psql - unix(3157455@a2tech):8963 - Total duration: 1s50ms - Times executed: 1 ]
[ Application: psql - unix(3150256@a2tech):8963 - Total duration: 1s50ms - Times executed: 1 ]
[ Application: psql - unix(3155121@a2tech):8963 - Total duration: 1s49ms - Times executed: 1 ]
[ Application: psql - unix(3154565@a2tech):8963 - Total duration: 1s49ms - Times executed: 1 ]
[ Application: psql - unix(3160186@a2tech):8963 - Total duration: 1s48ms - Times executed: 1 ]
[ Application: psql - unix(3164578@a2tech):8963 - Total duration: 1s48ms - Times executed: 1 ]
[ Application: psql - unix(3156482@a2tech):8963 - Total duration: 1s47ms - Times executed: 1 ]
[ Application: psql - unix(3150118@a2tech):8963 - Total duration: 1s47ms - Times executed: 1 ]
[ Application: psql - unix(3151013@a2tech):8963 - Total duration: 1s46ms - Times executed: 1 ]
[ Application: psql - unix(3158076@a2tech):8963 - Total duration: 1s46ms - Times executed: 1 ]
[ Application: psql - unix(3152793@a2tech):8963 - Total duration: 1s46ms - Times executed: 1 ]
[ Application: psql - unix(3163186@a2tech):8963 - Total duration: 1s45ms - Times executed: 1 ]
[ Application: psql - unix(3160921@a2tech):8963 - Total duration: 1s45ms - Times executed: 1 ]
[ Application: psql - unix(3149992@a2tech):8963 - Total duration: 1s44ms - Times executed: 1 ]
[ Application: psql - unix(3151676@a2tech):8963 - Total duration: 1s43ms - Times executed: 1 ]
[ Application: psql - unix(3154374@a2tech):8963 - Total duration: 1s43ms - Times executed: 1 ]
[ Application: psql - unix(3158622@a2tech):8963 - Total duration: 1s42ms - Times executed: 1 ]
[ Application: psql - unix(3159345@a2tech):8963 - Total duration: 1s41ms - Times executed: 1 ]
[ Application: psql - unix(3160049@a2tech):8963 - Total duration: 1s41ms - Times executed: 1 ]
[ Application: psql - unix(3161625@a2tech):8963 - Total duration: 1s41ms - Times executed: 1 ]
[ Application: psql - unix(3158215@a2tech):8963 - Total duration: 1s40ms - Times executed: 1 ]
[ Application: psql - unix(3163316@a2tech):8963 - Total duration: 1s39ms - Times executed: 1 ]
[ Application: psql - unix(3152415@a2tech):8963 - Total duration: 1s39ms - Times executed: 1 ]
[ Application: psql - unix(3150862@a2tech):8963 - Total duration: 1s39ms - Times executed: 1 ]
[ Application: psql - unix(3162458@a2tech):8963 - Total duration: 1s38ms - Times executed: 1 ]
[ Application: psql - unix(3151554@a2tech):8963 - Total duration: 1s38ms - Times executed: 1 ]
[ Application: psql - unix(3162737@a2tech):8963 - Total duration: 1s37ms - Times executed: 1 ]
[ Application: psql - unix(3158493@a2tech):8963 - Total duration: 1s37ms - Times executed: 1 ]
[ Application: psql - unix(3162329@a2tech):8963 - Total duration: 1s36ms - Times executed: 1 ]
[ Application: psql - unix(3154258@a2tech):8963 - Total duration: 1s35ms - Times executed: 1 ]
[ Application: psql - unix(3160631@a2tech):8963 - Total duration: 1s34ms - Times executed: 1 ]
[ Application: psql - unix(3155666@a2tech):8963 - Total duration: 1s34ms - Times executed: 1 ]
[ Application: psql - unix(3168947@a2tech):8963 - Total duration: 1s34ms - Times executed: 1 ]
[ Application: psql - unix(3157189@a2tech):8963 - Total duration: 1s34ms - Times executed: 1 ]
[ Application: psql - unix(3155789@a2tech):8963 - Total duration: 1s31ms - Times executed: 1 ]
[ Application: psql - unix(3157757@a2tech):8963 - Total duration: 1s28ms - Times executed: 1 ]
[ Application: psql - unix(3162865@a2tech):8963 - Total duration: 1s28ms - Times executed: 1 ]
[ Application: psql - unix(3162007@a2tech):8963 - Total duration: 1s27ms - Times executed: 1 ]
[ Application: psql - unix(3164905@a2tech):8963 - Total duration: 1s25ms - Times executed: 1 ]
[ Application: psql - unix(3163705@a2tech):8963 - Total duration: 1s25ms - Times executed: 1 ]
[ Application: psql - unix(3164439@a2tech):8963 - Total duration: 1s23ms - Times executed: 1 ]
[ Application: psql - unix(3165035@a2tech):8963 - Total duration: 1s22ms - Times executed: 1 ]
[ Application: psql - unix(3166738@a2tech):8963 - Total duration: 1s22ms - Times executed: 1 ]
[ Application: psql - unix(3166247@a2tech):8963 - Total duration: 1s19ms - Times executed: 1 ]
[ Application: psql - unix(3154827@a2tech):8963 - Total duration: 1s16ms - Times executed: 1 ]
[ Application: psql - unix(3159077@a2tech):8963 - Total duration: 193ms - Times executed: 1 ]
[ Application: psql - unix(3166748@a2tech):8963 - Total duration: 184ms - Times executed: 1 ]
[ Application: psql - unix(3152166@a2tech):8963 - Total duration: 179ms - Times executed: 1 ]
[ Application: psql - unix(3163037@a2tech):8963 - Total duration: 174ms - Times executed: 1 ]
[ Application: psql - unix(3160060@a2tech):8963 - Total duration: 162ms - Times executed: 1 ]
[ Application: psql - unix(3149490@a2tech):8963 - Total duration: 162ms - Times executed: 1 ]
[ Application: psql - unix(3168688@a2tech):8963 - Total duration: 161ms - Times executed: 1 ]
[ Application: psql - unix(3162184@a2tech):8963 - Total duration: 160ms - Times executed: 1 ]
[ Application: psql - unix(3156212@a2tech):8963 - Total duration: 159ms - Times executed: 1 ]
[ Application: psql - unix(3150508@a2tech):8963 - Total duration: 158ms - Times executed: 1 ]
[ Application: psql - unix(3152304@a2tech):8963 - Total duration: 158ms - Times executed: 1 ]
[ Application: psql - unix(3166454@a2tech):8963 - Total duration: 155ms - Times executed: 1 ]
[ Application: psql - unix(3154578@a2tech):8963 - Total duration: 155ms - Times executed: 1 ]
[ Application: psql - unix(3151309@a2tech):8963 - Total duration: 154ms - Times executed: 1 ]
[ Application: psql - unix(3165043@a2tech):8963 - Total duration: 154ms - Times executed: 1 ]
[ Application: psql - unix(3151684@a2tech):8963 - Total duration: 153ms - Times executed: 1 ]
[ Application: psql - unix(3155250@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
[ Application: psql - unix(3167616@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
[ Application: psql - unix(3156361@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
[ Application: psql - unix(3157340@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
[ Application: psql - unix(3168955@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
[ Application: psql - unix(3153193@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
[ Application: psql - unix(3152560@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
[ Application: psql - unix(3156491@a2tech):8963 - Total duration: 150ms - Times executed: 1 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-02 20:05:03 Duration: 1s339ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3166443@a2tech):8963
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-02 00:05:03 Duration: 1s331ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3149476@a2tech):8963
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-02 08:05:04 Duration: 1s308ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3156201@a2tech):8963
2 48 52m19s 513ms 3m17s 1m5s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 02 07 3 3m28s 1m9s 08 3 3m15s 1m5s 09 3 3m15s 1m5s 10 3 3m15s 1m5s 11 3 3m14s 1m4s 12 3 3m13s 1m4s 13 3 3m16s 1m5s 14 3 3m13s 1m4s 15 3 3m14s 1m4s 16 3 3m12s 1m4s 17 3 3m13s 1m4s 18 3 3m15s 1m5s 19 3 3m15s 1m5s 20 3 3m23s 1m7s 21 3 3m16s 1m5s 22 3 3m15s 1m5s [ User: intelifix - Total duration: 52m19s - Times executed: 48 ]
[ Application: psql - unix(3155383@a2tech):8963 - Total duration: 3m17s - Times executed: 1 ]
[ Application: psql - unix(3166435@a2tech):8963 - Total duration: 3m13s - Times executed: 1 ]
[ Application: psql - unix(3167311@a2tech):8963 - Total duration: 3m7s - Times executed: 1 ]
[ Application: psql - unix(3160458@a2tech):8963 - Total duration: 3m7s - Times executed: 1 ]
[ Application: psql - unix(3157907@a2tech):8963 - Total duration: 3m6s - Times executed: 1 ]
[ Application: psql - unix(3157033@a2tech):8963 - Total duration: 3m6s - Times executed: 1 ]
[ Application: psql - unix(3156194@a2tech):8963 - Total duration: 3m6s - Times executed: 1 ]
[ Application: psql - unix(3165567@a2tech):8963 - Total duration: 3m6s - Times executed: 1 ]
[ Application: psql - unix(3168156@a2tech):8963 - Total duration: 3m6s - Times executed: 1 ]
[ Application: psql - unix(3164739@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3158774@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3162169@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3159613@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3163853@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3161337@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3163019@a2tech):8963 - Total duration: 3m3s - Times executed: 1 ]
[ Application: psql - unix(3155455@a2tech):8963 - Total duration: 10s204ms - Times executed: 1 ]
[ Application: psql - unix(3166518@a2tech):8963 - Total duration: 9s6ms - Times executed: 1 ]
[ Application: psql - unix(3168332@a2tech):8963 - Total duration: 8s921ms - Times executed: 1 ]
[ Application: psql - unix(3164811@a2tech):8963 - Total duration: 8s835ms - Times executed: 1 ]
[ Application: psql - unix(3157980@a2tech):8963 - Total duration: 8s618ms - Times executed: 1 ]
[ Application: psql - unix(3162236@a2tech):8963 - Total duration: 8s423ms - Times executed: 1 ]
[ Application: psql - unix(3157100@a2tech):8963 - Total duration: 8s386ms - Times executed: 1 ]
[ Application: psql - unix(3156265@a2tech):8963 - Total duration: 8s358ms - Times executed: 1 ]
[ Application: psql - unix(3163923@a2tech):8963 - Total duration: 8s331ms - Times executed: 1 ]
[ Application: psql - unix(3158839@a2tech):8963 - Total duration: 8s312ms - Times executed: 1 ]
[ Application: psql - unix(3159688@a2tech):8963 - Total duration: 8s305ms - Times executed: 1 ]
[ Application: psql - unix(3165633@a2tech):8963 - Total duration: 8s302ms - Times executed: 1 ]
[ Application: psql - unix(3161399@a2tech):8963 - Total duration: 8s297ms - Times executed: 1 ]
[ Application: psql - unix(3167378@a2tech):8963 - Total duration: 8s281ms - Times executed: 1 ]
[ Application: psql - unix(3163090@a2tech):8963 - Total duration: 8s269ms - Times executed: 1 ]
[ Application: psql - unix(3160537@a2tech):8963 - Total duration: 8s269ms - Times executed: 1 ]
[ Application: psql - unix(3155486@a2tech):8963 - Total duration: 871ms - Times executed: 1 ]
[ Application: psql - unix(3166551@a2tech):8963 - Total duration: 746ms - Times executed: 1 ]
[ Application: psql - unix(3157130@a2tech):8963 - Total duration: 577ms - Times executed: 1 ]
[ Application: psql - unix(3167410@a2tech):8963 - Total duration: 563ms - Times executed: 1 ]
[ Application: psql - unix(3164841@a2tech):8963 - Total duration: 558ms - Times executed: 1 ]
[ Application: psql - unix(3161430@a2tech):8963 - Total duration: 553ms - Times executed: 1 ]
[ Application: psql - unix(3159719@a2tech):8963 - Total duration: 549ms - Times executed: 1 ]
[ Application: psql - unix(3163951@a2tech):8963 - Total duration: 544ms - Times executed: 1 ]
[ Application: psql - unix(3158013@a2tech):8963 - Total duration: 542ms - Times executed: 1 ]
[ Application: psql - unix(3162264@a2tech):8963 - Total duration: 540ms - Times executed: 1 ]
[ Application: psql - unix(3165664@a2tech):8963 - Total duration: 537ms - Times executed: 1 ]
[ Application: psql - unix(3168362@a2tech):8963 - Total duration: 537ms - Times executed: 1 ]
[ Application: psql - unix(3160572@a2tech):8963 - Total duration: 533ms - Times executed: 1 ]
[ Application: psql - unix(3158869@a2tech):8963 - Total duration: 524ms - Times executed: 1 ]
[ Application: psql - unix(3156295@a2tech):8963 - Total duration: 520ms - Times executed: 1 ]
[ Application: psql - unix(3163122@a2tech):8963 - Total duration: 513ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-02 07:08:20 Duration: 3m17s Database: rio User: intelifix Remote: [local] Application: psql - unix(3155383@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-02 20:08:15 Duration: 3m13s Database: rio User: intelifix Remote: [local] Application: psql - unix(3166435@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-02 21:08:10 Duration: 3m7s Database: rio User: intelifix Remote: [local] Application: psql - unix(3167311@a2tech):8963
3 48 39m33s 318ms 2m12s 49s454ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 02 07 3 2m32s 50s844ms 08 3 2m27s 49s265ms 09 3 2m28s 49s561ms 10 3 2m27s 49s27ms 11 3 2m27s 49s77ms 12 3 2m27s 49s202ms 13 3 2m27s 49s189ms 14 3 2m27s 49s261ms 15 3 2m28s 49s394ms 16 3 2m27s 49s111ms 17 3 2m27s 49s286ms 18 3 2m27s 49s155ms 19 3 2m27s 49s222ms 20 3 2m32s 50s803ms 21 3 2m27s 49s300ms 22 3 2m28s 49s569ms [ User: intelifix - Total duration: 39m33s - Times executed: 48 ]
[ Application: psql - unix(3155462@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(3166523@a2tech):8963 - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - unix(3168336@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3157105@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3162241@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3156271@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3167381@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3163927@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3161404@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3160546@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3159693@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3163094@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3165637@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3158846@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3164816@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3157985@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3166509@a2tech):8963 - Total duration: 20s198ms - Times executed: 1 ]
[ Application: psql - unix(3155448@a2tech):8963 - Total duration: 19s871ms - Times executed: 1 ]
[ Application: psql - unix(3164803@a2tech):8963 - Total duration: 17s658ms - Times executed: 1 ]
[ Application: psql - unix(3165623@a2tech):8963 - Total duration: 17s533ms - Times executed: 1 ]
[ Application: psql - unix(3157091@a2tech):8963 - Total duration: 17s446ms - Times executed: 1 ]
[ Application: psql - unix(3167371@a2tech):8963 - Total duration: 17s444ms - Times executed: 1 ]
[ Application: psql - unix(3163916@a2tech):8963 - Total duration: 17s426ms - Times executed: 1 ]
[ Application: psql - unix(3159681@a2tech):8963 - Total duration: 17s425ms - Times executed: 1 ]
[ Application: psql - unix(3162228@a2tech):8963 - Total duration: 17s420ms - Times executed: 1 ]
[ Application: psql - unix(3158832@a2tech):8963 - Total duration: 17s395ms - Times executed: 1 ]
[ Application: psql - unix(3161392@a2tech):8963 - Total duration: 17s390ms - Times executed: 1 ]
[ Application: psql - unix(3168324@a2tech):8963 - Total duration: 17s361ms - Times executed: 1 ]
[ Application: psql - unix(3157971@a2tech):8963 - Total duration: 17s338ms - Times executed: 1 ]
[ Application: psql - unix(3156257@a2tech):8963 - Total duration: 17s333ms - Times executed: 1 ]
[ Application: psql - unix(3160531@a2tech):8963 - Total duration: 17s307ms - Times executed: 1 ]
[ Application: psql - unix(3163083@a2tech):8963 - Total duration: 17s201ms - Times executed: 1 ]
[ Application: psql - unix(3166555@a2tech):8963 - Total duration: 472ms - Times executed: 1 ]
[ Application: psql - unix(3155491@a2tech):8963 - Total duration: 461ms - Times executed: 1 ]
[ Application: psql - unix(3168365@a2tech):8963 - Total duration: 375ms - Times executed: 1 ]
[ Application: psql - unix(3165668@a2tech):8963 - Total duration: 365ms - Times executed: 1 ]
[ Application: psql - unix(3157134@a2tech):8963 - Total duration: 363ms - Times executed: 1 ]
[ Application: psql - unix(3164846@a2tech):8963 - Total duration: 354ms - Times executed: 1 ]
[ Application: psql - unix(3163955@a2tech):8963 - Total duration: 352ms - Times executed: 1 ]
[ Application: psql - unix(3158873@a2tech):8963 - Total duration: 351ms - Times executed: 1 ]
[ Application: psql - unix(3158017@a2tech):8963 - Total duration: 351ms - Times executed: 1 ]
[ Application: psql - unix(3160578@a2tech):8963 - Total duration: 348ms - Times executed: 1 ]
[ Application: psql - unix(3167414@a2tech):8963 - Total duration: 346ms - Times executed: 1 ]
[ Application: psql - unix(3162269@a2tech):8963 - Total duration: 346ms - Times executed: 1 ]
[ Application: psql - unix(3159724@a2tech):8963 - Total duration: 341ms - Times executed: 1 ]
[ Application: psql - unix(3163126@a2tech):8963 - Total duration: 341ms - Times executed: 1 ]
[ Application: psql - unix(3161433@a2tech):8963 - Total duration: 322ms - Times executed: 1 ]
[ Application: psql - unix(3156298@a2tech):8963 - Total duration: 318ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-02 07:11:03 Duration: 2m12s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3155462@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-02 20:10:57 Duration: 2m11s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3166523@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-02 22:10:47 Duration: 2m10s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3168336@a2tech):8963
4 32 7s432ms 154ms 643ms 232ms 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 #4
Day Hour Count Duration Avg duration May 02 08 3 1s151ms 383ms 09 2 384ms 192ms 10 1 268ms 268ms 11 2 485ms 242ms 12 2 480ms 240ms 13 1 218ms 218ms 14 3 657ms 219ms 15 2 392ms 196ms 16 1 228ms 228ms 17 2 396ms 198ms 18 2 473ms 236ms 19 2 315ms 157ms 20 3 700ms 233ms 21 3 612ms 204ms 22 3 667ms 222ms [ User: intelifix - Total duration: 7s432ms - Times executed: 32 ]
[ Application: psql - unix(3156108@a2tech):8963 - Total duration: 643ms - Times executed: 1 ]
[ Application: psql - unix(3168492@a2tech):8963 - Total duration: 281ms - Times executed: 1 ]
[ Application: psql - unix(3166681@a2tech):8963 - Total duration: 277ms - Times executed: 1 ]
[ Application: psql - unix(3158432@a2tech):8963 - Total duration: 268ms - Times executed: 1 ]
[ Application: psql - unix(3159279@a2tech):8963 - Total duration: 265ms - Times executed: 1 ]
[ Application: psql - unix(3161568@a2tech):8963 - Total duration: 258ms - Times executed: 1 ]
[ Application: psql - unix(3166937@a2tech):8963 - Total duration: 257ms - Times executed: 1 ]
[ Application: psql - unix(3156423@a2tech):8963 - Total duration: 254ms - Times executed: 1 ]
[ Application: psql - unix(3156690@a2tech):8963 - Total duration: 253ms - Times executed: 1 ]
[ Application: psql - unix(3164652@a2tech):8963 - Total duration: 250ms - Times executed: 1 ]
[ Application: psql - unix(3159536@a2tech):8963 - Total duration: 242ms - Times executed: 1 ]
[ Application: psql - unix(3161828@a2tech):8963 - Total duration: 242ms - Times executed: 1 ]
[ Application: psql - unix(3159859@a2tech):8963 - Total duration: 237ms - Times executed: 1 ]
[ Application: psql - unix(3162396@a2tech):8963 - Total duration: 236ms - Times executed: 1 ]
[ Application: psql - unix(3164084@a2tech):8963 - Total duration: 235ms - Times executed: 1 ]
[ Application: psql - unix(3167810@a2tech):8963 - Total duration: 230ms - Times executed: 1 ]
[ Application: psql - unix(3168761@a2tech):8963 - Total duration: 230ms - Times executed: 1 ]
[ Application: psql - unix(3163254@a2tech):8963 - Total duration: 228ms - Times executed: 1 ]
[ Application: psql - unix(3157569@a2tech):8963 - Total duration: 227ms - Times executed: 1 ]
[ Application: psql - unix(3167540@a2tech):8963 - Total duration: 226ms - Times executed: 1 ]
[ Application: psql - unix(3165229@a2tech):8963 - Total duration: 223ms - Times executed: 1 ]
[ Application: psql - unix(3159014@a2tech):8963 - Total duration: 219ms - Times executed: 1 ]
[ Application: psql - unix(3160698@a2tech):8963 - Total duration: 218ms - Times executed: 1 ]
[ Application: psql - unix(3166331@a2tech):8963 - Total duration: 164ms - Times executed: 1 ]
[ Application: psql - unix(3166063@a2tech):8963 - Total duration: 161ms - Times executed: 1 ]
[ Application: psql - unix(3163775@a2tech):8963 - Total duration: 160ms - Times executed: 1 ]
[ Application: psql - unix(3156947@a2tech):8963 - Total duration: 156ms - Times executed: 1 ]
[ Application: psql - unix(3161253@a2tech):8963 - Total duration: 156ms - Times executed: 1 ]
[ Application: psql - unix(3162674@a2tech):8963 - Total duration: 155ms - Times executed: 1 ]
[ Application: psql - unix(3167193@a2tech):8963 - Total duration: 155ms - Times executed: 1 ]
[ Application: psql - unix(3168065@a2tech):8963 - Total duration: 155ms - Times executed: 1 ]
[ Application: psql - unix(3165477@a2tech):8963 - Total duration: 154ms - 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-02 08:00:02 Duration: 643ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3156108@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-02 22:20:01 Duration: 281ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3168492@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-02 20:20:01 Duration: 277ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3166681@a2tech):8963
5 30 6s813ms 195ms 254ms 227ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 02 08 2 481ms 240ms 09 3 678ms 226ms 10 3 680ms 226ms 11 1 216ms 216ms 12 1 221ms 221ms 13 3 724ms 241ms 14 1 220ms 220ms 15 2 420ms 210ms 16 3 678ms 226ms 17 1 222ms 222ms 18 3 661ms 220ms 19 3 724ms 241ms 20 1 227ms 227ms 21 2 455ms 227ms 22 1 200ms 200ms [ User: intelifix - Total duration: 6s813ms - Times executed: 30 ]
[ Application: psql - unix(3156110@a2tech):8963 - Total duration: 254ms - Times executed: 1 ]
[ Application: psql - unix(3160993@a2tech):8963 - Total duration: 251ms - Times executed: 1 ]
[ Application: psql - unix(3160995@a2tech):8963 - Total duration: 250ms - Times executed: 1 ]
[ Application: psql - unix(3165803@a2tech):8963 - Total duration: 249ms - Times executed: 1 ]
[ Application: psql - unix(3165805@a2tech):8963 - Total duration: 246ms - Times executed: 1 ]
[ Application: psql - unix(3162941@a2tech):8963 - Total duration: 239ms - Times executed: 1 ]
[ Application: psql - unix(3167812@a2tech):8963 - Total duration: 237ms - Times executed: 1 ]
[ Application: psql - unix(3162938@a2tech):8963 - Total duration: 236ms - Times executed: 1 ]
[ Application: psql - unix(3157256@a2tech):8963 - Total duration: 236ms - Times executed: 1 ]
[ Application: psql - unix(3164975@a2tech):8963 - Total duration: 234ms - Times executed: 1 ]
[ Application: psql - unix(3158434@a2tech):8963 - Total duration: 229ms - Times executed: 1 ]
[ Application: psql - unix(3157258@a2tech):8963 - Total duration: 229ms - Times executed: 1 ]
[ Application: psql - unix(3158147@a2tech):8963 - Total duration: 229ms - Times executed: 1 ]
[ Application: psql - unix(3166067@a2tech):8963 - Total duration: 228ms - Times executed: 1 ]
[ Application: psql - unix(3166939@a2tech):8963 - Total duration: 227ms - Times executed: 1 ]
[ Application: psql - unix(3156425@a2tech):8963 - Total duration: 227ms - Times executed: 1 ]
[ Application: psql - unix(3162079@a2tech):8963 - Total duration: 225ms - Times executed: 1 ]
[ Application: psql - unix(3160383@a2tech):8963 - Total duration: 223ms - Times executed: 1 ]
[ Application: psql - unix(3164086@a2tech):8963 - Total duration: 222ms - Times executed: 1 ]
[ Application: psql - unix(3158145@a2tech):8963 - Total duration: 221ms - Times executed: 1 ]
[ Application: psql - unix(3160123@a2tech):8963 - Total duration: 221ms - Times executed: 1 ]
[ Application: psql - unix(3161255@a2tech):8963 - Total duration: 220ms - Times executed: 1 ]
[ Application: psql - unix(3164977@a2tech):8963 - Total duration: 219ms - Times executed: 1 ]
[ Application: psql - unix(3167542@a2tech):8963 - Total duration: 218ms - Times executed: 1 ]
[ Application: psql - unix(3159281@a2tech):8963 - Total duration: 216ms - Times executed: 1 ]
[ Application: psql - unix(3157571@a2tech):8963 - Total duration: 211ms - Times executed: 1 ]
[ Application: psql - unix(3165231@a2tech):8963 - Total duration: 207ms - Times executed: 1 ]
[ Application: psql - unix(3163256@a2tech):8963 - Total duration: 201ms - Times executed: 1 ]
[ Application: psql - unix(3168763@a2tech):8963 - Total duration: 200ms - Times executed: 1 ]
[ Application: psql - unix(3162399@a2tech):8963 - Total duration: 195ms - Times executed: 1 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-02 08:00:02 Duration: 254ms Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3156110@a2tech):8963
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-02 13:40:02 Duration: 251ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3160993@a2tech):8963
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-02 13:40:02 Duration: 250ms Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3160995@a2tech):8963
6 6 1m9s 1s581ms 27s177ms 11s504ms 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 #6
Day Hour Count Duration Avg duration May 02 20 3 32s980ms 10s993ms 23 3 36s47ms 12s15ms [ 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-02 23:15:49 Duration: 27s177ms 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-02 20:04:56 Duration: 24s538ms 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-02 23:31:30 Duration: 7s181ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 6 57s340ms 1s176ms 23s2ms 9s556ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 02 20 3 27s331ms 9s110ms 23 3 30s9ms 10s3ms [ User: intelifix - Total duration: 57s340ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s340ms - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-02 23:16:14 Duration: 23s2ms 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-02 20:05:19 Duration: 20s975ms 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-02 23:31:36 Duration: 5s699ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 6 57s89ms 2s284ms 22s860ms 9s514ms 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 #8
Day Hour Count Duration Avg duration May 02 20 3 27s351ms 9s117ms 23 3 29s738ms 9s912ms [ User: intelifix - Total duration: 57s89ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s89ms - 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-02 23:29:45 Duration: 22s860ms 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-02 20:06:53 Duration: 21s26ms 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-02 23:37:52 Duration: 4s374ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 6 47s172ms 1s111ms 16s929ms 7s862ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 02 20 3 22s632ms 7s544ms 23 3 24s539ms 8s179ms [ User: intelifix - Total duration: 47s172ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 47s172ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-02 23:13:39 Duration: 16s929ms 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-02 20:02:56 Duration: 15s494ms 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-02 23:31:09 Duration: 6s419ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 6 46s945ms 1s201ms 16s170ms 7s824ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 02 20 3 22s613ms 7s537ms 23 3 24s332ms 8s110ms [ User: intelifix - Total duration: 46s945ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 46s945ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-02 23:13:10 Duration: 16s170ms 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-02 20:02:30 Duration: 15s58ms 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-02 23:31:01 Duration: 6s863ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 41s264ms 827ms 17s360ms 6s877ms 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 #11
Day Hour Count Duration Avg duration May 02 20 3 19s712ms 6s570ms 23 3 21s552ms 7s184ms [ User: intelifix - Total duration: 41s264ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s264ms - 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-02 23:14:21 Duration: 17s360ms 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-02 20:03:35 Duration: 15s882ms 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-02 23:31:20 Duration: 3s284ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 6 35s436ms 898ms 12s244ms 5s906ms 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 #12
Day Hour Count Duration Avg duration May 02 20 3 16s672ms 5s557ms 23 3 18s763ms 6s254ms [ User: intelifix - Total duration: 35s436ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s436ms - 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-02 23:13:51 Duration: 12s244ms 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-02 20:03:07 Duration: 10s910ms 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-02 23:31:15 Duration: 5s521ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 26s713ms 491ms 11s705ms 4s452ms 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 #13
Day Hour Count Duration Avg duration May 02 20 3 12s899ms 4s299ms 23 3 13s813ms 4s604ms [ User: intelifix - Total duration: 26s713ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 26s713ms - 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-02 23:13:22 Duration: 11s705ms 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-02 20:02:41 Duration: 10s977ms 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-02 23:31:03 Duration: 1s571ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 19s498ms 431ms 9s199ms 3s249ms 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 #14
Day Hour Count Duration Avg duration May 02 20 3 9s347ms 3s115ms 23 3 10s150ms 3s383ms [ User: intelifix - Total duration: 19s498ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 19s498ms - 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-02 23:14:04 Duration: 9s199ms 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-02 20:03:19 Duration: 8s460ms 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-02 23:31:16 Duration: 487ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 18s558ms 492ms 7s619ms 3s93ms 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 #15
Day Hour Count Duration Avg duration May 02 20 3 8s963ms 2s987ms 23 3 9s594ms 3s198ms [ User: intelifix - Total duration: 18s558ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 18s558ms - 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-02 23:12:52 Duration: 7s619ms 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-02 20:02:13 Duration: 7s103ms 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-02 23:30:54 Duration: 1s445ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 18s422ms 1s810ms 4s533ms 3s70ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 02 00 3 12s526ms 4s175ms 06 3 5s895ms 1s965ms [ User: intelifix - Total duration: 18s422ms - Times executed: 6 ]
[ Application: psql - unix(3149473@a2tech):8963 - Total duration: 4s533ms - Times executed: 1 ]
[ Application: psql - unix(3149509@a2tech):8963 - Total duration: 4s229ms - Times executed: 1 ]
[ Application: psql - unix(3149508@a2tech):8963 - Total duration: 3s763ms - Times executed: 1 ]
[ Application: psql - unix(3154567@a2tech):8963 - Total duration: 2s82ms - Times executed: 1 ]
[ Application: psql - unix(3154598@a2tech):8963 - Total duration: 2s2ms - Times executed: 1 ]
[ Application: psql - unix(3154590@a2tech):8963 - Total duration: 1s810ms - Times executed: 1 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-02 00:05:06 Duration: 4s533ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3149473@a2tech):8963
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-02 00:05:14 Duration: 4s229ms Database: contagem User: intelifix Remote: [local] Application: psql - unix(3149509@a2tech):8963
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-02 00:05:10 Duration: 3s763ms Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3149508@a2tech):8963
17 6 17s200ms 1s500ms 3s713ms 2s866ms 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 #17
Day Hour Count Duration Avg duration May 02 20 3 8s278ms 2s759ms 23 3 8s921ms 2s973ms [ User: intelifix - Total duration: 17s200ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 17s200ms - 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-02 23:28:22 Duration: 3s713ms 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-02 23:37:44 Duration: 3s529ms Database: brasilia 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-02 20:05:34 Duration: 3s483ms Database: rio User: intelifix Remote: [local] Application: pg_dump
18 6 12s224ms 1s939ms 2s132ms 2s37ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 02 20 3 5s876ms 1s958ms 23 3 6s347ms 2s115ms [ User: intelifix - Total duration: 12s224ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 12s224ms - Times executed: 6 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-02 23:12:43 Duration: 2s132ms Database: rio 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-02 23:30:52 Duration: 2s115ms 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-02 23:38:43 Duration: 2s99ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 6 8s992ms 231ms 3s84ms 1s498ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 02 20 3 4s339ms 1s446ms 23 3 4s653ms 1s551ms [ User: intelifix - Total duration: 8s992ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 8s992ms - 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-02 23:13:54 Duration: 3s84ms 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-02 20:03:10 Duration: 2s903ms 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-02 23:31:16 Duration: 1s319ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 5s337ms 855ms 937ms 889ms copy ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 02 20 3 2s571ms 857ms 23 3 2s766ms 922ms [ User: intelifix - Total duration: 5s337ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 5s337ms - Times executed: 6 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-02 23:12:41 Duration: 937ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-02 23:38:41 Duration: 914ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-02 23:30:50 Duration: 914ms 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 57s318ms 1m53s 1m23s 3 4m10s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 02 05 3 4m10s 1m23s [ User: intelifix - Total duration: 4m10s - Times executed: 3 ]
[ Application: psql - unix(3153636@a2tech):8963 - Total duration: 1m53s - Times executed: 1 ]
[ Application: psql - unix(3153666@a2tech):8963 - Total duration: 1m19s - Times executed: 1 ]
[ Application: psql - unix(3153678@a2tech):8963 - Total duration: 57s318ms - Times executed: 1 ]
-
analyze verbose;
Date: 2026-05-02 05:01:54 Duration: 1m53s Database: rio User: intelifix Remote: [local] Application: psql - unix(3153636@a2tech):8963
-
analyze verbose;
Date: 2026-05-02 05:03:14 Duration: 1m19s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3153666@a2tech):8963
-
analyze verbose;
Date: 2026-05-02 05:04:11 Duration: 57s318ms Database: contagem User: intelifix Remote: [local] Application: psql - unix(3153678@a2tech):8963
2 513ms 3m17s 1m5s 48 52m19s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 02 07 3 3m28s 1m9s 08 3 3m15s 1m5s 09 3 3m15s 1m5s 10 3 3m15s 1m5s 11 3 3m14s 1m4s 12 3 3m13s 1m4s 13 3 3m16s 1m5s 14 3 3m13s 1m4s 15 3 3m14s 1m4s 16 3 3m12s 1m4s 17 3 3m13s 1m4s 18 3 3m15s 1m5s 19 3 3m15s 1m5s 20 3 3m23s 1m7s 21 3 3m16s 1m5s 22 3 3m15s 1m5s [ User: intelifix - Total duration: 52m19s - Times executed: 48 ]
[ Application: psql - unix(3155383@a2tech):8963 - Total duration: 3m17s - Times executed: 1 ]
[ Application: psql - unix(3166435@a2tech):8963 - Total duration: 3m13s - Times executed: 1 ]
[ Application: psql - unix(3167311@a2tech):8963 - Total duration: 3m7s - Times executed: 1 ]
[ Application: psql - unix(3160458@a2tech):8963 - Total duration: 3m7s - Times executed: 1 ]
[ Application: psql - unix(3157907@a2tech):8963 - Total duration: 3m6s - Times executed: 1 ]
[ Application: psql - unix(3157033@a2tech):8963 - Total duration: 3m6s - Times executed: 1 ]
[ Application: psql - unix(3156194@a2tech):8963 - Total duration: 3m6s - Times executed: 1 ]
[ Application: psql - unix(3165567@a2tech):8963 - Total duration: 3m6s - Times executed: 1 ]
[ Application: psql - unix(3168156@a2tech):8963 - Total duration: 3m6s - Times executed: 1 ]
[ Application: psql - unix(3164739@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3158774@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3162169@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3159613@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3163853@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3161337@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3163019@a2tech):8963 - Total duration: 3m3s - Times executed: 1 ]
[ Application: psql - unix(3155455@a2tech):8963 - Total duration: 10s204ms - Times executed: 1 ]
[ Application: psql - unix(3166518@a2tech):8963 - Total duration: 9s6ms - Times executed: 1 ]
[ Application: psql - unix(3168332@a2tech):8963 - Total duration: 8s921ms - Times executed: 1 ]
[ Application: psql - unix(3164811@a2tech):8963 - Total duration: 8s835ms - Times executed: 1 ]
[ Application: psql - unix(3157980@a2tech):8963 - Total duration: 8s618ms - Times executed: 1 ]
[ Application: psql - unix(3162236@a2tech):8963 - Total duration: 8s423ms - Times executed: 1 ]
[ Application: psql - unix(3157100@a2tech):8963 - Total duration: 8s386ms - Times executed: 1 ]
[ Application: psql - unix(3156265@a2tech):8963 - Total duration: 8s358ms - Times executed: 1 ]
[ Application: psql - unix(3163923@a2tech):8963 - Total duration: 8s331ms - Times executed: 1 ]
[ Application: psql - unix(3158839@a2tech):8963 - Total duration: 8s312ms - Times executed: 1 ]
[ Application: psql - unix(3159688@a2tech):8963 - Total duration: 8s305ms - Times executed: 1 ]
[ Application: psql - unix(3165633@a2tech):8963 - Total duration: 8s302ms - Times executed: 1 ]
[ Application: psql - unix(3161399@a2tech):8963 - Total duration: 8s297ms - Times executed: 1 ]
[ Application: psql - unix(3167378@a2tech):8963 - Total duration: 8s281ms - Times executed: 1 ]
[ Application: psql - unix(3163090@a2tech):8963 - Total duration: 8s269ms - Times executed: 1 ]
[ Application: psql - unix(3160537@a2tech):8963 - Total duration: 8s269ms - Times executed: 1 ]
[ Application: psql - unix(3155486@a2tech):8963 - Total duration: 871ms - Times executed: 1 ]
[ Application: psql - unix(3166551@a2tech):8963 - Total duration: 746ms - Times executed: 1 ]
[ Application: psql - unix(3157130@a2tech):8963 - Total duration: 577ms - Times executed: 1 ]
[ Application: psql - unix(3167410@a2tech):8963 - Total duration: 563ms - Times executed: 1 ]
[ Application: psql - unix(3164841@a2tech):8963 - Total duration: 558ms - Times executed: 1 ]
[ Application: psql - unix(3161430@a2tech):8963 - Total duration: 553ms - Times executed: 1 ]
[ Application: psql - unix(3159719@a2tech):8963 - Total duration: 549ms - Times executed: 1 ]
[ Application: psql - unix(3163951@a2tech):8963 - Total duration: 544ms - Times executed: 1 ]
[ Application: psql - unix(3158013@a2tech):8963 - Total duration: 542ms - Times executed: 1 ]
[ Application: psql - unix(3162264@a2tech):8963 - Total duration: 540ms - Times executed: 1 ]
[ Application: psql - unix(3165664@a2tech):8963 - Total duration: 537ms - Times executed: 1 ]
[ Application: psql - unix(3168362@a2tech):8963 - Total duration: 537ms - Times executed: 1 ]
[ Application: psql - unix(3160572@a2tech):8963 - Total duration: 533ms - Times executed: 1 ]
[ Application: psql - unix(3158869@a2tech):8963 - Total duration: 524ms - Times executed: 1 ]
[ Application: psql - unix(3156295@a2tech):8963 - Total duration: 520ms - Times executed: 1 ]
[ Application: psql - unix(3163122@a2tech):8963 - Total duration: 513ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-02 07:08:20 Duration: 3m17s Database: rio User: intelifix Remote: [local] Application: psql - unix(3155383@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-02 20:08:15 Duration: 3m13s Database: rio User: intelifix Remote: [local] Application: psql - unix(3166435@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-02 21:08:10 Duration: 3m7s Database: rio User: intelifix Remote: [local] Application: psql - unix(3167311@a2tech):8963
3 318ms 2m12s 49s454ms 48 39m33s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 02 07 3 2m32s 50s844ms 08 3 2m27s 49s265ms 09 3 2m28s 49s561ms 10 3 2m27s 49s27ms 11 3 2m27s 49s77ms 12 3 2m27s 49s202ms 13 3 2m27s 49s189ms 14 3 2m27s 49s261ms 15 3 2m28s 49s394ms 16 3 2m27s 49s111ms 17 3 2m27s 49s286ms 18 3 2m27s 49s155ms 19 3 2m27s 49s222ms 20 3 2m32s 50s803ms 21 3 2m27s 49s300ms 22 3 2m28s 49s569ms [ User: intelifix - Total duration: 39m33s - Times executed: 48 ]
[ Application: psql - unix(3155462@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(3166523@a2tech):8963 - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - unix(3168336@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3157105@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3162241@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3156271@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3167381@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3163927@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3161404@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3160546@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3159693@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3163094@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3165637@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3158846@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3164816@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3157985@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3166509@a2tech):8963 - Total duration: 20s198ms - Times executed: 1 ]
[ Application: psql - unix(3155448@a2tech):8963 - Total duration: 19s871ms - Times executed: 1 ]
[ Application: psql - unix(3164803@a2tech):8963 - Total duration: 17s658ms - Times executed: 1 ]
[ Application: psql - unix(3165623@a2tech):8963 - Total duration: 17s533ms - Times executed: 1 ]
[ Application: psql - unix(3157091@a2tech):8963 - Total duration: 17s446ms - Times executed: 1 ]
[ Application: psql - unix(3167371@a2tech):8963 - Total duration: 17s444ms - Times executed: 1 ]
[ Application: psql - unix(3163916@a2tech):8963 - Total duration: 17s426ms - Times executed: 1 ]
[ Application: psql - unix(3159681@a2tech):8963 - Total duration: 17s425ms - Times executed: 1 ]
[ Application: psql - unix(3162228@a2tech):8963 - Total duration: 17s420ms - Times executed: 1 ]
[ Application: psql - unix(3158832@a2tech):8963 - Total duration: 17s395ms - Times executed: 1 ]
[ Application: psql - unix(3161392@a2tech):8963 - Total duration: 17s390ms - Times executed: 1 ]
[ Application: psql - unix(3168324@a2tech):8963 - Total duration: 17s361ms - Times executed: 1 ]
[ Application: psql - unix(3157971@a2tech):8963 - Total duration: 17s338ms - Times executed: 1 ]
[ Application: psql - unix(3156257@a2tech):8963 - Total duration: 17s333ms - Times executed: 1 ]
[ Application: psql - unix(3160531@a2tech):8963 - Total duration: 17s307ms - Times executed: 1 ]
[ Application: psql - unix(3163083@a2tech):8963 - Total duration: 17s201ms - Times executed: 1 ]
[ Application: psql - unix(3166555@a2tech):8963 - Total duration: 472ms - Times executed: 1 ]
[ Application: psql - unix(3155491@a2tech):8963 - Total duration: 461ms - Times executed: 1 ]
[ Application: psql - unix(3168365@a2tech):8963 - Total duration: 375ms - Times executed: 1 ]
[ Application: psql - unix(3165668@a2tech):8963 - Total duration: 365ms - Times executed: 1 ]
[ Application: psql - unix(3157134@a2tech):8963 - Total duration: 363ms - Times executed: 1 ]
[ Application: psql - unix(3164846@a2tech):8963 - Total duration: 354ms - Times executed: 1 ]
[ Application: psql - unix(3163955@a2tech):8963 - Total duration: 352ms - Times executed: 1 ]
[ Application: psql - unix(3158873@a2tech):8963 - Total duration: 351ms - Times executed: 1 ]
[ Application: psql - unix(3158017@a2tech):8963 - Total duration: 351ms - Times executed: 1 ]
[ Application: psql - unix(3160578@a2tech):8963 - Total duration: 348ms - Times executed: 1 ]
[ Application: psql - unix(3167414@a2tech):8963 - Total duration: 346ms - Times executed: 1 ]
[ Application: psql - unix(3162269@a2tech):8963 - Total duration: 346ms - Times executed: 1 ]
[ Application: psql - unix(3159724@a2tech):8963 - Total duration: 341ms - Times executed: 1 ]
[ Application: psql - unix(3163126@a2tech):8963 - Total duration: 341ms - Times executed: 1 ]
[ Application: psql - unix(3161433@a2tech):8963 - Total duration: 322ms - Times executed: 1 ]
[ Application: psql - unix(3156298@a2tech):8963 - Total duration: 318ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-02 07:11:03 Duration: 2m12s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3155462@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-02 20:10:57 Duration: 2m11s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3166523@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-02 22:10:47 Duration: 2m10s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3168336@a2tech):8963
4 45s670ms 45s670ms 45s670ms 1 45s670ms refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 02 05 1 45s670ms 45s670ms [ User: intelifix - Total duration: 45s670ms - Times executed: 1 ]
[ Application: psql - unix(3154076@a2tech):8963 - Total duration: 45s670ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-02 05:31:09 Duration: 45s670ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3154076@a2tech):8963
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-02 05:31:03 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3154076@a2tech):8963
5 14s177ms 1m2s 32s153ms 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 02 23 3 1m36s 32s153ms [ 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-02 23:11:48 Duration: 1m2s 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-02 23:30:32 Duration: 20s25ms 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-02 23:38:27 Duration: 14s177ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 13s9ms 50s913ms 26s739ms 3 1m20s 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 02 23 3 1m20s 26s739ms [ User: intelifix - Total duration: 1m20s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m20s - 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-02 23:12:39 Duration: 50s913ms 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-02 23:30:48 Duration: 16s296ms 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-02 23:38:40 Duration: 13s9ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 2s85ms 50s352ms 26s9ms 4 1m44s 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 02 20 2 51s488ms 25s744ms 23 2 52s550ms 26s275ms [ User: intelifix - Total duration: 1m44s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m44s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-02 23:29:22 Duration: 50s352ms 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-02 20:06:31 Duration: 49s403ms 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-02 23:37:47 Duration: 2s197ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 11s418ms 44s270ms 24s600ms 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 02 23 3 1m13s 24s600ms [ 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-02 23:10:46 Duration: 44s270ms 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-02 23:30:12 Duration: 18s112ms 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-02 23:38:13 Duration: 11s418ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 274ms 43s36ms 21s51ms 4 1m24s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 02 20 2 40s893ms 20s446ms 23 2 43s313ms 21s656ms [ 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-02 23:15:21 Duration: 43s36ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-02 20:04:30 Duration: 40s619ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-02 23:31:23 Duration: 276ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 1s581ms 27s177ms 11s504ms 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 #10
Day Hour Count Duration Avg duration May 02 20 3 32s980ms 10s993ms 23 3 36s47ms 12s15ms [ 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-02 23:15:49 Duration: 27s177ms 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-02 20:04:56 Duration: 24s538ms 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-02 23:31:30 Duration: 7s181ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 226ms 27s386ms 10s664ms 3 31s992ms copy public.posicao_oficina_26 (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 #11
Day Hour Count Duration Avg duration May 02 23 3 31s992ms 10s664ms [ User: intelifix - Total duration: 31s992ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 31s992ms - Times executed: 3 ]
-
COPY public.posicao_oficina_26 (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-02 23:27:34 Duration: 27s386ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.posicao_oficina_26 (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-02 23:37:18 Duration: 4s378ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.posicao_oficina_26 (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-02 23:39:08 Duration: 226ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 1s176ms 23s2ms 9s556ms 6 57s340ms 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 02 20 3 27s331ms 9s110ms 23 3 30s9ms 10s3ms [ User: intelifix - Total duration: 57s340ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s340ms - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-02 23:16:14 Duration: 23s2ms 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-02 20:05:19 Duration: 20s975ms 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-02 23:31:36 Duration: 5s699ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s284ms 22s860ms 9s514ms 6 57s89ms 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 02 20 3 27s351ms 9s117ms 23 3 29s738ms 9s912ms [ User: intelifix - Total duration: 57s89ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s89ms - 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-02 23:29:45 Duration: 22s860ms 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-02 20:06:53 Duration: 21s26ms 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-02 23:37:52 Duration: 4s374ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 2s489ms 16s801ms 9s286ms 4 37s146ms 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 02 20 2 17s655ms 8s827ms 23 2 19s490ms 9s745ms [ User: intelifix - Total duration: 37s146ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 37s146ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-02 23:14:38 Duration: 16s801ms 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-02 20:03:50 Duration: 15s166ms 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-02 23:31:22 Duration: 2s689ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1s111ms 16s929ms 7s862ms 6 47s172ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 02 20 3 22s632ms 7s544ms 23 3 24s539ms 8s179ms [ User: intelifix - Total duration: 47s172ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 47s172ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-02 23:13:39 Duration: 16s929ms 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-02 20:02:56 Duration: 15s494ms 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-02 23:31:09 Duration: 6s419ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1s201ms 16s170ms 7s824ms 6 46s945ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 02 20 3 22s613ms 7s537ms 23 3 24s332ms 8s110ms [ User: intelifix - Total duration: 46s945ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 46s945ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-02 23:13:10 Duration: 16s170ms 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-02 20:02:30 Duration: 15s58ms 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-02 23:31:01 Duration: 6s863ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 827ms 17s360ms 6s877ms 6 41s264ms 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 02 20 3 19s712ms 6s570ms 23 3 21s552ms 7s184ms [ User: intelifix - Total duration: 41s264ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s264ms - 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-02 23:14:21 Duration: 17s360ms 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-02 20:03:35 Duration: 15s882ms 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-02 23:31:20 Duration: 3s284ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 898ms 12s244ms 5s906ms 6 35s436ms 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 #18
Day Hour Count Duration Avg duration May 02 20 3 16s672ms 5s557ms 23 3 18s763ms 6s254ms [ User: intelifix - Total duration: 35s436ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s436ms - 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-02 23:13:51 Duration: 12s244ms 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-02 20:03:07 Duration: 10s910ms 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-02 23:31:15 Duration: 5s521ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 491ms 11s705ms 4s452ms 6 26s713ms 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 #19
Day Hour Count Duration Avg duration May 02 20 3 12s899ms 4s299ms 23 3 13s813ms 4s604ms [ User: intelifix - Total duration: 26s713ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 26s713ms - 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-02 23:13:22 Duration: 11s705ms 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-02 20:02:41 Duration: 10s977ms 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-02 23:31:03 Duration: 1s571ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 431ms 9s199ms 3s249ms 6 19s498ms 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 #20
Day Hour Count Duration Avg duration May 02 20 3 9s347ms 3s115ms 23 3 10s150ms 3s383ms [ User: intelifix - Total duration: 19s498ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 19s498ms - 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-02 23:14:04 Duration: 9s199ms 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-02 20:03:19 Duration: 8s460ms 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-02 23:31:16 Duration: 487ms 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 8 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration May 02 09 1 0ms 0ms 10 1 0ms 0ms 13 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 3m5s - Times executed: 8 ]
[ Application: psql - unix(3163019@a2tech):8963 - Total duration: 3m3s - Times executed: 1 ]
[ Application: psql - unix(3168554@a2tech):8963 - Total duration: 1s243ms - Times executed: 1 ]
[ Application: psql - unix(3158434@a2tech):8963 - Total duration: 229ms - Times executed: 1 ]
[ Application: psql - unix(3166067@a2tech):8963 - Total duration: 228ms - Times executed: 1 ]
[ Application: psql - unix(3160383@a2tech):8963 - Total duration: 223ms - Times executed: 1 ]
[ Application: psql - unix(3162184@a2tech):8963 - Total duration: 160ms - Times executed: 1 ]
[ Application: psql - unix(3165043@a2tech):8963 - Total duration: 154ms - Times executed: 1 ]
[ Application: psql - unix(3157340@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql - unix(3168554@a2tech):8963
-
Events
Log levels
Key values
- 4,722 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 17 FATAL entries
- 1156 ERROR entries
- 0 WARNING entries
- 2 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,152 Max number of times the same event was reported
- 1,175 Total events found
Rank Times reported Error 1 1,152 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count May 02 00 45 01 49 02 50 03 46 04 50 05 48 06 48 07 50 08 49 09 48 10 48 11 51 12 49 13 49 14 46 15 47 16 46 17 49 18 46 19 47 20 48 21 48 22 48 23 47 - ERROR: prepared statement "_PLAN000000004CA80030" does not exist
- ERROR: prepared statement "_PLAN000000004CA80DE0" does not exist
- ERROR: prepared statement "_PLAN000000004CA77BE0" does not exist
Statement: DEALLOCATE "_PLAN000000004CA80030"
Date: 2026-05-02 00:01:50 Database: brasilia Application: app - 177.99.204.34:51210 User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000004CA80DE0"
Date: 2026-05-02 00:03:58 Database: brasilia Application: app - 177.99.204.34:51937 User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000004CA77BE0"
Date: 2026-05-02 00:05:01 Database: brasilia Application: app - 177.99.204.34:51559 User: etiquetas Remote: [local]
2 9 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count May 02 00 1 02 1 05 1 06 1 10 3 15 1 19 1 3 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count May 02 03 7 4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count May 02 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-02 05:31:09 Database: brasilia Application: psql - unix(3154082@a2tech):8963 User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-02 05:31:09 Database: brasilia Application: psql - unix(3154083@a2tech):8963 User: intelifix Remote: [local]
5 1 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #5
Day Hour Count May 02 03 1 6 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #6
Day Hour Count May 02 03 1 7 1 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #7
Day Hour Count May 02 17 1