explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uq9J : 234

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.229 ↓ 11.0 11 1

Nested Loop Semi Join (cost=1.41..44.90 rows=1 width=8) (actual time=0.074..0.229 rows=11 loops=1)

  • Join Filter: (c.id = uzgps_user_access_list.ual_contractid)
  • Rows Removed by Join Filter: 55
2. 0.139 0.139 ↓ 11.0 11 1

Seq Scan on uzgps_contract c (cost=0.00..43.16 rows=1 width=8) (actual time=0.017..0.139 rows=11 loops=1)

  • Filter: ((status_id = ANY ('{1,2}'::bigint[])) AND ((c_status)::text = 'A'::text))
3. 0.051 0.077 ↑ 1.7 6 11

HashAggregate (cost=1.41..1.51 rows=10 width=8) (actual time=0.005..0.007 rows=6 loops=11)

  • Group Key: uzgps_user_access_list.ual_contractid
4. 0.026 0.026 ↓ 3.2 32 1

Seq Scan on uzgps_user_access_list (cost=0.00..1.39 rows=10 width=8) (actual time=0.008..0.026 rows=32 loops=1)

  • Filter: (ual_routing > 0)