explain.depesz.com

PostgreSQL's explain analyze made readable

Result: deV5

Settings
# exclusive inclusive rows x rows loops node
1. 1.125 1.649 ↓ 1.0 3,411 1

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

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

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