explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rHn6

Settings
# exclusive inclusive rows x rows loops node
1. 0.685 9,132.653 ↑ 1.0 1,000 1

Limit (cost=53,921.11..274,354,286.00 rows=1,000 width=579) (actual time=22.906..9,132.653 rows=1,000 loops=1)

  • Buffers: shared hit=361754
2. 6,175.137 9,131.968 ↑ 27,484.2 1,000 1

GroupAggregate (cost=53,921.11..7,538,930,531,341.03 rows=27,484,216 width=579) (actual time=22.904..9,131.968 rows=1,000 loops=1)

  • Group Key: p1.ms1_peak_id
  • Buffers: shared hit=361754
3. 414.620 2,956.831 ↑ 3,982,032.4 2,341,946 1

Nested Loop Left Join (cost=53,921.11..7,492,301,662,995.10 rows=9,325,704,958,647 width=579) (actual time=1.091..2,956.831 rows=2,341,946 loops=1)

  • Buffers: shared hit=361754
4. 4.676 4.676 ↑ 27,456.8 1,001 1

Index Scan using ms1_peak_pkey on ms1_peak p1 (cost=0.44..2,557,381.68 rows=27,484,216 width=547) (actual time=0.019..4.676 rows=1,001 loops=1)

  • Buffers: shared hit=1006
5. 2,056.054 2,537.535 ↑ 145.0 2,340 1,001

Bitmap Heap Scan on ms1_peak p2 (cost=53,920.68..269,210.59 rows=339,311 width=52) (actual time=0.525..2.535 rows=2,340 loops=1,001)

  • Recheck Cond: ((mz >= (p1.mz - (('5'::double precision * p1.mz) / '1000000'::double precision))) AND (mz <= (p1.mz + (('5'::double precision * p1.mz) / '1000000'::double precision))) AND (rt >= (p1.rt - '15'::double precision)) AND (rt <= (p1.rt + '15'::double precision)))
  • Filter: (ms1_peak_id <> p1.ms1_peak_id)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=333642
  • Buffers: shared hit=360748
6. 481.481 481.481 ↑ 144.9 2,341 1,001

Bitmap Index Scan on ms1_peak_mz_rt_idx (cost=0.00..53,835.85 rows=339,311 width=0) (actual time=0.481..0.481 rows=2,341 loops=1,001)

  • Index Cond: ((mz >= (p1.mz - (('5'::double precision * p1.mz) / '1000000'::double precision))) AND (mz <= (p1.mz + (('5'::double precision * p1.mz) / '1000000'::double precision))) AND (rt >= (p1.rt - '15'::double precision)) AND (rt <= (p1.rt + '15'::double precision)))
  • Buffers: shared hit=27106
Planning time : 0.441 ms