explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qaBe

Settings
# exclusive inclusive rows x rows loops node
1. 0.181 2,636.420 ↓ 2.2 152 1

Nested Loop (cost=949,032.790..1,933,927.420 rows=68 width=24) (actual time=1,500.989..2,636.420 rows=152 loops=1)

2. 1,207.387 2,635.631 ↓ 2.2 152 1

Seq Scan on bravo oscar_romeo (cost=949,032.350..1,933,352.300 rows=68 width=17) (actual time=1,500.970..2,635.631 rows=152 loops=1)

  • Filter: ((tango >= 'india'::date) AND (tango <= 'oscar_four'::date) AND (oscar_xray <> 0) AND (NOT (mike delta 1)) AND (three = 'two'::text) AND (foxtrot = 'four'::text))
  • Rows Removed by Filter: 4832895
3.          

SubPlan (for Seq Scan)

4. 1,428.244 1,428.244 ↑ 1.7 473 1

Seq Scan on bravo juliet_india (cost=0.000..949,030.360 rows=796 width=9) (actual time=62.132..1,428.244 rows=473 loops=1)

  • Filter: ((tango >= 'india'::date) AND (tango <= 'oscar_four'::date) AND (victor = 1))
  • Rows Removed by Filter: 4832574
5. 0.608 0.608 ↑ 1.0 1 152

Index Scan using alpha on november whiskey (cost=0.430..8.450 rows=1 width=15) (actual time=0.004..0.004 rows=1 loops=152)

  • Index Cond: (juliet_romeo = oscar_romeo.juliet_romeo)
Planning time : 0.362 ms