Data-Wrappers

Foreign Data Wrappers

Valerie Parham-Thompson
Ansible, Automation, Distributed-Systems, Postgres, Queries, Rdbms, Yugabytedb

I was recently setting up a demo to show off query logging features. Two common extensions, pg_stat_statements and pg_stat_monitor, store data locally. In the case of a distributed database, it is helpful to combine the query runtimes on all nodes.

YugabyteDB supports foreign data wrappers, so I decided to use this feature to combine query statistics from each of my three test nodes.

The libraries for the pg_stat_monitor extension are already installed, so the extension just needs to be created: