On 4/15/23 10:53, Joe Conway wrote:
On 4/15/23 07:04, André Rodrigues wrote:
Hello
I have just started in the new challenger as dba postgres and I am in
charge of enhancing our postgres monitoring( dashboards and alarms )
using Grafana.
Could you list me relevant metrics in postgres that I
Hi,
On 11/14/19 1:04 PM, Tom Lane wrote:
As of v12, that WITH will get flattened, so that you still end up
with three invocations of jsonb_path_query_first, as EXPLAIN VERBOSE
will show you. You could write "WITH foo AS MATERIALIZED ..." to
prevent that, but then you'll need to stick the WHERE
Hi,
We have a table which has a jsonb column in it. Each row contains a lot
of data in that column, so TOASTed.
We have to extract data from that column at different levels, so an
example query could look like
select
col1,
col2,
jsonb_path_query_first(data,'$.lvl1.lvl2.lvl3.lvl4.lvl5.v
