explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E7hp

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

WindowAgg (cost=216,186.14..216,197.50 rows=505 width=815) (actual time=820.039..820.039 rows=0 loops=1)

2. 0.015 820.039 ↓ 0.0 0 1

Sort (cost=216,186.14..216,187.40 rows=505 width=807) (actual time=820.038..820.039 rows=0 loops=1)

  • Sort Key: uphoria_event.event_id, uphoria_event.create_dt_tm, uphoria_event.org_event_id
  • Sort Method: quicksort Memory: 25kB
3. 820.024 820.024 ↓ 0.0 0 1

Seq Scan on uphoria_event (cost=0.00..216,163.46 rows=505 width=807) (actual time=820.024..820.024 rows=0 loops=1)

  • Filter: (featured AND (parent_org_id = '2631b21f-77d6-4f8f-8cf7-8dab675e6e33'::uuid))
  • Rows Removed by Filter: 608387