explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EalW

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 348.419 ↓ 20.0 20 1

Limit (cost=387.81..387.81 rows=1 width=16) (actual time=348.410..348.419 rows=20 loops=1)

2. 90.277 348.414 ↓ 20.0 20 1

Sort (cost=387.81..387.81 rows=1 width=16) (actual time=348.408..348.414 rows=20 loops=1)

  • Sort Key: sort_name_base
  • Sort Method: top-N heapsort Memory: 25kB
3. 126.663 258.137 ↓ 374,755.0 374,755 1

Bitmap Heap Scan on product_kv (cost=383.78..387.80 rows=1 width=16) (actual time=133.511..258.137 rows=374,755 loops=1)

  • Recheck Cond: ((nds && '{1312}'::integer[]) AND (pls && '{15,139}'::integer[]))
  • Heap Blocks: exact=13109
4. 1.395 131.474 ↓ 0.0 0 1

BitmapAnd (cost=383.78..383.78 rows=1 width=0) (actual time=131.474..131.474 rows=0 loops=1)

5. 39.758 39.758 ↓ 487.5 374,855 1

Bitmap Index Scan on fts_product_kv_nds_idx (cost=0.00..17.77 rows=769 width=0) (actual time=39.758..39.758 rows=374,855 loops=1)

  • Index Cond: (nds && '{1312}'::integer[])
6. 90.321 90.321 ↓ 1,004.1 772,159 1

Bitmap Index Scan on fts_product_kv_pls_idx (cost=0.00..365.77 rows=769 width=0) (actual time=90.321..90.321 rows=772,159 loops=1)

  • Index Cond: (pls && '{15,139}'::integer[])
Planning time : 0.137 ms
Execution time : 348.556 ms