explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DxNN

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 64.417 ↑ 1.0 1 1

Finalize Aggregate (cost=12,636.93..12,636.94 rows=1 width=8) (actual time=62.252..64.417 rows=1 loops=1)

2. 29.516 64.412 ↓ 2.0 2 1

Gather (cost=12,636.82..12,636.93 rows=1 width=8) (actual time=62.244..64.412 rows=2 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 0.006 34.896 ↑ 1.0 1 2 / 2

Partial Aggregate (cost=11,636.82..11,636.83 rows=1 width=8) (actual time=34.895..34.896 rows=1 loops=2)

4. 0.287 34.890 ↓ 1.5 12 2 / 2

Nested Loop (cost=0.42..11,636.80 rows=8 width=0) (actual time=34.827..34.890 rows=12 loops=2)

5. 24.796 24.796 ↑ 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.055..24.796 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
6. 9.807 9.807 ↓ 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=4) (actual time=0.007..0.007 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.244 ms
Execution time : 64.546 ms