explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Sr5

Settings
# exclusive inclusive rows x rows loops node
1. 1.706 2.203 ↓ 1.0 3,411 1

HashAggregate (cost=98.53..132.50 rows=3,397 width=4) (actual time=1.052..2.203 rows=3,411 loops=1)

  • Group Key: user_id
2. 0.497 0.497 ↓ 1.0 3,416 1

Seq Scan on direct_translator (cost=0.00..90.02 rows=3,402 width=4) (actual time=0.008..0.497 rows=3,416 loops=1)