explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xu9a

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 2.289 ↑ 1.0 258 1

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

2. 0.492 2.271 ↑ 1.0 258 1

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

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

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

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

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

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

6. 0.057 0.116 ↑ 1.0 258 1

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

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

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

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