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:

1. { 2. "queryId" : "20131229_211533_00017_dk5x2", 3. "session" : { 4. "user" : "tobrien", 5. "source" : "presto-cli", 6. "catalog" : "jmx", 7. "schema" : "jmx", 8. "remoteUserAddress" : "173.15.79.89", 9. "userAgent" : "StatementClient/0.55-SNAPSHOT", 10. "startTime" : 1388351852026 11. }, 12. "state" : "FINISHED", 13. "self" : "http://10.193.207.128:8080/v1/query/20131229_211533_00017_dk5x2", 14. "fieldNames" : [ "name" ], 15. "query" : "select name from \"java.lang:type=runtime\"", 16. "queryStats" : { 17. "createTime" : "2013-12-29T16:17:32.027-05:00", 18. "executionStartTime" : "2013-12-29T16:17:32.086-05:00", 19. "lastHeartbeat" : "2013-12-29T16:17:44.561-05:00", 20. "endTime" : "2013-12-29T16:17:32.152-05:00", 21. "elapsedTime" : "125.00ms", 22. "queuedTime" : "1.31ms", 23. "analysisTime" : "4.84ms", 24. "totalTasks" : 2, 25. "runningTasks" : 0, 26. "completedTasks" : 2, 27. "totalDrivers" : 2, 28. "queuedDrivers" : 0, 29. "runningDrivers" : 0, 30. "completedDrivers" : 2, 31. "totalMemoryReservation" : "0B", 32. "totalScheduledTime" : "5.84ms", 33. "totalCpuTime" : "710.49us", 34. "totalBlockedTime" : "27.38ms", 35. "rawInputDataSize" : "27B", 36. "rawInputPositions" : 1, 37. "processedInputDataSize" : "32B", 38. "processedInputPositions" : 1, 39. "outputDataSize" : "32B", 40. "outputPositions" : 1 41. }, 42. "outputStage" : ... 43. }