explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jFye

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 73.808 ↓ 0.0 0 1

Sort (cost=4,452.10..4,452.11 rows=1 width=130) (actual time=73.808..73.808 rows=0 loops=1)

  • Sort Key: s.name
  • Sort Method: quicksort Memory: 25kB
2. 0.001 73.793 ↓ 0.0 0 1

Nested Loop (cost=0.68..4,452.09 rows=1 width=130) (actual time=73.792..73.793 rows=0 loops=1)

  • Join Filter: ((a.id = ANY (u.admin)) OR (a.id = ANY (u.standard)) OR (a.id = ANY (u.restricted)) OR (((u.team)::text = 'APM'::text) AND (u.sso =
3. 0.001 73.792 ↓ 0.0 0 1

Nested Loop (cost=0.27..4,443.57 rows=1 width=98) (actual time=73.792..73.792 rows=0 loops=1)

4. 73.791 73.791 ↓ 0.0 0 1

Seq Scan on synthetics s (cost=0.00..4,435.25 rows=1 width=80) (actual time=73.790..73.791 rows=0 loops=1)

  • Filter: (((status)::text <> 'DELETED'::text) AND ((name)::text ~~* '%a#%'::text))
  • Rows Removed by Filter: 6786
5. 0.000 0.000 ↓ 0.0 0

Index Scan using accounts_id_key on accounts a (cost=0.27..8.29 rows=1 width=22) (never executed)

  • Index Cond: (id = s.account)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using users_sso_idx on users u (cost=0.41..8.46 rows=1 width=135) (never executed)

  • Index Cond: (sso = 212767406)
Planning time : 1.738 ms
Execution time : 73.951 ms