explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dzr6

Settings
# exclusive inclusive rows x rows loops node
1. 31.230 47,902.622 ↑ 367.8 5 1

GroupAggregate (cost=449,826.63..450,102.48 rows=1,839 width=124) (actual time=47,875.313..47,902.622 rows=5 loops=1)

  • Group Key: ((post.dat_sost)::date)
2. 33.993 47,871.392 ↓ 17.8 32,793 1

Sort (cost=449,826.63..449,831.23 rows=1,839 width=97) (actual time=47,869.161..47,871.392 rows=32,793 loops=1)

  • Sort Key: ((post.dat_sost)::date)
  • Sort Method: quicksort Memory: 5,782kB
3. 26.991 47,837.399 ↓ 17.8 32,793 1

Nested Loop Left Join (cost=3.65..449,726.91 rows=1,839 width=97) (actual time=18,015.427..47,837.399 rows=32,793 loops=1)

4. 48.928 46,957.790 ↓ 17.8 32,793 1

Nested Loop Left Join (cost=3.09..444,251.73 rows=1,839 width=91) (actual time=18,014.453..46,957.790 rows=32,793 loops=1)

5. 20.586 40,055.125 ↓ 17.8 32,793 1

Nested Loop Left Join (cost=2.54..425,443.50 rows=1,839 width=71) (actual time=18,011.252..40,055.125 rows=32,793 loops=1)

6. 33.663 35,082.796 ↓ 17.8 32,793 1

Nested Loop Left Join (cost=1.98..422,181.68 rows=1,839 width=47) (actual time=18,008.622..35,082.796 rows=32,793 loops=1)

7. 38.894 33,966.964 ↓ 17.8 32,793 1

Nested Loop (cost=1.14..328,485.16 rows=1,839 width=45) (actual time=18,005.887..33,966.964 rows=32,793 loops=1)

8. 27,238.094 27,238.094 ↓ 13.0 32,794 1

Index Scan using docs_post_idx1 on docs_post post (cost=0.57..320,970.46 rows=2,520 width=45) (actual time=18,003.773..27,238.094 rows=32,794 loops=1)

  • Index Cond: ((dat_sost >= (('now'::cstring)::date - '7 days'::interval)) AND (dat_sost <= ('now'::cstring)::date))
  • Filter: ((doc_n IS NOT NULL) AND ((ogai_sost_kod)::text = '45597'::text))
  • Rows Removed by Filter: 45,107
9. 6,689.976 6,689.976 ↑ 1.0 1 32,794

Index Scan using decis_docs_post_id on decis (cost=0.56..2.97 rows=1 width=6) (actual time=0.203..0.204 rows=1 loops=32,794)

  • Index Cond: (docs_post_id = post.docs_id)
  • Filter: (decis_kod = ANY ('{4,65}'::numeric[]))
  • Rows Removed by Filter: 0
10. 33.663 1,082.169 ↑ 4,659.0 1 32,793

Nested Loop (cost=0.84..4.36 rows=4,659 width=14) (actual time=0.032..0.033 rows=1 loops=32,793)

11. 852.618 852.618 ↑ 1.0 1 32,793

Index Scan using ind_reg_sending_delo_id on reg_sending s (cost=0.43..2.79 rows=1 width=12) (actual time=0.025..0.026 rows=1 loops=32,793)

  • Index Cond: (delo_id = post.delo_id)
12. 195.888 195.888 ↑ 1.0 1 32,648

Index Scan using reg_registry_pkey on reg_registry reg (cost=0.41..1.56 rows=1 width=14) (actual time=0.006..0.006 rows=1 loops=32,648)

  • Index Cond: (id = s.reg_id)
  • Filter: ((reg_type = ANY ('{4,10}'::integer[])) AND ((ogai_kod)::text = '45597'::text))
13. 4,951.743 4,951.743 ↑ 1.0 1 32,793

Index Only Scan using apr_decis_postn_b on decis gibdd_v (cost=0.56..1.76 rows=1 width=24) (actual time=0.148..0.151 rows=1 loops=32,793)

  • Index Cond: (post_n = (post.doc_n)::text)
  • Heap Fetches: 18,667
14. 6,853.737 6,853.737 ↑ 4.0 1 32,793

Index Scan using rnip_icharges_supp_bill_id_index on rnip_icharges rnip (cost=0.56..10.19 rows=4 width=45) (actual time=0.139..0.209 rows=1 loops=32,793)

  • Index Cond: ((supp_bill_id)::text = (post.doc_n)::text)
  • Filter: ((change_status_meaning = 1) AND (process_status = ANY ('{-1,-2,-3,-4,-9,2,5,6}'::integer[])))
  • Rows Removed by Filter: 0
15. 852.618 852.618 ↑ 1.0 1 32,793

Index Scan using docs_signature_docs_id_category on docs_signature sign (cost=0.56..2.96 rows=1 width=14) (actual time=0.025..0.026 rows=1 loops=32,793)

  • Index Cond: ((post.docs_id = card_id) AND (card_category = '7'::numeric))
Planning time : 24.192 ms
Execution time : 47,902.939 ms