explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tKPv

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 263.945 ↓ 200.0 200 1

Limit (cost=162.77..163.66 rows=1 width=2,940) (actual time=262.905..263.945 rows=200 loops=1)

2. 0.915 263.916 ↓ 200.0 200 1

Unique (cost=162.77..163.66 rows=1 width=2,940) (actual time=262.904..263.916 rows=200 loops=1)

3. 16.038 263.001 ↓ 200.0 200 1

Sort (cost=162.77..162.77 rows=1 width=2,940) (actual time=262.903..263.001 rows=200 loops=1)

  • Sort Key: account_entry.operation_num, account_entry.block, 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.descri (...)
  • Sort Method: quicksort Memory: 5531kB
4. 4.024 246.963 ↓ 2,492.0 2,492 1

Nested Loop Left Join (cost=7.73..162.76 rows=1 width=2,940) (actual time=1.740..246.963 rows=2,492 loops=1)

5. 5.156 232.971 ↓ 2,492.0 2,492 1

Nested Loop Left Join (cost=7.30..160.10 rows=1 width=2,916) (actual time=1.482..232.971 rows=2,492 loops=1)

6. 5.472 205.387 ↓ 2,492.0 2,492 1

Nested Loop Left Join (cost=6.87..158.41 rows=1 width=2,695) (actual time=1.174..205.387 rows=2,492 loops=1)

7. 4.382 172.503 ↓ 2,492.0 2,492 1

Nested Loop Left Join (cost=6.44..155.75 rows=1 width=2,643) (actual time=0.769..172.503 rows=2,492 loops=1)

8. 4.709 168.121 ↓ 2,492.0 2,492 1

Nested Loop Left Join (cost=6.01..153.09 rows=1 width=2,526) (actual time=0.766..168.121 rows=2,492 loops=1)

9. 5.130 155.936 ↓ 2,492.0 2,492 1

Nested Loop Left Join (cost=5.58..150.44 rows=1 width=2,374) (actual time=0.760..155.936 rows=2,492 loops=1)

10. 4.334 140.838 ↓ 2,492.0 2,492 1

Nested Loop Left Join (cost=5.16..147.78 rows=1 width=2,257) (actual time=0.746..140.838 rows=2,492 loops=1)

11. 4.184 126.536 ↓ 2,492.0 2,492 1

Nested Loop Left Join (cost=4.73..145.13 rows=1 width=2,105) (actual time=0.729..126.536 rows=2,492 loops=1)

12. 4.373 122.352 ↓ 2,492.0 2,492 1

Nested Loop Left Join (cost=4.30..142.47 rows=1 width=1,919) (actual time=0.724..122.352 rows=2,492 loops=1)

13. 3.917 108.011 ↓ 2,492.0 2,492 1

Nested Loop Left Join (cost=3.87..139.81 rows=1 width=1,733) (actual time=0.700..108.011 rows=2,492 loops=1)

14. 4.270 104.094 ↓ 2,492.0 2,492 1

Nested Loop Left Join (cost=3.43..137.15 rows=1 width=1,561) (actual time=0.696..104.094 rows=2,492 loops=1)

15. 3.638 89.856 ↓ 2,492.0 2,492 1

Nested Loop Left Join (cost=3.00..134.49 rows=1 width=1,389) (actual time=0.442..89.856 rows=2,492 loops=1)

16. 3.273 86.218 ↓ 2,492.0 2,492 1

Nested Loop Left Join (cost=2.58..131.84 rows=1 width=1,196) (actual time=0.440..86.218 rows=2,492 loops=1)

17. 4.236 72.977 ↓ 2,492.0 2,492 1

Nested Loop Left Join (cost=2.15..129.19 rows=1 width=1,003) (actual time=0.426..72.977 rows=2,492 loops=1)

18. 3.429 61.265 ↓ 2,492.0 2,492 1

Nested Loop (cost=1.86..126.67 rows=1 width=880) (actual time=0.413..61.265 rows=2,492 loops=1)

19. 2.663 47.868 ↓ 2,492.0 2,492 1

Nested Loop (cost=1.43..124.01 rows=1 width=701) (actual time=0.248..47.868 rows=2,492 loops=1)

20. 25.269 35.237 ↓ 2,492.0 2,492 1

