explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mlQ9

Settings
# exclusive inclusive rows x rows loops node
1. 2.442 950.300 ↓ 214.1 6,636 1

Group (cost=224,098.32..224,098.47 rows=31 width=17) (actual time=946.406..950.300 rows=6,636 loops=1)

  • Group Key: related_domain_observations.domain_name
2. 62.462 947.858 ↓ 701.6 21,749 1

Sort (cost=224,098.32..224,098.39 rows=31 width=17) (actual time=946.403..947.858 rows=21,749 loops=1)

  • Sort Key: related_domain_observations.domain_name
  • Sort Method: quicksort Memory: 2,156kB
3. 2.069 885.396 ↓ 701.6 21,749 1

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

4. 0.005 864.693 ↓ 5.5 11 1

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

5. 17.892 864.688 ↓ 5.5 11 1

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

6. 9.290 846.796 ↑ 1.7 91,744 1

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

7. 0.002 410.688 ↓ 6.0 12 1

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

8. 72.769 410.686 ↓ 6.0 12 1

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

9. 42.450 337.917 ↑ 1.6 630,571 1

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

10. 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.028..0.044 rows=12 loops=1)

11. 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.028..0.042 rows=12 loops=1)

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

13. 238.945 238.945 ↑ 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..238.945 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
14. 13.730 426.818 ↑ 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.261..426.818 rows=91,732 loops=1)

15. 0.000 413.088 ↑ 1.7 91,732 1

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

  • Workers Planned: 2
  • Workers Launched: 2
16. 417.722 417.722 ↑ 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.018..417.722 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
17. 18.634 18.634 ↓ 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.694 rows=1,977 loops=11)

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