DISCARD(7)

🌸 DISCARD 🌸

okay bestie, welcome to the DISCARD(7) page from the PostgreSQL 16.15 docs ✨ this one is literally all about hitting reset on your database session state, and it is giving “clean slate” energy 💅

---

🎀 NAME 🎀

DISCARD — discard session state 🫶

🦋 SYNOPSIS 🦋

DISCARD { ALL | PLANS | SEQUENCES | TEMPORARY | TEMP }

💖 DESCRIPTION 💖

So DISCARD releases internal resources associated with a database session. Iconic, honestly. This command is useful for partially or fully resetting the session’s state ✨

There are several subcommands to release different types of resources; the DISCARD ALL variant subsumes all the others, and also resets additional state. Basically ALL is the main character here 👑

🌈 PARAMETERS 🌈

• PLANS — releases all cached query plans, forcing re-planning to occur the next time the associated prepared statement is used. The planner is gonna have to think again, no cap 🧠
• SEQUENCES — discards all cached sequence-related state, including currval()/lastval() information and any preallocated sequence values that have not yet been returned by nextval(). (See CREATE SEQUENCE (CREATE_SEQUENCE(7)) for a description of preallocated sequence values.) 🎀
• TEMPORARY or TEMP — drops all temporary tables created in the current session. Bye-bye temp tables, you had a good run 💀
• ALL — releases all temporary resources associated with the current session and resets the session to its initial state. Currently, this has the same effect as executing the following sequence of statements 👇

CLOSE ALL;
SET SESSION AUTHORIZATION DEFAULT;
RESET ALL;
DEALLOCATE ALL;
UNLISTEN *;
SELECT pg_advisory_unlock_all();
DISCARD PLANS;
DISCARD TEMP;
DISCARD SEQUENCES;

⭐ NOTES ⭐

DISCARD ALL cannot be executed inside a transaction block. fr fr, do not try to sneak it in there 🙈

💜 COMPATIBILITY 💜

DISCARD is a PostgreSQL extension. iykyk 🌸

---

signing off from the PostgreSQL 16.15 docs, 2026 edition — stay clean, stay reset, bestie 💖✨🎀