explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fZXt

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 1,631.610 ↑ 786.0 2 1

Sort (cost=91,374.07..91,378.00 rows=1,572 width=545) (actual time=1,631.609..1,631.610 rows=2 loops=1)

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

Hash Join (cost=11,330.06..91,290.61 rows=1,572 width=545) (actual time=1,021.374..1,631.582 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: 180315
3. 206.375 206.375 ↓ 1.0 180,317 1

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

4. 252.451 485.346 ↑ 1.0 248,847 1

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

  • Buckets: 65536 Batches: 8 Memory Usage: 3107kB
5. 232.895 232.895 ↑ 1.0 248,847 1

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