explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eZOd

Settings
# exclusive inclusive rows x rows loops node
1. 186.648 440.928 ↓ 4.9 3,028 1

HashAggregate (cost=96,347.22..96,354.97 rows=620 width=48) (actual time=439.901..440.928 rows=3,028 loops=1)

  • Group Key: workspace_id
2. 254.280 254.280 ↑ 1.1 646,523 1

Seq Scan on clip (cost=0.00..92,943.48 rows=680,748 width=23) (actual time=0.095..254.280 rows=646,523 loops=1)

Planning time : 0.058 ms