explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jp5 : Optimization for: Optimization for: plan #FiPB; plan #ajQE

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 28.963 249.640 ↑ 1.8 10,961 1

Nested Loop Left Join (cost=2.090..155,372.230 rows=19,465 width=1,195) (actual time=0.060..249.640 rows=10,961 loops=1)

2. 2.867 154.911 ↑ 1.8 10,961 1

Nested Loop Left Join (cost=1.540..112,268.650 rows=19,465 width=1,115) (actual time=0.032..154.911 rows=10,961 loops=1)

3. 3.346 86.278 ↑ 1.8 10,961 1

Nested Loop (cost=0.980..72,937.210 rows=19,465 width=1,106) (actual time=0.024..86.278 rows=10,961 loops=1)

4. 13.398 13.398 ↑ 2.0 11,589 1

Index Scan using uniform on november quebec_three (cost=0.420..25,309.360 rows=23,689 width=1,106) (actual time=0.012..13.398 rows=11,589 loops=1)

  • Index Cond: ((romeo_seven = 'romeo_alpha'::text) AND (two = 86))
5. 69.534 69.534 ↑ 1.0 1 11,589

Index Only Scan using oscar_bravo on four juliet (cost=0.560..2.010 rows=1 width=33) (actual time=0.006..0.006 rows=1 loops=11,589)

  • Index Cond: (alpha = quebec_three.quebec_seven)
  • Heap Fetches: 10,961
6. 65.766 65.766 ↑ 1.0 1 10,961

Index Scan using bravo on five echo (cost=0.560..2.020 rows=1 width=42) (actual time=0.006..0.006 rows=1 loops=10,961)

  • Index Cond: (alpha = quebec_three.quebec_seven)
7. 65.766 65.766 ↑ 1.0 1 10,961

Index Scan using oscar_seven on seven quebec_sierra (cost=0.560..1.960 rows=1 width=49) (actual time=0.006..0.006 rows=1 loops=10,961)

  • Index Cond: (alpha = quebec_three.quebec_seven)
Planning time : 0.495 ms
Execution time : 249.970 ms