#	exclusive	inclusive	rows x	rows	loops	node
1.	408.317	408.317	↑ 1.1	55205	1	→ Seq Scan on profile_male (cost=0.00..30771.08 rows=61695 width=4) (actual time=1.663..408.317 rows=55205 loops=1) Filter: (in_search AND ((vip = 0) OR (vip IS NULL)) AND (iage >= 0) AND (iage <= 99) AND (city = 476434))

 Seq Scan on profile_male  (cost=0.00..30771.08 rows=61695 width=4) (actual time=1.663..408.317 rows=55205 loops=1)
   Filter: (in_search AND ((vip = 0) OR (vip IS NULL)) AND (iage >= 0) AND (iage <= 99) AND (city = 476434))
 Total runtime: 488.427 ms

Per node type stats

node type	count	sum of times	% of query
Seq Scan	1	408.317 ms	100.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
profile_male	1	408.317 ms	100.0 %
Seq Scan	1	408.317 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: eV1

Colorize:

Columns visibility:

Per node type stats

Per table stats