explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hvjp

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

Limit (cost=59.77..60.68 rows=1 width=3,047) (actual time=0.386..0.386 rows=0 loops=1)

2. 0.000 0.386 ↓ 0.0 0 1

Unique (cost=59.77..60.68 rows=1 width=3,047) (actual time=0.386..0.386 rows=0 loops=1)

3. 0.159 0.386 ↓ 0.0 0 1

Sort (cost=59.77..59.78 rows=1 width=3,047) (actual time=0.386..0.386 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 0.227 ↓ 0.0 0 1

Nested Loop Left Join (cost=22.71..59.76 rows=1 width=3,047) (actual time=0.227..0.227 rows=0 loops=1)

5. 0.000 0.227 ↓ 0.0 0 1

Nested Loop Left Join (cost=22.29..57.12 rows=1 width=2,982) (actual time=0.227..0.227 rows=0 loops=1)

6. 0.000 0.227 ↓ 0.0 0 1

Nested Loop Left Join (cost=21.86..56.39 rows=1 width=2,761) (actual time=0.227..0.227 rows=0 loops=1)

7. 0.000 0.227 ↓ 0.0 0 1

Nested Loop Left Join (cost=21.44..53.74 rows=1 width=2,668) (actual time=0.227..0.227 rows=0 loops=1)

8. 0.000 0.227 ↓ 0.0 0 1

Nested Loop Left Join (cost=21.01..51.09 rows=1 width=2,551) (actual time=0.227..0.227 rows=0 loops=1)

9. 0.000 0.227 ↓ 0.0 0 1

Nested Loop Left Join (cost=20.58..48.43 rows=1 width=2,399) (actual time=0.227..0.227 rows=0 loops=1)

10. 0.000 0.227 ↓ 0.0 0 1

Nested Loop Left Join (cost=20.16..45.78 rows=1 width=2,282) (actual time=0.227..0.227 rows=0 loops=1)

11. 0.002 0.227 ↓ 0.0 0 1

Nested Loop Left Join (cost=19.73..43.12 rows=1 width=2,130) (actual time=0.226..0.227 rows=0 loops=1)

12. 0.000 0.225 ↓ 0.0 0 1

Nested Loop Left Join (cost=19.30..40.46 rows=1 width=1,944) (actual time=0.225..0.225 rows=0 loops=1)

13. 0.000 0.225 ↓ 0.0 0 1

Nested Loop Left Join (cost=18.87..37.80 rows=1 width=1,758) (actual time=0.225..0.225 rows=0 loops=1)

14. 0.000 0.225 ↓ 0.0 0 1

Nested Loop Left Join (cost=18.43..35.14 rows=1 width=1,586) (actual time=0.225..0.225 rows=0 loops=1)

15. 0.000 0.225 ↓ 0.0 0 1

Nested Loop Left Join (cost=18.00..32.48 rows=1 width=1,414) (actual time=0.225..0.225 rows=0 loops=1)

16. 0.001 0.225 ↓ 0.0 0 1

Nested Loop Left Join (cost=17.58..29.83 rows=1 width=1,221) (actual time=0.225..0.225 rows=0 loops=1)

17. 0.000 0.224 ↓ 0.0 0 1

Nested Loop Left Join (cost=17.15..27.18 rows=1 width=1,028) (actual time=0.224..0.224 rows=0 loops=1)

18. 0.000 0.224 ↓ 0.0 0 1

Nested Loop (cost=16.86..24.66 rows=1 width=905) (actual time=0.224..0.224 rows=0 loops=1)

19. 0.000 0.224 ↓ 0.0 0 1

Nested Loop (cost=16.43..22.00 rows=1 width=726) (actual time=0.224..0.224 rows=0 loops=1)

20. 0.000 0.224 ↓ 0.0 0 1

Nested Loop (cost=16.00..19.34 rows=1 width=573) (actual time=0.224..0.224 rows=0 loops=1)

21. 0.001 0.224 ↓ 0.0 0 1

Bitmap Heap Scan on temp_account_entry (cost=15.56..16.68 rows=1 width=390) (actual time=0.224..0.224 rows=0 loops=1)

  • Recheck Cond: (((temp_id)::text = '52f06ce1da6a49c3af1cf973f7cbb7ab'::text) AND (document_id = 24007865))
  • Filter: (ent_id = 4699)
22. 0.001 0.223 ↓ 0.0 0 1

BitmapAnd (cost=15.56..15.56 rows=1 width=0) (actual time=0.222..0.223 rows=0 loops=1)

23. 0.222 0.222 ↓ 0.0 0 1

Bitmap Index Scan on temp_account_entry_temp_id (cost=0.00..2.89 rows=19 width=0) (actual time=0.222..0.222 rows=0 loops=1)

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

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

  • Index Cond: (document_id = 24007865)
25. 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 = 24007865)
26. 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)
27. 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)
28. 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)
29. 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)
30. 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)
31. 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)
32. 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)
33. 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)
34. 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)
35. 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)
36. 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)
37. 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)
38. 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)
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.42..2.64 rows=1 width=93) (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..0.72 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.41..2.63 rows=1 width=65) (never executed)

  • Index Cond: (temp_account_entry.id = second_entry_id)
Planning time : 558.381 ms
Execution time : 2.076 ms