explain.depesz.com

A tool for finding a real cause for slow queries.

Result: tcH

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# 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[]))