explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dymx

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 227.551 580.473 ↓ 263.0 89,420 1

Hash Join (cost=309.61..334.26 rows=340 width=622) (actual time=357.483..580.473 rows=89,420 loops=1)

  • Hash Cond: (f_ipasumi_query.mip_id = f_zemesgabali_query.mip_id)
2. 18.816 18.816 ↓ 5.7 5,667 1

Function Scan on f_ipasumi_query (cost=0.25..10.25 rows=1,000 width=4) (actual time=18.549..18.816 rows=5,667 loops=1)

3. 110.183 334.106 ↓ 1,325.0 90,102 1

Hash (cost=308.51..308.51 rows=68 width=626) (actual time=334.106..334.106 rows=90,102 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 32 (originally 1) Memory Usage: 4,033kB
4. 68.140 223.923 ↓ 1,325.0 90,102 1

Nested Loop (cost=4.65..308.51 rows=68 width=626) (actual time=31.159..223.923 rows=90,102 loops=1)

5. 39.823 39.823 ↓ 1,784.0 8,920 1

Function Scan on f_zemesgabali_query (cost=0.25..12.75 rows=5 width=8) (actual time=31.128..39.823 rows=8,920 loops=1)

  • Filter: (zg_status = 0)
  • Rows Removed by Filter: 324
6. 89.200 115.960 ↑ 1.4 10 8,920

Bitmap Heap Scan on tbl_management_units_1_0_lv b (cost=4.40..59.01 rows=14 width=626) (actual time=0.005..0.013 rows=10 loops=8,920)

  • Recheck Cond: (cadastral_sys_id = f_zemesgabali_query.zgab_id)
  • Filter: (the_geom IS NOT NULL)
  • Heap Blocks: exact=38,762
7. 26.760 26.760 ↑ 1.4 10 8,920

Bitmap Index Scan on idx_cadastral_sys_id_1_0_lv (cost=0.00..4.40 rows=14 width=0) (actual time=0.003..0.003 rows=10 loops=8,920)

  • Index Cond: (cadastral_sys_id = f_zemesgabali_query.zgab_id)
Planning time : 0.396 ms
Execution time : 586.409 ms