explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XjGi

Settings
# exclusive inclusive rows x rows loops node
1. 414.667 1,405.136 ↓ 5.5 11 1

Bitmap Heap Scan on related_domain_observations (cost=1,004.58..220,941.72 rows=2 width=34) (actual time=383.447..1,405.136 rows=11 loops=1)

  • Recheck Cond: (domain_name = 'bhge.com'::text)
  • Filter: (((source <> 'whoxy.name_server'::text) OR (NOT (SubPlan 1))) AND ((source <> 'whoxy.registrant_email'::text) OR (NOT (SubPlan 2))))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=12
2. 0.044 0.044 ↓ 6.0 12 1

Bitmap Index Scan on related_domain_observations_domain_index (cost=0.00..4.58 rows=2 width=0) (actual time=0.044..0.044 rows=12 loops=1)

  • Index Cond: (domain_name = 'bhge.com'::text)
3.          

SubPlan (for Bitmap Heap Scan)

4. 598.235 832.050 ↑ 1.6 630,559 10

Materialize (cost=0.00..64,146.46 rows=1,004,633 width=16) (actual time=0.004..83.205 rows=630,559 loops=10)

5. 233.815 233.815 ↑ 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.005..233.815 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. 6.201 158.375 ↑ 4.9 31,882 1

Materialize (cost=1,000.00..153,881.25 rows=155,925 width=15) (actual time=0.271..158.375 rows=31,882 loops=1)

7. 2.848 152.174 ↑ 4.9 31,882 1

Gather (cost=1,000.00..152,339.63 rows=155,925 width=15) (actual time=0.268..152.174 rows=31,882 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 149.326 149.326 ↑ 6.1 10,634 3 / 3

Parallel Seq Scan on email_stopwords (cost=0.00..135,747.13 rows=64,969 width=15) (actual time=0.019..149.326 rows=10,634 loops=3)

  • Filter: ((actual = 1) OR (prediction <> 0) OR (stopword_probability >= '0.5'::double precision))
  • Rows Removed by Filter: 1,026,215
Planning time : 0.143 ms
Execution time : 1,409.692 ms