pgBadger-
Global information
- Generated on Sun Sep 6 23:50:18 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 9,415 log entries in 15s
- Log start from 2026-09-05 00:00:30 to 2026-09-05 23:59:59
-
Overview
Global Stats
- 148 Number of unique normalized queries
- 921 Number of queries
- 3h48m19s Total query duration
- 2026-09-05 00:01:17 First query
- 2026-09-05 23:57:59 Last query
- 5 queries/s at 2026-09-05 23:42:27 Query peak
- 3h48m19s Total query duration
- 204ms Prepare/parse total duration
- 0ms Bind total duration
- 3h48m19s Execute total duration
- 1,463 Number of events
- 6 Number of unique normalized events
- 1,426 Max number of times the same event was reported
- 0 Number of cancellation
- 6 Total number of automatic vacuums
- 2 Total number of automatic analyzes
- 20 Number temporary file
- 244.71 MiB Max size of temporary file
- 66.60 MiB Average size of temporary file
- 218 Total number of sessions
- 7 sessions at 2026-09-05 02:35:28 Session peak
- 8d3h21m54s Total duration of sessions
- 53m46s Average duration of sessions
- 4 Average queries per session
- 1m2s Average queries duration per session
- 52m43s Average idle time per session
- 231 Total number of connections
- 5 connections/s at 2026-09-05 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-05 23:42:27 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-09-05 23:32:28 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-05 23:42:27 Date
Queries duration
Key values
- 3h48m19s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 05 00 32 0ms 18s208ms 2s837ms 4s251ms 5s415ms 57s924ms 01 16 0ms 5s373ms 2s37ms 3s351ms 5s111ms 8s216ms 02 23 0ms 3s363ms 1s403ms 3s841ms 5s345ms 6s147ms 03 14 0ms 4s950ms 2s411ms 3s349ms 6s977ms 7s856ms 04 21 0ms 4s561ms 1s653ms 4s342ms 5s234ms 7s739ms 05 23 0ms 10m6s 56s181ms 10s145ms 2m45s 10m6s 06 16 0ms 7s312ms 2s795ms 2s988ms 3s592ms 22s899ms 07 15 0ms 6m55s 51s158ms 2s900ms 1m31s 6m55s 08 21 0ms 4m48s 27s343ms 3s115ms 42s49ms 4m48s 09 21 0ms 4m47s 27s267ms 3s62ms 42s218ms 4m47s 10 21 0ms 4m45s 27s71ms 3s23ms 42s576ms 4m45s 11 19 0ms 4m50s 30s123ms 2s960ms 42s390ms 4m50s 12 21 0ms 4m45s 27s174ms 2s983ms 43s523ms 4m45s 13 21 0ms 4m46s 27s229ms 3s50ms 42s454ms 4m46s 14 20 0ms 4m47s 28s373ms 2s857ms 43s159ms 4m47s 15 20 0ms 4m48s 28s799ms 2s932ms 42s602ms 4m48s 16 20 0ms 4m49s 28s775ms 2s921ms 42s922ms 4m49s 17 23 0ms 4m44s 25s112ms 3s135ms 42s815ms 4m44s 18 24 0ms 4m42s 23s571ms 2s957ms 43s247ms 4m42s 19 21 0ms 4m44s 27s1ms 2s885ms 42s337ms 4m44s 20 113 0ms 6m59s 11s728ms 1m6s 1m27s 6m59s 21 22 0ms 6m6s 29s445ms 2s963ms 3s280ms 6m50s 22 22 0ms 4m45s 26s183ms 3s65ms 42s608ms 4m45s 23 352 0ms 1m2s 5s574ms 1m4s 1m12s 1m16s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 05 00 10 0 911ms 0ms 0ms 2s540ms 01 0 0 0ms 0ms 0ms 0ms 02 6 0 349ms 0ms 0ms 675ms 03 0 0 0ms 0ms 0ms 0ms 04 4 0 266ms 0ms 0ms 360ms 05 3 0 329ms 0ms 0ms 0ms 06 3 0 2s22ms 0ms 0ms 0ms 07 6 0 2m5s 0ms 0ms 4m2s 08 6 0 1m31s 0ms 0ms 3m36s 09 6 0 1m31s 0ms 0ms 3m37s 10 6 0 1m30s 0ms 0ms 3m38s 11 6 0 1m31s 0ms 0ms 3m35s 12 6 0 1m31s 0ms 0ms 3m39s 13 6 0 1m31s 0ms 0ms 3m40s 14 6 0 1m30s 0ms 0ms 3m35s 15 6 0 1m32s 0ms 0ms 3m42s 16 6 0 1m32s 0ms 0ms 3m40s 17 6 0 1m32s 0ms 0ms 3m45s 18 9 0 1m 0ms 0ms 3m36s 19 6 0 1m30s 0ms 0ms 3m37s 20 15 78 13s799ms 36s328ms 1m3s 3m51s 21 7 0 1m29s 0ms 0ms 3m34s 22 6 0 1m32s 0ms 0ms 3m45s 23 31 320 5s589ms 1m 1m4s 1m12s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 05 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 05 00 0 2 2.00 0.00% 01 0 0 0.00 0.00% 02 0 2 2.00 0.00% 03 0 0 0.00 0.00% 04 0 1 1.00 0.00% 05 0 1 1.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 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 1 5 5.00 0.28% Day Hour Count Average / Second Sep 05 00 19 0.01/s 01 9 0.00/s 02 13 0.00/s 03 16 0.00/s 04 9 0.00/s 05 10 0.00/s 06 15 0.00/s 07 13 0.00/s 08 7 0.00/s 09 10 0.00/s 10 6 0.00/s 11 8 0.00/s 12 7 0.00/s 13 7 0.00/s 14 9 0.00/s 15 9 0.00/s 16 8 0.00/s 17 8 0.00/s 18 7 0.00/s 19 9 0.00/s 20 10 0.00/s 21 7 0.00/s 22 7 0.00/s 23 8 0.00/s Day Hour Count Average Duration Average idle time Sep 05 00 6 1h30s 1h15s 01 16 1h1m7s 1h1m5s 02 9 1h 59m56s 03 21 23m34s 23m32s 04 7 1h2m8s 1h2m3s 05 10 55m18s 53m9s 06 9 58m40s 58m35s 07 14 59m56s 59m1s 08 7 1h 58m38s 09 8 53m59s 52m48s 10 8 1h58s 59m47s 11 7 54m8s 52m46s 12 7 1h57s 59m36s 13 7 54m42s 53m21s 14 7 1h25s 59m4s 15 8 1h51s 59m39s 16 7 1h33s 59m11s 17 8 1h59s 59m47s 18 7 1h3s 58m43s 19 7 1h1m11s 59m50s 20 11 44m28s 42m28s 21 7 1h1m17s 59m45s 22 7 1h 58m38s 23 13 34m50s 32m19s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-09-05 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 231 connections Total
Connections per user
Key values
- intelifix Main User
- 231 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-09-05 02:35:28 Date
Histogram of session times
Key values
- 182 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 218 sessions Total
Sessions per user
Key values
- intelifix Main User
- 218 sessions Total
Sessions per host
Key values
- [local] Main Host
- 218 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 14,808 buffers Checkpoint Peak
- 2026-09-05 00:09:44 Date
- 269.922 seconds Highest write time
- 0.131 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-09-05 00:09:44 Date
Checkpoints distance
Key values
- 106.57 Mo Distance Peak
- 2026-09-05 00:19:44 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 05 00 25,174 654.277s 0.081s 654.386s 01 1,978 198.192s 0.082s 198.298s 02 1,970 197.315s 0.088s 197.486s 03 1,649 165.167s 0.213s 165.415s 04 2,297 230.008s 0.156s 230.189s 05 9,640 965.592s 0.252s 965.889s 06 2,817 269.758s 0.002s 269.764s 07 2,248 225.311s 0.073s 225.395s 08 26 2.626s 0.017s 2.675s 09 24 2.419s 0.009s 2.441s 10 25 2.52s 0.01s 2.542s 11 24 2.421s 0.012s 2.441s 12 25 2.52s 0.011s 2.538s 13 24 2.419s 0.006s 2.431s 14 25 2.521s 0.016s 2.542s 15 24 2.42s 0.034s 2.462s 16 25 2.519s 0.01s 2.535s 17 23 2.313s 0.002s 2.318s 18 855 85.727s 0.016s 85.759s 19 23 2.312s 0.002s 2.317s 20 97 9.742s 0.036s 9.787s 21 53 5.332s 0.023s 5.366s 22 23 2.311s 0.003s 2.317s 23 27 2.717s 0.007s 2.731s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 05 00 0 0 6 604 0.062s 0.006s 01 0 0 1 425 0.062s 0.006s 02 0 0 1 469 0.062s 0.006s 03 0 0 0 379 0.062s 0.009s 04 0 0 1 529 0.062s 0.006s 05 0 0 4 861 0.117s 0.01s 06 0 0 1 28 0.001s 0.001s 07 0 0 0 25 0.062s 0.011s 08 0 0 0 6 0.012s 0.008s 09 0 0 0 5 0.004s 0.004s 10 0 0 0 5 0.005s 0.005s 11 0 0 0 5 0.008s 0.005s 12 0 0 0 5 0.007s 0.005s 13 0 0 0 5 0.002s 0.003s 14 0 0 0 5 0.012s 0.007s 15 0 0 0 5 0.022s 0.012s 16 0 0 0 5 0.006s 0.004s 17 0 0 0 2 0.002s 0.001s 18 0 0 1 53 0.010s 0.005s 19 0 0 0 3 0.001s 0.001s 20 0 0 0 22 0.030s 0.007s 21 0 0 0 18 0.008s 0.006s 22 0 0 0 3 0.002s 0.001s 23 0 0 0 4 0.005s 0.004s Day Hour Count Avg time (sec) Sep 05 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 05 00 18,202.33 kB 45,616.17 kB 01 1,597.50 kB 25,963.00 kB 02 1,582.83 kB 14,536.67 kB 03 1,081.38 kB 4,000.25 kB 04 2,000.50 kB 2,902.50 kB 05 8,363.00 kB 15,201.22 kB 06 4,075.00 kB 12,767.00 kB 07 3,514.67 kB 11,296.00 kB 08 64.00 kB 8,280.33 kB 09 94.50 kB 6,371.00 kB 10 95.00 kB 5,180.00 kB 11 94.00 kB 4,212.00 kB 12 94.50 kB 3,431.50 kB 13 94.50 kB 2,797.00 kB 14 94.50 kB 2,284.00 kB 15 94.50 kB 1,868.00 kB 16 94.50 kB 1,531.00 kB 17 183.00 kB 1,326.00 kB 18 755.75 kB 2,319.50 kB 19 187.00 kB 1,807.00 kB 20 353.67 kB 1,529.33 kB 21 88.33 kB 1,171.00 kB 22 187.00 kB 967.00 kB 23 41.00 kB 831.00 kB -
Temporary Files
Size of temporary files
Key values
- 489.42 MiB Temp Files size Peak
- 2026-09-05 05:31:55 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-05 05:32:01 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 05 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.30 GiB 66.60 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 16 1.00 GiB 36.49 MiB 244.71 MiB 64.22 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-05 05:32:04 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-05 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 304.60 MiB 56.62 MiB 93.18 MiB 76.15 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-05 05:30:41 Duration: 38s920ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-05 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 244.71 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-05 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 244.71 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-05 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 93.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-05 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 93.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-05 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 61.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-05 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 56.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-05 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.41 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-05 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.36 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-05 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-05 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-05 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.34 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-05 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-05 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-05 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 36.56 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-05 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.51 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-05 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.51 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-05 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.50 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-05 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.50 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-05 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-05 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-05 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.28 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-09-05 05:11:03 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.28 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-09-05 05:11:03 Date
Analyzes per table
Key values
- pg_catalog.pg_type (1) Main table analyzed (database rio)
- 2 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database contagem
- 6 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 142 5 14,559 0 0 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,673 1,256 4,586,440 1,190 7,123 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,736 886 3,042,665 843 5,816 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 173 49 149,097 10 27 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 867 267 1,188,589 124 451 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,265 7 169,961 0 0 Total 6 6 0 0 0 0 0 9,856 2,470 9,151,311 2,167 13,417 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.28) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
Tuples removed per table
Key values
- pg_catalog.pg_statistic (4536) Main table with removed tuples on database rio
- 13496 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,536 7,489 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,362 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,687 7,360 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 675 681 0 0 289 contagem.pg_toast.pg_toast_2619 1 1 118 114 0 7 54 brasilia.pg_toast.pg_toast_2619 1 1 118 137 0 10 58 Total 6 6 13,496 23,055 0 17 3,770 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (10) Main table with removed pages on database brasilia
- 17 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed brasilia.pg_toast.pg_toast_2619 1 1 118 10 contagem.pg_toast.pg_toast_2619 1 1 118 7 rio.pg_catalog.pg_statistic 1 1 4536 0 brasilia.pg_catalog.pg_statistic 1 1 3687 0 rio.pg_toast.pg_toast_2619 1 1 675 0 contagem.pg_catalog.pg_statistic 1 1 4362 0 Total 6 6 13,496 17 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 05 00 0 0 01 0 0 02 0 2 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.28 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
- 166 Total read queries
- 399 Total write queries
Queries by database
Key values
- rio Main database
- 445 Requests
- 2h22m34s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 899 Requests
User Request type Count Duration etiquetas Total 10 8s4ms others 1 191ms select 9 7s812ms intelifix Total 899 3h47m57s copy to 398 41m29s ddl 1 332ms others 355 32m4s select 145 2h34m22s lenon Total 12 13s834ms select 12 13s834ms Duration by user
Key values
- 3h47m57s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 10 8s4ms others 1 191ms select 9 7s812ms intelifix Total 899 3h47m57s copy to 398 41m29s ddl 1 332ms others 355 32m4s select 145 2h34m22s lenon Total 12 13s834ms select 12 13s834ms Queries by host
Key values
- [local] Main host
- 921 Requests
- 3h48m19s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 461 Requests
- 3h6m23s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-05 20:34:38 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 364 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 10m6s analyze verbose;[ Date: 2026-09-05 05:10:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 6m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-05 20:12:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 6m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-05 07:11:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-05 21:11:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m analyze verbose;[ Date: 2026-09-05 05:16:08 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
6 4m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-05 11:09:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 4m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-05 16:09:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 4m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-05 08:09:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 4m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-05 15:09:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 4m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-05 14:09:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 4m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-05 09:09:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 4m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-05 13:09:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 4m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-05 12:09:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 4m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-05 22:09:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 4m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-05 10:09:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 4m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-05 17:09:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 4m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-05 19:09:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-05 18:09:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 3m56s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-05 07:17:25 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m44s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-05 20:17:13 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h26m43s 48 1s378ms 6m59s 1m48s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 05 07 3 7m28s 2m29s 08 3 5m4s 1m41s 09 3 5m2s 1m40s 10 3 5m 1m40s 11 3 5m5s 1m41s 12 3 5m2s 1m40s 13 3 5m2s 1m40s 14 3 5m3s 1m41s 15 3 5m3s 1m41s 16 3 5m5s 1m41s 17 3 5m 1m40s 18 3 4m58s 1m39s 19 3 4m59s 1m39s 20 3 7m22s 2m27s 21 3 6m22s 2m7s 22 3 5m1s 1m40s [ User: intelifix - Total duration: 1h26m43s - Times executed: 48 ]
[ Application: psql - Total duration: 1h26m43s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-05 20:12:00 Duration: 6m59s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-05 07:11:57 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-05 21:11:07 Duration: 6m6s Database: rio User: intelifix Remote: [local] Application: psql
2 1h7m21s 48 263ms 3m56s 1m24s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 05 07 3 5m1s 1m40s 08 3 4m3s 1m21s 09 3 4m4s 1m21s 10 3 4m5s 1m21s 11 3 4m2s 1m20s 12 3 4m6s 1m22s 13 3 4m6s 1m22s 14 3 4m2s 1m20s 15 3 4m9s 1m23s 16 3 4m7s 1m22s 17 3 4m13s 1m24s 18 3 4m4s 1m21s 19 3 4m4s 1m21s 20 3 4m55s 1m38s 21 3 4m2s 1m20s 22 3 4m12s 1m24s [ User: intelifix - Total duration: 1h7m21s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m21s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-05 07:17:25 Duration: 3m56s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-05 20:17:13 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-05 17:14:13 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql
3 18m52s 3 2m45s 10m6s 6m17s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 05 05 3 18m52s 6m17s [ User: intelifix - Total duration: 18m52s - Times executed: 3 ]
[ Application: psql - Total duration: 18m52s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-05 05:10:08 Duration: 10m6s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-05 05:16:08 Duration: 6m Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-05 05:18:53 Duration: 2m45s Database: contagem User: intelifix Remote: [local] Application: psql
4 7m17s 215 150ms 10s179ms 2s35ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 05 00 10 22s424ms 2s242ms 01 10 17s864ms 1s786ms 02 11 18s794ms 1s708ms 03 9 18s694ms 2s77ms 04 11 18s791ms 1s708ms 05 10 20s276ms 2s27ms 06 10 18s601ms 1s860ms 07 9 17s260ms 1s917ms 08 9 17s857ms 1s984ms 09 9 17s637ms 1s959ms 10 9 17s817ms 1s979ms 11 7 18s478ms 2s639ms 12 9 17s663ms 1s962ms 13 9 17s986ms 1s998ms 14 8 17s279ms 2s159ms 15 8 18s9ms 2s251ms 16 8 17s765ms 2s220ms 17 11 19s134ms 1s739ms 18 9 17s485ms 1s942ms 19 9 17s376ms 1s930ms 20 11 34s293ms 3s117ms 21 9 17s940ms 1s993ms 22 10 18s143ms 1s814ms [ User: intelifix - Total duration: 7m17s - Times executed: 215 ]
[ Application: psql - Total duration: 7m17s - Times executed: 215 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-05 20:15:11 Duration: 10s179ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-05 20:05:12 Duration: 9s996ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-05 00:05:25 Duration: 5s546ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m14s 4 4s136ms 1m3s 33s609ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 05 20 2 1m7s 33s974ms 23 2 1m6s 33s244ms [ User: intelifix - Total duration: 2m14s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m14s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-05 20:08:38 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-05 23:16:34 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-05 20:10:36 Duration: 4s240ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 1m45s 4 335ms 52s615ms 26s379ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 05 20 2 53s31ms 26s515ms 23 2 52s486ms 26s243ms [ User: intelifix - Total duration: 1m45s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m45s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-05 20:05:42 Duration: 52s615ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-05 23:13:42 Duration: 52s151ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-05 20:10:01 Duration: 416ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 1m45s 6 3s17ms 39s352ms 17s531ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 05 20 3 52s866ms 17s622ms 23 3 52s324ms 17s441ms [ User: intelifix - Total duration: 1m45s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m45s - 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-09-05 20:06:23 Duration: 39s352ms 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-09-05 23:14:22 Duration: 39s 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-09-05 20:10:12 Duration: 10s391ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m40s 35 434ms 18s208ms 2s878ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 05 00 6 27s277ms 4s546ms 01 6 14s734ms 2s455ms 02 6 11s393ms 1s898ms 03 5 15s73ms 3s14ms 04 6 14s867ms 2s477ms 05 5 16s943ms 3s388ms 20 1 459ms 459ms [ User: intelifix - Total duration: 1m40s - Times executed: 35 ]
[ Application: psql - Total duration: 1m40s - Times executed: 35 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-05 00:05:19 Duration: 18s208ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-05 05:25:07 Duration: 5s550ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-05 01:35:07 Duration: 5s373ms Database: rio User: intelifix Remote: [local] Application: psql
9 1m22s 1 1m22s 1m22s 1m22s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 05 05 1 1m22s 1m22s [ User: intelifix - Total duration: 1m22s - Times executed: 1 ]
[ Application: psql - Total duration: 1m22s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-05 05:32:04 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-05 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
10 1m22s 6 2s190ms 31s762ms 13s709ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 05 20 3 41s847ms 13s949ms 23 3 40s409ms 13s469ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-05 20:06:57 Duration: 31s762ms 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-09-05 23:14:56 Duration: 30s730ms 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-09-05 20:10:21 Duration: 7s846ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 1m21s 6 3s23ms 31s368ms 13s546ms 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 #11
Day Hour Count Duration Avg duration Sep 05 20 3 40s857ms 13s619ms 23 3 40s424ms 13s474ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - 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-09-05 20:09:10 Duration: 31s368ms 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-09-05 23:17:05 Duration: 31s189ms 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-09-05 20:10:43 Duration: 6s376ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1m9s 6 2s386ms 22s937ms 11s623ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 05 20 3 34s802ms 11s600ms 23 3 34s936ms 11s645ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-05 23:10:47 Duration: 22s937ms 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-09-05 20:02:47 Duration: 22s775ms 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-09-05 20:09:30 Duration: 9s639ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1m9s 6 2s156ms 23s578ms 11s567ms 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 Sep 05 20 3 34s764ms 11s588ms 23 3 34s642ms 11s547ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-05 20:03:28 Duration: 23s578ms 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-09-05 23:11:28 Duration: 23s482ms 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-09-05 20:09:42 Duration: 9s29ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1m5s 6 1s810ms 26s92ms 10s951ms 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 #14
Day Hour Count Duration Avg duration Sep 05 20 3 32s700ms 10s900ms 23 3 33s7ms 11s2ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m5s - 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-09-05 23:12:26 Duration: 26s92ms 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-09-05 20:04:27 Duration: 26s60ms 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-09-05 23:33:13 Duration: 5s21ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 54s301ms 4 4s74ms 23s105ms 13s575ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 05 20 2 27s121ms 13s560ms 23 2 27s180ms 13s590ms [ User: intelifix - Total duration: 54s301ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 54s301ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-05 23:12:49 Duration: 23s105ms 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-09-05 20:04:50 Duration: 22s879ms 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-09-05 20:10:01 Duration: 4s241ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 51s106ms 6 6s117ms 10s889ms 8s517ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 05 00 3 31s47ms 10s349ms 06 3 20s58ms 6s686ms [ User: intelifix - Total duration: 51s106ms - Times executed: 6 ]
[ Application: psql - Total duration: 51s106ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-05 00:05:12 Duration: 10s889ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-05 00:05:32 Duration: 10s153ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-05 00:05:22 Duration: 10s4ms Database: brasilia User: intelifix Remote: [local] Application: psql
17 50s310ms 6 1s740ms 16s338ms 8s385ms 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 #17
Day Hour Count Duration Avg duration Sep 05 20 3 25s380ms 8s460ms 23 3 24s929ms 8s309ms [ User: intelifix - Total duration: 50s310ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 50s310ms - 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-09-05 20:03:44 Duration: 16s338ms 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-09-05 23:11:44 Duration: 16s38ms 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-09-05 20:09:49 Duration: 7s241ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 48s635ms 59 572ms 2s716ms 824ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 05 08 4 3s475ms 868ms 09 4 5s294ms 1s323ms 10 3 2s282ms 760ms 11 4 2s943ms 735ms 12 4 2s821ms 705ms 13 4 2s824ms 706ms 14 3 2s166ms 722ms 15 3 2s176ms 725ms 16 4 3s7ms 751ms 17 3 2s295ms 765ms 18 4 2s882ms 720ms 19 6 4s908ms 818ms 20 4 4s649ms 1s162ms 21 4 2s957ms 739ms 22 5 3s947ms 789ms [ User: intelifix - Total duration: 48s635ms - Times executed: 59 ]
[ Application: psql - Total duration: 48s635ms - Times executed: 59 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-05 09:20:05 Duration: 2s716ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-05 20:20:04 Duration: 2s398ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-05 08:00:07 Duration: 1s130ms Database: brasilia User: intelifix Remote: [local] Application: psql
19 40s177ms 6 1s45ms 16s591ms 6s696ms 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 Sep 05 20 3 20s77ms 6s692ms 23 3 20s99ms 6s699ms [ User: intelifix - Total duration: 40s177ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s177ms - 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-09-05 23:11:04 Duration: 16s591ms 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-09-05 20:03:04 Duration: 16s533ms 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-09-05 20:09:33 Duration: 2s498ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 38s920ms 1 38s920ms 38s920ms 38s920ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 05 05 1 38s920ms 38s920ms [ User: intelifix - Total duration: 38s920ms - Times executed: 1 ]
[ Application: psql - Total duration: 38s920ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-05 05:30:41 Duration: 38s920ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-05 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 215 7m17s 150ms 10s179ms 2s35ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 05 00 10 22s424ms 2s242ms 01 10 17s864ms 1s786ms 02 11 18s794ms 1s708ms 03 9 18s694ms 2s77ms 04 11 18s791ms 1s708ms 05 10 20s276ms 2s27ms 06 10 18s601ms 1s860ms 07 9 17s260ms 1s917ms 08 9 17s857ms 1s984ms 09 9 17s637ms 1s959ms 10 9 17s817ms 1s979ms 11 7 18s478ms 2s639ms 12 9 17s663ms 1s962ms 13 9 17s986ms 1s998ms 14 8 17s279ms 2s159ms 15 8 18s9ms 2s251ms 16 8 17s765ms 2s220ms 17 11 19s134ms 1s739ms 18 9 17s485ms 1s942ms 19 9 17s376ms 1s930ms 20 11 34s293ms 3s117ms 21 9 17s940ms 1s993ms 22 10 18s143ms 1s814ms [ User: intelifix - Total duration: 7m17s - Times executed: 215 ]
[ Application: psql - Total duration: 7m17s - Times executed: 215 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-05 20:15:11 Duration: 10s179ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-05 20:05:12 Duration: 9s996ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-05 00:05:25 Duration: 5s546ms Database: rio User: intelifix Remote: [local] Application: psql
2 59 48s635ms 572ms 2s716ms 824ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 05 08 4 3s475ms 868ms 09 4 5s294ms 1s323ms 10 3 2s282ms 760ms 11 4 2s943ms 735ms 12 4 2s821ms 705ms 13 4 2s824ms 706ms 14 3 2s166ms 722ms 15 3 2s176ms 725ms 16 4 3s7ms 751ms 17 3 2s295ms 765ms 18 4 2s882ms 720ms 19 6 4s908ms 818ms 20 4 4s649ms 1s162ms 21 4 2s957ms 739ms 22 5 3s947ms 789ms [ User: intelifix - Total duration: 48s635ms - Times executed: 59 ]
[ Application: psql - Total duration: 48s635ms - Times executed: 59 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-05 09:20:05 Duration: 2s716ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-05 20:20:04 Duration: 2s398ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-05 08:00:07 Duration: 1s130ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 48 1h26m43s 1s378ms 6m59s 1m48s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 05 07 3 7m28s 2m29s 08 3 5m4s 1m41s 09 3 5m2s 1m40s 10 3 5m 1m40s 11 3 5m5s 1m41s 12 3 5m2s 1m40s 13 3 5m2s 1m40s 14 3 5m3s 1m41s 15 3 5m3s 1m41s 16 3 5m5s 1m41s 17 3 5m 1m40s 18 3 4m58s 1m39s 19 3 4m59s 1m39s 20 3 7m22s 2m27s 21 3 6m22s 2m7s 22 3 5m1s 1m40s [ User: intelifix - Total duration: 1h26m43s - Times executed: 48 ]
[ Application: psql - Total duration: 1h26m43s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-05 20:12:00 Duration: 6m59s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-05 07:11:57 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-05 21:11:07 Duration: 6m6s Database: rio User: intelifix Remote: [local] Application: psql
4 48 1h7m21s 263ms 3m56s 1m24s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 05 07 3 5m1s 1m40s 08 3 4m3s 1m21s 09 3 4m4s 1m21s 10 3 4m5s 1m21s 11 3 4m2s 1m20s 12 3 4m6s 1m22s 13 3 4m6s 1m22s 14 3 4m2s 1m20s 15 3 4m9s 1m23s 16 3 4m7s 1m22s 17 3 4m13s 1m24s 18 3 4m4s 1m21s 19 3 4m4s 1m21s 20 3 4m55s 1m38s 21 3 4m2s 1m20s 22 3 4m12s 1m24s [ User: intelifix - Total duration: 1h7m21s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m21s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-05 07:17:25 Duration: 3m56s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-05 20:17:13 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-05 17:14:13 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql
5 35 1m40s 434ms 18s208ms 2s878ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 05 00 6 27s277ms 4s546ms 01 6 14s734ms 2s455ms 02 6 11s393ms 1s898ms 03 5 15s73ms 3s14ms 04 6 14s867ms 2s477ms 05 5 16s943ms 3s388ms 20 1 459ms 459ms [ User: intelifix - Total duration: 1m40s - Times executed: 35 ]
[ Application: psql - Total duration: 1m40s - Times executed: 35 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-05 00:05:19 Duration: 18s208ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-05 05:25:07 Duration: 5s550ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-05 01:35:07 Duration: 5s373ms Database: rio User: intelifix Remote: [local] Application: psql
6 31 30s896ms 598ms 4s419ms 996ms 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 #6
Day Hour Count Duration Avg duration Sep 05 08 2 5s302ms 2s651ms 09 2 2s474ms 1s237ms 10 3 2s470ms 823ms 11 2 2s804ms 1s402ms 12 2 1s645ms 822ms 13 2 1s686ms 843ms 14 3 2s368ms 789ms 15 3 2s644ms 881ms 16 2 1s501ms 750ms 17 3 2s565ms 855ms 18 2 1s522ms 761ms 20 2 1s336ms 668ms 21 2 1s636ms 818ms 22 1 938ms 938ms [ User: intelifix - Total duration: 30s896ms - Times executed: 31 ]
[ Application: psql - Total duration: 30s896ms - Times executed: 31 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-05 08:00:06 Duration: 4s419ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-05 09:20:03 Duration: 1s876ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-05 11:20:03 Duration: 1s874ms Database: rio User: intelifix Remote: [local] Application: psql
7 7 3s188ms 250ms 679ms 455ms select p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault(?, p.proowner) as acldefault, p.pronamespace, p.proowner from pg_proc p left join pg_init_privs pip on (p.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?) where p.prokind <> ? and not exists ( select ? from pg_depend where classid = ?::regclass and objid = p.oid and deptype = ?) and (pronamespace != ( select oid from pg_namespace where nspname = ?) or exists ( select ? from pg_cast where pg_cast.oid > ? and p.oid = pg_cast.castfunc) or exists ( select ? from pg_transform where pg_transform.oid > ? and (p.oid = pg_transform.trffromsql or p.oid = pg_transform.trftosql)) or p.proacl is distinct from pip.initprivs);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 05 20 3 1s120ms 373ms 23 4 2s68ms 517ms [ User: intelifix - Total duration: 3s188ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 3s188ms - Times executed: 7 ]
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-09-05 23:17:08 Duration: 679ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-09-05 23:10:02 Duration: 668ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-09-05 20:09:12 Duration: 469ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 7 2s434ms 218ms 488ms 347ms select c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( case when c.relkind = ? then ?::"char" else ?::"char" end, c.relowner) as acldefault, case when c.relkind = ? then ( select ftserver from pg_catalog.pg_foreign_table where ftrelid = c.oid) else ? end as foreignserver, c.relfrozenxid, tc.relfrozenxid as tfrozenxid, tc.oid as toid, tc.relpages as toastpages, tc.reloptions as toast_reloptions, d.refobjid as owning_tab, d.refobjsubid as owning_col, tsp.spcname as reltablespace, false as relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid as tminmxid, array_remove(array_remove(c.reloptions, ?), ?) as reloptions, case when ? = any (c.reloptions) then ?::text when ? = any (c.reloptions) then ?::text else null end as checkoption, am.amname, (d.deptype = ?) is true as is_identity_sequence, c.relispartition as ispartition from pg_class c left join pg_depend d on (c.relkind = ? and d.classid = ?::regclass and d.objid = c.oid and d.objsubid = ? and d.refclassid = ?::regclass and d.deptype in (...)) left join pg_tablespace tsp on (tsp.oid = c.reltablespace) left join pg_am am on (c.relam = am.oid) left join pg_class tc on (c.reltoastrelid = tc.oid and tc.relkind = ? and c.relkind <> ?) where c.relkind in (...) order by c.oid;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 05 20 3 809ms 269ms 23 4 1s625ms 406ms [ User: intelifix - Total duration: 2s434ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s434ms - Times executed: 7 ]
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-09-05 23:41:52 Duration: 488ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-09-05 23:10:02 Duration: 428ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-09-05 23:32:27 Duration: 404ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 6 1m45s 3s17ms 39s352ms 17s531ms 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 #9
Day Hour Count Duration Avg duration Sep 05 20 3 52s866ms 17s622ms 23 3 52s324ms 17s441ms [ User: intelifix - Total duration: 1m45s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m45s - 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-09-05 20:06:23 Duration: 39s352ms 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-09-05 23:14:22 Duration: 39s 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-09-05 20:10:12 Duration: 10s391ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 6 1m22s 2s190ms 31s762ms 13s709ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 05 20 3 41s847ms 13s949ms 23 3 40s409ms 13s469ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-05 20:06:57 Duration: 31s762ms 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-09-05 23:14:56 Duration: 30s730ms 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-09-05 20:10:21 Duration: 7s846ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 1m21s 3s23ms 31s368ms 13s546ms 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 #11
Day Hour Count Duration Avg duration Sep 05 20 3 40s857ms 13s619ms 23 3 40s424ms 13s474ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - 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-09-05 20:09:10 Duration: 31s368ms 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-09-05 23:17:05 Duration: 31s189ms 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-09-05 20:10:43 Duration: 6s376ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 6 1m9s 2s386ms 22s937ms 11s623ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 05 20 3 34s802ms 11s600ms 23 3 34s936ms 11s645ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-05 23:10:47 Duration: 22s937ms 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-09-05 20:02:47 Duration: 22s775ms 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-09-05 20:09:30 Duration: 9s639ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 1m9s 2s156ms 23s578ms 11s567ms 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 Sep 05 20 3 34s764ms 11s588ms 23 3 34s642ms 11s547ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-05 20:03:28 Duration: 23s578ms 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-09-05 23:11:28 Duration: 23s482ms 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-09-05 20:09:42 Duration: 9s29ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 1m5s 1s810ms 26s92ms 10s951ms 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 #14
Day Hour Count Duration Avg duration Sep 05 20 3 32s700ms 10s900ms 23 3 33s7ms 11s2ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m5s - 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-09-05 23:12:26 Duration: 26s92ms 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-09-05 20:04:27 Duration: 26s60ms 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-09-05 23:33:13 Duration: 5s21ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 51s106ms 6s117ms 10s889ms 8s517ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 05 00 3 31s47ms 10s349ms 06 3 20s58ms 6s686ms [ User: intelifix - Total duration: 51s106ms - Times executed: 6 ]
[ Application: psql - Total duration: 51s106ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-05 00:05:12 Duration: 10s889ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-05 00:05:32 Duration: 10s153ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-05 00:05:22 Duration: 10s4ms Database: brasilia User: intelifix Remote: [local] Application: psql
16 6 50s310ms 1s740ms 16s338ms 8s385ms 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 #16
Day Hour Count Duration Avg duration Sep 05 20 3 25s380ms 8s460ms 23 3 24s929ms 8s309ms [ User: intelifix - Total duration: 50s310ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 50s310ms - 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-09-05 20:03:44 Duration: 16s338ms 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-09-05 23:11:44 Duration: 16s38ms 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-09-05 20:09:49 Duration: 7s241ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 6 40s177ms 1s45ms 16s591ms 6s696ms 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 #17
Day Hour Count Duration Avg duration Sep 05 20 3 20s77ms 6s692ms 23 3 20s99ms 6s699ms [ User: intelifix - Total duration: 40s177ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s177ms - 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-09-05 23:11:04 Duration: 16s591ms 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-09-05 20:03:04 Duration: 16s533ms 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-09-05 20:09:33 Duration: 2s498ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 28s381ms 838ms 12s482ms 4s730ms 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 #18
Day Hour Count Duration Avg duration Sep 05 20 3 14s276ms 4s758ms 23 3 14s105ms 4s701ms [ User: intelifix - Total duration: 28s381ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 28s381ms - 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-09-05 20:04:01 Duration: 12s482ms 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-09-05 23:12:00 Duration: 12s366ms 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-09-05 20:09:52 Duration: 926ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 26s681ms 2s732ms 5s693ms 4s446ms 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 #19
Day Hour Count Duration Avg duration Sep 05 20 3 13s594ms 4s531ms 23 3 13s86ms 4s362ms [ User: intelifix - Total duration: 26s681ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 26s681ms - 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-09-05 20:07:22 Duration: 5s693ms 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-09-05 23:15:19 Duration: 5s360ms 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-09-05 20:10:30 Duration: 5s167ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 26s666ms 943ms 10s231ms 4s444ms 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 #20
Day Hour Count Duration Avg duration Sep 05 20 3 13s365ms 4s455ms 23 3 13s301ms 4s433ms [ User: intelifix - Total duration: 26s666ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 26s666ms - 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-09-05 20:02:21 Duration: 10s231ms 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-09-05 23:10:20 Duration: 10s167ms 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-09-05 23:32:36 Duration: 2s189ms 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 2m45s 10m6s 6m17s 3 18m52s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 05 05 3 18m52s 6m17s [ User: intelifix - Total duration: 18m52s - Times executed: 3 ]
[ Application: psql - Total duration: 18m52s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-05 05:10:08 Duration: 10m6s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-05 05:16:08 Duration: 6m Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-05 05:18:53 Duration: 2m45s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s378ms 6m59s 1m48s 48 1h26m43s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 05 07 3 7m28s 2m29s 08 3 5m4s 1m41s 09 3 5m2s 1m40s 10 3 5m 1m40s 11 3 5m5s 1m41s 12 3 5m2s 1m40s 13 3 5m2s 1m40s 14 3 5m3s 1m41s 15 3 5m3s 1m41s 16 3 5m5s 1m41s 17 3 5m 1m40s 18 3 4m58s 1m39s 19 3 4m59s 1m39s 20 3 7m22s 2m27s 21 3 6m22s 2m7s 22 3 5m1s 1m40s [ User: intelifix - Total duration: 1h26m43s - Times executed: 48 ]
[ Application: psql - Total duration: 1h26m43s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-05 20:12:00 Duration: 6m59s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-05 07:11:57 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-05 21:11:07 Duration: 6m6s Database: rio User: intelifix Remote: [local] Application: psql
3 263ms 3m56s 1m24s 48 1h7m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 05 07 3 5m1s 1m40s 08 3 4m3s 1m21s 09 3 4m4s 1m21s 10 3 4m5s 1m21s 11 3 4m2s 1m20s 12 3 4m6s 1m22s 13 3 4m6s 1m22s 14 3 4m2s 1m20s 15 3 4m9s 1m23s 16 3 4m7s 1m22s 17 3 4m13s 1m24s 18 3 4m4s 1m21s 19 3 4m4s 1m21s 20 3 4m55s 1m38s 21 3 4m2s 1m20s 22 3 4m12s 1m24s [ User: intelifix - Total duration: 1h7m21s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m21s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-05 07:17:25 Duration: 3m56s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-05 20:17:13 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-05 17:14:13 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql
4 1m22s 1m22s 1m22s 1 1m22s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 05 05 1 1m22s 1m22s [ User: intelifix - Total duration: 1m22s - Times executed: 1 ]
[ Application: psql - Total duration: 1m22s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-05 05:32:04 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-05 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
5 38s920ms 38s920ms 38s920ms 1 38s920ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 05 05 1 38s920ms 38s920ms [ User: intelifix - Total duration: 38s920ms - Times executed: 1 ]
[ Application: psql - Total duration: 38s920ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-05 05:30:41 Duration: 38s920ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-05 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
6 4s136ms 1m3s 33s609ms 4 2m14s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 05 20 2 1m7s 33s974ms 23 2 1m6s 33s244ms [ User: intelifix - Total duration: 2m14s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m14s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-05 20:08:38 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-05 23:16:34 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-05 20:10:36 Duration: 4s240ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 335ms 52s615ms 26s379ms 4 1m45s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 05 20 2 53s31ms 26s515ms 23 2 52s486ms 26s243ms [ User: intelifix - Total duration: 1m45s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m45s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-05 20:05:42 Duration: 52s615ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-05 23:13:42 Duration: 52s151ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-05 20:10:01 Duration: 416ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 3s17ms 39s352ms 17s531ms 6 1m45s 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 #8
Day Hour Count Duration Avg duration Sep 05 20 3 52s866ms 17s622ms 23 3 52s324ms 17s441ms [ User: intelifix - Total duration: 1m45s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m45s - 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-09-05 20:06:23 Duration: 39s352ms 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-09-05 23:14:22 Duration: 39s 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-09-05 20:10:12 Duration: 10s391ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 2s190ms 31s762ms 13s709ms 6 1m22s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 05 20 3 41s847ms 13s949ms 23 3 40s409ms 13s469ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-05 20:06:57 Duration: 31s762ms 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-09-05 23:14:56 Duration: 30s730ms 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-09-05 20:10:21 Duration: 7s846ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 4s74ms 23s105ms 13s575ms 4 54s301ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 05 20 2 27s121ms 13s560ms 23 2 27s180ms 13s590ms [ User: intelifix - Total duration: 54s301ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 54s301ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-05 23:12:49 Duration: 23s105ms 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-09-05 20:04:50 Duration: 22s879ms 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-09-05 20:10:01 Duration: 4s241ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 3s23ms 31s368ms 13s546ms 6 1m21s 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 #11
Day Hour Count Duration Avg duration Sep 05 20 3 40s857ms 13s619ms 23 3 40s424ms 13s474ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - 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-09-05 20:09:10 Duration: 31s368ms 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-09-05 23:17:05 Duration: 31s189ms 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-09-05 20:10:43 Duration: 6s376ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s386ms 22s937ms 11s623ms 6 1m9s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 05 20 3 34s802ms 11s600ms 23 3 34s936ms 11s645ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-05 23:10:47 Duration: 22s937ms 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-09-05 20:02:47 Duration: 22s775ms 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-09-05 20:09:30 Duration: 9s639ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s156ms 23s578ms 11s567ms 6 1m9s 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 Sep 05 20 3 34s764ms 11s588ms 23 3 34s642ms 11s547ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-05 20:03:28 Duration: 23s578ms 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-09-05 23:11:28 Duration: 23s482ms 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-09-05 20:09:42 Duration: 9s29ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1s810ms 26s92ms 10s951ms 6 1m5s 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 #14
Day Hour Count Duration Avg duration Sep 05 20 3 32s700ms 10s900ms 23 3 33s7ms 11s2ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m5s - 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-09-05 23:12:26 Duration: 26s92ms 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-09-05 20:04:27 Duration: 26s60ms 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-09-05 23:33:13 Duration: 5s21ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6s117ms 10s889ms 8s517ms 6 51s106ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 05 00 3 31s47ms 10s349ms 06 3 20s58ms 6s686ms [ User: intelifix - Total duration: 51s106ms - Times executed: 6 ]
[ Application: psql - Total duration: 51s106ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-05 00:05:12 Duration: 10s889ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-05 00:05:32 Duration: 10s153ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-05 00:05:22 Duration: 10s4ms Database: brasilia User: intelifix Remote: [local] Application: psql
16 1s740ms 16s338ms 8s385ms 6 50s310ms 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 #16
Day Hour Count Duration Avg duration Sep 05 20 3 25s380ms 8s460ms 23 3 24s929ms 8s309ms [ User: intelifix - Total duration: 50s310ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 50s310ms - 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-09-05 20:03:44 Duration: 16s338ms 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-09-05 23:11:44 Duration: 16s38ms 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-09-05 20:09:49 Duration: 7s241ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1s45ms 16s591ms 6s696ms 6 40s177ms 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 #17
Day Hour Count Duration Avg duration Sep 05 20 3 20s77ms 6s692ms 23 3 20s99ms 6s699ms [ User: intelifix - Total duration: 40s177ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s177ms - 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-09-05 23:11:04 Duration: 16s591ms 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-09-05 20:03:04 Duration: 16s533ms 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-09-05 20:09:33 Duration: 2s498ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 838ms 12s482ms 4s730ms 6 28s381ms 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 #18
Day Hour Count Duration Avg duration Sep 05 20 3 14s276ms 4s758ms 23 3 14s105ms 4s701ms [ User: intelifix - Total duration: 28s381ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 28s381ms - 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-09-05 20:04:01 Duration: 12s482ms 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-09-05 23:12:00 Duration: 12s366ms 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-09-05 20:09:52 Duration: 926ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 2s732ms 5s693ms 4s446ms 6 26s681ms 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 #19
Day Hour Count Duration Avg duration Sep 05 20 3 13s594ms 4s531ms 23 3 13s86ms 4s362ms [ User: intelifix - Total duration: 26s681ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 26s681ms - 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-09-05 20:07:22 Duration: 5s693ms 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-09-05 23:15:19 Duration: 5s360ms 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-09-05 20:10:30 Duration: 5s167ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 943ms 10s231ms 4s444ms 6 26s666ms 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 #20
Day Hour Count Duration Avg duration Sep 05 20 3 13s365ms 4s455ms 23 3 13s301ms 4s433ms [ User: intelifix - Total duration: 26s666ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 26s666ms - 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-09-05 20:02:21 Duration: 10s231ms 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-09-05 23:10:20 Duration: 10s167ms 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-09-05 23:32:36 Duration: 2s189ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 204ms 1 204ms 204ms 204ms select * from rs_caixa_qr ();Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Sep 05 23 1 204ms 204ms [ User: etiquetas - Total duration: 2s241ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 2s241ms - Times executed: 1 ]
-
select * from rs_caixa_qr ();
Date: 2026-09-05 23:38:45 Duration: 204ms Database: postgres User: rio Remote: etiquetas Application: [local] Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 11 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 05 08 1 0ms 0ms 09 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 17 1 0ms 0ms 19 1 0ms 0ms 20 2 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 3m47s - Times executed: 11 ]
[ Application: psql - Total duration: 3m47s - Times executed: 11 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 4,975 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 32 FATAL entries
- 1430 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,426 Max number of times the same event was reported
- 1,463 Total events found
Rank Times reported Error 1 1,426 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 05 00 60 01 59 02 60 03 54 04 60 05 60 06 59 07 60 08 59 09 60 10 59 11 60 12 60 13 59 14 60 15 60 16 59 17 60 18 59 19 60 20 60 21 59 22 60 23 60 - ERROR: prepared statement "_PLAN00000000297E0380" does not exist
- ERROR: prepared statement "_PLAN00000000297DC830" does not exist
- ERROR: prepared statement "_PLAN000000002959C920" does not exist
Statement: DEALLOCATE "_PLAN00000000297E0380"
Date: 2026-09-05 00:00:30 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000297DC830"
Date: 2026-09-05 00:01:30 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002959C920"
Date: 2026-09-05 00:02:31 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 17 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 05 00 3 02 1 06 1 07 6 09 1 14 1 15 2 17 1 19 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-05 00:02:08 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-05 00:41:28 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-05 00:55:57 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 12 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 05 03 12 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-05 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-05 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-05 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local]
4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 05 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-05 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-05 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-05 05:32:04 Database: contagem Application: psql User: intelifix Remote: [local]
5 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 05 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-05 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-05 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-05 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
6 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 05 03 1 - LOG: database system was shut down at 2026-09-05 03:05:01 -03
Date: 2026-09-05 03:05:02