explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BxMk

Settings
# exclusive inclusive rows x rows loops node
1. 8.333 854.464 ↓ 5.5 11 1

Hash Anti Join (cost=226,732.46..232,416.55 rows=2 width=34) (actual time=815.799..854.464 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. 31.285 397.127 ↓ 6.0 12 1

Hash Anti Join (cost=71,681.77..76,601.83 rows=2 width=34) (actual time=366.323..397.127 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.053 0.053 ↓ 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.032..0.053 rows=12 loops=1)

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

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

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

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

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

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

  • Workers Planned: 2
  • Workers Launched: 2
8. 416.536 416.536 ↑ 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..416.536 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.358 ms
Execution time : 854.876 ms