explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4jS3 : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #gWgH; plan #lj5Ms; plan #B8eq; plan #Yty9; plan #Lheu; plan #27c; plan #qUXb; plan #6xFD; plan #YOFp; plan #tvR9; plan #vDLc

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.010 22.279 ↑ 2.0 122 1

Limit (cost=7,261.72..7,262.35 rows=250 width=967) (actual time=22.254..22.279 rows=122 loops=1)

2. 0.144 22.269 ↑ 8.2 122 1

Sort (cost=7,261.72..7,264.22 rows=1,000 width=967) (actual time=22.253..22.269 rows=122 loops=1)

  • Sort Key: lima_delta1.mike_seven
  • Sort Method: quicksort Memory: 270kB
3. 0.085 22.125 ↑ 8.2 122 1

Nested Loop Left Join (cost=0.83..7,216.89 rows=1,000 width=967) (actual time=0.046..22.125 rows=122 loops=1)

  • Join Filter: (lima_delta1.juliet = uniform1.quebec_seven)
4. 22.040 22.040 ↑ 8.2 122 1

Index Scan using papa_yankee on foxtrot quebec_sierra (cost=0.56..7,199.40 rows=1,000 width=295) (actual time=0.037..22.040 rows=122 loops=1)

  • Index Cond: ((lima_romeo)::text = 'quebec_quebec'::text)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five NULL)) AND (juliet = 81) AND ((mike_seven)::date >= 'golf'::date))
  • Rows Removed by Filter: 27,068
5. 0.000 0.000 ↑ 1.0 1 122

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

6. 0.006 0.006 ↑ 1.0 1 1

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

  • Index Cond: (quebec_seven = 81)
Planning time : 0.227 ms
Execution time : 22.416 ms