#	exclusive	inclusive	rows x	rows	loops	node
1.	0.024	137.430	↑ 1.0	24	1	→ Limit (cost=112074997552225.62..112074997552225.69 rows=24 width=28) (actual time=137.393..137.430 rows=24 loops=1)
2.	35.769	137.406	↑ 2007.4	24	1	→ Sort (cost=112074997552225.62..112074997552346.06 rows=48177 width=28) (actual time=137.391..137.406 rows=24 loops=1) Sort Key: entity_love.id Sort Method: top-N heapsort Memory: 26kB
3.	47.983	101.637	↑ 1.1	41965	1	→ Limit (cost=374.12..112074997550398.53 rows=48177 width=28) (actual time=6.891..101.637 rows=41965 loops=1)
4.	48.730	53.654	↑ 1.1	41965	1	→ Bitmap Heap Scan on entity_love (cost=374.12..112074997550398.53 rows=48177 width=28) (actual time=6.889..53.654 rows=41965 loops=1) Recheck Cond: (user_id = ANY ('{36615,8345,1930}'::integer[]))
5.	4.924	4.924	↑ 1.1	41965	1	→ Bitmap Index Scan on entity_love__user_id__id (cost=0.00..362.08 rows=48177 width=0) (actual time=4.924..4.924 rows=41965 loops=1) Index Cond: (user_id = ANY ('{36615,8345,1930}'::integer[]))

Limit  (cost=112074997552225.62..112074997552225.69 rows=24 width=28) (actual time=137.393..137.430 rows=24 loops=1)
  ->  Sort  (cost=112074997552225.62..112074997552346.06 rows=48177 width=28) (actual time=137.391..137.406 rows=24 loops=1)
        Sort Key: entity_love.id
        Sort Method: top-N heapsort  Memory: 26kB
        ->  Limit  (cost=374.12..112074997550398.53 rows=48177 width=28) (actual time=6.891..101.637 rows=41965 loops=1)
              ->  Bitmap Heap Scan on entity_love  (cost=374.12..112074997550398.53 rows=48177 width=28) (actual time=6.889..53.654 rows=41965 loops=1)
                    Recheck Cond: (user_id = ANY ('{36615,8345,1930}'::integer[]))
                    ->  Bitmap Index Scan on entity_love__user_id__id  (cost=0.00..362.08 rows=48177 width=0) (actual time=4.924..4.924 rows=41965 loops=1)
                          Index Cond: (user_id = ANY ('{36615,8345,1930}'::integer[]))
Total runtime: 137.473 ms

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	48.730 ms	35.5 %
Bitmap Index Scan	1	4.924 ms	3.6 %
Limit	2	48.007 ms	34.9 %
Sort	1	35.769 ms	26.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
entity_love	1	48.730 ms	35.5 %
Bitmap Heap Scan	1	48.730 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: tcH

Colorize:

Columns visibility:

Per node type stats

Per table stats