explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UPOr

Settings
# exclusive inclusive rows x rows loops node
1. 0.377 4,526.764 ↑ 1.0 50 1

Limit (cost=74,177.53..78,619.79 rows=50 width=1,917) (actual time=4,519.359..4,526.764 rows=50 loops=1)

2. 0.278 4,526.387 ↑ 41.4 50 1

Result (cost=74,177.53..258,175.86 rows=2,071 width=1,917) (actual time=4,519.358..4,526.387 rows=50 loops=1)

3. 2.744 4,519.059 ↑ 41.4 50 1

Sort (cost=74,177.53..74,182.71 rows=2,071 width=2,356) (actual time=4,519.050..4,519.059 rows=50 loops=1)

  • Sort Key: good.sku, equipment.id
  • Sort Method: top-N heapsort Memory: 62kB
4. 8.977 4,516.315 ↓ 1.6 3,273 1

WindowAgg (cost=73,963.76..74,108.73 rows=2,071 width=2,356) (actual time=4,512.611..4,516.315 rows=3,273 loops=1)

5. 448.504 4,507.338 ↓ 1.6 3,273 1

GroupAggregate (cost=73,963.76..74,072.49 rows=2,071 width=2,348) (actual time=3,882.992..4,507.338 rows=3,273 loops=1)

  • Group Key: equipment.id, good.id, good_group.id, good_subgroup.id, owner.id, administrator.id, warehouse.id, equipment_status_color.id, client.id, subject_object.id, equipment_purchase.id, ecsin.equipment_id
6. 1,519.165 4,058.834 ↓ 288.2 596,882 1

Sort (cost=73,963.76..73,968.94 rows=2,071 width=2,833) (actual time=3,882.972..4,058.834 rows=596,882 loops=1)

  • Sort Key: equipment.id, good.id, good_group.id, good_subgroup.id, owner.id, administrator.id, warehouse.id, equipment_status_color.id, client.id, subject_object.id, equipment_purchase.id, ecsin.equipment_id
  • Sort Method: external merge Disk: 166544kB
7. 416.522 2,539.669 ↓ 288.2 596,882 1

Nested Loop Left Join (cost=62,736.65..71,312.19 rows=2,071 width=2,833) (actual time=525.966..2,539.669 rows=596,882 loops=1)

8. 271.037 1,526.265 ↓ 288.2 596,882 1

Nested Loop Left Join (cost=62,736.52..70,991.21 rows=2,071 width=2,321) (actual time=525.951..1,526.265 rows=596,882 loops=1)

9. 93.878 945.768 ↓ 29.9 61,892 1

Nested Loop Left Join (cost=62,736.23..69,931.21 rows=2,071 width=2,312) (actual time=525.938..945.768 rows=61,892 loops=1)

  • Join Filter: ((equipment_status_color.status)::text = (equipment.status)::text)
  • Rows Removed by Join Filter: 309544
10. 57.531 789.998 ↓ 29.9 61,892 1

Hash Left Join (cost=62,736.23..69,743.75 rows=2,071 width=1,792) (actual time=525.920..789.998 rows=61,892 loops=1)

  • Hash Cond: (equipment.id = equipment_1.id)
11. 71.814 213.502 ↓ 29.9 61,892 1

