explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wNvO

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 7.468 ↑ 1.0 258 1

Limit (cost=114.36..115.01 rows=258 width=115) (actual time=7.387..7.468 rows=258 loops=1)

2. 1.542 7.431 ↑ 1.0 258 1

Sort (cost=114.36..115.01 rows=258 width=115) (actual time=7.386..7.431 rows=258 loops=1)

  • Sort Key: t1.name, t1.id
  • Sort Method: quicksort Memory: 58kB
3. 3.030 5.889 ↑ 1.0 258 1

HashAggregate (cost=101.45..104.03 rows=258 width=115) (actual time=5.801..5.889 rows=258 loops=1)

  • Group Key: t1.name, t1.id, t1.description, t1.group_name, t1.user_type
4. 2.074 2.859 ↓ 1.0 2,101 1

Hash Right Join (cost=10.82..75.81 rows=2,051 width=115) (actual time=0.369..2.859 rows=2,101 loops=1)

  • Hash Cond: (t0.user_permission_id = t1.id)
5. 0.436 0.436 ↑ 1.0 2,289 1

Seq Scan on user_role_permission t0 (cost=0.00..35.89 rows=2,289 width=10) (actual time=0.008..0.436 rows=2,289 loops=1)

6. 0.164 0.349 ↑ 1.0 258 1

Hash (cost=7.60..7.60 rows=258 width=115) (actual time=0.349..0.349 rows=258 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 33kB
7. 0.185 0.185 ↑ 1.0 258 1

Seq Scan on user_permission t1 (cost=0.00..7.60 rows=258 width=115) (actual time=0.016..0.185 rows=258 loops=1)

  • Filter: ((user_type)::text = 'consoleOperator'::text)
  • Rows Removed by Filter: 30