explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j2kZ

Settings
# exclusive inclusive rows x rows loops node
1. 588.661 3,604.472 ↑ 1.0 100,000 1

Hash Semi Join (cost=64,359.28..91,278.44 rows=100,000 width=105) (actual time=2,789.607..3,604.472 rows=100,000 loops=1)

  • Hash Cond: ((storage_email_storage.safe_email)::text = (storage_email_storage_1.safe_email)::text)
2. 227.037 227.037 ↓ 1.0 837,868 1

Seq Scan on storage_email_storage (cost=0.00..23,608.80 rows=837,280 width=105) (actual time=0.018..227.037 rows=837,868 loops=1)

3. 57.480 2,788.774 ↑ 1.0 100,000 1

Hash (cost=63,109.28..63,109.28 rows=100,000 width=67) (actual time=2,788.773..2,788.774 rows=100,000 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 10,681kB
4. 0.000 2,731.294 ↑ 1.0 100,000 1

Limit (cost=50,441.80..62,109.28 rows=100,000 width=67) (actual time=2,527.043..2,731.294 rows=100,000 loops=1)

5. 199.870 2,731.362 ↑ 7.0 100,000 1

Gather Merge (cost=50,441.80..131,849.79 rows=697,734 width=67) (actual time=2,527.039..2,731.362 rows=100,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 2,397.629 2,531.492 ↑ 10.3 33,740 3 / 3

Sort (cost=49,441.78..50,313.95 rows=348,867 width=67) (actual time=2,518.907..2,531.492 rows=33,740 loops=3)

  • Sort Key: storage_email_storage_1.safe_email
  • Sort Method: top-N heapsort Memory: 29,071kB
  • Worker 0: Sort Method: top-N heapsort Memory: 29,177kB
  • Worker 1: Sort Method: top-N heapsort Memory: 29,185kB
7. 133.863 133.863 ↑ 1.2 279,289 3 / 3

Parallel Seq Scan on storage_email_storage storage_email_storage_1 (cost=0.00..18,724.67 rows=348,867 width=67) (actual time=0.041..133.863 rows=279,289 loops=3)

Planning time : 0.558 ms
Execution time : 3,642.489 ms