explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZIbJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.061 14,629.864 ↑ 477.5 2 1

Sort (cost=71,633.95..71,636.34 rows=955 width=224) (actual time=14,629.864..14,629.864 rows=2 loops=1)

  • Sort Key: post.dat_sost
  • Sort Method: quicksort Memory: 25kB
2. 1.889 14,629.803 ↑ 477.5 2 1

Nested Loop (cost=2.00..71,586.68 rows=955 width=224) (actual time=6,964.186..14,629.803 rows=2 loops=1)

3. 0.357 14,622.406 ↑ 477.5 2 1

Nested Loop (cost=1.44..60,513.57 rows=955 width=77) (actual time=6,958.958..14,622.406 rows=2 loops=1)

4. 49.840 13,734.574 ↓ 3.0 35,499 1

Nested Loop (cost=1.01..52,215.03 rows=11,794 width=73) (actual time=3.168..13,734.574 rows=35,499 loops=1)

5. 8,395.383 8,395.383 ↓ 2.8 35,499 1

Index Scan using docs_post_sost on docs_post post (cost=0.57..16,987.27 rows=12,747 width=66) (actual time=1.175..8,395.383 rows=35,499 loops=1)

  • Index Cond: ((public.trunc(dat_sost) >= (('now'::cstring)::date - '7 days'::interval)) AND (public.trunc(dat_sost) <= (('now'::cstring)::date - '1 day'::interval)) AND ((ogai_sost_kod)::text = '45597'::text))
  • Filter: (doc_n IS NOT NULL)
  • Rows Removed by Filter: 382
6. 5,289.351 5,289.351 ↑ 1.0 1 35,499

Index Scan using uchast_pkey on uchast uch (cost=0.43..2.75 rows=1 width=13) (actual time=0.149..0.149 rows=1 loops=35,499)

  • Index Cond: (uchast_id = post.uchast_id)
  • Filter: (uchast_vid = '1'::numeric)
7. 887.475 887.475 ↓ 0.0 0 35,499

Index Scan using kart_ul_pkey on kart_ul ul (cost=0.42..0.69 rows=1 width=17) (actual time=0.025..0.025 rows=0 loops=35,499)

  • Index Cond: (id = uch.ul_id)
  • Filter: ((inn)::text = '7705002602'::numeric)
  • Rows Removed by Filter: 0
8. 1.396 1.396 ↑ 1.0 1 2

Index Scan using decis_docs_post_id on decis (cost=0.56..2.93 rows=1 width=10) (actual time=0.697..0.698 rows=1 loops=2)

  • Index Cond: (docs_post_id = post.docs_id)
9.          

SubPlan (for Nested Loop)

10. 0.018 0.018 ↑ 1.0 1 2

Index Scan using s_stotv_pkey on s_stotv (cost=0.27..2.69 rows=1 width=15) (actual time=0.009..0.009 rows=1 loops=2)

  • Index Cond: (stotv_id = post.stotv_id)
11. 0.014 4.094 ↑ 1.0 1 2

Nested Loop (cost=0.87..5.72 rows=1 width=12) (actual time=2.046..2.047 rows=1 loops=2)

12. 2.600 2.600 ↑ 1.0 1 2

Index Scan using vehs_pkey on vehs v_1 (cost=0.43..2.85 rows=1 width=6) (actual time=1.299..1.300 rows=1 loops=2)

  • Index Cond: (vehs_id = post.vehs_id)
  • Filter: (vehs_vid = '1'::numeric)
13. 1.480 1.480 ↑ 1.0 1 2

Index Scan using kart_docs_pkey on kart_docs kdr (cost=0.43..2.85 rows=1 width=18) (actual time=0.740..0.740 rows=1 loops=2)

  • Index Cond: (id = v_1.regno_id)
Planning time : 58.991 ms
Execution time : 14,630.009 ms