explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TkSg

Settings
# exclusive inclusive rows x rows loops node
1. 44.606 329.707 ↑ 620.0 1 1

GroupAggregate (cost=0.00..97,503.35 rows=620 width=48) (actual time=329.707..329.707 rows=1 loops=1)

  • Group Key: workspace_id
2. 285.101 285.101 ↓ 1.1 244,947 1

Seq Scan on clip (cost=0.00..96,347.22 rows=229,676 width=23) (actual time=0.099..285.101 rows=244,947 loops=1)

  • Filter: (visible AND (NOT inactive) AND (status <> 'created'::text) AND (workspace_id = '8271b633-a524-46e8-9620-c2d15c7ce3c6'::uuid))
  • Rows Removed by Filter: 401576