Show generated SQL and query plan

show_sql() displays the SQL query that will be dispatched to the database; explain() displays both the SQL query and the query plan.

Usage

# S3 method for class 'tbl_lazy'
show_query(x, ..., use_colour = TRUE, sql_options = NULL, cte = deprecated())

# S3 method for class 'tbl_sql'
explain(x, ...)

Arguments

x

An object to explain

...

For explain(), further arguments to remote_query_plan(). For show_query(), ignored.

use_colour

Should the output be coloured?

sql_options

SQL rendering options generated by sql_options().

cte

Use the sql_options argument instead.