explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nn2r

Settings
# exclusive inclusive rows x rows loops node
1. 1,150.414 1,694.914 ↓ 1.2 2,220,713 1

Hash Join (cost=22.98..58,709.83 rows=1,913,317 width=8) (actual time=0.184..1,694.914 rows=2,220,713 loops=1)

  • Hash Cond: (t.user_id = users.id)
2. 544.341 544.341 ↓ 1.0 2,220,713 1

Seq Scan on tmp_user_device t (cost=0.00..31,446.40 rows=2,161,940 width=8) (actual time=0.016..544.341 rows=2,220,713 loops=1)

3. 0.050 0.159 ↑ 1.0 177 1

Hash (cost=20.77..20.77 rows=177 width=4) (actual time=0.159..0.159 rows=177 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
4. 0.109 0.109 ↑ 1.0 177 1

Seq Scan on users (cost=0.00..20.77 rows=177 width=4) (actual time=0.004..0.109 rows=177 loops=1)

  • Filter: (is_active AND is_admin)