explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8G1t : Optimization for: Optimization for: Optimization for: sss; plan #icTc; plan #fViG; plan #2fxL

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 5,108.193 14,057.854 ↑ 2.4 10,606,540 1

Nested Loop Left Join (cost=5,284,238.22..6,048,451.27 rows=25,469,900 width=181) (actual time=7,147.803..14,057.854 rows=10,606,540 loops=1)

  • Total runtime: 14602.134 ms
2. 1,099.985 8,949.661 ↑ 2.4 5,303,270 1

Merge Left Join (cost=5,284,238.22..5,411,702.75 rows=12,734,950 width=173) (actual time=7,147.779..8,949.661 rows=5,303,270 loops=1)

  • Merge Cond: ((a_1.cell_id)::text = ((b.cell)::text))
3. 4,524.819 7,849.676 ↑ 2.4 5,303,270 1

Sort (cost=5,283,195.41..5,315,032.79 rows=12,734,950 width=135) (actual time=7,147.774..7,849.676 rows=5,303,270 loops=1)

  • Sort Key: a_1.cell_id
  • Sort Method: external sort Disk: 409016kB
4. 3,324.857 3,324.857 ↑ 2.4 5,303,270 1

Seq Scan on b_rbt_trans_hd_rpt28 a_1 (cost=0.00..298,105.50 rows=12,734,950 width=135) (actual time=151.639..3,324.857 rows=5,303,270 loops=1)

5. 0.000 0.000 ↓ 0.0 0

Sort (cost=1,042.81..1,071.56 rows=11,502 width=44) (never executed)

  • Sort Key: ((b.cell)::text)
6. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_cell_id b (cost=0.00..267.02 rows=11,502 width=44) (never executed)

7. 0.000 0.000 ↑ 1.0 2 5,303,270

Materialize (cost=0.00..1.03 rows=2 width=8) (actual time=0.000..0.000 rows=2 loops=5,303,270)

8. 0.005 0.005 ↑ 1.0 2 1

Seq Scan on dim_currency c (cost=0.00..1.02 rows=2 width=8) (actual time=0.004..0.005 rows=2 loops=1)