explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qYeS

Settings
# exclusive inclusive rows x rows loops node
1. 0.054 0.090 ↓ 0.0 0 1

Sort (cost=112.40..112.45 rows=21 width=22) (actual time=0.090..0.090 rows=0 loops=1)

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

Nested Loop (cost=0.41..111.94 rows=21 width=22) (actual time=0.036..0.036 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.035 0.035 ↓ 0.0 0 1

Index Scan using users_sso_idx on users u (cost=0.41..8.46 rows=1 width=135) (actual time=0.035..0.035 rows=0 loops=1)

  • Index Cond: (sso = 555444333)
4. 0.000 0.000 ↓ 0.0 0

Seq Scan on accounts a (cost=0.00..85.00 rows=352 width=22) (never executed)

  • Filter: ((status)::text <> 'cancelled'::text)
Planning time : 1.271 ms
Execution time : 0.172 ms