explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q429

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.005 0.028 ↓ 2.0 2 1

GroupAggregate (cost=8.18..8.21 rows=1 width=16) (actual time=0.027..0.028 rows=2 loops=1)

  • Output: (date_part('day'::text, inserted_at)), count(inserted_at)
  • Group Key: (date_part('day'::text, up.inserted_at))
2. 0.006 0.023 ↓ 8.0 8 1

Sort (cost=8.18..8.19 rows=1 width=16) (actual time=0.022..0.023 rows=8 loops=1)

  • Output: (date_part('day'::text, inserted_at)), inserted_at
  • Sort Key: (date_part('day'::text, up.inserted_at))
  • Sort Method: quicksort Memory: 25kB
3. 0.017 0.017 ↓ 8.0 8 1

Index Only Scan using user_passphrases_inserted_at_index on public.user_passphrases up (cost=0.15..8.17 rows=1 width=16) (actual time=0.014..0.017 rows=8 loops=1)

  • Output: date_part('day'::text, inserted_at), inserted_at
  • Index Cond: ((up.inserted_at >= (now() - '7 days'::interval)) AND (up.inserted_at <= now()))
  • Heap Fetches: 8
Planning time : 0.101 ms
Execution time : 0.048 ms