explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KQLGV

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 69.995 ↑ 14,989.0 2 1

Nested Loop (cost=24,334.06..165,201.55 rows=29,978 width=27) (actual time=64.424..69.995 rows=2 loops=1)

2. 0.026 51.272 ↑ 14.6 72 1

Nested Loop (cost=24,333.35..70,258.93 rows=1,053 width=8) (actual time=30.188..51.272 rows=72 loops=1)

3. 0.074 42.750 ↑ 38.8 72 1

Nested Loop (cost=24,332.79..47,323.67 rows=2,792 width=12) (actual time=26.783..42.750 rows=72 loops=1)

4. 0.054 24.820 ↑ 38.8 72 1

HashAggregate (cost=24,332.21..24,360.13 rows=2,792 width=4) (actual time=24.791..24.820 rows=72 loops=1)

  • Group Key: u0.financialcollectionid
5. 0.014 24.766 ↑ 38.8 72 1

Nested Loop (cost=1.57..24,325.23 rows=2,792 width=4) (actual time=1.144..24.766 rows=72 loops=1)

6. 0.009 17.707 ↑ 42.2 5 1

Nested Loop (cost=1.00..7,492.45 rows=211 width=4) (actual time=1.131..17.707 rows=5 loops=1)

7. 15.943 15.943 ↑ 17.8 5 1

Index Scan using ix_ciqfinperiod on ciqfinperiod u2 (cost=0.43..6,299.54 rows=89 width=4) (actual time=1.113..15.943 rows=5 loops=1)

  • Index Cond: (companyid = 292387)
  • Filter: (latestperiodflag = 1)
  • Rows Removed by Filter: 370
8. 1.755 1.755 ↑ 6.0 1 5

Index Scan using ix_ciqfininstance on ciqfininstance u1 (cost=0.56..13.34 rows=6 width=8) (actual time=0.348..0.351 rows=1 loops=5)

  • Index Cond: (financialperiodid = u2.financialperiodid)
9. 7.045 7.045 ↑ 21.4 14 5

Index Scan using ix_ciqfincollection on ciqfincollection u0 (cost=0.57..76.78 rows=300 width=8) (actual time=0.823..1.409 rows=14 loops=5)

  • Index Cond: (financialinstanceid = u1.financialinstanceid)
10. 17.856 17.856 ↑ 1.0 1 72

Index Scan using ix_ciqfincollection_filter_flags on ciqfincollection (cost=0.57..8.21 rows=1 width=8) (actual time=0.248..0.248 rows=1 loops=72)

  • Index Cond: (financialcollectionid = u0.financialcollectionid)
11. 8.496 8.496 ↑ 1.0 1 72

Index Scan using ix_financialinstanceid_multi on ciqfininstance (cost=0.56..8.20 rows=1 width=4) (actual time=0.117..0.118 rows=1 loops=72)

  • Index Cond: ((financialinstanceid = ciqfincollection.financialinstanceid) AND (latestfilingforinstanceflag = 1))
  • Filter: (latestforfinancialperiodflag = 1)
12. 18.720 18.720 ↓ 0.0 0 72

Index Scan using pk_ciqfincollectiondata on ciqfincollectiondata (cost=0.71..89.88 rows=28 width=27) (actual time=0.260..0.260 rows=0 loops=72)

  • Index Cond: ((financialcollectionid = ciqfincollection.financialcollectionid) AND (dataitemid = 4364))