#	exclusive	inclusive	rows x	rows	loops	node
1.	0.002	0.117	↑ 20.0	1	1	→ Limit (cost=3262.57..3262.77 rows=20 width=5) (actual time=0.116..0.117 rows=1 loops=1)
2.	0.020	0.115	↑ 884.0	1	1	→ HashAggregate (cost=3262.57..3271.41 rows=884 width=5) (actual time=0.115..0.115 rows=1 loops=1)
3.	0.022	0.095	↑ 16.7	53	1	→ Nested Loop (cost=36.04..3260.36 rows=884 width=5) (actual time=0.036..0.095 rows=53 loops=1)
4.	0.012	0.012	↑ 1.0	1	1	→ Index Scan using product_parent_name_idx on product_parent par_ (cost=0.00..16.31 rows=1 width=4) (actual time=0.011..0.012 rows=1 loops=1) Index Cond: (((parent_name)::text ~>=~ 'aa'::text) AND ((parent_name)::text ~<~ 'ab'::text)) Filter: ((parent_name)::text ~~ 'aa%'::text)
5.	0.047	0.061	↑ 17.0	53	1	→ Bitmap Heap Scan on product p_ (cost=36.04..3232.82 rows=899 width=9) (actual time=0.021..0.061 rows=53 loops=1) Recheck Cond: (parent_id = par_.id)
6.	0.014	0.014	↑ 17.0	53	1	→ Bitmap Index Scan on product_parent_id_idx (cost=0.00..35.81 rows=899 width=0) (actual time=0.014..0.014 rows=53 loops=1) Index Cond: (parent_id = par_.id)

"Limit  (cost=3262.57..3262.77 rows=20 width=5) (actual time=0.116..0.117 rows=1 loops=1)"
"  ->  HashAggregate  (cost=3262.57..3271.41 rows=884 width=5) (actual time=0.115..0.115 rows=1 loops=1)"
"        ->  Nested Loop  (cost=36.04..3260.36 rows=884 width=5) (actual time=0.036..0.095 rows=53 loops=1)"
"              ->  Index Scan using product_parent_name_idx on product_parent par_  (cost=0.00..16.31 rows=1 width=4) (actual time=0.011..0.012 rows=1 loops=1)"
"                    Index Cond: (((parent_name)::text ~>=~ 'aa'::text) AND ((parent_name)::text ~<~ 'ab'::text))"
"                    Filter: ((parent_name)::text ~~ 'aa%'::text)"
"              ->  Bitmap Heap Scan on product p_  (cost=36.04..3232.82 rows=899 width=9) (actual time=0.021..0.061 rows=53 loops=1)"
"                    Recheck Cond: (parent_id = par_.id)"
"                    ->  Bitmap Index Scan on product_parent_id_idx  (cost=0.00..35.81 rows=899 width=0) (actual time=0.014..0.014 rows=53 loops=1)"
"                          Index Cond: (parent_id = par_.id)"
"Total runtime: 0.155 ms"

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	0.047 ms	40.2 %
Bitmap Index Scan	1	0.014 ms	12.0 %
HashAggregate	1	0.020 ms	17.1 %
Index Scan	1	0.012 ms	10.3 %
Limit	1	0.002 ms	1.7 %
Nested Loop	1	0.022 ms	18.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
product	1	0.047 ms	40.2 %
Bitmap Heap Scan	1	0.047 ms	100.0 %
product_parent	1	0.012 ms	10.3 %
Index Scan	1	0.012 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 4iL

Colorize:

Columns visibility:

Per node type stats

Per table stats