explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vZkS

Settings
# exclusive inclusive rows x rows loops node
1. 0.118 12.043 ↑ 1.1 22 1

Sort (cost=889.41..889.47 rows=24 width=76) (actual time=12.039..12.043 rows=22 loops=1)

  • Sort Key: b.name
  • Sort Method: quicksort Memory: 27kB
2. 0.109 11.925 ↑ 1.1 22 1

Nested Loop (cost=90.21..888.86 rows=24 width=76) (actual time=4.517..11.925 rows=22 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. 2.097 2.097 ↑ 1.0 1 1

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

  • Index Cond: (sso = 212767406)
4. 0.063 9.719 ↑ 18.0 22 1

Hash Join (cost=89.80..857.63 rows=396 width=48) (actual time=4.258..9.719 rows=22 loops=1)

  • Hash Cond: (b.account = a.id)
5. 8.575 8.575 ↑ 18.0 22 1

Seq Scan on browser_applications b (cost=0.00..766.78 rows=396 width=26) (actual time=3.141..8.575 rows=22 loops=1)

  • Filter: ((name)::text ~~* '%am%'::text)
  • Rows Removed by Filter: 1638
6. 0.363 1.081 ↓ 1.0 482 1

Hash (cost=83.80..83.80 rows=480 width=22) (actual time=1.081..1.081 rows=482 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 35kB
7. 0.718 0.718 ↓ 1.0 482 1

Seq Scan on accounts a (cost=0.00..83.80 rows=480 width=22) (actual time=0.010..0.718 rows=482 loops=1)

Planning time : 1.723 ms
Execution time : 12.206 ms