explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5Dqo

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

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

  • Merge Cond: (sc.sample_collection_id = sr.sample_collection_id)
2. 907.577 907.577 ↓ 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.011..907.577 rows=2,368,588 loops=1)

3. 3.829 3.829 ↑ 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.009..3.829 rows=19,422 loops=1)