R/explain.r

Defines functions explain explain.tbl_sql show_query

Documented in explain show_query

#' Explain details of a tbl.
#'
#' This is a generic function which gives more details about an object than
#' \code{\link{print}}, and is more focussed on human readable output than
#' \code{\link{str}}.
#'
#' @section Databases:
#' Explaining a \code{tbl_sql} will run the SQL \code{EXPLAIN} command which
#' will describe the query plan. This requires a little bit of knowledge about
#' how \code{EXPLAIN} works for your database, but is very useful for
#' diagnosing performance problems.
#'
#' @export
#' @param x An object to explain
#' @param ... Other parameters possibly used by generic
#' @examples
#' \donttest{
#' if (require("RSQLite") && has_lahman("sqlite")) {
#'
#' lahman_s <- lahman_sqlite()
#' batting <- tbl(lahman_s, "Batting")
#' batting %>% show_query()
#' batting %>% explain()
#'
#' # The batting database has indices on all ID variables:
#' # SQLite automatically picks the most restrictive index
#' batting %>% filter(lgID == "NL" & yearID == 2000L) %>% explain()
#'
#' # OR's will use multiple indexes
#' batting %>% filter(lgID == "NL" | yearID == 2000) %>% explain()
#'
#' # Joins will use indexes in both tables
#' teams <- tbl(lahman_s, "Teams")
#' batting %>% left_join(teams, c("yearID", "teamID")) %>% explain()
#' }
#' }
explain <- function(x, ...) {
  UseMethod("explain")
}

#' @export
explain.tbl_sql <- function(x, ...) {
  force(x)
  show_query(x)
  message("\n")
  message("<PLAN>\n", db_explain(x$src$con, sql_render(x)))

  invisible(NULL)
}

#' @export
#' @rdname explain
show_query <- function(x) {
  message("<SQL>\n", sql_render(x))
}
sctyner/dplyr050 documentation built on May 17, 2019, 2:22 p.m.