explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mQab8

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 139.653 ↑ 1.0 1 1

Aggregate (cost=79,372.54..79,372.55 rows=1 width=8) (actual time=139.653..139.653 rows=1 loops=1)

2.          

CTE created_records

3. 0.002 139.644 ↓ 0.0 0 1

Insert on project_features (cost=0.87..79,372.52 rows=1 width=52) (actual time=139.644..139.644 rows=0 loops=1)

  • Conflict Resolution: NOTHING
  • Conflict Arbiter Indexes: index_project_features_on_project_id
  • Tuples Inserted: 0
  • Conflicting Tuples: 0
4. 2.994 139.642 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.87..79,372.52 rows=1 width=52) (actual time=139.642..139.642 rows=0 loops=1)

5. 29.998 29.998 ↓ 1.0 35,550 1

Index Only Scan using projects_pkey on projects (cost=0.43..2,293.58 rows=35,042 width=4) (actual time=7.884..29.998 rows=35,550 loops=1)

  • Index Cond: ((id >= 2100000) AND (id <= 2150000))
  • Heap Fetches: 326
6. 106.650 106.650 ↑ 1.0 1 35,550

Index Only Scan using index_project_features_on_project_id on project_features project_features_1 (cost=0.43..2.19 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=35,550)

  • Index Cond: (project_id = projects.id)
  • Heap Fetches: 4339
7. 139.647 139.647 ↓ 0.0 0 1

CTE Scan on created_records (cost=0.00..0.02 rows=1 width=0) (actual time=139.647..139.647 rows=0 loops=1)

Planning time : 0.797 ms
Execution time : 139.748 ms