explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y2JZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.029 ↑ 1.0 1 1

Aggregate (cost=3.63..3.64 rows=1 width=8) (actual time=0.028..0.029 rows=1 loops=1)

2. 0.006 0.019 ↑ 1.0 1 1

Bitmap Heap Scan on authentication_events (cost=2.60..3.63 rows=1 width=8) (actual time=0.018..0.019 rows=1 loops=1)

  • Recheck Cond: ((provider = 'ldap'::text) AND (user_id >= 0) AND (user_id <= 1,000))
  • Filter: ((created_at >= '2020-08-12 19:05:45.606188-05'::timestamp with time zone) AND (created_at <= '2020-09-09 19:05:45.606328-05'::timestamp with time zone))
  • Heap Blocks: exact=1
3. 0.000 0.013 ↓ 0.0 0 1

BitmapAnd (cost=2.60..2.60 rows=1 width=0) (actual time=0.013..0.013 rows=0 loops=1)

4. 0.010 0.010 ↑ 3.0 1 1

Bitmap Index Scan on index_authentication_events_on_provider (cost=0.00..1.17 rows=3 width=0) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (provider = 'ldap'::text)
5. 0.003 0.003 ↑ 1.5 2 1

Bitmap Index Scan on index_authentication_events_on_user_id (cost=0.00..1.18 rows=3 width=0) (actual time=0.003..0.003 rows=2 loops=1)

  • Index Cond: ((user_id >= 0) AND (user_id <= 1,000))
Planning time : 0.106 ms
Execution time : 0.083 ms