explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kpeL

Settings
# exclusive inclusive rows x rows loops node
1. 0.471 65.547 ↓ 19.5 1,247 1

Sort (cost=4,950.23..4,950.39 rows=64 width=156) (actual time=65.495..65.547 rows=1,247 loops=1)

  • Sort Key: ((NULLIF(regexp_replace((d.object_cn)::text, '\D'::text, ''::text, 'g'::text), ''::text))::bigint)
  • Sort Method: quicksort Memory: 352kB
2. 4.234 65.076 ↓ 19.5 1,247 1

GroupAggregate (cost=4,944.79..4,948.31 rows=64 width=156) (actual time=60.753..65.076 rows=1,247 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. 4.001 60.842 ↓ 29.4 1,882 1

Sort (cost=4,944.79..4,944.95 rows=64 width=160) (actual time=60.725..60.842 rows=1,882 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: 461kB
4. 0.827 56.841 ↓ 29.4 1,882 1

Nested Loop Left Join (cost=3.10..4,942.87 rows=64 width=160) (actual time=0.137..56.841 rows=1,882 loops=1)

5. 0.878 43.939 ↓ 27.0 1,725 1

Nested Loop Left Join (cost=2.54..2,020.08 rows=64 width=153) (actual time=0.117..43.939 rows=1,725 loops=1)

6. 1.266 34.332 ↓ 19.5 1,247 1

Nested Loop Left Join (cost=1.99..1,412.94 rows=64 width=115) (actual time=0.096..34.332 rows=1,247 loops=1)

7. 1.177 23.090 ↓ 19.5 1,247 1

Nested Loop Left Join (cost=1.55..1,110.51 rows=64 width=109) (actual time=0.079..23.090 rows=1,247 loops=1)

8. 1.004 14.431 ↓ 19.5 1,247 1

Nested Loop (cost=1.12..810.80 rows=64 width=99) (actual time=0.060..14.431 rows=1,247 loops=1)

9. 0.957 0.957 ↓ 19.5 1,247 1

Index Scan using object_adress_index on object_address a (cost=0.56..261.84 rows=64 width=51) (actual time=0.034..0.957 rows=1,247 loops=1)

  • Index Cond: (((object_street)::text = 'Ленинский'::text) AND ((object_house)::text = '99'::text))
10. 12.470 12.470 ↑ 1.0 1 1,247

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

  • Index Cond: ((object_id)::text = (a.object_id)::text)
11. 7.482 7.482 ↓ 0.0 0 1,247

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

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

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

  • Index Cond: ((d.object_id)::text = (object_id)::text)
13. 8.729 8.729 ↑ 3.0 1 1,247

Index Scan using right_data_pkey on right_data r (cost=0.56..9.46 rows=3 width=53) (actual time=0.007..0.007 rows=1 loops=1,247)

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

Index Scan using encumbrance_data_pkey on encumbrance_data e (cost=0.56..45.47 rows=20 width=22) (actual time=0.007..0.007 rows=0 loops=1,725)

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