explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nLmZg

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.342 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.87..12.14 rows=1 width=753) (actual time=0.342..0.342 rows=0 loops=1)

2. 0.146 0.146 ↑ 1.0 2 1

Index Scan using projects_pkey on projects (cost=0.43..6.72 rows=2 width=753) (actual time=0.076..0.146 rows=2 loops=1)

  • Index Cond: (id = ANY ('{100000,200000}'::integer[]))
3. 0.188 0.188 ↑ 1.0 1 2

Index Only Scan using index_project_features_on_project_id on project_features (cost=0.43..2.70 rows=1 width=4) (actual time=0.094..0.094 rows=1 loops=2)

  • Index Cond: (project_id = projects.id)
  • Heap Fetches: 0
Planning time : 10.482 ms
Execution time : 0.461 ms