explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CyOF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0 1 1

Nested Loop (cost=0..0 rows=0 width=0) (actual rows=1 loops=1)

2. 0.000 0.000 ↓ 0.0 1 1

Seq Scan on terms_acceptance terms_acceptance (cost=0..0 rows=0 width=0) (actual rows=1 loops=1)

  • Filter: active
3. 0.000 0.000 ↓ 0.0 1 1

GroupAggregate (cost=0..0 rows=0 width=0) (actual rows=1 loops=1)

  • Group Key: terms_acceptance_1.property_id
  • Filter: (max(terms_acceptance_event_log.event_date) <= (CURRENT_DATE - '5 days'::interval day))
4. 0.000 0.000 ↓ 0.0 2 1

Sort (cost=0..0 rows=0 width=0) (actual rows=2 loops=1)

  • Sort Key: terms_acceptance_1.property_id
  • Sort Method: quicksort Memory: 25kB
5. 0.000 0.000 ↓ 0.0 2 1

Nested Loop (cost=0..0 rows=0 width=0) (actual rows=2 loops=1)

6. 0.000 0.000 ↓ 0.0 1 1

Seq Scan on terms_acceptance terms_acceptance_1 (cost=0..0 rows=0 width=0) (actual rows=1 loops=1)

  • Filter: ((NOT accepted) AND active AND (invited_count >= 1) AND (reminded_count = 0))
7. 0.000 0.000 ↓ 0.0 2 1

Seq Scan on terms_acceptance_event_log terms_acceptance_event_log (cost=0..0 rows=0 width=0) (actual rows=2 loops=1)

  • Filter: ((event_name)::text = 'INVITED'::text)