explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6K8U

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 82.604 ↓ 1.8 24 1

Sort (cost=14,820.28..14,820.31 rows=13 width=872) (actual time=82.600..82.604 rows=24 loops=1)

  • Sort Key: surveys.scheduling_date
  • Sort Method: quicksort Memory: 32kB
2. 0.094 82.565 ↓ 1.8 24 1

Hash Join (cost=4,297.79..14,820.03 rows=13 width=872) (actual time=69.499..82.565 rows=24 loops=1)

  • Hash Cond: (surveys.current_client_area_token_id = client_area_tokens.id)
3. 34.988 49.104 ↑ 7.0 292 1

Bitmap Heap Scan on surveys (cost=1,546.22..12,063.09 rows=2,046 width=872) (actual time=17.034..49.104 rows=292 loops=1)

  • Recheck Cond: (account_owner_id = 1,576)
  • Filter: ((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: 83,638
  • Heap Blocks: exact=6,888
4. 14.116 14.116 ↓ 1.0 83,930 1

Bitmap Index Scan on surveys_account_owner_id_idx (cost=0.00..1,545.71 rows=83,372 width=0) (actual time=14.116..14.116 rows=83,930 loops=1)

  • Index Cond: (account_owner_id = 1,576)
5. 0.898 33.367 ↑ 1.0 2,802 1

Hash (cost=2,715.57..2,715.57 rows=2,880 width=4) (actual time=33.366..33.367 rows=2,802 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 131kB
6. 32.469 32.469 ↑ 1.0 2,802 1

Seq Scan on client_area_tokens (cost=0.00..2,715.57 rows=2,880 width=4) (actual time=0.022..32.469 rows=2,802 loops=1)

  • 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: 118,461
Planning time : 5.920 ms
Execution time : 82.812 ms