explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ZNt

options
# exclusive inclusive rows x rows loops node
1. 154.109 1597.967 ↑ 1.0 1 1
→

Aggregate (cost=53271.40..53271.41 rows=1 width=0) (actual time=1597.966..1597.967 rows=1 loops=1)

2. 307.035 1443.858 ↑ 1.1 103516 1
→

Append (cost=0.00..52983.38 rows=115206 width=0) (actual time=0.095..1443.858 rows=103516 loops=1)

3. 165.434 671.208 ↑ 1.1 55205 1
→

Subquery Scan on "*SELECT* 1" (cost=0.00..31384.72 rows=61464 width=0) (actual time=0.091..671.208 rows=55205 loops=1)

4. 505.774 505.774 ↑ 1.1 55205 1
→

Seq Scan on profile_male (cost=0.00..30770.08 rows=61464 width=4) (actual time=0.088..505.774 rows=55205 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 48311 1
→

Subquery Scan on "*SELECT* 2" (cost=0.00..21598.66 rows=53742 width=0) (actual time=1.308..465.615 rows=48311 loops=1)

6. 322.540 322.540 ↑ 1.1 48311 1
→

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

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