explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5Rra

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 4.555 ↑ 1.0 1 1

Aggregate (cost=40,085.28..40,085.29 rows=1 width=8) (actual time=4.555..4.555 rows=1 loops=1)

2.          

CTE da_events

3. 0.001 0.192 ↑ 61,719.0 1 1

Append (cost=0.43..38,179.17 rows=61,719 width=241) (actual time=0.192..0.192 rows=1 loops=1)

4. 0.191 0.191 ↑ 61,719.0 1 1

Index Scan using events_org_part_2_created_idx on events_org_part_2 e_1 (cost=0.43..37,870.58 rows=61,719 width=241) (actual time=0.191..0.191 rows=1 loops=1)

  • Index Cond: (created >= '2019-06-03 19:08:29-07'::timestamp with time zone)
  • Filter: (upper_inf(valid_range) AND (organization_uuid = '5d2881bc-e8d3-42fa-abb0-a504a975e889'::uuid) AND ((event_type)::text = 'USER'::text))
5. 0.009 4.549 ↓ 0.0 0 1

Hash Join (cost=440.27..1,906.11 rows=1 width=0) (actual time=4.548..4.549 rows=0 loops=1)

  • Hash Cond: (e.submitter_uuid = p.person_uuid)
6. 0.196 0.196 ↑ 61,719.0 1 1

CTE Scan on da_events e (cost=0.00..1,234.38 rows=61,719 width=16) (actual time=0.196..0.196 rows=1 loops=1)

7. 0.002 4.344 ↓ 0.0 0 1

Hash (cost=440.26..440.26 rows=1 width=16) (actual time=4.343..4.344 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
8. 4.342 4.342 ↓ 0.0 0 1

Index Scan using persons_org_valid_range_gist on persons p (cost=0.41..440.26 rows=1 width=16) (actual time=4.342..4.342 rows=0 loops=1)

  • Index Cond: ((organization_uuid = '5d2881bc-e8d3-42fa-abb0-a504a975e889'::uuid) AND (valid_range @> '2019-07-03 19:08:29-07'::timestamp with time zone))
  • Filter: ((is_visible IS TRUE) AND ((target_name)::text ~~* '%call tree%'::text))
  • Rows Removed by Filter: 456
Planning time : 4.472 ms
Execution time : 4.674 ms