explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xeOB

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.066 ↑ 1.0 1 1

Limit (cost=1.13..5.58 rows=1 width=32) (actual time=0.065..0.066 rows=1 loops=1)

2. 0.020 0.065 ↑ 1.0 1 1

Nested Loop (cost=1.13..5.58 rows=1 width=32) (actual time=0.064..0.065 rows=1 loops=1)

3. 0.029 0.029 ↑ 1.0 1 1

Index Scan using index_tokens_on_auth_key_and_device_and_device_id_and_valid_to_ on tokens t (cost=0.70..2.92 rows=1 width=4) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: (((auth_key)::text = '8eb03f944d92185b6ca5f5d28ee6d4c4'::text) AND ((device)::text = 'android'::text) AND ((device_id)::text = '1580482318152-7964809045194773619'::text) AND (valid_to >= (now())::timestamp without time zone))
  • Filter: (ip = '223.189.149.114'::inet)
4. 0.016 0.016 ↑ 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.016..0.016 rows=1 loops=1)

  • Index Cond: (id = t.user_id)
Planning time : 4.368 ms
Execution time : 0.105 ms