explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FqWiM

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 170.924 ↓ 0.0 0 1

Limit (cost=0.430..90,524.890 rows=3 width=43) (actual time=170.924..170.924 rows=0 loops=1)

2. 0.005 170.923 ↓ 0.0 0 1

Append (cost=0.430..90,524.890 rows=3 width=43) (actual time=170.923..170.923 rows=0 loops=1)

3. 57.896 57.896 ↓ 0.0 0 1

Index Scan using lima_yankee on uniform_three (cost=0.430..31,324.260 rows=1 width=43) (actual time=57.896..57.896 rows=0 loops=1)

  • Index Cond: (tango > (zulu_golf() - 'foxtrot'::interval))
  • Filter: ((november five NOT NULL) AND (tango < bravo) AND ((lima_quebec)::text = 'romeo'::text) AND (bravo >= (zulu_golf() - 'delta'::interval)) AND (bravo <= (zulu_golf() - 'oscar'::interval)) AND ((((november)::bigint * 1000))::double precision < echo('uniform_whiskey'::text, bravo)) AND (golf((echo('uniform_whiskey'::text, bravo) - (((november)::bigint * 1000))::double precision)) > 'two'::double precision))
  • Rows Removed by Filter: 31739
4. 57.006 57.006 ↓ 0.0 0 1

Index Scan using juliet on zulu_lima (cost=0.430..29,650.190 rows=1 width=43) (actual time=57.006..57.006 rows=0 loops=1)

  • Index Cond: (tango > (zulu_golf() - 'foxtrot'::interval))
  • Filter: ((november five NOT NULL) AND (tango < bravo) AND ((lima_quebec)::text = 'romeo'::text) AND (bravo >= (zulu_golf() - 'delta'::interval)) AND (bravo <= (zulu_golf() - 'oscar'::interval)) AND ((((november)::bigint * 1000))::double precision < echo('uniform_whiskey'::text, bravo)) AND (golf((echo('uniform_whiskey'::text, bravo) - (((november)::bigint * 1000))::double precision)) > 'two'::double precision))
  • Rows Removed by Filter: 31700
5. 56.016 56.016 ↓ 0.0 0 1

Index Scan using sierra on seven (cost=0.430..29,550.420 rows=1 width=43) (actual time=56.016..56.016 rows=0 loops=1)

  • Index Cond: (tango > (zulu_golf() - 'foxtrot'::interval))
  • Filter: ((november five NOT NULL) AND (tango < bravo) AND ((lima_quebec)::text = 'romeo'::text) AND (bravo >= (zulu_golf() - 'delta'::interval)) AND (bravo <= (zulu_golf() - 'oscar'::interval)) AND ((((november)::bigint * 1000))::double precision < echo('uniform_whiskey'::text, bravo)) AND (golf((echo('uniform_whiskey'::text, bravo) - (((november)::bigint * 1000))::double precision)) > 'two'::double precision))
  • Rows Removed by Filter: 31622