explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jkKb : audience v3

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.103 ↓ 0.0 0 1

Nested Loop (cost=1.62..2.76 rows=1 width=12) (actual time=0.103..0.103 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.009 0.009 ↑ 1.0 3 1

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

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

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

4. 0.004 0.090 ↑ 2.0 1 1

Subquery Scan on pre (cost=1.62..1.71 rows=2 width=20) (actual time=0.084..0.090 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.008 0.086 ↑ 1.0 7 1

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

6. 0.060 0.078 ↓ 1.0 71 1

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

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

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

Planning time : 0.320 ms
Execution time : 0.136 ms