explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WqS : spik

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 2,861.586 ↑ 1.0 1 1

Aggregate (cost=278,354.54..278,354.55 rows=1 width=8) (actual time=2,861.585..2,861.586 rows=1 loops=1)

2. 298.651 2,861.582 ↓ 0.0 0 1

Seq Scan on employee_applied_marketoffs (cost=276,094.58..278,354.54 rows=1 width=4) (actual time=2,861.582..2,861.582 rows=0 loops=1)

  • Filter: ((approval_flag <> 1) AND (NOT (hashed SubPlan 1)) AND (from_date = '2018-11-30'::date) AND (customer_id = 167) AND (active_flag = 1))
  • Rows Removed by Filter: 59626
3.          

SubPlan (forSeq Scan)

4. 2,562.931 2,562.931 ↓ 1.0 32,640 1

Index Only Scan using idx_attendances on attendances (cost=0.56..276,013.83 rows=32,299 width=4) (actual time=2,077.825..2,562.931 rows=32,640 loops=1)

  • Index Cond: (start_date = '2018-11-30 00:00:00'::timestamp without time zone)
  • Heap Fetches: 47035