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, cte = FALSE, sql_options = NULL)

# 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?

cte

Use the sql_options argument instead.

sql_options

SQL rendering options generated by sql_options().