DBLINK_IS_BUSY(3)

✨ NAME ✨

okay so bestie, this is the DBLINK_IS_BUSY(3) manual page 💖 and dblink_is_busy checks if a connection is busy with an async query. that's the whole vibe check. no cap.

🌸 SYNOPSIS 🌸

dblink_is_busy(text connname) returns int

🦋 DESCRIPTION 🦋

dblink_is_busy tests whether an async query is in progress. periodt. like, it's giving “is this connection occupied with async query business right now?” energy, and that is literally the whole function. 💅

🎀 ARGUMENTS 🎀

• connname — the name of the connection to check. yep, you hand it the connection's name and it does the look. 🫶

⭐ RETURN VALUE ⭐

Returns 1 if the connection is busy, and 0 if it is not busy. If this function returns 0, it is guaranteed that dblink_get_result will not block. that's the important bit, bestie — zero means no blocking from dblink_get_result, fr fr. 😭

💜 EXAMPLES 💜

like, the classic:

SELECT dblink_is_busy('dtest1');

slay, that's the example. ✨

cute little sign-off: this page comes from PostgreSQL 17.11, dated 2026, and the manual you're reading is DBLINK_IS_BUSY(3). mwah 💋