explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CQ7W

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

Limit (cost=1.13..5.58 rows=1 width=32) (actual time=0.050..0.051 rows=1 loops=1)

2. 0.012 0.050 ↑ 1.0 1 1

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

3. 0.023 0.023 ↑ 1.0 1 1

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

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

  • Index Cond: (id = t.user_id)
Planning time : 2.620 ms
Execution time : 0.079 ms