explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bCIG : Join Query

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 111.040 5,831.544 ↓ 2.4 86,983 1

Unique (cost=9.38..376,533.66 rows=36,555 width=1,359) (actual time=0.090..5,831.544 rows=86,983 loops=1)

2. 3,769.254 5,720.504 ↑ 1.0 1,013,242 1

Merge Join (cost=9.38..373,946.68 rows=1,034,792 width=1,359) (actual time=0.090..5,720.504 rows=1,013,242 loops=1)

  • Merge Cond: ((kilo_sierra.uniform ->> 'november_charlie'::text) = (november_uniform.uniform ->> 'november_charlie'::text))
3. 201.719 201.719 ↑ 1.0 99,210 1

Index Scan using kilo_tango on delta kilo_sierra (cost=0.42..32,806.66 rows=99,297 width=538) (actual time=0.003..201.719 rows=99,210 loops=1)

4. 326.064 1,749.531 ↓ 1.6 1,098,941 1

Materialize (cost=0.42..318,842.29 rows=684,733 width=789) (actual time=0.008..1,749.531 rows=1,098,941 loops=1)

5. 1,423.467 1,423.467 ↑ 1.0 683,851 1

Index Scan using november_seven on juliet november_uniform (cost=0.42..317,130.45 rows=684,733 width=789) (actual time=0.005..1,423.467 rows=683,851 loops=1)

Planning time : 2.425 ms
Execution time : 5,836.026 ms