explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pfSV

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.047 ↑ 1.0 1 1

Aggregate (cost=3,388.03..3,388.04 rows=1 width=8) (actual time=0.047..0.047 rows=1 loops=1)

2. 0.023 0.044 ↑ 42.4 12 1

Bitmap Heap Scan on event_entity ee (cost=31.06..3,386.75 rows=509 width=8) (actual time=0.028..0.044 rows=12 loops=1)

  • Recheck Cond: ((user_id)::text = 'cb908070-19da-46b4-9ef1-c1360fbfbb36'::text)
  • Filter: ((type)::text = 'LOGIN'::text)
  • Rows Removed by Filter: 13
  • Heap Blocks: exact=11
3. 0.021 0.021 ↑ 34.0 25 1

Bitmap Index Scan on user_id_idx (cost=0.00..30.93 rows=849 width=0) (actual time=0.021..0.021 rows=25 loops=1)

  • Index Cond: ((user_id)::text = 'cb908070-19da-46b4-9ef1-c1360fbfbb36'::text)
Planning time : 0.137 ms
Execution time : 0.068 ms