explain.depesz.com

A tool for finding a real cause for slow queries.

Result: oSH

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.037 0.106 ↓ 0.0 0 1

Sort (cost=87.97..88.00 rows=15 width=62) (actual time=0.106..0.106 rows=0 loops=1)

  • Sort Key: recent_access.date_created
  • Sort Method: quicksort Memory: 25kB
  • Total runtime: 0.188 ms
2. 0.003 0.069 ↓ 0.0 0 1

Hash Join (cost=35.57..87.67 rows=15 width=62) (actual time=0.069..0.069 rows=0 loops=1)

  • Hash Cond: ((recent_access.object_id)::text = (project.id)::text)
3. 0.002 0.066 ↓ 0.0 0 1

Bitmap Heap Scan on recent_access (cost=4.42..56.32 rows=15 width=17) (actual time=0.066..0.066 rows=0 loops=1)

  • Recheck Cond: (((user_id)::text = 'user3044'::text) AND ((access_type)::text = 'projects'::text))
4. 0.064 0.064 ↓ 0.0 0 1

Bitmap Index Scan on recent_access_user_type_date (cost=0.00..4.41 rows=15 width=0) (actual time=0.064..0.064 rows=0 loops=1)

  • Index Cond: (((user_id)::text = 'user3044'::text) AND ((access_type)::text = 'projects'::text))
5. 0.000 0.000 ↓ 0.0 0

Hash (cost=25.49..25.49 rows=453 width=54) (actual time=.. rows= loops=0)

6. 0.000 0.000 ↓ 0.0 0

Seq Scan on project (cost=0.00..25.49 rows=453 width=54) (actual time=.. rows= loops=0)

  • Filter: ((NOT is_deleted) AND ((parent_project_id)::text = 'proj1002'::text))