explain.depesz.com

A tool for finding a real cause for slow queries.

Result: NjVf

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 161.032 2066.498 ↑ 1.0 1 1

Aggregate (cost=66263.27..66263.28 rows=1 width=4) (actual time=2066.497..2066.498 rows=1 loops=1)

2. 326.285 1905.466 ↑ 1.1 103516 1

Unique (cost=64247.17..64823.20 rows=115206 width=4) (actual time=1399.802..1905.466 rows=103516 loops=1)

3. 428.737 1579.181 ↑ 1.1 103516 1

Sort (cost=64247.17..64535.18 rows=115206 width=4) (actual time=1399.799..1579.181 rows=103516 loops=1)

  • Sort Key: profile_male.user_id
  • Sort Method: external merge Disk: 1400kB
4. 308.681 1150.444 ↑ 1.1 103516 1

Append (cost=0.00..52983.38 rows=115206 width=4) (actual time=0.106..1150.444 rows=103516 loops=1)

5. 518.242 518.242 ↑ 1.1 55205 1

Seq Scan on profile_male (cost=0.00..30770.08 rows=61464 width=4) (actual time=0.103..518.242 rows=55205 loops=1)

  • Filter: (in_search AND ((vip = 0) OR (vip IS NULL)) AND (iage >= 0) AND (iage <= 99) AND (city = 476434))
6. 323.521 323.521 ↑ 1.1 48311 1

Seq Scan on profile_female (cost=0.00..21061.24 rows=53742 width=4) (actual time=0.902..323.521 rows=48311 loops=1)

  • Filter: (in_search AND ((vip = 0) OR (vip IS NULL)) AND (iage >= 0) AND (iage <= 99) AND (city = 476434))