Gather (cost=1,289.78..8,289.52 rows=2,071 width=1,738) (actual time=6.943..213.502 rows=61,892 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
12. 64.375 141.688 ↓ 25.4 30,946 2

Nested Loop Left Join (cost=289.78..7,082.42 rows=1,218 width=1,738) (actual time=4.890..141.688 rows=30,946 loops=2)

13. 1.784 77.284 ↓ 1.3 1,636 2

Hash Left Join (cost=289.49..5,663.50 rows=1,218 width=1,738) (actual time=4.868..77.284 rows=1,636 loops=2)

  • Hash Cond: (equipment.warehouse_id = warehouse.id)
14. 5.473 75.461 ↓ 1.3 1,636 2

Nested Loop (cost=287.79..5,658.42 rows=1,218 width=702) (actual time=4.814..75.461 rows=1,636 loops=2)

15. 8.555 69.986 ↓ 1.3 1,636 2

Nested Loop (cost=287.50..5,256.42 rows=1,218 width=683) (actual time=4.803..69.986 rows=1,636 loops=2)

16. 1.714 61.428 ↓ 1.3 1,636 2

Hash Join (cost=287.22..4,854.42 rows=1,218 width=664) (actual time=4.774..61.428 rows=1,636 loops=2)

  • Hash Cond: (good.subgroup_id = good_subgroup.id)
17. 1.713 59.602 ↓ 1.3 1,636 2

Hash Join (cost=282.11..4,846.02 rows=1,218 width=648) (actual time=4.564..59.602 rows=1,636 loops=2)

  • Hash Cond: (good.group_id = good_group.id)
18. 2.162 57.798 ↓ 1.3 1,636 2

Hash Join (cost=280.26..4,840.61 rows=1,218 width=132) (actual time=4.398..57.798 rows=1,636 loops=2)

  • Hash Cond: (equipment.id = equipment_purchase.equipment_id)
19. 19.127 52.323 ↑ 21.8 1,636 2

Hash Join (cost=57.28..4,432.66 rows=35,684 width=120) (actual time=1.031..52.323 rows=1,636 loops=2)

  • Hash Cond: (equipment.good_id = good.id)
20. 32.223 32.223 ↑ 1.2 89,028 2

Parallel Seq Scan on equipment (cost=0.00..4,099.12 rows=104,890 width=68) (actual time=0.019..32.223 rows=89,028 loops=2)

  • Filter: (id > 0)
21. 0.222 0.973 ↓ 1.1 481 2

Hash (cost=51.91..51.91 rows=429 width=56) (actual time=0.973..0.973 rows=481 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
22. 0.751 0.751 ↓ 1.1 481 2

Seq Scan on good (cost=0.00..51.91 rows=429 width=56) (actual time=0.039..0.751 rows=481 loops=2)

  • Filter: (((type)::text = 'equipment'::text) AND ((subtype)::text = 'unique'::text))
  • Rows Removed by Filter: 780
23. 1.185 3.313 ↑ 1.9 3,273 2

Hash (cost=146.88..146.88 rows=6,088 width=16) (actual time=3.313..3.313 rows=3,273 loops=2)

  • Buckets: 8192 Batches: 1 Memory Usage: 224kB
24. 2.128 2.128 ↑ 1.0 6,088 2

Seq Scan on equipment_purchase (cost=0.00..146.88 rows=6,088 width=16) (actual time=0.021..2.128 rows=6,088 loops=2)

25. 0.031 0.091 ↑ 1.0 38 2

Hash (cost=1.38..1.38 rows=38 width=520) (actual time=0.091..0.091 rows=38 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
26. 0.060 0.060 ↑ 1.0 38 2

Seq Scan on good_group (cost=0.00..1.38 rows=38 width=520) (actual time=0.051..0.060 rows=38 loops=2)

27. 0.051 0.112 ↑ 1.0 138 2

Hash (cost=3.38..3.38 rows=138 width=20) (actual time=0.112..0.112 rows=138 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
28. 0.061 0.061 ↑ 1.0 138 2

Seq Scan on good_subgroup (cost=0.00..3.38 rows=138 width=20) (actual time=0.024..0.061 rows=138 loops=2)

29. 0.003 0.003 ↑ 1.0 1 3,273

Index Scan using subject_subject_pkey on subject_subject owner (cost=0.29..0.33 rows=1 width=23) (actual time=0.003..0.003 rows=1 loops=3,273)

  • Index Cond: (id = equipment.owner_id)
30. 0.002 0.002 ↑ 1.0 1 3,273

Index Scan using subject_subject_pkey on subject_subject administrator (cost=0.29..0.33 rows=1 width=23) (actual time=0.002..0.002 rows=1 loops=3,273)

  • Index Cond: (id = equipment.administrator_id)
31. 0.014 0.039 ↑ 1.0 31 2

Hash (cost=1.31..1.31 rows=31 width=1,036) (actual time=0.039..0.039 rows=31 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
32. 0.025 0.025 ↑ 1.0 31 2

Seq Scan on warehouse (cost=0.00..1.31 rows=31 width=1,036) (actual time=0.018..0.025 rows=31 loops=2)

33. 0.029 0.029 ↑ 1.6 19 3,273

Index Only Scan using maintenance_task_equipment_id on maintenance_task (cost=0.29..0.85 rows=31 width=4) (actual time=0.005..0.029 rows=19 loops=3,273)

  • Index Cond: (equipment_id = equipment.id)
  • Heap Fetches: 0
34. 0.572 518.965 ↓ 14.0 1,639 1

Hash (cost=61,444.99..61,444.99 rows=117 width=58) (actual time=518.965..518.965 rows=1,639 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 175kB
35. 1.689 518.393 ↓ 14.0 1,639 1

Nested Loop Left Join (cost=60,371.14..61,444.99 rows=117 width=58) (actual time=494.072..518.393 rows=1,639 loops=1)

36. 0.254 511.787 ↓ 14.0 1,639 1

Nested Loop Left Join (cost=60,370.86..61,390.61 rows=117 width=39) (actual time=494.061..511.787 rows=1,639 loops=1)

37. 1.105 506.616 ↓ 14.0 1,639 1

Nested Loop Left Join (cost=60,370.57..61,349.87 rows=117 width=12) (actual time=494.047..506.616 rows=1,639 loops=1)

38. 0.762 502.233 ↓ 14.0 1,639 1

Nested Loop Left Join (cost=60,370.28..61,311.98 rows=117 width=8) (actual time=494.033..502.233 rows=1,639 loops=1)

39. 0.638 494.915 ↓ 14.0 1,639 1

Group (cost=60,369.86..60,371.62 rows=117 width=21) (actual time=494.007..494.915 rows=1,639 loops=1)

  • Group Key: equipment_1.id, rent_account_1.id, good_1.subtype, rent_account_good_1.id, rent_account_task.id
40. 0.842 494.277 ↓ 14.0 1,639 1

Sort (cost=60,369.86..60,370.16 rows=117 width=21) (actual time=494.005..494.277 rows=1,639 loops=1)

  • Sort Key: equipment_1.id, rent_account_1.id, rent_account_good_1.id, rent_account_task.id
  • Sort Method: quicksort Memory: 177kB
41. 7.731 493.435 ↓ 14.0 1,639 1

Hash Left Join (cost=36,293.23..60,365.84 rows=117 width=21) (actual time=460.273..493.435 rows=1,639 loops=1)

  • Hash Cond: (rent_account_equipment.account_good_id = rent_account_equipment_1.account_good_id)
  • Filter: ((rent_account_task_1.status IS NULL) OR ((rent_account_task_1.status)::text = 'not_done'::text))
  • Rows Removed by Filter: 860
42. 0.000 100.739 ↑ 3.9 2,499 1

Gather (cost=8,131.38..29,370.59 rows=9,826 width=25) (actual time=74.833..100.739 rows=2,499 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
43. 6.240 297.206 ↑ 4.9 833 3

Nested Loop (cost=7,131.38..27,387.99 rows=4,094 width=25) (actual time=90.128..297.206 rows=833 loops=3)

44. 11.917 290.961 ↑ 7.3 1,133 3

Nested Loop (cost=7,131.09..24,568.48 rows=8,238 width=25) (actual time=90.103..290.961 rows=1,133 loops=3)

45. 10.226 279.035 ↑ 7.3 1,133 3

Nested Loop (cost=7,130.67..20,675.80 rows=8,238 width=25) (actual time=90.078..279.035 rows=1,133 loops=3)

  • Join Filter: (rent_account_good_1.id = ratg_rag.rag_id)
46. 15.669 268.798 ↑ 6.0 833 3

Hash Join (cost=7,130.24..18,196.78 rows=4,969 width=21) (actual time=90.045..268.798 rows=833 loops=3)

  • Hash Cond: (rent_account_equipment.equipment_id = equipment_1.id)
47. 103.142 175.705 ↓ 2.8 62,474 3

Nested Loop (cost=1,297.08..12,229.27 rows=22,578 width=16) (actual time=12.313..175.705 rows=62,474 loops=3)

48. 27.332 72.555 ↓ 1.6 9,165 3

Hash Join (cost=1,296.66..6,181.88 rows=5,773 width=8) (actual time=12.264..72.555 rows=9,165 loops=3)

  • Hash Cond: (rent_account_good_1.account_id = rent_account_1.id)
49. 33.061 33.061 ↑ 1.3 63,425 3

Parallel Seq Scan on rent_account_good rent_account_good_1 (cost=0.00..4,677.02 rows=79,302 width=8) (actual time=0.024..33.061 rows=63,425 loops=3)

50. 0.632 12.162 ↑ 1.1 2,052 3

Hash (cost=1,269.11..1,269.11 rows=2,204 width=4) (actual time=12.162..12.162 rows=2,052 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 105kB
51. 11.530 11.530 ↑ 1.1 2,052 3

Seq Scan on rent_account rent_account_1 (cost=0.00..1,269.11 rows=2,204 width=4) (actual time=0.020..11.530 rows=2,052 loops=3)

  • Filter: (((type)::text = 'external'::text) AND ((status)::text = 'in_progress'::text))
  • Rows Removed by Filter: 28222
52. 0.008 0.008 ↑ 2.6 7 27,495

Index Scan using rent_account_equipment_account_good_id on rent_account_equipment (cost=0.42..0.87 rows=18 width=8) (actual time=0.006..0.008 rows=7 loops=27,495)

  • Index Cond: (account_good_id = rent_account_good_1.id)
53. 0.873 77.424 ↑ 23.9 1,639 3

Hash (cost=5,342.65..5,342.65 rows=39,241 width=9) (actual time=77.424..77.424 rows=1,639 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 581kB
54. 22.041 76.551 ↑ 23.9 1,639 3

Hash Join (cost=54.78..5,342.65 rows=39,241 width=9) (actual time=0.761..76.551 rows=1,639 loops=3)

  • Hash Cond: (equipment_1.good_id = good_1.id)
55. 53.851 53.851 ↑ 1.0 102,515 3

Seq Scan on equipment equipment_1 (cost=0.00..5,016.91 rows=102,875 width=8) (actual time=0.062..53.851 rows=102,515 loops=3)

  • Filter: ((status)::text = 'in_use'::text)
  • Rows Removed by Filter: 75542
56. 0.189 0.659 ↑ 1.0 481 3

Hash (cost=48.76..48.76 rows=481 width=9) (actual time=0.659..0.659 rows=481 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
57. 0.470 0.470 ↑ 1.0 481 3

Seq Scan on good good_1 (cost=0.00..48.76 rows=481 width=9) (actual time=0.014..0.470 rows=481 loops=3)

  • Filter: ((subtype)::text = 'unique'::text)
  • Rows Removed by Filter: 780
58. 0.011 0.011 ↑ 2.0 1 2,499

Index Scan using ratg_rag_rag_id on ratg_rag (cost=0.42..0.47 rows=2 width=8) (actual time=0.006..0.011 rows=1 loops=2,499)

  • Index Cond: (rag_id = rent_account_equipment.account_good_id)
59. 0.009 0.009 ↑ 1.0 1 3,400

Index Scan using rent_account_task_good_pkey on rent_account_task_good (cost=0.42..0.47 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=3,400)

  • Index Cond: (id = ratg_rag.ratg_id)
60. 0.005 0.005 ↑ 1.0 1 3,400

Index Scan using rent_account_task_pkey on rent_account_task (cost=0.29..0.34 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=3,400)

  • Index Cond: (id = rent_account_task_good.task_id)
  • Filter: (((type)::text = 'transfer'::text) AND ((status)::text = 'completed'::text))
  • Rows Removed by Filter: 0
61. 38.583 384.965 ↓ 1.9 85,475 1

Hash (cost=27,598.23..27,598.23 rows=45,090 width=13) (actual time=384.965..384.965 rows=85,475 loops=1)

  • Buckets: 131072 (originally 65536) Batches: 2 (originally 1) Memory Usage: 3073kB
62. 24.477 346.382 ↓ 1.9 85,475 1

Gather (cost=2,298.22..27,598.23 rows=45,090 width=13) (actual time=17.306..346.382 rows=85,475 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
63. 51.101 321.905 ↓ 1.5 28,492 3

Nested Loop (cost=1,298.22..22,089.23 rows=18,788 width=13) (actual time=17.718..321.905 rows=28,492 loops=3)

  • Join Filter: (rent_account_good_1_1.id = rent_account_equipment_1.account_good_id)
64. 62.593 270.795 ↑ 1.2 4,070 3

Nested Loop (cost=1,297.80..17,083.84 rows=4,804 width=17) (actual time=17.634..270.795 rows=4,070 loops=3)

65. 75.967 208.198 ↓ 1.3 12,873 3

Nested Loop (cost=1,297.50..13,831.70 rows=9,572 width=12) (actual time=17.573..208.198 rows=12,873 loops=3)

66. 67.307 132.226 ↓ 1.3 12,873 3

Nested Loop (cost=1,297.08..9,308.66 rows=9,572 width=12) (actual time=17.544..132.226 rows=12,873 loops=3)

67. 28.605 64.913 ↓ 1.6 9,165 3

Hash Join (cost=1,296.66..6,181.88 rows=5,773 width=4) (actual time=17.491..64.913 rows=9,165 loops=3)

  • Hash Cond: (rent_account_good_1_1.account_id = rent_account_1_1.id)
68. 18.953 18.953 ↑ 1.3 63,425 3

Parallel Seq Scan on rent_account_good rent_account_good_1_1 (cost=0.00..4,677.02 rows=79,302 width=8) (actual time=0.031..18.953 rows=63,425 loops=3)

69. 0.901 17.355 ↑ 1.1 2,052 3

Hash (cost=1,269.11..1,269.11 rows=2,204 width=4) (actual time=17.355..17.355 rows=2,052 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 105kB
70. 16.454 16.454 ↑ 1.1 2,052 3

Seq Scan on rent_account rent_account_1_1 (cost=0.00..1,269.11 rows=2,204 width=4) (actual time=0.024..16.454 rows=2,052 loops=3)

  • Filter: (((type)::text = 'external'::text) AND ((status)::text = 'in_progress'::text))
  • Rows Removed by Filter: 28222
71. 0.006 0.006 ↑ 2.0 1 27,495

Index Scan using ratg_rag_rag_id on ratg_rag ratg_rag_1 (cost=0.42..0.52 rows=2 width=8) (actual time=0.005..0.006 rows=1 loops=27,495)

  • Index Cond: (rag_id = rent_account_good_1_1.id)
72. 0.005 0.005 ↑ 1.0 1 38,619

Index Scan using rent_account_task_good_pkey on rent_account_task_good rent_account_task_good_1 (cost=0.42..0.47 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=38,619)

  • Index Cond: (id = ratg_rag_1.ratg_id)
73. 0.004 0.004 ↓ 0.0 0 38,619

Index Scan using rent_account_task_pkey on rent_account_task rent_account_task_1 (cost=0.29..0.34 rows=1 width=13) (actual time=0.004..0.004 rows=0 loops=38,619)

  • Index Cond: (id = rent_account_task_good_1.task_id)
  • Filter: ((type)::text = 'return'::text)
  • Rows Removed by Filter: 1
74. 0.009 0.009 ↑ 2.6 7 12,209

Index Only Scan using rent_account_equipment_account_good_id on rent_account_equipment rent_account_equipment_1 (cost=0.42..0.82 rows=18 width=4) (actual time=0.006..0.009 rows=7 loops=12,209)

  • Index Cond: (account_good_id = ratg_rag_1.rag_id)
  • Heap Fetches: 24572
75. 6.556 6.556 ↑ 1.0 1 1,639

Index Scan using rent_account_good_pkey on rent_account_good (cost=0.42..8.03 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1,639)

  • Index Cond: (id = rent_account_good_1.id)
76. 3.278 3.278 ↑ 1.0 1 1,639

Index Scan using rent_account_pkey on rent_account (cost=0.29..0.32 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=1,639)

  • Index Cond: (id = rent_account_good.account_id)
77. 4.917 4.917 ↑ 1.0 1 1,639

Index Scan using subject_object_pkey on subject_object (cost=0.29..0.35 rows=1 width=31) (actual time=0.003..0.003 rows=1 loops=1,639)

  • Index Cond: (id = rent_account.object_id)
78. 4.917 4.917 ↑ 1.0 1 1,639

Index Scan using subject_subject_pkey on subject_subject client (cost=0.29..0.46 rows=1 width=23) (actual time=0.003..0.003 rows=1 loops=1,639)

  • Index Cond: (id = rent_account.client_id)
79. 61.879 61.892 ↑ 1.0 6 61,892

Materialize (cost=0.00..1.09 rows=6 width=1,036) (actual time=0.000..0.001 rows=6 loops=61,892)

80. 0.013 0.013 ↑ 1.0 6 1

Seq Scan on equipment_status_color (cost=0.00..1.06 rows=6 width=1,036) (actual time=0.012..0.013 rows=6 loops=1)

81. 309.460 309.460 ↓ 1.2 10 61,892

Index Scan using equipment_country_safety_inspection_no_equipment_id on equipment_country_safety_inspection_no ecsin (cost=0.29..0.43 rows=8 width=9) (actual time=0.003..0.005 rows=10 loops=61,892)

  • Index Cond: (equipment_id = equipment.id)
82. 596.882 596.882 ↑ 1.0 1 596,882

Index Scan using address_country_pkey on address_country ecsin_country (cost=0.14..0.16 rows=1 width=520) (actual time=0.001..0.001 rows=1 loops=596,882)

  • Index Cond: (id = ecsin.country_id)
83.          

SubPlan (forResult)

84. 0.100 1.950 ↑ 1.0 1 50

Limit (cost=4.35..33.51 rows=1 width=29) (actual time=0.039..0.039 rows=1 loops=50)

85. 1.550 1.850 ↑ 1.0 1 50

Bitmap Heap Scan on translation_field (cost=4.35..33.51 rows=1 width=29) (actual time=0.037..0.037 rows=1 loops=50)

  • Recheck Cond: (rid = good.id)
  • Filter: (((tablename)::text = 'good'::text) AND ((fieldname)::text = 'title'::text) AND (language_id = 2))
  • Rows Removed by Filter: 54
  • Heap Blocks: exact=1388
86. 0.300 0.300 ↓ 7.1 64 50

Bitmap Index Scan on translation_field_rid (cost=0.00..4.35 rows=9 width=0) (actual time=0.006..0.006 rows=64 loops=50)

  • Index Cond: (rid = good.id)
87. 0.100 1.600 ↑ 1.0 1 50

Limit (cost=10.65..14.67 rows=1 width=29) (actual time=0.031..0.032 rows=1 loops=50)

88. 0.150 1.500 ↑ 1.0 1 50

Bitmap Heap Scan on translation_field translation_field_1 (cost=10.65..14.67 rows=1 width=29) (actual time=0.030..0.030 rows=1 loops=50)

  • Recheck Cond: ((rid = good_group.id) AND ((tablename)::text = 'good_group'::text))
  • Filter: (((fieldname)::text = 'title'::text) AND (language_id = 2))
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=60
89. 0.150 1.350 ↓ 0.0 0 50

BitmapAnd (cost=10.65..10.65 rows=1 width=0) (actual time=0.027..0.027 rows=0 loops=50)

90. 0.350 0.350 ↓ 11.0 99 50

Bitmap Index Scan on translation_field_rid (cost=0.00..4.35 rows=9 width=0) (actual time=0.007..0.007 rows=99 loops=50)

  • Index Cond: (rid = good_group.id)
91. 0.850 0.850 ↑ 1.0 235 50

Bitmap Index Scan on translation_field_tablename (cost=0.00..6.05 rows=235 width=0) (actual time=0.017..0.017 rows=235 loops=50)

  • Index Cond: ((tablename)::text = 'good_group'::text)
92. 0.100 3.200 ↑ 1.0 1 50

Limit (cost=27.29..31.31 rows=1 width=29) (actual time=0.063..0.064 rows=1 loops=50)

93. 0.150 3.100 ↑ 1.0 1 50

Bitmap Heap Scan on translation_field translation_field_2 (cost=27.29..31.31 rows=1 width=29) (actual time=0.062..0.062 rows=1 loops=50)

  • Recheck Cond: ((rid = good_subgroup.id) AND ((tablename)::text = 'good_subgroup'::text))
  • Filter: (((fieldname)::text = 'title'::text) AND (language_id = 2))
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=59
94. 0.100 2.950 ↓ 0.0 0 50

BitmapAnd (cost=27.29..27.29 rows=1 width=0) (actual time=0.059..0.059 rows=0 loops=50)

95. 0.300 0.300 ↓ 10.2 92 50

Bitmap Index Scan on translation_field_rid (cost=0.00..4.35 rows=9 width=0) (actual time=0.006..0.006 rows=92 loops=50)

  • Index Cond: (rid = good_subgroup.id)
96. 2.550 2.550 ↑ 1.0 853 50

Bitmap Index Scan on translation_field_tablename (cost=0.00..22.68 rows=853 width=0) (actual time=0.051..0.051 rows=853 loops=50)

  • Index Cond: ((tablename)::text = 'good_subgroup'::text)
97. 0.100 0.300 ↑ 1.0 1 50

Aggregate (cost=9.32..9.34 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=50)

98. 0.031 0.200 ↓ 0.0 0 50

Nested Loop (cost=0.28..9.31 rows=1 width=516) (actual time=0.004..0.004 rows=0 loops=50)

  • Join Filter: (equipment_gps_system_attribute.gps_system_attribute_id = gps_system_attribute.id)
99. 0.150 0.150 ↓ 0.0 0 50

Index Scan using equipment_gps_system_attribute_equipment_id on equipment_gps_system_attribute (cost=0.28..8.29 rows=1 width=4) (actual time=0.002..0.003 rows=0 loops=50)

  • Index Cond: (equipment_id = equipment.id)
100. 0.019 0.019 ↑ 1.0 1 19

Seq Scan on gps_system_attribute (cost=0.00..1.01 rows=1 width=520) (actual time=0.001..0.001 rows=1 loops=19)