explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jADF

Settings
# exclusive inclusive rows x rows loops node
1. 0.283 27.843 ↓ 262.0 262 1

Nested Loop (cost=0.53..3.30 rows=1 width=4) (actual time=25.100..27.843 rows=262 loops=1)

2. 25.130 25.130 ↓ 270.0 270 1

Function Scan on load_properties lp (cost=0.25..1.00 rows=1 width=8) (actual time=25.006..25.130 rows=270 loops=1)

  • Filter: ((cid = 3395) AND (is_disabled = 0))
3. 2.430 2.430 ↑ 1.0 1 270

Index Scan using idx_property_gl_settings_cid_property_id_activate_po_posting on property_gl_settings pgs (cost=0.28..2.29 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=270)

  • Index Cond: ((cid = 3395) AND (property_id = lp.property_id))
  • Filter: activate_standard_posting
  • Rows Removed by Filter: 0
Planning time : 7.984 ms