explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2C2o

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,095.182 ↓ 0.0 0 1

Unique (cost=1.00..2,936,901.62 rows=4 width=5) (actual time=1,095.182..1,095.182 rows=0 loops=1)

2. 0.000 1,095.180 ↓ 0.0 0 1

Nested Loop (cost=1.00..2,936,884.01 rows=7,044 width=5) (actual time=1,095.180..1,095.180 rows=0 loops=1)

3. 1,095.180 1,095.180 ↓ 0.0 0 1

Index Scan using test on modification_history (cost=0.56..2,881,044.75 rows=7,181 width=9) (actual time=1,095.179..1,095.180 rows=0 loops=1)

  • Index Cond: ((external_system IS NOT NULL) AND (creation_type IS NOT NULL))
  • Filter: (((external_system)::text <> 't'::text) AND ((user_type)::text = 'candidate'::text))
  • Rows Removed by Filter: 1249849
4. 0.000 0.000 ↓ 0.0 0

Index Scan using users_pkey on users (cost=0.43..7.77 rows=1 width=4) (never executed)

  • Index Cond: (id = modification_history.user_id)
  • Filter: (NOT deleted)