explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FWPZ : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.073 10,352.087 ↑ 1.0 20 1

Limit (cost=634,776.82..678,155.93 rows=20 width=208) (actual time=9,696.471..10,352.087 rows=20 loops=1)

2. 0.277 10,352.014 ↑ 11.7 20 1

Result (cost=634,776.82..1,140,143.50 rows=233 width=208) (actual time=9,696.469..10,352.014 rows=20 loops=1)

3. 0.188 9,664.817 ↑ 11.7 20 1

Sort (cost=634,776.82..634,777.40 rows=233 width=176) (actual time=9,664.798..9,664.817 rows=20 loops=1)

  • Sort Key: parent.name, chart_of_accounts.name
  • Sort Method: quicksort Memory: 35kB
4. 0.113 9,664.629 ↑ 5.8 40 1

Nested Loop Left Join (cost=1.27..634,770.62 rows=233 width=176) (actual time=42.719..9,664.629 rows=40 loops=1)

5. 1.234 9,664.476 ↑ 5.8 40 1

Nested Loop (cost=0.84..634,636.39 rows=233 width=158) (actual time=42.706..9,664.476 rows=40 loops=1)

6. 0.732 0.732 ↓ 1.1 319 1

Index Scan using index_business_chart_of_accounts_unique on business_chart_of_accounts (cost=0.42..1,130.95 rows=291 width=7) (actual time=0.016..0.732 rows=319 loops=1)

  • Index Cond: (business_id = 810)
  • Filter: (deleted_at IS NULL)
7. 4.912 9,662.510 ↓ 0.0 0 319

Index Scan using index_chart_of_accounts_on_id on chart_of_accounts (cost=0.42..2,176.99 rows=1 width=155) (actual time=30.290..30.290 rows=0 loops=319)

  • Index Cond: (id = business_chart_of_accounts.chart_of_account_id)
  • Filter: ((NOT hidden) AND (((SubPlan 5) > 0) OR ((SubPlan 6) > 0) OR ((SubPlan 7) > 0) OR ((SubPlan 8) > 0)))
  • Rows Removed by Filter: 1
8.          

SubPlan (for Index Scan)

9. 1.272 3,597.216 ↑ 1.0 1 318

Aggregate (cost=791.02..791.03 rows=1 width=8) (actual time=11.312..11.312 rows=1 loops=318)

10. 21.624 3,595.944 ↓ 0.0 0 318

Nested Loop Left Join (cost=39.13..790.89 rows=53 width=0) (actual time=10.897..11.308 rows=0 loops=318)

  • Filter: (((service_document_splits_3.id IS NULL) AND (service_documents_1.chart_of_account_id = chart_of_accounts.id)) OR (service_document_splits_3.id IS NOT NULL))
  • Rows Removed by Filter: 65
11. 1,301.542 3,532.980 ↓ 1.2 65 318

Hash Join (cost=38.85..772.18 rows=53 width=8) (actual time=0.029..11.110 rows=65 loops=318)

  • Hash Cond: (service_documents_1.business_advisor_id = business_advisors_4.id)
12. 2,231.406 2,231.406 ↓ 1.0 18,439 318

Seq Scan on service_documents service_documents_1 (cost=0.00..684.98 rows=18,398 width=12) (actual time=0.003..7.017 rows=18,439 loops=318)

13. 0.009 0.032 ↑ 1.0 11 1

