DROP_STATISTICS(7pg14)

💅 DROP STATISTICS 💅

okay so bestie, welcome to the DROP STATISTICS page — that's the 7pg14 manual, straight out of the PostgreSQL 14.24 docs. yes, we're doing extended statistics today. it's giving cleanup era ✨

---

🌸 NAME 🌸

DROP_STATISTICS — remove extended statistics 🧹💖

---

✨ SYNOPSIS ✨

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

like look at her. she's so simple. she's so clean. no cap 🎀

---

🦋 DESCRIPTION 🦋

DROP STATISTICS removes statistics object(s) from the database. that's it, that's the whole vibe — you point at your statistics objects and they're gone 💨

but okay, permission check, because of course: 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 three, bestie, this is not your main character moment 😭

---

💜 PARAMETERS 💜

• IF EXISTS — do not throw an error if the statistics object does not exist. instead a notice is issued in this case. so like, no drama, no screaming, just a lil heads up 🫶
• name — the name of the statistics object to drop, optionally schema-qualified. yes you can do the schema.thing thing, slay ✨
• CASCADE / RESTRICT — okay so these key words literally do not have any effect, since there are no dependencies on statistics. iconic of them to be there anyway tbh. they're just vibing 💀

---

🔥 EXAMPLES 🔥

the assignment: destroy two statistics objects in different schemas, without failing if they don't exist. and she ate:

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

see how we used IF EXISTS? that's the "no crying if it's not there" energy 🎀

---

🌈 COMPATIBILITY 🌈

there is no DROP STATISTICS command in the SQL standard. so like, this is a PostgreSQL exclusive. iykyk 👑

---

⭐ SEE ALSO ⭐

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

go read those too, bestie, they're the prequel and the sequel fr fr 🦋

---

lowkey a warning for you: only the owner, the schema owner, or a superuser can drop these — don't come for me if it errors, you were warned 💅

---

kisses and clean schemas, bestie 💖 this has been the DROP STATISTICS(7) page from PostgreSQL 14.24 Documentation, dated 2026. periodt. 🎀✨