explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ZNt

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

Aggregate (cost=53,271.40..53,271.41 rows=1 width=0) (actual time=1,597.966..1,597.967 rows=1 loops=1)

2. 307.035 1,443.858 ↑ 1.1 103,516 1

Append (cost=0.00..52,983.38 rows=115,206 width=0) (actual time=0.095..1,443.858 rows=103,516 loops=1)

3. 165.434 671.208 ↑ 1.1 55,205 1

Subquery Scan on "*SELECT* 1" (cost=0.00..31,384.72 rows=61,464 width=0) (actual time=0.091..671.208 rows=55,205 loops=1)

4. 505.774 505.774 ↑ 1.1 55,205 1

Seq Scan on profile_male (cost=0.00..30,770.08 rows=61,464 width=4) (actual time=0.088..505.774 rows=55,205 loops=1)

  • Filter: (in_search AND ((vip = 0) OR (vip IS NULL)) AND (iage >= 0) AND (iage <= 99) AND (city = 476434))
5. 143.075 465.615 ↑ 1.1 48,311 1

Subquery Scan on "*SELECT* 2" (cost=0.00..21,598.66 rows=53,742 width=0) (actual time=1.308..465.615 rows=48,311 loops=1)

6. 322.540 322.540 ↑ 1.1 48,311 1

Seq Scan on profile_female (cost=0.00..21,061.24 rows=53,742 width=4) (actual time=1.304..322.540 rows=48,311 loops=1)

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