explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wqMV

Settings
# exclusive inclusive rows x rows loops node
1. 0.681 71.349 ↓ 3.7 6,370 1

Limit (cost=18,877,454.76..18,877,459.10 rows=1,735 width=409) (actual time=67.844..71.349 rows=6,370 loops=1)

2. 24.795 70.668 ↓ 3.7 6,370 1

Sort (cost=18,877,454.76..18,877,459.10 rows=1,735 width=409) (actual time=67.842..70.668 rows=6,370 loops=1)

  • Sort Key: fi.periodenddate DESC
  • Sort Method: external merge Disk: 3216kB
3. 6.696 45.873 ↓ 3.7 6,370 1

Nested Loop (cost=2.57..18,877,361.41 rows=1,735 width=409) (actual time=3.022..45.873 rows=6,370 loops=1)

4. 2.531 26.437 ↓ 3.7 6,370 1

Nested Loop (cost=2.28..18,863,781.69 rows=1,735 width=189) (actual time=3.015..26.437 rows=6,370 loops=1)

5. 11.533 18.286 ↓ 2.3 281 1

Nested Loop (cost=1.57..2,000.44 rows=120 width=162) (actual time=2.999..18.286 rows=281 loops=1)

  • Join Filter: (fc.currencyid = c.currencyid)
  • Rows Removed by Join Filter: 64630
6. 0.054 0.054 ↑ 1.0 231 1

Seq Scan on ciqcurrency c (cost=0.00..4.31 rows=231 width=30) (actual time=0.005..0.054 rows=231 loops=1)

7. 5.495 6.699 ↓ 2.3 281 231

Materialize (cost=1.57..1,580.63 rows=120 width=132) (actual time=0.003..0.029 rows=281 loops=231)

8. 0.094 1.204 ↓ 2.3 281 1

Nested Loop (cost=1.57..1,580.03 rows=120 width=132) (actual time=0.697..1.204 rows=281 loops=1)

9. 0.055 0.889 ↓ 1.9 17 1

Nested Loop (cost=1.00..863.93 rows=9 width=112) (actual time=0.687..0.889 rows=17 loops=1)

10. 0.106 0.106 ↓ 2.0 104 1

Index Scan using ix_ciqfinperiod_companyid_periodtypeid on ciqfinperiod fp (cost=0.43..181.37 rows=51 width=34) (actual time=0.014..0.106 rows=104 loops=1)

  • Index Cond: ((companyid = 105612) AND (periodtypeid = 2))
11. 0.728 0.728 ↓ 0.0 0 104

Index Scan using ix_ciqfininstance on ciqfininstance fi (cost=0.56..13.37 rows=1 width=78) (actual time=0.007..0.007 rows=0 loops=104)

  • Index Cond: (financialperiodid = fp.financialperiodid)
  • Filter: ((filingdate >= '2016-01-23 00:00:00'::timestamp without time zone) AND (latestforfinancialperiodflag = 1))
  • Rows Removed by Filter: 4
12. 0.221 0.221 ↑ 17.6 17 17

Index Scan using ix_ciqfincollection on ciqfincollection fc (cost=0.57..76.57 rows=300 width=20) (actual time=0.007..0.013 rows=17 loops=17)

  • Index Cond: (financialinstanceid = fi.financialinstanceid)
13. 5.620 5.620 ↑ 2,238.8 23 281

Index Scan using pk_ciqfincollectiondata on ciqfincollectiondata cd (cost=0.71..156,666.59 rows=51,492 width=27) (actual time=0.006..0.020 rows=23 loops=281)

  • Index Cond: (financialcollectionid = fc.financialcollectionid)
14. 12.740 12.740 ↑ 1.0 1 6,370

Index Scan using pk_ciqdataitem on ciqdataitem di (cost=0.29..7.82 rows=1 width=220) (actual time=0.002..0.002 rows=1 loops=6,370)

  • Index Cond: (dataitemid = cd.dataitemid)