explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qm7V : Optimization for: plan #Dymx

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 301.484 588.551 ↓ 261.5 89,420 1

Hash Join (cost=309.61..334.26 rows=342 width=622) (actual time=289.307..588.551 rows=89,420 loops=1)

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

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

3. 104.891 272.021 ↓ 1,325.0 90,102 1

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

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

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

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

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

  • Filter: (zg_status = 0)
  • Rows Removed by Filter: 324
6. 53.520 71.360 ↑ 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.004..0.008 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. 17.840 17.840 ↑ 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.002..0.002 rows=10 loops=8,920)

  • Index Cond: (cadastral_sys_id = f_zemesgabali_query.zgab_id)
Planning time : 0.410 ms
Execution time : 593.371 ms