Aurora DSQL - Simple Inserts Workload from an AWS CloudShell

postgres=> \d postgresqlkeyvalue

       Table "public.postgresqlkeyvalue"

 Column | Type | Collation | Nullable | Default 

--------+------+-----------+----------+---------

 k      | text |           | not null | 

 v      | text |           |          | 

Indexes:

    "postgresqlkeyvalue_pkey" PRIMARY KEY, btree_index (k) INCLUDE (v)



postgres=> \timing on

Timing is on.



postgres=> select;

--

(1 row)



Time: 70.224 ms



postgres=> select;

--

(1 row)



Time: 2.505 ms



postgres=> explain (analyze, costs off) 

 insert into postgresqlkeyvalue values (1e6*random(),0)

\watch



               Sun 08 Dec 2024 08:57:23 PM UTC (every 2s)



                               QUERY PLAN                               

------------------------------------------------------------------------

 Insert on postgresqlkeyvalue (actual time=0.034..0.034 rows=0 loops=1)

   ->  Result (actual time=0.003..0.004 rows=1 loops=1)

 Planning Time: 0.054 ms

 Execution Time: 1.687 ms

(4 rows)



Time: 23.914 ms

               Sun 08 Dec 2024 08:57:25 PM UTC (every 2s)



                               QUERY PLAN                               

------------------------------------------------------------------------

 Insert on postgresqlkeyvalue (actual time=0.035..0.035 rows=0 loops=1)

   ->  Result (actual time=0.003..0.004 rows=1 loops=1)

 Planning Time: 0.053 ms

 Execution Time: 0.962 ms

(4 rows)



Time: 22.328 ms

               Sun 08 Dec 2024 08:57:27 PM UTC (every 2s)



                               QUERY PLAN                               

------------------------------------------------------------------------

 Insert on postgresqlkeyvalue (actual time=0.034..0.035 rows=0 loops=1)

   ->  Result (actual time=0.004..0.004 rows=1 loops=1)

 Planning Time: 0.053 ms

 Execution Time: 0.993 ms

(4 rows)



Time: 28.290 ms