explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v6uaD : Optimization for: Optimization for: plan #VFAc; plan #HFmb

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 1.852 ↑ 11.8 11 1

Append (cost=0.00..81.17 rows=130 width=56) (actual time=0.780..1.852 rows=11 loops=1)

  • Buffers: shared hit=292
2. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on lnk_entity_flg a (cost=0.00..1.00 rows=1 width=48) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (lnk_lvl = 1)
  • Buffers: shared hit=1
3. 0.776 0.776 ↑ 1.0 1 1

Index Scan using lnk_entity_flg_1_lnk_lvl on lnk_entity_flg_1 a_1 (cost=0.14..8.16 rows=1 width=160) (actual time=0.775..0.776 rows=1 loops=1)

  • Index Cond: (lnk_lvl = 1)
  • Buffers: shared hit=108
4. 0.710 0.710 ↑ 60.0 2 1

Index Scan using lnk_entity_flg_2_lnk_lvl on lnk_entity_flg_2 a_2 (cost=0.15..44.41 rows=120 width=48) (actual time=0.709..0.710 rows=2 loops=1)

  • Index Cond: (lnk_lvl = 1)
  • Buffers: shared hit=108
5. 0.193 0.360 ↑ 1.0 8 1

Bitmap Heap Scan on lnk_entity_flg_0 a_3 (cost=4.34..27.60 rows=8 width=160) (actual time=0.178..0.360 rows=8 loops=1)

  • Recheck Cond: (lnk_lvl = 1)
  • Heap Blocks: exact=59
  • Buffers: shared hit=75
6. 0.167 0.167 ↓ 474.4 3,795 1

Bitmap Index Scan on lnk_entity_flg_0_lnk_lvl (cost=0.00..4.34 rows=8 width=0) (actual time=0.167..0.167 rows=3,795 loops=1)

  • Index Cond: (lnk_lvl = 1)
  • Buffers: shared hit=16
Planning time : 4.161 ms
Execution time : 1.899 ms