explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yFeY

Settings
# exclusive inclusive rows x rows loops node
1. 273.563 695.606 ↓ 3.0 19,651 1

HashAggregate (cost=1,076.04..1,141.55 rows=6,551 width=100) (actual time=566.972..695.606 rows=19,651 loops=1)

  • Group Key: mailbox_applied_rule_transitions.id, mailbox_applied_rule_transitions.mailbox_id, mailbox_applied_rule_transitions.rule_id, mailbox_applied_rule_transitions.created_at, mailbox_applied_rule_transitions.updated_at, mailbox_applied_rule_transitions.mpi_key, mailbox_applied_rule_transitions.rule_slug, mailbox_applied_rule_transitions.mailbox_slug
2. 257.692 422.043 ↓ 3.0 19,651 1

Hash Join (cost=106.16..945.02 rows=6,551 width=100) (actual time=41.377..422.043 rows=19,651 loops=1)

  • Hash Cond: ((mailbox_applied_rule_transitions.mpi_key)::text = (mailbox_provider_instances.key)::text)
  • Join Filter: (mailbox_applied_rule_transitions.id > mailbox_provider_instances.mailbox_rule_sync_delta_token)
3. 123.042 123.042 ↑ 1.0 19,651 1

Seq Scan on mailbox_applied_rule_transitions (cost=0.00..519.52 rows=19,652 width=100) (actual time=0.018..123.042 rows=19,651 loops=1)

4. 20.813 41.309 ↑ 1.0 2,718 1

Hash (cost=72.18..72.18 rows=2,718 width=25) (actual time=41.303..41.309 rows=2,718 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 192kB
5. 20.496 20.496 ↑ 1.0 2,718 1

Seq Scan on mailbox_provider_instances (cost=0.00..72.18 rows=2,718 width=25) (actual time=0.020..20.496 rows=2,718 loops=1)

Planning time : 1.296 ms
Execution time : 812.232 ms