explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zy9Tv : Optimization for: plan #H4oY

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.004 21.577 ↑ 1.0 10 1

Limit (cost=133.25..143.39 rows=10 width=1,505) (actual time=21.155..21.577 rows=10 loops=1)

2. 9.517 21.573 ↑ 261.3 10 1

Bitmap Heap Scan on uba_user_102151 (cost=133.25..2,783.44 rows=2,613 width=1,505) (actual time=21.154..21.573 rows=10 loops=1)

  • Recheck Cond: ((profiling -> 'adobe_tt_exp_v2'::text) ? 'migration test booking engine 2018=hermes'::text)
  • Heap Blocks: exact=10
3. 12.056 12.056 ↓ 16.1 41,983 1

Bitmap Index Scan on uba_user_adobe_tt_exp_v2_sid_id_gin_idx_102151_simple (cost=0.00..132.60 rows=2,613 width=0) (actual time=12.056..12.056 rows=41,983 loops=1)

  • Index Cond: ((profiling -> 'adobe_tt_exp_v2'::text) ? 'migration test booking engine 2018=hermes'::text)
Planning time : 0.291 ms
Execution time : 21.655 ms