explain.depesz.com

PostgreSQL's explain analyze made readable

Result: muWI : Optimization for: plan #5wfU

Settings

Optimization path:

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

Limit (cost=147.23..148.12 rows=1 width=2,936) (actual time=0.225..0.225 rows=0 loops=1)

2. 0.001 0.225 ↓ 0.0 0 1

Unique (cost=147.23..148.12 rows=1 width=2,936) (actual time=0.225..0.225 rows=0 loops=1)

3. 0.185 0.224 ↓ 0.0 0 1

Sort (cost=147.23..147.23 rows=1 width=2,936) (actual time=0.224..0.224 rows=0 loops=1)

  • Sort Key: account_entry.operation_num, account_entry.id, account_entry.document_type_id, account_entry.old_document_id, account_entry.document_number, account_entry.document_date, account_entry.state, account_entry.description, account_entry. (...)
  • Sort Method: quicksort Memory: 25kB
4. 0.000 0.039 ↓ 0.0 0 1

Nested Loop Left Join (cost=7.73..147.22 rows=1 width=2,936) (actual time=0.039..0.039 rows=0 loops=1)

5. 0.001 0.039 ↓ 0.0 0 1

Nested Loop Left Join (cost=7.30..138.76 rows=1 width=2,912) (actual time=0.039..0.039 rows=0 loops=1)

6. 0.000 0.038 ↓ 0.0 0 1

Nested Loop Left Join (cost=6.87..135.31 rows=1 width=2,693) (actual time=0.038..0.038 rows=0 loops=1)

7. 0.001 0.039 ↓ 0.0 0 1

Nested Loop Left Join (cost=6.44..126.84 rows=1 width=2,641) (actual time=0.038..0.039 rows=0 loops=1)

8. 0.000 0.038 ↓ 0.0 0 1

Nested Loop Left Join (cost=6.01..118.39 rows=1 width=2,524) (actual time=0.038..0.038 rows=0 loops=1)

9. 0.000 0.038 ↓ 0.0 0 1

Nested Loop Left Join (cost=5.58..109.93 rows=1 width=2,373) (actual time=0.038..0.038 rows=0 loops=1)

10. 0.001 0.038 ↓ 0.0 0 1

Nested Loop Left Join (cost=5.16..101.48 rows=1 width=2,256) (actual time=0.038..0.038 rows=0 loops=1)

11. 0.000 0.037 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.73..93.02 rows=1 width=2,105) (actual time=0.037..0.037 rows=0 loops=1)

12. 0.000 0.037 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.30..84.57 rows=1 width=1,919) (actual time=0.037..0.037 rows=0 loops=1)

13. 0.000 0.037 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.87..76.11 rows=1 width=1,733) (actual time=0.037..0.037 rows=0 loops=1)

14. 0.001 0.037 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.43..67.65 rows=1 width=1,561) (actual time=0.037..0.037 rows=0 loops=1)

15. 0.001 0.036 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.00..59.19 rows=1 width=1,389) (actual time=0.036..0.036 rows=0 loops=1)

16. 0.000 0.035 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.58..50.74 rows=1 width=1,196) (actual time=0.035..0.035 rows=0 loops=1)

17. 0.000 0.035 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.15..42.28 rows=1 width=1,003) (actual time=0.035..0.035 rows=0 loops=1)

18. 0.000 0.035 ↓ 0.0 0 1

Nested Loop (cost=1.86..33.97 rows=1 width=880) (actual time=0.035..0.035 rows=0 loops=1)

19. 0.000 0.035 ↓ 0.0 0 1

Nested Loop (cost=1.43..25.51 rows=1 width=702) (actual time=0.035..0.035 rows=0 loops=1)

20. 0.035 0.035 ↓ 0.0 0 1

