explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L9nI

Settings
# exclusive inclusive rows x rows loops node
1. 0.093 723.893 ↑ 38,820.8 4 1

Nested Loop (cost=24,334.00..547,876.87 rows=155,283 width=27) (actual time=653.967..723.893 rows=4 loops=1)

2. 0.081 666.170 ↑ 10.3 102 1

Nested Loop (cost=24,333.29..70,225.81 rows=1,052 width=8) (actual time=596.483..666.170 rows=102 loops=1)

3. 0.086 648.953 ↑ 13.7 204 1

Nested Loop (cost=24,332.73..47,307.06 rows=2,790 width=12) (actual time=594.097..648.953 rows=204 loops=1)

4. 0.218 592.563 ↑ 13.7 204 1

HashAggregate (cost=24,332.15..24,360.05 rows=2,790 width=4) (actual time=592.473..592.563 rows=204 loops=1)

  • Group Key: u0.financialcollectionid
5. 0.052 592.345 ↑ 13.7 204 1

Nested Loop (cost=1.57..24,325.18 rows=2,790 width=4) (actual time=14.946..592.345 rows=204 loops=1)

6. 0.026 540.173 ↑ 21.1 10 1

Nested Loop (cost=1.00..7,492.45 rows=211 width=4) (actual time=11.850..540.173 rows=10 loops=1)

7. 495.502 495.502 ↑ 17.8 5 1

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

  • Index Cond: (companyid = 278679)
  • Filter: (latestperiodflag = 1)
  • Rows Removed by Filter: 420
8. 44.645 44.645 ↑ 3.0 2 5

Index Scan using ix_ciqfininstance on ciqfininstance u1 (cost=0.56..13.34 rows=6 width=8) (actual time=2.616..8.929 rows=2 loops=5)

  • Index Cond: (financialperiodid = u2.financialperiodid)
9. 52.120 52.120 ↑ 15.0 20 10

Index Scan using ix_ciqfincollection on ciqfincollection u0 (cost=0.57..76.78 rows=300 width=8) (actual time=2.587..5.212 rows=20 loops=10)

  • Index Cond: (financialinstanceid = u1.financialinstanceid)
10. 56.304 56.304 ↑ 1.0 1 204

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

  • Index Cond: (financialcollectionid = u0.financialcollectionid)
11. 17.136 17.136 ↓ 0.0 0 204

Index Scan using ix_financialinstanceid_multi on ciqfininstance (cost=0.56..8.20 rows=1 width=4) (actual time=0.084..0.084 rows=0 loops=204)

  • Index Cond: ((financialinstanceid = ciqfincollection.financialinstanceid) AND (latestfilingforinstanceflag = 1))
  • Filter: (latestforfinancialperiodflag = 1)
  • Rows Removed by Filter: 0
12. 57.630 57.630 ↓ 0.0 0 102

Index Scan using pk_ciqfincollectiondata on ciqfincollectiondata (cost=0.71..452.56 rows=148 width=27) (actual time=0.565..0.565 rows=0 loops=102)

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