explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l5cY

Settings
# exclusive inclusive rows x rows loops node
1. 8.059 14.261 ↓ 8,034.0 8,034 1

Bitmap Heap Scan on product_kv (cost=77.24..81.25 rows=1 width=8) (actual time=6.294..14.261 rows=8,034 loops=1)

  • Recheck Cond: ((nds @> '{"nd": [1310]}'::jsonb) AND ((pls @> '{"pl": [15]}'::jsonb) OR (pls @> '{"pl": [74]}'::jsonb)))
  • Heap Blocks: exact=466
2. 0.037 6.202 ↓ 0.0 0 1

BitmapAnd (cost=77.24..77.24 rows=1 width=0) (actual time=6.202..6.202 rows=0 loops=1)

3. 1.513 1.513 ↓ 20.6 8,226 1

Bitmap Index Scan on fts_product_kv_nds_idx (cost=0.00..22.99 rows=399 width=0) (actual time=1.513..1.513 rows=8,226 loops=1)

  • Index Cond: (nds @> '{"nd": [1310]}'::jsonb)
4. 0.001 4.652 ↓ 0.0 0 1

BitmapOr (cost=53.99..53.99 rows=799 width=0) (actual time=4.652..4.652 rows=0 loops=1)

5. 4.490 4.490 ↓ 77.4 30,889 1

Bitmap Index Scan on fts_product_kv_pls_idx (cost=0.00..26.99 rows=399 width=0) (actual time=4.490..4.490 rows=30,889 loops=1)

  • Index Cond: (pls @> '{"pl": [15]}'::jsonb)
6. 0.161 0.161 ↑ 24.9 16 1

Bitmap Index Scan on fts_product_kv_pls_idx (cost=0.00..26.99 rows=399 width=0) (actual time=0.161..0.161 rows=16 loops=1)

  • Index Cond: (pls @> '{"pl": [74]}'::jsonb)
Planning time : 0.084 ms
Execution time : 15.570 ms