explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jkFL

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 42,807.804 ↑ 1.0 25 1

Limit (cost=0.68..10,293.37 rows=25 width=117) (actual time=3,540.401..42,807.804 rows=25 loops=1)

  • Output: guid, first_name, second_name, last_name, birth_date, gender, student, staff, austaff, parent, unbound, death_date, death_place, has_death
  • Buffers: shared hit=7059 read=2045
2. 0.188 42,807.775 ↑ 346.7 25 1

Unique (cost=0.68..3,568,684.55 rows=8,668 width=117) (actual time=3,540.399..42,807.775 rows=25 loops=1)

  • Output: guid, first_name, second_name, last_name, birth_date, gender, student, staff, austaff, parent, unbound, death_date, death_place, has_death
  • Buffers: shared hit=7059 read=2045
3. 42,807.587 42,807.587 ↑ 154.8 56 1

Index Scan using mv_person_grid_student_2018_sort_idx on public.mv_person_grid persongrid0_ (cost=0.68..3,568,381.17 rows=8,668 width=117) (actual time=3,540.396..42,807.587 rows=56 loops=1)

  • Output: guid, first_name, second_name, last_name, birth_date, gender, student, staff, austaff, parent, unbound, death_date, death_place, has_death
  • Filter: ((persongrid0_.authority_guid)::text = 'bfc5d9c6-33e8-4c9e-8f5f-862db6b8c357'::text)
  • Rows Removed by Filter: 11970
  • Buffers: shared hit=7059 read=2045