DBLINK_IS_BUSY(3)

💅 DBLINK_IS_BUSY(3)

okay so bestie, this is a page straight out of the PostgreSQL 16.15 Documentation and it's literally the manual entry for dblink_is_busy — yes, the whole manual name is DBLINK_IS_BUSY(3), we're being formal today ✨

🌸 NAME

dblink_is_busy — checks if connection is busy with an async query 🫶

✨ SYNOPSIS

dblink_is_busy(text connname) returns int

🦋 DESCRIPTION

so dblink_is_busy tests whether an async query is in progress. that's it, that's the whole vibe check 🔥 it's the "u up? are you still working on that" of functions, no cap.

🎀 ARGUMENTS

• connname — Name of the connection to check. literally just tell her which connection you're side-eyeing 🙈

👑 RETURN VALUE

Returns 1 if connection is busy, 0 if it is not busy. If this function returns 0, it is guaranteed that dblink_get_result will not block. that second part is the iconic bit — a 0 is your hall pass to call dblink_get_result and know it won't make you sit there waiting 😭👑

⭐ EXAMPLES

SELECT dblink_is_busy('dtest1');

run it, get your answer, move on. slay 💅

and that's the page, bestie 🎀 this one came from the PostgreSQL 16.15 documentation and it's dated 2026, so you know it's fresh ✨ go check on your connections, they miss you 🫶💖