explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dRu3

Settings
# exclusive inclusive rows x rows loops node
1. 897.244 4,398.157 ↑ 1.0 10,000,000 1

Limit (cost=0.43..125,292.52 rows=10,000,000 width=139) (actual time=4.204..4,398.157 rows=10,000,000 loops=1)

2. 2,763.567 3,500.913 ↑ 881,348,042,663.8 10,000,000 1

Nested Loop (cost=0.43..110,425,932,829,103,216.00 rows=8,813,480,426,637,663,232 width=139) (actual time=4.203..3,500.913 rows=10,000,000 loops=1)

3. 36.210 112.346 ↑ 106,507,316,334.0 125,000 1

Nested Loop (cost=0.00..257,427,496,124,541.88 rows=13,313,414,541,748,736 width=105) (actual time=4.176..112.346 rows=125,000 loops=1)

4. 4.168 4.168 ↑ 1,868,303.0 1 1

Seq Scan on ciqfininstance fi (cost=0.00..1,070,055.26 rows=1,868,303 width=78) (actual time=4.168..4.168 rows=1 loops=1)

  • Filter: ((filingdate >= '2017-02-01 00:00:00'::timestamp without time zone) AND (latestforfinancialperiodflag = 1))
  • Rows Removed by Filter: 37527
5. 49.488 71.968 ↑ 57,007.5 125,000 1

Materialize (cost=0.00..209,156,818.68 rows=7,125,939,712 width=27) (actual time=0.007..71.968 rows=125,000 loops=1)

6. 22.480 22.480 ↑ 57,007.5 125,000 1

Seq Scan on ciqfincollectiondata cd (cost=0.00..124,814,641.12 rows=7,125,939,712 width=27) (actual time=0.003..22.480 rows=125,000 loops=1)

7. 624.769 625.000 ↑ 8.3 80 125,000

Materialize (cost=0.43..7,875.80 rows=662 width=34) (actual time=0.000..0.005 rows=80 loops=125,000)

8. 0.231 0.231 ↑ 8.3 80 1

Index Scan using ix_ciqfinperiod on ciqfinperiod fp (cost=0.43..7,872.49 rows=662 width=34) (actual time=0.015..0.231 rows=80 loops=1)

  • Index Cond: (companyid = 683733)
  • Filter: (periodtypeid = 2)
  • Rows Removed by Filter: 246