explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QfaJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 325.574 ↓ 200.0 200 1

Limit (cost=147.29..148.19 rows=1 width=2,937) (actual time=324.667..325.574 rows=200 loops=1)

2. 0.773 325.554 ↓ 200.0 200 1

Unique (cost=147.29..148.19 rows=1 width=2,937) (actual time=324.666..325.554 rows=200 loops=1)

3. 60.570 324.781 ↓ 200.0 200 1

Sort (cost=147.29..147.30 rows=1 width=2,937) (actual time=324.663..324.781 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: 2,429kB
4. 1.605 264.211 ↓ 1,181.0 1,181 1

Nested Loop Left Join (cost=7.73..147.28 rows=1 width=2,937) (actual time=0.241..264.211 rows=1,181 loops=1)

5. 2.331 260.244 ↓ 1,181.0 1,181 1

Nested Loop Left Join (cost=7.31..138.83 rows=1 width=2,913) (actual time=0.224..260.244 rows=1,181 loops=1)

6. 1.233 254.370 ↓ 1,181.0 1,181 1

Nested Loop Left Join (cost=6.87..135.32 rows=1 width=2,691) (actual time=0.205..254.370 rows=1,181 loops=1)

7. 1.405 204.716 ↓ 1,181.0 1,181 1

Nested Loop Left Join (cost=6.44..126.85 rows=1 width=2,639) (actual time=0.189..204.716 rows=1,181 loops=1)

8. 1.421 203.311 ↓ 1,181.0 1,181 1

Nested Loop Left Join (cost=6.01..118.40 rows=1 width=2,522) (actual time=0.186..203.311 rows=1,181 loops=1)

9. 1.705 201.890 ↓ 1,181.0 1,181 1

Nested Loop Left Join (cost=5.58..109.94 rows=1 width=2,371) (actual time=0.182..201.890 rows=1,181 loops=1)

10. 1.423 196.642 ↓ 1,181.0 1,181 1

Nested Loop Left Join (cost=5.16..101.49 rows=1 width=2,254) (actual time=0.164..196.642 rows=1,181 loops=1)

11. 1.449 195.219 ↓ 1,181.0 1,181 1

Nested Loop Left Join (cost=4.73..93.03 rows=1 width=2,103) (actual time=0.160..195.219 rows=1,181 loops=1)

12. 4.367 193.770 ↓ 1,181.0 1,181 1

Nested Loop Left Join (cost=4.30..84.58 rows=1 width=1,917) (actual time=0.156..193.770 rows=1,181 loops=1)

13. 18.132 187.041 ↓ 1,181.0 1,181 1

Nested Loop Left Join (cost=3.87..76.12 rows=1 width=1,731) (actual time=0.139..187.041 rows=1,181 loops=1)

14. 1.904 168.909 ↓ 1,181.0 1,181 1

Nested Loop Left Join (cost=3.44..67.66 rows=1 width=1,560) (actual time=0.136..168.909 rows=1,181 loops=1)

15. 1.151 150.471 ↓ 1,181.0 1,181 1

Nested Loop Left Join (cost=3.00..59.20 rows=1 width=1,389) (actual time=0.121..150.471 rows=1,181 loops=1)

16. 33.873 149.320 ↓ 1,181.0 1,181 1

Nested Loop Left Join (cost=2.58..50.74 rows=1 width=1,196) (actual time=0.118..149.320 rows=1,181 loops=1)

17. 1.003 113.085 ↓ 1,181.0 1,181 1

Nested Loop Left Join (cost=2.15..42.29 rows=1 width=1,003) (actual time=0.104..113.085 rows=1,181 loops=1)

18. 1.864 109.720 ↓ 1,181.0 1,181 1

Nested Loop (cost=1.86..33.98 rows=1 width=880) (actual time=0.091..109.720 rows=1,181 loops=1)

19. 1.338 105.494 ↓ 1,181.0 1,181 1

Nested Loop (cost=1.43..25.51 rows=1 width=702) (actual time=0.074..105.494 rows=1,181 loops=1)

20. 4.952 78.174 ↓ 1,181.0 1,181 1

Nested Loop (cost=1.00..17.06 rows=1 width=549) (actual time=0.057..78.174 rows=1,181 loops=1)

  • -> Index Scan using account_ent_documen_4e8349_idx on account_entry (cost=0.56..8.59 rows=1 width=365) (actual time=0.038..3.329 rows=1,181 (...)
  • Index Cond: ((document_id = 22,696,650) AND (ent_id = 3,970))
  • Filter: (block = ANY ('{1,3,5,6,10,17}'::integer[]))
21. 73.222 73.222 ↑ 1.0 1 1,181

Index Scan using document_base_pkey on document_base (cost=0.43..8.45 rows=1 width=184) (actual time=0.062..0.062 rows=1 loops=1,181)

  • Index Cond: (id = 22,696,650)
22. 25.982 25.982 ↑ 1.0 1 1,181

Index Scan using document_types_pkey on document_types (cost=0.43..8.45 rows=1 width=153) (actual time=0.022..0.022 rows=1 loops=1,181)

  • Index Cond: (id = account_entry.document_type_id)
23. 2.362 2.362 ↑ 1.0 1 1,181

Index Scan using document_operations_pkey on document_operations (cost=0.44..8.46 rows=1 width=178) (actual time=0.002..0.002 rows=1 loops=1,181)

  • Index Cond: (id = account_entry.operation_id)
24. 2.362 2.362 ↑ 1.0 1 1,181

Index Scan using kbk_activity_type_pkey on kbk_activity_type (cost=0.29..8.31 rows=1 width=123) (actual time=0.002..0.002 rows=1 loops=1,181)

  • Index Cond: (account_entry.kvd_id = id)
25. 2.362 2.362 ↑ 1.0 1 1,181

Index Scan using kbk_pkey on kbk (cost=0.42..8.44 rows=1 width=193) (actual time=0.002..0.002 rows=1 loops=1,181)

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

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

  • Index Cond: (account_entry.credit_kbk_id = id)
27. 16.534 16.534 ↑ 1.0 1 1,181

Index Scan using account_chart_pkey on account_chart (cost=0.43..8.45 rows=1 width=171) (actual time=0.014..0.014 rows=1 loops=1,181)

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

Index Scan using account_chart_pkey on account_chart t10 (cost=0.43..8.45 rows=1 width=171) (actual time=0.000..0.000 rows=0 loops=1,181)

  • Index Cond: (account_entry.credit_account_id = id)
29. 2.362 2.362 ↑ 1.0 1 1,181

Index Scan using kbk_kosgu_pkey on kbk_kosgu (cost=0.43..8.45 rows=1 width=186) (actual time=0.002..0.002 rows=1 loops=1,181)

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

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

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

Index Scan using unidictrec_pkey on unidictrec (cost=0.43..8.45 rows=1 width=151) (actual time=0.000..0.000 rows=0 loops=1,181)

  • Index Cond: (account_entry.debet_kvd_analytic_id = id)
32. 3.543 3.543 ↑ 1.0 1 1,181

Index Scan using account_view_accelerator_pkey on account_view_accelerator (cost=0.42..8.44 rows=1 width=117) (actual time=0.003..0.003 rows=1 loops=1,181)

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

Index Scan using unidictrec_pkey on unidictrec t15 (cost=0.43..8.45 rows=1 width=151) (actual time=0.000..0.000 rows=0 loops=1,181)

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

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

  • Index Cond: (account_entry.credit_analytic1_id = id)
35. 48.421 48.421 ↑ 1.0 1 1,181

Index Scan using account_entry_spec_entry_id on account_entry_spec (cost=0.43..8.45 rows=1 width=52) (actual time=0.040..0.041 rows=1 loops=1,181)

  • Index Cond: (account_entry.id = entry_id)
36. 3.543 3.543 ↑ 1.0 1 1,181

Index Scan using dicts_product_pkey on dicts_product (cost=0.43..3.50 rows=1 width=222) (actual time=0.003..0.003 rows=1 loops=1,181)

  • Index Cond: (account_entry_spec.product_id = id)
37. 2.362 2.362 ↓ 0.0 0 1,181

Index Scan using account_entry_contract_second_entry_id_key on account_entry_contract (cost=0.43..8.45 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=1,181)

  • Index Cond: (account_entry.id = second_entry_id)
Planning time : 3,369.881 ms
Execution time : 327.089 ms