explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n9QD

Settings
# exclusive inclusive rows x rows loops node
1. 69.304 20,320.182 ↓ 0.0 0 1

Update on campaign_contact (cost=0.56..7,562.08 rows=95 width=334) (actual time=20,320.182..20,320.182 rows=0 loops=1)

2. 20,250.878 20,250.878 ↑ 9.5 10 1

Index Scan using campaign_contact_campaign_id_index on campaign_contact (cost=0.56..7,562.08 rows=95 width=334) (actual time=23.649..20,250.878 rows=10 loops=1)

  • Index Cond: (campaign_id = 4,393)
  • Filter: ((assignment_id IS NOT NULL) AND (message_status = 'needsResponse'::text) AND (updated_at < (now() - '01:00:00'::interval)))
  • Rows Removed by Filter: 113,187
Planning time : 22.634 ms
Execution time : 20,320.315 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
_500_campaign_contact_updated_at 0.432 ms 10 0.043 ms