<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Dynatrace Workflows: &amp;quot;Auto-fetch execution plans&amp;quot; Workflow is Not Fetching Execution Plans in Automations</title>
    <link>https://community.dynatrace.com/t5/Automations/Dynatrace-Workflows-quot-Auto-fetch-execution-plans-quot/m-p/292515#M2465</link>
    <description>&lt;P&gt;&lt;FONT color="#000000"&gt;&lt;STRONG&gt;Description:&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;We recently added Dynatrace's ready-made&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;A href="https://docs.dynatrace.com/docs/observe/infrastructure-observability/databases/database-app#auto-fetch-workflow" target="_blank" rel="noopener noreferrer"&gt;Auto-fetch execution plans workflow&lt;/A&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;to our&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Dynatrace Workflows&lt;/STRONG&gt;.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;However, even though it's executing as expected, when in the&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Databases&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;app, I'm not seeing any new&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Execution plans&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;marked as&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Available&lt;/STRONG&gt;.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;&lt;STRONG&gt;Note: The only Execution Plans marked as Available are the ones I fetched manually.&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;I thought the whole point to adding this Workflow was so we didn't have to manually Fetch Execution Plans?&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;&lt;STRONG&gt;Technologies:&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;This is related to the Execution Plan function in the&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Databases&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;app, where we are currently and primarily monitoring our primary RDS PostgreSQL instances.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;&lt;STRONG&gt;Troubleshooting steps already tried:&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;Confirmed the affected TEST database meets all the&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;A href="https://docs.dynatrace.com/docs/shortlink/postgresdb-remote-monitoring-extension#requirements" target="_blank" rel="noopener noreferrer"&gt;requirements&lt;/A&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;listed here. Auto-fetching doesn't work, but manually fetching&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Execution Plans&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;does.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;&lt;STRONG&gt;Steps for Reproduction:&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;Visiting the&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Databases&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;app, you can clearly see no&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Execution Plans&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;are marked as&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Available&lt;/STRONG&gt;.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;&lt;STRONG&gt;Impacted environments:&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;At the moment, only our TEST databases are affected. We have not created the&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;dynatrace&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;schema needed for&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Execution Plans&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;(as mentioned in the&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;A href="https://docs.dynatrace.com/docs/shortlink/postgresdb-remote-monitoring-extension#requirements" target="_blank" rel="noopener noreferrer"&gt;requirements&lt;/A&gt;) on any of our PROD databases. We want to confirm functionality on a TEST database before deploying this to PROD.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;Could someone help us confirm that this ready-made Workflow is actually working properly?&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;If it's not working as expected, we will need to disable it, as&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Workflows&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;cost us money.&lt;/FONT&gt;&lt;/P&gt;</description>
    <pubDate>Wed, 07 Jan 2026 07:53:50 GMT</pubDate>
    <dc:creator>ASE</dc:creator>
    <dc:date>2026-01-07T07:53:50Z</dc:date>
    <item>
      <title>Dynatrace Workflows: "Auto-fetch execution plans" Workflow is Not Fetching Execution Plans</title>
      <link>https://community.dynatrace.com/t5/Automations/Dynatrace-Workflows-quot-Auto-fetch-execution-plans-quot/m-p/292515#M2465</link>
      <description>&lt;P&gt;&lt;FONT color="#000000"&gt;&lt;STRONG&gt;Description:&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;We recently added Dynatrace's ready-made&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;A href="https://docs.dynatrace.com/docs/observe/infrastructure-observability/databases/database-app#auto-fetch-workflow" target="_blank" rel="noopener noreferrer"&gt;Auto-fetch execution plans workflow&lt;/A&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;to our&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Dynatrace Workflows&lt;/STRONG&gt;.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;However, even though it's executing as expected, when in the&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Databases&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;app, I'm not seeing any new&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Execution plans&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;marked as&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Available&lt;/STRONG&gt;.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;&lt;STRONG&gt;Note: The only Execution Plans marked as Available are the ones I fetched manually.&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;I thought the whole point to adding this Workflow was so we didn't have to manually Fetch Execution Plans?&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;&lt;STRONG&gt;Technologies:&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;This is related to the Execution Plan function in the&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Databases&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;app, where we are currently and primarily monitoring our primary RDS PostgreSQL instances.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;&lt;STRONG&gt;Troubleshooting steps already tried:&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;Confirmed the affected TEST database meets all the&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;A href="https://docs.dynatrace.com/docs/shortlink/postgresdb-remote-monitoring-extension#requirements" target="_blank" rel="noopener noreferrer"&gt;requirements&lt;/A&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;listed here. Auto-fetching doesn't work, but manually fetching&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Execution Plans&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;does.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;&lt;STRONG&gt;Steps for Reproduction:&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;Visiting the&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Databases&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;app, you can clearly see no&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Execution Plans&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;are marked as&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Available&lt;/STRONG&gt;.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;&lt;STRONG&gt;Impacted environments:&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;At the moment, only our TEST databases are affected. We have not created the&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;dynatrace&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;schema needed for&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Execution Plans&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;(as mentioned in the&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;A href="https://docs.dynatrace.com/docs/shortlink/postgresdb-remote-monitoring-extension#requirements" target="_blank" rel="noopener noreferrer"&gt;requirements&lt;/A&gt;) on any of our PROD databases. We want to confirm functionality on a TEST database before deploying this to PROD.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;Could someone help us confirm that this ready-made Workflow is actually working properly?&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;If it's not working as expected, we will need to disable it, as&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Workflows&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;cost us money.&lt;/FONT&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 07 Jan 2026 07:53:50 GMT</pubDate>
      <guid>https://community.dynatrace.com/t5/Automations/Dynatrace-Workflows-quot-Auto-fetch-execution-plans-quot/m-p/292515#M2465</guid>
      <dc:creator>ASE</dc:creator>
      <dc:date>2026-01-07T07:53:50Z</dc:date>
    </item>
    <item>
      <title>Re: Dynatrace Workflows: "Auto-fetch execution plans" Workflow is Not Fetching Execution Plans</title>
      <link>https://community.dynatrace.com/t5/Automations/Dynatrace-Workflows-quot-Auto-fetch-execution-plans-quot/m-p/292516#M2466</link>
      <description>&lt;DIV&gt;&lt;FONT color="#000000"&gt;Another thing I just noticed is that the queries retrieved from the logs (when using the DQL query below) do not match the queries displayed in the&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Statement Performance&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;tab.&lt;/FONT&gt;&lt;/DIV&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV&gt;&lt;FONT color="#000000"&gt;Even when sorted by&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;Total Execution Time&lt;/STRONG&gt;, they do not match.&lt;/FONT&gt;&lt;/DIV&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV&gt;&lt;FONT color="#000000"&gt;&lt;STRONG&gt;fetch logs&lt;BR /&gt;| filter&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;A href="http://dt.extension.name/" target="_blank" rel="noopener noreferrer"&gt;dt.extension.name&lt;/A&gt;=="com.dynatrace.extension.postgres" and event.group=="top_queries"&lt;BR /&gt;| sort total_exec_time desc&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/DIV&gt;</description>
      <pubDate>Tue, 06 Jan 2026 23:14:18 GMT</pubDate>
      <guid>https://community.dynatrace.com/t5/Automations/Dynatrace-Workflows-quot-Auto-fetch-execution-plans-quot/m-p/292516#M2466</guid>
      <dc:creator>ASE</dc:creator>
      <dc:date>2026-01-06T23:14:18Z</dc:date>
    </item>
  </channel>
</rss>

