Upgrade to Pro — share decks privately, control downloads, hide ads and more …

DatadogでAPI毎のSQL発行数を可視化してN+1を改善した話

Nealle
May 29, 2024

 DatadogでAPI毎のSQL発行数を可視化してN+1を改善した話

2024-05-29
Japan Datadog User Group Meetup#4
https://datadog-jp.connpass.com/event/317091/

Nealle

May 29, 2024
Tweet

More Decks by Nealle

Other Decks in Programming

Transcript

  1.  ࢯ໊ ॴଐ ܦྺ ٶޙܒհʗ,FJTVLF.JZBVTIJSP גࣜձࣾχʔϦʔ ϓϩμΫτຊ෦ϓϥοτϑΥʔϜάϧʔϓ43&νʔϜ ʢגࣜձࣾ೔ཱιϦϡʔγϣϯζʣ ɹۀ຿γεςϜͷ։ൃ ʢϠϑʔגࣜձࣾʣ

    ɹ48"5ͱͯ͠ϠϑʔϝʔϧͳͲෳ਺αʔϏεͷ։ൃ 
 ɹͦͷޙɺ1BZ1BZϑϦϚͷ43&νʔϜϦʔμʔ OPXʢגࣜձࣾχʔϦʔʣ ɹ1BSL%JSFDUͷ43&νʔϜ ʛࣗݾ঺հ !NJZBLFJ
  2.  EBUBEPHBHFOUίϯςφ • ؀ڥม਺ ◦ %%@05-1@$0/'*(@3&$&*7&3@13050$0-4@)551@&/%10*/5 ▪ 05&-͔ΒͷϝτϦΫεసૹΛड͚෇͚ΔΤϯυϙΠϯτ ◦ %%@05-1@$0/'*(@.&53*$4@3&4063$&@"553*#65&4@"4@5"(4USVF

    ▪ &$4ͷϦιʔε৘ใΛଐੑʹ௥Ճ͢Δઃఆ • 1PSU.BQQJOH ◦ IPTU1PSU DPOUBJOFS1PSU QSPUPDPMUDQ ▪ "QQMJDBUJPOˠEBUBEPHBHFOUίϯςφؒͰ௨৴Ͱ͖ΔΑ͏ʹ։์ "QQMJDBUJPOίϯςφઃఆ • ؀ڥม਺ ◦ 05&-@&91035&3@05-1@&/%10*/5IUUQMPDBMIPTU ▪ 0QFO5FMFNFUSZ4%,ͷϝτϦΫεసૹઌ ʛܭଌͷ͘͠ΈEBUBEPHBHFOU΁ͷసૹ෦෼