explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 64Yk

Settings
# exclusive inclusive rows x rows loops node
1. 162.323 456.704 ↓ 3.1 1,934 1

HashAggregate (cost=97,527.11..97,534.86 rows=620 width=48) (actual time=456.065..456.704 rows=1,934 loops=1)

  • Group Key: workspace_id
2. 294.381 294.381 ↑ 1.0 564,025 1

Seq Scan on clip (cost=0.00..94,645.35 rows=576,352 width=23) (actual time=0.098..294.381 rows=564,025 loops=1)

  • Filter: (visible AND (NOT inactive) AND (status <> 'created'::text))
  • Rows Removed by Filter: 82498
Planning time : 0.163 ms