explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1u9R

Settings
# exclusive inclusive rows x rows loops node
1. 8.349 864.269 ↓ 5.5 11 1

Hash Anti Join (cost=226,732.46..232,416.55 rows=2 width=34) (actual time=826.007..864.269 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. 30.862 404.857 ↓ 6.0 12 1

Hash Anti Join (cost=71,681.77..76,601.83 rows=2 width=34) (actual time=374.478..404.857 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.060 0.060 ↓ 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.039..0.060 rows=12 loops=1)

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

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

  • Buckets: 131,072 Batches: 16 Memory Usage: 2,844kB
5. 247.500 247.500 ↑ 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..247.500 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. 30.805 451.063 ↑ 1.7 91,732 1

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

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

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

  • Workers Planned: 2
  • Workers Launched: 2
8. 420.168 420.168 ↑ 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..420.168 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.343 ms
Execution time : 864.663 ms