explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5abG

Settings
# exclusive inclusive rows x rows loops node
1. 2,522.781 9,926.548 ↓ 1.3 38,365 1

Unique (cost=56,505.86..58,254.82 rows=28,780 width=16) (actual time=5,008.115..9,926.548 rows=38,365 loops=1)

2. 4,862.129 7,403.767 ↓ 1.0 350,192 1

Sort (cost=56,505.86..57,380.34 rows=349,791 width=16) (actual time=5,008.100..7,403.767 rows=350,192 loops=1)

  • Sort Key: e0.entity_instance_id
  • Sort Method: external merge Disk: 8,872kB
3. 2,541.638 2,541.638 ↓ 1.0 350,192 1

Seq Scan on entity_facts e0 (cost=0.00..18,318.88 rows=349,791 width=16) (actual time=0.018..2,541.638 rows=350,192 loops=1)

  • Filter: ((end_date IS NULL) AND ((dataset)::text = ANY ('{public,cvca_member,cvca_admin,aca,zwQhmwKvEMuklYHp34x4S6JGcziY=}'::text[])))
  • Rows Removed by Filter: 189,308