explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aZhNV

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 1,539.892 ↑ 1.0 10 1

Limit (cost=1.84..108,664.53 rows=10 width=7) (actual time=1,538.332..1,539.892 rows=10 loops=1)

2. 0.005 1,539.887 ↑ 1,494.9 10 1

Nested Loop (cost=1.84..162,439,847.12 rows=14,949 width=7) (actual time=1,538.330..1,539.887 rows=10 loops=1)

3. 0.002 1,538.312 ↑ 1,031.0 1 1

Nested Loop (cost=1.14..385,722.29 rows=1,031 width=4) (actual time=1,538.312..1,538.312 rows=1 loops=1)

4. 0.174 1,538.299 ↑ 78.0 1 1

Nested Loop (cost=0.56..379,515.76 rows=78 width=4) (actual time=1,538.299..1,538.299 rows=1 loops=1)

5. 1,537.105 1,537.105 ↑ 9.7 68 1

Seq Scan on ciqfinperiod fp (cost=0.00..370,673.91 rows=662 width=4) (actual time=21.245..1,537.105 rows=68 loops=1)

  • Filter: ((companyid = 683733) AND (periodtypeid = 2))
  • Rows Removed by Filter: 12955374
6. 1.020 1.020 ↓ 0.0 0 68

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

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

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

  • Index Cond: (financialinstanceid = fi.financialinstanceid)
8. 1.570 1.570 ↑ 5,149.2 10 1

Index Scan using pk_ciqfincollectiondata on ciqfincollectiondata cd (cost=0.71..156,666.58 rows=51,492 width=11) (actual time=0.015..1.570 rows=10 loops=1)

  • Index Cond: (financialcollectionid = fc.financialcollectionid)