sushantrmishra

Based on the OOM killer prints: - RSS is much higher for Postgres backends. Does top command output captured before the OOM happened ? @shantanugupta-yb

Can you please collect output of the following commands for PostgreSQL backends. - Select yb_mem_usage_kb() - Select yb_mem_usage_sql_kb() If possible then attach gdb to a backend and dump the memory...

> We could implement a metrics to push this data to prometheus to track the cumulative count of queries terminated due to temp_file_limit breached. Currently we do not plan to...

``` yugabyte=# \d warehouse Table "public.warehouse" Column | Type | Collation | Nullable | Default ------------+-----------------------+-----------+----------+--------- w_id | integer | | not null | w_ytd | numeric(12,2) | | not...

``` yugabyte=# select count(*) from warehouse where w_zip is null; count ------- 0 (1 row) ``` Though there are rows retrieved with NULL clause ``` yugabyte=# select * from warehouse...

``` yugabyte=# explain (analyze) select * from warehouse where w_zip is null; QUERY PLAN ------------------------------------------------------------------------------------------------------------ Seq Scan on warehouse (cost=0.00..100.00 rows=1000 width=296) (actual time=2.946..3.117 rows=334 loops=1) Remote Filter: (w_zip IS...

``` yugabyte=# explain (analyze, dist) select * from warehouse where w_zip is null; QUERY PLAN ------------------------------------------------------------------------------------------------------------ Seq Scan on warehouse (cost=0.00..100.00 rows=1000 width=296) (actual time=3.087..3.254 rows=334 loops=1) Remote Filter: (w_zip...

with count(*) 334 are obsolete keys and without there are no obsolete keys. ``` Metric docdb_obsolete_keys_found: 334.000 Metric docdb_obsolete_keys_found_past_cutoff: 334.000 ``` ``` yugabyte=# explain (analyze, dist, debug) select * from...

Possibly duplicate of https://github.com/yugabyte/yugabyte-db/issues/18192

Duplicate of https://github.com/yugabyte/yugabyte-db/issues/18192