explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zFHT

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

Nested Loop (cost=198.73..285.18 rows=1 width=1,372) (actual time=0.052..0.052 rows=0 loops=1)

2.          

Initplan (forNested Loop)

3. 0.000 0.000 ↓ 0.0 0

Group (cost=195.78..195.79 rows=1 width=32) (never executed)

  • Group Key: decis_2.delo_id
4. 0.000 0.000 ↓ 0.0 0

Sort (cost=195.78..195.78 rows=1 width=32) (never executed)

  • Sort Key: decis_2.delo_id
5. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on decis decis_2 (cost=4.76..195.77 rows=1 width=32) (never executed)

  • Recheck Cond: (dat_rasm = date(now()))
  • Filter: ((dat_uved IS NOT NULL) AND (decis_kod = '92'::numeric))
6. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on decis_dat_rasm_ind (cost=0.00..4.76 rows=63 width=0) (never executed)

  • Index Cond: (dat_rasm = date(now()))
7. 0.000 0.052 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.67..26.40 rows=1 width=679) (actual time=0.052..0.052 rows=0 loops=1)

8. 0.000 0.052 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.53..26.23 rows=1 width=573) (actual time=0.052..0.052 rows=0 loops=1)

9. 0.000 0.052 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.24..17.92 rows=1 width=558) (actual time=0.052..0.052 rows=0 loops=1)

10. 0.001 0.052 ↓ 0.0 0 1

Nested Loop (cost=1.96..17.41 rows=1 width=550) (actual time=0.052..0.052 rows=0 loops=1)

11. 0.001 0.051 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.68..17.04 rows=1 width=543) (actual time=0.051..0.051 rows=0 loops=1)

12. 0.000 0.050 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.40..16.55 rows=1 width=480) (actual time=0.050..0.050 rows=0 loops=1)

13. 0.000 0.050 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.10..15.83 rows=1 width=130) (actual time=0.050..0.050 rows=0 loops=1)

14. 0.001 0.050 ↓ 0.0 0 1

Nested Loop (cost=0.82..15.27 rows=1 width=102) (actual time=0.050..0.050 rows=0 loops=1)

15. 0.049 0.049 ↓ 0.0 0 1

Index Scan using delo_ogai_n on delo d (cost=0.54..6.95 rows=1 width=76) (actual time=0.049..0.049 rows=0 loops=1)

  • Index Cond: ((ogai_nah_kod)::text = (apr_session_params.get_ogai_code())::text)
  • Filter: ((stad_delo_kod < '5'::numeric) AND (delo_tip = '1'::numeric) AND (delo_id = ANY ($10)))
16. 0.000 0.000 ↓ 0.0 0

Index Scan using viol_pk on viol v (cost=0.29..8.30 rows=1 width=26) (never executed)

  • Index Cond: (delo_id = d.delo_id)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using uchast_pkey on uchast u (cost=0.29..0.55 rows=1 width=33) (never executed)

  • Index Cond: (v.lvok_id = uchast_id)
18. 0.000 0.000 ↓ 0.0 0

Index Scan using kart_fl_pkey on kart_fl kf (cost=0.29..0.71 rows=1 width=382) (never executed)

  • Index Cond: (u.fl_id = id)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using docs_post_pkey on docs_post dps (cost=0.28..0.47 rows=1 width=100) (never executed)

  • Index Cond: (v.docs_post_id = docs_id)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using docs_prot_pkey on docs_prot dpr (cost=0.28..0.37 rows=1 width=17) (never executed)

  • Index Cond: (docs_id = v.docs_prot_id)
  • Filter: (doc_n IS NOT NULL)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using docs_other_pkey on docs_other dot (cost=0.29..0.50 rows=1 width=18) (never executed)

  • Index Cond: (v.docs_other_id = docs_id)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using decis_ispoln_pkey on decis_ispoln di (cost=0.28..8.30 rows=1 width=52) (never executed)

  • Index Cond: (d.decis_ispoln_last_id = decis_ispoln_id)
23. 0.000 0.000 ↓ 0.0 0

Index Scan using s_sstad_ispoln_pkey on s_sstad_ispoln si (cost=0.14..0.16 rows=1 width=130) (never executed)

  • Index Cond: (di.stad_ispoln_kod = stad_ispoln_kod)
24. 0.000 0.000 ↓ 0.0 0

Index Scan using delo_tags_delo_id on delo_tags t (cost=0.28..0.30 rows=1 width=7) (never executed)

  • Index Cond: (delo_id = v.delo_id)
  • Filter: ((card_category = '1'::numeric) AND (type_id = '4'::numeric))
25.          

SubPlan (forNested Loop)

26. 0.000 0.000 ↓ 0.0 0

Seq Scan on s_sstad_delo ss (cost=0.00..1.09 rows=1 width=118) (never executed)

  • Filter: (d.stad_delo_kod = stad_delo_kod)
27. 0.000 0.000 ↓ 0.0 0

Index Scan using s_stotv_pkey on s_stotv ss_1 (cost=0.27..8.29 rows=1 width=12) (never executed)

  • Index Cond: (stotv_id = d.stotv_id)
28. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..16.75 rows=1 width=58) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Index Scan using vehs_pkey on vehs v_1 (cost=0.29..8.30 rows=1 width=32) (never executed)

  • Index Cond: (vehs_id = u.vehs_id)
30. 0.000 0.000 ↓ 0.0 0

Index Scan using kart_docs_pkey on kart_docs kdr (cost=0.42..8.44 rows=1 width=90) (never executed)

  • Index Cond: (id = v_1.regno_id)
31. 0.000 0.000 ↓ 0.0 0

Seq Scan on s_sdecis sd (cost=8.30..9.73 rows=1 width=218) (never executed)

  • Filter: (decis_kod = $5)
32.          

Initplan (forSeq Scan)

33. 0.000 0.000 ↓ 0.0 0

Index Scan using decis_pkey on decis (cost=0.29..8.30 rows=1 width=12) (never executed)

  • Index Cond: (decis_id = d.decis_first_id)
34. 0.000 0.000 ↓ 0.0 0

Index Scan using decis_pkey on decis de (cost=0.29..8.30 rows=1 width=8) (never executed)

  • Index Cond: (decis_id = d.decis_first_id)
35. 0.000 0.000 ↓ 0.0 0

Seq Scan on s_sdecis sd_1 (cost=8.30..9.73 rows=1 width=218) (never executed)

  • Filter: (decis_kod = $8)
36.          

Initplan (forSeq Scan)

37. 0.000 0.000 ↓ 0.0 0

Index Scan using decis_pkey on decis decis_1 (cost=0.29..8.30 rows=1 width=12) (never executed)

  • Index Cond: (decis_id = d.decis_last_id)
38. 0.000 0.000 ↓ 0.0 0

Index Scan using decis_pkey on decis de_1 (cost=0.29..8.30 rows=1 width=8) (never executed)

  • Index Cond: (decis_id = d.decis_last_id)
Planning time : 4.420 ms
Execution time : 0.308 ms