explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TKsNk

Settings
# exclusive inclusive rows x rows loops node
1. 17.620 862.146 ↓ 5.5 11 1

HashSetOp Except (cost=0.56..223,977.95 rows=2 width=68) (actual time=862.145..862.146 rows=11 loops=1)

2. 9.233 844.526 ↑ 1.7 91,744 1

Append (cost=0.56..223,198.31 rows=155,927 width=68) (actual time=408.873..844.526 rows=91,744 loops=1)

3. 0.002 408.875 ↓ 6.0 12 1

Result (cost=0.56..69,299.43 rows=2 width=68) (actual time=408.872..408.875 rows=12 loops=1)

4. 74.861 408.873 ↓ 6.0 12 1

HashSetOp Except (cost=0.56..69,299.41 rows=2 width=68) (actual time=408.871..408.873 rows=12 loops=1)

5. 42.523 334.012 ↑ 1.6 630,571 1

Append (cost=0.56..64,276.24 rows=1,004,635 width=68) (actual time=0.028..334.012 rows=630,571 loops=1)

6. 0.002 0.043 ↓ 6.0 12 1

Subquery Scan on "*SELECT* 1" (cost=0.56..12.62 rows=2 width=38) (actual time=0.028..0.043 rows=12 loops=1)

7. 0.041 0.041 ↓ 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.027..0.041 rows=12 loops=1)

  • Index Cond: (domain_name = 'bhge.com'::text)
8. 56.572 291.446 ↑ 1.6 630,559 1

Subquery Scan on "*SELECT* 2" (cost=0.00..64,263.62 rows=1,004,633 width=52) (actual time=0.009..291.446 rows=630,559 loops=1)

9. 234.874 234.874 ↑ 1.6 630,559 1

Seq Scan on ns_stopwords (cost=0.00..54,217.29 rows=1,004,633 width=48) (actual time=0.008..234.874 rows=630,559 loops=1)

  • Filter: ((actual = 1) OR (prediction = 1) OR (stopword_probability > '0.5'::double precision))
  • Rows Removed by Filter: 1,466,560
10. 12.547 426.418 ↑ 1.7 91,732 1

Subquery Scan on "*SELECT* 3" (cost=1,000.00..153,898.88 rows=155,925 width=51) (actual time=0.256..426.418 rows=91,732 loops=1)

11. 0.000 413.871 ↑ 1.7 91,732 1

Gather (cost=1,000.00..152,339.63 rows=155,925 width=47) (actual time=0.256..413.871 rows=91,732 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
12. 417.499 417.499 ↑ 2.1 30,577 3 / 3

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

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