explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lsjq : Optimization for: plan #T8Up

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.004 494.953 ↑ 1.0 1 1

Aggregate (cost=18,407,155.80..18,407,155.81 rows=1 width=8) (actual time=494.953..494.953 rows=1 loops=1)

2. 494.927 494.949 ↓ 0.0 0 1

Seq Scan on c4_call_entry (cost=0.00..18,405,314.75 rows=736,420 width=16) (actual time=494.948..494.949 rows=0 loops=1)

  • Filter: (((account_id = 'ca5870fb-9978-403a-94a9-2993d0c7e582'::uuid) AND (from_user_id = 'ca5870fb-9978-403a-94a9-2993d0c7e582'::uuid)) OR (alternatives: SubPlan 1 or hashed SubPlan 2))
  • Rows Removed by Filter: 1,473,293
3.          

SubPlan (for Seq Scan)

4. 0.000 0.000 ↓ 0.0 0

Index Scan using call_entry_targets_call_entry_id_index on c4_call_entry_targets (cost=0.42..12.46 rows=1 width=0) (never executed)

  • Index Cond: (call_entry_id = c4_call_entry.id)
  • Filter: (user_id = 'ca5870fb-9978-403a-94a9-2993d0c7e582'::uuid)
5. 0.002 0.022 ↓ 0.0 0 1

Bitmap Heap Scan on c4_call_entry_targets c4_call_entry_targets_1 (cost=15.96..1,572.37 rows=456 width=16) (actual time=0.022..0.022 rows=0 loops=1)

  • Recheck Cond: (user_id = 'ca5870fb-9978-403a-94a9-2993d0c7e582'::uuid)
6. 0.020 0.020 ↓ 0.0 0 1

Bitmap Index Scan on call_entry_targets_user_id_index (cost=0.00..15.85 rows=456 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: (user_id = 'ca5870fb-9978-403a-94a9-2993d0c7e582'::uuid)
Planning time : 0.293 ms
Execution time : 495.033 ms