explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FXTX

Settings
# exclusive inclusive rows x rows loops node
1. 0.366 16,781.661 ↓ 7.0 362 1

Sort (cost=4,022.76..4,022.89 rows=52 width=156) (actual time=16,781.619..16,781.661 rows=362 loops=1)

  • Sort Key: ((NULLIF(regexp_replace((d.object_cn)::text, '\D'::text, ''::text, 'g'::text), ''::text))::bigint)
  • Sort Method: quicksort Memory: 120kB
2. 3.504 16,781.295 ↓ 7.0 362 1

GroupAggregate (cost=4,018.42..4,021.28 rows=52 width=156) (actual time=16,777.779..16,781.295 rows=362 loops=1)

  • Group Key: d.object_id, a.object_street, a.object_house, a.object_building, a.object_structure, a.object_apartment, p.premises_floor, p.area_value, par.area_value
3. 3.462 16,777.791 ↓ 8.7 452 1

Sort (cost=4,018.42..4,018.55 rows=52 width=160) (actual time=16,777.728..16,777.791 rows=452 loops=1)

  • Sort Key: d.object_id, a.object_building, a.object_structure, a.object_apartment, p.premises_floor, p.area_value, par.area_value
  • Sort Method: quicksort Memory: 121kB
4. 2.824 16,774.329 ↓ 8.7 452 1

Nested Loop Left Join (cost=3.10..4,016.94 rows=52 width=160) (actual time=85.583..16,774.329 rows=452 loops=1)

5. 2.391 15,258.505 ↓ 8.2 425 1

Nested Loop Left Join (cost=2.54..1,642.17 rows=52 width=153) (actual time=67.987..15,258.505 rows=425 loops=1)

6. 2.031 9,966.932 ↓ 7.0 362 1

Nested Loop Left Join (cost=1.99..1,148.87 rows=52 width=115) (actual time=42.858..9,966.932 rows=362 loops=1)

7. 2.971 8,953.111 ↓ 7.0 362 1

Nested Loop Left Join (cost=1.55..903.15 rows=52 width=109) (actual time=42.800..8,953.111 rows=362 loops=1)

8. 2.303 4,885.604 ↓ 7.0 362 1

Nested Loop (cost=1.12..659.63 rows=52 width=99) (actual time=19.575..4,885.604 rows=362 loops=1)

9. 4.265 4.265 ↓ 7.0 362 1

Index Scan using object_adress_index on object_address a (cost=0.56..213.60 rows=52 width=51) (actual time=0.177..4.265 rows=362 loops=1)

  • Index Cond: (((object_street)::text = 'Ленинский'::text) AND ((object_house)::text = '102'::text))
10. 4,879.036 4,879.036 ↑ 1.0 1 362

Index Scan using object_data_pkey on object_data d (cost=0.56..8.58 rows=1 width=63) (actual time=13.478..13.478 rows=1 loops=362)

  • Index Cond: ((object_id)::text = (a.object_id)::text)
11. 4,064.536 4,064.536 ↓ 0.0 0 362

Index Scan using premises_data_pkey on premises_data p (cost=0.43..4.68 rows=1 width=25) (actual time=11.228..11.228 rows=0 loops=362)

  • Index Cond: ((d.object_id)::text = (object_id)::text)
12. 1,011.790 1,011.790 ↑ 1.0 1 362

Index Scan using parcel_data_pkey on parcel_data par (cost=0.43..4.73 rows=1 width=21) (actual time=2.795..2.795 rows=1 loops=362)

  • Index Cond: ((d.object_id)::text = (object_id)::text)
13. 5,289.182 5,289.182 ↑ 3.0 1 362

Index Scan using right_data_pkey on right_data r (cost=0.56..9.46 rows=3 width=53) (actual time=14.200..14.611 rows=1 loops=362)

  • Index Cond: ((d.object_id)::text = (object_id)::text)
14. 1,513.000 1,513.000 ↓ 0.0 0 425

Index Scan using encumbrance_data_pkey on encumbrance_data e (cost=0.56..45.47 rows=20 width=22) (actual time=3.559..3.560 rows=0 loops=425)

  • Index Cond: ((d.object_id)::text = (object_id)::text)