explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TC1H

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,644.560 ↑ 1.0 6 1

Limit (cost=2.13..65,190.29 rows=6 width=409) (actual time=1,644.547..1,644.560 rows=6 loops=1)

2. 0.004 1,644.560 ↑ 3,702.7 6 1

Nested Loop (cost=2.13..241,370,015.80 rows=22,216 width=409) (actual time=1,644.547..1,644.560 rows=6 loops=1)

3. 0.004 1,644.544 ↑ 3,702.7 6 1

Nested Loop (cost=1.84..241,196,132.77 rows=22,216 width=189) (actual time=1,644.539..1,644.544 rows=6 loops=1)

4. 0.015 1,644.525 ↑ 1,532.0 1 1

Nested Loop (cost=1.14..394,058.79 rows=1,532 width=162) (actual time=1,644.525..1,644.525 rows=1 loops=1)

  • Join Filter: (fc.currencyid = c.currencyid)
  • Rows Removed by Join Filter: 80
5. 0.002 1,644.490 ↑ 1,532.0 1 1

Nested Loop (cost=1.14..388,745.52 rows=1,532 width=132) (actual time=1,644.490..1,644.490 rows=1 loops=1)

6. 0.213 1,644.480 ↑ 116.0 1 1

Nested Loop (cost=0.56..379,515.76 rows=116 width=112) (actual time=1,644.480..1,644.480 rows=1 loops=1)

7. 1,643.307 1,643.307 ↑ 10.3 64 1

Seq Scan on ciqfinperiod fp (cost=0.00..370,673.91 rows=662 width=34) (actual time=28.707..1,643.307 rows=64 loops=1)

  • Filter: ((companyid = 683733) AND (periodtypeid = 2))
  • Rows Removed by Filter: 12022613
8. 0.960 0.960 ↓ 0.0 0 64

Index Scan using ix_ciqfininstance on ciqfininstance fi (cost=0.56..13.35 rows=1 width=78) (actual time=0.015..0.015 rows=0 loops=64)

  • Index Cond: (financialperiodid = fp.financialperiodid)
  • Filter: ((filingdate >= '2016-02-01 00:00:00'::timestamp without time zone) AND (latestforfinancialperiodflag = 1))
  • Rows Removed by Filter: 4
9. 0.008 0.008 ↑ 300.0 1 1

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

  • Index Cond: (financialinstanceid = fi.financialinstanceid)
10. 0.012 0.020 ↑ 2.9 81 1

Materialize (cost=0.00..5.47 rows=231 width=30) (actual time=0.007..0.020 rows=81 loops=1)

11. 0.008 0.008 ↑ 2.9 81 1

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

12. 0.015 0.015 ↑ 8,582.0 6 1

Index Scan using pk_ciqfincollectiondata on ciqfincollectiondata cd (cost=0.71..156,666.59 rows=51,492 width=27) (actual time=0.012..0.015 rows=6 loops=1)

  • Index Cond: (financialcollectionid = fc.financialcollectionid)
13. 0.012 0.012 ↑ 1.0 1 6

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)

  • Index Cond: (dataitemid = cd.dataitemid)