Where's the webhook logs

I've a db webhook set up on a table on insert, lately I noticed it doesn't call my api, and I wonder why, is there anyway to troubleshoot this? perhaps I can find anything in logs?

garyaustin•10/14/25, 11:49 PM

Webhooks are a postgres trigger function (postgres log if error) and a pg_net call. The net schema has two tables one of which is the actual call and the other is the http_reponse from your network request.

Ggaryaustin Webhooks are a postgres trigger function (postgres log if error) and a pg_net ca...

appimageOP•10/14/25, 11:55 PM

_http_response
and
http_request_queue
?

the first has only a very few rows, the other is empty. I don't see any errors in the postgres log. I'm using the raw feature of Supabase Webhooks though I am aware that it is a trigger and pg_net under the hood. it has so far worked fine but only lately stopped unexpectedly, I thought it was my api, but my api is working when tested separately, and when a new row is inserted everything works in the db, except the db webhook isn't firing I believe.

garyaustin•10/14/25, 11:57 PM

If you don't have entries in the request_queue and made very recent webhook calls then the trigger is not firing most likely.

garyaustin•10/14/25, 11:57 PM

The response is kept around longer and might show errors, but they would usually be response errors from the api.

garyaustin•10/14/25, 11:59 PM

If you do something that should generate a webhook call and go look at the request_queue table and don't see anything then your trigger is likely not firing OR erroring. But if erroring then should be in the Postgres log.

Ggaryaustin If you don't have entries in the request_queue and made very recent webhook call...

appimageOP•10/15/25, 12:00 AM

I'm really surprised because it does work sometimes, and when it works I can see that my api has been called in my own api logs, but then sometimes my api isn't getting called. which made me suspect that the problem lies in the supabase webhook

garyaustin•10/15/25, 12:01 AM

As I said it is just a trigger that calls pg_net though. So one of those two parts would not be working. Trigger is all postgres so not likely a bug. pg_net does have alot more going on...
https://github.com/orgs/supabase/discussions/21023

GitHub

Webhook debugging guide · supabase · Discussion #21023

This is a copy of a troubleshooting article on Supabase's docs site. It may be missing some details from the original. View the original article. NOTE: version 0.10.0 of pg*net is out. You shou...

garyaustin•10/15/25, 12:03 AM

Did you set up the webhook with the UI or "code" your own trigger?

Ggaryaustin The response is kept around longer and might show errors, but they would usually...

appimageOP•10/15/25, 12:03 AM

how long does data stay in http_request_queue

when it worked once, I was watching the table but I didn't see any record.

Ggaryaustin Did you set up the webhook with the UI or "code" your own trigger?

appimageOP•10/15/25, 12:03 AM

garyaustin•10/15/25, 12:04 AM

Sorry, I don't know off the top of my head. It would be documented somewhere in the supabase/pg_net github. But it is not minutes I don't believe.

appimageOP•10/15/25, 12:05 AM

that's fine I'll keep trying, and debug, I hope I'll be able to find a solution

garyaustin•10/15/25, 12:05 AM

OK that table is gone as soon as pg_net runs the request....

garyaustin•10/15/25, 12:06 AM

So it has a "loop" that checks that table, pulls off stuff to do then would delete the rows.

appimageOP•10/15/25, 12:06 AM

it has been working great for such a long time. I'm using supabase for almost two years, just lately started experiencing this particular issue

garyaustin•10/15/25, 12:06 AM

How fast are you hitting the table with changes?

Ggaryaustin How fast are you hitting the table with changes?

appimageOP•10/15/25, 12:07 AM

do you mean how fast does the table get new records?

garyaustin•10/15/25, 12:07 AM

If that is what your webhook is on (inserts).

appimageOP•10/15/25, 12:07 AM

yes

appimageOP•10/15/25, 12:07 AM

so, not very fast

appimageOP•10/15/25, 12:07 AM

one new record every few minutes

garyaustin•10/15/25, 12:08 AM

Then not sure. That is one thing that can be overwhelmed and there is a setting for that in pg_net (not sure about webhooks) but it is requests per second type thing.

appimageOP•10/15/25, 12:09 AM

on the same table I've triggers that also do make use of pg_net and they work always

garyaustin•10/15/25, 12:09 AM

Could your API not be responding in time for any reason?

Ggaryaustin Could your API not be responding in time for any reason?

appimageOP•10/15/25, 12:10 AM

I don't believe that is the reason, since my api gets in fact called from another trigger on the same table.

garyaustin•10/15/25, 12:10 AM

So you have multiple insert triggers both running pg_net very close together?

garyaustin•10/15/25, 12:11 AM

Then why are you using the webhook versus just your triggers?

Ggaryaustin So you have multiple insert triggers both running pg_net very close together?

appimageOP•10/15/25, 12:11 AM

one I setup myself, calls a different endpoint, than the one the webhook calls

garyaustin•10/15/25, 12:11 AM

Not that I know of a reason that would not work.

Ggaryaustin Then why are you using the webhook versus just your triggers?

appimageOP•10/15/25, 12:11 AM

I've a notify endpoint, which it was really easy to use with the webhook, the other endpoint I had to use a trigger because there's some logic that goes inside the trigger

garyaustin•10/15/25, 12:12 AM

It should look like trigger1 pg_net return, trigger2 pg_net return and pg_net would not know the difference.

garyaustin•10/15/25, 12:13 AM

What are your timeouts set for in your code versus the webhook?

garyaustin•10/15/25, 12:13 AM

garyaustin•10/15/25, 12:14 AM

The trouble shooting link I gave is likely not much use if another pg_net call is working at same time.

garyaustin•10/15/25, 12:14 AM

Any errors in the http_response table rows?

Ggaryaustin What are your timeouts set for in your code versus the webhook?

appimageOP•10/15/25, 12:15 AM

this is in the code for my first trigger (the one I setup manually) which is working.

Ggaryaustin Any errors in the http_response table rows?

appimageOP•10/15/25, 12:15 AM

there aren't any.

Ggaryaustin Click to see attachment

appimageOP•10/15/25, 12:16 AM

garyaustin•10/15/25, 12:16 AM

You might increase that.
I think default pg_net is 5000.

garyaustin•10/15/25, 12:17 AM

Which is what your other trigger is running.

garyaustin•10/15/25, 12:17 AM

That says your API has 1 sec from the time the request leaves Supabase to respond back to Supabase including latency.

appimageOP•10/15/25, 12:18 AM

I don't think I've manually changed it to 1000, is it possible that it was the default in the UI a while back?

garyaustin•10/15/25, 12:18 AM

No idea what the default was.
Let me see what it is now.

Ggaryaustin That says your API has 1 sec from the time the request leaves Supabase to respon...

appimageOP•10/15/25, 12:18 AM

oh. I'll try increasing that for sure then

garyaustin•10/15/25, 12:19 AM

It is 5000 now.

garyaustin•10/15/25, 12:19 AM

I think that would fit your issue. If you were right on the edge and things slowed down a bit.

appimageOP•10/15/25, 12:20 AM

You're right. I'm seeing that it now hitting my api versus before it only hit once at such random times.

garyaustin•10/15/25, 12:20 AM

I would think though some rows in response table would have error, but more detail than I've ever looked into.

Aappimage You're right. I'm seeing that it now hitting my api versus before it only hit on...

appimageOP•10/15/25, 12:20 AM

when I changed that to 5000

appimageOP•10/15/25, 12:23 AM

I'm not seeing errors in the tables we talked about nor in the other logs of supabase. But that it now works hopefully it will continue to work, only time would tell

Where's the webhook logs

Similar Threads

Similar Threads

Similar Threads