explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zh1b

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,149.016 ↓ 0.0 0 1

Limit (cost=0.99..5,278.51 rows=100 width=12) (actual time=1,149.016..1,149.016 rows=0 loops=1)

2. 7.977 1,149.016 ↓ 0.0 0 1

Nested Loop (cost=0.99..27,074.65 rows=513 width=12) (actual time=1,149.016..1,149.016 rows=0 loops=1)

3. 58.546 216.943 ↓ 200.0 308,032 1

Merge Left Join (cost=0.57..13,668.15 rows=1,540 width=20) (actual time=0.014..216.943 rows=308,032 loops=1)

  • Merge Cond: (dp.id = cf.diridx)
  • Filter: (cf.id IS NULL)
4. 158.396 158.396 ↑ 1.0 308,032 1

Index Scan using dirpath_id_key on dirpath dp (cost=0.42..12,847.60 rows=308,032 width=20) (actual time=0.010..158.396 rows=308,032 loops=1)

5. 0.001 0.001 ↓ 0.0 0 1

Index Scan using cloudfiles_diridx_idx on cloudfiles cf (cost=0.14..47.59 rows=230 width=12) (actual time=0.001..0.001 rows=0 loops=1)

6. 924.096 924.096 ↓ 0.0 0 308,032

Index Scan using dirtable_id_key on dirtable dt (cost=0.42..8.70 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=308,032)

  • Index Cond: (id = dp.dtidx)
  • Filter: (genid < (SubPlan 1))
  • Rows Removed by Filter: 1
7.          

SubPlan (forIndex Scan)

8. 0.000 0.000 ↓ 0.0 0 308,032

Index Scan using dirtable_genid_mountinst_key on dirtable_genid (cost=0.15..8.17 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=308,032)

  • Index Cond: (mountinst = dp.mountinst)