explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u2fJ

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

Unique (cost=67,396.34..67,396.34 rows=3 width=110) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=67,396.34..67,396.34 rows=3 width=110) (actual rows= loops=)

  • Sort Key: uw.updated DESC, uw.id DESC, zh."timestamp" DESC
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.08..67,396.33 rows=3 width=110) (actual rows= loops=)

  • Join Filter: (p.id = ap.page_ptr_id)
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.08..67,219.23 rows=3 width=348) (actual rows= loops=)

  • Join Filter: (ap.page_ptr_id = uw.product_id)
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.08..67,155.79 rows=3 width=348) (actual rows= loops=)

  • Join Filter: (q.id = uw.questionnaire_id)
6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.08..67,151.08 rows=3 width=334) (actual rows= loops=)

  • Join Filter: (zh.zendesk_id = uw.zendesk_id)
7. 0.000 0.000 ↓ 0.0

Index Scan using useracts_userworkflow_user_id on useracts_userworkflow uw (cost=0.08..8.10 rows=3 width=26) (actual rows= loops=)

  • Index Cond: (user_id = 19441)
  • Filter: (archived_at IS NULL)
8. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..66,546.65 rows=51,855 width=316) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on useracts_zendeskhistory zh (cost=0.00..66,494.80 rows=51,855 width=316) (actual rows= loops=)

  • Filter: (((data -> 'statut_workflow'::text) ->> 'value'::text) = ANY ('{presta_terminee,rejet,reçu,requête_en_IP_a_initier,dossier_a_modifier,traité_par_ls,relance_a_faire,en_attente_des_frais_admin,en_attente_frais_de_succès,requête_initiée,recherche_d_antériorité,amiable_en_cours,en_attente_infos_client}'::text[]))
10. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..4.18 rows=46 width=22) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on acts_questionnaire q (cost=0.00..4.14 rows=46 width=22) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..61.63 rows=157 width=4) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on acts_product ap (cost=0.00..61.47 rows=157 width=4) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..157.74 rows=1,684 width=42) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on pages_page p (cost=0.00..156.05 rows=1,684 width=42) (actual rows= loops=)