itsmefox

@Interaction
class PingCommand : DiscordCommand("ping", "Send a ping command") {

    override fun execute(event: SlashCommandInteractionEvent) {
        //Reply to the user
        val startTime = System.currentTimeMillis()
        event.reply("Ping ...").setEphemeral(true).queue {
            it.editOriginal("Pong: ${System.currentTimeMillis() - startTime}ms").queue()
        }
    }

itsmefox

@Component
class BotReadyListener : ApplicationListener<DiscordFirstShardReadyEvent> {

    override fun onApplicationEvent(event: DiscordFirstShardReadyEvent) {
        //Set the status of the bot as soon as possible
        event.shardManager.setPresence(OnlineStatus.ONLINE, Activity.playing("I'm Ready"))
    }

}

itsmefox

--- PSQL queries which also duplicated from https://github.com/anvk/AwesomePSQLList/blob/master/README.md
--- some of them taken from https://www.slideshare.net/alexeylesovsky/deep-dive-into-postgresql-statistics-54594192

-- I'm not an expert in PSQL. Just a developer who is trying to accumulate useful stat queries which could potentially explain problems in your Postgres DB.

------------
-- Basics --
------------

-- Get indexes of tables