explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Esu

Settings
# exclusive inclusive rows x rows loops node
1. 0.219 0.745 ↓ 29.0 29 1

WindowAgg (cost=0.250..14.360 rows=1 width=147) (actual time=0.241..0.745 rows=29 loops=1)

2. 0.028 0.120 ↓ 29.0 29 1

Nested Loop (cost=0.250..7.770 rows=1 width=185) (actual time=0.051..0.120 rows=29 loops=1)

  • Join Filter: (papa_tango.papa_tango @@ papa_kilo.xray_hotel)
  • Rows Removed by Join Filter: 16
3. 0.031 0.031 ↑ 1.0 1 1

Function Scan on xray_yankee papa_tango (cost=0.250..0.260 rows=1 width=32) (actual time=0.031..0.031 rows=1 loops=1)

4. 0.061 0.061 ↓ 1.0 45 1

Seq Scan on sierra papa_kilo (cost=0.000..6.970 rows=43 width=153) (actual time=0.015..0.061 rows=45 loops=1)

  • Filter: ((NOT seven) AND (juliet = 'tango'::text))
  • Rows Removed by Filter: 33
5.          

SubPlan (forWindowAgg)

6. 0.116 0.406 ↑ 1.0 1 29

Aggregate (cost=6.550..6.560 rows=1 width=8) (actual time=0.013..0.014 rows=1 loops=29)

7. 0.290 0.290 ↑ 1.0 1 29

Seq Scan on quebec_four five (cost=0.000..6.550 rows=1 width=0) (actual time=0.007..0.010 rows=1 loops=29)

  • Filter: (yankee = papa_kilo.quebec_seven)
  • Rows Removed by Filter: 43