explain.depesz.com

PostgreSQL's explain analyze made readable

Result: liQpp

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1.761 ↓ 0.0 0 1

Limit (cost=66.17..67.08 rows=1 width=3,048) (actual time=1.761..1.761 rows=0 loops=1)

2. 0.000 1.760 ↓ 0.0 0 1

Unique (cost=66.17..67.08 rows=1 width=3,048) (actual time=1.760..1.760 rows=0 loops=1)

3. 0.164 1.760 ↓ 0.0 0 1

Sort (cost=66.17..66.18 rows=1 width=3,048) (actual time=1.760..1.760 rows=0 loops=1)

  • Sort Key: temp_account_entry.operation_num, temp_account_entry.block, temp_account_entry.id, temp_account_entry.creation_time, temp_account_entry.document_type_id, temp_account_entry.old_document_id, temp_account_entry.document_number, temp_a (...)
  • Sort Method: quicksort Memory: 25kB
4. 0.000 1.596 ↓ 0.0 0 1

Nested Loop Left Join (cost=7.69..66.16 rows=1 width=3,048) (actual time=1.596..1.596 rows=0 loops=1)

5. 0.000 1.596 ↓ 0.0 0 1

Nested Loop Left Join (cost=7.28..63.52 rows=1 width=2,983) (actual time=1.596..1.596 rows=0 loops=1)

6. 0.001 1.596 ↓ 0.0 0 1

Nested Loop Left Join (cost=6.85..62.78 rows=1 width=2,762) (actual time=1.596..1.596 rows=0 loops=1)

7. 0.000 1.595 ↓ 0.0 0 1

Nested Loop Left Join (cost=6.42..60.12 rows=1 width=2,669) (actual time=1.595..1.595 rows=0 loops=1)

8. 0.000 1.595 ↓ 0.0 0 1

Nested Loop Left Join (cost=6.00..57.47 rows=1 width=2,552) (actual time=1.595..1.595 rows=0 loops=1)

9. 0.000 1.595 ↓ 0.0 0 1

Nested Loop Left Join (cost=5.57..54.81 rows=1 width=2,400) (actual time=1.595..1.595 rows=0 loops=1)

10. 0.000 1.595 ↓ 0.0 0 1

Nested Loop Left Join (cost=5.14..52.16 rows=1 width=2,283) (actual time=1.595..1.595 rows=0 loops=1)

11. 0.000 1.595 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.71..49.50 rows=1 width=2,131) (actual time=1.595..1.595 rows=0 loops=1)

12. 0.000 1.595 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.28..46.85 rows=1 width=1,945) (actual time=1.595..1.595 rows=0 loops=1)

13. 0.000 1.595 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.85..44.19 rows=1 width=1,759) (actual time=1.595..1.595 rows=0 loops=1)

14. 0.001 1.595 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.42..41.53 rows=1 width=1,587) (actual time=1.594..1.595 rows=0 loops=1)

15. 0.000 1.594 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.99..38.87 rows=1 width=1,415) (actual time=1.594..1.594 rows=0 loops=1)

16. 0.000 1.594 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.56..36.22 rows=1 width=1,222) (actual time=1.594..1.594 rows=0 loops=1)

17. 0.000 1.594 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.14..33.56 rows=1 width=1,029) (actual time=1.594..1.594 rows=0 loops=1)

18. 0.000 1.594 ↓ 0.0 0 1

Nested Loop (cost=1.85..31.05 rows=1 width=906) (actual time=1.594..1.594 rows=0 loops=1)

19. 0.001 1.594 ↓ 0.0 0 1

Nested Loop (cost=1.41..28.38 rows=1 width=727) (actual time=1.594..1.594 rows=0 loops=1)

20. 1.593 1.593 ↓ 0.0 0 1

Nested Loop (cost=0.99..25.73 rows=1 width=574) (actual time=1.593..1.593 rows=0 loops=1)

  • -> Index Scan using temp_account_entry_temp_id on temp_account_entry (cost=0.55..23.07 rows=1 width=391) (actual time=1.593..1.593 rows=0 (...)
  • Index Cond: ((temp_id)::text = '3872cfd389fd479bad87f77fd59bcb2c'::text)
  • Filter: ((document_id = 13376863) AND (ent_id = 3910) AND (block = ANY ('{1,3,5,6,10,17}'::integer[])))
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 = 13376863)
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 = temp_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 = temp_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: (temp_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: (temp_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: (temp_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: (temp_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: (temp_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: (temp_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: (temp_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: (temp_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: (temp_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: (temp_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: (temp_account_entry.credit_analytic1_id = id)
35. 0.000 0.000 ↓ 0.0 0

Index Scan using temp_account_entry_spec_entry_id_key on temp_account_entry_spec (cost=0.42..2.64 rows=1 width=93) (never executed)

  • Index Cond: (temp_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..0.74 rows=1 width=221) (never executed)

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

Index Scan using temp_account_entry_contract_second_entry_id_key on temp_account_entry_contract (cost=0.41..2.63 rows=1 width=65) (never executed)

  • Index Cond: (temp_account_entry.id = second_entry_id)