explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WDW6

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 15.429 ↓ 0.0 0 1

Nested Loop Anti Join (cost=1.00..12,976.07 rows=970 width=158) (actual time=15.429..15.429 rows=0 loops=1)

2. 12.575 12.575 ↑ 1.0 1,000 1

Index Scan using index_lfs_objects_on_oid on lfs_objects (cost=0.56..3,577.00 rows=1,000 width=158) (actual time=0.024..12.575 rows=1,000 loops=1)

  • Index Cond: ((oid)::text = ANY ('// 1000 oids here //'::text[]))
3. 3.000 3.000 ↑ 1.0 1 1,000

Index Scan using index_lfs_objects_projects_on_lfs_object_id on lfs_objects_projects (cost=0.44..9.40 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1,000)

  • Index Cond: (lfs_object_id = lfs_objects.id)
  • Filter: (project_id = 10851098)
Planning time : 1.206 ms
Execution time : 16.454 ms