explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LdC6 : Optimization for: plan #oOum

Settings

Optimization path:

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

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

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

Bitmap Heap Scan on "SnapshotV2" (cost=47.86..7,308.79 rows=25 width=208) (actual time=453.709..510.640 rows=1,327 loops=1)

  • Recheck Cond: ((session ->> 'stage'::text) = 'production'::text)
  • Rows Removed by Index Recheck: 11582
  • Filter: ((upper((station ->> 'hostname'::text)) ~~ '%UMC%'::text) AND ((((invocation ->> 'start_time'::text))::double precision >= '1565561169'::double precision) OR (((invocation ->> 'end_time'::text))::double precision >= '1565561169'::double precision)) AND ((((invocation ->> 'start_time'::text))::double precision <= '1565588169'::double precision) OR (((invocation ->> 'end_time'::text))::double precision <= '1565588169'::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 snapshotv2__session__stage__idx (cost=0.00..47.86 rows=2,058 width=0) (actual time=39.157..39.157 rows=346,063 loops=1)

  • Index Cond: ((session ->> 'stage'::text) = 'production'::text)
Planning time : 0.211 ms
Execution time : 517.721 ms