explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ve9e

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=69,371,950.71..69,371,950.72 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.99..11,899.02 rows=134 width=21) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..11,689.30 rows=379 width=9) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on ce_sec_entity (cost=0.00..2,410.98 rows=485 width=36) (actual rows= loops=)

  • Filter: (factset_entity_id = '05RYHC-E'::bpchar)
5. 0.000 0.000 ↓ 0.0

Index Scan using sym_coverage_fsym_security_id_idx on sym_coverage (cost=0.56..19.12 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (fsym_security_id = ce_sec_entity.fsym_id)
  • Filter: (active_flag = 1)
6. 0.000 0.000 ↓ 0.0

Index Scan using sym_ticker_exchange_pkey on sym_ticker_exchange (cost=0.43..0.54 rows=1 width=21) (actual rows= loops=)

  • Index Cond: (fsym_id = sym_coverage.fsym_id)
7.          

SubPlan (forAggregate)

8. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=2,012.17..517,612.31 rows=533 width=9) (actual rows= loops=)

  • Hash Cond: (sym_cov2.fsym_primary_listing_id = sym_cov1.fsym_id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on sym_coverage sym_cov2 (cost=0.00..458,204.05 rows=15,304,205 width=18) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=2,005.51..2,005.51 rows=533 width=9) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using sym_coverage_fsym_primary_listing_id_idx on sym_coverage sym_cov1 (cost=0.56..2,005.51 rows=533 width=9) (actual rows= loops=)

  • Index Cond: (fsym_primary_listing_id = sym_ticker_exchange.fsym_id)