Asking this question for a colleague who ran into this behaviour with PostgreSQL. Hoping somebody out there can solve this puzzle for us. The following logs Rows updated: 3 when run: drop table if exists test; create table test (str…
I demonstrate the issue with the following simple table. (The actual table and JSON document have a lot more fields.) CREATE table contact ( id bigint PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR, lastname VARCHAR, birthday timestamp with…
I'm building a language learning platform, here are some tables: create table users ( id bigserial primary key, ... ) create table users_languages ( id bigserial primary key, user_id bigint not null constraint users_languages_user_id_foreign references users, level varchar(255) not null,…
I am using PostgreSQL 15 and have the following two statements in PL/pgSQL: -- Statement 1 SELECT to_json(T) FROM (SELECT * FROM category WHERE category.id = 43) T) -- Statement 2 SELECT json_build_object('products', JSON_AGG(T)) FROM (SELECT * FROM product WHERE…
I have a new database with only about 225 rows. I was facing a slow query issue only on the postgres running in production on my Ubuntu server. It was reporting 423.460 ms for the execution time. The postgres on…