Try API hooks, maybe? You could set up a function to intercept datastore queries and log them to memcache, the app log, or back into the datastore itself.
http://code.google.com/appengine/articles/hooks.html On Oct 7, 3:34 pm, Tim Jones <[email protected]> wrote: > Thanks for the suggestion. I've already been keeping a close watch on my > app's indexes file, and was hoping for something that would reveal more > detail. > > It's true that a verbose query log isn't as important on GAE as it is on a > relational db. Still, I bet it would be real useful for finding redundant or > repeated queries, or just for getting a better understanding of how GAE works > under the hood. > > Maybe I'll try to hack one together... > > =T= > > On Oct 6, 2010, at 11:12 PM, Grant wrote: > > > > > Hi > > > I do not think there is a query log, but you can use the fact that the > > datastore only every queries an index to simulate one... > > >http://code.google.com/appengine/docs/python/datastore/queriesandinde... > > > There is an implicit index on all (actually most) properties on any > > entity and those indexes are used when you query a single property on > > an entity e.g. [FROM person WHERE age = 18] > > > To do a more complex query e.g. [FROM person WHERE country_code = 'ZA' > > AND age > 18] you need an explicit index for that query. > > > These explicit indexes are automatically generated when you make a > > request on the local dev server... > >http://code.google.com/appengine/docs/python/config/indexconfig.html#... > > (python) > >http://code.google.com/appengine/docs/java/config/indexconfig.html#Us... > > (java) > > > If you clear out your indexes file on a dev machine and then hit the > > URL you are interested in it will automatically generate any indexes > > required for that request. The contents of the index file would then > > act as a rudimentary query log especially when taken next to your > > Appstats from your production instance. > > > Grant > > > On Oct 7, 12:22 am, Tim Jones <[email protected]> wrote: > >> I'm somewhat new to App Engine, and attempting to streamline my app's > >> datastore load. > > >> With a LAMP app, I'm usually able to access or generate a database query > >> log to assist in this process -- a list of all queries run on the database > >> for a given http request, along with how long each took and other helpful > >> metadata. > > >> Is there a good way to access or create something similar for App Engine > >> queries? The closest I've found is Appstats -- but while Appstats will > >> provide information sorted by http-request, I haven't found a way to make > >> it display a database query log. > > >> Any help would be appreciated. Thanks, > > >> =Tim= > > > -- > > You received this message because you are subscribed to the Google Groups > > "Google App Engine" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group > > athttp://groups.google.com/group/google-appengine?hl=en.- Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
