explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XmCB

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 30.731 ↑ 1.0 1 1

Aggregate (cost=303,262.86..303,262.87 rows=1 width=8) (actual time=30.731..30.731 rows=1 loops=1)

2.          

CTE da_events

3. 0.000 0.040 ↑ 215,307.0 1 1

Append (cost=0.43..204,254.95 rows=215,307 width=284) (actual time=0.040..0.040 rows=1 loops=1)

4. 0.040 0.040 ↑ 215,307.0 1 1

Index Scan using events_org_part_1_created_idx on events_org_part_1 e_1 (cost=0.43..203,178.42 rows=215,307 width=284) (actual time=0.040..0.040 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 = 'a214aa3a-e70c-41bc-8bad-db588e255138'::uuid) AND ((event_type)::text = 'USER'::text))
5. 0.009 30.724 ↓ 0.0 0 1

Hash Join (cost=92,010.08..99,007.84 rows=28 width=0) (actual time=30.723..30.724 rows=0 loops=1)

  • Hash Cond: (e.submitter_uuid = p.person_uuid)
6. 0.045 0.045 ↑ 215,307.0 1 1

CTE Scan on da_events e (cost=0.00..4,306.14 rows=215,307 width=16) (actual time=0.045..0.045 rows=1 loops=1)

7. 0.004 30.670 ↓ 0.0 0 1

Hash (cost=92,009.98..92,009.98 rows=8 width=16) (actual time=30.669..30.670 rows=0 loops=1)

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

Bitmap Heap Scan on persons p (cost=3,250.92..92,009.98 rows=8 width=16) (actual time=30.666..30.666 rows=0 loops=1)

  • Recheck Cond: ((organization_uuid = 'a214aa3a-e70c-41bc-8bad-db588e255138'::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: 19100
  • Heap Blocks: exact=2968
9. 6.282 6.282 ↑ 4.5 19,100 1

Bitmap Index Scan on persons_org_valid_range_gist (cost=0.00..3,250.91 rows=86,550 width=0) (actual time=6.282..6.282 rows=19,100 loops=1)

  • Index Cond: ((organization_uuid = 'a214aa3a-e70c-41bc-8bad-db588e255138'::uuid) AND (valid_range @> '2019-07-03 19:08:29-07'::timestamp with time zone))
Planning time : 4.658 ms
Execution time : 30.861 ms