explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JKQ3

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

Aggregate (cost=122,749.47..122,749.48 rows=1 width=8) (actual time=520.159..520.160 rows=1 loops=1)

2.          

CTE created_records

3. 0.003 520.152 ↓ 0.0 0 1

Insert on project_features (cost=0.87..122,749.20 rows=12 width=52) (actual time=520.152..520.152 rows=0 loops=1)

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

Nested Loop Anti Join (cost=0.87..122,749.20 rows=12 width=52) (actual time=520.149..520.149 rows=0 loops=1)

5. 91.396 91.396 ↓ 1.0 67,970 1

Index Only Scan using projects_pkey on projects (cost=0.43..4,270.54 rows=66,544 width=4) (actual time=3.659..91.396 rows=67,970 loops=1)

  • Index Cond: ((id >= 1100000) AND (id <= 1200000))
  • Heap Fetches: 556
6. 407.820 407.820 ↑ 1.0 1 67,970

Index Only Scan using index_project_features_on_project_id on project_features project_features_1 (cost=0.43..1.77 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=67,970)

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

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

Planning time : 0.726 ms
Execution time : 520.268 ms