explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oOum

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 6.294 516.934 ↓ 53.1 1,327 1

Sort (cost=7,309.370..7,309.430 rows=25 width=208) (actual time=516.654..516.934 rows=1,327 loops=1)

  • Sort Key: ((charlie_three ->> 'delta'::text))
  • Sort Method: quicksort Memory: 374kB
2. 471.483 510.640 ↓ 53.1 1,327 1

Bitmap Heap Scan on romeo_juliet (cost=47.860..7,308.790 rows=25 width=208) (actual time=453.709..510.640 rows=1,327 loops=1)

  • Recheck Cond: ((seven_sierra ->> 'alpha'::text) = 'whiskey_india'::text)
  • Rows Removed by Index Recheck: 11582
  • Filter: ((yankee((foxtrot ->> 'whiskey_delta'::text)) ~~ 'charlie_golf'::text) AND ((((charlie_three ->> 'delta'::text))::double precision >= 'romeo_two'::double precision) OR (((charlie_three ->> 'seven_alpha'::text))::double precision >= 'romeo_two'::double precision)) AND ((((charlie_three ->> 'delta'::text))::double precision <= 'juliet'::double precision) OR (((charlie_three ->> 'seven_alpha'::text))::double precision <= 'juliet'::double precision)))
  • Rows Removed by Filter: 344736
  • Heap Blocks: exact=41872 lossy=26455
3. 39.157 39.157 ↓ 168.2 346,063 1

Bitmap Index Scan on tango (cost=0.000..47.860 rows=2,058 width=0) (actual time=39.157..39.157 rows=346,063 loops=1)

  • Index Cond: ((seven_sierra ->> 'alpha'::text) = 'whiskey_india'::text)
Planning time : 0.211 ms
Execution time : 517.721 ms