Nested Loop (cost=1.00..17.05 rows=1 width=549) (actual time=0.035..0.035 rows=0 loops=1)

  • -> Index Scan using account_entry_document_id_ent_id on account_entry (cost=0.56..8.59 rows=1 width=365) (actual time=0.035..0.035 rows=0 (...)
  • Index Cond: ((document_id = 24263135) AND (ent_id = 7525))
  • Filter: (block = 2)
  • Rows Removed by Filter: 2
21. 0.000 0.000 ↓ 0.0 0

Index Scan using document_base_pkey on document_base (cost=0.43..8.45 rows=1 width=184) (never executed)

  • Index Cond: (id = 24263135)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using document_types_pkey on document_types (cost=0.43..8.45 rows=1 width=153) (never executed)

  • Index Cond: (id = account_entry.document_type_id)
23. 0.000 0.000 ↓ 0.0 0

Index Scan using document_operations_pkey on document_operations (cost=0.43..8.45 rows=1 width=178) (never executed)

  • Index Cond: (id = account_entry.operation_id)
24. 0.000 0.000 ↓ 0.0 0

Index Scan using kbk_activity_type_pkey on kbk_activity_type (cost=0.29..8.31 rows=1 width=123) (never executed)

  • Index Cond: (account_entry.kvd_id = id)
25. 0.000 0.000 ↓ 0.0 0

Index Scan using kbk_pkey on kbk (cost=0.42..8.44 rows=1 width=193) (never executed)

  • Index Cond: (account_entry.debet_kbk_id = id)
26. 0.000 0.000 ↓ 0.0 0

Index Scan using kbk_pkey on kbk t8 (cost=0.42..8.44 rows=1 width=193) (never executed)

  • Index Cond: (account_entry.credit_kbk_id = id)
27. 0.000 0.000 ↓ 0.0 0

Index Scan using account_chart_pkey on account_chart (cost=0.43..8.45 rows=1 width=172) (never executed)

  • Index Cond: (account_entry.debet_account_id = id)
28. 0.000 0.000 ↓ 0.0 0

Index Scan using account_chart_pkey on account_chart t10 (cost=0.43..8.45 rows=1 width=172) (never executed)

  • Index Cond: (account_entry.credit_account_id = id)
29. 0.000 0.000 ↓ 0.0 0

Index Scan using kbk_kosgu_pkey on kbk_kosgu (cost=0.43..8.45 rows=1 width=186) (never executed)

  • Index Cond: (account_entry.debet_kosgu_id = id)
30. 0.000 0.000 ↓ 0.0 0

Index Scan using kbk_kosgu_pkey on kbk_kosgu t12 (cost=0.43..8.45 rows=1 width=186) (never executed)

  • Index Cond: (account_entry.credit_kosgu_id = id)
31. 0.000 0.000 ↓ 0.0 0

Index Scan using unidictrec_pkey on unidictrec (cost=0.43..8.45 rows=1 width=151) (never executed)

  • Index Cond: (account_entry.debet_kvd_analytic_id = id)
32. 0.000 0.000 ↓ 0.0 0

Index Scan using account_view_accelerator_pkey on account_view_accelerator (cost=0.42..8.44 rows=1 width=117) (never executed)

  • Index Cond: (account_entry.debet_analytic1_id = id)
33. 0.000 0.000 ↓ 0.0 0

Index Scan using unidictrec_pkey on unidictrec t15 (cost=0.43..8.45 rows=1 width=151) (never executed)

  • Index Cond: (account_entry.credit_kvd_analytic_id = id)
34. 0.000 0.000 ↓ 0.0 0

Index Scan using account_view_accelerator_pkey on account_view_accelerator t16 (cost=0.42..8.44 rows=1 width=117) (never executed)

  • Index Cond: (account_entry.credit_analytic1_id = id)
35. 0.000 0.000 ↓ 0.0 0

Index Scan using account_entry_spec_entry_id on account_entry_spec (cost=0.43..8.45 rows=1 width=52) (never executed)

  • Index Cond: (account_entry.id = entry_id)
36. 0.000 0.000 ↓ 0.0 0

Index Scan using dicts_product_pkey on dicts_product (cost=0.43..3.44 rows=1 width=219) (never executed)

  • Index Cond: (account_entry_spec.product_id = id)
37. 0.000 0.000 ↓ 0.0 0

Index Scan using account_entry_contract_second_entry_id_key on account_entry_contract (cost=0.43..8.45 rows=1 width=24) (never executed)

  • Index Cond: (account_entry.id = second_entry_id)
Planning time : 438.486 ms
Execution time : 2.020 ms