add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
SELECT 0
CREATE FUNCTION
CREATE TRIGGER
QUERY PLAN
Insert on source_table (actual time=1.118..1.118 rows=0 loops=1)
  -> ProjectSet (actual time=0.004..0.119 rows=1000 loops=1)
        -> Result (actual time=0.001..0.001 rows=1 loops=1)
Planning Time: 0.038 ms
Trigger on_source_table_update: time=2.389 calls=1
Execution Time: 3.542 ms
EXPLAIN
DROP TRIGGER
CREATE TRIGGER
QUERY PLAN
Insert on source_table (actual time=1.026..1.027 rows=0 loops=1)
  -> ProjectSet (actual time=0.002..0.119 rows=1000 loops=1)
        -> Result (actual time=0.001..0.001 rows=1 loops=1)
Planning Time: 0.028 ms
Trigger on_source_table_update: time=5034.604 calls=1000
Execution Time: 5035.992 ms
EXPLAIN