explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VFAc

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 0.024 ↓ 13.5 27 1

Append (cost=0.00..2.34 rows=2 width=4) (actual time=0.018..0.024 rows=27 loops=1)

2. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on lnk_entity_flg (cost=0.00..1.00 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (dwh_partition_id = 0)
3. 0.011 0.011 ↓ 27.0 27 1

Seq Scan on lnk_entity_flg_0 (cost=0.00..1.34 rows=1 width=4) (actual time=0.007..0.011 rows=27 loops=1)

  • Filter: (dwh_partition_id = 0)