From: | Ilya Gladyshev <i(dot)gladyshev(at)postgrespro(dot)ru> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Per query FDW network stat collection |
Date: | 2021-08-24 09:12:38 |
Message-ID: | 5a845ea7-4614-9de4-c366-56752c91dbea@postgrespro.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello,
I have implemented per query network stat collection for FDW. It is done
in a similar way to how buffer and WAL stats are collected and it can be
seen with a new NETWORK option for explain command:
explain (analyze, network) insert into itrtest values (2, 'blah');
QUERY PLAN
-----------------------------------------------------------------------------------------------
Insert on itrtest (cost=0.00..0.01 rows=0 width=0) (actual
time=0.544..0.544 rows=0 loops=1)
Network: FDW bytes sent=197 received=72, wait_time=0.689
-> Result (cost=0.00..0.01 rows=1 width=36) (actual
time=0.003..0.003 rows=1 loops=1)
Planning Time: 0.025 ms
Execution Time: 0.701 ms
(5 rows)
I am yet to add corresponding columns to pg_stat_statements, write tests
and documentation, but before I go ahead with that, I would like to know
what the community thinks about the patch.
Regards,
Ilya Gladyshev
Attachment | Content-Type | Size |
---|---|---|
0001-adds-per-query-FDW-network-usage-stats.patch | text/x-patch | 29.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2021-08-24 09:13:44 | remove internal support in pgcrypto? |
Previous Message | Shruthi Gowda | 2021-08-24 09:10:04 | Re: preserving db/ts/relfilenode OIDs across pg_upgrade (was Re: storing an explicit nonce) |