Uploaded image for project: 'Cost Management'
  1. Cost Management
  2. COST-5473

Clean up 2020 partitions from our prod db

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Won't Do
    • Icon: Minor Minor
    • None
    • None
    • Data Pipeline
    • 1
    • False
    • None
    • False

      We have some very old partitions in our prod db, tho they don't seem to contain any records. Seen these for a few schemas across AWS and Azure.

      Here's the query to check for partitions on a table and example results:

       

      select inhrelid::regclass as child from pg_catalog.pg_inherits where inhparent = 'acct6193296.reporting_awscostentrylineitem_daily_summary'::regclass;
 
["acct6193296.reporting_awscostentrylineitem_daily_summary_2020_09"], ["acct6193296.reporting_awscostentrylineitem_daily_summary_2020_08"], ["acct6193296.reporting_awscostentrylineitem_daily_summary_2020_07"],
 
["acct6193296.reporting_azurecostentrylineitem_daily_summary_2020_09"], ["acct6193296.reporting_azurecostentrylineitem_daily_summary_2020_08"], ["acct6193296.reporting_azurecostentrylineitem_daily_summary_2020_07"],

       

              Unassigned Unassigned
              rh-ee-dnakabaa David Nakabaale
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: