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)