Is there any way to get a query plan from Pinot, s...
# generalj
Joey Pereira
08/19/2020, 6:25 PMIs there any way to get a query plan from Pinot, such as indexes used to pull data, or is this something that you can only really interpret from the query response stats on the Controller's query console?
Joey Pereira
08/19/2020, 6:25 PMCouldn't find anything searching by key words like "query plan" or "explain" on the docs, so I'm assuming no?
k
Kishore G
08/19/2020, 6:26 PM
we removed explain, it was not very useful
Kishore G
08/19/2020, 6:27 PM
stats were more useful
Kishore G
08/19/2020, 6:27 PM
there is a trace feature
Kishore G
08/19/2020, 6:27 PM
that will be dump a lot of details but its more for dev's
k
Kenny Bastani
08/19/2020, 7:39 PMI'm working on a blog post that explains how to debug a query using the execution statistics. @Joey Pereira, are you wanting to optimize query performance (segments, indexes, etc)?
j
Joey Pereira
08/19/2020, 7:48 PMYep!
k
Kenny Bastani
08/19/2020, 8:47 PMI’ll expedite work on that. We can help you for the meantime if you are looking to optimize a query. LMK
j
Joey Pereira
08/21/2020, 4:19 PMOOC, @Kenny Bastani were you going to touch on the details of specific execution statistics?
Was just trying to understand them a bit when comparing two different table setups and found the public docs are pretty sparse on specifics.
k
Kenny Bastani
08/21/2020, 4:23 PMMy goal is to start with the high level interpretation of each stat and how it relates to the trade offs for indexing.