explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5QCd

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 3,205.227 ↑ 1.9 53 1

Limit (cost=2.64..6,625.94 rows=100 width=483) (actual time=65.175..3,205.227 rows=53 loops=1)

2. 51.101 3,205.216 ↑ 241.2 53 1

ProjectSet (cost=2.64..846,856.95 rows=12,786 width=483) (actual time=65.175..3,205.216 rows=53 loops=1)

3. 110.559 3,129.485 ↑ 241.2 53 1

Nested Loop Semi Join (cost=2.64..514,836.50 rows=12,786 width=394) (actual time=0.964..3,129.485 rows=53 loops=1)

4. 72.836 2,728.817 ↓ 2.0 290,109 1

Nested Loop Left Join (cost=2.22..443,735.85 rows=145,558 width=423) (actual time=0.057..2,728.817 rows=290,109 loops=1)

5. 75.465 2,365.872 ↓ 2.0 290,109 1

Nested Loop Left Join (cost=1.94..331,402.47 rows=145,558 width=380) (actual time=0.049..2,365.872 rows=290,109 loops=1)

6. 0.000 2,000.298 ↓ 2.0 290,109 1

Nested Loop Left Join (cost=1.67..277,066.06 rows=145,558 width=333) (actual time=0.045..2,000.298 rows=290,109 loops=1)

7. 76.592 1,714.859 ↓ 2.0 290,109 1

Nested Loop Left Join (cost=1.40..234,839.29 rows=145,558 width=333) (actual time=0.040..1,714.859 rows=290,109 loops=1)

8. 9.443 1,348.158 ↓ 2.0 290,109 1

Nested Loop Left Join (cost=1.13..180,502.87 rows=145,558 width=290) (actual time=0.033..1,348.158 rows=290,109 loops=1)

9. 202.956 1,048.606 ↓ 2.0 290,109 1

Nested Loop Left Join (cost=0.85..138,276.38 rows=145,558 width=290) (actual time=0.023..1,048.606 rows=290,109 loops=1)

10. 0.000 555.541 ↓ 2.0 290,109 1

Nested Loop Left Join (cost=0.56..86,297.43 rows=145,558 width=233) (actual time=0.021..555.541 rows=290,109 loops=1)

11. 265.704 265.704 ↓ 2.0 290,109 1

Index Scan Backward using model_task_date_idx on model_task t (cost=0.42..63,012.79 rows=145,558 width=174) (actual time=0.013..265.704 rows=290,109 loops=1)

  • Filter: (NOT COALESCE(is_deleted, false))
  • Rows Removed by Filter: 1007
12. 290.109 290.109 ↑ 1.0 1 290,109

Index Scan using model_doc_status_pkey on model_doc_status st (cost=0.14..0.16 rows=1 width=63) (actual time=0.001..0.001 rows=1 loops=290,109)

  • Index Cond: (id = t.status_id)
13. 290.109 290.109 ↑ 1.0 1 290,109

Index Scan using model_person_pkey on model_person p (cost=0.29..0.36 rows=1 width=65) (actual time=0.001..0.001 rows=1 loops=290,109)

  • Index Cond: (id = t.person_id)
14. 290.109 290.109 ↑ 1.0 1 290,109

Index Only Scan using tbl_users_pkey on tbl_users a (cost=0.27..0.29 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=290,109)

  • Index Cond: (id = t.author_id)
  • Heap Fetches: 16267
15. 290.109 290.109 ↑ 1.0 1 290,109

Index Scan using tbl_profiles_user_id_idx1 on tbl_profiles ap (cost=0.27..0.37 rows=1 width=51) (actual time=0.001..0.001 rows=1 loops=290,109)

  • Index Cond: (user_id = a.id)
16. 290.109 290.109 ↑ 1.0 1 290,109

Index Only Scan using tbl_users_pkey on tbl_users d (cost=0.27..0.29 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=290,109)

  • Index Cond: (id = t.doer_id)
  • Heap Fetches: 2354
17. 290.109 290.109 ↑ 1.0 1 290,109

Index Scan using tbl_profiles_user_id_idx1 on tbl_profiles dp (cost=0.27..0.37 rows=1 width=55) (actual time=0.001..0.001 rows=1 loops=290,109)

  • Index Cond: (user_id = d.id)
18. 290.109 290.109 ↑ 1.0 1 290,109

Index Scan using model_listitem_pkey on model_listitem dpp (cost=0.28..0.77 rows=1 width=51) (actual time=0.001..0.001 rows=1 loops=290,109)

  • Index Cond: (id = dp.doer_post)
19. 290.109 290.109 ↓ 0.0 0 290,109

Index Only Scan using document_produced_doc_id_parent_doc_name_doc_name_index on document_produced (cost=0.42..0.48 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=290,109)

  • Index Cond: ((doc_id = t.id) AND (parent_doc_name = 'Task'::text) AND (doc_name = 'Task'::text))
  • Heap Fetches: 0
20.          

SubPlan (for ProjectSet)

21. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_file_doc_guid on document_file (cost=0.42..8.44 rows=1 width=0) (never executed)

  • Index Cond: (doc_guid = t.guid)
  • Heap Fetches: 0
22. 24.630 24.630 ↓ 1.0 124,461 1

Seq Scan on document_file document_file_1 (cost=0.00..3,307.58 rows=124,458 width=16) (actual time=0.013..24.630 rows=124,461 loops=1)

23. 0.000 0.000 ↓ 0.0 0 106

Index Scan using typology_pkey on typology (cost=8.72..16.73 rows=1 width=67) (actual time=0.000..0.000 rows=0 loops=106)

  • Index Cond: (id = $3)
24.          

Initplan (for Index Scan)

25. 0.000 0.318 ↑ 1.0 1 106

Limit (cost=0.42..8.44 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=106)

26. 0.318 0.318 ↑ 1.0 1 106

Index Scan using document_produced_doc_id_parent_doc_name_doc_name_index on document_produced document_produced_1 (cost=0.42..8.44 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=106)

  • Index Cond: ((doc_id = t.id) AND (doc_name = 'Task'::text))
Planning time : 6.631 ms
Execution time : 3,205.435 ms