explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9HCQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 31,965.867 ↑ 1.0 1 1

Limit (cost=4,351.99..4,351.99 rows=1 width=181) (actual time=31,965.864..31,965.867 rows=1 loops=1)

2. 0.051 31,965.860 ↑ 2,058.0 1 1

Sort (cost=4,351.99..4,357.14 rows=2,058 width=181) (actual time=31,965.860..31,965.860 rows=1 loops=1)

  • Sort Key: (lower(person_roles_org_part_4.valid_range)) DESC, person_roles_org_part_4.sequence DESC
  • Sort Method: quicksort Memory: 25kB
3. 31,965.809 31,965.809 ↑ 2,058.0 1 1

Index Scan using person_roles_org_part_4_organization_uuid_person_uuid_seque_idx on person_roles_org_part_4 (cost=0.56..4,341.70 rows=2,058 width=181) (actual time=24,579.070..31,965.809 rows=1 loops=1)

  • Index Cond: ((organization_uuid = '6b205e8a-daf5-4d46-b515-0695bfe79454'::uuid) AND (person_uuid = '03fadd1e-3a5c-4427-8fd1-1a54831fa0bc'::uuid))
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE))
  • Rows Removed by Filter: 4,723
Planning time : 469.424 ms
Execution time : 31,966.003 ms