I want to subract additional time in $__timeFilter in grafana. Like if I have selected Last 7 days, I want to run 2 queries which do a comparison like one query gives me avg cpu utilization for last 7 days…
I want to write an SELECT statement using Supabase-JS library, where it would return all rows whose associated_campaigns (array of UUIDs) column is either null or doesn't contain input string. I'm trying with something like this, where campaign_id is input…
I have a requirement where in, the controller class receives a list as a request param. This list can contain a range of values, which is salary column in the table. ex: {500-10000 , 10000-12000, 12000-14000..} using this range of…
Using PostgreSQL 9.6, I'm trying to insert rows into a table map, generated from another table tbl. tbl name in1 in2 a 1 b 2 {3} c 4 {5,6} d 7 {8,9,10} Should result in this: map name out1 out2…
I do a lot of looking at user behavior and want an easy way to order by the first event in a group of events per user. i.e. User1 | Event1 User1 | Event2 User1 | Event3 User2 | Event1…
I have PostgreSQL 14 server running on Windows 10. I have read here that the default value for the shared_buffer parameter is low and increasing it can improve performance for some jobs. However, it appears that the shared_buffer parameter cannot…
I have the following table "sales" date revenue 2022-06-01(Week 1) 100 2022-06-08(week 2) 200 2022-05-01(week 1) 800 2022-05-08(week 2) 900 and I want to compare sales current week vs the same week last month and get the following result: date…
I am having the following issue. I have a table like the following that holds all the exchange rates per day for all currencies (as base currency is Euro): id rates_values rate_date 1 {"AED":2.835349,"AFN":67.743417,... 1-1-2022 2 {"AED":2.485349,"AFN":66.843814, 2-2-2022 The column…
The official doc states that: One advantage of the separate-column approach over an expression index is that ... Another advantage is that searches will be faster, since it will not be necessary to redo the to_tsvector calls to verify index…
I have a table where I store some info about events. My table have columns: id, created_at(which is date field), key(which is varchar255), quantity(which is integer) and event(which is varchar255). I'm making query to take all keys which exists on…