explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RPMu

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 7.486 ↑ 1.0 258 1

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

2. 1.596 7.440 ↑ 1.0 258 1

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

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

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

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

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

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

6. 0.170 0.336 ↑ 1.0 258 1

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

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

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

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