explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kliF : audience v2

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.098 ↓ 0.0 0 1

Nested Loop (cost=1.62..2.76 rows=1 width=12) (actual time=0.098..0.098 rows=0 loops=1)

  • Join Filter: (((c.last_notified_released < pre."time") OR (c.last_notified_released IS NULL)) AND ((pre.phone)::text = (c.phone)::text))
  • Rows Removed by Join Filter: 3
2. 0.008 0.008 ↑ 1.0 3 1

Seq Scan on contestants c (cost=0.00..1.02 rows=3 width=20) (actual time=0.007..0.008 rows=3 loops=1)

  • Filter: (active AND (NOT blacklist))
  • Rows Removed by Filter: 4
3. 0.002 0.087 ↑ 2.0 1 3

Materialize (cost=1.62..1.72 rows=2 width=20) (actual time=0.027..0.029 rows=1 loops=3)

4. 0.003 0.085 ↑ 2.0 1 1

Subquery Scan on pre (cost=1.62..1.71 rows=2 width=20) (actual time=0.079..0.085 rows=1 loops=1)

  • Filter: (((pre.event_code)::text = 'MAXED'::text) OR ((pre.event_code)::text = 'SOONER'::text))
  • Rows Removed by Filter: 6
5. 0.009 0.082 ↑ 1.0 7 1

Unique (cost=1.62..1.69 rows=7 width=25) (actual time=0.071..0.082 rows=7 loops=1)

6. 0.059 0.073 ↓ 1.0 71 1

Sort (cost=1.62..1.65 rows=68 width=25) (actual time=0.069..0.073 rows=71 loops=1)

  • Sort Key: event_attempts.phone, event_attempts."time" DESC
  • Sort Method: quicksort Memory: 30kB
7. 0.014 0.014 ↓ 1.0 71 1

Seq Scan on event_attempts (cost=0.00..1.20 rows=68 width=25) (actual time=0.005..0.014 rows=71 loops=1)

Planning time : 0.330 ms
Execution time : 0.130 ms