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 10517.575 ↑ 1.0 8761 1

Seq Scan on test1 t1 (cost=0.00..1787086.55 rows=8761 width=4) (actual time=12.877..10517.575 rows=8761 loops=1)

  • Total runtime: 10522.346 ms
2.          

SubPlan (forSeq Scan)

3. 140.176 10451.873 ↑ 1.0 1 8761

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

4. 6684.643 10311.697 ↓ 0.0 0 8761

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

  • Recheck Cond: ((category)::text = 'A'::text)
  • Filter: (test1_id = $0)
5. 3627.054 3627.054 ↑ 1.0 1631 8761

Bitmap Index Scan on test_category_idx (cost=0.00..36.49 rows=1631 width=0) (actual time=0.414..0.414 rows=1631 loops=8761)

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