pgBadger-
Global information
- Generated on Wed Jul 15 23:00:11 2026
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 94,605 log entries in 9s
- Log start from 2026-07-15 07:00:01 to 2026-07-15 22:00:00
-
Overview
Global Stats
- 2 Number of unique normalized queries
- 13 Number of queries
- 13s975ms Total query duration
- 2026-07-15 07:00:02 First query
- 2026-07-15 20:00:02 Last query
- 1 queries/s at 2026-07-15 18:00:02 Query peak
- 13s975ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 13s975ms Execute total duration
- 626 Number of events
- 8 Number of unique normalized events
- 597 Max number of times the same event was reported
- 0 Number of cancellation
- 77 Total number of automatic vacuums
- 103 Total number of automatic analyzes
- 1,080 Number temporary file
- 2.12 MiB Max size of temporary file
- 1.12 MiB Average size of temporary file
- 10,701 Total number of sessions
- 24 sessions at 2026-07-15 22:00:00 Session peak
- 2d23h33m8s Total duration of sessions
- 24s71ms Average duration of sessions
- 0 Average queries per session
- 1ms Average queries duration per session
- 24s70ms Average idle time per session
- 10,701 Total number of connections
- 10 connections/s at 2026-07-15 19:25:22 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-15 18:00:02 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-15 18:00:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 13s975ms 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) Jul 15 07 1 0ms 1s155ms 1s155ms 0ms 0ms 1s155ms 08 1 0ms 1s41ms 1s41ms 0ms 0ms 1s41ms 09 1 0ms 1s21ms 1s21ms 0ms 0ms 1s21ms 10 1 0ms 1s1ms 1s1ms 0ms 0ms 1s1ms 11 1 0ms 1s26ms 1s26ms 0ms 0ms 1s26ms 12 1 0ms 1s166ms 1s166ms 0ms 0ms 1s166ms 13 1 0ms 1s30ms 1s30ms 0ms 0ms 1s30ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 1 0ms 1s21ms 1s21ms 0ms 0ms 1s21ms 16 1 0ms 1s263ms 1s263ms 0ms 0ms 1s263ms 17 1 0ms 1s3ms 1s3ms 0ms 0ms 1s3ms 18 1 0ms 1s25ms 1s25ms 0ms 0ms 1s25ms 19 1 0ms 1s114ms 1s114ms 0ms 0ms 1s114ms 20 1 0ms 1s102ms 1s102ms 0ms 0ms 1s102ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 15 07 1 0 1s155ms 0ms 0ms 0ms 08 1 0 1s41ms 0ms 0ms 0ms 09 1 0 1s21ms 0ms 0ms 0ms 10 1 0 1s1ms 0ms 0ms 0ms 11 1 0 1s26ms 0ms 0ms 0ms 12 1 0 1s166ms 0ms 0ms 0ms 13 1 0 1s30ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 1 0 1s21ms 0ms 0ms 0ms 16 1 0 1s263ms 0ms 0ms 0ms 17 1 0 1s3ms 0ms 0ms 0ms 18 1 0 1s25ms 0ms 0ms 0ms 19 1 0 1s114ms 0ms 0ms 0ms 20 1 0 1s102ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 15 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 Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 15 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% Day Hour Count Average / Second Jul 15 07 709 0.20/s 08 717 0.20/s 09 713 0.20/s 10 713 0.20/s 11 713 0.20/s 12 713 0.20/s 13 713 0.20/s 14 713 0.20/s 15 713 0.20/s 16 713 0.20/s 17 713 0.20/s 18 713 0.20/s 19 713 0.20/s 20 713 0.20/s 21 713 0.20/s 22 6 0.00/s Day Hour Count Average Duration Average idle time Jul 15 07 715 25s559ms 25s557ms 08 717 24s691ms 24s690ms 09 713 23s906ms 23s905ms 10 713 23s907ms 23s905ms 11 713 23s907ms 23s905ms 12 713 22s646ms 22s644ms 13 713 25s170ms 25s168ms 14 713 21s383ms 21s383ms 15 713 26s432ms 26s431ms 16 713 23s909ms 23s907ms 17 713 22s646ms 22s645ms 18 713 23s909ms 23s908ms 19 713 22s647ms 22s646ms 20 713 25s172ms 25s171ms 21 713 25s172ms 25s172ms 22 0 0ms 0ms -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2026-07-15 19:25:22 Date
Connections per database
Key values
- etendo Main Database
- 10,701 connections Total
Connections per user
Key values
- postgres Main User
- 10,701 connections Total
-
Sessions
Simultaneous sessions
Key values
- 24 sessions Session Peak
- 2026-07-15 22:00:00 Date
Histogram of session times
Key values
- 10,425 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 10,701 sessions Total
Sessions per user
Key values
- postgres Main User
- 10,701 sessions Total
Sessions per host
Key values
- [local] Main Host
- 10,701 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 1,411 buffers Checkpoint Peak
- 2026-07-15 07:06:31 Date
- 140.929 seconds Highest write time
- 0.006 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-07-15 15:06:29 Date
Checkpoints distance
Key values
- 23.44 Mo Distance Peak
- 2026-07-15 07:06:31 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 15 07 1,709 169.15s 0.019s 169.206s 08 1,573 155.503s 0.019s 155.562s 09 1,574 156.09s 0.019s 156.147s 10 1,486 147.062s 0.017s 147.12s 11 1,538 152.692s 0.017s 152.748s 12 1,594 157.606s 0.018s 157.659s 13 1,568 155.302s 0.016s 155.359s 14 1,665 164.948s 0.017s 165.002s 15 1,568 155.418s 0.019s 155.475s 16 1,585 157.004s 0.016s 157.059s 17 1,598 158.209s 0.016s 158.266s 18 1,599 158.218s 0.016s 158.274s 19 1,584 156.615s 0.019s 156.663s 20 1,567 155.222s 0.017s 155.283s 21 1,555 153.898s 0.016s 153.954s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 15 07 0 1 0 272 0.002s 0.012s 08 0 1 0 270 0.002s 0.012s 09 0 1 0 265 0.001s 0.012s 10 0 1 0 262 0.002s 0.012s 11 0 0 0 259 0.001s 0.012s 12 0 1 0 272 0.001s 0.012s 13 0 1 0 268 0.002s 0.012s 14 0 1 0 271 0.002s 0.012s 15 0 1 0 262 0.005s 0.012s 16 0 0 0 261 0.002s 0.012s 17 0 1 0 272 0.002s 0.012s 18 0 1 0 272 0.002s 0.012s 19 0 1 0 272 0.002s 0.012s 20 0 1 0 263 0.002s 0.012s 21 0 0 0 261 0.001s 0.012s 22 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 15 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 Day Hour Mean distance Mean estimate Jul 15 07 1,156.83 kB 35,747.42 kB 08 1,055.75 kB 10,851.67 kB 09 1,080.00 kB 6,655.50 kB 10 1,022.67 kB 6,487.83 kB 11 1,063.25 kB 6,709.25 kB 12 1,095.42 kB 6,807.92 kB 13 1,072.58 kB 6,572.58 kB 14 1,140.00 kB 7,028.33 kB 15 1,068.33 kB 6,799.67 kB 16 1,081.08 kB 6,727.50 kB 17 1,095.08 kB 6,623.17 kB 18 1,099.50 kB 6,822.33 kB 19 1,087.25 kB 6,771.67 kB 20 1,068.17 kB 6,723.42 kB 21 1,061.75 kB 6,595.25 kB 22 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 6.75 MiB Temp Files size Peak
- 2026-07-15 19:05:00 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2026-07-15 19:05:00 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 15 07 66 74.22 MiB 1.12 MiB 08 72 80.96 MiB 1.12 MiB 09 72 80.96 MiB 1.12 MiB 10 72 80.96 MiB 1.12 MiB 11 72 80.96 MiB 1.12 MiB 12 72 80.96 MiB 1.12 MiB 13 72 80.96 MiB 1.12 MiB 14 72 80.96 MiB 1.12 MiB 15 72 80.96 MiB 1.12 MiB 16 72 80.96 MiB 1.12 MiB 17 72 80.96 MiB 1.12 MiB 18 72 80.96 MiB 1.12 MiB 19 72 80.96 MiB 1.12 MiB 20 72 80.96 MiB 1.12 MiB 21 72 80.96 MiB 1.12 MiB 22 6 6.75 MiB 1.12 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 1,080 1.19 GiB 127.74 KiB 2.12 MiB 1.12 MiB select ord.c_order_id from c_order ord left join c_orderline ol on ord.c_order_id = ol.c_order_id where ord.docstatus = ? and ol.qtyordered <= ol.qtydelivered and ord.issotrx = ? and ord.ad_client_id = ? and ord.c_order_id not in ( select ord.c_order_id from c_orderline ol left join c_order ord on ord.c_order_id = ol.c_order_id left join m_product mp on ol.m_product_id = mp.m_product_id where ol.qtydelivered >= ? and ol.qtyordered <> ? and ol.qtydelivered < ol.qtyordered) group by ord.c_order_id;-
SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;
Date: 2026-07-15 07:05:00 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
Queries generating the largest temporary files
Rank Size Query 1 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:05:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:05:00 ]
3 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:05:00 ]
4 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:10:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:10:00 ]
6 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:10:00 ]
7 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:15:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:15:00 ]
9 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:15:00 ]
10 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:20:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
11 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:20:00 ]
12 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:20:00 ]
13 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:25:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
14 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:25:00 ]
15 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:25:00 ]
16 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:30:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
17 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:30:00 ]
18 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:30:00 ]
19 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:35:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
20 2.12 MiB SELECT ord.c_order_id FROM c_order ord LEFT JOIN c_orderline ol ON ord.c_order_id = ol.c_order_id WHERE ord.docstatus = 'CO' AND ol.qtyordered <= ol.qtydelivered AND ord.issotrx = 'Y' and ord.ad_client_id = '6656FEC9897B4157903686173D963950' AND ord.c_order_id NOT IN ( SELECT ord.c_order_id FROM c_orderline ol LEFT JOIN c_order ord ON ord.c_order_id = ol.c_order_id LEFT JOIN m_product mp on ol.m_product_id = mp.m_product_id WHERE ol.qtydelivered >= 0 AND ol.qtyordered <> 0 AND ol.qtydelivered < ol.qtyordered) GROUP BY ord.c_order_id;[ Date: 2026-07-15 07:35:00 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.32 sec Highest CPU-cost vacuum
Table profile.sample_stat_tables
Database etendo - 2026-07-15 18:01:02 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 0.32 sec Highest CPU-cost vacuum
Table profile.sample_stat_tables
Database etendo - 2026-07-15 18:01:02 Date
Analyzes per table
Key values
- profile.last_stat_indexes_srv1 (15) Main table analyzed (database etendo)
- 103 analyzes Total
Table Number of analyzes etendo.profile.last_stat_indexes_srv1 15 etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.last_stat_tables_srv1 15 etendo.profile.last_stat_statements_srv1 15 etendo.public.ad_process_request 12 etendo.profile.tables_list 6 etendo.profile.stmt_list 4 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.last_extension_versions 4 etendo.profile.last_stat_slru 2 etendo.profile.indexes_list 2 etendo.profile.sample_stat_database 1 etendo.profile.sample_stat_slru 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.sample_stat_tables 1 etendo.profile.sample_stat_tables_total 1 etendo.profile.sample_stat_indexes 1 etendo.profile.sample_stat_user_functions 1 etendo.profile.sample_statements 1 etendo.public.advcrm2_configapp 1 Total 103 Vacuums per table
Key values
- profile.last_stat_user_functions_srv1 (15) Main table vacuumed on database etendo
- 77 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples etendo.profile.last_stat_user_functions_srv1 15 15 2,765 0 34 0 0 1,516 41 321,121 0 0 etendo.profile.last_stat_statements_srv1 15 15 4,143 0 59 0 43 2,175 69 470,607 0 0 etendo.profile.last_stat_indexes_srv1 15 15 19,856 0 352 0 0 14,526 361 2,280,178 0 0 etendo.profile.last_stat_tables_srv1 15 15 15,228 0 231 0 0 11,439 241 1,638,970 0 0 etendo.profile.tables_list 4 4 617 0 16 0 0 217 12 111,490 0 0 etendo.profile.stmt_list 3 3 470 0 16 0 0 172 7 63,099 0 0 etendo.profile.last_stat_activity_count_srv1 2 0 65 0 10 0 0 12 4 32,118 0 0 etendo.profile.indexes_list 2 2 256 0 8 0 0 35 4 35,385 0 0 etendo.profile.last_extension_versions 2 2 111 0 10 0 0 10 4 33,322 0 0 etendo.profile.sample_stat_indexes 1 1 397 0 252 0 0 286 27 102,551 0 0 etendo.profile.last_stat_database_srv1 1 1 61 0 6 0 0 6 3 20,174 0 0 etendo.profile.sample_stat_tables 1 1 1,312 0 1,136 0 0 1,276 87 218,351 0 0 etendo.profile.last_stat_slru 1 1 61 0 5 0 0 5 2 16,717 0 0 Total 77 75 45,342 2,411 2,135 0 43 31,675 862 5,344,083 0 0 Vacuum throughput per table
Key values
- profile.sample_stat_tables (0.32) Max CPU elapsed for vacuum on database etendo
- unknown (0 ms) Max I/O read time for vacuum on database etendo
- unknown (0 ms) Max I/O write time for vacuum on database etendo
I/O timing (ms) CPU (s) Table read write elapsed etendo.profile.last_stat_user_functions_srv1 0 0 0 etendo.profile.last_stat_statements_srv1 0 0 0 etendo.profile.last_stat_indexes_srv1 0 0 0.3 etendo.profile.last_stat_tables_srv1 0 0 0.15 etendo.profile.tables_list 0 0 0 etendo.profile.stmt_list 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.indexes_list 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.profile.sample_stat_indexes 0 0 0.07 etendo.profile.last_stat_database_srv1 0 0 0 etendo.profile.sample_stat_tables 0 0 0.32 etendo.profile.last_stat_slru 0 0 0 Total 0 0 0.84 Tuples removed per table
Key values
- profile.last_stat_indexes_srv1 (93370) Main table with removed tuples on database etendo
- 173701 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.profile.last_stat_indexes_srv1 15 15 93,370 46,080 0 0 5,580 etendo.profile.last_stat_tables_srv1 15 15 59,856 28,575 0 0 4,440 etendo.profile.last_stat_statements_srv1 15 15 9,039 5,908 0 63 649 etendo.profile.last_stat_user_functions_srv1 15 15 7,875 7,380 0 7 490 etendo.profile.sample_stat_tables 1 1 2,156 29,894 0 0 1,058 etendo.profile.sample_stat_indexes 1 1 706 13,574 0 0 224 etendo.profile.tables_list 4 4 337 2,450 0 0 72 etendo.profile.last_extension_versions 2 2 112 16 0 0 2 etendo.profile.stmt_list 3 3 88 806 0 0 63 etendo.profile.indexes_list 2 2 58 298 0 0 10 etendo.profile.last_stat_slru 1 1 52 4 0 0 1 etendo.profile.last_stat_activity_count_srv1 2 0 48 0 0 2 0 etendo.profile.last_stat_database_srv1 1 1 4 4 0 0 1 Total 77 75 173,701 134,989 0 72 12,590 Pages removed per table
Key values
- profile.last_stat_statements_srv1 (63) Main table with removed pages on database etendo
- 72 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.profile.last_stat_statements_srv1 15 15 9039 63 etendo.profile.last_stat_user_functions_srv1 15 15 7875 7 etendo.profile.last_stat_activity_count_srv1 2 0 48 2 etendo.profile.sample_stat_indexes 1 1 706 0 etendo.profile.indexes_list 2 2 58 0 etendo.profile.last_stat_indexes_srv1 15 15 93370 0 etendo.profile.tables_list 4 4 337 0 etendo.profile.last_stat_database_srv1 1 1 4 0 etendo.profile.sample_stat_tables 1 1 2156 0 etendo.profile.last_stat_slru 1 1 52 0 etendo.profile.stmt_list 3 3 88 0 etendo.profile.last_stat_tables_srv1 15 15 59856 0 etendo.profile.last_extension_versions 2 2 112 0 Total 77 75 173,701 72 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 15 07 5 8 08 6 5 09 4 7 10 4 5 11 5 6 12 6 7 13 5 7 14 5 9 15 4 7 16 5 6 17 6 9 18 7 5 19 7 8 20 4 7 21 4 7 22 0 0 - 0.32 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
- 13 Total read queries
- 0 Total write queries
Queries by database
Key values
- etendo Main database
- 13 Requests
- 13s975ms (etendo)
- Main time consuming database
Queries by user
Key values
- postgres Main user
- 13 Requests
User Request type Count Duration postgres Total 13 13s975ms select 13 13s975ms Duration by user
Key values
- 13s975ms (postgres) Main time consuming user
User Request type Count Duration postgres Total 13 13s975ms select 13 13s975ms Queries by host
Key values
- [local] Main host
- 13 Requests
- 13s975ms ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 13 Requests
- 13s975ms (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-15 20:04:08 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 13 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1s263ms SELECT profile.take_sample ();[ Date: 2026-07-15 16:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
2 1s166ms SELECT profile.take_sample ();[ Date: 2026-07-15 12:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
3 1s155ms SELECT profile.take_sample ();[ Date: 2026-07-15 07:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
4 1s114ms SELECT profile.take_sample ();[ Date: 2026-07-15 19:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
5 1s102ms SELECT profile.take_sample ();[ Date: 2026-07-15 20:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
6 1s41ms SELECT profile.take_sample ();[ Date: 2026-07-15 08:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
7 1s30ms SELECT profile.take_sample ();[ Date: 2026-07-15 13:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
8 1s26ms SELECT profile.take_sample ();[ Date: 2026-07-15 11:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
9 1s25ms SELECT profile.take_sample ();[ Date: 2026-07-15 18:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
10 1s21ms SELECT profile.take_sample ();[ Date: 2026-07-15 09:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
11 1s21ms SELECT profile.take_sample ();[ Date: 2026-07-15 15:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
12 1s3ms SELECT profile.take_sample ();[ Date: 2026-07-15 17:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
13 1s1ms SELECT profile.take_sample ();[ Date: 2026-07-15 10:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 13s975ms 13 1s1ms 1s263ms 1s75ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 15 07 1 1s155ms 1s155ms 08 1 1s41ms 1s41ms 09 1 1s21ms 1s21ms 10 1 1s1ms 1s1ms 11 1 1s26ms 1s26ms 12 1 1s166ms 1s166ms 13 1 1s30ms 1s30ms 15 1 1s21ms 1s21ms 16 1 1s263ms 1s263ms 17 1 1s3ms 1s3ms 18 1 1s25ms 1s25ms 19 1 1s114ms 1s114ms 20 1 1s102ms 1s102ms [ User: postgres - Total duration: 13s975ms - Times executed: 13 ]
[ Application: psql - Total duration: 13s975ms - Times executed: 13 ]
-
SELECT profile.take_sample ();
Date: 2026-07-15 16:00:02 Duration: 1s263ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-15 12:00:02 Duration: 1s166ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-15 07:00:02 Duration: 1s155ms Database: etendo User: postgres Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 13 13s975ms 1s1ms 1s263ms 1s75ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 15 07 1 1s155ms 1s155ms 08 1 1s41ms 1s41ms 09 1 1s21ms 1s21ms 10 1 1s1ms 1s1ms 11 1 1s26ms 1s26ms 12 1 1s166ms 1s166ms 13 1 1s30ms 1s30ms 15 1 1s21ms 1s21ms 16 1 1s263ms 1s263ms 17 1 1s3ms 1s3ms 18 1 1s25ms 1s25ms 19 1 1s114ms 1s114ms 20 1 1s102ms 1s102ms [ User: postgres - Total duration: 13s975ms - Times executed: 13 ]
[ Application: psql - Total duration: 13s975ms - Times executed: 13 ]
-
SELECT profile.take_sample ();
Date: 2026-07-15 16:00:02 Duration: 1s263ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-15 12:00:02 Duration: 1s166ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-15 07:00:02 Duration: 1s155ms Database: etendo User: postgres Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1s1ms 1s263ms 1s75ms 13 13s975ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 15 07 1 1s155ms 1s155ms 08 1 1s41ms 1s41ms 09 1 1s21ms 1s21ms 10 1 1s1ms 1s1ms 11 1 1s26ms 1s26ms 12 1 1s166ms 1s166ms 13 1 1s30ms 1s30ms 15 1 1s21ms 1s21ms 16 1 1s263ms 1s263ms 17 1 1s3ms 1s3ms 18 1 1s25ms 1s25ms 19 1 1s114ms 1s114ms 20 1 1s102ms 1s102ms [ User: postgres - Total duration: 13s975ms - Times executed: 13 ]
[ Application: psql - Total duration: 13s975ms - Times executed: 13 ]
-
SELECT profile.take_sample ();
Date: 2026-07-15 16:00:02 Duration: 1s263ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-15 12:00:02 Duration: 1s166ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-15 07:00:02 Duration: 1s155ms Database: etendo User: postgres Remote: [local] Application: psql
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 NO DATASET
-
Events
Log levels
Key values
- 46,872 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 626 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 597 Max number of times the same event was reported
- 626 Total events found
Rank Times reported Error 1 597 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 15 07 42 08 42 09 40 10 40 11 39 12 39 13 41 14 39 15 41 16 39 17 40 18 39 19 40 20 39 21 37 - FATAL: no pg_hba.conf entry for host "186.236.254.56", user "postgres", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "159.65.148.75", user "admin", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "186.236.254.56", user "postgres", database "postgres", no encryption
Date: 2026-07-15 07:01:58 Database: postgres Application: [unknown] User: postgres Remote: 186.236.254.56
Date: 2026-07-15 07:02:28 Database: postgres Application: [unknown] User: admin Remote: 159.65.148.75
Date: 2026-07-15 07:05:11 Database: postgres Application: [unknown] User: postgres Remote: 186.236.254.56
2 16 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL encryption
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 15 11 1 12 14 15 1 - FATAL: no pg_hba.conf entry for host "64.89.163.137", user "postgres", database "postgres", SSL encryption
- FATAL: no pg_hba.conf entry for host "213.209.159.66", user "postgres", database "postgres", SSL encryption
- FATAL: no pg_hba.conf entry for host "213.209.159.66", user "postgres", database "postgres", SSL encryption
Date: 2026-07-15 11:06:23 Database: postgres Application: [unknown] User: postgres Remote: 64.89.163.137
Date: 2026-07-15 12:26:17 Database: postgres Application: [unknown] User: postgres Remote: 213.209.159.66
Date: 2026-07-15 12:27:53 Database: postgres Application: [unknown] User: postgres Remote: 213.209.159.66
3 3 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 15 09 1 12 1 18 1 - FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Date: 2026-07-15 09:56:02 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.186.185
Date: 2026-07-15 12:22:20 Database: [unknown] Application: [unknown] User: [unknown] Remote: 213.209.159.66
Date: 2026-07-15 18:37:32 Database: [unknown] Application: [unknown] User: [unknown] Remote: 64.62.156.172
4 3 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 15 09 1 12 1 18 1 - FATAL: no PostgreSQL user name specified in startup packet
- FATAL: no PostgreSQL user name specified in startup packet
- FATAL: no PostgreSQL user name specified in startup packet
Date: 2026-07-15 09:56:06 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.186.185
Date: 2026-07-15 12:22:20 Database: [unknown] Application: [unknown] User: [unknown] Remote: 213.209.159.66
Date: 2026-07-15 18:37:32 Database: [unknown] Application: [unknown] User: [unknown] Remote: 64.62.156.172
5 3 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 15 09 1 12 1 18 1 - FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Date: 2026-07-15 09:56:03 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.186.185
Date: 2026-07-15 12:22:20 Database: [unknown] Application: [unknown] User: [unknown] Remote: 213.209.159.66
Date: 2026-07-15 18:37:32 Database: [unknown] Application: [unknown] User: [unknown] Remote: 64.62.156.172
6 2 FATAL: unsupported frontend protocol 2.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 15 19 2 - FATAL: unsupported frontend protocol 2.0: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 2.0: server supports 3.0 to 3.0
Date: 2026-07-15 19:35:33 Database: [unknown] Application: [unknown] User: [unknown] Remote: 152.32.134.182
Date: 2026-07-15 19:35:34 Database: [unknown] Application: [unknown] User: [unknown] Remote: 152.32.134.182
7 1 FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 15 13 1 - FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Date: 2026-07-15 13:35:58 Database: [unknown] Application: [unknown] User: [unknown] Remote: 45.56.79.53
8 1 FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 15 14 1 - FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Date: 2026-07-15 14:42:10 Database: [unknown] Application: [unknown] User: [unknown] Remote: 20.106.196.31