explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lUP7

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 2,073.323 ↑ 786.0 2 1

Sort (cost=92,634.17..92,638.10 rows=1,572 width=763) (actual time=2,073.321..2,073.323 rows=2 loops=1)

  • Sort Key: molecules.rec_id, batches.hash
  • Sort Method: quicksort Memory: 27kB
2. 0.040 2,073.296 ↑ 786.0 2 1

Nested Loop Left Join (cost=11,330.76..92,550.71 rows=1,572 width=763) (actual time=1,294.450..2,073.296 rows=2 loops=1)

3. 0.019 2,073.226 ↑ 786.0 2 1

Nested Loop Left Join (cost=11,330.48..92,056.00 rows=1,572 width=456) (actual time=1,294.406..2,073.226 rows=2 loops=1)

4. 1,334.393 2,073.145 ↑ 786.0 2 1

Hash Join (cost=11,330.06..91,282.75 rows=1,572 width=449) (actual time=1,294.364..2,073.145 rows=2 loops=1)

  • Hash Cond: ((batches.rec_id)::text = (molecules.rec_id)::text)
  • Join Filter: ((molecules.synonyms && '{3d32844b-2b7e-4d7d-b5b5-416e026d72c9,93a383c7-5ea3-4063-a24e-26f1a7b82114}'::character varying[]) OR ((batches.hash)::text = ANY ('{3d32844b-2b7e-4d7d-b5b5-416e026d72c9,93a383c7-5ea3-4063-a24e-26f1a7b82114}'::text[])))
  • Rows Removed by Join Filter: 180,315
5. 255.584 255.584 ↓ 1.0 180,317 1

Seq Scan on batches (cost=0.00..55,297.11 rows=178,911 width=407) (actual time=0.013..255.584 rows=180,317 loops=1)

6. 238.560 483.168 ↑ 1.0 248,847 1

Hash (cost=5,788.47..5,788.47 rows=248,847 width=54) (actual time=483.168..483.168 rows=248,847 loops=1)

  • Buckets: 65,536 Batches: 8 Memory Usage: 3,107kB
7. 244.608 244.608 ↑ 1.0 248,847 1

Seq Scan on molecules (cost=0.00..5,788.47 rows=248,847 width=54) (actual time=0.014..244.608 rows=248,847 loops=1)

8. 0.062 0.062 ↓ 0.0 0 2

Index Scan using ix_cauldron_sirnas_rec_id on sirnas (cost=0.42..0.48 rows=1 width=23) (actual time=0.031..0.031 rows=0 loops=2)

  • Index Cond: ((rec_id)::text = (molecules.rec_id)::text)
9. 0.030 0.030 ↓ 0.0 0 2

Index Scan using ix_cauldron_guides_rec_id on guides (cost=0.28..0.30 rows=1 width=22) (actual time=0.015..0.015 rows=0 loops=2)

  • Index Cond: ((rec_id)::text = (molecules.rec_id)::text)