explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2l87

Settings
# exclusive inclusive rows x rows loops node
1. 25.825 54.583 ↓ 3.0 24 1

Gather Merge (cost=12,636.93..12,637.85 rows=8 width=872) (actual time=52.261..54.583 rows=24 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 0.039 28.758 ↓ 1.5 12 2 / 2

Sort (cost=11,636.92..11,636.94 rows=8 width=872) (actual time=28.756..28.758 rows=12 loops=2)

  • Sort Key: surveys.scheduling_date
  • Sort Method: quicksort Memory: 26kB
3. 0.849 28.719 ↓ 1.5 12 2 / 2

Nested Loop (cost=0.42..11,636.80 rows=8 width=872) (actual time=28.677..28.719 rows=12 loops=2)

4. 19.464 19.464 ↑ 1.2 1,401 2 / 2

Parallel Seq Scan on client_area_tokens (cost=0.00..2,216.28 rows=1,694 width=4) (actual time=0.019..19.464 rows=1,401 loops=2)

  • Filter: ((client_email IS NOT NULL) OR (client_cell_phone_number IS NOT NULL) OR (requester_email IS NOT NULL) OR (requester_cell_phone_number IS NOT NULL))
  • Rows Removed by Filter: 59,230
5. 8.406 8.406 ↓ 0.0 0 2,802 / 2

Index Scan using surveys_current_client_area_token_id_idx on surveys (cost=0.42..5.55 rows=1 width=872) (actual time=0.006..0.006 rows=0 loops=2,802)

  • Index Cond: (current_client_area_token_id = client_area_tokens.id)
  • Filter: ((account_owner_id = 1,576) AND (flow_responsible_account_id = 1,576) AND ((current_status)::text = ANY ('{with_expert,budgeting,budgeting_by_cilia_pass,with_analyst,analyzing,analyzing_by_cilia_pass}'::text[])))
  • Rows Removed by Filter: 1
Planning time : 1.430 ms
Execution time : 54.737 ms