PostgreSQL Performance Test - Longhorn Storage

Storage Configuration: This PostgreSQL instance uses Longhorn distributed storage with 3 replicas across the K3s cluster for high availability and data redundancy.
Database: appdb
User: appuser
Host: postgresql.database.svc.cluster.local
Connected: ✓ Yes

Database Connection

✓ Success
1.32 ms
Connected successfully at Wed Dec 24 2025 20:57:59 GMT+0000 (Coordinated Universal Time)

Single INSERT

✓ Success
10.86 ms
Inserted row ID: 17373

Batch INSERT (100 rows)

✓ Success
92.51 ms
Inserted 100 rows in transaction (0.93 ms/row)

SELECT COUNT(*)

✓ Success
3.78 ms
Total rows in table: 17473

Indexed SELECT (recent rows)

✓ Success
1.92 ms
Retrieved 10 rows

UPDATE Query

✓ Success
8.49 ms
Updated 1 row(s)

Concurrent Queries (10 simultaneous)

✓ Success
465.84 ms
Executed 10 queries concurrently (avg 46.58 ms/query)