explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XDgJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2.637 ↑ 1.0 1 1

Limit (cost=1.12..51.87 rows=1 width=8) (actual time=2.636..2.637 rows=1 loops=1)

2. 0.152 2.636 ↑ 3,205,689.0 1 1

Nested Loop (cost=1.12..162,675,114.19 rows=3,205,689 width=8) (actual time=2.636..2.636 rows=1 loops=1)

3. 1.353 1.353 ↑ 32,348.6 377 1

Index Scan using index_docs_on_sourceid on docs (cost=0.56..34,694,192.99 rows=12,195,433 width=12) (actual time=0.042..1.353 rows=377 loops=1)

4. 1.131 1.131 ↓ 0.0 0 377

Index Scan using index_project_docs_on_doc_id on project_docs (cost=0.56..10.48 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=377)

  • Index Cond: (doc_id = docs.id)
  • Filter: (project_id = 136)
  • Rows Removed by Filter: 1
Planning time : 0.207 ms
Execution time : 2.655 ms