explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H5b8

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

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

2. 0.024 0.411 ↑ 1.0 1 1

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

3. 0.314 0.314 ↑ 1.0 1 1

Index Scan using idx_tokens_auth_temp on tokens t (cost=0.56..2.80 rows=1 width=4) (actual time=0.314..0.314 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.073 0.073 ↑ 1.0 1 1

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

  • Index Cond: (id = t.user_id)
  • Filter: active
Planning time : 6.993 ms
Execution time : 0.504 ms