Reply To: Confusing question about Amazon Redshift

[to22]

I agree with Ryan that the answer is not correct.

See https://docs.aws.amazon.com/redshift/latest/dg/r_PG_TABLE_DEF.html :

A query that references only catalog tables (tables with a PG prefix, such as PG_TABLE_DEF) or that does not reference any tables, runs exclusively on the leader node.

So it does not make sense that PG_TABLE_DEF resides on compute nodes as stated in the answer currently marked as correct.