I have the following code to pull records from a daterange in PostgreSQL, it works as intended. The "end date" is determined by the "date" column from the last record, and the "start date" is calculated by subtracting a 7-day…
I have a query which is taking 2.5 seconds to run. On checking the query plan, I got to know that postgres is heavily underestimating the number of rows leading to nested loops. Following is the query explain analyze SELECT…
Imagine the following data: I am interested in returning the entries where there is a gap in the data for a particular student, where the category changes from one year to another, or both. So the output that I'm after…
How can i modify join to get rid of JOIN AND (... OR ...) conditions? select table1.id, table1.country, table1.city, table1.platform, sum(table2.installs) as installs from schema.table1 inner join schema.table2 on table1.id = table2.id and ( table1.country = table2.country or table1.country is…
I have a one to many relation with Postgres. The primary key entity LUT is dependent on its child entities. I am looking for a way to cascade changes in the foreign key entities to the primary entity and update…
In Postgres I have a dataset of events, I'd like to count number of the event and profit for them having same ticker and same filter_name which occurred within time range, for example in the last 3 hours. id ticker…
I have a table of people transferring between positions: id new_position old_position 1 A B 2 C B 3 B D And so on, for several hundred rows. I want to make a query that will return each position with…
I'm computing some percentile sales data grouped by product / US state, and the query is extremely slow for a large list of locations (see "dma" in [long list of locations]). The table is around ~15 million rows. SELECT 'us_state'…
For example, i have a table with the data: Screenshot This table named "table". I have the SQL query: select kind, count(kind) from table where region = 'eng' group by kind And I get the result: Question: how do I…
I have a one to many relationship mapping table in postgres and the tables are as below: Students id Name 1 Shibbir 2 Ahmed 3 John Courses id Name 1 Data Structure 2 Algorithms 3 Math student_course_mapping studentId courseId 1…