explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cUSF

Settings
# exclusive inclusive rows x rows loops node
1. 1,093.850 2,047.835 ↓ 1.0 2,378,657 1

Merge Left Join (cost=0.72..128,002.13 rows=2,368,245 width=521) (actual time=0.017..2,047.835 rows=2,378,657 loops=1)

  • Merge Cond: (sc.sample_collection_id = sr.sample_collection_id)
2. 949.971 949.971 ↓ 1.0 2,368,588 1

Index Scan using sample_collection_id_pkey on sample_collection sc (cost=0.43..115,354.49 rows=2,368,245 width=517) (actual time=0.007..949.971 rows=2,368,588 loops=1)

3. 4.014 4.014 ↑ 1.0 19,422 1

Index Scan using idx_sample_rejections_sample_collection_id on sample_rejections sr (cost=0.29..563.64 rows=19,422 width=8) (actual time=0.006..4.014 rows=19,422 loops=1)