explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nII

Settings
# exclusive inclusive rows x rows loops node
1. 932.351 1,850.354 ↓ 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,850.354 rows=2,378,657 loops=1)

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

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