#	exclusive	inclusive	rows x	rows	loops	node
1.	0.020	0.098	↓ 2.0	2	1	→ Sort (cost=24.51..24.51 rows=1 width=1148) (actual time=0.096..0.098 rows=2 loops=1) Sort Key: (upper((u.name)::text)) Sort Method: quicksort Memory: 17kB
2.	0.033	0.078	↓ 2.0	2	1	→ Hash Join (cost=13.66..24.50 rows=1 width=1148) (actual time=0.061..0.078 rows=2 loops=1) Hash Cond: ((u.id)::text = (uc.user_id)::text)
3.	0.016	0.016	↑ 8.6	7	1	→ Seq Scan on "user" u (cost=0.00..10.60 rows=60 width=1148) (actual time=0.009..0.016 rows=7 loops=1)
4.	0.008	0.029	↑ 1.0	2	1	→ Hash (cost=13.64..13.64 rows=2 width=82) (actual time=0.029..0.029 rows=2 loops=1)
5.	0.010	0.021	↑ 1.0	2	1	→ Bitmap Heap Scan on user_company uc (cost=9.40..13.64 rows=2 width=82) (actual time=0.019..0.021 rows=2 loops=1) Recheck Cond: ((company_id)::text = 'c3a1c8e4cb654a6a891c74ac49c13988'::text)
6.	0.011	0.011	↑ 1.0	2	1	→ Bitmap Index Scan on user_company_pk (cost=0.00..9.40 rows=2 width=0) (actual time=0.011..0.011 rows=2 loops=1) Index Cond: ((company_id)::text = 'c3a1c8e4cb654a6a891c74ac49c13988'::text)

"Sort  (cost=24.51..24.51 rows=1 width=1148) (actual time=0.096..0.098 rows=2 loops=1)"
"  Sort Key: (upper((u.name)::text))"
"  Sort Method:  quicksort  Memory: 17kB"
"  ->  Hash Join  (cost=13.66..24.50 rows=1 width=1148) (actual time=0.061..0.078 rows=2 loops=1)"
"        Hash Cond: ((u.id)::text = (uc.user_id)::text)"
"        ->  Seq Scan on "user" u  (cost=0.00..10.60 rows=60 width=1148) (actual time=0.009..0.016 rows=7 loops=1)"
"        ->  Hash  (cost=13.64..13.64 rows=2 width=82) (actual time=0.029..0.029 rows=2 loops=1)"
"              ->  Bitmap Heap Scan on user_company uc  (cost=9.40..13.64 rows=2 width=82) (actual time=0.019..0.021 rows=2 loops=1)"
"                    Recheck Cond: ((company_id)::text = 'c3a1c8e4cb654a6a891c74ac49c13988'::text)"
"                    ->  Bitmap Index Scan on user_company_pk  (cost=0.00..9.40 rows=2 width=0) (actual time=0.011..0.011 rows=2 loops=1)"
"                          Index Cond: ((company_id)::text = 'c3a1c8e4cb654a6a891c74ac49c13988'::text)"
"Total runtime: 0.165 ms"

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	0.010 ms	10.2 %
Bitmap Index Scan	1	0.011 ms	11.2 %
Hash	1	0.008 ms	8.2 %
Hash Join	1	0.033 ms	33.7 %
Seq Scan	1	0.016 ms	16.3 %
Sort	1	0.020 ms	20.4 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
"user"	1	0.016 ms	16.3 %
Seq Scan	1	0.016 ms	100.0 %
user_company	1	0.010 ms	10.2 %
Bitmap Heap Scan	1	0.010 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: y0q

Colorize:

Columns visibility:

Per node type stats

Per table stats