explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fl4q

Settings
# exclusive inclusive rows x rows loops node
1. 0.275 25,586.687 ↑ 1.0 1 1

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

2. 0.046 20.322 ↑ 4.1 33 1

Nested Loop (cost=0.99..11,899.02 rows=134 width=21) (actual time=17.872..20.322 rows=33 loops=1)

3. 0.030 19.858 ↑ 10.0 38 1

Nested Loop (cost=0.56..11,689.30 rows=379 width=9) (actual time=17.859..19.858 rows=38 loops=1)

4. 19.708 19.708 ↑ 121.2 4 1

Seq Scan on ce_sec_entity (cost=0.00..2,410.98 rows=485 width=36) (actual time=3.204..19.708 rows=4 loops=1)

  • Filter: (factset_entity_id = '05RYHC-E'::bpchar)
  • Rows Removed by Filter: 187992
5. 0.120 0.120 ↓ 10.0 10 4

Index Scan using sym_coverage_fsym_security_id_idx on sym_coverage (cost=0.56..19.12 rows=1 width=18) (actual time=0.015..0.030 rows=10 loops=4)

  • Index Cond: (fsym_security_id = ce_sec_entity.fsym_id)
  • Filter: (active_flag = 1)
  • Rows Removed by Filter: 1
6. 0.418 0.418 ↑ 1.0 1 38

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

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

SubPlan (forAggregate)

8. 12,819.060 25,566.090 ↓ 0.0 0 33

Hash Right Join (cost=2,012.17..517,612.31 rows=533 width=9) (actual time=745.280..774.730 rows=0 loops=33)

  • Hash Cond: (sym_cov2.fsym_primary_listing_id = sym_cov1.fsym_id)
9. 12,746.667 12,746.667 ↑ 1.0 15,077,070 3

Seq Scan on sym_coverage sym_cov2 (cost=0.00..458,204.05 rows=15,304,205 width=18) (actual time=0.004..4,248.889 rows=15,077,070 loops=3)

10. 0.033 0.363 ↓ 0.0 0 33

Hash (cost=2,005.51..2,005.51 rows=533 width=9) (actual time=0.011..0.011 rows=0 loops=33)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
11. 0.330 0.330 ↓ 0.0 0 33

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 time=0.010..0.010 rows=0 loops=33)

  • Index Cond: (fsym_primary_listing_id = sym_ticker_exchange.fsym_id)