-
Global information
- Generated on Sun May 3 23:50:06 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-Wed.log
- Parsed 9,187 log entries in 5s
- Log start from 2026-05-03 00:00:48 to 2026-05-03 23:49:56
-
Overview
Global Stats
- 128 Number of unique normalized queries
- 709 Number of queries
- 2h15m8s Total query duration
- 2026-05-03 00:05:04 First query
- 2026-05-03 23:39:06 Last query
- 6 queries/s at 2026-05-03 23:38:47 Query peak
- 2h15m8s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h15m8s Execute total duration
- 1,165 Number of events
- 7 Number of unique normalized events
- 1,136 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
- 396 Total number of sessions
- 17 sessions at 2026-05-03 22:32:42 Session peak
- 7d12h9m47s Total duration of sessions
- 27m17s Average duration of sessions
- 1 Average queries per session
- 20s476ms Average queries duration per session
- 26m57s Average idle time per session
- 403 Total number of connections
- 5 connections/s at 2026-05-03 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-05-03 23:38:47 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-05-03 14:10:45 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 6 queries/s Query Peak
- 2026-05-03 23:38:47 Date
Queries duration
Key values
- 2h15m8s 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 03 00 10 0ms 4s477ms 2s27ms 1s51ms 1s90ms 14s864ms 01 7 0ms 1s92ms 931ms 1s35ms 1s86ms 1s195ms 02 8 0ms 1s195ms 867ms 1s39ms 1s106ms 1s351ms 03 8 0ms 1s245ms 882ms 1s23ms 1s139ms 1s414ms 04 7 0ms 1s112ms 930ms 1s13ms 1s81ms 1s265ms 05 12 0ms 1m53s 26s812ms 1s183ms 57s484ms 1m53s 06 10 0ms 2s148ms 1s263ms 1s26ms 1s127ms 7s161ms 07 13 0ms 3m18s 28s460ms 1s76ms 1s325ms 3m49s 08 18 0ms 3m5s 19s437ms 1s80ms 1s322ms 3m31s 09 17 0ms 3m7s 20s714ms 1s54ms 1s104ms 3m33s 10 17 0ms 3m4s 20s502ms 1s81ms 1s405ms 3m30s 11 17 0ms 3m7s 20s686ms 1s86ms 1s136ms 3m33s 12 14 0ms 3m4s 24s854ms 1s35ms 1s131ms 3m29s 13 16 0ms 3m4s 21s742ms 1s66ms 1s127ms 3m29s 14 16 0ms 3m4s 21s808ms 1s43ms 1s249ms 3m30s 15 15 0ms 3m10s 23s626ms 1s52ms 1s234ms 3m35s 16 17 0ms 3m4s 20s512ms 1s76ms 1s212ms 3m30s 17 16 0ms 3m5s 21s797ms 1s51ms 1s224ms 3m30s 18 17 0ms 3m9s 20s769ms 1s71ms 1s148ms 3m34s 19 16 0ms 3m4s 21s822ms 1s48ms 1s359ms 3m30s 20 91 0ms 3m15s 8s21ms 54s586ms 1m13s 3m55s 21 15 0ms 3m5s 23s268ms 1s88ms 1s229ms 3m30s 22 18 0ms 3m11s 19s754ms 1s91ms 1s242ms 3m36s 23 314 0ms 1m2s 5s482ms 1m5s 1m7s 1m12s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 03 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 8 0 42s762ms 0ms 0ms 2m10s 09 6 0 57s453ms 0ms 0ms 2m11s 10 6 0 56s801ms 0ms 0ms 2m10s 11 6 0 57s331ms 0ms 0ms 2m10s 12 6 0 56s857ms 0ms 0ms 2m11s 13 6 0 56s748ms 0ms 0ms 2m10s 14 6 0 56s910ms 0ms 0ms 2m10s 15 6 0 57s891ms 0ms 0ms 2m11s 16 6 0 56s896ms 0ms 0ms 2m10s 17 6 0 56s941ms 0ms 0ms 2m10s 18 6 0 57s579ms 0ms 0ms 2m10s 19 6 0 56s902ms 0ms 0ms 2m10s 20 6 73 9s127ms 0ms 54s586ms 2m12s 21 6 0 56s978ms 0ms 0ms 2m10s 22 6 0 57s985ms 0ms 0ms 2m11s 23 0 314 5s482ms 1m2s 1m5s 1m12s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 03 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 03 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 03 00 22 0.01/s 01 17 0.00/s 02 12 0.00/s 03 23 0.01/s 04 18 0.01/s 05 18 0.01/s 06 21 0.01/s 07 15 0.00/s 08 17 0.00/s 09 18 0.01/s 10 15 0.00/s 11 16 0.00/s 12 12 0.00/s 13 15 0.00/s 14 17 0.00/s 15 17 0.00/s 16 18 0.01/s 17 14 0.00/s 18 18 0.01/s 19 16 0.00/s 20 18 0.01/s 21 16 0.00/s 22 18 0.01/s 23 12 0.00/s Day Hour Count Average Duration Average idle time May 03 00 11 10m35s 10m33s 01 22 33m9s 33m9s 02 12 34m19s 34m18s 03 21 13m24s 13m24s 04 16 26m29s 26m29s 05 17 24m55s 24m36s 06 16 29m32s 29m31s 07 20 38m21s 38m2s 08 15 28m7s 27m44s 09 19 27m21s 27m3s 10 16 29m41s 29m20s 11 15 27m42s 27m19s 12 13 36m38s 36m11s 13 16 26m29s 26m8s 14 15 24m1s 23m38s 15 18 26m10s 25m51s 16 17 24m59s 24m39s 17 15 35m50s 35m27s 18 16 22m12s 21m50s 19 16 30m19s 29m57s 20 19 25m5s 24m27s 21 16 26m1s 25m39s 22 17 24m45s 24m24s 23 18 27m51s 26m15s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-05-03 03:05:17 Date
Connections per database
Key values
- brasilia Main Database
- 403 connections Total
Connections per user
Key values
- etiquetas Main User
- 403 connections Total
-
Sessions
Simultaneous sessions
Key values
- 17 sessions Session Peak
- 2026-05-03 22:32:42 Date
Histogram of session times
Key values
- 198 60000-600000ms duration
Sessions per database
Key values
- brasilia Main Database
- 396 sessions Total
Sessions per user
Key values
- etiquetas Main User
- 396 sessions Total
Sessions per host
Key values
- [local] Main Host
- 396 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 396 sessions Total
Application Count Total Duration Average Duration [unknown] 121 4d17h49m30s 56m26s app - 177.99.204.34:49231 1 13m41s 13m41s app - 177.99.204.34:49398 1 4m11s 4m11s app - 177.99.204.34:49472 1 5m15s 5m15s app - 177.99.204.34:49524 1 5m16s 5m16s app - 177.99.204.34:49551 1 5m12s 5m12s app - 177.99.204.34:49557 1 1h 1h app - 177.99.204.34:49641 2 1h2m3s 31m1s app - 177.99.204.34:49757 1 2m4s 2m4s app - 177.99.204.34:50016 1 4m10s 4m10s app - 177.99.204.34:50105 1 5m14s 5m14s app - 177.99.204.34:50156 1 5m16s 5m16s app - 177.99.204.34:50224 1 6m19s 6m19s app - 177.99.204.34:50238 1 9m27s 9m27s app - 177.99.204.34:50324 1 5m14s 5m14s app - 177.99.204.34:50332 1 2m4s 2m4s app - 177.99.204.34:50383 1 2m4s 2m4s app - 177.99.204.34:50475 1 12m39s 12m39s app - 177.99.204.34:50566 1 10m32s 10m32s app - 177.99.204.34:50574 1 7m23s 7m23s app - 177.99.204.34:50783 1 6m18s 6m18s app - 177.99.204.34:50874 1 5m14s 5m14s app - 177.99.204.34:50881 1 4m13s 4m13s app - 177.99.204.34:50945 1 3m7s 3m7s app - 177.99.204.34:51062 1 7m21s 7m21s app - 177.99.204.34:51275 2 1h2m4s 31m2s app - 177.99.204.34:51299 1 2m4s 2m4s app - 177.99.204.34:51404 1 1h 1h app - 177.99.204.34:51413 2 1h1m2s 30m31s app - 177.99.204.34:51417 1 8m25s 8m25s app - 177.99.204.34:51477 1 4m11s 4m11s app - 177.99.204.34:51537 1 4m10s 4m10s app - 177.99.204.34:51548 1 6m16s 6m16s app - 177.99.204.34:51612 1 5m15s 5m15s app - 177.99.204.34:51653 1 16m54s 16m54s app - 177.99.204.34:51743 1 3m8s 3m8s app - 177.99.204.34:51820 1 2m4s 2m4s app - 177.99.204.34:51906 1 4m9s 4m9s app - 177.99.204.34:52017 1 6m19s 6m19s app - 177.99.204.34:52101 1 20m6s 20m6s app - 177.99.204.34:52415 1 4m10s 4m10s app - 177.99.204.34:52460 1 9m27s 9m27s app - 177.99.204.34:52521 1 4m10s 4m10s app - 177.99.204.34:52590 1 2m4s 2m4s app - 177.99.204.34:52654 1 16m55s 16m55s app - 177.99.204.34:52685 1 3m7s 3m7s app - 177.99.204.34:52742 1 6m16s 6m16s app - 177.99.204.34:52840 1 12m39s 12m39s app - 177.99.204.34:52929 1 6m16s 6m16s app - 177.99.204.34:52941 1 5m14s 5m14s app - 177.99.204.34:52992 1 10m31s 10m31s app - 177.99.204.34:53090 1 6m17s 6m17s app - 177.99.204.34:53095 1 6m17s 6m17s app - 177.99.204.34:53136 2 1h4m7s 32m3s app - 177.99.204.34:53141 1 8m27s 8m27s app - 177.99.204.34:53146 1 10m33s 10m33s app - 177.99.204.34:53224 1 4m9s 4m9s app - 177.99.204.34:53254 1 3m7s 3m7s app - 177.99.204.34:53273 1 1h 1h app - 177.99.204.34:53291 2 1h7m15s 33m37s app - 177.99.204.34:53364 1 3m6s 3m6s app - 177.99.204.34:53373 1 4m12s 4m12s app - 177.99.204.34:53460 1 3m8s 3m8s app - 177.99.204.34:53582 1 2m4s 2m4s app - 177.99.204.34:53620 1 11m37s 11m37s app - 177.99.204.34:53630 1 3m9s 3m9s app - 177.99.204.34:53725 1 5m13s 5m13s app - 177.99.204.34:53821 1 5m14s 5m14s app - 177.99.204.34:53883 1 12m26s 12m26s app - 177.99.204.34:53934 1 3m7s 3m7s app - 177.99.204.34:54117 1 4m10s 4m10s app - 177.99.204.34:54146 1 10m37s 10m37s app - 177.99.204.34:54261 1 7m19s 7m19s app - 177.99.204.34:54435 1 2m4s 2m4s app - 177.99.204.34:54471 1 3m7s 3m7s app - 177.99.204.34:54580 1 3m8s 3m8s app - 177.99.204.34:54637 1 5m14s 5m14s app - 177.99.204.34:54726 1 1h 1h app - 177.99.204.34:54794 1 14m49s 14m49s app - 177.99.204.34:54817 1 4m10s 4m10s app - 177.99.204.34:54818 1 4m12s 4m12s app - 177.99.204.34:54975 1 8m13s 8m13s app - 177.99.204.34:55018 1 5m14s 5m14s app - 177.99.204.34:55041 1 6m18s 6m18s app - 177.99.204.34:55161 1 1h 1h app - 177.99.204.34:55242 1 4m9s 4m9s app - 177.99.204.34:55331 1 7m21s 7m21s app - 177.99.204.34:55421 1 7m22s 7m22s app - 177.99.204.34:55478 1 8m20s 8m20s app - 177.99.204.34:55479 1 7m20s 7m20s app - 177.99.204.34:55486 1 2m4s 2m4s app - 177.99.204.34:55567 1 3m7s 3m7s app - 177.99.204.34:55619 1 9m26s 9m26s app - 177.99.204.34:55634 1 2m4s 2m4s app - 177.99.204.34:55718 1 4m10s 4m10s app - 177.99.204.34:55733 2 1h52s 30m26s app - 177.99.204.34:55830 1 6m7s 6m7s app - 177.99.204.34:55949 1 28m34s 28m34s app - 177.99.204.34:55990 1 8m27s 8m27s app - 177.99.204.34:55996 1 5m13s 5m13s app - 177.99.204.34:56133 1 8m27s 8m27s app - 177.99.204.34:56182 1 2m4s 2m4s app - 177.99.204.34:56250 1 3m8s 3m8s app - 177.99.204.34:56259 1 2m4s 2m4s app - 177.99.204.34:56348 1 4m12s 4m12s app - 177.99.204.34:56360 1 16m56s 16m56s app - 177.99.204.34:56636 1 4m10s 4m10s app - 177.99.204.34:56651 1 5m14s 5m14s app - 177.99.204.34:56776 1 11m35s 11m35s app - 177.99.204.34:56793 1 5m16s 5m16s app - 177.99.204.34:56835 1 5m14s 5m14s app - 177.99.204.34:56882 1 5m16s 5m16s app - 177.99.204.34:56987 1 4m10s 4m10s app - 177.99.204.34:57062 1 10m34s 10m34s app - 177.99.204.34:57067 1 4m11s 4m11s app - 177.99.204.34:57267 1 7m21s 7m21s app - 177.99.204.34:57393 1 7m22s 7m22s app - 177.99.204.34:57509 1 2m4s 2m4s app - 177.99.204.34:57512 1 6m17s 6m17s app - 177.99.204.34:57545 1 4m10s 4m10s app - 177.99.204.34:57579 1 8m24s 8m24s app - 177.99.204.34:57684 1 4m7s 4m7s app - 177.99.204.34:57787 1 3m14s 3m14s app - 177.99.204.34:57795 1 1h 1h app - 177.99.204.34:57987 1 6m18s 6m18s app - 177.99.204.34:58031 1 2m4s 2m4s app - 177.99.204.34:58202 1 2m4s 2m4s app - 177.99.204.34:58239 1 7m24s 7m24s app - 177.99.204.34:58449 1 3m7s 3m7s app - 177.99.204.34:58476 1 10m40s 10m40s app - 177.99.204.34:58492 1 4m10s 4m10s app - 177.99.204.34:58555 2 1h6m15s 33m7s app - 177.99.204.34:58666 1 4m9s 4m9s app - 177.99.204.34:58749 1 11m36s 11m36s app - 177.99.204.34:58767 1 4m11s 4m11s app - 177.99.204.34:58840 1 47s583ms 47s583ms app - 177.99.204.34:58841 1 5m16s 5m16s app - 177.99.204.34:58931 1 3m7s 3m7s app - 177.99.204.34:58938 1 14m47s 14m47s app - 177.99.204.34:59029 1 11m32s 11m32s app - 177.99.204.34:59109 1 3m9s 3m9s app - 177.99.204.34:59193 1 4m11s 4m11s app - 177.99.204.34:59229 1 12m39s 12m39s app - 177.99.204.34:59282 1 7m21s 7m21s app - 177.99.204.34:59335 1 4m11s 4m11s app - 177.99.204.34:59429 1 4m12s 4m12s app - 177.99.204.34:59439 1 5m14s 5m14s app - 177.99.204.34:59484 1 3m7s 3m7s app - 177.99.204.34:59816 1 4m9s 4m9s app - 177.99.204.34:59866 1 2m4s 2m4s app - 177.99.204.34:59995 1 6m19s 6m19s app - 177.99.204.34:60078 1 12m40s 12m40s app - 177.99.204.34:60103 1 3m7s 3m7s app - 177.99.204.34:60124 1 3m8s 3m8s app - 177.99.204.34:60141 1 5m15s 5m15s app - 177.99.204.34:60144 1 12m40s 12m40s app - 177.99.204.34:60163 1 6m15s 6m15s app - 177.99.204.34:60391 1 10m31s 10m31s app - 177.99.204.34:60405 1 12m42s 12m42s app - 177.99.204.34:60419 1 6m19s 6m19s app - 177.99.204.34:60559 1 1h 1h app - 177.99.204.34:60586 1 2m4s 2m4s app - 177.99.204.34:60599 1 1h 1h app - 177.99.204.34:60600 1 6m15s 6m15s app - 177.99.204.34:60676 1 3m8s 3m8s app - 177.99.204.34:60679 1 6m21s 6m21s app - 177.99.204.34:60900 1 3m12s 3m12s app - 177.99.204.34:60963 1 4m14s 4m14s app - 177.99.204.34:61034 1 9m28s 9m28s app - 177.99.204.34:61065 1 3m7s 3m7s app - 177.99.204.34:61078 1 2m4s 2m4s app - 177.99.204.34:61082 1 2m4s 2m4s app - 177.99.204.34:61154 2 1h1m52s 30m56s app - 177.99.204.34:61188 1 6m17s 6m17s app - 177.99.204.34:61251 1 2m4s 2m4s app - 177.99.204.34:61297 1 2m4s 2m4s app - 177.99.204.34:61304 1 8m18s 8m18s app - 177.99.204.34:61395 1 4m11s 4m11s app - 177.99.204.34:61447 1 15m50s 15m50s app - 177.99.204.34:61559 1 4m13s 4m13s app - 177.99.204.34:61631 1 11m35s 11m35s app - 177.99.204.34:61787 1 3m7s 3m7s app - 177.99.204.34:61804 2 1h5m16s 32m38s app - 177.99.204.34:61868 1 10m32s 10m32s app - 177.99.204.34:61977 1 3m7s 3m7s app - 177.99.204.34:62018 1 7m20s 7m20s app - 177.99.204.34:62129 1 11m36s 11m36s app - 177.99.204.34:62141 1 8m22s 8m22s app - 177.99.204.34:62167 1 5m13s 5m13s app - 177.99.204.34:62260 1 3m7s 3m7s app - 177.99.204.34:62337 1 3m8s 3m8s app - 177.99.204.34:62438 1 15m55s 15m55s app - 177.99.204.34:62582 1 3m8s 3m8s app - 177.99.204.34:62603 1 7m22s 7m22s app - 177.99.204.34:62644 1 6m17s 6m17s app - 177.99.204.34:62691 1 3m7s 3m7s app - 177.99.204.34:62827 1 2m4s 2m4s app - 177.99.204.34:62852 1 5m13s 5m13s app - 177.99.204.34:62972 1 1h 1h app - 177.99.204.34:63032 1 4m11s 4m11s app - 177.99.204.34:63243 2 1h4m10s 32m5s app - 177.99.204.34:63334 1 5m13s 5m13s app - 177.99.204.34:63345 1 2m4s 2m4s app - 177.99.204.34:63350 1 5m15s 5m15s app - 177.99.204.34:63518 1 10m31s 10m31s app - 177.99.204.34:63601 1 3m8s 3m8s app - 177.99.204.34:63620 1 6m18s 6m18s app - 177.99.204.34:63730 1 2m4s 2m4s app - 177.99.204.34:63803 2 11m18s 5m39s app - 177.99.204.34:63850 1 8m24s 8m24s app - 177.99.204.34:63902 1 4m10s 4m10s app - 177.99.204.34:63924 1 14m49s 14m49s app - 177.99.204.34:64070 1 23m15s 23m15s app - 177.99.204.34:64083 2 1h50s 30m25s app - 177.99.204.34:64175 1 2m10s 2m10s app - 177.99.204.34:64332 1 5m14s 5m14s app - 177.99.204.34:64337 1 4m11s 4m11s app - 177.99.204.34:64338 1 1m2s 1m2s app - 177.99.204.34:64357 1 1h 1h app - 177.99.204.34:64426 1 3m7s 3m7s app - 177.99.204.34:64434 1 3m8s 3m8s app - 177.99.204.34:64591 1 3m9s 3m9s app - 177.99.204.34:64622 1 4m11s 4m11s app - 177.99.204.34:64662 1 5m15s 5m15s app - 177.99.204.34:64664 1 5m13s 5m13s app - 177.99.204.34:64797 1 5m14s 5m14s app - 177.99.204.34:64855 1 4m12s 4m12s app - 177.99.204.34:64861 1 6m20s 6m20s app - 177.99.204.34:64910 1 1h 1h app - 177.99.204.34:64917 1 3m8s 3m8s app - 177.99.204.34:64929 1 7m23s 7m23s app - 177.99.204.34:64949 1 1h 1h app - 177.99.204.34:65043 1 7m20s 7m20s app - 177.99.204.34:65128 1 2m4s 2m4s app - 177.99.204.34:65333 1 3m11s 3m11s app - 177.99.204.34:65347 1 7m18s 7m18s app - 177.99.204.34:65357 1 7m20s 7m20s app - 177.99.204.34:65404 1 2m4s 2m4s pg_dump 6 35m13s 5m52s postgres_fdw 1 55m 55m psql - unix(3172432@a2tech):8963 1 1h 1h psql - unix(3172556@a2tech):8963 1 1h 1h psql - unix(3174479@a2tech):8963 1 1h 1h psql - unix(3174613@a2tech):8963 1 1h 1h psql - unix(3179382@a2tech):8963 1 1h3m1s 1h3m1s psql - unix(3180677@a2tech):8963 1 1h 1h psql - unix(3181150@a2tech):8963 1 1h16s 1h16s psql - unix(3181546@a2tech):8963 1 1h 1h psql - unix(3181691@a2tech):8963 1 1h 1h psql - unix(3181963@a2tech):8963 1 1h3m3s 1h3m3s psql - unix(3182039@a2tech):8963 1 1h 1h psql - unix(3182661@a2tech):8963 1 1h 1h psql - unix(3182812@a2tech):8963 1 1h3m4s 1h3m4s psql - unix(3184540@a2tech):8963 1 1h3m4s 1h3m4s psql - unix(3186414@a2tech):8963 1 1h 1h psql - unix(3187992@a2tech):8963 1 1h8s 1h8s psql - unix(3188834@a2tech):8963 1 1h3m5s 1h3m5s psql - unix(3188903@a2tech):8963 1 1h2m4s 1h2m4s psql - unix(3190129@a2tech):8963 1 1h 1h -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 13,982 buffers Checkpoint Peak
- 2026-05-03 00:09:47 Date
- 269.478 seconds Highest write time
- 0.004 seconds Sync time
Checkpoints Wal files
Key values
- 2 files Wal files usage Peak
- 2026-05-03 05:09:34 Date
Checkpoints distance
Key values
- 213.54 Mo Distance Peak
- 2026-05-03 00:09:47 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 03 00 13,982 269.09s 0.004s 269.115s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 243 0.013s 0.003s 0.023s 04 0 0s 0s 0s 05 4,070 308.172s 0.012s 308.198s 06 1,895 189.203s 0.002s 189.207s 07 945 94.302s 0.002s 94.308s 08 33 3.114s 0.004s 3.125s 09 20 1.907s 0.002s 1.912s 10 21 2.008s 0.003s 2.014s 11 21 2.008s 0.002s 2.014s 12 21 2.008s 0.002s 2.015s 13 20 1.907s 0.003s 1.913s 14 20 1.908s 0.002s 1.913s 15 21 2.006s 0.002s 2.011s 16 21 2.007s 0.002s 2.012s 17 21 2.007s 0.002s 2.012s 18 466 46.413s 0.006s 46.429s 19 21 2.007s 0.002s 2.013s 20 49 4.814s 0.003s 4.82s 21 21 2.008s 0.002s 2.014s 22 20 1.907s 0.002s 1.912s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 03 00 0 6 1 46 0.001s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 14 0.001s 0.002s 04 0 0 0 0 0s 0s 05 0 0 2 97 0.002s 0.004s 06 0 0 0 6 0.001s 0.001s 07 0 0 1 13 0.001s 0.001s 08 0 0 0 15 0.002s 0.002s 09 0 0 0 3 0.002s 0.001s 10 0 0 0 3 0.002s 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.001s 0.001s 18 0 0 0 32 0.001s 0.003s 19 0 0 0 3 0.002s 0.001s 20 0 0 0 17 0.002s 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 03 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 03 00 109,334.00 kB 109,334.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 119.50 kB 49,212.50 kB 04 0.00 kB 0.00 kB 05 8,987.00 kB 23,335.75 kB 06 11,163.00 kB 25,742.00 kB 07 6,900.00 kB 23,857.00 kB 08 100.50 kB 20,415.00 kB 09 155.00 kB 17,424.00 kB 10 161.00 kB 15,698.00 kB 11 159.00 kB 14,144.00 kB 12 158.00 kB 12,745.00 kB 13 156.00 kB 11,486.00 kB 14 153.00 kB 10,353.00 kB 15 160.00 kB 9,334.00 kB 16 158.00 kB 8,416.00 kB 17 157.00 kB 7,590.00 kB 18 987.67 kB 6,429.00 kB 19 161.00 kB 5,215.00 kB 20 657.00 kB 4,759.00 kB 21 158.00 kB 4,299.00 kB 22 156.00 kB 3,885.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-03 05:31:02 Date
Number of temporary files
Key values
- 3 per second Temp Files Peak
- 2026-05-03 05:31:07 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 03 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-03 05:31:07 Duration: 45s209ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3175469@a2tech):8963
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-03 05:31:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3175469@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-03 05:30:22 Duration: 20s676ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3175462@a2tech):8963
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-05-03 05:30:20 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3175462@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-03 05:31:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3175469@a2tech):8963 ]
2 221.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-03 05:31:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3175469@a2tech):8963 ]
3 84.88 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-05-03 05:30:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3175462@a2tech):8963 ]
4 84.88 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-05-03 05:30:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3175462@a2tech):8963 ]
5 73.03 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-03 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3175469@a2tech):8963 ]
6 72.97 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-03 05:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3175469@a2tech):8963 ]
7 72.96 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-03 05:31:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3175469@a2tech):8963 ]
8 66.00 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-03 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3175469@a2tech):8963 ]
9 65.95 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-03 05:31:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3175469@a2tech):8963 ]
10 65.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-03 05:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3175469@a2tech):8963 ]
11 56.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-05-03 05:30:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3175462@a2tech):8963 ]
12 51.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-05-03 05:30:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3175462@a2tech):8963 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.06 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_05
Database rio - 2026-05-03 00:05:53 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.06 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_05
Database rio - 2026-05-03 00:05:53 Date
Analyzes per table
Key values
- auditor.auditor_2026_05 (1) Main table analyzed (database rio)
- 3 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_statistic (1) Main table vacuumed on database brasilia
- 9 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes brasilia.pg_catalog.pg_statistic 1 1 2,279 0 1 0 0 2,206 2 159,665 rio.pg_toast.pg_toast_2619 1 1 822 0 16 0 0 654 8 62,597 contagem.auditor.auditor_2026_05 1 0 1,668 0 13 0 0 770 2 61,009 contagem.pg_catalog.pg_statistic 1 1 2,175 0 3 0 0 2,099 2 151,068 brasilia.auditor.auditor_2026_05 1 0 1,419 0 14 0 0 662 2 54,469 contagem.pg_toast.pg_toast_2619 1 1 192 0 1 0 0 135 2 24,232 brasilia.pg_toast.pg_toast_2619 1 1 208 0 1 0 0 152 2 24,775 rio.auditor.auditor_2026_05 1 0 1,629 0 205 0 0 760 2 55,667 rio.pg_catalog.pg_statistic 1 1 2,861 0 14 0 0 2,671 14 201,048 Total 9 6 13,253 255 268 0 0 10,109 36 794,530 Tuples removed per table
Key values
- pg_catalog.pg_statistic (3505) Main table with removed tuples on database rio
- 10138 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 3,505 7,684 0 0 1,279 brasilia.pg_catalog.pg_statistic 1 1 3,050 7,358 0 0 951 contagem.pg_catalog.pg_statistic 1 1 2,791 7,336 0 0 922 rio.pg_toast.pg_toast_2619 1 1 569 669 0 39 225 brasilia.pg_toast.pg_toast_2619 1 1 115 140 0 0 63 contagem.pg_toast.pg_toast_2619 1 1 108 126 0 0 56 contagem.auditor.auditor_2026_05 1 0 0 79,961 0 0 2,282 brasilia.auditor.auditor_2026_05 1 0 0 68,463 0 0 1,955 rio.auditor.auditor_2026_05 1 0 0 117,851 0 0 4,366 Total 9 6 10,138 289,588 0 39 12,099 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (39) Main table with removed pages on database rio
- 39 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_toast.pg_toast_2619 1 1 569 39 brasilia.pg_catalog.pg_statistic 1 1 3050 0 contagem.auditor.auditor_2026_05 1 0 0 0 contagem.pg_catalog.pg_statistic 1 1 2791 0 brasilia.auditor.auditor_2026_05 1 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 108 0 brasilia.pg_toast.pg_toast_2619 1 1 115 0 rio.auditor.auditor_2026_05 1 0 0 0 rio.pg_catalog.pg_statistic 1 1 3505 0 Total 9 6 10,138 39 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 03 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.06 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
- 98 Total read queries
- 387 Total write queries
Queries by database
Key values
- rio Main database
- 354 Requests
- 1h24m57s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 1,424 Requests
User Request type Count Duration intelifix Total 1,424 4h30m19s copy to 771 1h9m37s others 459 16m45s select 194 3h3m56s Duration by user
Key values
- 4h30m19s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 1,424 4h30m19s copy to 771 1h9m37s others 459 16m45s select 194 3h3m56s Queries by host
Key values
- [local] Main host
- 1,424 Requests
- 4h30m19s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 387 Requests
- 34m44s (pg_dump)
- Main time consuming application
Application Request type Count Duration app - 127.0.0.1:40034 Total 1 224ms select 1 224ms app - 127.0.0.1:55468 Total 1 262ms select 1 262ms pg_dump Total 387 34m44s copy to 387 34m44s psql - unix(3170819@a2tech):8963 Total 1 2s56ms others 1 2s56ms psql - unix(3170821@a2tech):8963 Total 1 4s477ms others 1 4s477ms psql - unix(3170833@a2tech):8963 Total 1 287ms others 1 287ms psql - unix(3170851@a2tech):8963 Total 1 3s697ms others 1 3s697ms psql - unix(3170852@a2tech):8963 Total 1 4s346ms others 1 4s346ms psql - unix(3170960@a2tech):8963 Total 1 1s90ms others 1 1s90ms psql - unix(3171083@a2tech):8963 Total 1 1s84ms others 1 1s84ms psql - unix(3171244@a2tech):8963 Total 1 1s117ms others 1 1s117ms psql - unix(3171369@a2tech):8963 Total 1 1s68ms others 1 1s68ms psql - unix(3171498@a2tech):8963 Total 1 1s51ms others 1 1s51ms psql - unix(3171644@a2tech):8963 Total 1 1s92ms others 1 1s92ms psql - unix(3171774@a2tech):8963 Total 1 1s51ms others 1 1s51ms psql - unix(3171896@a2tech):8963 Total 1 1s42ms others 1 1s42ms psql - unix(3171904@a2tech):8963 Total 1 153ms others 1 153ms psql - unix(3172017@a2tech):8963 Total 1 1s86ms others 1 1s86ms psql - unix(3172147@a2tech):8963 Total 1 1s35ms others 1 1s35ms psql - unix(3172287@a2tech):8963 Total 1 1s62ms others 1 1s62ms psql - unix(3172432@a2tech):8963 Total 1 1s98ms others 1 1s98ms psql - unix(3172556@a2tech):8963 Total 1 1s106ms others 1 1s106ms psql - unix(3172677@a2tech):8963 Total 1 1s120ms others 1 1s120ms psql - unix(3172687@a2tech):8963 Total 1 154ms others 1 154ms psql - unix(3172805@a2tech):8963 Total 1 1s195ms others 1 1s195ms psql - unix(3172816@a2tech):8963 Total 1 155ms others 1 155ms psql - unix(3172933@a2tech):8963 Total 1 1s39ms others 1 1s39ms psql - unix(3173055@a2tech):8963 Total 1 1s68ms others 1 1s68ms psql - unix(3173524@a2tech):8963 Total 1 1s245ms others 1 1s245ms psql - unix(3173538@a2tech):8963 Total 1 168ms others 1 168ms psql - unix(3173658@a2tech):8963 Total 1 1s83ms others 1 1s83ms psql - unix(3173782@a2tech):8963 Total 1 1s41ms others 1 1s41ms psql - unix(3173921@a2tech):8963 Total 1 1s179ms others 1 1s179ms psql - unix(3173932@a2tech):8963 Total 1 180ms others 1 180ms psql - unix(3174043@a2tech):8963 Total 1 1s23ms others 1 1s23ms psql - unix(3174166@a2tech):8963 Total 1 1s139ms others 1 1s139ms psql - unix(3174307@a2tech):8963 Total 1 1s81ms others 1 1s81ms psql - unix(3174479@a2tech):8963 Total 1 1s36ms others 1 1s36ms psql - unix(3174605@a2tech):8963 Total 1 1s89ms others 1 1s89ms psql - unix(3174740@a2tech):8963 Total 1 1s112ms others 1 1s112ms psql - unix(3174753@a2tech):8963 Total 1 152ms others 1 152ms psql - unix(3174864@a2tech):8963 Total 1 1s25ms others 1 1s25ms psql - unix(3174981@a2tech):8963 Total 1 1s13ms others 1 1s13ms psql - unix(3175051@a2tech):8963 Total 1 1m53s others 1 1m53s psql - unix(3175084@a2tech):8963 Total 1 1m18s others 1 1m18s psql - unix(3175095@a2tech):8963 Total 1 57s484ms others 1 57s484ms psql - unix(3175131@a2tech):8963 Total 1 1s88ms others 1 1s88ms psql - unix(3175260@a2tech):8963 Total 1 1s155ms others 1 1s155ms psql - unix(3175377@a2tech):8963 Total 1 1s44ms others 1 1s44ms psql - unix(3175462@a2tech):8963 Total 1 20s676ms others 1 20s676ms psql - unix(3175469@a2tech):8963 Total 1 45s209ms others 1 45s209ms psql - unix(3175537@a2tech):8963 Total 1 1s117ms others 1 1s117ms psql - unix(3175666@a2tech):8963 Total 1 1s39ms others 1 1s39ms psql - unix(3175786@a2tech):8963 Total 1 1s31ms others 1 1s31ms psql - unix(3175794@a2tech):8963 Total 1 151ms others 1 151ms psql - unix(3175968@a2tech):8963 Total 1 1s100ms others 1 1s100ms psql - unix(3175969@a2tech):8963 Total 1 2s148ms others 1 2s148ms psql - unix(3175994@a2tech):8963 Total 1 1s834ms others 1 1s834ms psql - unix(3176000@a2tech):8963 Total 1 2s77ms others 1 2s77ms psql - unix(3176103@a2tech):8963 Total 1 1s43ms others 1 1s43ms psql - unix(3176230@a2tech):8963 Total 1 1s26ms others 1 1s26ms psql - unix(3176362@a2tech):8963 Total 1 1s127ms others 1 1s127ms psql - unix(3176488@a2tech):8963 Total 1 1s33ms others 1 1s33ms psql - unix(3176613@a2tech):8963 Total 1 1s82ms others 1 1s82ms psql - unix(3176621@a2tech):8963 Total 1 161ms others 1 161ms psql - unix(3176759@a2tech):8963 Total 1 3m18s select 1 3m18s psql - unix(3176765@a2tech):8963 Total 1 1s174ms others 1 1s174ms psql - unix(3176776@a2tech):8963 Total 1 151ms others 1 151ms psql - unix(3176822@a2tech):8963 Total 1 21s517ms select 1 21s517ms psql - unix(3176830@a2tech):8963 Total 1 9s840ms select 1 9s840ms psql - unix(3176834@a2tech):8963 Total 1 2m12s select 1 2m12s psql - unix(3176862@a2tech):8963 Total 1 768ms select 1 768ms psql - unix(3176867@a2tech):8963 Total 1 446ms select 1 446ms psql - unix(3176918@a2tech):8963 Total 1 1s49ms others 1 1s49ms psql - unix(3177038@a2tech):8963 Total 1 1s97ms others 1 1s97ms psql - unix(3177168@a2tech):8963 Total 1 1s107ms others 1 1s107ms psql - unix(3177296@a2tech):8963 Total 1 1s76ms others 1 1s76ms psql - unix(3177421@a2tech):8963 Total 1 1s37ms others 1 1s37ms psql - unix(3177493@a2tech):8963 Total 1 654ms others 1 654ms psql - unix(3177495@a2tech):8963 Total 1 259ms others 1 259ms psql - unix(3177571@a2tech):8963 Total 1 3m5s select 1 3m5s psql - unix(3177578@a2tech):8963 Total 1 1s123ms others 1 1s123ms psql - unix(3177589@a2tech):8963 Total 1 152ms others 1 152ms psql - unix(3177642@a2tech):8963 Total 1 17s551ms select 1 17s551ms psql - unix(3177649@a2tech):8963 Total 1 8s140ms select 1 8s140ms psql - unix(3177654@a2tech):8963 Total 1 2m9s select 1 2m9s psql - unix(3177681@a2tech):8963 Total 1 492ms select 1 492ms psql - unix(3177684@a2tech):8963 Total 1 329ms select 1 329ms psql - unix(3177775@a2tech):8963 Total 1 1s90ms others 1 1s90ms psql - unix(3177911@a2tech):8963 Total 1 1s37ms others 1 1s37ms psql - unix(3178066@a2tech):8963 Total 1 1s98ms others 1 1s98ms psql - unix(3178212@a2tech):8963 Total 1 242ms others 1 242ms psql - unix(3178278@a2tech):8963 Total 1 1s80ms others 1 1s80ms psql - unix(3178402@a2tech):8963 Total 1 1s28ms others 1 1s28ms psql - unix(3178479@a2tech):8963 Total 1 156ms others 1 156ms psql - unix(3178481@a2tech):8963 Total 1 232ms others 1 232ms psql - unix(3178557@a2tech):8963 Total 1 3m7s select 1 3m7s psql - unix(3178564@a2tech):8963 Total 1 1s104ms others 1 1s104ms psql - unix(3178620@a2tech):8963 Total 1 17s586ms select 1 17s586ms psql - unix(3178628@a2tech):8963 Total 1 8s215ms select 1 8s215ms psql - unix(3178632@a2tech):8963 Total 1 2m10s select 1 2m10s psql - unix(3178657@a2tech):8963 Total 1 549ms select 1 549ms psql - unix(3178660@a2tech):8963 Total 1 349ms select 1 349ms psql - unix(3178714@a2tech):8963 Total 1 1s57ms others 1 1s57ms psql - unix(3178780@a2tech):8963 Total 1 225ms others 1 225ms psql - unix(3178782@a2tech):8963 Total 1 221ms others 1 221ms psql - unix(3178841@a2tech):8963 Total 1 1s54ms others 1 1s54ms psql - unix(3178970@a2tech):8963 Total 1 1s48ms others 1 1s48ms psql - unix(3179043@a2tech):8963 Total 1 241ms others 1 241ms psql - unix(3179104@a2tech):8963 Total 1 1s20ms others 1 1s20ms psql - unix(3179221@a2tech):8963 Total 1 1s56ms others 1 1s56ms psql - unix(3179294@a2tech):8963 Total 1 249ms others 1 249ms psql - unix(3179382@a2tech):8963 Total 1 3m4s select 1 3m4s psql - unix(3179385@a2tech):8963 Total 1 1s253ms others 1 1s253ms psql - unix(3179396@a2tech):8963 Total 1 151ms others 1 151ms psql - unix(3179441@a2tech):8963 Total 1 17s454ms select 1 17s454ms psql - unix(3179451@a2tech):8963 Total 1 8s262ms select 1 8s262ms psql - unix(3179456@a2tech):8963 Total 1 2m9s select 1 2m9s psql - unix(3179480@a2tech):8963 Total 1 538ms select 1 538ms psql - unix(3179483@a2tech):8963 Total 1 356ms select 1 356ms psql - unix(3179538@a2tech):8963 Total 1 1s51ms others 1 1s51ms psql - unix(3179607@a2tech):8963 Total 1 237ms others 1 237ms psql - unix(3179609@a2tech):8963 Total 1 207ms others 1 207ms psql - unix(3179671@a2tech):8963 Total 1 1s123ms others 1 1s123ms psql - unix(3179799@a2tech):8963 Total 1 1s94ms others 1 1s94ms psql - unix(3179872@a2tech):8963 Total 1 251ms others 1 251ms psql - unix(3179935@a2tech):8963 Total 1 1s81ms others 1 1s81ms psql - unix(3180067@a2tech):8963 Total 1 1s33ms others 1 1s33ms psql - unix(3180136@a2tech):8963 Total 1 156ms others 1 156ms psql - unix(3180138@a2tech):8963 Total 1 274ms others 1 274ms psql - unix(3180216@a2tech):8963 Total 1 3m7s select 1 3m7s psql - unix(3180222@a2tech):8963 Total 1 1s72ms others 1 1s72ms psql - unix(3180279@a2tech):8963 Total 1 17s635ms select 1 17s635ms psql - unix(3180290@a2tech):8963 Total 1 8s192ms select 1 8s192ms psql - unix(3180295@a2tech):8963 Total 1 2m9s select 1 2m9s psql - unix(3180321@a2tech):8963 Total 1 562ms select 1 562ms psql - unix(3180325@a2tech):8963 Total 1 356ms select 1 356ms psql - unix(3180391@a2tech):8963 Total 1 1s86ms others 1 1s86ms psql - unix(3180492@a2tech):8963 Total 1 242ms others 1 242ms psql - unix(3180494@a2tech):8963 Total 1 199ms others 1 199ms psql - unix(3180552@a2tech):8963 Total 1 1s129ms others 1 1s129ms psql - unix(3180677@a2tech):8963 Total 1 1s91ms others 1 1s91ms psql - unix(3180749@a2tech):8963 Total 1 264ms others 1 264ms psql - unix(3180811@a2tech):8963 Total 1 1s136ms others 1 1s136ms psql - unix(3180931@a2tech):8963 Total 1 1s28ms others 1 1s28ms psql - unix(3181091@a2tech):8963 Total 1 3m4s select 1 3m4s psql - unix(3181095@a2tech):8963 Total 1 1s107ms others 1 1s107ms psql - unix(3181150@a2tech):8963 Total 1 17s210ms select 1 17s210ms psql - unix(3181159@a2tech):8963 Total 1 8s451ms select 1 8s451ms psql - unix(3181164@a2tech):8963 Total 1 2m10s select 1 2m10s psql - unix(3181191@a2tech):8963 Total 1 542ms select 1 542ms psql - unix(3181195@a2tech):8963 Total 1 342ms select 1 342ms psql - unix(3181255@a2tech):8963 Total 1 1s25ms others 1 1s25ms psql - unix(3181321@a2tech):8963 Total 1 242ms others 1 242ms psql - unix(3181323@a2tech):8963 Total 1 211ms others 1 211ms psql - unix(3181381@a2tech):8963 Total 1 1s46ms others 1 1s46ms psql - unix(3181530@a2tech):8963 Total 1 1s35ms others 1 1s35ms psql - unix(3181691@a2tech):8963 Total 1 1s27ms others 1 1s27ms psql - unix(3181810@a2tech):8963 Total 1 1s131ms others 1 1s131ms psql - unix(3181889@a2tech):8963 Total 1 223ms others 1 223ms psql - unix(3181963@a2tech):8963 Total 1 3m4s select 1 3m4s psql - unix(3181971@a2tech):8963 Total 1 1s127ms others 1 1s127ms psql - unix(3182030@a2tech):8963 Total 1 17s346ms select 1 17s346ms psql - unix(3182039@a2tech):8963 Total 1 8s276ms select 1 8s276ms psql - unix(3182044@a2tech):8963 Total 1 2m9s select 1 2m9s psql - unix(3182070@a2tech):8963 Total 1 526ms select 1 526ms psql - unix(3182074@a2tech):8963 Total 1 347ms select 1 347ms psql - unix(3182131@a2tech):8963 Total 1 1s42ms others 1 1s42ms psql - unix(3182210@a2tech):8963 Total 1 268ms others 1 268ms psql - unix(3182212@a2tech):8963 Total 1 222ms others 1 222ms psql - unix(3182268@a2tech):8963 Total 1 1s66ms others 1 1s66ms psql - unix(3182395@a2tech):8963 Total 1 1s92ms others 1 1s92ms psql - unix(3182469@a2tech):8963 Total 1 243ms others 1 243ms psql - unix(3182536@a2tech):8963 Total 1 1s30ms others 1 1s30ms psql - unix(3182661@a2tech):8963 Total 1 1s75ms others 1 1s75ms psql - unix(3182812@a2tech):8963 Total 1 3m4s select 1 3m4s psql - unix(3182820@a2tech):8963 Total 1 1s249ms others 1 1s249ms psql - unix(3182884@a2tech):8963 Total 1 17s706ms select 1 17s706ms psql - unix(3182892@a2tech):8963 Total 1 8s191ms select 1 8s191ms psql - unix(3182898@a2tech):8963 Total 1 2m9s select 1 2m9s psql - unix(3182921@a2tech):8963 Total 1 531ms select 1 531ms psql - unix(3182926@a2tech):8963 Total 1 337ms select 1 337ms psql - unix(3182986@a2tech):8963 Total 1 1s43ms others 1 1s43ms psql - unix(3183057@a2tech):8963 Total 1 231ms others 1 231ms psql - unix(3183059@a2tech):8963 Total 1 221ms others 1 221ms psql - unix(3183116@a2tech):8963 Total 1 1s133ms others 1 1s133ms psql - unix(3183243@a2tech):8963 Total 1 1s89ms others 1 1s89ms psql - unix(3183315@a2tech):8963 Total 1 228ms others 1 228ms psql - unix(3183320@a2tech):8963 Total 1 218ms others 1 218ms psql - unix(3183376@a2tech):8963 Total 1 1s26ms others 1 1s26ms psql - unix(3183494@a2tech):8963 Total 1 1s34ms others 1 1s34ms psql - unix(3183707@a2tech):8963 Total 1 1s115ms others 1 1s115ms psql - unix(3183708@a2tech):8963 Total 1 3m10s select 1 3m10s psql - unix(3183771@a2tech):8963 Total 1 17s493ms select 1 17s493ms psql - unix(3183777@a2tech):8963 Total 1 8s104ms select 1 8s104ms psql - unix(3183784@a2tech):8963 Total 1 2m10s select 1 2m10s psql - unix(3183807@a2tech):8963 Total 1 546ms select 1 546ms psql - unix(3183811@a2tech):8963 Total 1 349ms select 1 349ms psql - unix(3183871@a2tech):8963 Total 1 1s48ms others 1 1s48ms psql - unix(3183941@a2tech):8963 Total 1 233ms others 1 233ms psql - unix(3184001@a2tech):8963 Total 1 1s81ms others 1 1s81ms psql - unix(3184009@a2tech):8963 Total 1 152ms others 1 152ms psql - unix(3184129@a2tech):8963 Total 1 1s52ms others 1 1s52ms psql - unix(3184204@a2tech):8963 Total 1 208ms others 1 208ms psql - unix(3184264@a2tech):8963 Total 1 1s42ms others 1 1s42ms psql - unix(3184389@a2tech):8963 Total 1 1s112ms others 1 1s112ms psql - unix(3184540@a2tech):8963 Total 1 3m4s select 1 3m4s psql - unix(3184547@a2tech):8963 Total 1 1s76ms others 1 1s76ms psql - unix(3184605@a2tech):8963 Total 1 17s512ms select 1 17s512ms psql - unix(3184613@a2tech):8963 Total 1 8s254ms select 1 8s254ms psql - unix(3184617@a2tech):8963 Total 1 2m9s select 1 2m9s psql - unix(3184643@a2tech):8963 Total 1 559ms select 1 559ms psql - unix(3184647@a2tech):8963 Total 1 387ms select 1 387ms psql - unix(3184704@a2tech):8963 Total 1 1s6ms others 1 1s6ms psql - unix(3184775@a2tech):8963 Total 1 222ms others 1 222ms psql - unix(3184836@a2tech):8963 Total 1 1s41ms others 1 1s41ms psql - unix(3184844@a2tech):8963 Total 1 158ms others 1 158ms psql - unix(3184960@a2tech):8963 Total 1 1s146ms others 1 1s146ms psql - unix(3185038@a2tech):8963 Total 1 250ms others 1 250ms psql - unix(3185040@a2tech):8963 Total 1 219ms others 1 219ms psql - unix(3185096@a2tech):8963 Total 1 1s44ms others 1 1s44ms psql - unix(3185104@a2tech):8963 Total 1 167ms others 1 167ms psql - unix(3185214@a2tech):8963 Total 1 1s6ms others 1 1s6ms psql - unix(3185289@a2tech):8963 Total 1 220ms others 1 220ms psql - unix(3185368@a2tech):8963 Total 1 3m5s select 1 3m5s psql - unix(3185371@a2tech):8963 Total 1 1s73ms others 1 1s73ms psql - unix(3185426@a2tech):8963 Total 1 17s118ms select 1 17s118ms psql - unix(3185434@a2tech):8963 Total 1 8s173ms select 1 8s173ms psql - unix(3185438@a2tech):8963 Total 1 2m9s select 1 2m9s psql - unix(3185465@a2tech):8963 Total 1 560ms select 1 560ms psql - unix(3185469@a2tech):8963 Total 1 343ms select 1 343ms psql - unix(3185523@a2tech):8963 Total 1 1s51ms others 1 1s51ms psql - unix(3185592@a2tech):8963 Total 1 223ms others 1 223ms psql - unix(3185656@a2tech):8963 Total 1 1s78ms others 1 1s78ms psql - unix(3185784@a2tech):8963 Total 1 1s41ms others 1 1s41ms psql - unix(3185857@a2tech):8963 Total 1 154ms others 1 154ms psql - unix(3185914@a2tech):8963 Total 1 1s68ms others 1 1s68ms psql - unix(3185922@a2tech):8963 Total 1 156ms others 1 156ms psql - unix(3186051@a2tech):8963 Total 1 1s34ms others 1 1s34ms psql - unix(3186128@a2tech):8963 Total 1 252ms others 1 252ms psql - unix(3186132@a2tech):8963 Total 1 237ms others 1 237ms psql - unix(3186253@a2tech):8963 Total 1 3m9s select 1 3m9s psql - unix(3186257@a2tech):8963 Total 1 1s71ms others 1 1s71ms psql - unix(3186315@a2tech):8963 Total 1 17s453ms select 1 17s453ms psql - unix(3186324@a2tech):8963 Total 1 8s123ms select 1 8s123ms psql - unix(3186329@a2tech):8963 Total 1 2m9s select 1 2m9s psql - unix(3186355@a2tech):8963 Total 1 525ms select 1 525ms psql - unix(3186360@a2tech):8963 Total 1 339ms select 1 339ms psql - unix(3186414@a2tech):8963 Total 1 1s148ms others 1 1s148ms psql - unix(3186484@a2tech):8963 Total 1 273ms others 1 273ms psql - unix(3186487@a2tech):8963 Total 1 217ms others 1 217ms psql - unix(3186544@a2tech):8963 Total 1 1s76ms others 1 1s76ms psql - unix(3186670@a2tech):8963 Total 1 1s85ms others 1 1s85ms psql - unix(3186741@a2tech):8963 Total 1 157ms others 1 157ms psql - unix(3186803@a2tech):8963 Total 1 1s27ms others 1 1s27ms psql - unix(3186926@a2tech):8963 Total 1 1s50ms others 1 1s50ms psql - unix(3186998@a2tech):8963 Total 1 153ms others 1 153ms psql - unix(3187001@a2tech):8963 Total 1 247ms others 1 247ms psql - unix(3187088@a2tech):8963 Total 1 3m4s select 1 3m4s psql - unix(3187096@a2tech):8963 Total 1 1s294ms others 1 1s294ms psql - unix(3187178@a2tech):8963 Total 1 17s405ms select 1 17s405ms psql - unix(3187188@a2tech):8963 Total 1 8s107ms select 1 8s107ms psql - unix(3187193@a2tech):8963 Total 1 2m10s select 1 2m10s psql - unix(3187221@a2tech):8963 Total 1 507ms select 1 507ms psql - unix(3187224@a2tech):8963 Total 1 325ms select 1 325ms psql - unix(3187283@a2tech):8963 Total 1 1s45ms others 1 1s45ms psql - unix(3187360@a2tech):8963 Total 1 275ms others 1 275ms psql - unix(3187363@a2tech):8963 Total 1 215ms others 1 215ms psql - unix(3187420@a2tech):8963 Total 1 1s67ms others 1 1s67ms psql - unix(3187563@a2tech):8963 Total 1 1s48ms others 1 1s48ms psql - unix(3187698@a2tech):8963 Total 1 1s37ms others 1 1s37ms psql - unix(3187824@a2tech):8963 Total 1 1s359ms others 1 1s359ms psql - unix(3187897@a2tech):8963 Total 1 162ms others 1 162ms psql - unix(3187992@a2tech):8963 Total 1 3m15s select 1 3m15s psql - unix(3188000@a2tech):8963 Total 1 1s739ms others 1 1s739ms psql - unix(3188012@a2tech):8963 Total 1 277ms others 1 277ms psql - unix(3188063@a2tech):8963 Total 1 21s376ms select 1 21s376ms psql - unix(3188075@a2tech):8963 Total 1 9s51ms select 1 9s51ms psql - unix(3188079@a2tech):8963 Total 1 2m11s select 1 2m11s psql - unix(3188107@a2tech):8963 Total 1 707ms select 1 707ms psql - unix(3188110@a2tech):8963 Total 1 452ms select 1 452ms psql - unix(3188161@a2tech):8963 Total 1 1s436ms others 1 1s436ms psql - unix(3188170@a2tech):8963 Total 1 159ms others 1 159ms psql - unix(3188241@a2tech):8963 Total 1 252ms others 1 252ms psql - unix(3188243@a2tech):8963 Total 1 209ms others 1 209ms psql - unix(3188298@a2tech):8963 Total 1 1s131ms others 1 1s131ms psql - unix(3188424@a2tech):8963 Total 1 1s222ms others 1 1s222ms psql - unix(3188496@a2tech):8963 Total 1 242ms others 1 242ms psql - unix(3188561@a2tech):8963 Total 1 1s19ms others 1 1s19ms psql - unix(3188679@a2tech):8963 Total 1 1s49ms others 1 1s49ms psql - unix(3188833@a2tech):8963 Total 1 1s133ms others 1 1s133ms psql - unix(3188834@a2tech):8963 Total 1 3m5s select 1 3m5s psql - unix(3188891@a2tech):8963 Total 1 17s76ms select 1 17s76ms psql - unix(3188898@a2tech):8963 Total 1 8s215ms select 1 8s215ms psql - unix(3188903@a2tech):8963 Total 1 2m10s select 1 2m10s psql - unix(3188931@a2tech):8963 Total 1 537ms select 1 537ms psql - unix(3188935@a2tech):8963 Total 1 337ms select 1 337ms psql - unix(3189023@a2tech):8963 Total 1 1s39ms others 1 1s39ms psql - unix(3189100@a2tech):8963 Total 1 224ms others 1 224ms psql - unix(3189160@a2tech):8963 Total 1 1s156ms others 1 1s156ms psql - unix(3189303@a2tech):8963 Total 1 1s62ms others 1 1s62ms psql - unix(3189314@a2tech):8963 Total 1 166ms others 1 166ms psql - unix(3189379@a2tech):8963 Total 1 227ms others 1 227ms psql - unix(3189439@a2tech):8963 Total 1 1s51ms others 1 1s51ms psql - unix(3189558@a2tech):8963 Total 1 1s88ms others 1 1s88ms psql - unix(3189732@a2tech):8963 Total 1 3m11s select 1 3m11s psql - unix(3189756@a2tech):8963 Total 1 1s135ms others 1 1s135ms psql - unix(3189884@a2tech):8963 Total 1 17s503ms select 1 17s503ms psql - unix(3189892@a2tech):8963 Total 1 8s159ms select 1 8s159ms psql - unix(3189897@a2tech):8963 Total 1 2m10s select 1 2m10s psql - unix(3189923@a2tech):8963 Total 1 548ms select 1 548ms psql - unix(3189928@a2tech):8963 Total 1 391ms select 1 391ms psql - unix(3189985@a2tech):8963 Total 1 1s55ms others 1 1s55ms psql - unix(3189993@a2tech):8963 Total 1 152ms others 1 152ms psql - unix(3190064@a2tech):8963 Total 1 238ms others 1 238ms psql - unix(3190068@a2tech):8963 Total 1 243ms others 1 243ms psql - unix(3190129@a2tech):8963 Total 1 1s88ms others 1 1s88ms psql - unix(3190138@a2tech):8963 Total 1 153ms others 1 153ms psql - unix(3190282@a2tech):8963 Total 1 1s91ms others 1 1s91ms psql - unix(3190358@a2tech):8963 Total 1 231ms others 1 231ms psql - unix(3190360@a2tech):8963 Total 1 152ms others 1 152ms psql - unix(3190420@a2tech):8963 Total 1 1s78ms others 1 1s78ms psql - unix(3190537@a2tech):8963 Total 1 1s44ms others 1 1s44ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-03 20:51:27 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 385 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 3m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-03 07:08:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3176759@a2tech):8963 ]
2 3m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-03 20:08:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3187992@a2tech):8963 ]
3 3m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-03 22:08:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3189732@a2tech):8963 ]
4 3m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-03 15:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3183708@a2tech):8963 ]
5 3m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-03 18:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3186253@a2tech):8963 ]
6 3m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-03 09:08:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3178557@a2tech):8963 ]
7 3m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-03 11:08:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3180216@a2tech):8963 ]
8 3m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-03 21:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3188834@a2tech):8963 ]
9 3m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-03 17:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3185368@a2tech):8963 ]
10 3m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-03 08:08:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3177571@a2tech):8963 ]
11 3m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-03 19:08:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3187088@a2tech):8963 ]
12 3m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-03 14:08:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3182812@a2tech):8963 ]
13 3m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-03 16:08:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3184540@a2tech):8963 ]
14 3m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-03 10:08:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3179382@a2tech):8963 ]
15 3m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-03 12:08:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3181091@a2tech):8963 ]
16 3m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-03 13:08:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql - unix(3181963@a2tech):8963 ]
17 2m12s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-05-03 07:11:05 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3176834@a2tech):8963 ]
18 2m11s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-05-03 20:11:00 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3188079@a2tech):8963 ]
19 2m10s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-05-03 15:10:50 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3183784@a2tech):8963 ]
20 2m10s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-05-03 12:10:43 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql - unix(3181164@a2tech):8963 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 52m26s 48 492ms 3m18s 1m5s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 03 07 3 3m28s 1m9s 08 3 3m14s 1m4s 09 3 3m16s 1m5s 10 3 3m13s 1m4s 11 3 3m16s 1m5s 12 3 3m13s 1m4s 13 3 3m12s 1m4s 14 3 3m13s 1m4s 15 3 3m18s 1m6s 16 3 3m13s 1m4s 17 3 3m14s 1m4s 18 3 3m18s 1m6s 19 3 3m13s 1m4s 20 3 3m25s 1m8s 21 3 3m14s 1m4s 22 3 3m19s 1m6s [ User: intelifix - Total duration: 52m26s - Times executed: 48 ]
[ Application: psql - unix(3176759@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(3187992@a2tech):8963 - Total duration: 3m15s - Times executed: 1 ]
[ Application: psql - unix(3189732@a2tech):8963 - Total duration: 3m11s - Times executed: 1 ]
[ Application: psql - unix(3183708@a2tech):8963 - Total duration: 3m10s - Times executed: 1 ]
[ Application: psql - unix(3186253@a2tech):8963 - Total duration: 3m9s - Times executed: 1 ]
[ Application: psql - unix(3178557@a2tech):8963 - Total duration: 3m7s - Times executed: 1 ]
[ Application: psql - unix(3180216@a2tech):8963 - Total duration: 3m7s - Times executed: 1 ]
[ Application: psql - unix(3188834@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3185368@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3177571@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3187088@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3182812@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3184540@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3179382@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3181091@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3181963@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3176830@a2tech):8963 - Total duration: 9s840ms - Times executed: 1 ]
[ Application: psql - unix(3188075@a2tech):8963 - Total duration: 9s51ms - Times executed: 1 ]
[ Application: psql - unix(3181159@a2tech):8963 - Total duration: 8s451ms - Times executed: 1 ]
[ Application: psql - unix(3182039@a2tech):8963 - Total duration: 8s276ms - Times executed: 1 ]
[ Application: psql - unix(3179451@a2tech):8963 - Total duration: 8s262ms - Times executed: 1 ]
[ Application: psql - unix(3184613@a2tech):8963 - Total duration: 8s254ms - Times executed: 1 ]
[ Application: psql - unix(3188898@a2tech):8963 - Total duration: 8s215ms - Times executed: 1 ]
[ Application: psql - unix(3178628@a2tech):8963 - Total duration: 8s215ms - Times executed: 1 ]
[ Application: psql - unix(3180290@a2tech):8963 - Total duration: 8s192ms - Times executed: 1 ]
[ Application: psql - unix(3182892@a2tech):8963 - Total duration: 8s191ms - Times executed: 1 ]
[ Application: psql - unix(3185434@a2tech):8963 - Total duration: 8s173ms - Times executed: 1 ]
[ Application: psql - unix(3189892@a2tech):8963 - Total duration: 8s159ms - Times executed: 1 ]
[ Application: psql - unix(3177649@a2tech):8963 - Total duration: 8s140ms - Times executed: 1 ]
[ Application: psql - unix(3186324@a2tech):8963 - Total duration: 8s123ms - Times executed: 1 ]
[ Application: psql - unix(3187188@a2tech):8963 - Total duration: 8s107ms - Times executed: 1 ]
[ Application: psql - unix(3183777@a2tech):8963 - Total duration: 8s104ms - Times executed: 1 ]
[ Application: psql - unix(3176862@a2tech):8963 - Total duration: 768ms - Times executed: 1 ]
[ Application: psql - unix(3188107@a2tech):8963 - Total duration: 707ms - Times executed: 1 ]
[ Application: psql - unix(3180321@a2tech):8963 - Total duration: 562ms - Times executed: 1 ]
[ Application: psql - unix(3185465@a2tech):8963 - Total duration: 560ms - Times executed: 1 ]
[ Application: psql - unix(3184643@a2tech):8963 - Total duration: 559ms - Times executed: 1 ]
[ Application: psql - unix(3178657@a2tech):8963 - Total duration: 549ms - Times executed: 1 ]
[ Application: psql - unix(3189923@a2tech):8963 - Total duration: 548ms - Times executed: 1 ]
[ Application: psql - unix(3183807@a2tech):8963 - Total duration: 546ms - Times executed: 1 ]
[ Application: psql - unix(3181191@a2tech):8963 - Total duration: 542ms - Times executed: 1 ]
[ Application: psql - unix(3179480@a2tech):8963 - Total duration: 538ms - Times executed: 1 ]
[ Application: psql - unix(3188931@a2tech):8963 - Total duration: 537ms - Times executed: 1 ]
[ Application: psql - unix(3182921@a2tech):8963 - Total duration: 531ms - Times executed: 1 ]
[ Application: psql - unix(3182070@a2tech):8963 - Total duration: 526ms - Times executed: 1 ]
[ Application: psql - unix(3186355@a2tech):8963 - Total duration: 525ms - Times executed: 1 ]
[ Application: psql - unix(3187221@a2tech):8963 - Total duration: 507ms - Times executed: 1 ]
[ Application: psql - unix(3177681@a2tech):8963 - Total duration: 492ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-03 07:08:20 Duration: 3m18s Database: rio User: intelifix Remote: [local] Application: psql - unix(3176759@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-03 20:08:18 Duration: 3m15s Database: rio User: intelifix Remote: [local] Application: psql - unix(3187992@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-03 22:08:14 Duration: 3m11s Database: rio User: intelifix Remote: [local] Application: psql - unix(3189732@a2tech):8963
2 39m36s 48 325ms 2m12s 49s513ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 03 07 3 2m34s 51s546ms 08 3 2m27s 49s202ms 09 3 2m28s 49s352ms 10 3 2m27s 49s221ms 11 3 2m27s 49s155ms 12 3 2m27s 49s312ms 13 3 2m27s 49s179ms 14 3 2m28s 49s340ms 15 3 2m28s 49s501ms 16 3 2m27s 49s290ms 17 3 2m27s 49s140ms 18 3 2m27s 49s148ms 19 3 2m27s 49s294ms 20 3 2m33s 51s49ms 21 3 2m27s 49s155ms 22 3 2m27s 49s323ms [ User: intelifix - Total duration: 39m36s - Times executed: 48 ]
[ Application: psql - unix(3176834@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(3188079@a2tech):8963 - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - unix(3183784@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3181164@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3187193@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3178632@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3189897@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3188903@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3182898@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3184617@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3185438@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3179456@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3182044@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3177654@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3186329@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3180295@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3176822@a2tech):8963 - Total duration: 21s517ms - Times executed: 1 ]
[ Application: psql - unix(3188063@a2tech):8963 - Total duration: 21s376ms - Times executed: 1 ]
[ Application: psql - unix(3182884@a2tech):8963 - Total duration: 17s706ms - Times executed: 1 ]
[ Application: psql - unix(3180279@a2tech):8963 - Total duration: 17s635ms - Times executed: 1 ]
[ Application: psql - unix(3178620@a2tech):8963 - Total duration: 17s586ms - Times executed: 1 ]
[ Application: psql - unix(3177642@a2tech):8963 - Total duration: 17s551ms - Times executed: 1 ]
[ Application: psql - unix(3184605@a2tech):8963 - Total duration: 17s512ms - Times executed: 1 ]
[ Application: psql - unix(3189884@a2tech):8963 - Total duration: 17s503ms - Times executed: 1 ]
[ Application: psql - unix(3183771@a2tech):8963 - Total duration: 17s493ms - Times executed: 1 ]
[ Application: psql - unix(3179441@a2tech):8963 - Total duration: 17s454ms - Times executed: 1 ]
[ Application: psql - unix(3186315@a2tech):8963 - Total duration: 17s453ms - Times executed: 1 ]
[ Application: psql - unix(3187178@a2tech):8963 - Total duration: 17s405ms - Times executed: 1 ]
[ Application: psql - unix(3182030@a2tech):8963 - Total duration: 17s346ms - Times executed: 1 ]
[ Application: psql - unix(3181150@a2tech):8963 - Total duration: 17s210ms - Times executed: 1 ]
[ Application: psql - unix(3185426@a2tech):8963 - Total duration: 17s118ms - Times executed: 1 ]
[ Application: psql - unix(3188891@a2tech):8963 - Total duration: 17s76ms - Times executed: 1 ]
[ Application: psql - unix(3188110@a2tech):8963 - Total duration: 452ms - Times executed: 1 ]
[ Application: psql - unix(3176867@a2tech):8963 - Total duration: 446ms - Times executed: 1 ]
[ Application: psql - unix(3189928@a2tech):8963 - Total duration: 391ms - Times executed: 1 ]
[ Application: psql - unix(3184647@a2tech):8963 - Total duration: 387ms - Times executed: 1 ]
[ Application: psql - unix(3180325@a2tech):8963 - Total duration: 356ms - Times executed: 1 ]
[ Application: psql - unix(3179483@a2tech):8963 - Total duration: 356ms - Times executed: 1 ]
[ Application: psql - unix(3183811@a2tech):8963 - Total duration: 349ms - Times executed: 1 ]
[ Application: psql - unix(3178660@a2tech):8963 - Total duration: 349ms - Times executed: 1 ]
[ Application: psql - unix(3182074@a2tech):8963 - Total duration: 347ms - Times executed: 1 ]
[ Application: psql - unix(3185469@a2tech):8963 - Total duration: 343ms - Times executed: 1 ]
[ Application: psql - unix(3181195@a2tech):8963 - Total duration: 342ms - Times executed: 1 ]
[ Application: psql - unix(3186360@a2tech):8963 - Total duration: 339ms - Times executed: 1 ]
[ Application: psql - unix(3182926@a2tech):8963 - Total duration: 337ms - Times executed: 1 ]
[ Application: psql - unix(3188935@a2tech):8963 - Total duration: 337ms - Times executed: 1 ]
[ Application: psql - unix(3177684@a2tech):8963 - Total duration: 329ms - Times executed: 1 ]
[ Application: psql - unix(3187224@a2tech):8963 - Total duration: 325ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-03 07:11:05 Duration: 2m12s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3176834@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-03 20:11:00 Duration: 2m11s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3188079@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-03 15:10:50 Duration: 2m10s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3183784@a2tech):8963
3 4m9s 3 57s484ms 1m53s 1m23s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 03 05 3 4m9s 1m23s [ User: intelifix - Total duration: 4m9s - Times executed: 3 ]
[ Application: psql - unix(3175051@a2tech):8963 - Total duration: 1m53s - Times executed: 1 ]
[ Application: psql - unix(3175084@a2tech):8963 - Total duration: 1m18s - Times executed: 1 ]
[ Application: psql - unix(3175095@a2tech):8963 - Total duration: 57s484ms - Times executed: 1 ]
-
analyze verbose;
Date: 2026-05-03 05:01:54 Duration: 1m53s Database: rio User: intelifix Remote: [local] Application: psql - unix(3175051@a2tech):8963
-
analyze verbose;
Date: 2026-05-03 05:03:13 Duration: 1m18s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3175084@a2tech):8963
-
analyze verbose;
Date: 2026-05-03 05:04:11 Duration: 57s484ms Database: contagem User: intelifix Remote: [local] Application: psql - unix(3175095@a2tech):8963
4 2m34s 159 151ms 2s56ms 974ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 03 00 7 7s755ms 1s107ms 01 7 6s523ms 931ms 02 8 6s940ms 867ms 03 8 7s62ms 882ms 04 7 6s511ms 930ms 05 7 6s628ms 946ms 06 7 6s574ms 939ms 07 7 6s693ms 956ms 08 7 6s609ms 944ms 09 6 6s341ms 1s56ms 10 7 6s790ms 970ms 11 6 6s544ms 1s90ms 12 6 6s373ms 1s62ms 13 6 6s435ms 1s72ms 14 6 6s577ms 1s96ms 15 7 6s606ms 943ms 16 8 6s648ms 831ms 17 7 6s504ms 929ms 18 6 6s459ms 1s76ms 19 6 6s853ms 1s142ms 20 8 8s35ms 1s4ms 21 7 6s699ms 957ms 22 8 6s800ms 850ms [ User: intelifix - Total duration: 2m34s - Times executed: 159 ]
[ Application: psql - unix(3170819@a2tech):8963 - Total duration: 2s56ms - Times executed: 1 ]
[ Application: psql - unix(3188000@a2tech):8963 - Total duration: 1s739ms - Times executed: 1 ]
[ Application: psql - unix(3188161@a2tech):8963 - Total duration: 1s436ms - Times executed: 1 ]
[ Application: psql - unix(3187824@a2tech):8963 - Total duration: 1s359ms - Times executed: 1 ]
[ Application: psql - unix(3187096@a2tech):8963 - Total duration: 1s294ms - Times executed: 1 ]
[ Application: psql - unix(3179385@a2tech):8963 - Total duration: 1s253ms - Times executed: 1 ]
[ Application: psql - unix(3182820@a2tech):8963 - Total duration: 1s249ms - Times executed: 1 ]
[ Application: psql - unix(3173524@a2tech):8963 - Total duration: 1s245ms - Times executed: 1 ]
[ Application: psql - unix(3188424@a2tech):8963 - Total duration: 1s222ms - Times executed: 1 ]
[ Application: psql - unix(3172805@a2tech):8963 - Total duration: 1s195ms - Times executed: 1 ]
[ Application: psql - unix(3173921@a2tech):8963 - Total duration: 1s179ms - Times executed: 1 ]
[ Application: psql - unix(3176765@a2tech):8963 - Total duration: 1s174ms - Times executed: 1 ]
[ Application: psql - unix(3189160@a2tech):8963 - Total duration: 1s156ms - Times executed: 1 ]
[ Application: psql - unix(3175260@a2tech):8963 - Total duration: 1s155ms - Times executed: 1 ]
[ Application: psql - unix(3186414@a2tech):8963 - Total duration: 1s148ms - Times executed: 1 ]
[ Application: psql - unix(3184960@a2tech):8963 - Total duration: 1s146ms - Times executed: 1 ]
[ Application: psql - unix(3174166@a2tech):8963 - Total duration: 1s139ms - Times executed: 1 ]
[ Application: psql - unix(3180811@a2tech):8963 - Total duration: 1s136ms - Times executed: 1 ]
[ Application: psql - unix(3189756@a2tech):8963 - Total duration: 1s135ms - Times executed: 1 ]
[ Application: psql - unix(3188833@a2tech):8963 - Total duration: 1s133ms - Times executed: 1 ]
[ Application: psql - unix(3183116@a2tech):8963 - Total duration: 1s133ms - Times executed: 1 ]
[ Application: psql - unix(3188298@a2tech):8963 - Total duration: 1s131ms - Times executed: 1 ]
[ Application: psql - unix(3181810@a2tech):8963 - Total duration: 1s131ms - Times executed: 1 ]
[ Application: psql - unix(3180552@a2tech):8963 - Total duration: 1s129ms - Times executed: 1 ]
[ Application: psql - unix(3181971@a2tech):8963 - Total duration: 1s127ms - Times executed: 1 ]
[ Application: psql - unix(3176362@a2tech):8963 - Total duration: 1s127ms - Times executed: 1 ]
[ Application: psql - unix(3179671@a2tech):8963 - Total duration: 1s123ms - Times executed: 1 ]
[ Application: psql - unix(3177578@a2tech):8963 - Total duration: 1s123ms - Times executed: 1 ]
[ Application: psql - unix(3172677@a2tech):8963 - Total duration: 1s120ms - Times executed: 1 ]
[ Application: psql - unix(3171244@a2tech):8963 - Total duration: 1s117ms - Times executed: 1 ]
[ Application: psql - unix(3175537@a2tech):8963 - Total duration: 1s117ms - Times executed: 1 ]
[ Application: psql - unix(3183707@a2tech):8963 - Total duration: 1s115ms - Times executed: 1 ]
[ Application: psql - unix(3184389@a2tech):8963 - Total duration: 1s112ms - Times executed: 1 ]
[ Application: psql - unix(3174740@a2tech):8963 - Total duration: 1s112ms - Times executed: 1 ]
[ Application: psql - unix(3177168@a2tech):8963 - Total duration: 1s107ms - Times executed: 1 ]
[ Application: psql - unix(3181095@a2tech):8963 - Total duration: 1s107ms - Times executed: 1 ]
[ Application: psql - unix(3172556@a2tech):8963 - Total duration: 1s106ms - Times executed: 1 ]
[ Application: psql - unix(3178564@a2tech):8963 - Total duration: 1s104ms - Times executed: 1 ]
[ Application: psql - unix(3175968@a2tech):8963 - Total duration: 1s100ms - Times executed: 1 ]
[ Application: psql - unix(3172432@a2tech):8963 - Total duration: 1s98ms - Times executed: 1 ]
[ Application: psql - unix(3178066@a2tech):8963 - Total duration: 1s98ms - Times executed: 1 ]
[ Application: psql - unix(3177038@a2tech):8963 - Total duration: 1s97ms - Times executed: 1 ]
[ Application: psql - unix(3179799@a2tech):8963 - Total duration: 1s94ms - Times executed: 1 ]
[ Application: psql - unix(3182395@a2tech):8963 - Total duration: 1s92ms - Times executed: 1 ]
[ Application: psql - unix(3171644@a2tech):8963 - Total duration: 1s92ms - Times executed: 1 ]
[ Application: psql - unix(3180677@a2tech):8963 - Total duration: 1s91ms - Times executed: 1 ]
[ Application: psql - unix(3190282@a2tech):8963 - Total duration: 1s91ms - Times executed: 1 ]
[ Application: psql - unix(3170960@a2tech):8963 - Total duration: 1s90ms - Times executed: 1 ]
[ Application: psql - unix(3177775@a2tech):8963 - Total duration: 1s90ms - Times executed: 1 ]
[ Application: psql - unix(3183243@a2tech):8963 - Total duration: 1s89ms - Times executed: 1 ]
[ Application: psql - unix(3174605@a2tech):8963 - Total duration: 1s89ms - Times executed: 1 ]
[ Application: psql - unix(3189558@a2tech):8963 - Total duration: 1s88ms - Times executed: 1 ]
[ Application: psql - unix(3175131@a2tech):8963 - Total duration: 1s88ms - Times executed: 1 ]
[ Application: psql - unix(3190129@a2tech):8963 - Total duration: 1s88ms - Times executed: 1 ]
[ Application: psql - unix(3172017@a2tech):8963 - Total duration: 1s86ms - Times executed: 1 ]
[ Application: psql - unix(3180391@a2tech):8963 - Total duration: 1s86ms - Times executed: 1 ]
[ Application: psql - unix(3186670@a2tech):8963 - Total duration: 1s85ms - Times executed: 1 ]
[ Application: psql - unix(3171083@a2tech):8963 - Total duration: 1s84ms - Times executed: 1 ]
[ Application: psql - unix(3173658@a2tech):8963 - Total duration: 1s83ms - Times executed: 1 ]
[ Application: psql - unix(3176613@a2tech):8963 - Total duration: 1s82ms - Times executed: 1 ]
[ Application: psql - unix(3179935@a2tech):8963 - Total duration: 1s81ms - Times executed: 1 ]
[ Application: psql - unix(3184001@a2tech):8963 - Total duration: 1s81ms - Times executed: 1 ]
[ Application: psql - unix(3174307@a2tech):8963 - Total duration: 1s81ms - Times executed: 1 ]
[ Application: psql - unix(3178278@a2tech):8963 - Total duration: 1s80ms - Times executed: 1 ]
[ Application: psql - unix(3190420@a2tech):8963 - Total duration: 1s78ms - Times executed: 1 ]
[ Application: psql - unix(3185656@a2tech):8963 - Total duration: 1s78ms - Times executed: 1 ]
[ Application: psql - unix(3177296@a2tech):8963 - Total duration: 1s76ms - Times executed: 1 ]
[ Application: psql - unix(3184547@a2tech):8963 - Total duration: 1s76ms - Times executed: 1 ]
[ Application: psql - unix(3186544@a2tech):8963 - Total duration: 1s76ms - Times executed: 1 ]
[ Application: psql - unix(3182661@a2tech):8963 - Total duration: 1s75ms - Times executed: 1 ]
[ Application: psql - unix(3185371@a2tech):8963 - Total duration: 1s73ms - Times executed: 1 ]
[ Application: psql - unix(3180222@a2tech):8963 - Total duration: 1s72ms - Times executed: 1 ]
[ Application: psql - unix(3186257@a2tech):8963 - Total duration: 1s71ms - Times executed: 1 ]
[ Application: psql - unix(3173055@a2tech):8963 - Total duration: 1s68ms - Times executed: 1 ]
[ Application: psql - unix(3185914@a2tech):8963 - Total duration: 1s68ms - Times executed: 1 ]
[ Application: psql - unix(3171369@a2tech):8963 - Total duration: 1s68ms - Times executed: 1 ]
[ Application: psql - unix(3187420@a2tech):8963 - Total duration: 1s67ms - Times executed: 1 ]
[ Application: psql - unix(3182268@a2tech):8963 - Total duration: 1s66ms - Times executed: 1 ]
[ Application: psql - unix(3172287@a2tech):8963 - Total duration: 1s62ms - Times executed: 1 ]
[ Application: psql - unix(3189303@a2tech):8963 - Total duration: 1s62ms - Times executed: 1 ]
[ Application: psql - unix(3178714@a2tech):8963 - Total duration: 1s57ms - Times executed: 1 ]
[ Application: psql - unix(3179221@a2tech):8963 - Total duration: 1s56ms - Times executed: 1 ]
[ Application: psql - unix(3189985@a2tech):8963 - Total duration: 1s55ms - Times executed: 1 ]
[ Application: psql - unix(3178841@a2tech):8963 - Total duration: 1s54ms - Times executed: 1 ]
[ Application: psql - unix(3184129@a2tech):8963 - Total duration: 1s52ms - Times executed: 1 ]
[ Application: psql - unix(3189439@a2tech):8963 - Total duration: 1s51ms - Times executed: 1 ]
[ Application: psql - unix(3185523@a2tech):8963 - Total duration: 1s51ms - Times executed: 1 ]
[ Application: psql - unix(3171774@a2tech):8963 - Total duration: 1s51ms - Times executed: 1 ]
[ Application: psql - unix(3179538@a2tech):8963 - Total duration: 1s51ms - Times executed: 1 ]
[ Application: psql - unix(3171498@a2tech):8963 - Total duration: 1s51ms - Times executed: 1 ]
[ Application: psql - unix(3186926@a2tech):8963 - Total duration: 1s50ms - Times executed: 1 ]
[ Application: psql - unix(3176918@a2tech):8963 - Total duration: 1s49ms - Times executed: 1 ]
[ Application: psql - unix(3188679@a2tech):8963 - Total duration: 1s49ms - Times executed: 1 ]
[ Application: psql - unix(3183871@a2tech):8963 - Total duration: 1s48ms - Times executed: 1 ]
[ Application: psql - unix(3187563@a2tech):8963 - Total duration: 1s48ms - Times executed: 1 ]
[ Application: psql - unix(3178970@a2tech):8963 - Total duration: 1s48ms - Times executed: 1 ]
[ Application: psql - unix(3181381@a2tech):8963 - Total duration: 1s46ms - Times executed: 1 ]
[ Application: psql - unix(3187283@a2tech):8963 - Total duration: 1s45ms - Times executed: 1 ]
[ Application: psql - unix(3175377@a2tech):8963 - Total duration: 1s44ms - Times executed: 1 ]
[ Application: psql - unix(3185096@a2tech):8963 - Total duration: 1s44ms - Times executed: 1 ]
[ Application: psql - unix(3190537@a2tech):8963 - Total duration: 1s44ms - Times executed: 1 ]
[ Application: psql - unix(3176103@a2tech):8963 - Total duration: 1s43ms - Times executed: 1 ]
[ Application: psql - unix(3182986@a2tech):8963 - Total duration: 1s43ms - Times executed: 1 ]
[ Application: psql - unix(3182131@a2tech):8963 - Total duration: 1s42ms - Times executed: 1 ]
[ Application: psql - unix(3184264@a2tech):8963 - Total duration: 1s42ms - Times executed: 1 ]
[ Application: psql - unix(3171896@a2tech):8963 - Total duration: 1s42ms - Times executed: 1 ]
[ Application: psql - unix(3173782@a2tech):8963 - Total duration: 1s41ms - Times executed: 1 ]
[ Application: psql - unix(3185784@a2tech):8963 - Total duration: 1s41ms - Times executed: 1 ]
[ Application: psql - unix(3184836@a2tech):8963 - Total duration: 1s41ms - Times executed: 1 ]
[ Application: psql - unix(3172933@a2tech):8963 - Total duration: 1s39ms - Times executed: 1 ]
[ Application: psql - unix(3189023@a2tech):8963 - Total duration: 1s39ms - Times executed: 1 ]
[ Application: psql - unix(3175666@a2tech):8963 - Total duration: 1s39ms - Times executed: 1 ]
[ Application: psql - unix(3177421@a2tech):8963 - Total duration: 1s37ms - Times executed: 1 ]
[ Application: psql - unix(3187698@a2tech):8963 - Total duration: 1s37ms - Times executed: 1 ]
[ Application: psql - unix(3177911@a2tech):8963 - Total duration: 1s37ms - Times executed: 1 ]
[ Application: psql - unix(3174479@a2tech):8963 - Total duration: 1s36ms - Times executed: 1 ]
[ Application: psql - unix(3181530@a2tech):8963 - Total duration: 1s35ms - Times executed: 1 ]
[ Application: psql - unix(3172147@a2tech):8963 - Total duration: 1s35ms - Times executed: 1 ]
[ Application: psql - unix(3183494@a2tech):8963 - Total duration: 1s34ms - Times executed: 1 ]
[ Application: psql - unix(3186051@a2tech):8963 - Total duration: 1s34ms - Times executed: 1 ]
[ Application: psql - unix(3180067@a2tech):8963 - Total duration: 1s33ms - Times executed: 1 ]
[ Application: psql - unix(3176488@a2tech):8963 - Total duration: 1s33ms - Times executed: 1 ]
[ Application: psql - unix(3175786@a2tech):8963 - Total duration: 1s31ms - Times executed: 1 ]
[ Application: psql - unix(3182536@a2tech):8963 - Total duration: 1s30ms - Times executed: 1 ]
[ Application: psql - unix(3178402@a2tech):8963 - Total duration: 1s28ms - Times executed: 1 ]
[ Application: psql - unix(3180931@a2tech):8963 - Total duration: 1s28ms - Times executed: 1 ]
[ Application: psql - unix(3186803@a2tech):8963 - Total duration: 1s27ms - Times executed: 1 ]
[ Application: psql - unix(3181691@a2tech):8963 - Total duration: 1s27ms - Times executed: 1 ]
[ Application: psql - unix(3176230@a2tech):8963 - Total duration: 1s26ms - Times executed: 1 ]
[ Application: psql - unix(3183376@a2tech):8963 - Total duration: 1s26ms - Times executed: 1 ]
[ Application: psql - unix(3181255@a2tech):8963 - Total duration: 1s25ms - Times executed: 1 ]
[ Application: psql - unix(3174864@a2tech):8963 - Total duration: 1s25ms - Times executed: 1 ]
[ Application: psql - unix(3174043@a2tech):8963 - Total duration: 1s23ms - Times executed: 1 ]
[ Application: psql - unix(3179104@a2tech):8963 - Total duration: 1s20ms - Times executed: 1 ]
[ Application: psql - unix(3188561@a2tech):8963 - Total duration: 1s19ms - Times executed: 1 ]
[ Application: psql - unix(3174981@a2tech):8963 - Total duration: 1s13ms - Times executed: 1 ]
[ Application: psql - unix(3184704@a2tech):8963 - Total duration: 1s6ms - Times executed: 1 ]
[ Application: psql - unix(3185214@a2tech):8963 - Total duration: 1s6ms - Times executed: 1 ]
[ Application: psql - unix(3170833@a2tech):8963 - Total duration: 287ms - Times executed: 1 ]
[ Application: psql - unix(3188012@a2tech):8963 - Total duration: 277ms - Times executed: 1 ]
[ Application: psql - unix(3173932@a2tech):8963 - Total duration: 180ms - Times executed: 1 ]
[ Application: psql - unix(3173538@a2tech):8963 - Total duration: 168ms - Times executed: 1 ]
[ Application: psql - unix(3185104@a2tech):8963 - Total duration: 167ms - Times executed: 1 ]
[ Application: psql - unix(3189314@a2tech):8963 - Total duration: 166ms - Times executed: 1 ]
[ Application: psql - unix(3176621@a2tech):8963 - Total duration: 161ms - Times executed: 1 ]
[ Application: psql - unix(3188170@a2tech):8963 - Total duration: 159ms - Times executed: 1 ]
[ Application: psql - unix(3184844@a2tech):8963 - Total duration: 158ms - Times executed: 1 ]
[ Application: psql - unix(3185922@a2tech):8963 - Total duration: 156ms - Times executed: 1 ]
[ Application: psql - unix(3172816@a2tech):8963 - Total duration: 155ms - Times executed: 1 ]
[ Application: psql - unix(3172687@a2tech):8963 - Total duration: 154ms - Times executed: 1 ]
[ Application: psql - unix(3171904@a2tech):8963 - Total duration: 153ms - Times executed: 1 ]
[ Application: psql - unix(3190138@a2tech):8963 - Total duration: 153ms - Times executed: 1 ]
[ Application: psql - unix(3189993@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
[ Application: psql - unix(3184009@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
[ Application: psql - unix(3174753@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
[ Application: psql - unix(3177589@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
[ Application: psql - unix(3179396@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
[ Application: psql - unix(3175794@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
[ Application: psql - unix(3176776@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-03 00:05:04 Duration: 2s56ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3170819@a2tech):8963
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-03 20:05:04 Duration: 1s739ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3188000@a2tech):8963
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-03 20:15:03 Duration: 1s436ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3188161@a2tech):8963
5 1m42s 4 2s68ms 50s77ms 25s605ms 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 03 20 2 50s131ms 25s65ms 23 2 52s291ms 26s145ms [ User: intelifix - Total duration: 1m42s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m42s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-03 23:29:15 Duration: 50s77ms 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-03 20:06:31 Duration: 48s63ms 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-03 23:37:38 Duration: 2s214ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 1m37s 3 14s366ms 1m2s 32s387ms 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 03 23 3 1m37s 32s387ms [ User: intelifix - Total duration: 1m37s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m37s - 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-03 23:11:50 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-03 23:30:23 Duration: 19s988ms 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-03 23:38:18 Duration: 14s366ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 1m24s 4 270ms 43s145ms 21s55ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 03 20 2 40s763ms 20s381ms 23 2 43s456ms 21s728ms [ 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-03 23:15:22 Duration: 43s145ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-03 20:04:31 Duration: 40s492ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-03 23:31:14 Duration: 310ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m20s 3 13s284ms 50s837ms 26s780ms 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 03 23 3 1m20s 26s780ms [ 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-03 23:12:41 Duration: 50s837ms 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-03 23:30:40 Duration: 16s220ms 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-03 23:38:31 Duration: 13s284ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 1m14s 3 11s367ms 44s968ms 24s835ms 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 03 23 3 1m14s 24s835ms [ User: intelifix - Total duration: 1m14s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m14s - 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-03 23:10:47 Duration: 44s968ms 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-03 23:30:03 Duration: 18s169ms 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-03 23:38:03 Duration: 11s367ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1m8s 6 1s594ms 26s799ms 11s465ms 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 03 20 3 33s58ms 11s19ms 23 3 35s732ms 11s910ms [ User: intelifix - Total duration: 1m8s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m8s - 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-03 23:15:50 Duration: 26s799ms 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-03 20:04:57 Duration: 24s689ms 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-03 23:31:21 Duration: 7s225ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 57s149ms 6 1s178ms 22s978ms 9s524ms 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 03 20 3 27s259ms 9s86ms 23 3 29s889ms 9s963ms [ User: intelifix - Total duration: 57s149ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s149ms - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-03 23:16:15 Duration: 22s978ms 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-03 20:05:20 Duration: 20s886ms 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-03 23:31:27 Duration: 5s604ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 56s793ms 6 2s307ms 22s589ms 9s465ms 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 03 20 3 27s284ms 9s94ms 23 3 29s509ms 9s836ms [ User: intelifix - Total duration: 56s793ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 56s793ms - 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-03 23:29:37 Duration: 22s589ms 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-03 20:06:52 Duration: 20s966ms 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-03 23:37:43 Duration: 4s376ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 46s976ms 6 1s106ms 16s735ms 7s829ms 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 03 20 3 22s576ms 7s525ms 23 3 24s400ms 8s133ms [ User: intelifix - Total duration: 46s976ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 46s976ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-03 23:13:41 Duration: 16s735ms 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-03 20:02:58 Duration: 15s414ms 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-03 23:31:00 Duration: 6s475ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 46s841ms 6 1s196ms 16s181ms 7s806ms 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 03 20 3 22s558ms 7s519ms 23 3 24s282ms 8s94ms [ User: intelifix - Total duration: 46s841ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 46s841ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-03 23:13:12 Duration: 16s181ms 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-03 20:02:31 Duration: 14s995ms 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-03 23:30:52 Duration: 6s787ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 45s209ms 1 45s209ms 45s209ms 45s209ms refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 03 05 1 45s209ms 45s209ms [ User: intelifix - Total duration: 45s209ms - Times executed: 1 ]
[ Application: psql - unix(3175469@a2tech):8963 - Total duration: 45s209ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-03 05:31:07 Duration: 45s209ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3175469@a2tech):8963
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-03 05:31:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3175469@a2tech):8963
16 41s308ms 6 832ms 17s397ms 6s884ms 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 03 20 3 19s753ms 6s584ms 23 3 21s555ms 7s185ms [ User: intelifix - Total duration: 41s308ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s308ms - 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-03 23:14:22 Duration: 17s397ms 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-03 20:03:36 Duration: 15s894ms 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-03 23:31:11 Duration: 3s249ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 36s844ms 4 2s527ms 16s532ms 9s211ms 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 03 20 2 17s557ms 8s778ms 23 2 19s287ms 9s643ms [ User: intelifix - Total duration: 36s844ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 36s844ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-03 23:14:39 Duration: 16s532ms 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-03 20:03:51 Duration: 15s30ms 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-03 23:31:13 Duration: 2s754ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 35s256ms 6 887ms 12s163ms 5s876ms 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 03 20 3 16s680ms 5s560ms 23 3 18s576ms 6s192ms [ User: intelifix - Total duration: 35s256ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s256ms - 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-03 23:13:53 Duration: 12s163ms 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-03 20:03:08 Duration: 10s913ms 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-03 23:31:06 Duration: 5s432ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 26s719ms 3 213ms 22s163ms 8s906ms 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 03 23 3 26s719ms 8s906ms [ User: intelifix - Total duration: 26s719ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 26s719ms - 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-03 23:27:27 Duration: 22s163ms 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-03 23:37:09 Duration: 4s342ms 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-03 23:38:59 Duration: 213ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 26s698ms 6 493ms 11s711ms 4s449ms 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 03 20 3 12s918ms 4s306ms 23 3 13s779ms 4s593ms [ User: intelifix - Total duration: 26s698ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 26s698ms - 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-03 23:13:24 Duration: 11s711ms 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-03 20:02:42 Duration: 10s981ms 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-03 23:30:54 Duration: 1s527ms 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 159 2m34s 151ms 2s56ms 974ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 03 00 7 7s755ms 1s107ms 01 7 6s523ms 931ms 02 8 6s940ms 867ms 03 8 7s62ms 882ms 04 7 6s511ms 930ms 05 7 6s628ms 946ms 06 7 6s574ms 939ms 07 7 6s693ms 956ms 08 7 6s609ms 944ms 09 6 6s341ms 1s56ms 10 7 6s790ms 970ms 11 6 6s544ms 1s90ms 12 6 6s373ms 1s62ms 13 6 6s435ms 1s72ms 14 6 6s577ms 1s96ms 15 7 6s606ms 943ms 16 8 6s648ms 831ms 17 7 6s504ms 929ms 18 6 6s459ms 1s76ms 19 6 6s853ms 1s142ms 20 8 8s35ms 1s4ms 21 7 6s699ms 957ms 22 8 6s800ms 850ms [ User: intelifix - Total duration: 2m34s - Times executed: 159 ]
[ Application: psql - unix(3170819@a2tech):8963 - Total duration: 2s56ms - Times executed: 1 ]
[ Application: psql - unix(3188000@a2tech):8963 - Total duration: 1s739ms - Times executed: 1 ]
[ Application: psql - unix(3188161@a2tech):8963 - Total duration: 1s436ms - Times executed: 1 ]
[ Application: psql - unix(3187824@a2tech):8963 - Total duration: 1s359ms - Times executed: 1 ]
[ Application: psql - unix(3187096@a2tech):8963 - Total duration: 1s294ms - Times executed: 1 ]
[ Application: psql - unix(3179385@a2tech):8963 - Total duration: 1s253ms - Times executed: 1 ]
[ Application: psql - unix(3182820@a2tech):8963 - Total duration: 1s249ms - Times executed: 1 ]
[ Application: psql - unix(3173524@a2tech):8963 - Total duration: 1s245ms - Times executed: 1 ]
[ Application: psql - unix(3188424@a2tech):8963 - Total duration: 1s222ms - Times executed: 1 ]
[ Application: psql - unix(3172805@a2tech):8963 - Total duration: 1s195ms - Times executed: 1 ]
[ Application: psql - unix(3173921@a2tech):8963 - Total duration: 1s179ms - Times executed: 1 ]
[ Application: psql - unix(3176765@a2tech):8963 - Total duration: 1s174ms - Times executed: 1 ]
[ Application: psql - unix(3189160@a2tech):8963 - Total duration: 1s156ms - Times executed: 1 ]
[ Application: psql - unix(3175260@a2tech):8963 - Total duration: 1s155ms - Times executed: 1 ]
[ Application: psql - unix(3186414@a2tech):8963 - Total duration: 1s148ms - Times executed: 1 ]
[ Application: psql - unix(3184960@a2tech):8963 - Total duration: 1s146ms - Times executed: 1 ]
[ Application: psql - unix(3174166@a2tech):8963 - Total duration: 1s139ms - Times executed: 1 ]
[ Application: psql - unix(3180811@a2tech):8963 - Total duration: 1s136ms - Times executed: 1 ]
[ Application: psql - unix(3189756@a2tech):8963 - Total duration: 1s135ms - Times executed: 1 ]
[ Application: psql - unix(3188833@a2tech):8963 - Total duration: 1s133ms - Times executed: 1 ]
[ Application: psql - unix(3183116@a2tech):8963 - Total duration: 1s133ms - Times executed: 1 ]
[ Application: psql - unix(3188298@a2tech):8963 - Total duration: 1s131ms - Times executed: 1 ]
[ Application: psql - unix(3181810@a2tech):8963 - Total duration: 1s131ms - Times executed: 1 ]
[ Application: psql - unix(3180552@a2tech):8963 - Total duration: 1s129ms - Times executed: 1 ]
[ Application: psql - unix(3181971@a2tech):8963 - Total duration: 1s127ms - Times executed: 1 ]
[ Application: psql - unix(3176362@a2tech):8963 - Total duration: 1s127ms - Times executed: 1 ]
[ Application: psql - unix(3179671@a2tech):8963 - Total duration: 1s123ms - Times executed: 1 ]
[ Application: psql - unix(3177578@a2tech):8963 - Total duration: 1s123ms - Times executed: 1 ]
[ Application: psql - unix(3172677@a2tech):8963 - Total duration: 1s120ms - Times executed: 1 ]
[ Application: psql - unix(3171244@a2tech):8963 - Total duration: 1s117ms - Times executed: 1 ]
[ Application: psql - unix(3175537@a2tech):8963 - Total duration: 1s117ms - Times executed: 1 ]
[ Application: psql - unix(3183707@a2tech):8963 - Total duration: 1s115ms - Times executed: 1 ]
[ Application: psql - unix(3184389@a2tech):8963 - Total duration: 1s112ms - Times executed: 1 ]
[ Application: psql - unix(3174740@a2tech):8963 - Total duration: 1s112ms - Times executed: 1 ]
[ Application: psql - unix(3177168@a2tech):8963 - Total duration: 1s107ms - Times executed: 1 ]
[ Application: psql - unix(3181095@a2tech):8963 - Total duration: 1s107ms - Times executed: 1 ]
[ Application: psql - unix(3172556@a2tech):8963 - Total duration: 1s106ms - Times executed: 1 ]
[ Application: psql - unix(3178564@a2tech):8963 - Total duration: 1s104ms - Times executed: 1 ]
[ Application: psql - unix(3175968@a2tech):8963 - Total duration: 1s100ms - Times executed: 1 ]
[ Application: psql - unix(3172432@a2tech):8963 - Total duration: 1s98ms - Times executed: 1 ]
[ Application: psql - unix(3178066@a2tech):8963 - Total duration: 1s98ms - Times executed: 1 ]
[ Application: psql - unix(3177038@a2tech):8963 - Total duration: 1s97ms - Times executed: 1 ]
[ Application: psql - unix(3179799@a2tech):8963 - Total duration: 1s94ms - Times executed: 1 ]
[ Application: psql - unix(3182395@a2tech):8963 - Total duration: 1s92ms - Times executed: 1 ]
[ Application: psql - unix(3171644@a2tech):8963 - Total duration: 1s92ms - Times executed: 1 ]
[ Application: psql - unix(3180677@a2tech):8963 - Total duration: 1s91ms - Times executed: 1 ]
[ Application: psql - unix(3190282@a2tech):8963 - Total duration: 1s91ms - Times executed: 1 ]
[ Application: psql - unix(3170960@a2tech):8963 - Total duration: 1s90ms - Times executed: 1 ]
[ Application: psql - unix(3177775@a2tech):8963 - Total duration: 1s90ms - Times executed: 1 ]
[ Application: psql - unix(3183243@a2tech):8963 - Total duration: 1s89ms - Times executed: 1 ]
[ Application: psql - unix(3174605@a2tech):8963 - Total duration: 1s89ms - Times executed: 1 ]
[ Application: psql - unix(3189558@a2tech):8963 - Total duration: 1s88ms - Times executed: 1 ]
[ Application: psql - unix(3175131@a2tech):8963 - Total duration: 1s88ms - Times executed: 1 ]
[ Application: psql - unix(3190129@a2tech):8963 - Total duration: 1s88ms - Times executed: 1 ]
[ Application: psql - unix(3172017@a2tech):8963 - Total duration: 1s86ms - Times executed: 1 ]
[ Application: psql - unix(3180391@a2tech):8963 - Total duration: 1s86ms - Times executed: 1 ]
[ Application: psql - unix(3186670@a2tech):8963 - Total duration: 1s85ms - Times executed: 1 ]
[ Application: psql - unix(3171083@a2tech):8963 - Total duration: 1s84ms - Times executed: 1 ]
[ Application: psql - unix(3173658@a2tech):8963 - Total duration: 1s83ms - Times executed: 1 ]
[ Application: psql - unix(3176613@a2tech):8963 - Total duration: 1s82ms - Times executed: 1 ]
[ Application: psql - unix(3179935@a2tech):8963 - Total duration: 1s81ms - Times executed: 1 ]
[ Application: psql - unix(3184001@a2tech):8963 - Total duration: 1s81ms - Times executed: 1 ]
[ Application: psql - unix(3174307@a2tech):8963 - Total duration: 1s81ms - Times executed: 1 ]
[ Application: psql - unix(3178278@a2tech):8963 - Total duration: 1s80ms - Times executed: 1 ]
[ Application: psql - unix(3190420@a2tech):8963 - Total duration: 1s78ms - Times executed: 1 ]
[ Application: psql - unix(3185656@a2tech):8963 - Total duration: 1s78ms - Times executed: 1 ]
[ Application: psql - unix(3177296@a2tech):8963 - Total duration: 1s76ms - Times executed: 1 ]
[ Application: psql - unix(3184547@a2tech):8963 - Total duration: 1s76ms - Times executed: 1 ]
[ Application: psql - unix(3186544@a2tech):8963 - Total duration: 1s76ms - Times executed: 1 ]
[ Application: psql - unix(3182661@a2tech):8963 - Total duration: 1s75ms - Times executed: 1 ]
[ Application: psql - unix(3185371@a2tech):8963 - Total duration: 1s73ms - Times executed: 1 ]
[ Application: psql - unix(3180222@a2tech):8963 - Total duration: 1s72ms - Times executed: 1 ]
[ Application: psql - unix(3186257@a2tech):8963 - Total duration: 1s71ms - Times executed: 1 ]
[ Application: psql - unix(3173055@a2tech):8963 - Total duration: 1s68ms - Times executed: 1 ]
[ Application: psql - unix(3185914@a2tech):8963 - Total duration: 1s68ms - Times executed: 1 ]
[ Application: psql - unix(3171369@a2tech):8963 - Total duration: 1s68ms - Times executed: 1 ]
[ Application: psql - unix(3187420@a2tech):8963 - Total duration: 1s67ms - Times executed: 1 ]
[ Application: psql - unix(3182268@a2tech):8963 - Total duration: 1s66ms - Times executed: 1 ]
[ Application: psql - unix(3172287@a2tech):8963 - Total duration: 1s62ms - Times executed: 1 ]
[ Application: psql - unix(3189303@a2tech):8963 - Total duration: 1s62ms - Times executed: 1 ]
[ Application: psql - unix(3178714@a2tech):8963 - Total duration: 1s57ms - Times executed: 1 ]
[ Application: psql - unix(3179221@a2tech):8963 - Total duration: 1s56ms - Times executed: 1 ]
[ Application: psql - unix(3189985@a2tech):8963 - Total duration: 1s55ms - Times executed: 1 ]
[ Application: psql - unix(3178841@a2tech):8963 - Total duration: 1s54ms - Times executed: 1 ]
[ Application: psql - unix(3184129@a2tech):8963 - Total duration: 1s52ms - Times executed: 1 ]
[ Application: psql - unix(3189439@a2tech):8963 - Total duration: 1s51ms - Times executed: 1 ]
[ Application: psql - unix(3185523@a2tech):8963 - Total duration: 1s51ms - Times executed: 1 ]
[ Application: psql - unix(3171774@a2tech):8963 - Total duration: 1s51ms - Times executed: 1 ]
[ Application: psql - unix(3179538@a2tech):8963 - Total duration: 1s51ms - Times executed: 1 ]
[ Application: psql - unix(3171498@a2tech):8963 - Total duration: 1s51ms - Times executed: 1 ]
[ Application: psql - unix(3186926@a2tech):8963 - Total duration: 1s50ms - Times executed: 1 ]
[ Application: psql - unix(3176918@a2tech):8963 - Total duration: 1s49ms - Times executed: 1 ]
[ Application: psql - unix(3188679@a2tech):8963 - Total duration: 1s49ms - Times executed: 1 ]
[ Application: psql - unix(3183871@a2tech):8963 - Total duration: 1s48ms - Times executed: 1 ]
[ Application: psql - unix(3187563@a2tech):8963 - Total duration: 1s48ms - Times executed: 1 ]
[ Application: psql - unix(3178970@a2tech):8963 - Total duration: 1s48ms - Times executed: 1 ]
[ Application: psql - unix(3181381@a2tech):8963 - Total duration: 1s46ms - Times executed: 1 ]
[ Application: psql - unix(3187283@a2tech):8963 - Total duration: 1s45ms - Times executed: 1 ]
[ Application: psql - unix(3175377@a2tech):8963 - Total duration: 1s44ms - Times executed: 1 ]
[ Application: psql - unix(3185096@a2tech):8963 - Total duration: 1s44ms - Times executed: 1 ]
[ Application: psql - unix(3190537@a2tech):8963 - Total duration: 1s44ms - Times executed: 1 ]
[ Application: psql - unix(3176103@a2tech):8963 - Total duration: 1s43ms - Times executed: 1 ]
[ Application: psql - unix(3182986@a2tech):8963 - Total duration: 1s43ms - Times executed: 1 ]
[ Application: psql - unix(3182131@a2tech):8963 - Total duration: 1s42ms - Times executed: 1 ]
[ Application: psql - unix(3184264@a2tech):8963 - Total duration: 1s42ms - Times executed: 1 ]
[ Application: psql - unix(3171896@a2tech):8963 - Total duration: 1s42ms - Times executed: 1 ]
[ Application: psql - unix(3173782@a2tech):8963 - Total duration: 1s41ms - Times executed: 1 ]
[ Application: psql - unix(3185784@a2tech):8963 - Total duration: 1s41ms - Times executed: 1 ]
[ Application: psql - unix(3184836@a2tech):8963 - Total duration: 1s41ms - Times executed: 1 ]
[ Application: psql - unix(3172933@a2tech):8963 - Total duration: 1s39ms - Times executed: 1 ]
[ Application: psql - unix(3189023@a2tech):8963 - Total duration: 1s39ms - Times executed: 1 ]
[ Application: psql - unix(3175666@a2tech):8963 - Total duration: 1s39ms - Times executed: 1 ]
[ Application: psql - unix(3177421@a2tech):8963 - Total duration: 1s37ms - Times executed: 1 ]
[ Application: psql - unix(3187698@a2tech):8963 - Total duration: 1s37ms - Times executed: 1 ]
[ Application: psql - unix(3177911@a2tech):8963 - Total duration: 1s37ms - Times executed: 1 ]
[ Application: psql - unix(3174479@a2tech):8963 - Total duration: 1s36ms - Times executed: 1 ]
[ Application: psql - unix(3181530@a2tech):8963 - Total duration: 1s35ms - Times executed: 1 ]
[ Application: psql - unix(3172147@a2tech):8963 - Total duration: 1s35ms - Times executed: 1 ]
[ Application: psql - unix(3183494@a2tech):8963 - Total duration: 1s34ms - Times executed: 1 ]
[ Application: psql - unix(3186051@a2tech):8963 - Total duration: 1s34ms - Times executed: 1 ]
[ Application: psql - unix(3180067@a2tech):8963 - Total duration: 1s33ms - Times executed: 1 ]
[ Application: psql - unix(3176488@a2tech):8963 - Total duration: 1s33ms - Times executed: 1 ]
[ Application: psql - unix(3175786@a2tech):8963 - Total duration: 1s31ms - Times executed: 1 ]
[ Application: psql - unix(3182536@a2tech):8963 - Total duration: 1s30ms - Times executed: 1 ]
[ Application: psql - unix(3178402@a2tech):8963 - Total duration: 1s28ms - Times executed: 1 ]
[ Application: psql - unix(3180931@a2tech):8963 - Total duration: 1s28ms - Times executed: 1 ]
[ Application: psql - unix(3186803@a2tech):8963 - Total duration: 1s27ms - Times executed: 1 ]
[ Application: psql - unix(3181691@a2tech):8963 - Total duration: 1s27ms - Times executed: 1 ]
[ Application: psql - unix(3176230@a2tech):8963 - Total duration: 1s26ms - Times executed: 1 ]
[ Application: psql - unix(3183376@a2tech):8963 - Total duration: 1s26ms - Times executed: 1 ]
[ Application: psql - unix(3181255@a2tech):8963 - Total duration: 1s25ms - Times executed: 1 ]
[ Application: psql - unix(3174864@a2tech):8963 - Total duration: 1s25ms - Times executed: 1 ]
[ Application: psql - unix(3174043@a2tech):8963 - Total duration: 1s23ms - Times executed: 1 ]
[ Application: psql - unix(3179104@a2tech):8963 - Total duration: 1s20ms - Times executed: 1 ]
[ Application: psql - unix(3188561@a2tech):8963 - Total duration: 1s19ms - Times executed: 1 ]
[ Application: psql - unix(3174981@a2tech):8963 - Total duration: 1s13ms - Times executed: 1 ]
[ Application: psql - unix(3184704@a2tech):8963 - Total duration: 1s6ms - Times executed: 1 ]
[ Application: psql - unix(3185214@a2tech):8963 - Total duration: 1s6ms - Times executed: 1 ]
[ Application: psql - unix(3170833@a2tech):8963 - Total duration: 287ms - Times executed: 1 ]
[ Application: psql - unix(3188012@a2tech):8963 - Total duration: 277ms - Times executed: 1 ]
[ Application: psql - unix(3173932@a2tech):8963 - Total duration: 180ms - Times executed: 1 ]
[ Application: psql - unix(3173538@a2tech):8963 - Total duration: 168ms - Times executed: 1 ]
[ Application: psql - unix(3185104@a2tech):8963 - Total duration: 167ms - Times executed: 1 ]
[ Application: psql - unix(3189314@a2tech):8963 - Total duration: 166ms - Times executed: 1 ]
[ Application: psql - unix(3176621@a2tech):8963 - Total duration: 161ms - Times executed: 1 ]
[ Application: psql - unix(3188170@a2tech):8963 - Total duration: 159ms - Times executed: 1 ]
[ Application: psql - unix(3184844@a2tech):8963 - Total duration: 158ms - Times executed: 1 ]
[ Application: psql - unix(3185922@a2tech):8963 - Total duration: 156ms - Times executed: 1 ]
[ Application: psql - unix(3172816@a2tech):8963 - Total duration: 155ms - Times executed: 1 ]
[ Application: psql - unix(3172687@a2tech):8963 - Total duration: 154ms - Times executed: 1 ]
[ Application: psql - unix(3171904@a2tech):8963 - Total duration: 153ms - Times executed: 1 ]
[ Application: psql - unix(3190138@a2tech):8963 - Total duration: 153ms - Times executed: 1 ]
[ Application: psql - unix(3189993@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
[ Application: psql - unix(3184009@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
[ Application: psql - unix(3174753@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
[ Application: psql - unix(3177589@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
[ Application: psql - unix(3179396@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
[ Application: psql - unix(3175794@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
[ Application: psql - unix(3176776@a2tech):8963 - Total duration: 151ms - Times executed: 1 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-03 00:05:04 Duration: 2s56ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3170819@a2tech):8963
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-03 20:05:04 Duration: 1s739ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3188000@a2tech):8963
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-03 20:15:03 Duration: 1s436ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3188161@a2tech):8963
2 48 52m26s 492ms 3m18s 1m5s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 03 07 3 3m28s 1m9s 08 3 3m14s 1m4s 09 3 3m16s 1m5s 10 3 3m13s 1m4s 11 3 3m16s 1m5s 12 3 3m13s 1m4s 13 3 3m12s 1m4s 14 3 3m13s 1m4s 15 3 3m18s 1m6s 16 3 3m13s 1m4s 17 3 3m14s 1m4s 18 3 3m18s 1m6s 19 3 3m13s 1m4s 20 3 3m25s 1m8s 21 3 3m14s 1m4s 22 3 3m19s 1m6s [ User: intelifix - Total duration: 52m26s - Times executed: 48 ]
[ Application: psql - unix(3176759@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(3187992@a2tech):8963 - Total duration: 3m15s - Times executed: 1 ]
[ Application: psql - unix(3189732@a2tech):8963 - Total duration: 3m11s - Times executed: 1 ]
[ Application: psql - unix(3183708@a2tech):8963 - Total duration: 3m10s - Times executed: 1 ]
[ Application: psql - unix(3186253@a2tech):8963 - Total duration: 3m9s - Times executed: 1 ]
[ Application: psql - unix(3178557@a2tech):8963 - Total duration: 3m7s - Times executed: 1 ]
[ Application: psql - unix(3180216@a2tech):8963 - Total duration: 3m7s - Times executed: 1 ]
[ Application: psql - unix(3188834@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3185368@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3177571@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3187088@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3182812@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3184540@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3179382@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3181091@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3181963@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3176830@a2tech):8963 - Total duration: 9s840ms - Times executed: 1 ]
[ Application: psql - unix(3188075@a2tech):8963 - Total duration: 9s51ms - Times executed: 1 ]
[ Application: psql - unix(3181159@a2tech):8963 - Total duration: 8s451ms - Times executed: 1 ]
[ Application: psql - unix(3182039@a2tech):8963 - Total duration: 8s276ms - Times executed: 1 ]
[ Application: psql - unix(3179451@a2tech):8963 - Total duration: 8s262ms - Times executed: 1 ]
[ Application: psql - unix(3184613@a2tech):8963 - Total duration: 8s254ms - Times executed: 1 ]
[ Application: psql - unix(3188898@a2tech):8963 - Total duration: 8s215ms - Times executed: 1 ]
[ Application: psql - unix(3178628@a2tech):8963 - Total duration: 8s215ms - Times executed: 1 ]
[ Application: psql - unix(3180290@a2tech):8963 - Total duration: 8s192ms - Times executed: 1 ]
[ Application: psql - unix(3182892@a2tech):8963 - Total duration: 8s191ms - Times executed: 1 ]
[ Application: psql - unix(3185434@a2tech):8963 - Total duration: 8s173ms - Times executed: 1 ]
[ Application: psql - unix(3189892@a2tech):8963 - Total duration: 8s159ms - Times executed: 1 ]
[ Application: psql - unix(3177649@a2tech):8963 - Total duration: 8s140ms - Times executed: 1 ]
[ Application: psql - unix(3186324@a2tech):8963 - Total duration: 8s123ms - Times executed: 1 ]
[ Application: psql - unix(3187188@a2tech):8963 - Total duration: 8s107ms - Times executed: 1 ]
[ Application: psql - unix(3183777@a2tech):8963 - Total duration: 8s104ms - Times executed: 1 ]
[ Application: psql - unix(3176862@a2tech):8963 - Total duration: 768ms - Times executed: 1 ]
[ Application: psql - unix(3188107@a2tech):8963 - Total duration: 707ms - Times executed: 1 ]
[ Application: psql - unix(3180321@a2tech):8963 - Total duration: 562ms - Times executed: 1 ]
[ Application: psql - unix(3185465@a2tech):8963 - Total duration: 560ms - Times executed: 1 ]
[ Application: psql - unix(3184643@a2tech):8963 - Total duration: 559ms - Times executed: 1 ]
[ Application: psql - unix(3178657@a2tech):8963 - Total duration: 549ms - Times executed: 1 ]
[ Application: psql - unix(3189923@a2tech):8963 - Total duration: 548ms - Times executed: 1 ]
[ Application: psql - unix(3183807@a2tech):8963 - Total duration: 546ms - Times executed: 1 ]
[ Application: psql - unix(3181191@a2tech):8963 - Total duration: 542ms - Times executed: 1 ]
[ Application: psql - unix(3179480@a2tech):8963 - Total duration: 538ms - Times executed: 1 ]
[ Application: psql - unix(3188931@a2tech):8963 - Total duration: 537ms - Times executed: 1 ]
[ Application: psql - unix(3182921@a2tech):8963 - Total duration: 531ms - Times executed: 1 ]
[ Application: psql - unix(3182070@a2tech):8963 - Total duration: 526ms - Times executed: 1 ]
[ Application: psql - unix(3186355@a2tech):8963 - Total duration: 525ms - Times executed: 1 ]
[ Application: psql - unix(3187221@a2tech):8963 - Total duration: 507ms - Times executed: 1 ]
[ Application: psql - unix(3177681@a2tech):8963 - Total duration: 492ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-03 07:08:20 Duration: 3m18s Database: rio User: intelifix Remote: [local] Application: psql - unix(3176759@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-03 20:08:18 Duration: 3m15s Database: rio User: intelifix Remote: [local] Application: psql - unix(3187992@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-03 22:08:14 Duration: 3m11s Database: rio User: intelifix Remote: [local] Application: psql - unix(3189732@a2tech):8963
3 48 39m36s 325ms 2m12s 49s513ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 03 07 3 2m34s 51s546ms 08 3 2m27s 49s202ms 09 3 2m28s 49s352ms 10 3 2m27s 49s221ms 11 3 2m27s 49s155ms 12 3 2m27s 49s312ms 13 3 2m27s 49s179ms 14 3 2m28s 49s340ms 15 3 2m28s 49s501ms 16 3 2m27s 49s290ms 17 3 2m27s 49s140ms 18 3 2m27s 49s148ms 19 3 2m27s 49s294ms 20 3 2m33s 51s49ms 21 3 2m27s 49s155ms 22 3 2m27s 49s323ms [ User: intelifix - Total duration: 39m36s - Times executed: 48 ]
[ Application: psql - unix(3176834@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(3188079@a2tech):8963 - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - unix(3183784@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3181164@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3187193@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3178632@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3189897@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3188903@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3182898@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3184617@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3185438@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3179456@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3182044@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3177654@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3186329@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3180295@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3176822@a2tech):8963 - Total duration: 21s517ms - Times executed: 1 ]
[ Application: psql - unix(3188063@a2tech):8963 - Total duration: 21s376ms - Times executed: 1 ]
[ Application: psql - unix(3182884@a2tech):8963 - Total duration: 17s706ms - Times executed: 1 ]
[ Application: psql - unix(3180279@a2tech):8963 - Total duration: 17s635ms - Times executed: 1 ]
[ Application: psql - unix(3178620@a2tech):8963 - Total duration: 17s586ms - Times executed: 1 ]
[ Application: psql - unix(3177642@a2tech):8963 - Total duration: 17s551ms - Times executed: 1 ]
[ Application: psql - unix(3184605@a2tech):8963 - Total duration: 17s512ms - Times executed: 1 ]
[ Application: psql - unix(3189884@a2tech):8963 - Total duration: 17s503ms - Times executed: 1 ]
[ Application: psql - unix(3183771@a2tech):8963 - Total duration: 17s493ms - Times executed: 1 ]
[ Application: psql - unix(3179441@a2tech):8963 - Total duration: 17s454ms - Times executed: 1 ]
[ Application: psql - unix(3186315@a2tech):8963 - Total duration: 17s453ms - Times executed: 1 ]
[ Application: psql - unix(3187178@a2tech):8963 - Total duration: 17s405ms - Times executed: 1 ]
[ Application: psql - unix(3182030@a2tech):8963 - Total duration: 17s346ms - Times executed: 1 ]
[ Application: psql - unix(3181150@a2tech):8963 - Total duration: 17s210ms - Times executed: 1 ]
[ Application: psql - unix(3185426@a2tech):8963 - Total duration: 17s118ms - Times executed: 1 ]
[ Application: psql - unix(3188891@a2tech):8963 - Total duration: 17s76ms - Times executed: 1 ]
[ Application: psql - unix(3188110@a2tech):8963 - Total duration: 452ms - Times executed: 1 ]
[ Application: psql - unix(3176867@a2tech):8963 - Total duration: 446ms - Times executed: 1 ]
[ Application: psql - unix(3189928@a2tech):8963 - Total duration: 391ms - Times executed: 1 ]
[ Application: psql - unix(3184647@a2tech):8963 - Total duration: 387ms - Times executed: 1 ]
[ Application: psql - unix(3180325@a2tech):8963 - Total duration: 356ms - Times executed: 1 ]
[ Application: psql - unix(3179483@a2tech):8963 - Total duration: 356ms - Times executed: 1 ]
[ Application: psql - unix(3183811@a2tech):8963 - Total duration: 349ms - Times executed: 1 ]
[ Application: psql - unix(3178660@a2tech):8963 - Total duration: 349ms - Times executed: 1 ]
[ Application: psql - unix(3182074@a2tech):8963 - Total duration: 347ms - Times executed: 1 ]
[ Application: psql - unix(3185469@a2tech):8963 - Total duration: 343ms - Times executed: 1 ]
[ Application: psql - unix(3181195@a2tech):8963 - Total duration: 342ms - Times executed: 1 ]
[ Application: psql - unix(3186360@a2tech):8963 - Total duration: 339ms - Times executed: 1 ]
[ Application: psql - unix(3182926@a2tech):8963 - Total duration: 337ms - Times executed: 1 ]
[ Application: psql - unix(3188935@a2tech):8963 - Total duration: 337ms - Times executed: 1 ]
[ Application: psql - unix(3177684@a2tech):8963 - Total duration: 329ms - Times executed: 1 ]
[ Application: psql - unix(3187224@a2tech):8963 - Total duration: 325ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-03 07:11:05 Duration: 2m12s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3176834@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-03 20:11:00 Duration: 2m11s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3188079@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-03 15:10:50 Duration: 2m10s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3183784@a2tech):8963
4 27 6s716ms 154ms 654ms 248ms 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 03 08 2 896ms 448ms 09 2 467ms 233ms 10 2 489ms 244ms 11 2 507ms 253ms 12 1 242ms 242ms 13 3 736ms 245ms 14 1 228ms 228ms 15 1 233ms 233ms 16 1 222ms 222ms 17 2 378ms 189ms 18 3 682ms 227ms 19 1 275ms 275ms 20 3 657ms 219ms 21 1 227ms 227ms 22 2 469ms 234ms [ User: intelifix - Total duration: 6s716ms - Times executed: 27 ]
[ Application: psql - unix(3177493@a2tech):8963 - Total duration: 654ms - Times executed: 1 ]
[ Application: psql - unix(3187360@a2tech):8963 - Total duration: 275ms - Times executed: 1 ]
[ Application: psql - unix(3186484@a2tech):8963 - Total duration: 273ms - Times executed: 1 ]
[ Application: psql - unix(3182210@a2tech):8963 - Total duration: 268ms - Times executed: 1 ]
[ Application: psql - unix(3180749@a2tech):8963 - Total duration: 264ms - Times executed: 1 ]
[ Application: psql - unix(3188241@a2tech):8963 - Total duration: 252ms - Times executed: 1 ]
[ Application: psql - unix(3186128@a2tech):8963 - Total duration: 252ms - Times executed: 1 ]
[ Application: psql - unix(3179872@a2tech):8963 - Total duration: 251ms - Times executed: 1 ]
[ Application: psql - unix(3182469@a2tech):8963 - Total duration: 243ms - Times executed: 1 ]
[ Application: psql - unix(3180492@a2tech):8963 - Total duration: 242ms - Times executed: 1 ]
[ Application: psql - unix(3181321@a2tech):8963 - Total duration: 242ms - Times executed: 1 ]
[ Application: psql - unix(3188496@a2tech):8963 - Total duration: 242ms - Times executed: 1 ]
[ Application: psql - unix(3178212@a2tech):8963 - Total duration: 242ms - Times executed: 1 ]
[ Application: psql - unix(3179043@a2tech):8963 - Total duration: 241ms - Times executed: 1 ]
[ Application: psql - unix(3190064@a2tech):8963 - Total duration: 238ms - Times executed: 1 ]
[ Application: psql - unix(3179607@a2tech):8963 - Total duration: 237ms - Times executed: 1 ]
[ Application: psql - unix(3183941@a2tech):8963 - Total duration: 233ms - Times executed: 1 ]
[ Application: psql - unix(3190358@a2tech):8963 - Total duration: 231ms - Times executed: 1 ]
[ Application: psql - unix(3183315@a2tech):8963 - Total duration: 228ms - Times executed: 1 ]
[ Application: psql - unix(3189379@a2tech):8963 - Total duration: 227ms - Times executed: 1 ]
[ Application: psql - unix(3178780@a2tech):8963 - Total duration: 225ms - Times executed: 1 ]
[ Application: psql - unix(3185592@a2tech):8963 - Total duration: 223ms - Times executed: 1 ]
[ Application: psql - unix(3181889@a2tech):8963 - Total duration: 223ms - Times executed: 1 ]
[ Application: psql - unix(3184775@a2tech):8963 - Total duration: 222ms - Times executed: 1 ]
[ Application: psql - unix(3187897@a2tech):8963 - Total duration: 162ms - Times executed: 1 ]
[ Application: psql - unix(3186741@a2tech):8963 - Total duration: 157ms - Times executed: 1 ]
[ Application: psql - unix(3185857@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-03 08:00:02 Duration: 654ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3177493@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-03 19:20:02 Duration: 275ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3187360@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-03 18:20:02 Duration: 273ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3186484@a2tech):8963
5 27 5s864ms 152ms 274ms 217ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 03 08 1 259ms 259ms 09 3 611ms 203ms 10 2 456ms 228ms 11 3 630ms 210ms 12 1 211ms 211ms 13 1 222ms 222ms 14 3 672ms 224ms 15 1 208ms 208ms 16 2 470ms 235ms 17 1 220ms 220ms 18 2 455ms 227ms 19 3 616ms 205ms 20 1 209ms 209ms 21 1 224ms 224ms 22 2 396ms 198ms [ User: intelifix - Total duration: 5s864ms - Times executed: 27 ]
[ Application: psql - unix(3180138@a2tech):8963 - Total duration: 274ms - Times executed: 1 ]
[ Application: psql - unix(3177495@a2tech):8963 - Total duration: 259ms - Times executed: 1 ]
[ Application: psql - unix(3185038@a2tech):8963 - Total duration: 250ms - Times executed: 1 ]
[ Application: psql - unix(3179294@a2tech):8963 - Total duration: 249ms - Times executed: 1 ]
[ Application: psql - unix(3187001@a2tech):8963 - Total duration: 247ms - Times executed: 1 ]
[ Application: psql - unix(3190068@a2tech):8963 - Total duration: 243ms - Times executed: 1 ]
[ Application: psql - unix(3186132@a2tech):8963 - Total duration: 237ms - Times executed: 1 ]
[ Application: psql - unix(3178481@a2tech):8963 - Total duration: 232ms - Times executed: 1 ]
[ Application: psql - unix(3183057@a2tech):8963 - Total duration: 231ms - Times executed: 1 ]
[ Application: psql - unix(3189100@a2tech):8963 - Total duration: 224ms - Times executed: 1 ]
[ Application: psql - unix(3182212@a2tech):8963 - Total duration: 222ms - Times executed: 1 ]
[ Application: psql - unix(3178782@a2tech):8963 - Total duration: 221ms - Times executed: 1 ]
[ Application: psql - unix(3183059@a2tech):8963 - Total duration: 221ms - Times executed: 1 ]
[ Application: psql - unix(3185289@a2tech):8963 - Total duration: 220ms - Times executed: 1 ]
[ Application: psql - unix(3185040@a2tech):8963 - Total duration: 219ms - Times executed: 1 ]
[ Application: psql - unix(3183320@a2tech):8963 - Total duration: 218ms - Times executed: 1 ]
[ Application: psql - unix(3186487@a2tech):8963 - Total duration: 217ms - Times executed: 1 ]
[ Application: psql - unix(3187363@a2tech):8963 - Total duration: 215ms - Times executed: 1 ]
[ Application: psql - unix(3181323@a2tech):8963 - Total duration: 211ms - Times executed: 1 ]
[ Application: psql - unix(3188243@a2tech):8963 - Total duration: 209ms - Times executed: 1 ]
[ Application: psql - unix(3184204@a2tech):8963 - Total duration: 208ms - Times executed: 1 ]
[ Application: psql - unix(3179609@a2tech):8963 - Total duration: 207ms - Times executed: 1 ]
[ Application: psql - unix(3180494@a2tech):8963 - Total duration: 199ms - Times executed: 1 ]
[ Application: psql - unix(3180136@a2tech):8963 - Total duration: 156ms - Times executed: 1 ]
[ Application: psql - unix(3178479@a2tech):8963 - Total duration: 156ms - Times executed: 1 ]
[ Application: psql - unix(3186998@a2tech):8963 - Total duration: 153ms - Times executed: 1 ]
[ Application: psql - unix(3190360@a2tech):8963 - Total duration: 152ms - Times executed: 1 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-03 11:00:02 Duration: 274ms Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3180138@a2tech):8963
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-03 08:00:02 Duration: 259ms Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3177495@a2tech):8963
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-03 16:40:02 Duration: 250ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3185038@a2tech):8963
6 6 1m8s 1s594ms 26s799ms 11s465ms 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 03 20 3 33s58ms 11s19ms 23 3 35s732ms 11s910ms [ User: intelifix - Total duration: 1m8s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m8s - 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-03 23:15:50 Duration: 26s799ms 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-03 20:04:57 Duration: 24s689ms 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-03 23:31:21 Duration: 7s225ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 6 57s149ms 1s178ms 22s978ms 9s524ms 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 03 20 3 27s259ms 9s86ms 23 3 29s889ms 9s963ms [ User: intelifix - Total duration: 57s149ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s149ms - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-03 23:16:15 Duration: 22s978ms 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-03 20:05:20 Duration: 20s886ms 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-03 23:31:27 Duration: 5s604ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 6 56s793ms 2s307ms 22s589ms 9s465ms 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 03 20 3 27s284ms 9s94ms 23 3 29s509ms 9s836ms [ User: intelifix - Total duration: 56s793ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 56s793ms - 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-03 23:29:37 Duration: 22s589ms 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-03 20:06:52 Duration: 20s966ms 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-03 23:37:43 Duration: 4s376ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 6 46s976ms 1s106ms 16s735ms 7s829ms 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 03 20 3 22s576ms 7s525ms 23 3 24s400ms 8s133ms [ User: intelifix - Total duration: 46s976ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 46s976ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-03 23:13:41 Duration: 16s735ms 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-03 20:02:58 Duration: 15s414ms 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-03 23:31:00 Duration: 6s475ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 6 46s841ms 1s196ms 16s181ms 7s806ms 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 03 20 3 22s558ms 7s519ms 23 3 24s282ms 8s94ms [ User: intelifix - Total duration: 46s841ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 46s841ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-03 23:13:12 Duration: 16s181ms 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-03 20:02:31 Duration: 14s995ms 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-03 23:30:52 Duration: 6s787ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 41s308ms 832ms 17s397ms 6s884ms 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 03 20 3 19s753ms 6s584ms 23 3 21s555ms 7s185ms [ User: intelifix - Total duration: 41s308ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s308ms - 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-03 23:14:22 Duration: 17s397ms 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-03 20:03:36 Duration: 15s894ms 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-03 23:31:11 Duration: 3s249ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 6 35s256ms 887ms 12s163ms 5s876ms 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 03 20 3 16s680ms 5s560ms 23 3 18s576ms 6s192ms [ User: intelifix - Total duration: 35s256ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s256ms - 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-03 23:13:53 Duration: 12s163ms 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-03 20:03:08 Duration: 10s913ms 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-03 23:31:06 Duration: 5s432ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 26s698ms 493ms 11s711ms 4s449ms 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 03 20 3 12s918ms 4s306ms 23 3 13s779ms 4s593ms [ User: intelifix - Total duration: 26s698ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 26s698ms - 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-03 23:13:24 Duration: 11s711ms 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-03 20:02:42 Duration: 10s981ms 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-03 23:30:54 Duration: 1s527ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 19s428ms 431ms 9s93ms 3s238ms 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 03 20 3 9s384ms 3s128ms 23 3 10s44ms 3s348ms [ User: intelifix - Total duration: 19s428ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 19s428ms - 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-03 23:14:05 Duration: 9s93ms 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-03 20:03:20 Duration: 8s495ms 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-03 23:31:07 Duration: 485ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 18s683ms 487ms 7s711ms 3s113ms 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 03 20 3 8s997ms 2s999ms 23 3 9s685ms 3s228ms [ User: intelifix - Total duration: 18s683ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 18s683ms - 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-03 23:12:54 Duration: 7s711ms 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-03 20:02:14 Duration: 7s151ms 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-03 23:30:45 Duration: 1s443ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 18s582ms 1s834ms 4s477ms 3s97ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 03 00 3 12s521ms 4s173ms 06 3 6s60ms 2s20ms [ User: intelifix - Total duration: 18s582ms - Times executed: 6 ]
[ Application: psql - unix(3170821@a2tech):8963 - Total duration: 4s477ms - Times executed: 1 ]
[ Application: psql - unix(3170852@a2tech):8963 - Total duration: 4s346ms - Times executed: 1 ]
[ Application: psql - unix(3170851@a2tech):8963 - Total duration: 3s697ms - Times executed: 1 ]
[ Application: psql - unix(3175969@a2tech):8963 - Total duration: 2s148ms - Times executed: 1 ]
[ Application: psql - unix(3176000@a2tech):8963 - Total duration: 2s77ms - Times executed: 1 ]
[ Application: psql - unix(3175994@a2tech):8963 - Total duration: 1s834ms - Times executed: 1 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-03 00:05:06 Duration: 4s477ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3170821@a2tech):8963
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-03 00:05:15 Duration: 4s346ms Database: contagem User: intelifix Remote: [local] Application: psql - unix(3170852@a2tech):8963
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-03 00:05:10 Duration: 3s697ms Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3170851@a2tech):8963
17 6 17s309ms 1s591ms 3s768ms 2s884ms 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 03 20 3 8s360ms 2s786ms 23 3 8s949ms 2s983ms [ User: intelifix - Total duration: 17s309ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 17s309ms - 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-03 23:28:15 Duration: 3s768ms 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-03 23:37:35 Duration: 3s538ms 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-03 20:05:34 Duration: 3s486ms Database: rio User: intelifix Remote: [local] Application: pg_dump
18 6 12s231ms 1s937ms 2s137ms 2s38ms 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 03 20 3 5s859ms 1s953ms 23 3 6s371ms 2s123ms [ User: intelifix - Total duration: 12s231ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 12s231ms - Times executed: 6 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-03 23:38:34 Duration: 2s137ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-03 23:12:45 Duration: 2s126ms 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-03 23:30:43 Duration: 2s107ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 8s860ms 233ms 3s55ms 1s476ms 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 03 20 3 4s244ms 1s414ms 23 3 4s616ms 1s538ms [ User: intelifix - Total duration: 8s860ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 8s860ms - 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-03 23:13:56 Duration: 3s55ms 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-03 20:03:11 Duration: 2s796ms 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-03 23:31:07 Duration: 1s313ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 5s342ms 854ms 923ms 890ms 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 03 20 3 2s602ms 867ms 23 3 2s739ms 913ms [ User: intelifix - Total duration: 5s342ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 5s342ms - Times executed: 6 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-03 23:38:32 Duration: 923ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-03 23:12:42 Duration: 912ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-03 23:30:41 Duration: 903ms 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 57s484ms 1m53s 1m23s 3 4m9s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 03 05 3 4m9s 1m23s [ User: intelifix - Total duration: 4m9s - Times executed: 3 ]
[ Application: psql - unix(3175051@a2tech):8963 - Total duration: 1m53s - Times executed: 1 ]
[ Application: psql - unix(3175084@a2tech):8963 - Total duration: 1m18s - Times executed: 1 ]
[ Application: psql - unix(3175095@a2tech):8963 - Total duration: 57s484ms - Times executed: 1 ]
-
analyze verbose;
Date: 2026-05-03 05:01:54 Duration: 1m53s Database: rio User: intelifix Remote: [local] Application: psql - unix(3175051@a2tech):8963
-
analyze verbose;
Date: 2026-05-03 05:03:13 Duration: 1m18s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3175084@a2tech):8963
-
analyze verbose;
Date: 2026-05-03 05:04:11 Duration: 57s484ms Database: contagem User: intelifix Remote: [local] Application: psql - unix(3175095@a2tech):8963
2 492ms 3m18s 1m5s 48 52m26s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 03 07 3 3m28s 1m9s 08 3 3m14s 1m4s 09 3 3m16s 1m5s 10 3 3m13s 1m4s 11 3 3m16s 1m5s 12 3 3m13s 1m4s 13 3 3m12s 1m4s 14 3 3m13s 1m4s 15 3 3m18s 1m6s 16 3 3m13s 1m4s 17 3 3m14s 1m4s 18 3 3m18s 1m6s 19 3 3m13s 1m4s 20 3 3m25s 1m8s 21 3 3m14s 1m4s 22 3 3m19s 1m6s [ User: intelifix - Total duration: 52m26s - Times executed: 48 ]
[ Application: psql - unix(3176759@a2tech):8963 - Total duration: 3m18s - Times executed: 1 ]
[ Application: psql - unix(3187992@a2tech):8963 - Total duration: 3m15s - Times executed: 1 ]
[ Application: psql - unix(3189732@a2tech):8963 - Total duration: 3m11s - Times executed: 1 ]
[ Application: psql - unix(3183708@a2tech):8963 - Total duration: 3m10s - Times executed: 1 ]
[ Application: psql - unix(3186253@a2tech):8963 - Total duration: 3m9s - Times executed: 1 ]
[ Application: psql - unix(3178557@a2tech):8963 - Total duration: 3m7s - Times executed: 1 ]
[ Application: psql - unix(3180216@a2tech):8963 - Total duration: 3m7s - Times executed: 1 ]
[ Application: psql - unix(3188834@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3185368@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3177571@a2tech):8963 - Total duration: 3m5s - Times executed: 1 ]
[ Application: psql - unix(3187088@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3182812@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3184540@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3179382@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3181091@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3181963@a2tech):8963 - Total duration: 3m4s - Times executed: 1 ]
[ Application: psql - unix(3176830@a2tech):8963 - Total duration: 9s840ms - Times executed: 1 ]
[ Application: psql - unix(3188075@a2tech):8963 - Total duration: 9s51ms - Times executed: 1 ]
[ Application: psql - unix(3181159@a2tech):8963 - Total duration: 8s451ms - Times executed: 1 ]
[ Application: psql - unix(3182039@a2tech):8963 - Total duration: 8s276ms - Times executed: 1 ]
[ Application: psql - unix(3179451@a2tech):8963 - Total duration: 8s262ms - Times executed: 1 ]
[ Application: psql - unix(3184613@a2tech):8963 - Total duration: 8s254ms - Times executed: 1 ]
[ Application: psql - unix(3188898@a2tech):8963 - Total duration: 8s215ms - Times executed: 1 ]
[ Application: psql - unix(3178628@a2tech):8963 - Total duration: 8s215ms - Times executed: 1 ]
[ Application: psql - unix(3180290@a2tech):8963 - Total duration: 8s192ms - Times executed: 1 ]
[ Application: psql - unix(3182892@a2tech):8963 - Total duration: 8s191ms - Times executed: 1 ]
[ Application: psql - unix(3185434@a2tech):8963 - Total duration: 8s173ms - Times executed: 1 ]
[ Application: psql - unix(3189892@a2tech):8963 - Total duration: 8s159ms - Times executed: 1 ]
[ Application: psql - unix(3177649@a2tech):8963 - Total duration: 8s140ms - Times executed: 1 ]
[ Application: psql - unix(3186324@a2tech):8963 - Total duration: 8s123ms - Times executed: 1 ]
[ Application: psql - unix(3187188@a2tech):8963 - Total duration: 8s107ms - Times executed: 1 ]
[ Application: psql - unix(3183777@a2tech):8963 - Total duration: 8s104ms - Times executed: 1 ]
[ Application: psql - unix(3176862@a2tech):8963 - Total duration: 768ms - Times executed: 1 ]
[ Application: psql - unix(3188107@a2tech):8963 - Total duration: 707ms - Times executed: 1 ]
[ Application: psql - unix(3180321@a2tech):8963 - Total duration: 562ms - Times executed: 1 ]
[ Application: psql - unix(3185465@a2tech):8963 - Total duration: 560ms - Times executed: 1 ]
[ Application: psql - unix(3184643@a2tech):8963 - Total duration: 559ms - Times executed: 1 ]
[ Application: psql - unix(3178657@a2tech):8963 - Total duration: 549ms - Times executed: 1 ]
[ Application: psql - unix(3189923@a2tech):8963 - Total duration: 548ms - Times executed: 1 ]
[ Application: psql - unix(3183807@a2tech):8963 - Total duration: 546ms - Times executed: 1 ]
[ Application: psql - unix(3181191@a2tech):8963 - Total duration: 542ms - Times executed: 1 ]
[ Application: psql - unix(3179480@a2tech):8963 - Total duration: 538ms - Times executed: 1 ]
[ Application: psql - unix(3188931@a2tech):8963 - Total duration: 537ms - Times executed: 1 ]
[ Application: psql - unix(3182921@a2tech):8963 - Total duration: 531ms - Times executed: 1 ]
[ Application: psql - unix(3182070@a2tech):8963 - Total duration: 526ms - Times executed: 1 ]
[ Application: psql - unix(3186355@a2tech):8963 - Total duration: 525ms - Times executed: 1 ]
[ Application: psql - unix(3187221@a2tech):8963 - Total duration: 507ms - Times executed: 1 ]
[ Application: psql - unix(3177681@a2tech):8963 - Total duration: 492ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-03 07:08:20 Duration: 3m18s Database: rio User: intelifix Remote: [local] Application: psql - unix(3176759@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-03 20:08:18 Duration: 3m15s Database: rio User: intelifix Remote: [local] Application: psql - unix(3187992@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-03 22:08:14 Duration: 3m11s Database: rio User: intelifix Remote: [local] Application: psql - unix(3189732@a2tech):8963
3 325ms 2m12s 49s513ms 48 39m36s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 03 07 3 2m34s 51s546ms 08 3 2m27s 49s202ms 09 3 2m28s 49s352ms 10 3 2m27s 49s221ms 11 3 2m27s 49s155ms 12 3 2m27s 49s312ms 13 3 2m27s 49s179ms 14 3 2m28s 49s340ms 15 3 2m28s 49s501ms 16 3 2m27s 49s290ms 17 3 2m27s 49s140ms 18 3 2m27s 49s148ms 19 3 2m27s 49s294ms 20 3 2m33s 51s49ms 21 3 2m27s 49s155ms 22 3 2m27s 49s323ms [ User: intelifix - Total duration: 39m36s - Times executed: 48 ]
[ Application: psql - unix(3176834@a2tech):8963 - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - unix(3188079@a2tech):8963 - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - unix(3183784@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3181164@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3187193@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3178632@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3189897@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3188903@a2tech):8963 - Total duration: 2m10s - Times executed: 1 ]
[ Application: psql - unix(3182898@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3184617@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3185438@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3179456@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3182044@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3177654@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3186329@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3180295@a2tech):8963 - Total duration: 2m9s - Times executed: 1 ]
[ Application: psql - unix(3176822@a2tech):8963 - Total duration: 21s517ms - Times executed: 1 ]
[ Application: psql - unix(3188063@a2tech):8963 - Total duration: 21s376ms - Times executed: 1 ]
[ Application: psql - unix(3182884@a2tech):8963 - Total duration: 17s706ms - Times executed: 1 ]
[ Application: psql - unix(3180279@a2tech):8963 - Total duration: 17s635ms - Times executed: 1 ]
[ Application: psql - unix(3178620@a2tech):8963 - Total duration: 17s586ms - Times executed: 1 ]
[ Application: psql - unix(3177642@a2tech):8963 - Total duration: 17s551ms - Times executed: 1 ]
[ Application: psql - unix(3184605@a2tech):8963 - Total duration: 17s512ms - Times executed: 1 ]
[ Application: psql - unix(3189884@a2tech):8963 - Total duration: 17s503ms - Times executed: 1 ]
[ Application: psql - unix(3183771@a2tech):8963 - Total duration: 17s493ms - Times executed: 1 ]
[ Application: psql - unix(3179441@a2tech):8963 - Total duration: 17s454ms - Times executed: 1 ]
[ Application: psql - unix(3186315@a2tech):8963 - Total duration: 17s453ms - Times executed: 1 ]
[ Application: psql - unix(3187178@a2tech):8963 - Total duration: 17s405ms - Times executed: 1 ]
[ Application: psql - unix(3182030@a2tech):8963 - Total duration: 17s346ms - Times executed: 1 ]
[ Application: psql - unix(3181150@a2tech):8963 - Total duration: 17s210ms - Times executed: 1 ]
[ Application: psql - unix(3185426@a2tech):8963 - Total duration: 17s118ms - Times executed: 1 ]
[ Application: psql - unix(3188891@a2tech):8963 - Total duration: 17s76ms - Times executed: 1 ]
[ Application: psql - unix(3188110@a2tech):8963 - Total duration: 452ms - Times executed: 1 ]
[ Application: psql - unix(3176867@a2tech):8963 - Total duration: 446ms - Times executed: 1 ]
[ Application: psql - unix(3189928@a2tech):8963 - Total duration: 391ms - Times executed: 1 ]
[ Application: psql - unix(3184647@a2tech):8963 - Total duration: 387ms - Times executed: 1 ]
[ Application: psql - unix(3180325@a2tech):8963 - Total duration: 356ms - Times executed: 1 ]
[ Application: psql - unix(3179483@a2tech):8963 - Total duration: 356ms - Times executed: 1 ]
[ Application: psql - unix(3183811@a2tech):8963 - Total duration: 349ms - Times executed: 1 ]
[ Application: psql - unix(3178660@a2tech):8963 - Total duration: 349ms - Times executed: 1 ]
[ Application: psql - unix(3182074@a2tech):8963 - Total duration: 347ms - Times executed: 1 ]
[ Application: psql - unix(3185469@a2tech):8963 - Total duration: 343ms - Times executed: 1 ]
[ Application: psql - unix(3181195@a2tech):8963 - Total duration: 342ms - Times executed: 1 ]
[ Application: psql - unix(3186360@a2tech):8963 - Total duration: 339ms - Times executed: 1 ]
[ Application: psql - unix(3182926@a2tech):8963 - Total duration: 337ms - Times executed: 1 ]
[ Application: psql - unix(3188935@a2tech):8963 - Total duration: 337ms - Times executed: 1 ]
[ Application: psql - unix(3177684@a2tech):8963 - Total duration: 329ms - Times executed: 1 ]
[ Application: psql - unix(3187224@a2tech):8963 - Total duration: 325ms - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-03 07:11:05 Duration: 2m12s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3176834@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-03 20:11:00 Duration: 2m11s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3188079@a2tech):8963
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-03 15:10:50 Duration: 2m10s Database: brasilia User: intelifix Remote: [local] Application: psql - unix(3183784@a2tech):8963
4 45s209ms 45s209ms 45s209ms 1 45s209ms refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 03 05 1 45s209ms 45s209ms [ User: intelifix - Total duration: 45s209ms - Times executed: 1 ]
[ Application: psql - unix(3175469@a2tech):8963 - Total duration: 45s209ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-03 05:31:07 Duration: 45s209ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3175469@a2tech):8963
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-03 05:31:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql - unix(3175469@a2tech):8963
5 14s366ms 1m2s 32s387ms 3 1m37s 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 03 23 3 1m37s 32s387ms [ User: intelifix - Total duration: 1m37s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m37s - 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-03 23:11:50 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-03 23:30:23 Duration: 19s988ms 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-03 23:38:18 Duration: 14s366ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 13s284ms 50s837ms 26s780ms 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 03 23 3 1m20s 26s780ms [ 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-03 23:12:41 Duration: 50s837ms 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-03 23:30:40 Duration: 16s220ms 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-03 23:38:31 Duration: 13s284ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 2s68ms 50s77ms 25s605ms 4 1m42s 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 03 20 2 50s131ms 25s65ms 23 2 52s291ms 26s145ms [ User: intelifix - Total duration: 1m42s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m42s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-03 23:29:15 Duration: 50s77ms 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-03 20:06:31 Duration: 48s63ms 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-03 23:37:38 Duration: 2s214ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 11s367ms 44s968ms 24s835ms 3 1m14s 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 03 23 3 1m14s 24s835ms [ User: intelifix - Total duration: 1m14s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m14s - 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-03 23:10:47 Duration: 44s968ms 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-03 23:30:03 Duration: 18s169ms 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-03 23:38:03 Duration: 11s367ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 270ms 43s145ms 21s55ms 4 1m24s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 03 20 2 40s763ms 20s381ms 23 2 43s456ms 21s728ms [ 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-03 23:15:22 Duration: 43s145ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-03 20:04:31 Duration: 40s492ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-03 23:31:14 Duration: 310ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 1s594ms 26s799ms 11s465ms 6 1m8s 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 03 20 3 33s58ms 11s19ms 23 3 35s732ms 11s910ms [ User: intelifix - Total duration: 1m8s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m8s - 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-03 23:15:50 Duration: 26s799ms 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-03 20:04:57 Duration: 24s689ms 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-03 23:31:21 Duration: 7s225ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 1s178ms 22s978ms 9s524ms 6 57s149ms 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 03 20 3 27s259ms 9s86ms 23 3 29s889ms 9s963ms [ User: intelifix - Total duration: 57s149ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s149ms - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-03 23:16:15 Duration: 22s978ms 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-03 20:05:20 Duration: 20s886ms 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-03 23:31:27 Duration: 5s604ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s307ms 22s589ms 9s465ms 6 56s793ms 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 03 20 3 27s284ms 9s94ms 23 3 29s509ms 9s836ms [ User: intelifix - Total duration: 56s793ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 56s793ms - 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-03 23:29:37 Duration: 22s589ms 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-03 20:06:52 Duration: 20s966ms 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-03 23:37:43 Duration: 4s376ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s527ms 16s532ms 9s211ms 4 36s844ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 03 20 2 17s557ms 8s778ms 23 2 19s287ms 9s643ms [ User: intelifix - Total duration: 36s844ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 36s844ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-03 23:14:39 Duration: 16s532ms 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-03 20:03:51 Duration: 15s30ms 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-03 23:31:13 Duration: 2s754ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 213ms 22s163ms 8s906ms 3 26s719ms 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 #14
Day Hour Count Duration Avg duration May 03 23 3 26s719ms 8s906ms [ User: intelifix - Total duration: 26s719ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 26s719ms - 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-03 23:27:27 Duration: 22s163ms 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-03 23:37:09 Duration: 4s342ms 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-03 23:38:59 Duration: 213ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 1s106ms 16s735ms 7s829ms 6 46s976ms 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 03 20 3 22s576ms 7s525ms 23 3 24s400ms 8s133ms [ User: intelifix - Total duration: 46s976ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 46s976ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-03 23:13:41 Duration: 16s735ms 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-03 20:02:58 Duration: 15s414ms 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-03 23:31:00 Duration: 6s475ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1s196ms 16s181ms 7s806ms 6 46s841ms 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 03 20 3 22s558ms 7s519ms 23 3 24s282ms 8s94ms [ User: intelifix - Total duration: 46s841ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 46s841ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-03 23:13:12 Duration: 16s181ms 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-03 20:02:31 Duration: 14s995ms 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-03 23:30:52 Duration: 6s787ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 832ms 17s397ms 6s884ms 6 41s308ms 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 03 20 3 19s753ms 6s584ms 23 3 21s555ms 7s185ms [ User: intelifix - Total duration: 41s308ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s308ms - 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-03 23:14:22 Duration: 17s397ms 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-03 20:03:36 Duration: 15s894ms 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-03 23:31:11 Duration: 3s249ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 887ms 12s163ms 5s876ms 6 35s256ms 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 03 20 3 16s680ms 5s560ms 23 3 18s576ms 6s192ms [ User: intelifix - Total duration: 35s256ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s256ms - 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-03 23:13:53 Duration: 12s163ms 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-03 20:03:08 Duration: 10s913ms 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-03 23:31:06 Duration: 5s432ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 493ms 11s711ms 4s449ms 6 26s698ms 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 03 20 3 12s918ms 4s306ms 23 3 13s779ms 4s593ms [ User: intelifix - Total duration: 26s698ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 26s698ms - 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-03 23:13:24 Duration: 11s711ms 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-03 20:02:42 Duration: 10s981ms 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-03 23:30:54 Duration: 1s527ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 431ms 9s93ms 3s238ms 6 19s428ms 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 03 20 3 9s384ms 3s128ms 23 3 10s44ms 3s348ms [ User: intelifix - Total duration: 19s428ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 19s428ms - 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-03 23:14:05 Duration: 9s93ms 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-03 20:03:20 Duration: 8s495ms 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-03 23:31:07 Duration: 485ms 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 17 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 May 03 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 14 2 0ms 0ms 16 1 0ms 0ms 18 1 0ms 0ms 19 2 0ms 0ms [ User: intelifix - Total duration: 3m34s - Times executed: 17 ]
[ Application: psql - unix(3163019@a2tech):8963 - Total duration: 3m3s - Times executed: 1 ]
[ Application: psql - unix(3178628@a2tech):8963 - Total duration: 8s215ms - Times executed: 1 ]
[ Application: psql - unix(3180290@a2tech):8963 - Total duration: 8s192ms - Times executed: 1 ]
[ Application: psql - unix(3187188@a2tech):8963 - Total duration: 8s107ms - Times executed: 1 ]
[ Application: psql - unix(3168554@a2tech):8963 - Total duration: 1s243ms - Times executed: 1 ]
[ Application: psql - unix(3183243@a2tech):8963 - Total duration: 1s89ms - Times executed: 1 ]
[ Application: psql - unix(3186544@a2tech):8963 - Total duration: 1s76ms - Times executed: 1 ]
[ Application: psql - unix(3187420@a2tech):8963 - Total duration: 1s67ms - 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(3183320@a2tech):8963 - Total duration: 218ms - Times executed: 1 ]
[ Application: psql - unix(3185104@a2tech):8963 - Total duration: 167ms - 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(3179396@a2tech):8963 - Total duration: 151ms - 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(3187420@a2tech):8963
-
Events
Log levels
Key values
- 4,848 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 16 FATAL entries
- 1140 ERROR entries
- 0 WARNING entries
- 9 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,136 Max number of times the same event was reported
- 1,165 Total events found
Rank Times reported Error 1 1,136 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count May 03 00 47 01 46 02 51 03 49 04 47 05 46 06 48 07 49 08 48 09 46 10 48 11 48 12 51 13 47 14 47 15 46 16 47 17 50 18 46 19 48 20 48 21 47 22 46 23 40 - ERROR: prepared statement "_PLAN000000004CA81700" does not exist
- ERROR: prepared statement "_PLAN000000004CA74E40" does not exist
- ERROR: prepared statement "_PLAN000000004CA80950" does not exist
Statement: DEALLOCATE "_PLAN000000004CA81700"
Date: 2026-05-03 00:00:48 Database: brasilia Application: app - 177.99.204.34:50899 User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000004CA74E40"
Date: 2026-05-03 00:01:51 Database: brasilia Application: app - 177.99.204.34:50913 User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000004CA80950"
Date: 2026-05-03 00:02:55 Database: brasilia Application: app - 177.99.204.34:50899 User: etiquetas Remote: [local]
2 8 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count May 03 13 1 14 1 19 4 22 2 3 7 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count May 03 00 1 02 1 03 1 04 2 06 1 17 1 4 6 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count May 03 03 6 5 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count May 03 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-03 05:31:08 Database: brasilia Application: psql - unix(3175477@a2tech):8963 User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-03 05:31:08 Database: brasilia Application: psql - unix(3175478@a2tech):8963 User: intelifix Remote: [local]
6 3 FATAL: unsupported frontend protocol 27265.28208: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #6
Day Hour Count May 03 19 2 22 1 7 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #7
Day Hour Count May 03 03 1