explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FpgV : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #XHT8; plan #VT6p; plan #3B7m; plan #i57iN; plan #kmS; plan #1cmJ; plan #O7Gn; plan #KqxH

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.004 21.951 ↑ 1.4 41 1

Limit (cost=7,355.84..7,355.98 rows=57 width=1,425) (actual time=21.939..21.951 rows=41 loops=1)

2. 0.101 21.947 ↑ 1.4 41 1

Sort (cost=7,355.84..7,355.98 rows=57 width=1,425) (actual time=21.938..21.947 rows=41 loops=1)

  • Sort Key: lima_delta1.quebec_seven
  • Sort Method: quicksort Memory: 189kB
3. 0.034 21.846 ↑ 1.4 41 1

Nested Loop Left Join (cost=1.40..7,354.18 rows=57 width=1,425) (actual time=0.103..21.846 rows=41 loops=1)

  • Join Filter: (lima_delta1.juliet = uniform_delta1.quebec_seven)
4. 0.040 21.812 ↑ 1.4 41 1

Nested Loop Left Join (cost=1.12..7,350.83 rows=57 width=753) (actual time=0.096..21.812 rows=41 loops=1)

  • Join Filter: (lima_delta1.four_sierra = romeo1.quebec_seven)
  • Rows Removed by Join Filter: 82
5. 0.041 21.772 ↑ 1.4 41 1

Nested Loop Left Join (cost=1.12..7,339.22 rows=57 width=705) (actual time=0.087..21.772 rows=41 loops=1)

6. 0.049 21.649 ↑ 1.4 41 1

Nested Loop Left Join (cost=0.84..7,240.72 rows=57 width=580) (actual time=0.082..21.649 rows=41 loops=1)

7. 21.518 21.518 ↑ 1.4 41 1

Index Scan using papa_yankee on foxtrot quebec_sierra (cost=0.56..7,124.62 rows=57 width=295) (actual time=0.076..21.518 rows=41 loops=1)

  • Index Cond: ((lima_romeo)::text = 'quebec_quebec'::text)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five NULL)) AND (mike_seven >= 'golf_xray'::timestamp without time zone) AND (juliet = 81))
  • Rows Removed by Filter: 26,998
8. 0.082 0.082 ↑ 1.0 1 41

Index Scan using sierra_delta on sierra_three whiskey (cost=0.28..2.04 rows=1 width=285) (actual time=0.002..0.002 rows=1 loops=41)

  • Index Cond: (lima_delta1.lima_echo = quebec_seven)
9. 0.082 0.082 ↑ 1.0 1 41

Index Scan using kilo on golf_five uniform_romeo (cost=0.28..1.73 rows=1 width=125) (actual time=0.002..0.002 rows=1 loops=41)

  • Index Cond: (lima_delta1.two_romeo = quebec_seven)
10. 0.000 0.000 ↑ 4.3 3 41

Materialize (cost=0.00..1.19 rows=13 width=48) (actual time=0.000..0.000 rows=3 loops=41)

11. 0.006 0.006 ↑ 4.3 3 1

Seq Scan on tango four_uniform (cost=0.00..1.13 rows=13 width=48) (actual time=0.006..0.006 rows=3 loops=1)

12. 0.000 0.000 ↑ 1.0 1 41

Materialize (cost=0.27..2.50 rows=1 width=664) (actual time=0.000..0.000 rows=1 loops=41)

13. 0.005 0.005 ↑ 1.0 1 1

Index Scan using two_delta on echo mike_quebec (cost=0.27..2.49 rows=1 width=664) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (quebec_seven = 81)
Planning time : 0.948 ms
Execution time : 22.088 ms