0

On Amazon Aurora in the PostgreSQL (10) flavor there is a function names aurora_replica_status() documented. I can use the function and look at its definition:

postgres=> select * from aurora_replica_status();
-[ RECORD 1 ]----------------------+-----------------------
server_id                          | test
session_id                         | MASTER_SESSION_ID
durable_lsn                        | 48018742
...
postgres=> \sf aurora_replica_status
CREATE OR REPLACE FUNCTION pg_catalog.aurora_replica_status(OUT server_id ...
read_ios bigint, OUT iops bigint, OUT cpu real)
  RETURNS SETOF record
  LANGUAGE internal
  PARALLEL RESTRICTED ROWS 1
AS $function$ro_replica_status$function$

So naturally I wanted to see what other Aurora functions (for example with \dfS+ aur*) or views exist, however I could not find any (not even the aurora_replica_status). Is there a query I can try?

postgres=> select proname from pg_proc where proname like '%aurora%';
proname
---------
(0 Zeilen)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.