explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kKqJ

Settings
# exclusive inclusive rows x rows loops node
1. 5.642 8,134.572 ↓ 4.8 1,990 1

Nested Loop (cost=1.01..5,167.10 rows=416 width=81) (actual time=3.912..8,134.572 rows=1,990 loops=1)

2. 3,214.770 3,214.770 ↓ 4.8 2,014 1

Index Scan using ix_ciqowncompanyholding_company_latestflag on ciqowncompanyholding ch (cost=0.57..1,654.70 rows=416 width=30) (actual time=1.719..3,214.770 rows=2,014 loops=1)

  • Index Cond: ((ownedcompanyid = 312375) AND (latestflag = 1))
3. 4,914.160 4,914.160 ↑ 1.0 1 2,014

Index Scan using ix_ciqcompany_country on ciqcompany c_owner (cost=0.43..8.43 rows=1 width=55) (actual time=2.420..2.440 rows=1 loops=2,014)

  • Index Cond: (companyid = ch.ownerobjectid)