explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r6av

Settings
# exclusive inclusive rows x rows loops node
1. 45.794 307,359.310 ↑ 1.0 1 1

Aggregate (cost=109,799.80..109,799.81 rows=1 width=8) (actual time=307,359.309..307,359.310 rows=1 loops=1)

2.          

CTE filtered_events

3. 307,138.042 307,138.042 ↓ 1.1 110,342 1

CTE Scan on da_events e_2 (cost=105,411.84..107,476.76 rows=103,246 width=428) (actual time=99.537..307,138.042 rows=110,342 loops=1)

4.          

CTE da_events

5. 26.672 306,804.346 ↓ 1.1 110,342 1

Append (cost=0.43..105,411.84 rows=103,246 width=302) (actual time=99.531..306,804.346 rows=110,342 loops=1)

6. 306,777.674 306,777.674 ↓ 1.1 110,342 1

Index Scan using events_org_part_199_created_idx on events_org_part_199 e_1 (cost=0.43..104,895.61 rows=103,246 width=302) (actual time=99.529..306,777.674 rows=110,342 loops=1)

  • Index Cond: ((created <= now()) AND (created >= '2019-10-02 20:57:10+00'::timestamp with time zone))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'fcb0b139-ed68-4220-a7a6-7e56e8214519'::uuid) AND ((event_type)::text = 'USER'::text))
  • Rows Removed by Filter: 207314
7. 307,313.516 307,313.516 ↓ 1.1 110,342 1

CTE Scan on filtered_events e (cost=0.00..2,064.92 rows=103,246 width=0) (actual time=99.542..307,313.516 rows=110,342 loops=1)

Planning time : 49,210.771 ms
Execution time : 307,375.018 ms