explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vEx3 : Optimization for: plan #qlIA

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather (cost=427,694.32..3,691,411.59 rows=2,910 width=74) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=426,694.32..3,690,120.59 rows=1,212 width=74) (actual rows= loops=)

  • Hash Cond: (td.compartment_id = c.id)
3. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=426,692.67..3,690,115.29 rows=1,212 width=70) (actual rows= loops=)

  • Hash Cond: (td.transaction_id = t.id)
4. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on transaction_detail td (cost=31,406.72..3,292,998.88 rows=697,320 width=54) (actual rows= loops=)

  • Recheck Cond: (credit_id IS NULL)
  • Filter: ((NOT is_deleted) AND is_active)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transaction_detail_credit_id_idx (cost=0.00..30,988.33 rows=1,673,568 width=0) (actual rows= loops=)

  • Index Cond: (credit_id IS NULL)
6. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=394,736.48..394,736.48 rows=43,957 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Parallel Index Scan using transaction_contract_id_deposit_date_idx on transaction t (cost=0.56..394,736.48 rows=43,957 width=16) (actual rows= loops=)

  • Index Cond: ((contract_id = 1596) AND (deposit_date >= '2019-01-01 00:00:00-03'::timestamp with time zone))
  • Filter: ((operation_id = 1) AND (equipment_state_id = 1))
8. 0.000 0.000 ↓ 0.0

Hash (cost=1.29..1.29 rows=29 width=8) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on compartment c (cost=0.00..1.29 rows=29 width=8) (actual rows= loops=)