Query Resource¶

The Query REST service is the most complex of the rest services. It contains detailed information about nodes, and other details that capture the state and history of a query being executed on a Presto installation.

GET /v1/query()¶

This service returns information and statistics about queries that are currently being executed on a Presto coordinator.

When you point a web browser at a Presto coordinate you’ll see a rendered version of the output from this service which will display recent queries that have executed on a Presto installation.

GET /v1/query/{queryId}()¶

If you are looking to gather very detailed statistics about a query, this is the service you would call. If you load the web interface of a Presto coordinator you will see a list of current queries. Clicking on a query will reveal a link to this service.

Example response:

{
  "queryId" : "20131229_211533_00017_dk5x2",
  "session" : {
      "user" : "tobrien",
      "source" : "presto-cli",
      "catalog" : "jmx",
      "schema" : "jmx",
      "remoteUserAddress" : "173.15.79.89",
      "userAgent" : "StatementClient/0.55-SNAPSHOT",
      "startTime" : 1388351852026
  },
  "state" : "FINISHED",
  "self" : "http://10.193.207.128:8080/v1/query/20131229_211533_00017_dk5x2",
  "fieldNames" : [ "name" ],
  "query" : "select name from \"java.lang:type=runtime\"",
  "queryStats" : {
      "createTime" : "2013-12-29T16:17:32.027-05:00",
      "executionStartTime" : "2013-12-29T16:17:32.086-05:00",
      "lastHeartbeat" : "2013-12-29T16:17:44.561-05:00",
      "endTime" : "2013-12-29T16:17:32.152-05:00",
      "elapsedTime" : "125.00ms",
      "queuedTime" : "1.31ms",
      "analysisTime" : "4.84ms",
      "totalTasks" : 2,
      "runningTasks" : 0,
      "completedTasks" : 2,
      "totalDrivers" : 2,
      "queuedDrivers" : 0,
      "runningDrivers" : 0,
      "completedDrivers" : 2,
      "totalMemoryReservation" : "0B",
      "totalScheduledTime" : "5.84ms",
      "totalCpuTime" : "710.49us",
      "totalBlockedTime" : "27.38ms",
      "rawInputDataSize" : "27B",
      "rawInputPositions" : 1,
      "processedInputDataSize" : "32B",
      "processedInputPositions" : 1,
      "outputDataSize" : "32B",
      "outputPositions" : 1
  },
  "outputStage" : { }
}