explain.depesz.com

A tool for finding a real cause for slow queries.

Result: KxF

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 65.702 10,517.575 ↑ 1.0 8,761 1

Seq Scan on test1 t1 (cost=0.00..1,787,086.55 rows=8,761 width=4) (actual time=12.877..10,517.575 rows=8,761 loops=1)

  • Total runtime: 10522.346 ms
2.          

SubPlan (forSeq Scan)

3. 140.176 10,451.873 ↑ 1.0 1 8,761

Aggregate (cost=203.96..203.97 rows=1 width=4) (actual time=1.193..1.193 rows=1 loops=8,761)

4. 6,684.643 10,311.697 ↓ 0.0 0 8,761

Bitmap Heap Scan on test2 t2 (cost=36.49..203.95 rows=1 width=4) (actual time=1.109..1.177 rows=0 loops=8,761)

  • Recheck Cond: ((category)::text = 'A'::text)
  • Filter: (test1_id = $0)
5. 3,627.054 3,627.054 ↑ 1.0 1,631 8,761

Bitmap Index Scan on test_category_idx (cost=0.00..36.49 rows=1,631 width=0) (actual time=0.414..0.414 rows=1,631 loops=8,761)

  • Index Cond: ((category)::text = 'A'::text)