explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dcXX

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.008 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.57..9.16 rows=1 width=45) (actual time=0.008..0.008 rows=0 loops=1)

  • Join Filter: (o.application_user_id = p.application_user_id)
2.          

CTE o

3. 0.001 0.008 ↓ 0.0 0 1

GroupAggregate (cost=0.56..1.71 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=1)

  • Group Key: orders.application_user_id
4. 0.007 0.007 ↓ 0.0 0 1

Index Scan using orders_created_at_index on orders (cost=0.56..1.70 rows=1 width=12) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (created_at >= (now() - '01:00:00'::interval))
  • Filter: (application_user_id = 34370585)
5. 0.000 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.43..2.68 rows=1 width=41) (actual time=0.008..0.008 rows=0 loops=1)

6. 0.008 0.008 ↓ 0.0 0 1

CTE Scan on o (cost=0.00..0.02 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=1)

7. 0.000 0.000 ↓ 0.0 0

Index Scan using application_users_pkey on application_users au (cost=0.43..2.65 rows=1 width=33) (never executed)

  • Index Cond: (id = o.application_user_id)
8. 0.000 0.000 ↓ 0.0 0

Unique (cost=0.42..4.74 rows=1 width=8) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Scan using prime_primes_application_user_id_index on primes p (cost=0.42..4.74 rows=1 width=8) (never executed)

  • Index Cond: (application_user_id = 34370585)
  • Filter: (ends_at >= now())
Planning time : 0.271 ms
Execution time : 0.060 ms