explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2ToD

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 79.845 ↑ 1.0 100 1

Limit (cost=5.73..2,925.92 rows=100 width=483) (actual time=41.837..79.845 rows=100 loops=1)

2.          

Initplan (forLimit)

3. 0.020 0.020 ↑ 1.0 2 1

Seq Scan on model_doc_status (cost=0.00..3.51 rows=2 width=4) (actual time=0.010..0.020 rows=2 loops=1)

  • Filter: ((machine_name)::text = ANY ('{closed,rejected}'::text[]))
  • Rows Removed by Filter: 119
4. 60.510 79.820 ↑ 1,194.3 100 1

ProjectSet (cost=2.22..3,487,487.26 rows=119,427 width=483) (actual time=41.836..79.820 rows=100 loops=1)

5. 1.371 4.827 ↑ 1,194.3 100 1

Nested Loop Left Join (cost=2.22..386,266.63 rows=119,427 width=394) (actual time=0.105..4.827 rows=100 loops=1)

6. 0.153 3.156 ↑ 1,194.3 100 1

Nested Loop Left Join (cost=1.94..289,621.12 rows=119,427 width=380) (actual time=0.089..3.156 rows=100 loops=1)

7. 0.135 2.703 ↑ 1,194.3 100 1

Nested Loop Left Join (cost=1.67..245,039.30 rows=119,427 width=333) (actual time=0.085..2.703 rows=100 loops=1)

8. 0.119 2.368 ↑ 1,194.3 100 1

Nested Loop Left Join (cost=1.40..210,389.61 rows=119,427 width=333) (actual time=0.083..2.368 rows=100 loops=1)

9. 0.128 1.949 ↑ 1,194.3 100 1

Nested Loop Left Join (cost=1.13..165,807.79 rows=119,427 width=290) (actual time=0.078..1.949 rows=100 loops=1)

10. 0.189 1.521 ↑ 1,194.3 100 1

Nested Loop Left Join (cost=0.85..131,158.33 rows=119,427 width=290) (actual time=0.074..1.521 rows=100 loops=1)

11. 0.263 0.932 ↑ 1,194.3 100 1

Nested Loop Left Join (cost=0.56..87,214.68 rows=119,427 width=233) (actual time=0.073..0.932 rows=100 loops=1)

12. 0.469 0.469 ↑ 1,194.3 100 1

Index Scan Backward using model_task_date_idx on model_task t (cost=0.42..68,107.32 rows=119,427 width=174) (actual time=0.068..0.469 rows=100 loops=1)

  • Filter: ((NOT COALESCE(is_deleted, false)) AND (time_end_guess <= now()) AND (status_id <> ANY ($4)))
  • Rows Removed by Filter: 91
13. 0.200 0.200 ↑ 1.0 1 100

Index Scan using model_doc_status_pkey on model_doc_status st (cost=0.14..0.16 rows=1 width=63) (actual time=0.002..0.002 rows=1 loops=100)

  • Index Cond: (id = t.status_id)
14. 0.400 0.400 ↑ 1.0 1 100

Index Scan using model_person_pkey on model_person p (cost=0.29..0.37 rows=1 width=65) (actual time=0.004..0.004 rows=1 loops=100)

  • Index Cond: (id = t.person_id)
15. 0.300 0.300 ↑ 1.0 1 100

Index Only Scan using tbl_users_pkey on tbl_users a (cost=0.27..0.29 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: (id = t.author_id)
  • Heap Fetches: 1
16. 0.300 0.300 ↑ 1.0 1 100

Index Scan using tbl_profiles_user_id_idx1 on tbl_profiles ap (cost=0.27..0.37 rows=1 width=51) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: (user_id = a.id)
17. 0.200 0.200 ↑ 1.0 1 100

Index Only Scan using tbl_users_pkey on tbl_users d (cost=0.27..0.29 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=100)

  • Index Cond: (id = t.doer_id)
  • Heap Fetches: 3
18. 0.300 0.300 ↑ 1.0 1 100

Index Scan using tbl_profiles_user_id_idx1 on tbl_profiles dp (cost=0.27..0.37 rows=1 width=55) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: (user_id = d.id)
19. 0.300 0.300 ↑ 1.0 1 100

Index Scan using model_listitem_pkey on model_listitem dpp (cost=0.28..0.77 rows=1 width=51) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: (id = dp.doer_post)
20.          

SubPlan (forProjectSet)

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. 13.886 13.886 ↓ 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..13.886 rows=124,461 loops=1)

23. 0.000 0.597 ↑ 1.0 1 199

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

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

Initplan (forIndex Scan)

25. 0.199 1.194 ↑ 1.0 1 199

Limit (cost=0.42..8.44 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=199)

26. 0.995 0.995 ↑ 1.0 1 199

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

  • Index Cond: ((doc_id = t.id) AND (doc_name = 'Task'::text))
Planning time : 3.000 ms
Execution time : 80.000 ms