explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dJg1

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.007 0.057 ↓ 5.0 5 1

GroupAggregate (cost=1.76..1.78 rows=1 width=16) (actual time=0.053..0.057 rows=5 loops=1)

  • Output: (date_trunc('day'::text, inserted_at)), count(inserted_at)
  • Group Key: (date_trunc('day'::text, up.inserted_at))
2. 0.011 0.050 ↓ 13.0 13 1

Sort (cost=1.76..1.76 rows=1 width=16) (actual time=0.049..0.050 rows=13 loops=1)

  • Output: (date_trunc('day'::text, inserted_at)), inserted_at
  • Sort Key: (date_trunc('day'::text, up.inserted_at))
  • Sort Method: quicksort Memory: 25kB
3. 0.039 0.039 ↓ 13.0 13 1

Seq Scan on public.user_passphrases up (cost=0.00..1.75 rows=1 width=16) (actual time=0.024..0.039 rows=13 loops=1)

  • Output: date_trunc('day'::text, inserted_at), inserted_at
  • Filter: ((up.inserted_at <= now()) AND (up.inserted_at >= (now() - '7 days'::interval)) AND (date_part('week'::text, up.inserted_at) = date_part('week'::text, now())))
  • Rows Removed by Filter: 16
Planning time : 0.106 ms
Execution time : 0.082 ms