Investigate slow query

[jcoyne]

In sul-requests we run this query and it takes about 30 seconds in the folio-dev environment:

         query InstanceByHrid {
            instances(hrid: "L284") {
              id
              title
              identifiers {
                value
                identifierTypeObject {
                  name
                }
              }
              instanceType {
                name
              }
              contributors {
                name
                primary
              }
              publication {
                dateOfPublication
              }
              electronicAccess {
                materialsSpecification
                uri
              }
              items {
                barcode
                status {
                  name
                }
                dueDate
                materialType {
                  id
                  name
                }
                chronology
                enumeration
                effectiveCallNumberComponents {
                  callNumber
                }
                notes {
                  note
                  itemNoteType {
                    name
                  }
                }
                effectiveLocation {
                  id
                  campusId
                  libraryId
                  institutionId
                  code
                  discoveryDisplayName
                  name
                  servicePoints {
                    id
                    code
                    pickupLocation
                  }
                  library {
                    id
                    code
                  }
                  campus {
                    id
                    code
                  }
                  details {
                    pageAeonSite
                    pageMediationGroupKey
                    pageServicePoints {
                      id
                      code
                      name
                    }
                    scanServicePointCode
                    availabilityClass
                  }
                }
                permanentLocation {
                  id
                  code
                  details {
                    pagingSchedule
                  }
                }
                permanentLoanTypeId
                temporaryLoanTypeId
                holdingsRecord {
                  effectiveLocation {
                    code
                  }
                }
              }
            }
          }

Which parts are particularly slow? Is there any way to optimize?

This was originally part of sul-dlss/sul-requests#1676

[jcoyne]

It's dueDate that's taking about 15s
holdingRecords are good for another 4s.
effectiveLocation is another 5s.
permanentLocation is another 3s.