explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kacQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 0.053 ↓ 0.0 0 1

Update on cats (cost=0.00..14.88 rows=2 width=184) (actual time=0.053..0.053 rows=0 loops=1)

2. 0.019 0.019 ↑ 2.0 1 1

Seq Scan on cats (cost=0.00..14.88 rows=2 width=184) (actual time=0.018..0.019 rows=1 loops=1)

  • Filter: ((color)::text = 'blue'::text)
  • Rows Removed by Filter: 4
Planning time : 0.087 ms
Execution time : 0.089 ms