postgres-continuous-discovery source produces duplicate outputs

[kmoppel]

Seems some unnecessary duplication going on, as in the below case the "public.pgbench_accounts_ts_hash" table only exists in the "postgres" database in reality

pwatch output:

$ curl -s localhost:9188/ | grep pgbench_accounts_ts_hash | grep n_live
pgwatch_table_stats_n_live_tup{dbname="test1_bench",schema="public",table_full_name="public.pgbench_accounts_ts_hash",table_name="pgbench_accounts_ts_hash",table_size_cardinality_mb="0"} 0 1728115109486
pgwatch_table_stats_n_live_tup{dbname="test1_pgwatch2_metrics",schema="public",table_full_name="public.pgbench_accounts_ts_hash",table_name="pgbench_accounts_ts_hash",table_size_cardinality_mb="0"} 0 1728115109480
pgwatch_table_stats_n_live_tup{dbname="test1_postgres",schema="public",table_full_name="public.pgbench_accounts_ts_hash",table_name="pgbench_accounts_ts_hash",table_size_cardinality_mb="0"} 0 1728115109474

pgwatch2 output in same mode:

$ curl -s localhost:9187/ | grep pgbench_accounts_ts_hash | grep n_live
pgwatch2_table_stats_n_live_tup{dbname="adhoc_postgres",schema="public",table_full_name="public.pgbench_accounts_ts_hash",table_name="pgbench_accounts_ts_hash",table_size_cardinality_mb="0"} 0 1728115333370

[pashagolub]

Thanks Kaarel! I found the problem. It's not prometheus related but resolver related