explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mMMZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.697 236.066 ↓ 70.1 3,367 1

Unique (cost=1,069.20..1,069.44 rows=48 width=424) (actual time=235.132..236.066 rows=3,367 loops=1)

2.          

CTE parsed_send_data

3. 197.485 197.485 ↓ 70.2 3,369 1

Seq Scan on csat_raven_sends (cost=0.00..1,066.90 rows=48 width=271) (actual time=0.170..197.485 rows=3,369 loops=1)

  • Filter: (((event_timestamp)::date >= '2018-11-20'::date) AND ((event_timestamp)::date < '2018-11-21'::date))
  • Rows Removed by Filter: 6194
4. 35.203 235.369 ↓ 70.2 3,369 1

Sort (cost=2.30..2.42 rows=48 width=424) (actual time=235.131..235.369 rows=3,369 loops=1)

  • Sort Key: parsed_send_data.ref_id, parsed_send_data.time_sent
  • Sort Method: quicksort Memory: 991kB
5. 200.166 200.166 ↓ 70.2 3,369 1

CTE Scan on parsed_send_data (cost=0.00..0.96 rows=48 width=424) (actual time=0.176..200.166 rows=3,369 loops=1)