pgBadger-
Global information
- Generated on Thu Jun 4 23:50:04 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 6,754 log entries in 2s
- Log start from 2026-06-04 00:02:01 to 2026-06-04 23:40:33
-
Overview
Global Stats
- 151 Number of unique normalized queries
- 634 Number of queries
- 2h29m59s Total query duration
- 2026-06-04 00:02:05 First query
- 2026-06-04 23:40:32 Last query
- 4 queries/s at 2026-06-04 23:40:01 Query peak
- 2h29m59s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h29m59s Execute total duration
- 427 Number of events
- 7 Number of unique normalized events
- 378 Max number of times the same event was reported
- 0 Number of cancellation
- 6 Total number of automatic vacuums
- 15 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 111 Total number of sessions
- 5 sessions at 2026-06-04 01:05:01 Session peak
- 4d1h18m27s Total duration of sessions
- 52m35s Average duration of sessions
- 5 Average queries per session
- 1m21s Average queries duration per session
- 51m14s Average idle time per session
- 529 Total number of connections
- 4 connections/s at 2026-06-04 06:02:04 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-04 23:40:01 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-06-04 23:38:38 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-04 23:40:01 Date
Queries duration
Key values
- 2h29m59s 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) Jun 04 00 23 0ms 17s893ms 3s747ms 6s601ms 58s572ms 58s572ms 01 12 0ms 3s276ms 2s267ms 4s661ms 4s751ms 4s751ms 02 11 256ms 3s41ms 2s33ms 5s105ms 5s105ms 5s105ms 03 25 0ms 12s342ms 1s498ms 5s76ms 14s776ms 14s776ms 04 20 0ms 4s175ms 1s477ms 4s149ms 4s876ms 7s453ms 05 23 0ms 7m34s 26s162ms 6s552ms 2m 7m34s 06 10 0ms 8s403ms 3s745ms 19s298ms 19s298ms 19s298ms 07 10 0ms 8m17s 57s405ms 58s484ms 8m17s 8m17s 08 13 0ms 5m 26s910ms 3s268ms 5m28s 5m28s 09 19 0ms 5m 20s154ms 32s491ms 5m29s 5m29s 10 13 0ms 4m55s 26s443ms 27s827ms 4m55s 4m55s 11 13 430ms 4m54s 26s287ms 27s81ms 4m54s 4m54s 12 13 422ms 5m8s 27s327ms 5m35s 5m35s 5m35s 13 13 0ms 4m52s 26s281ms 29s307ms 4m52s 4m52s 14 13 413ms 4m59s 26s636ms 5m26s 5m26s 5m26s 15 13 0ms 5m7s 27s490ms 3s230ms 5m36s 5m36s 16 13 0ms 5m14s 27s890ms 3s233ms 5m42s 5m42s 17 13 563ms 4m55s 26s514ms 28s233ms 4m55s 4m55s 18 14 0ms 5m2s 25s163ms 3s719ms 5m29s 5m29s 19 13 0ms 5m2s 27s222ms 3s296ms 5m33s 5m33s 20 65 157ms 5m27s 12s468ms 2m6s 5m27s 5m27s 21 19 0ms 5m6s 18s887ms 3s105ms 5m38s 5m38s 22 13 0ms 5m5s 27s263ms 3s116ms 5m32s 5m32s 23 240 0ms 1m44s 7s615ms 1m29s 2m7s 2m7s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 04 00 8 0 789ms 999ms 1s414ms 3s732ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 13 0 367ms 912ms 1s317ms 2s186ms 04 8 0 233ms 185ms 188ms 809ms 05 10 0 387ms 160ms 371ms 2s335ms 06 2 0 1s817ms 0ms 3s635ms 3s635ms 07 4 0 2m19s 0ms 58s484ms 8m17s 08 4 0 1m22s 0ms 0ms 5m28s 09 10 0 36s254ms 1s9ms 32s491ms 5m29s 10 4 0 1m20s 0ms 27s827ms 4m55s 11 4 0 1m20s 0ms 27s81ms 4m54s 12 4 0 1m23s 0ms 5m35s 5m35s 13 4 0 1m20s 0ms 29s307ms 4m52s 14 4 0 1m21s 0ms 5m26s 5m26s 15 4 0 1m24s 0ms 0ms 5m36s 16 4 0 1m25s 0ms 0ms 5m42s 17 4 0 1m20s 0ms 28s233ms 4m55s 18 5 0 1m6s 0ms 758ms 5m29s 19 4 0 1m23s 0ms 0ms 5m33s 20 7 49 14s75ms 58s36ms 2m5s 5m27s 21 10 0 33s920ms 359ms 750ms 5m38s 22 4 0 1m23s 0ms 0ms 5m32s 23 15 221 7s736ms 1m5s 1m29s 2m7s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 04 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 Jun 04 00 0 2 2.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 4 4.00 0.00% 04 0 1 1.00 0.00% 05 0 3 3.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 2 2.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Jun 04 00 26 0.01/s 01 17 0.00/s 02 17 0.00/s 03 27 0.01/s 04 19 0.01/s 05 22 0.01/s 06 23 0.01/s 07 20 0.01/s 08 26 0.01/s 09 28 0.01/s 10 22 0.01/s 11 22 0.01/s 12 23 0.01/s 13 22 0.01/s 14 22 0.01/s 15 23 0.01/s 16 22 0.01/s 17 22 0.01/s 18 24 0.01/s 19 22 0.01/s 20 26 0.01/s 21 25 0.01/s 22 22 0.01/s 23 7 0.00/s Day Hour Count Average Duration Average idle time Jun 04 00 2 35m 34m17s 01 8 1h1m7s 1h1m4s 02 3 1h1s 59m53s 03 11 11m2s 10m59s 04 5 1h1m5s 1h59s 05 5 1h36s 58m35s 06 3 1h 59m48s 07 7 1h51s 59m29s 08 5 50m36s 49m26s 09 5 50m36s 49m19s 10 8 1h1m22s 1h39s 11 3 1h1m38s 59m44s 12 3 51m40s 49m41s 13 4 1h1m58s 1h32s 14 3 1h1m39s 59m44s 15 3 1h2m40s 1h40s 16 4 1h45s 59m14s 17 3 1h1m39s 59m44s 18 3 1h 58m2s 19 4 1h2m 1h31s 20 5 37m28s 34m46s 21 4 1h2m1s 1h31s 22 5 1h41s 59m30s 23 5 42m6s 36m -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-06-04 06:02:04 Date
Connections per database
Key values
- brasilia Main Database
- 529 connections Total
Connections per user
Key values
- intelifix Main User
- 529 connections Total
-
Sessions
Simultaneous sessions
Key values
- 5 sessions Session Peak
- 2026-06-04 01:05:01 Date
Histogram of session times
Key values
- 92 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 111 sessions Total
Sessions per user
Key values
- intelifix Main User
- 111 sessions Total
Sessions per host
Key values
- [local] Main Host
- 111 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 10,273 buffers Checkpoint Peak
- 2026-06-04 00:19:45 Date
- 270.034 seconds Highest write time
- 0.016 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-06-04 00:19:45 Date
Checkpoints distance
Key values
- 97.86 Mo Distance Peak
- 2026-06-04 00:19:45 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 04 00 18,035 723.95s 0.023s 724.01s 01 2,141 214.622s 0.02s 214.679s 02 1,389 139.288s 0.02s 139.331s 03 1,599 154.872s 0.037s 154.94s 04 3,045 305.298s 0.03s 305.36s 05 7,492 716.022s 0.032s 716.095s 06 3,859 269.138s 0.002s 269.145s 07 892 89.299s 0.012s 89.323s 08 22 2.249s 0.005s 2.263s 09 3,112 272.282s 0.01s 272.307s 10 21 2.148s 0.005s 2.16s 11 23 2.351s 0.003s 2.361s 12 20 2.027s 0.004s 2.035s 13 22 2.246s 0.005s 2.259s 14 23 2.348s 0.005s 2.36s 15 319 32.036s 0.004s 32.049s 16 24 2.429s 0.005s 2.442s 17 22 2.248s 0.005s 2.262s 18 778 78.02s 0.01s 78.051s 19 21 2.139s 0.005s 2.15s 20 275 27.63s 0.007s 27.648s 21 124 12.524s 0.011s 12.551s 22 23 2.349s 0.006s 2.364s 23 473 47.514s 0.026s 47.566s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 04 00 0 0 6 647 0.002s 0.008s 01 0 0 1 476 0.003s 0.008s 02 0 0 0 393 0.003s 0.006s 03 0 0 1 462 0.003s 0.009s 04 0 0 1 566 0.003s 0.008s 05 0 0 4 806 0.003s 0.009s 06 0 0 1 7 0.002s 0.001s 07 0 0 0 19 0.004s 0.003s 08 0 0 0 5 0.002s 0.002s 09 0 0 1 81 0.003s 0.005s 10 0 0 0 5 0.002s 0.002s 11 0 0 0 5 0.002s 0.002s 12 0 0 0 3 0.002s 0.002s 13 0 0 0 5 0.002s 0.002s 14 0 0 0 5 0.002s 0.002s 15 0 0 0 9 0.002s 0.002s 16 0 0 0 4 0.003s 0.002s 17 0 0 0 5 0.002s 0.002s 18 0 0 0 57 0.003s 0.004s 19 0 0 0 5 0.002s 0.002s 20 0 0 0 35 0.002s 0.003s 21 0 0 0 80 0.002s 0.004s 22 0 0 0 5 0.003s 0.003s 23 0 0 0 105 0.004s 0.009s Day Hour Count Avg time (sec) Jun 04 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 Jun 04 00 12,022.00 kB 37,564.88 kB 01 1,401.38 kB 18,105.25 kB 02 1,189.67 kB 9,160.17 kB 03 1,034.00 kB 2,663.12 kB 04 2,030.38 kB 2,804.00 kB 05 7,505.00 kB 23,962.33 kB 06 9,489.00 kB 17,498.00 kB 07 2,052.33 kB 14,749.33 kB 08 81.00 kB 11,351.50 kB 09 4,640.67 kB 10,726.33 kB 10 81.00 kB 11,774.50 kB 11 81.50 kB 9,553.50 kB 12 161.00 kB 8,166.00 kB 13 81.50 kB 6,994.00 kB 14 81.00 kB 5,679.00 kB 15 415.50 kB 4,646.50 kB 16 162.00 kB 4,017.00 kB 17 81.00 kB 3,447.00 kB 18 725.25 kB 2,767.00 kB 19 81.00 kB 2,031.00 kB 20 290.67 kB 1,627.33 kB 21 107.50 kB 1,177.25 kB 22 81.50 kB 873.00 kB 23 237.00 kB 687.50 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 04 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 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 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 1.06 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database contagem - 2026-06-04 00:05:48 Date
- 0 sec Highest CPU-cost analyze
Table
Database contagem - Date
Average Autovacuum Duration
Key values
- 1.06 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database contagem - 2026-06-04 00:05:48 Date
Analyzes per table
Key values
- public.temp0000281699 (9) Main table analyzed (database rio)
- 15 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_statistic (1) Main table vacuumed on database contagem
- 6 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,396 1,052 3,055,083 993 7,225 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,505 492 2,309,072 444 2,750 rio.public.logs 1 0 0 0 0 0 0 873 558 679,938 150 3,747 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 157 65 175,916 20 43 contagem.auditor.auditor_2026_06 1 0 0 0 0 0 0 4,360 3,602 4,323,260 0 0 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 907 159 1,009,147 86 317 Total 6 4 0 0 0 0 0 12,198 5,928 11,552,416 1,693 14,082 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (1.06) Max CPU elapsed for vacuum on database contagem
- unknown (0 ms) Max I/O read time for vacuum on database contagem
- unknown (0 ms) Max I/O write time for vacuum on database contagem
Tuples removed per table
Key values
- pg_catalog.pg_statistic (4069) Main table with removed tuples on database rio
- 8742 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,069 7,492 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 3,801 7,274 0 0 1,011 rio.pg_toast.pg_toast_2619 1 1 725 680 0 0 290 contagem.pg_toast.pg_toast_2619 1 1 147 114 0 0 62 rio.public.logs 1 0 0 15,806,603 0 0 631,500 contagem.auditor.auditor_2026_06 1 0 0 533,680 0 0 24,670 Total 6 4 8,742 16,355,843 0 0 658,819 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed contagem.pg_catalog.pg_statistic 1 1 3801 0 rio.pg_catalog.pg_statistic 1 1 4069 0 rio.public.logs 1 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 147 0 contagem.auditor.auditor_2026_06 1 0 0 0 rio.pg_toast.pg_toast_2619 1 1 725 0 Total 6 4 8,742 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 04 00 1 0 01 0 1 02 0 0 03 0 2 04 0 5 05 4 6 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 1 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 1 - 1.06 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 136 Total read queries
- 274 Total write queries
Queries by database
Key values
- rio Main database
- 465 Requests
- 2h24m44s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 615 Requests
User Request type Count Duration intelifix Total 615 2h29m46s copy to 270 37m8s ddl 4 1s989ms others 224 19m10s select 117 1h33m25s lenon Total 19 13s428ms select 19 13s428ms Duration by user
Key values
- 2h29m46s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 615 2h29m46s copy to 270 37m8s ddl 4 1s989ms others 224 19m10s select 117 1h33m25s lenon Total 19 13s428ms select 19 13s428ms Queries by host
Key values
- [local] Main host
- 634 Requests
- 2h29m59s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 294 Requests
- 1h51m53s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-04 23:33:40 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 252 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 8m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-04 07:13:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m34s analyze verbose;[ Date: 2026-06-04 05:07:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 5m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-04 20:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 5m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-04 16:10:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-04 12:10:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-04 15:10:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-04 21:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-04 22:10:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-04 18:10:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-04 19:10:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-04 09:10:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-04 08:10:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 4m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-04 14:10:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 4m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-04 17:09:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 4m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-04 10:09:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 4m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-04 11:09:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 4m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-04 13:09:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 2m analyze verbose;[ Date: 2026-06-04 05:09:36 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
19 1m44s COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;[ Date: 2026-06-04 23:14:34 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
20 1m29s COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;[ Date: 2026-06-04 23:11:35 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h24m28s 32 906ms 8m17s 2m38s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 04 07 2 8m19s 4m9s 08 2 5m1s 2m30s 09 2 5m1s 2m30s 10 2 4m56s 2m28s 11 2 4m55s 2m27s 12 2 5m9s 2m34s 13 2 4m53s 2m26s 14 2 5m 2m30s 15 2 5m8s 2m34s 16 2 5m15s 2m37s 17 2 4m56s 2m28s 18 2 5m3s 2m31s 19 2 5m3s 2m31s 20 2 5m29s 2m44s 21 2 5m7s 2m33s 22 2 5m6s 2m33s [ User: intelifix - Total duration: 1h24m28s - Times executed: 32 ]
[ Application: psql - Total duration: 1h24m28s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-04 07:13:18 Duration: 8m17s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-04 20:10:29 Duration: 5m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-04 16:10:16 Duration: 5m14s Database: rio User: intelifix Remote: [local] Application: psql
2 9m34s 2 2m 7m34s 4m47s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 04 05 2 9m34s 4m47s [ User: intelifix - Total duration: 9m34s - Times executed: 2 ]
[ Application: psql - Total duration: 9m34s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-06-04 05:07:35 Duration: 7m34s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-04 05:09:36 Duration: 2m Database: contagem User: intelifix Remote: [local] Application: psql
3 8m5s 32 413ms 55s186ms 15s177ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 04 07 2 56s432ms 28s216ms 08 2 27s112ms 13s556ms 09 2 27s239ms 13s619ms 10 2 26s834ms 13s417ms 11 2 26s60ms 13s30ms 12 2 25s173ms 12s586ms 13 2 27s969ms 13s984ms 14 2 26s362ms 13s181ms 15 2 27s806ms 13s903ms 16 2 26s510ms 13s255ms 17 2 27s61ms 13s530ms 18 2 26s755ms 13s377ms 19 2 30s22ms 15s11ms 20 2 49s77ms 24s538ms 21 2 29s61ms 14s530ms 22 2 26s188ms 13s94ms [ User: intelifix - Total duration: 8m5s - Times executed: 32 ]
[ Application: psql - Total duration: 8m5s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-04 07:14:14 Duration: 55s186ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-04 20:11:16 Duration: 47s636ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-04 19:10:32 Duration: 29s562ms Database: rio User: intelifix Remote: [local] Application: psql
4 6m56s 138 2s612ms 12s342ms 3s15ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 04 00 6 24s869ms 4s144ms 01 6 17s978ms 2s996ms 02 6 17s130ms 2s855ms 03 6 26s650ms 4s441ms 04 6 17s604ms 2s934ms 05 6 16s958ms 2s826ms 06 6 17s345ms 2s890ms 07 6 17s892ms 2s982ms 08 6 16s829ms 2s804ms 09 6 17s305ms 2s884ms 10 6 17s85ms 2s847ms 11 6 17s252ms 2s875ms 12 6 16s932ms 2s822ms 13 6 16s934ms 2s822ms 14 6 16s705ms 2s784ms 15 6 16s947ms 2s824ms 16 6 17s615ms 2s935ms 17 6 17s543ms 2s923ms 18 6 18s444ms 3s74ms 19 6 17s586ms 2s931ms 20 6 18s552ms 3s92ms 21 6 16s530ms 2s755ms 22 6 17s467ms 2s911ms [ User: intelifix - Total duration: 6m56s - Times executed: 138 ]
[ Application: psql - Total duration: 6m56s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-04 03:05:29 Duration: 12s342ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-04 00:05:25 Duration: 10s521ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-04 18:15:05 Duration: 3s719ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m43s 2 1m18s 1m24s 1m21s 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 Jun 04 20 1 1m18s 1m18s 23 1 1m24s 1m24s [ User: intelifix - Total duration: 2m43s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m43s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-04 23:38:13 Duration: 1m24s 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-06-04 20:08:06 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: pg_dump
6 2m3s 2 19s432ms 1m44s 1m1s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 04 23 2 2m3s 1m1s [ User: intelifix - Total duration: 2m3s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m3s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-04 23:14:34 Duration: 1m44s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-04 23:39:35 Duration: 19s432ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 1m48s 2 19s60ms 1m29s 54s276ms copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 04 23 2 1m48s 54s276ms [ User: intelifix - Total duration: 1m48s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 2 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-04 23:11:35 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-04 23:38:59 Duration: 19s60ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 1m48s 2 49s825ms 58s659ms 54s242ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 04 20 1 58s659ms 58s659ms 23 1 49s825ms 49s825ms [ User: intelifix - Total duration: 1m48s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-04 20:05:16 Duration: 58s659ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-04 23:17:55 Duration: 49s825ms Database: rio User: intelifix Remote: [local] Application: pg_dump
9 1m31s 2 16s644ms 1m14s 45s604ms copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 04 23 2 1m31s 45s604ms [ User: intelifix - Total duration: 1m31s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m31s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-04 23:12:49 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-04 23:39:16 Duration: 16s644ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1m1s 4 2s114ms 29s452ms 15s465ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 04 20 2 30s86ms 15s43ms 23 2 31s776ms 15s888ms [ User: intelifix - Total duration: 1m1s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m1s - Times executed: 4 ]
-
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-06-04 23:18:26 Duration: 29s452ms 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-06-04 20:05:46 Duration: 27s972ms 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-06-04 23:39:53 Duration: 2s324ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 55s947ms 33 196ms 12s720ms 1s695ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 04 00 6 19s666ms 3s277ms 01 6 9s228ms 1s538ms 02 5 5s234ms 1s46ms 03 5 5s790ms 1s158ms 04 6 10s75ms 1s679ms 05 5 5s951ms 1s190ms [ User: intelifix - Total duration: 55s947ms - Times executed: 33 ]
[ Application: psql - Total duration: 55s947ms - Times executed: 33 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-04 00:05:14 Duration: 12s720ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-04 04:45:05 Duration: 4s175ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-04 03:15:04 Duration: 2s333ms Database: rio User: intelifix Remote: [local] Application: psql
12 54s957ms 4 1s592ms 26s857ms 13s739ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 04 20 2 26s331ms 13s165ms 23 2 28s625ms 14s312ms [ User: intelifix - Total duration: 54s957ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 54s957ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-04 23:18:55 Duration: 26s857ms 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-06-04 20:06:13 Duration: 24s739ms 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-06-04 23:39:55 Duration: 1s767ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 51s572ms 45 731ms 2s327ms 1s146ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 04 08 3 4s317ms 1s439ms 09 3 3s87ms 1s29ms 10 3 3s789ms 1s263ms 11 3 3s178ms 1s59ms 12 3 3s285ms 1s95ms 13 3 3s292ms 1s97ms 14 3 3s113ms 1s37ms 15 3 4s108ms 1s369ms 16 3 2s887ms 962ms 17 3 3s148ms 1s49ms 18 3 3s157ms 1s52ms 19 3 3s45ms 1s15ms 20 3 3s669ms 1s223ms 21 3 3s119ms 1s39ms 22 3 4s371ms 1s457ms [ User: intelifix - Total duration: 51s572ms - Times executed: 45 ]
[ Application: psql - Total duration: 51s572ms - Times executed: 45 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-04 15:20:03 Duration: 2s327ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-04 10:20:04 Duration: 2s227ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-04 22:20:03 Duration: 2s218ms Database: rio User: intelifix Remote: [local] Application: psql
14 51s537ms 4 8s66ms 17s893ms 12s884ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 04 00 2 35s67ms 17s533ms 06 2 16s469ms 8s234ms [ User: intelifix - Total duration: 51s537ms - Times executed: 4 ]
[ Application: psql - Total duration: 51s537ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-04 00:05:19 Duration: 17s893ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-04 00:05:36 Duration: 17s174ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-04 06:05:10 Duration: 8s403ms Database: rio User: intelifix Remote: [local] Application: psql
15 50s926ms 4 2s578ms 23s25ms 12s731ms 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 #15
Day Hour Count Duration Avg duration Jun 04 20 2 25s293ms 12s646ms 23 2 25s632ms 12s816ms [ User: intelifix - Total duration: 50s926ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 50s926ms - Times executed: 4 ]
-
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-06-04 23:38:36 Duration: 23s25ms 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-06-04 20:08:29 Duration: 22s715ms 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-06-04 23:40:30 Duration: 2s607ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 44s116ms 4 1s276ms 21s295ms 11s29ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 04 20 2 22s571ms 11s285ms 23 2 21s545ms 10s772ms [ User: intelifix - Total duration: 44s116ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 44s116ms - Times executed: 4 ]
-
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-06-04 20:04:00 Duration: 21s295ms 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-06-04 23:16:47 Duration: 20s221ms 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-06-04 23:39:51 Duration: 1s323ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 38s637ms 4 1s390ms 18s102ms 9s659ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 04 20 2 19s143ms 9s571ms 23 2 19s493ms 9s746ms [ User: intelifix - Total duration: 38s637ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 38s637ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-04 23:15:59 Duration: 18s102ms 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-06-04 20:03:09 Duration: 17s524ms 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-06-04 20:08:41 Duration: 1s618ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 38s132ms 4 1s627ms 17s516ms 9s533ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 04 20 2 19s318ms 9s659ms 23 2 18s813ms 9s406ms [ User: intelifix - Total duration: 38s132ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 38s132ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-04 20:02:39 Duration: 17s516ms 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-06-04 23:15:27 Duration: 17s186ms 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-06-04 20:08:39 Duration: 1s802ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 35s804ms 2 17s883ms 17s920ms 17s902ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 04 20 1 17s883ms 17s883ms 23 1 17s920ms 17s920ms [ User: intelifix - Total duration: 35s804ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 35s804ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-04 23:17:05 Duration: 17s920ms 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-06-04 20:04:18 Duration: 17s883ms Database: rio User: intelifix Remote: [local] Application: pg_dump
20 31s665ms 2 1s96ms 30s569ms 15s832ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 04 09 2 31s665ms 15s832ms [ User: intelifix - Total duration: 31s665ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 31s665ms - Times executed: 2 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-04', 080, '', '', 0, 6, '2026-06-01');
Date: 2026-06-04 09:41:07 Duration: 30s569ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-04', 080, '', '', 0, 2, '2026-06-01');
Date: 2026-06-04 09:41:46 Duration: 1s96ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 138 6m56s 2s612ms 12s342ms 3s15ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 04 00 6 24s869ms 4s144ms 01 6 17s978ms 2s996ms 02 6 17s130ms 2s855ms 03 6 26s650ms 4s441ms 04 6 17s604ms 2s934ms 05 6 16s958ms 2s826ms 06 6 17s345ms 2s890ms 07 6 17s892ms 2s982ms 08 6 16s829ms 2s804ms 09 6 17s305ms 2s884ms 10 6 17s85ms 2s847ms 11 6 17s252ms 2s875ms 12 6 16s932ms 2s822ms 13 6 16s934ms 2s822ms 14 6 16s705ms 2s784ms 15 6 16s947ms 2s824ms 16 6 17s615ms 2s935ms 17 6 17s543ms 2s923ms 18 6 18s444ms 3s74ms 19 6 17s586ms 2s931ms 20 6 18s552ms 3s92ms 21 6 16s530ms 2s755ms 22 6 17s467ms 2s911ms [ User: intelifix - Total duration: 6m56s - Times executed: 138 ]
[ Application: psql - Total duration: 6m56s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-04 03:05:29 Duration: 12s342ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-04 00:05:25 Duration: 10s521ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-04 18:15:05 Duration: 3s719ms Database: rio User: intelifix Remote: [local] Application: psql
2 45 51s572ms 731ms 2s327ms 1s146ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 04 08 3 4s317ms 1s439ms 09 3 3s87ms 1s29ms 10 3 3s789ms 1s263ms 11 3 3s178ms 1s59ms 12 3 3s285ms 1s95ms 13 3 3s292ms 1s97ms 14 3 3s113ms 1s37ms 15 3 4s108ms 1s369ms 16 3 2s887ms 962ms 17 3 3s148ms 1s49ms 18 3 3s157ms 1s52ms 19 3 3s45ms 1s15ms 20 3 3s669ms 1s223ms 21 3 3s119ms 1s39ms 22 3 4s371ms 1s457ms [ User: intelifix - Total duration: 51s572ms - Times executed: 45 ]
[ Application: psql - Total duration: 51s572ms - Times executed: 45 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-04 15:20:03 Duration: 2s327ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-04 10:20:04 Duration: 2s227ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-04 22:20:03 Duration: 2s218ms Database: rio User: intelifix Remote: [local] Application: psql
3 33 55s947ms 196ms 12s720ms 1s695ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 04 00 6 19s666ms 3s277ms 01 6 9s228ms 1s538ms 02 5 5s234ms 1s46ms 03 5 5s790ms 1s158ms 04 6 10s75ms 1s679ms 05 5 5s951ms 1s190ms [ User: intelifix - Total duration: 55s947ms - Times executed: 33 ]
[ Application: psql - Total duration: 55s947ms - Times executed: 33 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-04 00:05:14 Duration: 12s720ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-04 04:45:05 Duration: 4s175ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-04 03:15:04 Duration: 2s333ms Database: rio User: intelifix Remote: [local] Application: psql
4 32 1h24m28s 906ms 8m17s 2m38s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 04 07 2 8m19s 4m9s 08 2 5m1s 2m30s 09 2 5m1s 2m30s 10 2 4m56s 2m28s 11 2 4m55s 2m27s 12 2 5m9s 2m34s 13 2 4m53s 2m26s 14 2 5m 2m30s 15 2 5m8s 2m34s 16 2 5m15s 2m37s 17 2 4m56s 2m28s 18 2 5m3s 2m31s 19 2 5m3s 2m31s 20 2 5m29s 2m44s 21 2 5m7s 2m33s 22 2 5m6s 2m33s [ User: intelifix - Total duration: 1h24m28s - Times executed: 32 ]
[ Application: psql - Total duration: 1h24m28s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-04 07:13:18 Duration: 8m17s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-04 20:10:29 Duration: 5m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-04 16:10:16 Duration: 5m14s Database: rio User: intelifix Remote: [local] Application: psql
5 32 8m5s 413ms 55s186ms 15s177ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 04 07 2 56s432ms 28s216ms 08 2 27s112ms 13s556ms 09 2 27s239ms 13s619ms 10 2 26s834ms 13s417ms 11 2 26s60ms 13s30ms 12 2 25s173ms 12s586ms 13 2 27s969ms 13s984ms 14 2 26s362ms 13s181ms 15 2 27s806ms 13s903ms 16 2 26s510ms 13s255ms 17 2 27s61ms 13s530ms 18 2 26s755ms 13s377ms 19 2 30s22ms 15s11ms 20 2 49s77ms 24s538ms 21 2 29s61ms 14s530ms 22 2 26s188ms 13s94ms [ User: intelifix - Total duration: 8m5s - Times executed: 32 ]
[ Application: psql - Total duration: 8m5s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-04 07:14:14 Duration: 55s186ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-04 20:11:16 Duration: 47s636ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-04 19:10:32 Duration: 29s562ms Database: rio User: intelifix Remote: [local] Application: psql
6 15 6s61ms 308ms 589ms 404ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 04 00 2 976ms 488ms 03 4 1s566ms 391ms 04 1 335ms 335ms 05 3 1s145ms 381ms 09 2 768ms 384ms 21 2 853ms 426ms 23 1 414ms 414ms [ User: lenon - Total duration: 6s61ms - Times executed: 15 ]
[ Application: [unknown] - Total duration: 6s61ms - Times executed: 15 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-04 00:15:02 Duration: 589ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-04 21:10:08 Duration: 545ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-04 09:40:34 Duration: 429ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
7 12 6s747ms 441ms 971ms 562ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 04 00 2 1s271ms 635ms 03 4 2s134ms 533ms 04 1 474ms 474ms 05 3 1s454ms 484ms 21 1 441ms 441ms 23 1 971ms 971ms [ User: intelifix - Total duration: 6s747ms - Times executed: 12 ]
[ Application: [unknown] - Total duration: 6s747ms - Times executed: 12 ]
-
select * from rs_menu_grants (502, 19, 1);
Date: 2026-06-04 23:27:40 Duration: 971ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-06-04 00:15:02 Duration: 659ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-06-04 03:05:20 Duration: 632ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10 2s416ms 154ms 543ms 241ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 04 03 1 273ms 273ms 04 5 871ms 174ms 05 4 1s272ms 318ms [ User: intelifix - Total duration: 2s416ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 2s416ms - Times executed: 10 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241731249099,241676590220,241608678596,241618279499,241701358090,241608880918,241659743345,241728531125,241732161726,241703993758,241604762031,241617908599,241728687884,241658350112,241604355167,241667186181,241667080313,241707280207,230049258588,241667007476,241639036071,230049233839,241674592022,241635983439,241614528506,241663845866,241598152340,241654542950,241654354143,241636130525,241673358096,241680380915,241663845260,241656701017,241618219113,241671518703,241680427585,241659711423,241654297897', NULL, NULL, 0320, 00);
Date: 2026-06-04 05:15:55 Duration: 543ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229996271937,229926246269,229992981627,229969647777,229994843750,229983585266,229969321226,230003313443,229961058398,229927209809,229958088502,230000768895,229953167886,229993085980,229983428304,229938556079,230016980120,229969674144,229997490002,230013814647,230012776779,229925704365,230018403737,229994333442,229931145771,230018440408,229985775154,229959122834', NULL, NULL, 0287, 00);
Date: 2026-06-04 05:26:30 Duration: 371ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '121', 2, '230005739920,230030088705', NULL, NULL, 0295, 00);
Date: 2026-06-04 03:07:55 Duration: 273ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 4 1m1s 2s114ms 29s452ms 15s465ms 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 Jun 04 20 2 30s86ms 15s43ms 23 2 31s776ms 15s888ms [ User: intelifix - Total duration: 1m1s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m1s - Times executed: 4 ]
-
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-06-04 23:18:26 Duration: 29s452ms 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-06-04 20:05:46 Duration: 27s972ms 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-06-04 23:39:53 Duration: 2s324ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 4 54s957ms 1s592ms 26s857ms 13s739ms 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 Jun 04 20 2 26s331ms 13s165ms 23 2 28s625ms 14s312ms [ User: intelifix - Total duration: 54s957ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 54s957ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-04 23:18:55 Duration: 26s857ms 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-06-04 20:06:13 Duration: 24s739ms 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-06-04 23:39:55 Duration: 1s767ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 4 51s537ms 8s66ms 17s893ms 12s884ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 04 00 2 35s67ms 17s533ms 06 2 16s469ms 8s234ms [ User: intelifix - Total duration: 51s537ms - Times executed: 4 ]
[ Application: psql - Total duration: 51s537ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-04 00:05:19 Duration: 17s893ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-04 00:05:36 Duration: 17s174ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-04 06:05:10 Duration: 8s403ms Database: rio User: intelifix Remote: [local] Application: psql
12 4 50s926ms 2s578ms 23s25ms 12s731ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 04 20 2 25s293ms 12s646ms 23 2 25s632ms 12s816ms [ User: intelifix - Total duration: 50s926ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 50s926ms - Times executed: 4 ]
-
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-06-04 23:38:36 Duration: 23s25ms 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-06-04 20:08:29 Duration: 22s715ms 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-06-04 23:40:30 Duration: 2s607ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 4 44s116ms 1s276ms 21s295ms 11s29ms 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 #13
Day Hour Count Duration Avg duration Jun 04 20 2 22s571ms 11s285ms 23 2 21s545ms 10s772ms [ User: intelifix - Total duration: 44s116ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 44s116ms - Times executed: 4 ]
-
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-06-04 20:04:00 Duration: 21s295ms 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-06-04 23:16:47 Duration: 20s221ms 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-06-04 23:39:51 Duration: 1s323ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 4 38s637ms 1s390ms 18s102ms 9s659ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 04 20 2 19s143ms 9s571ms 23 2 19s493ms 9s746ms [ User: intelifix - Total duration: 38s637ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 38s637ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-04 23:15:59 Duration: 18s102ms 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-06-04 20:03:09 Duration: 17s524ms 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-06-04 20:08:41 Duration: 1s618ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 4 38s132ms 1s627ms 17s516ms 9s533ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 04 20 2 19s318ms 9s659ms 23 2 18s813ms 9s406ms [ User: intelifix - Total duration: 38s132ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 38s132ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-04 20:02:39 Duration: 17s516ms 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-06-04 23:15:27 Duration: 17s186ms 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-06-04 20:08:39 Duration: 1s802ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 4 29s270ms 1s389ms 13s929ms 7s317ms 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 Jun 04 20 2 15s319ms 7s659ms 23 2 13s951ms 6s975ms [ User: intelifix - Total duration: 29s270ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 29s270ms - Times executed: 4 ]
-
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-06-04 20:03:23 Duration: 13s929ms 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-06-04 23:16:11 Duration: 12s541ms 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-06-04 23:39:48 Duration: 1s410ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 4 27s550ms 762ms 13s472ms 6s887ms 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 Jun 04 20 2 13s311ms 6s655ms 23 2 14s239ms 7s119ms [ User: intelifix - Total duration: 27s550ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 27s550ms - Times executed: 4 ]
-
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-06-04 23:15:41 Duration: 13s472ms 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-06-04 20:02:52 Duration: 12s549ms 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-06-04 23:39:45 Duration: 766ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 4 23s883ms 628ms 11s227ms 5s970ms 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 Jun 04 20 2 11s855ms 5s927ms 23 2 12s27ms 6s13ms [ User: intelifix - Total duration: 23s883ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 23s883ms - Times executed: 4 ]
-
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-06-04 20:03:38 Duration: 11s227ms 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-06-04 23:16:27 Duration: 11s208ms 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-06-04 23:39:49 Duration: 819ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 4 19s192ms 655ms 9s392ms 4s798ms 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 #19
Day Hour Count Duration Avg duration Jun 04 20 2 10s170ms 5s85ms 23 2 9s21ms 4s510ms [ User: intelifix - Total duration: 19s192ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 19s192ms - Times executed: 4 ]
-
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-06-04 20:02:18 Duration: 9s392ms 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-06-04 23:15:06 Duration: 8s365ms 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-06-04 20:08:37 Duration: 778ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 4 18s783ms 2s545ms 6s642ms 4s695ms 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 #20
Day Hour Count Duration Avg duration Jun 04 20 2 9s595ms 4s797ms 23 2 9s187ms 4s593ms [ User: intelifix - Total duration: 18s783ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 18s783ms - Times executed: 4 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-06-04 23:36:36 Duration: 6s642ms 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-06-04 20:06:36 Duration: 6s475ms 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-06-04 20:08:53 Duration: 3s120ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m 7m34s 4m47s 2 9m34s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 04 05 2 9m34s 4m47s [ User: intelifix - Total duration: 9m34s - Times executed: 2 ]
[ Application: psql - Total duration: 9m34s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-06-04 05:07:35 Duration: 7m34s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-04 05:09:36 Duration: 2m Database: contagem User: intelifix Remote: [local] Application: psql
2 906ms 8m17s 2m38s 32 1h24m28s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 04 07 2 8m19s 4m9s 08 2 5m1s 2m30s 09 2 5m1s 2m30s 10 2 4m56s 2m28s 11 2 4m55s 2m27s 12 2 5m9s 2m34s 13 2 4m53s 2m26s 14 2 5m 2m30s 15 2 5m8s 2m34s 16 2 5m15s 2m37s 17 2 4m56s 2m28s 18 2 5m3s 2m31s 19 2 5m3s 2m31s 20 2 5m29s 2m44s 21 2 5m7s 2m33s 22 2 5m6s 2m33s [ User: intelifix - Total duration: 1h24m28s - Times executed: 32 ]
[ Application: psql - Total duration: 1h24m28s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-04 07:13:18 Duration: 8m17s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-04 20:10:29 Duration: 5m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-04 16:10:16 Duration: 5m14s Database: rio User: intelifix Remote: [local] Application: psql
3 1m18s 1m24s 1m21s 2 2m43s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 04 20 1 1m18s 1m18s 23 1 1m24s 1m24s [ User: intelifix - Total duration: 2m43s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m43s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-04 23:38:13 Duration: 1m24s 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-06-04 20:08:06 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 19s432ms 1m44s 1m1s 2 2m3s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 04 23 2 2m3s 1m1s [ User: intelifix - Total duration: 2m3s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m3s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-04 23:14:34 Duration: 1m44s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-04 23:39:35 Duration: 19s432ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 19s60ms 1m29s 54s276ms 2 1m48s copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 04 23 2 1m48s 54s276ms [ User: intelifix - Total duration: 1m48s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 2 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-04 23:11:35 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-04 23:38:59 Duration: 19s60ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 49s825ms 58s659ms 54s242ms 2 1m48s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 04 20 1 58s659ms 58s659ms 23 1 49s825ms 49s825ms [ User: intelifix - Total duration: 1m48s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-04 20:05:16 Duration: 58s659ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-04 23:17:55 Duration: 49s825ms Database: rio User: intelifix Remote: [local] Application: pg_dump
7 16s644ms 1m14s 45s604ms 2 1m31s copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 04 23 2 1m31s 45s604ms [ User: intelifix - Total duration: 1m31s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m31s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-04 23:12:49 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-04 23:39:16 Duration: 16s644ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 17s883ms 17s920ms 17s902ms 2 35s804ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 04 20 1 17s883ms 17s883ms 23 1 17s920ms 17s920ms [ User: intelifix - Total duration: 35s804ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 35s804ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-04 23:17:05 Duration: 17s920ms 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-06-04 20:04:18 Duration: 17s883ms Database: rio User: intelifix Remote: [local] Application: pg_dump
9 1s96ms 30s569ms 15s832ms 2 31s665ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 04 09 2 31s665ms 15s832ms [ User: intelifix - Total duration: 31s665ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 31s665ms - Times executed: 2 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-04', 080, '', '', 0, 6, '2026-06-01');
Date: 2026-06-04 09:41:07 Duration: 30s569ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-04', 080, '', '', 0, 2, '2026-06-01');
Date: 2026-06-04 09:41:46 Duration: 1s96ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
10 2s114ms 29s452ms 15s465ms 4 1m1s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 04 20 2 30s86ms 15s43ms 23 2 31s776ms 15s888ms [ User: intelifix - Total duration: 1m1s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m1s - Times executed: 4 ]
-
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-06-04 23:18:26 Duration: 29s452ms 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-06-04 20:05:46 Duration: 27s972ms 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-06-04 23:39:53 Duration: 2s324ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 413ms 55s186ms 15s177ms 32 8m5s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 04 07 2 56s432ms 28s216ms 08 2 27s112ms 13s556ms 09 2 27s239ms 13s619ms 10 2 26s834ms 13s417ms 11 2 26s60ms 13s30ms 12 2 25s173ms 12s586ms 13 2 27s969ms 13s984ms 14 2 26s362ms 13s181ms 15 2 27s806ms 13s903ms 16 2 26s510ms 13s255ms 17 2 27s61ms 13s530ms 18 2 26s755ms 13s377ms 19 2 30s22ms 15s11ms 20 2 49s77ms 24s538ms 21 2 29s61ms 14s530ms 22 2 26s188ms 13s94ms [ User: intelifix - Total duration: 8m5s - Times executed: 32 ]
[ Application: psql - Total duration: 8m5s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-04 07:14:14 Duration: 55s186ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-04 20:11:16 Duration: 47s636ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-04 19:10:32 Duration: 29s562ms Database: rio User: intelifix Remote: [local] Application: psql
12 1s592ms 26s857ms 13s739ms 4 54s957ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 04 20 2 26s331ms 13s165ms 23 2 28s625ms 14s312ms [ User: intelifix - Total duration: 54s957ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 54s957ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-04 23:18:55 Duration: 26s857ms 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-06-04 20:06:13 Duration: 24s739ms 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-06-04 23:39:55 Duration: 1s767ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 8s66ms 17s893ms 12s884ms 4 51s537ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 04 00 2 35s67ms 17s533ms 06 2 16s469ms 8s234ms [ User: intelifix - Total duration: 51s537ms - Times executed: 4 ]
[ Application: psql - Total duration: 51s537ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-04 00:05:19 Duration: 17s893ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-04 00:05:36 Duration: 17s174ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-04 06:05:10 Duration: 8s403ms Database: rio User: intelifix Remote: [local] Application: psql
14 2s578ms 23s25ms 12s731ms 4 50s926ms 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 #14
Day Hour Count Duration Avg duration Jun 04 20 2 25s293ms 12s646ms 23 2 25s632ms 12s816ms [ User: intelifix - Total duration: 50s926ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 50s926ms - Times executed: 4 ]
-
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-06-04 23:38:36 Duration: 23s25ms 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-06-04 20:08:29 Duration: 22s715ms 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-06-04 23:40:30 Duration: 2s607ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 1s276ms 21s295ms 11s29ms 4 44s116ms 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 #15
Day Hour Count Duration Avg duration Jun 04 20 2 22s571ms 11s285ms 23 2 21s545ms 10s772ms [ User: intelifix - Total duration: 44s116ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 44s116ms - Times executed: 4 ]
-
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-06-04 20:04:00 Duration: 21s295ms 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-06-04 23:16:47 Duration: 20s221ms 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-06-04 23:39:51 Duration: 1s323ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 1s390ms 18s102ms 9s659ms 4 38s637ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 04 20 2 19s143ms 9s571ms 23 2 19s493ms 9s746ms [ User: intelifix - Total duration: 38s637ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 38s637ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-04 23:15:59 Duration: 18s102ms 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-06-04 20:03:09 Duration: 17s524ms 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-06-04 20:08:41 Duration: 1s618ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 1s627ms 17s516ms 9s533ms 4 38s132ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 04 20 2 19s318ms 9s659ms 23 2 18s813ms 9s406ms [ User: intelifix - Total duration: 38s132ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 38s132ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-04 20:02:39 Duration: 17s516ms 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-06-04 23:15:27 Duration: 17s186ms 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-06-04 20:08:39 Duration: 1s802ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 1s389ms 13s929ms 7s317ms 4 29s270ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 04 20 2 15s319ms 7s659ms 23 2 13s951ms 6s975ms [ User: intelifix - Total duration: 29s270ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 29s270ms - Times executed: 4 ]
-
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-06-04 20:03:23 Duration: 13s929ms 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-06-04 23:16:11 Duration: 12s541ms 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-06-04 23:39:48 Duration: 1s410ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 762ms 13s472ms 6s887ms 4 27s550ms 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 Jun 04 20 2 13s311ms 6s655ms 23 2 14s239ms 7s119ms [ User: intelifix - Total duration: 27s550ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 27s550ms - Times executed: 4 ]
-
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-06-04 23:15:41 Duration: 13s472ms 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-06-04 20:02:52 Duration: 12s549ms 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-06-04 23:39:45 Duration: 766ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 628ms 11s227ms 5s970ms 4 23s883ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 04 20 2 11s855ms 5s927ms 23 2 12s27ms 6s13ms [ User: intelifix - Total duration: 23s883ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 23s883ms - Times executed: 4 ]
-
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-06-04 20:03:38 Duration: 11s227ms 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-06-04 23:16:27 Duration: 11s208ms 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-06-04 23:39:49 Duration: 819ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 2 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 04 11 1 0ms 0ms 14 1 0ms 0ms [ User: intelifix - Total duration: 3s754ms - Times executed: 2 ]
[ Application: psql - Total duration: 3s754ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: contagem Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 2,997 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 422 FATAL entries
- 4 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 378 Max number of times the same event was reported
- 427 Total events found
Rank Times reported Error 1 378 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 04 00 17 01 14 02 14 03 14 04 14 05 19 06 16 07 15 08 18 09 16 10 17 11 17 12 16 13 17 14 17 15 17 16 16 17 16 18 17 19 16 20 18 21 18 22 18 23 1 - FATAL: database "brasilia" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "brasilia" does not exist
Date: 2026-06-04 00:02:05 Database: brasilia Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-04 00:02:05 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-04 00:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
2 37 FATAL: database "..." does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 04 07 1 08 3 09 3 10 2 11 2 12 3 13 2 14 2 15 2 16 3 17 3 18 3 19 3 20 2 21 2 22 1 - FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: 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(
- FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: 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(
- FATAL: database "jaboatao" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: 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-06-04 07:55:20 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-04 08:15:19 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-04 08:36:22 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 5 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 04 03 5 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-04 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-04 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-04 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local]
4 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 04 05 2 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-04 05:30:16 Database: contagem Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-04 05:30:16 Database: contagem Application: psql User: intelifix Remote: [local]
5 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 04 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-04 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-04 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
6 2 ERROR: could not connect to server "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 04 05 2 - ERROR: could not connect to server "Brasilia"
- ERROR: could not connect to server "Brasilia"
Detail: connection to server at "localhost" (127.0.0.1), port 9276 failed: FATAL: database "brasilia" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;Date: 2026-06-04 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
Detail: connection to server at "localhost" (127.0.0.1), port 9276 failed: FATAL: database "brasilia" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;Date: 2026-06-04 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
7 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 04 03 1 - LOG: database system was shut down at 2026-06-04 03:05:01 -03
Date: 2026-06-04 03:05:02