explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ck7U

Settings
# exclusive inclusive rows x rows loops node
1. 4,431.440 8,678.507 ↑ 1,667,854.0 1 1

Hash Join (cost=11,747.82..527,373.85 rows=1,667,854 width=9) (actual time=6,834.508..8,678.507 rows=1 loops=1)

  • Hash Cond: (sym_coverage.fsym_primary_listing_id = sym_cov1.fsym_id)
2. 4,246.922 4,246.922 ↑ 1.0 15,077,070 1

Seq Scan on sym_coverage (cost=0.00..458,204.05 rows=15,304,205 width=18) (actual time=0.032..4,246.922 rows=15,077,070 loops=1)

3. 0.004 0.145 ↑ 1,564.0 2 1

Hash (cost=11,708.72..11,708.72 rows=3,128 width=9) (actual time=0.145..0.145 rows=2 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 33kB
4. 0.141 0.141 ↑ 1,564.0 2 1

Index Scan using sym_coverage_fsym_primary_listing_id_idx on sym_coverage sym_cov1 (cost=0.56..11,708.72 rows=3,128 width=9) (actual time=0.110..0.141 rows=2 loops=1)

  • Index Cond: (fsym_primary_listing_id = ANY ('{B51JKY-L,B69WX4-L,BJF140-L,CPYVCV-L,D5GYBS-L,DTG8T8-L,GPK7XP-L,HK6Y1Z-L,JBG89C-L,K3FXRD-L,K5B9KN-L,R5KCM1-L}'::bpchar[]))
  • Filter: (fsym_regional_id IS NOT NULL)