explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zu1V

Settings
# exclusive inclusive rows x rows loops node
1. 0.094 0.334 ↓ 0.0 0 1

Insert on cattoys (cost=21.50..21.52 rows=1 width=12) (actual time=0.334..0.334 rows=0 loops=1)

2.          

Initplan (forInsert)

3. 0.031 0.031 ↑ 1.0 1 1

Seq Scan on cats (cost=0.00..10.62 rows=1 width=4) (actual time=0.019..0.031 rows=1 loops=1)

  • Filter: ((name)::text = 'Ryan'::text)
  • Rows Removed by Filter: 4
4. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on toys (cost=0.00..10.88 rows=1 width=4) (actual time=0.019..0.019 rows=0 loops=1)

  • Filter: ((name)::text = 'tin foil'::text)
  • Rows Removed by Filter: 4
5. 0.190 0.190 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=12) (actual time=0.189..0.190 rows=1 loops=1)

Planning time : 0.124 ms
Execution time : 0.616 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint cattoys_cat_id_fkey 0.196 ms 1 0.196 ms
for constraint cattoys_toy_id_fkey 0.004 ms 1 0.004 ms