Hash (cost=38.71..38.71 rows=11 width=4) (actual time=0.031..0.032 rows=11 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
14. 0.015 0.023 ↑ 1.0 11 1

Bitmap Heap Scan on business_advisors business_advisors_4 (cost=4.37..38.71 rows=11 width=4) (actual time=0.013..0.023 rows=11 loops=1)

  • Recheck Cond: (business_id = 810)
  • Heap Blocks: exact=8
15. 0.008 0.008 ↑ 1.0 11 1

Bitmap Index Scan on index_business_advisors_on_business_id (cost=0.00..4.36 rows=11 width=0) (actual time=0.008..0.008 rows=11 loops=1)

  • Index Cond: (business_id = 810)
16. 41.340 41.340 ↓ 0.0 0 20,670

Index Scan using idx_service_document_splits_service_document on service_document_splits service_document_splits_3 (cost=0.28..0.34 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=20,670)

  • Index Cond: (((service_document_type)::text = 'ServiceDocument'::text) AND (service_document_id = service_documents_1.id))
  • Filter: (chart_of_account_id = chart_of_accounts.id)
  • Rows Removed by Filter: 0
17. 3.887 785.174 ↑ 1.0 1 299

Aggregate (cost=159.09..159.10 rows=1 width=8) (actual time=2.625..2.626 rows=1 loops=299)

18. 18.538 781.287 ↓ 0.0 0 299

Nested Loop Left Join (cost=39.13..159.06 rows=10 width=0) (actual time=2.591..2.613 rows=0 loops=299)

  • Filter: (((service_document_splits_4.id IS NULL) AND (receipt_service_documents_1.chart_of_account_id = chart_of_accounts.id)) OR (service_document_splits_4.id IS NOT NULL))
  • Rows Removed by Filter: 88
19. 240.962 710.125 ↓ 8.8 88 299

Hash Join (cost=38.85..155.12 rows=10 width=8) (actual time=0.188..2.375 rows=88 loops=299)

  • Hash Cond: (receipt_service_documents_1.receipt_service_id = business_advisors_5.id)
20. 469.131 469.131 ↑ 1.0 3,585 299

Seq Scan on receipt_service_documents receipt_service_documents_1 (cost=0.00..106.85 rows=3,585 width=12) (actual time=0.002..1.569 rows=3,585 loops=299)

21. 0.006 0.032 ↑ 1.0 11 1

Hash (cost=38.71..38.71 rows=11 width=4) (actual time=0.032..0.032 rows=11 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
22. 0.015 0.026 ↑ 1.0 11 1

Bitmap Heap Scan on business_advisors business_advisors_5 (cost=4.37..38.71 rows=11 width=4) (actual time=0.016..0.026 rows=11 loops=1)

  • Recheck Cond: (business_id = 810)
  • Heap Blocks: exact=8
23. 0.011 0.011 ↑ 1.0 11 1

Bitmap Index Scan on index_business_advisors_on_business_id (cost=0.00..4.36 rows=11 width=0) (actual time=0.011..0.011 rows=11 loops=1)

  • Index Cond: (business_id = 810)
24. 52.624 52.624 ↓ 0.0 0 26,312

Index Scan using idx_service_document_splits_service_document on service_document_splits service_document_splits_4 (cost=0.28..0.38 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=26,312)

  • Index Cond: (((service_document_type)::text = 'ReceiptServiceDocument'::text) AND (service_document_id = receipt_service_documents_1.id))
  • Filter: (chart_of_account_id = chart_of_accounts.id)
  • Rows Removed by Filter: 0
25. 0.588 22.344 ↑ 1.0 1 294

Aggregate (cost=17.28..17.29 rows=1 width=8) (actual time=0.076..0.076 rows=1 loops=294)

26. 0.814 21.756 ↓ 0.0 0 294

Nested Loop (cost=12.66..17.27 rows=1 width=0) (actual time=0.073..0.074 rows=0 loops=294)

  • Join Filter: (revenue_service_documents_1.revenue_service_id = business_advisors_6.id)
27. 1.075 20.286 ↓ 2.0 2 294

Nested Loop (cost=12.38..16.37 rows=1 width=12) (actual time=0.059..0.069 rows=2 loops=294)

28. 1.470 18.228 ↓ 1.5 3 294

Merge Join (cost=12.23..15.65 rows=2 width=12) (actual time=0.057..0.062 rows=3 loops=294)

  • Merge Cond: (revenue_service_documents_1.revenue_service_id = revenue_service_categories_1.revenue_service_id)
29. 2.352 2.352 ↑ 53.2 5 294

Index Scan using index_revenue_service_documents_on_revenue_service_id on revenue_service_documents revenue_service_documents_1 (cost=0.15..20.45 rows=266 width=8) (actual time=0.006..0.008 rows=5 loops=294)

30. 1.176 14.406 ↓ 0.0 0 294

Materialize (cost=12.08..12.09 rows=1 width=4) (actual time=0.048..0.049 rows=0 loops=294)

31. 2.058 13.230 ↓ 0.0 0 294

Sort (cost=12.08..12.08 rows=1 width=4) (actual time=0.045..0.045 rows=0 loops=294)

  • Sort Key: revenue_service_categories_1.revenue_service_id
  • Sort Method: quicksort Memory: 25kB
32. 2.086 11.172 ↓ 0.0 0 294

Hash Join (cost=5.78..12.07 rows=1 width=4) (actual time=0.035..0.038 rows=0 loops=294)

  • Hash Cond: (revenue_report_type_categories_1.revenue_service_category_id = revenue_service_categories_1.id)
33. 0.560 0.560 ↑ 1.1 243 10

Seq Scan on revenue_report_type_categories revenue_report_type_categories_1 (cost=0.00..5.60 rows=260 width=4) (actual time=0.002..0.056 rows=243 loops=10)

34. 0.588 8.526 ↓ 0.0 0 294

Hash (cost=5.76..5.76 rows=1 width=8) (actual time=0.029..0.029 rows=0 loops=294)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
35. 7.938 7.938 ↓ 0.0 0 294

Seq Scan on revenue_service_categories revenue_service_categories_1 (cost=0.00..5.76 rows=1 width=8) (actual time=0.026..0.027 rows=0 loops=294)

  • Filter: (chart_of_account_id = chart_of_accounts.id)
  • Rows Removed by Filter: 260
36. 0.983 0.983 ↑ 1.0 1 983

Index Scan using revenue_report_types_pkey on revenue_report_types revenue_report_types_1 (cost=0.15..0.35 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=983)

  • Index Cond: (id = revenue_service_documents_1.revenue_report_type_id)
  • Filter: (revenue_service_documents_1.revenue_service_id = revenue_service_id)
37. 0.656 0.656 ↓ 0.0 0 656

Index Scan using business_advisors_pkey on business_advisors business_advisors_6 (cost=0.28..0.89 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=656)

  • Index Cond: (id = revenue_report_types_1.revenue_service_id)
  • Filter: (business_id = 810)
  • Rows Removed by Filter: 1
38. 1.156 5,252.864 ↑ 1.0 1 289

Aggregate (cost=1,201.52..1,201.53 rows=1 width=8) (actual time=18.175..18.176 rows=1 loops=289)

39. 194.208 5,251.708 ↓ 0.0 0 289

Hash Left Join (cost=51.98..1,201.31 rows=81 width=0) (actual time=17.965..18.172 rows=0 loops=289)

  • Hash Cond: (transaction_service_documents_1.id = service_document_splits_5.service_document_id)
  • Filter: (((service_document_splits_5.id IS NULL) AND (transaction_service_documents_1.chart_of_account_id = chart_of_accounts.id)) OR (service_document_splits_5.id IS NOT NULL))
  • Rows Removed by Filter: 2,416
40. 2,045.229 5,054.899 ↓ 29.8 2,416 289

Hash Join (cost=38.85..1,187.87 rows=81 width=8) (actual time=0.023..17.491 rows=2,416 loops=289)

  • Hash Cond: (transaction_service_documents_1.reconciliation_service_id = business_advisors_7.id)
41. 3,009.646 3,009.646 ↓ 1.0 28,134 289

Seq Scan on transaction_service_documents transaction_service_documents_1 (cost=0.00..1,075.14 rows=28,114 width=12) (actual time=0.003..10.414 rows=28,134 loops=289)

42. 0.006 0.024 ↑ 1.0 11 1

Hash (cost=38.71..38.71 rows=11 width=4) (actual time=0.023..0.024 rows=11 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
43. 0.010 0.018 ↑ 1.0 11 1

Bitmap Heap Scan on business_advisors business_advisors_7 (cost=4.37..38.71 rows=11 width=4) (actual time=0.010..0.018 rows=11 loops=1)

  • Recheck Cond: (business_id = 810)
  • Heap Blocks: exact=8
44. 0.008 0.008 ↑ 1.0 11 1

Bitmap Index Scan on index_business_advisors_on_business_id (cost=0.00..4.36 rows=11 width=0) (actual time=0.007..0.008 rows=11 loops=1)

  • Index Cond: (business_id = 810)
45. 0.578 2.601 ↓ 0.0 0 289

Hash (cost=13.12..13.12 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=289)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
46. 0.578 2.023 ↓ 0.0 0 289

Bitmap Heap Scan on service_document_splits service_document_splits_5 (cost=9.10..13.12 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=289)

  • Recheck Cond: ((chart_of_account_id = chart_of_accounts.id) AND ((service_document_type)::text = 'TransactionServiceDocument'::text))
  • Heap Blocks: exact=2
47. 0.269 1.445 ↓ 0.0 0 289

BitmapAnd (cost=9.10..9.10 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=289)

48. 1.156 1.156 ↓ 0.0 0 289

Bitmap Index Scan on sdoc_chart_of_account_id_idx (cost=0.00..4.34 rows=8 width=0) (actual time=0.004..0.004 rows=0 loops=289)

  • Index Cond: (chart_of_account_id = chart_of_accounts.id)
49. 0.020 0.020 ↑ 1.1 29 2

Bitmap Index Scan on idx_service_document_splits_service_document (cost=0.00..4.51 rows=31 width=0) (actual time=0.010..0.010 rows=29 loops=2)

  • Index Cond: ((service_document_type)::text = 'TransactionServiceDocument'::text)
50. 0.040 0.040 ↓ 0.0 0 40

Index Scan using index_chart_of_accounts_on_id on chart_of_accounts parent (cost=0.42..0.58 rows=1 width=22) (actual time=0.001..0.001 rows=0 loops=40)

  • Index Cond: (id = chart_of_accounts.parent_id)
51.          

SubPlan (for Result)

52. 0.120 250.960 ↑ 1.0 1 20

Aggregate (cost=791.02..791.03 rows=1 width=8) (actual time=12.548..12.548 rows=1 loops=20)

53. 1.480 250.840 ↑ 53.0 1 20

Nested Loop Left Join (cost=39.13..790.89 rows=53 width=0) (actual time=9.043..12.542 rows=1 loops=20)

  • Filter: (((service_document_splits.id IS NULL) AND (service_documents.chart_of_account_id = chart_of_accounts.id)) OR (service_document_splits.id IS NOT NULL))
  • Rows Removed by Filter: 64
54. 83.636 246.760 ↓ 1.2 65 20

Hash Join (cost=38.85..772.18 rows=53 width=8) (actual time=0.033..12.338 rows=65 loops=20)

  • Hash Cond: (service_documents.business_advisor_id = business_advisors.id)
55. 163.080 163.080 ↓ 1.0 18,439 20

Seq Scan on service_documents (cost=0.00..684.98 rows=18,398 width=12) (actual time=0.004..8.154 rows=18,439 loops=20)

56. 0.006 0.044 ↑ 1.0 11 1

Hash (cost=38.71..38.71 rows=11 width=4) (actual time=0.043..0.044 rows=11 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
57. 0.029 0.038 ↑ 1.0 11 1

Bitmap Heap Scan on business_advisors (cost=4.37..38.71 rows=11 width=4) (actual time=0.026..0.038 rows=11 loops=1)

  • Recheck Cond: (business_id = 810)
  • Heap Blocks: exact=8
58. 0.009 0.009 ↑ 1.0 11 1

Bitmap Index Scan on index_business_advisors_on_business_id (cost=0.00..4.36 rows=11 width=0) (actual time=0.009..0.009 rows=11 loops=1)

  • Index Cond: (business_id = 810)
59. 2.600 2.600 ↓ 0.0 0 1,300

Index Scan using idx_service_document_splits_service_document on service_document_splits (cost=0.28..0.34 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1,300)

  • Index Cond: (((service_document_type)::text = 'ServiceDocument'::text) AND (service_document_id = service_documents.id))
  • Filter: (chart_of_account_id = chart_of_accounts.id)
  • Rows Removed by Filter: 0
60. 0.080 47.980 ↑ 1.0 1 20

Aggregate (cost=159.09..159.10 rows=1 width=8) (actual time=2.399..2.399 rows=1 loops=20)

61. 0.980 47.900 ↓ 0.0 0 20

Nested Loop Left Join (cost=39.13..159.06 rows=10 width=0) (actual time=2.116..2.395 rows=0 loops=20)

  • Filter: (((service_document_splits_1.id IS NULL) AND (receipt_service_documents.chart_of_account_id = chart_of_accounts.id)) OR (service_document_splits_1.id IS NOT NULL))
  • Rows Removed by Filter: 88
62. 16.074 43.400 ↓ 8.8 88 20

Hash Join (cost=38.85..155.12 rows=10 width=8) (actual time=0.189..2.170 rows=88 loops=20)

  • Hash Cond: (receipt_service_documents.receipt_service_id = business_advisors_1.id)
63. 27.300 27.300 ↑ 1.0 3,585 20

Seq Scan on receipt_service_documents (cost=0.00..106.85 rows=3,585 width=12) (actual time=0.002..1.365 rows=3,585 loops=20)

64. 0.005 0.026 ↑ 1.0 11 1

Hash (cost=38.71..38.71 rows=11 width=4) (actual time=0.026..0.026 rows=11 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
65. 0.014 0.021 ↑ 1.0 11 1

Bitmap Heap Scan on business_advisors business_advisors_1 (cost=4.37..38.71 rows=11 width=4) (actual time=0.011..0.021 rows=11 loops=1)

  • Recheck Cond: (business_id = 810)
  • Heap Blocks: exact=8
66. 0.007 0.007 ↑ 1.0 11 1

Bitmap Index Scan on index_business_advisors_on_business_id (cost=0.00..4.36 rows=11 width=0) (actual time=0.007..0.007 rows=11 loops=1)

  • Index Cond: (business_id = 810)
67. 3.520 3.520 ↓ 0.0 0 1,760

Index Scan using idx_service_document_splits_service_document on service_document_splits service_document_splits_1 (cost=0.28..0.38 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1,760)

  • Index Cond: (((service_document_type)::text = 'ReceiptServiceDocument'::text) AND (service_document_id = receipt_service_documents.id))
  • Filter: (chart_of_account_id = chart_of_accounts.id)
  • Rows Removed by Filter: 0
68. 0.060 2.120 ↑ 1.0 1 20

Aggregate (cost=17.28..17.29 rows=1 width=8) (actual time=0.106..0.106 rows=1 loops=20)

69. 0.048 2.060 ↓ 3.0 3 20

Nested Loop (cost=12.66..17.27 rows=1 width=0) (actual time=0.089..0.103 rows=3 loops=20)

  • Join Filter: (revenue_service_documents.revenue_service_id = business_advisors_2.id)
70. 0.097 1.900 ↓ 3.0 3 20

Nested Loop (cost=12.38..16.37 rows=1 width=12) (actual time=0.086..0.095 rows=3 loops=20)

71. 0.100 1.740 ↓ 1.5 3 20

Merge Join (cost=12.23..15.65 rows=2 width=12) (actual time=0.083..0.087 rows=3 loops=20)

  • Merge Cond: (revenue_service_documents.revenue_service_id = revenue_service_categories.revenue_service_id)
72. 0.180 0.180 ↑ 88.7 3 20

Index Scan using index_revenue_service_documents_on_revenue_service_id on revenue_service_documents (cost=0.15..20.45 rows=266 width=8) (actual time=0.008..0.009 rows=3 loops=20)

73. 0.080 1.460 ↓ 2.0 2 20

Materialize (cost=12.08..12.09 rows=1 width=4) (actual time=0.072..0.073 rows=2 loops=20)

74. 0.160 1.380 ↓ 0.0 0 20

Sort (cost=12.08..12.08 rows=1 width=4) (actual time=0.069..0.069 rows=0 loops=20)

  • Sort Key: revenue_service_categories.revenue_service_id
  • Sort Method: quicksort Memory: 25kB
75. 0.370 1.220 ↓ 0.0 0 20

Hash Join (cost=5.78..12.07 rows=1 width=4) (actual time=0.041..0.061 rows=0 loops=20)

  • Hash Cond: (revenue_report_type_categories.revenue_service_category_id = revenue_service_categories.id)
76. 0.250 0.250 ↑ 1.2 216 5

Seq Scan on revenue_report_type_categories (cost=0.00..5.60 rows=260 width=4) (actual time=0.002..0.050 rows=216 loops=5)

77. 0.060 0.600 ↓ 0.0 0 20

Hash (cost=5.76..5.76 rows=1 width=8) (actual time=0.029..0.030 rows=0 loops=20)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
78. 0.540 0.540 ↓ 0.0 0 20

Seq Scan on revenue_service_categories (cost=0.00..5.76 rows=1 width=8) (actual time=0.024..0.027 rows=0 loops=20)

  • Filter: (chart_of_account_id = chart_of_accounts.id)
  • Rows Removed by Filter: 260
79. 0.063 0.063 ↑ 1.0 1 63

Index Scan using revenue_report_types_pkey on revenue_report_types (cost=0.15..0.35 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=63)

  • Index Cond: (id = revenue_service_documents.revenue_report_type_id)
  • Filter: (revenue_service_documents.revenue_service_id = revenue_service_id)
80. 0.112 0.112 ↑ 1.0 1 56

Index Scan using business_advisors_pkey on business_advisors business_advisors_2 (cost=0.28..0.89 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=56)

  • Index Cond: (id = revenue_report_types.revenue_service_id)
  • Filter: (business_id = 810)
81. 0.120 385.860 ↑ 1.0 1 20

Aggregate (cost=1,201.52..1,201.53 rows=1 width=8) (actual time=19.293..19.293 rows=1 loops=20)

82. 12.920 385.740 ↑ 27.0 3 20

Hash Left Join (cost=51.98..1,201.31 rows=81 width=0) (actual time=11.359..19.287 rows=3 loops=20)

  • Hash Cond: (transaction_service_documents.id = service_document_splits_2.service_document_id)
  • Filter: (((service_document_splits_2.id IS NULL) AND (transaction_service_documents.chart_of_account_id = chart_of_accounts.id)) OR (service_document_splits_2.id IS NOT NULL))
  • Rows Removed by Filter: 2,413
83. 137.157 372.580 ↓ 29.8 2,416 20

Hash Join (cost=38.85..1,187.87 rows=81 width=8) (actual time=0.025..18.629 rows=2,416 loops=20)

  • Hash Cond: (transaction_service_documents.reconciliation_service_id = business_advisors_3.id)
84. 235.400 235.400 ↓ 1.0 28,134 20

Seq Scan on transaction_service_documents (cost=0.00..1,075.14 rows=28,114 width=12) (actual time=0.003..11.770 rows=28,134 loops=20)

85. 0.005 0.023 ↑ 1.0 11 1

Hash (cost=38.71..38.71 rows=11 width=4) (actual time=0.022..0.023 rows=11 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
86. 0.011 0.018 ↑ 1.0 11 1

Bitmap Heap Scan on business_advisors business_advisors_3 (cost=4.37..38.71 rows=11 width=4) (actual time=0.010..0.018 rows=11 loops=1)

  • Recheck Cond: (business_id = 810)
  • Heap Blocks: exact=8
87. 0.007 0.007 ↑ 1.0 11 1

Bitmap Index Scan on index_business_advisors_on_business_id (cost=0.00..4.36 rows=11 width=0) (actual time=0.007..0.007 rows=11 loops=1)

  • Index Cond: (business_id = 810)
88. 0.040 0.240 ↓ 0.0 0 20

Hash (cost=13.12..13.12 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=20)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
89. 0.060 0.200 ↓ 0.0 0 20

Bitmap Heap Scan on service_document_splits service_document_splits_2 (cost=9.10..13.12 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=20)

  • Recheck Cond: ((chart_of_account_id = chart_of_accounts.id) AND ((service_document_type)::text = 'TransactionServiceDocument'::text))
  • Heap Blocks: exact=3
90. 0.024 0.140 ↓ 0.0 0 20

BitmapAnd (cost=9.10..9.10 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=20)

91. 0.080 0.080 ↓ 0.0 0 20

Bitmap Index Scan on sdoc_chart_of_account_id_idx (cost=0.00..4.34 rows=8 width=0) (actual time=0.004..0.004 rows=0 loops=20)

  • Index Cond: (chart_of_account_id = chart_of_accounts.id)
92. 0.036 0.036 ↑ 1.1 29 4

Bitmap Index Scan on idx_service_document_splits_service_document (cost=0.00..4.51 rows=31 width=0) (actual time=0.009..0.009 rows=29 loops=4)

  • Index Cond: ((service_document_type)::text = 'TransactionServiceDocument'::text)
Planning time : 5.538 ms
Execution time : 10,352.485 ms