explain.depesz.com

PostgreSQL's explain analyze made readable

Result: csyy

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 280.011 ↑ 1.0 72 1

Limit (cost=103,255.72..103,255.90 rows=72 width=24) (actual time=279.999..280.011 rows=72 loops=1)

2. 29.089 280.004 ↑ 3,590.5 72 1

Sort (cost=103,255.72..103,902.00 rows=258,513 width=24) (actual time=279.998..280.004 rows=72 loops=1)

  • Sort Key: created_at DESC
  • Sort Method: top-N heapsort Memory: 30kB
3. 250.915 250.915 ↑ 1.0 255,952 1

Seq Scan on clip (cost=0.00..93,988.12 rows=258,513 width=24) (actual time=0.115..250.915 rows=255,952 loops=1)

  • Filter: (workspace_id = '8271b633-a524-46e8-9620-c2d15c7ce3c6'::uuid)
  • Rows Removed by Filter: 372218