explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aSTL

Settings
# exclusive inclusive rows x rows loops node
1. 0.137 4,128.523 ↑ 1.0 1 1

Nested Loop Left Join (cost=2,068.60..224,716.29 rows=1 width=322) (actual time=4,128.520..4,128.523 rows=1 loops=1)

2. 0.003 4,128.328 ↑ 1.0 1 1

Nested Loop (cost=2,068.18..224,704.73 rows=1 width=1,021) (actual time=4,128.326..4,128.328 rows=1 loops=1)

3. 0.000 4,128.317 ↑ 1.0 1 1

Nested Loop (cost=2,067.90..224,704.44 rows=1 width=1,001) (actual time=4,128.314..4,128.317 rows=1 loops=1)

  • Join Filter: (l.objid = o.id)
4. 42.043 4,165.126 ↑ 1.0 1 1

Gather (cost=2,067.47..224,703.30 rows=1 width=671) (actual time=4,128.269..4,165.126 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 132.351 4,123.083 ↓ 0.0 0 3 / 3

Hash Join (cost=1,067.47..223,703.20 rows=1 width=671) (actual time=2,782.534..4,123.083 rows=0 loops=3)

  • Hash Cond: (r.objectidid = l.objid)
6. 3,990.429 3,990.429 ↑ 1.2 363,736 3 / 3

Parallel Seq Scan on reestr_1 r (cost=0.00..220,930.70 rows=454,670 width=639) (actual time=0.016..3,990.429 rows=363,736 loops=3)

7. 0.003 0.303 ↑ 1.0 1 3 / 3

Hash (cost=1,067.46..1,067.46 rows=1 width=32) (actual time=0.303..0.303 rows=1 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
8. 0.034 0.300 ↑ 1.0 1 3 / 3

Hash Join (cost=23.64..1,067.46 rows=1 width=32) (actual time=0.297..0.300 rows=1 loops=3)

  • Hash Cond: (l.typeid = ot.id)
9. 0.016 0.071 ↑ 271.0 1 3 / 3

Bitmap Heap Scan on lawinstance l (cost=10.53..1,053.64 rows=271 width=36) (actual time=0.070..0.071 rows=1 loops=3)

  • Recheck Cond: (rightholderid = 'cc50e288-1d44-4cf1-8fed-525ff270caa0'::uuid)
  • Heap Blocks: exact=1
10. 0.055 0.055 ↑ 271.0 1 3 / 3

Bitmap Index Scan on lawinstance_rightholderid_idx (cost=0.00..10.46 rows=271 width=0) (actual time=0.055..0.055 rows=1 loops=3)

  • Index Cond: (rightholderid = 'cc50e288-1d44-4cf1-8fed-525ff270caa0'::uuid)
11. 0.007 0.195 ↑ 1.0 3 3 / 3

Hash (cost=13.07..13.07 rows=3 width=4) (actual time=0.194..0.195 rows=3 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
12. 0.188 0.188 ↑ 1.0 3 3 / 3

Seq Scan on objecttype ot (cost=0.00..13.07 rows=3 width=4) (actual time=0.092..0.188 rows=3 loops=3)

  • Filter: ((appobjectid)::text = ANY ('{KVOD.v1.rightOper,KVOD.v1.rightEconomicManag,KVOD.v1.rightPermanentUse}'::text[]))
  • Rows Removed by Filter: 599
13. 0.033 0.033 ↑ 1.0 1 1

Index Scan using obj_pkey on obj o (cost=0.43..1.13 rows=1 width=378) (actual time=0.033..0.033 rows=1 loops=1)

  • Index Cond: (id = r.objectidid)
14. 0.008 0.008 ↑ 1.0 1 1

Index Scan using objecttype_pkey on objecttype oto (cost=0.28..0.29 rows=1 width=24) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (id = o.typeid)
15. 0.012 0.012 ↑ 1.0 1 1

Index Scan using subj_pkey on subj s (cost=0.42..8.01 rows=1 width=78) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: ((id = l.rightholderid) AND (id = 'cc50e288-1d44-4cf1-8fed-525ff270caa0'::uuid))
16.          

SubPlan (for Nested Loop Left Join)

17. 0.001 0.046 ↓ 0.0 0 1

Limit (cost=3.50..3.51 rows=1 width=24) (actual time=0.046..0.046 rows=0 loops=1)

18. 0.010 0.045 ↓ 0.0 0 1

Sort (cost=3.50..3.75 rows=100 width=24) (actual time=0.045..0.045 rows=0 loops=1)

  • Sort Key: (((a.value ->> 'actualDate'::text))::date) DESC
  • Sort Method: quicksort Memory: 25kB
19. 0.035 0.035 ↓ 0.0 0 1

Function Scan on jsonb_array_elements a (cost=0.01..3.00 rows=100 width=24) (actual time=0.035..0.035 rows=0 loops=1)

  • Filter: ((value ->> 'cadastrCost'::text) IS NOT NULL)
  • Rows Removed by Filter: 1