explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cr5a

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 0.023 ↓ 0.0 0 1

Insert on tab1 (cost=0.00..10.00 rows=1,000 width=32) (actual time=0.023..0.023 rows=0 loops=1)

2. 0.007 0.007 ↑ 333.3 3 1

Function Scan on generate_series (cost=0.00..10.00 rows=1,000 width=32) (actual time=0.006..0.007 rows=3 loops=1)

Planning time : 0.035 ms
Execution time : 3,012.957 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
tab1_upd_trigger 3,012.914 ms 3 1,004.305 ms