explain.depesz.com

PostgreSQL's explain analyze made readable

Result: moiR

Settings
# exclusive inclusive rows x rows loops node
1. 47.784 300.647 ↑ 620.0 1 1

GroupAggregate (cost=0.00..96,009.49 rows=620 width=48) (actual time=300.647..300.647 rows=1 loops=1)

  • Group Key: workspace_id
2. 252.863 252.863 ↑ 1.1 255,952 1

Seq Scan on clip (cost=0.00..94,645.35 rows=271,278 width=23) (actual time=0.099..252.863 rows=255,952 loops=1)

  • Filter: (workspace_id = '8271b633-a524-46e8-9620-c2d15c7ce3c6'::uuid)
  • Rows Removed by Filter: 390571
Planning time : 0.329 ms