explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O90q

Settings
# exclusive inclusive rows x rows loops node
1. 0.047 7.565 ↑ 1.0 258 1

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

2. 1.622 7.518 ↑ 1.0 258 1

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

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

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

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

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

  • Hash Cond: (t0.user_permission_id = t1.id)
5. 0.376 0.376 ↑ 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.007..0.376 rows=2,289 loops=1)

6. 0.181 0.338 ↑ 1.0 258 1

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

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

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

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