explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y3BH

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.713 ↑ 1.0 1 1

Limit (cost=1.00..5.46 rows=1 width=32) (actual time=0.712..0.713 rows=1 loops=1)

2. 0.017 0.711 ↑ 1.0 1 1

Nested Loop (cost=1.00..5.46 rows=1 width=32) (actual time=0.711..0.711 rows=1 loops=1)

3. 0.032 0.032 ↑ 1.0 1 1

Index Scan using idx_tokens_auth_temp2 on tokens t (cost=0.56..2.80 rows=1 width=4) (actual time=0.032..0.032 rows=1 loops=1)

  • Index Cond: ((auth_key)::text = '8eb03f944d92185b6ca5f5d28ee6d4c4'::text)
  • Filter: (((device)::text = 'android'::text) AND ((device_id)::text = '1580482318152-7964809045194773619'::text) AND (ip = '223.189.149.114'::inet) AND (valid_to >= (now())::timestamp without time zone))
4. 0.662 0.662 ↑ 1.0 1 1

Index Scan using idx_users_id_active on users u (cost=0.44..2.66 rows=1 width=36) (actual time=0.662..0.662 rows=1 loops=1)

  • Index Cond: (id = t.user_id)
Planning time : 9.560 ms
Execution time : 1.356 ms