Uploaded image for project: 'Hippo CMS'
  1. Hippo CMS
  2. CMS-15393

For Query Diagnostics, besides the query statement also log the query limit and offset

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Normal
    • Resolution: Fixed
    • None
    • 15.2.3
    • None
    • None
    • Quasar
    • Quasar Sprint 308
    • Undetermined
    • Small (1-2)

    Description

      Currently we see in diagnostics logging something like:

      `- HstComponentInvokerProfiler (3991ms): {method=doBeforeRender, window=content, component=org.hippoecm.hst.component.support.bean.dynamic.DocumentQueryDynamicComponent, ref=r2_r1, HippoBeanIterationCount=121}
                 `- query (3981ms): {statement=//element(*,foo)[constraint] order by fn:lower-case(@hippostdpubwf:publicationDate) descending}
      

      but we do not see the 'limit' or 'offset' for the query which is executed, which is important information of the query. We need to add this info

      Attachments

        Activity

          People

            aschrijvers Ard Schrijvers
            aschrijvers Ard Schrijvers
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: