explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tEjX

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 28,027.545 ↑ 1.0 1 1

Limit (cost=107,179.800..107,179.800 rows=1 width=73) (actual time=28,027.540..28,027.545 rows=1 loops=1)

2. 7.656 28,027.539 ↑ 6,956.0 1 1

Sort (cost=107,179.800..107,197.190 rows=6,956 width=73) (actual time=28,027.539..28,027.539 rows=1 loops=1)

  • Sort Key: ((papa_lima.tango_whiskey = ANY ('seven_delta'::bpchar[]))) DESC, ((papa_lima.xray + papa_lima.quebec_alpha)) DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 57.923 28,019.883 ↓ 3.2 22,460 1

WindowAgg (cost=106,327.690..107,145.020 rows=6,956 width=73) (actual time=27,960.152..28,019.883 rows=22,460 loops=1)

4. 20.835 27,961.960 ↓ 3.2 22,460 1

Sort (cost=106,327.690..106,345.080 rows=6,956 width=68) (actual time=27,960.140..27,961.960 rows=22,460 loops=1)

  • Sort Key: ((papa_lima.tango_whiskey = ANY ('seven_delta'::bpchar[]))), ((papa_lima.xray + papa_lima.quebec_alpha)) DESC
  • Sort Method: quicksort Memory: 2523kB
5. 50.234 27,941.125 ↓ 3.2 22,460 1

WindowAgg (cost=2.570..105,883.750 rows=6,956 width=68) (actual time=27,936.885..27,941.125 rows=22,460 loops=1)

6. 20.309 27,890.891 ↓ 3.2 22,460 1

Nested Loop Left Join (cost=2.570..105,083.810 rows=6,956 width=36) (actual time=5.207..27,890.891 rows=22,460 loops=1)

  • Join Filter: (papa_lima.tango_whiskey = 'yankee_alpha'::bpchar)
  • Rows Removed by Join Filter: 4
7. 13.359 27,803.202 ↓ 3.2 22,460 1

Nested Loop Left Join (cost=2.140..88,119.890 rows=6,956 width=38) (actual time=5.196..27,803.202 rows=22,460 loops=1)

  • Join Filter: (papa_lima.tango_whiskey = 'four_xray'::bpchar)
  • Rows Removed by Join Filter: 79
8. 21.714 321.263 ↓ 3.2 22,460 1

Nested Loop Left Join (cost=1.570..67,427.100 rows=6,956 width=32) (actual time=3.039..321.263 rows=22,460 loops=1)

  • Join Filter: (papa_lima.tango_whiskey = 'delta_sierra_alpha'::bpchar)
  • Rows Removed by Join Filter: 4
9. 30.029 30.029 ↓ 3.2 22,460 1

Index Scan using three on india_alpha papa_lima (cost=0.430..22,737.120 rows=6,956 width=25) (actual time=0.013..30.029 rows=22,460 loops=1)

  • Index Cond: (seven_bravo = 292710)
  • Filter: ((xray + quebec_alpha) <= 'oscar'::timestamp without time zone)
10. 0.000 269.520 ↓ 0.0 0 22,460

Nested Loop (cost=1.140..6.320 rows=1 width=11) (actual time=0.012..0.012 rows=0 loops=22,460)

11. 12.004 269.520 ↓ 0.0 0 22,460

Nested Loop (cost=0.850..4.320 rows=1 width=15) (actual time=0.012..0.012 rows=0 loops=22,460)

12. 157.220 157.220 ↓ 0.0 0 22,460

Index Scan using papa_charlie on tango_six four_kilo (cost=0.420..2.280 rows=1 width=19) (actual time=0.007..0.007 rows=0 loops=22,460)

  • Index Cond: (yankee_india = papa_lima.mike_november)
13. 100.296 100.296 ↑ 1.0 1 56

Index Scan using six on india_oscar two (cost=0.420..2.040 rows=1 width=4) (actual time=1.791..1.791 rows=1 loops=56)

  • Index Cond: (kilo_bravo = four_kilo.hotel)
  • Filter: (kilo_golf = 'delta_sierra_alpha'::bpchar)
  • Rows Removed by Filter: 0
14. 12.485 12.485 ↓ 0.0 0 55

Index Scan using quebec_yankee on delta_sierra_charlie four_whiskey (cost=0.290..2.010 rows=1 width=4) (actual time=0.227..0.227 rows=0 loops=55)

  • Index Cond: (alpha = four_kilo.foxtrot)
  • Filter: ((echo)::text <> november ('juliet'::text[]))
  • Rows Removed by Filter: 1
15. 27,468.580 27,468.580 ↑ 1.0 1 22,460

Index Scan using quebec_quebec on delta_alpha mike_juliet (cost=0.570..2.870 rows=1 width=10) (actual time=1.223..1.223 rows=1 loops=22,460)

  • Index Cond: (four_zulu = papa_lima.mike_november)
16. 67.380 67.380 ↓ 0.0 0 22,460

Index Scan using zulu on golf four_india (cost=0.430..2.330 rows=1 width=11) (actual time=0.003..0.003 rows=0 loops=22,460)

  • Index Cond: (four_tango = papa_lima.mike_november)
Planning time : 8.098 ms
Execution time : 28,027.644 ms