explain.depesz.com

PostgreSQL's explain analyze made readable

Result: POqI : 1

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 17,457.304 ↑ 40.0 1 1

Limit (cost=1.280..260,838.910 rows=40 width=16) (actual time=10,340.132..17,457.304 rows=1 loops=1)

2. 0.002 17,457.303 ↑ 161.0 1 1

Subquery Scan on romeo (cost=1.280..1,049,872.730 rows=161 width=16) (actual time=10,340.131..17,457.303 rows=1 loops=1)

3. 0.006 17,457.301 ↑ 161.0 1 1

Nested Loop Left Join (cost=1.280..1,049,871.120 rows=161 width=705) (actual time=10,340.130..17,457.301 rows=1 loops=1)

4. 2,100.443 17,457.235 ↑ 161.0 1 1

Nested Loop Left Join (cost=0.850..1,049,796.960 rows=161 width=27) (actual time=10,340.066..17,457.235 rows=1 loops=1)

  • Filter: ((golf((delta.victor)::text) ~~ 'quebec_xray'::text) OR ((lima.oscar)::text = 'yankee'::text))
  • Rows Removed by Filter: 1,602,866
5. 2,533.856 2,533.856 ↑ 1.0 1,602,867 1

Index Scan using quebec_papa on bravo lima (cost=0.430..99,034.130 rows=1,603,419 width=43) (actual time=0.057..2,533.856 rows=1,602,867 loops=1)

6. 12,822.936 12,822.936 ↑ 1.0 1 1,602,867

Index Scan using kilo_charlie on kilo_alpha delta (cost=0.430..0.580 rows=1 width=36) (actual time=0.008..0.008 rows=1 loops=1,602,867)

  • Index Cond: (lima.quebec_seven = kilo_quebec)
  • Filter: (five = 1)
7. 0.060 0.060 ↑ 1.0 1 1

Index Only Scan using three on two six (cost=0.430..0.450 rows=1 width=16) (actual time=0.060..0.060 rows=1 loops=1)

  • Index Cond: (echo = lima.quebec_seven)
  • Heap Fetches: 1
Planning time : 0.544 ms
Execution time : 17,457.387 ms