explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xeJ6

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 14,227.069 ↑ 1.0 1 1

Limit (cost=1.12..51.87 rows=1 width=8) (actual time=14,227.068..14,227.069 rows=1 loops=1)

2. 617.917 14,227.067 ↑ 3,205,689.0 1 1

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

3. 8,496.703 8,496.703 ↑ 7.2 1,704,149 1

Index Scan Backward using index_docs_on_sourceid on docs (cost=0.56..34,694,192.99 rows=12,195,433 width=12) (actual time=0.024..8,496.703 rows=1,704,149 loops=1)

4. 5,112.447 5,112.447 ↓ 0.0 0 1,704,149

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=1,704,149)

  • Index Cond: (doc_id = docs.id)
  • Filter: (project_id = 136)
  • Rows Removed by Filter: 2
Planning time : 0.224 ms
Execution time : 14,227.090 ms