explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FvLS

Settings
# exclusive inclusive rows x rows loops node
1. 13,687.822 14,092.799 ↓ 0.0 0 1

Update on nomenclature (cost=1,482.86..100,003.85 rows=35,737 width=906) (actual time=14,092.799..14,092.799 rows=0 loops=1)

2. 385.419 404.977 ↓ 3.1 110,947 1

Bitmap Heap Scan on nomenclature (cost=1,482.86..100,003.85 rows=35,737 width=906) (actual time=21.838..404.977 rows=110,947 loops=1)

  • Recheck Cond: ((owner_id = 6919) AND ((source_system)::text = 'RKEEPER'::text))
  • Heap Blocks: exact=13690
3. 19.558 19.558 ↓ 6.1 216,498 1

Bitmap Index Scan on idx_nomenclature_iiko_rkeeper_unique (cost=0.00..1,473.93 rows=35,737 width=0) (actual time=19.558..19.558 rows=216,498 loops=1)

  • Index Cond: ((owner_id = 6919) AND ((source_system)::text = 'RKEEPER'::text))
Planning time : 0.174 ms
Execution time : 14,092.959 ms