explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ubW

Settings
# exclusive inclusive rows x rows loops node
1. 0.085 55,608.247 ↑ 1,437.5 8 1

Unique (cost=4,148,627.22..4,148,714.78 rows=11,500 width=13) (actual time=55,608.091..55,608.247 rows=8 loops=1)

2. 0.343 55,608.162 ↑ 19.2 912 1

Sort (cost=4,148,627.22..4,148,671.00 rows=17,513 width=13) (actual time=55,608.090..55,608.162 rows=912 loops=1)

  • Sort Key: external_system
  • Sort Method: quicksort Memory: 67kB
3. 55,607.819 55,607.819 ↑ 19.2 912 1

Seq Scan on modification_history (cost=0.00..4,147,392.89 rows=17,513 width=13) (actual time=243.425..55,607.819 rows=912 loops=1)

  • Filter: ((creation_type IS NOT NULL) AND (external_system IS NOT NULL) AND ((user_type)::text = 'candidate'::text))
  • Rows Removed by Filter: 2285360