explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VZcd

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.258 ↓ 0.0 0 1

Limit (cost=150.91..151.81 rows=1 width=3,022) (actual time=0.258..0.258 rows=0 loops=1)

2. 0.000 0.256 ↓ 0.0 0 1

Unique (cost=150.91..151.81 rows=1 width=3,022) (actual time=0.256..0.256 rows=0 loops=1)

3. 0.222 0.256 ↓ 0.0 0 1

Sort (cost=150.91..150.91 rows=1 width=3,022) (actual time=0.256..0.256 rows=0 loops=1)

  • Sort Key: temp_account_entry.operation_num, 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_account_entry.document_date (...)
  • Sort Method: quicksort Memory: 25kB
4. 0.000 0.034 ↓ 0.0 0 1

Nested Loop Left Join (cost=17.87..150.90 rows=1 width=3,022) (actual time=0.034..0.034 rows=0 loops=1)

5. 0.000 0.034 ↓ 0.0 0 1

Nested Loop Left Join (cost=17.58..142.58 rows=1 width=2,957) (actual time=0.034..0.034 rows=0 loops=1)

6. 0.001 0.034 ↓ 0.0 0 1

Nested Loop Left Join (cost=17.15..141.58 rows=1 width=2,736) (actual time=0.034..0.034 rows=0 loops=1)

7. 0.000 0.033 ↓ 0.0 0 1

Nested Loop Left Join (cost=16.72..133.12 rows=1 width=2,644) (actual time=0.033..0.033 rows=0 loops=1)

8. 0.000 0.033 ↓ 0.0 0 1

Nested Loop Left Join (cost=16.29..124.67 rows=1 width=2,528) (actual time=0.033..0.033 rows=0 loops=1)

9. 0.000 0.033 ↓ 0.0 0 1

Nested Loop Left Join (cost=15.87..116.22 rows=1 width=2,387) (actual time=0.033..0.033 rows=0 loops=1)

10. 0.000 0.033 ↓ 0.0 0 1

Nested Loop Left Join (cost=15.44..107.76 rows=1 width=2,271) (actual time=0.033..0.033 rows=0 loops=1)

11. 0.001 0.033 ↓ 0.0 0 1

Nested Loop Left Join (cost=15.01..99.31 rows=1 width=2,130) (actual time=0.033..0.033 rows=0 loops=1)

12. 0.000 0.032 ↓ 0.0 0 1

Nested Loop Left Join (cost=14.59..90.85 rows=1 width=1,947) (actual time=0.032..0.032 rows=0 loops=1)

13. 0.000 0.032 ↓ 0.0 0 1

Nested Loop Left Join (cost=14.16..82.40 rows=1 width=1,764) (actual time=0.032..0.032 rows=0 loops=1)

14. 0.001 0.033 ↓ 0.0 0 1

Nested Loop Left Join (cost=13.73..73.94 rows=1 width=1,593) (actual time=0.032..0.033 rows=0 loops=1)

15. 0.000 0.032 ↓ 0.0 0 1

Nested Loop Left Join (cost=13.29..65.48 rows=1 width=1,422) (actual time=0.032..0.032 rows=0 loops=1)

16. 0.000 0.032 ↓ 0.0 0 1

Nested Loop Left Join (cost=12.87..57.03 rows=1 width=1,229) (actual time=0.032..0.032 rows=0 loops=1)

17. 0.001 0.032 ↓ 0.0 0 1

Nested Loop Left Join (cost=12.44..48.57 rows=1 width=1,036) (actual time=0.032..0.032 rows=0 loops=1)

18. 0.001 0.031 ↓ 0.0 0 1

Nested Loop (cost=12.15..40.26 rows=1 width=914) (actual time=0.031..0.031 rows=0 loops=1)

19. 0.000 0.030 ↓ 0.0 0 1

Nested Loop (cost=11.72..31.79 rows=1 width=737) (actual time=0.030..0.030 rows=0 loops=1)

20. 0.000 0.030 ↓ 0.0 0 1

Nested Loop (cost=11.29..23.34 rows=1 width=586) (actual time=0.030..0.030 rows=0 loops=1)

21. 0.001 0.030 ↓ 0.0 0 1

Bitmap Heap Scan on temp_account_entry (cost=10.86..14.88 rows=1 width=403) (actual time=0.030..0.030 rows=0 loops=1)

  • Recheck Cond: (((temp_id)::text = '1ae19002263b43e9ba354a9ee0379723'::text) AND (document_id = 23071063))
  • Filter: ((block = 4) AND (ent_id = 3910))
22. 0.000 0.029 ↓ 0.0 0 1

BitmapAnd (cost=10.86..10.86 rows=1 width=0) (actual time=0.029..0.029 rows=0 loops=1)

23. 0.030 0.030 ↓ 0.0 0 1

Bitmap Index Scan on temp_account_entry_temp_id (cost=0.00..5.11 rows=74 width=0) (actual time=0.029..0.030 rows=0 loops=1)

  • Index Cond: ((temp_id)::text = '1ae19002263b43e9ba354a9ee0379723'::text)
24. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on temp_account_entry_document_id (cost=0.00..5.49 rows=142 width=0) (never executed)

  • Index Cond: (document_id = 23071063)
25. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: (id = temp_account_entry.document_type_id)
27. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = temp_account_entry.operation_id)
28. 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=122) (never executed)

  • Index Cond: (temp_account_entry.kvd_id = id)
29. 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: (temp_account_entry.debet_kbk_id = id)
30. 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: (temp_account_entry.credit_kbk_id = id)
31. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (temp_account_entry.debet_account_id = id)
32. 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=171) (never executed)

  • Index Cond: (temp_account_entry.credit_account_id = id)
33. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (temp_account_entry.debet_kosgu_id = id)
34. 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=183) (never executed)

  • Index Cond: (temp_account_entry.credit_kosgu_id = id)
35. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (temp_account_entry.debet_kvd_analytic_id = id)
36. 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=116) (never executed)

  • Index Cond: (temp_account_entry.debet_analytic1_id = id)
37. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (temp_account_entry.credit_kvd_analytic_id = id)
38. 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=116) (never executed)

  • Index Cond: (temp_account_entry.credit_analytic1_id = id)
39. 0.000 0.000 ↓ 0.0 0

Index Scan using temp_account_entry_spec_entry_id_key on temp_account_entry_spec (cost=0.43..8.45 rows=1 width=92) (never executed)

  • Index Cond: (temp_account_entry.id = entry_id)
40. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (temp_account_entry_spec.product_id = id)
41. 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.29..8.30 rows=1 width=65) (never executed)

  • Index Cond: (temp_account_entry.id = second_entry_id)