Nested Loop (cost=1.00..121.35 rows=1 width=548) (actual time=0.231..35.237 rows=2,492 loops=1)

  • -> Index Scan using account_entry_document_id on account_entry (cost=0.56..118.69 rows=1 width=365) (actual time=0.218..21.555 rows=2492 l (...)
  • Index Cond: (document_id = 22680191)
  • Filter: ((ent_id = 4792) AND (block = ANY ('{1,3,5,6,10,17}'::integer[])))
21. 9.968 9.968 ↑ 1.0 1 2,492

Index Scan using document_base_pkey on document_base (cost=0.43..2.65 rows=1 width=183) (actual time=0.004..0.004 rows=1 loops=2,492)

  • Index Cond: (id = 22680191)
22. 9.968 9.968 ↑ 1.0 1 2,492

Index Scan using document_types_pkey on document_types (cost=0.43..2.65 rows=1 width=153) (actual time=0.003..0.004 rows=1 loops=2,492)

  • Index Cond: (id = account_entry.document_type_id)
23. 9.968 9.968 ↑ 1.0 1 2,492

Index Scan using document_operations_pkey on document_operations (cost=0.43..2.65 rows=1 width=179) (actual time=0.004..0.004 rows=1 loops=2,492)

  • Index Cond: (id = account_entry.operation_id)
24. 7.476 7.476 ↑ 1.0 1 2,492

Index Scan using kbk_activity_type_pkey on kbk_activity_type (cost=0.29..2.51 rows=1 width=123) (actual time=0.003..0.003 rows=1 loops=2,492)

  • Index Cond: (account_entry.kvd_id = id)
25. 9.968 9.968 ↑ 1.0 1 2,492

Index Scan using kbk_pkey on kbk (cost=0.42..2.64 rows=1 width=193) (actual time=0.003..0.004 rows=1 loops=2,492)

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

Index Scan using kbk_pkey on kbk t8 (cost=0.42..2.64 rows=1 width=193) (actual time=0.000..0.000 rows=0 loops=2,492)

  • Index Cond: (account_entry.credit_kbk_id = id)
27. 9.968 9.968 ↑ 1.0 1 2,492

Index Scan using account_chart_pkey on account_chart (cost=0.43..2.65 rows=1 width=172) (actual time=0.004..0.004 rows=1 loops=2,492)

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

Index Scan using account_chart_pkey on account_chart t10 (cost=0.43..2.65 rows=1 width=172) (actual time=0.000..0.000 rows=0 loops=2,492)

  • Index Cond: (account_entry.credit_account_id = id)
29. 9.968 9.968 ↑ 1.0 1 2,492

Index Scan using kbk_kosgu_pkey on kbk_kosgu (cost=0.43..2.65 rows=1 width=186) (actual time=0.004..0.004 rows=1 loops=2,492)

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

Index Scan using kbk_kosgu_pkey on kbk_kosgu t12 (cost=0.43..2.65 rows=1 width=186) (actual time=0.000..0.000 rows=0 loops=2,492)

  • Index Cond: (account_entry.credit_kosgu_id = id)
31. 9.968 9.968 ↑ 1.0 1 2,492

Index Scan using unidictrec_pkey on unidictrec (cost=0.43..2.65 rows=1 width=152) (actual time=0.004..0.004 rows=1 loops=2,492)

  • Index Cond: (account_entry.debet_kvd_analytic_id = id)
32. 9.968 9.968 ↑ 1.0 1 2,492

Index Scan using account_view_accelerator_pkey on account_view_accelerator (cost=0.42..2.64 rows=1 width=117) (actual time=0.004..0.004 rows=1 loops=2,492)

  • Index Cond: (account_entry.debet_analytic1_id = id)
33. 7.476 7.476 ↑ 1.0 1 2,492

Index Scan using unidictrec_pkey on unidictrec t15 (cost=0.43..2.65 rows=1 width=152) (actual time=0.003..0.003 rows=1 loops=2,492)

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

Index Scan using account_view_accelerator_pkey on account_view_accelerator t16 (cost=0.42..2.64 rows=1 width=117) (actual time=0.000..0.000 rows=0 loops=2,492)

  • Index Cond: (account_entry.credit_analytic1_id = id)
35. 27.412 27.412 ↑ 1.0 1 2,492

Index Scan using account_entry_spec_entry_id on account_entry_spec (cost=0.43..2.65 rows=1 width=52) (actual time=0.011..0.011 rows=1 loops=2,492)

  • Index Cond: (account_entry.id = entry_id)
36. 22.428 22.428 ↑ 1.0 1 2,492

Index Scan using dicts_product_pkey on dicts_product (cost=0.43..1.68 rows=1 width=221) (actual time=0.008..0.009 rows=1 loops=2,492)

  • Index Cond: (account_entry_spec.product_id = id)
37. 9.968 9.968 ↓ 0.0 0 2,492

Index Scan using account_entry_contract_second_entry_id_key on account_entry_contract (cost=0.43..2.65 rows=1 width=24) (actual time=0.004..0.004 rows=0 loops=2,492)

  • Index Cond: (account_entry.id = second_entry_id)