inst/QueryLibrary/Aggregate/system/query_plan.md
In sib-swiss/dsQueryLibraryServer: OMOP query Library
query_plan
Description
This query returns the execution plan of any given query after optionally setting a given parameter to a given value. The variables set.parameter.statement (optionally) and query.sql must be set as options in the R session before execution.
Query
explain analyze @~query.sql~@;
sib-swiss/dsQueryLibraryServer documentation built on Feb. 13, 2025, 8:07 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
query_plan
Description
This query returns the execution plan of any given query after optionally setting a given parameter to a given value. The variables set.parameter.statement (optionally) and query.sql must be set as options in the R session before execution.
Query
explain analyze @~query.sql~@;
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.