explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UZzO

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.100 ↑ 2.0 1 1

Nested Loop (cost=4,582.52..4,597.26 rows=2 width=187) (actual time=0.100..0.100 rows=1 loops=1)

  • Output: c.id, c.name
  • Inner Unique: true
  • Buffers: shared hit=8
2. 0.001 0.092 ↑ 2.0 1 1

Unique (cost=4,582.11..4,582.12 rows=2 width=4) (actual time=0.092..0.092 rows=1 loops=1)

  • Output: part.case_id
  • Buffers: shared hit=4
3. 0.009 0.091 ↑ 2.0 1 1

Sort (cost=4,582.11..4,582.11 rows=2 width=4) (actual time=0.091..0.091 rows=1 loops=1)

  • Output: part.case_id
  • Sort Key: part.case_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=4
4. 0.001 0.082 ↑ 2.0 1 1

Nested Loop (cost=0.29..4,582.10 rows=2 width=4) (actual time=0.081..0.082 rows=1 loops=1)

  • Output: part.case_id
  • Inner Unique: true
  • Buffers: shared hit=4
5. 0.011 0.011 ↑ 1,570.0 1 1

Seq Scan on safekids.participant part (cost=0.00..25.70 rows=1,570 width=8) (actual time=0.010..0.011 rows=1 loops=1)

  • Output: part.id, part.case_id, part.person_id, part.participant_type_id, part.participant_status_id, part.status_type_id
  • Buffers: shared hit=1
6. 0.070 0.070 ↑ 1.0 1 1

Index Scan using person_pkey on safekids.person per (cost=0.29..2.90 rows=1 width=4) (actual time=0.070..0.070 rows=1 loops=1)

  • Output: per.id, per.gender_id, per.firstname, per.lastname, per.patrname, per.birth_dt, per.birth_year, per.citizenship_id, per.birthplace, per.address_reg, per.address_fact, per.employment_type_id, per.employment_place, per.phone, per.email, per.social_links, per.mother_initials, per.father_initials, per.employment_existence, per.employment_status, per.employment_dt, per.contacts
  • Index Cond: (per.id = part.person_id)
  • Filter: (fullname(per.lastname, per.firstname, per.patrname) @@ to_tsquery('долларrewrew | Юдита'::text))
  • Buffers: shared hit=3
7. 0.007 0.007 ↑ 1.0 1 1

Index Scan using case_pkey on safekids."case" c (cost=0.41..7.57 rows=1 width=187) (actual time=0.007..0.007 rows=1 loops=1)

  • Output: c.id, c.category_id, c.create_dt, c.steal_dt, c.state_id, c.direction_id, c.executor_id, c.country_id, c.central_authority_id, c.fabula, c.delete_dt, c.name
  • Index Cond: (c.id = part.case_id)
  • Buffers: shared hit=4
Planning time : 0.275 ms
Execution time : 0.132 ms