DROP_STATISTICS(7pg15)

💅 DROP_STATISTICS 💅

Hey bestie, welcome to the DROP_STATISTICS page — that's the one from the PostgreSQL 15.19 Documentation, and yes she's short and sweet. Sit down, hydrate, and let's remove some extended statistics together 🫶

---

🌸 NAME 🌸

DROP_STATISTICS — remove extended statistics ✨

---

🦋 SYNOPSIS 🦋

DROP STATISTICS [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

---

💖 DESCRIPTION 💖

So DROP STATISTICS removes statistics object(s) from the database. That's it, that's the whole vibe. It's giving clean slate 🎀

But okay, gatekeeping time: only the statistics object's owner, the schema owner, or a superuser can drop a statistics object. So if you're not one of those, no cap, it's not happening 💀

---

✨ PARAMETERS ✨

• IF EXISTS — do not throw an error if the statistics object does not exist. A notice is issued in this case. Basically "if she's not there, don't make it weird" 🙈
• name — the name (optionally schema-qualified) of the statistics object to drop. Yes you can qualify it, go off 👑
• CASCADE, RESTRICT — these key words do not have any effect, since there are no dependencies on statistics. Literally they're just standing there, existing, contributing nothing 💀 (they're in the synopsis though, so we keep them, iykyk)

---

🔥 EXAMPLES 🔥

To destroy two statistics objects in different schemas, without failing if they don't exist:

DROP STATISTICS IF EXISTS
    accounting.users_uid_creation,
    public.grants_user_role;

Two different schemas, one command, zero drama. We love a multi-schema moment 🌈

---

💀 COMPATIBILITY 💀

There is no DROP STATISTICS command in the SQL standard. Periodt. She's a PostgreSQL original 💅

---

👑 SEE ALSO 👑

• ALTER STATISTICS (ALTER_STATISTICS(7))
• CREATE STATISTICS (CREATE_STATISTICS(7))

---

And that's the whole page, bestie — you ate that 🍓

Friendly reminder of the whole plot: DROP STATISTICS removes extended statistics, and only the owner, schema owner, or superuser can do it.

⭐ Sign-off time ⭐ — this little gem is from PostgreSQL 15.19, dated 2026, and it's the DROP STATISTICS(7) page. Bye, love you, go drop some stats responsibly 🧚💜