Hi, I'm using a foreign data wrapper to access mongodb and I'm looking for a way to monitor query stats against foreign tables.
It looks like the common methods have limited support for foreign tables at this time. pg_stat_statements collects the query, total time, and rows returned, which is useful. But all the disk access stats are zero (understandably). Looks like pg_stat_all_tables doesn't have any info on foreign tables from my tests. I'm interested in the following: - Foreign table rows read - Foreign table bytes read - Foreign table read time I'm working with my own fork of the FDW, so I could build these in myself, but I was wondering if there's more generic support for this sort of stuff. Or at the least, if I do implement it can I push it into another stats collection framework rather than logging it. Thanks, David Crawford
