explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dSUv

Settings
# exclusive inclusive rows x rows loops node
1. 2.066 893.364 ↓ 701.6 21,749 1

Nested Loop (cost=1.13..224,097.55 rows=31 width=17) (actual time=872.913..893.364 rows=21,749 loops=1)

2. 0.005 872.873 ↓ 5.5 11 1

Subquery Scan on "ANY_subquery" (cost=0.56..223,977.97 rows=2 width=64) (actual time=872.866..872.873 rows=11 loops=1)

3. 18.388 872.868 ↓ 5.5 11 1

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

4. 9.109 854.480 ↑ 1.7 91,744 1

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

5. 0.003 408.873 ↓ 6.0 12 1

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

6. 73.892 408.870 ↓ 6.0 12 1

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

7. 42.419 334.978 ↑ 1.6 630,571 1

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

8. 0.002 0.044 ↓ 6.0 12 1

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

9. 0.042 0.042 ↓ 6.0 12 1

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

  • Index Cond: (domain_name = 'bhge.com'::text)
10. 55.788 292.515 ↑ 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.006..292.515 rows=630,559 loops=1)

11. 236.727 236.727 ↑ 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.006..236.727 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
12. 13.724 436.498 ↑ 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..436.498 rows=91,732 loops=1)

13. 0.000 422.774 ↑ 1.7 91,732 1

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

  • Workers Planned: 2
  • Workers Launched: 2
14. 427.242 427.242 ↑ 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.020..427.242 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
15. 18.425 18.425 ↓ 131.8 1,977 11

Index Scan using related_domain_observations_source_index on related_domain_observations (cost=0.56..59.64 rows=15 width=51) (actual time=0.017..1.675 rows=1,977 loops=11)

  • Index Cond: ((source = ""ANY_subquery"".source) AND (source_entity = ""ANY_subquery"".source_entity))
Planning time : 0.276 ms
Execution time : 894.287 ms