explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Veec

Settings
# exclusive inclusive rows x rows loops node
1. 91.818 2,376.527 ↑ 1.0 123,344 1

Unique (cost=23,560.59..28,590.11 rows=125,738 width=129) (actual time=1,830.944..2,376.527 rows=123,344 loops=1)

2. 2,128.911 2,284.709 ↑ 1.0 123,344 1

Sort (cost=23,560.59..23,874.93 rows=125,738 width=129) (actual time=1,830.943..2,284.709 rows=123,344 loops=1)

  • Sort Key: u.id, u.activated, u.email, u.first_name, u.lang_key, u.last_name, u.login, u.last_invite_email_status, u.last_login_date, u.last_invite_date, u.activation_date, u.office, u.lock_date, a.unit_id, a.authority_name
  • Sort Method: external merge Disk: 17800kB
3. 116.551 155.798 ↑ 1.0 123,344 1

Hash Right Join (cost=263.76..4,314.54 rows=125,738 width=129) (actual time=2.829..155.798 rows=123,344 loops=1)

  • Hash Cond: (a.user_id = u.id)
4. 36.432 36.432 ↓ 1.0 128,856 1

Seq Scan on t_user_authority a (cost=0.00..2,424.49 rows=128,849 width=31) (actual time=0.005..36.432 rows=128,856 loops=1)

5. 1.253 2.815 ↑ 1.0 2,627 1

Hash (cost=230.92..230.92 rows=2,627 width=106) (actual time=2.815..2.815 rows=2,627 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 371kB
6. 1.562 1.562 ↑ 1.0 2,627 1

Seq Scan on t_user u (cost=0.00..230.92 rows=2,627 width=106) (actual time=0.005..1.562 rows=2,627 loops=1)

  • Filter: (retired_date IS NULL)
  • Rows Removed by Filter: 65