#	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))

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
   ->  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)
         ->  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))
               ->  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))
         ->  Hash  (cost=25.49..25.49 rows=453 width=54) (never executed)
               ->  Seq Scan on project  (cost=0.00..25.49 rows=453 width=54) (never executed)
                     Filter: ((NOT is_deleted) AND ((parent_project_id)::text = 'proj1002'::text))
 Total runtime: 0.188 ms
(13 rows)

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	0.002 ms	1.9 %
Bitmap Index Scan	1	0.064 ms	60.4 %
Hash	1	0.000 ms	0.0 %
Hash Join	1	0.003 ms	2.8 %
Seq Scan	1	0.000 ms	0.0 %
Sort	1	0.037 ms	34.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
project	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
recent_access	1	0.002 ms	1.9 %
Bitmap Heap Scan	1	0.002 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: oSH

Colorize:

Columns visibility:

Per node type stats

Per table stats