explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a0Zl

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 706.231 ↑ 1.0 1 1

Aggregate (cost=121,877.19..121,877.20 rows=1 width=8) (actual time=706.230..706.231 rows=1 loops=1)

2.          

CTE created_records

3. 0.035 706.210 ↓ 0.0 0 1

Insert on project_features (cost=0.87..121,876.92 rows=12 width=52) (actual time=706.210..706.210 rows=0 loops=1)

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

Nested Loop Anti Join (cost=0.87..121,876.92 rows=12 width=52) (actual time=706.175..706.175 rows=0 loops=1)

5. 135.302 135.302 ↑ 1.0 64,251 1

Index Only Scan using projects_pkey on projects (cost=0.43..4,229.66 rows=65,888 width=4) (actual time=0.832..135.302 rows=64,251 loops=1)

  • Index Cond: ((id >= 100000) AND (id <= 200000))
  • Heap Fetches: 520
6. 578.259 578.259 ↑ 1.0 1 64,251

Index Only Scan using index_project_features_on_project_id on project_features project_features_1 (cost=0.43..1.78 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=64,251)

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

CTE Scan on created_records (cost=0.00..0.24 rows=12 width=0) (actual time=706.213..706.213 rows=0 loops=1)

Planning time : 71.398 ms
Execution time : 706.629 ms