explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BFCl

Settings
# exclusive inclusive rows x rows loops node
1. 9.251 873.901 ↓ 5.5 11 1

Hash Anti Join (cost=226,732.46..232,416.55 rows=2 width=34) (actual time=833.042..873.901 rows=11 loops=1)

  • Hash Cond: (related_domain_observations.source_entity = email_stopwords.email_whois_domain)
  • Join Filter: (related_domain_observations.source = 'whoxy.registrant_email'::text)
  • Rows Removed by Join Filter: 1
2. 32.573 405.511 ↓ 6.0 12 1

Hash Anti Join (cost=71,681.77..76,601.83 rows=2 width=34) (actual time=373.433..405.511 rows=12 loops=1)

  • Hash Cond: (related_domain_observations.source_entity = ns_stopwords.ns_whois_domain)
  • Join Filter: (related_domain_observations.source = 'whoxy.name_server'::text)
3. 0.051 0.051 ↓ 6.0 12 1

Index Scan using related_domain_observations_domain_index on related_domain_observations (cost=0.56..12.60 rows=2 width=34) (actual time=0.030..0.051 rows=12 loops=1)

  • Index Cond: (domain_name = 'bhge.com'::text)
4. 125.933 372.887 ↑ 1.6 630,559 1

Hash (cost=54,217.29..54,217.29 rows=1,004,633 width=16) (actual time=372.887..372.887 rows=630,559 loops=1)

  • Buckets: 131,072 Batches: 16 Memory Usage: 2,844kB
5. 246.954 246.954 ↑ 1.6 630,559 1

Seq Scan on ns_stopwords (cost=0.00..54,217.29 rows=1,004,633 width=16) (actual time=0.007..246.954 rows=630,559 loops=1)

  • Filter: ((actual = 1) OR (prediction <> 0) OR (stopword_probability >= '0.5'::double precision))
  • Rows Removed by Filter: 1,466,560
6. 31.561 459.139 ↑ 1.7 91,732 1

Hash (cost=152,339.63..152,339.63 rows=155,925 width=15) (actual time=459.139..459.139 rows=91,732 loops=1)

  • Buckets: 131,072 Batches: 4 Memory Usage: 2,073kB
7. 0.637 427.578 ↑ 1.7 91,732 1

Gather (cost=1,000.00..152,339.63 rows=155,925 width=15) (actual time=0.237..427.578 rows=91,732 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 426.941 426.941 ↑ 2.1 30,577 3 / 3

Parallel Seq Scan on email_stopwords (cost=0.00..135,747.13 rows=64,969 width=15) (actual time=0.018..426.941 rows=30,577 loops=3)

  • Filter: ((actual = 1) OR (prediction <> 0) OR (stopword_probability >= '0.5'::double precision))
  • Rows Removed by Filter: 2,872,456
Planning time : 0.370 ms
Execution time : 874.361 ms