explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MRjE

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1,906.153 ↓ 0.0 0 1

Unique (cost=132,943.10..3,029,272.95 rows=4 width=5) (actual time=1,906.152..1,906.153 rows=0 loops=1)

2.          

CTE deleted_users

3. 667.321 667.321 ↓ 1.0 83,212 1

Seq Scan on users (cost=0.00..131,072.58 rows=83,109 width=4) (actual time=0.059..667.321 rows=83,212 loops=1)

  • Filter: (deleted IS TRUE)
  • Rows Removed by Filter: 4274770
4. 1,191.245 1,906.150 ↓ 0.0 0 1

Index Scan using test on modification_history (cost=1,870.52..2,898,191.32 rows=3,622 width=5) (actual time=1,906.150..1,906.150 rows=0 loops=1)

  • Index Cond: ((external_system IS NOT NULL) AND (creation_type IS NOT NULL))
  • Filter: ((NOT (hashed SubPlan 2)) AND ((user_type)::text = 'candidate'::text))
  • Rows Removed by Filter: 1249849
5.          

SubPlan (forIndex Scan)

6. 714.905 714.905 ↓ 1.0 83,212 1

CTE Scan on deleted_users (cost=0.00..1,662.18 rows=83,109 width=4) (actual time=0.062..714.905 rows=83,212 loops=1)