I am using nextjs 13 and the postgresql provided by vercel, I have created a few routes, here's an example of one of them: get-testcase.ts import { NextApiRequest, NextApiResponse } from 'next'; import { sql } from '@vercel/postgres'; export default…
I'm facing a performance issue with a complex SQL query in PostgreSQL and seeking your expertise to help optimize it. The query involves multiple tables and joins and seems to be taking longer to execute than expected. I believe there…
I am facing problem while reading data from a Postgres database and inserting into Elastic search using Nest library in an ASP.NET Core console application. My approach: Get total rows from RedShift. Make query of ~100,000 against RedShift. Again divided…
I'm trying to view slow queries in my Postgres log, but it's filled with errors like: 2023-07-26 07:40:47.460 UTC [3446461] odoo@postgres FATAL: password authentication failed for user "odoo" 2023-07-26 07:40:47.460 UTC [3446461] odoo@postgres DETAIL: Role "odoo" does not exist. Connection…
Using Postgresql and Spring. The Backend gets User Input from the frontend which is called "filter". I want the database "contacts" to be checked in multiple columns: @Query("SELECT c FROM Contacts c " + "WHERE LOWER(CAST(c.supplierNo AS string)) LIKE %:filter%…
I have a table with a text column that holds millions of text documents of various lengths (from a couple of kb to some mb). There are many duplicates. I would like to create a table with a unique md5…
Column A Column B Column C Column D A B C A D A A B C A D A This is the table for instance. We are supposed to find the number of occurrences of A in the entire…
I have a table master_data_approval_table in my postgres DB having field approval_value (type Jsonb) which contains below structure: We want only those records where each object of jsonb array strictly matches the given condition "status": "Approved" Expected O/P: I tried…
We have this large table in our Postgres DB, let's call it DataTable with a decent amount of read/write operations. There currently exists a unique constraint on this table that I would like to get rid of and instead replace…
I am trying to retrieve data from public.users tables and this the query I am using but I am not able to retrieve, what i actually require: WITH duplicates AS ( SELECT email, COUNT(*) AS duplicate_count FROM public.users GROUP BY…