explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ENFJ : Optimization for: plan #SVHy

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=1,278.17..1,278.34 rows=69 width=87) (actual rows= loops=)

  • Sort Key: (count(*)) DESC
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,095.90..1,276.06 rows=69 width=87) (actual rows= loops=)

  • Hash Cond: (asset."UserID" = c.userid)
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,059.35..1,239.44 rows=25 width=79) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1,059.06..1,059.63 rows=25 width=36) (actual rows= loops=)

  • Group Key: asset."UserID", asset."Username", asset.nama
5. 0.000 0.000 ↓ 0.0

Sort (cost=1,059.06..1,059.13 rows=25 width=28) (actual rows= loops=)

  • Sort Key: asset."UserID", asset."Username", asset.nama
6. 0.000 0.000 ↓ 0.0

Seq Scan on asset (cost=0.00..1,058.48 rows=25 width=28) (actual rows= loops=)

  • Filter: ((is_delete = 0) AND (date(last_update) <= '2019-05-03'::date) AND (lower((status)::text) = 'assigning'::text))
7. 0.000 0.000 ↓ 0.0

Index Scan using users_pkey on users b (cost=0.29..7.18 rows=1 width=47) (actual rows= loops=)

  • Index Cond: (asset."UserID" = "UserID")
8. 0.000 0.000 ↓ 0.0

Hash (cost=29.63..29.63 rows=554 width=12) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Subquery Scan on c (cost=18.55..29.63 rows=554 width=12) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

HashAggregate (cost=18.55..24.09 rows=554 width=12) (actual rows= loops=)

  • Group Key: asset_reminder.userid
11. 0.000 0.000 ↓ 0.0

Seq Scan on asset_reminder (cost=0.00..14.70 rows=770 width=12) (actual rows= loops=)