explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iTA

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 0.943 ↓ 0.0 0 1

Sort (cost=32.03..32.04 rows=1 width=149) (actual time=0.943..0.943 rows=0 loops=1)

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

Nested Loop Left Join (cost=0.27..32.02 rows=1 width=149) (actual time=0.921..0.921 rows=0 loops=1)

3. 0.920 0.920 ↓ 0.0 0 1

Seq Scan on sikuli_monitors s (cost=0.00..23.70 rows=1 width=85) (actual time=0.920..0.920 rows=0 loops=1)

  • Filter: ((name)::text ~~* '%pttus#%'::text)
  • Rows Removed by Filter: 137
4. 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)
Planning time : 1.241 ms
Execution time : 1.074 ms