explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kMJD

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

Limit (cost=46.87..47.76 rows=1 width=2,940) (actual time=0.419..0.419 rows=0 loops=1)

2. 0.002 0.419 ↓ 0.0 0 1

Unique (cost=46.87..47.76 rows=1 width=2,940) (actual time=0.419..0.419 rows=0 loops=1)

3. 0.385 0.417 ↓ 0.0 0 1

Sort (cost=46.87..46.87 rows=1 width=2,940) (actual time=0.417..0.417 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.032 ↓ 0.0 0 1

Nested Loop Left Join (cost=7.73..46.86 rows=1 width=2,940) (actual time=0.032..0.032 rows=0 loops=1)

5. 0.000 0.032 ↓ 0.0 0 1

Nested Loop Left Join (cost=7.30..44.20 rows=1 width=2,916) (actual time=0.032..0.032 rows=0 loops=1)

6. 0.001 0.033 ↓ 0.0 0 1

Nested Loop Left Join (cost=6.87..42.51 rows=1 width=2,695) (actual time=0.032..0.033 rows=0 loops=1)

7. 0.000 0.032 ↓ 0.0 0 1

Nested Loop Left Join (cost=6.44..39.85 rows=1 width=2,643) (actual time=0.032..0.032 rows=0 loops=1)

8. 0.000 0.032 ↓ 0.0 0 1

Nested Loop Left Join (cost=6.01..37.19 rows=1 width=2,526) (actual time=0.032..0.032 rows=0 loops=1)

9. 0.001 0.032 ↓ 0.0 0 1

Nested Loop Left Join (cost=5.58..34.54 rows=1 width=2,374) (actual time=0.032..0.032 rows=0 loops=1)

10. 0.001 0.031 ↓ 0.0 0 1

Nested Loop Left Join (cost=5.16..31.88 rows=1 width=2,257) (actual time=0.031..0.031 rows=0 loops=1)

11. 0.000 0.030 ↓ 0.0 0 1

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

12. 0.000 0.030 ↓ 0.0 0 1

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

13. 0.000 0.030 ↓ 0.0 0 1

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

14. 0.000 0.030 ↓ 0.0 0 1

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

15. 0.000 0.030 ↓ 0.0 0 1

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

16. 0.000 0.030 ↓ 0.0 0 1

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

17. 0.000 0.030 ↓ 0.0 0 1

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

18. 0.001 0.031 ↓ 0.0 0 1

Nested Loop (cost=1.86..10.77 rows=1 width=880) (actual time=0.030..0.031 rows=0 loops=1)

19. 0.001 0.030 ↓ 0.0 0 1

Nested Loop (cost=1.43..8.11 rows=1 width=701) (actual time=0.030..0.030 rows=0 loops=1)

20. 0.029 0.029 ↓ 0.0 0 1

Nested Loop (cost=1.00..5.45 rows=1 width=548) (actual time=0.029..0.029 rows=0 loops=1)

  • -> Index Scan using account_entry_document_id_ent_id on account_entry (cost=0.56..2.79 rows=1 width=365) (actual time=0.029..0.029 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..2.65 rows=1 width=183) (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..2.65 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..2.65 rows=1 width=179) (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..2.51 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..2.64 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..2.64 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..2.65 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..2.65 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..2.65 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..2.65 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..2.65 rows=1 width=152) (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..2.64 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..2.65 rows=1 width=152) (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..2.64 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..2.65 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..1.68 rows=1 width=221) (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..2.65 rows=1 width=24) (never executed)

  • Index Cond: (account_entry.id = second_entry_id)