YugabyteDB Distributed UDF Execution Plans Revealed
YugabyteDB optimizes UDFs by distributing work between query layer & storage servers, reducing remote calls & time spent on filtering & indexing.
In the previous post about "truly distributed UDF" I displayed some execution plans to show how YugabyteDB distributes User Defined Functions (UDF) for reads (Remote Filter) and writes (Function Based Indexes for point queries on the function). I didn't realize that the latest version I was running the demo on (YugabyteDB 2.17) has already the dist option of explain analyze to show the remove calls between the query layer (YSQL - the PostgreSQL based backend) and the storage server (DocDB - the distributed storage and transaction). Without push-down If I disable Expression Push-Down,...